View Single Post
LondoN
Senior Member
Join Date: Dec 2015
Location: Roman, Romania.
Old 04-19-2021 , 03:54   Re: Whats wrong in this mysql?
Reply With Quote #7

Code:
public client_connect(id)
{
	new g_szAuthID[32];
	get_user_authid(id, g_szAuthID, charsmax(g_szAuthID));

	new g_szQuery[256];
	formatex(g_szQuery, charsmax(g_szQuery), "SELECT * FROM tablename WHERE player_auth = '%s'", g_szAuthID);

	new g_szData[1];
	g_szData[0] = id;

	SQL_ThreadQuery(g_SQLTuple, "SQL_Check", g_szQuery, g_szData, sizeof g_szData);
}

public SQL_Check(FailState, Handle: Query, szError[], iErrorCode, szData[], iDataSize)
{
	if(!FailState && !iErrorCode)
	{
		new id = szData[0];

		if(!SQL_NumResults(Query))
			server_cmd("kick #%d", get_user_userid(id));
	}

	SQL_FreeHandle(Query);
}
This type of 'doing sql' always worked fine for me, you can try.
__________________
LondoN is offline