11.06.2012, 10:08
For starters, you query does not look quite fine. I tried having a look in the documentation, but it still beats me how a query like
SELECT Date < UNIX_TIMESTAMP() FROM bans WHERE IP = '...'
could return anything but true or false.
Also, the callback that is fired after query execution is NoThreadResult with the INVALID_PLAYER_ID passed to it. There are 2 issues to this:
1. Why would you name it NoThreadResult while you clearly need to work with the result and do it INSIDE the callback that is fired, not below the mysql_function_query itself?
2. Why do you pass INVALID_PLAYER_ID to the callback? How will you know the player ID when it appears that there is indeed a ban?
Lets get to fixing this code. What you need to do first is have the code in a custom callback, have a working query and have the right player ID passed to it.
This query will return data only if there's a ban which has not expired yet (I assumed that the field Date stores the unban timestamp).
Now move on to your custom callback.
Extremo is right and I feel incredibly shit for helping you out since you don't seem to put much effort into this, instead you just go around the forum and spam topics with the same issue. But actually, this seems to be the first time you ever do some code on your own rather than throw a bunch of code together into one .pwn file, so you might as well read this post of mine 
SELECT Date < UNIX_TIMESTAMP() FROM bans WHERE IP = '...'
could return anything but true or false.
Also, the callback that is fired after query execution is NoThreadResult with the INVALID_PLAYER_ID passed to it. There are 2 issues to this:
1. Why would you name it NoThreadResult while you clearly need to work with the result and do it INSIDE the callback that is fired, not below the mysql_function_query itself?
2. Why do you pass INVALID_PLAYER_ID to the callback? How will you know the player ID when it appears that there is indeed a ban?
Lets get to fixing this code. What you need to do first is have the code in a custom callback, have a working query and have the right player ID passed to it.
pawn Код:
GetPlayerIp(playerid, plrIP, sizeof(plrIP));
mysql_format(MySQLConnection, MySQL, "SELECT Date FROM bans WHERE IP = '%s' AND Date > UNIX_TIMESTAMP()", plrIP);
mysql_function_query(MySQLConnection, MySQL, true, "OnBanQueryFinish", "i", playerid);
Now move on to your custom callback.
pawn Код:
forward OnBanQueryFinish(playerid);
public OnBanQueryFinish(playerid)
{
new rows, fields;
cache_get_data(rows, fields);
// You might also want to add a LIMIT clause to your ban since you don't seem to use more than one row here.
if(rows)
{
new data[12];
cache_get_row(0, 0, data);
new expire = strval(data);
printf("Extracted unban time %d from string '%s'", expire, data);
SendClientMessage(playerid, COLOR, "You banned bro!");
}
return 1;
}