inc/modules/guest/what-login.php

   1 <?php
   2 /************************************************************************
   3  * MXChange v0.2.1                                    Start: 10/14/2003 *
   4  * ===============                              Last change: 04/28/2004 *
   5  *                                                                      *
   6  * -------------------------------------------------------------------- *
   7  * File              : what-login.php                                   *
   8  * -------------------------------------------------------------------- *
   9  * Short description : Login area (redirects to the real login module)  *
  10  * -------------------------------------------------------------------- *
  11  * Kurzbeschreibung  : Loginbereich (leitet an das richtige Lgin-Modul  *
  12  *                     weiter)                                          *
  13  * -------------------------------------------------------------------- *
  14  *                                                                      *
  15  * -------------------------------------------------------------------- *
  16  * Copyright (c) 2003 - 2008 by Roland Haeder                           *
  17  * For more information visit: http://www.mxchange.org                  *
  18  *                                                                      *
  19  * This program is free software; you can redistribute it and/or modify *
  20  * it under the terms of the GNU General Public License as published by *
  21  * the Free Software Foundation; either version 2 of the License, or    *
  22  * (at your option) any later version.                                  *
  23  *                                                                      *
  24  * This program is distributed in the hope that it will be useful,      *
  25  * but WITHOUT ANY WARRANTY; without even the implied warranty of       *
  26  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the        *
  27  * GNU General Public License for more details.                         *
  28  *                                                                      *
  29  * You should have received a copy of the GNU General Public License    *
  30  * along with this program; if not, write to the Free Software          *
  31  * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston,               *
  32  * MA  02110-1301  USA                                                  *
  33  ************************************************************************/
  34
  35 // Some security stuff...
  36 if (!defined('__SECURITY')) {
  37         $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php";
  38         require($INC);
  39 }
  40
  41 // Add description as navigation point
  42 ADD_DESCR("guest", __FILE__);
  43
  44 global $DATA, $FATAL;
  45
  46 // Initialize data
  47 $probe_nickname = false; $uid = false; $hash = "";
  48 unset($login); unset($online);
  49
  50 if ((!empty($GLOBALS['userid'])) && (isSessionVariableSet('u_hash'))) {
  51         // Already logged in?
  52         $uid = $GLOBALS['userid'];
  53 } elseif ((!empty($_POST['id'])) && (!empty($_POST['password'])) && (isset($_POST['ok']))) {
  54         // Set userid and crypt password when login data was submitted
  55         $probe_nickname = ((EXT_IS_ACTIVE("nickname")) && (("".($_POST['id'] + 0)."") != $_POST['id']));
  56         if ($probe_nickname === true) {
  57                 // Nickname entered
  58                 $uid = SQL_ESCAPE($_POST['id']);
  59         } else {
  60                 // Direct userid entered
  61                 $uid  = bigintval($_POST['id']);
  62         }
  63 } elseif (!empty($_POST['new_pass'])) {
  64         // New password requested
  65         $uid = 0;
  66         if (!empty($_POST['id'])) $uid = $_POST['id'];
  67 } else {
  68         // Not logged in
  69         $uid = 0; $hash = "";
  70 }
  71
  72 $URL = ""; $ADD = "";
  73 // Set unset variables
  74 if (empty($_POST['new_pass'])) $_POST['new_pass'] = "";
  75 if (empty($_GET['login']))     $_GET['login']     = "";
  76
  77 if (IS_MEMBER()) {
  78         // Login immidiately...
  79         $URL = URL."/modules.php?module=login";
  80 } elseif ((isset($_POST['ok'])) && ("".$uid."" != "".$_POST['id']."")) {
  81         // Invalid input (no nickname extension installed but nickname entered)
  82         $ERROR = CODE_EXTENSION_PROBLEM;
  83 } elseif (isset($_POST['ok'])) {
  84         // Add last_login if available
  85         $LAST = "";
  86         if (GET_EXT_VERSION("sql_patches") >= "0.2.8") {
  87                 $LAST = ", last_login";
  88         } // END - if
  89
  90         // Check login data
  91         $password = ""; $uid2 = ""; $dmy = "";
  92         if ($probe_nickname === true) {
  93                 // Nickname entered
  94                 $result = SQL_QUERY_ESC("SELECT userid, password, last_online".$LAST." FROM "._MYSQL_PREFIX."_user_data WHERE nickname='%s' AND status='CONFIRMED' LIMIT 1",
  95                  array($uid), __FILE__, __LINE__);
  96                 list($uid2, $password, $online, $login) = SQL_FETCHROW($result);
  97                 if (!empty($uid2)) $uid = bigintval($uid2);
  98         } else {
  99                 // Direct userid entered
 100                 $result = SQL_QUERY_ESC("SELECT userid, password, last_online".$LAST." FROM "._MYSQL_PREFIX."_user_data WHERE userid=%s AND status='CONFIRMED' LIMIT 1",
 101                  array($uid, $hash), __FILE__, __LINE__);
 102                 list($dmy, $password, $online, $login) = SQL_FETCHROW($result);
 103         }
 104
 105         // Is there an entry?
 106         if ((SQL_NUMROWS($result) == 1) && ((($probe_nickname) && (!empty($uid2))) || ($dmy == $uid))) {
 107                 // Free result
 108                 SQL_FREERESULT($result);
 109
 110                 // By default the hash is empty
 111                 $hash = "";
 112
 113                 // Check for old MD5 passwords
 114                 if ((strlen($password) == 32) && (md5($_POST['password']) == $password)) {
 115                         // Just set the hash to the password from DB... :)
 116                         $hash = $password;
 117                 } else {
 118                         // Encrypt hash for comparsion
 119                         $hash = generateHash($_POST['password'], substr($password, 0, -40));
 120                 }
 121
 122                 if ($hash == $password) {
 123                         // New hashed password found so let's generate a new one
 124                         $hash = generateHash($_POST['password']);
 125
 126                         // ... and update database
 127                         $result_update = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data SET password='%s' WHERE userid=%s AND status='CONFIRMED' LIMIT 1",
 128                          array($hash, $uid), __FILE__, __LINE__);
 129
 130                         // No login bonus by default
 131                         $BONUS = false;
 132
 133                         // Probe for last online timemark
 134                         $probe = time() -  $online;
 135                         if (!empty($login)) $probe = time() - $login;
 136                         if ((GET_EXT_VERSION("bonus") >= "0.2.2") && ($probe >= $_CONFIG['login_timeout'])) {
 137                                 // Add login bonus to user's account
 138                                 $ADD = ", login_bonus=login_bonus+'".$_CONFIG['login_bonus']."'";
 139                                 $BONUS = true;
 140
 141                                 // Subtract login bonus from userid's account or jackpot
 142                                 if ((GET_EXT_VERSION("bonus") >= "0.3.5") && ($_CONFIG['bonus_mode'] != "ADD")) BONUS_POINTS_HANDLER('login_bonus');
 143                         } // END - if
 144
 145
 146                         // Secure lifetime from input form
 147                         $l = bigintval($_POST['lifetime']);
 148                         $life = "-1";
 149                         if ($l > 0) {
 150                                 // Calculate lifetime of cookies
 151                                 $life = time() + $l;
 152
 153                                 // Calculate new hash with the secret key and master salt together
 154                                 $hash = generatePassString($hash);
 155
 156                                 // Update cookies
 157                                 $login = (set_session("userid"  , $uid , $life, COOKIE_PATH)
 158                                        && set_session("u_hash"  , $hash, $life, COOKIE_PATH)
 159                                        && set_session("lifetime", $l   , $life, COOKIE_PATH));
 160
 161                                 // Update global array
 162                                 $GLOBALS['userid'] = $uid;
 163                         } else {
 164                                 // Check for login data
 165                                 $login = IS_MEMBER();
 166                         }
 167
 168                         if ($login) {
 169                                 // Update database records
 170                                 $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data SET total_logins=total_logins+1".$ADD." WHERE userid=%s LIMIT 1",
 171                                  array($uid), __FILE__, __LINE__);
 172                                 if (SQL_AFFECTEDROWS() == 1) {
 173                                         // Procedure to checking for login data
 174                                         if (($BONUS) && (EXT_IS_ACTIVE("bonus"))) {
 175                                                 // Bonus added (just displaying!)
 176                                                 $URL = URL."/modules.php?module=chk_login&amp;mode=bonus";
 177                                         } else {
 178                                                 // Bonus not added
 179                                                 $URL = URL."/modules.php?module=chk_login&amp;mode=login";
 180                                         }
 181                                 } else {
 182                                         // Cannot update counter!
 183                                         $URL = URL."/modules.php?module=index&amp;what=login&amp;login=".CODE_CNTR_FAILED;
 184                                 }
 185                         } else {
 186                                 // Cookies not setable!
 187                                 $URL = URL."/modules.php?module=index&amp;what=login&amp;login=".CODE_NO_COOKIES;
 188                         }
 189                 } else {
 190                         // Update failture counter
 191                         SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data SET login_failtures=login_failtures+1,last_failture=NOW() WHERE userid=%s LIMIT 1",
 192                                 array($uid), __FILE__, __LINE__);
 193
 194                         // Wrong password!
 195                         $ERROR = CODE_WRONG_PASS;
 196                 }
 197         } elseif ((($probe_nickname) && (!empty($uid2))) || ($dmy == $uid)) {
 198                 // Other account status?
 199                 $result = SQL_QUERY_ESC("SELECT status FROM "._MYSQL_PREFIX."_user_data WHERE userid=%s LIMIT 1",
 200                  array($uid), __FILE__, __LINE__);
 201
 202                 // Entry found?
 203                 if (SQL_NUMROWS($result) == 1) {
 204                         // Load status
 205                         list($status) = SQL_FETCHROW($result);
 206                         switch ($status) {
 207                                 case "LOCKED":
 208                                         $ERROR = CODE_ID_LOCKED;
 209                                         break;
 210
 211                                 case "UNCONFIRMED":
 212                                         $ERROR = CODE_ID_UNCONFIRMED;
 213                                         break;
 214
 215                                 default:
 216                                         $ERROR = CODE_UNKNOWN_STATUS;
 217                                         break;
 218                         }
 219                 } else {
 220                         // ID not found!
 221                         $ERROR = CODE_WRONG_ID;
 222                 }
 223
 224                 // Construct URL
 225                 $URL = URL."/modules.php?module=index&amp;what=login&amp;login=".$ERROR;
 226         } else {
 227                 // ID not found!
 228                 $ERROR = CODE_WRONG_ID;
 229         }
 230 } elseif ((!empty($_POST['new_pass'])) && (isset($uid))) {
 231         // Compile email when found in address (only secure chars!)
 232         if (!empty($_POST['email'])) $_POST['email'] = str_replace("{DOT}", '.', $_POST['email']);
 233
 234         // Set ID number when left empty
 235         if (empty($_POST['id'])) $_POST['id'] = 0;
 236
 237         // Probe userid/nickname
 238         $probe_nickname = ((EXT_IS_ACTIVE("nickname")) && (("".round($_POST['id'])."") != $_POST['id']));
 239         if ($probe_nickname) {
 240                 // Nickname entered
 241                 $result = SQL_QUERY_ESC("SELECT userid, status FROM "._MYSQL_PREFIX."_user_data WHERE nickname='%s' OR email='%s' LIMIT 1",
 242                  array(addslashes($uid), $_POST['email']), __FILE__, __LINE__);
 243         } else {
 244                 // Direct userid entered
 245                 $result = SQL_QUERY_ESC("SELECT userid, status FROM "._MYSQL_PREFIX."_user_data WHERE userid=%s OR email='%s' LIMIT 1",
 246                  array($uid, $_POST['email']), __FILE__, __LINE__);
 247         }
 248
 249         // Any entry found?
 250         if (SQL_NUMROWS($result) == 1) {
 251                 // This data is valid, so we create a new pass... :-)
 252                 list($uid, $status) = SQL_FETCHROW($result);
 253
 254                 if ($status == "CONFIRMED") {
 255                         // Ooppps, this was missing! ;-) We should update the database...
 256                         $NEW_PASS = GEN_PASS();
 257                         $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data SET password='%s' WHERE userid=%s LIMIT 1",
 258                          array(generateHash($NEW_PASS), $uid), __FILE__, __LINE__);
 259
 260                         // Prepare data and message for email
 261                         $msg = LOAD_EMAIL_TEMPLATE("new-pass", array('new_pass' => $NEW_PASS), $uid);
 262
 263                         // ... and send it away
 264                         SEND_EMAIL($uid, GUEST_NEW_PASSWORD, $msg);
 265
 266                         // Output note to user
 267                         LOAD_TEMPLATE("admin_settings_saved", false, GUEST_NEW_PASSWORD_SEND);
 268                 } else {
 269                         // Account is locked or unconfirmed
 270                         switch ($status) {
 271                                 case "LOCKED"     : $MSG = CODE_ID_LOCKED;      break;
 272                                 case "UNCONFIRMED": $MSG = CODE_ID_UNCONFIRMED; break;
 273                         }
 274
 275                         // Load URL
 276                         LOAD_URL("modules.php?module=index&amp;what=login&amp;login=".$MSG);
 277                 }
 278         } else {
 279                 // ID or email is wrong
 280                 LOAD_TEMPLATE("admin_settings_saved", false, "<SPAN class=\"guest_failed\">".GUEST_WRONG_ID_EMAIL."</SPAN>");
 281         }
 282 }
 283
 284 // Login problems?
 285 if (!empty($_GET['login'])) {
 286         // Use code from URL
 287         $ERROR = SQL_ESCAPE($_GET['login']);
 288 } // END  - if
 289
 290 // Login problems?
 291 if (!empty($ERROR)) {
 292         // Ok, which one now?
 293         $MSG = "<TR>
 294   <TD width=\"10\">&nbsp;</TD>
 295   <TD colspan=\"7\" align=\"center\">
 296     <STRONG><SPAN class=\"guest_failed\">";
 297
 298         switch ($ERROR) {
 299                 case CODE_WRONG_PASS:
 300                         $MSG .= LOGIN_WRONG_PASS;
 301                         break;
 302
 303                 case CODE_WRONG_ID:
 304                         $MSG .= LOGIN_WRONG_ID;
 305                         break;
 306
 307                 case CODE_ID_LOCKED:
 308                         $MSG .= LOGIN_ID_LOCKED;
 309                         break;
 310
 311                 case CODE_ID_UNCONFIRMED:
 312                         $MSG .= LOGIN_ID_UNCONFIRMED;
 313                         break;
 314
 315                 case CODE_NO_COOKIES:
 316                         $MSG .= LOGIN_NO_COOKIES;
 317                         break;
 318
 319                 case CODE_EXTENSION_PROBLEM:
 320                         if (IS_ADMIN()) {
 321                                 $MSG .= sprintf(EXTENSION_PROBLEM_NOT_INSTALLED, "nickname");
 322                         } else {
 323                                 $MSG .= LOGIN_WRONG_ID;
 324                         }
 325                         break;
 326
 327                 default:
 328                         $MSG .= LOGIN_WRONG_ID;
 329                         break;
 330                 }
 331                 $MSG .= "</SPAN></STRONG>
 332   </TD>
 333   <TD width=\"10\">&nbsp;</TD>
 334 </TR>\n";
 335                 define('LOGIN_FAILURE_MSG', $MSG);
 336 } else {
 337         // No problems, no output
 338         define('LOGIN_FAILURE_MSG', "");
 339 }
 340
 341 // Display login form with resend-password form
 342 if (EXT_IS_ACTIVE("nickname")) {
 343         LOAD_TEMPLATE("guest_nickname_login");
 344 } else {
 345         LOAD_TEMPLATE("guest_login");
 346 }
 347
 348 // Was an URL constructed?
 349 if (!empty($URL)) {
 350         // URL was constructed
 351         if (!empty($FATAL[0])) {
 352                 // Fatal errors!
 353                 require_once(PATH."inc/fatal_errors.php");
 354         } else {
 355                 // Load URL
 356                 LOAD_URL($URL);
 357         }
 358 } // END - if
 359
 360 //
 361 ?>