

========================2021-02-04 12:51:42======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = PC 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 1867B03B032C5043AF06 
sCDKey = 906859224531 
sName = PC 
========================2021-02-04 12:51:42======================== 
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 = '906859224531' 
			AND r.app_code = '039'
			AND r.app_block = 0 


========================2021-02-04 12:52:57======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = PC 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 1867B03B032C5043AF06 
sCDKey = 906859224531 
sName = PC 
========================2021-02-04 12:52: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 = '906859224531' 
			AND r.app_code = '039'
			AND r.app_block = 0 


========================2021-02-04 13:12:16======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = PC 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 1867B03B032C5043AF06 
sCDKey = 906859224531 
sName = PC 
========================2021-02-04 13:12:16======================== 
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 = '906859224531' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2021-02-04 13:12:16======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'dodo6914'  
========================2021-02-04 13:12:16======================== 
SELECT idx FROM macs WHERE mac_addr = '1867B03B032C5043AF06' AND app_code = '039' 
========================2021-02-04 13:12:16======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '221659' 
========================2021-02-04 13:12:16======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '221659' 
========================2021-02-04 13:12:16======================== 
UPDATE mac_detail SET  pc_name = 'PC', os_type = '110', user_id = 'dodo6914', user_name = '(주)로얄아트글라스[박동신]',
												 screen_w = '1920', screen_h = '1080', cdkey = '906859224531'
								  WHERE mac_idx = '221659'  


========================2021-02-04 14:29:48======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = SJ0506E-PC 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 3C7C3F7E64A6C5949842 
sCDKey = 796377480568 
sName = SJ0506E-PC 
========================2021-02-04 14:29: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 = '796377480568' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2021-02-04 14:29:48======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'treebelle'  
========================2021-02-04 14:29:48======================== 
SELECT idx FROM macs WHERE mac_addr = '3C7C3F7E64A6C5949842' AND app_code = '039' 
========================2021-02-04 14:29:48======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '336434' 
========================2021-02-04 14:29:48======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '336434' 
========================2021-02-04 14:29:48======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '336434', '3C7C3F7E64A6C5949842', '039', 'SJ0506E-PC', '110', '1920', '1080', 'treebelle', '주식회사 세종어패럴[박용석]', '796377480568'  ) 


========================2021-02-04 14:49:37======================== 
noteurl_start 
parm_app_code = 051 
parm_pc_name = SKIN330001356 
parm_os_type = 109 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 9883892757B4EA587EF5 
sCDKey = 003401679376 
sName = SKIN330001356 
========================2021-02-04 14:49:37======================== 
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 = '003401679376' 
			AND r.app_code = '051'
			AND r.app_block = 0 
========================2021-02-04 14:49:37======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'skinfosec'  
========================2021-02-04 14:49:37======================== 
SELECT idx FROM macs WHERE mac_addr = '9883892757B4EA587EF5' AND app_code = '051' 
========================2021-02-04 14:49:37======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '331464' 
========================2021-02-04 14:49:37======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '331464' 
========================2021-02-04 14:49:37======================== 
UPDATE mac_detail SET  pc_name = 'SKIN330001356', os_type = '109', user_id = 'skinfosec', user_name = '인포섹[이대윤]',
												 screen_w = '1920', screen_h = '1080', cdkey = '003401679376'
								  WHERE mac_idx = '331464'  


========================2021-02-04 15:59:15======================== 
noteurl_start 
parm_app_code = 051 
parm_pc_name = SKIN330001062 
parm_os_type = 109 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 98838925E14C222E54E9 
sCDKey = 003401679376 
sName = SKIN330001062 
========================2021-02-04 15:59:15======================== 
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 = '003401679376' 
			AND r.app_code = '051'
			AND r.app_block = 0 
========================2021-02-04 15:59:15======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'skinfosec'  
========================2021-02-04 15:59:15======================== 
SELECT idx FROM macs WHERE mac_addr = '98838925E14C222E54E9' AND app_code = '051' 
========================2021-02-04 15:59:15======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '336446' 
========================2021-02-04 15:59:15======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '336446' 
========================2021-02-04 15:59:15======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '336446', '98838925E14C222E54E9', '051', 'SKIN330001062', '109', '1920', '1080', 'skinfosec', '인포섹[이대윤]', '003401679376'  ) 


========================2021-02-04 16:03:36======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = OWNER-PC 
parm_os_type = 90 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 107B444E4E3DD6D7F46B 
sCDKey = 959984696638 
sName = OWNER-PC 
========================2021-02-04 16:03: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 = '959984696638' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2021-02-04 16:03:36======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'ys8230884'  
========================2021-02-04 16:03:36======================== 
SELECT idx FROM macs WHERE mac_addr = '107B444E4E3DD6D7F46B' AND app_code = '046' 
========================2021-02-04 16:03:36======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '336448' 
========================2021-02-04 16:03:36======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '336448' 
========================2021-02-04 16:03: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	 ( '336448', '107B444E4E3DD6D7F46B', '046', 'OWNER-PC', '90', '1920', '1080', 'ys8230884', '(주)유성건재철물[정연순]', '959984696638'  ) 


========================2021-02-04 16:32:29======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-H65K255 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 380025082A002013EFB4 
sCDKey = 389429185329 
sName = DESKTOP-H65K255 
========================2021-02-04 16:32:29======================== 
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 = '389429185329' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2021-02-04 16:32:29======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'amtiger7420'  
========================2021-02-04 16:32:29======================== 
SELECT idx FROM macs WHERE mac_addr = '380025082A002013EFB4' AND app_code = '039' 
========================2021-02-04 16:32:29======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '336413' 
========================2021-02-04 16:32:29======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '336413' 
========================2021-02-04 16:32:29======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '336413', '380025082A002013EFB4', '039', 'DESKTOP-H65K255', '110', '1920', '1080', 'amtiger7420', '엄마의 텃밭[박미라]', '389429185329'  )