Changeset 283 for dev/common

Timestamp:

12/12/07 08:55:32 (14 years ago)

Author:

ralle030583

Message:

-readded a shorten check_navigatable() to autoupgrade.php

to fix issue with not shown navigation after changeing KBSITE

Location:

dev/common

Files:

• admin/option_db.php (modified) (1 diff)
• includes/autoupgrade.php (modified) (1 diff)
• includes/globals.php (modified) (1 diff)

dev/common/admin/option_db.php

@@ -8 +8 @@
     function checkDatabase()
     {
-        // nothing to do currently
+        //check if navigation table filled with default links
+        check_navigationtable();
     }
 

dev/common/includes/autoupgrade.php

@@ -1 +1 @@
 <?php
-
+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;
+        }
+        $query = "select count(KBSITE) from kb3_navigation WHERE KBSITE = '".KB_SITE."' AND target = '?a=home'";
+        $result = @mysql_query($query);
+        $row = mysql_fetch_row($result);
+        if ($row[0] == 0)
+        {
+                $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."');
+                                        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."');
+                                        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."');
+                                        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."');
+                                        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."');
+                                        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."');
+                                        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."');
+                                        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."');
+                                        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."');
+                                        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."');
+                                        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."');
+                                        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."');";
+                $query = explode("\n", $queries);
+                $qry = new DBQuery();
+                foreach ($query as $querystring)
+                {
+                        if ($string = trim(str_replace(');', ')', $querystring)))
+                        {
+                            $qry->execute($string);
+                        }
+                }
+        }
+}       
 ?>

dev/common/includes/globals.php

@@ -1 +1 @@
 <?php
 // current subversion revision
-preg_match('/\$Re'.'vision: (.*?) \$/', '$Revision: 281 $', $match);
+preg_match('/\$Re'.'vision: (.*?) \$/', '$Revision: 283 $', $match);
 define('SVN_REV', $match[1]);