[GESIOR AAC] Full WWW otsmateria.pl folder - ALL scripts etc...

Pan Kropelka

I HATE SLENDER :(
Joined
Mar 28, 2013
Messages
19
Reaction score
4
ADD TO DB:

Code:
ALTER TABLE players ADD ip varchar(255) NOT NULL
Code:
CREATE TABLE `castle_fighters` (
  `id` INT(11) NOT NULL,
  `guild` INT(11) NOT NULL
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;
Code:
CREATE TABLE `castle` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `owner` INT(11) NOT NULL,
  `guild_name` VARCHAR(99) NOT NULL,
  `king` INT(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
Code:
CREATE TABLE `castle_dmg` (
  `guild` INT(11) NOT NULL,
  `dmg` INT(11) NOT NULL
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;
Code:
CREATE TABLE `events` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `event_name` varchar(255) NOT NULL,
  `winner_name` varchar(255) NOT NULL,
  `won_item` varchar(255) NOT NULL,
  `time_win` int(7) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=45 ;
Code:
ALTER TABLE `z_shop_offer` ADD `bought` INT( 11 ) NOT NULL DEFAULT '0';
Code:
ALTER TABLE `accounts` ADD `ip` VARCHAR( 30 ) NOT NULL ;
Code:
ALTER TABLE `accounts` ADD `get_points` INT(11) NOT NULL DEFAULT '0';
Code:
ALTER TABLE `guilds` ADD `get_points` INT(11) NOT NULL DEFAULT '0';
Code:
ALTER TABLE `players` ADD `get_points` INT(11) NOT NULL DEFAULT '0';
Code:
ALTER TABLE `accounts` ADD `guild_points` int(11) NOT NULL DEFAULT '0';
Code:
CREATE TABLE `application` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `nick` varchar(255) NOT NULL DEFAULT '',
  `guildid` int(11) NOT NULL,
  `players` varchar(255) NOT NULL DEFAULT '',
  `vt_ip` varchar(255) NOT NULL DEFAULT '',
  `vt_port` varchar(255) NOT NULL DEFAULT '',
  `vt_password` varchar(255) NOT NULL DEFAULT '',
  `vt_version` varchar(255) NOT NULL DEFAULT '',
  `vt_acc_nick` varchar(255) NOT NULL DEFAULT '',
  `vt_acc_password` varchar(255) NOT NULL DEFAULT '',
  `reason` varchar(255) NOT NULL DEFAULT '',
  `contact` varchar(255) NOT NULL DEFAULT '',
  `accept` int(5) NOT NULL DEFAULT 0,
  `data` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
Code:
CREATE TABLE IF NOT EXISTS `sms_cost` ( 
  `id` int(11) NOT NULL AUTO_INCREMENT, 
  `cash` double DEFAULT NULL, 
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 
  PRIMARY KEY (`id`) 
);
Code:
CREATE TABLE IF NOT EXISTS `guild_wars` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `guild_id` INT NOT NULL,
  `enemy_id` INT NOT NULL,
  `begin` BIGINT NOT NULL DEFAULT '0',
  `end` BIGINT NOT NULL DEFAULT '0',
  `frags` INT UNSIGNED NOT NULL DEFAULT '0',
  `payment` BIGINT UNSIGNED NOT NULL DEFAULT '0',
  `guild_kills` INT UNSIGNED NOT NULL DEFAULT '0',
  `enemy_kills` INT UNSIGNED NOT NULL DEFAULT '0',
  `status` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `status` (`status`),
  KEY `guild_id` (`guild_id`),
  KEY `enemy_id` (`enemy_id`)
) ENGINE=InnoDB;
Code:
ALTER TABLE `guild_wars`
  ADD CONSTRAINT `guild_wars_ibfk_1` FOREIGN KEY (`guild_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `guild_wars_ibfk_2` FOREIGN KEY (`enemy_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE;
Code:
ALTER TABLE `guilds` ADD `balance` BIGINT UNSIGNED NOT NULL AFTER `motd`;
Code:
CREATE TABLE IF NOT EXISTS `guild_kills` (
  `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `guild_id` INT NOT NULL,
  `war_id` INT NOT NULL,
  `death_id` INT NOT NULL
) ENGINE = InnoDB;
Code:
ALTER TABLE `guild_kills`
  ADD CONSTRAINT `guild_kills_ibfk_1` FOREIGN KEY (`war_id`) REFERENCES `guild_wars` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `guild_kills_ibfk_2` FOREIGN KEY (`death_id`) REFERENCES `player_deaths` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `guild_kills_ibfk_3` FOREIGN KEY (`guild_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE;
Code:
ALTER TABLE `killers` ADD `war` INT NOT NULL DEFAULT 0;
Code:
CREATE TABLE IF NOT EXISTS `z_forum` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sticky` tinyint(1) NOT NULL DEFAULT '0',
  `closed` tinyint(1) NOT NULL DEFAULT '0',
  `first_post` int(11) NOT NULL DEFAULT '0',
  `last_post` int(11) NOT NULL DEFAULT '0',
  `section` int(3) NOT NULL DEFAULT '0',
  `icon_id` int(3) NOT NULL DEFAULT '1',
  `replies` int(20) NOT NULL DEFAULT '0',
  `views` int(20) NOT NULL DEFAULT '0',
  `author_aid` int(20) NOT NULL DEFAULT '0',
  `author_guid` int(20) NOT NULL DEFAULT '0',
  `post_text` text NOT NULL,
  `post_topic` varchar(255) NOT NULL,
  `post_smile` tinyint(1) NOT NULL DEFAULT '0',
  `post_date` int(20) NOT NULL DEFAULT '0',
  `last_edit_aid` int(20) NOT NULL DEFAULT '0',
  `edit_date` int(20) NOT NULL DEFAULT '0',
  `post_ip` varchar(32) NOT NULL DEFAULT '0.0.0.0',
  PRIMARY KEY (`id`),
  KEY `section` (`section`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=67 ;
Code:
CREATE TABLE IF NOT EXISTS `lists_cache` (
  `cache_id` char(32) NOT NULL,
  `cache_html` mediumtext,
  `cache_date` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`cache_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Code:
CREATE TABLE `point_winner` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `account_id` INT(11) NOT NULL,
  `date` timestamp NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
Code:
ALTER TABLE accounts ADD referrer INT(11) NOT NULL DEFAULT '0';
Code:
CREATE TABLE `guild_competition` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `guild_id` int(11) NOT NULL,
  `guild_name` varchar(255) NOT NULL,
  `group_first` varchar(30) NOT NULL,
  `group_second` varchar(30) NOT NULL,
  `group_semi_final` varchar(30) NOT NULL,
  `group_final` varchar(30) NOT NULL,
  `group_winner` varchar(30) NOT NULL,
  `wins` int(5) NOT NULL DEFAULT '0',
  `losses` int(5) NOT NULL DEFAULT '0',
  `draws` int(5) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
Code:
CREATE TABLE `guild_fights` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `guild_id` int(11) NOT NULL,
  `guild_name` varchar(255) NOT NULL,
  `enemy_id` int(11) NOT NULL,
  `enemy_name` varchar(255) NOT NULL,
  `time_fight` int(11) NOT NULL,
  `winner` int(11) NOT NULL DEFAULT '0',
  `losser` int(11) NOT NULL DEFAULT '0',
  `room` int(10) NOT NULL,
  `join_first` varchar(10) NOT NULL DEFAULT 'false',
  `join_second` varchar(10) NOT NULL DEFAULT 'false',
  `running` varchar(10) NOT NULL DEFAULT 'false',
  `joining` varchar(10) NOT NULL DEFAULT 'false',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
Code:
ALTER TABLE guild_fights ADD guild_frags INT(5) NOT NULL DEFAULT '0';
ALTER TABLE guild_fights ADD enemy_frags INT(5) NOT NULL DEFAULT '0';
ALTER TABLE guild_competition ADD status INT(1) NOT NULL DEFAULT '0';
Code:
CREATE TABLE IF NOT EXISTS `sellchar` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(40) NOT NULL,
  `vocation` int(11) NOT NULL,
  `price` int(11) NOT NULL,
  `status` varchar(40) NOT NULL,
  `oldid` varchar(40) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1;
Code:
CREATE TABLE IF NOT EXISTS `z_forum2` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sticky` tinyint(1) NOT NULL DEFAULT '0',
  `closed` tinyint(1) NOT NULL DEFAULT '0',
  `first_post` int(11) NOT NULL DEFAULT '0',
  `last_post` int(11) NOT NULL DEFAULT '0',
  `section` int(3) NOT NULL DEFAULT '0',
  `icon_id` int(3) NOT NULL DEFAULT '1',
  `replies` int(20) NOT NULL DEFAULT '0',
  `views` int(20) NOT NULL DEFAULT '0',
  `author_aid` int(20) NOT NULL DEFAULT '0',
  `author_guid` int(20) NOT NULL DEFAULT '0',
  `post_text` text NOT NULL,
  `post_topic` varchar(255) NOT NULL,
  `post_smile` tinyint(1) NOT NULL DEFAULT '0',
  `post_date` int(20) NOT NULL DEFAULT '0',
  `last_edit_aid` int(20) NOT NULL DEFAULT '0',
  `edit_date` int(20) NOT NULL DEFAULT '0',
  `post_ip` varchar(32) NOT NULL DEFAULT '0.0.0.0',
  PRIMARY KEY (`id`),
  KEY `section` (`section`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=78 ;
Download: HERE
 

Dexter91

New Member
Joined
Mar 31, 2013
Messages
72
Reaction score
9
Location
New York.
this is not for geisor lol!
nm. i think it is but it's buggy
 
Last edited:

Uzzio

New Member
Joined
Jan 3, 2009
Messages
27
Reaction score
0
Could you give us screen from otsmateria's layout?
 

Ervvin

New Member
Joined
Apr 21, 2015
Messages
1
Reaction score
0
Can rehost this rar? I will use it to edit my old own site.
 
Top