SA-MP Forums Archive
Problem with a_mysql | Making login/register mysql based - 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: Problem with a_mysql | Making login/register mysql based (/showthread.php?tid=632096)



Problem with a_mysql | Making login/register mysql based - akib - 09.04.2017

hi, i am newbie in pawno
i am trying to make a login register system mysql based
but facing two problems.....
Код:
D:\GTA San Andreas\Server\gamemodes\cdm.pwn(68) : error 035: argument type mismatch (argument 1)
D:\GTA San Andreas\Server\gamemodes\cdm.pwn(69) : error 017: undefined symbol "mysql_store_result"
Pawn compiler 3.2.3664	 	 	Copyright © 1997-2006, ITB CompuPhase
The gm code [only DB info's included] :
Код:
#include <a_mysql>
#include <sscanf2>

#define SQL_HOST ""
#define SQL_USER ""
#define SQL_PASS ""
#define SQL_DB ""

public OnGameModeInit()
{
	mysql_connect("SQL_HOST","SQL_USER","SQL_PASS","SQL_DB");
	// Don't use these lines if it's a filterscript
	SetGameModeText("Blank Script");
	AddPlayerClass(0, 1958.3783, 1343.1572, 15.3746, 269.1425, 0, 0, 0, 0, 0, 0);
	return 1;
}

public OnPlayerConnect(playerid)
{
	new query[128],name[MAX_PLAYER_NAME];
	GetPlayerName(playerid,name,sizeof(name));
	format(query,sizeof(query),"SELECT * FROM accounts WHERE username = %s",name);
	
	mysql_query(query);
	mysql_store_result();
	
	return 1;
}
Please Help mE :/
thanks in advance


Re: Problem with a_mysql | Making login/register mysql based - Vince - 09.04.2017

Find a recent tutorial, preferably from the last six months, and work off of that. Don't use outdated stuff.


Re: Problem with a_mysql | Making login/register mysql based - akib - 09.04.2017

Quote:
Originally Posted by Vince
Посмотреть сообщение
Find a recent tutorial, preferably from the last six months, and work off of that. Don't use outdated stuff.
Thanks for your reply.
Can u plz give me a link for latest tutorial?


Re: Problem with a_mysql | Making login/register mysql based - verlaj - 09.04.2017

https://sampforum.blast.hk/showthread.php?tid=461766