

========================2018-10-12 09:11:28======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name =  
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 8A66A5B1FB02BE44694C 
sCDKey = 935851285112 
sName =  
========================2018-10-12 09:11:28======================== 
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 = '935851285112' 
			AND r.app_code = '039'
			AND r.app_block = 0 


========================2018-10-12 09:11:30======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name =  
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 8A66A5B1FB02BE44694C 
sCDKey = 935851285112 
sName =  
========================2018-10-12 09:11: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 = '935851285112' 
			AND r.app_code = '039'
			AND r.app_block = 0 


========================2018-10-12 09:11:38======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name =  
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 8A66A5B1FB02BE44694C 
sCDKey = 935851285112 
sName = 유니푸드텍 
========================2018-10-12 09:11:38======================== 
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 = '935851285112' 
			AND r.app_code = '039'
			AND r.app_block = 0 


========================2018-10-12 09:14:18======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name =  
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 8A66A5B1FB02BE44694C 
sCDKey = 935851285112 
sName =  
========================2018-10-12 09:14:18======================== 
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 = '935851285112' 
			AND r.app_code = '039'
			AND r.app_block = 0 


========================2018-10-12 09:14:26======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name =  
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 8A66A5B1FB02BE44694C 
sCDKey = 935851285112 
sName = 유니푸드텍 
========================2018-10-12 09:14:26======================== 
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 = '935851285112' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2018-10-12 09:14:26======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'unifoodkorea'  
========================2018-10-12 09:14:26======================== 
SELECT idx FROM macs WHERE mac_addr = '8A66A5B1FB02BE44694C' AND app_code = '039' 
========================2018-10-12 09:14:26======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '262170' 
========================2018-10-12 09:14:26======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '262170' 
========================2018-10-12 09:14:26======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '262170', '8A66A5B1FB02BE44694C', '039', '유니푸드텍', '110', '1920', '1080', 'unifoodkorea', '유니푸드텍[변차환]', '935851285112'  ) 


========================2018-10-12 10:27:00======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = HHY-PC 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = F44D30B9B7922E87FB70 
sCDKey = 324407496376 
sName = HHY-PC 
========================2018-10-12 10:27: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 = '324407496376' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2018-10-12 10:27:00======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'hhy111'  
========================2018-10-12 10:27:00======================== 
SELECT idx FROM macs WHERE mac_addr = 'F44D30B9B7922E87FB70' AND app_code = '039' 
========================2018-10-12 10:27:00======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '221989' 
========================2018-10-12 10:27:00======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '221989' 
========================2018-10-12 10:27:00======================== 
UPDATE mac_detail SET  pc_name = 'HHY-PC', os_type = '110', user_id = 'hhy111', user_name = '[황희영]',
												 screen_w = '1920', screen_h = '1080', cdkey = '324407496376'
								  WHERE mac_idx = '221989'  


========================2018-10-12 10:37:19======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = OKPOS 
parm_os_type = 64 
parm_screen_w = 1024 
parm_screen_h = 768 
parm_user_mac = B8975A8D1216800B9B0F 
sCDKey = 109328527074 
sName = OKPOS 
========================2018-10-12 10:37: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 = '109328527074' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2018-10-12 10:37:19======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'lyj3274'  
========================2018-10-12 10:37:19======================== 
SELECT idx FROM macs WHERE mac_addr = 'B8975A8D1216800B9B0F' AND app_code = '046' 
========================2018-10-12 10:37:19======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '262189' 
========================2018-10-12 10:37:19======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '262189' 
========================2018-10-12 10:37: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	 ( '262189', 'B8975A8D1216800B9B0F', '046', 'OKPOS', '64', '1024', '768', 'lyj3274', '애견용품할인매장[김명기]', '109328527074'  ) 


========================2018-10-12 10:51:21======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = MSDN-SPECIAL 
parm_os_type = 90 
parm_screen_w = 1024 
parm_screen_h = 768 
parm_user_mac = E0D55E927300A46F7AE3 
sCDKey = 024273106239 
sName = MSDN-SPECIAL 
========================2018-10-12 10:51:21======================== 
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 = '024273106239' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2018-10-12 10:51:21======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'is10000'  
========================2018-10-12 10:51:21======================== 
SELECT idx FROM macs WHERE mac_addr = 'E0D55E927300A46F7AE3' AND app_code = '039' 
========================2018-10-12 10:51:21======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '262191' 
========================2018-10-12 10:51:21======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '262191' 
========================2018-10-12 10:51:21======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '262191', 'E0D55E927300A46F7AE3', '039', 'MSDN-SPECIAL', '90', '1024', '768', 'is10000', '충주시농협쌀조합공동사업법인[이상현]', '024273106239'  ) 


