Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
schedule_development [2016/12/08 22:07] textstorm |
schedule_development [2016/12/08 22:10] textstorm |
||
---|---|---|---|
Line 9: | Line 9: | ||
You **will not** be able to instantiate the //User class// or //use any functions// with schedules. | You **will not** be able to instantiate the //User class// or //use any functions// with schedules. | ||
===== Schedule Structure ===== | ===== Schedule Structure ===== | ||
- | Start with the below code structure: | + | Start with the below code structure and add your own code underneath the "Put your schedule code here" comment: |
<file php ScheduleStructure.php> | <file php ScheduleStructure.php> | ||
<?php | <?php | ||
Line 21: | Line 21: | ||
//set $count to the number of rows you have updated ($queryresult->rowCount();) it will store how many rows were affected the last time the schedule ran | //set $count to the number of rows you have updated ($queryresult->rowCount();) it will store how many rows were affected the last time the schedule ran | ||
$db->query("UPDATE scheduler SET rowsaff = '$count', running = '0' WHERE schedref = '$schedref'"); | $db->query("UPDATE scheduler SET rowsaff = '$count', running = '0' WHERE schedref = '$schedref'"); | ||
+ | } | ||
+ | ?> | ||
+ | </file> | ||
+ | |||
+ | The below code is an example of a simple schedule to clear down old Administration Panel logs: | ||
+ | <file php ClearAdminLogsSchedule.php> | ||
+ | <?php | ||
+ | if($caller) { | ||
+ | $schedref = "LOG1"; | ||
+ | $date = date("Y-m-d"); | ||
+ | $dategen = new DateTime($date); | ||
+ | $dategen->modify('-30 day'); | ||
+ | $deldate = $dategen->format('Y-m-d'); | ||
+ | $del = $db->query("DELETE FROM panel_logs WHERE logdate < '$deldate'"); | ||
+ | $count = $del->rowCount(); | ||
+ | $db->query("UPDATE scheduler SET rowsaff = '$count' WHERE schedref = '$schedref'"); | ||
} | } | ||
?> | ?> |