SA-MP Forums Archive
MYSQL Error - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MYSQL Error (/showthread.php?tid=447706)



MYSQL Error - NeroX98 - 01.07.2013

invalid connection handle. (ID = 0)

What does this error mean ? (It's MYSQL error)

Код:
		format(szLargeString, sizeof(szLargeString), "INSERT INTO Igraci (pProfil, pKey) VALUES('%s', '%s')", playername3, password);
		static dbHandle;
		mysql_function_query(dbHandle, szLargeString, false, "", "");



Re: MYSQL Error - NeroX98 - 01.07.2013

New pawno compile error

Код:
argument type mismatch (argument 3)
pawn Код:
public OnPlayerRegister(playerid, password[])
{
    if(IsPlayerConnected(playerid))
    {
        new szLargeString[364];
        new playername3[MAX_PLAYER_NAME];
        GetPlayerName(playerid, playername3, sizeof(playername3));
        mysql_format(dbHandle, szLargeString, "INSERT INTO `Igraci` (`pProfil`, `pKey`) VALUES (`%s`, `%s`)", playername3, password);
        //^^^^^^^^^^ THAT LINE ^^^^^^^^^^^^^^^^
        mysql_function_query(dbHandle, szLargeString, false, "", "");
    }
}