1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
| <?php
|
| /************
| * 计划任务：每日自动更新部分职位
| * 仅作参考
| */
| global $db_config,$db;
|
| $stime = time()-86400*31;
| $query = $db->query("SELECT r1.id FROM $db_config[def]company_job AS r1 JOIN (SELECT ROUND(RAND() * (SELECT MAX(id) FROM $db_config[def]company_job)) AS id) AS r2 WHERE r1.id >= r2.id AND `sdate`>'".$stime."' AND `state`=1 AND `r_status`<>2 AND `status`<>1 ORDER BY r1.id ASC LIMIT 30");
|
|
| while($rs = $db->fetch_array($query))
| {
| $LastTime = strtotime('-'.rand(1,59).' minutes', time());
| $db->query("update $db_config[def]company_job set `lastupdate`='".$LastTime."' where `id`='".$rs['id']."'");
| // $db->update_all("company_job","`lastupdate`='".$LastTime."'","`id`='".$rs['id']."'");
| }
|
|
| ?>
|
|
