Changeset 390 for index.php

Timestamp:

Oct 8, 2008, 1:28:45 PM (16 years ago)

Author:

george

Message:

• Opraveno: Dynamické zobrazování GM podle herních účtů namísto ručního přepisování.

File:

• index.php (modified) (1 diff)

index.php

@@ -74 +74 @@
 <a href="gm.php">Administrátoři</a>
 <div>');
-
-  //include('administrace/SubFiles/DatabaseConection.php');
-  $Database->select_db('wow');
-  $Result = $Database->select('user', '*', 'ban = 0 ORDER BY id');
-  while($Row = $Result->fetch_array()) 
-    echo($Row['User'].' - '.$Row['Function'].'<br/>');
+$ChronosId = 11432;
+$Database->select_db('realmd');
+$Result = $Database->query('SELECT * FROM account WHERE (locked = 0) AND (id != '.$ChronosId.') AND (gmlevel > 0) ORDER BY gmlevel DESC');
+while($Row = $Result->fetch_array())
+{
+  $Row['username'] = strtoupper($Row['username'][0]).strtolower(substr($Row['username'], 1));
+  if(substr($Row['username'], -2, 2) == 'gm') $Row['username'] = substr($Row['username'], 0, -2);
+  echo($Row['username'].'<br/>');
+}
 
 echo('</div>