Changeset 477 for branches

Timestamp:

Mar 8, 2009, 5:16:41 PM (16 years ago)

Author:

amun

Message:

 

File:

• branches/beta/rss.php (modified) (2 diffs)

branches/beta/rss.php

@@ -11 +11 @@
 <rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
   <channel>
-    <title>WoW Zdechov RSS</title>
-    <link><b>Webová stranka serveru:</b> http://wow.zdechov.net/</link>
-  
+    <title>HoF Ticket RSS</title>
+    <link>http://wow.zdechov.net/</link>
+    <description>HoF Ticket RSS</description>
+    <language>cs</language>
     <lastBuildDate><?php echo date("j/m/Y H:i:s").""; ?></lastBuildDate>
     <atom:link href="http://www.samuraj-cz.com/rss/" rel="self" type="application/rss+xml" />
@@ -24 +25 @@
    $result = mysql_query("SELECT * FROM character_ticket ORDER BY ticket_lastchange DESC, ticket_id DESC LIMIT 20 ");
     while($rec = mysql_fetch_array($result)) {
+        $guid = $rec["guid"];
         $time = $rec["ticket_lastchange"];
-            $human_date = date("d.m.Y  H:i", strtotime($time)); ?>
+    $human_date = date("d.m.Y  H:i", strtotime($time)); 
+        $result2 = mysql_query("SELECT name FROM characters where guid='$guid' ");
+        while($rec2 = mysql_fetch_array($result2)) {
+        $name = $rec2["name"];
+        }
+        ?>
     <item>
-          <pubDate><?php echo"<br><b> $human_date </b></br> ";?></pubDate>
-      <description><?php echo "".htmlspecialchars(strip_tags($rec[ticket_text]))." "; ?></description>
-      
+        
+     <title><?php echo "<br><b>$name</b></br>"; ?> sss</title>
+         <pubDate><?php echo"$human_date";?></pubDate>
+         <link>http://wow.zdechov.net/beta</link>
+         <description><?php echo "<br>".htmlspecialchars(strip_tags($rec[ticket_text]))." </br>"; ?></description>
+     
+         
     </item>
 <?php
-    }
+   } 
+  
 ?>
  </channel>