

========================2019-09-19 09:35:29======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = PJH 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 7085C2B92617DABAE9EC 
sCDKey = 944629376206 
sName = PJH 
========================2019-09-19 09:35:29======================== 
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 = '944629376206' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2019-09-19 09:35:29======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'youi92'  
========================2019-09-19 09:35:29======================== 
SELECT idx FROM macs WHERE mac_addr = '7085C2B92617DABAE9EC' AND app_code = '046' 
========================2019-09-19 09:35:29======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '281354' 
========================2019-09-19 09:35:29======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '281354' 
========================2019-09-19 09:35:29======================== 
UPDATE mac_detail SET  pc_name = 'PJH', os_type = '110', user_id = 'youi92', user_name = '[박주현]',
												 screen_w = '1920', screen_h = '1080', cdkey = '944629376206'
								  WHERE mac_idx = '281354'  


========================2019-09-19 11:43: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 = 94C691FA00D6D258648A 
sCDKey = 204467956951 
sName =  
========================2019-09-19 11:43: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 = '204467956951' 
			AND r.app_code = '050'
			AND r.app_block = 0 


========================2019-09-19 11:44:05======================== 
noteurl_start 
parm_app_code = 050 
parm_pc_name =  
parm_os_type = 109 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 94C691FA00D6D258648A 
sCDKey = 204467956951 
sName = (재)대전평생교육진흥원 
========================2019-09-19 11:44:05======================== 
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 = '204467956951' 
			AND r.app_code = '050'
			AND r.app_block = 0 


========================2019-09-19 11:44:23======================== 
noteurl_start 
parm_app_code = 050 
parm_pc_name =  
parm_os_type = 109 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 94C691FA00D6D258648A 
sCDKey = 204467956951 
sName = (재)대전평생교육진흥원 
========================2019-09-19 11:44: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 = '204467956951' 
			AND r.app_code = '050'
			AND r.app_block = 0 


========================2019-09-19 11:44:26======================== 
noteurl_start 
parm_app_code = 050 
parm_pc_name =  
parm_os_type = 109 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 94C691FA00D6D258648A 
sCDKey = 204467956951 
sName = 대전평생교육진흥원 
========================2019-09-19 11:44:26======================== 
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 = '204467956951' 
			AND r.app_code = '050'
			AND r.app_block = 0 


========================2019-09-19 11:45:16======================== 
noteurl_start 
parm_app_code = 050 
parm_pc_name =  
parm_os_type = 109 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 94C691FA00D6D258648A 
sCDKey = 204467956951 
sName = 대전평생교육진흥원 
========================2019-09-19 11:45: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 = '204467956951' 
			AND r.app_code = '050'
			AND r.app_block = 0 


========================2019-09-19 11:47:45======================== 
noteurl_start 
parm_app_code = 050 
parm_pc_name =  
parm_os_type = 109 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 94C691FA00D6D258648A 
sCDKey = 204467956951 
sName =  
========================2019-09-19 11:47: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 = '204467956951' 
			AND r.app_code = '050'
			AND r.app_block = 0 


========================2019-09-19 11:48:01======================== 
noteurl_start 
parm_app_code = 050 
parm_pc_name =  
parm_os_type = 109 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 94C691FA00D6D258648A 
sCDKey = 204467956951 
sName = (재)대전평생교육진흥원 
========================2019-09-19 11:48:01======================== 
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 = '204467956951' 
			AND r.app_code = '050'
			AND r.app_block = 0 


========================2019-09-19 11:48:10======================== 
noteurl_start 
parm_app_code = 050 
parm_pc_name =  
parm_os_type = 109 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 94C691FA00D6D258648A 
sCDKey = 204467956951 
sName = 이기모 
========================2019-09-19 11:48: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 = '204467956951' 
			AND r.app_code = '050'
			AND r.app_block = 0 


