|
将以下两个功能,合并成一个计划任务执行:
https://www.fedcba9876543210.com/thread-3854-1-1.html
https://www.fedcba9876543210.com/thread-3244-1-1.html
新建一个计划任务,命名为:cron_regdateip.php
新建文件 source\include\cron\cron_regdateip.php 粘贴以下代码,保存即可:
- <?php
- if(!defined('IN_DISCUZ')) {
- exit('Access Denied');
- }
- $common_member = DB::table('common_member');
- $common_member_status = DB::table('common_member_status');
- $ucenter_members = DB::table('ucenter_members');
- foreach(DB::fetch_all("SELECT regdate,regip,uid FROM $ucenter_members") As $fetch) {
- $uid = $fetch['uid'];
- $regdate = $fetch['regdate'];
- $regip = $fetch['regip'];
- DB::query("UPDATE $common_member SET regdate = $regdate WHERE uid=$uid");
- DB::query("UPDATE $common_member_status SET regip ='$regip' WHERE uid=$uid");
- }
- ?>
复制代码 |
|