Помогите пожалуйста переписать этот код под ipb
<?php
/**
*
* 2Moons auth plug-in for phpBB3
*
* @package login
* @version $Id$
* @copyright (c) 2012 Jan Krцpke
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
*/
/**
* @ignore
*/
if (!defined('IN_PHPBB'))
{
exit;
}
function init_2moons()
{
global $config, $user;
if(!function_exists('mysql_connect'))
{
return 'MySQL Module required';
}
$port = isset($config['moons_dbport']) ? (int) $config['moons_dbport'] : 3306;
$link = @mysql_connect($config['moons_dbhost'].':'.$port, $config['moons_dbuser'], $config['moons_dbpassword']);
if (!$link)
{
return 'MySQL Connection Error: '.mysql_error();
}
if ((@mysql_select_db($config['moons_dbtable'], $link)) === false)
{
return 'Can\'t select database '.$config['moons_dbtable'].': '.mysql_error();
}
$prefix = str_replace('_', '\_', mysql_real_escape_string($config['moons_dbprefix'], $link));
foreach(array('users', 'config', 'session') as $table)
{
$query = mysql_query("SHOW TABLES LIKE '".$prefix.$table."'", $link);
if (!$query)
{
return 'MySQL Query Error: '.mysql_error().'<br>'."SHOW TABLES LIKE '".$prefix.$table."'";
}
$tableExists = mysql_num_rows($query);
if($tableExists !== 1)
{
return 'Table'.$config['moons_dbprefix'].$table.' not found!';
}
}
$query = mysql_query("SELECT COUNT(*) FROM ".mysql_real_escape_string($config['moons_dbprefix'], $link)."config WHERE uni = ".((int) $config['moons_universe']).";", $link);
if (!$query)
{
return 'MySQL Query Error: '.mysql_error().'<br>'."SELECT COUNT(*) FROM ".mysql_real_escape_string($config['moons_dbprefix'], $link)."config WHERE uni = ".((int) $config['moons_universe']).";";
}
$universeExists = mysql_num_rows($query);
if($universeExists !== 1)
{
return 'Universe '.((int) $config['moons_universe']).' does not exists!';
}
@mysql_close($link);
return false;
}
/**
* Login function
*/
function login_2moons(&$username, &$password)
{
global $db, $config, $user;
// do not allow empty password
if (!$password)
{
return array(
'status' => LOGIN_ERROR_PASSWORD,
'error_msg' => 'NO_PASSWORD_SUPPLIED',
'user_row' => array('user_id' => ANONYMOUS),
);
}
if (!$username)
{
return array(
'status' => LOGIN_ERROR_USERNAME,
'error_msg' => 'LOGIN_ERROR_USERNAME',
'user_row' => array('user_id' => ANONYMOUS),
);
}
$port = isset($config['moons_dbport']) ? (int) $config['moons_dbport'] : 3306;
$link = @mysql_connect($config['moons_dbhost'].':'.$port, $config['moons_dbuser'], $config['moons_dbpassword']);
$prefix = mysql_real_escape_string($config['moons_dbprefix'], $link);
if (!$link)
{
return array(
'status' => LOGIN_ERROR_EXTERNAL_AUTH,
'error_msg' => 'CONNECTION_FAILED',
'user_row' => array('user_id' => ANONYMOUS),
);
}
mysql_select_db($config['moons_dbtable'], $link);
mysql_set_charset('utf8', $link);
$sql = "SELECT id, username, password, universe, email_2 FROM ".$prefix."users WHERE universe = ".((int) $config['moons_universe'])." AND username = '".mysql_real_escape_string($username, $link)."' AND password = '".cryptPassword2Moons($password)."';";
$query = mysql_query($sql, $link);
if (!$query)
{
trigger_error('MySQL Query Error: '.mysql_error().'<br>'.$sql);
}
$userExists = mysql_num_rows($query);
if ($userExists == 1)
{
$userData = mysql_fetch_array($query, MYSQL_ASSOC);
@mysql_free_result($query);
@mysql_close($link);
$sql ='SELECT user_id, username, user_password, user_passchg, user_email, user_type
FROM ' . USERS_TABLE . "
WHERE username_clean = '" . $db->sql_escape(utf8_clean_string($username)) . "'";
$result = $db->sql_query($sql);
$row = $db->sql_fetchrow($result);
$db->sql_freeresult($result);
if ($row)
{
unset($userExists);
// User inactive...
if ($row['user_type'] == USER_INACTIVE || $row['user_type'] == USER_IGNORE)
{
return array(
'status' => LOGIN_ERROR_ACTIVE,
'error_msg' => 'ACTIVE_ERROR',
'user_row' => $row,
);
}
setcookie('phpbb_2moonsautologin', implode('|', array($row['user_id'], md5(implode('::', $userData)))), time() + 60*60*24*30);
// Successful login... set user_login_attempts to zero...
return array(
'status' => LOGIN_SUCCESS,
'error_msg' => false,
'user_row' => $row,
);
}
else
{
// retrieve default group id
$sql = 'SELECT group_id
FROM ' . GROUPS_TABLE . "
WHERE group_name = '" . $db->sql_escape('REGISTERED') . "'
AND group_type = " . GROUP_SPECIAL;
$result = $db->sql_query($sql);
$row = $db->sql_fetchrow($result);
$db->sql_freeresult($result);
if (!$row)
{
trigger_error('NO_GROUP');
}
// generate user account data
$moons_user_row = array(
'username' => $username,
'user_password' => phpbb_hash($password),
'user_email' => $userData['email_2'],
'group_id' => (int) $row['group_id'],
'user_type' => USER_NORMAL,
'user_ip' => $user->ip,
'user_new' => ($config['new_member_post_limit']) ? 1 : ,
);
setcookie('phpbb_2moonsautologin', implode('|', array($row['user_id'], md5(implode('::', $userData)))), time() + 60*60*24*30);
// this is the user's first login so create an empty profile
return array(
'status' => LOGIN_SUCCESS_CREATE_PROFILE,
'error_msg' => false,
'user_row' => $moons_user_row,
);
}
}
unset($userExists);
@mysql_close($link);
return array(
'status' => LOGIN_ERROR_USERNAME,
'error_msg' => 'LOGIN_ERROR_USERNAME',
'user_row' => array('user_id' => ANONYMOUS),
);
}
function autologin_2moons()
{
global $db, $config, $user;
if(!isset($_COOKIE['phpbb_2moonsautologin']))
{
return array();
}
$port = isset($config['moons_dbport']) ? (int) $config['moons_dbport'] : 3306;
$link = @mysql_connect($config['moons_dbhost'].':'.$port, $config['moons_dbuser'], $config['moons_dbpassword']);
$prefix = mysql_real_escape_string($config['moons_dbprefix'], $link);
if (!$link)
{
return array(
'status' => LOGIN_ERROR_EXTERNAL_AUTH,
'error_msg' => 'CONNECTION_FAILED',
'user_row' => array('user_id' => ANONYMOUS),
);
}
mysql_select_db($config['moons_dbtable'], $link);
mysql_set_charset('utf8', $link);
list($userID, $hash) = explode('|', $_COOKIE['phpbb_2moonsautologin']);
$sql = "SELECT id FROM ".$prefix."users WHERE MD5(CONCAT_WS('::', id, username, password, universe, email_2)) = '".mysql_real_escape_string($hash, $link)."';";
$query = mysql_query($sql, $link);
if (!$query)
{
trigger_error('MySQL Query Error: '.mysql_error().'<br>'.$sql);
}
$userExists = mysql_num_rows($query);
if ($userExists == 1)
{
@mysql_close($link);
$sql ='SELECT user_id, username, user_password, user_passchg, user_email, user_type
FROM ' . USERS_TABLE . "
WHERE user_id = " . ((int) $userID) . "";
$result = $db->sql_query($sql);
$row = $db->sql_fetchrow($result);
$db->sql_freeresult($result);
if ($row)
{
setcookie('phpbb_2moonsautologin', $_COOKIE['phpbb_2moonsautologin'], 31536000);
return ($row['user_type'] == USER_INACTIVE || $row['user_type'] == USER_IGNORE) ? array() : $row;
} else {
setcookie('phpbb_2moonsautologin', '', time() - 3600);
}
} else {
@mysql_close($link);
}
unset($userExists);
return array();
}
/**
* This function is used to output any required fields in the authentication
* admin panel. It also defines any required configuration table fields.
*/
function acp_2moons(&$new)
{
global $user;
$tpl = '
<dl>
<dt><label for="moons_dbhost">2Moons-Database-Host:</label></dt>
<dd><input type="text" id="moons_dbhost" size="40" name="config[moons_dbhost]" value="' . $new['moons_dbhost'] . '" /></dd>
</dl>
<dl>
<dt><label for="moons_dbport">2Moons-Database-Port:</label></dt>
<dd><input type="text" id="moons_dbport" size="40" name="config[moons_dbport]" value="' . $new['moons_dbport'] . '" /></dd>
</dl>
<dl>
<dt><label for="moons_dbuser">2Moons-Database-User:</label></dt>
<dd><input type="text" id="moons_dbuser" size="40" name="config[moons_dbuser]" value="' . $new['moons_dbuser'] . '" /></dd>
</dl>
<dl>
<dt><label for="moons_dbpassword">2Moons-Database-Password:</label></dt>
<dd><input type="password" id="moons_dbpassword" size="40" name="config[moons_dbpassword]" value="' . $new['moons_dbpassword'] . '" autocomplete="off" /></dd>
</dl>
<dl>
<dt><label for="moons_dbtable">2Moons-Database-Table:</label></dt>
<dd><input type="text" id="moons_dbtable" size="40" name="config[moons_dbtable]" value="' . $new['moons_dbtable'] . '" /></dd>
</dl>
<dl>
<dt><label for="moons_dbprefix">2Moons-Database-Prefix:</label></dt>
<dd><input type="text" id="moons_dbprefix" size="40" name="config[moons_dbprefix]" value="' . $new['moons_dbprefix'] . '" /></dd>
</dl>
<dl>
<dt><label for="moons_salt">2Moons-Passwort-Salt:</label><br /><span>Definded at ./includes/config.php in $salt</span></dt>
<dd><input type="text" id="moons_salt" size="40" name="config[moons_salt]" value="' . $new['moons_salt'] . '" /></dd>
</dl>
<dl>
<dt><label for="moons_universe">2Moons Universe:</label><br /><span>MultiUniverse is currently unsupported.<br>Default: 1</span></dt>
<dd><input type="text" id="moons_universe" size="40" name="config[moons_universe]" value="' . $new['moons_universe'] . '"/></dd>
</dl>
';
// These are fields required in the config table
return array(
'tpl' => $tpl,
'config' => array('moons_dbhost', 'moons_dbport', 'moons_dbuser', 'moons_dbpassword', 'moons_dbtable', 'moons_dbprefix', 'moons_salt', 'moons_universe')
);
}
// 2Moons functions
function cryptPassword2Moons($password)
{
// http://www.phpgangsta.de/schoener-hashen-mit-bcrypt
global $config;
if(!CRYPT_BLOWFISH || !isset($config['moons_salt']))
{
return md5($password);
} else {
return crypt($password, '$2a$09$'.$config['moons_salt'].'$');
}
}
?>
