[2020-01-24 00:04:17] UPDATE pbxsetting SET lastupdatetimestamp='1579795457' WHERE PBXPid=1 [2020-01-24 00:04:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579795447 [2020-01-24 00:04:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579795457,`PBXCuid`=1579795457 [2020-01-24 00:09:17] UPDATE pbxsetting SET lastupdatetimestamp='1579795757' WHERE PBXPid=1 [2020-01-24 00:09:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579795747 [2020-01-24 00:09:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579795757,`PBXCuid`=1579795757 [2020-01-24 00:14:17] UPDATE pbxsetting SET lastupdatetimestamp='1579796057' WHERE PBXPid=1 [2020-01-24 00:14:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579796047 [2020-01-24 00:14:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579796057,`PBXCuid`=1579796057 [2020-01-24 00:19:17] UPDATE pbxsetting SET lastupdatetimestamp='1579796357' WHERE PBXPid=1 [2020-01-24 00:19:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579796347 [2020-01-24 00:19:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579796357,`PBXCuid`=1579796357 [2020-01-24 00:24:17] UPDATE pbxsetting SET lastupdatetimestamp='1579796657' WHERE PBXPid=1 [2020-01-24 00:24:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579796647 [2020-01-24 00:24:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579796657,`PBXCuid`=1579796657 [2020-01-24 00:26:29] UPDATE sales SET login_ip='119.247.228.39', login_time='15797967898605' WHERE Sid='1' LIMIT 1 [2020-01-24 00:26:29] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`type`) VALUES ('2020-01-24 00:26:29',1,'119.247.228.39',1,2) [2020-01-24 00:26:30] UPDATE sales SET lastlogindate='2020-01-24 00:26:30' WHERE Sid='1' LIMIT 1 [2020-01-24 00:26:30] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 00:26:30] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 00:26:30] 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-24 00:26:30] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 00:26:31] UPDATE sales SET lastlogindate='2020-01-24 00:26:31' WHERE Sid='1' LIMIT 1 [2020-01-24 00:26:31] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 00:26:31] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 00:26: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-24 00:26:32] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 00:26:36] UPDATE sales SET lastlogindate='2020-01-24 00:26:36' WHERE Sid='1' LIMIT 1 [2020-01-24 00:26:36] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 00:26:36] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 00:26: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-24 00:26:37] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 00:26: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-24 00:26: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-24 00:27:09] UPDATE sales SET lastlogindate='2020-01-24 00:27:09' WHERE Sid='1' LIMIT 1 [2020-01-24 00:27:09] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 00:27:09] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 00:27: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-24 00:27:09] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 00:27:10] 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-24 00:27:10] 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-24 00:27:10] UPDATE sales SET lastlogindate='2020-01-24 00:27:10' WHERE Sid='1' LIMIT 1 [2020-01-24 00:27:10] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 00:27:10] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 00:27: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-24 00:27:11] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 00:27: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-24 00:27: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-24 00:27:29] UPDATE sales SET lastlogindate='2020-01-24 00:27:29' WHERE Sid='1' LIMIT 1 [2020-01-24 00:27:29] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 00:27:29] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 00:27: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-24 00:27:30] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 00:27: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-24 00:27: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-24 00:27:57] UPDATE sales SET lastlogindate='2020-01-24 00:27:57' WHERE Sid='1' LIMIT 1 [2020-01-24 00:27:57] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 00:27:57] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 00:27: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-24 00:27:58] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 00:27:58] 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-24 00:27:58] 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-24 00:27:58] UPDATE sales SET lastlogindate='2020-01-24 00:27:58' WHERE Sid='1' LIMIT 1 [2020-01-24 00:27:58] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 00:27:59] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 00:27:59] 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-24 00:27:59] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 00:27:59] 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-24 00:28:00] 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-24 00:29:17] UPDATE pbxsetting SET lastupdatetimestamp='1579796957' WHERE PBXPid=1 [2020-01-24 00:29:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579796947 [2020-01-24 00:29:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579796957,`PBXCuid`=1579796957 [2020-01-24 00:29:23] UPDATE sales SET lastlogindate='2020-01-24 00:29:23' WHERE Sid='1' LIMIT 1 [2020-01-24 00:29:23] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 00:29:23] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 00:29: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-24 00:29:24] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 00:29: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-24 00:29: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-24 00:29:24] UPDATE sales SET lastlogindate='2020-01-24 00:29:24' WHERE Sid='1' LIMIT 1 [2020-01-24 00:29:24] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 00:29:24] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 00:29:24] 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-24 00:29:25] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 00:29:25] 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-24 00:29:25] 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-24 00:29:31] UPDATE sales SET lastlogindate='2020-01-24 00:29:31' WHERE Sid='1' LIMIT 1 [2020-01-24 00:29:31] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 00:29:31] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 00:29: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-24 00:29:32] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 00:29: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-24 00:29: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-24 00:29:37] UPDATE sales SET lastlogindate='2020-01-24 00:29:37' WHERE Sid='1' LIMIT 1 [2020-01-24 00:29:37] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 00:29:38] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 00:29: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-24 00:29:38] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 00:29: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-24 00:29: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-24 00:29:39] UPDATE sales SET lastlogindate='2020-01-24 00:29:39' WHERE Sid='1' LIMIT 1 [2020-01-24 00:29:39] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 00:29:39] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 00:29: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-24 00:29:40] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 00:29: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-24 00:29: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-24 00:29:53] UPDATE sales SET lastlogindate='2020-01-24 00:29:53' WHERE Sid='1' LIMIT 1 [2020-01-24 00:29:53] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 00:29:54] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 00:29: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-24 00:29:54] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 00:29: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-24 00:29: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-24 00:29:55] UPDATE sales SET lastlogindate='2020-01-24 00:29:55' WHERE Sid='1' LIMIT 1 [2020-01-24 00:29:55] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 00:29:55] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 00:29: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-24 00:29:56] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 00:29: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-24 00:29: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-24 00:30:02] UPDATE sales SET lastlogindate='2020-01-24 00:30:02' WHERE Sid='1' LIMIT 1 [2020-01-24 00:30:02] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 00:30:03] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 00:30: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-24 00:30:03] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 00:30: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-24 00:30: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-24 00:30:04] UPDATE sales SET lastlogindate='2020-01-24 00:30:04' WHERE Sid='1' LIMIT 1 [2020-01-24 00:30:04] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 00:30:04] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 00:30: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-24 00:30:05] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 00:30: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-24 00:30: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-24 00:30:45] UPDATE sales SET lastlogindate='2020-01-24 00:30:45' WHERE Sid='1' LIMIT 1 [2020-01-24 00:30:45] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 00:30:45] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 00:30: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-24 00:30:46] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 00:34:17] UPDATE pbxsetting SET lastupdatetimestamp='1579797257' WHERE PBXPid=1 [2020-01-24 00:34:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579797247 [2020-01-24 00:34:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579797257,`PBXCuid`=1579797257 [2020-01-24 00:39:17] UPDATE pbxsetting SET lastupdatetimestamp='1579797557' WHERE PBXPid=1 [2020-01-24 00:39:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579797547 [2020-01-24 00:39:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579797557,`PBXCuid`=1579797557 [2020-01-24 00:44:17] UPDATE pbxsetting SET lastupdatetimestamp='1579797857' WHERE PBXPid=1 [2020-01-24 00:44:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579797847 [2020-01-24 00:44:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579797857,`PBXCuid`=1579797857 [2020-01-24 00:49:17] UPDATE pbxsetting SET lastupdatetimestamp='1579798157' WHERE PBXPid=1 [2020-01-24 00:49:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579798147 [2020-01-24 00:49:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579798157,`PBXCuid`=1579798157 [2020-01-24 00:54:17] UPDATE pbxsetting SET lastupdatetimestamp='1579798457' WHERE PBXPid=1 [2020-01-24 00:54:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579798447 [2020-01-24 00:54:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579798457,`PBXCuid`=1579798457 [2020-01-24 00:57:30] UPDATE sales SET login_ip='119.247.228.39', login_time='15797986505196' WHERE Sid='1' LIMIT 1 [2020-01-24 00:57:30] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`type`) VALUES ('2020-01-24 00:57:30',1,'119.247.228.39',1,2) [2020-01-24 00:57:30] UPDATE sales SET lastlogindate='2020-01-24 00:57:30' WHERE Sid='1' LIMIT 1 [2020-01-24 00:57:30] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 00:57:30] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 00:57:30] 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-24 00:57:31] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 00:57:31] UPDATE sales SET lastlogindate='2020-01-24 00:57:31' WHERE Sid='1' LIMIT 1 [2020-01-24 00:57:31] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 00:57:31] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 00:57: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-24 00:57:32] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 00:57:35] UPDATE sales SET lastlogindate='2020-01-24 00:57:35' WHERE Sid='1' LIMIT 1 [2020-01-24 00:57:35] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 00:57:35] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 00:57: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-24 00:57:36] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 00:57:36] 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-24 00:57:36] 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-24 00:58:49] UPDATE sales SET lastlogindate='2020-01-24 00:58:49' WHERE Sid='1' LIMIT 1 [2020-01-24 00:58:49] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 00:58:49] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 00:58: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-24 00:58:50] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 00:58: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-24 00:58: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-24 00:59:17] UPDATE pbxsetting SET lastupdatetimestamp='1579798757' WHERE PBXPid=1 [2020-01-24 00:59:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579798747 [2020-01-24 00:59:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579798757,`PBXCuid`=1579798757 [2020-01-24 01:00:05] UPDATE sales SET lastlogindate='2020-01-24 01:00:05' WHERE Sid='1' LIMIT 1 [2020-01-24 01:00:05] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 01:00:05] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 01:00:05] 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-24 01:00:06] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 01:00:06] 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-24 01:00:06] 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-24 01:04:17] UPDATE pbxsetting SET lastupdatetimestamp='1579799057' WHERE PBXPid=1 [2020-01-24 01:04:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579799047 [2020-01-24 01:04:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579799057,`PBXCuid`=1579799057 [2020-01-24 01:09:17] UPDATE pbxsetting SET lastupdatetimestamp='1579799357' WHERE PBXPid=1 [2020-01-24 01:09:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579799347 [2020-01-24 01:09:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579799357,`PBXCuid`=1579799357 [2020-01-24 01:14:17] UPDATE pbxsetting SET lastupdatetimestamp='1579799657' WHERE PBXPid=1 [2020-01-24 01:14:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579799647 [2020-01-24 01:14:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579799657,`PBXCuid`=1579799657 [2020-01-24 01:15:24] UPDATE sales SET login_ip='119.247.228.39', login_time='15797997243060' WHERE Sid='1' LIMIT 1 [2020-01-24 01:15:24] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`type`) VALUES ('2020-01-24 01:15:24',1,'119.247.228.39',1,2) [2020-01-24 01:15:24] UPDATE sales SET lastlogindate='2020-01-24 01:15:24' WHERE Sid='1' LIMIT 1 [2020-01-24 01:15:24] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 01:15:24] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 01:15:24] 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-24 01:15:25] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 01:15:25] UPDATE sales SET lastlogindate='2020-01-24 01:15:25' WHERE Sid='1' LIMIT 1 [2020-01-24 01:15:25] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 01:15:26] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 01:15:26] 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-24 01:15:26] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 01:15:29] UPDATE sales SET lastlogindate='2020-01-24 01:15:29' WHERE Sid='1' LIMIT 1 [2020-01-24 01:15:29] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 01:15:29] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 01:15: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-24 01:15:30] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 01:15: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-24 01:15: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-24 01:19:17] UPDATE pbxsetting SET lastupdatetimestamp='1579799957' WHERE PBXPid=1 [2020-01-24 01:19:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579799947 [2020-01-24 01:19:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579799957,`PBXCuid`=1579799957 [2020-01-24 01:24:17] UPDATE pbxsetting SET lastupdatetimestamp='1579800257' WHERE PBXPid=1 [2020-01-24 01:24:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579800247 [2020-01-24 01:24:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579800257,`PBXCuid`=1579800257 [2020-01-24 01:27:53] UPDATE sales SET login_ip='183.178.142.115', login_time='15798004734305' WHERE Sid='98' LIMIT 1 [2020-01-24 01:27:53] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`type`) VALUES ('2020-01-24 01:27:53',98,'183.178.142.115',1,2) [2020-01-24 01:27:53] UPDATE sales SET lastlogindate='2020-01-24 01:27:53' WHERE Sid='98' LIMIT 1 [2020-01-24 01:27:53] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 01:27:53] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 01:27: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-24 01:27:54] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 01:27:54] UPDATE sales SET lastlogindate='2020-01-24 01:27:54' WHERE Sid='98' LIMIT 1 [2020-01-24 01:27:54] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 01:27:54] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 01:27: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-24 01:27:55] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 01:28:52] UPDATE sales SET lastlogindate='2020-01-24 01:28:52' WHERE Sid='98' LIMIT 1 [2020-01-24 01:28:52] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 01:28:52] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 01:28: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-24 01:28:53] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 01:28: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-24 01:28: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-24 01:29:17] UPDATE pbxsetting SET lastupdatetimestamp='1579800557' WHERE PBXPid=1 [2020-01-24 01:29:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579800547 [2020-01-24 01:29:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579800557,`PBXCuid`=1579800557 [2020-01-24 01:29:45] UPDATE sales SET lastlogindate='2020-01-24 01:29:45' WHERE Sid='98' LIMIT 1 [2020-01-24 01:29:45] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 01:29:46] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 01:29: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-24 01:29:46] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 01:29: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-24 01:29: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-24 01:30:02] UPDATE sales SET lastlogindate='2020-01-24 01:30:02' WHERE Sid='98' LIMIT 1 [2020-01-24 01:30:02] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 01:30:02] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 01:30: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-24 01:30:03] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 01:30: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-24 01:30: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-24 01:30:48] UPDATE sales SET lastlogindate='2020-01-24 01:30:48' WHERE Sid='98' LIMIT 1 [2020-01-24 01:30:48] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 01:30:49] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 01:30: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-24 01:30:49] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 01:30: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-24 01:30: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-24 01:30:58] UPDATE sales SET lastlogindate='2020-01-24 01:30:58' WHERE Sid='98' LIMIT 1 [2020-01-24 01:30:58] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 01:30:59] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 01:30:59] 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-24 01:30:59] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 01:31:11] UPDATE sales SET lastlogindate='2020-01-24 01:31:11' WHERE Sid='98' LIMIT 1 [2020-01-24 01:31:11] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 01:31:11] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 01:31: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-24 01:31:12] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 01:31:12] 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-24 01:31:12] 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-24 01:32:19] UPDATE sales SET lastlogindate='2020-01-24 01:32:19' WHERE Sid='98' LIMIT 1 [2020-01-24 01:32:19] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 01:32:19] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 01:32: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-24 01:32:20] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 01:32:20] 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-24 01:32: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-24 01:32:45] UPDATE sales SET lastlogindate='2020-01-24 01:32:45' WHERE Sid='98' LIMIT 1 [2020-01-24 01:32:45] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 01:32:45] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 01:32: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-24 01:32:46] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 01:32:47] UPDATE sales SET lastlogindate='2020-01-24 01:32:47' WHERE Sid='98' LIMIT 1 [2020-01-24 01:32:47] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 01:32:47] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 01:32: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-24 01:32:47] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 01:32:48] UPDATE sales SET lastlogindate='2020-01-24 01:32:48' WHERE Sid='98' LIMIT 1 [2020-01-24 01:32:48] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 01:32:48] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 01:32: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-24 01:32:49] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 01:32:49] UPDATE sales SET lastlogindate='2020-01-24 01:32:49' WHERE Sid='98' LIMIT 1 [2020-01-24 01:32:49] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 01:32:50] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 01:32:50] 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-24 01:32:50] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 01:34:17] UPDATE pbxsetting SET lastupdatetimestamp='1579800857' WHERE PBXPid=1 [2020-01-24 01:34:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579800847 [2020-01-24 01:34:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579800857,`PBXCuid`=1579800857 [2020-01-24 01:39:17] UPDATE pbxsetting SET lastupdatetimestamp='1579801157' WHERE PBXPid=1 [2020-01-24 01:39:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579801147 [2020-01-24 01:39:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579801157,`PBXCuid`=1579801157 [2020-01-24 01:44:17] UPDATE pbxsetting SET lastupdatetimestamp='1579801457' WHERE PBXPid=1 [2020-01-24 01:44:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579801447 [2020-01-24 01:44:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579801457,`PBXCuid`=1579801457 [2020-01-24 01:49:17] UPDATE pbxsetting SET lastupdatetimestamp='1579801757' WHERE PBXPid=1 [2020-01-24 01:49:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579801747 [2020-01-24 01:49:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579801757,`PBXCuid`=1579801757 [2020-01-24 01:54:17] UPDATE pbxsetting SET lastupdatetimestamp='1579802057' WHERE PBXPid=1 [2020-01-24 01:54:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579802047 [2020-01-24 01:54:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579802057,`PBXCuid`=1579802057 [2020-01-24 01:59:17] UPDATE pbxsetting SET lastupdatetimestamp='1579802357' WHERE PBXPid=1 [2020-01-24 01:59:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579802347 [2020-01-24 01:59:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579802357,`PBXCuid`=1579802357 [2020-01-24 02:04:17] UPDATE pbxsetting SET lastupdatetimestamp='1579802657' WHERE PBXPid=1 [2020-01-24 02:04:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579802647 [2020-01-24 02:04:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579802657,`PBXCuid`=1579802657 [2020-01-24 02:09:17] UPDATE pbxsetting SET lastupdatetimestamp='1579802957' WHERE PBXPid=1 [2020-01-24 02:09:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579802947 [2020-01-24 02:09:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579802957,`PBXCuid`=1579802957 [2020-01-24 02:14:17] UPDATE pbxsetting SET lastupdatetimestamp='1579803257' WHERE PBXPid=1 [2020-01-24 02:14:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579803247 [2020-01-24 02:14:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579803257,`PBXCuid`=1579803257 [2020-01-24 02:19:17] UPDATE pbxsetting SET lastupdatetimestamp='1579803557' WHERE PBXPid=1 [2020-01-24 02:19:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579803547 [2020-01-24 02:19:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579803557,`PBXCuid`=1579803557 [2020-01-24 02:24:17] UPDATE pbxsetting SET lastupdatetimestamp='1579803857' WHERE PBXPid=1 [2020-01-24 02:24:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579803847 [2020-01-24 02:24:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579803857,`PBXCuid`=1579803857 [2020-01-24 02:29:17] UPDATE pbxsetting SET lastupdatetimestamp='1579804157' WHERE PBXPid=1 [2020-01-24 02:29:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579804147 [2020-01-24 02:29:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579804157,`PBXCuid`=1579804157 [2020-01-24 02:34:17] UPDATE pbxsetting SET lastupdatetimestamp='1579804457' WHERE PBXPid=1 [2020-01-24 02:34:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579804447 [2020-01-24 02:34:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579804457,`PBXCuid`=1579804457 [2020-01-24 02:39:17] UPDATE pbxsetting SET lastupdatetimestamp='1579804757' WHERE PBXPid=1 [2020-01-24 02:39:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579804747 [2020-01-24 02:39:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579804757,`PBXCuid`=1579804757 [2020-01-24 02:44:17] UPDATE pbxsetting SET lastupdatetimestamp='1579805057' WHERE PBXPid=1 [2020-01-24 02:44:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579805047 [2020-01-24 02:44:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579805057,`PBXCuid`=1579805057 [2020-01-24 02:49:17] UPDATE pbxsetting SET lastupdatetimestamp='1579805357' WHERE PBXPid=1 [2020-01-24 02:49:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579805347 [2020-01-24 02:49:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579805357,`PBXCuid`=1579805357 [2020-01-24 02:54:17] UPDATE pbxsetting SET lastupdatetimestamp='1579805657' WHERE PBXPid=1 [2020-01-24 02:54:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579805647 [2020-01-24 02:54:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579805657,`PBXCuid`=1579805657 [2020-01-24 02:59:17] UPDATE pbxsetting SET lastupdatetimestamp='1579805957' WHERE PBXPid=1 [2020-01-24 02:59:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579805947 [2020-01-24 02:59:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579805957,`PBXCuid`=1579805957 [2020-01-24 03:04:17] UPDATE pbxsetting SET lastupdatetimestamp='1579806257' WHERE PBXPid=1 [2020-01-24 03:04:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579806247 [2020-01-24 03:04:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579806257,`PBXCuid`=1579806257 [2020-01-24 03:09:17] UPDATE pbxsetting SET lastupdatetimestamp='1579806557' WHERE PBXPid=1 [2020-01-24 03:09:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579806547 [2020-01-24 03:09:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579806557,`PBXCuid`=1579806557 [2020-01-24 03:14:17] UPDATE pbxsetting SET lastupdatetimestamp='1579806857' WHERE PBXPid=1 [2020-01-24 03:14:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579806847 [2020-01-24 03:14:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579806857,`PBXCuid`=1579806857 [2020-01-24 03:19:17] UPDATE pbxsetting SET lastupdatetimestamp='1579807157' WHERE PBXPid=1 [2020-01-24 03:19:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579807147 [2020-01-24 03:19:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579807157,`PBXCuid`=1579807157 [2020-01-24 03:24:17] UPDATE pbxsetting SET lastupdatetimestamp='1579807457' WHERE PBXPid=1 [2020-01-24 03:24:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579807447 [2020-01-24 03:24:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579807457,`PBXCuid`=1579807457 [2020-01-24 03:29:17] UPDATE pbxsetting SET lastupdatetimestamp='1579807757' WHERE PBXPid=1 [2020-01-24 03:29:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579807747 [2020-01-24 03:29:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579807757,`PBXCuid`=1579807757 [2020-01-24 03:34:17] UPDATE pbxsetting SET lastupdatetimestamp='1579808057' WHERE PBXPid=1 [2020-01-24 03:34:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579808047 [2020-01-24 03:34:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579808057,`PBXCuid`=1579808057 [2020-01-24 03:39:17] UPDATE pbxsetting SET lastupdatetimestamp='1579808357' WHERE PBXPid=1 [2020-01-24 03:39:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579808347 [2020-01-24 03:39:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579808357,`PBXCuid`=1579808357 [2020-01-24 03:44:17] UPDATE pbxsetting SET lastupdatetimestamp='1579808657' WHERE PBXPid=1 [2020-01-24 03:44:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579808647 [2020-01-24 03:44:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579808657,`PBXCuid`=1579808657 [2020-01-24 03:49:17] UPDATE pbxsetting SET lastupdatetimestamp='1579808957' WHERE PBXPid=1 [2020-01-24 03:49:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579808947 [2020-01-24 03:49:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579808957,`PBXCuid`=1579808957 [2020-01-24 03:54:17] UPDATE pbxsetting SET lastupdatetimestamp='1579809257' WHERE PBXPid=1 [2020-01-24 03:54:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579809247 [2020-01-24 03:54:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579809257,`PBXCuid`=1579809257 [2020-01-24 03:59:17] UPDATE pbxsetting SET lastupdatetimestamp='1579809557' WHERE PBXPid=1 [2020-01-24 03:59:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579809547 [2020-01-24 03:59:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579809557,`PBXCuid`=1579809557 [2020-01-24 04:04:17] UPDATE pbxsetting SET lastupdatetimestamp='1579809857' WHERE PBXPid=1 [2020-01-24 04:04:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579809847 [2020-01-24 04:04:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579809857,`PBXCuid`=1579809857 [2020-01-24 04:09:17] UPDATE pbxsetting SET lastupdatetimestamp='1579810157' WHERE PBXPid=1 [2020-01-24 04:09:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579810147 [2020-01-24 04:09:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579810157,`PBXCuid`=1579810157 [2020-01-24 04:14:17] UPDATE pbxsetting SET lastupdatetimestamp='1579810457' WHERE PBXPid=1 [2020-01-24 04:14:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579810447 [2020-01-24 04:14:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579810457,`PBXCuid`=1579810457 [2020-01-24 04:19:17] UPDATE pbxsetting SET lastupdatetimestamp='1579810757' WHERE PBXPid=1 [2020-01-24 04:19:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579810747 [2020-01-24 04:19:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579810757,`PBXCuid`=1579810757 [2020-01-24 04:24:17] UPDATE pbxsetting SET lastupdatetimestamp='1579811057' WHERE PBXPid=1 [2020-01-24 04:24:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579811047 [2020-01-24 04:24:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579811057,`PBXCuid`=1579811057 [2020-01-24 04:29:17] UPDATE pbxsetting SET lastupdatetimestamp='1579811357' WHERE PBXPid=1 [2020-01-24 04:29:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579811347 [2020-01-24 04:29:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579811357,`PBXCuid`=1579811357 [2020-01-24 04:34:17] UPDATE pbxsetting SET lastupdatetimestamp='1579811657' WHERE PBXPid=1 [2020-01-24 04:34:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579811647 [2020-01-24 04:34:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579811657,`PBXCuid`=1579811657 [2020-01-24 04:39:17] UPDATE pbxsetting SET lastupdatetimestamp='1579811957' WHERE PBXPid=1 [2020-01-24 04:39:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579811947 [2020-01-24 04:39:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579811957,`PBXCuid`=1579811957 [2020-01-24 04:44:17] UPDATE pbxsetting SET lastupdatetimestamp='1579812257' WHERE PBXPid=1 [2020-01-24 04:44:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579812247 [2020-01-24 04:44:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579812257,`PBXCuid`=1579812257 [2020-01-24 04:49:17] UPDATE pbxsetting SET lastupdatetimestamp='1579812557' WHERE PBXPid=1 [2020-01-24 04:49:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579812547 [2020-01-24 04:49:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579812557,`PBXCuid`=1579812557 [2020-01-24 04:54:17] UPDATE pbxsetting SET lastupdatetimestamp='1579812857' WHERE PBXPid=1 [2020-01-24 04:54:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579812847 [2020-01-24 04:54:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579812857,`PBXCuid`=1579812857 [2020-01-24 04:59:17] UPDATE pbxsetting SET lastupdatetimestamp='1579813157' WHERE PBXPid=1 [2020-01-24 04:59:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579813147 [2020-01-24 04:59:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579813157,`PBXCuid`=1579813157 [2020-01-24 05:04:17] UPDATE pbxsetting SET lastupdatetimestamp='1579813457' WHERE PBXPid=1 [2020-01-24 05:04:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579813447 [2020-01-24 05:04:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579813457,`PBXCuid`=1579813457 [2020-01-24 05:09:17] UPDATE pbxsetting SET lastupdatetimestamp='1579813757' WHERE PBXPid=1 [2020-01-24 05:09:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579813747 [2020-01-24 05:09:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579813757,`PBXCuid`=1579813757 [2020-01-24 05:14:17] UPDATE pbxsetting SET lastupdatetimestamp='1579814057' WHERE PBXPid=1 [2020-01-24 05:14:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579814047 [2020-01-24 05:14:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579814057,`PBXCuid`=1579814057 [2020-01-24 05:19:17] UPDATE pbxsetting SET lastupdatetimestamp='1579814357' WHERE PBXPid=1 [2020-01-24 05:19:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579814347 [2020-01-24 05:19:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579814357,`PBXCuid`=1579814357 [2020-01-24 05:24:17] UPDATE pbxsetting SET lastupdatetimestamp='1579814657' WHERE PBXPid=1 [2020-01-24 05:24:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579814647 [2020-01-24 05:24:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579814657,`PBXCuid`=1579814657 [2020-01-24 05:29:17] UPDATE pbxsetting SET lastupdatetimestamp='1579814957' WHERE PBXPid=1 [2020-01-24 05:29:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579814947 [2020-01-24 05:29:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579814957,`PBXCuid`=1579814957 [2020-01-24 05:34:17] UPDATE pbxsetting SET lastupdatetimestamp='1579815257' WHERE PBXPid=1 [2020-01-24 05:34:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579815247 [2020-01-24 05:34:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579815257,`PBXCuid`=1579815257 [2020-01-24 05:39:17] UPDATE pbxsetting SET lastupdatetimestamp='1579815557' WHERE PBXPid=1 [2020-01-24 05:39:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579815547 [2020-01-24 05:39:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579815557,`PBXCuid`=1579815557 [2020-01-24 05:44:17] UPDATE pbxsetting SET lastupdatetimestamp='1579815857' WHERE PBXPid=1 [2020-01-24 05:44:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579815847 [2020-01-24 05:44:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579815857,`PBXCuid`=1579815857 [2020-01-24 05:49:17] UPDATE pbxsetting SET lastupdatetimestamp='1579816157' WHERE PBXPid=1 [2020-01-24 05:49:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579816147 [2020-01-24 05:49:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579816157,`PBXCuid`=1579816157 [2020-01-24 05:54:17] UPDATE pbxsetting SET lastupdatetimestamp='1579816457' WHERE PBXPid=1 [2020-01-24 05:54:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579816447 [2020-01-24 05:54:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579816457,`PBXCuid`=1579816457 [2020-01-24 05:59:17] UPDATE pbxsetting SET lastupdatetimestamp='1579816757' WHERE PBXPid=1 [2020-01-24 05:59:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579816747 [2020-01-24 05:59:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579816757,`PBXCuid`=1579816757 [2020-01-24 06:04:17] UPDATE pbxsetting SET lastupdatetimestamp='1579817057' WHERE PBXPid=1 [2020-01-24 06:04:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579817047 [2020-01-24 06:04:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579817057,`PBXCuid`=1579817057 [2020-01-24 06:09:17] UPDATE pbxsetting SET lastupdatetimestamp='1579817357' WHERE PBXPid=1 [2020-01-24 06:09:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579817347 [2020-01-24 06:09:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579817357,`PBXCuid`=1579817357 [2020-01-24 06:14:17] UPDATE pbxsetting SET lastupdatetimestamp='1579817657' WHERE PBXPid=1 [2020-01-24 06:14:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579817647 [2020-01-24 06:14:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579817657,`PBXCuid`=1579817657 [2020-01-24 06:19:17] UPDATE pbxsetting SET lastupdatetimestamp='1579817957' WHERE PBXPid=1 [2020-01-24 06:19:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579817947 [2020-01-24 06:19:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579817957,`PBXCuid`=1579817957 [2020-01-24 06:24:17] UPDATE pbxsetting SET lastupdatetimestamp='1579818257' WHERE PBXPid=1 [2020-01-24 06:24:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579818247 [2020-01-24 06:24:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579818257,`PBXCuid`=1579818257 [2020-01-24 06:29:17] UPDATE pbxsetting SET lastupdatetimestamp='1579818557' WHERE PBXPid=1 [2020-01-24 06:29:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579818547 [2020-01-24 06:29:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579818557,`PBXCuid`=1579818557 [2020-01-24 06:34:17] UPDATE pbxsetting SET lastupdatetimestamp='1579818857' WHERE PBXPid=1 [2020-01-24 06:34:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579818847 [2020-01-24 06:34:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579818857,`PBXCuid`=1579818857 [2020-01-24 06:39:17] UPDATE pbxsetting SET lastupdatetimestamp='1579819157' WHERE PBXPid=1 [2020-01-24 06:39:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579819147 [2020-01-24 06:39:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579819157,`PBXCuid`=1579819157 [2020-01-24 06:44:17] UPDATE pbxsetting SET lastupdatetimestamp='1579819457' WHERE PBXPid=1 [2020-01-24 06:44:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579819447 [2020-01-24 06:44:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579819457,`PBXCuid`=1579819457 [2020-01-24 06:49:17] UPDATE pbxsetting SET lastupdatetimestamp='1579819757' WHERE PBXPid=1 [2020-01-24 06:49:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579819747 [2020-01-24 06:49:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579819757,`PBXCuid`=1579819757 [2020-01-24 06:54:17] UPDATE pbxsetting SET lastupdatetimestamp='1579820057' WHERE PBXPid=1 [2020-01-24 06:54:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579820047 [2020-01-24 06:54:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579820057,`PBXCuid`=1579820057 [2020-01-24 06:59:17] UPDATE pbxsetting SET lastupdatetimestamp='1579820357' WHERE PBXPid=1 [2020-01-24 06:59:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579820347 [2020-01-24 06:59:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579820357,`PBXCuid`=1579820357 [2020-01-24 07:04:17] UPDATE pbxsetting SET lastupdatetimestamp='1579820657' WHERE PBXPid=1 [2020-01-24 07:04:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579820647 [2020-01-24 07:04:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579820657,`PBXCuid`=1579820657 [2020-01-24 07:09:17] UPDATE pbxsetting SET lastupdatetimestamp='1579820957' WHERE PBXPid=1 [2020-01-24 07:09:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579820947 [2020-01-24 07:09:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579820957,`PBXCuid`=1579820957 [2020-01-24 07:14:17] UPDATE pbxsetting SET lastupdatetimestamp='1579821257' WHERE PBXPid=1 [2020-01-24 07:14:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579821247 [2020-01-24 07:14:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579821257,`PBXCuid`=1579821257 [2020-01-24 07:19:17] UPDATE pbxsetting SET lastupdatetimestamp='1579821557' WHERE PBXPid=1 [2020-01-24 07:19:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579821547 [2020-01-24 07:19:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579821557,`PBXCuid`=1579821557 [2020-01-24 07:24:17] UPDATE pbxsetting SET lastupdatetimestamp='1579821857' WHERE PBXPid=1 [2020-01-24 07:24:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579821847 [2020-01-24 07:24:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579821857,`PBXCuid`=1579821857 [2020-01-24 07:29:17] UPDATE pbxsetting SET lastupdatetimestamp='1579822157' WHERE PBXPid=1 [2020-01-24 07:29:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579822147 [2020-01-24 07:29:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579822157,`PBXCuid`=1579822157 [2020-01-24 07:34:17] UPDATE pbxsetting SET lastupdatetimestamp='1579822457' WHERE PBXPid=1 [2020-01-24 07:34:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579822447 [2020-01-24 07:34:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579822457,`PBXCuid`=1579822457 [2020-01-24 07:39:17] UPDATE pbxsetting SET lastupdatetimestamp='1579822757' WHERE PBXPid=1 [2020-01-24 07:39:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579822747 [2020-01-24 07:39:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579822757,`PBXCuid`=1579822757 [2020-01-24 07:44:17] UPDATE pbxsetting SET lastupdatetimestamp='1579823057' WHERE PBXPid=1 [2020-01-24 07:44:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579823047 [2020-01-24 07:44:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579823057,`PBXCuid`=1579823057 [2020-01-24 07:49:17] UPDATE pbxsetting SET lastupdatetimestamp='1579823357' WHERE PBXPid=1 [2020-01-24 07:49:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579823347 [2020-01-24 07:49:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579823357,`PBXCuid`=1579823357 [2020-01-24 07:54:17] UPDATE pbxsetting SET lastupdatetimestamp='1579823657' WHERE PBXPid=1 [2020-01-24 07:54:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579823647 [2020-01-24 07:54:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579823657,`PBXCuid`=1579823657 [2020-01-24 07:59:17] UPDATE pbxsetting SET lastupdatetimestamp='1579823957' WHERE PBXPid=1 [2020-01-24 07:59:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579823947 [2020-01-24 07:59:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579823957,`PBXCuid`=1579823957 [2020-01-24 08:04:17] UPDATE pbxsetting SET lastupdatetimestamp='1579824257' WHERE PBXPid=1 [2020-01-24 08:04:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579824247 [2020-01-24 08:04:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579824257,`PBXCuid`=1579824257 [2020-01-24 08:09:17] UPDATE pbxsetting SET lastupdatetimestamp='1579824557' WHERE PBXPid=1 [2020-01-24 08:09:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579824547 [2020-01-24 08:09:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579824557,`PBXCuid`=1579824557 [2020-01-24 08:14:17] UPDATE pbxsetting SET lastupdatetimestamp='1579824857' WHERE PBXPid=1 [2020-01-24 08:14:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579824847 [2020-01-24 08:14:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579824857,`PBXCuid`=1579824857 [2020-01-24 08:19:17] UPDATE pbxsetting SET lastupdatetimestamp='1579825157' WHERE PBXPid=1 [2020-01-24 08:19:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579825147 [2020-01-24 08:19:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579825157,`PBXCuid`=1579825157 [2020-01-24 08:24:17] UPDATE pbxsetting SET lastupdatetimestamp='1579825457' WHERE PBXPid=1 [2020-01-24 08:24:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579825447 [2020-01-24 08:24:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579825457,`PBXCuid`=1579825457 [2020-01-24 08:29:17] UPDATE pbxsetting SET lastupdatetimestamp='1579825757' WHERE PBXPid=1 [2020-01-24 08:29:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579825747 [2020-01-24 08:29:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579825757,`PBXCuid`=1579825757 [2020-01-24 08:34:17] UPDATE pbxsetting SET lastupdatetimestamp='1579826057' WHERE PBXPid=1 [2020-01-24 08:34:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579826047 [2020-01-24 08:34:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579826057,`PBXCuid`=1579826057 [2020-01-24 08:39:17] UPDATE pbxsetting SET lastupdatetimestamp='1579826357' WHERE PBXPid=1 [2020-01-24 08:39:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579826347 [2020-01-24 08:39:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579826357,`PBXCuid`=1579826357 [2020-01-24 08:44:17] UPDATE pbxsetting SET lastupdatetimestamp='1579826657' WHERE PBXPid=1 [2020-01-24 08:44:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579826647 [2020-01-24 08:44:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579826657,`PBXCuid`=1579826657 [2020-01-24 08:49:17] UPDATE pbxsetting SET lastupdatetimestamp='1579826957' WHERE PBXPid=1 [2020-01-24 08:49:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579826947 [2020-01-24 08:49:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579826957,`PBXCuid`=1579826957 [2020-01-24 08:54:17] UPDATE pbxsetting SET lastupdatetimestamp='1579827257' WHERE PBXPid=1 [2020-01-24 08:54:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579827247 [2020-01-24 08:54:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579827257,`PBXCuid`=1579827257 [2020-01-24 08:59:17] UPDATE pbxsetting SET lastupdatetimestamp='1579827557' WHERE PBXPid=1 [2020-01-24 08:59:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579827547 [2020-01-24 08:59:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579827557,`PBXCuid`=1579827557 [2020-01-24 09:04:17] UPDATE pbxsetting SET lastupdatetimestamp='1579827857' WHERE PBXPid=1 [2020-01-24 09:04:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579827847 [2020-01-24 09:04:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579827857,`PBXCuid`=1579827857 [2020-01-24 09:09:17] UPDATE pbxsetting SET lastupdatetimestamp='1579828157' WHERE PBXPid=1 [2020-01-24 09:09:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579828147 [2020-01-24 09:09:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579828157,`PBXCuid`=1579828157 [2020-01-24 09:14:17] UPDATE pbxsetting SET lastupdatetimestamp='1579828457' WHERE PBXPid=1 [2020-01-24 09:14:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579828447 [2020-01-24 09:14:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579828457,`PBXCuid`=1579828457 [2020-01-24 09:19:17] UPDATE pbxsetting SET lastupdatetimestamp='1579828757' WHERE PBXPid=1 [2020-01-24 09:19:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579828747 [2020-01-24 09:19:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579828757,`PBXCuid`=1579828757 [2020-01-24 09:24:17] UPDATE pbxsetting SET lastupdatetimestamp='1579829057' WHERE PBXPid=1 [2020-01-24 09:24:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579829047 [2020-01-24 09:24:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579829057,`PBXCuid`=1579829057 [2020-01-24 09:29:17] UPDATE pbxsetting SET lastupdatetimestamp='1579829357' WHERE PBXPid=1 [2020-01-24 09:29:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579829347 [2020-01-24 09:29:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579829357,`PBXCuid`=1579829357 [2020-01-24 09:34:17] UPDATE pbxsetting SET lastupdatetimestamp='1579829657' WHERE PBXPid=1 [2020-01-24 09:34:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579829647 [2020-01-24 09:34:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579829657,`PBXCuid`=1579829657 [2020-01-24 09:39:17] UPDATE pbxsetting SET lastupdatetimestamp='1579829957' WHERE PBXPid=1 [2020-01-24 09:39:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579829947 [2020-01-24 09:39:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579829957,`PBXCuid`=1579829957 [2020-01-24 09:44:17] UPDATE pbxsetting SET lastupdatetimestamp='1579830257' WHERE PBXPid=1 [2020-01-24 09:44:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579830247 [2020-01-24 09:44:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579830257,`PBXCuid`=1579830257 [2020-01-24 09:49:17] UPDATE pbxsetting SET lastupdatetimestamp='1579830557' WHERE PBXPid=1 [2020-01-24 09:49:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579830547 [2020-01-24 09:49:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579830557,`PBXCuid`=1579830557 [2020-01-24 09:54:17] UPDATE pbxsetting SET lastupdatetimestamp='1579830857' WHERE PBXPid=1 [2020-01-24 09:54:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579830847 [2020-01-24 09:54:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579830857,`PBXCuid`=1579830857 [2020-01-24 09:59:17] UPDATE pbxsetting SET lastupdatetimestamp='1579831157' WHERE PBXPid=1 [2020-01-24 09:59:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579831147 [2020-01-24 09:59:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579831157,`PBXCuid`=1579831157 [2020-01-24 10:04:17] UPDATE pbxsetting SET lastupdatetimestamp='1579831457' WHERE PBXPid=1 [2020-01-24 10:04:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579831447 [2020-01-24 10:04:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579831457,`PBXCuid`=1579831457 [2020-01-24 10:09:17] UPDATE pbxsetting SET lastupdatetimestamp='1579831757' WHERE PBXPid=1 [2020-01-24 10:09:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579831747 [2020-01-24 10:09:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579831757,`PBXCuid`=1579831757 [2020-01-24 10:14:17] UPDATE pbxsetting SET lastupdatetimestamp='1579832057' WHERE PBXPid=1 [2020-01-24 10:14:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579832047 [2020-01-24 10:14:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579832057,`PBXCuid`=1579832057 [2020-01-24 10:18:05] UPDATE sales SET login_ip='42.200.71.168', login_time='15798322855279' WHERE Sid='95' LIMIT 1 [2020-01-24 10:18:05] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`type`) VALUES ('2020-01-24 10:18:05',95,'42.200.71.168',1,2) [2020-01-24 10:18:05] UPDATE sales SET lastlogindate='2020-01-24 10:18:05' WHERE Sid='95' LIMIT 1 [2020-01-24 10:18:05] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 10:18:05] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 10:18:05] 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-24 10:18:06] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 10:18:06] UPDATE sales SET lastlogindate='2020-01-24 10:18:06' WHERE Sid='95' LIMIT 1 [2020-01-24 10:18:06] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 10:18:07] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 10:18: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-24 10:18:07] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 10:19:17] UPDATE pbxsetting SET lastupdatetimestamp='1579832357' WHERE PBXPid=1 [2020-01-24 10:19:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579832347 [2020-01-24 10:19:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579832357,`PBXCuid`=1579832357 [2020-01-24 10:24:17] UPDATE pbxsetting SET lastupdatetimestamp='1579832657' WHERE PBXPid=1 [2020-01-24 10:24:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579832647 [2020-01-24 10:24:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579832657,`PBXCuid`=1579832657 [2020-01-24 10:29:17] UPDATE pbxsetting SET lastupdatetimestamp='1579832957' WHERE PBXPid=1 [2020-01-24 10:29:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579832947 [2020-01-24 10:29:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579832957,`PBXCuid`=1579832957 [2020-01-24 10:34:17] UPDATE pbxsetting SET lastupdatetimestamp='1579833257' WHERE PBXPid=1 [2020-01-24 10:34:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579833247 [2020-01-24 10:34:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579833257,`PBXCuid`=1579833257 [2020-01-24 10:39:17] UPDATE pbxsetting SET lastupdatetimestamp='1579833557' WHERE PBXPid=1 [2020-01-24 10:39:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579833547 [2020-01-24 10:39:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579833557,`PBXCuid`=1579833557 [2020-01-24 10:44:17] UPDATE pbxsetting SET lastupdatetimestamp='1579833857' WHERE PBXPid=1 [2020-01-24 10:44:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579833847 [2020-01-24 10:44:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579833857,`PBXCuid`=1579833857 [2020-01-24 10:49:17] UPDATE pbxsetting SET lastupdatetimestamp='1579834157' WHERE PBXPid=1 [2020-01-24 10:49:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579834147 [2020-01-24 10:49:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579834157,`PBXCuid`=1579834157 [2020-01-24 10:49:19] UPDATE sales SET lastlogindate='2020-01-24 10:49:19' WHERE Sid='95' LIMIT 1 [2020-01-24 10:49:19] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 10:49:20] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 10:49: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-24 10:49:20] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 10:49: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-24 10:49:21] 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-24 10:50:38] UPDATE sales SET lastlogindate='2020-01-24 10:50:38' WHERE Sid='95' LIMIT 1 [2020-01-24 10:50:38] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 10:50:38] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 10:50: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-24 10:50:39] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 10:50: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-24 10:50: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-24 10:54:17] UPDATE pbxsetting SET lastupdatetimestamp='1579834457' WHERE PBXPid=1 [2020-01-24 10:54:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579834447 [2020-01-24 10:54:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579834457,`PBXCuid`=1579834457 [2020-01-24 10:59:17] UPDATE pbxsetting SET lastupdatetimestamp='1579834757' WHERE PBXPid=1 [2020-01-24 10:59:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579834747 [2020-01-24 10:59:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579834757,`PBXCuid`=1579834757 [2020-01-24 11:00:08] UPDATE sales SET lastlogindate='2020-01-24 11:00:08' WHERE Sid='95' LIMIT 1 [2020-01-24 11:00:08] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 11:00:08] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 11:00: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-24 11:00:09] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 11:00:09] 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-24 11:00:10] 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-24 11:04:17] UPDATE pbxsetting SET lastupdatetimestamp='1579835057' WHERE PBXPid=1 [2020-01-24 11:04:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579835047 [2020-01-24 11:04:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579835057,`PBXCuid`=1579835057 [2020-01-24 11:09:17] UPDATE pbxsetting SET lastupdatetimestamp='1579835357' WHERE PBXPid=1 [2020-01-24 11:09:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579835347 [2020-01-24 11:09:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579835357,`PBXCuid`=1579835357 [2020-01-24 11:14:17] UPDATE pbxsetting SET lastupdatetimestamp='1579835657' WHERE PBXPid=1 [2020-01-24 11:14:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579835647 [2020-01-24 11:14:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579835657,`PBXCuid`=1579835657 [2020-01-24 11:19:17] UPDATE pbxsetting SET lastupdatetimestamp='1579835957' WHERE PBXPid=1 [2020-01-24 11:19:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579835947 [2020-01-24 11:19:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579835957,`PBXCuid`=1579835957 [2020-01-24 11:24:17] UPDATE pbxsetting SET lastupdatetimestamp='1579836257' WHERE PBXPid=1 [2020-01-24 11:24:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579836247 [2020-01-24 11:24:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579836257,`PBXCuid`=1579836257 [2020-01-24 11:29:17] UPDATE pbxsetting SET lastupdatetimestamp='1579836557' WHERE PBXPid=1 [2020-01-24 11:29:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579836547 [2020-01-24 11:29:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579836557,`PBXCuid`=1579836557 [2020-01-24 11:34:17] UPDATE pbxsetting SET lastupdatetimestamp='1579836857' WHERE PBXPid=1 [2020-01-24 11:34:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579836847 [2020-01-24 11:34:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579836857,`PBXCuid`=1579836857 [2020-01-24 11:39:17] UPDATE pbxsetting SET lastupdatetimestamp='1579837157' WHERE PBXPid=1 [2020-01-24 11:39:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579837147 [2020-01-24 11:39:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579837157,`PBXCuid`=1579837157 [2020-01-24 11:44:17] UPDATE pbxsetting SET lastupdatetimestamp='1579837457' WHERE PBXPid=1 [2020-01-24 11:44:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579837447 [2020-01-24 11:44:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579837457,`PBXCuid`=1579837457 [2020-01-24 11:48:18] UPDATE sales SET login_ip='59.149.178.147', login_time='15798376984205' WHERE Sid='77' LIMIT 1 [2020-01-24 11:48:18] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`type`) VALUES ('2020-01-24 11:48:18',77,'59.149.178.147',1,2) [2020-01-24 11:48:19] UPDATE sales SET lastlogindate='2020-01-24 11:48:19' WHERE Sid='77' LIMIT 1 [2020-01-24 11:48:19] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 11:48:19] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 11:48: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-24 11:48:19] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 11:48:20] UPDATE sales SET lastlogindate='2020-01-24 11:48:20' WHERE Sid='77' LIMIT 1 [2020-01-24 11:48:20] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 11:48:20] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 11:48: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-24 11:48:21] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 11:48:24] UPDATE sales SET lastlogindate='2020-01-24 11:48:24' WHERE Sid='77' LIMIT 1 [2020-01-24 11:48:24] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 11:48:24] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 11:48:24] 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-24 11:48:25] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 11:48:25] 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-24 11:48:25] 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-24 11:49:17] UPDATE pbxsetting SET lastupdatetimestamp='1579837757' WHERE PBXPid=1 [2020-01-24 11:49:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579837747 [2020-01-24 11:49:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579837757,`PBXCuid`=1579837757 [2020-01-24 11:50:20] UPDATE sales SET lastlogindate='2020-01-24 11:50:20' WHERE Sid='77' LIMIT 1 [2020-01-24 11:50:20] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 11:50:20] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 11: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-24 11: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-24 11:50: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-24 11:50:21] 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-24 11:54:17] UPDATE pbxsetting SET lastupdatetimestamp='1579838057' WHERE PBXPid=1 [2020-01-24 11:54:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579838047 [2020-01-24 11:54:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579838057,`PBXCuid`=1579838057 [2020-01-24 11:59:17] UPDATE pbxsetting SET lastupdatetimestamp='1579838357' WHERE PBXPid=1 [2020-01-24 11:59:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579838347 [2020-01-24 11:59:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579838357,`PBXCuid`=1579838357 [2020-01-24 12:04:17] UPDATE pbxsetting SET lastupdatetimestamp='1579838657' WHERE PBXPid=1 [2020-01-24 12:04:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579838647 [2020-01-24 12:04:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579838657,`PBXCuid`=1579838657 [2020-01-24 12:06:16] UPDATE sales SET login_ip='192.168.0.173', login_time='15798387763170' WHERE Sid='98' LIMIT 1 [2020-01-24 12:06:16] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`type`) VALUES ('2020-01-24 12:06:16',98,'192.168.0.173',1,2) [2020-01-24 12:06:16] UPDATE sales SET lastlogindate='2020-01-24 12:06:16' WHERE Sid='98' LIMIT 1 [2020-01-24 12:06:16] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 12:06:16] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 12:06:16] 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-24 12:06:17] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 12:06:18] UPDATE sales SET lastlogindate='2020-01-24 12:06:18' WHERE Sid='98' LIMIT 1 [2020-01-24 12:06:18] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 12:06:18] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 12:06:18] 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-24 12:06:19] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 12:06:39] UPDATE sales SET lastlogindate='2020-01-24 12:06:39' WHERE Sid='98' LIMIT 1 [2020-01-24 12:06:39] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 12:06:39] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 12:06: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-24 12:06:40] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 12:06: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-24 12:06: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-24 12:08:07] UPDATE sales SET lastlogindate='2020-01-24 12:08:07' WHERE Sid='98' LIMIT 1 [2020-01-24 12:08:07] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 12:08:08] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 12:08: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-24 12:08:08] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 12:08:22] UPDATE sales SET lastlogindate='2020-01-24 12:08:22' WHERE Sid='98' LIMIT 1 [2020-01-24 12:08:22] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 12:08:22] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 12:08: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-24 12:08:23] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 12:08:23] 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-24 12:08:23] 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-24 12:09:08] UPDATE sales SET lastlogindate='2020-01-24 12:09:08' WHERE Sid='98' LIMIT 1 [2020-01-24 12:09:08] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 12:09:08] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 12:09: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-24 12:09:09] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 12:09:17] UPDATE pbxsetting SET lastupdatetimestamp='1579838957' WHERE PBXPid=1 [2020-01-24 12:09:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579838947 [2020-01-24 12:09:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579838957,`PBXCuid`=1579838957 [2020-01-24 12:14:17] UPDATE pbxsetting SET lastupdatetimestamp='1579839257' WHERE PBXPid=1 [2020-01-24 12:14:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579839247 [2020-01-24 12:14:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579839257,`PBXCuid`=1579839257 [2020-01-24 12:18:06] UPDATE sales SET lastlogindate='2020-01-24 12:18:06' WHERE Sid='98' LIMIT 1 [2020-01-24 12:18:06] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 12:18:06] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 12:18:06] 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-24 12:18:06] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 12:18:07] 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-24 12:18:07] 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-24 12:18:31] UPDATE sales SET lastlogindate='2020-01-24 12:18:31' WHERE Sid='98' LIMIT 1 [2020-01-24 12:18:31] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 12:18:31] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 12:18: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-24 12:18:32] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 12:18: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-24 12:18: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-24 12:18:44] INSERT INTO adminlog ( `logintime`, `id`, `ip`, `status`, `field`, `remark`, `r`, `type` ) VALUES ( NOW(), '98', '192.168.0.173', '8', 'project', '樓盤︰藍田 - 康田苑 座: B, 單位: 02, 層: 25, 地段編號: *', '10385', '2' ) [2020-01-24 12:19:17] UPDATE pbxsetting SET lastupdatetimestamp='1579839557' WHERE PBXPid=1 [2020-01-24 12:19:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579839547 [2020-01-24 12:19:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579839557,`PBXCuid`=1579839557 [2020-01-24 12:24:17] UPDATE pbxsetting SET lastupdatetimestamp='1579839857' WHERE PBXPid=1 [2020-01-24 12:24:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579839847 [2020-01-24 12:24:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579839857,`PBXCuid`=1579839857 [2020-01-24 12:29:17] UPDATE pbxsetting SET lastupdatetimestamp='1579840157' WHERE PBXPid=1 [2020-01-24 12:29:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579840147 [2020-01-24 12:29:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579840157,`PBXCuid`=1579840157 [2020-01-24 12:34:17] UPDATE pbxsetting SET lastupdatetimestamp='1579840457' WHERE PBXPid=1 [2020-01-24 12:34:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579840447 [2020-01-24 12:34:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579840457,`PBXCuid`=1579840457 [2020-01-24 12:37:50] UPDATE sales SET lastlogindate='2020-01-24 12:37:50' WHERE Sid='98' LIMIT 1 [2020-01-24 12:37:50] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 12:37:50] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 12:37: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-24 12:37:51] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 12:37:51] 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-24 12:37:52] 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-24 12:37:52] UPDATE sales SET lastlogindate='2020-01-24 12:37:52' WHERE Sid='98' LIMIT 1 [2020-01-24 12:37:52] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 12:37:52] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 12:37: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-24 12:37:53] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 12:37: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-24 12:37: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-24 12:39:17] UPDATE pbxsetting SET lastupdatetimestamp='1579840757' WHERE PBXPid=1 [2020-01-24 12:39:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579840747 [2020-01-24 12:39:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579840757,`PBXCuid`=1579840757 [2020-01-24 12:44:17] UPDATE pbxsetting SET lastupdatetimestamp='1579841057' WHERE PBXPid=1 [2020-01-24 12:44:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579841047 [2020-01-24 12:44:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579841057,`PBXCuid`=1579841057 [2020-01-24 12:49:17] UPDATE pbxsetting SET lastupdatetimestamp='1579841357' WHERE PBXPid=1 [2020-01-24 12:49:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579841347 [2020-01-24 12:49:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579841357,`PBXCuid`=1579841357 [2020-01-24 12:50:40] UPDATE sales SET lastlogindate='2020-01-24 12:50:40' WHERE Sid='98' LIMIT 1 [2020-01-24 12:50:40] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 12:50:40] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 12:50: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-24 12:50:41] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 12:51:49] UPDATE sales SET lastlogindate='2020-01-24 12:51:49' WHERE Sid='98' LIMIT 1 [2020-01-24 12:51:49] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 12:51:49] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 12:51: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-24 12:51:50] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 12:51: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-24 12:51: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-24 12:52:31] UPDATE sales SET login_ip='119.247.228.39', login_time='15798415512518' WHERE Sid='1' LIMIT 1 [2020-01-24 12:52:31] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`type`) VALUES ('2020-01-24 12:52:31',1,'119.247.228.39',1,2) [2020-01-24 12:52:32] UPDATE sales SET lastlogindate='2020-01-24 12:52:32' WHERE Sid='1' LIMIT 1 [2020-01-24 12:52:32] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 12:52:32] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 12:52: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-24 12:52:32] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 12:52:33] UPDATE sales SET lastlogindate='2020-01-24 12:52:33' WHERE Sid='1' LIMIT 1 [2020-01-24 12:52:33] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 12:52:33] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 12:52: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-24 12:52:34] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 12:52:38] UPDATE sales SET lastlogindate='2020-01-24 12:52:38' WHERE Sid='1' LIMIT 1 [2020-01-24 12:52:38] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 12:52:38] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 12:52: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-24 12:52:39] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 12:52: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-24 12:52: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-24 12:52:56] INSERT INTO adminlog ( `logintime`, `id`, `ip`, `status`, `field`, `remark`, `r`, `type` ) VALUES ( NOW(), '1', '119.247.228.39', '10', 'project', '樓盤︰油塘/住宅 - 海傲灣 座: 1B, 單位: H, 層: 11, 地段編號: ', '10534', '2' ) [2020-01-24 12:53:03] UPDATE sales SET lastlogindate='2020-01-24 12:53:03' WHERE Sid='1' LIMIT 1 [2020-01-24 12:53:03] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 12:53:03] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 12:53: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-24 12:53:04] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 12:53:04] UPDATE setting SET propertyadno=propertyadno+1 WHERE id=1 LIMIT 1 [2020-01-24 12:53:04] UPDATE sales SET lastlogindate='2020-01-24 12:53:04' WHERE Sid='1' LIMIT 1 [2020-01-24 12:53:04] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 12:53:04] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 12:53: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-24 12:53:05] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 12:53: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-24 12:53: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-24 12:53:14] UPDATE sales SET lastlogindate='2020-01-24 12:53:14' WHERE Sid='98' LIMIT 1 [2020-01-24 12:53:14] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 12:53:15] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 12:53:15] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate1=NOW() AND Pstepcount=2 [2020-01-24 12:53:15] UPDATE project SET Pstatus2=4 WHERE Pstatus2=2 AND Pbexdate1=NOW() AND Pstepcount=2 [2020-01-24 12:53:15] 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-24 12:53:16] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 12:53:16] UPDATE project SET Pbreceived='5800' WHERE Pid='9375' LIMIT 1 [2020-01-24 12:53:16] UPDATE project SET Pstatus=8 WHERE Pstatus<>8 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-01-24 12:53:16] 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-24 12:53:16] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 12:53:16] 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-24 12:53:17] 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-24 12:53:17] 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-24 12:53:23] UPDATE sales SET lastlogindate='2020-01-24 12:53:23' WHERE Sid='1' LIMIT 1 [2020-01-24 12:53:23] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 12:53:23] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 12:53: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-24 12:53:24] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 12:53: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-24 12:53: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-24 12:53:27] UPDATE sales SET lastlogindate='2020-01-24 12:53:27' WHERE Sid='1' LIMIT 1 [2020-01-24 12:53:27] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 12:53:27] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 12:53: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-24 12:53:28] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 12:53:28] 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-24 12:53:28] 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-24 12:54:17] UPDATE pbxsetting SET lastupdatetimestamp='1579841657' WHERE PBXPid=1 [2020-01-24 12:54:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579841647 [2020-01-24 12:54:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579841657,`PBXCuid`=1579841657 [2020-01-24 12:59:17] UPDATE pbxsetting SET lastupdatetimestamp='1579841957' WHERE PBXPid=1 [2020-01-24 12:59:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579841947 [2020-01-24 12:59:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579841957,`PBXCuid`=1579841957 [2020-01-24 13:04:17] UPDATE pbxsetting SET lastupdatetimestamp='1579842257' WHERE PBXPid=1 [2020-01-24 13:04:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579842247 [2020-01-24 13:04:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579842257,`PBXCuid`=1579842257 [2020-01-24 13:09:17] UPDATE pbxsetting SET lastupdatetimestamp='1579842557' WHERE PBXPid=1 [2020-01-24 13:09:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579842547 [2020-01-24 13:09:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579842557,`PBXCuid`=1579842557 [2020-01-24 13:14:17] UPDATE pbxsetting SET lastupdatetimestamp='1579842857' WHERE PBXPid=1 [2020-01-24 13:14:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579842847 [2020-01-24 13:14:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579842857,`PBXCuid`=1579842857 [2020-01-24 13:19:17] UPDATE pbxsetting SET lastupdatetimestamp='1579843157' WHERE PBXPid=1 [2020-01-24 13:19:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579843147 [2020-01-24 13:19:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579843157,`PBXCuid`=1579843157 [2020-01-24 13:24:17] UPDATE pbxsetting SET lastupdatetimestamp='1579843457' WHERE PBXPid=1 [2020-01-24 13:24:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579843447 [2020-01-24 13:24:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579843457,`PBXCuid`=1579843457 [2020-01-24 13:29:17] UPDATE pbxsetting SET lastupdatetimestamp='1579843757' WHERE PBXPid=1 [2020-01-24 13:29:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579843747 [2020-01-24 13:29:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579843757,`PBXCuid`=1579843757 [2020-01-24 13:34:17] UPDATE pbxsetting SET lastupdatetimestamp='1579844057' WHERE PBXPid=1 [2020-01-24 13:34:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579844047 [2020-01-24 13:34:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579844057,`PBXCuid`=1579844057 [2020-01-24 13:39:17] UPDATE pbxsetting SET lastupdatetimestamp='1579844357' WHERE PBXPid=1 [2020-01-24 13:39:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579844347 [2020-01-24 13:39:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579844357,`PBXCuid`=1579844357 [2020-01-24 13:44:17] UPDATE pbxsetting SET lastupdatetimestamp='1579844657' WHERE PBXPid=1 [2020-01-24 13:44:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579844647 [2020-01-24 13:44:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579844657,`PBXCuid`=1579844657 [2020-01-24 13:49:17] UPDATE pbxsetting SET lastupdatetimestamp='1579844957' WHERE PBXPid=1 [2020-01-24 13:49:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579844947 [2020-01-24 13:49:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579844957,`PBXCuid`=1579844957 [2020-01-24 13:54:17] UPDATE pbxsetting SET lastupdatetimestamp='1579845257' WHERE PBXPid=1 [2020-01-24 13:54:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579845247 [2020-01-24 13:54:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579845257,`PBXCuid`=1579845257 [2020-01-24 13:57:23] INSERT INTO adminlog ( `logintime`, `id`, `ip`, `status`, `type` ) VALUES ( NOW(), '95', '42.200.71.168', '9', '2' ) [2020-01-24 13:57:23] UPDATE sales SET logined=2 WHERE Sid='95' LIMIT 1 [2020-01-24 13:57:43] UPDATE sales SET login_ip='42.200.71.168', login_time='15798454636420' WHERE Sid='95' LIMIT 1 [2020-01-24 13:57:43] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`type`) VALUES ('2020-01-24 13:57:43',95,'42.200.71.168',1,2) [2020-01-24 13:57:43] UPDATE sales SET lastlogindate='2020-01-24 13:57:43' WHERE Sid='95' LIMIT 1 [2020-01-24 13:57:43] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 13:57:43] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 13:57: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-24 13:57:44] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 13:57:44] UPDATE sales SET lastlogindate='2020-01-24 13:57:44' WHERE Sid='95' LIMIT 1 [2020-01-24 13:57:44] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 13:57:45] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 13:57: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-24 13:57:45] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 13:59:17] UPDATE pbxsetting SET lastupdatetimestamp='1579845557' WHERE PBXPid=1 [2020-01-24 13:59:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579845547 [2020-01-24 13:59:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579845557,`PBXCuid`=1579845557 [2020-01-24 13:59:33] UPDATE sales SET lastlogindate='2020-01-24 13:59:33' WHERE Sid='95' LIMIT 1 [2020-01-24 13:59:33] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 13:59:33] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 13:59: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-24 13:59:34] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 13:59:34] 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-24 13:59: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-24 14:00:20] UPDATE sales SET lastlogindate='2020-01-24 14:00:20' WHERE Sid='95' LIMIT 1 [2020-01-24 14:00:20] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 14:00:20] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 14:00: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-24 14:00:20] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 14:00: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-24 14:00:21] 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-24 14:01:07] UPDATE sales SET lastlogindate='2020-01-24 14:01:07' WHERE Sid='95' LIMIT 1 [2020-01-24 14:01:07] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 14:01:07] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 14:01: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-24 14:01:08] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 14:01:08] INSERT INTO project (`Pdate`,`Pname`,`Poname`,`Poremark`,`Pbname`,`Pbremark`,`Pprice`,`Popay`,`Pbpay`,`Premark`,`Bid`,`Sid`,`Pstatus`,`Porecedate`,`Potype`,`Popaytype`,`Popaydate`,`Popaymethod`,`Pobankno`,`Popayremark`,`Pbrecedate`,`Pbtype`,`Pbpaytype`,`Pbpaydate`,`Pbpaymethod`,`Pbbankno`,`Pbpayremark`,`Ptype`,`Pexdate1`,`Pexdate2`,`Poexdate1`,`Pbexdate1`,`Polawyer`,`Pblawyer`,`Pocheque`,`Pbcheque`,`BDid`,`Poadminid`,`Pbadminid`,`Poreceived`,`Pbreceived`,`Pocooperate`,`Pbcooperate`,`Pstatus2`,`Pstepcount`,`Polawyermore`,`Pblawyermore`,`Pextra1`,`Pextra2`,`Pextra3`,`Pextra4`,`Pextra5`,`Pextra6`,`Pextra7`,`Pextra8`,`Pextra9`,`Pextra10`,`Pextra11`,`Pname2`,`Pflat`,`Pfloor`,`Pcar`,`Plivestatus`,`Pkeyno`,`Pnumber`,`Potel`,`Poctel`,`Pomtel`,`Plocid`,`PBDcarea`,`PBDsarea`,`PBDinterval`,`PBDmfees`,`PBDrfees`,`PBDtype`,`PBDlandscape`,`PBDdecorating`,`PBDdescription`,`Pcustom`,`PBDaddress`,`PBDroom`,`PBDhall`,`PBDsuite`,`PBDcarspac`,`PBDmaidroom`,`PBDtoilet`,`PBDstorerooms`,`PBDkitchen`,`PBDwindowsill`,`PBDrooftop`,`PBDgarden`,`PBDstatus`,`PBDexclusive`,`PBDlistings`,`PBDkey`,`PtmpBid`,`PtmpSid`,`Cid`,`Oid`,`PBDsources`,`Prpice`,`Poremarkmulti`,`Pocontact`,`Pocontacttel`,`Ppprice`,`Prent`,`Ppprice_s`,`Ppprice_t`,`Prent_s`,`Prent_t`,`Plot_no`,`Pexdate3`,`Pcreatedate`,`Pmodifydate`,`Pmobile_status`,`Pmobile_pprice`,`Pmobile_pprice_s`,`Pmobile_pprice_t`,`Pmobiler_rent`,`Pmobiler_rent_s`,`Pmobiler_rent_t`,`Pmobile_top`,`PBDterrace`,`PBDwork_platform`,`PBDcarspac_no`,`PBDkey_no`,`PBDmobiler_desc`,`PBDyoutube`,`Pmobile_sno`,`PBDopeninterval`,`PBDceiling`,`PBDdoorwidth`,`PBDpoweredby`,`PBDgas`,`Prpice2`,`PgroupID`,`Pcompany`,`Pbrname`,`Pbrtel`,`Pdirection`,`Pocontactmulti`,`Pccontactmulti`,`Pcremarkmulti`,`Pttype`,`Pdcontactmulti`,`Pdremarkmulti`,`Padnumber`) VALUES (NULL,NULL,NULL,NULL,NULL,NULL,'0.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'11',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'B','08','7',NULL,'3',NULL,NULL,NULL,NULL,NULL,'37',NULL,NULL,NULL,NULL,NULL,'1',NULL,'出售期數： 第八期丙 落成年份： 1987年1月 樓宇類型： 風車型 樓宇座數： 3 樓宇名稱： A宏康閣 B怡康閣 C頌康閣 單位數目： 1 680 單位建築面積 (平方米)： 43 - 53 單位實用面積 (平方米)： 32 - 39 首次推出售價 ($)： 154400 - 286800 業主立案法團： 已成立 區域物業管理辦事處 / 分區租約事務： 房屋署順利邨辦事處 九龍觀塘順利邨利富樓地下 電話：2341 8286 傳真：2763 6066 屋苑物業管理： 新昌管理服務有限公司 九龍藍田連德道2號康華苑宏康閣地下管理處 電話：2379 0000 傳真：2379 5411 電郵：zhow@synergis.com.hk 停車場管理： 新昌管理集團有限公司 香港九龍觀塘偉業街107-109號新昌中心 電話: 2579 8313 傳真: 2751 8784 電郵: hacp@synergis.com.hk 屋苑網站： - 首次出售時大約折扣率：24% 2013/09/03 藍田康華苑 A座 宏康閣 29樓 下午3時11分,管理員接獲投訴單位傳出臭味,消防員破門入... 2013/01/29 藍田康華苑 A座 宏康閣 72歲患有鼻咽癌老翁,被家人發現在住所跳樓,救護人員到... 2004/06/14 藍田康華苑 B座 怡康閣 2樓 68歲姓蘇老婦,疑有精神病問題,於上址用刀刎頸自殺. 詳情 2002/11/16 藍田康華苑 C座 頌康閣 31歲姓羅男子,躲在浴室內再度燒炭,其父於深夜如廁時,發... 2000/08/30 藍田康華苑 A座 宏康閣 1樓 42歲姓余男子,疑因工作壓力及被解僱,而燒炭自殺身亡',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1',NULL,NULL,NULL,'2','95',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'*',NULL,'2020-01-24 14:01:08','2020-01-24 14:01:08',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'5865') [2020-01-24 14:01:08] UPDATE setting SET propertyadno=propertyadno+1 WHERE id=1 LIMIT 1 [2020-01-24 14:01:08] UPDATE project SET Pprice_old='2020-01-24 14:01:08::0::0' WHERE Pid='11212' LIMIT 1 [2020-01-24 14:01:08] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`field`,`remark`,`r`,`type`) VALUES ('2020-01-24 14:01:08',95,'42.200.71.168',2,'project','項目 : ',11212,'2') [2020-01-24 14:01:08] UPDATE sales SET lastlogindate='2020-01-24 14:01:08' WHERE Sid='95' LIMIT 1 [2020-01-24 14:01:08] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 14:01:08] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 14:01: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-24 14:01:09] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 14:01:09] 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-24 14:01:09] 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-24 14:02:00] INSERT INTO adminlog ( `logintime`, `id`, `ip`, `status`, `field`, `remark`, `r`, `type` ) VALUES ( NOW(), '95', '42.200.71.168', '8', 'project', '樓盤︰藍田 - 康華苑 座: B, 單位: 08, 層: 7, 地段編號: *', '11212', '2' ) [2020-01-24 14:02:38] UPDATE sales SET lastlogindate='2020-01-24 14:02:38' WHERE Sid='95' LIMIT 1 [2020-01-24 14:02:38] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 14:02:38] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 14:02: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-24 14:02:38] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 14:02:39] UPDATE project SET `Pdate`=NULL,`Pname`=NULL,`Poname`=NULL,`Poremark`=NULL,`Pbname`=NULL,`Pbremark`=NULL,`Pprice`='0.00',`Popay`='0.00',`Pbpay`='0.00',`Premark`=NULL,`Bid`=NULL,`Sid`=NULL,`Pstatus`=NULL,`Potype`=NULL,`Popaytype`=NULL,`Popaydate`=NULL,`Popaymethod`=NULL,`Pobankno`=NULL,`Popayremark`=NULL,`Pbtype`=NULL,`Pbpaytype`=NULL,`Pbpaydate`=NULL,`Pbpaymethod`=NULL,`Pbbankno`=NULL,`Pbpayremark`=NULL,`Ptype`='2',`Pexdate1`=NULL,`Pexdate2`=NULL,`Poexdate1`='2020-01-24',`Pbexdate1`='2020-01-24',`Polawyer`=NULL,`Pblawyer`=NULL,`Pocheque`=NULL,`Pbcheque`=NULL,`BDid`='11',`Poadminid`=NULL,`Pbadminid`=NULL,`Pocooperate`=NULL,`Pbcooperate`=NULL,`Pstatus2`=NULL,`Pstepcount`='1',`Polawyermore`=NULL,`Pblawyermore`=NULL,`Pextra1`=NULL,`Pextra2`=NULL,`Pextra3`=NULL,`Pextra4`=NULL,`Pextra5`=NULL,`Pextra6`=NULL,`Pextra7`=NULL,`Pextra8`=NULL,`Pextra9`=NULL,`Pextra10`=NULL,`Pextra11`=NULL,`Pname2`='B',`Pflat`='08',`Pfloor`='7',`Pcar`=NULL,`Plivestatus`='3',`Pkeyno`=NULL,`Pnumber`=NULL,`Potel`=NULL,`Poctel`=NULL,`Pomtel`=NULL,`Plocid`='37',`PBDcarea`=NULL,`PBDsarea`='380',`PBDinterval`=NULL,`PBDmfees`=NULL,`PBDrfees`=NULL,`PBDtype`='1',`PBDlandscape`=NULL,`PBDdecorating`='出售期數： 第八期丙 落成年份： 1987年1月 樓宇類型： 風車型 樓宇座數： 3 樓宇名稱： A宏康閣 B怡康閣 C頌康閣 單位數目： 1 680 單位建築面積 (平方米)： 43 - 53 單位實用面積 (平方米)： 32 - 39 首次推出售價 ($)： 154400 - 286800 業主立案法團： 已成立 區域物業管理辦事處 / 分區租約事務： 房屋署順利邨辦事處 九龍觀塘順利邨利富樓地下 電話：2341 8286 傳真：2763 6066 屋苑物業管理： 新昌管理服務有限公司 九龍藍田連德道2號康華苑宏康閣地下管理處 電話：2379 0000 傳真：2379 5411 電郵：zhow@synergis.com.hk 停車場管理： 新昌管理集團有限公司 香港九龍觀塘偉業街107-109號新昌中心 電話: 2579 8313 傳真: 2751 8784 電郵: hacp@synergis.com.hk 屋苑網站： - 首次出售時大約折扣率：24% 2013/09/03 藍田康華苑 A座 宏康閣 29樓 下午3時11分,管理員接獲投訴單位傳出臭味,消防員破門入... 2013/01/29 藍田康華苑 A座 宏康閣 72歲患有鼻咽癌老翁,被家人發現在住所跳樓,救護人員到... 2004/06/14 藍田康華苑 B座 怡康閣 2樓 68歲姓蘇老婦,疑有精神病問題,於上址用刀刎頸自殺. 詳情 2002/11/16 藍田康華苑 C座 頌康閣 31歲姓羅男子,躲在浴室內再度燒炭,其父於深夜如廁時,發... 2000/08/30 藍田康華苑 A座 宏康閣 1樓 42歲姓余男子,疑因工作壓力及被解僱,而燒炭自殺身亡',`PBDdescription`=NULL,`Pcustom`=NULL,`PBDaddress`=NULL,`PBDroom`=NULL,`PBDhall`=NULL,`PBDsuite`=NULL,`PBDcarspac`=NULL,`PBDmaidroom`=NULL,`PBDtoilet`=NULL,`PBDstorerooms`=NULL,`PBDkitchen`=NULL,`PBDwindowsill`=NULL,`PBDrooftop`=NULL,`PBDgarden`=NULL,`PBDstatus`='1',`PBDexclusive`=NULL,`PBDlistings`=NULL,`PBDkey`=NULL,`PtmpBid`='2',`PtmpSid`='95',`Cid`=NULL,`Oid`=NULL,`PBDsources`=NULL,`Prpice`=NULL,`Poremarkmulti`='|2020-01-24 14:02:36::2::95::*OR + TEL 5% BY IRENE $12K|',`Pocontact`=NULL,`Pocontacttel`=NULL,`Ppprice`=NULL,`Prent`='12000',`Ppprice_s`=NULL,`Ppprice_t`=NULL,`Prent_s`=NULL,`Prent_t`=NULL,`Plot_no`='*',`Pexdate3`=NULL,`Pcreatedate`='2020-01-24 14:01:08',`Pmodifydate`='2020-01-24 14:02:39',`Pmobile_status`=NULL,`Pmobile_pprice`=NULL,`Pmobile_pprice_s`=NULL,`Pmobile_pprice_t`=NULL,`Pmobiler_rent`=NULL,`Pmobiler_rent_s`=NULL,`Pmobiler_rent_t`=NULL,`Pmobile_top`=NULL,`PBDterrace`=NULL,`PBDwork_platform`=NULL,`PBDcarspac_no`=NULL,`PBDkey_no`=NULL,`PBDmobiler_desc`=NULL,`PBDyoutube`=NULL,`Pmobile_sno`=NULL,`PBDopeninterval`=NULL,`PBDceiling`=NULL,`PBDdoorwidth`=NULL,`PBDpoweredby`=NULL,`PBDgas`=NULL,`Prpice2`=NULL,`PgroupID`=NULL,`Pcompany`=NULL,`Pbrname`=NULL,`Pbrtel`=NULL,`Pdirection`=NULL,`Pocontactmulti`='MR WONG####::(手提)92758603',`Pccontactmulti`=NULL,`Pcremarkmulti`=NULL,`Pttype`=NULL,`Pdcontactmulti`=NULL,`Pdremarkmulti`=NULL,`Padnumber`='5865' WHERE Pid=11212 [2020-01-24 14:02:39] UPDATE project SET Pprice_old='2020-01-24 14:02:39::::12000.00,2020-01-24 14:01:08::0::0' WHERE Pid='11212' LIMIT 1 [2020-01-24 14:02:39] INSERT INTO projectalert (`PAPid`,`PAdate`,`PAadmin`,`PAtype`,`PAstatus`,`f1_title`,`f1_a`,`f1_b`,`other`) VALUE ('11212','2020-01-24 14:02:39','95','2','1','Prent','','12000','Popay,Pbpay,Poexdate1,Pbexdate1,Poremarkmulti,Pocontactmulti') [2020-01-24 14:02:39] DELETE FROM projectalert WHERE PAPid='11212' && PAadmin='95' && PAtype='2' && PAalert=1 [2020-01-24 14:02:39] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`field`,`remark`,`r`,`type`) VALUES ('2020-01-24 14:02:39',95,'42.200.71.168',3,'project','樓盤︰藍田 - 康華苑 座: B, 單位: 08, 層: 7, 地段編號: *',11212,2) [2020-01-24 14:02:39] UPDATE projectshare SET Pname='' WHERE Pid=11212 [2020-01-24 14:02:39] UPDATE projectshare SET Pprice='0.00',Popay='0.00',Pbpay='0.00' WHERE Pid=11212 [2020-01-24 14:02:39] UPDATE projectshare SET PSprice=ROUND((0)*PSperc/100,2) WHERE Pid=11212 [2020-01-24 14:02:39] UPDATE projectshare AS A SET A.Pdate = (SELECT B.Pdate FROM project AS B WHERE A.Pid=B.Pid) [2020-01-24 14:02:39] UPDATE project SET Pstatus=2 WHERE Pid=11212 [2020-01-24 14:02:39] UPDATE project SET Pstatus2=2 WHERE Pid=11212 [2020-01-24 14:02:39] UPDATE projectsharepayment SET PSPsalrealdate=PSPsaldate WHERE PSPsalrealdate IS NULL OR PSPsalrealdate='' [2020-01-24 14:02:39] UPDATE sales SET lastlogindate='2020-01-24 14:02:39' WHERE Sid='95' LIMIT 1 [2020-01-24 14:02:39] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 14:02:39] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 14:02: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-24 14:02:40] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 14:02: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-24 14:02: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-24 14:02:53] UPDATE sales SET lastlogindate='2020-01-24 14:02:53' WHERE Sid='95' LIMIT 1 [2020-01-24 14:02:53] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 14:02:53] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 14:02: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-24 14:02:54] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 14:03:34] INSERT INTO `message`(`Mdate`, `Madmin`, `Madmintype`, `Mcontent`, `Mstatus`) VALUES ( NOW(), '95', '2', '*OR HW B708 380\' $12K', '1' ) [2020-01-24 14:03:34] UPDATE sales SET lastlogindate='2020-01-24 14:03:34' WHERE Sid='95' LIMIT 1 [2020-01-24 14:03:34] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 14:03:34] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 14:03:34] 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-24 14:03:35] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 14:03:41] UPDATE sales SET lastlogindate='2020-01-24 14:03:41' WHERE Sid='95' LIMIT 1 [2020-01-24 14:03:41] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 14:03:41] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 14:03:41] 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-24 14:03:42] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 14:03:42] 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-24 14:03:42] 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-24 14:04:17] UPDATE pbxsetting SET lastupdatetimestamp='1579845857' WHERE PBXPid=1 [2020-01-24 14:04:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579845847 [2020-01-24 14:04:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579845857,`PBXCuid`=1579845857 [2020-01-24 14:09:17] UPDATE pbxsetting SET lastupdatetimestamp='1579846157' WHERE PBXPid=1 [2020-01-24 14:09:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579846147 [2020-01-24 14:09:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579846157,`PBXCuid`=1579846157 [2020-01-24 14:14:17] UPDATE pbxsetting SET lastupdatetimestamp='1579846457' WHERE PBXPid=1 [2020-01-24 14:14:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579846447 [2020-01-24 14:14:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579846457,`PBXCuid`=1579846457 [2020-01-24 14:18:00] UPDATE sales SET lastlogindate='2020-01-24 14:18:00' WHERE Sid='95' LIMIT 1 [2020-01-24 14:18:00] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 14:18:00] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 14:18:00] 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-24 14:18:01] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 14:19:17] UPDATE pbxsetting SET lastupdatetimestamp='1579846757' WHERE PBXPid=1 [2020-01-24 14:19:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579846747 [2020-01-24 14:19:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579846757,`PBXCuid`=1579846757 [2020-01-24 14:24:17] UPDATE pbxsetting SET lastupdatetimestamp='1579847057' WHERE PBXPid=1 [2020-01-24 14:24:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579847047 [2020-01-24 14:24:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579847057,`PBXCuid`=1579847057 [2020-01-24 14:29:17] UPDATE pbxsetting SET lastupdatetimestamp='1579847357' WHERE PBXPid=1 [2020-01-24 14:29:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579847347 [2020-01-24 14:29:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579847357,`PBXCuid`=1579847357 [2020-01-24 14:34:17] UPDATE pbxsetting SET lastupdatetimestamp='1579847657' WHERE PBXPid=1 [2020-01-24 14:34:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579847647 [2020-01-24 14:34:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579847657,`PBXCuid`=1579847657 [2020-01-24 14:39:17] UPDATE pbxsetting SET lastupdatetimestamp='1579847957' WHERE PBXPid=1 [2020-01-24 14:39:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579847947 [2020-01-24 14:39:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579847957,`PBXCuid`=1579847957 [2020-01-24 14:44:17] UPDATE pbxsetting SET lastupdatetimestamp='1579848257' WHERE PBXPid=1 [2020-01-24 14:44:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579848247 [2020-01-24 14:44:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579848257,`PBXCuid`=1579848257 [2020-01-24 14:49:17] UPDATE pbxsetting SET lastupdatetimestamp='1579848557' WHERE PBXPid=1 [2020-01-24 14:49:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579848547 [2020-01-24 14:49:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579848557,`PBXCuid`=1579848557 [2020-01-24 14:49:58] UPDATE sales SET lastlogindate='2020-01-24 14:49:58' WHERE Sid='95' LIMIT 1 [2020-01-24 14:49:58] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 14:49:59] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 14:49:59] 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-24 14:49:59] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 14:49:59] 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-24 14:50:00] 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-24 14:50:01] UPDATE sales SET lastlogindate='2020-01-24 14:50:01' WHERE Sid='95' LIMIT 1 [2020-01-24 14:50:01] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 14:50:01] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 14:50:01] 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-24 14:50:01] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 14:50:02] 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-24 14:50:02] 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-24 14:50:11] UPDATE sales SET lastlogindate='2020-01-24 14:50:11' WHERE Sid='95' LIMIT 1 [2020-01-24 14:50:11] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-01-24 14:50:11] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-01-24 14:50: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-24 14:50:12] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-01-24 14:50:12] 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-24 14:50:12] 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-24 14:54:17] UPDATE pbxsetting SET lastupdatetimestamp='1579848857' WHERE PBXPid=1 [2020-01-24 14:54:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579848847 [2020-01-24 14:54:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579848857,`PBXCuid`=1579848857 [2020-01-24 14:59:17] UPDATE pbxsetting SET lastupdatetimestamp='1579849157' WHERE PBXPid=1 [2020-01-24 14:59:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579849147 [2020-01-24 14:59:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579849157,`PBXCuid`=1579849157 [2020-01-24 15:04:17] UPDATE pbxsetting SET lastupdatetimestamp='1579849457' WHERE PBXPid=1 [2020-01-24 15:04:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579849447 [2020-01-24 15:04:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579849457,`PBXCuid`=1579849457 [2020-01-24 15:06:24] INSERT INTO adminlog ( `logintime`, `id`, `ip`, `status`, `type` ) VALUES ( NOW(), '1', '119.247.228.39', '9', '2' ) [2020-01-24 15:06:24] UPDATE sales SET logined=2 WHERE Sid='1' LIMIT 1 [2020-01-24 15:09:17] UPDATE pbxsetting SET lastupdatetimestamp='1579849757' WHERE PBXPid=1 [2020-01-24 15:09:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1579849747 [2020-01-24 15:09:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1579849757,`PBXCuid`=1579849757