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]; }