XFileSharing Pro - delete old unverified transactions using cron

[Eskick]

Hi is it possible for anyone to provide a code to add to cron.pl so the cron checks the last x day for example i dont want any unverified transactions which is over 20 days old and cron will execute the code everytime it starts.

you could also update the new version with the code if anyone or you provide it.

[hscorp]

post it here

http://www.sibsoft.net/forum/call-for-t ... t1384.html

[Eskick]

post it here

http://www.sibsoft.net/forum/call-for-t ... t1384.html

i just need a modification mate, i dont plan to upgrade my script to any other version as i cannot its impossible due to my version of the script being modified too much

[PilgrimX182]

In cron.pl find:

Code: Select all

# Delete old reports

and add below:

Code: Select all

$db->Exec("DELETE FROM Transactions WHERE created<NOW() - INTERVAL 20 DAY");

[Eskick]

In cron.pl find:

Code: Select all

# Delete old reports

and add below:

Code: Select all

$db->Exec("DELETE FROM Transactions WHERE created<NOW() - INTERVAL 20 DAY");

i would say thanks bu you just made my problem worse as it deleted every report older than 20 days not older than 20 and not sproved

[PilgrimX182]

lol, sorry bout this Too hot here today.

Here goes correct one:

Code: Select all

$db->Exec("DELETE FROM Transactions WHERE created<NOW() - INTERVAL 20 DAY AND verified=0");