========================2018-03-13 09:31:55======================== noteurl_start parm_app_code = 039 parm_pc_name = CHOI-PC parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = DCA9711D900C70F9AA64 sCDKey = 566106175278 sName = CHOI-PC ========================2018-03-13 09:31:55======================== 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 = '566106175278' AND r.app_code = '039' AND r.app_block = 0 ========================2018-03-13 09:31:55======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'choi6042' ========================2018-03-13 09:31:55======================== SELECT idx FROM macs WHERE mac_addr = 'DCA9711D900C70F9AA64' AND app_code = '039' ========================2018-03-13 09:31:55======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '179883' ========================2018-03-13 09:31:55======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '179883' ========================2018-03-13 09:31:55======================== UPDATE mac_detail SET pc_name = 'CHOI-PC', os_type = '90', user_id = 'choi6042', user_name = '삼흥상사[최정현]', screen_w = '1366', screen_h = '768', cdkey = '566106175278' WHERE mac_idx = '179883' ========================2018-03-13 11:36:20======================== noteurl_start parm_app_code = 039 parm_pc_name = 아라유통 parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 54E1ADE8FA98265114FA sCDKey = 834930034290 sName = 아라유통 ========================2018-03-13 11:36:20======================== 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 = '834930034290' AND r.app_code = '039' AND r.app_block = 0 ========================2018-03-13 11:36:20======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'mirmelove' ========================2018-03-13 11:36:20======================== SELECT idx FROM macs WHERE mac_addr = '54E1ADE8FA98265114FA' AND app_code = '039' ========================2018-03-13 11:36:20======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '244315' ========================2018-03-13 11:36:20======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '244315' ========================2018-03-13 11:36:20======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '244315', '54E1ADE8FA98265114FA', '039', '아라유통', '110', '1536', '864', 'mirmelove', '아라유통[김윤식]', '834930034290' ) ========================2018-03-13 13:59:36======================== noteurl_start parm_app_code = 039 parm_pc_name = parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 3C528259547B7EFDF124 sCDKey = 416793959069 sName = 비에스푸드 ========================2018-03-13 13:59:36======================== 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 = '416793959069' AND r.app_code = '039' AND r.app_block = 0 ========================2018-03-13 13:59:46======================== noteurl_start parm_app_code = 039 parm_pc_name = parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 3C528259547B7EFDF124 sCDKey = 416793959069 sName = 비에스푸드 ========================2018-03-13 13:59:46======================== 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 = '416793959069' AND r.app_code = '039' AND r.app_block = 0 ========================2018-03-13 13:59:46======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bsfood' ========================2018-03-13 13:59:46======================== SELECT idx FROM macs WHERE mac_addr = '3C528259547B7EFDF124' AND app_code = '039' ========================2018-03-13 13:59:46======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '244352' ========================2018-03-13 13:59:46======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '244352' ========================2018-03-13 13:59:46======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '244352', '3C528259547B7EFDF124', '039', '비에스푸드', '110', '1920', '1080', 'bsfood', '비에스푸드[구희주]', '416793959069' ) ========================2018-03-13 15:35:09======================== noteurl_start parm_app_code = 039 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D0509977338D58BC59ED sCDKey = 130237735661 sName = USER-PC ========================2018-03-13 15:35:09======================== 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 = '130237735661' AND r.app_code = '039' AND r.app_block = 0 ========================2018-03-13 16:19:19======================== noteurl_start parm_app_code = 039 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1440 parm_screen_h = 900 parm_user_mac = 305A3A5654827CE21186 sCDKey = 866376021069 sName = USER-PC ========================2018-03-13 16:19: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 = '866376021069' AND r.app_code = '039' AND r.app_block = 0 ========================2018-03-13 16:19:19======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hswt7296' ========================2018-03-13 16:19:19======================== SELECT idx FROM macs WHERE mac_addr = '305A3A5654827CE21186' AND app_code = '039' ========================2018-03-13 16:19:19======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '244367' ========================2018-03-13 16:19:19======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '244367' ========================2018-03-13 16:19:19======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '244367', '305A3A5654827CE21186', '039', 'USER-PC', '90', '1440', '900', 'hswt7296', '한성물수건[정방완]', '866376021069' )