ah3E9viN

1--
2-- Databank: `xshadows_HS`
3--
4
5-- --------------------------------------------------------
6
7--
8-- Tabelstructuur voor tabel `hs_users`
9--
10
11CREATE TABLE IF NOT EXISTS `hs_users` (
12  `id` int(11) NOT NULL AUTO_INCREMENT,
13  `username` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
14  `rights` int(1) NOT NULL DEFAULT '0',
15  `overall_xp` bigint(20) NOT NULL,
16  `attack_xp` int(11) NOT NULL,
17  `defence_xp` int(11) NOT NULL,
18  `strength_xp` int(11) NOT NULL,
19  `constitution_xp` int(11) NOT NULL,
20  `ranged_xp` int(11) NOT NULL,
21  `prayer_xp` int(11) NOT NULL,
22  `magic_xp` int(11) NOT NULL,
23  `cooking_xp` int(11) NOT NULL,
24  `woodcutting_xp` int(11) NOT NULL,
25  `fletching_xp` int(11) NOT NULL,
26  `fishing_xp` int(11) NOT NULL,
27  `firemaking_xp` int(11) NOT NULL,
28  `crafting_xp` int(11) NOT NULL,
29  `smithing_xp` int(11) NOT NULL,
30  `mining_xp` int(11) NOT NULL,
31  `herblore_xp` int(11) NOT NULL,
32  `agility_xp` int(11) NOT NULL,
33  `thieving_xp` int(11) NOT NULL,
34  `slayer_xp` int(11) NOT NULL,
35  `farming_xp` int(11) NOT NULL,
36  `runecrafting_xp` int(11) NOT NULL,
37  `hunter_xp` int(11) NOT NULL,
38  `construction_xp` int(11) NOT NULL,
39  `summoning_xp` int(11) NOT NULL,
40  `dungeoneering_xp` int(11) NOT NULL,
41  PRIMARY KEY (`id`)
42) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=39 ;
43
44--
45-- Gegevens worden uitgevoerd voor tabel `hs_users`
46--
47
48INSERT INTO `hs_users` (`id`, `username`, `rights`, `overall_xp`, `attack_xp`, `defence_xp`, `strength_xp`, `constitution_xp`, `ranged_xp`, `prayer_xp`, `magic_xp`, `cooking_xp`, `woodcutting_xp`, `fletching_xp`, `fishing_xp`, `firemaking_xp`, `crafting_xp`, `smithing_xp`, `mining_xp`, `herblore_xp`, `agility_xp`, `thieving_xp`, `slayer_xp`, `farming_xp`, `runecrafting_xp`, `hunter_xp`, `construction_xp`, `summoning_xp`, `dungeoneering_xp`) VALUES
49(2, 'Matthew', 0, 35292154, 397920, 0, 601440, 44304, 0, 0, 0, 0, 373200, 0, 120000, 4919520, 2287800, 103320, 26444400, 250, 0, 0, 0, 0, 0, 0, 0, 0, 0),
50(4, 'Miner Lt1', 0, 449306994, 18762280, 19137760, 61540000, 82110584, 74645160, 11818800, 99585900, 1922400, 2228700, 60000, 13052400, 1511196, 13131540, 384768, 1112400, 312250, 13059480, 90960, 3022080, 765000, 1813920, 13110000, 333120, 13360296, 2436000),
51(7, 'Addiel', 0, 200388342, 21206920, 20776840, 40121320, 35075264, 16582320, 4195200, 14436300, 0, 231000, 0, 60000, 108000, 84000, 0, 20091000, 4571890, 390888, 120000, 5388000, 60000, 0, 168000, 120000, 14657400, 1944000),
52(8, 'God Kill7', 0, 235464110, 13056718, 14612382, 13043027, 14974106, 3332761, 14240280, 401764, 1450000, 616416, 1489209, 459480, 1470440, 13391690, 4949760, 49493900, 3006235, 13195446, 13035960, 2230400, 720, 13057024, 26271900, 3566400, 13423288, 694800),
53(9, 'Itrolledu', 0, 58395474, 74600, 88640, 187040, 117944, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 30774000, 250, 0, 0, 0, 2061000, 0, 25092000, 0, 0, 0),
54(10, 'Red Kid', 0, 123255039, 13172967, 22796819, 23584609, 25944045, 13288157, 13588400, 8009790, 0, 0, 0, 0, 0, 82000, 0, 0, 229850, 0, 0, 2246800, 0, 164000, 0, 0, 0, 147600),
55(11, 'Hugiz', 0, 564379445, 14221405, 37980597, 35304589, 104129354, 74619152, 27936000, 200000000, 0, 0, 148000, 0, 13331200, 13289440, 0, 13409600, 13180090, 849856, 272000, 80000, 0, 0, 0, 0, 14980160, 648000),
56(12, 'Stewie', 0, 5000000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000),
57(13, 'Beast', 0, 5000000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000),
58(14, 'Ashley', 0, 16492001, 3440501, 2444356, 2436341, 3094525, 2788426, 317200, 604000, 0, 0, 0, 0, 341600, 0, 0, 0, 250, 341600, 463600, 0, 0, 0, 0, 0, 0, 219600),
59(15, 'Mathy', 0, 864421, 316800, 41560, 43840, 122130, 640, 0, 2200, 0, 161000, 0, 56000, 0, 0, 0, 0, 40250, 80000, 0, 0, 0, 0, 0, 0, 0, 0),
60(16, 'System Error', 0, 252785817, 1026801, 1026561, 1024881, 1197314, 510241, 24000001, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 24000001, 200000000),
61(17, 'Benem', 0, 77789434, 1783120, 3175600, 2382640, 3974184, 4577640, 24504000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 250, 0, 0, 0, 0, 0, 0, 0, 24000000, 13392000),
62(18, 'Skull Agent7', 0, 281756862, 15186120, 6755640, 13346880, 63992624, 155057040, 2784000, 3124200, 0, 84000, 0, 0, 84000, 180000, 336000, 77700, 84250, 2509200, 228000, 3271800, 0, 144000, 0, 240000, 13911408, 360000),
63(19, 'Khoui', 0, 219340584, 21831160, 17048860, 23124760, 36479744, 43212540, 7429200, 13195050, 168000, 204000, 60000, 10538400, 180000, 13092600, 120000, 964200, 288250, 13250592, 1614000, 0, 120000, 180000, 168000, 288000, 15291228, 492000),
64(20, 'King Fox', 0, 5000000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000),
65(21, 'Jornskills', 0, 78908602, 13052173, 3997733, 13736053, 13712064, 3467360, 3522800, 13186800, 0, 0, 0, 0, 0, 13128280, 0, 0, 97338, 0, 0, 0, 0, 0, 0, 0, 0, 1008000),
66(22, 'A Friend', 0, 1058518290, 200000000, 47684200, 119330200, 200000000, 200000000, 14817600, 72365100, 13142400, 14924400, 13139928, 13038000, 15756264, 13487280, 1917900, 13163400, 250, 13410372, 13474200, 2208000, 13035000, 13049400, 13113000, 13620000, 4647396, 19194000),
67(23, 'Purple Pking', 0, 5000000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000),
68(24, 'Propker009', 0, 5000000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000),
69(25, 'Exit', 0, 339518718, 13180080, 13118400, 13183680, 27740744, 34117560, 2496000, 21694800, 13090800, 2334300, 2026776, 13152000, 13477920, 13114200, 58344, 152463600, 4066402, 203112, 0, 0, 0, 0, 0, 0, 0, 0),
70(26, 'Chris', 0, 633916885, 13062966, 13584406, 41094006, 95304535, 23221793, 13223201, 200000000, 13083841, 13076665, 1, 13089601, 13076833, 13326401, 14452897, 13040001, 13315249, 13144001, 1, 40001, 1441, 13038561, 70452001, 13085281, 13243201, 4960000),
71(27, 'Beachboyx', 0, 5000000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000),
72(28, 'Beachboyx122', 0, 5000000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000),
73(29, 'Ninjastorm', 0, 7160527, 770666, 450706, 769746, 906517, 0, 20000, 1224000, 0, 0, 0, 0, 0, 2962640, 0, 0, 56250, 0, 0, 0, 0, 0, 0, 0, 0, 0),
74(30, 'Redbull', 0, 3639141, 789359, 799039, 791999, 876450, 128640, 0, 173400, 0, 0, 0, 0, 40000, 0, 0, 0, 250, 0, 0, 0, 40000, 0, 0, 0, 0, 0),
75(31, 'King Of Fish', 0, 142428578, 31664052, 13052561, 47616521, 31467694, 2136395, 13525900, 122836, 0, 0, 0, 0, 0, 0, 0, 311600, 82250, 15334, 0, 0, 0, 0, 0, 0, 2285832, 147600),
76(32, 'Smileyownkid', 0, 192979504, 13254605, 13489621, 59437541, 42153506, 38855296, 19586000, 1830200, 112000, 1310779, 0, 0, 706200, 0, 0, 434400, 19658, 8640, 4480, 648000, 0, 112000, 80000, 0, 576, 936000),
77(33, 'Godmode', 0, 5000000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000, 200000000),
78(34, 'Swagskiller', 0, 500580394, 16000000, 16000000, 16000000, 1184, 16000000, 16000000, 16000000, 16000000, 16000000, 16000000, 16000000, 16256000, 13904000, 16018960, 16000000, 16000250, 16000000, 16000000, 16000000, 16000000, 16000000, 16000000, 16000000, 16000000, 134400000),
79(35, 'J English', 0, 149950917, 16184640, 16044085, 22712128, 22359477, 27274336, 16096000, 13208000, 0, 0, 0, 0, 0, 0, 0, 0, 250, 0, 0, 0, 0, 0, 0, 0, 16000000, 72000),
80(36, 'Elf', 0, 21185146, 279488, 0, 1011584, 3851967, 10261280, 234000, 0, 0, 0, 0, 80000, 0, 5249920, 0, 0, 89866, 15040, 0, 0, 112000, 0, 0, 0, 0, 0),
81(37, 'Godstar', 0, 737839, 34304, 0, 28576, 147925, 384, 80000, 286400, 0, 0, 0, 0, 0, 80000, 0, 0, 250, 80000, 0, 0, 0, 0, 0, 0, 0, 0),
82(38, 'Jake', 0, 82340002, 1765608, 1746792, 13039416, 5518456, 0, 1212800, 0, 0, 0, 0, 0, 0, 0, 0, 0, 250, 8680, 0, 32000, 0, 0, 58296000, 0, 0, 720000);