========================2019-04-26 14:31:00======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-7LTKEIO parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 94B86D3D20DEA4C8380 sCDKey = 243564489238 sName = DESKTOP-7LTKEIO ========================2019-04-26 14:31:00======================== 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 = '243564489238' AND r.app_code = '039' AND r.app_block = 0 ========================2019-04-26 14:31:00======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'chf943' ========================2019-04-26 14:31:00======================== SELECT idx FROM macs WHERE mac_addr = '94B86D3D20DEA4C8380' AND app_code = '039' ========================2019-04-26 14:31:00======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '282017' ========================2019-04-26 14:31:00======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '282017' ========================2019-04-26 14:31:00======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '282017', '94B86D3D20DEA4C8380', '039', 'DESKTOP-7LTKEIO', '110', '1920', '1080', 'chf943', '완도청해포구주식회사[이율]', '243564489238' ) ========================2019-04-26 14:39:18======================== noteurl_start parm_app_code = 039 parm_pc_name = NAMJOONLEE parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 24F5AAE1AC65BEB99ACA sCDKey = 120532180445 sName = NAMJOONLEE ========================2019-04-26 14:39:18======================== 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 = '120532180445' AND r.app_code = '039' AND r.app_block = 0 ========================2019-04-26 14:39:18======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'elimjeonbok' ========================2019-04-26 14:39:18======================== SELECT idx FROM macs WHERE mac_addr = '24F5AAE1AC65BEB99ACA' AND app_code = '039' ========================2019-04-26 14:39:18======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '208486' ========================2019-04-26 14:39:18======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '208486' ========================2019-04-26 14:39:18======================== UPDATE mac_detail SET pc_name = 'NAMJOONLEE', os_type = '110', user_id = 'elimjeonbok', user_name = '엘림수산영어조합법인[이남준]', screen_w = '1920', screen_h = '1080', cdkey = '120532180445' WHERE mac_idx = '208486' ========================2019-04-26 17:12:10======================== noteurl_start parm_app_code = 045 parm_pc_name = DONGMING parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1200 parm_user_mac = 448A5BF6FCD4945CEED5 sCDKey = 457889227889 sName = DONGMING ========================2019-04-26 17:12:10======================== 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 = '457889227889' AND r.app_code = '045' AND r.app_block = 0 ========================2019-04-26 17:12:10======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dongming9868' ========================2019-04-26 17:12:10======================== SELECT idx FROM macs WHERE mac_addr = '448A5BF6FCD4945CEED5' AND app_code = '045' ========================2019-04-26 17:12:10======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '221280' ========================2019-04-26 17:12:10======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '221280' ========================2019-04-26 17:12:10======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '221280', '448A5BF6FCD4945CEED5', '045', 'DONGMING', '110', '1920', '1200', 'dongming9868', '동명마트[해매란]', '457889227889' ) ========================2019-04-26 17:12:17======================== noteurl_start parm_app_code = 045 parm_pc_name = DONGMING parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1200 parm_user_mac = 448A5BF6FCD4945CEED5 sCDKey = 457889227889 sName = DONGMING ========================2019-04-26 17:12:17======================== 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 = '457889227889' AND r.app_code = '045' AND r.app_block = 0 ========================2019-04-26 17:12:29======================== noteurl_start parm_app_code = 045 parm_pc_name = DONGMING parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1200 parm_user_mac = 448A5BF6FCD4945CEED5 sCDKey = 457889227889 sName = DONGMING ========================2019-04-26 17:12:29======================== 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 = '457889227889' AND r.app_code = '045' AND r.app_block = 0 ========================2019-04-26 17:48:28======================== noteurl_start parm_app_code = 046 parm_pc_name = APDR0TZGCPUDVDY parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 00190F0F073E815922C sCDKey = 834962125925 sName = 2층매장 ========================2019-04-26 17:48:28======================== 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 = '834962125925' AND r.app_code = '046' AND r.app_block = 0 ========================2019-04-26 17:48:28======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ericaan' ========================2019-04-26 17:48:28======================== SELECT idx FROM macs WHERE mac_addr = '00190F0F073E815922C' AND app_code = '046' ========================2019-04-26 17:48:28======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '273188' ========================2019-04-26 17:48:28======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '273188' ========================2019-04-26 17:48:28======================== UPDATE mac_detail SET pc_name = '2층매장', os_type = '64', user_id = 'ericaan', user_name = '주식회사 메종드파리[안진현]', screen_w = '1024', screen_h = '768', cdkey = '834962125925' WHERE mac_idx = '273188'