SA-MP Forums Archive
Small 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: Small problem (/showthread.php?tid=551478)


Small problem - Zaec - 19.12.2014

Hello everyone, i have problem with mysql loading.

Maybe someone knows can be wrong with this:

Money will be loaded if i write like this:

Код:
				format(Query,sizeof(Query),"SELECT Money FROM `Players` WHERE Nickname = '%s' AND Password = md5('%s') LIMIT 1",Name,inputtext);
But its doesn't work if i write like this:

Код:
				format(Query,sizeof(Query),"SELECT * FROM `Players` WHERE Nickname = '%s' AND Password = md5('%s') LIMIT 1",vardas,inputtext);
It should work yes? I no need to load only money, so i put "SELEC * " to load everything, kills, deaths....
If someone knows whats the problem, please help me ;] I using old Mysql R5 plugin

Re: Small problem - PowerPC603 - 19.12.2014

In the second query, you use "vardas" instead of "Name".
Can you also show how you read the data, after the query?

Re: Small problem - Zaec - 19.12.2014

Oh yes, i know that then i write in here i did this mistake. In both have to be "Name" But its still not working

Re: Small problem - Zaec - 19.12.2014

Please, help me

Re: Small problem - Zaec - 19.12.2014

Does anyone can help me? Comon....