

========================2019-11-22 11:31:27======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-U8UK6GH 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 988389DE48399C1B19AE 
sCDKey = 245398473363 
sName = DESKTOP-U8UK6GH 
========================2019-11-22 11:31: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 = '245398473363' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2019-11-22 11:31:27======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'soo800'  
========================2019-11-22 11:31:27======================== 
SELECT idx FROM macs WHERE mac_addr = '988389DE48399C1B19AE' AND app_code = '039' 
========================2019-11-22 11:31:27======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '303465' 
========================2019-11-22 11:31:27======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '303465' 
========================2019-11-22 11:31:27======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '303465', '988389DE48399C1B19AE', '039', 'DESKTOP-U8UK6GH', '110', '1920', '1080', 'soo800', '아이티티[송수종]', '245398473363'  ) 


========================2019-11-22 13:18:52======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = IPOS 
parm_os_type = 64 
parm_screen_w = 1280 
parm_screen_h = 1024 
parm_user_mac = B8975AB57744646F7D14 
sCDKey = 206832107552 
sName = IPOS 
========================2019-11-22 13:18: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 = '206832107552' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2019-11-22 13:18:52======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'free5054'  
========================2019-11-22 13:18:52======================== 
SELECT idx FROM macs WHERE mac_addr = 'B8975AB57744646F7D14' AND app_code = '046' 
========================2019-11-22 13:18:52======================== 
값이 없을 경우 


========================2019-11-22 13:27:13======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = IPOS 
parm_os_type = 64 
parm_screen_w = 1280 
parm_screen_h = 1024 
parm_user_mac = B8975AB57744646F7D14 
sCDKey = 206832107552 
sName = IPOS 
========================2019-11-22 13:27: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 = '206832107552' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2019-11-22 13:27:13======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'free5054'  
========================2019-11-22 13:27:13======================== 
SELECT idx FROM macs WHERE mac_addr = 'B8975AB57744646F7D14' AND app_code = '046' 
========================2019-11-22 13:27:13======================== 
값이 없을 경우 


========================2019-11-22 15:03:54======================== 
noteurl_start 
parm_app_code = 050 
parm_pc_name = DESKTOP-QS3PHB3 
parm_os_type = 109 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 1C6F65C716166A5BD1BA 
sCDKey = 986566549072 
sName = DESKTOP-QS3PHB3 
========================2019-11-22 15:03:54======================== 
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 = '986566549072' 
			AND r.app_code = '050'
			AND r.app_block = 0 
========================2019-11-22 15:03:54======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'sangwha'  
========================2019-11-22 15:03:54======================== 
SELECT idx FROM macs WHERE mac_addr = '1C6F65C716166A5BD1BA' AND app_code = '050' 
========================2019-11-22 15:03:54======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '205035' 
========================2019-11-22 15:03:54======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '205035' 
========================2019-11-22 15:03:54======================== 
UPDATE mac_detail SET  pc_name = 'DESKTOP-QS3PHB3', os_type = '109', user_id = 'sangwha', user_name = '주식회사 상화[임희재]',
												 screen_w = '1920', screen_h = '1080', cdkey = '986566549072'
								  WHERE mac_idx = '205035'