fix error when language is not set

[e-DoKo.git] / include / user.php

diff --git a/include/user.php b/include/user.php
index 6cc96370bac78718f1e1a8510cecd5be7213e339..5142918fbb9188dd564831c82d377cf6577a8d45 100644 (file)
--- a/include/user.php
+++ b/include/user.php
@@ -1,4 +1,23 @@
 <?php
 <?php

+/* Copyright 2006, 2007, 2008, 2009, 2010, 2011, 2012, 2013, 2014, 2016 Arun Persaud <arun@nubati.net>
+ *
+ *   This file is part of e-DoKo.
+ *
+ *   e-DoKo is free software: you can redistribute it and/or modify
+ *   it under the terms of the GNU General Public License as published by
+ *   the Free Software Foundation, either version 3 of the License, or
+ *   (at your option) any later version.
+ *
+ *   e-DoKo is distributed in the hope that it will be useful,
+ *   but WITHOUT ANY WARRANTY; without even the implied warranty of
+ *   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+ *   GNU General Public License for more details.
+ *
+ *   You should have received a copy of the GNU General Public License
+ *   along with e-DoKo.  If not, see <http://www.gnu.org/licenses/>.
+ *
+ */
+

 /* make sure that we are not called from outside the scripts,
  * use a variable defined in config.php to check this
  */
 /* make sure that we are not called from outside the scripts,
  * use a variable defined in config.php to check this
  */


@@ -6,20 +25,21 @@ if(!isset($HOST))
   exit;
 
 /* test id and password, should really be done in one step */
   exit;
 
 /* test id and password, should really be done in one step */

-if(!isset($_SESSION["name"]))
-  {
-    $email     = $_REQUEST["email"];
-    $password  = $_REQUEST["password"];
-  }
-else
+if(isset($_SESSION['id']))

   {
   {

-    $name = $_SESSION["name"];
-    $email     = DB_get_email('name',$name);
-    $password  = DB_get_passwd_by_name($name);
+    $myid = $_SESSION['id'];
+    $r = DB_query_array("SELECT email,password FROM User WHERE id=".DB_quote_smart($myid)."");
+    if($r)
+      {
+       $email     = $r[0];
+       $password  = $r[1];
+      };

   };
 
   };
 

+global  $ADMIN_NAME;
+

 /* user has forgotten his password */
 /* user has forgotten his password */

