Kod:
#
# `AtackLog`
#
CREATE TABLE `AtackLog` (
`ID` int(11) NOT NULL auto_increment,
`userID` int(11) NOT NULL default '0',
`toUserID` int(11) NOT NULL default '0',
`atackTurns` int(11) NOT NULL default '0',
`atackStrength` int(11) NOT NULL default '0',
`defStrength` int(11) NOT NULL default '0',
`gold` int(11) NOT NULL default '0',
`phrase` varchar(255) NOT NULL default '',
`atackUsersKilled` int(11) NOT NULL default '0',
`defUsersKilled` int(11) NOT NULL default '0',
`atackTrained` int(11) NOT NULL default '0',
`atackUnTrained` int(11) NOT NULL default '0',
`defTrained` int(11) NOT NULL default '0',
`defUnTrained` int(11) NOT NULL default '0',
`atackWeapons` varchar(255) NOT NULL default '',
`defWeapons` varchar(255) NOT NULL default '',
`atackWeaponWas` varchar(255) NOT NULL default '',
`atackWeaponIs` varchar(255) NOT NULL default '',
`time` int(11) NOT NULL default '0',
`atackWeaponCount` varchar(255) NOT NULL default '',
`defWeaponWas` varchar(255) NOT NULL default '',
`defWeaponIs` varchar(255) NOT NULL default '',
`defWeaponCount` varchar(255) NOT NULL default '',
PRIMARY KEY (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=63 ;
#
# `AtackLog`
#
# --------------------------------------------------------
#
# `IPs`
#
CREATE TABLE `IPs` (
`ID` int(11) NOT NULL auto_increment,
`ip` varchar(15) NOT NULL default '',
`userID` int(11) NOT NULL default '0',
`time` int(11) NOT NULL default '0',
PRIMARY KEY (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=14 ;
#
# `IPs`
#
INSERT INTO `IPs` (`ID`, `ip`, `userID`, `time`) VALUES (1, '67.67.147.81', 0, 1083710034),
(2, '194.146.134.4', 0, 1083709874),
(3, '67.67.147.81', 41, 1083711236),
(4, '67.67.147.81', 42, 1083711472),
(5, '67.67.147.81', 43, 1083711525),
(6, '67.67.147.81', 44, 1083711607),
(7, '24.55.128.133', 45, 1083764140),
(8, '24.55.128.133', 46, 1083764260),
(9, '66.139.248.248', 20, 1083987485),
(10, '66.139.248.248', 27, 1083987507),
(11, '66.139.248.248', 28, 1083987541),
(12, '194.146.134.4', 25, 1083987609),
(13, '194.146.134.4', 28, 1083987786);
# --------------------------------------------------------
#
# `Mercenaries`
#
CREATE TABLE `Mercenaries` (
`attackSpecCount` int(11) NOT NULL default '0',
`defSpecCount` int(11) NOT NULL default '0',
`untrainedCount` int(11) NOT NULL default '0',
`lastTurnTime` int(11) NOT NULL default '0'
) TYPE=MyISAM;
#
# `Mercenaries`
#
INSERT INTO `Mercenaries` (`attackSpecCount`, `defSpecCount`, `untrainedCount`, `lastTurnTime`) VALUES (215, 215, 215, 1083963719);
# --------------------------------------------------------
#
# `Messages`
#
CREATE TABLE `Messages` (
`ID` int(11) NOT NULL auto_increment,
`userID` int(11) NOT NULL default '0',
`fromID` int(11) NOT NULL default '0',
`subject` varchar(255) NOT NULL default '',
`text` text NOT NULL,
`date` int(11) NOT NULL default '0',
PRIMARY KEY (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=7 ;
#
# `Messages`
#
# --------------------------------------------------------
#
#`Ranks`
#
CREATE TABLE `Ranks` (
`ID` int(11) NOT NULL auto_increment,
`userID` int(11) NOT NULL default '0',
`rank` int(11) NOT NULL default '0',
`strikeActionRank` int(11) NOT NULL default '0',
`defenceActionRank` int(11) NOT NULL default '0',
`covertActionRank` int(11) NOT NULL default '0',
PRIMARY KEY (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=38 ;
#
# `Ranks`
#
INSERT INTO `Ranks` (`ID`, `userID`, `rank`, `strikeActionRank`, `defenceActionRank`, `covertActionRank`) VALUES (11, 20, 3, 4, 3, 2),
(35, 44, 0, 0, 0, 0),
(15, 24, 0, 0, 0, 0),
(16, 25, 0, 0, 0, 0),
(18, 27, 5, 5, 5, 1),
(17, 26, 2, 2, 2, 4),
(19, 28, 4, 3, 4, 3),
(37, 46, 6, 6, 6, 6),
(34, 43, 0, 0, 0, 0),
(33, 42, 0, 0, 0, 0),
(32, 41, 0, 0, 0, 0);
# --------------------------------------------------------
#
# `SpyLog`
#
CREATE TABLE `SpyLog` (
`ID` int(11) NOT NULL auto_increment,
`userID` int(11) NOT NULL default '0',
`toUserID` int(11) NOT NULL default '0',
`spyStrength` int(11) NOT NULL default '0',
`spyDefStrength` int(11) NOT NULL default '0',
`trainedAttackSold` varchar(15) NOT NULL default '',
`trainedAttackMerc` varchar(15) NOT NULL default '',
`trainedDefSold` varchar(15) NOT NULL default '',
`trainedDefMerc` varchar(15) NOT NULL default '',
`untrainedMerc` varchar(15) NOT NULL default '',
`untrainedSold` varchar(15) NOT NULL default '',
`strikeAction` varchar(15) NOT NULL default '',
`defenceAction` varchar(15) NOT NULL default '',
`covertSkill` varchar(15) NOT NULL default '',
`covertOperatives` varchar(15) NOT NULL default '',
`siegeLevel` varchar(15) NOT NULL default '',
`atackTurns` varchar(15) NOT NULL default '',
`unitProduction` varchar(15) NOT NULL default '',
`weapons` varchar(255) NOT NULL default '',
`types` varchar(255) NOT NULL default '',
`types2` varchar(255) NOT NULL default '',
`quantities` varchar(255) NOT NULL default '',
`strengths` varchar(255) NOT NULL default '',
`allStrengths` varchar(255) NOT NULL default '',
`time` int(11) NOT NULL default '0',
`spies` int(11) NOT NULL default '0',
`isSuccess` tinyint(1) NOT NULL default '0',
`race` int(11) NOT NULL default '0',
PRIMARY KEY (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=38 ;
#
# `SpyLog`
#
# --------------------------------------------------------
#
# `UserDetails`
#
CREATE TABLE `UserDetails` (
`ID` int(11) NOT NULL auto_increment,
`userName` varchar(100) NOT NULL default '',
`race` tinyint(4) NOT NULL default '0',
`e_mail` varchar(255) NOT NULL default '',
`password` varchar(50) NOT NULL default '',
`commander` int(11) NOT NULL default '0',
`active` int(1) NOT NULL default '0',
`uniqueLink` varchar(12) NOT NULL default '',
`fortificationLevel` int(11) NOT NULL default '0',
`siegeLevel` int(11) NOT NULL default '0',
`gold` int(11) NOT NULL default '0',
`attackTurns` int(11) NOT NULL default '0',
`currentUnitProduction` int(11) default NULL,
`currentSpySkill` int(11) default NULL,
`trainedAttackSold` int(11) default NULL,
`trainedAttackMerc` int(11) default NULL,
`trainedDefSold` int(11) default NULL,
`trainedDefMerc` int(11) default NULL,
`untrainedSold` float default NULL,
`untrainedMerc` int(11) default NULL,
`spies` int(11) default NULL,
`lastTurnTime` int(11) NOT NULL default '0',
PRIMARY KEY (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=49 ;
#
# `UserDetails`
#
INSERT INTO `UserDetails` (`ID`, `userName`, `race`, `e_mail`, `password`, `commander`, `active`, `uniqueLink`, `fortificationLevel`, `siegeLevel`, `gold`, `attackTurns`, `currentUnitProduction`, `currentSpySkill`, `trainedAttackSold`, `trainedAttackMerc`, `trainedDefSold`, `trainedDefMerc`, `untrainedSold`, `untrainedMerc`, `spies`, `lastTurnTime`) VALUES (27, 'user13', 2, 'user13@email.ru', '1', 0, 1, 'uk4610829096', 1, 1, 2053218, 180, 24, 38, 21, 864, 490, 1831, '1580', 1049, 237, 1083987525),
(28, 'user5', 3, 'user14@email.ru', '1', 0, 1, 'uu3310829096', 3, 3, 1, 1, 80, 25, 1, 1, 1, 1, '1', 1, 223, 1083987973),
(44, 'xvxczcxddaa', 0, 'csmaster2005@hotmail.com', '32800635', 0, 0, 'sl1083711607', 0, 0, 2800, 17, 0, 0, 0, 0, 0, 0, '1', 0, 0, 1083711607),
(20, 'user6', 1, 'user6@email.ru', '1', 0, 1, 'yt2010829096', 1, 0, 7171076, 221, 55, 28, 1582, 1716, 719, 1084, '4264', 1365, 1237, 1089727410),
(46, 'jason', 0, 'webmaster@worldhatred.com', 'internet', 0, 1, 'ep1083764260', 0, 0, 3699, 46, 0, 0, 0, 0, 0, 0, '1', 0, 0, 1083764636),
(26, 'user12', 1, 'user12@email.ru', '1', 0, 1, 'ab6810829096', 3, 1, 9071948, 210, 91, 18, 1770, 912, 1850, 1959, '5651', 459, 808, 1090281246),
(25, 'user11', 1, 'user11@email.ru', '1', 0, 0, 'df8510829096', 2, 2, 83874, 98, 13, 0, 1670, 654, 1047, 979, '1273', 527, 207, 1083611939),
(24, 'user10', 2, 'user10@email.ru', '1', 0, 0, 'iu2421082909', 2, 2, 132483, 75, 92, 79, 1146, 1197, 1, 1881, '1998', 1881, 772, 1084659030),
(43, 'xvxczcxdd', 0, 'csmaster2005@hotmail.com', '40447503', 0, 0, 'ez1083711525', 0, 0, 2800, 17, 0, 0, 0, 0, 0, 0, '1', 0, 0, 1083711525),
(42, 'xvxczcx', 0, 'test@hotmail.com', '34349144', 0, 0, 'rg1083711472', 0, 0, 2800, 17, 0, 0, 0, 0, 0, 0, '1', 0, 0, 1083711472),
(41, 'sfdsfsfd', 2, 'myemail@hotmail.com', '33360663', 0, 0, 'ql1083711236', 0, 0, 2800, 17, 0, 0, 0, 0, 0, 0, '1', 0, 0, 1083711236),
(45, 'tsunami', 0, 'abuse@pimpkane.com', '65882608', 0, 0, 'pi1083764140', 0, 0, 806, 43, 0, 0, 0, 0, 0, 0, '1', 0, 0, 1083765813),
(48, 'admin', 0, 'admin@mail.com', '1', 0, 4, '', 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);
# --------------------------------------------------------
#
# `Weapon`
#
CREATE TABLE `Weapon` (
`ID` int(11) NOT NULL auto_increment,
`weaponID` int(11) NOT NULL default '0',
`weaponStrength` int(11) NOT NULL default '0',
`weaponCount` int(11) NOT NULL default '0',
`isAtack` int(11) NOT NULL default '0',
`userID` int(11) NOT NULL default '0',
PRIMARY KEY (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=25 ;
#
# `Weapon`
#
INSERT INTO `Weapon` (`ID`, `weaponID`, `weaponStrength`, `weaponCount`, `isAtack`, `userID`) VALUES (24, 0, 10, 1, 0, 45),
(23, 0, 5, 1, 1, 45);
# --------------------------------------------------------
#
# `c_ban_users`
#
CREATE TABLE `c_ban_users` (
`username` varchar(30) NOT NULL default '',
`latin1` tinyint(1) NOT NULL default '0',
`ip` varchar(16) NOT NULL default '',
`rooms` varchar(100) NOT NULL default '',
`ban_until` int(11) NOT NULL default '0'
) TYPE=MyISAM;
#
# `c_ban_users`
#
# --------------------------------------------------------
#
# `c_messages`
#
CREATE TABLE `c_messages` (
`type` tinyint(1) NOT NULL default '0',
`room` varchar(30) NOT NULL default '',
`username` varchar(30) NOT NULL default '',
`latin1` tinyint(1) NOT NULL default '0',
`m_time` int(11) NOT NULL default '0',
`address` varchar(30) NOT NULL default '',
`message` text NOT NULL
) TYPE=MyISAM;
#
# `c_messages`
#
INSERT INTO `c_messages` (`type`, `room`, `username`, `latin1`, `m_time`, `address`, `message`) VALUES (1, 'Default', 'SYS enter', 0, 1080955692, '', 'sprintf(L_ENTER_ROM, "vv")'),
(1, 'Default', 'SYS welcome', 0, 1080956641, 'vv', 'sprintf("Welcome to our chat. Please obey the net etiquette while chatting: <I>try to be pleasant and polite</I>.")'),
(1, 'Default', 'vv', 1, 1080955707, '', '<FONT COLOR="#000000">fuck</FONT>'),
(1, 'Default', 'vv', 1, 1080955710, '', '<FONT COLOR="#000000">dfgdfg</FONT>'),
(1, 'Default', 'vv', 1, 1080955715, '', '<FONT COLOR="#3ffc40">dsfsdf</FONT>'),
(1, 'Default', 'vv', 1, 1080955718, '', '<FONT COLOR="#a503d3">sdfsdf</FONT>'),
(1, 'Default', 'SYS enter', 0, 1080955950, '', 'sprintf(L_ENTER_ROM, "rrrr")'),
(1, 'Default', 'SYS welcome', 0, 1080955951, 'rrrr', 'sprintf("Welcome to our chat. Please obey the net etiquette while chatting: <I>try to be pleasant and polite</I>.")'),
(1, 'Default', 'rrrr', 1, 1080955973, '', '<FONT COLOR="#000000">vv> rrr</FONT>'),
(1, 'Default', 'SYS enter', 0, 1080955995, '', 'sprintf(L_ENTER_ROM, "ee")'),
(1, 'Default', 'SYS welcome', 0, 1080956023, 'ee', 'sprintf("Welcome to our chat. Please obey the net etiquette while chatting: <I>try to be pleasant and polite</I>.")'),
(1, 'Default', 'SYS exit', 0, 1080956012, '', 'sprintf(L_EXIT_ROM, "ee")'),
(1, 'MyRoom1', 'SYS enter', 0, 1080956012, '', 'sprintf(L_ENTER_ROM, "ee")'),
(1, 'MyRoom1', 'SYS exit', 0, 1080956016, '', 'sprintf(L_EXIT_ROM, "ee")'),
(1, 'MyRoom2', 'SYS enter', 0, 1080956017, '', 'sprintf(L_ENTER_ROM, "ee")'),
(1, 'MyRoom2', 'SYS exit', 0, 1080956022, '', 'sprintf(L_EXIT_ROM, "ee")'),
(1, 'Default', 'SYS enter', 0, 1080956022, '', 'sprintf(L_ENTER_ROM, "ee")'),
(1, 'Default', 'SYS enter', 0, 1080956640, '', 'sprintf(L_ENTER_ROM, "vv")'),
(1, 'Default', 'SYS enter', 0, 1080979836, '', 'sprintf(L_ENTER_ROM, "iii")'),
(1, 'Default', 'SYS welcome', 0, 1080979837, 'iii', 'sprintf("Welcome to our chat. Please obey the net etiquette while chatting: <I>try to be pleasant and polite</I>.")'),
(1, 'Default', 'iii', 1, 1080979862, '', '<FONT COLOR="#000000">ghgfhg</FONT>');
# --------------------------------------------------------
#
# `c_reg_users`
#
CREATE TABLE `c_reg_users` (
`username` varchar(30) NOT NULL default '',
`latin1` tinyint(1) NOT NULL default '0',
`password` varchar(32) NOT NULL default '',
`firstname` varchar(64) NOT NULL default '',
`lastname` varchar(64) NOT NULL default '',
`country` varchar(64) NOT NULL default '',
`website` varchar(64) NOT NULL default '',
`email` varchar(64) NOT NULL default '',
`showemail` tinyint(1) NOT NULL default '0',
`perms` varchar(9) NOT NULL default '',
`rooms` varchar(128) NOT NULL default '',
`reg_time` int(11) NOT NULL default '0',
`ip` varchar(16) NOT NULL default '',
`gender` tinyint(1) NOT NULL default '0'
) TYPE=MyISAM;
#
# `c_reg_users`
#
INSERT INTO `c_reg_users` (`username`, `latin1`, `password`, `firstname`, `lastname`, `country`, `website`, `email`, `showemail`, `perms`, `rooms`, `reg_time`, `ip`, `gender`) VALUES ('admin', 0, '21232f297a57a5a743894a0e4a801fc3', '', '', '', '', '', 0, 'admin', '', 0, '', 0),
('vv', 1, 'c4055e3a20b6b3af3d10590ea446ef6c', 'vv', 'vv', '', '', 'vv@vv.vv', 0, 'user', '', 1080956640, '127.0.0.1', 0);
# --------------------------------------------------------
#
# `c_users`
#
CREATE TABLE `c_users` (
`room` varchar(30) NOT NULL default '',
`username` varchar(30) NOT NULL default '',
`latin1` tinyint(1) NOT NULL default '0',
`u_time` int(11) NOT NULL default '0',
`status` char(1) NOT NULL default '',
`ip` varchar(16) NOT NULL default '',
UNIQUE KEY `room` (`room`,`username`)
) TYPE=MyISAM;
4. Jak na razie tyle co do instalacji.
Zakładki