========================2019-12-11 10:27:22======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = OFFICE-PC 
parm_os_type = 110 
parm_screen_w = 1280 
parm_screen_h = 1024 
parm_user_mac = C83A35C8BE74846BB25F 
sCDKey = 217223037343 
sName = OFFICE-PC 
========================2019-12-11 10:27:22======================== 
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 = '217223037343' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2019-12-11 10:27:22======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'sunjin677'  
========================2019-12-11 10:27:22======================== 
SELECT idx FROM macs WHERE mac_addr = 'C83A35C8BE74846BB25F' AND app_code = '039' 
========================2019-12-11 10:27:22======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '284851' 
========================2019-12-11 10:27:22======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '284851' 
========================2019-12-11 10:27:22======================== 
UPDATE mac_detail SET  pc_name = 'OFFICE-PC', os_type = '110', user_id = 'sunjin677', user_name = '¼±ÁøFS[±èÇüÈñ]',
												 screen_w = '1280', screen_h = '1024', cdkey = '217223037343'
								  WHERE mac_idx = '284851'  



========================2019-12-11 16:10:40======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = ADMIN1912111453 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = C03FD5C030B998CB1A8E 
sCDKey = 990358659035 
sName = ADMIN1912111453 
========================2019-12-11 16:10:40======================== 
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 = '990358659035' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2019-12-11 16:10:40======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'bbs8910'  
========================2019-12-11 16:10:40======================== 
SELECT idx FROM macs WHERE mac_addr = 'C03FD5C030B998CB1A8E' AND app_code = '039' 
========================2019-12-11 16:10:40======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '305121' 
========================2019-12-11 16:10:40======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '305121' 
========================2019-12-11 16:10:40======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '305121', 'C03FD5C030B998CB1A8E', '039', 'ADMIN1912111453', '110', '1920', '1080', 'bbs8910', 'À¸¶ä³ó»ê[¹æº¸½Ä]', '990358659035'  ) 



========================2019-12-11 17:41:38======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-6S1CBU2 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 98838988082C8A3B632C 
sCDKey = 414867616982 
sName = DESKTOP-6S1CBU2 
========================2019-12-11 17:41:38======================== 
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 = '414867616982' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2019-12-11 17:41:38======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'khh0457'  
========================2019-12-11 17:41:38======================== 
SELECT idx FROM macs WHERE mac_addr = '98838988082C8A3B632C' AND app_code = '039' 
========================2019-12-11 17:41:38======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '305139' 
========================2019-12-11 17:41:38======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '305139' 
========================2019-12-11 17:41:38======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '305139', '98838988082C8A3B632C', '039', 'DESKTOP-6S1CBU2', '110', '1920', '1080', 'khh0457', 'µ¿¾ÆƯ¼ö°ø±¸[±èÇöÈ£]', '414867616982'  )