Changeset 627 for trunk/pages/gmteam.php

Timestamp:

Aug 19, 2009, 9:06:06 AM (15 years ago)

Author:

george

Message:

• Upraveno: Strkutura a názvy tabulek gm_tym, finance, finance_rewards.
• Upraveno: Stránka informací o serveru doplněna pro podporu zobrazení více fyzických serverů.
• Přidáno: Zobrazení dřívějších GM v dolní částí stránky GM týmu.

File:

• trunk/pages/gmteam.php (modified) (4 diffs)

trunk/pages/gmteam.php

@@ -5 +5 @@
   global $db, $Config;
   
-  $Result = $db->query('SELECT `gm_tym`.*, `account`.`id`, `account`.`username` FROM `'.$Config['Mangos']['DatabaseRealmd'].'`.`account` LEFT JOIN `'.$Config['Database']['Database'].'`.`gm_tym` ON `gm_tym`.`AccountId` = `account`.`id` WHERE (`account`.`locked` = 0) AND (`account`.`gmlevel` > 0) AND (`gm_tym`.`RealmId` = '.$Realm['Id'].') ORDER BY `gm_tym`.`RealmId`, `account`.`username`');
+  $Result = $db->query('SELECT * FROM `GmTeam` WHERE (`RealmId` = '.$Realm['Id'].') AND (`TimeTo` IS NULL) ORDER BY `RealmId`, `Nick`');
   if($Realm['Id'] == 0) $Output = '<h3 class="PageTitle">'.$Realm['Name'].'</h3>';
     else $Output = '<h3 class="PageTitle">Svět '.$Realm['Name'].'</h3>';
@@ -13 +13 @@
   
   while($Line = $Result->fetch_array())
-  {
-    $Line['username'] = strtoupper($Line['username'][0]).strtolower(substr($Line['username'], 1));
-    if(substr($Line['username'], -2, 2) == 'gm') $Line['username'] = substr($Line['username'], 0, -2);
-  
-    $Output .= '<tr><td>'.$Line['username'].'</td>'.
+  {  
+    // Create link from name if ForumId defined
+    if($Line['ForumId'] != 0) $Line['Nick'] = '<a href="'.$Config['Web']['BaseURL'].'forum/memberlist.php?mode=viewprofile&u='.$Line['ForumId'].'">'.$Line['Nick'].'</a>';
+    
+    $Output .= '<tr><td>'.$Line['Nick'].'</td>'.
       '<td>'.$Line['Delegation'].'</td>';
-    $db->select_db($Config['Mangos']['RealmList'][$_COOKIE['RealmIndex']]['DatabaseCharacters']);
     $Output .= '<td>';
     $Characters = array();
-    $ResultMangos = $db->query('SELECT * FROM `characters` WHERE account = "'.$Line['id'].'"');
+    $ResultMangos = $db->query('SELECT * FROM `'.$Config['Mangos']['RealmList'][$_COOKIE['RealmIndex']]['DatabaseCharacters'].'`.`characters` WHERE `account` = "'.$Line['AccountId'].'"');
     while($LineMangos = $ResultMangos->fetch_array())
     { 
@@ -50 +49 @@
 //$_COOKIE['RealmIndex']
 
+$db->select_db($Config['Database']['Database']);
 $Output = '<h2 class="PageTitle">GM tým</h3>';
 
@@ -59 +59 @@
 $Output .= '<br />'.$server->RealmSelection();
 
+$Output .= '<h3 class="PageTitle">Dřívější GM</h3>';
+$List = array();
+$DbResult = $db->query('SELECT * FROM `GmTeam` WHERE `TimeTo` IS NOT NULL');
+while($DbRow = $DbResult->fetch_assoc())
+{
+  $List[] = $DbRow['Nick'].' ('.$server->HumanDate($DbRow['TimeFrom'], 0).' - '.$server->HumanDate($DbRow['TimeTo'], 0).')';
+}
+$Output .= implode(', ', $List);
+
 echo($Output);