========================2023-05-10 11:23:27======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-GHTP11R parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 50AF734183C30EEF09AE sCDKey = 709642917325 sName = 아펙사G포스장비 ========================2023-05-10 11:23:27======================== 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 = '709642917325' AND r.app_code = '047' AND r.app_block = 0 ========================2023-05-10 11:23:27======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'pscm0211' ========================2023-05-10 11:23:27======================== SELECT idx FROM macs WHERE mac_addr = '50AF734183C30EEF09AE' AND app_code = '047' ========================2023-05-10 11:23:27======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '387554' ========================2023-05-10 11:23:27======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '387554' ========================2023-05-10 11:23:27======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '387554', '50AF734183C30EEF09AE', '047', '아펙사G포스장비', '�쐢�룄�슦 10', '0', '0', 'pscm0211', '풍성상사[하헌주]', '709642917325' ) ========================2023-05-10 14:47:09======================== noteurl_start parm_app_code = 039 parm_pc_name = 보성PC parm_os_type = 110 parm_screen_w = 2560 parm_screen_h = 1080 parm_user_mac = A036BC2AE55C2C0B1BB5 sCDKey = 658488852655 sName = 보성PC ========================2023-05-10 14:47:09======================== 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 = '658488852655' AND r.app_code = '039' AND r.app_block = 0 ========================2023-05-10 14:47:09======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'qhtjd' ========================2023-05-10 14:47:09======================== SELECT idx FROM macs WHERE mac_addr = 'A036BC2AE55C2C0B1BB5' AND app_code = '039' ========================2023-05-10 14:47:09======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '387570' ========================2023-05-10 14:47:09======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '387570' ========================2023-05-10 14:47:09======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '387570', 'A036BC2AE55C2C0B1BB5', '039', '보성PC', '110', '2560', '1080', 'qhtjd', '보성금속[강동희]', '658488852655' )