========================2021-10-02 10:33:19======================== noteurl_start parm_app_code = 047 parm_pc_name = °­¸í±Õ parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = B4B6767ACC90221B85DC sCDKey = 3971-3192-46 sName = °­¸í±Õ ========================2021-10-02 10:33:19======================== 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 = '3971319246' AND r.app_code = '047' AND r.app_block = 0 ========================2021-10-02 10:38:41======================== noteurl_start parm_app_code = 047 parm_pc_name = °­¸í±Õ parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = B4B6767ACC90221B85DC sCDKey = 397131924664 sName = °­¸í±Õ ========================2021-10-02 10:38:41======================== 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 = '397131924664' AND r.app_code = '047' AND r.app_block = 0 ========================2021-10-02 10:38:42======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'mooto' ========================2021-10-02 10:38:42======================== SELECT idx FROM macs WHERE mac_addr = 'B4B6767ACC90221B85DC' AND app_code = '047' ========================2021-10-02 10:38:42======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '351938' ========================2021-10-02 10:38:42======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '351938' ========================2021-10-02 10:38:42======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '351938', 'B4B6767ACC90221B85DC', '047', '°­¸í±Õ', '�쐢�룄�슦 10', '0', '0', 'mooto', 'ÄÃó¸ÞÀÌÄ¿[°­¸í±Õ]', '397131924664' )