typo
[lhc/web/wiklou.git] / includes / User.php
index d53e30c..572060b 100644 (file)
@@ -1,7 +1,7 @@
 <?php
 # See user.doc
 
-include_once( "WatchedItem.php" );
+require_once( "WatchedItem.php" );
 
 class User {
        /* private */ var $mId, $mName, $mPassword, $mEmail, $mNewtalk;
@@ -11,6 +11,8 @@ class User {
        /* private */ var $mBlockedby, $mBlockreason;
        /* private */ var $mTouched;
        /* private */ var $mCookiePassword;
+        /* private */ var $mRealName;
+       /* private */ var $mUserTable;
 
        function User()
        {
@@ -35,16 +37,29 @@ class User {
                return wfGetSQL( "user", "user_name", "user_id=$id" );
        }
 
+       /* static */ function whoIsReal( $id )
+       {
+               return wfGetSQL( "user", "user_real_name", "user_id=$id" );
+       }
+
        /* static */ function idFromName( $name )
        {
+               global $wgIsPg;
                $nt = Title::newFromText( $name );
-               $sql = "SELECT user_id FROM user WHERE user_name='" .
+               if( is_null( $nt ) ) {
+                       # Illegal name
+                       return null;
+               }
+               $usertable=$wgIsPg?'"user"':'user';
+               $sql = "SELECT user_id FROM $usertable WHERE user_name='" .
                  wfStrencode( $nt->getText() ) . "'";
                $res = wfQuery( $sql, DB_READ, "User::idFromName" );
 
-               if ( 0 == wfNumRows( $res ) ) { return 0; }
-               else {
+               if ( 0 == wfNumRows( $res ) ) {
+                       return 0;
+               } else {
                        $s = wfFetchObject( $res );
+                       wfFreeResult( $res );
                        return $s->user_id;
                }
        }
@@ -70,7 +85,7 @@ class User {
 
        function loadDefaults()
        {
-               global $wgLang, $wgIP;
+               global $wgLang, $wgIP, $wgIsPg;
                global $wgNamespacesToBeSearchedDefault;
 
                $this->mId = $this->mNewtalk = 0;
@@ -78,7 +93,7 @@ class User {
                $this->mEmail = "";
                $this->mPassword = $this->mNewpassword = "";
                $this->mRights = array();
-               $defOpt = $wgLang->getDefaultAnonOptions() ;
+               $defOpt = $wgLang->getDefaultUserOptions() ;
                foreach ( $defOpt as $oname => $val ) {
                        $this->mOptions[$oname] = $val;
                }
@@ -90,12 +105,9 @@ class User {
                $this->mBlockedby = -1; # Unset
                $this->mTouched = '0'; # Allow any pages to be cached
                $this->cookiePassword = "";
-       }
 
-       function loadDefaultUserOptions()
-       {
-               global $wgLang;
-               $this->mOptions = $wgLang->getDefaultUserOptions();
+               /* avoid reserved keyword usage for PostgreSQL */
+               $this->mUserTable=$wgIsPg?'"user"':'user';
        }
 
        /* private */ function getBlockedStatus()
@@ -144,41 +156,35 @@ class User {
 
        function SetupSession() {
                global $wgSessionsInMemcached, $wgCookiePath, $wgCookieDomain;
-               global $wsUserID, $wsUserName, $wsUserPassword, $wsUploadFiles;
                if( $wgSessionsInMemcached ) {
-                       include_once( "MemcachedSessions.php" );
+                       require_once( "MemcachedSessions.php" );
                }
                session_set_cookie_params( 0, $wgCookiePath, $wgCookieDomain );
                session_cache_limiter( "private, must-revalidate" );
-               session_start();
-               session_register( "wsUserID" );
-               session_register( "wsUserName" );
-               session_register( "wsUserPassword" );
-               session_register( "wsUploadFiles" );
+               @session_start();
        }
 
        /* static */ function loadFromSession()
        {
-               global $HTTP_COOKIE_VARS, $wsUserID, $wsUserName, $wsUserPassword;
                global $wgMemc, $wgDBname;
 
-               if ( isset( $wsUserID ) ) {
-                       if ( 0 != $wsUserID ) {
-                               $sId = $wsUserID;
+               if ( isset( $_SESSION['wsUserID'] ) ) {
+                       if ( 0 != $_SESSION['wsUserID'] ) {
+                               $sId = $_SESSION['wsUserID'];
                        } else {
                                return new User();
                        }
-               } else if ( isset( $HTTP_COOKIE_VARS["{$wgDBname}UserID"] ) ) {
-                       $sId = IntVal( $HTTP_COOKIE_VARS["{$wgDBname}UserID"] );
-                       $wsUserID = $sId;
+               } else if ( isset( $_COOKIE["{$wgDBname}UserID"] ) ) {
+                       $sId = IntVal( $_COOKIE["{$wgDBname}UserID"] );
+                       $_SESSION['wsUserID'] = $sId;
                } else {
                        return new User();
                }
-               if ( isset( $wsUserName ) ) {
-                       $sName = $wsUserName;
-               } else if ( isset( $HTTP_COOKIE_VARS["{$wgDBname}UserName"] ) ) {
-                       $sName = $HTTP_COOKIE_VARS["{$wgDBname}UserName"];
-                       $wsUserName = $sName;
+               if ( isset( $_SESSION['wsUserName'] ) ) {
+                       $sName = $_SESSION['wsUserName'];
+               } else if ( isset( $_COOKIE["{$wgDBname}UserName"] ) ) {
+                       $sName = $_COOKIE["{$wgDBname}UserName"];
+                       $_SESSION['wsUserName'] = $sName;
                } else {
                        return new User();
                }
@@ -194,12 +200,12 @@ class User {
                        wfDebug( "User::loadFromSession() got from cache!\n" );
                }
 
-               if ( isset( $wsUserPassword ) ) {
-                       $passwordCorrect = $wsUserPassword == $user->mPassword;
-               } else if ( isset( $HTTP_COOKIE_VARS["{$wgDBname}Password"] ) ) {
-                       $user->mCookiePassword = $HTTP_COOKIE_VARS["{$wgDBname}Password"];
-                       $wsUserPassword = $user->addSalt( $user->mCookiePassword );
-                       $passwordCorrect = $wsUserPassword == $user->mPassword;
+               if ( isset( $_SESSION['wsUserPassword'] ) ) {
+                       $passwordCorrect = $_SESSION['wsUserPassword'] == $user->mPassword;
+               } else if ( isset( $_COOKIE["{$wgDBname}Password"] ) ) {
+                       $user->mCookiePassword = $_COOKIE["{$wgDBname}Password"];
+                       $_SESSION['wsUserPassword'] = $user->addSalt( $user->mCookiePassword );
+                       $passwordCorrect = $_SESSION['wsUserPassword'] == $user->mPassword;
                } else {
                        return new User(); # Can't log in from session
                }
@@ -219,8 +225,11 @@ class User {
 
        function loadFromDatabase()
        {
-               if ( $this->mDataLoaded ) { return; }
-               
+               global $wgCommandLineMode;
+               if ( $this->mDataLoaded || $wgCommandLineMode ) {
+                       return;
+               }
+
                # Paranoia
                $this->mId = IntVal( $this->mId );
 
@@ -235,7 +244,6 @@ class User {
                        }
                        wfFreeResult( $res );
                } else {
-                       # TEST THIS @@@
                        global $wgDBname, $wgMemc;
                        $key = "$wgDBname:newtalk:ip:{$this->mName}";
                        $newtalk = $wgMemc->get( $key );
@@ -257,14 +265,15 @@ class User {
                } # the following stuff is for non-anonymous users only
 
                $sql = "SELECT user_name,user_password,user_newpassword,user_email," .
-                 "user_options,user_rights,user_touched FROM user WHERE user_id=" .
-                 "{$this->mId}";
+                 "user_real_name,user_options,user_rights,user_touched " . 
+                  " FROM {$this->mUserTable} WHERE user_id=" . $this->mId;
                $res = wfQuery( $sql, DB_READ, "User::loadFromDatabase" );
 
                if ( wfNumRows( $res ) > 0 ) {
                        $s = wfFetchObject( $res );
                        $this->mName = $s->user_name;
                        $this->mEmail = $s->user_email;
+                       $this->mRealName = $s->user_real_name;
                        $this->mPassword = $s->user_password;
                        $this->mNewpassword = $s->user_newpassword;
                        $this->decodeOptions( $s->user_options );
@@ -376,6 +385,18 @@ class User {
                $this->mEmail = $str;
        }
 
+       function getRealName()
+       {
+               $this->loadFromDatabase();
+               return $this->mRealName;
+       }
+
+       function setRealName( $str )
+       {
+               $this->loadFromDatabase();
+               $this->mRealName = $str;
+       }
+
        function getOption( $oname )
        {
                $this->loadFromDatabase();
@@ -389,6 +410,10 @@ class User {
        function setOption( $oname, $val )
        {
                $this->loadFromDatabase();
+               if ( $oname == 'skin' ) {
+                       # Clear cached skin, so the new one displays immediately in Special:Preferences
+                       unset( $this->mSkin );
+               }
                $this->mOptions[$oname] = $val;
                $this->invalidateCache();
        }
@@ -433,7 +458,9 @@ class User {
        function isBot()
        {
                $this->loadFromDatabase();
-               if ( 0 == $this->mId ) { return false; }
+
+               # Why was this here? I need a UID=0 conversion script [TS]
+               # if ( 0 == $this->mId ) { return false; }
 
                return in_array( "bot", $this->mRights );
        }
@@ -443,10 +470,25 @@ class User {
                if ( ! isset( $this->mSkin ) ) {
                        $skinNames = Skin::getSkinNames();
                        $s = $this->getOption( "skin" );
-                       if ( "" == $s ) { $s = 0; }
-
-                       if ( $s >= count( $skinNames ) ) { $sn = "SkinStandard"; }
-                       else $sn = "Skin" . $skinNames[$s];
+                       if ( "" == $s ) { $s = 'standard'; }
+
+                       if ( !isset( $skinNames[$s] ) ) {
+                               $fallback = array(
+                                       0 => "SkinStandard",
+                                       1 => "SkinNostalgia",
+                                       2 => "SkinCologneBlue");
+                               if ( isset( $skinNames['monobook'] ) ) {
+                                       $fallback[0] = "SkinMonoBook";
+                               }
+                               
+                               if(is_numeric($s) && isset( $fallback[$s]) ){
+                                       $sn = $fallback[$s];
+                               } else {
+                                       $sn = "SkinStandard";
+                               }
+                       } else {
+                               $sn = "Skin" . $skinNames[$s];
+                       }
                        $this->mSkin = new $sn;
                }
                return $this->mSkin;
@@ -492,19 +534,18 @@ class User {
 
        function setCookies()
        {
-               global $wsUserID, $wsUserName, $wsUserPassword;
                global $wgCookieExpiration, $wgCookiePath, $wgCookieDomain, $wgDBname;
                if ( 0 == $this->mId ) return;
                $this->loadFromDatabase();
                $exp = time() + $wgCookieExpiration;
 
-               $wsUserID = $this->mId;
+               $_SESSION['wsUserID'] = $this->mId;
                setcookie( "{$wgDBname}UserID", $this->mId, $exp, $wgCookiePath, $wgCookieDomain );
 
-               $wsUserName = $this->mName;
+               $_SESSION['wsUserName'] = $this->mName;
                setcookie( "{$wgDBname}UserName", $this->mName, $exp, $wgCookiePath, $wgCookieDomain );
 
-               $wsUserPassword = $this->mPassword;
+               $_SESSION['wsUserPassword'] = $this->mPassword;
                if ( 1 == $this->getOption( "rememberpassword" ) ) {
                        setcookie( "{$wgDBname}Password", $this->mCookiePassword, $exp, $wgCookiePath, $wgCookieDomain );
                } else {
@@ -514,10 +555,10 @@ class User {
 
        function logout()
        {
-               global $wsUserID, $wgCookiePath, $wgCookieDomain, $wgDBname;
+               global $wgCookiePath, $wgCookieDomain, $wgDBname;
                $this->mId = 0;
 
-               $wsUserID = 0;
+               $_SESSION['wsUserID'] = 0;
 
                setcookie( "{$wgDBname}UserID", "", time() - 3600, $wgCookiePath, $wgCookieDomain );
                setcookie( "{$wgDBname}Password", "", time() - 3600, $wgCookiePath, $wgCookieDomain );
@@ -526,7 +567,6 @@ class User {
        function saveSettings()
        {
                global $wgMemc, $wgDBname;
-
                if ( ! $this->mNewtalk ) {
                        if( $this->mId ) {
                                $sql="DELETE FROM user_newtalk WHERE user_id={$this->mId}";
@@ -539,10 +579,11 @@ class User {
                }
                if ( 0 == $this->mId ) { return; }
 
-               $sql = "UPDATE user SET " .
+               $sql = "UPDATE {$this->mUserTable} SET " .
                  "user_name= '" . wfStrencode( $this->mName ) . "', " .
                  "user_password= '" . wfStrencode( $this->mPassword ) . "', " .
                  "user_newpassword= '" . wfStrencode( $this->mNewpassword ) . "', " .
+                 "user_real_name= '" . wfStrencode( $this->mRealName ) . "', " .
                  "user_email= '" . wfStrencode( $this->mEmail ) . "', " .
                  "user_options= '" . $this->encodeOptions() . "', " .
                  "user_rights= '" . wfStrencode( implode( ",", $this->mRights ) ) . "', " .
@@ -560,7 +601,7 @@ class User {
                $s = trim( $this->mName );
                if ( 0 == strcmp( "", $s ) ) return 0;
 
-               $sql = "SELECT user_id FROM user WHERE user_name='" .
+               $sql = "SELECT user_id FROM {$this->mUserTable} WHERE user_name='" .
                  wfStrencode( $s ) . "'";
                $res = wfQuery( $sql, DB_READ, "User::idForName" );
                if ( 0 == wfNumRows( $res ) ) { return 0; }
@@ -575,12 +616,13 @@ class User {
 
        function addToDatabase()
        {
-               $sql = "INSERT INTO user (user_name,user_password,user_newpassword," .
-                 "user_email, user_rights, user_options) " .
+               $sql = "INSERT INTO {$this->mUserTable} (user_name,user_password,user_newpassword," .
+                 "user_email, user_real_name, user_rights, user_options) " .
                  " VALUES ('" . wfStrencode( $this->mName ) . "', '" .
                  wfStrencode( $this->mPassword ) . "', '" .
                  wfStrencode( $this->mNewpassword ) . "', '" .
                  wfStrencode( $this->mEmail ) . "', '" .
+                 wfStrencode( $this->mRealName ) . "', '" .
                  wfStrencode( implode( ",", $this->mRights ) ) . "', '" .
                  $this->encodeOptions() . "')";
                wfQuery( $sql, DB_WRITE, "User::addToDatabase" );
@@ -613,14 +655,20 @@ class User {
                }
                
                # Make a new block object with the desired properties
-               wfDebug( "Autoblocking {$this->mUserName}@{$wgIP}\n" );
+               wfDebug( "Autoblocking {$this->mName}@{$wgIP}\n" );
                $ipblock->mAddress = $wgIP;
                $ipblock->mUser = 0;
                $ipblock->mBy = $userblock->mBy;
                $ipblock->mReason = wfMsg( "autoblocker", $this->getName(), $userblock->mReason );
                $ipblock->mTimestamp = wfTimestampNow();
                $ipblock->mAuto = 1;
-               $ipblock->mExpiry = Block::getAutoblockExpiry( $ipblock->mTimestamp );
+               # If the user is already blocked with an expiry date, we don't 
+               # want to pile on top of that!
+               if($userblock->mExpiry) {
+                       $ipblock->mExpiry = min ( $userblock->mExpiry, Block::getAutoblockExpiry( $ipblock->mTimestamp ));
+               } else {
+                       $ipblock->mExpiry = Block::getAutoblockExpiry( $ipblock->mTimestamp );
+               }
 
                # Insert it
                $ipblock->insert();
@@ -668,8 +716,16 @@ class User {
                return $allowed;
        }
 
-
-
+       # Set mDataLoaded, return previous value
+       # Use this to prevent DB access in command-line scripts or similar situations
+       function setLoaded( $loaded ) 
+       {
+               wfSetVar( $this->mDataLoaded, $loaded );
+       }
+       
+       function getUserPage() {
+               return Title::makeTitle( NS_USER, $this->mName );
+       }
 }
 
 ?>