[FIX] FTS 1.1 remove expired warnings

[Edgein]

When a user is warned and the warned time is over
the system does not remove the warning automatic

go to /include/libs/cron/cron_class.php
and find

PHP Code:

    public function deadtime()
    { 


above add

PHP Code:

//remove expired warnings
  $res = mysql_query("SELECT id FROM users WHERE warned='yes' AND warneduntil < NOW() AND warneduntil <> '0000-00-00 00:00:00'") or sqlerr(__FILE__, __LINE__);
  if (mysql_num_rows($res) > 0)
  {
    $dt = sqlesc(get_date_time());
    $msg = sqlesc("Your warning has been removed. Please keep in your best behaviour from now on.\n");
    while ($arr = mysql_fetch_assoc($res))
    {
      mysql_query("UPDATE users SET warned = 'no', warneduntil = '0000-00-00 00:00:00' WHERE id = $arr[id]") or sqlerr(__FILE__, __LINE__);
      mysql_query("INSERT INTO messages (sender, receiver, added, msg, poster) VALUES(0, $arr[id], $dt, $msg, 0)") or sqlerr(__FILE__, __LINE__);
    }
  }
//end remove expired warnings 


grtzz Edgein

[yordanov2010]

what is fts? copied/modified version of xam 1.3/3/4/5 series?

btw do you really know anything about coding? if yes please let me know what does following lines means;

PHP Code:

$dt = sqlesc(get_date_time());
$msg = sqlesc("Your warning has been removed. Please keep in your best behaviour from now on.\n"); 


[Edgein]

lol what a questionto test or skills there are other sites

and what if there are people who love the FTS source
while I find it a hobby to help people whether I am a coder or not

[joeroberts]

Originally Posted by yordanov2010

what is fts? copied/modified version of xam 1.3/3/4/5 series?

btw do you really know anything about coding? if yes please let me know what does following lines means;

PHP Code:

$dt = sqlesc(get_date_time());
$msg = sqlesc("Your warning has been removed. Please keep in your best behaviour from now on.\n"); 


$dt = sqlesc(get_date_time());

is a call to 2 functions to generate a time stamp and set it as a variable {$dt}!

$msg = sqlesc("Your warning has been removed. Please keep in your best behaviour from now on.\n");

is all call to a function to clean up a message and add forward slashes to all {" ' and "} to help stop sql injections
and to set that message as a variable {$msg}

if you want to test a coder you well need to try harder then that

[yordanov2010]

Originally Posted by joeroberts

is a call to 2 functions to generate a time stamp and set it as a variable {$dt}!

You don't need any protection for those both lines. That's why I asked this basic question. get_date_time() should be NOW()

and the second one must be: $msg = "Your warning has been removed.

Please keep in your best behaviour from now on.\n";

[joeroberts]

some data bases servers run a different time then the php server and using
because some hosts well use a external database server in a different location
[if you do not use localhost you use a

blabla.ru.co

for your $db_host = "localhost";]
sqlesc() is just a standerd.