========================2018-02-03 10:28:35======================== noteurl_start parm_app_code = 046 parm_pc_name = POS parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 7C0507D05857ECB8A99D sCDKey = 131558883381 sName = POS ========================2018-02-03 10:28:35======================== 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 = '131558883381' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-03 10:28:35======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'luckypet12' ========================2018-02-03 10:28:35======================== SELECT idx FROM macs WHERE mac_addr = '7C0507D05857ECB8A99D' AND app_code = '046' ========================2018-02-03 10:28:35======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '234629' ========================2018-02-03 10:28:35======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '234629' ========================2018-02-03 10:28:35======================== UPDATE mac_detail SET pc_name = 'POS', os_type = '64', user_id = 'luckypet12', user_name = '럭키펫(태릉점)[박채희]', screen_w = '1024', screen_h = '768', cdkey = '131558883381' WHERE mac_idx = '234629' ========================2018-02-03 13:20:21======================== noteurl_start parm_app_code = 046 parm_pc_name = A6 parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = EC55F95F559166E860A9 sCDKey = 187009624545 sName = A6 ========================2018-02-03 13:20:21======================== 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 = '187009624545' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-03 14:51:31======================== noteurl_start parm_app_code = 046 parm_pc_name = A6 parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = EC55F95F559166E860A9 sCDKey = 187009624545 sName = A6 ========================2018-02-03 14:51: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 = '187009624545' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-03 15:53:56======================== noteurl_start parm_app_code = 046 parm_pc_name = A6 parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = EC55F95F559166E860A9 sCDKey = 187009624545 sName = A6 ========================2018-02-03 15:53:56======================== 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 = '187009624545' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-03 15:53:56======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'luckype53' ========================2018-02-03 15:53:56======================== SELECT idx FROM macs WHERE mac_addr = 'EC55F95F559166E860A9' AND app_code = '046' ========================2018-02-03 15:53:56======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '241232' ========================2018-02-03 15:53:56======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '241232' ========================2018-02-03 15:53:56======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '241232', 'EC55F95F559166E860A9', '046', 'A6', '90', '1366', '768', 'luckype53', '(주)럭키펫유통[박영원]', '187009624545' ) ========================2018-02-03 17:09:45======================== noteurl_start parm_app_code = 046 parm_pc_name = A6 parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = EC55F95F559166E860A9 sCDKey = 187009624545 sName = A6 ========================2018-02-03 17:09: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 = '187009624545' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-03 17:12:15======================== noteurl_start parm_app_code = 046 parm_pc_name = A6 parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = EC55F95F559166E860A9 sCDKey = 187009624545 sName = A6 ========================2018-02-03 17:12:15======================== 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 = '187009624545' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-03 17:12:15======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'luckype53' ========================2018-02-03 17:12:15======================== SELECT idx FROM macs WHERE mac_addr = 'EC55F95F559166E860A9' AND app_code = '046' ========================2018-02-03 17:12:15======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '241232' ========================2018-02-03 17:12:15======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '241232' ========================2018-02-03 17:12:15======================== UPDATE mac_detail SET pc_name = 'A6', os_type = '90', user_id = 'luckype53', user_name = '(주)럭키펫유통[박영원]', screen_w = '1366', screen_h = '768', cdkey = '187009624545' WHERE mac_idx = '241232' ========================2018-02-03 17:45:36======================== noteurl_start parm_app_code = 046 parm_pc_name = MY-PC parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 40F02FA352BA82DEC8E9 sCDKey = 187009624545 sName = MY-PC ========================2018-02-03 17:45: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 = '187009624545' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-03 17:45:36======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'luckype53' ========================2018-02-03 17:45:36======================== SELECT idx FROM macs WHERE mac_addr = '40F02FA352BA82DEC8E9' AND app_code = '046' ========================2018-02-03 17:45:36======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '241248' ========================2018-02-03 17:45:36======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '241248' ========================2018-02-03 17:45:36======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '241248', '40F02FA352BA82DEC8E9', '046', 'MY-PC', '90', '1366', '768', 'luckype53', '(주)럭키펫유통[박영원]', '187009624545' )