

========================2022-11-10 11:41:53======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-3B3BG3B 
parm_os_type = 110 
parm_screen_w = 1680 
parm_screen_h = 1050 
parm_user_mac = 18C04D47CD4FC44AB3B5 
sCDKey = 218735525853 
sName = DESKTOP-3B3BG3B 
========================2022-11-10 11:41:53======================== 
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 = '218735525853' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2022-11-10 11:41:53======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'msc4374'  
========================2022-11-10 11:41:53======================== 
SELECT idx FROM macs WHERE mac_addr = '18C04D47CD4FC44AB3B5' AND app_code = '039' 
========================2022-11-10 11:41:53======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '376995' 
========================2022-11-10 11:41:53======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '376995' 
========================2022-11-10 11:41:53======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '376995', '18C04D47CD4FC44AB3B5', '039', 'DESKTOP-3B3BG3B', '110', '1680', '1050', 'msc4374', '명성테크[성호성]', '218735525853'  ) 


========================2022-11-10 11:54:40======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = PC1 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 14DAE9200AE112A481E4 
sCDKey = 109436997008 
sName = PC1 
========================2022-11-10 11:54: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 = '109436997008' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2022-11-10 11:54:40======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'kimlee21'  
========================2022-11-10 11:54:40======================== 
SELECT idx FROM macs WHERE mac_addr = '14DAE9200AE112A481E4' AND app_code = '039' 
========================2022-11-10 11:54:40======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '376997' 
========================2022-11-10 11:54:40======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '376997' 
========================2022-11-10 11:54: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	 ( '376997', '14DAE9200AE112A481E4', '039', 'PC1', '110', '1920', '1080', 'kimlee21', '(주)태봉산업개발[김남국]', '109436997008'  ) 


========================2022-11-10 13:29:56======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-M8F23T8 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = E8039A65C8D9967B5514 
sCDKey = 109436997008 
sName = DESKTOP-M8F23T8 
========================2022-11-10 13:29:56======================== 
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 = '109436997008' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2022-11-10 13:29:56======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'kimlee21'  
========================2022-11-10 13:29:56======================== 
SELECT idx FROM macs WHERE mac_addr = 'E8039A65C8D9967B5514' AND app_code = '039' 
========================2022-11-10 13:29:56======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '323403' 
========================2022-11-10 13:29:56======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '323403' 
========================2022-11-10 13:29:56======================== 
UPDATE mac_detail SET  pc_name = 'DESKTOP-M8F23T8', os_type = '110', user_id = 'kimlee21', user_name = '(주)태봉산업개발[김남국]',
												 screen_w = '1920', screen_h = '1080', cdkey = '109436997008'
								  WHERE mac_idx = '323403'  


========================2022-11-10 18:13:59======================== 
noteurl_start 
parm_app_code = 045 
parm_pc_name = KOREA-PC 
parm_os_type = 90 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 305A3A552210ACE01D42 
sCDKey = 187357958476 
sName = KOREA-PC 
========================2022-11-10 18:13:59======================== 
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 = '187357958476' 
			AND r.app_code = '045'
			AND r.app_block = 0 
========================2022-11-10 18:13:59======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'coonroom'  
========================2022-11-10 18:13:59======================== 
SELECT idx FROM macs WHERE mac_addr = '305A3A552210ACE01D42' AND app_code = '045' 
========================2022-11-10 18:13:59======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '377035' 
========================2022-11-10 18:13:59======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '377035' 
========================2022-11-10 18:13:59======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '377035', '305A3A552210ACE01D42', '045', 'KOREA-PC', '90', '1920', '1080', 'coonroom', '그린펫[곽종민]', '187357958476'  )