Changeset 186 for administrace/home.php

Timestamp:

Jan 1, 2008, 2:22:36 PM (17 years ago)

Author:

george

Message:

Doplnění funkcí a odkazů v administraci. Opět funkční RSS kanály GM zpráv a ticketů(žádanek).

File:

• administrace/home.php (modified) (1 diff)

administrace/home.php

@@ -4 +4 @@
 {
   global $Database;
+  
   echo('<h3>Správa serveru</h3>');
+  echo('<table witdh="100%"><tr><td valign="top">');
+  echo('<a href="https://wow.zdechov.net/mysql/">Správa databáze PhpMyAdmin</a><br>');
+  echo('<a href="https://wow.zdechov.net/trac/wow/">Zdrojové kody webu</a><br>');
+  echo('<a href="gm_rules.php">Pravidla pro GM</a><br>');
+  echo('<a href="http://game.zdechov.net/statistic/">Statistiky provozu</a><br>');
+  echo('<a href="../navody/">Návody</a><br>');
+  echo('</td><td valign="top">');
+  echo('<a href="rss.php">RSS GM zpráv</a><br>');
+  echo('<a href="rss_tickets.php">RSS herních žádanek</a><br>');
+  echo('</td></table><br>');  
+  
   echo('<form action="?op=AddMessage" method="post">
-  <input name="text" width="40"> <input type="submit" value="Pøidat"><br><br>');
-  echo('</form>');
+  <input name="text" size="80"> <input type="submit" value="Pøidat">');
+  echo('</form>'); 
   
-  echo('<strong>Historie zpráv:</strong><br>');
-  $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 0 , 30');
+  $PerPage = 15;
+  if(array_key_exists('page', $_GET)) $Page = addslashes($_GET['page']); else $Page = 0;
+
+
+  echo('<strong>Historie zpráv:</strong><table cellspacing="0" width="100%" style="color: white;" border="1"><tr><td>');
+  $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);
   while($Row = $DbResult->fetch_array())
   {
-    echo($Row['username'].': '.$Row['text'].'<br>');
+    echo('<strong>'.$Row['username'].':</strong> '.$Row['text'].'<br>');
   }
+  echo('</td></tr></table>');
   
+  $DbResult = $Database->query('SELECT COUNT(*) FROM wow.gm_news');
+  $Row = $DbResult->fetch_array();
+  echo(PagesList('?page=', $Page, $Row[0], $PerPage));
   //echo(phpinfo());
 }