Pan Kropelka
I HATE SLENDER :(
- Joined
- Mar 28, 2013
- Messages
- 19
- Reaction score
- 4
ADD TO DB:
Download: HERE
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