root/dev/install/install_step42.php @ 400

Revision 400, 1.1 KB (checked in by kovell, 13 years ago)

Fixes: install is locked after first run, private cache files made inaccesible, initial summary caching removed from kill posting, board will not attempt to run on MySQL < 4.1, PILOT_ID cannot be set, legacy option removed from admin panel, pos values added to installation defaults

Line 
1<?php
2if(!$installrunning) {header('Location: index.php');die();}
3$stoppage = false;
4
5include_once('../kbconfig.php');
6$db = mysql_connect(DB_HOST, DB_USER, DB_PASS);
7mysql_select_db(DB_NAME);
8
9$query = "update kb3_items_destroyed
10            inner join kb3_items on itd_itm_id=itm_id
11            inner join kb3_invtypes on itm_name=typeName
12            set itd_itm_id=typeID";
13mysql_query($query);
14echo mysql_error();
15
16$query = "update kb3_inv_detail
17            inner join kb3_items on ind_wep_id=itm_id
18            inner join kb3_invtypes on itm_name=typeName
19            set ind_wep_id=typeID";
20mysql_query($query);
21echo mysql_error();
22
23$query = "insert into kb3_item_price
24            select typeID, itm_value as price
25            from kb3_items
26            left join kb3_invtypes on itm_name=typeName
27            where typeID is not null and itm_value != 0 and itm_value!=basePrice";
28mysql_query($query);
29echo mysql_error();
30
31?>
32<p>Queries executed, please proceed...</p>
33<?php if ($stoppage)
34{
35    return;
36}?>
37<p><a href="?step=<?php echo ($_SESSION['state']+1); ?>">Next Step</a></p>
Note: See TracBrowser for help on using the browser.