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)