

========================2020-08-03 00:47:31======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-9G3EH35 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 98E743CD8CA3D4E44486 
sCDKey = 422114683375 
sName = DESKTOP-9G3EH35 
========================2020-08-03 00:47: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 = '422114683375' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2020-08-03 00:47:31======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'id4love'  
========================2020-08-03 00:47:31======================== 
SELECT idx FROM macs WHERE mac_addr = '98E743CD8CA3D4E44486' AND app_code = '039' 
========================2020-08-03 00:47:31======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '323188' 
========================2020-08-03 00:47:31======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '323188' 
========================2020-08-03 00:47:31======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '323188', '98E743CD8CA3D4E44486', '039', 'DESKTOP-9G3EH35', '110', '1920', '1080', 'id4love', '파란컴퓨터[김현우]', '422114683375'  ) 


========================2020-08-03 09:05:05======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = 녹천주유소-PC 
parm_os_type = 90 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = BC5FF46D4E96D6470BB1 
sCDKey = 112645303364 
sName = 녹천주유소-PC 
========================2020-08-03 09:05: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 = '112645303364' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2020-08-03 09:05:05======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'kimsiok'  
========================2020-08-03 09:05:05======================== 
SELECT idx FROM macs WHERE mac_addr = 'BC5FF46D4E96D6470BB1' AND app_code = '039' 
========================2020-08-03 09:05:05======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '323197' 
========================2020-08-03 09:05:05======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '323197' 
========================2020-08-03 09:05:05======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '323197', 'BC5FF46D4E96D6470BB1', '039', '녹천주유소-PC', '90', '1920', '1080', 'kimsiok', '녹천주유소[김시옥]', '112645303364'  ) 


========================2020-08-03 14:50:11======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-9G3EH35 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 50E085DD28D6D4E44486 
sCDKey = 422114683375 
sName = DESKTOP-9G3EH35 
========================2020-08-03 14:50:11======================== 
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 = '422114683375' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2020-08-03 14:50:11======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'id4love'  
========================2020-08-03 14:50:11======================== 
SELECT idx FROM macs WHERE mac_addr = '50E085DD28D6D4E44486' AND app_code = '039' 
========================2020-08-03 14:50:11======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '323248' 
========================2020-08-03 14:50:11======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '323248' 
========================2020-08-03 14:50:11======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '323248', '50E085DD28D6D4E44486', '039', 'DESKTOP-9G3EH35', '110', '1920', '1080', 'id4love', '파란컴퓨터[김현우]', '422114683375'  ) 


========================2020-08-03 15:48:13======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-0NES1F9 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = E811323661C32C0C0FA7 
sCDKey = 717963635903 
sName = DESKTOP-0NES1F9 
========================2020-08-03 15:48: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 = '717963635903' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2020-08-03 15:48:13======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'silvera3'  
========================2020-08-03 15:48:13======================== 
SELECT idx FROM macs WHERE mac_addr = 'E811323661C32C0C0FA7' AND app_code = '039' 
========================2020-08-03 15:48:13======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '323262' 
========================2020-08-03 15:48:13======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '323262' 
========================2020-08-03 15:48:13======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '323262', 'E811323661C32C0C0FA7', '039', 'DESKTOP-0NES1F9', '110', '1920', '1080', 'silvera3', '선진종합상사[조명수]', '717963635903'  ) 


========================2020-08-03 17:39:05======================== 
noteurl_start 
parm_app_code = 045 
parm_pc_name = DESKTOP-BRRBGV6 
parm_os_type = 110 
parm_screen_w = 1536 
parm_screen_h = 864 
parm_user_mac = F4B5201D80C190530D0E 
sCDKey = 034284919263 
sName = DESKTOP-BRRBGV6 
========================2020-08-03 17:39: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 = '034284919263' 
			AND r.app_code = '045'
			AND r.app_block = 0 
========================2020-08-03 17:39:05======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'jjhh1538'  
========================2020-08-03 17:39:05======================== 
SELECT idx FROM macs WHERE mac_addr = 'F4B5201D80C190530D0E' AND app_code = '045' 
========================2020-08-03 17:39:05======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '323271' 
========================2020-08-03 17:39:05======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '323271' 
========================2020-08-03 17:39:05======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '323271', 'F4B5201D80C190530D0E', '045', 'DESKTOP-BRRBGV6', '110', '1536', '864', 'jjhh1538', '지오유통[최숙자]', '034284919263'  ) 


========================2020-08-03 18:23:58======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = USER-PC 
parm_os_type = 90 
parm_screen_w = 1024 
parm_screen_h = 768 
parm_user_mac = 50AF7328BD3FA41C65F 
sCDKey = 002871299999 
sName = USER-PC 
========================2020-08-03 18:23:58======================== 
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 = '002871299999' 
			AND r.app_code = '046'
			AND r.app_block = 0 


========================2020-08-03 18:24:09======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = USER-PC 
parm_os_type = 90 
parm_screen_w = 1024 
parm_screen_h = 768 
parm_user_mac = 50AF7328BD3FA41C65F 
sCDKey = 002871299999 
sName = USER-PC 
========================2020-08-03 18:24:09======================== 
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 = '002871299999' 
			AND r.app_code = '046'
			AND r.app_block = 0 


========================2020-08-03 18:24:52======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = USER-PC 
parm_os_type = 90 
parm_screen_w = 1024 
parm_screen_h = 768 
parm_user_mac = 50AF7328BD3FA41C65F 
sCDKey = 002871299999 
sName = USER-PC 
========================2020-08-03 18:24:52======================== 
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 = '002871299999' 
			AND r.app_code = '046'
			AND r.app_block = 0 


========================2020-08-03 18:27:08======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = USER-PC 
parm_os_type = 90 
parm_screen_w = 1024 
parm_screen_h = 768 
parm_user_mac = 50AF7328BD3FA41C65F 
sCDKey = 002871299999 
sName = USER-PC 
========================2020-08-03 18:27: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 = '002871299999' 
			AND r.app_code = '046'
			AND r.app_block = 0