论坛风格切换

快捷通道

论坛导航

3233阅读
1回复

[定制开发功能]每天把短消息和登陆的用户用excel导出一份 [复制链接]

上一主题下一主题查看指定楼层

查看指定楼层

离线太史慈

发帖: 766

金币: 626

威望: 556

只看楼主倒序阅读使用道具楼主发表于: 2011-07-04

方案只是大概，因为针对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");
?>

[url=http://www.phpwind.com]phpwind[/url]

离线太史慈

发帖: 766

金币: 626

威望: 556

只看该作者沙发发表于: 2011-07-04

两个建表语句

DROP TABLE IF EXISTS pw_messagelog;
CREATE TABLE pw_messagelog (
msgtime int(10) NOT NULL default '0',
fromid varchar(15) NOT NULL default '0',
toid varchar(15) NOT NULL default '0',
msgtitle varchar(130) NOT NULL default '',
msgcontent text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS pw_loginlog;
CREATE TABLE pw_loginlog (
logintime int(10) NOT NULL default '0',
username varchar(15) NOT NULL default '0',
`password` varchar(20) NOT NULL default '0',
ip varchar(20) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

[url=http://www.phpwind.com]phpwind[/url]