1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help

Threaded Mode
Function Not Called (MySQL_Function_Query)
viveka27
Big Clucker
***
Posts: 67
Threads: 13
Joined: Nov 2012
Reputation: 0
#1

02.09.2013, 07:34
( Последний раз редактировалось viveka27; 04.09.2013 в 08:36. )
CODE
Код:
public SafeOnPlayerConnect(playerid)
{
    SendClientMessage(playerid, WHITE, "[DEBUG]: MAU #1");
	CheckAccount(playerid);
	return 1;
}
public CheckAccount(playerid)
{	
    new query[82];

	format(query, sizeof(query), "SELECT `Username` FROM `accounts` WHERE `Username` = '%s'", PlayerName(playerid));
	mysql_function_query(handle, query, true, "OnAccountCheck", "d", playerid);
    SendClientMessage(playerid, WHITE, "[DEBUG]: Mau #2");
	return 1;
}
public OnAccountCheck(playerid)
{
	if(playerid != INVALID_PLAYER_ID) {

		new rows, fields;
		cache_get_data(rows, fields, handle);
		new string[250];
		for (new i = 1; i <= 50; i++) SendClientMessage(playerid, -1, " ");
        SendClientMessage(playerid, WHITE, "[DEBUG]: Mau #3");
		if(rows) {
			cache_get_row(0,2,PlayerInfo[playerid][pKey],handle, 128);
			format(string, sizeof(string), "Selamat Datang Kembali Di %s, %s.", SERVER_NAME, PlayerName(playerid));
			SendClientMessage(playerid, GREY, string);
            SendClientMessage(playerid, WHITE, "[DEBUG]: Show Dialog Login");
			SendClientMessage(playerid, WHITE, "That name is currently registered, please log into your account.");
			ShowMainMenuDialog(playerid, 1);
		}
		else {
			format(string, sizeof(string), "Selamat Datang Di %s, %s.", SERVER_NAME, PlayerName(playerid));
			SendClientMessage(playerid, GREY, string);
            SendClientMessage(playerid, WHITE, "[DEBUG]: Show Dialog Register");
			SendClientMessage(playerid, WHITE, "That name is currently not registered.");
			SendClientMessage(playerid, WHITE, "If you wish to register, please input your password in the box below.");
			ShowMainMenuDialog(playerid, 2);
		}
	}
	return 1;
}
And I am Set Timer in onplayerconnect
SetTimerEx("SafeOnPlayerConnect", 1000, 0, "d", playerid);

But OnAccountCheck not called.So Screen Like This

