

========================2018-03-29 10:17:10======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = HANDO 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 60F677E1B3E776D7F1ED 
sCDKey = 173379187341 
sName = HANDO 
========================2018-03-29 10:17: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 = '173379187341' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2018-03-29 10:17:10======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'hando77'  
========================2018-03-29 10:17:10======================== 
SELECT idx FROM macs WHERE mac_addr = '60F677E1B3E776D7F1ED' AND app_code = '039' 
========================2018-03-29 10:17:10======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '238712' 
========================2018-03-29 10:17:10======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '238712' 
========================2018-03-29 10:17:10======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '238712', '60F677E1B3E776D7F1ED', '039', 'HANDO', '110', '1920', '1080', 'hando77', '한도교역[한도교역]', '173379187341'  ) 


========================2018-03-29 11:18:06======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name =  
parm_os_type = 110 
parm_screen_w = 1600 
parm_screen_h = 900 
parm_user_mac = F44D304EC66F2265D712 
sCDKey = 089395851318 
sName = 1 
========================2018-03-29 11:18:06======================== 
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 = '089395851318' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2018-03-29 11:18:06======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'hak79'  
========================2018-03-29 11:18:06======================== 
SELECT idx FROM macs WHERE mac_addr = 'F44D304EC66F2265D712' AND app_code = '039' 
========================2018-03-29 11:18:06======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '237409' 
========================2018-03-29 11:18:06======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '237409' 
========================2018-03-29 11:18:06======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '237409', 'F44D304EC66F2265D712', '039', '1', '110', '1600', '900', 'hak79', '[이봉학1]', '089395851318'  ) 


========================2018-03-29 11:52:17======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = HANDO 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 98838981F74D76D7F1ED 
sCDKey = 173379187341 
sName = HANDO 
========================2018-03-29 11:52: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 = '173379187341' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2018-03-29 11:52:17======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'hando77'  
========================2018-03-29 11:52:17======================== 
SELECT idx FROM macs WHERE mac_addr = '98838981F74D76D7F1ED' AND app_code = '039' 
========================2018-03-29 11:52:17======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '235354' 
========================2018-03-29 11:52:17======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '235354' 
========================2018-03-29 11:52:17======================== 
UPDATE mac_detail SET  pc_name = 'HANDO', os_type = '110', user_id = 'hando77', user_name = '한도교역[한도교역]',
												 screen_w = '1920', screen_h = '1080', cdkey = '173379187341'
								  WHERE mac_idx = '235354'  


========================2018-03-29 13:25:50======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = USER-PC 
parm_os_type = 90 
parm_screen_w = 1680 
parm_screen_h = 1050 
parm_user_mac = 001966FE70E150723526 
sCDKey = 549176813222 
sName = USER-PC 
========================2018-03-29 13:25:50======================== 
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 = '549176813222' 
			AND r.app_code = '039'
			AND r.app_block = 0 


========================2018-03-29 13:26:21======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = USER-PC 
parm_os_type = 90 
parm_screen_w = 1680 
parm_screen_h = 1050 
parm_user_mac = 001966FE70E150723526 
sCDKey = 549176813222 
sName = USER-PC 
========================2018-03-29 13:26: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 = '549176813222' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2018-03-29 13:26:21======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'js1212'  
========================2018-03-29 13:26:21======================== 
SELECT idx FROM macs WHERE mac_addr = '001966FE70E150723526' AND app_code = '039' 
========================2018-03-29 13:26:21======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '115186' 
========================2018-03-29 13:26:21======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '115186' 
========================2018-03-29 13:26:21======================== 
UPDATE mac_detail SET  pc_name = 'USER-PC', os_type = '90', user_id = 'js1212', user_name = '정성테크[김길례]',
												 screen_w = '1680', screen_h = '1050', cdkey = '549176813222'
								  WHERE mac_idx = '115186'  


========================2018-03-29 13:26:27======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = USER-PC 
parm_os_type = 90 
parm_screen_w = 1680 
parm_screen_h = 1050 
parm_user_mac = 001966FE70E150723526 
sCDKey = 549176813222 
sName = USER-PC 
========================2018-03-29 13:26:27======================== 
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 = '549176813222' 
			AND r.app_code = '039'
			AND r.app_block = 0 


========================2018-03-29 14:19:40======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = LAPTOP-KNTJPMQT 
parm_os_type = 110 
parm_screen_w = 1536 
parm_screen_h = 864 
parm_user_mac = 5800E324935AFCAF2D34 
sCDKey = 205303618682 
sName = LAPTOP-KNTJPMQT 
========================2018-03-29 14:19: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 = '205303618682' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2018-03-29 14:19:40======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'sk95227'  
========================2018-03-29 14:19:40======================== 
SELECT idx FROM macs WHERE mac_addr = '5800E324935AFCAF2D34' AND app_code = '039' 
========================2018-03-29 14:19:40======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '229767' 
========================2018-03-29 14:19:40======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '229767' 
========================2018-03-29 14:19:40======================== 
UPDATE mac_detail SET  pc_name = 'LAPTOP-KNTJPMQT', os_type = '110', user_id = 'sk95227', user_name = '에스케이(sk)커버링[남인선]',
												 screen_w = '1536', screen_h = '864', cdkey = '205303618682'
								  WHERE mac_idx = '229767'  


========================2018-03-29 14:19:48======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = LAPTOP-KNTJPMQT 
parm_os_type = 110 
parm_screen_w = 1536 
parm_screen_h = 864 
parm_user_mac = 5800E324935AFCAF2D34 
sCDKey = 205303618682 
sName = LAPTOP-KNTJPMQT 
========================2018-03-29 14:19:48======================== 
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 = '205303618682' 
			AND r.app_code = '039'
			AND r.app_block = 0 


========================2018-03-29 20:36:14======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = DESKTOP-S8EA3M6 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 909F3309C73FA6E0D61D 
sCDKey = 921252470168 
sName = DESKTOP-S8EA3M6 
========================2018-03-29 20:36: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 = '921252470168' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2018-03-29 20:36:14======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'cherhomes'  
========================2018-03-29 20:36:14======================== 
SELECT idx FROM macs WHERE mac_addr = '909F3309C73FA6E0D61D' AND app_code = '046' 
========================2018-03-29 20:36:14======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '222179' 
========================2018-03-29 20:36:14======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '222179' 
========================2018-03-29 20:36:14======================== 
UPDATE mac_detail SET  pc_name = 'DESKTOP-S8EA3M6', os_type = '110', user_id = 'cherhomes', user_name = '쉐르홈즈[최화별]',
												 screen_w = '1920', screen_h = '1080', cdkey = '921252470168'
								  WHERE mac_idx = '222179'