function auth_getpass($auth_ucookie)
{
global $yabbsedb, $db_prefix, $txt, $db, $g_default_settings, $prefix, $x7c;
$query = $yabbsedb->DoQuery("SELECT passwd FROM {$db_prefix}members WHERE memberName='{$_COOKIE[$auth_ucookie]}'");
$password = $yabbsedb->Do_Fetch_Row($query);
// Check if they have an X7 Chat account
if ($password[0] != "") {
$query = $db->DoQuery("SELECT * FROM {$prefix}users WHERE username='******'");
$row = $db->Do_Fetch_Row($query);
if ($row[0] == "") {
// Create an X7 Chat account for them.
$time = time();
$ip = $_SERVER['REMOTE_ADDR'];
$db->DoQuery("INSERT INTO {$prefix}users (id,username,password,status,user_group,time,settings,hideemail,ip) VALUES('0','{$_COOKIE[$auth_ucookie]}','{$password['0']}','{$txt['150']}','{$x7c->settings['usergroup_default']}','{$time}','{$g_default_settings}','0','{$ip}')");
}
}
return yabben($password[0], "ys");
}
function getPass($username)
{
global $DATABASE, $_COOKIE, $SERVER, $db_server, $db_user, $db_passwd, $db_name, $db_prefix;
mysql_close();
@DoConnect("{$db_server}", "{$db_user}", "{$db_passwd}");
@DoSelectDb("{$db_name}");
$q = DoQuery("SELECT passwd FROM {$db_prefix}members WHERE memberName='{$username}'");
echo mysql_error();
$pass = Do_Fetch_Row($q);
mysql_close();
DoConnect($DATABASE['HOST'], $DATABASE['USER'], $DATABASE['PASS']);
DoSelectDb($DATABASE['DATABASE']);
$q = DoQuery("SELECT * FROM {$SERVER['TBL_PREFIX']}users WHERE username='******'");
$row = Do_Fetch_Row($q);
if ($row[0] == "" && $_COOKIE['X2CHATP'] == $pass[0]) {
DoQuery("INSERT INTO {$SERVER['TBL_PREFIX']}users VALUES('0','{$username}','','','1','','','','','','','','','14000,1000,1,1,0,3,1,0,0,1')");
echo mysql_error();
}
$pass[0] = yabben($pass[0], "ys");
return $pass[0];
}