========================2018-10-12 10:51:24======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = MSDN-SPECIAL 
parm_os_type = 90 
parm_screen_w = 1024 
parm_screen_h = 768 
parm_user_mac = E0D55E927300A46F7AE3 
sCDKey = 024273106239 
sName = MSDN-SPECIAL 
========================2018-10-12 10:51:24======================== 
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 = '024273106239' 
			AND r.app_code = '039'
			AND r.app_block = 0 


========================2018-10-12 11:50:09======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name =  
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 6CF049B50748BE44694C 
sCDKey = 935851285112 
sName = 유니푸드텍 
========================2018-10-12 11:50:09======================== 
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 = '935851285112' 
			AND r.app_code = '039'
			AND r.app_block = 0 


========================2018-10-12 11:50:49======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name =  
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 6CF049B50748BE44694C 
sCDKey = 935851285112 
sName = 유니푸드텍 
========================2018-10-12 11:50: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 = '935851285112' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2018-10-12 11:50:49======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'unifoodkorea'  
========================2018-10-12 11:50:49======================== 
SELECT idx FROM macs WHERE mac_addr = '6CF049B50748BE44694C' AND app_code = '039' 
========================2018-10-12 11:50:49======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '177146' 
========================2018-10-12 11:50:49======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '177146' 
========================2018-10-12 11:50:49======================== 
UPDATE mac_detail SET  pc_name = '유니푸드텍', os_type = '110', user_id = 'unifoodkorea', user_name = '유니푸드텍[변차환]',
												 screen_w = '1920', screen_h = '1080', cdkey = '935851285112'
								  WHERE mac_idx = '177146'  


========================2018-10-12 15:32:57======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = USER-PC 
parm_os_type = 90 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 00137780FB7C6476DC43 
sCDKey = 618650604114 
sName = USER-PC 
========================2018-10-12 15:32:57======================== 
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 = '618650604114' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2018-10-12 15:32:57======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'daelim1060'  
========================2018-10-12 15:32:57======================== 
SELECT idx FROM macs WHERE mac_addr = '00137780FB7C6476DC43' AND app_code = '046' 
========================2018-10-12 15:32:57======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '262234' 
========================2018-10-12 15:32:57======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '262234' 
========================2018-10-12 15:32:57======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '262234', '00137780FB7C6476DC43', '046', 'USER-PC', '90', '1920', '1080', 'daelim1060', '대림농자재[이완구]', '618650604114'  ) 


========================2018-10-12 17:54:25======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = PC-PC 
parm_os_type = 90 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 9CB654F681F72A0389BC 
sCDKey = 339301481100 
sName = PC-PC 
========================2018-10-12 17:54:25======================== 
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 = '339301481100' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2018-10-12 17:54:25======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'skalfl72'  
========================2018-10-12 17:54:25======================== 
SELECT idx FROM macs WHERE mac_addr = '9CB654F681F72A0389BC' AND app_code = '046' 
========================2018-10-12 17:54:25======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '262258' 
========================2018-10-12 17:54:25======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '262258' 
========================2018-10-12 17:54:25======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '262258', '9CB654F681F72A0389BC', '046', 'PC-PC', '90', '1920', '1080', 'skalfl72', '양천사[김진연]', '339301481100'  ) 


========================2018-10-12 18:04:23======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = PB-IKXZTWBJV0MN 
parm_os_type = 64 
parm_screen_w = 1024 
parm_screen_h = 768 
parm_user_mac = 54BEF7461EFED0305710 
sCDKey = 339301481100 
sName = PB-IKXZTWBJV0MN 
========================2018-10-12 18:04:23======================== 
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 = '339301481100' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2018-10-12 18:04:23======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'skalfl72'  
========================2018-10-12 18:04:23======================== 
SELECT idx FROM macs WHERE mac_addr = '54BEF7461EFED0305710' AND app_code = '046' 
========================2018-10-12 18:04:23======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '121061' 
========================2018-10-12 18:04:23======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '121061' 
========================2018-10-12 18:04:23======================== 
UPDATE mac_detail SET  pc_name = 'PB-IKXZTWBJV0MN', os_type = '64', user_id = 'skalfl72', user_name = '양천사[김진연]',
												 screen_w = '1024', screen_h = '768', cdkey = '339301481100'
								  WHERE mac_idx = '121061'