[yxliang]

I use mysql plugin r7

Код:

mysql_function_query(mysql_Account, query, false, "IsResultExist","i",i);

[yxliang]

any one knows that?

[jonrb]

Check what this outputs:

Код:

public OnQueryError(errorid, error[], resultid, extraid, callback[], query[], connectionHandle)
{
printf("(%i) %s",errorid, error);
}

[yxliang]

Quote:

Originally Posted by jonrb Check what this outputs: Код: public OnQueryError(errorid, error[], resultid, extraid, callback[], query[], connectionHandle) { printf("(%i) %s",errorid, error); }

that's not error exist. In mysql_log.txt that is wrote about query success. So IsResultExist should be runned.

[18:00:18] Passing query SELECT `Id` FROM `Account` WHERE `Name`='Mxtdg_Goodx' limit 1 | i
[18:00:18] ProcessQueryThread(IsResultExist) - Query was successful. (SELECT `Id` FROM `Account` WHERE `Name`='Mxtdg_Goodx' limit 1)
[18:00:18] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()

[yxliang]

Need help..

[yxliang]

Quote:

Originally Posted by ****** Can you show your "IsResultExist" function?

Can you reply the pm message?

Код:

forward IsResultExist(handleid);
public IsResultExist(handleid)
{
    SendClientMessageToAll(COLOR_RED,"IsResultExist Runned");
    mysql_store_result_Account();
    if(!mysql_num_rows_Account())
    {
	mysql_Result_Check[handleid] = 0;
    }
	else
	{
	mysql_Result_Check[handleid] = 1;
	}
	mysql_free_result_Account();
return 1;
}

[B-Matt]

This need to be like this:

pawn Код:

mysql_function_query(mysql_Account, query, false, "IsResultExist","i",playerid);

If you don't need return of playerid use something else.

[coakiddo]

You disabled cache.

Код:

mysql_function_query(mysql_Account, query,true, "IsResultExist","i",playerid);

Код:

public IsResultExist(handleid)
{
    new rows,fields;
    cache_get_data(rows,fields);
    if(rows)
    {
    }
    else
    {
    }
    return 1; // No need for mysql_free_result if you return it.
}

[yxliang]

Quote:

Originally Posted by coakiddo You disabled cache. Код: mysql_function_query(mysql_Account, query,true, "IsResultExist","i",playerid); Код: public IsResultExist(handleid) { new rows,fields; cache_get_data(rows,fields); if(rows) { } else { } return 1; // No need for mysql_free_result if you return it. }

You think I must enable cache to use mysql_function_query? But I have seen the a_mysql include

Код:

#define mysql_query(%1,%2,%3,%4) \
	mysql_function_query(%4,%1,false,"OnQueryFinish","siii",%1,%2,%3,%4)

So I think I don't need use cache.

[yxliang]

Quote:

Originally Posted by coakiddo You disabled cache. Код: mysql_function_query(mysql_Account, query,true, "IsResultExist","i",playerid); Код: public IsResultExist(handleid) { new rows,fields; cache_get_data(rows,fields); if(rows) { } else { } return 1; // No need for mysql_free_result if you return it. }

I tried to enable cache but I got same result.