· 7 years ago · Nov 22, 2018, 11:44 PM
1## Database
2
3DROP TABLE IF EXISTS `cms_cron`;
4CREATE TABLE `cms_cron` (
5 `id` int(11) NOT NULL AUTO_INCREMENT,
6 `prio` int(11) NOT NULL DEFAULT '5',
7 `enabled` enum('0','1') NOT NULL DEFAULT '1',
8 `last_exec` int(11) NOT NULL,
9 `exec_every` int(11) NOT NULL,
10 PRIMARY KEY (`id`)
11) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
12
13
14INSERT INTO `cms_cron` VALUES ('1', '5', '1', '1347481927', '86400');
15
16## Database
17
18
19<?php
20class Corncore
21{
22 public function __construct()
23 {
24 self::Execute();
25 }
26
27 public static function Execute()
28 {
29 $sql = mysql_query("SELECT * FROM `cms_cron` WHERE `enabled` = '1' ORDER BY `prio` ASC");
30 while($cron = mysql_fetch_assoc($sql))
31 {
32
33 if(($cron['last_exec'] + $cron['exec_every']) <= time())
34 {
35 mysql_query("UPDATE `users` SET `vip` = '0' WHERE `rank` = '1' AND `vip` = '1'");
36 mysql_query("UPDATE `users` SET `rank` = '1' AND `vip` = '0' WHERE `vip_dagen` = '0' AND `rank` = '2'");
37 mysql_query("UPDATE `users` SET `vip_dagen` = `vip_dagen` - '1' WHERE `rank` = '2'");
38
39
40 mysql_query("UPDATE `user_stats` SET `dailyrespectpoints` = '10'");
41 mysql_query("UPDATE `user_stats` SET `dailypetrespectpoints` = '10'");
42
43
44 mysql_query("UPDATE `users` SET `credits` = '500000' WHERE `credits` > 10000000");
45 mysql_query("UPDATE `users` SET `activity_points` = '500000' WHERE `activity_points` > 10000000");
46
47 mysql_query("UPDATE `cms_cron` SET `last_exec` = '".time()."' WHERE `id` = '".$cron['id']."' LIMIT 1");
48 }
49 }
50 }
51}
52
53new Corncore();
54?>