X-Git-Url: https://git.nubati.net/cgi-bin/gitweb.cgi?p=e-DoKo.git;a=blobdiff_plain;f=db.php;h=45f5eff7f02d11226d32f0bd438f8de87b750492;hp=9f002053b45b30e3b209eb6700f71b0863834b12;hb=6e709fb780a236b6518653ac392c26a684204462;hpb=f0bbdae184fed051df8ae0e93a41e88c9442a7db diff --git a/db.php b/db.php index 9f00205..45f5eff 100644 --- a/db.php +++ b/db.php @@ -6,9 +6,9 @@ function DB_open() { - global $DB; - if ( $DB = mysql_connect('mysql.nubati.net','doko', '$DoKo#.') ) - mysql_select_db('dokodb') or die('Could not select database'); + global $DB,$DB_user,$DB_host,$DB_database,$DB_password; + if ( $DB = mysql_connect($DB_host,$DB_user, $DB_password) ) + mysql_select_db($DB_database) or die('Could not select database'); else die (mysql_error()); @@ -59,6 +59,28 @@ function DB_get_email_by_name($name) return ""; } +function DB_get_email_by_userid($id) +{ + $result = mysql_query("SELECT email 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_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)); @@ -89,6 +111,16 @@ function DB_get_userid_by_email($email) 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) { @@ -101,6 +133,19 @@ function DB_get_handid_by_hash($hash) return 0; } +function DB_get_handid_by_gameid_and_position($gameid,$pos) +{ + $result = mysql_query("SELECT id FROM Hand WHERE game_id=". + DB_quote_smart($gameid)." AND position=". + DB_quote_smart($pos)); + $r = mysql_fetch_array($result,MYSQL_NUM); + + if($r) + return $r[0]; + else + return -1; +} + function DB_get_userid_by_hash($hash) { $result = mysql_query("SELECT user_id FROM Hand WHERE hash=".DB_quote_smart($hash)); @@ -134,6 +179,17 @@ function DB_get_name_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)); @@ -168,9 +224,22 @@ function DB_set_hand_status_by_hash($hash,$status) 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($uid). + " AND game_id=".DB_quote_smart($gid)); + $r = mysql_fetch_array($result,MYSQL_NUM); + + if($r) + return $r[0]; + else + return 0; +} + +function DB_get_sickness_by_userid_and_gameid($uid,$gid) { - $result = mysql_query("SELECT status FROM Hand WHERE user_id=".DB_quote_smart($id)); + $result = mysql_query("SELECT sickness 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) @@ -237,26 +306,35 @@ function DB_get_hand($me) function DB_get_cards_by_trick($id) { $cards = array(); - $cards[0]=0; /* need to return index 1-4 */ - + $i = 1; + $result = mysql_query("SELECT card_id FROM Play LEFT JOIN Hand_Card ON Hand_Card.id=Play.hand_card_id ". "LEFT JOIN Hand ON Hand.id=Hand_Card.hand_id ". "WHERE trick_id=". DB_quote_smart($id)." ORDER BY position ASC"); while($r = mysql_fetch_array($result,MYSQL_NUM)) - $cards[]=$r[0]; + { + $cards[$i]=$r[0]; + $i++; + } return $cards; } -function DB_set_solo_by_hash($me,$solo) +function DB_set_solo_by_hash($hash,$solo) { mysql_query("UPDATE Hand SET solo=".DB_quote_smart($solo)." WHERE hash=".DB_quote_smart($hash)); return; } -function DB_set_sickness_by_hash($me,$sickness) +function DB_set_solo_by_gameid($id,$solo) +{ + mysql_query("UPDATE Game SET solo=".DB_quote_smart($solo)." WHERE id=".DB_quote_smart($id)); + return; +} + +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; @@ -264,11 +342,14 @@ function DB_set_sickness_by_hash($me,$sickness) function DB_get_current_trickid($gameid) { + $trickid = NULL; + $sequence = NULL; + $result = mysql_query("SELECT Trick.id,MAX(Play.sequence) FROM Play ". "LEFT JOIN Trick ON Play.trick_id=Trick.id ". "WHERE Trick.game_id=".DB_quote_smart($gameid)." ". "GROUP BY Trick.id"); - while( $r = mysql_fetch_array($result,MYSQL_NUM) ) + while( $r = mysql_fetch_array($result,MYSQL_NUM) ) { $trickid = $r[0]; $sequence = $r[1]; @@ -301,7 +382,9 @@ function DB_play_card($trickid,$handcardid,$sequence) { mysql_query("INSERT INTO Play VALUES(NULL,NULL,NULL,".DB_quote_smart($trickid). ",".DB_quote_smart($handcardid).",".DB_quote_smart($sequence).")"); - return; + + $playid = mysql_insert_id(); + return $playid; } function DB_get_all_names_by_gameid($id) @@ -376,4 +459,57 @@ function DB_get_user_timezone($userid) else return 0; } + +function DB_insert_comment($comment,$playid,$userid) +{ + mysql_query("INSERT INTO Comment VALUES (NULL,NULL,NULL,$userid,$playid, ".DB_quote_smart($comment).")"); + return; +} + +function DB_get_gametype_by_gameid($id) +{ + $result = mysql_query("SELECT type FROM Game WHERE id=".DB_quote_smart($id)); + $r = mysql_fetch_array($result,MYSQL_NUM); + + if($r) + return $r[0].""; + else + return ""; +} + +function DB_set_gametype_by_gameid($id,$p) +{ + mysql_query("UPDATE Game SET type='".$p."' WHERE id=".DB_quote_smart($id)); + return; +} + +function DB_get_solo_by_gameid($id) +{ + $result = mysql_query("SELECT solo FROM Game WHERE id=".DB_quote_smart($id)); + $r = mysql_fetch_array($result,MYSQL_NUM); + + if($r) + return $r[0].""; + else + return ""; +} + + +function DB_get_startplayer_by_gameid($id) +{ + $result = mysql_query("SELECT startplayer FROM Game WHERE id=".DB_quote_smart($id)); + $r = mysql_fetch_array($result,MYSQL_NUM); + + if($r) + return $r[0]; + else + return 0; +} + +function DB_set_startplayer_by_gameid($id,$p) +{ + mysql_query("UPDATE Game SET startplayer='".$p."' WHERE id=".DB_quote_smart($id)); + return; +} + ?> \ No newline at end of file