

========================2018-03-30 10:35:57======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = PC02 
parm_os_type = 90 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = E0D55E5A018F22E362ED 
sCDKey = 644061740807 
sName = PC02 
========================2018-03-30 10:35: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 = '644061740807' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2018-03-30 10:35:57======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'craft1tk'  
========================2018-03-30 10:35:57======================== 
SELECT idx FROM macs WHERE mac_addr = 'E0D55E5A018F22E362ED' AND app_code = '039' 
========================2018-03-30 10:35:57======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '245885' 
========================2018-03-30 10:35:57======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '245885' 
========================2018-03-30 10:35: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	 ( '245885', 'E0D55E5A018F22E362ED', '039', 'PC02', '90', '1920', '1080', 'craft1tk', '도심재생문화재단[김태형]', '644061740807'  ) 


========================2018-03-30 11:47:45======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name =  
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = D067E51555CA46B9D6F4 
sCDKey = 314912656780 
sName =  
========================2018-03-30 11:47:45======================== 
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 = '314912656780' 
			AND r.app_code = '039'
			AND r.app_block = 0 


========================2018-03-30 11:47: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 = D067E51555CA46B9D6F4 
sCDKey = 314912656780 
sName = 111 
========================2018-03-30 11:47: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 = '314912656780' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2018-03-30 11:47:49======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'wj85576'  
========================2018-03-30 11:47:49======================== 
SELECT idx FROM macs WHERE mac_addr = 'D067E51555CA46B9D6F4' AND app_code = '039' 
========================2018-03-30 11:47:49======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '245892' 
========================2018-03-30 11:47:49======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '245892' 
========================2018-03-30 11:47:49======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '245892', 'D067E51555CA46B9D6F4', '039', '111', '110', '1920', '1080', 'wj85576', '우정엠앤에스[조병근]', '314912656780'  ) 


========================2018-03-30 11:58:45======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = HOMESPOS 
parm_os_type = 110 
parm_screen_w = 1024 
parm_screen_h = 768 
parm_user_mac = 50AF7325BFF3A4AF7DFD 
sCDKey = 921252470168 
sName = HOMESPOS 
========================2018-03-30 11:58:45======================== 
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 = '921252470168' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2018-03-30 11:58:45======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'cherhomes'  
========================2018-03-30 11:58:45======================== 
SELECT idx FROM macs WHERE mac_addr = '50AF7325BFF3A4AF7DFD' AND app_code = '046' 
========================2018-03-30 11:58:45======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '236522' 
========================2018-03-30 11:58:45======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '236522' 
========================2018-03-30 11:58:45======================== 
UPDATE mac_detail SET  pc_name = 'HOMESPOS', os_type = '110', user_id = 'cherhomes', user_name = '쉐르홈즈[최화별]',
												 screen_w = '1024', screen_h = '768', cdkey = '921252470168'
								  WHERE mac_idx = '236522'  


========================2018-03-30 13:47:52======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = MIJIN_JUNPYO 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 005056C0000838540FC2 
sCDKey = 808382986370 
sName = MIJIN_JUNPYO 
========================2018-03-30 13:47:52======================== 
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 = '808382986370' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2018-03-30 13:47:52======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'tkekcom'  
========================2018-03-30 13:47:52======================== 
SELECT idx FROM macs WHERE mac_addr = '005056C0000838540FC2' AND app_code = '039' 
========================2018-03-30 13:47:52======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '206269' 
========================2018-03-30 13:47:52======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '206269' 
========================2018-03-30 13:47:52======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '206269', '005056C0000838540FC2', '039', 'MIJIN_JUNPYO', '110', '1920', '1080', 'tkekcom', '엠제이소프트[김준표]', '808382986370'  ) 


========================2018-03-30 14:18:11======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = LAPTOP-KNTJPMQT 
parm_os_type = 110 
parm_screen_w = 1536 
parm_screen_h = 864 
parm_user_mac = 98838934A8DDFCAF2D34 
sCDKey = 205303618682 
sName = LAPTOP-KNTJPMQT 
========================2018-03-30 14:18:11======================== 
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 = '205303618682' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2018-03-30 14:18:11======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'sk95227'  
========================2018-03-30 14:18:11======================== 
SELECT idx FROM macs WHERE mac_addr = '98838934A8DDFCAF2D34' AND app_code = '039' 
========================2018-03-30 14:18:11======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '229617' 
========================2018-03-30 14:18:11======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '229617' 
========================2018-03-30 14:18:11======================== 
UPDATE mac_detail SET  pc_name = 'LAPTOP-KNTJPMQT', os_type = '110', user_id = 'sk95227', user_name = '에스케이(sk)커버링[남인선]',
												 screen_w = '1536', screen_h = '864', cdkey = '205303618682'
								  WHERE mac_idx = '229617'