Location: PHPKode > projects > My little forum > forum/includes/auto_login.inc.php
<?php
if(!defined('IN_INDEX'))
 {
  header('Location: ../index.php');
  exit;
 }

if(empty($_SESSION[$settings['session_prefix'].'user_id']) && isset($_COOKIE[$settings['session_prefix'].'auto_login']) && isset($settings['autologin']) && $settings['autologin'] == 1)
 {
  // clear up expired auto_login_codes:
  #if($settings['autologin']==1) @mysql_query("UPDATE ".$db_settings['userdata_table']." SET auto_login_code='' WHERE auto_login_code != '' AND last_login < (NOW() - INTERVAL ".$settings['cookie_validity_days']." DAY)", $connid);

  $auto_login_code = substr($_COOKIE[$settings['session_prefix'].'auto_login'],0,50);
  $auto_login_id = intval(substr($_COOKIE[$settings['session_prefix'].'auto_login'],50));
  if(isset($auto_login_id) && $auto_login_id>0 && isset($auto_login_code) && trim($auto_login_code)!='')
   {
    $result = mysql_query("SELECT user_id, user_name, user_pw, user_type, UNIX_TIMESTAMP(last_login) AS last_login, UNIX_TIMESTAMP(last_logout) AS last_logout, thread_order, user_view, sidebar, fold_threads, thread_display, category_selection, auto_login_code, activate_code, language, time_zone, time_difference, theme, entries_read FROM ".$db_settings['userdata_table']." WHERE user_id = ".intval($auto_login_id), $connid) or raise_error('database_error',mysql_error());
    if(mysql_num_rows($result)==1)
     {
      $feld = mysql_fetch_array($result);
      if(strlen($feld['auto_login_code'])==50 && $auto_login_code==$feld['auto_login_code'] && trim($feld['activate_code']==''))
       {
        $user_id = $feld['user_id'];
        $user_name = $feld['user_name'];
        $user_type = $feld['user_type'];
        $usersettings['newtime'] = $feld['last_logout'];
        $usersettings['user_view'] = $feld['user_view'];
        $usersettings['thread_order'] = $feld['thread_order'];
        $usersettings['sidebar'] = $feld['sidebar'];
        $usersettings['fold_threads'] = $feld['fold_threads'];
        $usersettings['thread_display'] = $feld['thread_display'];
        $usersettings['page'] = 1;
        $usersettings['category'] = 0;
        $usersettings['latest_postings'] = 1;
        if(empty($feld['entries_read'])) $usersettings['read'] = array();
        else $usersettings['read'] = explode(',',$feld['entries_read']);

        if(!is_null($feld['category_selection']))
         {
          $category_selection = explode(',',$feld['category_selection']);
          $usersettings['category_selection'] = $category_selection;
         }

        if($feld['language']!='')
          {
           $languages = get_languages();
           if(isset($languages) && in_array($feld['language'], $languages))
            {
             $usersettings['language'] = $feld['language'];
             $language_update = $feld['language'];
            }
          }
        if(empty($language_update)) $language_update = '';

        if($feld['theme']!='')
          {
           $themes = get_themes();
           if(isset($themes) && in_array($feld['theme'], $themes))
            {
             $usersettings['theme'] = $feld['theme'];
             $theme_update = $feld['theme'];
            }
          }
        if(empty($theme_update)) $theme_update = '';

        if($feld['time_zone']!='')
          {
           if(function_exists('date_default_timezone_set') && $time_zones = get_timezones())
            {
             if(in_array($feld['time_zone'], $time_zones))
              {
               $usersettings['time_zone'] = $feld['time_zone'];
               $time_zone_update = $feld['time_zone'];
              }
            }
          }
        if(empty($time_zone_update)) $time_zone_update = '';

        if(!empty($feld['time_difference'])) $usersettings['time_difference'] = $feld['time_difference'];

        #if(isset($read)) $read_before_logged_in = $read; // get read postings from cookie (read before logged in)

        $_SESSION[$settings['session_prefix'].'user_id'] = $user_id;
        $_SESSION[$settings['session_prefix'].'user_name'] = $user_name;
        $_SESSION[$settings['session_prefix'].'user_type'] = $user_type;
        $_SESSION[$settings['session_prefix'].'usersettings'] = $usersettings;

        $read = set_read($usersettings['read']);
        #if(isset($read_before_logged_in)) $read = set_read($read_before_logged_in); // get read postings from cookie (read before logged in)
        save_read(false);

        @mysql_query("UPDATE ".$db_settings['userdata_table']." SET logins=logins+1, last_login=NOW(), last_logout=NOW(), user_ip='".mysql_real_escape_string($_SERVER['REMOTE_ADDR'])."', pwf_code='', language='".mysql_real_escape_string($language_update)."', time_zone='".mysql_real_escape_string($time_zone_update)."', theme='".mysql_real_escape_string($theme_update)."' WHERE user_id=".intval($user_id), $connid);

        // auto delete spam:
        if($user_type>0 && $settings['auto_delete_spam']>0) @mysql_query("DELETE FROM ".$db_settings['forum_table']." WHERE time < (NOW() - INTERVAL ".$settings['auto_delete_spam']." HOUR) AND spam=1", $connid);
        setcookie($settings['session_prefix'].'auto_login',$_COOKIE[$settings['session_prefix'].'auto_login'],TIMESTAMP+(3600*24*$settings['cookie_validity_days']));
        if($db_settings['useronline_table'] != "")
         {
          @mysql_query("DELETE FROM ".$db_settings['useronline_table']." WHERE ip = '".$_SERVER['REMOTE_ADDR']."'", $connid);
         }
       }
      else
       {
        if($settings['temp_block_ip_after_repeated_failed_logins']==1) count_failed_logins();
        setcookie($settings['session_prefix'].'auto_login','',0);
       }
     }
    else
     {
      if($settings['temp_block_ip_after_repeated_failed_logins']==1) count_failed_logins();
      setcookie($settings['session_prefix'].'auto_login','',0);
     }
    }
   else
    {
     if($settings['temp_block_ip_after_repeated_failed_logins']==1) count_failed_logins();
     setcookie($settings['session_prefix'].'auto_login','',0);
    }
 }
Return current item: My little forum