========================2019-09-19 11:49:30======================== 
noteurl_start 
parm_app_code = 050 
parm_pc_name =  
parm_os_type = 109 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 94C691FA00D6D258648A 
sCDKey = 204467956951 
sName =  
========================2019-09-19 11:49:30======================== 
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 = '204467956951' 
			AND r.app_code = '050'
			AND r.app_block = 0 


========================2019-09-19 11:49:39======================== 
noteurl_start 
parm_app_code = 050 
parm_pc_name =  
parm_os_type = 109 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 94C691FA00D6D258648A 
sCDKey = 204467956951 
sName = 대전평생교육진흥원 
========================2019-09-19 11:49:39======================== 
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 = '204467956951' 
			AND r.app_code = '050'
			AND r.app_block = 0 


========================2019-09-19 11:51:40======================== 
noteurl_start 
parm_app_code = 050 
parm_pc_name =  
parm_os_type = 109 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 94C691FA00D6D258648A 
sCDKey = 204467956951 
sName =  
========================2019-09-19 11:51: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 = '204467956951' 
			AND r.app_code = '050'
			AND r.app_block = 0 


========================2019-09-19 13:55:24======================== 
noteurl_start 
parm_app_code = 050 
parm_pc_name =  
parm_os_type = 109 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 94C691FA00D6D258648A 
sCDKey = 204467956951 
sName = (재)대전평생교육진흥원 
========================2019-09-19 13:55: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 = '204467956951' 
			AND r.app_code = '050'
			AND r.app_block = 0 
========================2019-09-19 13:55:24======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'kdsoon0402'  
========================2019-09-19 13:55:24======================== 
SELECT idx FROM macs WHERE mac_addr = '94C691FA00D6D258648A' AND app_code = '050' 
========================2019-09-19 13:55:24======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '297186' 
========================2019-09-19 13:55:24======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '297186' 
========================2019-09-19 13:55: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	 ( '297186', '94C691FA00D6D258648A', '050', '(재)대전평생교육진흥원', '109', '1920', '1080', 'kdsoon0402', '대전평생교육진흥원[대전평생교육진흥원]', '204467956951'  ) 


========================2019-09-19 14:15:37======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = KD82 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 6A3D20524153BCFD2539 
sCDKey = 146845660413 
sName = KD82 
========================2019-09-19 14:15: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 = '146845660413' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2019-09-19 14:15:37======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'kd4052'  
========================2019-09-19 14:15:37======================== 
SELECT idx FROM macs WHERE mac_addr = '6A3D20524153BCFD2539' AND app_code = '039' 
========================2019-09-19 14:15:37======================== 
값이 없을 경우 


========================2019-09-19 14:22:01======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = KD82 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 6A3D20524153BCFD2539 
sCDKey = 146845660413 
sName = KD82 
========================2019-09-19 14:22:01======================== 
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 = '146845660413' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2019-09-19 14:22:01======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'kd4052'  
========================2019-09-19 14:22:01======================== 
SELECT idx FROM macs WHERE mac_addr = '6A3D20524153BCFD2539' AND app_code = '039' 
========================2019-09-19 14:22:01======================== 
값이 없을 경우 


========================2019-09-19 14:37:34======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = AHN-PC 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 80EA205241536033E3EA 
sCDKey = 852815921316 
sName = AHN-PC 
========================2019-09-19 14:37:34======================== 
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 = '852815921316' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2019-09-19 14:37:34======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'aej123456'  
========================2019-09-19 14:37:34======================== 
SELECT idx FROM macs WHERE mac_addr = '80EA205241536033E3EA' AND app_code = '039' 
========================2019-09-19 14:37:34======================== 
값이 없을 경우 


========================2019-09-19 14:37:53======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = AHN-PC 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 80EA205241536033E3EA 
sCDKey = 852815921316 
sName = AHN-PC 
========================2019-09-19 14:37: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 = '852815921316' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2019-09-19 14:37:53======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'aej123456'  
========================2019-09-19 14:37:53======================== 
SELECT idx FROM macs WHERE mac_addr = '80EA205241536033E3EA' AND app_code = '039' 
========================2019-09-19 14:37:53======================== 
값이 없을 경우 


