phpBB Guru - Официальная русская поддержка форума phpBB3

Код: Выделить всё

 public function getCanonicalName( $username ) 
         { 
             // Connect to the database. 
             $fresMySQLConnection = $this->connect(); 

             $username = $this->utf8($username); // Convert to UTF8 

             // Check Database for username. We will return the correct casing of the name. 
             $fstrMySQLQuery = sprintf("SELECT `username` 
                                FROM `%s` 
                                WHERE `username_clean` = '%s' 
                                LIMIT 1", 
                                $this->_UserTB, 
                                mysql_real_escape_string($username, $fresMySQLConnection)); 

             // Query Database. 
             $fresMySQLResult = mysql_query($fstrMySQLQuery, $fresMySQLConnection) 
                 or die($this->mySQLError('Unable to view external table')); 

             while($faryMySQLResult = mysql_fetch_assoc($fresMySQLResult)) 
             { 
                 return $faryMySQLResult['username']; 
             } 

             // At this point the username is invalid and should return just as it was passed.            return $username; 
         }