

========================2018-06-20 09:23:23======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = ADTECH3 
parm_os_type = 90 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 003018A8C5CCC807F0A 
sCDKey = 452631342040 
sName = ADTECH3 
========================2018-06-20 09:23: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 = '452631342040' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2018-06-20 09:23:23======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'adtech0202'  
========================2018-06-20 09:23:23======================== 
SELECT idx FROM macs WHERE mac_addr = '003018A8C5CCC807F0A' AND app_code = '039' 
========================2018-06-20 09:23:23======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '152593' 
========================2018-06-20 09:23:23======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '152593' 
========================2018-06-20 09:23:23======================== 
UPDATE mac_detail SET  pc_name = 'ADTECH3', os_type = '90', user_id = 'adtech0202', user_name = '에이디테크[고남섭]',
												 screen_w = '1920', screen_h = '1080', cdkey = '452631342040'
								  WHERE mac_idx = '152593'  


========================2018-06-20 09:23:27======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = ADTECH3 
parm_os_type = 90 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 003018A8C5CCC807F0A 
sCDKey = 452631342040 
sName = ADTECH3 
========================2018-06-20 09:23: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 = '452631342040' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2018-06-20 09:23:27======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'adtech0202'  
========================2018-06-20 09:23:27======================== 
SELECT idx FROM macs WHERE mac_addr = '003018A8C5CCC807F0A' AND app_code = '039' 
========================2018-06-20 09:23:27======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '152593' 
========================2018-06-20 09:23:27======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '152593' 
========================2018-06-20 09:23:27======================== 
UPDATE mac_detail SET  pc_name = 'ADTECH3', os_type = '90', user_id = 'adtech0202', user_name = '에이디테크[고남섭]',
												 screen_w = '1920', screen_h = '1080', cdkey = '452631342040'
								  WHERE mac_idx = '152593'  


========================2018-06-20 10:29:23======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = EUNJIN-CHIHEUN 
parm_os_type = 90 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = D43D7E0AC1CC661D8213 
sCDKey = 518905460020 
sName = 신선맘 
========================2018-06-20 10:29: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 = '518905460020' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2018-06-20 10:29:23======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'pouy8695'  
========================2018-06-20 10:29:23======================== 
SELECT idx FROM macs WHERE mac_addr = 'D43D7E0AC1CC661D8213' AND app_code = '039' 
========================2018-06-20 10:29:23======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '223954' 
========================2018-06-20 10:29:23======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '223954' 
========================2018-06-20 10:29:23======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '223954', 'D43D7E0AC1CC661D8213', '039', '신선맘', '90', '1920', '1080', 'pouy8695', '신선맘[송치완]', '518905460020'  ) 


========================2018-06-20 15:15:28======================== 
noteurl_start 
parm_app_code = 045 
parm_pc_name = DESKTOP-V8HEQLM 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 48BA4E61092E1E6A96EF 
sCDKey = 932847330830 
sName = DESKTOP-V8HEQLM 
========================2018-06-20 15:15: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 = '932847330830' 
			AND r.app_code = '045'
			AND r.app_block = 0 
========================2018-06-20 15:15:28======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'chamnara'  
========================2018-06-20 15:15:28======================== 
SELECT idx FROM macs WHERE mac_addr = '48BA4E61092E1E6A96EF' AND app_code = '045' 
========================2018-06-20 15:15:28======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '241591' 
========================2018-06-20 15:15:28======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '241591' 
========================2018-06-20 15:15:28======================== 
UPDATE mac_detail SET  pc_name = 'DESKTOP-V8HEQLM', os_type = '110', user_id = 'chamnara', user_name = '(주)참나라 농업회사법인[임준상]',
												 screen_w = '1920', screen_h = '1080', cdkey = '932847330830'
								  WHERE mac_idx = '241591'  


========================2018-06-20 15:20:13======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = K-PC 
parm_os_type = 90 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 1C1B0DFB27E526FC53C8 
sCDKey = 329041203772 
sName = K-PC 
========================2018-06-20 15:20:13======================== 
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 = '329041203772' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2018-06-20 15:20:13======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'dy0516'  
========================2018-06-20 15:20:13======================== 
SELECT idx FROM macs WHERE mac_addr = '1C1B0DFB27E526FC53C8' AND app_code = '039' 
========================2018-06-20 15:20:13======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '252458' 
========================2018-06-20 15:20:13======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '252458' 
========================2018-06-20 15:20:13======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '252458', '1C1B0DFB27E526FC53C8', '039', 'K-PC', '90', '1920', '1080', 'dy0516', '(주)대영종합환경[권미화]', '329041203772'  ) 


