========================2024-04-11 09:44:09======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-RL3RU0G parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 10FFE001B9514235AC21 sCDKey = 342847528630 sName = DESKTOP-RL3RU0G ========================2024-04-11 09:44: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 = '342847528630' AND r.app_code = '039' AND r.app_block = 0 ========================2024-04-11 09:44:09======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'rlacjfals123' ========================2024-04-11 09:44:09======================== SELECT idx FROM macs WHERE mac_addr = '10FFE001B9514235AC21' AND app_code = '039' ========================2024-04-11 09:44:09======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '403844' ========================2024-04-11 09:44:09======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '403844' ========================2024-04-11 09:44: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 ( '403844', '10FFE001B9514235AC21', '039', 'DESKTOP-RL3RU0G', '110', '1920', '1080', 'rlacjfals123', '정철분체[김경식]', '342847528630' ) ========================2024-04-11 09:44:12======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-RL3RU0G parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 10FFE001B9514235AC21 sCDKey = 342847528630 sName = DESKTOP-RL3RU0G ========================2024-04-11 09:44:12======================== 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 = '342847528630' AND r.app_code = '039' AND r.app_block = 0 ========================2024-04-11 13:17:26======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-8CIQFF2 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 64E599FB3E06B4FFE751 sCDKey = 990337893755 sName = TEST ========================2024-04-11 13:17: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 = '990337893755' AND r.app_code = '047' AND r.app_block = 0 ========================2024-04-11 13:17:27======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'adam5352' ========================2024-04-11 13:17:27======================== SELECT idx FROM macs WHERE mac_addr = '64E599FB3E06B4FFE751' AND app_code = '047' ========================2024-04-11 13:17:27======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '384345' ========================2024-04-11 13:17:27======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '384345' ========================2024-04-11 13:17:27======================== UPDATE mac_detail SET pc_name = 'TEST', os_type = '�쐢�룄�슦 10', user_id = 'adam5352', user_name = '다미식품[오상목]', screen_w = '0', screen_h = '0', cdkey = '990337893755' WHERE mac_idx = '384345'