i tried to modify some code to use an existing database for logins, but another database for storing information. i am having problems login in with the edited code, any help would be great.
original code
function loginaction($username, $password) {
global $uid;
dbconnect();
$query = "SELECT * FROM IPM_users WHERE username='$username'";
if (!($result = mysql_query($query))) {
die("Couldn't retrieve authorization data, please try again later");
}
if (mysql_num_rows($result) > 0) {
if ($user=mysql_fetch_array($result)) {
if (md5($password) == $user[password]) {
($SECURE_COOKIES == "true")? $SSL=1: $SSL=0;
setcookie("uid", $user[id], "0", "", "", $SSL);
$uid = $user[id];
mytasks();
} else {
login();
}
}
} else {
login();
}
}
modified code
function loginaction($username, $password) {
global $uid;
dbconnect2();
function authMysql ($username, $password, $db_username2, $db_password2, $db_servername2, $db_dbname2, $db_table2) {
$connection = mysql_connect($db_servername2, $db_username2, $db_password2) or die("Invalid server or user or something");
mysql_select_db($db_dbname2);
$query = "select username, password, password('$password') from $table where username = '$username'";
$result = mysql_db_query($db_dbname2, $query, $connection) or die ("error in query: $query");
$dbrow = mysql_fetch_array($result, MYSQL_NUM);
$pass = $dbrow[1];
$pass2 = $dbrow[2];
if ($pass == $pass2) {
dbconnect();
$query="SELECT id FROM IPM_users WHERE username='$username'";
$result=mysql_query($query);
if (mysql_num_rows($result) > 0) {
if ($user=mysql_fetch_array($result)) {
if (md5($password) == $user[password]) {
($SECURE_COOKIES == "true")? $SSL=1: $SSL=0;
setcookie("uid", $user[id], "0", "", "", $SSL);
$uid = $user[id];
mytasks();
} elseif (mysql_num_rows($result) < 0) {
$query="INSERT INTO IPM_users VALUES (NULL,'$username','NULL','$username','defaultgroup','$username@test.org','1')";
mysql_query($query);
if (md5($password) == $user[password]) {
($SECURE_COOKIES == "true")? $SSL=1: $SSL=0;
setcookie("uid", $user[id], "0", "", "", $SSL);
$uid = $user[id];
mytask();
} else {
login();
}
}
}
}
}
}
}
I hope someone is able to donate a small amount of their time to help me with this. Thank you very much. - TonyR