========================2018-10-11 10:29:22======================== noteurl_start parm_app_code = 047 parm_pc_name = USER-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 50AF732D157E0A41C65F sCDKey = 120563833396 sName = USER-PC ========================2018-10-11 10:29:22======================== 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 = '120563833396' AND r.app_code = '047' AND r.app_block = 0 ========================2018-10-11 10:29:22======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'cozycos' ========================2018-10-11 10:29:22======================== SELECT idx FROM macs WHERE mac_addr = '50AF732D157E0A41C65F' AND app_code = '047' ========================2018-10-11 10:29:22======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '262068' ========================2018-10-11 10:29:22======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '262068' ========================2018-10-11 10:29:22======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '262068', '50AF732D157E0A41C65F', '047', 'USER-PC', '�쐢�룄�슦 7', '0', '0', 'cozycos', '(주)코지코스메틱[오현석]', '120563833396' ) ========================2018-10-11 10:35:50======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-HNB0KO3 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C2779F63ACB59B42 sCDKey = 329246619432 sName = DESKTOP-HNB0KO3 ========================2018-10-11 10:35:50======================== 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 = '329246619432' AND r.app_code = '046' AND r.app_block = 0 ========================2018-10-11 10:35:50======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jasminb' ========================2018-10-11 10:35:50======================== SELECT idx FROM macs WHERE mac_addr = '7085C2779F63ACB59B42' AND app_code = '046' ========================2018-10-11 10:35:50======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '262070' ========================2018-10-11 10:35:50======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '262070' ========================2018-10-11 10:35:50======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '262070', '7085C2779F63ACB59B42', '046', 'DESKTOP-HNB0KO3', '110', '1920', '1080', 'jasminb', '곤지암공구프라자[박요셉]', '329246619432' ) ========================2018-10-11 14:04:34======================== noteurl_start parm_app_code = 039 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 002454923BC1883AEBA4 sCDKey = 533767975538 sName = USER-PC ========================2018-10-11 14:04:34======================== 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 = '533767975538' AND r.app_code = '039' AND r.app_block = 0 ========================2018-10-11 14:04:34======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'cjw0727' ========================2018-10-11 14:04:34======================== SELECT idx FROM macs WHERE mac_addr = '002454923BC1883AEBA4' AND app_code = '039' ========================2018-10-11 14:04:34======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '255216' ========================2018-10-11 14:04:34======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '255216' ========================2018-10-11 14:04:34======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '255216', '002454923BC1883AEBA4', '039', 'USER-PC', '90', '1600', '900', 'cjw0727', '명성테크[최성남]', '533767975538' ) ========================2018-10-11 16:00:20======================== noteurl_start parm_app_code = 046 parm_pc_name = POS parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 00E0B4148F58B2DBC6B6 sCDKey = 469845315448 sName = 놀부펫마트 ========================2018-10-11 16:00: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 = '469845315448' AND r.app_code = '046' AND r.app_block = 0 ========================2018-10-11 16:00:20======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jjjk3003' ========================2018-10-11 16:00:20======================== SELECT idx FROM macs WHERE mac_addr = '00E0B4148F58B2DBC6B6' AND app_code = '046' ========================2018-10-11 16:00:20======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '248848' ========================2018-10-11 16:00:20======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '248848' ========================2018-10-11 16:00:20======================== UPDATE mac_detail SET pc_name = '놀부펫마트', os_type = '90', user_id = 'jjjk3003', user_name = '제이엔씨유통(j&c)[전경철]', screen_w = '1024', screen_h = '768', cdkey = '469845315448' WHERE mac_idx = '248848' ========================2018-10-11 16:13:41======================== noteurl_start parm_app_code = 046 parm_pc_name = OKPOS parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B8975A8D10E6ECDC7146 sCDKey = 469845315448 sName = OKPOS ========================2018-10-11 16:13:41======================== 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 = '469845315448' AND r.app_code = '046' AND r.app_block = 0 ========================2018-10-11 16:13:41======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jjjk3003' ========================2018-10-11 16:13:41======================== SELECT idx FROM macs WHERE mac_addr = 'B8975A8D10E6ECDC7146' AND app_code = '046' ========================2018-10-11 16:13:41======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '262112' ========================2018-10-11 16:13:41======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '262112' ========================2018-10-11 16:13:41======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '262112', 'B8975A8D10E6ECDC7146', '046', 'OKPOS', '90', '1024', '768', 'jjjk3003', '제이엔씨유통(j&c)[전경철]', '469845315448' ) ========================2018-10-11 17:19:26======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-UD6SF4E parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 309C23637E2CD67A1ED7 sCDKey = 868114698301 sName = DESKTOP-UD6SF4E ========================2018-10-11 17:19:26======================== 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 = '868114698301' AND r.app_code = '039' AND r.app_block = 0 ========================2018-10-11 17:19:26======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'easy8833' ========================2018-10-11 17:19:26======================== SELECT idx FROM macs WHERE mac_addr = '309C23637E2CD67A1ED7' AND app_code = '039' ========================2018-10-11 17:19:26======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '262123' ========================2018-10-11 17:19:26======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '262123' ========================2018-10-11 17:19:26======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '262123', '309C23637E2CD67A1ED7', '039', 'DESKTOP-UD6SF4E', '110', '1600', '900', 'easy8833', '이지렌탈[김영모]', '868114698301' )