

========================2019-12-18 10:04:02======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = SEAIKARUS 
parm_os_type = 110 
parm_screen_w = 1366 
parm_screen_h = 768 
parm_user_mac = 988389204906480CB7A6 
sCDKey = 985125381266 
sName = SEAIKARUS 
========================2019-12-18 10:04:02======================== 
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 = '985125381266' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2019-12-18 10:04:02======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'seaikarus'  
========================2019-12-18 10:04:02======================== 
SELECT idx FROM macs WHERE mac_addr = '988389204906480CB7A6' AND app_code = '039' 
========================2019-12-18 10:04:02======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '301680' 
========================2019-12-18 10:04:02======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '301680' 
========================2019-12-18 10:04:02======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '301680', '988389204906480CB7A6', '039', 'SEAIKARUS', '110', '1366', '768', 'seaikarus', '신일복사[윤상혁]', '985125381266'  ) 


========================2019-12-18 10:20:07======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = LG 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 00E09129ADC7F4A41E29 
sCDKey = 205663637872 
sName = LG 
========================2019-12-18 10:20:07======================== 
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 = '205663637872' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2019-12-18 10:20:07======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'ltg1020'  
========================2019-12-18 10:20:07======================== 
SELECT idx FROM macs WHERE mac_addr = '00E09129ADC7F4A41E29' AND app_code = '039' 
========================2019-12-18 10:20:07======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '123051' 
========================2019-12-18 10:20:07======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '123051' 
========================2019-12-18 10:20:07======================== 
UPDATE mac_detail SET  pc_name = 'LG', os_type = '110', user_id = 'ltg1020', user_name = '유강산업사[이태곤]',
												 screen_w = '1920', screen_h = '1080', cdkey = '205663637872'
								  WHERE mac_idx = '123051'  


========================2019-12-18 11:18:56======================== 
noteurl_start 
parm_app_code = 050 
parm_pc_name =  
parm_os_type = 109 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 50B7C3A64E5C24FF0903 
sCDKey = 922590601683 
sName = 경상북도환경연수원 
========================2019-12-18 11:18: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 = '922590601683' 
			AND r.app_code = '050'
			AND r.app_block = 0 


========================2019-12-18 11:19:46======================== 
noteurl_start 
parm_app_code = 050 
parm_pc_name =  
parm_os_type = 109 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 50B7C3A64E5C24FF0903 
sCDKey = 922590601683 
sName = 경상북도환경연수원 
========================2019-12-18 11:19: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 = '922590601683' 
			AND r.app_code = '050'
			AND r.app_block = 0 


========================2019-12-18 11:24:41======================== 
noteurl_start 
parm_app_code = 050 
parm_pc_name =  
parm_os_type = 109 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 50B7C3A64E5C24FF0903 
sCDKey = 922590601683 
sName = 경상북도환경연수원 
========================2019-12-18 11:24:41======================== 
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 = '922590601683' 
			AND r.app_code = '050'
			AND r.app_block = 0 


========================2019-12-18 11:24:53======================== 
noteurl_start 
parm_app_code = 050 
parm_pc_name =  
parm_os_type = 109 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 50B7C3A64E5C24FF0903 
sCDKey = 922590601683 
sName = 경상북도환경연수원 
========================2019-12-18 11:24: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 = '922590601683' 
			AND r.app_code = '050'
			AND r.app_block = 0 
========================2019-12-18 11:24:53======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'iicooii'  
========================2019-12-18 11:24:53======================== 
SELECT idx FROM macs WHERE mac_addr = '50B7C3A64E5C24FF0903' AND app_code = '050' 
========================2019-12-18 11:24:53======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '305420' 
========================2019-12-18 11:24:53======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '305420' 
========================2019-12-18 11:24: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	 ( '305420', '50B7C3A64E5C24FF0903', '050', '경상북도환경연수원', '109', '1920', '1080', 'iicooii', '경상북도환경연수원[이진숙]', '922590601683'  ) 


========================2019-12-18 16:34:17======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = USER1912-PC 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 14DAE9EC5F994F8461D6 
sCDKey = 553029866173 
sName = USER1912-PC 
========================2019-12-18 16:34:17======================== 
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 = '553029866173' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2019-12-18 16:34:17======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'kyong6431'  
========================2019-12-18 16:34:17======================== 
SELECT idx FROM macs WHERE mac_addr = '14DAE9EC5F994F8461D6' AND app_code = '039' 
========================2019-12-18 16:34:17======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '305800' 
========================2019-12-18 16:34:17======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '305800' 
========================2019-12-18 16:34: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	 ( '305800', '14DAE9EC5F994F8461D6', '039', 'USER1912-PC', '110', '1920', '1080', 'kyong6431', '부산철물공구[문경용]', '553029866173'  ) 


========================2019-12-18 18:40:43======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = LAPTOP-BSCUUDF3 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 3C5282EEE42A7C19CB8F 
sCDKey = 854361852591 
sName = LAPTOP-BSCUUDF3 
========================2019-12-18 18:40:43======================== 
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 = '854361852591' 
			AND r.app_code = '046'
			AND r.app_block = 0 


========================2019-12-18 22:25:21======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = J-HP 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = E0699542D069DAACED67 
sCDKey = 473894409706 
sName = J-HP 
========================2019-12-18 22:25:21======================== 
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 = '473894409706' 
			AND r.app_code = '039'
			AND r.app_block = 0 


========================2019-12-18 22:25:49======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = J-HP 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = E0699542D069DAACED67 
sCDKey = 584905510807 
sName = J 
========================2019-12-18 22:25:49======================== 
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 = '584905510807' 
			AND r.app_code = '039'
			AND r.app_block = 0 


========================2019-12-18 22:26:23======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = J-HP 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = E0699542D069DAACED67 
sCDKey = 584905510806 
sName = J 
========================2019-12-18 22:26:23======================== 
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 = '584905510806' 
			AND r.app_code = '039'
			AND r.app_block = 0