· 10 years ago · Aug 28, 2016, 03:20 PM
1-- phpMyAdmin SQL Dump
2-- version 3.5.2.2
3-- http://www.phpmyadmin.net
4--
5-- Vært: 127.0.0.1
6-- Genereringstid: 14. 06 2013 kl. 13:58:24
7-- Serverversion: 5.5.27
8-- PHP-version: 5.4.7
9
10SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Database: `darkorbit`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Struktur-dump for tabellen `clan`
27--
28
29CREATE TABLE IF NOT EXISTS `clan` (
30 `clanID` int(11) NOT NULL,
31 `clanName` varchar(255) NOT NULL,
32 `tagName` varchar(255) NOT NULL,
33 `memberCount` int(2) NOT NULL DEFAULT '1' COMMENT 'Can''t be more than 50',
34 PRIMARY KEY (`clanID`)
35) ENGINE=MyISAM DEFAULT CHARSET=utf8;
36
37--
38-- Data dump for tabellen `clan`
39--
40
41INSERT INTO `clan` (`clanID`, `clanName`, `tagName`, `memberCount`) VALUES
42(1, 'Administradores', 'adm', 1),
43(2, 'Developer', 'Dev', 1);
44
45-- --------------------------------------------------------
46
47--
48-- Struktur-dump for tabellen `equipment`
49--
50
51CREATE TABLE IF NOT EXISTS `equipment` (
52 `id` int(11) NOT NULL,
53 `name` varchar(255) NOT NULL,
54 `etype` varchar(255) NOT NULL,
55 `gfx` int(50) NOT NULL DEFAULT '0',
56 `effect` text NOT NULL,
57 `uridium` double(255,1) NOT NULL DEFAULT '-1.0',
58 `credits` int(255) NOT NULL DEFAULT '-1',
59 PRIMARY KEY (`id`),
60 KEY `1` (`id`),
61 KEY `2` (`name`),
62 KEY `3` (`etype`)
63) ENGINE=MyISAM DEFAULT CHARSET=utf8;
64
65--
66-- Data dump for tabellen `equipment`
67--
68
69INSERT INTO `equipment` (`id`, `name`, `etype`, `gfx`, `effect`, `uridium`, `credits`) VALUES
70(1, 'LF-1', 'laser', 1, 'D40', -1.0, 10000),
71(2, 'MP-1', 'laser', 2, 'D60', -1.0, 40000),
72(3, 'LF-2', 'laser', 3, 'D100', 5000.0, -1),
73(4, 'LF-3', 'laser', 4, 'D150', 10000.0, -1),
74(5, 'HST-1', 'laser', 11, 'HM3', -1.0, 500000),
75(6, 'HST-2', 'laser', 12, 'HM5', 15000.0, -1),
76(7, 'LCB-10', 'battery', 1, '', -1.0, 10),
77(8, 'MCB-25', 'battery', 2, '', 0.5, -1),
78(9, 'MCB-50', 'battery', 3, '', 1.0, -1),
79(10, 'UCB-100', 'battery', 4, '', 2.5, -1),
80(11, 'SAB-50', 'battery', 5, '', 1.0, -1),
81(12, 'RSB-75', 'battery', 6, '', 5.0, -1),
82(13, 'R-310', 'rocket', 1, 'D1000', -1.0, 100),
83(14, 'PLT-2026', 'rocket', 2, 'D2000', -1.0, 500),
84(15, 'PLT-2021', 'rocket', 3, 'D4000', 5.0, -1),
85(16, 'PLD-8', 'rocket', 4, 'DIS3', 100.0, -1),
86(17, 'PLT-3030', 'rocket', 5, 'D6000', 7.0, -1),
87(18, 'ACM-1', 'rocket', 11, 'DM20', 100.0, -1),
88(19, 'HSTRM-01', 'rocket', 50, 'D5000', 25.0, -1),
89(20, 'UBR-100', 'rocket', 51, 'D8000', 30.0, -1),
90(21, 'ECO-10', 'rocket', 52, 'D2400', -1.0, 1500),
91(22, 'G3N-1010', 'generator', 1, 'V2', -1.0, 2000),
92(23, 'G3N-2010', 'generator', 2, 'V3', -1.0, 4000),
93(24, 'G3N-3210', 'generator', 3, 'V4', -1.0, 8000),
94(25, 'G3N-3310', 'generator', 4, 'V5', -1.0, 16000),
95(26, 'G3N-6900', 'generator', 5, 'V7', 1000.0, -1),
96(27, 'G3N-7900', 'generator', 6, 'V10', 2000.0, -1),
97(28, 'SG3N-A01', 'generator', 7, 'E1000|40', -1.0, 8000),
98(29, 'SG3N-A02', 'generator', 8, 'E2000|50', -1.0, 16000),
99(30, 'SG3N-B01', 'generator', 9, 'E4000|70', 2500.0, -1),
100(31, 'SG3N-A03', 'generator', 10, 'E5000|60', -1.0, 256000),
101(32, 'SG3N-B02', 'generator', 11, 'E10000|80', 10000.0, -1),
102(33, 'LF-4', 'laser', 0, 'D200', -1.0, -1);
103
104-- --------------------------------------------------------
105
106--
107-- Struktur-dump for tabellen `maps`
108--
109
110CREATE TABLE IF NOT EXISTS `maps` (
111 `id` smallint(4) NOT NULL AUTO_INCREMENT,
112 `Name` varchar(20) NOT NULL DEFAULT '',
113 `Portals` text NOT NULL,
114 `NPCS` text NOT NULL,
115 `isStarterMap` enum('0','1') NOT NULL DEFAULT '0',
116 `factionId` tinyint(1) NOT NULL DEFAULT '0',
117 PRIMARY KEY (`id`)
118) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
119
120--
121-- Data dump for tabellen `maps`
122--
123
124INSERT INTO `maps` (`id`, `Name`, `Portals`, `NPCS`, `isStarterMap`, `factionId`) VALUES
125(1, '1-1', '[{"Id":1,"x":"18500","y":"11500","newX":"2000","newY":"2000","Map":2}]', '[{"npcId":84,"Count":50}]', '1', 1),
126(2, '1-2', '[{"Id":1,"x":"2000","y":"2000","newX":"18500","newY":"11500","Map":1},{"Id":2,"x":"18500","y":"2000","newX":"2000","newY":"11500","Map":3}]', '[{"npcId":84,"Count":50},{"npcId":71,"Count":25}]', '1', 1),
127(3, '1-3', '[{"Id":1,"x":"2000","y":"11500","newX":"18500","newY":"2000","Map":2}]', '[{"npcId":71,"Count":25},{"npcId":72,"Count":10}]', '0', 1);
128
129-- --------------------------------------------------------
130
131--
132-- Struktur-dump for tabellen `rank`
133--
134
135CREATE TABLE IF NOT EXISTS `rank` (
136 `id` int(11) unsigned NOT NULL,
137 `name` varchar(50) NOT NULL,
138 `percentage` double(11,2) NOT NULL DEFAULT '0.00',
139 PRIMARY KEY (`id`)
140) ENGINE=MyISAM DEFAULT CHARSET=utf8;
141
142--
143-- Data dump for tabellen `rank`
144--
145
146INSERT INTO `rank` (`id`, `name`, `percentage`) VALUES
147(1, 'Basic Space Pilot', 20.00),
148(2, 'Space Pilot', 12.39),
149(3, 'Chief Space Pilot', 10.00),
150(4, 'Basic Sergeant', 9.00),
151(5, 'Sergeant', 8.00),
152(6, 'Chief Sergeant', 7.00),
153(7, 'Basic Lieutenant', 6.00),
154(8, 'Lieutenant', 5.00),
155(9, 'Chief Lieutenant', 4.50),
156(10, 'Basic Captain', 4.00),
157(11, 'Captain', 3.50),
158(12, 'Chief Captain', 3.00),
159(13, 'Basic Major', 2.50),
160(14, 'Major', 2.00),
161(15, 'Chief Major', 1.50),
162(16, 'Basic Colonel', 1.00),
163(17, 'Colonel', 0.50),
164(18, 'Chief Colonel', 0.10),
165(19, 'Basic General', 0.01),
166(20, 'General', 0.00),
167(99, 'Administrator', 0.00),
168(21, 'Administrator', 0.00),
169(22, 'Wanted', 0.00);
170
171-- --------------------------------------------------------
172
173--
174-- Struktur-dump for tabellen `servers`
175--
176
177CREATE TABLE IF NOT EXISTS `servers` (
178 `ID` int(255) NOT NULL AUTO_INCREMENT,
179 `Name` varchar(255) NOT NULL DEFAULT 'Server 1',
180 `ShortName` varchar(10) NOT NULL DEFAULT 'SV1',
181 PRIMARY KEY (`ID`)
182) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
183
184--
185-- Data dump for tabellen `servers`
186--
187
188INSERT INTO `servers` (`ID`, `Name`, `ShortName`) VALUES
189(1, 'Global', 'G');
190
191-- --------------------------------------------------------
192
193--
194-- Struktur-dump for tabellen `server_1_players`
195--
196
197CREATE TABLE IF NOT EXISTS `server_1_players` (
198 `playerID` int(255) NOT NULL AUTO_INCREMENT,
199 `userID` int(255) NOT NULL,
200 `tokenId` bigint(20) NOT NULL DEFAULT '0',
201 `shipId` smallint(11) NOT NULL DEFAULT '59',
202 `factionId` smallint(1) NOT NULL DEFAULT '0',
203 `mapId` smallint(30) NOT NULL DEFAULT '1',
204 `x` varchar(5) NOT NULL DEFAULT '1000',
205 `y` varchar(5) NOT NULL DEFAULT '1000',
206 `settings` text NOT NULL,
207 `rank` int(11) NOT NULL DEFAULT '1' COMMENT '1: Basic Space Pilot',
208 `premium` int(1) NOT NULL DEFAULT '1' COMMENT '0: No, Premium | 1: Yes, Premium',
209 `level` int(11) NOT NULL DEFAULT '1',
210 `uav` varchar(255) NOT NULL DEFAULT '3/3-25-25-25,3/4-25-25-25-25,3/3-25-25-25',
211 `clanId` int(11) NOT NULL DEFAULT '0',
212 `uri` varchar(255) NOT NULL DEFAULT '20.000.000',
213 `exp` bigint(255) NOT NULL DEFAULT '0',
214 `credits` varchar(255) NOT NULL DEFAULT '50.000.000',
215 `jackpot` double(50,2) NOT NULL DEFAULT '0.00',
216 `Health` bigint(255) NOT NULL DEFAULT '4000',
217 `maxHealth` bigint(255) NOT NULL DEFAULT '4000',
218 `shield` bigint(255) NOT NULL DEFAULT '0',
219 `maxShield` bigint(255) NOT NULL DEFAULT '0',
220 `Nanohull` bigint(255) NOT NULL DEFAULT '0',
221 `MaxNanohull` bigint(255) NOT NULL DEFAULT '0',
222 `speed` int(11) NOT NULL DEFAULT '320',
223 `honor` bigint(255) NOT NULL DEFAULT '0',
224 PRIMARY KEY (`playerID`)
225) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED AUTO_INCREMENT=1003 ;
226
227--
228-- Data dump for tabellen `server_1_players`
229--
230
231INSERT INTO `server_1_players` (`playerID`, `userID`, `tokenId`, `shipId`, `factionId`, `mapId`, `x`, `y`, `settings`, `rank`, `premium`, `level`, `uav`, `clanId`, `uri`, `exp`, `credits`, `jackpot`, `Health`, `maxHealth`, `shield`, `maxShield`, `Nanohull`, `MaxNanohull`, `speed`, `honor`) VALUES
232(1000, 1, 2322130013, 59, 1, 1, '868', '1077', '{"SET":"1|1|1|1|1|1|1|1|1|1|1|0|0|1|1|0|0|1|1|0|0|1|1|1|1","MINIMAP_SCALE":"3|8","DISPLAY_PLAYER_NAMES":true,"DISPLAY_CHAT":true,"PLAY_MUSIC":true,"PLAY_SFX":true,"BAR_STATUS":"23,0,24,0,25,1,26,0,27,0","WINDOW_SETTINGS":"3|0,376,6,1,1,601,6,1,3,821,251,1,5,10,10,1,10,4,330,1,13,315,122,0,20,7,544,1,22,475,260,0,23,1060,131,1,24,412,97,0\\n\\u0000","AUTO_REFINEMENT":false,"QUICKSLOT_STOP_ATTACK":false,"DOUBLECLICK_ATTACK":true,"AUTO_START":false,"DISPLAY_NOTIFICATIONS":true,"SHOW_DRONES":true,"DISPLAY_WINDOW_BACKGROUND":true,"ALWAYS_DRAGGABLE_WINDOWS":true,"PRELOAD_USER_SHIPS":false,"QUALITY_PRESETTING":3,"QUALITY_CUSTOMIZED":0,"QUALITY_BACKGROUND":3,"QUALITY_POIZONE":3,"QUALITY_SHIP":3,"QUALITY_ENGINE":3,"QUALITY_COLLECTABLE":3,"QUALITY_ATTACK":3,"QUALITY_EFFECT":3,"QUALITY_EXPLOSION":3,"QUICKBAR_SLOT":"-1,-1,-1,-1,-1,-1,-1,-1,-1,-1","SLOTMENU_POSITION":"313,451","SLOTMENU_ORDER":0}', 12, 1, 9, '3/3-25-25-25,3/4-25-25-25-25,3/3-25-25-25', 1, 500000, 999999, 99999, 0.00, 999, 999, 1000, 1000, 0, 0, 320, 999),
233(1002, 3, 168785701, 10, 3, 1, '1000', '1000', '', 1, 1, 1, '3/3-25-25-25,3/4-25-25-25-25,3/3-25-25-25', 0, 500000, 9000000, 2500000, 0.00, 4000, 256000, 0, 0, 101100, 256000, 320, 9181205);
234
235-- --------------------------------------------------------
236
237--
238-- Struktur-dump for tabellen `server_1_players_equipment`
239--
240
241CREATE TABLE IF NOT EXISTS `server_1_players_equipment` (
242 `playerID` int(255) NOT NULL,
243 `userID` int(255) NOT NULL,
244 `equipmentCombo` int(255) NOT NULL,
245 PRIMARY KEY (`playerID`),
246 UNIQUE KEY `userID` (`userID`)
247) ENGINE=InnoDB DEFAULT CHARSET=latin1;
248
249-- --------------------------------------------------------
250
251--
252-- Struktur-dump for tabellen `ships`
253--
254
255CREATE TABLE IF NOT EXISTS `ships` (
256 `Id` smallint(11) NOT NULL AUTO_INCREMENT,
257 `Name` varchar(255) NOT NULL DEFAULT '-=[ ]=-',
258 `type` varchar(100) NOT NULL DEFAULT '',
259 `Costs` bigint(255) NOT NULL,
260 `HP` int(255) NOT NULL DEFAULT '1000',
261 `MaxNanohull` bigint(255) NOT NULL,
262 `Shield` int(255) NOT NULL DEFAULT '0',
263 `shieldAbsorb` smallint(11) NOT NULL DEFAULT '20',
264 `Damage` int(255) NOT NULL DEFAULT '20',
265 `Speed` smallint(11) NOT NULL DEFAULT '150',
266 `isNeutral` enum('0','1') NOT NULL DEFAULT '1',
267 `LaserId` tinyint(1) NOT NULL DEFAULT '0',
268 `Lasers` bigint(255) NOT NULL,
269 `Generators` bigint(255) NOT NULL,
270 `Batteries` bigint(255) NOT NULL,
271 `Rockets` bigint(255) NOT NULL,
272 `Extra` int(11) NOT NULL,
273 `Cargo` bigint(255) NOT NULL,
274 PRIMARY KEY (`Id`)
275) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=99 ;
276
277--
278-- Data dump for tabellen `ships`
279--
280
281INSERT INTO `ships` (`Id`, `Name`, `type`, `Costs`, `HP`, `MaxNanohull`, `Shield`, `shieldAbsorb`, `Damage`, `Speed`, `isNeutral`, `LaserId`, `Lasers`, `Generators`, `Batteries`, `Rockets`, `Extra`, `Cargo`) VALUES
282(23, '..::{ Boss Streuner }::..', '', -1, 3200, 0, 1600, 60, 80, 250, '1', 0, 0, 0, 0, 0, 0, 0),
283(71, '-=[ Lordakia ]=-', '', -1, 2000, 0, 2000, 60, 80, 320, '0', 0, 0, 0, 0, 0, 0, 0),
284(84, '-=[ Streuner ]=-', '', -1, 800, 0, 400, 60, 20, 270, '1', 0, 0, 0, 0, 0, 0, 0),
285(72, '-=[ Devolarium ]=-', '', -1, 100000, 0, 100000, 60, 1000, 200, '0', 0, 0, 0, 0, 0, 0, 0),
286(1, 'Phoenix', 'ship_phoenix', 0, 4000, 4000, 0, 0, 0, 320, '1', 0, 0, 0, 0, 0, 0, 0),
287(2, 'Yamato', 'ship_yamato', 0, 8000, 8000, 0, 0, 0, 340, '1', 0, 0, 0, 0, 0, 0, 0),
288(3, 'Leonov', 'ship_leonov', 0, 64000, 64000, 0, 0, 0, 360, '1', 0, 0, 0, 0, 0, 0, 0),
289(4, 'Defcom', 'ship_defcom', 0, 12000, 12000, 0, 0, 0, 280, '1', 0, 0, 0, 0, 0, 0, 0),
290(5, 'Liberator', 'ship_liberator', 0, 16000, 16000, 0, 0, 0, 300, '1', 0, 0, 0, 0, 0, 0, 0),
291(6, 'Piranha', 'ship_piranha', 0, 64000, 64000, 0, 0, 0, 360, '1', 0, 0, 0, 0, 0, 0, 0),
292(7, 'Nostromo', 'ship_nostromo', 0, 120000, 120000, 0, 0, 0, 340, '1', 0, 0, 0, 0, 0, 0, 0),
293(8, 'Vengeance', 'ship_vengeance', 0, 180000, 180000, 0, 0, 0, 380, '1', 0, 0, 0, 0, 0, 0, 0),
294(9, 'Bigboy', 'ship_bigboy', 0, 160000, 160000, 0, 0, 0, 260, '1', 0, 0, 0, 0, 0, 0, 0),
295(10, 'Goliath', 'ship_goliath', 0, 256000, 256000, 0, 0, 0, 300, '1', 0, 0, 0, 0, 0, 0, 0),
296(98, 'PoliceShip', 'ship_police', 0, 20000000, 20000000, 0, 0, 0, 700, '1', 0, 0, 0, 0, 0, 0, 0);
297
298-- --------------------------------------------------------
299
300--
301-- Struktur-dump for tabellen `ships_designs`
302--
303
304CREATE TABLE IF NOT EXISTS `ships_designs` (
305 `Id` smallint(11) NOT NULL AUTO_INCREMENT,
306 `ShipId` smallint(11) NOT NULL,
307 `Name` varchar(255) NOT NULL DEFAULT '',
308 `type` varchar(255) NOT NULL DEFAULT '',
309 PRIMARY KEY (`Id`)
310) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=111 ;
311
312--
313-- Data dump for tabellen `ships_designs`
314--
315
316INSERT INTO `ships_designs` (`Id`, `ShipId`, `Name`, `type`) VALUES
317(16, 8, 'Vengeance Adept', 'ship_vengeance_design_adept'),
318(17, 8, 'Vengeance Corsair', 'ship_vengeance_design_corsair'),
319(18, 8, 'Vengeance Skill Design Lightning', 'ship_vengeance_design_lightning'),
320(19, 10, 'Goliath Jade', 'ship_goliath_design_jade'),
321(52, 10, 'Goliath Orange / Amber', 'ship_goliath_design_amber'),
322(53, 10, 'Goliath Red (Crimson)', 'ship_goliath_design_crimson'),
323(54, 10, 'Goliath Blue / Sapphire', 'ship_goliath_design_sapphire'),
324(56, 10, 'Goliath Black (Enforcer)', 'ship_goliath_design_enforcer'),
325(57, 10, 'Goliath Stars and Stripes', 'ship_goliath_design_independence'),
326(58, 8, 'Vengeance Revenge', 'ship_vengeance_design_revenge'),
327(59, 10, 'Goliath Bastion', 'ship_goliath_design_bastion'),
328(60, 8, 'Vengeance Avenger', 'ship_vengeance_design_avenger'),
329(61, 10, 'Goliath Veteran', 'ship_goliath_design_veteran'),
330(62, 10, 'Goliath Exalted', 'ship_goliath_design_exalted'),
331(63, 10, 'Skill Design 1 - Solace', 'ship_goliath_design_solace'),
332(64, 10, 'Skill Design 2 - Diminisher', 'ship_goliath_design_diminisher'),
333(65, 10, 'Skill Design 3 - Spectrum', 'ship_goliath_design_spectrum'),
334(66, 10, 'Skill Design 4 - Sentinel', 'ship_goliath_design_sentinel'),
335(67, 10, 'Skill Design 5 - Venom', 'ship_goliath_design_venom'),
336(68, 10, 'Goliath Ignite', 'ship_goliath_design_ignite'),
337(86, 10, 'Goliath Kick', 'ship_goliath_design_kick'),
338(87, 10, 'Goliath Referee', 'ship_goliath_design_referee'),
339(88, 10, 'Goliath Goal', 'ship_goliath_design_goal'),
340(109, 10, 'Goliath Saturn', 'ship_goliath_design_saturn'),
341(110, 10, 'Goliath Centaur', 'ship_goliath_design_centaur');
342
343-- --------------------------------------------------------
344
345--
346-- Struktur-dump for tabellen `users`
347--
348
349CREATE TABLE IF NOT EXISTS `users` (
350 `ID` int(255) NOT NULL AUTO_INCREMENT,
351 `Email` varchar(255) NOT NULL DEFAULT '',
352 `Name` varchar(255) NOT NULL DEFAULT '',
353 `pwHash` varchar(255) NOT NULL DEFAULT '',
354 `Servers` text NOT NULL,
355 `sessionId` bigint(20) NOT NULL DEFAULT '0',
356 PRIMARY KEY (`ID`)
357) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
358
359--
360-- Data dump for tabellen `users`
361--
362
363INSERT INTO `users` (`ID`, `Email`, `Name`, `pwHash`, `Servers`, `sessionId`) VALUES
364
365/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
366/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
367/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;