Changeset 220

Timestamp:

05/10/07 21:27:25 (15 years ago)

Author:

ralle030583

Message:

- autoupgrade if somebody hasnt or has an old kb3_navigation table

Location:

dev/common/includes

Files:

• autoupgrade.php (modified) (4 diffs)
• class.navigation.php (modified) (2 diffs)

dev/common/includes/autoupgrade.php

@@ -5 +5 @@
     $qry = new DBQuery();
     $query = 'select count(*) from kb3_comments';
-    $result = mysql_query($query);
+    $result = $qry->execute($query);
     if ($result)
     {
@@ -28 +28 @@
         if ($result)
         {
-            return;
+                $query = "select count(KBSITE) from kb3_navigation WHERE KBSITE = '".KB_SITE."'";
+                $result = @mysql_query($query);
+                if ($result)
+                {
+                        return;
+                }
+                $query = 'ALTER TABLE `kb3_navigation` ADD `KBSITE` VARCHAR( 16 ) NOT NULL';
+        $qry->execute($query);
+                $query = 'UPDATE `kb3_navigation` SET KBSITE = "'.KB_SITE.'" WHERE KBSITE LIKE "";';
+        $qry->execute($query);
+                return;
         }
         $query = 'CREATE TABLE `kb3_navigation` (
@@ -39 +49 @@
         `posnr` INT NOT NULL,
         `page` TINYTEXT NOT NULL,
+        `KBSITE` VARCHAR ( 16 ) NOT NULL,
         PRIMARY KEY ( `ID` )
         ) TYPE = MYISAM';
@@ -50 +61 @@
             $statlink = '?a=alliance_detail&all_id='.ALLIANCE_ID;
         }
-        $queries = "INSERT IGNORE INTO `kb3_navigation` VALUES (1,'top',1,'Home','?a=home','_self',1,'ALL_PAGES');
-                INSERT IGNORE INTO `kb3_navigation` VALUES (2,'top',1,'Campaings','?a=campaigns','_self',2,'ALL_PAGES');
-                INSERT IGNORE INTO `kb3_navigation` VALUES (3,'top',1,'Contracts','?a=contracts','_self',3,'ALL_PAGES');
-                INSERT IGNORE INTO `kb3_navigation` VALUES (4,'top',1,'Kills','?a=home','_self',4,'ALL_PAGES');
-                INSERT IGNORE INTO `kb3_navigation` VALUES (5,'top',1,'Losses','?a=losses','_self',5,'ALL_PAGES');
-                INSERT IGNORE INTO `kb3_navigation` VALUES (6,'top',1,'Post Mail','?a=post','_self',6,'ALL_PAGES');
-                INSERT IGNORE INTO `kb3_navigation` VALUES (7,'top',1,'Stats','$statlink','_self',7,'ALL_PAGES');
-                INSERT IGNORE INTO `kb3_navigation` VALUES (8,'top',1,'Awards','?a=awards','_self',8,'ALL_PAGES');
-                INSERT IGNORE INTO `kb3_navigation` VALUES (9,'top',1,'Standings','?a=standings','_self',9,'ALL_PAGES');
-                INSERT IGNORE INTO `kb3_navigation` VALUES (10,'top',1,'Search','?a=search','_self',10,'ALL_PAGES');
-                INSERT IGNORE INTO `kb3_navigation` VALUES (11,'top',1,'Admin','?a=admin','_self',11,'ALL_PAGES');
-                INSERT IGNORE INTO `kb3_navigation` VALUES (12,'top',1,'About','?a=about','_self',12,'ALL_PAGES');";
+        $queries = "INSERT IGNORE INTO `kb3_navigation` VALUES (1,'top',1,'Home','?a=home','_self',1,'ALL_PAGES','".KB_SITE."');
+                INSERT IGNORE INTO `kb3_navigation` VALUES (2,'top',1,'Campaings','?a=campaigns','_self',2,'ALL_PAGES','".KB_SITE."');
+                INSERT IGNORE INTO `kb3_navigation` VALUES (3,'top',1,'Contracts','?a=contracts','_self',3,'ALL_PAGES','".KB_SITE."');
+                INSERT IGNORE INTO `kb3_navigation` VALUES (4,'top',1,'Kills','?a=home','_self',4,'ALL_PAGES','".KB_SITE."');
+                INSERT IGNORE INTO `kb3_navigation` VALUES (5,'top',1,'Losses','?a=losses','_self',5,'ALL_PAGES','".KB_SITE."');
+                INSERT IGNORE INTO `kb3_navigation` VALUES (6,'top',1,'Post Mail','?a=post','_self',6,'ALL_PAGES','".KB_SITE."');
+                INSERT IGNORE INTO `kb3_navigation` VALUES (7,'top',1,'Stats','$statlink','_self',7,'ALL_PAGES','".KB_SITE."');
+                INSERT IGNORE INTO `kb3_navigation` VALUES (8,'top',1,'Awards','?a=awards','_self',8,'ALL_PAGES','".KB_SITE."');
+                INSERT IGNORE INTO `kb3_navigation` VALUES (9,'top',1,'Standings','?a=standings','_self',9,'ALL_PAGES','".KB_SITE."');
+                INSERT IGNORE INTO `kb3_navigation` VALUES (10,'top',1,'Search','?a=search','_self',10,'ALL_PAGES','".KB_SITE."');
+                INSERT IGNORE INTO `kb3_navigation` VALUES (11,'top',1,'Admin','?a=admin','_self',11,'ALL_PAGES','".KB_SITE."');
+                INSERT IGNORE INTO `kb3_navigation` VALUES (12,'top',1,'About','?a=about','_self',12,'ALL_PAGES','".KB_SITE."');";
         $query = explode("\n", $queries);
         foreach ($query as $querystring)

dev/common/includes/class.navigation.php

@@ -1 +1 @@
 <?php
+//for easier patching
+
 
 class Navigation{
@@ -5 +7 @@
         function Navigation()
         {
+                require_once('common/includes/autoupgrade.php');
+                check_navigationtable();
                 $this->contracts_ = killboard::hasContracts();
         $this->campaigns_ = killboard::hasCampaigns();