========================2018-12-21 10:12:23======================== noteurl_start parm_app_code = 039 parm_pc_name = VIP-PC parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 1C1B0DF70EBF669639DB sCDKey = 564286598646 sName = VIP-PC ========================2018-12-21 10:12:23======================== 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 = '564286598646' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-21 10:12:56======================== noteurl_start parm_app_code = 039 parm_pc_name = VIP-PC parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 1C1B0DF70EBF669639DB sCDKey = 564286598646 sName = VIP-PC ========================2018-12-21 10:12:56======================== 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 = '564286598646' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-21 10:12:56======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'khg7454' ========================2018-12-21 10:12:56======================== SELECT idx FROM macs WHERE mac_addr = '1C1B0DF70EBF669639DB' AND app_code = '039' ========================2018-12-21 10:12:56======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '231402' ========================2018-12-21 10:12:56======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '231402' ========================2018-12-21 10:12:56======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '231402', '1C1B0DF70EBF669639DB', '039', 'VIP-PC', '90', '1680', '1050', 'khg7454', '우림정밀[김해권]', '564286598646' ) ========================2018-12-21 16:25:05======================== noteurl_start parm_app_code = 046 parm_pc_name = MAIN-PC parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 1C1B0D2B1D31865631CD sCDKey = 616636429020 sName = MAIN-PC ========================2018-12-21 16:25:05======================== 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 = '616636429020' AND r.app_code = '046' AND r.app_block = 0 ========================2018-12-21 16:25:05======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'qkdxo200' ========================2018-12-21 16:25:05======================== SELECT idx FROM macs WHERE mac_addr = '1C1B0D2B1D31865631CD' AND app_code = '046' ========================2018-12-21 16:25:05======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '271572' ========================2018-12-21 16:25:05======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '271572' ========================2018-12-21 16:25:05======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '271572', '1C1B0D2B1D31865631CD', '046', 'MAIN-PC', '90', '1024', '768', 'qkdxo200', '성도유통[방휘대]', '616636429020' ) ========================2018-12-21 16:25:19======================== noteurl_start parm_app_code = 046 parm_pc_name = MAIN-PC parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 1C1B0D2B1D31865631CD sCDKey = 616636429020 sName = MAIN-PC ========================2018-12-21 16:25:19======================== 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 = '616636429020' AND r.app_code = '046' AND r.app_block = 0 ========================2018-12-21 17:24:25======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-501EC1S parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = BC5FF49C41C9A0C6349D sCDKey = 757959864664 sName = DESKTOP-501EC1S ========================2018-12-21 17:24:25======================== 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 = '757959864664' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-21 17:24:25======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kdle64' ========================2018-12-21 17:24:25======================== SELECT idx FROM macs WHERE mac_addr = 'BC5FF49C41C9A0C6349D' AND app_code = '039' ========================2018-12-21 17:24:25======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '271510' ========================2018-12-21 17:24:25======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '271510' ========================2018-12-21 17:24:25======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '271510', 'BC5FF49C41C9A0C6349D', '039', 'DESKTOP-501EC1S', '110', '1920', '1080', 'kdle64', '성진산업[이갑동]', '757959864664' ) ========================2018-12-21 17:24:27======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-501EC1S parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = BC5FF49C41C9A0C6349D sCDKey = 757959864664 sName = DESKTOP-501EC1S ========================2018-12-21 17:24:27======================== 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 = '757959864664' AND r.app_code = '039' AND r.app_block = 0