CRON scripts

[GetRekt]

Ubercms cron

How do I make this

<?php

if (!defined('UBER') || !UBER)
{
    exit;
}

dbquery("UPDATE user_stats SET DailyRespectPoints = '5'");

?>

I want to make a credit reset script but for VIP ranks 2-6

 

[Data]

Just setup a navicat event.

 

[GetRekt]

Can I make it so it updates only the people with rank 2-6

 

[Data]

Set it up as a cron, best thing to do I guess.

<?php 
$select = mysql_fetch_assoc(mysql_query("SELECT * FROM users WHERE rank >= 2"));
mysql_query("UPDATE user_stats SET DailyRespectPoints = '5' WHERE id = '{$select['id']}'");
echo 'Done.';
?>

I don't know if this will work, but that is similar how it should be done.
Then setup a cronjob to run every 24 hours.

 

[GetRekt]

Can you make a event for navicat for me that might be better I forgot all about that