========================2019-03-06 16:44:11======================== noteurl_start parm_app_code = 045 parm_pc_name = HAPPYMAN-PC parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 88532EC7A39968CAE76F sCDKey = 966376153340 sName = HAPPYMAN-PC ========================2019-03-06 16:44:11======================== 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 = '966376153340' AND r.app_code = '045' AND r.app_block = 0 ========================2019-03-06 16:44:11======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hijaje' ========================2019-03-06 16:44:11======================== SELECT idx FROM macs WHERE mac_addr = '88532EC7A39968CAE76F' AND app_code = '045' ========================2019-03-06 16:44:11======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '279219' ========================2019-03-06 16:44:11======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '279219' ========================2019-03-06 16:44:11======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '279219', '88532EC7A39968CAE76F', '045', 'HAPPYMAN-PC', '110', '1366', '768', 'hijaje', 'ÇåÀÎÀÚÀç[¹Úö±³]', '966376153340' ) ========================2019-03-06 16:44:18======================== noteurl_start parm_app_code = 045 parm_pc_name = HAPPYMAN-PC parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 88532EC7A39968CAE76F sCDKey = 966376153340 sName = HAPPYMAN-PC ========================2019-03-06 16:44: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 = '966376153340' AND r.app_code = '045' AND r.app_block = 0