========================2022-04-29 09:31:20======================== 
noteurl_start 
parm_app_code = 045 
parm_pc_name = DESKTOP-S12FGNF 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 3C7C3FC1B4E242A31881 
sCDKey = 433641474113 
sName = DESKTOP-S12FGNF 
========================2022-04-29 09:31:20======================== 
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 = '433641474113' 
			AND r.app_code = '045'
			AND r.app_block = 0 
========================2022-04-29 09:31:20======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'gaon2015'  
========================2022-04-29 09:31:20======================== 
SELECT idx FROM macs WHERE mac_addr = '3C7C3FC1B4E242A31881' AND app_code = '045' 
========================2022-04-29 09:31:20======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '365994' 
========================2022-04-29 09:31:20======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '365994' 
========================2022-04-29 09:31:20======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '365994', '3C7C3FC1B4E242A31881', '045', 'DESKTOP-S12FGNF', '110', '1920', '1080', 'gaon2015', '°¡¿ÂÄÚÆÛ·¹À̼Ç[Á¶ÃáÈñ]', '433641474113'  ) 



========================2022-04-29 13:36:46======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-I169BAE 
parm_os_type = 110 
parm_screen_w = 3440 
parm_screen_h = 1440 
parm_user_mac = 2CF05DD135301EECDFC3 
sCDKey = 172998658701 
sName = DESKTOP-I169BAE 
========================2022-04-29 13:36: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 = '172998658701' 
			AND r.app_code = '039'
			AND r.app_block = 0 



========================2022-04-29 13:38:33======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-I169BAE 
parm_os_type = 110 
parm_screen_w = 3440 
parm_screen_h = 1440 
parm_user_mac = 2CF05DD135301EECDFC3 
sCDKey = 172998658701 
sName = DESKTOP-I169BAE 
========================2022-04-29 13:38:33======================== 
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 = '172998658701' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2022-04-29 13:38:33======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'sekwang0316'  
========================2022-04-29 13:38:33======================== 
SELECT idx FROM macs WHERE mac_addr = '2CF05DD135301EECDFC3' AND app_code = '039' 
========================2022-04-29 13:38:33======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '365985' 
========================2022-04-29 13:38:33======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '365985' 
========================2022-04-29 13:38:33======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '365985', '2CF05DD135301EECDFC3', '039', 'DESKTOP-I169BAE', '110', '3440', '1440', 'sekwang0316', '¼¼±¤[¹®°æ³²]', '172998658701'  ) 



========================2022-04-29 13:38:45======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-I169BAE 
parm_os_type = 110 
parm_screen_w = 3440 
parm_screen_h = 1440 
parm_user_mac = 2CF05DD135301EECDFC3 
sCDKey = 172998658701 
sName = ¼¼±¤ 
========================2022-04-29 13:38: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 = '172998658701' 
			AND r.app_code = '039'
			AND r.app_block = 0