

========================2018-06-18 09:17:19======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = USER-PC 
parm_os_type = 90 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 64E599F9A230CAED5ACC 
sCDKey = 481112971650 
sName = USER-PC 
========================2018-06-18 09:17:19======================== 
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 = '481112971650' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2018-06-18 09:17:19======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'ha9909'  
========================2018-06-18 09:17:19======================== 
SELECT idx FROM macs WHERE mac_addr = '64E599F9A230CAED5ACC' AND app_code = '039' 
========================2018-06-18 09:17:19======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '250747' 
========================2018-06-18 09:17:19======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '250747' 
========================2018-06-18 09:17:19======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '250747', '64E599F9A230CAED5ACC', '039', 'USER-PC', '90', '1920', '1080', 'ha9909', '대성아쿠아테크[하두오]', '481112971650'  ) 


========================2018-06-18 11:04:30======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = DESKTOP-QKE9AKN 
parm_os_type = 110 
parm_screen_w = 1536 
parm_screen_h = 864 
parm_user_mac = 90004EAFFF97E8D62CA3 
sCDKey = 810135661075 
sName = DESKTOP-QKE9AKN 
========================2018-06-18 11:04: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 = '810135661075' 
			AND r.app_code = '046'
			AND r.app_block = 0 


========================2018-06-18 11:05:00======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = DESKTOP-QKE9AKN 
parm_os_type = 110 
parm_screen_w = 1536 
parm_screen_h = 864 
parm_user_mac = 90004EAFFF97E8D62CA3 
sCDKey = 810135661075 
sName = super1417 
========================2018-06-18 11:05:00======================== 
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 = '810135661075' 
			AND r.app_code = '046'
			AND r.app_block = 0 


========================2018-06-18 11:05:48======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = DESKTOP-QKE9AKN 
parm_os_type = 110 
parm_screen_w = 1536 
parm_screen_h = 864 
parm_user_mac = 90004EAFFF97E8D62CA3 
sCDKey = 810135661075 
sName = suntools 
========================2018-06-18 11:05:48======================== 
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 = '810135661075' 
			AND r.app_code = '046'
			AND r.app_block = 0 


========================2018-06-18 11:08:46======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = 금림1 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 1C1B0D38142F1212240D 
sCDKey = 337741337408 
sName = 금림1 
========================2018-06-18 11:08:46======================== 
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 = '337741337408' 
			AND r.app_code = '039'
			AND r.app_block = 0 


========================2018-06-18 12:31:05======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = 락성골재 
parm_os_type = 110 
parm_screen_w = 1024 
parm_screen_h = 819 
parm_user_mac = 002358B78566A6EF7DCA 
sCDKey = 481957013433 
sName = 락성골재 
========================2018-06-18 12:31: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 = '481957013433' 
			AND r.app_code = '039'
			AND r.app_block = 0 


========================2018-06-18 13:09:14======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = 락성골재 
parm_os_type = 110 
parm_screen_w = 1024 
parm_screen_h = 819 
parm_user_mac = 002358B78566A6EF7DCA 
sCDKey = 481957013433 
sName = 락성골재 
========================2018-06-18 13:09: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 = '481957013433' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2018-06-18 13:09:14======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'jjj1197'  
========================2018-06-18 13:09:14======================== 
SELECT idx FROM macs WHERE mac_addr = '002358B78566A6EF7DCA' AND app_code = '039' 
========================2018-06-18 13:09:14======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '213838' 
========================2018-06-18 13:09:14======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '213838' 
========================2018-06-18 13:09:14======================== 
UPDATE mac_detail SET  pc_name = '락성골재', os_type = '110', user_id = 'jjj1197', user_name = '낙성종합골재[정재진]',
												 screen_w = '1024', screen_h = '819', cdkey = '481957013433'
								  WHERE mac_idx = '213838'  


========================2018-06-18 13:51:30======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = USER 
parm_os_type = 110 
parm_screen_w = 1600 
parm_screen_h = 900 
parm_user_mac = 005056C000083E59CBD3 
sCDKey = 076018663977 
sName = USER 
========================2018-06-18 13:51: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 = '076018663977' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2018-06-18 13:51:30======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'hyoworl'  
========================2018-06-18 13:51:30======================== 
SELECT idx FROM macs WHERE mac_addr = '005056C000083E59CBD3' AND app_code = '039' 
========================2018-06-18 13:51:30======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '197204' 
========================2018-06-18 13:51:30======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '197204' 
========================2018-06-18 13:51:30======================== 
UPDATE mac_detail SET  pc_name = 'USER', os_type = '110', user_id = 'hyoworl', user_name = '효월영농조합법인[이기영]',
												 screen_w = '1600', screen_h = '900', cdkey = '076018663977'
								  WHERE mac_idx = '197204'