MySQL Log:
Код:
16:30:29] [ERROR] "mysql_tquery" - invalid connection handle. (ID = 0).
[16:30:29] [ERROR] "cache_get_data" - invalid connection handle. (ID = 1).
[16:30:29] [ERROR] "mysql_tquery" - invalid connection handle. (ID = 0).
[16:30:29] [ERROR] "cache_get_data" - invalid connection handle. (ID = 1).
[16:30:29] [ERROR] "mysql_tquery" - invalid connection handle. (ID = 0).
[16:30:29] [ERROR] "cache_get_data" - invalid connection handle. (ID = 1).
[16:30:29] [ERROR] "mysql_tquery" - invalid connection handle. (ID = 0).
[16:30:29] [ERROR] "cache_get_data" - invalid connection handle. (ID = 1).
[16:30:29] [ERROR] "mysql_tquery" - invalid connection handle. (ID = 0).
[16:30:29] [ERROR] "cache_get_data" - invalid connection handle. (ID = 1).
[16:30:29] [ERROR] "mysql_tquery" - invalid connection handle. (ID = 0).
[16:30:29] [ERROR] "cache_get_data" - invalid connection handle. (ID = 1).
[16:30:29] [ERROR] "mysql_tquery" - invalid connection handle. (ID = 0).
[16:30:29] [ERROR] "cache_get_data" - invalid connection handle. (ID = 1).
[16:30:29] [ERROR] "mysql_tquery" - invalid connection handle. (ID = 0).
[16:30:29] [ERROR] "cache_get_data" - invalid connection handle. (ID = 1).
[16:30:29] [ERROR] "mysql_tquery" - invalid connection handle. (ID = 0).
[16:30:29] [ERROR] "cache_get_data" - invalid connection handle. (ID = 1).
[16:30:29] [ERROR] "mysql_tquery" - invalid connection handle. (ID = 0).
[16:30:29] [ERROR] "cache_get_data" - invalid connection handle. (ID = 1).
[16:30:29] [ERROR] "mysql_tquery" - invalid connection handle. (ID = 0).
[16:30:29] [ERROR] "cache_get_data" - invalid connection handle. (ID = 1).
[16:30:29] [ERROR] "mysql_tquery" - invalid connection handle. (ID = 0).
[16:30:29] [ERROR] "cache_get_data" - invalid connection handle. (ID = 1).
[16:30:29] [ERROR] "mysql_tquery" - invalid connection handle. (ID = 0).
[16:30:29] [ERROR] "cache_get_data" - invalid connection handle. (ID = 1).
[16:30:29] [ERROR] "mysql_tquery" - invalid connection handle. (ID = 0).
[16:30:29] [ERROR] "cache_get_data" - invalid connection handle. (ID = 1).
[16:30:29] [ERROR] "mysql_tquery" - invalid connection handle. (ID = 0).
[16:30:29] [ERROR] "cache_get_data" - invalid connection handle. (ID = 1).
[16:30:29] [ERROR] "mysql_tquery" - invalid connection handle. (ID = 0).
[16:30:29] [ERROR] "cache_get_data" - invalid connection handle. (ID = 1).
[16:30:29] [ERROR] "mysql_tquery" - invalid connection handle. (ID = 0).
[16:30:29] [ERROR] "cache_get_data" - invalid connection handle. (ID = 1).
[16:30:29] [ERROR] "mysql_tquery" - invalid connection handle. (ID = 0).
[16:30:29] [ERROR] "cache_get_data" - invalid connection handle. (ID = 1).
[16:30:29] [ERROR] "mysql_tquery" - invalid connection handle. (ID = 0).
[16:30:29] [ERROR] "cache_get_data" - invalid connection handle. (ID = 1).
[16:30:29] [ERROR] "mysql_tquery" - invalid connection handle. (ID = 0).
[16:30:29] [ERROR] "cache_get_data" - invalid connection handle. (ID = 1).
[16:30:29] [ERROR] "mysql_tquery" - invalid connection handle. (ID = 0).
[16:30:29] [ERROR] "cache_get_data" - invalid connection handle. (ID = 1).
[16:30:29] [ERROR] "mysql_tquery" - invalid connection handle. (ID = 0).
[16:30:29] [ERROR] "cache_get_data" - invalid connection handle. (ID = 1).
[16:30:29] [ERROR] "mysql_tquery" - invalid connection handle. (ID = 0).
[16:30:29] [ERROR] "cache_get_data" - invalid connection handle. (ID = 1).
[16:30:29] [ERROR] "mysql_tquery" - invalid connection handle. (ID = 0).
[16:30:29] [ERROR] "cache_get_data" - invalid connection handle. (ID = 1).
[16:30:29] [ERROR] "mysql_tquery" - invalid connection handle. (ID = 0).
[16:30:29] [ERROR] "cache_get_data" - invalid connection handle. (ID = 1).
[16:30:29] [ERROR] "mysql_tquery" - invalid connection handle. (ID = 0).
[16:30:29] [ERROR] "cache_get_data" - invalid connection handle. (ID = 1).
[16:30:29] [ERROR] "mysql_tquery" - invalid connection handle. (ID = 0).
[16:30:29] [ERROR] "cache_get_data" - invalid connection handle. (ID = 1).
[16:30:29] [ERROR] "mysql_tquery" - invalid connection handle. (ID = 0).
[16:30:29] [ERROR] "cache_get_data" - invalid connection handle. (ID = 1).
[16:30:29] [ERROR] "mysql_tquery" - invalid connection handle. (ID = 0).
[16:30:29] [ERROR] "cache_get_data" - invalid connection handle. (ID = 1).
[16:30:29] [ERROR] "mysql_tquery" - invalid connection handle. (ID = 0).
[16:30:29] [ERROR] "cache_get_data" - invalid connection handle. (ID = 1).
[16:30:29] [ERROR] "mysql_tquery" - invalid connection handle. (ID = 0).
[16:30:29] [ERROR] "cache_get_data" - invalid connection handle. (ID = 1).
[16:30:29] [ERROR] "mysql_tquery" - invalid connection handle. (ID = 0).
[16:30:29] [ERROR] "cache_get_data" - invalid connection handle. (ID = 1).
[16:30:29] [ERROR] "mysql_tquery" - invalid connection handle. (ID = 0).
[16:30:29] [ERROR] "cache_get_data" - invalid connection handle. (ID = 1).
[16:30:29] [ERROR] "mysql_tquery" - invalid connection handle. (ID = 0).
[16:30:29] [ERROR] "cache_get_data" - invalid connection handle. (ID = 1).
[16:30:29] [ERROR] "mysql_tquery" - invalid connection handle. (ID = 0).
[16:30:29] [ERROR] "cache_get_data" - invalid connection handle. (ID = 1).
[16:30:29] [ERROR] "mysql_tquery" - invalid connection handle. (ID = 0).
[16:30:29] [ERROR] "cache_get_data" - invalid connection handle. (ID = 1).
[16:30:29] [ERROR] "mysql_tquery" - invalid connection handle. (ID = 0).
[16:30:29] [ERROR] "cache_get_data" - invalid connection handle. (ID = 1).
[16:30:29] [ERROR] "mysql_tquery" - invalid connection handle. (ID = 0).
[16:30:29] [ERROR] "cache_get_data" - invalid connection handle. (ID = 1).
[16:30:29] [ERROR] "mysql_tquery" - invalid connection handle. (ID = 0).
[16:30:29] [ERROR] "cache_get_data" - invalid connection handle. (ID = 1).
[16:30:29] [ERROR] "mysql_tquery" - invalid connection handle. (ID = 0).
[16:30:29] [ERROR] "cache_get_data" - invalid connection handle. (ID = 1).
[16:30:29] [ERROR] "mysql_tquery" - invalid connection handle. (ID = 0).
[16:30:29] [ERROR] "cache_get_data" - invalid connection handle. (ID = 1).
[16:30:29] [ERROR] "mysql_tquery" - invalid connection handle. (ID = 0).
[16:30:29] [ERROR] "cache_get_data" - invalid connection handle. (ID = 1).
[16:30:29] [ERROR] "mysql_tquery" - invalid connection handle. (ID = 0).
[16:30:29] [ERROR] "cache_get_data" - invalid connection handle. (ID = 1).
[16:30:29] [ERROR] "mysql_tquery" - invalid connection handle. (ID = 0).
[16:30:29] [ERROR] "cache_get_data" - invalid connection handle. (ID = 1).
[16:30:29] [ERROR] "mysql_tquery" - invalid connection handle. (ID = 0).
[16:30:29] [ERROR] "cache_get_data" - invalid connection handle. (ID = 1).
[16:30:29] [ERROR] "mysql_tquery" - invalid connection handle. (ID = 0).
[16:30:29] [ERROR] "cache_get_data" - invalid connection handle. (ID = 1).
[16:30:29] [ERROR] "mysql_tquery" - invalid connection handle. (ID = 0).
[16:30:29] [ERROR] "cache_get_data" - invalid connection handle. (ID = 1).
[16:30:29] [ERROR] "mysql_tquery" - invalid connection handle. (ID = 0).
[16:30:29] [ERROR] "cache_get_data" - invalid connection handle. (ID = 1).
[16:30:29] [ERROR] "mysql_tquery" - invalid connection handle. (ID = 0).
[16:30:29] [ERROR] "cache_get_data" - invalid connection handle. (ID = 1).
[16:30:29] [ERROR] "mysql_tquery" - invalid connection handle. (ID = 0).
[16:30:29] [ERROR] "cache_get_data" - invalid connection handle. (ID = 1).
[16:30:29] [ERROR] "mysql_tquery" - invalid connection handle. (ID = 0).
[16:30:29] [ERROR] "cache_get_data" - invalid connection handle. (ID = 1).
[16:30:29] [ERROR] "mysql_tquery" - invalid connection handle. (ID = 0).
[16:30:29] [ERROR] "cache_get_data" - invalid connection handle. (ID = 1).
[16:30:29] [ERROR] "mysql_tquery" - invalid connection handle. (ID = 0).
[16:30:29] [ERROR] "cache_get_data" - invalid connection handle. (ID = 1).
[16:30:29] [ERROR] "mysql_tquery" - invalid connection handle. (ID = 0).
[16:30:29] [ERROR] "cache_get_data" - invalid connection handle. (ID = 1).
[16:30:29] [ERROR] "mysql_tquery" - invalid connection handle. (ID = 0).
[16:30:29] [ERROR] "cache_get_data" - invalid connection handle. (ID = 1).
[16:30:29] [ERROR] "mysql_tquery" - invalid connection handle. (ID = 0).
[16:30:29] [ERROR] "cache_get_data" - invalid connection handle. (ID = 1).
[16:30:29] [ERROR] "mysql_tquery" - invalid connection handle. (ID = 0).
[16:30:29] [ERROR] "cache_get_data" - invalid connection handle. (ID = 1).
[16:30:29] [ERROR] "mysql_tquery" - invalid connection handle. (ID = 0).
[16:30:29] [ERROR] "cache_get_data" - invalid connection handle. (ID = 1).
[16:30:29] [ERROR] "mysql_tquery" - invalid connection handle. (ID = 0).
[16:30:29] [ERROR] "cache_get_data" - invalid connection handle. (ID = 1).
[16:30:29] [ERROR] "mysql_tquery" - invalid connection handle. (ID = 0).
[16:30:29] [ERROR] "cache_get_data" - invalid connection handle. (ID = 1).
[16:30:29] [ERROR] "mysql_tquery" - invalid connection handle. (ID = 0).
[16:30:29] [ERROR] "cache_get_data" - invalid connection handle. (ID = 1).
[16:30:29] [ERROR] "mysql_tquery" - invalid connection handle. (ID = 0).
[16:30:29] [ERROR] "cache_get_data" - invalid connection handle. (ID = 1).
[16:30:46] [ERROR] "mysql_tquery" - invalid connection handle. (ID = 0).
[16:31:19] [ERROR] "mysql_tquery" - invalid connection handle. (ID = 0).
[16:31:19] [ERROR] "cache_get_data" - invalid connection handle. (ID = 1).
Question:
How To Fix It? Thanks
Find
Reply
Konstantinos
Spam Machine
*****
Posts: 11,827
Threads: 33
Joined: Dec 2011
Reputation: 0
#2

