========================2024-10-28 14:14:05======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-JNHG83S parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 10BF487D6A8138DC03C0 sCDKey = 262318519570 sName = DESKTOP-JNHG83S ========================2024-10-28 14:14: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 = '262318519570' AND r.app_code = '046' AND r.app_block = 0 ========================2024-10-28 14:14:05======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ssjj0099' ========================2024-10-28 14:14:05======================== SELECT idx FROM macs WHERE mac_addr = '10BF487D6A8138DC03C0' AND app_code = '046' ========================2024-10-28 14:14:05======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '412799' ========================2024-10-28 14:14:05======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '412799' ========================2024-10-28 14:14:05======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '412799', '10BF487D6A8138DC03C0', '046', 'DESKTOP-JNHG83S', '110', '1366', '768', 'ssjj0099', '½ÂÁøÆêÀ¯Åë[À̽ÂÁø]', '262318519570' ) ========================2024-10-28 18:28:18======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-LBG3VEV parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 00C2C6A9178A44F1584F sCDKey = 475623169846 sName = DESKTOP-LBG3VEV ========================2024-10-28 18:28:18======================== 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 = '475623169846' AND r.app_code = '047' AND r.app_block = 0