========================2022-07-29 16:03:43======================== 
noteurl_start 
parm_app_code = 045 
parm_pc_name = DESKTOP-9E3JGLP 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = A8A159AF4F69B6C8F4BB 
sCDKey = 592109452711 
sName = DESKTOP-9E3JGLP 
========================2022-07-29 16:03: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 = '592109452711' 
			AND r.app_code = '045'
			AND r.app_block = 0 
========================2022-07-29 16:03:43======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'donabi'  
========================2022-07-29 16:03:43======================== 
SELECT idx FROM macs WHERE mac_addr = 'A8A159AF4F69B6C8F4BB' AND app_code = '045' 
========================2022-07-29 16:03:43======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '371075' 
========================2022-07-29 16:03:43======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '371075' 
========================2022-07-29 16:03: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	 ( '371075', 'A8A159AF4F69B6C8F4BB', '045', 'DESKTOP-9E3JGLP', '110', '1920', '1080', 'donabi', '(ÁÖ)Æ÷¿ø [ÀÌÀ翵]', '592109452711'  ) 



========================2022-07-29 16:05:39======================== 
noteurl_start 
parm_app_code = 045 
parm_pc_name = DESKTOP-ARD2L49 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 7085C27AD69F328E0543 
sCDKey = 592109452711 
sName = DESKTOP-ARD2L49 
========================2022-07-29 16:05:39======================== 
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 = '592109452711' 
			AND r.app_code = '045'
			AND r.app_block = 0 
========================2022-07-29 16:05:39======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'donabi'  
========================2022-07-29 16:05:39======================== 
SELECT idx FROM macs WHERE mac_addr = '7085C27AD69F328E0543' AND app_code = '045' 
========================2022-07-29 16:05:39======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '329333' 
========================2022-07-29 16:05:39======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '329333' 
========================2022-07-29 16:05:39======================== 
UPDATE mac_detail SET  pc_name = 'DESKTOP-ARD2L49', os_type = '110', user_id = 'donabi', user_name = '(ÁÖ)Æ÷¿ø [ÀÌÀ翵]',
												 screen_w = '1920', screen_h = '1080', cdkey = '592109452711'
								  WHERE mac_idx = '329333'  



========================2022-07-29 16:18:31======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = USER-PC 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 1C1B0DA305FDC94140E 
sCDKey = 584885465107 
sName = USER-PC 
========================2022-07-29 16:18: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 = '584885465107' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2022-07-29 16:18:31======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'dsb0'  
========================2022-07-29 16:18:31======================== 
SELECT idx FROM macs WHERE mac_addr = '1C1B0DA305FDC94140E' AND app_code = '046' 
========================2022-07-29 16:18:31======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '371078' 
========================2022-07-29 16:18:31======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '371078' 
========================2022-07-29 16:18: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	 ( '371078', '1C1B0DA305FDC94140E', '046', 'USER-PC', '110', '1920', '1080', 'dsb0', 'µ¿¼ºÁ¾ÇÕº¼Æ®[±è¹Î¼­]', '584885465107'  )