========================2022-03-11 10:43:25======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-N2VE142 
parm_os_type = 110 
parm_screen_w = 1536 
parm_screen_h = 864 
parm_user_mac = 9883893D71C9AE6A5A2B 
sCDKey = 488871538267 
sName = DESKTOP-N2VE142 
========================2022-03-11 10:43:25======================== 
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 = '488871538267' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2022-03-11 10:43:25======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'sinseungodh'  
========================2022-03-11 10:43:25======================== 
SELECT idx FROM macs WHERE mac_addr = '9883893D71C9AE6A5A2B' AND app_code = '039' 
========================2022-03-11 10:43:25======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '363017' 
========================2022-03-11 10:43:25======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '363017' 
========================2022-03-11 10:43:25======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '363017', '9883893D71C9AE6A5A2B', '039', 'DESKTOP-N2VE142', '110', '1536', '864', 'sinseungodh', '½Å½ÂÁ¤¹Ð[¿Àµ¿È¯]', '488871538267'  ) 



========================2022-03-11 10:49:19======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = DESKTOP-Q1671TK 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = D8BBC119715890C13917 
sCDKey = 936245283016 
sName = DESKTOP-Q1671TK 
========================2022-03-11 10:49: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 = '936245283016' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2022-03-11 10:49:19======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'jeong4023'  
========================2022-03-11 10:49:19======================== 
SELECT idx FROM macs WHERE mac_addr = 'D8BBC119715890C13917' AND app_code = '046' 
========================2022-03-11 10:49:19======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '343680' 
========================2022-03-11 10:49:19======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '343680' 
========================2022-03-11 10:49:19======================== 
UPDATE mac_detail SET  pc_name = 'DESKTOP-Q1671TK', os_type = '110', user_id = 'jeong4023', user_name = '[±èÅÂÁ¤]',
												 screen_w = '1920', screen_h = '1080', cdkey = '936245283016'
								  WHERE mac_idx = '343680'  



========================2022-03-11 14:23:32======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = DESKTOP-BUOHQ3J 
parm_os_type = 110 
parm_screen_w = 1600 
parm_screen_h = 900 
parm_user_mac = 18C04DD7C0E0EA021A19 
sCDKey = 804494015422 
sName = DESKTOP-BUOHQ3J 
========================2022-03-11 14:23:32======================== 
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 = '804494015422' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2022-03-11 14:23:32======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'hansonfood'  
========================2022-03-11 14:23:32======================== 
SELECT idx FROM macs WHERE mac_addr = '18C04DD7C0E0EA021A19' AND app_code = '046' 
========================2022-03-11 14:23:32======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '363075' 
========================2022-03-11 14:23:32======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '363075' 
========================2022-03-11 14:23:32======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '363075', '18C04DD7C0E0EA021A19', '046', 'DESKTOP-BUOHQ3J', '110', '1600', '900', 'hansonfood', 'ÇѼֽÄÇ°[±èÇö½Ä]', '804494015422'  ) 



========================2022-03-11 15:54:10======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = HP-PC 
parm_os_type = 90 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 685D4300A3CA20F2983B 
sCDKey = 007922815942 
sName = HP-PC 
========================2022-03-11 15:54:10======================== 
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 = '007922815942' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2022-03-11 15:54:10======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'woori00834'  
========================2022-03-11 15:54:10======================== 
SELECT idx FROM macs WHERE mac_addr = '685D4300A3CA20F2983B' AND app_code = '039' 
========================2022-03-11 15:54:10======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '282357' 
========================2022-03-11 15:54:10======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '282357' 
========================2022-03-11 15:54:10======================== 
UPDATE mac_detail SET  pc_name = 'HP-PC', os_type = '90', user_id = 'woori00834', user_name = '(ÁÖ)¿ì¸®¹ÌÆ®¾Ø¿¡ÀÌ¡[¹ÚÁø±¹]',
												 screen_w = '1920', screen_h = '1080', cdkey = '007922815942'
								  WHERE mac_idx = '282357'