projects
/
e-DoKo.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
NEW FEATURE: provide an RSS feed for each user showing in which games it's his turn
[e-DoKo.git]
/
include
/
db.php
diff --git
a/include/db.php
b/include/db.php
index 882a1adb35448224451f230aff4f6278fa373a80..55d97c97e4673134418ad5a1aa49f934a65e799a 100644
(file)
--- a/
include/db.php
+++ b/
include/db.php
@@
-498,6
+498,15
@@
function DB_update_game_timestamp($gameid)
return;
}
return;
}
+function DB_get_game_timestamp($gameid)
+{
+ $r = DB_query_array("SELECT mod_date FROM Game WHERE id=".DB_quote_smart($gameid));
+
+ if($r)
+ return $r[0];
+ else
+ return NULL;
+}
function DB_update_user_timestamp($userid)
{
function DB_update_user_timestamp($userid)
{
@@
-514,6
+523,17
@@
function DB_get_user_timestamp($userid)
else
return NULL;
}
else
return NULL;
}
+
+function DB_get_user_creation_date($userid)
+{
+ $r = DB_query_array("SELECT create_date FROM User WHERE id=".DB_quote_smart($userid));
+
+ if($r)
+ return $r[0];
+ else
+ return NULL;
+}
+
function DB_get_user_timezone($userid)
{
$r = DB_query_array("SELECT timezone FROM User WHERE id=".DB_quote_smart($userid));
function DB_get_user_timezone($userid)
{
$r = DB_query_array("SELECT timezone FROM User WHERE id=".DB_quote_smart($userid));