PgvjtgcN

1  ▄████  ▄▄▄     ▄▄▄█████▓ ▒█████   ██▀███   ██▓    ▓█████ ▄▄▄        ▄████  █    ██ ▓█████ 
2 ██▒ ▀█▒▒████▄   ▓  ██▒ ▓▒▒██▒  ██▒▓██ ▒ ██▒▓██▒    ▓█   ▀▒████▄     ██▒ ▀█▒ ██  ▓██▒▓█   ▀ 
3▒██░▄▄▄░▒██  ▀█▄ ▒ ▓██░ ▒░▒██░  ██▒▓██ ░▄█ ▒▒██░    ▒███  ▒██  ▀█▄  ▒██░▄▄▄░▓██  ▒██░▒███   
4░▓█  ██▓░██▄▄▄▄██░ ▓██▓ ░ ▒██   ██░▒██▀▀█▄  ▒██░    ▒▓█  ▄░██▄▄▄▄██ ░▓█  ██▓▓▓█  ░██░▒▓█  ▄ 
5░▒▓███▀▒ ▓█   ▓██▒ ▒██▒ ░ ░ ████▓▒░░██▓ ▒██▒░██████▒░▒████▒▓█   ▓██▒░▒▓███▀▒▒▒█████▓ ░▒████▒
6 ░▒   ▒  ▒▒   ▓▒█░ ▒ ░░   ░ ▒░▒░▒░ ░ ▒▓ ░▒▓░░ ▒░▓  ░░░ ▒░ ░▒▒   ▓▒█░ ░▒   ▒ ░▒▓▒ ▒ ▒ ░░ ▒░ ░
7  â–‘   â–‘   â–’   â–’â–’ â–‘   â–‘      â–‘ â–’ â–’â–‘   â–‘â–’ â–‘ â–’â–‘â–‘ â–‘ â–’  â–‘ â–‘ â–‘  â–‘ â–’   â–’â–’ â–‘  â–‘   â–‘ â–‘â–‘â–’â–‘ â–‘ â–‘  â–‘ â–‘  â–‘
8â–‘ â–‘   â–‘   â–‘   â–’    â–‘      â–‘ â–‘ â–‘ â–’    â–‘â–‘   â–‘   â–‘ â–‘      â–‘    â–‘   â–’   â–‘ â–‘   â–‘  â–‘â–‘â–‘ â–‘ â–‘    â–‘   
9      â–‘       â–‘  â–‘            â–‘ â–‘     â–‘         â–‘  â–‘   â–‘  â–‘     â–‘  â–‘      â–‘    â–‘        â–‘  â–‘
10---------------------------------[http://www.twitter.com/GatorLeagues]---------------------------------------------------
11Just helping out #OpUSA #OpIsrael.
12----------------------
13https://gangster.co.il
14---------------------
15--
16-- Database: `doidjbpy_game`
17--
18
19-- --------------------------------------------------------
20
21--
22-- Table structure for table `admins`
23--
24
25CREATE TABLE IF NOT EXISTS `admins` (
26  `id` int(6) NOT NULL AUTO_INCREMENT,
27  `userID` int(6) NOT NULL,
28  PRIMARY KEY (`id`)
29) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
30
31-- --------------------------------------------------------
32
33--
34-- Table structure for table `allies`
35--
36
37CREATE TABLE IF NOT EXISTS `allies` (
38  `id` int(11) NOT NULL AUTO_INCREMENT,
39  `name` varchar(50) CHARACTER SET utf8 NOT NULL,
40  `totalForce` bigint(12) NOT NULL,
41  `percentsForce` int(6) NOT NULL DEFAULT '1',
42  `gold` int(6) NOT NULL DEFAULT '0',
43  `owner` varchar(30) CHARACTER SET utf8 NOT NULL,
44  `description` text CHARACTER SET utf8 NOT NULL,
45  PRIMARY KEY (`id`)
46) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=61 ;
47
48--
49-- Dumping data for table `allies`
50--
51
52INSERT INTO `allies` (`id`, `name`, `totalForce`, `percentsForce`, `gold`, `owner`, `description`) VALUES
53(24, 'ֳ—ֵ¾ֳ—ֲ×ֳ—ג€¢ֳ—ֲ§ֳ—ג„¢', 0, 1, 19950600, 'yakir', ''),
54(27, 'Pongik', 4626310133250000, 5, 19950600, 'DorTheSus', 'ֳ—ֲֳ—ג€“ ֳ—ג€˜ֳ—ֲ¡ֳ—ג€¢ֳ—ֲ£ ֳ—ג€ֳ—ֵ¾ֳ—ג€¢ֳ—ֲ¨ֳ—ג€œֳ—ג„¢ֳ—ֲ ֳ—ג€÷ֳ—ֵ¸ ֳ—ג€ֳ—ֲ×ֳ—ֲ₪ֳ—ֲ¨ֳ—ֲ§ֳ—ג€¢, ֳ—ֵ¾ֳ—ֲ₪ֳ—ֲ×ֳ—ג„¢ֳ—ֲ¢.\r\nֳ—ג€ֳ—ֲ₪ֳ—ֲ¢ֳ—ֲ ֳ—ג€÷ֳ—ג€˜ֳ—ֲ¨ ֳ—ג€ֳ—ֲ ֳ—ֵ“ֳ—ֲ ֳ—ג„¢ֳ—ֲ¦ֳ—ֵ“ֳ—ג„¢ֳ—ג€”ֳ—ג€¢ ֳ—ֵ“ֳ—ג€”ֳ—ג€“ֳ—ג€¢ֳ—ֲ¨ ֳ—ֵ¾ֳ—ג€ֳ—ֵ¾ֳ—ֲ¦ֳ—ג€˜ ֳ—ֲ©ֳ—ג€˜ֳ—ג€¢ ֳ—ג€ֳ—ֲ ֳ—ֲ ֳ—ֵ¾ֳ—ֲ¦ֳ—ֲֳ—ג„¢ֳ—ֲ.'),
55(28, 'Fuck', 1699, 1, 19950600, 'eds', ''),
56(31, 'ֳ—ג€™ֳ—ג€˜ֳ—ֲ¨ ֳ—ֲ¨ֳ—ֲ¦ֳ—ג€”', 110181992, 5, 19950600, 'gevergever', 'ֳ—ֲֳ—ֲ ֳ—ג€”ֳ—ֲ ֳ—ג€¢ ֳ—ג€™ֳ—ג€˜ֳ—ֲ¨ֳ—ג„¢ֳ—ֲ ֳ—ֲ¨ֳ—ֲ¦ֳ—ג€” ֳ—ג€¢ֳ—ג€÷ֳ—ֵ“ ֳ—ג€“ֳ—ג€'),
57(33, 'Pudding', 3587652, 5, 19950600, 'MrPudding', ''),
58(40, 'Attack', 35366263, 1, 19950600, 'eilon', 'ֳ—ג€˜ֳ—ֲ¨ֳ—ג„¢ֳ—ֲ× ֳ—ג€“ֳ—ג€¢, ֳ—ג€ֳ—ג„¢ֳ—ֲ ֳ—ג€˜ֳ—ֲ¨ֳ—ג„¢ֳ—ֲ× ֳ—ג€ֳ—ֲ©ֳ—ֲ ֳ—ג„¢ֳ—ג€ ! ֳ—ג€˜ֳ—ג€™ֳ—ג€¢ֳ—ג€œֳ—ֵ“ֳ—ג€ ֳ—ג€˜ֳ—ֵ¾ֳ—ֲ©ֳ—ג€”ֳ—ֲ§ .'),
59(41, 'ֳ—ג€™ֳ—ג€˜ֳ—ֲ¨ֳ—ג€™ֳ—ג€˜ֳ—ֲ¨', 100841987251, 4, 19950600, 'bacta', ''),
60(42, 'AdMatay', 9223372036854775807, 1, 19950600, 'frozenick', ''),
61(43, 'ֳ—ג€ֳ—ֵ¾ֳ—ֵ“ֳ—ֵ¡', 423221209511, 5, 19950600, 'DipDark', '\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\nֳ—ג€ֳ—ג€˜ֳ—ֲ¨ֳ—ג„¢ֳ—ֲ× ֳ—ֲ©ֳ—ֵ“ֳ—ג„¢ ֳ—ג€ֳ—ג„¢ֳ—ֲ ֳ—ג€ֳ—ג€˜ֳ—ֲ¨ֳ—ג„¢ֳ—ֲ× ֳ—ֲ©ֳ—ֲ×ֳ—ֲ©ֳ—ֵ“ֳ—ג€¢ֳ—ֻœ ֳ—ג€˜ֳ—ֵ¾ֳ—ֲ©ֳ—ג€”ֳ—ֲ§ ֳ—ג€ֳ—ג€“ֳ—ג€.\r\nֳ—ֵ¾ֳ—ג€ֳ—ֲ¨ֳ—ג€¢ ֳ—ֵ“ֳ—ֲ₪ֳ—ֲ ֳ—ג„¢ ֳ—ֲ©ֳ—ג€ֳ—ג€ֳ—ֲ¨ֳ—ֲ©ֳ—ֵ¾ֳ—ג€ ֳ—ֵ“ֳ—ג€˜ֳ—ֲ¨ֳ—ג„¢ֳ—ֲ× ֳ—ֲ×ֳ—ג€™ֳ—ֵ¾ֳ—ֲ¨.\r\nֳ—ג€÷ֳ—ג€œֳ—ֲֳ—ג„¢ ֳ—ֵ“ֳ—ג€÷ֳ—ֲ ֳ—ֵ“ֳ—ג€ֳ—ֲ¦ֳ—ֻœֳ—ֲ¨ֳ—ֲ£..\r\nֳ—ג€÷ֳ—ֵ“ ֳ—ֵ¾ֳ—ג„¢ ֳ—ֲ©ֳ—ג„¢ֳ—ֲ×ֳ—ֲ¢ֳ—ֲ¡ֳ—ֲ§ ֳ—ֲֳ—ג„¢ֳ—ֲ×ֳ—ֲ ֳ—ג€¢..\r\nֳ—ֲ¨ֳ—ֲ¢ ֳ—ג€¢ֳ—ֵ¾ֳ—ֲ¨ ֳ—ג„¢ֳ—ג€ֳ—ג„¢ֳ—ג€ ֳ—ג€™ֳ—ג€¢ֳ—ֲ¨ֳ—ֵ“ֳ—ג€¢.'),
62(44, 'Winner', 9223372036854775807, 1, 19950600, 'yakir1', ''),
63(45, 'jhhihi', 123, 1, 19950600, 'tomer4481', ''),
64(47, 'LOLL', 9223372036854775807, 5, 19950600, 'Admin', 'ֳ—ֲ ֳ—ג„¢ֳ—ֲ¦ֳ—ג€”ֳ—ג€¢ֳ—ֵ¸'),
65(50, 'Yakir Is Hacker', 9223372036854775807, 5, 19950600, 'IAW', ''),
66(51, 'ֳ—ג€÷ֳ—ג€÷ֳ—ג€÷ֳ—ג€÷ֳ—ג€÷ֳ—ג€÷ֳ—ג€÷ֳ—ג€÷', 9223372036854775807, 1, 19950600, 'Admin', 'ֳ—ג€ֳ—ג„¢ֳ—ג€ ֳ—ג€÷ֳ—ג„¢ֳ—ֲ£ :) ֳ—ג€”ֳ—ג€˜ֳ—ֵ“ ֳ—ֲ©ֳ—ֵ¾ֳ—ג€”ֳ—ֲ§ֳ—ֲ×ֳ—ֲ ֳ—ֲֳ—ג€¢ֳ—ֲ×ֳ—ג„¢...\r\n\r\nֳ—ֲֳ—ֲ ֳ—ג„¢ ֳ—ֲ¢ֳ—ג€œֳ—ג„¢ֳ—ג„¢ֳ—ֵ¸ ֳ—ֲ©ֳ—ג€¢ֳ—ֵ“ֳ—ֻœ ֳ—ג€¢ֳ—ֲ×ֳ—ֵ¾ֳ—ג„¢ֳ—ג€œ ֳ—ֲֳ—ֲ©ֳ—ֵ“ֳ—ג€¢ֳ—ֻœ :)'),
67(53, 'An Inspector Calls', 9223372036854775807, 5, 19950600, 'InSpecToR', '- An Inspector Calls -\r\n\r\nֳ—ֵ¾ֳ—ג„¢ ֳ—ֲ©ֳ—ֲ¨ֳ—ג€¢ֳ—ֲ¦ֳ—ג€ ֳ—ג€ֳ—ג€™ֳ—ֲ ֳ—ג€ ֳ—ֵ¾ֳ—ג€ֳ—ג€œֳ—ג„¢ֳ—ֲ¨ֳ—ג€¢ֳ—ג€™ֳ—ג„¢ֳ—ֲ ֳ—ג€ֳ—ֲ¨ֳ—ֲֳ—ֲ©ֳ—ג€¢ֳ—ֲ ֳ—ג„¢ֳ—ֲ ֳ—ג€˜ֳ—ֵ¾ֳ—ֲ©ֳ—ג€”ֳ—ֲ§, ֳ—ֲ©ֳ—ג„¢ֳ—ֲ©ֳ—ֵ“ֳ—ג€” ֳ—ֵ“ֳ—ג„¢ ֳ—ג€ֳ—ג€¢ֳ—ג€œֳ—ֲ¢ֳ—ג€ ֳ—ג€¢ֳ—ֲֳ—ֲ ֳ—ג„¢ ֳ—ג„¢ֳ—ֲ©ֳ—ֵ“ֳ—ג€” ֳ—ֵ“ֳ—ג€¢ ֳ—ג€˜ֳ—ֲ§ֳ—ֲ©ֳ—ֲ× ֳ—ג€ֳ—ֲ¦ֳ—ֻœֳ—ֲ¨ֳ—ֲ₪ֳ—ג€¢ֳ—ֲ× ֳ—ֵ“ֳ—ֲ©ֳ—ג€˜ֳ—ֻœ.\r\n\r\nֳ—ג€”ֳ—ֲ¡ֳ—ג€¢ֳ—ֵ¾ֳ—ג„¢ֳ—ֲ ֳ—ֵ“ֳ—ג€÷ֳ—ֲ ֳ—ג„¢ֳ—ֲ¡ֳ—ג€ (ֳ—ג€ֳ—ֲ¨ֳ—ֵ¾ֳ—ֲֳ—ג„¢ֳ—ֲ ֳ—ֵ“ֳ—ֵ¾ֳ—ג„¢ֳ—ֲ ֳ—ג„¢ֳ—ג€ֳ—ֲ):\r\nyakir1\r\nDorTheSus'),
68(56, 'ֳ—ֲ¡ֳ—ֲ§ֳ—ֲ¡', 3215353455742096512, 1, 19950600, 'mamama', ''),
69(57, 'ֳ—ג€”ֳ—ג€”ֳ—ג€”ֳ—ג€”ֳ—ג€”', 761790794, 1, 19950600, 'ֳ—ג„¢ֳ—ֲ§ֳ—ג„¢ֳ—ֲ¨ ֳ—ֵ¾ֳ—ג€ֳ—ג€œֳ—ג€¢ֳ—ֲ¨ֳ—ג„¢', ''),
70(58, 'Matoki', 50944425, 5, 19950600, 'DORVegas', ''),
71(59, 'makore', 7, 1, 0, 'relog123', 'ֳ—ֵ¾ֳ—ג€ ֳ—ֲ§ֳ—ג€¢ֳ—ֲ¨ֳ—ג€ ֳ—ג€”ֳ—ג€˜ֳ—ֲ¨?\r\n'),
72(60, '090', 1190, 1, 0, 'yakir112', 'hrhksdakhfdksfnoksdnflkdsnflksdnflkwsn');
73
74-- --------------------------------------------------------
75
76--
77-- Table structure for table `alliesmembers`
78--
79
80CREATE TABLE IF NOT EXISTS `alliesmembers` (
81  `id` int(6) NOT NULL AUTO_INCREMENT,
82  `name` varchar(30) CHARACTER SET utf8 NOT NULL,
83  `ally` varchar(30) CHARACTER SET utf8 NOT NULL,
84  `position` varchar(30) NOT NULL DEFAULT 'normal',
85  `goldDonating` int(6) NOT NULL DEFAULT '0',
86  PRIMARY KEY (`id`)
87) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=275 ;
88
89--
90-- Dumping data for table `alliesmembers`
91--
92
93INSERT INTO `alliesmembers` (`id`, `name`, `ally`, `position`, `goldDonating`) VALUES
94(112, 'DorTheSus', 'Pongik', 'owner', 4144287),
95(115, 'eds', 'Fuck', 'owner', 5015),
96(189, 'gevergever', 'ֳ—ג€™ֳ—ג€˜ֳ—ֲ¨ ֳ—ֲ¨ֳ—ֲ¦ֳ—ג€”', 'owner', 23754864),
97(190, 'orion', 'ֳ—ג€™ֳ—ג€˜ֳ—ֲ¨ ֳ—ֲ¨ֳ—ֲ¦ֳ—ג€”', 'owner', 5012087),
98(191, 'kami_sama', 'ֳ—ג€™ֳ—ג€˜ֳ—ֲ¨ ֳ—ֲ¨ֳ—ֲ¦ֳ—ג€”', 'normal', 40000),
99(193, 'ֳ—ֲ©ֳ—ֵ¾ֳ—ג€¢ֳ—ֵ“ֳ—ג„¢ֳ—ֲ§_ֳ—ג€ֳ—ֲ§ֳ—ג„¢ֳ—ֲ₪ֳ—ג€¢ֳ—ג€œ', 'ֳ—ג€™ֳ—ג€˜ֳ—ֲ¨ ֳ—ֲ¨ֳ—ֲ¦ֳ—ג€”', 'normal', 1569159),
100(198, 'ProToAll', 'ֳ—ג€™ֳ—ג€˜ֳ—ֲ¨ ֳ—ֲ¨ֳ—ֲ¦ֳ—ג€”', 'normal', 6),
101(199, 'talx1999talx', 'ֳ—ג€™ֳ—ג€˜ֳ—ֲ¨ ֳ—ֲ¨ֳ—ֲ¦ֳ—ג€”', 'normal', 0),
102(201, 'ֳ—ֲֳ—ג„¢ֳ—ֵ¸ֳ—ֵ“ֳ—ג„¢ֳ—ֲ©ֳ—ֲ ֳ—ג„¢ֳ—ֵ¾ֳ—ֲ©ֳ—ֲ×ֳ—ֵ¾ֳ—ֲ©ֳ—ג„¢ֳ—ֲ', 'ֳ—ג€™ֳ—ג€˜ֳ—ֲ¨ ֳ—ֲ¨ֳ—ֲ¦ֳ—ג€”', 'normal', 0),
103(203, 'MrPudding', 'Pudding', 'owner', 7921253),
104(235, 'eilon', 'Attack', 'owner', 0),
105(237, 'bacta', 'ֳ—ג€™ֳ—ג€˜ֳ—ֲ¨ֳ—ג€™ֳ—ג€˜ֳ—ֲ¨', 'owner', 2022136),
106(240, 'frozenick', 'AdMatay', 'owner', 0),
107(242, 'DipDark', 'ֳ—ג€ֳ—ֵ¾ֳ—ֵ“ֳ—ֵ¡', 'owner', 2261110),
108(246, 'yakir1', 'Winner', 'owner', 0),
109(247, 'tomer4481', 'jhhihi', 'owner', 0),
110(249, 'Admin', 'LOLL', 'owner', 2147483647),
111(253, 'IAW', 'Yakir Is Hacker', 'owner', 6000000),
112(254, 'Admin', 'ֳ—ג€÷ֳ—ג€÷ֳ—ג€÷ֳ—ג€÷ֳ—ג€÷ֳ—ג€÷ֳ—ג€÷ֳ—ג€÷', 'owner', 0),
113(256, 'InSpecToR', 'An Inspector Calls', 'owner', 2700000),
114(257, 'Regeneration', 'An Inspector Calls', 'normal', 2147483647),
115(258, 'CommulativeFrequency', 'An Inspector Calls', 'normal', 2147483647),
116(259, 'KoKoLoKo', 'An Inspector Calls', 'normal', 2147483647),
117(260, 'SlonoSarSki', 'An Inspector Calls', 'normal', 2147483647),
118(261, 'test', 'ֳ—ג€™ֳ—ג€˜ֳ—ֲ¨ ֳ—ֲ¨ֳ—ֲ¦ֳ—ג€”', 'normal', 0),
119(269, 'mamama', 'ֳ—ֲ¡ֳ—ֲ§ֳ—ֲ¡', 'owner', 0),
120(270, 'bolbol', 'ֳ—ֲ¡ֳ—ֲ§ֳ—ֲ¡', 'normal', 2147483647),
121(271, 'ֳ—ג„¢ֳ—ֲ§ֳ—ג„¢ֳ—ֲ¨ ֳ—ֵ¾ֳ—ג€ֳ—ג€œֳ—ג€¢ֳ—ֲ¨ֳ—ג„¢', 'ֳ—ג€”ֳ—ג€”ֳ—ג€”ֳ—ג€”ֳ—ג€”', 'owner', 0),
122(272, 'DORVegas', 'Matoki', 'owner', 22550600),
123(273, 'relog123', 'makore', 'owner', 0),
124(274, 'yakir112', '090', 'owner', 0);
125
126-- --------------------------------------------------------
127
128--
129-- Table structure for table `allyinvites`
130--
131
132CREATE TABLE IF NOT EXISTS `allyinvites` (
133  `id` int(6) NOT NULL AUTO_INCREMENT,
134  `reciever` varchar(30) CHARACTER SET utf8 NOT NULL,
135  `ally` varchar(30) CHARACTER SET utf8 NOT NULL,
136  PRIMARY KEY (`id`)
137) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
138
139-- --------------------------------------------------------
140
141--
142-- Table structure for table `attacks`
143--
144
145CREATE TABLE IF NOT EXISTS `attacks` (
146  `id` int(6) NOT NULL AUTO_INCREMENT,
147  `attacker` varchar(30) NOT NULL,
148  `defer` varchar(30) NOT NULL,
149  `winner` varchar(30) NOT NULL,
150  `goldWin` int(6) NOT NULL,
151  `ironWin` int(6) NOT NULL,
152  `woodWin` int(6) NOT NULL,
153  `cropWin` int(6) NOT NULL,
154  `attackerAtt` bigint(12) NOT NULL,
155  `deferDef` bigint(12) NOT NULL,
156  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
157  PRIMARY KEY (`id`)
158) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
159
160-- --------------------------------------------------------
161
162--
163-- Table structure for table `develop`
164--
165
166CREATE TABLE IF NOT EXISTS `develop` (
167  `userID` int(6) NOT NULL,
168  `bankGold` bigint(9) NOT NULL DEFAULT '0',
169  `interest` int(1) NOT NULL DEFAULT '1',
170  `id` int(6) NOT NULL AUTO_INCREMENT,
171  `totalWorkers` int(6) NOT NULL DEFAULT '100',
172  `inactiveWorkers` int(6) NOT NULL DEFAULT '0',
173  `activeWorkers` int(6) NOT NULL DEFAULT '100',
174  `turns` int(6) NOT NULL DEFAULT '200',
175  `woodWorkers` int(6) NOT NULL DEFAULT '25',
176  `cropWorkers` int(6) NOT NULL DEFAULT '25',
177  `ironWorkers` int(6) NOT NULL DEFAULT '25',
178  `goldWorkers` int(6) NOT NULL DEFAULT '25',
179  `goldProd` int(6) NOT NULL DEFAULT '2',
180  `ironProd` int(6) NOT NULL DEFAULT '2',
181  `woodProd` int(6) NOT NULL DEFAULT '2',
182  `cropProd` int(6) NOT NULL DEFAULT '2',
183  `soldiers` int(6) NOT NULL DEFAULT '5',
184  `spies` int(6) NOT NULL DEFAULT '5',
185  `withoutPosition` int(6) NOT NULL DEFAULT '100',
186  `attack` bigint(15) NOT NULL DEFAULT '10',
187  `def` bigint(15) NOT NULL DEFAULT '10',
188  `spy` bigint(15) NOT NULL DEFAULT '0',
189  `avgPower` bigint(15) NOT NULL DEFAULT '6',
190  `attackLvl` int(6) NOT NULL DEFAULT '1',
191  `defLvl` int(6) NOT NULL DEFAULT '1',
192  `spyLvl` int(6) NOT NULL DEFAULT '1',
193  `spyWep` bigint(15) NOT NULL DEFAULT '0',
194  `attWep` bigint(15) NOT NULL DEFAULT '2',
195  `defWep` bigint(15) NOT NULL DEFAULT '2',
196  `withoutPositionPerHour` int(6) NOT NULL DEFAULT '1',
197  `turnsPerUpdate` int(6) NOT NULL DEFAULT '5',
198  `diamondsPerUpdate` int(6) NOT NULL DEFAULT '10',
199  `goldUpgrade` int(6) NOT NULL DEFAULT '1',
200  `woodUpgrade` int(6) NOT NULL DEFAULT '1',
201  `ironUpgrade` int(6) NOT NULL DEFAULT '1',
202  `cropUpgrade` int(6) NOT NULL DEFAULT '1',
203  `ally` varchar(30) DEFAULT '',
204  `attacksWin` int(6) NOT NULL DEFAULT '0',
205  `attacksLose` int(6) NOT NULL DEFAULT '0',
206  `defWin` int(6) NOT NULL DEFAULT '0',
207  `defLose` int(6) NOT NULL DEFAULT '0',
208  `spyWin` int(6) NOT NULL DEFAULT '0',
209  `spyLose` int(6) NOT NULL DEFAULT '0',
210  `scoutWin` int(6) NOT NULL DEFAULT '0',
211  `scoutLose` int(6) NOT NULL DEFAULT '0',
212  `medal` varchar(30) NOT NULL DEFAULT '',
213  `gems` int(6) NOT NULL DEFAULT '0',
214  `monster` int(6) NOT NULL DEFAULT '1',
215  `monsterWin` int(6) NOT NULL DEFAULT '0',
216  `admin` varchar(6) NOT NULL DEFAULT '0',
217  `Deposits` int(1) NOT NULL DEFAULT '3',
218  `ban` varchar(10) NOT NULL DEFAULT '0',
219  PRIMARY KEY (`id`)
220) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
221
222-- --------------------------------------------------------
223
224--
225-- Table structure for table `fuckingspies`
226--
227
228CREATE TABLE IF NOT EXISTS `fuckingspies` (
229  `id` int(6) NOT NULL AUTO_INCREMENT,
230  `victim` varchar(30) NOT NULL,
231  `spy` varchar(30) NOT NULL,
232  `victimForce` bigint(12) NOT NULL,
233  `spyForce` bigint(12) NOT NULL,
234  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
235  PRIMARY KEY (`id`)
236) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
237
238-- --------------------------------------------------------
239
240--
241-- Table structure for table `magics`
242--
243
244CREATE TABLE IF NOT EXISTS `magics` (
245  `id` int(6) NOT NULL AUTO_INCREMENT,
246  `userid` varchar(6) NOT NULL,
247  `magic` varchar(30) NOT NULL,
248  `ending` datetime NOT NULL,
249  `value` int(6) NOT NULL DEFAULT '0',
250  PRIMARY KEY (`id`)
251) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
252
253-- --------------------------------------------------------
254
255--
256-- Table structure for table `messages`
257--
258
259CREATE TABLE IF NOT EXISTS `messages` (
260  `id` int(6) NOT NULL AUTO_INCREMENT,
261  `sender` varchar(30) CHARACTER SET utf8 NOT NULL,
262  `reciever` varchar(30) CHARACTER SET utf8 NOT NULL,
263  `title` varchar(50) CHARACTER SET utf8 NOT NULL,
264  `content` text CHARACTER SET utf8 NOT NULL,
265  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
266  `deleteSender` varchar(10) NOT NULL DEFAULT '0',
267  `deleteReciever` varchar(10) NOT NULL DEFAULT '0',
268  `readOrNot` varchar(10) NOT NULL DEFAULT '0',
269  PRIMARY KEY (`id`)
270) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
271
272-- --------------------------------------------------------
273
274--
275-- Table structure for table `missions`
276--
277
278CREATE TABLE IF NOT EXISTS `missions` (
279  `userID` int(6) NOT NULL,
280  `id` int(6) NOT NULL AUTO_INCREMENT,
281  `missionID` int(6) NOT NULL,
282  PRIMARY KEY (`id`)
283) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
284
285-- --------------------------------------------------------
286
287--
288-- Table structure for table `missionsid`
289--
290
291CREATE TABLE IF NOT EXISTS `missionsid` (
292  `id` int(6) NOT NULL,
293  `title` varchar(30) NOT NULL,
294  `des` text NOT NULL,
295  `colID` int(6) NOT NULL AUTO_INCREMENT,
296  PRIMARY KEY (`colID`)
297) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
298
299-- --------------------------------------------------------
300
301--
302-- Table structure for table `MonsterPrices`
303--
304
305CREATE TABLE IF NOT EXISTS `MonsterPrices` (
306  `MaxDiamonds` int(10) NOT NULL DEFAULT '0',
307  `MaxCitizens` int(10) NOT NULL DEFAULT '0',
308  `MaxResources` int(10) NOT NULL DEFAULT '0',
309  `id` int(6) NOT NULL AUTO_INCREMENT,
310  PRIMARY KEY (`id`)
311) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
312
313--
314-- Dumping data for table `MonsterPrices`
315--
316
317INSERT INTO `MonsterPrices` (`MaxDiamonds`, `MaxCitizens`, `MaxResources`, `id`) VALUES
318(10, 99999, 9999999, 1);
319
320-- --------------------------------------------------------
321
322--
323-- Table structure for table `pass_recovery`
324--
325
326CREATE TABLE IF NOT EXISTS `pass_recovery` (
327  `id` int(6) NOT NULL AUTO_INCREMENT,
328  `userID` varchar(6) NOT NULL,
329  `passKey` varchar(30) NOT NULL,
330  `newPass` varchar(8) NOT NULL,
331  `done` varchar(10) NOT NULL DEFAULT 'no',
332  PRIMARY KEY (`id`)
333) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
334
335-- --------------------------------------------------------
336
337--
338-- Table structure for table `settings`
339--
340
341CREATE TABLE IF NOT EXISTS `settings` (
342  `id` int(6) NOT NULL AUTO_INCREMENT,
343  `setting` varchar(10) NOT NULL,
344  `value` varchar(10) NOT NULL,
345  PRIMARY KEY (`id`)
346) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
347
348--
349-- Dumping data for table `settings`
350--
351
352INSERT INTO `settings` (`id`, `setting`, `value`) VALUES
353(1, 'monster', 'on');
354
355-- --------------------------------------------------------
356
357--
358-- Table structure for table `updates`
359--
360
361CREATE TABLE IF NOT EXISTS `updates` (
362  `id` int(6) NOT NULL AUTO_INCREMENT,
363  `title` varchar(30) NOT NULL,
364  `content` text NOT NULL,
365  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
366  PRIMARY KEY (`id`)
367) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
368
369-- --------------------------------------------------------
370
371--
372-- Table structure for table `usersInfo`
373--
374
375CREATE TABLE IF NOT EXISTS `usersInfo` (
376  `id` int(6) NOT NULL AUTO_INCREMENT,
377  `name` varchar(30) NOT NULL,
378  `pass` varchar(30) NOT NULL,
379  `email` varchar(50) NOT NULL,
380  `profileViews` int(6) NOT NULL DEFAULT '0',
381  `reg_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
382  PRIMARY KEY (`id`)
383) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
384
385-- --------------------------------------------------------
386
387--
388-- Table structure for table `usersres`
389--
390
391CREATE TABLE IF NOT EXISTS `usersres` (
392  `userID` int(6) NOT NULL,
393  `wood` bigint(15) NOT NULL DEFAULT '500',
394  `crop` bigint(15) NOT NULL DEFAULT '500',
395  `iron` bigint(15) NOT NULL DEFAULT '500',
396  `gold` bigint(15) NOT NULL DEFAULT '3000',
397  `diamonds` int(7) NOT NULL DEFAULT '50',
398  `id` int(6) NOT NULL AUTO_INCREMENT,
399  PRIMARY KEY (`id`)
400) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
401
402-- --------------------------------------------------------
403
404--
405-- Table structure for table `weapons`
406--
407
408CREATE TABLE IF NOT EXISTS `weapons` (
409  `userID` int(6) NOT NULL,
410  `id` int(6) NOT NULL AUTO_INCREMENT,
411  `def1` int(6) NOT NULL DEFAULT '0',
412  `def2` int(6) NOT NULL DEFAULT '0',
413  `def3` int(6) NOT NULL DEFAULT '0',
414  `def4` int(6) NOT NULL DEFAULT '0',
415  `def5` int(6) NOT NULL DEFAULT '0',
416  `def6` int(6) NOT NULL DEFAULT '0',
417  `def7` int(6) NOT NULL DEFAULT '0',
418  `def8` int(6) NOT NULL DEFAULT '0',
419  `def9` int(6) NOT NULL DEFAULT '0',
420  `def10` int(6) NOT NULL DEFAULT '0',
421  `att1` int(6) NOT NULL DEFAULT '0',
422  `att2` int(6) NOT NULL DEFAULT '0',
423  `att3` int(6) NOT NULL DEFAULT '0',
424  `att4` int(6) NOT NULL DEFAULT '0',
425  `att5` int(6) NOT NULL DEFAULT '0',
426  `att6` int(6) NOT NULL DEFAULT '0',
427  `att7` int(6) NOT NULL DEFAULT '0',
428  `att8` int(6) NOT NULL DEFAULT '0',
429  `att9` int(6) NOT NULL DEFAULT '0',
430  `att10` int(6) NOT NULL DEFAULT '0',
431  `spy1` int(6) NOT NULL DEFAULT '0',
432  `spy2` int(6) NOT NULL DEFAULT '0',
433  `spy3` int(6) NOT NULL DEFAULT '0',
434  PRIMARY KEY (`id`),
435  KEY `userID` (`userID`)
436) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
437
438/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
439/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
440/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;