========================2018-06-20 15:20:19======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = K-PC 
parm_os_type = 90 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 1C1B0DFB27E526FC53C8 
sCDKey = 329041203772 
sName = K-PC 
========================2018-06-20 15:20: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 = '329041203772' 
			AND r.app_code = '039'
			AND r.app_block = 0 


========================2018-06-20 15:20:22======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = K-PC 
parm_os_type = 90 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 1C1B0DFB27E526FC53C8 
sCDKey = 329041203772 
sName = K-PC 
========================2018-06-20 15:20: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 = '329041203772' 
			AND r.app_code = '039'
			AND r.app_block = 0 


========================2018-06-20 15:25:13======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = ADTECH1 
parm_os_type = 90 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 00306715AA492633F6AB 
sCDKey = 452631342040 
sName = ADTECH1 
========================2018-06-20 15:25:13======================== 
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 = '452631342040' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2018-06-20 15:25:13======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'adtech0202'  
========================2018-06-20 15:25:13======================== 
SELECT idx FROM macs WHERE mac_addr = '00306715AA492633F6AB' AND app_code = '039' 
========================2018-06-20 15:25:13======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '152594' 
========================2018-06-20 15:25:13======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '152594' 
========================2018-06-20 15:25:13======================== 
UPDATE mac_detail SET  pc_name = 'ADTECH1', os_type = '90', user_id = 'adtech0202', user_name = '에이디테크[고남섭]',
												 screen_w = '1920', screen_h = '1080', cdkey = '452631342040'
								  WHERE mac_idx = '152594'  


========================2018-06-20 16:21:58======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = DESKTOP-7H4210S 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = B0359F5CCE5792215C16 
sCDKey = 938129979397 
sName = DESKTOP-7H4210S 
========================2018-06-20 16:21:58======================== 
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 = '938129979397' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2018-06-20 16:21:58======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'mdpet'  
========================2018-06-20 16:21:58======================== 
SELECT idx FROM macs WHERE mac_addr = 'B0359F5CCE5792215C16' AND app_code = '046' 
========================2018-06-20 16:21:58======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '252472' 
========================2018-06-20 16:21:58======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '252472' 
========================2018-06-20 16:21:58======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '252472', 'B0359F5CCE5792215C16', '046', 'DESKTOP-7H4210S', '110', '1920', '1080', 'mdpet', '엠디펫[이종원]', '938129979397'  ) 


========================2018-06-20 16:32:03======================== 
noteurl_start 
parm_app_code = 051 
parm_pc_name = DESKTOP-TSN31CC 
parm_os_type = 109 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = D050994888750CF50B28 
sCDKey = 959237939642 
sName = DESKTOP-TSN31CC 
========================2018-06-20 16:32:03======================== 
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 = '959237939642' 
			AND r.app_code = '051'
			AND r.app_block = 0 
========================2018-06-20 16:32:03======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'ogokbab'  
========================2018-06-20 16:32:03======================== 
SELECT idx FROM macs WHERE mac_addr = 'D050994888750CF50B28' AND app_code = '051' 
========================2018-06-20 16:32:03======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '252474' 
========================2018-06-20 16:32:03======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '252474' 
========================2018-06-20 16:32:03======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '252474', 'D050994888750CF50B28', '051', 'DESKTOP-TSN31CC', '109', '1920', '1080', 'ogokbab', '알엠소프트[최도훈]', '959237939642'  ) 


========================2018-06-20 18:06:56======================== 
noteurl_start 
parm_app_code = 051 
parm_pc_name =  
parm_os_type = 109 
parm_screen_w = 1920 
parm_screen_h = 1200 
parm_user_mac = D0509943BAB6DEE35EAC 
sCDKey = 959237939642 
sName = 대전 
========================2018-06-20 18:06:56======================== 
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 = '959237939642' 
			AND r.app_code = '051'
			AND r.app_block = 0 
========================2018-06-20 18:06:56======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'ogokbab'  
========================2018-06-20 18:06:56======================== 
SELECT idx FROM macs WHERE mac_addr = 'D0509943BAB6DEE35EAC' AND app_code = '051' 
========================2018-06-20 18:06:56======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '252479' 
========================2018-06-20 18:06:56======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '252479' 
========================2018-06-20 18:06:56======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '252479', 'D0509943BAB6DEE35EAC', '051', '대전', '109', '1920', '1200', 'ogokbab', '알엠소프트[최도훈]', '959237939642'  )