最近在做一个phpwind的插件,但是对phpwind也不是太熟悉,更可恶的是phpwind团队写的php代码是真看不了.太多弯弯绕了,找来找去,都找晕了.索性朝mysql下手吧,插件功能是往phpwind发一新贴看看都改动了哪些表,网上找了一大通也没有找到合适的.
最后找来个my.ini的配置文件说明看了看偶然发现简单设置就可以
在my.ini 或my.cnf里面添加如下设置.重启mysql
[mysqld]
log=E:/MySQL5.1/my.log
log-output=FILE
看下log文件记录
Time Id Command Argument
100331 10:46:16 1 Connect on
1 Query SET character_set_connection=gbk,character_set_results=gbk,character_set_client=binary
1 Query SET sql_mode=''
1 Init DB phpwind
100331 10:46:17 1 Query SELECT uid,username,password,safecv,email,regdate FROM pw_members WHERE username= 'admin'
1 Query SELECT * FROM pw_ucapp
1 Query SELECT m.uid,m.username,m.password,m.safecv,m.groupid,m.memberid,m.yz,md.onlineip, md.postnum,md.rvrc,md.money,md.credit,md.currency,md.lastpost,md.onlinetime,md.todaypost,md.monthpost FROM pw_members m LEFT JOIN pw_memberdata md ON md.uid=m.uid WHERE m.uid= '1' AND m.groupid<>'0' AND md.uid IS NOT NULL
1 Query SELECT cid,value FROM pw_membercredit WHERE uid= '1'
1 Query REPLACE INTO pw_elements(type,mark,id,value,addition,time) VALUES ('usersort','money','1','6','admin','1270003576') , ('usersort','rvrc','1','2','admin','1270003576') , ('usersort','monthpost','1','5','admin','1270003576') , ('usersort','postnum','1','6','admin','1270003576')
1 Query SELECT * FROM pw_elements WHERE type='usersort' AND mark IN ('money','rvrc','monthpost','postnum') ORDER BY mark,value DESC
1 Query UPDATE pw_memberdata SET monoltime=IF(lastvisit<'1267372800',0,monoltime), lastvisit='1270003576', thisvisit='1270003576', onlineip='127.0.0.1|1270003576|6' WHERE uid= '1'
100331 10:46:18 1 Quit
------------------------------------------------------------------------------------------------------
哈哈太清楚了.
转载于:https://blog.51cto.com/ylj798/1061879