Mysql problem - Printable Version

Mysql problem - 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 problem (/showthread.php?tid=550793)

Mysql problem - Zaec - 14.12.2014

Hello everyone, maybe someone can help me with mysql problem. I need to convert mysql saving from mysql plugin R5 to R8(20)

R5 script

Код:

	new Query[200];
	format(Query, 200, "UPDATE houses SET Owner = '%s', Name = '%s', Password = '%s' WHERE ID = '%d'", HouseO, HouseN, HouseP, HouseID);
	mysql_query(Query);

I tryed like this, but its doesn't work

Код:

	new Querynnb[256];
    format(Querynnb, 256, "UPDATE `houses` SET Owner = '%s', `Name` = '%s', `Password` = '%s' WHERE `ID` = '%d'", HouseO, HouseN, HouseP, HouseID);
	mysql_function_query(1,Querynnb,false,"","");

Thanks for your help

+rep

Re: Mysql problem - Zaec - 14.12.2014

Please, someone

Re: Mysql problem - Zaec - 14.12.2014

Comon....

Re: Mysql problem - DaTa[X] - 14.12.2014

Mysql log ?

Re: Mysql problem - Zaec - 14.12.2014

Quote:

Originally Posted by DaTa[X]

Mysql log ?

Код:

[01:54:17] [INFO] Now logging: errors
[01:54:17] [ERROR] CMySQLHandler::NumRows() - You cannot call this function now (no result).

Re: Mysql problem - Zaec - 15.12.2014

Nobody doens't know what can be wrong?