Changeset 404 for administrace

Timestamp:

Jan 28, 2009, 11:23:01 AM (16 years ago)

Author:

george

Message:

• Upraveno: Názvy databází MaNGOSu přesunuty do konfiguračního souboru a odkazované skripty upraveny k použití těchto proměnných.

Location:

administrace

Files:

• global.php (modified) (1 diff)
• home.php (modified) (3 diffs)
• process_log.php (modified) (1 diff)
• rss_tickets.php (modified) (1 diff)
• user.php (modified) (1 diff)

administrace/global.php

@@ -4 +4 @@
 
 // Configuration
-$MangosConfFile = '/a/mangos/etc/mangosd.conf';
-$StdOutLogFile = '/a/log/mangos/mangos-worldd.log';
-$ErrOutLogFile = '/a/log/mangos/mangos-worldd.err';
-$MangosLogFile = '/a/log/mangos/Server.log';
-$MangosDbErrorsLogFile = '/a/log/mangos/DBErrors.log';
+$MangosConfFile = '/a/mangos1/etc/mangosd.conf';
+$StdOutLogFile = '/a/mangos1/log/mangos-worldd.log';
+$ErrOutLogFile = '/a/mangos1/log/mangos-worldd.err';
+$MangosLogFile = '/a/mangos1/log/Server.log';
+$MangosDbErrorsLogFile = '/a/mangos1/log/DBErrors.log';
 $ItemPerPage = 35;
 

administrace/home.php

@@ -3 +3 @@
 function Show()
 {
-  global $Database;
+  global $Database, $Config;
   
   echo('<h3>Správa serveru</h3>');
@@ -11 +11 @@
   echo('<a href="gm_rules.php">Pravidla pro GM</a><br>');
   echo('</td><td valign="top">');
-  echo('<a href="http://game.zdechov.net/statistic/">Statistiky provozu</a><br>');
+  echo('<a href="http://stat.zdechov.net/game/">Statistiky provozu</a><br>');
   echo('<a href="../navody/">Návody</a><br>');
   echo('<a href="../db/index.php?id=bugreport">Bug report</a>');
@@ -29 +29 @@
 
   echo('<table class="TableAdmin" cellspacing="0" width="100%" style="color: white;" border="1">');
-  $DbResult = $Database->query('SELECT wow.gm_news.text as text, realmd.account.username as username FROM wow.gm_news JOIN realmd.account ON wow.gm_news.author = realmd.account.Id ORDER BY wow.gm_news.time DESC LIMIT '.$Page*$PerPage.', '.$PerPage);
+  $DbResult = $Database->query('SELECT wow.gm_news.text as text, '.$Config['Mangos']['DatabaseRealmd'].'.account.username as username FROM wow.gm_news JOIN '.$Config['Mangos']['DatabaseRealmd'].'.account ON wow.gm_news.author = '.$Config['Mangos']['DatabaseRealmd'].'.account.Id ORDER BY wow.gm_news.time DESC LIMIT '.$Page*$PerPage.', '.$PerPage);
   while($Row = $DbResult->fetch_array())
   {

administrace/process_log.php

@@ -22 +22 @@
 
 // Get used database version from database
-$DbResult = $Database->query('SELECT * FROM `mangos`.`db_version`');
+$DbResult = $Database->query('SELECT * FROM `'.$Config['Mangos']['DatabaseMangos'].'`.`db_version`');
 $DbRow = $DbResult->fetch_array();
 $DbVersion = $DbRow['version'];
 
 // Get last uptime info
-$DbResult = $Database->query('SELECT * FROM `mangos`.`uptime` ORDER BY `starttime` DESC LIMIT 1');
+$DbResult = $Database->query('SELECT * FROM `'.$Config['Mangos']['DatabaseMangos'].'`.`uptime` ORDER BY `starttime` DESC LIMIT 1');
 echo($Database->error);
 $DbRow = $DbResult->fetch_array();

administrace/rss_tickets.php

@@ -7 +7 @@
 // Get news from database by selected categories
 $Items = array();
-$Database->select_db('characters');
+$Database->select_db($Config['Mangos']['DatabaseCharacters']);
 $DbResult = $Database->query("SELECT `character_ticket`.`ticket_text` AS `text`, `characters`.`name` AS `name` FROM `character_ticket` JOIN `characters` ON `characters`.`guid` = `character_ticket`.`guid`");
 while($Row = $DbResult->fetch_array())

administrace/user.php

@@ -23 +23 @@
   function Login($Username, $Password)
   {
+    global $Config;
     global $Database;
-    $Database->select_db('realmd');
+    $Database->select_db($Config['Mangos']['DatabaseRealmd']);
     $DbResult = $Database->select('account', 'Id,username', '(gmlevel > 0) AND (username = "'.$Username.'") AND (sha_pass_hash = SHA1(CONCAT(UCASE("'.$Username.'"),":",UCASE("'.$Password.'"))))');
     if($DbResult->num_rows > 0)