

========================2021-11-29 11:20:16======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = DESKTOP-9QQTEVN 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 8CB0E9177E02A4B64364 
sCDKey = 291546858846 
sName = DESKTOP-9QQTEVN 
========================2021-11-29 11:20:16======================== 
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 = '291546858846' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2021-11-29 11:20:16======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'leesuk5424'  
========================2021-11-29 11:20:16======================== 
SELECT idx FROM macs WHERE mac_addr = '8CB0E9177E02A4B64364' AND app_code = '046' 
========================2021-11-29 11:20:16======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '337595' 
========================2021-11-29 11:20:16======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '337595' 
========================2021-11-29 11:20:16======================== 
UPDATE mac_detail SET  pc_name = 'DESKTOP-9QQTEVN', os_type = '110', user_id = 'leesuk5424', user_name = '자연햇살주식회사[이홍숙]',
												 screen_w = '1920', screen_h = '1080', cdkey = '291546858846'
								  WHERE mac_idx = '337595'  


========================2021-11-29 17:17:15======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-ML05ERB 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = D8BBC16858C884A1A5D6 
sCDKey = 689416610602 
sName = DESKTOP-ML05ERB 
========================2021-11-29 17:17:15======================== 
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 = '689416610602' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2021-11-29 17:17:15======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'nspark830'  
========================2021-11-29 17:17:15======================== 
SELECT idx FROM macs WHERE mac_addr = 'D8BBC16858C884A1A5D6' AND app_code = '039' 
========================2021-11-29 17:17:15======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '355002' 
========================2021-11-29 17:17:15======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '355002' 
========================2021-11-29 17:17:15======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '355002', 'D8BBC16858C884A1A5D6', '039', 'DESKTOP-ML05ERB', '110', '1920', '1080', 'nspark830', '피알프로모션성남지사[박남섭]', '689416610602'  ) 


========================2021-11-29 19:48:05======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DELL 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 747827AD41F75A56E614 
sCDKey = 422114683375 
sName = DELL 
========================2021-11-29 19:48: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 = '422114683375' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2021-11-29 19:48:05======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'id4love'  
========================2021-11-29 19:48:05======================== 
SELECT idx FROM macs WHERE mac_addr = '747827AD41F75A56E614' AND app_code = '039' 
========================2021-11-29 19:48:06======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '355457' 
========================2021-11-29 19:48:06======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '355457' 
========================2021-11-29 19:48:06======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '355457', '747827AD41F75A56E614', '039', 'DELL', '110', '1920', '1080', 'id4love', '파란컴퓨터[김현우]', '422114683375'  )