Changeset 221 for dev

Timestamp:

05/10/07 22:00:46 (15 years ago)

Author:

ralle030583

Message:

-navigation table now will be created during install
-default pages will be added to navigation table when other killboards use same db. (different KB_SITE's)

Location:

dev

Files:

• common/includes/autoupgrade.php (modified) (3 diffs)
• install/sql/sql_tblstrct_navigation.sql (added)

dev/common/includes/autoupgrade.php

@@ -23 +23 @@
 
 function check_navigationtable(){
+        if (CORP_ID)
+        {
+            $statlink = '?a=corp_detail&crp_id='.CORP_ID;
+        }
+        elseif (ALLIANCE_ID)
+        {
+            $statlink = '?a=alliance_detail&all_id='.ALLIANCE_ID;
+        }
         $qry = new DBQuery();
         $query = 'select count(*) from kb3_navigation';
@@ -32 +40 @@
                 if ($result)
                 {
+                        $row = mysql_fetch_row($result);
+                        if ($row[0] == 0)
+                        {
+                                $queries = "INSERT IGNORE INTO `kb3_navigation` (`nav_type`,`intern`,`descr` ,`url` ,`target`,`posnr` ,`page`,`KBSITE`) VALUES ('top',1,'Home','?a=home','_self',1,'ALL_PAGES','".KB_SITE."');
+                                                        INSERT IGNORE INTO `kb3_navigation` (`nav_type`,`intern`,`descr` ,`url` ,`target`,`posnr` ,`page`,`KBSITE`) VALUES ('top',1,'Campaings','?a=campaigns','_self',2,'ALL_PAGES','".KB_SITE."');
+                                                        INSERT IGNORE INTO `kb3_navigation` (`nav_type`,`intern`,`descr` ,`url` ,`target`,`posnr` ,`page`,`KBSITE`) VALUES ('top',1,'Contracts','?a=contracts','_self',3,'ALL_PAGES','".KB_SITE."');
+                                                        INSERT IGNORE INTO `kb3_navigation` (`nav_type`,`intern`,`descr` ,`url` ,`target`,`posnr` ,`page`,`KBSITE`) VALUES ('top',1,'Kills','?a=home','_self',4,'ALL_PAGES','".KB_SITE."');
+                                                        INSERT IGNORE INTO `kb3_navigation` (`nav_type`,`intern`,`descr` ,`url` ,`target`,`posnr` ,`page`,`KBSITE`) VALUES ('top',1,'Losses','?a=losses','_self',5,'ALL_PAGES','".KB_SITE."');
+                                                        INSERT IGNORE INTO `kb3_navigation` (`nav_type`,`intern`,`descr` ,`url` ,`target`,`posnr` ,`page`,`KBSITE`) VALUES ('top',1,'Post Mail','?a=post','_self',6,'ALL_PAGES','".KB_SITE."');
+                                                        INSERT IGNORE INTO `kb3_navigation` (`nav_type`,`intern`,`descr` ,`url` ,`target`,`posnr` ,`page`,`KBSITE`) VALUES ('top',1,'Stats','$statlink','_self',7,'ALL_PAGES','".KB_SITE."');
+                                                        INSERT IGNORE INTO `kb3_navigation` (`nav_type`,`intern`,`descr` ,`url` ,`target`,`posnr` ,`page`,`KBSITE`) VALUES ('top',1,'Awards','?a=awards','_self',8,'ALL_PAGES','".KB_SITE."');
+                                                        INSERT IGNORE INTO `kb3_navigation` (`nav_type`,`intern`,`descr` ,`url` ,`target`,`posnr` ,`page`,`KBSITE`) VALUES ('top',1,'Standings','?a=standings','_self',9,'ALL_PAGES','".KB_SITE."');
+                                                        INSERT IGNORE INTO `kb3_navigation` (`nav_type`,`intern`,`descr` ,`url` ,`target`,`posnr` ,`page`,`KBSITE`) VALUES ('top',1,'Search','?a=search','_self',10,'ALL_PAGES','".KB_SITE."');
+                                                        INSERT IGNORE INTO `kb3_navigation` (`nav_type`,`intern`,`descr` ,`url` ,`target`,`posnr` ,`page`,`KBSITE`) VALUES ('top',1,'Admin','?a=admin','_self',11,'ALL_PAGES','".KB_SITE."');
+                                                        INSERT IGNORE INTO `kb3_navigation` (`nav_type`,`intern`,`descr` ,`url` ,`target`,`posnr` ,`page`,`KBSITE`) VALUES ('top',1,'About','?a=about','_self',12,'ALL_PAGES','".KB_SITE."');";
+                                $query = explode("\n", $queries);
+                                foreach ($query as $querystring)
+                                {
+                                        if ($string = trim(str_replace(');', ')', $querystring)))
+                                        {
+                                            $qry->execute($string);
+                                        }
+                                }
+                        }
                         return;
                 }
@@ -51 +83 @@
         `KBSITE` VARCHAR ( 16 ) NOT NULL,
         PRIMARY KEY ( `ID` )
-        ) TYPE = MYISAM';
+        ) TYPE = MYISAM;';
            $qry->execute($query);
-        if (CORP_ID)
-        {
-            $statlink = '?a=corp_detail&crp_id='.CORP_ID;
-        }
-        elseif (ALLIANCE_ID)
-        {
-            $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','".KB_SITE."');
                 INSERT IGNORE INTO `kb3_navigation` VALUES (2,'top',1,'Campaings','?a=campaigns','_self',2,'ALL_PAGES','".KB_SITE."');