X-Git-Url: https://git.nubati.net/cgi-bin/gitweb.cgi?p=e-DoKo.git;a=blobdiff_plain;f=db.php;h=7934781e0661bec924da8ba24661badce0447e22;hp=f5f6673cde706add1050d499f3e6a3bf08cc49e5;hb=661cdf100d59bb0d7ee3ade0d392efa68aba1a19;hpb=9732aef914603924915bde24684f322843ead085

diff --git a/db.php b/db.php
index f5f6673..7934781 100644
--- a/db.php
+++ b/db.php
@@ -578,6 +578,28 @@ function DB_get_all_names()
   return $names;
 }
 
+function DB_get_names_of_last_logins($N)
+{
+  $names  = array();
+
+  $result = mysql_query("SELECT fullname FROM User ORDER BY last_login DESC LIMIT $N");
+  while($r = mysql_fetch_array($result,MYSQL_NUM))
+    $names[] = $r[0];
+
+  return $names;
+}
+
+function DB_get_names_of_new_logins($N)
+{
+  $names  = array();
+
+  $result = mysql_query("SELECT fullname FROM User ORDER BY create_date DESC, id DESC LIMIT $N");
+  while($r = mysql_fetch_array($result,MYSQL_NUM))
+    $names[] = $r[0];
+
+  return $names;
+}
+
 function DB_update_game_timestamp($gameid)
 {
   mysql_query("UPDATE Game SET mod_date = CURRENT_TIMESTAMP WHERE id=".DB_quote_smart($gameid));
@@ -609,7 +631,7 @@ function DB_get_user_timezone($userid)
   if($r)
     return $r[0];
   else
-    return 0;
+    return "Europe/London";
 }
 
 function DB_insert_comment($comment,$playid,$userid)
@@ -619,6 +641,27 @@ function DB_insert_comment($comment,$playid,$userid)
   return;
 }
 
+function DB_insert_note($comment,$gameid,$userid)
+{
+  mysql_query("INSERT INTO Notes VALUES (NULL,NULL,NULL,$userid,$gameid, ".DB_quote_smart($comment).")");
+
+  return;
+}
+
+function DB_get_notes_by_userid_and_gameid($userid,$gameid)
+{
+  $notes = array();
+
+  $result = mysql_query("SELECT comment FROM Notes WHERE user_id=".DB_quote_smart($userid) .
+			" AND game_id=".DB_quote_smart($gameid));
+
+  while($r = mysql_fetch_array($result,MYSQL_NUM))
+    $notes[] = $r[0];
+
+  return $notes;
+}
+
+
 function DB_get_gametype_by_gameid($id)
 {
   $result = mysql_query("SELECT type FROM Game WHERE id=".DB_quote_smart($id));
@@ -723,7 +766,8 @@ function DB_get_hashes_by_session($session,$user)
   $result = mysql_query("SELECT Hand.hash FROM Hand".
 			" LEFT JOIN Game ON Game.id=Hand.game_id ".
 			" WHERE Game.session=".DB_quote_smart($session).
-			" AND Hand.user_id=".DB_quote_smart($user));
+			" AND Hand.user_id=".DB_quote_smart($user).
+			" ORDER BY Game.create_date ASC");
   while($t = mysql_fetch_array($result,MYSQL_NUM))
     $r[] = $t[0];