";
- echo "
These are all your games:
\n";
- echo "
Session:
\n";
- echo " p = pre-game phase ";
- echo "P = game in progess ";
- echo "F = game finished
";
- echo "
\n";
-
- $output = array();
- $result = DB_query("SELECT Hand.hash,Hand.game_id,Game.mod_date,Game.player,Game.status from Hand".
- " LEFT JOIN Game ON Game.id=Hand.game_id".
- " WHERE user_id='$myid'".
- " ORDER BY Game.session,Game.create_date" );
- $gamenrold = -1;
- echo "
\n | \n";
- while( $r = DB_fetch_array($result))
- {
- $game = DB_format_gameid($r[1]);
- $gamenr = (int) $game;
- if($gamenrold < $gamenr)
- {
- if($gamenrold!=-1)
- echo " |
\n | $gamenr: | ";
- else
- echo "$gamenr: | ";
- $gamenrold = $gamenr;
- }
- if($r[4]=='pre')
- {
- echo "\n p ";
-
- }
- else if ($r[4]=='gameover')
- echo "\n F ";
- else
- {
- echo "\n P ";
- }
- if($r[4] != 'gameover')
- {
- echo " | \n ";
- if($r[3]==$myid || !$r[3])
- echo "(it's your turn)\n";
- else
- {
- $name = DB_get_name('userid',$r[3]);
- $gameid = $r[1];
- if(DB_get_reminder($r[3],$gameid)==0)
- if(time()-strtotime($r[2]) > 60*60*24*7)
- echo "".
- "Send a reminder.";
- echo "(it's $name's turn)\n";
- };
- if(time()-strtotime($r[2]) > 60*60*24*30)
- echo "".
- "Cancel?".
- " (clicking here is final and can't be restored)";
-
- }
- }
- echo " |
\n
\n";
-
- /* display last 5 users that have signed up to e-DoKo */
- $names = DB_get_names_of_new_logins(5);
- echo "
New Players:
\n
\n";
- echo implode(", ",$names).",...\n";
- echo "
\n";
-
- /* display last 5 users that logged on */
- $names = DB_get_names_of_last_logins(5);
- echo "
Players last logged in:
\n
\n";
- echo implode(", ",$names).",...\n";
- echo "
\n";
-
- echo "
';
+
+ if($myvacation = check_vacation($myid))
+ {
+ $vac_start = $myvacation[0];
+ $vac_stop = $myvacation[1];
+ $vac_comment = $myvacation[2];
+ echo '
'._("Enjoy your vacation (don't forgot to change your settings once you're back).")." ".
+ _("Between $vac_start and $vac_stop other users will see the following message: $vac_comment.")."
\n";
+ }
+
+ echo '
'._('These are your games').":
\n";
+ /* output legend */
+ echo "
\n";
+ echo ' '._('pre-game phase');
+ echo ' '._('game in progess');
+ echo ' N '._('game over (N people played this hand)').'
';
+ echo ' '._("Reminder: canceling a game can't be reversed!");
+ echo "
\n";
+
+ /* get all games */
+ $output = array();
+ $result = DB_query("SELECT Hand.hash,Hand.game_id,G.mod_date,G.player,G.status, ".
+ " (SELECT count(H.randomnumbers) FROM Game H WHERE H.randomnumbers=G.randomnumbers) AS count, ".
+ " G.session".
+ " FROM Hand".
+ " LEFT JOIN Game G ON G.id=Hand.game_id".
+ " WHERE user_id=".DB_quote_smart($myid).
+ " ORDER BY G.session,G.create_date" );
+
+ /* sort into active and passive sessions */
+ $count = 0; /* count number of games to check for beginner status */
+ $session = -1;
+ $maxgame = 0;
+ $output_active = "";
+ $output_inactive = "";
+ $sessionoutput = "";
+ $gameoutput = "";
+ $keep_going = 2;
+ while( $keep_going )
+ {
+ /* get next element */
+ $r = DB_fetch_array($result);
+
+ if($r)
+ $count++;
+ else
+ {
+ /* need to run the while loop one more time when we run out of elements in the database */
+ $keep_going--;
+ $r[0] = NULL;
+ $r[1] = NULL;
+ $r[2] = NULL;
+ $r[3] = NULL;
+ $r[4] = NULL;
+ $r[5] = NULL;
+ $r[6] = -2;
+ }
+ if( $r[6]==$session )
+ {
+ /* same session, update information */
+ $maxgame++;
+ $myhash = $r[0];
+ $gameid = $r[1];
+ $gamemoddate = $r[2];
+ $userid = $r[3];
+ $gamestatus = $r[4];
+ $gamefrequence = $r[5];
+
+ /* create output */
+ $sessionoutput .= $gameoutput;
+ $gameoutput = "
"
+ .$gamefrequence."\n";
+ }
+ else
+ { /* new session */
+
+ /* output old session if available */
+ if($maxgame)
+ {
+ /* is session active? */
+ if($gamestatus == 'pre' || $gamestatus== 'play' || time()-strtotime($gamemoddate) < 60*60*24*5 )
+ {
+ $output_active .= "
";
+ if($gamestatus == 'pre')
+ $class= 'class="gamestatuspre gameid"';
+ else if($gamestatus == 'play')
+ $class= 'class="gamestatusplay gameid"';
+ else
+ $class= 'class="gamestatusover gameid"';
+ $output_active .= "".
+ DB_format_gameid($gameid).' ';
+
+
+ /* who's turn is it? */
+ if( $gamestatus == 'pre' || $gamestatus == 'play')
+ {
+ $output_active .= '';
+ if($userid==$myid || !$userid)
+ $output_active .= ' '._('your turn')."\n";
+ else
+ {
+ $name = DB_get_name('userid',$userid);
+
+ /* check vacaction status of this user */
+ if($vacation=check_vacation($userid))
+ {
+ $stop = substr($vacation[1],0,10);
+ $title = _('begin:').substr($vacation[0],0,10).' '._('end:').$vacation[1].' '.$vacation[2];
+ $output_active .= " ".
+ sprintf(_("%s's turn"),$name).' '._("(on vacation until $stop)")."\n";
+ }
+ else
+ $output_active .= sprintf(_("%s's turn"),$name)."\n";
+
+ /* check if we need to send out a reminder */
+ if(DB_get_reminder($userid,$gameid)==0)
+ if(time()-strtotime($gamemoddate) > 60*60*24*7)
+ $output_active .= ""._('Send a reminder?').' ';
+
+ };
+ $output_active .= '';
+
+ if(time()-strtotime($gamemoddate) > 60*60*24*30)
+ $output_active .= ""._('Cancel?').' ';
+ }
+
+ if($maxgame>1)
+ {
+ $output_active .= ' '._('show old').''.
+ ' '._('hide old').'
'."\n";
+ $output_active .= ' '.$sessionoutput.'';
+ }
+
+ $output_active .= "\n";
+
+ }
+ else
+ {
+ /* session is not active anymore */
+ $output_inactive .= "
$session:" ;
+ $output_inactive .= $sessionoutput.$gameoutput ;
+ $output_inactive .= "\n";
+ }
+
+ /* reset all session variables */
+ $maxgame = 0;
+ $sessionoutput = "";
+ $gameoutput = "";
+
+ }
+
+ /* save game information */
+ $maxgame++;
+ $myhash = $r[0];
+ $gameid = $r[1];
+ $gamemoddate = $r[2];
+ $userid = $r[3];
+ $gamestatus = $r[4];
+ $gamefrequence = $r[5];
+ $session = $r[6];
+
+ /* create output */
+ $sessionoutput .= $gameoutput;
+ $gameoutput = "
"
+ .$gamefrequence."\n";
+
+ }
+ }
+
+ echo "
\n";
+
+ /* give a hint for new players */
+ if($count<10)
+ echo '
'._('You can start new games using the link in the top right corner!')."
\n";
+
+ /* display last 5 users that have signed up to e-DoKo within the 45 days */
+ $names = DB_get_names_of_new_logins(5);
+ if ($names)
+ {
+ echo '
'._('New Player(s)').":
\n
\n";
+ echo implode(", ",$names).",...\n";
+ echo "
\n";
+ };
+
+ /* display last 5 users that logged on */
+ echo '
'._('Players last logged in').":
\n
\n";
+
+ $names = DB_get_names_of_last_logins(7);
+ $emails = DB_get_emails_of_last_logins(7);
+ for($i=0;$i<7;$i++)
+ {
+ echo ')). "'.$names[$i].
+ '")
\n";
+ }
+ echo "
\n";
+
+ echo "