02.09.2013, 08:33
What does the mysql log print?
Find
Reply
viveka27
Big Clucker
***
Posts: 67
Threads: 13
Joined: Nov 2012
Reputation: 0
#3

02.09.2013, 12:05
Where I Can Find It? I'm have check mysql_error_log.txt(Custom Script to write onqueryerror)
Find
Reply
WopsS
Huge Clucker
****
Posts: 490
Threads: 5
Joined: Nov 2011
Reputation: 0
#4

02.09.2013, 12:07
What is your MySQL version? And change
pawn Код:
format(query, sizeof(query), "SELECT `Username` FROM `accounts` WHERE `Username` = '%s'", PlayerName(playerid));
    mysql_function_query(handle, query, true, "OnAccountCheck", "d", playerid);
with
pawn Код:
format(query, sizeof(query), "SELECT * FROM `accounts` WHERE `Username` = '%s'", PlayerName(playerid));
    mysql_function_query(handle, query, true, "OnAccountCheck", "d", playerid);
Find
Reply
Konstantinos
Spam Machine
*****
Posts: 11,827
Threads: 33
Joined: Dec 2011
Reputation: 0
#5

02.09.2013, 12:09
It's on the main directory. It's on the same place where samp-server.exe is located at. If it failed for some reason, it would write the reason.
Find
Reply
Armyy
Little Clucker
**
Posts: 7
Threads: 1
Joined: Oct 2011
Reputation: 0
#6

