• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

[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
 
Back
Top