Help me - Printable Version

Help me - 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: Help me (/showthread.php?tid=659817)

Help me - Heress - 17.10.2018

Hello, I have error in this callback, because i have error:

Quote:

[17:33:15] [ERROR] CMySQLQuery::Execute[()] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

Please help me

Quote:

public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
if(dialogid == DIALOG_REGISTER)
{
if(response)
{
//Slaptaћodћio ilgis
new Vardas[MAX_PLAYER_NAME], query[64], slaptazodis[32];
GetPlayerName(playerid, Vardas, sizeof(Vardas));
if(strlen(inputtext) >= 6)
{
mysql_escape_string(inputtext, slaptazodis, manomysql);
format(query, sizeof(query), "INSERT INTO `user` (`vardas`, `slaptazodis`) VALUES ('%s', '%s')", Vardas, inputtext);
mysql_function_query(manomysql, query, false, "", "");
SendClientMessage(playerid, LIME, "Sėkmingai uћsiregistravote serveryje! Gero ћaidimo");
}
else
{
SendClientMessage(playerid, MELYNA, "Slaptaћodis turi būti bent 6 simbolių ilgio!");
ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_INPUT, "Registracija", "Praљome įvesti sugalvotą slaptaћodį!", "Registruotis", "Iљeiti");
}
}
else
{
Kick(playerid);
SendClientMessage(playerid, RAUDONA, "Atљaukėte registraciją!");
}
}
return 1;
}

Re: Help me - v1k1nG - 17.10.2018

PHP код:



new Vardas[MAX_PLAYER_NAME], query[64], slaptazodis[32];

query[64] is too small. Increase its size.

Also

PHP код:



mysql_function_query(manomysql, query, false, "", "");

Which MySql version are you using?

Re: Help me - Heress - 17.10.2018

Quote:

Originally Posted by v1k1nG

PHP код:



new Vardas[MAX_PLAYER_NAME], query[64], slaptazodis[32];

query[64] is too small. Increase its size.

Also

PHP код:



mysql_function_query(manomysql, query, false, "", "");

Which MySql version are you using?

I'm using r34

Re: Help me - Heress - 17.10.2018

THAANKS

it work

Re: Help me - v1k1nG - 17.10.2018

Anytime.
Anyways consider updating your code (backup it before doing that).

Re: Help me - Heress - 17.10.2018

Quote:

Originally Posted by v1k1nG

Anytime.
Anyways consider updating your code (backup it before doing that).

Thanks, +rep