lastlogin[playerid] = gettime() + (1 * 86400);
if(experience[playerid] <= 50 && nologindays >= 15) { deleta pra ficar mais leve } else if(experience[playerid] >= 51 && experience[playerid] <= 100 && nologindays >= 30) { deleta pra ficar mais leve } else if(experience[playerid] >= 101 && experience[playerid] <= 250 && nologindays >= 90) { deleta pra ficar mais leve } else if(experience[playerid] >= 251 && experience[playerid] <= 500 && nologindays >= 120) { deleta pra ficar mais leve } else if(experience[playerid] >= 501 && nologindays >= 360) { deleta pra ficar mais leve }
pawn Код:
|
forward HoraPayDay(); public HoraPayDay() { new h, m, s; gettime(h, m, s); if (h == 00 && m == 00 || h == 01 && m == 00 || h == 02 && m == 00 || h == 03 && m == 00 || h == 04 && m == 00 || h == 05 && m == 00 || h == 06 && m == 00 || h == 07 && m == 00 || h == 08 && m == 00 || h == 09 && m == 00 || h == 10 && m == 00 || h == 11 && m == 00 || h == 12 && m == 00 || h == 13 && m == 00 || h == 14 && m == 00 || h == 15 && m == 00 || h == 16 && m == 00 || h == 17 && m == 00 || h == 18 && m == 00 || h == 19 && m == 00 || h == 20 && m == 00 || h == 21 && m == 00 || h == 22 && m == 00 || h == 23 && m == 00 ){ if(h == 07 && m == 00) { // globalSaveHour day = 86400 if(experience[playerid] <= 50 && gettime() >= lastlogin[playerid] + 15 * day) { } else if(experience[playerid] <= 51 && experience[playerid] <= 100 && gettime() >= lastlogin[playerid] + 30 * day) { } else if(experience[playerid] <= 101 && experience[playerid] <= 250 && gettime() >= lastlogin[playerid] + 90 * day) { } else if(experience[playerid] <= 251 && experience[playerid] <= 500 && gettime() >= lastlogin[playerid] + 120 * day) { } else if(experience[playerid] >= 501 && gettime() >= lastlogin[playerid] + 360 * day) { } new MySQL_Format[200]; mysql_query(ConnectMYSQL,"DELETE FROM `accounts` `lastlogin` < '%i'", VALOR ); mysql_function_query(ConnectMYSQL, MySQL_Format, false, "", ""); } tevepdextra = 0; PayDay(); SetHora(); } return 1; }
<?php
$link = mysql_connect('IP', 'User', 'Pass');
mysql_select_db('DB', $link);
$EXP = array(
50,
100,
250,
500
);
$TEMPO = array(
15 * 86400,
30 * 86400,
90 * 86400,
120 * 86400,
360 * 86400
);
$query = "DELETE * FROM `accounts` WHERE `lastlogin` UNIX_TIMESTAMP() >= (`lastlogin` + " . $TEMPO[1] .") AND `experience` <=" . $EXP[1];
mysql_query($query);
$num = mysql_affected_rows();
echo "$num rows deletadas que nгo logaram nos ultimos 15 dias, com experiencia menor que 50";
$query = "DELETE * FROM `accounts` WHERE `lastlogin` UNIX_TIMESTAMP() >= (`lastlogin` + " . $TEMPO[2] .") AND `experience` <=" . $EXP[2];
mysql_query($query);
$num = mysql_affected_rows();
echo "$num rows deletadas que nгo logaram nos ultimos 30 dias, com experiencia menor que 100";
$query = "DELETE * FROM `accounts` WHERE `lastlogin` UNIX_TIMESTAMP() >= (`lastlogin` + " . $TEMPO[3] .") AND `experience` <=" . $EXP[3];
mysql_query($query);
$num = mysql_affected_rows();
echo "$num rows deletadas que nгo logaram nos ultimos 90 dias, com experiencia menor que 250";
$query = "DELETE * FROM `accounts` WHERE `lastlogin` UNIX_TIMESTAMP() >= (`lastlogin` + " . $TEMPO[4] .") AND `experience` <=" . $EXP[4];
mysql_query($query);
$num = mysql_affected_rows();
echo "$num rows deletadas que nгo logaram nos ultimos 120 dias, com experiencia menor que 500";
$query = "DELETE * FROM `accounts` WHERE `lastlogin` UNIX_TIMESTAMP() >= (`lastlogin` + " . $TEMPO[5] .")";
mysql_query($query);
$num = mysql_affected_rows();
echo "$num rows deletadas que nгo logaram nos ultimos 360 dias, com qualquer experiencia";
PHP код:
|
foward CleanDB(); public CleanDB() { $link = mysql_connect('IP', 'User', 'Pass'); mysql_select_db('DB', $link); new EXP[4]; EXP[1] = 50; EXP[2] = 100; EXP[3] = 250; EXP[4] = 500; new TEMPO[5]; TEMPO[1] = 15 * 86400; TEMPO[2] = 30 * 86400; TEMPO[3] = 90 * 86400; TEMPO[4] = 120 * 86400; TEMPO[5] = 360 * 86400; $query = "DELETE * FROM `accounts` WHERE `lastlogin` UNIX_TIMESTAMP() >= (`lastlogin` + " , TEMPO[1] .") AND `experience` <=" , EXP[1]; mysql_query($query); $num = mysql_affected_rows(); print("$num rows deletadas que nгo logaram nos ultimos 15 dias, com experiencia menor que 50"); $query = "DELETE * FROM `accounts` WHERE `lastlogin` UNIX_TIMESTAMP() >= (`lastlogin` + " , TEMPO[2] .") AND `experience` <=" , EXP[2]; mysql_query($query); $num = mysql_affected_rows(); print("$num rows deletadas que nгo logaram nos ultimos 30 dias, com experiencia menor que 100"); $query = "DELETE * FROM `accounts` WHERE `lastlogin` UNIX_TIMESTAMP() >= (`lastlogin` + " , TEMPO[3] .") AND `experience` <=" , EXP[3]; mysql_query($query); $num = mysql_affected_rows(); print("$num rows deletadas que nгo logaram nos ultimos 90 dias, com experiencia menor que 250"); $query = "DELETE * FROM `accounts` WHERE `lastlogin` UNIX_TIMESTAMP() >= (`lastlogin` + " , TEMPO[4] .") AND `experience` <=" , EXP[4]; mysql_query($query); $num = mysql_affected_rows(); print("$num rows deletadas que nгo logaram nos ultimos 120 dias, com experiencia menor que 500"); $query = "DELETE * FROM `accounts` WHERE `lastlogin` UNIX_TIMESTAMP() >= (`lastlogin` + " , TEMPO[5] .")"; mysql_query($query); $num = mysql_affected_rows(); print("$num rows deletadas que nгo logaram nos ultimos 360 dias, com qualquer experiencia"); }