24 | | function check_cap_industrial() |
25 | | { |
26 | | $qry = new DBQuery(); |
27 | | $query = 'select count(*) as cnt from kb3_ship_classes where scl_class="Cap. Industrial";'; |
28 | | $result = $qry->execute($query); |
29 | | if ($result['cnt'] == 1) |
30 | | { |
31 | | return; |
32 | | } |
33 | | $queries = "INSERT IGNORE INTO kb3_ship_classes(scl_id,scl_class,scl_value,scl_points) values ('','Cap. Industrial','1850000000','5000'); |
34 | | INSERT IGNORE INTO kb3_ships(shp_id,shp_name,shp_class,shp_externalid,shp_rce_id,shp_baseprice,shp_techlevel) values ('','Rorqual','','28352','0','1850000000','1'); |
35 | | UPDATE kb3_ships set kb3_ships.shp_class=(select scl_id from kb3_ship_classes where scl_class='Cap. Industrial') where kb3_ships.shp_name='Rorqual'; |
36 | | INSERT IGNORE INTO kb3_ships_values(shp_id,shp_value) values ((select kb3_ships.shp_id from kb3_ships where kb3_ships.shp_name='Rorqual'),'1850000000');"; |
37 | | $query = explode("\n", $queries); |
38 | | foreach ($query as $querystring) |
39 | | { |
40 | | if ($string = trim(str_replace(');', ')', $querystring))) |
41 | | { |
42 | | $qry->execute($string); |
43 | | } |
44 | | } |
45 | | } |
46 | | |
47 | | function check_navigationtable(){ |
48 | | if (CORP_ID) |
49 | | { |
50 | | $statlink = '?a=corp_detail&crp_id='.CORP_ID; |
51 | | } |
52 | | elseif (ALLIANCE_ID) |
53 | | { |
54 | | $statlink = '?a=alliance_detail&all_id='.ALLIANCE_ID; |
55 | | } |
56 | | $qry = new DBQuery(); |
57 | | $query = 'select count(*) from kb3_navigation'; |
58 | | $result = mysql_query($query); |
59 | | if ($result) |
60 | | { |
61 | | $query = "select hidden from kb3_navigation limit 1"; |
62 | | $result = @mysql_query($query); |
63 | | if (!$result) |
64 | | { |
65 | | $qry->execute("ALTER TABLE `kb3_navigation` ADD `hidden` BOOL NOT NULL DEFAULT '0' AFTER `page` ;"); |
66 | | } |
67 | | $query = "select count(KBSITE) from kb3_navigation WHERE KBSITE = '".KB_SITE."'"; |
68 | | $result = @mysql_query($query); |
69 | | if ($result) |
70 | | { |
71 | | $row = mysql_fetch_row($result); |
72 | | if ($row[0] == 0) |
73 | | { |
74 | | $queries = "INSERT IGNORE INTO `kb3_navigation` (`nav_type`,`intern`,`descr` ,`url` ,`target`,`posnr`,`page` ,`hidden`,`KBSITE`) VALUES ('top',1,'Home','?a=home','_self',1,'ALL_PAGES',0,'".KB_SITE."'); |
75 | | INSERT IGNORE INTO `kb3_navigation` (`nav_type`,`intern`,`descr` ,`url` ,`target`,`posnr` ,`page`,`hidden`,`KBSITE`) VALUES ('top',1,'Campaigns','?a=campaigns','_self',2,'ALL_PAGES',0,'".KB_SITE."'); |
76 | | INSERT IGNORE INTO `kb3_navigation` (`nav_type`,`intern`,`descr` ,`url` ,`target`,`posnr` ,`page`,`hidden`,`KBSITE`) VALUES ('top',1,'Contracts','?a=contracts','_self',3,'ALL_PAGES',0,'".KB_SITE."'); |
77 | | INSERT IGNORE INTO `kb3_navigation` (`nav_type`,`intern`,`descr` ,`url` ,`target`,`posnr` ,`page`,`hidden`,`KBSITE`) VALUES ('top',1,'Kills','?a=kills','_self',4,'ALL_PAGES',0,'".KB_SITE."'); |
78 | | INSERT IGNORE INTO `kb3_navigation` (`nav_type`,`intern`,`descr` ,`url` ,`target`,`posnr` ,`page`,`hidden`,`KBSITE`) VALUES ('top',1,'Losses','?a=losses','_self',5,'ALL_PAGES',0,'".KB_SITE."'); |
79 | | INSERT IGNORE INTO `kb3_navigation` (`nav_type`,`intern`,`descr` ,`url` ,`target`,`posnr` ,`page`,`hidden`,`KBSITE`) VALUES ('top',1,'Post Mail','?a=post','_self',6,'ALL_PAGES',0,'".KB_SITE."'); |
80 | | INSERT IGNORE INTO `kb3_navigation` (`nav_type`,`intern`,`descr` ,`url` ,`target`,`posnr` ,`page`,`hidden`,`KBSITE`) VALUES ('top',1,'Stats','$statlink','_self',7,'ALL_PAGES',0,'".KB_SITE."'); |
81 | | INSERT IGNORE INTO `kb3_navigation` (`nav_type`,`intern`,`descr` ,`url` ,`target`,`posnr` ,`page`,`hidden`,`KBSITE`) VALUES ('top',1,'Awards','?a=awards','_self',8,'ALL_PAGES',0,'".KB_SITE."'); |
82 | | INSERT IGNORE INTO `kb3_navigation` (`nav_type`,`intern`,`descr` ,`url` ,`target`,`posnr` ,`page`,`hidden`,`KBSITE`) VALUES ('top',1,'Standings','?a=standings','_self',9,'ALL_PAGES',0,'".KB_SITE."'); |
83 | | INSERT IGNORE INTO `kb3_navigation` (`nav_type`,`intern`,`descr` ,`url` ,`target`,`posnr` ,`page`,`hidden`,`KBSITE`) VALUES ('top',1,'Search','?a=search','_self',10,'ALL_PAGES',0,'".KB_SITE."'); |
84 | | INSERT IGNORE INTO `kb3_navigation` (`nav_type`,`intern`,`descr` ,`url` ,`target`,`posnr` ,`page`,`hidden`,`KBSITE`) VALUES ('top',1,'Admin','?a=admin','_self',11,'ALL_PAGES',0,'".KB_SITE."'); |
85 | | INSERT IGNORE INTO `kb3_navigation` (`nav_type`,`intern`,`descr` ,`url` ,`target`,`posnr` ,`page`,`hidden`,`KBSITE`) VALUES ('top',1,'About','?a=about','_self',12,'ALL_PAGES',0,'".KB_SITE."');"; |
86 | | $query = explode("\n", $queries); |
87 | | foreach ($query as $querystring) |
88 | | { |
89 | | if ($string = trim(str_replace(');', ')', $querystring))) |
90 | | { |
91 | | $qry->execute($string); |
92 | | } |
93 | | } |
94 | | } |
95 | | return; |
96 | | } |
97 | | $query = 'ALTER TABLE `kb3_navigation` ADD `KBSITE` VARCHAR( 16 ) NOT NULL'; |
98 | | $qry->execute($query); |
99 | | $query = 'UPDATE `kb3_navigation` SET KBSITE = "'.KB_SITE.'" WHERE KBSITE LIKE "";'; |
100 | | $qry->execute($query); |
101 | | return; |
102 | | }else{ |
103 | | $query = 'CREATE TABLE `kb3_navigation` ( |
104 | | `ID` INT NOT NULL AUTO_INCREMENT , |
105 | | `nav_type` TINYTEXT NOT NULL, |
106 | | `intern` INT ( 1 ) NOT NULL, |
107 | | `descr` TINYTEXT NOT NULL , |
108 | | `url` TINYTEXT NOT NULL , |
109 | | `target` VARCHAR( 10 ) NOT NULL, |
110 | | `posnr` INT NOT NULL, |
111 | | `page` TINYTEXT NOT NULL, |
112 | | `hidden` BOOL NOT NULL DEFAULT "0", |
113 | | `KBSITE` VARCHAR ( 16 ) NOT NULL, |
114 | | PRIMARY KEY ( `ID` ) |
115 | | ) TYPE = MYISAM;'; |
116 | | $qry->execute($query); |
117 | | $queries = "INSERT IGNORE INTO `kb3_navigation` VALUES (1,'top',1,'Home','?a=home','_self',1,'ALL_PAGES',0,'".KB_SITE."'); |
118 | | INSERT IGNORE INTO `kb3_navigation` VALUES (2,'top',1,'Campaigns','?a=campaigns','_self',2,'ALL_PAGES',0,'".KB_SITE."'); |
119 | | INSERT IGNORE INTO `kb3_navigation` VALUES (3,'top',1,'Contracts','?a=contracts','_self',3,'ALL_PAGES',0,'".KB_SITE."'); |
120 | | INSERT IGNORE INTO `kb3_navigation` VALUES (4,'top',1,'Kills','?a=kills','_self',4,'ALL_PAGES',0,'".KB_SITE."'); |
121 | | INSERT IGNORE INTO `kb3_navigation` VALUES (5,'top',1,'Losses','?a=losses','_self',5,'ALL_PAGES',0,'".KB_SITE."'); |
122 | | INSERT IGNORE INTO `kb3_navigation` VALUES (6,'top',1,'Post Mail','?a=post','_self',6,'ALL_PAGES',0,'".KB_SITE."'); |
123 | | INSERT IGNORE INTO `kb3_navigation` VALUES (7,'top',1,'Stats','$statlink','_self',7,'ALL_PAGES',0,'".KB_SITE."'); |
124 | | INSERT IGNORE INTO `kb3_navigation` VALUES (8,'top',1,'Awards','?a=awards','_self',8,'ALL_PAGES',0,'".KB_SITE."'); |
125 | | INSERT IGNORE INTO `kb3_navigation` VALUES (9,'top',1,'Standings','?a=standings','_self',9,'ALL_PAGES',0,'".KB_SITE."'); |
126 | | INSERT IGNORE INTO `kb3_navigation` VALUES (10,'top',1,'Search','?a=search','_self',10,'ALL_PAGES',0,'".KB_SITE."'); |
127 | | INSERT IGNORE INTO `kb3_navigation` VALUES (11,'top',1,'Admin','?a=admin','_self',11,'ALL_PAGES',0,'".KB_SITE."'); |
128 | | INSERT IGNORE INTO `kb3_navigation` VALUES (12,'top',1,'About','?a=about','_self',12,'ALL_PAGES',0,'".KB_SITE."');"; |
129 | | $query = explode("\n", $queries); |
130 | | foreach ($query as $querystring) |
131 | | { |
132 | | if ($string = trim(str_replace(');', ')', $querystring))) |
133 | | { |
134 | | $qry->execute($string); |
135 | | } |
136 | | } |
137 | | } |
138 | | } |
139 | | |
140 | | function check_commenttablerow() |
141 | | { |
142 | | $qry = new DBQuery(); |
143 | | $query = 'select posttime from kb3_comments limit 1'; |
144 | | $result = mysql_query($query); |
145 | | if ($result) |
146 | | { |
147 | | $query = 'ALTER TABLE `kb3_comments` CHANGE `ID` `id` INT( 11 ) NOT NULL AUTO_INCREMENT'; |
148 | | $qry->execute($query); |
149 | | return; |
150 | | } |
151 | | $query = 'ALTER TABLE `kb3_comments` ADD `posttime` TIMESTAMP DEFAULT \'0000-00-00 00:00:00\' NOT NULL'; |
152 | | $qry->execute($query); |
153 | | } |
154 | | |
155 | | function check_shipvaltable() |
156 | | { |
157 | | $qry = new DBQuery(); |
158 | | $query = 'select count(*) from kb3_ships_values'; |
159 | | $result = mysql_query($query); |
160 | | if ($result) |
161 | | { |
162 | | return; |
163 | | } |
164 | | $query = 'CREATE TABLE `kb3_ships_values` ( |
165 | | `shp_id` INT( 11 ) NOT NULL , |
166 | | `shp_value` BIGINT( 4 ) NOT NULL , |
167 | | PRIMARY KEY ( `shp_id` ) |
168 | | ) TYPE = MYISAM ;'; |
169 | | $qry->execute($query); |
170 | | $qry->execute('UPDATE kb3_ships set shp_class = 8 WHERE shp_id=257 limit 1'); |
171 | | $qry->execute('UPDATE kb3_ships set shp_class = 8 WHERE shp_id=252 limit 1'); |
172 | | $qry->execute('UPDATE kb3_ships set shp_class = 4 WHERE shp_id=266 limit 1'); |
173 | | $qry->execute('UPDATE kb3_ships set shp_class = 4 WHERE shp_id=275 limit 1'); |
174 | | $qry->execute('UPDATE kb3_ships set shp_class = 4 WHERE shp_id=272 limit 1'); |
175 | | $qry->execute('UPDATE kb3_ships set shp_class = 4 WHERE shp_id=246 limit 1'); |
176 | | $qry->execute('UPDATE kb3_ships set shp_class = 4 WHERE shp_id=249 limit 1'); |
177 | | $qry->execute('UPDATE kb3_ships set shp_techlevel = 2 where shp_class = 22'); |
178 | | } |
179 | | |
180 | | function check_invdetail() |
181 | | { |
182 | | $qry = new DBQuery(); |
183 | | $query = 'select ind_sec_status from kb3_inv_detail limit 1'; |
184 | | $qry->execute($query); |
185 | | $len = mysql_field_len($qry->resid_,0); |
186 | | if ($len == 4) |
187 | | { |
188 | | $query = 'ALTER TABLE `kb3_inv_detail` CHANGE `ind_sec_status` `ind_sec_status` VARCHAR(5)'; |
189 | | $qry->execute($query); |
190 | | } |
191 | | } |
192 | | |
193 | | function check_pilots() |
194 | | { |
195 | | $qry = new DBQuery(); |
196 | | $query = 'select plt_name from kb3_pilots limit 1'; |
197 | | $qry->execute($query); |
198 | | $len = mysql_field_len($qry->resid_,0); |
199 | | if ($len == 32) |
200 | | { |
201 | | $query = 'ALTER TABLE `kb3_pilots` CHANGE `plt_name` `plt_name` VARCHAR(64) NOT NULL'; |
202 | | $qry->execute($query); |
203 | | } |
204 | | } |
205 | | |
206 | | function check_contracts() |
207 | | { |
208 | | $qry = new DBQuery(); |
209 | | $query = 'select ctd_sys_id from kb3_contract_details limit 1'; |
210 | | $result = mysql_query($query); |
211 | | if ($result) |
212 | | { |
213 | | return; |
214 | | } |
215 | | $qry->execute('ALTER TABLE `kb3_contract_details` ADD `ctd_sys_id` INT(11) NOT NULL DEFAULT \'0\''); |
216 | | |
217 | | $qry->execute('SHOW columns from `kb3_contract_details` like \'ctd_ctr_id\''); |
218 | | $arr = $qry->getRow(); |
219 | | if ($arr['Key'] == 'PRI') |
220 | | { |
221 | | return; |
222 | | } |
223 | | $qry->execute('ALTER TABLE `kb3_contract_details` ADD INDEX (`ctd_ctr_id`) '); |
224 | | } |
225 | | function check_index() |
226 | | { |
227 | | check_index_invcrp(); |
228 | | check_index_invall(); |
229 | | $qry = new DBQuery(); |
230 | | $qry->execute('SHOW columns from kb3_item_types like \'itt_id\''); |
231 | | $arr = $qry->getRow(); |
232 | | if ($arr['Key'] == 'PRI') |
233 | | { |
234 | | return; |
235 | | } |
236 | | $qry->execute('ALTER TABLE `kb3_item_types` ADD PRIMARY KEY ( `itt_id` ) '); |
237 | | } |
238 | | function check_index_invcrp() |
239 | | { |
240 | | $qry = new DBQuery(); |
241 | | $qry->execute('SHOW columns from kb3_inv_crp like \'inc_kll_id\''); |
242 | | $arr = $qry->getRow(); |
243 | | if ($arr['Key'] == 'MUL') |
244 | | { |
245 | | return; |
246 | | } |
247 | | $qry->execute('ALTER TABLE `kb3_inv_crp` ADD INDEX ( `inc_kll_id` ) '); |
248 | | } |
249 | | function check_index_invall() |
250 | | { |
251 | | $qry = new DBQuery(); |
252 | | $qry->execute('SHOW columns from kb3_inv_all like \'ina_kll_id\''); |
253 | | $arr = $qry->getRow(); |
254 | | if ($arr['Key'] == 'MUL') |
255 | | { |
256 | | return; |
257 | | } |
258 | | $qry->execute('ALTER TABLE `kb3_inv_all` ADD INDEX ( `ina_kll_id` ) '); |
259 | | } |
260 | | function check_tblstrct1() |
261 | | { |
262 | | $qry = new DBQuery(); |
263 | | $query = 'select shp_description from kb3_ships limit 1'; |
264 | | $result = mysql_query($query); |
265 | | if (!$result) |
266 | | { |
267 | | return; |
268 | | } |
269 | | $query = 'ALTER TABLE `kb3_ships` DROP `shp_description`'; |
270 | | $qry->execute($query); |
271 | | } |
272 | | function check_tblstrct2() |
273 | | { |
274 | | $qry = new DBQuery(); |
275 | | $query = 'select itm_description from kb3_items limit 1'; |
276 | | $result = mysql_query($query); |
277 | | if (!$result) |
278 | | { |
279 | | return; |
280 | | } |
281 | | $query = 'ALTER TABLE `kb3_items` DROP `itm_description`'; |
282 | | $qry->execute($query); |
283 | | } |
284 | | function check_tblstrct3() |
285 | | { |
286 | | $qry = new DBQuery(); |
287 | | $query = 'select Value from kb3_items limit 1'; |
288 | | $result = mysql_query($query); |
289 | | if ($result) |
290 | | { |
291 | | $query = 'ALTER TABLE `kb3_items` CHANGE `Value` `itm_value` INT( 11 ) NOT NULL DEFAULT \'0\''; |
292 | | $qry->execute($query); |
293 | | } |
294 | | } |
295 | | function check_tblstrct4() |
296 | | { |
297 | | $qry = new DBQuery(); |
298 | | $query = 'select itm_value from kb3_items limit 1'; |
299 | | $result = mysql_query($query); |
300 | | if ($result) |
301 | | { |
302 | | return; |
303 | | } |
304 | | $query = 'ALTER TABLE `kb3_items` ADD `itm_value` INT( 11 ) NOT NULL DEFAULT \'0\''; |
305 | | $qry->execute($query); |
306 | | $qry->execute('ALTER TABLE `kb3_items` CHANGE `itm_externalid` `itm_externalid` INT( 11 ) NOT NULL DEFAULT \'0\''); |
307 | | } |
308 | | |
309 | | function check_tblstrct5() |
310 | | { |
311 | | $qry = new DBQuery(); |
312 | | $query = 'select count(*) from kb3_standings'; |
313 | | $result = mysql_query($query); |
314 | | if ($result) |
315 | | { |
316 | | $query = 'select count(*) from kb3_standings where sta_from=1 and sta_to=1 and sta_from_type=\'a\' and |
317 | | sta_to_type=\'c\''; |
318 | | $result = mysql_query($query); |
319 | | if ($result) |
320 | | { |
321 | | return; |
322 | | } |
323 | | $qry->execute('drop table kb3_standings'); |
324 | | } |
325 | | $query = 'CREATE TABLE `kb3_standings` ( |
326 | | `sta_from` int(11) NOT NULL default \'0\', |
327 | | `sta_to` int(11) NOT NULL default \'0\', |
328 | | `sta_from_type` enum(\'a\',\'c\') NOT NULL default \'a\', |
329 | | `sta_to_type` enum(\'a\',\'c\') NOT NULL default \'a\', |
330 | | `sta_value` float NOT NULL default \'0\', |
331 | | `sta_comment` varchar(200) NOT NULL, |
332 | | KEY `sta_from` (`sta_from`) |
333 | | ) TYPE=MyISAM;'; |
334 | | $qry->execute($query); |
335 | | } |
336 | | |
337 | | function chk_kb3_items() |
338 | | { |
339 | | $qry = new DBQuery(); |
340 | | $query = 'select count(*) from kb3_item_types where itt_id = 787'; |
341 | | $result = mysql_query($query); |
342 | | $result = mysql_fetch_array($result); |
343 | | if ($result['cnt'] == 1) |
344 | | { |
345 | | return; |
346 | | } |
347 | | $queries = " |
348 | | INSERT IGNORE INTO `kb3_item_types` VALUES (737, 'Gas Cloud Harvester',1); |
349 | | INSERT IGNORE INTO `kb3_item_types` VALUES (762, 'Inertia Stabilizer',3); |
350 | | INSERT IGNORE INTO `kb3_item_types` VALUES (763, 'Nanofiber Internal Structure',3); |
351 | | INSERT IGNORE INTO `kb3_item_types` VALUES (764, 'Overdrive Injector System',3); |
352 | | INSERT IGNORE INTO `kb3_item_types` VALUES (765, 'Expanded Cargohold',3); |
353 | | INSERT IGNORE INTO `kb3_item_types` VALUES (766, 'Power Diagnostic System',3); |
354 | | INSERT IGNORE INTO `kb3_item_types` VALUES (767, 'Capacitor Power Relay',3); |
355 | | INSERT IGNORE INTO `kb3_item_types` VALUES (768, 'Capacitor Flux Coil',3); |
356 | | INSERT IGNORE INTO `kb3_item_types` VALUES (769, 'Reactor Control Unit',3); |
357 | | INSERT IGNORE INTO `kb3_item_types` VALUES (770, 'Shield Flux Coil',3); |
358 | | INSERT IGNORE INTO `kb3_item_types` VALUES (771, 'Missile Launcher Heavy Assault',1); |
359 | | INSERT IGNORE INTO `kb3_item_types` VALUES (738, 'Cyber Armor', 0); |
360 | | INSERT IGNORE INTO `kb3_item_types` VALUES (740, 'Cyber Electronics', 0); |
361 | | INSERT IGNORE INTO `kb3_item_types` VALUES (741, 'Cyber Engineering', 0); |
362 | | INSERT IGNORE INTO `kb3_item_types` VALUES (742, 'Cyber Gunnery', 0); |
363 | | INSERT IGNORE INTO `kb3_item_types` VALUES (743, 'Cyber Industry', 0); |
364 | | INSERT IGNORE INTO `kb3_item_types` VALUES (744, 'Cyber Leadership', 0); |
365 | | INSERT IGNORE INTO `kb3_item_types` VALUES (745, 'Cyber Learning', 0); |
366 | | INSERT IGNORE INTO `kb3_item_types` VALUES (746, 'Cyber Missile', 0); |
367 | | INSERT IGNORE INTO `kb3_item_types` VALUES (747, 'Cyber Navigation', 0); |
368 | | INSERT IGNORE INTO `kb3_item_types` VALUES (748, 'Cyber Science', 0); |
369 | | INSERT IGNORE INTO `kb3_item_types` VALUES (749, 'Cyber Shields', 0); |
370 | | INSERT IGNORE INTO `kb3_item_types` VALUES (772, 'Assault Missile', 0); |
371 | | INSERT IGNORE INTO `kb3_item_types` VALUES (773, 'Rig Armor', 5); |
372 | | INSERT IGNORE INTO `kb3_item_types` VALUES (774, 'Rig Shield', 5); |
373 | | INSERT IGNORE INTO `kb3_item_types` VALUES (775, 'Rig Energy Weapon', 5); |
374 | | INSERT IGNORE INTO `kb3_item_types` VALUES (776, 'Rig Hybrid Weapon', 5); |
375 | | INSERT IGNORE INTO `kb3_item_types` VALUES (777, 'Rig Projectile Weapon', 5); |
376 | | INSERT IGNORE INTO `kb3_item_types` VALUES (778, 'Rig Drones', 5); |
377 | | INSERT IGNORE INTO `kb3_item_types` VALUES (779, 'Rig Launcher', 5); |
378 | | INSERT IGNORE INTO `kb3_item_types` VALUES (780, 'Rig Electronics', 5); |
379 | | INSERT IGNORE INTO `kb3_item_types` VALUES (781, 'Rig Energy Grid', 5); |
380 | | INSERT IGNORE INTO `kb3_item_types` VALUES (782, 'Rig Astronautic', 5); |
381 | | INSERT IGNORE INTO `kb3_item_types` VALUES (783, 'Cyber X Specials', 0); |
382 | | INSERT IGNORE INTO `kb3_item_types` VALUES (785, 'Script', 0); |
383 | | INSERT IGNORE INTO `kb3_item_types` VALUES (786, 'Rig Electronics Superiority', 5); |
384 | | INSERT IGNORE INTO `kb3_item_types` VALUES (722, 'Advanced Hybrid Ammo Blueprint', 0); |
385 | | INSERT IGNORE INTO `kb3_item_types` VALUES (723, 'Tractor Beam Blueprint', 0); |
386 | | INSERT IGNORE INTO `kb3_item_types` VALUES (724, 'Implant Blueprints', 0); |
387 | | INSERT IGNORE INTO `kb3_item_types` VALUES (725, 'Advanced Projectile Ammo Blueprint', 0); |
388 | | INSERT IGNORE INTO `kb3_item_types` VALUES (726, 'Advanced Frequency Crystal Blueprint', 0); |
389 | | INSERT IGNORE INTO `kb3_item_types` VALUES (727, 'Mining Crystal Blueprint', 0); |
390 | | INSERT IGNORE INTO `kb3_item_types` VALUES (728, 'Decryptors - Amarr', 0); |
391 | | INSERT IGNORE INTO `kb3_item_types` VALUES (729, 'Decryptors - Minmatar', 0); |
392 | | INSERT IGNORE INTO `kb3_item_types` VALUES (730, 'Decryptors - Gallente', 0); |
393 | | INSERT IGNORE INTO `kb3_item_types` VALUES (731, 'Decryptors - Caldari', 0); |
394 | | INSERT IGNORE INTO `kb3_item_types` VALUES (732, 'Decryptors - Sleepers', 0); |
395 | | INSERT IGNORE INTO `kb3_item_types` VALUES (733, 'Decryptors - Yan Jung', 0); |
396 | | INSERT IGNORE INTO `kb3_item_types` VALUES (734, 'Decryptors - Takmahl', 0); |
397 | | INSERT IGNORE INTO `kb3_item_types` VALUES (735, 'Decryptors - Talocan', 0); |
398 | | INSERT IGNORE INTO `kb3_item_types` VALUES (754, 'Salvaged Materials', 0); |
399 | | INSERT IGNORE INTO `kb3_item_types` VALUES (784, 'Large Collidable Ship', 0); |
400 | | INSERT IGNORE INTO `kb3_item_types` VALUES (787, 'Rig Blueprint', 0); |
401 | | "; |
402 | | $query = explode("\n", $queries); |
403 | | foreach ($query as $querystring) |
404 | | { |
405 | | if ($string = trim(str_replace(');', ')', $querystring))) |
406 | | { |
407 | | $qry->execute($string); |
408 | | } |
409 | | } |
410 | | } |
411 | | function chk_kb3_items2() |
412 | | { |
413 | | $qry = new DBQuery(); |
414 | | $query = 'select itm_externalid from kb3_items where itm_name = \'Repair Drone\''; |
415 | | $result = mysql_query($query); |
416 | | $result = mysql_fetch_array($result); |
417 | | if ($result['itm_externalid'] == '9871') |
418 | | { |
419 | | return; |
420 | | } |
421 | | $queries = " |
422 | | update kb3_items set itm_externalid='10246' where itm_name='Mining Drone I'; |
423 | | update kb3_items set itm_externalid='10248' where itm_name='Mining Drone - Improved UNUSED'; |
424 | | update kb3_items set itm_externalid='10250' where itm_name='Mining Drone II'; |
425 | | update kb3_items set itm_externalid='1187' where itm_name='Mining Drone - Elite'; |
426 | | update kb3_items set itm_externalid='1201' where itm_name='Proximity Drone'; |
427 | | update kb3_items set itm_externalid='1202' where itm_name='Wasp I'; |
428 | | update kb3_items set itm_externalid='15508' where itm_name='Civilian Mining Drone'; |
429 | | update kb3_items set itm_externalid='15510' where itm_name='Vespa I'; |
430 | | update kb3_items set itm_externalid='16206' where itm_name='Valkyrie I'; |
431 | | update kb3_items set itm_externalid='17565' where itm_name='Hellhound I'; |
432 | | update kb3_items set itm_externalid='21050' where itm_name='Unanchoring Drone'; |
433 | | update kb3_items set itm_externalid='21638' where itm_name='Survey Drone'; |
434 | | update kb3_items set itm_externalid='21640' where itm_name='Vespa II'; |
435 | | update kb3_items set itm_externalid='2173' where itm_name='Valkyrie II'; |
436 | | update kb3_items set itm_externalid='2175' where itm_name='Infiltrator I'; |
437 | | update kb3_items set itm_externalid='2183' where itm_name='Infiltrator II'; |
438 | | update kb3_items set itm_externalid='2185' where itm_name='Hammerhead I'; |
439 | | update kb3_items set itm_externalid='2193' where itm_name='Hammerhead II'; |
440 | | update kb3_items set itm_externalid='2195' where itm_name='Praetor I'; |
441 | | update kb3_items set itm_externalid='2203' where itm_name='Praetor II'; |
442 | | update kb3_items set itm_externalid='2205' where itm_name='Acolyte I'; |
443 | | update kb3_items set itm_externalid='2205' where itm_name='Acolyte II'; |
444 | | update kb3_items set itm_externalid='22572' where itm_name='Praetor EV-900'; |
445 | | update kb3_items set itm_externalid='22574' where itm_name='Warp Scrambling Drone'; |
446 | | update kb3_items set itm_externalid='22713' where itm_name='10mn webscramblifying Drone'; |
447 | | update kb3_items set itm_externalid='22765' where itm_name='Heavy Shield Maintenance Bot I'; |
448 | | update kb3_items set itm_externalid='22780' where itm_name='Fighter Uno'; |
449 | | update kb3_items set itm_externalid='23055' where itm_name='Templar'; |
450 | | update kb3_items set itm_externalid='23057' where itm_name='Dragonfly'; |
451 | | update kb3_items set itm_externalid='23059' where itm_name='Firbolg'; |
452 | | update kb3_items set itm_externalid='23061' where itm_name='Einherji'; |
453 | | update kb3_items set itm_externalid='23473' where itm_name='Wasp EC-900'; |
454 | | update kb3_items set itm_externalid='23506' where itm_name='Ogre SD-900'; |
455 | | update kb3_items set itm_externalid='23510' where itm_name='Praetor TD-900'; |
456 | | update kb3_items set itm_externalid='23512' where itm_name='Berserker TP-900'; |
457 | | update kb3_items set itm_externalid='23523' where itm_name='Heavy Armor Maintenance Bot I'; |
458 | | update kb3_items set itm_externalid='23525' where itm_name='Curator I'; |
459 | | update kb3_items set itm_externalid='23559' where itm_name='Berserker SW-900'; |
460 | | update kb3_items set itm_externalid='23559' where itm_name='Warden I'; |
461 | | update kb3_items set itm_externalid='23561' where itm_name='Garde I'; |
462 | | update kb3_items set itm_externalid='23563' where itm_name='Bouncer I'; |
463 | | update kb3_items set itm_externalid='23659' where itm_name='Acolyte EV-300'; |
464 | | update kb3_items set itm_externalid='23702' where itm_name='Infiltrator EV-600'; |
465 | | update kb3_items set itm_externalid='23705' where itm_name='Vespa EC-600'; |
466 | | update kb3_items set itm_externalid='23707' where itm_name='Hornet EC-300'; |
467 | | update kb3_items set itm_externalid='23709' where itm_name='Medium Armor Maintenance Bot I'; |
468 | | update kb3_items set itm_externalid='23711' where itm_name='Light Armor Maintenance Bot I'; |
469 | | update kb3_items set itm_externalid='23713' where itm_name='Hammerhead SD-600'; |
470 | | update kb3_items set itm_externalid='23715' where itm_name='Hobgoblin SD-300'; |
471 | | update kb3_items set itm_externalid='23717' where itm_name='Medium Shield Maintenance Bot I'; |
472 | | update kb3_items set itm_externalid='23719' where itm_name='Light Shield Maintenance Bot I'; |
473 | | update kb3_items set itm_externalid='23721' where itm_name='Valkyrie TP-600'; |
474 | | update kb3_items set itm_externalid='23723' where itm_name='Warrior TP-300'; |
475 | | update kb3_items set itm_externalid='23725' where itm_name='Infiltrator TD-600'; |
476 | | update kb3_items set itm_externalid='23727' where itm_name='Acolyte TD-300'; |
477 | | update kb3_items set itm_externalid='23729' where itm_name='Valkyrie SW-600'; |
478 | | update kb3_items set itm_externalid='23731' where itm_name='Warrior SW-300'; |
479 | | update kb3_items set itm_externalid='23759' where itm_name='FA-14 Templar'; |
480 | | update kb3_items set itm_externalid='2436' where itm_name='Wasp II'; |
481 | | update kb3_items set itm_externalid='2444' where itm_name='Ogre I'; |
482 | | update kb3_items set itm_externalid='2446' where itm_name='Ogre II'; |
483 | | update kb3_items set itm_externalid='2454' where itm_name='Hobgoblin I'; |
484 | | update kb3_items set itm_externalid='2456' where itm_name='Hobgoblin II'; |
485 | | update kb3_items set itm_externalid='24618' where itm_name='horrible tracking drone'; |
486 | | update kb3_items set itm_externalid='2464' where itm_name='Hornet I'; |
487 | | update kb3_items set itm_externalid='2466' where itm_name='Hornet II'; |
488 | | update kb3_items set itm_externalid='2476' where itm_name='Berserker I'; |
489 | | update kb3_items set itm_externalid='2478' where itm_name='Berserker II'; |
490 | | update kb3_items set itm_externalid='2486' where itm_name='Warrior I'; |
491 | | update kb3_items set itm_externalid='2488' where itm_name='Warrior II'; |
492 | | update kb3_items set itm_externalid='3218' where itm_name='Harvester Mining Drone'; |
493 | | update kb3_items set itm_externalid='3549' where itm_name='Tutorial Attack Drone'; |
494 | | update kb3_items set itm_externalid='9871' where itm_name='Repair Drone'; |
495 | | "; |
496 | | $query = explode("\n", $queries); |
497 | | foreach ($query as $querystring) |
498 | | { |
499 | | if ($string = trim(str_replace(');', ')', $querystring))) |
500 | | { |
501 | | $qry->execute($string); |
502 | | } |
503 | | } |
504 | | } |
505 | | function check_tblstrct6() |
506 | | { |
507 | | $qry = new DBQuery(); |
508 | | $query = 'select all_img from kb3_alliances limit 1'; |
509 | | $result = mysql_query($query); |
510 | | if (!$result) |
511 | | { |
512 | | return; |
513 | | } |
514 | | $query = 'ALTER TABLE `kb3_alliances` DROP `all_img`'; |
515 | | $qry->execute($query); |
516 | | } |