Changeset 555 for trunk/rss.php

Timestamp:

Mar 29, 2009, 4:21:14 PM (15 years ago)

Author:

george

Message:

• Přidáno: Mimo RSS kanál článků přidány kanály ticketů a finančních příspěvků.

File:

• trunk/rss.php (modified) (1 diff)

trunk/rss.php

@@ -9 +9 @@
 $Items = array();
 
-$DbResult = $db->query('SELECT UNIX_TIMESTAMP(date), articles.* FROM articles ORDER BY date DESC LIMIT '.$NewsCount);
-while($Row = $DbResult->fetch_array())
+if(array_key_exists('category', $_GET))
 {
-  $Items[] = array(
-    'Title' => $Row['title'],
-    'Link' => 'http://'.$_SERVER['SERVER_NAME'].$Config['Web']['BaseURL'],
-    'Description' => $Row['text']." (".$Row['autor'].")",
-    'Time' => $Row['UNIX_TIMESTAMP(date)'],
-  );
+  if($_GET['category'] == 'articles')
+  {
+    $Config['Web']['Title'] .= ' - články';
+    $DbResult = $db->query('SELECT UNIX_TIMESTAMP(date), articles.* FROM articles ORDER BY date DESC LIMIT '.$NewsCount);
+    while($Row = $DbResult->fetch_array())
+    {
+      $Items[] = array(
+        'Title' => $Row['title'],
+        'Link' => 'http://'.$_SERVER['SERVER_NAME'].$Config['Web']['BaseURL'],
+        'Description' => $Row['text']." (".$Row['autor'].")",
+        'Time' => $Row['UNIX_TIMESTAMP(date)'],
+      );
+    }
+  } else
+  if($_GET['category'] == 'tickets')
+  {
+    $Config['Web']['Title'] .= ' - žádosti hráčů';
+    $db->select_db($Config['Mangos']['DatabaseCharacters']);
+    $DbResult = $db->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())
+    {
+      $Items[] = array(
+        'Title' => $Row['name'].': '.$Row['text'],
+        'Link' => '',
+        'Description' => $Row['name'].': '.$Row['text'],
+        'Time' => 0,
+      );
+    }
+  } 
+  if($_GET['category'] == 'finance')
+  {
+    $Config['Web']['Title'] .= ' - finanční příspěvky';
+    $DbResult = $db->query('SELECT UNIX_TIMESTAMP(time), operation, description, money FROM finance ORDER BY time DESC LIMIT '.$NewsCount);
+    while($Row = $DbResult->fetch_array())
+    {
+      $Items[] = array
+      (
+        'Title' => $OperationType[$Row['operation']].' '.$Row['description'].' ('.$Row['money'].' Kč)',
+        'Link' => 'http://'.$_SERVER['SERVER_NAME'].$Config['Web']['BaseURL'].'finance/',
+        'Description' => $OperationType[$Row['operation']].' '.$Row['description']."<br>".$Row['money']." Kč",
+        'Time' => $Row['UNIX_TIMESTAMP(time)'],
+      );
+    }    
+  }
 }