========================2024-04-12 10:02:14======================== noteurl_start parm_app_code = 051 parm_pc_name = GA parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F8A2D65EE1059470A302 sCDKey = 378736978806 sName = GA ========================2024-04-12 10:02:14======================== 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 = '378736978806' AND r.app_code = '051' AND r.app_block = 0 ========================2024-04-12 10:02:14======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bdirect1' ========================2024-04-12 10:02:14======================== SELECT idx FROM macs WHERE mac_addr = 'F8A2D65EE1059470A302' AND app_code = '051' ========================2024-04-12 10:02:14======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '383839' ========================2024-04-12 10:02:14======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '383839' ========================2024-04-12 10:02:14======================== UPDATE mac_detail SET pc_name = 'GA', os_type = '109', user_id = 'bdirect1', user_name = '부동산다이렉트[김준영]', screen_w = '1920', screen_h = '1080', cdkey = '378736978806' WHERE mac_idx = '383839' ========================2024-04-12 10:04:25======================== noteurl_start parm_app_code = 051 parm_pc_name = GA공용 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = A85E456E209A4609EE86 sCDKey = 378736978806 sName = GA공용 ========================2024-04-12 10:04: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 = '378736978806' AND r.app_code = '051' AND r.app_block = 0 ========================2024-04-12 10:04:25======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bdirect1' ========================2024-04-12 10:04:25======================== SELECT idx FROM macs WHERE mac_addr = 'A85E456E209A4609EE86' AND app_code = '051' ========================2024-04-12 10:04:25======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '403926' ========================2024-04-12 10:04:25======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '403926' ========================2024-04-12 10:04:25======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '403926', 'A85E456E209A4609EE86', '051', 'GA공용', '109', '1920', '1080', 'bdirect1', '부동산다이렉트[김준영]', '378736978806' ) ========================2024-04-12 14:12:31======================== noteurl_start parm_app_code = 051 parm_pc_name = 이예지 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 9C6B0003FDA02C684B18 sCDKey = 016598783996 sName = 이예지 ========================2024-04-12 14:12: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 = '016598783996' AND r.app_code = '051' AND r.app_block = 0 ========================2024-04-12 14:12:31======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'meatbank' ========================2024-04-12 14:12:31======================== SELECT idx FROM macs WHERE mac_addr = '9C6B0003FDA02C684B18' AND app_code = '051' ========================2024-04-12 14:12:31======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '403942' ========================2024-04-12 14:12:31======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '403942' ========================2024-04-12 14:12: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 ( '403942', '9C6B0003FDA02C684B18', '051', '이예지', '109', '1920', '1080', 'meatbank', '(주)미트뱅크[미트뱅크]', '016598783996' ) ========================2024-04-12 14:52:56======================== noteurl_start parm_app_code = 048 parm_pc_name = HP000 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 047C16B4C3C13E3000AF sCDKey = 017001527824 sName = HP000 ========================2024-04-12 14:52: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 = '017001527824' AND r.app_code = '048' AND r.app_block = 0 ========================2024-04-12 14:52:56======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yeses' ========================2024-04-12 14:52:56======================== SELECT idx FROM macs WHERE mac_addr = '047C16B4C3C13E3000AF' AND app_code = '048' ========================2024-04-12 14:52:56======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '403805' ========================2024-04-12 14:52:56======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '403805' ========================2024-04-12 14:52: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 ( '403805', '047C16B4C3C13E3000AF', '048', 'HP000', '�쐢�룄�슦 10', '0', '0', 'yeses', '양념마을[강현열]', '017001527824' )