Call to undefined function getsqlvaluestring() with Dreamwea

Hi Murray Okay, seems like theres no reason for me to hide the code - the actual error is Fatal error : Call to undefined function getsqlvaluestring() in /u1/home/comzttoj/public_html/newsletters/Resources/promocenter/admin/ login.php on l

Hi Murray

Okay, seems like theres no reason for me to hide the code - the actual error is

Fatal error: Call to undefined function getsqlvaluestring() in/u1/home/comzttoj/public_html/newsletters/Resources/promocenter/admin/ login.php on line 22

and the code looks like this

// *** Validate request to login to this site.

if (!isset($_SESSION)) {

session_start();

}

$loginFormAction = $_SERVER['PHP_SELF'];

if (isset($_GET['accesscheck'])) {

$_SESSION['PrevUrl'] = $_GET['accesscheck'];

}

if (isset($_POST['username'])) {

$loginUsername=$_POST['username'];

$password=$_POST['password'];

$MM_fldUserAuthorization = "access_level";

$MM_redirectLoginSuccess = "index.php";

$MM_redirectLoginFailed = "login.php";

$MM_redirecttoReferrer = true;

mysql_select_db($database_promocenter, $promocenter);

$LoginRS__query=sprintf("SELECT username, password, destination_page FROM users WHERE username=%s AND password=%s",

GetSQLValueString($loginUsername, "text"), GetSQLValueString($password, "int"));

$LoginRS = mysql_query($LoginRS__query, $promocenter) or die(mysql_error());

$loginFoundUser = mysql_num_rows($LoginRS);

if ($loginFoundUser) {

$loginStrGroup = mysql_result($LoginRS,0,'access_level');

if (PHP_VERSION >= 5.1) {session_regenerate_id(true);} else {session_regenerate_id();}

//declare two session variables and assign them

$_SESSION['MM_Username'] = $loginUsername;

$_SESSION['MM_UserGroup'] = $loginStrGroup;

if (isset($_SESSION['PrevUrl']) && true) {

$MM_redirectLoginSuccess = $_SESSION['PrevUrl'];

}

header("Location: " . $MM_redirectLoginSuccess );

}

else {

header("Location: ". $MM_redirectLoginFailed );

}

}

?>

function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")

{

if (PHP_VERSION

$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

}

$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

switch ($theType) {

case "text":

$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";

break;

case "long":

case "int":

$theValue = ($theValue != "") ? intval($theValue) : "NULL";

break;

case "double":

$theValue = ($theValue != "") ? doubleval($theValue) : "NULL";

break;

case "date":

$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";

break;

case "defined":

$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;

break;

}

return $theValue;

}

}

mysql_select_db($database_promocenter, $promocenter);

$query_rs_users_login = "SELECT * FROM users";

$rs_users_login = mysql_query($query_rs_users_login, $promocenter) or die(mysql_error());

$row_rs_users_login = mysql_fetch_assoc($rs_users_login);

$totalRows_rs_users_login = mysql_num_rows($rs_users_login);

?>