========================2020-11-05 09:47:14======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-935CTST parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 2CF05D0E11ECAE06586A sCDKey = 013684412034 sName = DESKTOP-935CTST ========================2020-11-05 09:47:14======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '013684412034' AND r.app_code = '039' AND r.app_block = 0 ========================2020-11-05 09:47:14======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ysd114' ========================2020-11-05 09:47:14======================== SELECT idx FROM macs WHERE mac_addr = '2CF05D0E11ECAE06586A' AND app_code = '039' ========================2020-11-05 09:47:14======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '327227' ========================2020-11-05 09:47:14======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '327227' ========================2020-11-05 09:47:14======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '327227', '2CF05D0E11ECAE06586A', '039', 'DESKTOP-935CTST', '110', '1920', '1080', 'ysd114', '케이스푸드[권용우]', '013684412034' ) ========================2020-11-05 11:45:54======================== noteurl_start parm_app_code = 046 parm_pc_name = VIP-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D05099A28254F4EB1D67 sCDKey = 475639642848 sName = VIP-PC ========================2020-11-05 11:45:54======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '475639642848' AND r.app_code = '046' AND r.app_block = 0 ========================2020-11-05 11:45:54======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sharon' ========================2020-11-05 11:45:54======================== SELECT idx FROM macs WHERE mac_addr = 'D05099A28254F4EB1D67' AND app_code = '046' ========================2020-11-05 11:45:54======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '329468' ========================2020-11-05 11:45:54======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '329468' ========================2020-11-05 11:45:54======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '329468', 'D05099A28254F4EB1D67', '046', 'VIP-PC', '90', '1920', '1080', 'sharon', '샤론플라워랜드[김보필]', '475639642848' ) ========================2020-11-05 13:12:22======================== noteurl_start parm_app_code = 046 parm_pc_name = VIP-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 909F330A2CDFF4EB1D67 sCDKey = 475639642848 sName = VIP-PC ========================2020-11-05 13:12:22======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '475639642848' AND r.app_code = '046' AND r.app_block = 0 ========================2020-11-05 13:35:50======================== noteurl_start parm_app_code = 046 parm_pc_name = VIP-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 909F330A2CDFF4EB1D67 sCDKey = 475639642848 sName = VIP-PC ========================2020-11-05 13:35:50======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '475639642848' AND r.app_code = '046' AND r.app_block = 0 ========================2020-11-05 13:35:50======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sharon' ========================2020-11-05 13:35:50======================== SELECT idx FROM macs WHERE mac_addr = '909F330A2CDFF4EB1D67' AND app_code = '046' ========================2020-11-05 13:35:50======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '329476' ========================2020-11-05 13:35:50======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '329476' ========================2020-11-05 13:35:50======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '329476', '909F330A2CDFF4EB1D67', '046', 'VIP-PC', '90', '1920', '1080', 'sharon', '샤론플라워랜드[김보필]', '475639642848' ) ========================2020-11-05 15:53:54======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-LJQO782 parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 00241DC7C3B7AE4355F sCDKey = 658488852655 sName = DESKTOP-LJQO782 ========================2020-11-05 15:53:54======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '658488852655' AND r.app_code = '039' AND r.app_block = 0 ========================2020-11-05 15:53:54======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'qhtjd' ========================2020-11-05 15:53:54======================== SELECT idx FROM macs WHERE mac_addr = '00241DC7C3B7AE4355F' AND app_code = '039' ========================2020-11-05 15:53:54======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '329493' ========================2020-11-05 15:53:54======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '329493' ========================2020-11-05 15:53:54======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '329493', '00241DC7C3B7AE4355F', '039', 'DESKTOP-LJQO782', '110', '1680', '1050', 'qhtjd', '보성금속[강동희]', '658488852655' )