========================2019-09-19 14:42:57======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = AHN-PC 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 80EA205241536033E3EA 
sCDKey = 852815921316 
sName = AHN-PC 
========================2019-09-19 14:42:57======================== 
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 = '852815921316' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2019-09-19 14:42:57======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'aej123456'  
========================2019-09-19 14:42:57======================== 
SELECT idx FROM macs WHERE mac_addr = '80EA205241536033E3EA' AND app_code = '039' 
========================2019-09-19 14:42:57======================== 
값이 없을 경우 


========================2019-09-19 14:46:29======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = AHN-PC 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 38D547280D736033E3EA 
sCDKey = 852815921316 
sName = AHN-PC 
========================2019-09-19 14:46:29======================== 
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 = '852815921316' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2019-09-19 14:46:29======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'aej123456'  
========================2019-09-19 14:46:29======================== 
SELECT idx FROM macs WHERE mac_addr = '38D547280D736033E3EA' AND app_code = '039' 
========================2019-09-19 14:46:29======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '200108' 
========================2019-09-19 14:46:29======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '200108' 
========================2019-09-19 14:46:29======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '200108', '38D547280D736033E3EA', '039', 'AHN-PC', '110', '1920', '1080', 'aej123456', '엠제이소프트[안은준]', '852815921316'  ) 


========================2019-09-19 15:19:46======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = AHN-PC 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 80EA205241536033E3EA 
sCDKey = 852815921316 
sName = AHN-PC 
========================2019-09-19 15: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 = '852815921316' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2019-09-19 15:19:46======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'aej123456'  
========================2019-09-19 15:19:46======================== 
SELECT idx FROM macs WHERE mac_addr = '80EA205241536033E3EA' AND app_code = '039' 
========================2019-09-19 15:19:46======================== 
값이 없을 경우 


========================2019-09-19 15:35:21======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = AHN-PC 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac =  
sCDKey = 852815921316 
sName = AHN-PC 
========================2019-09-19 15:35: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 = '852815921316' 
			AND r.app_code = '039'
			AND r.app_block = 0 


========================2019-09-19 16:34:53======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = IMHG 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = F44D30B9AF0E96D60F97 
sCDKey = 290230002865 
sName = IMHG 
========================2019-09-19 16:34: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 = '290230002865' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2019-09-19 16:34:53======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'lhg88'  
========================2019-09-19 16:34:53======================== 
SELECT idx FROM macs WHERE mac_addr = 'F44D30B9AF0E96D60F97' AND app_code = '039' 
========================2019-09-19 16:34:53======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '221036' 
========================2019-09-19 16:34:53======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '221036' 
========================2019-09-19 16:34:53======================== 
UPDATE mac_detail SET  pc_name = 'IMHG', os_type = '110', user_id = 'lhg88', user_name = '엠제이소프트[임현규]',
												 screen_w = '1920', screen_h = '1080', cdkey = '290230002865'
								  WHERE mac_idx = '221036'  


========================2019-09-19 16:34:59======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = AHN-PC 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 38D547280D736033E3EA 
sCDKey = 852815921316 
sName = AHN-PC 
========================2019-09-19 16:34: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 = '852815921316' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2019-09-19 16:34:59======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'aej123456'  
========================2019-09-19 16:34:59======================== 
SELECT idx FROM macs WHERE mac_addr = '38D547280D736033E3EA' AND app_code = '039' 
========================2019-09-19 16:34:59======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '200108' 
========================2019-09-19 16:34:59======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '200108' 
========================2019-09-19 16:34:59======================== 
UPDATE mac_detail SET  pc_name = 'AHN-PC', os_type = '110', user_id = 'aej123456', user_name = '엠제이소프트[안은준]',
												 screen_w = '1920', screen_h = '1080', cdkey = '852815921316'
								  WHERE mac_idx = '200108'