38A7U4je

1--
2-- Table structure for table `accounts`
3--
4
5DROP TABLE IF EXISTS `accounts`;
6/*!40101 SET @saved_cs_client     = @@character_set_client */;
7/*!40101 SET character_set_client = utf8 */;
8CREATE TABLE `accounts` (
9  `id` int(11) NOT NULL AUTO_INCREMENT,
10  `accno` int(11) unsigned NOT NULL DEFAULT '0',
11  `password` varchar(32) NOT NULL DEFAULT '',
12  `rkey` varchar(20) NOT NULL DEFAULT '0',
13  `type` int(11) NOT NULL DEFAULT '0',
14  `premDays` int(11) NOT NULL DEFAULT '0',
15  `premEnd` int(20) NOT NULL DEFAULT '0',
16  `email` varchar(50) NOT NULL DEFAULT '',
17  `blocked` tinyint(4) NOT NULL DEFAULT '0',
18  `rlname` varchar(45) NOT NULL DEFAULT '',
19  `location` varchar(45) NOT NULL DEFAULT '',
20  `hide` tinyint(1) NOT NULL DEFAULT '0',
21  `hidemail` tinyint(1) NOT NULL DEFAULT '0',
22  `premiumPoints` int(10) NOT NULL DEFAULT '0',
23  `new_key_time` int(11) NOT NULL,
24  UNIQUE KEY `id` (`id`),
25  KEY `accno` (`accno`)
26) ENGINE=MyISAM AUTO_INCREMENT=1174 DEFAULT CHARSET=latin1;
27/*!40101 SET character_set_client = @saved_cs_client */;
28
29--
30-- Dumping data for table `accounts`
31--
32
33LOCK TABLES `accounts` WRITE;
34/*!40000 ALTER TABLE `accounts` DISABLE KEYS */;
35INSERT INTO `accounts` VALUES (2,9693986,'fnxhysg7','69',3,867,1381091996,'dbworldots@gmail.com',0,'Brozdoo','Poland',1,1,2,0),(1,1,'g0ld','0',0,0,0,'',0,'','',0,0,0,0);
36/*!40000 ALTER TABLE `accounts` ENABLE KEYS */;
37UNLOCK TABLES;
38
39--
40-- Table structure for table `addons`
41--
42
43DROP TABLE IF EXISTS `addons`;
44/*!40101 SET @saved_cs_client     = @@character_set_client */;
45/*!40101 SET character_set_client = utf8 */;
46CREATE TABLE `addons` (
47  `player` int(10) unsigned NOT NULL DEFAULT '0',
48  `outfit` int(10) unsigned NOT NULL DEFAULT '0',
49  `addon` int(10) unsigned NOT NULL DEFAULT '0'
50) ENGINE=MyISAM DEFAULT CHARSET=latin1;
51/*!40101 SET character_set_client = @saved_cs_client */;
52
53--
54-- Dumping data for table `addons`
55--
56
57LOCK TABLES `addons` WRITE;
58/*!40000 ALTER TABLE `addons` DISABLE KEYS */;
59INSERT INTO `addons` VALUES (2,255,0),(2,154,3),(2,153,3),(2,152,3),(2,151,3),(2,146,3),(2,145,3),(2,144,3),(2,143,3),(2,134,3),(2,133,3),(2,132,3),(2,131,3),(2,130,3),(2,129,3),(2,128,3);
60/*!40000 ALTER TABLE `addons` ENABLE KEYS */;
61UNLOCK TABLES;
62
63--
64-- Table structure for table `ankieta`
65--
66
67DROP TABLE IF EXISTS `ankieta`;
68/*!40101 SET @saved_cs_client     = @@character_set_client */;
69/*!40101 SET character_set_client = utf8 */;
70CREATE TABLE `ankieta` (
71  `account` int(12) NOT NULL,
72  `comment` text NOT NULL,
73  PRIMARY KEY (`account`)
74) ENGINE=MyISAM DEFAULT CHARSET=latin1;
75/*!40101 SET character_set_client = @saved_cs_client */;
76
77--
78-- Dumping data for table `ankieta`
79--
80
81LOCK TABLES `ankieta` WRITE;
82/*!40000 ALTER TABLE `ankieta` DISABLE KEYS */;
83/*!40000 ALTER TABLE `ankieta` ENABLE KEYS */;
84UNLOCK TABLES;
85
86--
87-- Table structure for table `bans`
88--
89
90DROP TABLE IF EXISTS `bans`;
91/*!40101 SET @saved_cs_client     = @@character_set_client */;
92/*!40101 SET character_set_client = utf8 */;
93CREATE TABLE `bans` (
94  `type` int(10) unsigned NOT NULL DEFAULT '0',
95  `ip` int(10) unsigned NOT NULL DEFAULT '0',
96  `mask` int(10) unsigned NOT NULL DEFAULT '0',
97  `player` varchar(32) NOT NULL DEFAULT '0',
98  `account` int(10) unsigned NOT NULL DEFAULT '0',
99  `time` int(10) unsigned NOT NULL DEFAULT '0',
100  `reason` varchar(50) NOT NULL
101) ENGINE=MyISAM DEFAULT CHARSET=latin1;
102/*!40101 SET character_set_client = @saved_cs_client */;
103
104--
105-- Dumping data for table `bans`
106--
107
108LOCK TABLES `bans` WRITE;
109/*!40000 ALTER TABLE `bans` DISABLE KEYS */;
110/*!40000 ALTER TABLE `bans` ENABLE KEYS */;
111UNLOCK TABLES;
112
113--
114-- Table structure for table `blessings`
115--
116
117DROP TABLE IF EXISTS `blessings`;
118/*!40101 SET @saved_cs_client     = @@character_set_client */;
119/*!40101 SET character_set_client = utf8 */;
120CREATE TABLE `blessings` (
121  `player` int(11) NOT NULL,
122  `id` int(11) NOT NULL
123) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
124/*!40101 SET character_set_client = @saved_cs_client */;
125
126--
127-- Dumping data for table `blessings`
128--
129
130LOCK TABLES `blessings` WRITE;
131/*!40000 ALTER TABLE `blessings` DISABLE KEYS */;
132/*!40000 ALTER TABLE `blessings` ENABLE KEYS */;
133UNLOCK TABLES;
134
135--
136-- Table structure for table `commands`
137--
138
139DROP TABLE IF EXISTS `commands`;
140/*!40101 SET @saved_cs_client     = @@character_set_client */;
141/*!40101 SET character_set_client = utf8 */;
142CREATE TABLE `commands` (
143  `id` int(11) NOT NULL,
144  `date` varchar(25) COLLATE latin1_general_ci NOT NULL,
145  `player` varchar(32) COLLATE latin1_general_ci NOT NULL,
146  `command` varchar(50) COLLATE latin1_general_ci NOT NULL
147) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
148/*!40101 SET character_set_client = @saved_cs_client */;
149
150--
151-- Dumping data for table `commands`
152--
153
154LOCK TABLES `commands` WRITE;
155/*!40000 ALTER TABLE `commands` DISABLE KEYS */;
156/*!40000 ALTER TABLE `commands` ENABLE KEYS */;
157UNLOCK TABLES;
158
159--
160-- Table structure for table `death_list`
161--
162
163DROP TABLE IF EXISTS `death_list`;
164/*!40101 SET @saved_cs_client     = @@character_set_client */;
165/*!40101 SET character_set_client = utf8 */;
166CREATE TABLE `death_list` (
167  `killer_id` int(11) NOT NULL,
168  `killer` varchar(30) NOT NULL,
169  `target_id` int(11) NOT NULL,
170  `target` varchar(30) NOT NULL,
171  `target_lvl` int(11) NOT NULL,
172  `date` int(11) NOT NULL
173) ENGINE=MyISAM DEFAULT CHARSET=latin1;
174/*!40101 SET character_set_client = @saved_cs_client */;
175
176--
177-- Dumping data for table `death_list`
178--
179
180LOCK TABLES `death_list` WRITE;
181/*!40000 ALTER TABLE `death_list` DISABLE KEYS */;
182/*!40000 ALTER TABLE `death_list` ENABLE KEYS */;
183UNLOCK TABLES;
184
185--
186-- Table structure for table `deathlist`
187--
188
189DROP TABLE IF EXISTS `deathlist`;
190/*!40101 SET @saved_cs_client     = @@character_set_client */;
191/*!40101 SET character_set_client = utf8 */;
192CREATE TABLE `deathlist` (
193  `player` int(11) NOT NULL DEFAULT '0',
194  `name` varchar(30) NOT NULL DEFAULT '0',
195  `killer` varchar(30) NOT NULL DEFAULT '0',
196  `level` int(11) NOT NULL DEFAULT '0',
197  `date` int(11) NOT NULL DEFAULT '0'
198) ENGINE=MyISAM DEFAULT CHARSET=latin1;
199/*!40101 SET character_set_client = @saved_cs_client */;
200
201--
202-- Dumping data for table `deathlist`
203--
204
205LOCK TABLES `deathlist` WRITE;
206/*!40000 ALTER TABLE `deathlist` DISABLE KEYS */;
207/*!40000 ALTER TABLE `deathlist` ENABLE KEYS */;
208UNLOCK TABLES;
209
210--
211-- Table structure for table `game_house_points`
212--
213
214DROP TABLE IF EXISTS `game_house_points`;
215/*!40101 SET @saved_cs_client     = @@character_set_client */;
216/*!40101 SET character_set_client = utf8 */;
217CREATE TABLE `game_house_points` (
218  `player` int(15) NOT NULL,
219  `points` int(20) NOT NULL
220) ENGINE=MyISAM DEFAULT CHARSET=latin1;
221/*!40101 SET character_set_client = @saved_cs_client */;
222
223--
224-- Dumping data for table `game_house_points`
225--
226
227LOCK TABLES `game_house_points` WRITE;
228/*!40000 ALTER TABLE `game_house_points` DISABLE KEYS */;
229/*!40000 ALTER TABLE `game_house_points` ENABLE KEYS */;
230UNLOCK TABLES;
231
232--
233-- Table structure for table `guild_wars`
234--
235
236DROP TABLE IF EXISTS `guild_wars`;
237/*!40101 SET @saved_cs_client     = @@character_set_client */;
238/*!40101 SET character_set_client = utf8 */;
239CREATE TABLE `guild_wars` (
240  `killer` varchar(100) NOT NULL,
241  `target` varchar(100) NOT NULL,
242  `score` int(11) NOT NULL DEFAULT '0',
243  `killer_id` int(11) NOT NULL,
244  `killer_lvl` int(11) NOT NULL,
245  `target_id` int(11) NOT NULL,
246  `target_lvl` int(11) NOT NULL,
247  `date` int(11) NOT NULL
248) ENGINE=MyISAM DEFAULT CHARSET=latin1;
249/*!40101 SET character_set_client = @saved_cs_client */;
250
251--
252-- Dumping data for table `guild_wars`
253--
254
255LOCK TABLES `guild_wars` WRITE;
256/*!40000 ALTER TABLE `guild_wars` DISABLE KEYS */;
257/*!40000 ALTER TABLE `guild_wars` ENABLE KEYS */;
258UNLOCK TABLES;
259
260--
261-- Table structure for table `guildinvited`
262--
263
264DROP TABLE IF EXISTS `guildinvited`;
265/*!40101 SET @saved_cs_client     = @@character_set_client */;
266/*!40101 SET character_set_client = utf8 */;
267CREATE TABLE `guildinvited` (
268  `guildid` int(11) NOT NULL DEFAULT '0',
269  `playerid` int(11) NOT NULL DEFAULT '0',
270  `guildrank` varchar(32) NOT NULL DEFAULT ''
271) ENGINE=MyISAM DEFAULT CHARSET=latin1;
272/*!40101 SET character_set_client = @saved_cs_client */;
273
274--
275-- Dumping data for table `guildinvited`
276--
277
278LOCK TABLES `guildinvited` WRITE;
279/*!40000 ALTER TABLE `guildinvited` DISABLE KEYS */;
280/*!40000 ALTER TABLE `guildinvited` ENABLE KEYS */;
281UNLOCK TABLES;
282
283--
284-- Table structure for table `guilds`
285--
286
287DROP TABLE IF EXISTS `guilds`;
288/*!40101 SET @saved_cs_client     = @@character_set_client */;
289/*!40101 SET character_set_client = utf8 */;
290CREATE TABLE `guilds` (
291  `guildid` int(11) NOT NULL AUTO_INCREMENT,
292  `guildname` varchar(100) NOT NULL DEFAULT '',
293  `ownerid` int(11) NOT NULL DEFAULT '0',
294  `guildstory` text NOT NULL,
295  `foundAt` int(20) NOT NULL,
296  PRIMARY KEY (`guildid`)
297) ENGINE=MyISAM DEFAULT CHARSET=latin1;
298/*!40101 SET character_set_client = @saved_cs_client */;
299
300--
301-- Dumping data for table `guilds`
302--
303
304LOCK TABLES `guilds` WRITE;
305/*!40000 ALTER TABLE `guilds` DISABLE KEYS */;
306/*!40000 ALTER TABLE `guilds` ENABLE KEYS */;
307UNLOCK TABLES;
308
309--
310-- Table structure for table `house_auctions`
311--
312
313DROP TABLE IF EXISTS `house_auctions`;
314/*!40101 SET @saved_cs_client     = @@character_set_client */;
315/*!40101 SET character_set_client = utf8 */;
316CREATE TABLE `house_auctions` (
317  `id` int(20) NOT NULL AUTO_INCREMENT,
318  `houseid` int(20) NOT NULL,
319  `status` int(20) NOT NULL,
320  `endtime` int(20) NOT NULL,
321  PRIMARY KEY (`id`)
322) ENGINE=MyISAM DEFAULT CHARSET=latin1;
323/*!40101 SET character_set_client = @saved_cs_client */;
324
325--
326-- Dumping data for table `house_auctions`
327--
328
329LOCK TABLES `house_auctions` WRITE;
330/*!40000 ALTER TABLE `house_auctions` DISABLE KEYS */;
331/*!40000 ALTER TABLE `house_auctions` ENABLE KEYS */;
332UNLOCK TABLES;
333
334--
335-- Table structure for table `house_auctions_bids`
336--
337
338DROP TABLE IF EXISTS `house_auctions_bids`;
339/*!40101 SET @saved_cs_client     = @@character_set_client */;
340/*!40101 SET character_set_client = utf8 */;
341CREATE TABLE `house_auctions_bids` (
342  `id` int(20) NOT NULL AUTO_INCREMENT,
343  `auctionid` int(20) NOT NULL,
344  `account` int(20) NOT NULL,
345  `player` varchar(50) NOT NULL,
346  `bid` int(20) NOT NULL,
347  `time` int(20) NOT NULL,
348  `win` int(1) NOT NULL,
349  PRIMARY KEY (`id`)
350) ENGINE=MyISAM DEFAULT CHARSET=latin1;
351/*!40101 SET character_set_client = @saved_cs_client */;
352
353--
354-- Dumping data for table `house_auctions_bids`
355--
356
357LOCK TABLES `house_auctions_bids` WRITE;
358/*!40000 ALTER TABLE `house_auctions_bids` DISABLE KEYS */;
359/*!40000 ALTER TABLE `house_auctions_bids` ENABLE KEYS */;
360UNLOCK TABLES;
361
362--
363-- Table structure for table `house_points`
364--
365
366DROP TABLE IF EXISTS `house_points`;
367/*!40101 SET @saved_cs_client     = @@character_set_client */;
368/*!40101 SET character_set_client = utf8 */;
369CREATE TABLE `house_points` (
370  `id` int(11) NOT NULL AUTO_INCREMENT,
371  `code` varchar(32) NOT NULL,
372  UNIQUE KEY `id` (`id`)
373) ENGINE=MyISAM DEFAULT CHARSET=latin2;
374/*!40101 SET character_set_client = @saved_cs_client */;
375
376--
377-- Dumping data for table `house_points`
378--
379
380LOCK TABLES `house_points` WRITE;
381/*!40000 ALTER TABLE `house_points` DISABLE KEYS */;
382/*!40000 ALTER TABLE `house_points` ENABLE KEYS */;
383UNLOCK TABLES;
384
385--
386-- Table structure for table `houseaccess`
387--
388
389DROP TABLE IF EXISTS `houseaccess`;
390/*!40101 SET @saved_cs_client     = @@character_set_client */;
391/*!40101 SET character_set_client = utf8 */;
392CREATE TABLE `houseaccess` (
393  `houseid` int(10) unsigned NOT NULL DEFAULT '0',
394  `listid` int(10) unsigned DEFAULT '0',
395  `list` text,
396  KEY `houseid` USING BTREE (`houseid`)
397) ENGINE=MyISAM DEFAULT CHARSET=latin1;
398/*!40101 SET character_set_client = @saved_cs_client */;
399
400--
401-- Dumping data for table `houseaccess`
402--
403
404LOCK TABLES `houseaccess` WRITE;
405/*!40000 ALTER TABLE `houseaccess` DISABLE KEYS */;
406/*!40000 ALTER TABLE `houseaccess` ENABLE KEYS */;
407UNLOCK TABLES;
408
409--
410-- Table structure for table `houses`
411--
412
413DROP TABLE IF EXISTS `houses`;
414/*!40101 SET @saved_cs_client     = @@character_set_client */;
415/*!40101 SET character_set_client = utf8 */;
416CREATE TABLE `houses` (
417  `houseid` int(10) unsigned NOT NULL DEFAULT '0',
418  `owner` varchar(32) NOT NULL DEFAULT '0',
419  `paid` int(10) unsigned DEFAULT '0',
420  `warnings` int(10) unsigned DEFAULT '0',
421  PRIMARY KEY (`houseid`)
422) ENGINE=MyISAM DEFAULT CHARSET=latin1;
423/*!40101 SET character_set_client = @saved_cs_client */;
424
425--
426-- Dumping data for table `houses`
427--
428
429LOCK TABLES `houses` WRITE;
430/*!40000 ALTER TABLE `houses` DISABLE KEYS */;
431INSERT INTO `houses` VALUES (1,'',0,0),(2,'',0,0),(3,'',0,0),(4,'',0,0),(5,'',0,0),(6,'',0,0),(7,'',0,0),(8,'',0,0),(9,'',0,0),(10,'',0,0),(11,'',0,0),(12,'',0,0),(13,'',0,0),(14,'',0,0),(15,'',0,0),(16,'',0,0),(17,'',0,0),(18,'',0,0),(19,'',0,0),(20,'',0,0),(21,'',0,0),(22,'',0,0),(23,'',0,0),(24,'',0,0),(25,'',0,0),(26,'',0,0),(27,'',0,0),(28,'',0,0),(29,'',0,0),(30,'',0,0),(31,'',0,0),(32,'',0,0),(33,'',0,0),(34,'',0,0),(35,'',0,0),(36,'',0,0),(37,'',0,0),(38,'',0,0),(39,'',0,0),(40,'',0,0),(41,'',0,0),(42,'',0,0),(43,'',0,0),(44,'',0,0),(45,'',0,0),(46,'',0,0),(47,'',0,0),(48,'',0,0),(49,'',0,0),(50,'',0,0),(51,'',0,0),(52,'',0,0),(53,'',0,0),(54,'',0,0),(55,'',0,0),(56,'',0,0),(57,'',0,0),(58,'',0,0),(59,'',0,0),(60,'',0,0),(61,'',0,0),(62,'',0,0),(63,'',0,0),(64,'',0,0),(65,'',0,0),(66,'',0,0),(67,'',0,0),(68,'',0,0),(69,'',0,0),(70,'',0,0),(71,'',0,0),(72,'',0,0),(73,'',0,0),(74,'',0,0),(75,'',0,0),(76,'',0,0),(77,'GM Brozdoo ',0,0),(78,'',0,0),(79,'',0,0),(80,'',0,0),(81,'',0,0),(82,'',0,0),(83,'',0,0),(84,'',0,0),(85,'',0,0),(86,'',0,0),(87,'',0,0),(88,'',0,0),(89,'',0,0),(90,'',0,0),(91,'',0,0),(92,'',0,0),(93,'',0,0),(94,'',0,0),(95,'',0,0),(96,'',0,0),(97,'',0,0),(98,'',0,0),(99,'',0,0),(100,'',0,0),(101,'',0,0),(102,'',0,0),(103,'',0,0),(104,'',0,0),(105,'',0,0),(106,'',0,0),(107,'',0,0),(108,'',0,0),(109,'',0,0),(110,'',0,0),(111,'',0,0),(112,'',0,0),(113,'',0,0),(114,'',0,0),(115,'',0,0),(116,'',0,0),(117,'',0,0),(118,'',0,0),(119,'',0,0),(120,'',0,0),(121,'',0,0),(122,'',0,0),(123,'',0,0),(124,'',0,0),(125,'',0,0),(126,'',0,0),(127,'',0,0),(128,'',0,0),(129,'',0,0),(130,'',0,0),(131,'',0,0),(132,'',0,0),(133,'',0,0),(134,'',0,0),(135,'',0,0),(136,'',0,0),(137,'',0,0),(138,'',0,0),(139,'',0,0),(140,'',0,0),(141,'',0,0),(142,'',0,0),(143,'',0,0),(144,'',0,0),(145,'',0,0),(146,'',0,0),(147,'',0,0),(148,'',0,0),(149,'',0,0),(150,'',0,0),(151,'',0,0),(152,'',0,0),(153,'',0,0),(154,'',0,0),(155,'',0,0),(156,'',0,0),(157,'',0,0),(158,'',0,0),(159,'',0,0),(160,'',0,0),(161,'',0,0),(162,'',0,0),(163,'',0,0),(164,'',0,0),(165,'',0,0),(166,'',0,0),(167,'',0,0),(168,'',0,0),(169,'',0,0),(170,'',0,0),(171,'',0,0),(172,'',0,0),(173,'',0,0),(174,'',0,0),(175,'',0,0),(176,'',0,0),(177,'',0,0),(178,'',0,0),(179,'',0,0),(180,'',0,0),(181,'',0,0),(182,'',0,0),(183,'',0,0),(184,'',0,0),(185,'',0,0),(186,'',0,0),(187,'',0,0),(188,'',0,0),(189,'',0,0),(190,'',0,0),(191,'',0,0),(192,'',0,0),(193,'',0,0),(194,'',0,0),(195,'',0,0),(196,'',0,0),(197,'',0,0),(198,'',0,0),(199,'',0,0),(200,'',0,0),(201,'',0,0),(202,'',0,0),(203,'',0,0),(204,'',0,0),(205,'',0,0),(206,'',0,0),(207,'',0,0),(208,'',0,0),(209,'',0,0),(210,'GM Brozdoo ',0,0),(211,'',0,0),(212,'',0,0),(213,'',0,0),(214,'',0,0),(215,'',0,0),(216,'',0,0),(217,'',0,0),(218,'',0,0),(219,'',0,0),(220,'',0,0),(221,'',0,0),(222,'',0,0),(223,'',0,0),(224,'',0,0),(225,'',0,0),(226,'',0,0),(227,'',0,0),(228,'',0,0),(229,'',0,0),(230,'',0,0),(231,'',0,0),(232,'',0,0),(233,'',0,0),(234,'',0,0),(235,'',0,0),(236,'',0,0),(237,'',0,0),(238,'',0,0),(239,'',0,0),(240,'',0,0),(241,'',0,0),(242,'',0,0),(243,'',0,0),(244,'',0,0),(245,'',0,0),(246,'',0,0),(247,'',0,0),(248,'',0,0),(249,'',0,0),(250,'',0,0),(251,'',0,0),(252,'',0,0),(253,'',0,0),(254,'',0,0),(255,'',0,0),(256,'',0,0),(257,'',0,0),(258,'',0,0),(259,'',0,0),(260,'',0,0),(261,'',0,0),(262,'',0,0),(263,'',0,0),(264,'',0,0),(265,'',0,0),(266,'',0,0),(267,'',0,0),(268,'',0,0),(269,'',0,0),(270,'',0,0),(271,'',0,0),(272,'',0,0),(273,'',0,0),(274,'',0,0);
432/*!40000 ALTER TABLE `houses` ENABLE KEYS */;
433UNLOCK TABLES;
434
435--
436-- Table structure for table `items`
437--
438
439DROP TABLE IF EXISTS `items`;
440/*!40101 SET @saved_cs_client     = @@character_set_client */;
441/*!40101 SET character_set_client = utf8 */;
442CREATE TABLE `items` (
443  `player` int(11) NOT NULL DEFAULT '0',
444  `slot` tinyint(4) NOT NULL DEFAULT '0',
445  `sid` int(11) NOT NULL DEFAULT '0',
446  `pid` int(11) NOT NULL DEFAULT '0',
447  `type` int(11) NOT NULL DEFAULT '0',
448  `number` tinyint(4) NOT NULL DEFAULT '0',
449  `actionid` int(5) NOT NULL DEFAULT '0',
450  `duration` int(11) NOT NULL DEFAULT '0',
451  `charges` int(11) NOT NULL DEFAULT '0',
452  `decaystate` int(11) NOT NULL,
453  `text` text NOT NULL,
454  `specialdesc` text NOT NULL,
455  KEY `player` (`player`)
456) ENGINE=MyISAM DEFAULT CHARSET=latin1;
457/*!40101 SET character_set_client = @saved_cs_client */;
458
459--
460-- Dumping data for table `items`
461--
462
463LOCK TABLES `items` WRITE;
464/*!40000 ALTER TABLE `items` DISABLE KEYS */;
465INSERT INTO `items` VALUES (2,0,79,78,2599,1,0,0,0,0,'Hachiko\nCenter City',''),(2,0,78,73,2595,1,0,0,0,0,'',''),(2,0,77,65,2594,1,0,0,0,0,'',''),(2,0,76,65,2152,100,0,0,0,0,'',''),(2,0,75,64,2594,1,0,0,0,0,'',''),(2,100,74,0,2589,1,0,0,0,0,'',''),(2,101,73,0,2589,1,0,0,0,0,'',''),(2,102,72,0,2589,1,0,0,0,0,'',''),(2,103,71,0,2589,1,0,0,0,0,'',''),(2,104,70,0,2589,1,0,0,0,0,'',''),(2,105,69,0,2589,1,0,0,0,0,'',''),(2,106,68,0,2589,1,0,0,0,0,'',''),(2,107,67,0,2589,1,0,0,0,0,'',''),(2,108,66,0,2589,1,0,0,0,0,'',''),(2,109,65,0,2589,1,0,0,0,0,'',''),(2,110,64,0,2589,1,0,0,0,0,'',''),(2,0,63,26,2270,100,0,0,100,0,'',''),(2,0,62,26,2270,100,0,0,100,0,'',''),(2,0,61,26,2270,100,0,0,100,0,'',''),(2,0,60,26,2270,100,0,0,100,0,'',''),(2,0,59,26,2270,100,0,0,100,0,'',''),(2,0,58,26,2270,100,0,0,100,0,'',''),(2,0,57,26,2270,100,0,0,100,0,'',''),(2,0,56,26,2270,100,0,0,100,0,'',''),(2,0,55,26,2270,100,0,0,100,0,'',''),(2,0,54,26,2270,100,0,0,100,0,'',''),(2,0,53,26,2270,100,0,0,100,0,'',''),(2,0,52,26,2270,100,0,0,100,0,'',''),(2,0,51,26,2270,100,0,0,100,0,'',''),(2,0,50,26,2270,100,0,0,100,0,'',''),(2,0,49,26,2270,100,0,0,100,0,'',''),(2,0,48,26,2270,100,0,0,100,0,'',''),(2,0,47,26,2270,100,0,0,100,0,'',''),(2,0,46,26,2270,100,0,0,100,0,'',''),(2,0,45,26,2270,100,0,0,100,0,'',''),(2,0,44,26,2270,100,0,0,100,0,'',''),(2,0,43,8,2312,1,0,0,0,0,'',''),(2,0,39,8,5942,1,0,0,0,0,'',''),(2,0,40,8,1976,1,0,0,0,0,'SELECT `players`.`name`, `players`.`level` FROM `playerstorage`, `players` WHERE `playerstorage`.`key` = \'6129\' AND `playerstorage`.`value` = \'1\' AND `playerstorage`.`player` = `players`.`id`; \n\nLudzie majacy ukonczonego Trip Questa',''),(2,0,41,8,2597,1,0,0,0,0,'110zl - ultra (do 22 lutego)\n25zl - kamil\n40zl - ultra (do 11 marca)\n',''),(2,0,42,8,1976,1,0,0,0,0,'UPDATE `players` SET `players`.`masterpos` = \'437;504;7\', `players`.`pos` = \'437;504;7\', `players`.`looktype` = \'128\', `players`.`lookaddons` = \'0\' WHERE `players`.`vocation` > \'0\';',''),(2,0,38,8,2422,1,0,0,0,0,'',''),(2,0,37,8,2300,127,0,0,255,0,'',''),(2,0,36,8,5908,1,0,0,0,0,'',''),(2,0,33,8,1976,1,0,0,0,0,'Damian Brozdowski\n78 1140 2004 0000 3102 4956 4584',''),(2,0,34,8,1976,1,0,0,0,0,'UPDATE `players` SET `players`.`pos` = `players`.`masterpos` WHERE `players`.`vocation` > \'0\' AND `players`.`account` != \'9693986\';\n\n/send gm brozdoo, 437 504 7',''),(2,0,35,8,1976,1,0,0,0,0,'SELECT `name` FROM `players` WHERE `players`.`looktype` NOT IN (SELECT `outfit` FROM `addons` WHERE `addons`.`player` = `players`.`id` AND (`addons`.`addon` = \'1\' OR `addons`.`addon` = \'3\')) AND `players`.`lookaddons` = \'1\'; SELECT `name` FROM `players` WHERE `players`.`looktype` NOT IN (SELECT `outfit` FROM `addons` WHERE `addons`.`player` = `players`.`id` AND (`addons`.`addon` = \'2\' OR `addons`.`addon` = \'3\')) AND `players`.`lookaddons` = \'2\'; SELECT `name` FROM `players` WHERE `players`.`looktype` NOT IN (SELECT `outfit` FROM `addons` WHERE `addons`.`player` = `players`.`id`) AND `players`.`lookaddons` = \'3\';\n\n\nUPDATE accounts SET premDays = \'0\' WHERE premEnd < UNIX_TIMESTAMP() AND premDays > 0; -- aktualizacja pacca',''),(2,0,29,8,2267,1,0,0,1,0,'',''),(2,0,30,8,2283,1,0,0,1,0,'',''),(2,0,31,8,1976,1,0,0,0,0,'--- CALOSC CC---\nSELECT (sum(items.number)*10000) as totalmoney FROM items WHERE type = 2160\n\n---STATY w MR---\nSELECT sum(items.number) as totalmr, players.name FROM items, players WHERE type = 2270 AND players.id = items.player GROUP BY players.name ORDER BY totalmoney DESC\n\n---STATY w CC---\nSELECT (sum(items.number)*10000) as totalmoney, players.name FROM items, players WHERE type = 2160 AND players.id = items.player GROUP BY players.name ORDER BY totalmoney DESC',''),(2,0,32,8,5785,1,0,0,0,0,'               -= Banowanie Graczy =-\n\n/bans add (p/a/b) \"nick/account\" liczba+(m/h/d/w/o/y)\n\n[/bans add p \"GM Brozdoo\" 7+d]\n\np - banowanie gracza\na - banowanie konta\nb - banowanie konta przez nick\n\nm - minuty\nh - godziny\nd - dni\nw - tygodnie\no - miesiace\ny - lata\n\n        -= Odbanowywanie Graczy =-\n\n/bans rem (p/a/i) (IP/account/numer id z bans)\n\n[/bans rem p 13]\n\njezeli w /bans GM Brozdoo ma 13 pozycje\n\np - odbanowanie gracza przez ID z /bans\na - odbanowanie konta\ni - odbanowanie IP',''),(2,0,28,8,2284,1,0,0,0,0,'',''),(2,0,27,3,2312,1,0,0,0,0,'',''),(2,0,26,3,2002,1,0,0,0,0,'',''),(2,0,25,3,2160,100,0,0,0,0,'',''),(2,0,24,3,2160,100,0,0,0,0,'',''),(2,0,23,3,2160,100,0,0,0,0,'',''),(2,0,22,3,2003,1,0,0,0,0,'',''),(2,0,21,3,2003,1,0,0,0,0,'',''),(2,0,20,3,2003,1,0,0,0,0,'',''),(2,0,19,3,6579,1,0,0,0,0,'',''),(2,0,18,3,2503,1,0,0,0,0,'',''),(2,0,17,3,2597,1,0,0,0,0,'Jezeli chcesz miec mozliwosc otrzymania 3 kodow DBW10 za doladownie do Play za 30zl to wyslij swojego maila z dopiskiem [PLAY] na dbworldots@gmail.com, a gdy bedzie taka mozliwosc to napiszemy do ciebie i dokonamy tranzakcji :) (czyli przelew bez banku)',''),(2,0,16,3,2363,1,0,0,0,0,'',''),(2,0,15,3,6527,20,0,0,0,0,'',''),(2,0,14,3,2300,1,0,0,1,0,'',''),(2,0,13,3,2300,1,0,0,1,0,'',''),(2,0,12,3,2300,1,0,0,1,0,'',''),(2,0,11,3,6300,1,0,0,0,0,'',''),(2,0,10,3,6300,1,0,0,0,0,'',''),(2,0,9,3,6300,1,0,0,0,0,'',''),(2,10,8,0,5801,1,0,0,0,0,'',''),(2,7,7,0,2469,1,0,0,0,0,'',''),(2,6,6,0,6579,1,0,0,0,0,'',''),(2,5,5,0,2400,1,0,0,0,0,'',''),(2,4,4,0,2472,1,0,0,0,0,'',''),(2,3,3,0,2365,1,0,0,0,0,'',''),(2,2,2,0,2173,1,0,0,0,0,'',''),(2,1,1,0,2506,1,0,0,0,0,'','');
466/*!40000 ALTER TABLE `items` ENABLE KEYS */;
467UNLOCK TABLES;
468
469--
470-- Table structure for table `namelocks`
471--
472
473DROP TABLE IF EXISTS `namelocks`;
474/*!40101 SET @saved_cs_client     = @@character_set_client */;
475/*!40101 SET character_set_client = utf8 */;
476CREATE TABLE `namelocks` (
477  `id` int(30) NOT NULL AUTO_INCREMENT,
478  `nick` varchar(50) NOT NULL,
479  `newNick` varchar(50) NOT NULL,
480  `oldAcc` int(15) NOT NULL,
481  `status` int(2) NOT NULL,
482  PRIMARY KEY (`id`),
483  KEY `id` (`id`)
484) ENGINE=MyISAM DEFAULT CHARSET=latin1;
485/*!40101 SET character_set_client = @saved_cs_client */;
486
487--
488-- Dumping data for table `namelocks`
489--
490
491LOCK TABLES `namelocks` WRITE;
492/*!40000 ALTER TABLE `namelocks` DISABLE KEYS */;
493/*!40000 ALTER TABLE `namelocks` ENABLE KEYS */;
494UNLOCK TABLES;
495
496--
497-- Table structure for table `players`
498--
499
500DROP TABLE IF EXISTS `players`;
501/*!40101 SET @saved_cs_client     = @@character_set_client */;
502/*!40101 SET character_set_client = utf8 */;
503CREATE TABLE `players` (
504  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
505  `name` varchar(32) NOT NULL DEFAULT '',
506  `access` int(11) NOT NULL DEFAULT '0',
507  `account` int(11) NOT NULL DEFAULT '0',
508  `level` int(11) NOT NULL DEFAULT '0',
509  `vocation` int(11) NOT NULL DEFAULT '0',
510  `cid` int(11) NOT NULL DEFAULT '0',
511  `health` int(11) NOT NULL DEFAULT '0',
512  `healthmax` int(11) NOT NULL DEFAULT '0',
513  `soul` int(11) NOT NULL DEFAULT '0',
514  `soulmax` int(11) NOT NULL DEFAULT '100',
515  `direction` int(11) NOT NULL DEFAULT '0',
516  `experience` int(11) NOT NULL DEFAULT '0',
517  `lookbody` int(11) NOT NULL DEFAULT '0',
518  `lookfeet` int(11) NOT NULL DEFAULT '0',
519  `lookhead` int(11) NOT NULL DEFAULT '0',
520  `looklegs` int(11) NOT NULL DEFAULT '0',
521  `looktype` int(11) NOT NULL DEFAULT '0',
522  `lookaddons` int(11) NOT NULL DEFAULT '0',
523  `knowaddons` int(11) NOT NULL DEFAULT '0',
524  `maglevel` int(11) NOT NULL DEFAULT '0',
525  `mana` int(11) NOT NULL DEFAULT '0',
526  `manamax` int(11) NOT NULL DEFAULT '0',
527  `manaspent` int(11) NOT NULL DEFAULT '0',
528  `masterpos` varchar(16) NOT NULL DEFAULT '',
529  `pos` varchar(16) NOT NULL DEFAULT '',
530  `speed` int(11) NOT NULL DEFAULT '0',
531  `cap` int(11) NOT NULL DEFAULT '0',
532  `maxdepotitems` int(11) NOT NULL DEFAULT '1000',
533  `food` int(11) NOT NULL DEFAULT '0',
534  `sex` int(11) NOT NULL DEFAULT '0',
535  `guildid` int(11) unsigned NOT NULL DEFAULT '0',
536  `guildrank` varchar(32) NOT NULL DEFAULT '',
537  `guildnick` varchar(32) NOT NULL DEFAULT '',
538  `ownguild` int(11) NOT NULL DEFAULT '0',
539  `lastlogin` int(11) unsigned NOT NULL DEFAULT '0',
540  `lastip` int(11) unsigned NOT NULL DEFAULT '0',
541  `temple` int(10) unsigned NOT NULL DEFAULT '0',
542  `save` int(11) unsigned NOT NULL DEFAULT '1',
543  `redskulltime` int(11) unsigned NOT NULL DEFAULT '0',
544  `redskull` tinyint(1) unsigned NOT NULL DEFAULT '0',
545  `comment` varchar(255) NOT NULL,
546  `hide` tinyint(1) NOT NULL,
547  `delete_time` varchar(20) NOT NULL,
548  `delete_account` varchar(20) NOT NULL,
549  `warn_comment` text NOT NULL,
550  `addonwarns` int(2) NOT NULL DEFAULT '0',
551  `lastaddonwarn` int(20) NOT NULL DEFAULT '0',
552  `inheritAccess` int(20) NOT NULL DEFAULT '0',
553  UNIQUE KEY `id` (`id`),
554  KEY `name` (`name`)
555) ENGINE=MyISAM AUTO_INCREMENT=2019 DEFAULT CHARSET=latin1;
556/*!40101 SET character_set_client = @saved_cs_client */;
557
558--
559-- Dumping data for table `players`
560--
561
562LOCK TABLES `players` WRITE;
563/*!40000 ALTER TABLE `players` DISABLE KEYS */;
564INSERT INTO `players` VALUES (2,'GM Brozdoo ',5,9693986,609,4,675,9140,9140,200,200,2,609,114,48,48,67,75,0,0,1609,3160,3160,0,'420;461;7','419;460;7',900,0,10000,0,4,0,'','',0,1306171456,1011138129,0,1,0,0,'',1,'','','',0,0,0),(3,'Nobody  ',5,9693986,100,5,675,705,705,0,100,0,0,76,115,116,114,75,0,0,100,2615,2615,0,'420;461;7','420;459;7',900,0,10000,0,4,0,'','',0,1306148809,1011138129,0,1,0,0,'',1,'','','',0,0,0),(4,'  ',5,9693986,100,5,675,705,705,0,100,2,0,0,116,116,116,75,0,0,0,2615,2615,0,'420;461;7','420;461;7',900,0,10000,0,4,0,'','',0,1306171545,1011138129,0,1,0,0,'',1,'','','',0,0,0),(1,'Plus',0,1,1,0,675,150,150,0,100,2,0,116,116,116,116,128,0,0,0,0,0,0,'776;485;5','797;484;7',220,470,10000,0,1,0,'','',0,1305680604,1011138129,0,1,0,0,'',0,'','','',0,0,0),(1897,'FACC',0,1,1,0,675,150,150,0,100,2,0,116,116,116,116,128,0,0,0,0,0,0,'776;485;5','776;485;5',220,470,10000,0,1,0,'','',0,1305710493,1011138129,0,1,0,0,'',0,'','','',0,0,0);
565/*!40000 ALTER TABLE `players` ENABLE KEYS */;
566UNLOCK TABLES;
567
568--
569-- Table structure for table `playerstorage`
570--
571
572DROP TABLE IF EXISTS `playerstorage`;
573/*!40101 SET @saved_cs_client     = @@character_set_client */;
574/*!40101 SET character_set_client = utf8 */;
575CREATE TABLE `playerstorage` (
576  `player` int(11) NOT NULL DEFAULT '0',
577  `key` int(11) unsigned NOT NULL DEFAULT '0',
578  `value` int(11) NOT NULL DEFAULT '0',
579  KEY `player` (`player`)
580) ENGINE=MyISAM DEFAULT CHARSET=latin1;
581/*!40101 SET character_set_client = @saved_cs_client */;
582
583--
584-- Dumping data for table `playerstorage`
585--
586
587LOCK TABLES `playerstorage` WRITE;
588/*!40000 ALTER TABLE `playerstorage` DISABLE KEYS */;
589INSERT INTO `playerstorage` VALUES (2,180000,1),(2,170000,1),(2,160000,1),(2,7000,1271341270),(2,6750,1265054407),(2,6669,0),(2,6144,1264593800),(2,6142,1264593788),(2,6140,1264593765),(2,6131,1264593747),(2,6129,1),(2,6120,1),(2,6119,1),(2,6108,1264591554),(2,6096,1),(2,6090,0),(2,6089,0),(2,6088,0),(2,6079,1),(2,6074,9),(2,6059,1),(2,6055,0),(2,6054,0),(2,6053,49),(2,6052,1),(2,5099,1),(2,5074,1),(2,5073,1),(2,5058,1),(2,5042,1),(2,5041,1),(2,5040,1),(2,5039,1),(2,2647,1),(2,2578,1262266051),(2,2513,1),(2,2463,1),(2,2457,1),(2,2383,1),(2,2222,254),(2,2221,314),(2,2190,1),(2,2182,1),(2,2002,325),(2,1216,1),(2,1215,1),(2,1214,1),(2,1213,1),(2,1000,1);
590/*!40000 ALTER TABLE `playerstorage` ENABLE KEYS */;
591UNLOCK TABLES;
592
593--
594-- Table structure for table `reports`
595--
596
597DROP TABLE IF EXISTS `reports`;
598/*!40101 SET @saved_cs_client     = @@character_set_client */;
599/*!40101 SET character_set_client = utf8 */;
600CREATE TABLE `reports` (
601  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
602  `date` varchar(25) COLLATE latin1_general_ci NOT NULL,
603  `report` varchar(150) COLLATE latin1_general_ci NOT NULL,
604  PRIMARY KEY (`id`)
605) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
606/*!40101 SET character_set_client = @saved_cs_client */;
607
608--
609-- Dumping data for table `reports`
610--
611
612LOCK TABLES `reports` WRITE;
613/*!40000 ALTER TABLE `reports` DISABLE KEYS */;
614/*!40000 ALTER TABLE `reports` ENABLE KEYS */;
615UNLOCK TABLES;
616
617--
618-- Table structure for table `skills`
619--
620
621DROP TABLE IF EXISTS `skills`;
622/*!40101 SET @saved_cs_client     = @@character_set_client */;
623/*!40101 SET character_set_client = utf8 */;
624CREATE TABLE `skills` (
625  `player` int(11) NOT NULL DEFAULT '0',
626  `id` tinyint(4) NOT NULL DEFAULT '0',
627  `skill` int(11) unsigned NOT NULL DEFAULT '0',
628  `tries` int(11) unsigned NOT NULL DEFAULT '0',
629  KEY `player` (`player`)
630) ENGINE=MyISAM DEFAULT CHARSET=latin1;
631/*!40101 SET character_set_client = @saved_cs_client */;
632
633--
634-- Dumping data for table `skills`
635--
636
637LOCK TABLES `skills` WRITE;
638/*!40000 ALTER TABLE `skills` DISABLE KEYS */;
639/*!40000 ALTER TABLE `skills` ENABLE KEYS */;
640UNLOCK TABLES;
641
642--
643-- Table structure for table `spells`
644--
645
646DROP TABLE IF EXISTS `spells`;
647/*!40101 SET @saved_cs_client     = @@character_set_client */;
648/*!40101 SET character_set_client = utf8 */;
649CREATE TABLE `spells` (
650  `player` int(11) NOT NULL,
651  `spell` varchar(50) COLLATE latin1_general_ci NOT NULL
652) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
653/*!40101 SET character_set_client = @saved_cs_client */;
654
655--
656-- Dumping data for table `spells`
657--
658
659LOCK TABLES `spells` WRITE;
660/*!40000 ALTER TABLE `spells` DISABLE KEYS */;
661INSERT INTO `spells` VALUES (2,'utevo vis lux'),(2,'exori mort'),(2,'exevo gran mas mort'),(2,'utevo res ina'),(2,'utani hur'),(2,'utevo lux'),(2,'exevo gran mas vis'),(2,'utani gran hur'),(2,'utani vita hur');
662/*!40000 ALTER TABLE `spells` ENABLE KEYS */;
663UNLOCK TABLES;
664
665--
666-- Table structure for table `tileitems`
667--
668
669DROP TABLE IF EXISTS `tileitems`;
670/*!40101 SET @saved_cs_client     = @@character_set_client */;
671/*!40101 SET character_set_client = utf8 */;
672CREATE TABLE `tileitems` (
673  `tileid` int(11) NOT NULL DEFAULT '0',
674  `sid` int(11) NOT NULL DEFAULT '0',
675  `pid` int(11) NOT NULL DEFAULT '0',
676  `type` int(11) NOT NULL DEFAULT '0',
677  `number` tinyint(4) NOT NULL,
678  `attributes` blob,
679  KEY `tileid` (`tileid`)
680) ENGINE=MyISAM DEFAULT CHARSET=latin1;
681/*!40101 SET character_set_client = @saved_cs_client */;
682
683--
684-- Dumping data for table `tileitems`
685--
686
687LOCK TABLES `tileitems` WRITE;
688/*!40000 ALTER TABLE `tileitems` DISABLE KEYS */;
689/*!40000 ALTER TABLE `tileitems` ENABLE KEYS */;
690UNLOCK TABLES;
691
692--
693-- Table structure for table `tilelist`
694--
695
696DROP TABLE IF EXISTS `tilelist`;
697/*!40101 SET @saved_cs_client     = @@character_set_client */;
698/*!40101 SET character_set_client = utf8 */;
699CREATE TABLE `tilelist` (
700  `tileid` int(11) unsigned NOT NULL,
701  `x` int(11) unsigned NOT NULL,
702  `y` int(11) unsigned NOT NULL,
703  `z` int(11) unsigned NOT NULL,
704  PRIMARY KEY (`tileid`),
705  UNIQUE KEY `x` (`x`,`y`,`z`)
706) ENGINE=MyISAM DEFAULT CHARSET=latin1;
707/*!40101 SET character_set_client = @saved_cs_client */;
708
709
710--
711-- Table structure for table `viplist`
712--
713
714DROP TABLE IF EXISTS `viplist`;
715/*!40101 SET @saved_cs_client     = @@character_set_client */;
716/*!40101 SET character_set_client = utf8 */;
717CREATE TABLE `viplist` (
718  `account` int(11) unsigned NOT NULL DEFAULT '0',
719  `player` varchar(32) NOT NULL DEFAULT '0',
720  KEY `player` USING BTREE (`account`)
721) ENGINE=MyISAM DEFAULT CHARSET=latin1;
722/*!40101 SET character_set_client = @saved_cs_client */;
723
724
725--
726-- Final view structure for view `aa_calosc_cc`
727--
728
729CREATE VIEW `aa_calosc_cc` AS select (sum(`items`.`number`) * 10000) AS `totalmoney` from `items` where (`items`.`type` = 2160);
730
731--
732-- Final view structure for view `aa_calosc_mr`
733--
734
735CREATE VIEW `aa_calosc_mr` AS select sum(`items`.`number`) AS `totalmr` from `items` where (`items`.`type` = 2270);
736
737--
738-- Final view structure for view `aa_calosc_mr_dom`
739--
740
741CREATE VIEW `aa_calosc_mr_dom` AS select sum(`tileitems`.`number`) AS `totalmr_dom` from `tileitems` where (`tileitems`.`type` = 2270);
742
743--
744-- Final view structure for view `aa_ilosc_paccow`
745--
746
747CREATE VIEW `aa_ilosc_paccow` AS select count(0) AS `ilosc_paccow` from `accounts` where (`accounts`.`premDays` > _utf8'0') group by `accounts`.`blocked`;
748
749--
750-- Final view structure for view `aa_statystyki_addon`
751--
752CREATE VIEW `aa_statystyki_addon` AS select sum(`items`.`number`) AS `totaladdon`,`players`.`name` AS `name` from (`items` join `players`) where ((`items`.`type` = 6579) and (`players`.`id` = `items`.`player`)) group by `players`.`name` order by sum(`items`.`number`) desc;
753
754--
755-- Final view structure for view `aa_statystyki_addon_dom`
756--
757
758CREATE VIEW `aa_statystyki_addon_dom` AS select sum(`tileitems`.`number`) AS `totaladdon_dom`,`tileitems`.`tileid` AS `tileid` from `tileitems` where (`tileitems`.`type` = 6579) group by `tileitems`.`tileid` order by sum(`tileitems`.`number`) desc;
759
760--
761-- Final view structure for view `aa_statystyki_bogaczy`
762--
763
764CREATE VIEW `aa_statystyki_bogaczy` AS select (sum(`items`.`number`) * 10000) AS `totalmoney`,`players`.`name` AS `name` from (`items` join `players`) where ((`items`.`type` = 2160) and (`players`.`id` = `items`.`player`)) group by `players`.`name` order by (sum(`items`.`number`) * 10000) desc;
765
766--
767-- Final view structure for view `aa_statystyki_eqbag`
768--
769
770CREATE VIEW `aa_statystyki_eqbag` AS select sum(`items`.`number`) AS `totaleqbag`,`players`.`name` AS `name` from (`items` join `players`) where (((`items`.`type` = 2331) or (`items`.`type` = 6391) or (`items`.`type` = 2502) or (`items`.`type` = 2503) or (`items`.`type` = 2644) or (`items`.`type` = 2504)) and (`players`.`id` = `items`.`player`)) group by `players`.`name` order by sum(`items`.`number`) desc;
771
772--
773-- Final view structure for view `aa_statystyki_eqbag_dom`
774--
775
776CREATE VIEW `aa_statystyki_eqbag_dom` AS select sum(`tileitems`.`number`) AS `totaleqbag_dom`,`tileitems`.`tileid` AS `tileid` from `tileitems` where ((`tileitems`.`type` = 2331) or (`tileitems`.`type` = 6391) or (`tileitems`.`type` = 2502) or (`tileitems`.`type` = 2503) or (`tileitems`.`type` = 2644) or (`tileitems`.`type` = 2504)) group by `tileitems`.`tileid` order by sum(`tileitems`.`number`) desc;
777
778--
779-- Final view structure for view `aa_statystyki_exp`
780--
781
782CREATE VIEW `aa_statystyki_exp` AS select sum(`items`.`number`) AS `totalexp`,`players`.`name` AS `name` from (`items` join `players`) where (((`items`.`type` = 2166) or (`items`.`type` = 2203)) and (`players`.`id` = `items`.`player`)) group by `players`.`name` order by sum(`items`.`number`) desc;
783
784--
785-- Final view structure for view `aa_statystyki_exp_dom`
786--
787
788CREATE VIEW `aa_statystyki_exp_dom` AS select sum(`tileitems`.`number`) AS `totalexp_dom`,`tileitems`.`tileid` AS `tileid` from `tileitems` where ((`tileitems`.`type` = 2166) or (`tileitems`.`type` = 2203) or (`tileitems`.`type` = 2327) or (`tileitems`.`type` = 5088)) group by `tileitems`.`tileid` order by sum(`tileitems`.`number`) desc;
789
790--
791-- Final view structure for view `aa_statystyki_miast`
792--
793
794CREATE VIEW `aa_statystyki_miast` AS select (case when (`players`.`masterpos` = _latin1'437;504;7') then _utf8'Center City' when (`players`.`masterpos` = _latin1'393;487;7') then _utf8'Desert City' when (`players`.`masterpos` = _latin1'539;471;7') then _utf8'Jungle' when (`players`.`masterpos` = _latin1'491;429;7') then _utf8'Inferno' when (`players`.`masterpos` = _latin1'654;531;7') then _utf8'Poison City' when (`players`.`masterpos` = _latin1'463;672;7') then _utf8'Old Land' when (`players`.`masterpos` = _latin1'420;461;7') then _utf8'GM Island' when (`players`.`masterpos` = _latin1'519;699;7') then _utf8'Electry City' when (`players`.`masterpos` = _latin1'776;485;5') then _utf8'Rook' when (`players`.`masterpos` = _latin1'721;717;7') then _utf8'Forest City' end) AS `miasto`,count(`players`.`id`) AS `ilosc` from `players` group by `players`.`masterpos`;
795
796--
797-- Final view structure for view `aa_statystyki_mr`
798--
799
800CREATE VIEW `aa_statystyki_mr` AS select sum(`items`.`number`) AS `totalmr`,`players`.`name` AS `name` from (`items` join `players`) where ((`items`.`type` = 2270) and (`players`.`id` = `items`.`player`)) group by `players`.`name` order by sum(`items`.`number`) desc;
801
802--
803-- Final view structure for view `aa_statystyki_mr_dom`
804--
805
806CREATE VIEW `aa_statystyki_mr_dom` AS select sum(`tileitems`.`number`) AS `totalmr_dom`,`tileitems`.`tileid` AS `tileid` from `tileitems` where (`tileitems`.`type` = 2270) group by `tileitems`.`tileid` order by sum(`tileitems`.`number`) desc;
807
808--
809-- Final view structure for view `aa_statystyki_paccr`
810--
811
812CREATE VIEW `aa_statystyki_paccr` AS select sum(`items`.`number`) AS `totalpaccr`,`players`.`name` AS `name` from (`items` join `players`) where ((`items`.`type` = 2312) and (`players`.`id` = `items`.`player`)) group by `players`.`name` order by sum(`items`.`number`) desc;
813
814--
815-- Final view structure for view `aa_statystyki_prof`
816--
817
818CREATE VIEW `aa_statystyki_prof` AS select (case when (`players`.`vocation` = 0) then _utf8'none' when ((`players`.`vocation` = 1) or (`players`.`vocation` = 5)) then _utf8'sorcerer' when ((`players`.`vocation` = 2) or (`players`.`vocation` = 6)) then _utf8'druid' when ((`players`.`vocation` = 3) or (`players`.`vocation` = 7)) then _utf8'paladin' when ((`players`.`vocation` = 4) or (`players`.`vocation` = 8)) then _utf8'knight' end) AS `profesja`,count(`players`.`id`) AS `ilosc` from `players` group by (case when (`players`.`vocation` = 0) then _utf8'none' when ((`players`.`vocation` = 1) or (`players`.`vocation` = 5)) then _utf8'sorcerer' when ((`players`.`vocation` = 2) or (`players`.`vocation` = 6)) then _utf8'druid' when ((`players`.`vocation` = 3) or (`players`.`vocation` = 7)) then _utf8'paladin' when ((`players`.`vocation` = 4) or (`players`.`vocation` = 8)) then _utf8'knight' end);
819
820--
821-- Final view structure for view `aa_statystyki_ssa`
822--
823
824CREATE VIEW `aa_statystyki_ssa` AS select sum(`items`.`number`) AS `totalssa`,`players`.`name` AS `name` from (`items` join `players`) where ((`items`.`type` = 2197) and (`players`.`id` = `items`.`player`)) group by `players`.`name` order by sum(`items`.`number`) desc;
825
826--
827-- Final view structure for view `aa_statystyki_ssa_dom`
828--
829
830CREATE VIEW `aa_statystyki_ssa_dom` AS select sum(`tileitems`.`number`) AS `totalssa_dom`,`tileitems`.`tileid` AS `tileid` from `tileitems` where (`tileitems`.`type` = 2197) group by `tileitems`.`tileid` order by sum(`tileitems`.`number`) desc;
831
832--
833-- Final view structure for view `guild_wars_score`
834--
835
836CREATE VIEW `guild_wars_score` AS select (select `guilds`.`guildname` AS `guildname` from `guilds` where (`guilds`.`guildid` = `GW1`.`target`)) AS `guild1`,`GW1`.`target` AS `guild1id`,(select count(`guild_wars`.`score`) AS `count(score)` from `guild_wars` where ((`guild_wars`.`killer` = `GW1`.`killer`) and (`guild_wars`.`target` = `GW1`.`target`))) AS `guild_score1`,(select count(`guild_wars`.`score`) AS `count(score)` from `guild_wars` where ((`guild_wars`.`killer` = `GW2`.`killer`) and (`guild_wars`.`target` = `GW2`.`target`))) AS `guild_score2`,`G1`.`guildname` AS `guild2`,`GW1`.`killer` AS `guild2id` from (`guilds` `G1` join (`guild_wars` `GW1` left join (`guild_wars` `GW2` join `guilds` `G2` on((`G2`.`guildid` = `GW2`.`killer`))) on(((`GW1`.`killer` = `GW2`.`target`) and (`GW1`.`target` = `GW2`.`killer`)))) on((`G1`.`guildid` = `GW1`.`killer`))) group by `GW1`.`killer`,`GW1`.`target` order by (select count(`guild_wars`.`score`) AS `count(score)` from `guild_wars` where ((`guild_wars`.`killer` = `GW1`.`killer`) and (`guild_wars`.`target` = `GW1`.`target`))) desc;
837
838--
839-- Final view structure for view `guild_wars_top_fraggers`
840--
841
842CREATE VIEW `guild_wars_top_fraggers` AS select `guild_wars`.`killer_id` AS `id`,`players`.`name` AS `name`,`players`.`level` AS `level`,count(0) AS `frags`,round(avg(`guild_wars`.`target_lvl`),0) AS `avg` from (`guild_wars` join `players` on((`guild_wars`.`killer_id` = `players`.`id`))) group by `guild_wars`.`killer_id` order by count(0) desc;
843
844--
845-- Final view structure for view `top_fraggers`
846--
847
848CREATE VIEW `top_fraggers` AS select `death_list`.`killer_id` AS `id`,`players`.`name` AS `name`,count(0) AS `frags`,round(avg(`death_list`.`target_lvl`),0) AS `avg` from (`death_list` join `players` on((`death_list`.`killer_id` = `players`.`id`))) group by `death_list`.`killer_id` order by count(0) desc;
849
850--
851-- Final view structure for view `v_accounts`
852--
853
854CREATE VIEW `v_accounts` AS select `accounts`.`id` AS `id`,`accounts`.`accno` AS `accno`,`accounts`.`premDays` AS `premDays`,`accounts`.`premEnd` AS `premEnd`,`accounts`.`email` AS `email`,`accounts`.`rlname` AS `rlname`,`accounts`.`location` AS `location` from `accounts`;