

========================2019-04-25 14:59:08======================== 
noteurl_start 
parm_app_code = 045 
parm_pc_name = OWNER-PC 
parm_os_type = 90 
parm_screen_w = 1366 
parm_screen_h = 768 
parm_user_mac = 002454BB77359E7337A9 
sCDKey = 147362244061 
sName = OWNER-PC 
========================2019-04-25 14:59:08======================== 
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 = '147362244061' 
			AND r.app_code = '045'
			AND r.app_block = 0 
========================2019-04-25 14:59:08======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'unisgolf'  
========================2019-04-25 14:59:08======================== 
SELECT idx FROM macs WHERE mac_addr = '002454BB77359E7337A9' AND app_code = '045' 
========================2019-04-25 14:59:08======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '284332' 
========================2019-04-25 14:59:08======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '284332' 
========================2019-04-25 14:59:08======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '284332', '002454BB77359E7337A9', '045', 'OWNER-PC', '90', '1366', '768', 'unisgolf', '주식회사 유니스골프[김용현]', '147362244061'  ) 


========================2019-04-25 17:18:49======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = YOUNGHUN 
parm_os_type = 110 
parm_screen_w = 1536 
parm_screen_h = 864 
parm_user_mac = C4544484EAA774C7498D 
sCDKey = 807343105782 
sName = YOUNGHUN 
========================2019-04-25 17:18:49======================== 
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 = '807343105782' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2019-04-25 17:18:49======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'yoonh01'  
========================2019-04-25 17:18:49======================== 
SELECT idx FROM macs WHERE mac_addr = 'C4544484EAA774C7498D' AND app_code = '039' 
========================2019-04-25 17:18:49======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '277069' 
========================2019-04-25 17:18:49======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '277069' 
========================2019-04-25 17:18:49======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '277069', 'C4544484EAA774C7498D', '039', 'YOUNGHUN', '110', '1536', '864', 'yoonh01', '카베(KAHVE)[윤영훈]', '807343105782'  ) 


========================2019-04-25 17:29:30======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = USER-PC 
parm_os_type = 90 
parm_screen_w = 1366 
parm_screen_h = 768 
parm_user_mac = D0509941542F8A17DBA0 
sCDKey = 218075322303 
sName = USER-PC 
========================2019-04-25 17:29:30======================== 
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 = '218075322303' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2019-04-25 17:29:30======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'ask71669'  
========================2019-04-25 17:29:30======================== 
SELECT idx FROM macs WHERE mac_addr = 'D0509941542F8A17DBA0' AND app_code = '039' 
========================2019-04-25 17:29:30======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '284352' 
========================2019-04-25 17:29:30======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '284352' 
========================2019-04-25 17:29:30======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '284352', 'D0509941542F8A17DBA0', '039', 'USER-PC', '90', '1366', '768', 'ask71669', '늘푸른냉동[안순강]', '218075322303'  )