

========================2018-09-27 10:31:15======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = 1-PC 
parm_os_type = 90 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 74D4355FBE9B1424579D 
sCDKey = 297151277754 
sName = 1-PC 
========================2018-09-27 10:31: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 = '297151277754' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2018-09-27 10:31:15======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'kj36549'  
========================2018-09-27 10:31:15======================== 
SELECT idx FROM macs WHERE mac_addr = '74D4355FBE9B1424579D' AND app_code = '039' 
========================2018-09-27 10:31:15======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '260858' 
========================2018-09-27 10:31:15======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '260858' 
========================2018-09-27 10:31: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	 ( '260858', '74D4355FBE9B1424579D', '039', '1-PC', '90', '1920', '1080', 'kj36549', '국제환경[한기철]', '297151277754'  ) 


========================2018-09-27 11:00:14======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = PC33 
parm_os_type = 90 
parm_screen_w = 1080 
parm_screen_h = 1080 
parm_user_mac = 7085C20DE03B625AEACB 
sCDKey = 212519567736 
sName = PC33 
========================2018-09-27 11:00:14======================== 
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 = '212519567736' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2018-09-27 11:00:14======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'parkhung'  
========================2018-09-27 11:00:14======================== 
SELECT idx FROM macs WHERE mac_addr = '7085C20DE03B625AEACB' AND app_code = '039' 
========================2018-09-27 11:00:14======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '260284' 
========================2018-09-27 11:00:14======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '260284' 
========================2018-09-27 11:00:14======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '260284', '7085C20DE03B625AEACB', '039', 'PC33', '90', '1080', '1080', 'parkhung', '하이퀵서비스[박선형]', '212519567736'  ) 


========================2018-09-27 17:23:48======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = CAFE-PC96 
parm_os_type = 110 
parm_screen_w = 2560 
parm_screen_h = 1440 
parm_user_mac = 0C9D92610ED0A00354F2 
sCDKey = 055100002174 
sName = CAFE-PC96 
========================2018-09-27 17:23: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 = '055100002174' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2018-09-27 17:23:48======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'nine_999'  
========================2018-09-27 17:23:48======================== 
SELECT idx FROM macs WHERE mac_addr = '0C9D92610ED0A00354F2' AND app_code = '046' 
========================2018-09-27 17:23:48======================== 
값이 없을 경우 


========================2018-09-27 17:36:10======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-J2RBN9J 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1200 
parm_user_mac = 24BE05E2C3C2A70B686 
sCDKey = 570958675846 
sName = DESKTOP-J2RBN9J 
========================2018-09-27 17:36:10======================== 
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 = '570958675846' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2018-09-27 17:36:10======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'sevin7409'  
========================2018-09-27 17:36:10======================== 
SELECT idx FROM macs WHERE mac_addr = '24BE05E2C3C2A70B686' AND app_code = '039' 
========================2018-09-27 17:36:10======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '260665' 
========================2018-09-27 17:36:10======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '260665' 
========================2018-09-27 17:36:10======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '260665', '24BE05E2C3C2A70B686', '039', 'DESKTOP-J2RBN9J', '110', '1920', '1200', 'sevin7409', '충남모타써비스[한기훈]', '570958675846'  )