

========================2019-04-04 09:04:05======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-E9BO5QE 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 24F5AAD58DCC2A880267 
sCDKey = 741506160169 
sName = DESKTOP-E9BO5QE 
========================2019-04-04 09:04: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 = '741506160169' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2019-04-04 09:04:05======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'yk264800'  
========================2019-04-04 09:04:05======================== 
SELECT idx FROM macs WHERE mac_addr = '24F5AAD58DCC2A880267' AND app_code = '039' 
========================2019-04-04 09:04:05======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '282462' 
========================2019-04-04 09:04:05======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '282462' 
========================2019-04-04 09:04:05======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '282462', '24F5AAD58DCC2A880267', '039', 'DESKTOP-E9BO5QE', '110', '1920', '1080', 'yk264800', '영광종합상사[장두환]', '741506160169'  ) 


========================2019-04-04 09:10:44======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-B2N80B6 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 7085C23B713DFA94C03F 
sCDKey = 741506160169 
sName = DESKTOP-B2N80B6 
========================2019-04-04 09:10:44======================== 
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 = '741506160169' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2019-04-04 09:10:44======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'yk264800'  
========================2019-04-04 09:10:44======================== 
SELECT idx FROM macs WHERE mac_addr = '7085C23B713DFA94C03F' AND app_code = '039' 
========================2019-04-04 09:10:44======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '282463' 
========================2019-04-04 09:10:44======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '282463' 
========================2019-04-04 09:10:44======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '282463', '7085C23B713DFA94C03F', '039', 'DESKTOP-B2N80B6', '110', '1920', '1080', 'yk264800', '영광종합상사[장두환]', '741506160169'  ) 


========================2019-04-04 09:59:20======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = USER-PC1 
parm_os_type = 90 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 3497F68F72D6622F6F33 
sCDKey = 852599218062 
sName = USER-PC1 
========================2019-04-04 09:59:20======================== 
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 = '852599218062' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2019-04-04 09:59:20======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'sd3022'  
========================2019-04-04 09:59:20======================== 
SELECT idx FROM macs WHERE mac_addr = '3497F68F72D6622F6F33' AND app_code = '046' 
========================2019-04-04 09:59:20======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '201872' 
========================2019-04-04 09:59:20======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '201872' 
========================2019-04-04 09:59:20======================== 
UPDATE mac_detail SET  pc_name = 'USER-PC1', os_type = '90', user_id = 'sd3022', user_name = '성도물산[곽효신]',
												 screen_w = '1920', screen_h = '1080', cdkey = '852599218062'
								  WHERE mac_idx = '201872'  


========================2019-04-04 10:21:15======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = OKPOS 
parm_os_type = 110 
parm_screen_w = 1024 
parm_screen_h = 768 
parm_user_mac = 68EDA41CCEAF68C7CAFB 
sCDKey = 852599218062 
sName = OKPOS 
========================2019-04-04 10:21: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 = '852599218062' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2019-04-04 10:21:15======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'sd3022'  
========================2019-04-04 10:21:15======================== 
SELECT idx FROM macs WHERE mac_addr = '68EDA41CCEAF68C7CAFB' AND app_code = '046' 
========================2019-04-04 10:21:15======================== 
값이 없을 경우 


========================2019-04-04 10:47:42======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = OKPOS 
parm_os_type = 110 
parm_screen_w = 1024 
parm_screen_h = 768 
parm_user_mac = 68EDA41CCEAF68C7CAFB 
sCDKey = 852599218062 
sName = OKPOS 
========================2019-04-04 10:47: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 = '852599218062' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2019-04-04 10:47:42======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'sd3022'  
========================2019-04-04 10:47:42======================== 
SELECT idx FROM macs WHERE mac_addr = '68EDA41CCEAF68C7CAFB' AND app_code = '046' 
========================2019-04-04 10:47:42======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '282475' 
========================2019-04-04 10:47:42======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '282475' 
========================2019-04-04 10:47:42======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '282475', '68EDA41CCEAF68C7CAFB', '046', 'OKPOS', '110', '1024', '768', 'sd3022', '성도물산[곽효신]', '852599218062'  ) 


========================2019-04-04 15:16:30======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-5DMQ7KP 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = B42E99432FE3EA05A76A 
sCDKey = 298490747753 
sName = DESKTOP-5DMQ7KP 
========================2019-04-04 15:16: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 = '298490747753' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2019-04-04 15:16:30======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'kimck1368'  
========================2019-04-04 15:16:30======================== 
SELECT idx FROM macs WHERE mac_addr = 'B42E99432FE3EA05A76A' AND app_code = '039' 
========================2019-04-04 15:16:30======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '282511' 
========================2019-04-04 15:16:30======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '282511' 
========================2019-04-04 15:16:30======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '282511', 'B42E99432FE3EA05A76A', '039', 'DESKTOP-5DMQ7KP', '110', '1920', '1080', 'kimck1368', '참테크[김찬기]', '298490747753'  ) 


========================2019-04-04 17:09:06======================== 
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 = D050993F043166881DD1 
sCDKey = 420380571543 
sName = USER-PC 
========================2019-04-04 17:09:06======================== 
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 = '420380571543' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2019-04-04 17:09:06======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'eoehd2658'  
========================2019-04-04 17:09:06======================== 
SELECT idx FROM macs WHERE mac_addr = 'D050993F043166881DD1' AND app_code = '039' 
========================2019-04-04 17:09:06======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '282534' 
========================2019-04-04 17:09:06======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '282534' 
========================2019-04-04 17:09:06======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '282534', 'D050993F043166881DD1', '039', 'USER-PC', '90', '1920', '1080', 'eoehd2658', '대동강한복[박진철]', '420380571543'  ) 


========================2019-04-04 18:56:01======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = APDR0TZGCPUDVDY 
parm_os_type = 64 
parm_screen_w = 1024 
parm_screen_h = 768 
parm_user_mac = 00190F0F073E815922C 
sCDKey = 834962125925 
sName = test 
========================2019-04-04 18:56:01======================== 
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 = '834962125925' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2019-04-04 18:56:01======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'ericaan'  
========================2019-04-04 18:56:01======================== 
SELECT idx FROM macs WHERE mac_addr = '00190F0F073E815922C' AND app_code = '046' 
========================2019-04-04 18:56:01======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '273188' 
========================2019-04-04 18:56:01======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '273188' 
========================2019-04-04 18:56:01======================== 
UPDATE mac_detail SET  pc_name = 'test', os_type = '64', user_id = 'ericaan', user_name = '주식회사 메종드파리[안진현]',
												 screen_w = '1024', screen_h = '768', cdkey = '834962125925'
								  WHERE mac_idx = '273188'