PHP error

[NeedForSpeed]

Ik begrijp hier dus echt niks van:

PHP Fatal error: Call to undefined function mssql_exec() in E:\*******\wwwroot\gunz\functions.php on line 104

<?php

    if( !ereg("index.php", $_SERVER['PHP_SELF']) )
    {
        header("Location: index.php");
        die();
    }

  ////////////////////
 // MAIN Functions //
////////////////////

function connect()
{
    global $_MSSQL;

    $resource = mssql_connect("Driver={SQL Server};Server={$_MSSQL[Host]}; Database={$_MSSQL[DBNa]}", $_MSSQL[User], $_MSSQL[Pass]) or die(mssql_errormsg());
    return $resource;

}

function num_rows($result)
{
    $count = 0;
    while( mssql_fetch_row($result) )
    {
        $count++;
    }
    mssql_fetch_row($result, 0);
    return $count;
}

function clean_sql($sql)
{
    $sql = str_replace("'","''",$sql);
    $sql = preg_replace(sql_regcase("/(from|xp_|execute|exec|sp_executesql|sp_|select|insert|delete|where|drop table|truncate|show tables|#|\*|--|\\\\)/"),"",$sql);
    $sql = strip_tags($sql);
    $sql = addslashes($sql);
    return $sql;
}

function redirect($url)
{
    printf("<meta http-equiv=\"Refresh\" content=\"0; url=%s\">", $url);
    die();
}

function writetolog($log)
{
    $date = date("d-m-y - H:i:s");
    $logfile = fopen("logs/log.txt","a+");
    $logtext = "$date - {$_SERVER['REMOTE_ADDR']} - StaffAID: {$_SESSION[AID]} : $log\r\n";
    fputs($logfile, $logtext);
	fclose($logfile);
}

function setmessage($title, $message)
{
    global $_STR;

    $_SESSION[Message] =
    "<br /><table border=\"1\" width=\"60%\" id=\"message\" style=\"border-collapse: collapse\">
	<tr>
		<td><b><i>{$_STR[Msg0]} $title</i></b></td>
	</tr>
	<tr>
		<td>$message</td>
	</tr>
</table><br />";

}

function showmessage()
{
    if( $_SESSION[Message] != "" )
    {
        printf("%s", $_SESSION[Message]);
        unset($_SESSION[Message]);
    }
}

   ////////////////////
  // End OF         //
 // MAIN Functions //
////////////////////

  /////////////////////
 // LOGIN Functions //
/////////////////////

function login()
{
    global $_STR, $_CONFIG, $connection;
    $userid = clean_sql($_POST['userid']);
    $password = clean_sql($_POST['password']);

    if( $userid == "" || $password == "" )
    {
        setmessage("Login", $_STR[Login4]);
        redirect("index.php");
        die();
    }

    $loginquery = mssql_exec($connection, "
                    SELECT a.AID, a.UserID, a.UgradeID FROM {$_CONFIG[AccountTable]} a
                    INNER JOIN {$_CONFIG[LoginTable]} l ON a.AID = l.AID
                    WHERE l.UserID = '$userid' AND l.Password = '$password'
                    ");
    if( num_rows($loginquery) == 1 )
    {
        $logindata = mssql_fetch_row($loginquery);
        $ugradeid = mssql_result($loginquery, 3);
        if( $ugradeid != 255 && $ugradeid != 254 && $ugradeid != 252 )
        {
            setmessage("Login", $_STR[Login5]);
            redirect("index.php");
            die();
        }
        $_SESSION[AID] = mssql_result($loginquery, 1);
        $_SESSION[UserID] = mssql_result($loginquery, 2);
        $_SESSION[UGradeID] = $ugradeid;
        redirect("index.php");
    }
    else
    {
        setmessage("Login", $_STR[Login6]);
        redirect("index.php");
        die();
    }
}

function logout()
{
    unset($_SESSION[AID], $_SESSION[UserID], $_SESSION[UGradeID]);
    redirect("index.php");
}

function check_ugradeid()
{
    global $_STR, $_CONFIG, $connection;

    $check = mssql_exec($connection, "SELECT UGradeID FROM {$_CONFIG[AccountTable]} WHERE AID = '{$_SESSION[AID]}'");
    mssql_fetch_row($check);
    $cugradeid = mssql_result($check, 1);
    if( $cugradeid != 255 && $cugradeid != 254 && $cugradeid != 252 )
    {
        printf( $_STR[Login5] );
        logout();
    }
    else
    {
        $_SESSION[UGradeID] = $check[0];
    }

}

   /////////////////////
  // End OF          //
 // LOGIN Functions //
/////////////////////


?>

 

[SvU]

Die functie bestaat niet. Je zult 'm zelf moeten schrijven of gebruik moeten maken van een bestaande mssql_*-functie. Had je makkelijk kunnen vinden op php.net.

http://nl.php.net/mssql

 

[Supersnail]

De functie "mssql_exec" bestaat niet: http://nl3.php.net/manual-lookup.php?pattern=mssql_exec&src=

 

[PCMario]

mysql_query
is een goed alternatief hiervoor.

if (!@mysql_select_db("pcmario", @mysql_connect("localhost", "TEST", "TEST***TEST"))) {echo "Er kan geen database connectie gemaakt worden."; exit(); } else {$loginquery = mysql_query("SELECT a.AID, a.UserID, a.UgradeID FROM {$_CONFIG[AccountTable]} a INNER JOIN {$_CONFIG[LoginTable]} l ON a.AID = l.AID WHERE l.UserID = '".$userid."' AND l.Password = '".$password."'")};

 

[SvU]

Alleen niet met een MSSQL-database. :')

 

[PCMario]

Um, idd niet goed gelezen... morgen weer een dag voor mij om hier eens goed naar te kijken... zzz

 

[SvU]

Dat zal een beetje een ondoordachte uitspraak zijn, neem ik aan.