========================2020-09-25 10:43:45======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name =  
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 1078D23DC6FAE7F631AB 
sCDKey = 282996638063 
sName = ³²¾ç¿£Áö´Ï¾î¸µ 
========================2020-09-25 10:43: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 = '282996638063' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2020-09-25 10:43:45======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'rich111801'  
========================2020-09-25 10:43:45======================== 
SELECT idx FROM macs WHERE mac_addr = '1078D23DC6FAE7F631AB' AND app_code = '039' 
========================2020-09-25 10:43:45======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '326903' 
========================2020-09-25 10:43:45======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '326903' 
========================2020-09-25 10:43: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	 ( '326903', '1078D23DC6FAE7F631AB', '039', '³²¾ç¿£Áö´Ï¾î¸µ', '110', '1920', '1080', 'rich111801', '³²¾ç¿£Áö´Ï¾î¸µ[È«À±±â]', '282996638063'  ) 



========================2020-09-25 10:43:53======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name =  
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 1078D23DC6FAE7F631AB 
sCDKey = 282996638063 
sName = ³²¾ç¿£Áö´Ï¾î¸µ 
========================2020-09-25 10: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 = '282996638063' 
			AND r.app_code = '039'
			AND r.app_block = 0 



========================2020-09-25 11:47:14======================== 
noteurl_start 
parm_app_code = 051 
parm_pc_name = NEXSYS-PC 
parm_os_type = 90 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = D05099462AC3840C4A94 
sCDKey = 074926232870 
sName = NEXSYS-PC 
========================2020-09-25 11:47: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 = '074926232870' 
			AND r.app_code = '051'
			AND r.app_block = 0 
========================2020-09-25 11:47:14======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'smartsensor'  
========================2020-09-25 11:47:14======================== 
SELECT idx FROM macs WHERE mac_addr = 'D05099462AC3840C4A94' AND app_code = '051' 
========================2020-09-25 11:47:14======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '326854' 
========================2020-09-25 11:47:14======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '326854' 
========================2020-09-25 11:47:14======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '326854', 'D05099462AC3840C4A94', '051', 'NEXSYS-PC', '90', '1920', '1080', 'smartsensor', 'Gachon University[ÇÔ½ÂÇå]', '074926232870'  ) 



========================2020-09-25 16:40:11======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-2K0O5RD 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 00D861BF86B94DB6D33 
sCDKey = 398348232074 
sName = DESKTOP-2K0O5RD 
========================2020-09-25 16:40: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 = '398348232074' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2020-09-25 16:40:11======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'jeng'  
========================2020-09-25 16:40:11======================== 
SELECT idx FROM macs WHERE mac_addr = '00D861BF86B94DB6D33' AND app_code = '039' 
========================2020-09-25 16:40:11======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '326945' 
========================2020-09-25 16:40:11======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '326945' 
========================2020-09-25 16:40: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	 ( '326945', '00D861BF86B94DB6D33', '039', 'DESKTOP-2K0O5RD', '110', '1920', '1080', 'jeng', 'Á¤ÀºÀü¿­ENG[¹Ú¿ëÀº]', '398348232074'  )