Changeset 315 for administrace


Ignore:
Timestamp:
Mar 22, 2008, 11:51:55 PM (17 years ago)
Author:
george
Message:

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

File:
1 edited

Legend:

Unmodified
Added
Removed
  • administrace/rss_tickets.php

    r186 r315  
    1 <?
     1<?php
    22header("Content-Type: text/xml");
    33
     
    99// Get news from database by selected categories
    1010$Items = array();
    11 
    1211$Database->select_db('characters');
    13 $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");
     12$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`");
    1413while($Row = $DbResult->fetch_array())
    1514{
     
    2322
    2423echo(GenerateRSS(array(
    25   'Title' => 'WoW GM lístky',
     24  'Title' => 'WoW GM žádanky',
    2625  'Link' => 'http://wow.zdechov.net/administrace/',
    27   'Description' => 'Požadavky hráèù na GM WoW serveru Heroes of Fantasy',
     26  'Description' => 'Požadavky hráèù na GM',
    2827  'WebmasterEmail' => 'wow@zdechov.net',
    2928  'Items' => $Items)));
Note: See TracChangeset for help on using the changeset viewer.