[2020-01-28 14:26:56] UPDATE pbxsetting SET lastupdatetimestamp='1580192816' WHERE PBXPid=1 [2020-01-28 14:26:56] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580192806 [2020-01-28 14:26:56] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580192816,`PBXCuid`=1580192816 [2020-01-28 14:26:56] UPDATE pbxsetting SET lastupdatetimestamp='1580192816' WHERE PBXPid=1 [2020-01-28 14:26:56] UPDATE pbxsetting SET lastupdatetimestamp='1580192816' WHERE PBXPid=1 [2020-01-28 14:26:56] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580192806 [2020-01-28 14:26:56] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580192816,`PBXCuid`=1580192816 [2020-01-28 14:26:56] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580192806 [2020-01-28 14:26:59] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580192819,`PBXCuid`=1580192819 [2020-01-28 14:28:52] UPDATE sales SET login_ip='192.168.0.159', login_time='15801929321352' WHERE Sid='1' LIMIT 1 [2020-01-28 14:28:52] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`type`) VALUES ('2020-01-28 14:28:52',1,'192.168.0.159',1,2) [2020-01-28 14:28:52] UPDATE sales SET lastlogindate='2020-01-28 14:28:52' WHERE Sid='1' LIMIT 1 [2020-01-28 14:28:52] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 14:28:54] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 14:28:55] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 14:28:55] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 14:28:56] UPDATE sales SET lastlogindate='2020-01-28 14:28:56' WHERE Sid='1' LIMIT 1 [2020-01-28 14:28:56] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 14:28:56] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 14:28:57] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 14:28:57] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 14:29:02] UPDATE sales SET lastlogindate='2020-01-28 14:29:02' WHERE Sid='1' LIMIT 1 [2020-01-28 14:29:02] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 14:29:03] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 14:29:03] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 14:29:03] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 14:29:04] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 14:29:04] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 14:29:17] UPDATE pbxsetting SET lastupdatetimestamp='1580192957' WHERE PBXPid=1 [2020-01-28 14:29:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580192947 [2020-01-28 14:29:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580192957,`PBXCuid`=1580192957 [2020-01-28 14:30:45] UPDATE pbxsetting SET lastupdatetimestamp='1580193045' WHERE PBXPid=1 [2020-01-28 14:30:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580193035 [2020-01-28 14:30:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580193045,`PBXCuid`=1580193045 [2020-01-28 14:32:02] UPDATE sales SET lastlogindate='2020-01-28 14:32:02' WHERE Sid='1' LIMIT 1 [2020-01-28 14:32:02] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 14:32:02] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 14:32:02] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 14:32:03] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 14:32:03] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 14:32:04] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 14:34:17] UPDATE pbxsetting SET lastupdatetimestamp='1580193257' WHERE PBXPid=1 [2020-01-28 14:34:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580193247 [2020-01-28 14:34:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580193257,`PBXCuid`=1580193257 [2020-01-28 14:35:09] UPDATE sales SET lastlogindate='2020-01-28 14:35:09' WHERE Sid='1' LIMIT 1 [2020-01-28 14:35:09] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 14:35:10] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 14:35:10] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 14:35:10] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 14:35:11] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 14:35:11] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 14:35:33] INSERT INTO adminlog ( `logintime`, `id`, `ip`, `status`, `field`, `remark`, `r`, `type` ) VALUES ( NOW(), '1', '192.168.0.159', '8', 'project', '樓盤︰油塘/住宅 - 油翠苑 座: C, 單位: 02, 層: 18, 地段編號: *', '8845', '2' ) [2020-01-28 14:35:45] UPDATE pbxsetting SET lastupdatetimestamp='1580193345' WHERE PBXPid=1 [2020-01-28 14:35:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580193335 [2020-01-28 14:35:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580193345,`PBXCuid`=1580193345 [2020-01-28 14:39:17] UPDATE pbxsetting SET lastupdatetimestamp='1580193557' WHERE PBXPid=1 [2020-01-28 14:39:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580193547 [2020-01-28 14:39:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580193557,`PBXCuid`=1580193557 [2020-01-28 14:39:20] UPDATE sales SET lastlogindate='2020-01-28 14:39:20' WHERE Sid='1' LIMIT 1 [2020-01-28 14:39:20] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 14:39:20] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 14:39:20] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 14:39:21] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 14:40:45] UPDATE pbxsetting SET lastupdatetimestamp='1580193645' WHERE PBXPid=1 [2020-01-28 14:40:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580193635 [2020-01-28 14:40:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580193645,`PBXCuid`=1580193645 [2020-01-28 14:44:17] UPDATE pbxsetting SET lastupdatetimestamp='1580193857' WHERE PBXPid=1 [2020-01-28 14:44:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580193847 [2020-01-28 14:44:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580193857,`PBXCuid`=1580193857 [2020-01-28 14:45:45] UPDATE pbxsetting SET lastupdatetimestamp='1580193945' WHERE PBXPid=1 [2020-01-28 14:45:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580193935 [2020-01-28 14:45:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580193945,`PBXCuid`=1580193945 [2020-01-28 14:45:51] UPDATE admin SET login_ip='' WHERE id='1' LIMIT 1 [2020-01-28 14:45:51] INSERT INTO adminlog ( `logintime`, `id`, `ip`, `status`, `type` ) VALUES ( NOW(), '1', '192.168.0.159', '9', '2' ) [2020-01-28 14:49:17] UPDATE pbxsetting SET lastupdatetimestamp='1580194157' WHERE PBXPid=1 [2020-01-28 14:49:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580194147 [2020-01-28 14:49:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580194157,`PBXCuid`=1580194157 [2020-01-28 14:50:45] UPDATE pbxsetting SET lastupdatetimestamp='1580194245' WHERE PBXPid=1 [2020-01-28 14:50:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580194235 [2020-01-28 14:50:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580194245,`PBXCuid`=1580194245 [2020-01-28 14:54:17] UPDATE pbxsetting SET lastupdatetimestamp='1580194457' WHERE PBXPid=1 [2020-01-28 14:54:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580194447 [2020-01-28 14:54:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580194457,`PBXCuid`=1580194457 [2020-01-28 14:55:45] UPDATE pbxsetting SET lastupdatetimestamp='1580194545' WHERE PBXPid=1 [2020-01-28 14:55:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580194535 [2020-01-28 14:55:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580194545,`PBXCuid`=1580194545 [2020-01-28 14:59:17] UPDATE pbxsetting SET lastupdatetimestamp='1580194757' WHERE PBXPid=1 [2020-01-28 14:59:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580194747 [2020-01-28 14:59:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580194757,`PBXCuid`=1580194757 [2020-01-28 15:00:45] UPDATE pbxsetting SET lastupdatetimestamp='1580194845' WHERE PBXPid=1 [2020-01-28 15:00:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580194835 [2020-01-28 15:00:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580194845,`PBXCuid`=1580194845 [2020-01-28 15:04:17] UPDATE pbxsetting SET lastupdatetimestamp='1580195057' WHERE PBXPid=1 [2020-01-28 15:04:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580195047 [2020-01-28 15:04:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580195057,`PBXCuid`=1580195057 [2020-01-28 15:05:45] UPDATE pbxsetting SET lastupdatetimestamp='1580195145' WHERE PBXPid=1 [2020-01-28 15:05:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580195135 [2020-01-28 15:05:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580195145,`PBXCuid`=1580195145 [2020-01-28 15:09:17] UPDATE pbxsetting SET lastupdatetimestamp='1580195357' WHERE PBXPid=1 [2020-01-28 15:09:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580195347 [2020-01-28 15:09:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580195357,`PBXCuid`=1580195357 [2020-01-28 15:10:45] UPDATE pbxsetting SET lastupdatetimestamp='1580195445' WHERE PBXPid=1 [2020-01-28 15:10:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580195435 [2020-01-28 15:10:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580195445,`PBXCuid`=1580195445 [2020-01-28 15:14:17] UPDATE pbxsetting SET lastupdatetimestamp='1580195657' WHERE PBXPid=1 [2020-01-28 15:14:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580195647 [2020-01-28 15:14:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580195657,`PBXCuid`=1580195657 [2020-01-28 15:15:45] UPDATE pbxsetting SET lastupdatetimestamp='1580195745' WHERE PBXPid=1 [2020-01-28 15:15:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580195735 [2020-01-28 15:15:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580195745,`PBXCuid`=1580195745 [2020-01-28 15:19:17] UPDATE pbxsetting SET lastupdatetimestamp='1580195957' WHERE PBXPid=1 [2020-01-28 15:19:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580195947 [2020-01-28 15:19:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580195957,`PBXCuid`=1580195957 [2020-01-28 15:20:45] UPDATE pbxsetting SET lastupdatetimestamp='1580196045' WHERE PBXPid=1 [2020-01-28 15:20:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580196035 [2020-01-28 15:20:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580196045,`PBXCuid`=1580196045 [2020-01-28 15:24:17] UPDATE pbxsetting SET lastupdatetimestamp='1580196257' WHERE PBXPid=1 [2020-01-28 15:24:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580196247 [2020-01-28 15:24:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580196257,`PBXCuid`=1580196257 [2020-01-28 15:25:45] UPDATE pbxsetting SET lastupdatetimestamp='1580196345' WHERE PBXPid=1 [2020-01-28 15:25:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580196335 [2020-01-28 15:25:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580196345,`PBXCuid`=1580196345 [2020-01-28 15:29:17] UPDATE pbxsetting SET lastupdatetimestamp='1580196557' WHERE PBXPid=1 [2020-01-28 15:29:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580196547 [2020-01-28 15:29:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580196557,`PBXCuid`=1580196557 [2020-01-28 15:30:45] UPDATE pbxsetting SET lastupdatetimestamp='1580196645' WHERE PBXPid=1 [2020-01-28 15:30:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580196635 [2020-01-28 15:30:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580196645,`PBXCuid`=1580196645 [2020-01-28 15:34:17] UPDATE pbxsetting SET lastupdatetimestamp='1580196857' WHERE PBXPid=1 [2020-01-28 15:34:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580196847 [2020-01-28 15:34:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580196857,`PBXCuid`=1580196857 [2020-01-28 15:35:45] UPDATE pbxsetting SET lastupdatetimestamp='1580196945' WHERE PBXPid=1 [2020-01-28 15:35:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580196935 [2020-01-28 15:35:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580196945,`PBXCuid`=1580196945 [2020-01-28 15:39:17] UPDATE pbxsetting SET lastupdatetimestamp='1580197157' WHERE PBXPid=1 [2020-01-28 15:39:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580197147 [2020-01-28 15:39:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580197157,`PBXCuid`=1580197157 [2020-01-28 15:40:45] UPDATE pbxsetting SET lastupdatetimestamp='1580197245' WHERE PBXPid=1 [2020-01-28 15:40:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580197235 [2020-01-28 15:40:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580197245,`PBXCuid`=1580197245 [2020-01-28 15:44:17] UPDATE pbxsetting SET lastupdatetimestamp='1580197457' WHERE PBXPid=1 [2020-01-28 15:44:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580197447 [2020-01-28 15:44:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580197457,`PBXCuid`=1580197457 [2020-01-28 15:45:45] UPDATE pbxsetting SET lastupdatetimestamp='1580197545' WHERE PBXPid=1 [2020-01-28 15:45:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580197535 [2020-01-28 15:45:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580197545,`PBXCuid`=1580197545 [2020-01-28 15:49:17] UPDATE pbxsetting SET lastupdatetimestamp='1580197757' WHERE PBXPid=1 [2020-01-28 15:49:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580197747 [2020-01-28 15:49:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580197757,`PBXCuid`=1580197757 [2020-01-28 15:50:45] UPDATE pbxsetting SET lastupdatetimestamp='1580197845' WHERE PBXPid=1 [2020-01-28 15:50:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580197835 [2020-01-28 15:50:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580197845,`PBXCuid`=1580197845 [2020-01-28 15:54:17] UPDATE pbxsetting SET lastupdatetimestamp='1580198057' WHERE PBXPid=1 [2020-01-28 15:54:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580198047 [2020-01-28 15:54:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580198057,`PBXCuid`=1580198057 [2020-01-28 15:55:45] UPDATE pbxsetting SET lastupdatetimestamp='1580198145' WHERE PBXPid=1 [2020-01-28 15:55:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580198135 [2020-01-28 15:55:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580198145,`PBXCuid`=1580198145 [2020-01-28 15:59:17] UPDATE pbxsetting SET lastupdatetimestamp='1580198357' WHERE PBXPid=1 [2020-01-28 15:59:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580198347 [2020-01-28 15:59:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580198357,`PBXCuid`=1580198357 [2020-01-28 16:00:45] UPDATE pbxsetting SET lastupdatetimestamp='1580198445' WHERE PBXPid=1 [2020-01-28 16:00:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580198435 [2020-01-28 16:00:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580198445,`PBXCuid`=1580198445 [2020-01-28 16:04:17] UPDATE pbxsetting SET lastupdatetimestamp='1580198657' WHERE PBXPid=1 [2020-01-28 16:04:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580198647 [2020-01-28 16:04:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580198657,`PBXCuid`=1580198657 [2020-01-28 16:04:47] UPDATE sales SET login_ip='14.136.97.31', login_time='15801986872688' WHERE Sid='88' LIMIT 1 [2020-01-28 16:04:47] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`type`) VALUES ('2020-01-28 16:04:47',88,'14.136.97.31',1,2) [2020-01-28 16:04:47] UPDATE sales SET lastlogindate='2020-01-28 16:04:47' WHERE Sid='88' LIMIT 1 [2020-01-28 16:04:47] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 16:04:47] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 16:04:47] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 16:04:48] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 16:04:49] UPDATE sales SET lastlogindate='2020-01-28 16:04:49' WHERE Sid='88' LIMIT 1 [2020-01-28 16:04:49] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 16:04:49] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 16:04:49] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 16:04:49] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 16:05:19] UPDATE sales SET lastlogindate='2020-01-28 16:05:19' WHERE Sid='88' LIMIT 1 [2020-01-28 16:05:19] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 16:05:19] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 16:05:19] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 16:05:19] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 16:05:21] UPDATE sales SET lastlogindate='2020-01-28 16:05:21' WHERE Sid='88' LIMIT 1 [2020-01-28 16:05:21] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 16:05:22] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 16:05:22] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 16:05:22] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 16:05:29] UPDATE sales SET lastlogindate='2020-01-28 16:05:29' WHERE Sid='88' LIMIT 1 [2020-01-28 16:05:29] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 16:05:29] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 16:05:29] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 16:05:30] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 16:05:30] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 16:05:30] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 16:05:45] UPDATE pbxsetting SET lastupdatetimestamp='1580198745' WHERE PBXPid=1 [2020-01-28 16:05:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580198735 [2020-01-28 16:05:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580198745,`PBXCuid`=1580198745 [2020-01-28 16:05:56] UPDATE sales SET lastlogindate='2020-01-28 16:05:56' WHERE Sid='88' LIMIT 1 [2020-01-28 16:05:56] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 16:05:56] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 16:05:56] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 16:05:56] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 16:05:57] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 16:05:57] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 16:06:02] UPDATE sales SET lastlogindate='2020-01-28 16:06:02' WHERE Sid='88' LIMIT 1 [2020-01-28 16:06:02] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 16:06:02] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 16:06:02] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 16:06:03] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 16:06:03] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 16:06:03] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 16:06:03] UPDATE sales SET lastlogindate='2020-01-28 16:06:03' WHERE Sid='88' LIMIT 1 [2020-01-28 16:06:03] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 16:06:04] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 16:06:04] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 16:06:04] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 16:06:05] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 16:06:05] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 16:06:37] UPDATE sales SET lastlogindate='2020-01-28 16:06:37' WHERE Sid='88' LIMIT 1 [2020-01-28 16:06:37] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 16:06:37] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 16:06:38] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 16:06:38] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 16:06:38] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 16:06:39] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 16:06:44] INSERT INTO adminlog ( `logintime`, `id`, `ip`, `status`, `field`, `remark`, `r`, `type` ) VALUES ( NOW(), '88', '14.136.97.31', '10', 'project', '樓盤︰油塘/住宅 - 海傲灣 座: 1B, 單位: H, 層: 11, 地段編號: ', '10534', '2' ) [2020-01-28 16:07:40] UPDATE sales SET lastlogindate='2020-01-28 16:07:40' WHERE Sid='88' LIMIT 1 [2020-01-28 16:07:40] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 16:07:40] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 16:07:40] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 16:07:41] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 16:07:41] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 16:07:41] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 16:08:39] UPDATE sales SET lastlogindate='2020-01-28 16:08:39' WHERE Sid='88' LIMIT 1 [2020-01-28 16:08:39] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 16:08:39] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 16:08:39] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 16:08:40] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 16:08:40] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 16:08:40] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 16:09:17] UPDATE pbxsetting SET lastupdatetimestamp='1580198957' WHERE PBXPid=1 [2020-01-28 16:09:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580198947 [2020-01-28 16:09:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580198957,`PBXCuid`=1580198957 [2020-01-28 16:09:54] UPDATE sales SET lastlogindate='2020-01-28 16:09:54' WHERE Sid='88' LIMIT 1 [2020-01-28 16:09:54] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 16:09:54] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 16:09:54] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 16:09:55] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 16:09:55] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 16:09:55] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 16:10:23] UPDATE sales SET lastlogindate='2020-01-28 16:10:23' WHERE Sid='88' LIMIT 1 [2020-01-28 16:10:23] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 16:10:23] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 16:10:23] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 16:10:24] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 16:10:34] UPDATE sales SET lastlogindate='2020-01-28 16:10:34' WHERE Sid='88' LIMIT 1 [2020-01-28 16:10:34] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 16:10:35] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 16:10:35] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 16:10:35] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 16:10:45] UPDATE pbxsetting SET lastupdatetimestamp='1580199045' WHERE PBXPid=1 [2020-01-28 16:10:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580199035 [2020-01-28 16:10:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580199045,`PBXCuid`=1580199045 [2020-01-28 16:10:55] UPDATE sales SET lastlogindate='2020-01-28 16:10:55' WHERE Sid='88' LIMIT 1 [2020-01-28 16:10:55] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 16:10:55] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 16:10:55] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 16:10:55] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 16:14:17] UPDATE pbxsetting SET lastupdatetimestamp='1580199257' WHERE PBXPid=1 [2020-01-28 16:14:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580199247 [2020-01-28 16:14:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580199257,`PBXCuid`=1580199257 [2020-01-28 16:15:40] UPDATE sales SET lastlogindate='2020-01-28 16:15:40' WHERE Sid='88' LIMIT 1 [2020-01-28 16:15:40] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 16:15:40] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 16:15:40] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 16:15:41] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 16:15:45] UPDATE pbxsetting SET lastupdatetimestamp='1580199345' WHERE PBXPid=1 [2020-01-28 16:15:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580199335 [2020-01-28 16:15:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580199345,`PBXCuid`=1580199345 [2020-01-28 16:15:55] UPDATE sales SET lastlogindate='2020-01-28 16:15:55' WHERE Sid='88' LIMIT 1 [2020-01-28 16:15:55] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 16:15:55] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 16:15:55] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 16:15:56] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 16:15:56] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 16:15:56] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 16:16:12] UPDATE sales SET lastlogindate='2020-01-28 16:16:12' WHERE Sid='88' LIMIT 1 [2020-01-28 16:16:12] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 16:16:12] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 16:16:12] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 16:16:13] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 16:19:17] UPDATE pbxsetting SET lastupdatetimestamp='1580199557' WHERE PBXPid=1 [2020-01-28 16:19:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580199547 [2020-01-28 16:19:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580199557,`PBXCuid`=1580199557 [2020-01-28 16:20:45] UPDATE pbxsetting SET lastupdatetimestamp='1580199645' WHERE PBXPid=1 [2020-01-28 16:20:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580199635 [2020-01-28 16:20:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580199645,`PBXCuid`=1580199645 [2020-01-28 16:24:17] UPDATE pbxsetting SET lastupdatetimestamp='1580199857' WHERE PBXPid=1 [2020-01-28 16:24:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580199847 [2020-01-28 16:24:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580199857,`PBXCuid`=1580199857 [2020-01-28 16:25:45] UPDATE pbxsetting SET lastupdatetimestamp='1580199945' WHERE PBXPid=1 [2020-01-28 16:25:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580199935 [2020-01-28 16:25:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580199945,`PBXCuid`=1580199945 [2020-01-28 16:29:17] UPDATE pbxsetting SET lastupdatetimestamp='1580200157' WHERE PBXPid=1 [2020-01-28 16:29:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580200147 [2020-01-28 16:29:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580200157,`PBXCuid`=1580200157 [2020-01-28 16:30:45] UPDATE pbxsetting SET lastupdatetimestamp='1580200245' WHERE PBXPid=1 [2020-01-28 16:30:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580200235 [2020-01-28 16:30:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580200245,`PBXCuid`=1580200245 [2020-01-28 16:34:17] UPDATE pbxsetting SET lastupdatetimestamp='1580200457' WHERE PBXPid=1 [2020-01-28 16:34:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580200447 [2020-01-28 16:34:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580200457,`PBXCuid`=1580200457 [2020-01-28 16:35:08] UPDATE sales SET login_ip='14.0.155.71', login_time='15802005088658' WHERE Sid='1' LIMIT 1 [2020-01-28 16:35:08] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`type`) VALUES ('2020-01-28 16:35:08',1,'14.0.155.71',1,2) [2020-01-28 16:35:08] UPDATE sales SET lastlogindate='2020-01-28 16:35:08' WHERE Sid='1' LIMIT 1 [2020-01-28 16:35:08] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 16:35:08] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 16:35:08] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 16:35:09] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 16:35:09] UPDATE sales SET lastlogindate='2020-01-28 16:35:09' WHERE Sid='1' LIMIT 1 [2020-01-28 16:35:09] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 16:35:10] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 16:35:10] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 16:35:10] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 16:35:13] UPDATE sales SET lastlogindate='2020-01-28 16:35:13' WHERE Sid='1' LIMIT 1 [2020-01-28 16:35:13] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 16:35:13] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 16:35:13] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 16:35:14] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 16:35:14] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 16:35:14] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 16:35:34] UPDATE sales SET lastlogindate='2020-01-28 16:35:34' WHERE Sid='1' LIMIT 1 [2020-01-28 16:35:34] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 16:35:34] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 16:35:35] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 16:35:35] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 16:35:35] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 16:35:35] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 16:35:45] UPDATE pbxsetting SET lastupdatetimestamp='1580200545' WHERE PBXPid=1 [2020-01-28 16:35:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580200535 [2020-01-28 16:35:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580200545,`PBXCuid`=1580200545 [2020-01-28 16:39:17] UPDATE pbxsetting SET lastupdatetimestamp='1580200757' WHERE PBXPid=1 [2020-01-28 16:39:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580200747 [2020-01-28 16:39:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580200757,`PBXCuid`=1580200757 [2020-01-28 16:40:45] UPDATE pbxsetting SET lastupdatetimestamp='1580200845' WHERE PBXPid=1 [2020-01-28 16:40:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580200835 [2020-01-28 16:40:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580200845,`PBXCuid`=1580200845 [2020-01-28 16:44:17] UPDATE pbxsetting SET lastupdatetimestamp='1580201057' WHERE PBXPid=1 [2020-01-28 16:44:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580201047 [2020-01-28 16:44:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580201057,`PBXCuid`=1580201057 [2020-01-28 16:45:45] UPDATE pbxsetting SET lastupdatetimestamp='1580201145' WHERE PBXPid=1 [2020-01-28 16:45:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580201135 [2020-01-28 16:45:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580201145,`PBXCuid`=1580201145 [2020-01-28 16:49:17] UPDATE pbxsetting SET lastupdatetimestamp='1580201357' WHERE PBXPid=1 [2020-01-28 16:49:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580201347 [2020-01-28 16:49:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580201357,`PBXCuid`=1580201357 [2020-01-28 16:50:45] UPDATE pbxsetting SET lastupdatetimestamp='1580201445' WHERE PBXPid=1 [2020-01-28 16:50:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580201435 [2020-01-28 16:50:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580201445,`PBXCuid`=1580201445 [2020-01-28 16:54:17] UPDATE pbxsetting SET lastupdatetimestamp='1580201657' WHERE PBXPid=1 [2020-01-28 16:54:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580201647 [2020-01-28 16:54:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580201657,`PBXCuid`=1580201657 [2020-01-28 16:55:45] UPDATE pbxsetting SET lastupdatetimestamp='1580201745' WHERE PBXPid=1 [2020-01-28 16:55:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580201735 [2020-01-28 16:55:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580201745,`PBXCuid`=1580201745 [2020-01-28 16:59:17] UPDATE pbxsetting SET lastupdatetimestamp='1580201957' WHERE PBXPid=1 [2020-01-28 16:59:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580201947 [2020-01-28 16:59:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580201957,`PBXCuid`=1580201957 [2020-01-28 17:00:45] UPDATE pbxsetting SET lastupdatetimestamp='1580202045' WHERE PBXPid=1 [2020-01-28 17:00:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580202035 [2020-01-28 17:00:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580202045,`PBXCuid`=1580202045 [2020-01-28 17:04:17] UPDATE pbxsetting SET lastupdatetimestamp='1580202257' WHERE PBXPid=1 [2020-01-28 17:04:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580202247 [2020-01-28 17:04:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580202257,`PBXCuid`=1580202257 [2020-01-28 17:05:45] UPDATE pbxsetting SET lastupdatetimestamp='1580202345' WHERE PBXPid=1 [2020-01-28 17:05:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580202335 [2020-01-28 17:05:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580202345,`PBXCuid`=1580202345 [2020-01-28 17:09:17] UPDATE pbxsetting SET lastupdatetimestamp='1580202557' WHERE PBXPid=1 [2020-01-28 17:09:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580202547 [2020-01-28 17:09:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580202557,`PBXCuid`=1580202557 [2020-01-28 17:10:45] UPDATE pbxsetting SET lastupdatetimestamp='1580202645' WHERE PBXPid=1 [2020-01-28 17:10:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580202635 [2020-01-28 17:10:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580202645,`PBXCuid`=1580202645 [2020-01-28 17:14:17] UPDATE pbxsetting SET lastupdatetimestamp='1580202857' WHERE PBXPid=1 [2020-01-28 17:14:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580202847 [2020-01-28 17:14:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580202857,`PBXCuid`=1580202857 [2020-01-28 17:15:45] UPDATE pbxsetting SET lastupdatetimestamp='1580202945' WHERE PBXPid=1 [2020-01-28 17:15:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580202935 [2020-01-28 17:15:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580202945,`PBXCuid`=1580202945 [2020-01-28 17:19:17] UPDATE pbxsetting SET lastupdatetimestamp='1580203157' WHERE PBXPid=1 [2020-01-28 17:19:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580203147 [2020-01-28 17:19:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580203157,`PBXCuid`=1580203157 [2020-01-28 17:20:30] UPDATE sales SET login_ip='182.239.87.51', login_time='15802032308899' WHERE Sid='98' LIMIT 1 [2020-01-28 17:20:30] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`type`) VALUES ('2020-01-28 17:20:30',98,'182.239.87.51',1,2) [2020-01-28 17:20:31] UPDATE sales SET lastlogindate='2020-01-28 17:20:31' WHERE Sid='98' LIMIT 1 [2020-01-28 17:20:31] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 17:20:31] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 17:20:31] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 17:20:32] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 17:20:32] UPDATE sales SET lastlogindate='2020-01-28 17:20:32' WHERE Sid='98' LIMIT 1 [2020-01-28 17:20:32] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 17:20:32] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 17:20:32] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 17:20:33] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 17:20:45] UPDATE pbxsetting SET lastupdatetimestamp='1580203245' WHERE PBXPid=1 [2020-01-28 17:20:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580203235 [2020-01-28 17:20:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580203245,`PBXCuid`=1580203245 [2020-01-28 17:21:20] UPDATE sales SET lastlogindate='2020-01-28 17:21:20' WHERE Sid='98' LIMIT 1 [2020-01-28 17:21:20] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 17:21:21] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 17:21:21] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 17:21:21] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 17:21:21] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 17:21:22] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 17:21:55] UPDATE sales SET lastlogindate='2020-01-28 17:21:55' WHERE Sid='98' LIMIT 1 [2020-01-28 17:21:55] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 17:21:55] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 17:21:55] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 17:21:56] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 17:21:56] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 17:21:56] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 17:22:17] UPDATE pbxsetting SET lastupdatetimestamp='1580203337' WHERE PBXPid=1 [2020-01-28 17:22:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580203327 [2020-01-28 17:22:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580203337,`PBXCuid`=1580203337 [2020-01-28 17:22:17] INSERT INTO adminlog ( `logintime`, `id`, `ip`, `status`, `field`, `remark`, `r`, `type` ) VALUES ( NOW(), '98', '182.239.87.51', '11', 'project', '樓盤︰油塘/住宅 - Ocean One 座: , 單位: D, 層: 32, 地段編號: *', '10915', '2' ) [2020-01-28 17:22:23] DELETE FROM `pbxtransferwaiting` WHERE `phone1`='67360110' [2020-01-28 17:22:23] DELETE FROM `pbxtransferwaiting` WHERE `phone1`='67360110' [2020-01-28 17:22:30] UPDATE pbxsetting SET lastupdatetimestamp='1580203350' WHERE PBXPid=1 [2020-01-28 17:22:30] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580203340 [2020-01-28 17:22:30] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580203350,`PBXCuid`=1580203337 [2020-01-28 17:22:30] INSERT INTO adminlog ( `logintime`, `id`, `ip`, `status`, `field`, `remark`, `r`, `type` ) VALUES ( NOW(), '98', '182.239.87.51', '11', 'project', '樓盤︰油塘/住宅 - Ocean One 座: , 單位: D, 層: 32, 地段編號: *', '10915', '2' ) [2020-01-28 17:22:46] UPDATE sales SET lastlogindate='2020-01-28 17:22:46' WHERE Sid='98' LIMIT 1 [2020-01-28 17:22:46] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 17:22:46] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 17:22:46] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 17:22:47] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 17:22:48] UPDATE sales SET lastlogindate='2020-01-28 17:22:48' WHERE Sid='98' LIMIT 1 [2020-01-28 17:22:48] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 17:22:48] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 17:22:48] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 17:22:48] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 17:23:09] UPDATE sales SET lastlogindate='2020-01-28 17:23:09' WHERE Sid='98' LIMIT 1 [2020-01-28 17:23:09] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 17:23:09] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 17:23:09] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 17:23:10] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 17:23:11] UPDATE sales SET lastlogindate='2020-01-28 17:23:11' WHERE Sid='98' LIMIT 1 [2020-01-28 17:23:11] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 17:23:11] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 17:23:11] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 17:23:11] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 17:23:32] UPDATE sales SET lastlogindate='2020-01-28 17:23:32' WHERE Sid='98' LIMIT 1 [2020-01-28 17:23:32] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 17:23:32] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 17:23:33] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 17:23:33] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 17:23:33] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 17:23:34] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 17:23:46] UPDATE sales SET lastlogindate='2020-01-28 17:23:46' WHERE Sid='98' LIMIT 1 [2020-01-28 17:23:46] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 17:23:47] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 17:23:47] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 17:23:47] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 17:23:48] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 17:23:48] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 17:24:17] UPDATE pbxsetting SET lastupdatetimestamp='1580203457' WHERE PBXPid=1 [2020-01-28 17:24:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580203447 [2020-01-28 17:24:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580203457,`PBXCuid`=1580203457 [2020-01-28 17:25:45] UPDATE pbxsetting SET lastupdatetimestamp='1580203545' WHERE PBXPid=1 [2020-01-28 17:25:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580203535 [2020-01-28 17:25:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580203545,`PBXCuid`=1580203545 [2020-01-28 17:29:17] UPDATE pbxsetting SET lastupdatetimestamp='1580203757' WHERE PBXPid=1 [2020-01-28 17:29:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580203747 [2020-01-28 17:29:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580203757,`PBXCuid`=1580203757 [2020-01-28 17:30:45] UPDATE pbxsetting SET lastupdatetimestamp='1580203845' WHERE PBXPid=1 [2020-01-28 17:30:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580203835 [2020-01-28 17:30:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580203845,`PBXCuid`=1580203845 [2020-01-28 17:34:17] UPDATE pbxsetting SET lastupdatetimestamp='1580204057' WHERE PBXPid=1 [2020-01-28 17:34:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580204047 [2020-01-28 17:34:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580204057,`PBXCuid`=1580204057 [2020-01-28 17:35:45] UPDATE pbxsetting SET lastupdatetimestamp='1580204145' WHERE PBXPid=1 [2020-01-28 17:35:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580204135 [2020-01-28 17:35:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580204145,`PBXCuid`=1580204145 [2020-01-28 17:39:17] UPDATE pbxsetting SET lastupdatetimestamp='1580204357' WHERE PBXPid=1 [2020-01-28 17:39:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580204347 [2020-01-28 17:39:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580204357,`PBXCuid`=1580204357 [2020-01-28 17:40:45] UPDATE pbxsetting SET lastupdatetimestamp='1580204445' WHERE PBXPid=1 [2020-01-28 17:40:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580204435 [2020-01-28 17:40:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580204445,`PBXCuid`=1580204445 [2020-01-28 17:44:17] UPDATE pbxsetting SET lastupdatetimestamp='1580204657' WHERE PBXPid=1 [2020-01-28 17:44:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580204647 [2020-01-28 17:44:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580204657,`PBXCuid`=1580204657 [2020-01-28 17:45:45] UPDATE pbxsetting SET lastupdatetimestamp='1580204745' WHERE PBXPid=1 [2020-01-28 17:45:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580204735 [2020-01-28 17:45:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580204745,`PBXCuid`=1580204745 [2020-01-28 17:50:45] UPDATE pbxsetting SET lastupdatetimestamp='1580205045' WHERE PBXPid=1 [2020-01-28 17:50:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580205035 [2020-01-28 17:50:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580205045,`PBXCuid`=1580205045 [2020-01-28 17:55:45] UPDATE pbxsetting SET lastupdatetimestamp='1580205345' WHERE PBXPid=1 [2020-01-28 17:55:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580205335 [2020-01-28 17:55:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580205345,`PBXCuid`=1580205345 [2020-01-28 18:00:45] UPDATE pbxsetting SET lastupdatetimestamp='1580205645' WHERE PBXPid=1 [2020-01-28 18:00:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580205635 [2020-01-28 18:00:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580205645,`PBXCuid`=1580205645 [2020-01-28 18:05:45] UPDATE pbxsetting SET lastupdatetimestamp='1580205945' WHERE PBXPid=1 [2020-01-28 18:05:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580205935 [2020-01-28 18:05:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580205945,`PBXCuid`=1580205945 [2020-01-28 18:10:45] UPDATE pbxsetting SET lastupdatetimestamp='1580206245' WHERE PBXPid=1 [2020-01-28 18:10:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580206235 [2020-01-28 18:10:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580206245,`PBXCuid`=1580206245 [2020-01-28 18:15:45] UPDATE pbxsetting SET lastupdatetimestamp='1580206545' WHERE PBXPid=1 [2020-01-28 18:15:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580206535 [2020-01-28 18:15:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580206545,`PBXCuid`=1580206545 [2020-01-28 18:20:45] UPDATE pbxsetting SET lastupdatetimestamp='1580206845' WHERE PBXPid=1 [2020-01-28 18:20:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580206835 [2020-01-28 18:20:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580206845,`PBXCuid`=1580206845 [2020-01-28 18:25:45] UPDATE pbxsetting SET lastupdatetimestamp='1580207145' WHERE PBXPid=1 [2020-01-28 18:25:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580207135 [2020-01-28 18:25:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580207145,`PBXCuid`=1580207145 [2020-01-28 18:30:45] UPDATE pbxsetting SET lastupdatetimestamp='1580207445' WHERE PBXPid=1 [2020-01-28 18:30:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580207435 [2020-01-28 18:30:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580207445,`PBXCuid`=1580207445 [2020-01-28 18:35:45] UPDATE pbxsetting SET lastupdatetimestamp='1580207745' WHERE PBXPid=1 [2020-01-28 18:35:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580207735 [2020-01-28 18:35:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580207745,`PBXCuid`=1580207745 [2020-01-28 18:39:16] UPDATE pbxsetting SET lastupdatetimestamp='1580207956' WHERE PBXPid=1 [2020-01-28 18:39:16] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580207946 [2020-01-28 18:39:16] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580207956,`PBXCuid`=1580207956 [2020-01-28 18:40:45] UPDATE pbxsetting SET lastupdatetimestamp='1580208045' WHERE PBXPid=1 [2020-01-28 18:40:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580208035 [2020-01-28 18:40:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580208045,`PBXCuid`=1580208045 [2020-01-28 18:44:17] UPDATE pbxsetting SET lastupdatetimestamp='1580208257' WHERE PBXPid=1 [2020-01-28 18:44:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580208247 [2020-01-28 18:44:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580208257,`PBXCuid`=1580208257 [2020-01-28 18:45:45] UPDATE pbxsetting SET lastupdatetimestamp='1580208345' WHERE PBXPid=1 [2020-01-28 18:45:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580208335 [2020-01-28 18:45:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580208345,`PBXCuid`=1580208345 [2020-01-28 18:49:17] UPDATE pbxsetting SET lastupdatetimestamp='1580208557' WHERE PBXPid=1 [2020-01-28 18:49:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580208547 [2020-01-28 18:49:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580208557,`PBXCuid`=1580208557 [2020-01-28 18:50:20] UPDATE sales SET login_ip='183.178.142.115', login_time='15802086209053' WHERE Sid='98' LIMIT 1 [2020-01-28 18:50:20] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`type`) VALUES ('2020-01-28 18:50:20',98,'183.178.142.115',1,2) [2020-01-28 18:50:20] UPDATE sales SET lastlogindate='2020-01-28 18:50:20' WHERE Sid='98' LIMIT 1 [2020-01-28 18:50:20] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 18:50:20] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 18:50:20] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 18:50:21] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 18:50:21] UPDATE sales SET lastlogindate='2020-01-28 18:50:21' WHERE Sid='98' LIMIT 1 [2020-01-28 18:50:21] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 18:50:21] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 18:50:21] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 18:50:22] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 18:50:25] UPDATE sales SET lastlogindate='2020-01-28 18:50:25' WHERE Sid='98' LIMIT 1 [2020-01-28 18:50:25] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 18:50:25] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 18:50:25] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 18:50:25] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 18:50:26] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 18:50:26] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 18:50:39] UPDATE sales SET lastlogindate='2020-01-28 18:50:39' WHERE Sid='98' LIMIT 1 [2020-01-28 18:50:39] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 18:50:39] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 18:50:39] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 18:50:40] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 18:50:40] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 18:50:40] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 18:50:45] UPDATE pbxsetting SET lastupdatetimestamp='1580208645' WHERE PBXPid=1 [2020-01-28 18:50:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580208635 [2020-01-28 18:50:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580208645,`PBXCuid`=1580208645 [2020-01-28 18:51:45] UPDATE sales SET lastlogindate='2020-01-28 18:51:45' WHERE Sid='98' LIMIT 1 [2020-01-28 18:51:45] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 18:51:45] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 18:51:45] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 18:51:46] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 18:51:46] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 18:51:46] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 18:52:06] INSERT INTO adminlog ( `logintime`, `id`, `ip`, `status`, `type` ) VALUES ( NOW(), '98', '183.178.142.115', '9', '2' ) [2020-01-28 18:52:06] UPDATE sales SET logined=2 WHERE Sid='98' LIMIT 1 [2020-01-28 18:52:17] UPDATE sales SET login_ip='183.178.142.115', login_time='15802087376001' WHERE Sid='98' LIMIT 1 [2020-01-28 18:52:17] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`type`) VALUES ('2020-01-28 18:52:17',98,'183.178.142.115',1,2) [2020-01-28 18:52:17] UPDATE sales SET lastlogindate='2020-01-28 18:52:17' WHERE Sid='98' LIMIT 1 [2020-01-28 18:52:17] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 18:52:17] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 18:52:17] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 18:52:18] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 18:52:19] UPDATE sales SET lastlogindate='2020-01-28 18:52:19' WHERE Sid='98' LIMIT 1 [2020-01-28 18:52:19] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 18:52:19] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 18:52:19] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 18:52:20] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 18:52:23] UPDATE sales SET lastlogindate='2020-01-28 18:52:23' WHERE Sid='98' LIMIT 1 [2020-01-28 18:52:23] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 18:52:23] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 18:52:23] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 18:52:24] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 18:52:24] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 18:52:24] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 18:52:49] UPDATE sales SET lastlogindate='2020-01-28 18:52:49' WHERE Sid='98' LIMIT 1 [2020-01-28 18:52:49] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 18:52:49] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 18:52:49] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 18:52:49] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 18:52:50] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 18:52:50] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 18:53:02] UPDATE pbxsetting SET lastupdatetimestamp='1580208782' WHERE PBXPid=1 [2020-01-28 18:53:02] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580208772 [2020-01-28 18:53:02] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580208782,`PBXCuid`=1580208782 [2020-01-28 18:53:02] INSERT INTO adminlog ( `logintime`, `id`, `ip`, `status`, `field`, `remark`, `r`, `type` ) VALUES ( NOW(), '98', '183.178.142.115', '11', 'project', '樓盤︰油塘/住宅 - Ocean One 座: , 單位: E, 層: 25, 地段編號: *', '8824', '2' ) [2020-01-28 18:53:09] DELETE FROM `pbxtransferwaiting` WHERE `phone1`='67360110' [2020-01-28 18:53:09] DELETE FROM `pbxtransferwaiting` WHERE `phone1`='67360110' [2020-01-28 18:53:43] UPDATE sales SET lastlogindate='2020-01-28 18:53:43' WHERE Sid='98' LIMIT 1 [2020-01-28 18:53:50] UPDATE sales SET login_ip='183.178.142.115', login_time='15802088308085' WHERE Sid='98' LIMIT 1 [2020-01-28 18:53:50] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`type`) VALUES ('2020-01-28 18:53:50',98,'183.178.142.115',1,2) [2020-01-28 18:53:50] UPDATE sales SET lastlogindate='2020-01-28 18:53:50' WHERE Sid='98' LIMIT 1 [2020-01-28 18:53:50] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 18:53:51] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 18:53:51] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 18:53:51] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 18:53:52] UPDATE sales SET lastlogindate='2020-01-28 18:53:52' WHERE Sid='98' LIMIT 1 [2020-01-28 18:53:52] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 18:53:52] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 18:53:52] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 18:53:53] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 18:53:55] UPDATE sales SET lastlogindate='2020-01-28 18:53:55' WHERE Sid='98' LIMIT 1 [2020-01-28 18:53:55] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 18:53:55] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 18:53:56] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 18:53:56] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 18:53:56] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 18:53:56] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 18:54:17] UPDATE pbxsetting SET lastupdatetimestamp='1580208857' WHERE PBXPid=1 [2020-01-28 18:54:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580208847 [2020-01-28 18:54:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580208857,`PBXCuid`=1580208857 [2020-01-28 18:54:18] UPDATE sales SET lastlogindate='2020-01-28 18:54:18' WHERE Sid='98' LIMIT 1 [2020-01-28 18:54:18] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 18:54:19] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 18:54:19] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 18:54:19] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 18:54:19] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 18:54:20] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 18:55:14] UPDATE sales SET lastlogindate='2020-01-28 18:55:14' WHERE Sid='98' LIMIT 1 [2020-01-28 18:55:14] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 18:55:14] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 18:55:14] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 18:55:15] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 18:55:15] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 18:55:15] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 18:55:25] UPDATE sales SET lastlogindate='2020-01-28 18:55:25' WHERE Sid='98' LIMIT 1 [2020-01-28 18:55:25] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 18:55:25] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 18:55:25] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 18:55:26] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 18:55:26] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 18:55:26] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 18:55:36] UPDATE sales SET lastlogindate='2020-01-28 18:55:36' WHERE Sid='98' LIMIT 1 [2020-01-28 18:55:36] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 18:55:36] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 18:55:36] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 18:55:37] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 18:55:37] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 18:55:37] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 18:55:38] UPDATE sales SET lastlogindate='2020-01-28 18:55:38' WHERE Sid='98' LIMIT 1 [2020-01-28 18:55:38] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 18:55:38] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 18:55:38] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 18:55:39] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 18:55:39] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 18:55:39] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 18:55:45] UPDATE pbxsetting SET lastupdatetimestamp='1580208945' WHERE PBXPid=1 [2020-01-28 18:55:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580208935 [2020-01-28 18:55:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580208945,`PBXCuid`=1580208945 [2020-01-28 18:56:20] UPDATE sales SET lastlogindate='2020-01-28 18:56:20' WHERE Sid='98' LIMIT 1 [2020-01-28 18:56:26] UPDATE sales SET login_ip='183.178.142.115', login_time='15802089866602' WHERE Sid='98' LIMIT 1 [2020-01-28 18:56:26] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`type`) VALUES ('2020-01-28 18:56:26',98,'183.178.142.115',1,2) [2020-01-28 18:56:27] UPDATE sales SET lastlogindate='2020-01-28 18:56:27' WHERE Sid='98' LIMIT 1 [2020-01-28 18:56:27] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 18:56:27] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 18:56:27] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 18:56:27] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 18:56:28] UPDATE sales SET lastlogindate='2020-01-28 18:56:28' WHERE Sid='98' LIMIT 1 [2020-01-28 18:56:28] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 18:56:28] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 18:56:28] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 18:56:29] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 18:56:31] UPDATE sales SET lastlogindate='2020-01-28 18:56:31' WHERE Sid='98' LIMIT 1 [2020-01-28 18:56:31] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 18:56:31] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 18:56:31] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 18:56:32] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 18:56:32] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 18:56:32] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 18:56:48] UPDATE sales SET lastlogindate='2020-01-28 18:56:48' WHERE Sid='98' LIMIT 1 [2020-01-28 18:56:48] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 18:56:48] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 18:56:49] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 18:56:49] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 18:56:49] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 18:56:49] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 18:56:59] UPDATE pbxsetting SET lastupdatetimestamp='1580209019' WHERE PBXPid=1 [2020-01-28 18:56:59] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580209009 [2020-01-28 18:56:59] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580209019,`PBXCuid`=1580208782 [2020-01-28 18:56:59] INSERT INTO adminlog ( `logintime`, `id`, `ip`, `status`, `field`, `remark`, `r`, `type` ) VALUES ( NOW(), '98', '183.178.142.115', '11', 'project', '樓盤︰油塘/住宅 - 鯉灣天下 座: , 單位: D, 層: 7, 地段編號: *', '10975', '2' ) [2020-01-28 18:57:05] DELETE FROM `pbxtransferwaiting` WHERE `phone1`='67360110' [2020-01-28 18:57:05] DELETE FROM `pbxtransferwaiting` WHERE `phone1`='67360110' [2020-01-28 18:58:39] UPDATE sales SET lastlogindate='2020-01-28 18:58:39' WHERE Sid='98' LIMIT 1 [2020-01-28 18:58:44] UPDATE sales SET login_ip='183.178.142.115', login_time='15802091243383' WHERE Sid='98' LIMIT 1 [2020-01-28 18:58:44] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`type`) VALUES ('2020-01-28 18:58:44',98,'183.178.142.115',1,2) [2020-01-28 18:58:44] UPDATE sales SET lastlogindate='2020-01-28 18:58:44' WHERE Sid='98' LIMIT 1 [2020-01-28 18:58:44] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 18:58:44] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 18:58:44] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 18:58:45] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 18:58:45] UPDATE sales SET lastlogindate='2020-01-28 18:58:45' WHERE Sid='98' LIMIT 1 [2020-01-28 18:58:45] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 18:58:45] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 18:58:46] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 18:58:46] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 18:58:51] UPDATE sales SET lastlogindate='2020-01-28 18:58:51' WHERE Sid='98' LIMIT 1 [2020-01-28 18:58:51] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 18:58:52] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 18:58:52] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 18:58:52] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 18:58:53] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 18:58:53] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 18:58:53] UPDATE sales SET lastlogindate='2020-01-28 18:58:53' WHERE Sid='98' LIMIT 1 [2020-01-28 18:58:53] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 18:58:53] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 18:58:53] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 18:58:54] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 18:58:54] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 18:58:54] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 18:59:17] UPDATE pbxsetting SET lastupdatetimestamp='1580209157' WHERE PBXPid=1 [2020-01-28 18:59:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580209147 [2020-01-28 18:59:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580209157,`PBXCuid`=1580209157 [2020-01-28 18:59:52] UPDATE sales SET lastlogindate='2020-01-28 18:59:52' WHERE Sid='98' LIMIT 1 [2020-01-28 18:59:52] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 18:59:52] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 18:59:52] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 18:59:52] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 18:59:53] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 18:59:53] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 19:00:45] UPDATE pbxsetting SET lastupdatetimestamp='1580209245' WHERE PBXPid=1 [2020-01-28 19:00:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580209235 [2020-01-28 19:00:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580209245,`PBXCuid`=1580209245 [2020-01-28 19:04:17] UPDATE pbxsetting SET lastupdatetimestamp='1580209457' WHERE PBXPid=1 [2020-01-28 19:04:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580209447 [2020-01-28 19:04:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580209457,`PBXCuid`=1580209457 [2020-01-28 19:05:45] UPDATE pbxsetting SET lastupdatetimestamp='1580209545' WHERE PBXPid=1 [2020-01-28 19:05:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580209535 [2020-01-28 19:05:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580209545,`PBXCuid`=1580209545 [2020-01-28 19:09:17] UPDATE pbxsetting SET lastupdatetimestamp='1580209757' WHERE PBXPid=1 [2020-01-28 19:09:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580209747 [2020-01-28 19:09:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580209757,`PBXCuid`=1580209757 [2020-01-28 19:10:45] UPDATE pbxsetting SET lastupdatetimestamp='1580209845' WHERE PBXPid=1 [2020-01-28 19:10:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580209835 [2020-01-28 19:10:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580209845,`PBXCuid`=1580209845 [2020-01-28 19:14:17] UPDATE pbxsetting SET lastupdatetimestamp='1580210057' WHERE PBXPid=1 [2020-01-28 19:14:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580210047 [2020-01-28 19:14:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580210057,`PBXCuid`=1580210057 [2020-01-28 19:15:45] UPDATE pbxsetting SET lastupdatetimestamp='1580210145' WHERE PBXPid=1 [2020-01-28 19:15:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580210135 [2020-01-28 19:15:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580210145,`PBXCuid`=1580210145 [2020-01-28 19:19:17] UPDATE pbxsetting SET lastupdatetimestamp='1580210357' WHERE PBXPid=1 [2020-01-28 19:19:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580210347 [2020-01-28 19:19:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580210357,`PBXCuid`=1580210357 [2020-01-28 19:20:45] UPDATE pbxsetting SET lastupdatetimestamp='1580210445' WHERE PBXPid=1 [2020-01-28 19:20:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580210435 [2020-01-28 19:20:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580210445,`PBXCuid`=1580210445 [2020-01-28 19:23:05] UPDATE sales SET lastlogindate='2020-01-28 19:23:05' WHERE Sid='98' LIMIT 1 [2020-01-28 19:24:17] UPDATE pbxsetting SET lastupdatetimestamp='1580210657' WHERE PBXPid=1 [2020-01-28 19:24:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580210647 [2020-01-28 19:24:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580210657,`PBXCuid`=1580210657 [2020-01-28 19:25:45] UPDATE pbxsetting SET lastupdatetimestamp='1580210745' WHERE PBXPid=1 [2020-01-28 19:25:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580210735 [2020-01-28 19:25:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580210745,`PBXCuid`=1580210745 [2020-01-28 19:29:17] UPDATE pbxsetting SET lastupdatetimestamp='1580210957' WHERE PBXPid=1 [2020-01-28 19:29:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580210947 [2020-01-28 19:29:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580210957,`PBXCuid`=1580210957 [2020-01-28 19:30:45] UPDATE pbxsetting SET lastupdatetimestamp='1580211045' WHERE PBXPid=1 [2020-01-28 19:30:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580211035 [2020-01-28 19:30:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580211045,`PBXCuid`=1580211045 [2020-01-28 19:34:17] UPDATE pbxsetting SET lastupdatetimestamp='1580211257' WHERE PBXPid=1 [2020-01-28 19:34:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580211247 [2020-01-28 19:34:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580211257,`PBXCuid`=1580211257 [2020-01-28 19:35:45] UPDATE pbxsetting SET lastupdatetimestamp='1580211345' WHERE PBXPid=1 [2020-01-28 19:35:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580211335 [2020-01-28 19:35:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580211345,`PBXCuid`=1580211345 [2020-01-28 19:39:17] UPDATE pbxsetting SET lastupdatetimestamp='1580211557' WHERE PBXPid=1 [2020-01-28 19:39:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580211547 [2020-01-28 19:39:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580211557,`PBXCuid`=1580211557 [2020-01-28 19:40:45] UPDATE pbxsetting SET lastupdatetimestamp='1580211645' WHERE PBXPid=1 [2020-01-28 19:40:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580211635 [2020-01-28 19:40:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580211645,`PBXCuid`=1580211645 [2020-01-28 19:44:17] UPDATE pbxsetting SET lastupdatetimestamp='1580211857' WHERE PBXPid=1 [2020-01-28 19:44:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580211847 [2020-01-28 19:44:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580211857,`PBXCuid`=1580211857 [2020-01-28 19:45:45] UPDATE pbxsetting SET lastupdatetimestamp='1580211945' WHERE PBXPid=1 [2020-01-28 19:45:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580211935 [2020-01-28 19:45:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580211945,`PBXCuid`=1580211945 [2020-01-28 19:49:17] UPDATE pbxsetting SET lastupdatetimestamp='1580212157' WHERE PBXPid=1 [2020-01-28 19:49:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580212147 [2020-01-28 19:49:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580212157,`PBXCuid`=1580212157 [2020-01-28 19:50:45] UPDATE pbxsetting SET lastupdatetimestamp='1580212245' WHERE PBXPid=1 [2020-01-28 19:50:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580212235 [2020-01-28 19:50:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580212245,`PBXCuid`=1580212245 [2020-01-28 19:54:17] UPDATE pbxsetting SET lastupdatetimestamp='1580212457' WHERE PBXPid=1 [2020-01-28 19:54:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580212447 [2020-01-28 19:54:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580212457,`PBXCuid`=1580212457 [2020-01-28 19:55:45] UPDATE pbxsetting SET lastupdatetimestamp='1580212545' WHERE PBXPid=1 [2020-01-28 19:55:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580212535 [2020-01-28 19:55:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580212545,`PBXCuid`=1580212545 [2020-01-28 19:59:17] UPDATE pbxsetting SET lastupdatetimestamp='1580212757' WHERE PBXPid=1 [2020-01-28 19:59:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580212747 [2020-01-28 19:59:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580212757,`PBXCuid`=1580212757 [2020-01-28 20:00:45] UPDATE pbxsetting SET lastupdatetimestamp='1580212845' WHERE PBXPid=1 [2020-01-28 20:00:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580212835 [2020-01-28 20:00:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580212845,`PBXCuid`=1580212845 [2020-01-28 20:04:17] UPDATE pbxsetting SET lastupdatetimestamp='1580213057' WHERE PBXPid=1 [2020-01-28 20:04:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580213047 [2020-01-28 20:04:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580213057,`PBXCuid`=1580213057 [2020-01-28 20:05:45] UPDATE pbxsetting SET lastupdatetimestamp='1580213145' WHERE PBXPid=1 [2020-01-28 20:05:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580213135 [2020-01-28 20:05:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580213145,`PBXCuid`=1580213145 [2020-01-28 20:09:17] UPDATE pbxsetting SET lastupdatetimestamp='1580213357' WHERE PBXPid=1 [2020-01-28 20:09:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580213347 [2020-01-28 20:09:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580213357,`PBXCuid`=1580213357 [2020-01-28 20:10:45] UPDATE pbxsetting SET lastupdatetimestamp='1580213445' WHERE PBXPid=1 [2020-01-28 20:10:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580213435 [2020-01-28 20:10:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580213445,`PBXCuid`=1580213445 [2020-01-28 20:14:17] UPDATE pbxsetting SET lastupdatetimestamp='1580213657' WHERE PBXPid=1 [2020-01-28 20:14:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580213647 [2020-01-28 20:14:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580213657,`PBXCuid`=1580213657 [2020-01-28 20:15:45] UPDATE pbxsetting SET lastupdatetimestamp='1580213745' WHERE PBXPid=1 [2020-01-28 20:15:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580213735 [2020-01-28 20:15:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580213745,`PBXCuid`=1580213745 [2020-01-28 20:17:16] INSERT INTO adminlog ( `logintime`, `id`, `ip`, `status`, `type` ) VALUES ( NOW(), '98', '183.178.142.115', '9', '2' ) [2020-01-28 20:17:16] UPDATE sales SET logined=2 WHERE Sid='98' LIMIT 1 [2020-01-28 20:17:20] UPDATE sales SET login_ip='183.178.142.115', login_time='15802138401025' WHERE Sid='98' LIMIT 1 [2020-01-28 20:17:20] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`type`) VALUES ('2020-01-28 20:17:20',98,'183.178.142.115',1,2) [2020-01-28 20:17:20] UPDATE sales SET lastlogindate='2020-01-28 20:17:20' WHERE Sid='98' LIMIT 1 [2020-01-28 20:17:20] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 20:17:21] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 20:17:21] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 20:17:21] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 20:17:22] UPDATE sales SET lastlogindate='2020-01-28 20:17:22' WHERE Sid='98' LIMIT 1 [2020-01-28 20:17:22] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 20:17:22] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 20:17:22] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 20:17:23] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 20:17:25] UPDATE sales SET lastlogindate='2020-01-28 20:17:25' WHERE Sid='98' LIMIT 1 [2020-01-28 20:17:25] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 20:17:25] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 20:17:25] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 20:17:26] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 20:17:26] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 20:17:26] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 20:17:45] UPDATE sales SET lastlogindate='2020-01-28 20:17:45' WHERE Sid='98' LIMIT 1 [2020-01-28 20:17:45] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 20:17:46] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 20:17:46] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 20:17:46] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 20:17:47] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 20:17:47] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 20:18:42] UPDATE sales SET login_ip='183.178.142.115', login_time='15802139227025' WHERE Sid='98' LIMIT 1 [2020-01-28 20:18:42] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`type`) VALUES ('2020-01-28 20:18:42',98,'183.178.142.115',1,2) [2020-01-28 20:18:43] UPDATE sales SET lastlogindate='2020-01-28 20:18:43' WHERE Sid='98' LIMIT 1 [2020-01-28 20:18:43] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 20:18:43] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 20:18:43] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 20:18:43] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 20:18:44] UPDATE sales SET lastlogindate='2020-01-28 20:18:44' WHERE Sid='98' LIMIT 1 [2020-01-28 20:18:44] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 20:18:44] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 20:18:44] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 20:18:45] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 20:18:48] UPDATE sales SET lastlogindate='2020-01-28 20:18:48' WHERE Sid='98' LIMIT 1 [2020-01-28 20:18:48] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 20:18:48] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 20:18:48] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 20:18:48] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 20:18:49] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 20:18:49] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 20:19:07] UPDATE sales SET lastlogindate='2020-01-28 20:19:07' WHERE Sid='98' LIMIT 1 [2020-01-28 20:19:07] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 20:19:07] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 20:19:07] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 20:19:08] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 20:19:08] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 20:19:08] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 20:19:17] UPDATE pbxsetting SET lastupdatetimestamp='1580213957' WHERE PBXPid=1 [2020-01-28 20:19:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580213947 [2020-01-28 20:19:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580213957,`PBXCuid`=1580213957 [2020-01-28 20:19:26] UPDATE pbxsetting SET lastupdatetimestamp='1580213966' WHERE PBXPid=1 [2020-01-28 20:19:26] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580213956 [2020-01-28 20:19:26] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580213966,`PBXCuid`=1580213966 [2020-01-28 20:19:26] INSERT INTO adminlog ( `logintime`, `id`, `ip`, `status`, `field`, `remark`, `r`, `type` ) VALUES ( NOW(), '98', '183.178.142.115', '11', 'project', '樓盤︰油塘/住宅 - 嘉賢居 座: , 單位: C, 層: 27, 地段編號: *', '3481', '2' ) [2020-01-28 20:19:32] DELETE FROM `pbxtransferwaiting` WHERE `phone1`='67360110' [2020-01-28 20:19:32] DELETE FROM `pbxtransferwaiting` WHERE `phone1`='67360110' [2020-01-28 20:20:45] UPDATE pbxsetting SET lastupdatetimestamp='1580214045' WHERE PBXPid=1 [2020-01-28 20:20:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580214035 [2020-01-28 20:20:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580214045,`PBXCuid`=1580214045 [2020-01-28 20:24:17] UPDATE pbxsetting SET lastupdatetimestamp='1580214257' WHERE PBXPid=1 [2020-01-28 20:24:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580214247 [2020-01-28 20:24:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580214257,`PBXCuid`=1580214257 [2020-01-28 20:25:39] UPDATE sales SET lastlogindate='2020-01-28 20:25:39' WHERE Sid='98' LIMIT 1 [2020-01-28 20:25:45] UPDATE pbxsetting SET lastupdatetimestamp='1580214345' WHERE PBXPid=1 [2020-01-28 20:25:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580214335 [2020-01-28 20:25:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580214345,`PBXCuid`=1580214345 [2020-01-28 20:25:48] UPDATE sales SET login_ip='183.178.142.115', login_time='15802143486827' WHERE Sid='98' LIMIT 1 [2020-01-28 20:25:48] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`type`) VALUES ('2020-01-28 20:25:48',98,'183.178.142.115',1,2) [2020-01-28 20:25:48] UPDATE sales SET lastlogindate='2020-01-28 20:25:48' WHERE Sid='98' LIMIT 1 [2020-01-28 20:25:48] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 20:25:48] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 20:25:48] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 20:25:48] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 20:25:49] UPDATE sales SET lastlogindate='2020-01-28 20:25:49' WHERE Sid='98' LIMIT 1 [2020-01-28 20:25:49] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 20:25:49] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 20:25:49] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 20:25:50] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 20:25:52] UPDATE sales SET lastlogindate='2020-01-28 20:25:52' WHERE Sid='98' LIMIT 1 [2020-01-28 20:25:52] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-28 20:25:53] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-28 20:25:53] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 20:25:53] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 20:25:53] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-28 20:25:54] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-28 20:26:37] UPDATE sales SET lastlogindate='2020-01-28 20:26:37' WHERE Sid='98' LIMIT 1 [2020-01-28 20:29:17] UPDATE pbxsetting SET lastupdatetimestamp='1580214557' WHERE PBXPid=1 [2020-01-28 20:29:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580214547 [2020-01-28 20:29:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580214557,`PBXCuid`=1580214557 [2020-01-28 20:30:45] UPDATE pbxsetting SET lastupdatetimestamp='1580214645' WHERE PBXPid=1 [2020-01-28 20:30:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580214635 [2020-01-28 20:30:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580214645,`PBXCuid`=1580214645 [2020-01-28 20:34:17] UPDATE pbxsetting SET lastupdatetimestamp='1580214857' WHERE PBXPid=1 [2020-01-28 20:34:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580214847 [2020-01-28 20:34:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580214857,`PBXCuid`=1580214857 [2020-01-28 20:35:45] UPDATE pbxsetting SET lastupdatetimestamp='1580214945' WHERE PBXPid=1 [2020-01-28 20:35:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580214935 [2020-01-28 20:35:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580214945,`PBXCuid`=1580214945 [2020-01-28 20:39:17] UPDATE pbxsetting SET lastupdatetimestamp='1580215157' WHERE PBXPid=1 [2020-01-28 20:39:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580215147 [2020-01-28 20:39:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580215157,`PBXCuid`=1580215157 [2020-01-28 20:40:45] UPDATE pbxsetting SET lastupdatetimestamp='1580215245' WHERE PBXPid=1 [2020-01-28 20:40:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580215235 [2020-01-28 20:40:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580215245,`PBXCuid`=1580215245 [2020-01-28 20:44:17] UPDATE pbxsetting SET lastupdatetimestamp='1580215457' WHERE PBXPid=1 [2020-01-28 20:44:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580215447 [2020-01-28 20:44:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580215457,`PBXCuid`=1580215457 [2020-01-28 20:45:45] UPDATE pbxsetting SET lastupdatetimestamp='1580215545' WHERE PBXPid=1 [2020-01-28 20:45:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580215535 [2020-01-28 20:45:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580215545,`PBXCuid`=1580215545 [2020-01-28 20:49:17] UPDATE pbxsetting SET lastupdatetimestamp='1580215757' WHERE PBXPid=1 [2020-01-28 20:49:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580215747 [2020-01-28 20:49:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580215757,`PBXCuid`=1580215757 [2020-01-28 20:50:45] UPDATE pbxsetting SET lastupdatetimestamp='1580215845' WHERE PBXPid=1 [2020-01-28 20:50:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580215835 [2020-01-28 20:50:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580215845,`PBXCuid`=1580215845 [2020-01-28 20:54:17] UPDATE pbxsetting SET lastupdatetimestamp='1580216057' WHERE PBXPid=1 [2020-01-28 20:54:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580216047 [2020-01-28 20:54:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580216057,`PBXCuid`=1580216057 [2020-01-28 20:55:45] UPDATE pbxsetting SET lastupdatetimestamp='1580216145' WHERE PBXPid=1 [2020-01-28 20:55:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580216135 [2020-01-28 20:55:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580216145,`PBXCuid`=1580216145 [2020-01-28 20:59:17] UPDATE pbxsetting SET lastupdatetimestamp='1580216357' WHERE PBXPid=1 [2020-01-28 20:59:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580216347 [2020-01-28 20:59:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580216357,`PBXCuid`=1580216357 [2020-01-28 21:00:45] UPDATE pbxsetting SET lastupdatetimestamp='1580216445' WHERE PBXPid=1 [2020-01-28 21:00:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580216435 [2020-01-28 21:00:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580216445,`PBXCuid`=1580216445 [2020-01-28 21:04:17] UPDATE pbxsetting SET lastupdatetimestamp='1580216657' WHERE PBXPid=1 [2020-01-28 21:04:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580216647 [2020-01-28 21:04:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580216657,`PBXCuid`=1580216657 [2020-01-28 21:05:45] UPDATE pbxsetting SET lastupdatetimestamp='1580216745' WHERE PBXPid=1 [2020-01-28 21:05:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580216735 [2020-01-28 21:05:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580216745,`PBXCuid`=1580216745 [2020-01-28 21:09:17] UPDATE pbxsetting SET lastupdatetimestamp='1580216957' WHERE PBXPid=1 [2020-01-28 21:09:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580216947 [2020-01-28 21:09:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580216957,`PBXCuid`=1580216957 [2020-01-28 21:10:45] UPDATE pbxsetting SET lastupdatetimestamp='1580217045' WHERE PBXPid=1 [2020-01-28 21:10:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580217035 [2020-01-28 21:10:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580217045,`PBXCuid`=1580217045 [2020-01-28 21:14:17] UPDATE pbxsetting SET lastupdatetimestamp='1580217257' WHERE PBXPid=1 [2020-01-28 21:14:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580217247 [2020-01-28 21:14:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580217257,`PBXCuid`=1580217257 [2020-01-28 21:15:45] UPDATE pbxsetting SET lastupdatetimestamp='1580217345' WHERE PBXPid=1 [2020-01-28 21:15:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580217335 [2020-01-28 21:15:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580217345,`PBXCuid`=1580217345 [2020-01-28 21:19:17] UPDATE pbxsetting SET lastupdatetimestamp='1580217557' WHERE PBXPid=1 [2020-01-28 21:19:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580217547 [2020-01-28 21:19:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580217557,`PBXCuid`=1580217557 [2020-01-28 21:20:45] UPDATE pbxsetting SET lastupdatetimestamp='1580217645' WHERE PBXPid=1 [2020-01-28 21:20:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580217635 [2020-01-28 21:20:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580217645,`PBXCuid`=1580217645 [2020-01-28 21:24:17] UPDATE pbxsetting SET lastupdatetimestamp='1580217857' WHERE PBXPid=1 [2020-01-28 21:24:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580217847 [2020-01-28 21:24:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580217857,`PBXCuid`=1580217857 [2020-01-28 21:25:45] UPDATE pbxsetting SET lastupdatetimestamp='1580217945' WHERE PBXPid=1 [2020-01-28 21:25:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580217935 [2020-01-28 21:25:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580217945,`PBXCuid`=1580217945 [2020-01-28 21:29:17] UPDATE pbxsetting SET lastupdatetimestamp='1580218157' WHERE PBXPid=1 [2020-01-28 21:29:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580218147 [2020-01-28 21:29:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580218157,`PBXCuid`=1580218157 [2020-01-28 21:30:45] UPDATE pbxsetting SET lastupdatetimestamp='1580218245' WHERE PBXPid=1 [2020-01-28 21:30:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580218235 [2020-01-28 21:30:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580218245,`PBXCuid`=1580218245 [2020-01-28 21:34:17] UPDATE pbxsetting SET lastupdatetimestamp='1580218457' WHERE PBXPid=1 [2020-01-28 21:34:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580218447 [2020-01-28 21:34:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580218457,`PBXCuid`=1580218457 [2020-01-28 21:35:45] UPDATE pbxsetting SET lastupdatetimestamp='1580218545' WHERE PBXPid=1 [2020-01-28 21:35:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580218535 [2020-01-28 21:35:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580218545,`PBXCuid`=1580218545 [2020-01-28 21:39:17] UPDATE pbxsetting SET lastupdatetimestamp='1580218757' WHERE PBXPid=1 [2020-01-28 21:39:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580218747 [2020-01-28 21:39:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580218757,`PBXCuid`=1580218757 [2020-01-28 21:40:45] UPDATE pbxsetting SET lastupdatetimestamp='1580218845' WHERE PBXPid=1 [2020-01-28 21:40:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580218835 [2020-01-28 21:40:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580218845,`PBXCuid`=1580218845 [2020-01-28 21:44:17] UPDATE pbxsetting SET lastupdatetimestamp='1580219057' WHERE PBXPid=1 [2020-01-28 21:44:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580219047 [2020-01-28 21:44:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580219057,`PBXCuid`=1580219057 [2020-01-28 21:45:45] UPDATE pbxsetting SET lastupdatetimestamp='1580219145' WHERE PBXPid=1 [2020-01-28 21:45:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580219135 [2020-01-28 21:45:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580219145,`PBXCuid`=1580219145 [2020-01-28 21:49:17] UPDATE pbxsetting SET lastupdatetimestamp='1580219357' WHERE PBXPid=1 [2020-01-28 21:49:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580219347 [2020-01-28 21:49:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580219357,`PBXCuid`=1580219357 [2020-01-28 21:50:45] UPDATE pbxsetting SET lastupdatetimestamp='1580219445' WHERE PBXPid=1 [2020-01-28 21:50:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580219435 [2020-01-28 21:50:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580219445,`PBXCuid`=1580219445 [2020-01-28 21:54:17] UPDATE pbxsetting SET lastupdatetimestamp='1580219657' WHERE PBXPid=1 [2020-01-28 21:54:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580219647 [2020-01-28 21:54:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580219657,`PBXCuid`=1580219657 [2020-01-28 21:55:45] UPDATE pbxsetting SET lastupdatetimestamp='1580219745' WHERE PBXPid=1 [2020-01-28 21:55:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580219735 [2020-01-28 21:55:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580219745,`PBXCuid`=1580219745 [2020-01-28 21:59:17] UPDATE pbxsetting SET lastupdatetimestamp='1580219957' WHERE PBXPid=1 [2020-01-28 21:59:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580219947 [2020-01-28 21:59:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580219957,`PBXCuid`=1580219957 [2020-01-28 22:00:45] UPDATE pbxsetting SET lastupdatetimestamp='1580220045' WHERE PBXPid=1 [2020-01-28 22:00:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580220035 [2020-01-28 22:00:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580220045,`PBXCuid`=1580220045 [2020-01-28 22:04:17] UPDATE pbxsetting SET lastupdatetimestamp='1580220257' WHERE PBXPid=1 [2020-01-28 22:04:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580220247 [2020-01-28 22:04:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580220257,`PBXCuid`=1580220257 [2020-01-28 22:05:45] UPDATE pbxsetting SET lastupdatetimestamp='1580220345' WHERE PBXPid=1 [2020-01-28 22:05:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580220335 [2020-01-28 22:05:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580220345,`PBXCuid`=1580220345 [2020-01-28 22:09:17] UPDATE pbxsetting SET lastupdatetimestamp='1580220557' WHERE PBXPid=1 [2020-01-28 22:09:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580220547 [2020-01-28 22:09:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580220557,`PBXCuid`=1580220557 [2020-01-28 22:10:45] UPDATE pbxsetting SET lastupdatetimestamp='1580220645' WHERE PBXPid=1 [2020-01-28 22:10:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580220635 [2020-01-28 22:10:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580220645,`PBXCuid`=1580220645 [2020-01-28 22:14:17] UPDATE pbxsetting SET lastupdatetimestamp='1580220857' WHERE PBXPid=1 [2020-01-28 22:14:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580220847 [2020-01-28 22:14:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580220857,`PBXCuid`=1580220857 [2020-01-28 22:15:45] UPDATE pbxsetting SET lastupdatetimestamp='1580220945' WHERE PBXPid=1 [2020-01-28 22:15:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580220935 [2020-01-28 22:15:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580220945,`PBXCuid`=1580220945 [2020-01-28 22:19:17] UPDATE pbxsetting SET lastupdatetimestamp='1580221157' WHERE PBXPid=1 [2020-01-28 22:19:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580221147 [2020-01-28 22:19:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580221157,`PBXCuid`=1580221157 [2020-01-28 22:20:45] UPDATE pbxsetting SET lastupdatetimestamp='1580221245' WHERE PBXPid=1 [2020-01-28 22:20:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580221235 [2020-01-28 22:20:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580221245,`PBXCuid`=1580221245 [2020-01-28 22:24:17] UPDATE pbxsetting SET lastupdatetimestamp='1580221457' WHERE PBXPid=1 [2020-01-28 22:24:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580221447 [2020-01-28 22:24:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580221457,`PBXCuid`=1580221457 [2020-01-28 22:25:45] UPDATE pbxsetting SET lastupdatetimestamp='1580221545' WHERE PBXPid=1 [2020-01-28 22:25:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580221535 [2020-01-28 22:25:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580221545,`PBXCuid`=1580221545 [2020-01-28 22:29:17] UPDATE pbxsetting SET lastupdatetimestamp='1580221757' WHERE PBXPid=1 [2020-01-28 22:29:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580221747 [2020-01-28 22:29:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580221757,`PBXCuid`=1580221757 [2020-01-28 22:30:45] UPDATE pbxsetting SET lastupdatetimestamp='1580221845' WHERE PBXPid=1 [2020-01-28 22:30:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580221835 [2020-01-28 22:30:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580221845,`PBXCuid`=1580221845 [2020-01-28 22:34:17] UPDATE pbxsetting SET lastupdatetimestamp='1580222057' WHERE PBXPid=1 [2020-01-28 22:34:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580222047 [2020-01-28 22:34:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580222057,`PBXCuid`=1580222057 [2020-01-28 22:35:45] UPDATE pbxsetting SET lastupdatetimestamp='1580222145' WHERE PBXPid=1 [2020-01-28 22:35:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580222135 [2020-01-28 22:35:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580222145,`PBXCuid`=1580222145 [2020-01-28 22:39:17] UPDATE pbxsetting SET lastupdatetimestamp='1580222357' WHERE PBXPid=1 [2020-01-28 22:39:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580222347 [2020-01-28 22:39:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580222357,`PBXCuid`=1580222357 [2020-01-28 22:40:45] UPDATE pbxsetting SET lastupdatetimestamp='1580222445' WHERE PBXPid=1 [2020-01-28 22:40:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580222435 [2020-01-28 22:40:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580222445,`PBXCuid`=1580222445 [2020-01-28 22:44:17] UPDATE pbxsetting SET lastupdatetimestamp='1580222657' WHERE PBXPid=1 [2020-01-28 22:44:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580222647 [2020-01-28 22:44:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580222657,`PBXCuid`=1580222657 [2020-01-28 22:45:45] UPDATE pbxsetting SET lastupdatetimestamp='1580222745' WHERE PBXPid=1 [2020-01-28 22:45:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580222735 [2020-01-28 22:45:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580222745,`PBXCuid`=1580222745 [2020-01-28 22:49:17] UPDATE pbxsetting SET lastupdatetimestamp='1580222957' WHERE PBXPid=1 [2020-01-28 22:49:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580222947 [2020-01-28 22:49:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580222957,`PBXCuid`=1580222957 [2020-01-28 22:50:45] UPDATE pbxsetting SET lastupdatetimestamp='1580223045' WHERE PBXPid=1 [2020-01-28 22:50:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580223035 [2020-01-28 22:50:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580223045,`PBXCuid`=1580223045 [2020-01-28 22:54:17] UPDATE pbxsetting SET lastupdatetimestamp='1580223257' WHERE PBXPid=1 [2020-01-28 22:54:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580223247 [2020-01-28 22:54:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580223257,`PBXCuid`=1580223257 [2020-01-28 22:55:45] UPDATE pbxsetting SET lastupdatetimestamp='1580223345' WHERE PBXPid=1 [2020-01-28 22:55:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580223335 [2020-01-28 22:55:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580223345,`PBXCuid`=1580223345 [2020-01-28 22:59:17] UPDATE pbxsetting SET lastupdatetimestamp='1580223557' WHERE PBXPid=1 [2020-01-28 22:59:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580223547 [2020-01-28 22:59:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580223557,`PBXCuid`=1580223557 [2020-01-28 23:00:45] UPDATE pbxsetting SET lastupdatetimestamp='1580223645' WHERE PBXPid=1 [2020-01-28 23:00:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580223635 [2020-01-28 23:00:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580223645,`PBXCuid`=1580223645 [2020-01-28 23:04:17] UPDATE pbxsetting SET lastupdatetimestamp='1580223857' WHERE PBXPid=1 [2020-01-28 23:04:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580223847 [2020-01-28 23:04:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580223857,`PBXCuid`=1580223857 [2020-01-28 23:05:45] UPDATE pbxsetting SET lastupdatetimestamp='1580223945' WHERE PBXPid=1 [2020-01-28 23:05:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580223935 [2020-01-28 23:05:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580223945,`PBXCuid`=1580223945 [2020-01-28 23:09:17] UPDATE pbxsetting SET lastupdatetimestamp='1580224157' WHERE PBXPid=1 [2020-01-28 23:09:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580224147 [2020-01-28 23:09:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580224157,`PBXCuid`=1580224157 [2020-01-28 23:10:45] UPDATE pbxsetting SET lastupdatetimestamp='1580224245' WHERE PBXPid=1 [2020-01-28 23:10:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580224235 [2020-01-28 23:10:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580224245,`PBXCuid`=1580224245 [2020-01-28 23:14:17] UPDATE pbxsetting SET lastupdatetimestamp='1580224457' WHERE PBXPid=1 [2020-01-28 23:14:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580224447 [2020-01-28 23:14:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580224457,`PBXCuid`=1580224457 [2020-01-28 23:15:45] UPDATE pbxsetting SET lastupdatetimestamp='1580224545' WHERE PBXPid=1 [2020-01-28 23:15:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580224535 [2020-01-28 23:15:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580224545,`PBXCuid`=1580224545 [2020-01-28 23:19:17] UPDATE pbxsetting SET lastupdatetimestamp='1580224757' WHERE PBXPid=1 [2020-01-28 23:19:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580224747 [2020-01-28 23:19:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580224757,`PBXCuid`=1580224757 [2020-01-28 23:20:45] UPDATE pbxsetting SET lastupdatetimestamp='1580224845' WHERE PBXPid=1 [2020-01-28 23:20:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580224835 [2020-01-28 23:20:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580224845,`PBXCuid`=1580224845 [2020-01-28 23:24:17] UPDATE pbxsetting SET lastupdatetimestamp='1580225057' WHERE PBXPid=1 [2020-01-28 23:24:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580225047 [2020-01-28 23:24:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580225057,`PBXCuid`=1580225057 [2020-01-28 23:25:45] UPDATE pbxsetting SET lastupdatetimestamp='1580225145' WHERE PBXPid=1 [2020-01-28 23:25:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580225135 [2020-01-28 23:25:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580225145,`PBXCuid`=1580225145 [2020-01-28 23:29:17] UPDATE pbxsetting SET lastupdatetimestamp='1580225357' WHERE PBXPid=1 [2020-01-28 23:29:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580225347 [2020-01-28 23:29:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580225357,`PBXCuid`=1580225357 [2020-01-28 23:30:45] UPDATE pbxsetting SET lastupdatetimestamp='1580225445' WHERE PBXPid=1 [2020-01-28 23:30:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580225435 [2020-01-28 23:30:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580225445,`PBXCuid`=1580225445 [2020-01-28 23:34:17] UPDATE pbxsetting SET lastupdatetimestamp='1580225657' WHERE PBXPid=1 [2020-01-28 23:34:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580225647 [2020-01-28 23:34:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580225657,`PBXCuid`=1580225657 [2020-01-28 23:35:45] UPDATE pbxsetting SET lastupdatetimestamp='1580225745' WHERE PBXPid=1 [2020-01-28 23:35:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580225735 [2020-01-28 23:35:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580225745,`PBXCuid`=1580225745 [2020-01-28 23:39:17] UPDATE pbxsetting SET lastupdatetimestamp='1580225957' WHERE PBXPid=1 [2020-01-28 23:39:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580225947 [2020-01-28 23:39:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580225957,`PBXCuid`=1580225957 [2020-01-28 23:40:45] UPDATE pbxsetting SET lastupdatetimestamp='1580226045' WHERE PBXPid=1 [2020-01-28 23:40:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580226035 [2020-01-28 23:40:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580226045,`PBXCuid`=1580226045 [2020-01-28 23:44:17] UPDATE pbxsetting SET lastupdatetimestamp='1580226257' WHERE PBXPid=1 [2020-01-28 23:44:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580226247 [2020-01-28 23:44:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580226257,`PBXCuid`=1580226257 [2020-01-28 23:45:45] UPDATE pbxsetting SET lastupdatetimestamp='1580226345' WHERE PBXPid=1 [2020-01-28 23:45:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580226335 [2020-01-28 23:45:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580226345,`PBXCuid`=1580226345 [2020-01-28 23:49:17] UPDATE pbxsetting SET lastupdatetimestamp='1580226557' WHERE PBXPid=1 [2020-01-28 23:49:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580226547 [2020-01-28 23:49:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580226557,`PBXCuid`=1580226557 [2020-01-28 23:50:45] UPDATE pbxsetting SET lastupdatetimestamp='1580226645' WHERE PBXPid=1 [2020-01-28 23:50:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580226635 [2020-01-28 23:50:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580226645,`PBXCuid`=1580226645 [2020-01-28 23:54:17] UPDATE pbxsetting SET lastupdatetimestamp='1580226857' WHERE PBXPid=1 [2020-01-28 23:54:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580226847 [2020-01-28 23:54:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580226857,`PBXCuid`=1580226857 [2020-01-28 23:55:45] UPDATE pbxsetting SET lastupdatetimestamp='1580226945' WHERE PBXPid=1 [2020-01-28 23:55:45] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580226935 [2020-01-28 23:55:45] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580226945,`PBXCuid`=1580226945 [2020-01-28 23:59:17] UPDATE pbxsetting SET lastupdatetimestamp='1580227157' WHERE PBXPid=1 [2020-01-28 23:59:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1580227147 [2020-01-28 23:59:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1580227157,`PBXCuid`=1580227157