reuse random number: test select distinct

[e-DoKo.git] / rss.php

diff --git a/rss.php b/rss.php
index 269b734b2fbbdf8eb73763f95a9d5570ce46f6ec..006daa22396c766a4f5cfff20411a4eab8089acb 100644 (file)
--- a/rss.php
+++ b/rss.php
@@ -1,5 +1,5 @@
 <?php
-/* Copyright 2006, 2007, 2008, 2009, 2010, 2011, 2012 Arun Persaud <arun@nubati.net>
+/* Copyright 2006, 2007, 2008, 2009, 2010, 2011, 2012, 2013, 2014 Arun Persaud <arun@nubati.net>
  *
  *   This file is part of e-DoKo.
  *
@@ -74,23 +74,8 @@ header("Content-Type: text/xml");
 <title>E-DoKo Feed</title>
 <?php
 
-  /* set language */
-  $PREF = DB_get_PREF($id);
-  $lang = $PREF['language'];
-
-  switch($lang)
-    {
-    case 'de':
-      putenv("LC_ALL=de_DE");
-      setlocale(LC_ALL, "de_DE");
-      // Specify location of translation tables
-      bindtextdomain("edoko", "./locale");
-      // Choose domain
-      textdomain("edoko");
-      break;
-    default:
-      /* do nothing */
-    }
+/* set language */
+set_language($id,'uid');
 
 echo '<subtitle>'._('Know when it is your turn')."</subtitle>\n";
 
@@ -115,8 +100,8 @@ echo "</author>\n\n";
 
   $result = DB_query("SELECT Hand.hash,Hand.game_id,Game.player from Hand".
                     " LEFT JOIN Game On Hand.game_id=Game.id".
-                    " WHERE Hand.user_id='$id'".
-                    " AND ( Game.player='$id' OR ISNULL(Game.player) )".
+                    " WHERE Hand.user_id=".DB_quote_smart($id).
+                    " AND ( Game.player=".DB_quote_smart($id)." OR ISNULL(Game.player) )".
                     " AND ( Game.status='pre' OR Game.status='play' )".
                     " ORDER BY Game.session" );