

========================2018-04-20 09:49:16======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = MSDN-SPECIAL 
parm_os_type = 90 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 28E3476F73484A97C7E2 
sCDKey = 573190698474 
sName = MSDN-SPECIAL 
========================2018-04-20 09:49: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 = '573190698474' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2018-04-20 09:49:16======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'groutmart'  
========================2018-04-20 09:49:16======================== 
SELECT idx FROM macs WHERE mac_addr = '28E3476F73484A97C7E2' AND app_code = '046' 
========================2018-04-20 09:49:16======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '247742' 
========================2018-04-20 09:49:16======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '247742' 
========================2018-04-20 09:49: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	 ( '247742', '28E3476F73484A97C7E2', '046', 'MSDN-SPECIAL', '90', '1920', '1080', 'groutmart', '크린앤네이처[줄눈마트]', '573190698474'  ) 


========================2018-04-20 11:10:12======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = OFFICE1 
parm_os_type = 90 
parm_screen_w = 1600 
parm_screen_h = 900 
parm_user_mac = E0D55E64ABDB44E837C0 
sCDKey = 590563984562 
sName = OFFICE1 
========================2018-04-20 11:10:12======================== 
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 = '590563984562' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2018-04-20 11:10:12======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'rnrwls0726'  
========================2018-04-20 11:10:12======================== 
SELECT idx FROM macs WHERE mac_addr = 'E0D55E64ABDB44E837C0' AND app_code = '039' 
========================2018-04-20 11:10:12======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '247750' 
========================2018-04-20 11:10:12======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '247750' 
========================2018-04-20 11:10:12======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '247750', 'E0D55E64ABDB44E837C0', '039', 'OFFICE1', '90', '1600', '900', 'rnrwls0726', '의성정밀[변국진]', '590563984562'  ) 


========================2018-04-20 11:45:59======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = HYUNPC 
parm_os_type = 110 
parm_screen_w = 1366 
parm_screen_h = 768 
parm_user_mac = 1867B029FE42D02CA63D 
sCDKey = 774078853154 
sName = HYUNPC 
========================2018-04-20 11:45: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 = '774078853154' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2018-04-20 11:45:59======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'ja2126'  
========================2018-04-20 11:45:59======================== 
SELECT idx FROM macs WHERE mac_addr = '1867B029FE42D02CA63D' AND app_code = '039' 
========================2018-04-20 11:45:59======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '127489' 
========================2018-04-20 11:45:59======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '127489' 
========================2018-04-20 11:45:59======================== 
UPDATE mac_detail SET  pc_name = 'HYUNPC', os_type = '110', user_id = 'ja2126', user_name = '형제상사[윤종태]',
												 screen_w = '1366', screen_h = '768', cdkey = '774078853154'
								  WHERE mac_idx = '127489'  


========================2018-04-20 13:06:31======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = USER-PC 
parm_os_type = 90 
parm_screen_w = 1024 
parm_screen_h = 768 
parm_user_mac = 0013775005A46E5B5117 
sCDKey = 755038250550 
sName = USER-PC 
========================2018-04-20 13:06:31======================== 
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 = '755038250550' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2018-04-20 13:06:31======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'skyx012'  
========================2018-04-20 13:06:31======================== 
SELECT idx FROM macs WHERE mac_addr = '0013775005A46E5B5117' AND app_code = '039' 
========================2018-04-20 13:06:31======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '191602' 
========================2018-04-20 13:06:31======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '191602' 
========================2018-04-20 13:06:31======================== 
UPDATE mac_detail SET  pc_name = 'USER-PC', os_type = '90', user_id = 'skyx012', user_name = '정우초경[정현근]',
												 screen_w = '1024', screen_h = '768', cdkey = '755038250550'
								  WHERE mac_idx = '191602'  


