========================2018-07-11 09:55:46======================== noteurl_start parm_app_code = 039 parm_pc_name = WIN7-20180623YT parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 54880E7FF19C82AD0C12 sCDKey = 291728851301 sName = WIN7-20180623YT ========================2018-07-11 09:55: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 = '291728851301' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-11 09:55:46======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'anayamy0418' ========================2018-07-11 09:55:46======================== SELECT idx FROM macs WHERE mac_addr = '54880E7FF19C82AD0C12' AND app_code = '039' ========================2018-07-11 09:55:46======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '254301' ========================2018-07-11 09:55:46======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '254301' ========================2018-07-11 09:55: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 ( '254301', '54880E7FF19C82AD0C12', '039', 'WIN7-20180623YT', '90', '1366', '768', 'anayamy0418', '주식회사 에센스[황명하]', '291728851301' ) ========================2018-07-11 09:55:57======================== noteurl_start parm_app_code = 039 parm_pc_name = WIN7-20180623YT parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 54880E7FF19C82AD0C12 sCDKey = 291728851301 sName = WIN7-20180623YT ========================2018-07-11 09:55:57======================== 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 = '291728851301' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-11 09:56:08======================== noteurl_start parm_app_code = 039 parm_pc_name = WIN7-20180623YT parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 54880E7FF19C82AD0C12 sCDKey = 291728851301 sName = 에센스2 ========================2018-07-11 09:56:08======================== 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 = '291728851301' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-11 15:06:38======================== noteurl_start parm_app_code = 046 parm_pc_name = 매장-POS2 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 24F5AAD30388B815AD40 sCDKey = 034322302191 sName = 매장-POS2 ========================2018-07-11 15:06:38======================== 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 = '034322302191' AND r.app_code = '046' AND r.app_block = 0 ========================2018-07-11 15:06:38======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yujung6852' ========================2018-07-11 15:06:38======================== SELECT idx FROM macs WHERE mac_addr = '24F5AAD30388B815AD40' AND app_code = '046' ========================2018-07-11 15:06:38======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '254337' ========================2018-07-11 15:06:38======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '254337' ========================2018-07-11 15:06:38======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '254337', '24F5AAD30388B815AD40', '046', '매장-POS2', '110', '1920', '1080', 'yujung6852', '(주)유정배관[윤경환]', '034322302191' ) ========================2018-07-11 15:28:45======================== noteurl_start parm_app_code = 039 parm_pc_name = OWNER11-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 90E6BA8BC2B486960B2B sCDKey = 761891735689 sName = OWNER11-PC ========================2018-07-11 15:28:45======================== 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 = '761891735689' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-11 15:28:45======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kjht5077' ========================2018-07-11 15:28:45======================== SELECT idx FROM macs WHERE mac_addr = '90E6BA8BC2B486960B2B' AND app_code = '039' ========================2018-07-11 15:28:45======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '254338' ========================2018-07-11 15:28:45======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '254338' ========================2018-07-11 15:28:45======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '254338', '90E6BA8BC2B486960B2B', '039', 'OWNER11-PC', '90', '1920', '1080', 'kjht5077', '금진열처리[김가영]', '761891735689' )