========================2018-10-08 13:41:46======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-GNL4B0B parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 24F5AAAC73CD26AD0554 sCDKey = 978196107728 sName = DESKTOP-GNL4B0B ========================2018-10-08 13:41: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 = '978196107728' AND r.app_code = '039' AND r.app_block = 0 ========================2018-10-08 13:41:46======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bs358' ========================2018-10-08 13:41:46======================== SELECT idx FROM macs WHERE mac_addr = '24F5AAAC73CD26AD0554' AND app_code = '039' ========================2018-10-08 13:41:46======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '125699' ========================2018-10-08 13:41:46======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '125699' ========================2018-10-08 13:41:46======================== UPDATE mac_detail SET pc_name = 'DESKTOP-GNL4B0B', os_type = '110', user_id = 'bs358', user_name = '영도스프링공업사[부산지사]', screen_w = '1920', screen_h = '1080', cdkey = '978196107728' WHERE mac_idx = '125699' ========================2018-10-08 13:50:44======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-9GBFKGR parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = E8393533549A88DE81E9 sCDKey = 995043238263 sName = DESKTOP-9GBFKGR ========================2018-10-08 13:50:44======================== 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 = '995043238263' AND r.app_code = '046' AND r.app_block = 0 ========================2018-10-08 13:50:44======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hizoner' ========================2018-10-08 13:50:44======================== SELECT idx FROM macs WHERE mac_addr = 'E8393533549A88DE81E9' AND app_code = '046' ========================2018-10-08 13:50:44======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '261816' ========================2018-10-08 13:50:44======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '261816' ========================2018-10-08 13:50:44======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '261816', 'E8393533549A88DE81E9', '046', 'DESKTOP-9GBFKGR', '110', '1680', '1050', 'hizoner', '다판다원주점[최영수]', '995043238263' ) ========================2018-10-08 14:16:31======================== noteurl_start parm_app_code = 047 parm_pc_name = TITAN-S260 parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F4B52008D12720A240CA sCDKey = 959922622472 sName = TITAN-S260 ========================2018-10-08 14:16:31======================== 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 = '959922622472' AND r.app_code = '047' AND r.app_block = 0 ========================2018-10-08 14:16:31======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sunk16' ========================2018-10-08 14:16:31======================== SELECT idx FROM macs WHERE mac_addr = 'F4B52008D12720A240CA' AND app_code = '047' ========================2018-10-08 14:16:31======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '261822' ========================2018-10-08 14:16:31======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '261822' ========================2018-10-08 14:16:31======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '261822', 'F4B52008D12720A240CA', '047', 'TITAN-S260', '�쐢�룄�슦 7', '0', '0', 'sunk16', '보일러백화점[허주현]', '959922622472' ) ========================2018-10-08 15:19:46======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-7FLD8LC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C27127B7B6422621 sCDKey = 491956787512 sName = DESKTOP-7FLD8LC ========================2018-10-08 15:19: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 = '491956787512' AND r.app_code = '046' AND r.app_block = 0 ========================2018-10-08 15:19:46======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'alzzane' ========================2018-10-08 15:19:46======================== SELECT idx FROM macs WHERE mac_addr = '7085C27127B7B6422621' AND app_code = '046' ========================2018-10-08 15:19:46======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '261832' ========================2018-10-08 15:19:46======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '261832' ========================2018-10-08 15:19: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 ( '261832', '7085C27127B7B6422621', '046', 'DESKTOP-7FLD8LC', '110', '1920', '1080', 'alzzane', '(주)창원케미칼[이은석]', '491956787512' )