you can now also comment, if it is not your turn,
and up to 7 days after the game finished.
doubled size of comments too
-ul.tricks li div div span {
+ul.tricks li div div span.comment {
position:absolute;
background-color:white;
margin:0;
padding:0;
width:10em;
border: 1px solid yellow;
position:absolute;
background-color:white;
margin:0;
padding:0;
width:10em;
border: 1px solid yellow;
+ z-index:-11;
+}
+ul.tricks li div div span.comment:hover {
-ul.tricks li div div.card0 span{
+ul.tricks li div div.card0 span.comment{
top:4em;
left:-10em;
border: 3px solid green;
}
top:4em;
left:-10em;
border: 3px solid green;
}
-ul.tricks li div div.card1 span{
+ul.tricks li div div.card1 span.comment{
top:-2em;
left:1em;
border: 3px solid green;
}
top:-2em;
left:1em;
border: 3px solid green;
}
-ul.tricks li div div.card2 span{
+ul.tricks li div div.card2 span.comment{
top:-2em;
left:0em;
border: 3px solid green;
}
top:-2em;
left:0em;
border: 3px solid green;
}
-ul.tricks li div div.card3 span{
+ul.tricks li div div.card3 span.comment{
top:2em;
left:20em;
border: 3px solid green;
}
top:2em;
left:20em;
border: 3px solid green;
}
+ul.tricks li div div span.comment span{
+ display:block;
+ width:10em;
+ text-align:left;
+ border-top:1px solid green;
+}
$result = mysql_query("SELECT MAX(id) FROM Trick WHERE game_id=".DB_quote_smart($gameid));
$r = mysql_fetch_array($result,MYSQL_NUM) ;
$result = mysql_query("SELECT MAX(id) FROM Trick WHERE game_id=".DB_quote_smart($gameid));
$r = mysql_fetch_array($result,MYSQL_NUM) ;
return ($r?$r[0]:NULL);
}
return ($r?$r[0]:NULL);
}
function DB_insert_comment($comment,$playid,$userid)
{
mysql_query("INSERT INTO Comment VALUES (NULL,NULL,NULL,$userid,$playid, ".DB_quote_smart($comment).")");
function DB_insert_comment($comment,$playid,$userid)
{
mysql_query("INSERT INTO Comment VALUES (NULL,NULL,NULL,$userid,$playid, ".DB_quote_smart($comment).")");
return "Error during get_card_name ".$card;
}
return "Error during get_card_name ".$card;
}
+function DB_get_current_playid($gameid)
+{
+ $trick = DB_get_max_trickid($gameid);
+
+ if(!$trick) return NULL;
+
+ $queryresult = mysql_query("SELECT id FROM Play WHERE trick_id='$trick' ORDER BY create_date DESC LIMIT 1");
+
+ $r = mysql_fetch_array($queryresult,MYSQL_NUM);
+ if($r)
+ return $r[0];
+
+ return "";
+}
+
?>
\ No newline at end of file
?>
\ No newline at end of file
+ /* get time from the last action of the game */
+ $result = mysql_query("SELECT mod_date from Game WHERE id='$gameid' " );
+ $r = mysql_fetch_array($result,MYSQL_NUM);
+ $gameend = time() - strtotime($r[0]);
+
+ /* handel comments in case player didn't play a card, allow comments a week after the end of the game */
+ if( (!myisset("card") && $mystatus=='play') || ($mystatus=='gameover' && ($gameend < 60*60*24*7)) )
+ if(myisset("comment"))
+ {
+ $comment = $_REQUEST["comment"];
+ $playid = DB_get_current_playid($gameid);
+
+ if($comment != "")
+ DB_insert_comment($comment,$playid,$myid);
+ };
+
/* get everything relevant to display the tricks */
$result = mysql_query("SELECT Hand_Card.card_id as card,".
" Hand.position as position,".
" Play.sequence as sequence, ".
" Trick.id, ".
/* get everything relevant to display the tricks */
$result = mysql_query("SELECT Hand_Card.card_id as card,".
" Hand.position as position,".
" Play.sequence as sequence, ".
" Trick.id, ".
+ " GROUP_CONCAT(CONCAT('<span>',User.fullname,': ',Comment.comment,'</span>') SEPARATOR '\n' ), ".
" Play.create_date, ".
" Hand.user_id ".
"FROM Trick ".
" Play.create_date, ".
" Hand.user_id ".
"FROM Trick ".
"LEFT JOIN Hand_Card ON Play.hand_card_id=Hand_Card.id ".
"LEFT JOIN Hand ON Hand_Card.hand_id=Hand.id ".
"LEFT JOIN Comment ON Play.id=Comment.play_id ".
"LEFT JOIN Hand_Card ON Play.hand_card_id=Hand_Card.id ".
"LEFT JOIN Hand ON Hand_Card.hand_id=Hand.id ".
"LEFT JOIN Comment ON Play.id=Comment.play_id ".
+ "LEFT JOIN User On User.id=Comment.user_id ".
"WHERE Trick.game_id='".$gameid."' ".
"WHERE Trick.game_id='".$gameid."' ".
- "ORDER BY Trick.id,sequence ASC");
+ "GROUP BY Trick.id, sequence ".
+ "ORDER BY Trick.id, sequence ASC");
$trickNR = 1;
$lasttrick = DB_get_max_trickid($gameid);
$trickNR = 1;
$lasttrick = DB_get_max_trickid($gameid);
$myturn = 1;
else
$myturn = 0;
$myturn = 1;
else
$myturn = 0;
/* do we want to play a card? */
if(myisset("card") && $myturn)
{
/* do we want to play a card? */
if(myisset("card") && $myturn)
{
if($handcardid) /* everything ok, play card */
{
if($handcardid) /* everything ok, play card */
{
/* update Game timestamp */
DB_update_game_timestamp($gameid);
/* update Game timestamp */
DB_update_game_timestamp($gameid);
mysql_query("UPDATE Hand_Card SET played='true' WHERE hand_id='$handid' AND card_id=".
DB_quote_smart($card));
mysql_query("UPDATE Hand_Card SET played='true' WHERE hand_id='$handid' AND card_id=".
DB_quote_smart($card));
+ /* get trick id or start new trick */
+ $a = DB_get_current_trickid($gameid);
+ $trickid = $a[0];
+ $sequence = $a[1];
+ $tricknr = $a[2];
+
+ $playid = DB_play_card($trickid,$handcardid,$sequence);
+
/* check for schweinchen */
/* check for schweinchen */
- //echo "schweinchen = ".$GAME["schweinchen"]." --$card-<br />";
if($card == 19 || $card == 20 )
{
$GAME["schweinchen"]++;
if($GAME["schweinchen"]==3 && $RULES["schweinchen"]=="second" )
if($card == 19 || $card == 20 )
{
$GAME["schweinchen"]++;
if($GAME["schweinchen"]==3 && $RULES["schweinchen"]=="second" )
- $comment="Schweinchen! ";
+ DB_insert_comment("Schweinchen! ",$playid,$myid);
if($RULES["schweinchen"]=="both" )
if($RULES["schweinchen"]=="both" )
- $comment="Schweinchen! ";
- if ($debug) echo "schweinchen = ".$GAME["schweinchen"]." ---<br />";
+ DB_insert_comment("Schweinchen! ",$playid,$myid);
+ if ($debug)
+ echo "schweinchen = ".$GAME["schweinchen"]." ---<br />";
- /* get trick id or start new trick */
- $a = DB_get_current_trickid($gameid);
- $trickid = $a[0];
- $sequence = $a[1];
- $tricknr = $a[2];
-
- $playid = DB_play_card($trickid,$handcardid,$sequence);
-
/* if sequence == 4 check who one in case of wedding */
if($sequence == 4 && $GT == "wedding")
{
/* if sequence == 4 check who one in case of wedding */
if($sequence == 4 && $GT == "wedding")
{
/* check for coment */
if(myisset("comment"))
{
/* check for coment */
if(myisset("comment"))
{
- $comment.=$_REQUEST["comment"];
+ $comment = $_REQUEST["comment"];
+ if($comment != "")
+ DB_insert_comment($comment,$playid,$myid);
- if($comment != "")
- DB_insert_comment($comment,$playid,$myid);
-
/* display played card */
echo "<div class=\"card\">";
echo " you played <br />";
/* display played card */
echo "<div class=\"card\">";
echo " you played <br />";
display_card($card,$PREF["cardset"]);
display_card($card,$PREF["cardset"]);
+ if($comment!="")
+ echo " <br /> Your comment:<br /><span class=\"comment\">".$comment."</span>\n";
echo "</div>\n";
/*check if we still have cards left, else set status to gameover */
echo "</div>\n";
/*check if we still have cards left, else set status to gameover */
" no call:".
" <input type=\"radio\" name=\"call0\" value=\"no\" /> ";
" no call:".
" <input type=\"radio\" name=\"call0\" value=\"no\" /> ";
- echo "<br />\nA short comments:<input name=\"comment\" type=\"text\" size=\"30\" maxlength=\"50\" />\n";
+ echo "<br />\nA short comment:<input name=\"comment\" type=\"text\" size=\"30\" maxlength=\"100\" />\n";
echo "<input type=\"hidden\" name=\"me\" value=\"$me\" />\n";
echo "<input type=\"hidden\" name=\"me\" value=\"$me\" />\n";
- echo "<input type=\"submit\" value=\"move\" />\n";
+ echo "<input type=\"submit\" value=\"submit\" />\n";
- else if($mystatus=='play')
- {
+ else if($mystatus=='play' )
+ {
echo "Your cards are: <br />\n";
foreach($mycards as $card)
display_card($card,$PREF["cardset"]);
echo "Your cards are: <br />\n";
foreach($mycards as $card)
display_card($card,$PREF["cardset"]);
+
+ echo "<form action=\"index.php?me=$me\" method=\"post\">\n";
+ echo "<br />\nA short comment:<input name=\"comment\" type=\"text\" size=\"30\" maxlength=\"100\" />\n";
+ echo "<input type=\"hidden\" name=\"me\" value=\"$me\" />\n";
+ echo "<input type=\"submit\" value=\"submit\" />\n";
+ echo "</form>\n";
+
}
else if($mystatus=='gameover')
{
}
else if($mystatus=='gameover')
{
+ /* get time from the last action of the game */
+ $result = mysql_query("SELECT mod_date from Game WHERE id='$gameid' " );
+ $r = mysql_fetch_array($result,MYSQL_NUM);
+ $gameend = time() - strtotime($r[0]);
+
+ if( $gameend < 60*60*24*7 )
+ {
+ echo "<form action=\"index.php?me=$me\" method=\"post\">\n";
+ echo "<br />\nA short comment:<input name=\"comment\" type=\"text\" size=\"30\" maxlength=\"100\" />\n";
+ echo "<input type=\"hidden\" name=\"me\" value=\"$me\" />\n";
+ echo "<input type=\"submit\" value=\"submit\" />\n";
+ echo "</form>\n";
+ }
+
$oldcards = DB_get_all_hand($me);
$oldcards = mysort($oldcards,$gametype);
echo "Your cards were: <br />\n";
$oldcards = DB_get_all_hand($me);
$oldcards = mysort($oldcards,$gametype);
echo "Your cards were: <br />\n";
foreach($oldcards as $card)
display_card($card,$PREF["cardset"]);
}
foreach($oldcards as $card)
display_card($card,$PREF["cardset"]);
}
}
echo "</div>\n";
/* if the game is over do some extra stuff, therefore exit the swtich statement if we are still playing*/
if($mystatus=='play')
break;
}
echo "</div>\n";
/* if the game is over do some extra stuff, therefore exit the swtich statement if we are still playing*/
if($mystatus=='play')
break;
/* the following happens only when the gamestatus is 'gameover' */
/* check if game is over, display results */
if(DB_get_game_status_by_gameid($gameid)=='play')
/* the following happens only when the gamestatus is 'gameover' */
/* check if game is over, display results */
if(DB_get_game_status_by_gameid($gameid)=='play')