========================2019-10-29 11:53:32======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = KS 
parm_os_type = 64 
parm_screen_w = 1024 
parm_screen_h = 768 
parm_user_mac = 00090FFE0001F49E0FF9 
sCDKey = 455716962303 
sName = KS 
========================2019-10-29 11:53:32======================== 
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 = '455716962303' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2019-10-29 11:53:32======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'elantra017'  
========================2019-10-29 11:53:32======================== 
SELECT idx FROM macs WHERE mac_addr = '00090FFE0001F49E0FF9' AND app_code = '039' 
========================2019-10-29 11:53:32======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '301408' 
========================2019-10-29 11:53:32======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '301408' 
========================2019-10-29 11:53:32======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '301408', '00090FFE0001F49E0FF9', '039', 'KS', '64', '1024', '768', 'elantra017', '¼¼Áø»ê¾÷[À̼¼¿¬]', '455716962303'  ) 



========================2019-10-29 13:08:35======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = COM 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 50B7C3A832E380151477 
sCDKey = 342918991698 
sName = COM 
========================2019-10-29 13:08:35======================== 
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 = '342918991698' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2019-10-29 13:08:35======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'jun9317718'  
========================2019-10-29 13:08:35======================== 
SELECT idx FROM macs WHERE mac_addr = '50B7C3A832E380151477' AND app_code = '046' 
========================2019-10-29 13:08:35======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '298145' 
========================2019-10-29 13:08:35======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '298145' 
========================2019-10-29 13:08:35======================== 
UPDATE mac_detail SET  pc_name = 'COM', os_type = '110', user_id = 'jun9317718', user_name = 'Çѳ󿬳óÀÚÀ翵³óÁ¶ÇÕ¹ýÀÎ[ÀüÁ¾¼®]',
												 screen_w = '1920', screen_h = '1080', cdkey = '342918991698'
								  WHERE mac_idx = '298145'  



========================2019-10-29 17:39:36======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = POP-SUB 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 24F5AAE0C8C75A435C31 
sCDKey = 755239997128 
sName = POP-SUB 
========================2019-10-29 17:39:36======================== 
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 = '755239997128' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2019-10-29 17:39:36======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'imclean'  
========================2019-10-29 17:39:36======================== 
SELECT idx FROM macs WHERE mac_addr = '24F5AAE0C8C75A435C31' AND app_code = '039' 
========================2019-10-29 17:39:36======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '301093' 
========================2019-10-29 17:39:36======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '301093' 
========================2019-10-29 17:39:36======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '301093', '24F5AAE0C8C75A435C31', '039', 'POP-SUB', '110', '1920', '1080', 'imclean', '¾ÆÀÌ¿¥Å¬¸°[¹Ú¿ëÇÑ]', '755239997128'  )