

========================2018-01-29 09:43:51======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = USER-PC 
parm_os_type = 90 
parm_screen_w = 1280 
parm_screen_h = 1024 
parm_user_mac = D05099639B5A24284B7D 
sCDKey = 683237735676 
sName = USER-PC 
========================2018-01-29 09:43:51======================== 
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 = '683237735676' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2018-01-29 09:43:51======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'meae12345'  
========================2018-01-29 09:43:51======================== 
SELECT idx FROM macs WHERE mac_addr = 'D05099639B5A24284B7D' AND app_code = '039' 
========================2018-01-29 09:43:51======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '240569' 
========================2018-01-29 09:43:51======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '240569' 
========================2018-01-29 09:43:51======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '240569', 'D05099639B5A24284B7D', '039', 'USER-PC', '90', '1280', '1024', 'meae12345', '서가네건어물[정미애]', '683237735676'  ) 


========================2018-01-29 10:08:24======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-3HTM40M 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 7085C2439537546A6AD5 
sCDKey = 364202194510 
sName = DESKTOP-3HTM40M 
========================2018-01-29 10:08:24======================== 
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 = '364202194510' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2018-01-29 10:08:24======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'bmkim123'  
========================2018-01-29 10:08:24======================== 
SELECT idx FROM macs WHERE mac_addr = '7085C2439537546A6AD5' AND app_code = '039' 
========================2018-01-29 10:08:24======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '240653' 
========================2018-01-29 10:08:24======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '240653' 
========================2018-01-29 10:08:24======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '240653', '7085C2439537546A6AD5', '039', 'DESKTOP-3HTM40M', '110', '1920', '1080', 'bmkim123', '광우산업[김병민]', '364202194510'  ) 


========================2018-01-29 11:08:37======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-7CR0VE9 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 14C91311F615627461D4 
sCDKey = 826605316014 
sName = DESKTOP-7CR0VE9 
========================2018-01-29 11:08: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 = '826605316014' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2018-01-29 11:08:37======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'y1776073'  
========================2018-01-29 11:08:37======================== 
SELECT idx FROM macs WHERE mac_addr = '14C91311F615627461D4' AND app_code = '039' 
========================2018-01-29 11:08:37======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '224427' 
========================2018-01-29 11:08:37======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '224427' 
========================2018-01-29 11:08:37======================== 
UPDATE mac_detail SET  pc_name = 'DESKTOP-7CR0VE9', os_type = '110', user_id = 'y1776073', user_name = '광자동화[황순영]',
												 screen_w = '1920', screen_h = '1080', cdkey = '826605316014'
								  WHERE mac_idx = '224427'  


========================2018-01-29 13:37:07======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-7CR0VE9 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = E4029B3703D9627461D4 
sCDKey = 826605316014 
sName = DESKTOP-7CR0VE9 
========================2018-01-29 13:37: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 = '826605316014' 
			AND r.app_code = '039'
			AND r.app_block = 0 


========================2018-01-29 13:37:20======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-7CR0VE9 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = E4029B3703D9627461D4 
sCDKey = 826605316014 
sName = DESKTOP-7CR0VE9 
========================2018-01-29 13:37:20======================== 
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 


========================2018-01-29 13:37:42======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-7CR0VE9 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = E4029B3703D9627461D4 
sCDKey = 826605316014 
sName = DESKTOP-7CR0VE9 
========================2018-01-29 13:37:42======================== 
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 


========================2018-01-29 13:38:08======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-7CR0VE9 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = E4029B3703D9627461D4 
sCDKey = 826605316014 
sName = DESKTOP-7CR0VE9 
========================2018-01-29 13:38:08======================== 
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 


========================2018-01-29 13:40:03======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-7CR0VE9 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = E4029B3703D9627461D4 
sCDKey = 826605316014 
sName = DESKTOP-7CR0VE9 
========================2018-01-29 13:40: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 = '826605316014' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2018-01-29 13:40:03======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'y1776073'  
========================2018-01-29 13:40:03======================== 
SELECT idx FROM macs WHERE mac_addr = 'E4029B3703D9627461D4' AND app_code = '039' 
========================2018-01-29 13:40:03======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '195365' 
========================2018-01-29 13:40:03======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '195365' 
========================2018-01-29 13:40:03======================== 
UPDATE mac_detail SET  pc_name = 'DESKTOP-7CR0VE9', os_type = '110', user_id = 'y1776073', user_name = '광자동화[황순영]',
												 screen_w = '1920', screen_h = '1080', cdkey = '826605316014'
								  WHERE mac_idx = '195365'  


========================2018-01-29 15:38:28======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = LGE 
parm_os_type = 110 
parm_screen_w = 1280 
parm_screen_h = 720 
parm_user_mac = 00E091575D98A3A8C23 
sCDKey = 363761528323 
sName = LGE 
========================2018-01-29 15:38:28======================== 
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 = '363761528323' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2018-01-29 15:38:28======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'syu007'  
========================2018-01-29 15:38:28======================== 
SELECT idx FROM macs WHERE mac_addr = '00E091575D98A3A8C23' AND app_code = '039' 
========================2018-01-29 15:38:28======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '238457' 
========================2018-01-29 15:38:28======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '238457' 
========================2018-01-29 15:38:28======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '238457', '00E091575D98A3A8C23', '039', 'LGE', '110', '1280', '720', 'syu007', '직거래농산[이병학]', '363761528323'  ) 


========================2018-01-29 15:51:14======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-2ND8BVU 
parm_os_type = 110 
parm_screen_w = 1024 
parm_screen_h = 768 
parm_user_mac = D05099913950221F7D39 
sCDKey = 977699794202 
sName = DESKTOP-2ND8BVU 
========================2018-01-29 15:51:14======================== 
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 = '977699794202' 
			AND r.app_code = '039'
			AND r.app_block = 0 


========================2018-01-29 15:51:45======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-2ND8BVU 
parm_os_type = 110 
parm_screen_w = 1024 
parm_screen_h = 768 
parm_user_mac = D05099913950221F7D39 
sCDKey = 977699794202 
sName = DESKTOP-2ND8BVU 
========================2018-01-29 15:51:45======================== 
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 = '977699794202' 
			AND r.app_code = '039'
			AND r.app_block = 0 


========================2018-01-29 15:52:13======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-2ND8BVU 
parm_os_type = 110 
parm_screen_w = 1024 
parm_screen_h = 768 
parm_user_mac = D05099913950221F7D39 
sCDKey = 977699794202 
sName = DESKTOP-2ND8BVU 
========================2018-01-29 15:52:13======================== 
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 = '977699794202' 
			AND r.app_code = '039'
			AND r.app_block = 0 


========================2018-01-29 15:53:51======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-2ND8BVU 
parm_os_type = 110 
parm_screen_w = 1024 
parm_screen_h = 768 
parm_user_mac = D05099913950221F7D39 
sCDKey = 977699794202 
sName = DESKTOP-2ND8BVU 
========================2018-01-29 15:53:51======================== 
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 = '977699794202' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2018-01-29 15:53:51======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'stfence2915'  
========================2018-01-29 15:53:51======================== 
SELECT idx FROM macs WHERE mac_addr = 'D05099913950221F7D39' AND app_code = '039' 
========================2018-01-29 15:53:51======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '239907' 
========================2018-01-29 15:53:51======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '239907' 
========================2018-01-29 15:53:51======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '239907', 'D05099913950221F7D39', '039', 'DESKTOP-2ND8BVU', '110', '1024', '768', 'stfence2915', '송탄철망[권동진]', '977699794202'  )