========================2022-09-15 13:52:39======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = USERMIC-5RLP9D7 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 581122A7FFC462CA0AF0 
sCDKey = 826605316014 
sName = USERMIC-5RLP9D7 
========================2022-09-15 13:52:39======================== 
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 = '826605316014' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2022-09-15 13:52:40======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'y1776073'  
========================2022-09-15 13:52:40======================== 
SELECT idx FROM macs WHERE mac_addr = '581122A7FFC462CA0AF0' AND app_code = '039' 
========================2022-09-15 13:52:40======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '373598' 
========================2022-09-15 13:52:40======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '373598' 
========================2022-09-15 13:52: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	 ( '373598', '581122A7FFC462CA0AF0', '039', 'USERMIC-5RLP9D7', '110', '1920', '1080', 'y1776073', '±¤ÀÚµ¿È­[Ȳ¼ø¿µ]', '826605316014'  ) 



========================2022-09-15 15:32:54======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-62A12QV 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 047C16136A052A3331AE 
sCDKey = 009449452592 
sName = DESKTOP-62A12QV 
========================2022-09-15 15:32:54======================== 
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 = '009449452592' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2022-09-15 15:32:54======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'lll2824'  
========================2022-09-15 15:32:55======================== 
SELECT idx FROM macs WHERE mac_addr = '047C16136A052A3331AE' AND app_code = '039' 
========================2022-09-15 15:32:55======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '373601' 
========================2022-09-15 15:32:55======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '373601' 
========================2022-09-15 15:32:55======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '373601', '047C16136A052A3331AE', '039', 'DESKTOP-62A12QV', '110', '1920', '1080', 'lll2824', '°¡Èï°ø¾÷»ç[ÀÌÀç°ü]', '009449452592'  ) 



========================2022-09-15 15:44:16======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = EASY-M 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 68545ACD1A2CA49B380B 
sCDKey = 378087224489 
sName = EASY-M 
========================2022-09-15 15:44:16======================== 
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 = '378087224489' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2022-09-15 15:44:16======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'jyounger72'  
========================2022-09-15 15:44:16======================== 
SELECT idx FROM macs WHERE mac_addr = '68545ACD1A2CA49B380B' AND app_code = '039' 
========================2022-09-15 15:44:16======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '339435' 
========================2022-09-15 15:44:16======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '339435' 
========================2022-09-15 15:44:16======================== 
UPDATE mac_detail SET  pc_name = 'EASY-M', os_type = '110', user_id = 'jyounger72', user_name = 'Easy-M[ÀÌÁ¦¿µ]',
												 screen_w = '1920', screen_h = '1080', cdkey = '378087224489'
								  WHERE mac_idx = '339435'  



========================2022-09-15 15:44:30======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = EASY-M 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 68545ACD1A2CA49B380B 
sCDKey = 378087224489 
sName = EASY-M 
========================2022-09-15 15:44:30======================== 
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 = '378087224489' 
			AND r.app_code = '039'
			AND r.app_block = 0 



========================2022-09-15 15:44:37======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = EASY-M 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 68545ACD1A2CA49B380B 
sCDKey = 378087224489 
sName = EASY-M 
========================2022-09-15 15:44:37======================== 
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 = '378087224489' 
			AND r.app_code = '039'
			AND r.app_block = 0