-if(myisset("forgot"))
+if(myisset('forgot'))

   {
     /* check if player is in the database */
     $ok = 1;
   {
     /* check if player is in the database */
     $ok = 1;


@@ -30,31 +50,34 @@ if(myisset("forgot"))
 
     if($ok)
       {
 
     if($ok)
       {

+       set_language($myid,'uid');
+

        /* check how many entries in recovery table */
        $number = DB_get_number_of_passwords_recovery($myid);
 
        /* if less than N recent ones, add a new one and send out email */
        if( $number < 5 )
          {
        /* check how many entries in recovery table */
        $number = DB_get_number_of_passwords_recovery($myid);
 
        /* if less than N recent ones, add a new one and send out email */
        if( $number < 5 )
          {

-           echo "Ok, I send you a new password. <br />";
+           echo _('Ok, I will send you a new password.').' <br />';

            if($number >1)
            if($number >1)

-             echo "N.B. You tried this already $number times during the last day and it will only work ".
-               " 5 times during a day.<br />";
-           echo "The new password will be valid for one day, make sure you reset it to something else.<br />";
-           echo "Back to the  <a href=\"$INDEX\">main page</a>.";
+             echo sprintf(_("N.B. You tried this already %s times during the last day and it will only work".
+                            " 5 times during a day."),$number)."<br />\n";
+           echo _('The new password will be valid for one day, make sure you reset it to something else.').'<br />';
+           echo sprintf(_('Back to the <a href="%s">main page</a>.'),$INDEX);

 
            /* create temporary password, use the fist 8 letters of a md5 hash */
            $TIME  = (string) time(); /* to avoid collisions */
 
            /* create temporary password, use the fist 8 letters of a md5 hash */
            $TIME  = (string) time(); /* to avoid collisions */

-           $hash  = md5("Anewpassword".$email.$TIME);
+           $rndstring = sha1(rand()); /* add some randomness */
+           $hash  = md5('Anewpassword'.$email.$TIME.$rndstring);

            $newpw = substr($hash,1,8);
 
            $newpw = substr($hash,1,8);
 

-           $message = "Someone (hopefully you) requested a new password. \n".
-             "You can use this email and the following password: \n".
-             "   $newpw    \n".
+           $message = sprintf( _("Someone (hopefully you) requested a new password.\n".
+             "You can use this email and the following password:\n".
+             "   %s\n".

              "to log into the server. The new password is valid for 24h, so make\n".
              "sure you reset your password to something new. Your old password will\n".
              "to log into the server. The new password is valid for 24h, so make\n".
              "sure you reset your password to something new. Your old password will\n".

-             " also still be valid until you set a new one\n";
-           mymail($email,$EmailName."recovery ",$message);
+             "also still be valid until you set a new one.\n"), $newpw);
+           mymail($myid,0, GAME_RECOVERY, $message);

 
            /* we save these in the database */
            DB_set_recovery_password($myid,md5($newpw));
 
            /* we save these in the database */
            DB_set_recovery_password($myid,md5($newpw));


@@ -63,9 +86,9 @@ if(myisset("forgot"))
          {
            /* make it so that people (or a robot) can request thousands of passwords within a short time
             * and spam a user this way */
          {
            /* make it so that people (or a robot) can request thousands of passwords within a short time
             * and spam a user this way */

-           echo "Sorry you already tried 5 times during the last 24h.<br />".
-             "You need to use one of those passwords or wait to get a new one.<br />";
-           echo "Back to the <a href=\"$INDEX\">main page</a>.";
+           echo _('Sorry you already tried 5 times during the last 24h.<br />'.
+                  'You need to use one of those passwords or wait to get a new one.').'<br />';
+           echo sprintf(_('Back to the <a href="%s">main page</a>.'),$INDEX);

          }
       }
     else
          }
       }
     else


@@ -73,149 +96,254 @@ if(myisset("forgot"))
 
        /* no email given? */
        if($email=="")
 
        /* no email given? */
        if($email=="")

-         echo "You need to give me an email address! <br />".
-           "Please try <a href=\"$INDEX\">again</a>.";
+         echo _('You need to give me an email address!')." <br />".
+           sprintf(_('Please try <a href="%s">again</a>.'),$INDEX);

        else /* default error message */
        else /* default error message */

-         echo "Couldn't find a player with this email! <br />".
-           "Please contact Arun, if you think this is a mistake <br />".
-           "or else try <a href=\"$INDEX\">again</a>.";
+         echo _("Couldn't find a player with this email!")."<br />".
+           sprintf(_('Please contact %s, if you think this is a mistake '.
+                     'or else try <a href="%s">again</a>.'),$ADMIN_NAME, $INDEX );

       }
   }
 else
   { /* normal user page */
 
     /* verify password and email */
       }
   }
 else
   { /* normal user page */
 
     /* verify password and email */

-    if(strlen($password)!=32)
-      $password = md5($password);
-

     $ok  = 1;
     $ok  = 1;

-    $myid = DB_get_userid('email-password',$email,$password);
-    if(!$myid)
+    if(isset($email, $password))
+      {
+       $myid = DB_get_userid('email-password',$email,$password);
+        if(!$myid)
+         $ok = 0;
+      }
+    else

       $ok = 0;
 
     if($ok)
       {
        /* user information is ok */
        $myname = DB_get_name('email',$email);
       $ok = 0;
 
     if($ok)
       {
        /* user information is ok */
        $myname = DB_get_name('email',$email);

-       $_SESSION["name"] = $myname;
+       $_SESSION['name'] = $myname;

 
        $PREF = DB_get_PREF($myid);
 
        $PREF = DB_get_PREF($myid);

+       /* set language chosen in preferences, will become active on the next reload (see index.php)*/
+       $_SESSION['language'] = $PREF['language'];
+       set_language($PREF['language']);

 
        DB_update_user_timestamp($myid);
 
        display_user_menu($myid);
 
        /* display all games the user has played */
 
        DB_update_user_timestamp($myid);
 
        display_user_menu($myid);
 
        /* display all games the user has played */

-       echo "<div class=\"user\">";
+       echo '<div class="user">';

 
        if($myvacation = check_vacation($myid))
          {
            $vac_start   = $myvacation[0];
            $vac_stop    = $myvacation[1];
            $vac_comment = $myvacation[2];
 
        if($myvacation = check_vacation($myid))
          {
            $vac_start   = $myvacation[0];
            $vac_stop    = $myvacation[1];
            $vac_comment = $myvacation[2];

-           echo "<p class=\"vacation\">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.</p>\n";
+           echo '<p class="vacation">'._("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.")."</p>\n";

          }
 
          }
 

-       echo "<h4>These are all your games:</h4>\n";
+       echo '<h4>'._('These are your games').":</h4>\n";

        /* output legend */
        /* output legend */

-       echo "<p>Session: <br />\n";
-       echo "<span class=\"gamestatuspre\"> p </span> =  pre-game phase ";
-       echo "<span class=\"gamestatusplay\">P </span> =  game in progess ";
-       echo "<span class=\"gamestatusover\">E </span> =  game ended ";
-       echo "<span class=\"gamestatusover multi\"><a>N</a> </span> =  N games with same hand <br />";
+       echo "<p>\n";
+       echo ' <span class="gamestatuspre"> &nbsp; </span> &nbsp;'._('pre-game phase');
+       echo ' <span class="gamestatusplay"> &nbsp; </span> &nbsp;'._('game in progess');
+       echo ' <span class="gamestatusover "><a>N</a> </span> &nbsp;'._('game over (N people played this hand)').' <br />';
+       echo ' '._("Reminder: canceling a game can't be reversed!");

        echo "</p>\n";
 
        echo "</p>\n";
 

+       /* get all games */

        $output = array();
        $result = DB_query("SELECT Hand.hash,Hand.game_id,G.mod_date,G.player,G.status, ".
        $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 ".
+                          " (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".
                           " FROM Hand".
                           " LEFT JOIN Game G ON G.id=Hand.game_id".

-                          " WHERE user_id='$myid'".
+                          " WHERE user_id=".DB_quote_smart($myid).

                           " ORDER BY G.session,G.create_date" );
 
                           " ORDER BY G.session,G.create_date" );
 

-       $gamenrold = -1;
-       $count = 0;
-       echo "<table>\n <tr><td>\n";
-       while( $r = DB_fetch_array($result))
+       /* 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 )

          {
          {

-           $count++;
-           $game = DB_format_gameid($r[1]);
-           $gamenr = (int) $game;
-           if($gamenrold < $gamenr)
+           /* get next element */
+           $r = DB_fetch_array($result);
+
+           if($r)
+             $count++;
+           else

              {
              {

-               if($gamenrold!=-1)
-                 echo "</td></tr>\n <tr> <td>$gamenr:</td>\n";
-               else
-                 echo "$gamenr:</td>\n";
-               $gamenrold = $gamenr;
-               echo "<td class=\"usergames\">\n";
+               /* 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;

              }
              }

-           $Multi = ($r[5]>1) ? "multi" : "";
-           if($r[4]=='pre')
-             echo "   <span class=\"gamestatuspre $Multi\"><a href=\"".$INDEX."?action=game&amp;me=".$r[0]."\">p </a></span>\n";
-           else if ($r[4]=='gameover')
-           {
-             echo "   <span class=\"gamestatusover $Multi\"><a href=\"".$INDEX."?action=game&amp;me=".$r[0]."\">";
-             if($r[5]<2)
-               echo "E ";
-             else
-               echo $r[5];
-             echo "</a></span>\n";
-           }
-           else
-             echo "   <span class=\"gamestatusplay $Multi\"><a href=\"".$INDEX."?action=game&amp;me=".$r[0]."\">P </a></span>\n";
-           if($r[4] != 'gameover')
+           if( $r[6]==$session )

              {
              {

-               echo "</td>\n<td>\n    ";
-               if($r[3]==$myid || !$r[3])
-                 echo "(it's <strong>your</strong> turn)\n";
-               else
+               /* 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     = "  <a class=\"gamestatusover\" href=\"".$INDEX."?action=game&amp;me=".$myhash."\">"
+                 .$gamefrequence."</a>\n";
+             }
+           else
+             { /* new session */
+
+               /* output old session if available */
+               if($maxgame)

                  {
                  {

-                   $name = DB_get_name('userid',$r[3]);
-                   $gameid = $r[1];
-                   /* check if we need to send out a reminder */
-                   if(DB_get_reminder($r[3],$gameid)==0)
-                     if(time()-strtotime($r[2]) > 60*60*24*7)
-                       echo "<a href=\"$INDEX?action=reminder&amp;me=".$r[0]."\">Send a reminder.</a>";
-
-                   /* check vacaction status of this user */
-                   if($vacation=check_vacation($r[3]))
+                   /* is session active? */
+                   if($gamestatus == 'pre' || $gamestatus== 'play' || time()-strtotime($gamemoddate) < 60*60*24*5 )

                      {
                      {

-                       $stop = substr($vacation[1],0,10);
-                       $title = 'begin:'.substr($vacation[0],0,10).' end:'.$vacation[1].' '.$vacation[2];
-                       echo "(it's <span class=\"vacation\" title=\"$title\">$name's (on vacation until $stop)</span> turn)\n";
+                       $output_active .= "<li> ";
+                       if($gamestatus == 'pre')
+                         $class= 'class="gamestatuspre gameid"';
+                       else if($gamestatus == 'play')
+                         $class= 'class="gamestatusplay gameid"';
+                       else
+                         $class= 'class="gamestatusover gameid"';
+                       $output_active .= "<a $class href=\"$INDEX?action=game&amp;me=$myhash\">".
+                         DB_format_gameid($gameid).'</a>&nbsp;&nbsp;&nbsp;';
+
+
+
+                       /* who's turn is it? */
+                       if( $gamestatus == 'pre' || $gamestatus == 'play')
+                         {
+                           $output_active .= '<span class="turn">';
+                           if($userid==$myid || !$userid)
+                             $output_active .= ' <strong>'._('your turn')."</strong>\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 .= " <span class=\"vacation\" title=\"$title\">".
+                                     sprintf(_("%s's turn"),$name).' '._("(on vacation until $stop)")."</span>\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 .= "<a href=\"$INDEX?action=reminder&amp;me=".$myhash."\">"._('Send a reminder?').'</a> ';
+
+                             };
+                           $output_active .= '</span>';
+
+                           if(time()-strtotime($gamemoddate) > 60*60*24*30)
+                             $output_active .= "<a href=\"$INDEX?action=cancel&amp;me=".$myhash."\">"._('Cancel?').'</a> ';
+                         }
+
+                       if($maxgame>1)
+                         {
+                           $output_active .= ' <span class="gamesshowsession"><a href="#">'._('show old').'</a></span>'.
+                             '  <span class="gameshidesession"><a href="#">'._('hide old').'</a></span><br />'."\n";
+                           $output_active .= ' <span class="gamessession">'.$sessionoutput.'</span>';
+                         }
+
+                       $output_active .= "</li>\n";
+

                      }
                    else
                      }
                    else

-                     echo "(it's $name's turn)\n";
-                 };
-               if(time()-strtotime($r[2]) > 60*60*24*30)
-                 echo "<a href=\"$INDEX?action=cancel&amp;me=".$r[0]."\">Cancel?</a>".
-                   " (clicking here is final and can't be restored)";
+                     {
+                       /* session is not active anymore */
+                       $output_inactive .= "<li> $session:" ;
+                       $output_inactive .= $sessionoutput.$gameoutput ;
+                       $output_inactive .= "</li>\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     = "   <span class=\"gamestatusover \"><a href=\"".$INDEX."?action=game&amp;me=".$myhash."\">"
+                 .$gamefrequence."</a></span>\n";
+

              }
          }
              }
          }

-       echo "</td></tr>\n</table>\n";
+
+       echo "<ul>\n ";
+       echo ' <li><span class="gameshowall"><a href="#">'._('show all').'</a></span> <span class="gamehideall"><a href="#">'._('hide all')."</a></span></li>\n";
+       echo $output_active;
+       echo ' <li><span class="gamesshowsession"><a href="#">'._('show inactive').'</a></span><span class="gameshidesession"><a href="#">'._('hide inactive').'</a></span><ul class="gamessession">'."$output_inactive </ul></li>";
+       echo "</ul>\n";

 
        /* give a hint for new players */
        if($count<10)
 
        /* give a hint for new players */
        if($count<10)

-         echo "<p class=\"newbiehint\">You can start new games using the link in the top right corner!</p>\n";
+         echo '<p class="newbiehint">'._('You can start new games using the link in the top right corner!')."</p>\n";

 
 

-       /* display last 5 users that have signed up to e-DoKo */
+       /* display last 5 users that have signed up to e-DoKo within the 45 days */

        $names = DB_get_names_of_new_logins(5);
        $names = DB_get_names_of_new_logins(5);

-       echo "<h4>New Players:</h4>\n<p>\n";
-       echo implode(", ",$names).",...\n";
-       echo "</p>\n";
+        if ($names)
+         {
+           echo '<h4>'._('New Player(s)').":</h4>\n<p>\n";
+           echo implode(", ",$names).",...\n";
+           echo "</p>\n";
+         };

 
        /* display last 5 users that logged on */
 
        /* display last 5 users that logged on */

-       $names = DB_get_names_of_last_logins(5);
-       echo "<h4>Players last logged in:</h4>\n<p>\n";
-       echo implode(", ",$names).",...\n";
+       echo '<h4>'._('Players last logged in').":</h4>\n<p>\n";
+
+       $names  = DB_get_names_of_last_logins(7);
+       $emails = DB_get_emails_of_last_logins(7);
+       for($i=0;$i<7;$i++)
+         {
+           echo '<img class="gravatar" title="'.$names[$i].
+             '" src="https://www.gravatar.com/avatar/'.
+             md5(strtolower(trim($emails[$i])))."?d=identicon\" />\n";
+         }

        echo "</p>\n";
 
        echo "</div>\n";
       }
     else
       {
        echo "</p>\n";
 
        echo "</div>\n";
       }
     else
       {

-       echo "<div class=\"message\">Sorry email and password don't match. Please <a href=\"$INDEX\">try again</a>. </div>";
+       echo '<div class="message">'."\n";
+       echo  sprintf(_("Sorry email and password don't match. Please <a href=\"%s\">try again</a>."),$INDEX);
+       echo '</div>'."\n";

       }
   };
 ?>
\ No newline at end of file
       }
   };
 ?>
\ No newline at end of file