========================2018-08-07 14:41:18======================== noteurl_start parm_app_code = 046 parm_pc_name = POS parm_os_type = 90 parm_screen_w = 768 parm_screen_h = 768 parm_user_mac = 00E0B4148F58B2DBC6B6 sCDKey = 057134299982 sName = POS ========================2018-08-07 14:41: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 = '057134299982' AND r.app_code = '046' AND r.app_block = 0 ========================2018-08-07 14:41:18======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hello' ========================2018-08-07 14:41:18======================== SELECT idx FROM macs WHERE mac_addr = '00E0B4148F58B2DBC6B6' AND app_code = '046' ========================2018-08-07 14:41:18======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '248848' ========================2018-08-07 14:41:18======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '248848' ========================2018-08-07 14:41:18======================== UPDATE mac_detail SET pc_name = 'POS', os_type = '90', user_id = 'hello', user_name = 'Çï·ÎÆê ½ÅźÁøÁ¡[°­Çü¹¬]', screen_w = '768', screen_h = '768', cdkey = '057134299982' WHERE mac_idx = '248848' ========================2018-08-07 16:07:45======================== noteurl_start parm_app_code = 039 parm_pc_name = ADMIN-PC parm_os_type = 110 parm_screen_w = 1440 parm_screen_h = 900 parm_user_mac = D0509922461ADCF705B0 sCDKey = 657279571543 sName = ADMIN-PC ========================2018-08-07 16:07:45======================== 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 = '657279571543' AND r.app_code = '039' AND r.app_block = 0 ========================2018-08-07 16:07:45======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ksgo0322' ========================2018-08-07 16:07:45======================== SELECT idx FROM macs WHERE mac_addr = 'D0509922461ADCF705B0' AND app_code = '039' ========================2018-08-07 16:07:45======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '256652' ========================2018-08-07 16:07:45======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '256652' ========================2018-08-07 16:07:45======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '256652', 'D0509922461ADCF705B0', '039', 'ADMIN-PC', '110', '1440', '900', 'ksgo0322', '°­Áø±â¾÷[±è»ó±Ù]', '657279571543' )