========================2019-01-02 09:34:35======================== noteurl_start parm_app_code = 046 parm_pc_name = N08OCZ93YJCFRUW parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B8975A6F3586F8D6576E sCDKey = 685230340148 sName = N08OCZ93YJCFRUW ========================2019-01-02 09:34: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 = '685230340148' AND r.app_code = '046' AND r.app_block = 0 ========================2019-01-02 09:34:35======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'petclubgj' ========================2019-01-02 09:34:35======================== SELECT idx FROM macs WHERE mac_addr = 'B8975A6F3586F8D6576E' AND app_code = '046' ========================2019-01-02 09:34:35======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '272613' ========================2019-01-02 09:34:35======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '272613' ========================2019-01-02 09:34:35======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '272613', 'B8975A6F3586F8D6576E', '046', 'N08OCZ93YJCFRUW', '64', '1024', '768', 'petclubgj', '펫클럽퍼스트도그[김기은]', '685230340148' ) ========================2019-01-02 09:51:26======================== noteurl_start parm_app_code = 046 parm_pc_name = 김기은-PC parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 94DE8020D863182C1740 sCDKey = 685230340148 sName = 김기은-PC ========================2019-01-02 09:51: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 = '685230340148' AND r.app_code = '046' AND r.app_block = 0 ========================2019-01-02 09:51:26======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'petclubgj' ========================2019-01-02 09:51:26======================== SELECT idx FROM macs WHERE mac_addr = '94DE8020D863182C1740' AND app_code = '046' ========================2019-01-02 09:51:26======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '272618' ========================2019-01-02 09:51:26======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '272618' ========================2019-01-02 09:51: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 ( '272618', '94DE8020D863182C1740', '046', '김기은-PC', '90', '1600', '900', 'petclubgj', '펫클럽퍼스트도그[김기은]', '685230340148' ) ========================2019-01-02 09:55: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 = 00E04C8043BF18482C9D sCDKey = 685230340148 sName = POS ========================2019-01-02 09:55: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 = '685230340148' AND r.app_code = '046' AND r.app_block = 0 ========================2019-01-02 09:56:08======================== 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 = 00E04C8043BF18482C9D sCDKey = 685230340148 sName = POS ========================2019-01-02 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 = '685230340148' AND r.app_code = '046' AND r.app_block = 0 ========================2019-01-02 10:11:08======================== 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 = 00E04C8043BF18482C9D sCDKey = 685230340148 sName = POS ========================2019-01-02 10:11: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 = '685230340148' AND r.app_code = '046' AND r.app_block = 0 ========================2019-01-02 10:11:08======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'petclubgj' ========================2019-01-02 10:11:08======================== SELECT idx FROM macs WHERE mac_addr = '00E04C8043BF18482C9D' AND app_code = '046' ========================2019-01-02 10:11:08======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '272620' ========================2019-01-02 10:11:08======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '272620' ========================2019-01-02 10:11:08======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '272620', '00E04C8043BF18482C9D', '046', 'POS', '64', '1024', '768', 'petclubgj', '펫클럽퍼스트도그[김기은]', '685230340148' ) ========================2019-01-02 11:52:06======================== noteurl_start parm_app_code = 039 parm_pc_name = 고평주유소-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 408D5C26D0491258D349 sCDKey = 110810768510 sName = 고평주유소-PC ========================2019-01-02 11:52:06======================== 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 = '110810768510' AND r.app_code = '039' AND r.app_block = 0 ========================2019-01-02 11:52:06======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'pack121234' ========================2019-01-02 11:52:06======================== SELECT idx FROM macs WHERE mac_addr = '408D5C26D0491258D349' AND app_code = '039' ========================2019-01-02 11:52:06======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '272643' ========================2019-01-02 11:52:06======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '272643' ========================2019-01-02 11:52:06======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '272643', '408D5C26D0491258D349', '039', '고평주유소-PC', '90', '1920', '1080', 'pack121234', '고평주유소[박종백]', '110810768510' ) ========================2019-01-02 15:52:25======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-GKFQA7V parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 7085C2A11C133814916B sCDKey = 854512780616 sName = DESKTOP-GKFQA7V ========================2019-01-02 15:52:25======================== 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 = '854512780616' AND r.app_code = '047' AND r.app_block = 0 ========================2019-01-02 15:52:25======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'goodboy216' ========================2019-01-02 15:52:25======================== SELECT idx FROM macs WHERE mac_addr = '7085C2A11C133814916B' AND app_code = '047' ========================2019-01-02 15:52:25======================== 값이 없을 경우 ========================2019-01-02 16:05:54======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-GKFQA7V parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 7085C2A11C133814916B sCDKey = 854512780616 sName = DESKTOP-GKFQA7V ========================2019-01-02 16:05:54======================== 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 = '854512780616' AND r.app_code = '047' AND r.app_block = 0 ========================2019-01-02 16:05:54======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'goodboy216' ========================2019-01-02 16:05:54======================== SELECT idx FROM macs WHERE mac_addr = '7085C2A11C133814916B' AND app_code = '047' ========================2019-01-02 16:05:54======================== 값이 없을 경우 ========================2019-01-02 16:14:59======================== noteurl_start parm_app_code = 046 parm_pc_name = PPPO parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 2025644DE4F7FC43E251 sCDKey = 853814887082 sName = PPPO ========================2019-01-02 16:14:59======================== 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 = '853814887082' AND r.app_code = '046' AND r.app_block = 0 ========================2019-01-02 16:14:59======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yagumall' ========================2019-01-02 16:14:59======================== SELECT idx FROM macs WHERE mac_addr = '2025644DE4F7FC43E251' AND app_code = '046' ========================2019-01-02 16:14:59======================== 값이 없을 경우 ========================2019-01-02 16:15:26======================== noteurl_start parm_app_code = 046 parm_pc_name = PPPO parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 2025644DE4F7FC43E251 sCDKey = 853814887082 sName = PPPO ========================2019-01-02 16:15: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 = '853814887082' AND r.app_code = '046' AND r.app_block = 0 ========================2019-01-02 16:15:26======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yagumall' ========================2019-01-02 16:15:26======================== SELECT idx FROM macs WHERE mac_addr = '2025644DE4F7FC43E251' AND app_code = '046' ========================2019-01-02 16:15:26======================== 값이 없을 경우 ========================2019-01-02 16:16:58======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-GKFQA7V parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 7085C2A11C133814916B sCDKey = 854512780616 sName = DESKTOP-GKFQA7V ========================2019-01-02 16:16:58======================== 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 = '854512780616' AND r.app_code = '047' AND r.app_block = 0 ========================2019-01-02 16:16:58======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'goodboy216' ========================2019-01-02 16:16:58======================== SELECT idx FROM macs WHERE mac_addr = '7085C2A11C133814916B' AND app_code = '047' ========================2019-01-02 16:16:58======================== 값이 없을 경우 ========================2019-01-02 16:21:05======================== noteurl_start parm_app_code = 046 parm_pc_name = PPPO parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 2025644DE4F7FC43E251 sCDKey = 853814887082 sName = PPPO ========================2019-01-02 16:21:05======================== 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 = '853814887082' AND r.app_code = '046' AND r.app_block = 0 ========================2019-01-02 16:21:05======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yagumall' ========================2019-01-02 16:21:05======================== SELECT idx FROM macs WHERE mac_addr = '2025644DE4F7FC43E251' AND app_code = '046' ========================2019-01-02 16:21:05======================== 값이 없을 경우 ========================2019-01-02 16:24:00======================== noteurl_start parm_app_code = 046 parm_pc_name = PPPO parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 2025644DE4F7FC43E251 sCDKey = 230985887958 sName = PPPO ========================2019-01-02 16:24: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 = '230985887958' AND r.app_code = '046' AND r.app_block = 0 ========================2019-01-02 16:24:00======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yagumall' ========================2019-01-02 16:24:00======================== SELECT idx FROM macs WHERE mac_addr = '2025644DE4F7FC43E251' AND app_code = '046' ========================2019-01-02 16:24:00======================== 값이 없을 경우 ========================2019-01-02 16:25:36======================== noteurl_start parm_app_code = 046 parm_pc_name = PPPO parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 2025644DE4F7FC43E251 sCDKey = 230985887958 sName = PPPO ========================2019-01-02 16:25: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 = '230985887958' AND r.app_code = '046' AND r.app_block = 0 ========================2019-01-02 16:25:36======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yagumall' ========================2019-01-02 16:25:36======================== SELECT idx FROM macs WHERE mac_addr = '2025644DE4F7FC43E251' AND app_code = '046' ========================2019-01-02 16:25:36======================== 값이 없을 경우 ========================2019-01-02 16:28:21======================== noteurl_start parm_app_code = 046 parm_pc_name = PPPO parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 2025644DE4F7FC43E251 sCDKey = 230985887958 sName = PPPO ========================2019-01-02 16:28: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 = '230985887958' AND r.app_code = '046' AND r.app_block = 0 ========================2019-01-02 16:28:21======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yagumall' ========================2019-01-02 16:28:21======================== SELECT idx FROM macs WHERE mac_addr = '2025644DE4F7FC43E251' AND app_code = '046' ========================2019-01-02 16:28:21======================== 값이 없을 경우 ========================2019-01-02 16:28:51======================== noteurl_start parm_app_code = 046 parm_pc_name = PPPO parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 2025644DE4F7FC43E251 sCDKey = 230985887958 sName = PPPO ========================2019-01-02 16:28:51======================== 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 = '230985887958' AND r.app_code = '046' AND r.app_block = 0 ========================2019-01-02 16:28:51======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yagumall' ========================2019-01-02 16:28:51======================== SELECT idx FROM macs WHERE mac_addr = '2025644DE4F7FC43E251' AND app_code = '046' ========================2019-01-02 16:28:51======================== 값이 없을 경우