Changeset 288
- Timestamp:
- 12/14/07 20:29:42 (12 years ago)
- Location:
- dev/common
- Files:
-
- 4 modified
-
admin/option_db.php (modified) (1 diff)
-
includes/autoupgrade.php (modified) (1 diff)
-
includes/class.navigation.php (modified) (3 diffs)
-
includes/globals.php (modified) (1 diff)
Legend:
- Unmodified
- Added
- Removed
-
dev/common/admin/option_db.php
r284 r288 8 8 function checkDatabase() 9 9 { 10 //check if navigation table filled with default links 11 require_once('common/includes/autoupgrade.php'); 12 check_navigationtable(); 10 // nothing to do atm 13 11 } 14 12 -
dev/common/includes/autoupgrade.php
r284 r288 1 1 <?php 2 function check_navigationtable(){ 3 if (CORP_ID) 4 { 5 $statlink = '?a=corp_detail&crp_id='.CORP_ID; 6 } 7 elseif (ALLIANCE_ID) 8 { 9 $statlink = '?a=alliance_detail&all_id='.ALLIANCE_ID; 10 } 11 $query = "select count(KBSITE) from kb3_navigation WHERE KBSITE = '".KB_SITE."'"; 12 $result = @mysql_query($query); 13 $row = mysql_fetch_row($result); 14 if ($row[0] == 0) 15 { 16 $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."'); 17 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."'); 18 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."'); 19 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."'); 20 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."'); 21 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."'); 22 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."'); 23 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."'); 24 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."'); 25 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."'); 26 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."'); 27 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."');"; 28 $query = explode("\n", $queries); 29 $qry = new DBQuery(); 30 foreach ($query as $querystring) 31 { 32 if ($string = trim(str_replace(');', ')', $querystring))) 33 { 34 $qry->execute($string); 35 } 36 } 37 } 38 } 2 // for easier patching 3 39 4 ?> -
dev/common/includes/class.navigation.php
r282 r288 1 1 <?php 2 //for easier patching3 4 2 5 3 class Navigation{ … … 7 5 function Navigation() 8 6 { 7 // checking if a minimum navigation exists 8 $this->check_navigationtable(); 9 9 10 $this->sql_start = "SELECT * FROM kb3_navigation"; 10 11 $this->sql_end = " AND KBSITE LIKE '" . KB_SITE . "' ORDER BY posnr"; … … 73 74 // TODO 74 75 } 76 77 function check_navigationtable(){ 78 if (CORP_ID) 79 { 80 $statlink = '?a=corp_detail&crp_id='.CORP_ID; 81 } 82 elseif (ALLIANCE_ID) 83 { 84 $statlink = '?a=alliance_detail&all_id='.ALLIANCE_ID; 85 } 86 $query = "select count(KBSITE) from kb3_navigation WHERE KBSITE = '".KB_SITE."'"; 87 $result = @mysql_query($query); 88 $row = mysql_fetch_row($result); 89 if ($row[0] == 0) 90 { 91 $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."'); 92 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."'); 93 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."'); 94 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."'); 95 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."'); 96 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."'); 97 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."'); 98 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."'); 99 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."'); 100 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."'); 101 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."'); 102 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."');"; 103 $query = explode("\n", $queries); 104 $qry = new DBQuery(); 105 foreach ($query as $querystring) 106 { 107 if ($string = trim(str_replace(');', ')', $querystring))) 108 { 109 $qry->execute($string); 110 } 111 } 112 } 113 } 75 114 } 76 115 ?> -
dev/common/includes/globals.php
r286 r288 1 1 <?php 2 2 // current subversion revision 3 preg_match('/\$Re'.'vision: (.*?) \$/', '$Revision: 28 6$', $match);3 preg_match('/\$Re'.'vision: (.*?) \$/', '$Revision: 288 $', $match); 4 4 define('SVN_REV', $match[1]); 5 5