========================2018-04-20 15:52:45======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = HOME-PC 
parm_os_type = 90 
parm_screen_w = 1120 
parm_screen_h = 700 
parm_user_mac = 00089FDA9FED761DE99D 
sCDKey = 309587979417 
sName = HOME-PC 
========================2018-04-20 15:52: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 = '309587979417' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2018-04-20 15:52:45======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'king9372'  
========================2018-04-20 15:52:45======================== 
SELECT idx FROM macs WHERE mac_addr = '00089FDA9FED761DE99D' AND app_code = '046' 
========================2018-04-20 15:52:45======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '247782' 
========================2018-04-20 15:52:45======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '247782' 
========================2018-04-20 15:52:45======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '247782', '00089FDA9FED761DE99D', '046', 'HOME-PC', '90', '1120', '700', 'king9372', '부강종합철물[최성진]', '309587979417'  ) 


========================2018-04-20 16:06:19======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-HRITSUI 
parm_os_type = 110 
parm_screen_w = 1600 
parm_screen_h = 900 
parm_user_mac = 681729EAFB73787001E3 
sCDKey = 340789024286 
sName = DESKTOP-HRITSUI 
========================2018-04-20 16:06:19======================== 
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 = '340789024286' 
			AND r.app_code = '039'
			AND r.app_block = 0 


========================2018-04-20 16:06:31======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-HRITSUI 
parm_os_type = 110 
parm_screen_w = 1600 
parm_screen_h = 900 
parm_user_mac = 681729EAFB73787001E3 
sCDKey = 340789024286 
sName = DESKTOP-HRITSUI 
========================2018-04-20 16:06:31======================== 
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 = '340789024286' 
			AND r.app_code = '039'
			AND r.app_block = 0 


========================2018-04-20 16:09:16======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-HRITSUI 
parm_os_type = 110 
parm_screen_w = 1600 
parm_screen_h = 900 
parm_user_mac = 681729EAFB73787001E3 
sCDKey = 340789024286 
sName = DESKTOP-HRITSUI 
========================2018-04-20 16:09: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 = '340789024286' 
			AND r.app_code = '039'
			AND r.app_block = 0 


========================2018-04-20 16:10:41======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-HRITSUI 
parm_os_type = 110 
parm_screen_w = 1600 
parm_screen_h = 900 
parm_user_mac = 681729EAFB73787001E3 
sCDKey = 340789024286 
sName = DESKTOP-HRITSUI 
========================2018-04-20 16:10: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 = '340789024286' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2018-04-20 16:10:41======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'cosmot'  
========================2018-04-20 16:10:41======================== 
SELECT idx FROM macs WHERE mac_addr = '681729EAFB73787001E3' AND app_code = '039' 
========================2018-04-20 16:10:41======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '247783' 
========================2018-04-20 16:10:41======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '247783' 
========================2018-04-20 16:10:41======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '247783', '681729EAFB73787001E3', '039', 'DESKTOP-HRITSUI', '110', '1600', '900', 'cosmot', '코스모과학[조성복]', '340789024286'  ) 


========================2018-04-20 17:15:56======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = USER-PC 
parm_os_type = 90 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = E8039A6DD865221608C1 
sCDKey = 188538452662 
sName = USER-PC 
========================2018-04-20 17:15: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 = '188538452662' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2018-04-20 17:15:56======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'qhtjd4873'  
========================2018-04-20 17:15:56======================== 
SELECT idx FROM macs WHERE mac_addr = 'E8039A6DD865221608C1' AND app_code = '039' 
========================2018-04-20 17:15:56======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '247711' 
========================2018-04-20 17:15:56======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '247711' 
========================2018-04-20 17:15:56======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '247711', 'E8039A6DD865221608C1', '039', 'USER-PC', '90', '1920', '1080', 'qhtjd4873', '주식획사 보성[전인영]', '188538452662'  ) 


========================2018-04-20 17:16:08======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = USER-PC 
parm_os_type = 90 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = E8039A6DD865221608C1 
sCDKey = 188538452662 
sName = USER-PC 
========================2018-04-20 17:16: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 = '188538452662' 
			AND r.app_code = '039'
			AND r.app_block = 0