SELECT count( ddid ) AS num, .( if(
STATUS =1, 1, NULL ) ) AS success, count( if(
STATUS =0, 1, NULL ) ) AS fail, ROUND( count( if( STATUS =1, 1, NULL ) ) / count( ddid ) *100, 2 ) AS result, userid
FROM fx_dingdan
GROUP BY userid
LIMIT 0 , 30
$userdingdan15 = SM('Dingdan')->groupData('count( ddid ) AS num, count( if( STATUS =1, 1, NULL ) ) AS success, count( if( STATUS =0, 1, NULL ) ) AS fail, userid' , 'addtime between ' . $start15min . ' AND '. $end ,'userid');
select count(ddid) as num , count(if(status = 1,1,null)) as success, count(if(status = 0,1,null)) as fail, ROUND(count(if(status = 1,1,null))/count(if(status = 0,1,null))) as result, userid from fx_dingdan where addtime between 1557244800 and 155733119 group by userid
https://processhacker.sourceforge.io/
netstat -ano
PID 找到相對應的 程式
sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
KK企业
利勤宏
[email protected]
yml365898
邯郸充昌
[email protected]
yml365898
DELETE FROM `fx_dingdan` WHERE status = 0 and addtime < 1575043200
可在外部注册line 取到authkey
用filder 抓封包
https://w.line.me/lrs/r?X-Line-Application=DESKTOPWIN%096.3.2.2338%09WINDOWS%0910.0.0-NT-x64®ion=TW&langCode=zh_TW&applicationType=DESKTOPWIN&deviceName=DESKTOPWIN_6.3.2.2338_DESKTOP-F2F55N5&systemName=DESKTOP-F2F55N5&systemVersion=10.0.0&zoom=100&model=DESKTOPWIN_6.3.2.2338_DESKTOP-F2F55N5%23