

========================2020-01-03 09:08:16======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = DESKTOP-6E62R5H 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 24F5AAD303884A94A004 
sCDKey = 034322302191 
sName = DESKTOP-6E62R5H 
========================2020-01-03 09:08: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 = '034322302191' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2020-01-03 09:08:17======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'yujung6852'  
========================2020-01-03 09:08:17======================== 
SELECT idx FROM macs WHERE mac_addr = '24F5AAD303884A94A004' AND app_code = '046' 
========================2020-01-03 09:08:17======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '307015' 
========================2020-01-03 09:08:17======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '307015' 
========================2020-01-03 09:08:17======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '307015', '24F5AAD303884A94A004', '046', 'DESKTOP-6E62R5H', '110', '1920', '1080', 'yujung6852', '(주)유정배관[윤경환]', '034322302191'  ) 


========================2020-01-03 10:43:03======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = A728 
parm_os_type = 90 
parm_screen_w = 1600 
parm_screen_h = 900 
parm_user_mac = 001CC0AC3912125374E9 
sCDKey = 291853185304 
sName = A728 
========================2020-01-03 10:43:03======================== 
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 = '291853185304' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2020-01-03 10:43:03======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'ch11963'  
========================2020-01-03 10:43:03======================== 
SELECT idx FROM macs WHERE mac_addr = '001CC0AC3912125374E9' AND app_code = '039' 
========================2020-01-03 10:43:03======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '158401' 
========================2020-01-03 10:43:03======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '158401' 
========================2020-01-03 10:43:03======================== 
UPDATE mac_detail SET  pc_name = 'A728', os_type = '90', user_id = 'ch11963', user_name = '신창코팅[최완규]',
												 screen_w = '1600', screen_h = '900', cdkey = '291853185304'
								  WHERE mac_idx = '158401'  


========================2020-01-03 10:43:46======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = PC0 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 0492264E8CF286C801C9 
sCDKey = 658835474912 
sName = PC0 
========================2020-01-03 10:43:46======================== 
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 = '658835474912' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2020-01-03 10:43:46======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'ssusung52'  
========================2020-01-03 10:43:46======================== 
SELECT idx FROM macs WHERE mac_addr = '0492264E8CF286C801C9' AND app_code = '039' 
========================2020-01-03 10:43:46======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '307026' 
========================2020-01-03 10:43:46======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '307026' 
========================2020-01-03 10:43:46======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '307026', '0492264E8CF286C801C9', '039', 'PC0', '110', '1920', '1080', 'ssusung52', '수성명판사[이수열]', '658835474912'  ) 


========================2020-01-03 13:19:22======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = LALA2 
parm_os_type = 110 
parm_screen_w = 1680 
parm_screen_h = 1050 
parm_user_mac = D43D7E0D9DEF4E266491 
sCDKey = 469858840605 
sName = LALA2 
========================2020-01-03 13:19: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 = '469858840605' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2020-01-03 13:19:22======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'lalasangsa'  
========================2020-01-03 13:19:22======================== 
SELECT idx FROM macs WHERE mac_addr = 'D43D7E0D9DEF4E266491' AND app_code = '039' 
========================2020-01-03 13:19:22======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '304927' 
========================2020-01-03 13:19:22======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '304927' 
========================2020-01-03 13:19:22======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '304927', 'D43D7E0D9DEF4E266491', '039', 'LALA2', '110', '1680', '1050', 'lalasangsa', '라라상사[나문주]', '469858840605'  ) 


========================2020-01-03 13:19:54======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = LALA2 
parm_os_type = 110 
parm_screen_w = 1680 
parm_screen_h = 1050 
parm_user_mac = D43D7E0D9DEF4E266491 
sCDKey = 469858840605 
sName = LALA2 
========================2020-01-03 13:19: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 = '469858840605' 
			AND r.app_code = '039'
			AND r.app_block = 0 


========================2020-01-03 14:25:15======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-NHLTC2M 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = E0D55E1BC0F6429F9CE6 
sCDKey = 230147408911 
sName = DESKTOP-NHLTC2M 
========================2020-01-03 14:25:15======================== 
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 = '230147408911' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2020-01-03 14:25:15======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'lee8631234'  
========================2020-01-03 14:25:15======================== 
SELECT idx FROM macs WHERE mac_addr = 'E0D55E1BC0F6429F9CE6' AND app_code = '039' 
========================2020-01-03 14:25:15======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '307033' 
========================2020-01-03 14:25:15======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '307033' 
========================2020-01-03 14:25:15======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '307033', 'E0D55E1BC0F6429F9CE6', '039', 'DESKTOP-NHLTC2M', '110', '1920', '1080', 'lee8631234', '형제광고사(주)[이영일]', '230147408911'  ) 


========================2020-01-03 15:03:16======================== 
noteurl_start 
parm_app_code = 045 
parm_pc_name = DESKTOP-1J45DRL 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 1CA0B878EC713E17DBA6 
sCDKey = 729985938957 
sName = DESKTOP-1J45DRL 
========================2020-01-03 15:03: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 = '729985938957' 
			AND r.app_code = '045'
			AND r.app_block = 0 
========================2020-01-03 15:03:16======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'seojinfa'  
========================2020-01-03 15:03:16======================== 
SELECT idx FROM macs WHERE mac_addr = '1CA0B878EC713E17DBA6' AND app_code = '045' 
========================2020-01-03 15:03:16======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '307064' 
========================2020-01-03 15:03:16======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '307064' 
========================2020-01-03 15:03:16======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '307064', '1CA0B878EC713E17DBA6', '045', 'DESKTOP-1J45DRL', '110', '1920', '1080', 'seojinfa', '(주)에스제이하이텍[유학현]', '729985938957'  ) 


========================2020-01-03 15:03:58======================== 
noteurl_start 
parm_app_code = 045 
parm_pc_name = DESKTOP-VR5OLCM 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = E0D55E1BC5C37874D105 
sCDKey = 729985938957 
sName = DESKTOP-VR5OLCM 
========================2020-01-03 15:03:58======================== 
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 = '729985938957' 
			AND r.app_code = '045'
			AND r.app_block = 0 
========================2020-01-03 15:03:58======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'seojinfa'  
========================2020-01-03 15:03:58======================== 
SELECT idx FROM macs WHERE mac_addr = 'E0D55E1BC5C37874D105' AND app_code = '045' 
========================2020-01-03 15:03:58======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '307065' 
========================2020-01-03 15:03:58======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '307065' 
========================2020-01-03 15:03:58======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '307065', 'E0D55E1BC5C37874D105', '045', 'DESKTOP-VR5OLCM', '110', '1920', '1080', 'seojinfa', '(주)에스제이하이텍[유학현]', '729985938957'  )