CURRENT_TIMESTAMP - Printable Version

CURRENT_TIMESTAMP - 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: CURRENT_TIMESTAMP (/showthread.php?tid=600016)

CURRENT_TIMESTAMP - Bruker - 02.02.2016

Код HTML:

if(cache_get_field_content(0, "UnbanTime", bSt[3]) < CURRENT_TIMESTAMP())
{
    format(query, sizeof(query), "DELETE FROM `bans` WHERE `Name` = '%s'", GetName(playerid)), mysql_tquery(MySQLCon, query, "", "");
    return 1;
}

ERROR:

Код HTML:

error 017: undefined symbol "CURRENT_TIMESTAMP"

Why?

Re: CURRENT_TIMESTAMP - Abagail - 02.02.2016

SA-MP doesn't have a "CURRENT_TIMESTAMP" function, however passing no values by reference to gettime() will return the current unix timestamp.

Example:

pawn Код:

if(cache_get_field_content(0, "UnbanTime", bSt[3]) < gettime())

Re: CURRENT_TIMESTAMP - Bruker - 02.02.2016

"UnbanTime" something like: 2016-02-03 04:29:58
GetTime return: Hour, Minute, Second.

Re: CURRENT_TIMESTAMP - Cypress - 02.02.2016

Quote:

Originally Posted by Bruker

"UnbanTime" something like: 2016-02-03 04:29:58
GetTime return: Hour, Minute, Second.

You should use unix timestamps instead of dealing with plain dates. It will also be a lot easier to compare them in the future.

Here is a good example of what you're probably trying to achieve.

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

Re: CURRENT_TIMESTAMP - Bruker - 02.02.2016

Quote:

Originally Posted by Cypress

I want to ban expire in days.
Can I give an example of how to use unix timestamps, please?

Re: CURRENT_TIMESTAMP - Mencent - 02.02.2016

I would change your system to this:

PHP код:



//Where you fill in the value of "UnBanTime":

UnBanTime = gettime()+60*60*24*2 //2 days

UnBanTime has to be an integer. And then like this:

PHP код:



if(cache_get_field_content_int(0,"UnbanTime",MySQLCon) < gettime())

{

    format(query,sizeof query,"DELETE FROM `bans` WHERE `Name`='%s'",GetName(playerid));

    mysql_tquery(MySQLCon,query,"","");

    return 1;

}

Re: CURRENT_TIMESTAMP - Cypress - 02.02.2016

Quote:

Originally Posted by Mencent

I would change your system to this:

PHP код:



//Where you fill in the value of "UnBanTime":

UnBanTime = gettime()+60*60*24*2 //2 days

UnBanTime has to be an integer. And then like this:

PHP код:



if(cache_get_field_content_int(0,"UnbanTime",MySQLCon) < gettime())

{

    format(query,sizeof query,"DELETE FROM `bans` WHERE `Name`='%s'",GetName(playerid));

    mysql_tquery(MySQLCon,query,"","");

    return 1;

}

First of all UnbanTime isn't a variable in his code, it's a row name in his table.

You can also use pquery, if you're running the latest version of BlueG's MySQL plugin.

pawn Код:

mysql_pquery( MySQLCon, query );

Also, I already gave you an example of how you should do it, just look at jBan, it has everything that you need.

Here is a link to get it http://www.jatochnietdan.com/project/sa-mp/jban

pawn Код:

stock jUnbanName(name[], bool:expired = false)
{
    if(strlen(name) > MAX_PLAYER_NAME) return 0;
    
    mysql_real_escape_string(name, name);
    
    if(expired == false) format(jQuery, MAX_QUERY_LENGTH, "DELETE FROM `"#J_TABLE"` WHERE user_banned = '%s' AND NOW() <= DATE_ADD(ban_timestamp, INTERVAL ban_time MINUTE)", name);
    else format(jQuery, MAX_QUERY_LENGTH, "DELETE FROM `"#J_TABLE"` WHERE user_banned = '%s'", name);
    
    mysql_query(jQuery, QUERY_UNBAN_NAME, 0, jban_connection);
    return 1;
}

It uses a bit older version of MySQL, however you could just easily edit it.

Another method would be when you load the UnBanTime from SQL, assuming you're using unix timestamps,
you could do this.

pawn Код:

new unban_date;

// When loading the information
unban_date = cache_get_field_content_int(0,"UnbanTime" );

if ( unban_date < gettime() )
{
     format(query,sizeof query,"DELETE FROM `bans` WHERE `Name`='%e'",GetName(playerid));
    mysql_pquery( MySQLCon,query );
    return 1;
}