hbb3ht4V

1--
2-- Table structure for table `LoginLogs`
3--
4
5DROP TABLE IF EXISTS `LoginLogs`;
6/*!40101 SET @saved_cs_client     = @@character_set_client */;
7/*!40101 SET character_set_client = utf8 */;
8CREATE TABLE `LoginLogs` (
9  `dbid` int(11) DEFAULT NULL,
10  `connectedFrom` varchar(100) DEFAULT NULL,
11  `hostAddress` varchar(100) DEFAULT NULL,
12  `macAddress` varchar(100) DEFAULT NULL,
13  `regSerial` varchar(100) DEFAULT NULL,
14  `systemName` varchar(100) DEFAULT NULL,
15  `playerName` varchar(50) DEFAULT NULL,
16  `playerRights` int(11) DEFAULT NULL,
17  `macAdress` varchar(100) DEFAULT NULL,
18  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
19) ENGINE=InnoDB DEFAULT CHARSET=latin1;
20/*!40101 SET character_set_client = @saved_cs_client */;
21
22--
23-- Table structure for table `account_registration`
24--
25
26DROP TABLE IF EXISTS `account_registration`;
27/*!40101 SET @saved_cs_client     = @@character_set_client */;
28/*!40101 SET character_set_client = utf8 */;
29CREATE TABLE `account_registration` (
30  `playerID` int(11) DEFAULT NULL,
31  `playerName` varchar(50) DEFAULT NULL,
32  `registerDateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
33  `hostAddress` varchar(100) DEFAULT NULL,
34  `macAddress` varchar(100) DEFAULT NULL,
35  `regSerial` varchar(100) DEFAULT NULL,
36  `systemName` varchar(100) DEFAULT NULL
37) ENGINE=InnoDB DEFAULT CHARSET=latin1;
38/*!40101 SET character_set_client = @saved_cs_client */;
39
40--
41-- Table structure for table `clients`
42--
43
44DROP TABLE IF EXISTS `clients`;
45/*!40101 SET @saved_cs_client     = @@character_set_client */;
46/*!40101 SET character_set_client = utf8 */;
47CREATE TABLE `clients` (
48  `playerID` int(11) DEFAULT NULL,
49  `voteStreaks` int(11) DEFAULT NULL,
50  `playerName` varchar(50) DEFAULT NULL,
51  `playerMacAddress` varchar(50) DEFAULT NULL,
52  `connectedFrom` varchar(50) DEFAULT NULL,
53  `regSerial` varchar(50) DEFAULT NULL,
54  `dbid` int(11) DEFAULT NULL,
55  `lockedExperienceGain` tinyint(1) DEFAULT NULL,
56  `weaponGameMeleeLevel` int(11) DEFAULT NULL,
57  `encryptedPass` varchar(100) DEFAULT NULL,
58  `gameMode` varchar(50) DEFAULT NULL,
59  `newPlayer` tinyint(1) DEFAULT NULL,
60  `heightLevel` int(11) DEFAULT NULL,
61  `absX` int(11) DEFAULT NULL,
62  `absY` int(11) DEFAULT NULL,
63  `playerRights` int(11) DEFAULT NULL,
64  `systemName` varchar(50) DEFAULT NULL,
65  `playerMacAdress` varchar(50) DEFAULT NULL,
66  `titleColor` varchar(50) DEFAULT NULL,
67  `runEnergy` int(11) DEFAULT NULL,
68  `titleShadow` varchar(50) DEFAULT NULL,
69  `textShadow` varchar(50) DEFAULT NULL,
70  `yellTitle` varchar(50) DEFAULT NULL,
71  `textYellColor` varchar(50) DEFAULT NULL,
72  `crystalBowShots` int(11) DEFAULT NULL,
73  `lostCatId` int(11) DEFAULT NULL,
74  `dungTokens` int(11) DEFAULT NULL,
75  `duelsWon` int(11) DEFAULT NULL,
76  `duelsLost` int(11) DEFAULT NULL,
77  `premiumPoints` int(11) DEFAULT NULL,
78  `voterPoints` int(11) DEFAULT NULL,
79  `totalVotes` int(11) DEFAULT NULL,
80  `amountDonated` int(11) DEFAULT NULL,
81  `title` varchar(50) DEFAULT NULL,
82  `donorPoints` int(11) DEFAULT NULL,
83  `tempAmountDonated` int(11) DEFAULT NULL,
84  `YellsRemaining` float DEFAULT NULL,
85  `playTime` mediumtext,
86  `weaponGameRangeLevel` int(11) DEFAULT NULL,
87  `weaponGameMageLevel` int(11) DEFAULT NULL,
88  `weaponGameMeleeKills` int(11) DEFAULT NULL,
89  `weaponGameRangeKills` int(11) DEFAULT NULL,
90  `weaponGameMeleeDeaths` int(11) DEFAULT NULL,
91  `weaponGameRangeDeaths` int(11) DEFAULT NULL,
92  `weaponGameMageDeaths` int(11) DEFAULT NULL,
93  `weaponGameMeleeLP` int(11) DEFAULT NULL,
94  `weaponGameRangeLP` int(11) DEFAULT NULL,
95  `weaponGameMageLP` int(11) DEFAULT NULL,
96  `lastWeapon` int(11) DEFAULT NULL,
97  `homeArea` int(11) DEFAULT NULL,
98  `Tasksdone` int(11) DEFAULT NULL,
99  `bankPin` int(11) DEFAULT NULL,
100  `recievedWg` tinyint(1) DEFAULT NULL,
101  `usingCurses` int(11) DEFAULT NULL,
102  `useCustomYell` tinyint(1) DEFAULT NULL,
103  `attemptsRemaining` int(11) DEFAULT NULL,
104  `WGPoints` int(11) DEFAULT NULL,
105  `poisonDamage` int(11) DEFAULT NULL,
106  `action` int(11) DEFAULT NULL,
107  `totalBossesKilled` int(11) DEFAULT NULL,
108  `PkKillCount` int(11) DEFAULT NULL,
109  `boostedHits` int(11) DEFAULT NULL,
110  `pure` int(11) DEFAULT NULL,
111  `isSpawned` tinyint(1) DEFAULT NULL,
112  `FamiliarID` int(11) DEFAULT NULL,
113  `pkingPoints` int(11) DEFAULT NULL,
114  `skullTimer` int(11) DEFAULT NULL,
115  `weaponGameMageKills` int(11) DEFAULT NULL,
116  `recoveryId` int(11) DEFAULT NULL,
117  `playerDeathCount` int(11) DEFAULT NULL,
118  `Blackmarks` int(11) DEFAULT NULL,
119  `xpLock` int(11) DEFAULT NULL,
120  `membership` tinyint(1) DEFAULT NULL,
121  `startDay` int(11) DEFAULT NULL,
122  `startMonth` int(11) DEFAULT NULL,
123  `recoilCount` int(11) DEFAULT NULL,
124  `doubleExpRingCount` int(11) DEFAULT NULL,
125  `playerMagicBook` int(11) DEFAULT NULL,
126  `barrowsNpcs` varchar(1000) DEFAULT NULL,
127  `specialAttackCharge` double DEFAULT NULL,
128  `randomCoffin` int(11) DEFAULT NULL,
129  `barrowsKillCount` int(11) DEFAULT NULL,
130  `pcPoints` int(11) DEFAULT NULL,
131  `donatedtimes` int(11) DEFAULT NULL,
132  `donatorType` int(11) DEFAULT NULL,
133  `isStarter` int(11) DEFAULT NULL,
134  `magePoints` int(11) DEFAULT NULL,
135  `pkPoints` int(11) DEFAULT NULL,
136  `waveId` int(11) DEFAULT NULL,
137  `killCount` int(11) DEFAULT NULL,
138  `fightStyle` int(11) DEFAULT NULL,
139  `fightMode` int(11) DEFAULT NULL,
140  `epAmount` int(11) DEFAULT NULL,
141  `splitChat` int(11) DEFAULT NULL,
142  `brightness` int(11) DEFAULT NULL,
143  `totalEXP` mediumtext,
144  `enterBHTimer` int(11) DEFAULT NULL,
145  `lastClan` varchar(50) DEFAULT NULL,
146  `lastWithdrawAmount` int(11) DEFAULT NULL,
147  `playerEquipment` varchar(1000) DEFAULT NULL,
148  `playerAppearance` varchar(1000) DEFAULT NULL,
149  `playerLevel` varchar(1000) DEFAULT NULL,
150  `playerItems` varchar(5000) DEFAULT NULL,
151  `playerBank` varchar(25000) DEFAULT NULL,
152  `clanKey` int(11) DEFAULT NULL,
153  `friends` varchar(1000) DEFAULT NULL,
154  `ignores` varchar(1000) DEFAULT NULL,
155  `publicChatMode` int(11) DEFAULT NULL,
156  `privateChatMode` int(11) DEFAULT NULL,
157  `clanChatMode` int(11) DEFAULT NULL,
158  `tradeMode` int(11) DEFAULT NULL,
159  `shoutMode` int(11) DEFAULT NULL,
160  `globalMode` int(11) DEFAULT NULL,
161  `gameChatMode` int(11) DEFAULT NULL,
162  `bossesKilled` int(11) DEFAULT NULL,
163  `wonBets` int(11) DEFAULT NULL,
164  `lostBets` int(11) DEFAULT NULL,
165  `resetRequestDate` mediumtext,
166  `tasks` varchar(2000) DEFAULT NULL,
167  `taskProgress` varchar(5000) DEFAULT NULL,
168  `familiaritems` varchar(1000) DEFAULT NULL,
169  `settingValues` varchar(500) DEFAULT NULL,
170  `playerData` varchar(5000) DEFAULT NULL,
171  `playerPresets` varchar(2000) DEFAULT NULL,
172  `playerTimers` varchar(2000) DEFAULT NULL,
173  `itemDegrading` varchar(2000) DEFAULT NULL,
174  `playerSettings` varchar(2000) DEFAULT NULL,
175  `quickPrayers` int(11) DEFAULT NULL,
176  `quickCurses` int(11) DEFAULT NULL,
177  `overloadTick` int(11) DEFAULT NULL,
178  `lastDailyReward` int(11) DEFAULT NULL,
179  `wgClassID` int(11) DEFAULT NULL,
180  `playerEmail` varchar(30) DEFAULT NULL,
181  `castleWarsScore` int(11) DEFAULT NULL,
182  `castleWarsCaptures` int(11) DEFAULT NULL,
183  `castleWarsCatapultDamage` int(11) DEFAULT NULL,
184  `changePassword` int(11) DEFAULT NULL,
185  `slayerMaster` int(11) DEFAULT NULL,
186  `castleWarsGamesPlayed` int(11) DEFAULT NULL,
187  `castleWarsKills` int(11) DEFAULT NULL,
188  `slayerMonsterType` int(11) DEFAULT NULL,
189  `slayerPendingKills` int(11) DEFAULT NULL,
190  `slayerPoints` int(11) DEFAULT NULL,
191  `slayerTaskStreak` int(11) DEFAULT NULL,
192  `slayerDisabledTasks` varchar(300) DEFAULT NULL,
193  `recolors` varchar(500) DEFAULT NULL,
194  `settingsFlags` mediumtext,
195  `killStreak` int(11) DEFAULT NULL,
196  `knowledgePool` mediumtext,
197  `luckPool` mediumtext,
198  `precisionPool` mediumtext,
199  `reinvigorationPool` mediumtext,
200  `securityPool` mediumtext,
201  `dfsCharges` int(11) DEFAULT NULL,
202  `acceptRules` int(11) DEFAULT NULL,
203  `lastVoteStreak` mediumtext,
204  `lastStreakPenalty` mediumtext,
205  `streakPenalty` mediumtext,
206  `donatorExpireTime` mediumtext,
207  `participationPoints` int(11) DEFAULT NULL,
208  `contributionPoints` int(11) DEFAULT NULL,
209  `dicingHosts` int(11) DEFAULT NULL,
210  `trollPetNameID` int(11) DEFAULT NULL,
211  `charmCollectSettings` int(11) DEFAULT NULL,
212  `skillingPoints` int(11) DEFAULT NULL,
213  `skillingExperience` int(11) DEFAULT NULL,
214  `experienceBonus` mediumtext,
215  `collectBoneID` int(11) DEFAULT NULL,
216  `collectedBones` int(11) DEFAULT NULL,
217  `playerTitle` varchar(100) DEFAULT NULL,
218  `titleTasks` varchar(300) DEFAULT NULL,
219  `progressVariables` varchar(300) DEFAULT NULL,
220  `fightPitsWins` int(11) DEFAULT NULL,
221  `middleman` tinyint(1) DEFAULT NULL,
222  `rareDropCount` int(11) DEFAULT NULL,
223  `duelPresets` varchar(300) DEFAULT NULL,
224  `minedDusts` int(11) DEFAULT NULL,
225  `spottedStars` int(11) DEFAULT NULL,
226  `soulPoints` int(11) DEFAULT NULL,
227  `lastRecoverCountReset` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
228  `collectionRecoveries` varchar(500) DEFAULT NULL,
229  `easyScroll` varchar(100) DEFAULT NULL,
230  `mediumScroll` varchar(100) DEFAULT NULL,
231  `hardScroll` varchar(100) DEFAULT NULL,
232  `eliteScroll` varchar(100) DEFAULT NULL,
233  `recoveryPoints` int(11) DEFAULT NULL,
234  `dicingDuration` mediumtext,
235  `bankItems` varchar(3000) DEFAULT NULL,
236  `isTrusted` tinyint(1) DEFAULT NULL
237) ENGINE=InnoDB DEFAULT CHARSET=latin1;
238/*!40101 SET character_set_client = @saved_cs_client */;
239
240--
241-- Table structure for table `clients_old`
242--
243
244DROP TABLE IF EXISTS `clients_old`;
245/*!40101 SET @saved_cs_client     = @@character_set_client */;
246/*!40101 SET character_set_client = utf8 */;
247CREATE TABLE `clients_old` (
248  `playerID` int(11) DEFAULT NULL,
249  `voteStreaks` int(11) DEFAULT NULL,
250  `playerName` varchar(50) DEFAULT NULL,
251  `playerMacAddress` varchar(50) DEFAULT NULL,
252  `connectedFrom` varchar(50) DEFAULT NULL,
253  `regSerial` varchar(50) DEFAULT NULL
254) ENGINE=InnoDB DEFAULT CHARSET=latin1;
255/*!40101 SET character_set_client = @saved_cs_client */;
256
257--
258-- Table structure for table `collect`
259--
260
261DROP TABLE IF EXISTS `collect`;
262/*!40101 SET @saved_cs_client     = @@character_set_client */;
263/*!40101 SET character_set_client = utf8 */;
264CREATE TABLE `collect` (
265  `player` int(11) DEFAULT NULL,
266  `items` varchar(1000) DEFAULT NULL
267) ENGINE=InnoDB DEFAULT CHARSET=latin1;
268/*!40101 SET character_set_client = @saved_cs_client */;
269
270--
271-- Table structure for table `npcKills`
272--
273
274DROP TABLE IF EXISTS `npcKills`;
275/*!40101 SET @saved_cs_client     = @@character_set_client */;
276/*!40101 SET character_set_client = utf8 */;
277CREATE TABLE `npcKills` (
278  `playerID` int(11) DEFAULT NULL,
279  `npcID` int(11) DEFAULT NULL,
280  `killCount` int(11) DEFAULT NULL,
281  `bestKillTime` mediumtext
282) ENGINE=InnoDB DEFAULT CHARSET=latin1;
283/*!40101 SET character_set_client = @saved_cs_client */;
284
285--
286-- Table structure for table `player_inventory`
287--
288
289DROP TABLE IF EXISTS `player_inventory`;
290/*!40101 SET @saved_cs_client     = @@character_set_client */;
291/*!40101 SET character_set_client = utf8 */;
292CREATE TABLE `player_inventory` (
293  `playerID` int(11) DEFAULT NULL,
294  `looting_bag` varchar(5000) DEFAULT NULL
295) ENGINE=InnoDB DEFAULT CHARSET=latin1;
296/*!40101 SET character_set_client = @saved_cs_client */;
297
298--
299-- Table structure for table `player_killing_score`
300--
301
302DROP TABLE IF EXISTS `player_killing_score`;
303/*!40101 SET @saved_cs_client     = @@character_set_client */;
304/*!40101 SET character_set_client = utf8 */;
305CREATE TABLE `player_killing_score` (
306  `player_id` int(11) DEFAULT NULL,
307  `pk_score` int(11) DEFAULT NULL
308) ENGINE=InnoDB DEFAULT CHARSET=latin1;
309/*!40101 SET character_set_client = @saved_cs_client */;
310
311--
312-- Table structure for table `player_pending_action`
313--
314
315DROP TABLE IF EXISTS `player_pending_action`;
316/*!40101 SET @saved_cs_client     = @@character_set_client */;
317/*!40101 SET character_set_client = utf8 */;
318CREATE TABLE `player_pending_action` (
319  `action_id` int(11) DEFAULT NULL,
320  `player_id` int(11) DEFAULT NULL,
321  `date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
322  `type` varchar(100) DEFAULT NULL
323) ENGINE=InnoDB DEFAULT CHARSET=latin1;
324/*!40101 SET character_set_client = @saved_cs_client */;
325
326--
327-- Table structure for table `playercount`
328--
329
330DROP TABLE IF EXISTS `playercount`;
331/*!40101 SET @saved_cs_client     = @@character_set_client */;
332/*!40101 SET character_set_client = utf8 */;
333CREATE TABLE `playercount` (
334  `playerCount` int(11) DEFAULT NULL,
335  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
336) ENGINE=InnoDB DEFAULT CHARSET=latin1;
337/*!40101 SET character_set_client = @saved_cs_client */;
338
339--
340-- Table structure for table `punishment`
341--
342
343DROP TABLE IF EXISTS `punishment`;
344/*!40101 SET @saved_cs_client     = @@character_set_client */;
345/*!40101 SET character_set_client = utf8 */;
346CREATE TABLE `punishment` (
347  `index` int(11) DEFAULT NULL,
348  `playerName` varchar(50) DEFAULT NULL,
349  `agent` varchar(50) DEFAULT NULL,
350  `expireDate` mediumtext,
351  `duration` varchar(50) DEFAULT NULL,
352  `type` varchar(300) DEFAULT NULL,
353  `reason` varchar(50) DEFAULT NULL,
354  `punishment` varchar(50) DEFAULT NULL,
355  `hostAddress` varchar(100) DEFAULT NULL,
356  `serial` varchar(100) DEFAULT NULL
357) ENGINE=InnoDB DEFAULT CHARSET=latin1;
358/*!40101 SET character_set_client = @saved_cs_client */;
359
360--
361-- Table structure for table `time_online_log`
362--
363
364DROP TABLE IF EXISTS `time_online_log`;
365/*!40101 SET @saved_cs_client     = @@character_set_client */;
366/*!40101 SET character_set_client = utf8 */;
367CREATE TABLE `time_online_log` (
368  `playerID` int(11) DEFAULT NULL,
369  `loginHash` int(11) DEFAULT NULL,
370  `onlineTime` mediumtext
371) ENGINE=InnoDB DEFAULT CHARSET=latin1;
372/*!40101 SET character_set_client = @saved_cs_client */;
373
374--
375-- Table structure for table `votes_record`
376--
377
378DROP TABLE IF EXISTS `votes_record`;
379/*!40101 SET @saved_cs_client     = @@character_set_client */;
380/*!40101 SET character_set_client = utf8 */;
381CREATE TABLE `votes_record` (
382  `playerID` int(11) DEFAULT NULL,
383  `playerName` varchar(50) DEFAULT NULL,
384  `points` int(11) DEFAULT NULL,
385  `totalPoints` int(11) DEFAULT NULL,
386  `voteStreaks` float DEFAULT NULL
387) ENGINE=InnoDB DEFAULT CHARSET=latin1;
388/*!40101 SET character_set_client = @saved_cs_client */;
389/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
390
391/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
392/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
393/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
394/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
395/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
396/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
397/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;