

========================2020-05-22 11:42:43======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = BLUE-PC 
parm_os_type = 90 
parm_screen_w = 1600 
parm_screen_h = 900 
parm_user_mac = 00E2D0C38710B61108F3 
sCDKey = 601532377359 
sName = BLUE-PC 
========================2020-05-22 11:42:43======================== 
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 = '601532377359' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2020-05-22 11:42:43======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'redda321'  
========================2020-05-22 11:42:43======================== 
SELECT idx FROM macs WHERE mac_addr = '00E2D0C38710B61108F3' AND app_code = '039' 
========================2020-05-22 11:42:43======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '318065' 
========================2020-05-22 11:42:43======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '318065' 
========================2020-05-22 11:42:43======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '318065', '00E2D0C38710B61108F3', '039', 'BLUE-PC', '90', '1600', '900', 'redda321', '유림식품[유림식품]', '601532377359'  ) 


========================2020-05-22 11:42:51======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = BLUE-PC 
parm_os_type = 90 
parm_screen_w = 1600 
parm_screen_h = 900 
parm_user_mac = 00E2D0C38710B61108F3 
sCDKey = 601532377359 
sName = BLUE-PC 
========================2020-05-22 11:42: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 = '601532377359' 
			AND r.app_code = '039'
			AND r.app_block = 0 


========================2020-05-22 15:44:10======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-SPPK26O 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 7085C27530B612206678 
sCDKey = 251007618539 
sName = DESKTOP-SPPK26O 
========================2020-05-22 15:44: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 = '251007618539' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2020-05-22 15:44:10======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'dksehd2571'  
========================2020-05-22 15:44:10======================== 
SELECT idx FROM macs WHERE mac_addr = '7085C27530B612206678' AND app_code = '039' 
========================2020-05-22 15:44:10======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '318041' 
========================2020-05-22 15:44:10======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '318041' 
========================2020-05-22 15:44: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	 ( '318041', '7085C27530B612206678', '039', 'DESKTOP-SPPK26O', '110', '1920', '1080', 'dksehd2571', '대명수산[안동원]', '251007618539'  ) 


========================2020-05-22 16:19:24======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-LDB94R7 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 408D5CBA1467EA557AC4 
sCDKey = 912639507488 
sName = DESKTOP-LDB94R7 
========================2020-05-22 16:19: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 = '912639507488' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2020-05-22 16:19:24======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'dainct2019'  
========================2020-05-22 16:19:24======================== 
SELECT idx FROM macs WHERE mac_addr = '408D5CBA1467EA557AC4' AND app_code = '039' 
========================2020-05-22 16:19:24======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '318106' 
========================2020-05-22 16:19:24======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '318106' 
========================2020-05-22 16:19: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	 ( '318106', '408D5CBA1467EA557AC4', '039', 'DESKTOP-LDB94R7', '110', '1920', '1080', 'dainct2019', '다인컨테이너[박소정]', '912639507488'  )