Changeset 315 for administrace

Timestamp:

Mar 22, 2008, 11:51:55 PM (17 years ago)

Author:

george

Message:

Opraveno: Načítání RSS kanálu ticketů.

File:

• administrace/rss_tickets.php (modified) (3 diffs)

administrace/rss_tickets.php

@@ -1 @@
-<?
+<?php
 header("Content-Type: text/xml");
 
@@ -9 +9 @@
 // Get news from database by selected categories
 $Items = array();
-
 $Database->select_db('characters');
-$DbResult = $Database->query("SELECT character_ticket.ticket_text AS text, character.name AS name FROM character_ticket JOIN `character` ON character.guid = character_ticket.guid");
+$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())
 {
@@ -23 +22 @@
 
 echo(GenerateRSS(array(
-  'Title' => 'WoW GM lístky',
+  'Title' => 'WoW GM žádanky',
   'Link' => 'http://wow.zdechov.net/administrace/',
-  'Description' => 'Požadavky hráèù na GM WoW serveru Heroes of Fantasy',
+  'Description' => 'Požadavky hráèù na GM',
   'WebmasterEmail' => 'wow@zdechov.net',
   'Items' => $Items)));