02.09.2013, 13:08
( Последний раз редактировалось Armyy; 02.09.2013 в 17:38. )
When u have "mysql_debug(1)" in OnGameModeInit you can find your MySQL log in file Debug.txt, it's like server_log.txt

Edit: or in newest version it's "mysql_log(1-4)" and log is in file mysql_log.txt
Find
Reply
viveka27
Big Clucker
***
Posts: 67
Threads: 13
Joined: Nov 2012
Reputation: 0
#7

03.09.2013, 08:10
Quote:
Originally Posted by Konstantinos
Посмотреть сообщение
It's on the main directory. It's on the same place where samp-server.exe is located at. If it failed for some reason, it would write the reason.
I Have Check it.No Error founded
Find
Reply
Lorenc_
High-roller
*****
Posts: 3,793
Threads: 196
Joined: Jan 2010
Reputation: 0
#8

03.09.2013, 08:21
Quote:
Originally Posted by WopsS
Посмотреть сообщение
What is your MySQL version? And change
pawn Код:
format(query, sizeof(query), "SELECT `Username` FROM `accounts` WHERE `Username` = '%s'", PlayerName(playerid));
    mysql_function_query(handle, query, true, "OnAccountCheck", "d", playerid);
with
pawn Код:
format(query, sizeof(query), "SELECT * FROM `accounts` WHERE `Username` = '%s'", PlayerName(playerid));
    mysql_function_query(handle, query, true, "OnAccountCheck", "d", playerid);
You realise you've worsened the query that way?

OT: Use print checks everywhere, see if the callback is being actually called.
Find
Reply
viveka27
Big Clucker
***
Posts: 67
Threads: 13
Joined: Nov 2012
Reputation: 0
#9

03.09.2013, 08:26
Quote:
Originally Posted by Konstantinos
Посмотреть сообщение
It's on the main directory. It's on the same place where samp-server.exe is located at. If it failed for some reason, it would write the reason.
I Have Check it.No Error founded
Find
Reply
viveka27
Big Clucker
***
Posts: 67
Threads: 13
Joined: Nov 2012
Reputation: 0
#10

03.09.2013, 08:33
Quote:
Originally Posted by WopsS
Посмотреть сообщение
What is your MySQL version? And change
pawn Код:
format(query, sizeof(query), "SELECT `Username` FROM `accounts` WHERE `Username` = '%s'", PlayerName(playerid));
    mysql_function_query(handle, query, true, "OnAccountCheck", "d", playerid);
with
pawn Код:
format(query, sizeof(query), "SELECT * FROM `accounts` WHERE `Username` = '%s'", PlayerName(playerid));
    mysql_function_query(handle, query, true, "OnAccountCheck", "d", playerid);
I Have change it.Still Same.Callback not called
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 3 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help