ADD TO DB: Code (Text): ALTER TABLE players ADD ip varchar(255) NOT NULL Code (Text): CREATE TABLE `castle_fighters` ( `id` INT(11) NOT NULL, `guild` INT(11) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; Code (Text): 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 (Text): CREATE TABLE `castle_dmg` ( `guild` INT(11) NOT NULL, `dmg` INT(11) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; Code (Text): 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 (Text): ALTER TABLE `z_shop_offer` ADD `bought` INT( 11 ) NOT NULL DEFAULT '0'; Code (Text): ALTER TABLE `accounts` ADD `ip` VARCHAR( 30 ) NOT NULL ; Code (Text): ALTER TABLE `accounts` ADD `get_points` INT(11) NOT NULL DEFAULT '0'; Code (Text): ALTER TABLE `guilds` ADD `get_points` INT(11) NOT NULL DEFAULT '0'; Code (Text): ALTER TABLE `players` ADD `get_points` INT(11) NOT NULL DEFAULT '0'; Code (Text): ALTER TABLE `accounts` ADD `guild_points` int(11) NOT NULL DEFAULT '0'; Code (Text): 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 (Text): 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 (Text): 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 (Text): 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 (Text): ALTER TABLE `guilds` ADD `balance` BIGINT UNSIGNED NOT NULL AFTER `motd`; Code (Text): 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 (Text): 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 (Text): ALTER TABLE `killers` ADD `war` INT NOT NULL DEFAULT 0; Code (Text): 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 (Text): 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 (Text): 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 (Text): ALTER TABLE accounts ADD referrer INT(11) NOT NULL DEFAULT '0'; Code (Text): 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 (Text): 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 (Text): 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 (Text): 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 (Text): 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