========================2016-08-10 13:39: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 = '' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2016-08-10 13:41: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 = '' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2016-08-10 13:41: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 = '' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2016-08-10 13:42: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 = '794659223172' 
			AND r.app_code = '046'
			AND r.app_block = 0 
sCDKey = 794659223172 
========================2016-08-10 13:42:35======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'dnjstjrdbxhd'  
========================2016-08-10 13:42:35======================== 
SELECT idx FROM macs WHERE mac_addr = '0021sasdasdasd' AND app_code = '046' 
========================2016-08-10 13:42:35======================== 
값이 없을 경우 


========================2016-08-10 13:43:43======================== 
noteurl_start 
========================2016-08-10 13:43: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 = '794659223172' 
			AND r.app_code = '046'
			AND r.app_block = 0 
sCDKey = 794659223172 
========================2016-08-10 13:43:43======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'dnjstjrdbxhd'  
========================2016-08-10 13:43:43======================== 
SELECT idx FROM macs WHERE mac_addr = '0021sasdasdasd' AND app_code = '046' 
========================2016-08-10 13:43:43======================== 
값이 없을 경우 


========================2016-08-10 13:47:27======================== 
noteurl_start 
========================2016-08-10 13:47:27======================== 
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 = '' 
			AND r.app_code = ''
			AND r.app_block = 0 


========================2016-08-10 13:49:22======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = USER-0FD764478B 
parm_os_type = 64 
parm_screen_w = 1280 
parm_screen_h = 1024 
parm_user_mac = 0013774472442032F943 
sCDKey = 794659223172 
sName = USER-0FD764478B 
========================2016-08-10 13:49:22======================== 
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 = '794659223172' 
			AND r.app_code = '046'
			AND r.app_block = 0 
parm_app_code = 046 
parm_pc_name = USER-0FD764478B 
parm_os_type = 64 
parm_screen_w = 1280 
parm_screen_h = 1024 
parm_user_mac = 0013774472442032F943 
sCDKey = 794659223172 
sName = USER-0FD764478B 
========================2016-08-10 13:49:22======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'dnjstjrdbxhd'  
parm_app_code = 046 
parm_pc_name = USER-0FD764478B 
parm_os_type = 64 
parm_screen_w = 1280 
parm_screen_h = 1024 
parm_user_mac = 0013774472442032F943 
sCDKey = 794659223172 
sName = USER-0FD764478B 
========================2016-08-10 13:49:22======================== 
SELECT idx FROM macs WHERE mac_addr = '0013774472442032F943' AND app_code = '046' 
parm_app_code = 046 
parm_pc_name = USER-0FD764478B 
parm_os_type = 64 
parm_screen_w = 1280 
parm_screen_h = 1024 
parm_user_mac = 0013774472442032F943 
sCDKey = 794659223172 
sName = USER-0FD764478B 


========================2016-08-10 14:04:14======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = USER-0FD764478B 
parm_os_type = 64 
parm_screen_w = 1280 
parm_screen_h = 1024 
parm_user_mac = 0013774472442032F943 
sCDKey = 794659223172 
sName = USER-0FD764478B 
========================2016-08-10 14:04:14======================== 
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 = '794659223172' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2016-08-10 14:04:14======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'dnjstjrdbxhd'  
========================2016-08-10 14:04:14======================== 
SELECT idx FROM macs WHERE mac_addr = '0013774472442032F943' AND app_code = '046' 
========================2016-08-10 14:04:14======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '127663' 
========================2016-08-10 14:04:14======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '127663' 
========================2016-08-10 14:04:14======================== 
UPDATE mac_detail SET  pc_name = 'USER-0FD764478B', os_type = '64', user_id = 'dnjstjrdbxhd', user_name = '원석유통[김영미]',
												 screen_w = '1280', screen_h = '1024', cdkey = '794659223172'
								  WHERE mac_idx = '127663'