return "";
}
+function DB_get_email_by_hash($hash)
+{
+ $result = mysql_query("SELECT User.email FROM User LEFT JOIN Hand ON Hand.user_id=User.id WHERE Hand.hash=".DB_quote_smart($hash)."");
+ $r = mysql_fetch_array($result,MYSQL_NUM);
+
+ if($r)
+ return $r[0];
+ else
+ return "";
+}
+
function DB_get_userid_by_name($name)
{
$result = mysql_query("SELECT id FROM User WHERE fullname=".DB_quote_smart($name));
else
return 0;
}
+function DB_get_userid_by_email_and_password($email,$password)
+{
+ $result = mysql_query("SELECT id FROM User WHERE email=".DB_quote_smart($email)." AND password=".DB_quote_smart($password));
+ $r = mysql_fetch_array($result,MYSQL_NUM);
+
+ if($r)
+ return $r[0];
+ else
+ return 0;
+}
function DB_get_handid_by_hash($hash)
{
return "";
}
+function DB_get_name_by_userid($id)
+{
+ $result = mysql_query("SELECT fullname FROM User WHERE id=".DB_quote_smart($id));
+ $r = mysql_fetch_array($result,MYSQL_NUM);
+
+ if($r)
+ return $r[0];
+ else
+ return "";
+}
+
function DB_get_status_by_hash($hash)
{
$result = mysql_query("SELECT status FROM Hand WHERE hash=".DB_quote_smart($hash));
return;
}
-function DB_get_hand_status_by_userid($id)
+function DB_get_hand_status_by_userid_and_gameid($uid,$gid)
{
- $result = mysql_query("SELECT status FROM Hand WHERE user_id=".DB_quote_smart($id));
+ $result = mysql_query("SELECT status FROM Hand WHERE user_id=".DB_quote_smart($uid).
+ " AND game_id=".DB_quote_smart($gid));
$r = mysql_fetch_array($result,MYSQL_NUM);
if($r)
return;
}
-function DB_set_sickness_by_hash($me,$sickness)
+function DB_set_sickness_by_hash($hash,$sickness)
{
mysql_query("UPDATE Hand SET sickness=".DB_quote_smart($sickness)." WHERE hash=".DB_quote_smart($hash));
return;