projects
/
e-DoKo.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
BUGFIX: final email didn't add up points for re/contra
[e-DoKo.git]
/
db.php
diff --git
a/db.php
b/db.php
index a78afb6aa744d58550385e0084abc56e69978ddd..bae70cbc943b7273f4478bce795c0d64871bb34c 100644
(file)
--- a/
db.php
+++ b/
db.php
@@
-466,7
+466,7
@@
function DB_get_current_trickid($gameid)
if(!$sequence || $sequence==4)
{
if(!$sequence || $sequence==4)
{
- mysql_query("INSERT INTO Trick VALUES (NULL,NULL,NULL, ".DB_quote_smart($gameid).")");
+ mysql_query("INSERT INTO Trick VALUES (NULL,NULL,NULL, ".DB_quote_smart($gameid)."
,NULL
)");
$trickid = mysql_insert_id();
$sequence = 1;
$number++;
$trickid = mysql_insert_id();
$sequence = 1;
$number++;
@@
-771,9
+771,9
@@
function DB_get_PREF($myid)
function DB_get_unused_randomnumbers($userstr)
{
function DB_get_unused_randomnumbers($userstr)
{
- $queryresult = mysql_query("SELECT randomnumbers,Game.id FROM Game ".
+ $queryresult = mysql_query("SELECT randomnumbers,Game.id
, COUNT(*) as num
FROM Game ".
" LEFT JOIN Hand ON Hand.game_id=Game.id ".
" LEFT JOIN Hand ON Hand.game_id=Game.id ".
- " AND
user_id not in (".$userstr.")".
+ " AND user_id not in (".$userstr.")".
" GROUP BY Game.id ".
" HAVING num=4");
" GROUP BY Game.id ".
" HAVING num=4");