========================2019-08-23 10:10:07======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = WIN-F161D2P29N6 
parm_os_type = 90 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 6C626DD59DEEAC124CF1 
sCDKey = 028658494405 
sName = WIN-F161D2P29N6 
========================2019-08-23 10:10:07======================== 
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 = '028658494405' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2019-08-23 10:10:07======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'kcs0611'  
========================2019-08-23 10:10:07======================== 
SELECT idx FROM macs WHERE mac_addr = '6C626DD59DEEAC124CF1' AND app_code = '039' 
========================2019-08-23 10:10:07======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '291835' 
========================2019-08-23 10:10:07======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '291835' 
========================2019-08-23 10:10:07======================== 
UPDATE mac_detail SET  pc_name = 'WIN-F161D2P29N6', os_type = '90', user_id = 'kcs0611', user_name = '¼¼¸ð¸ÞµðÄ®[±èÃæ¼ö]',
												 screen_w = '1920', screen_h = '1080', cdkey = '028658494405'
								  WHERE mac_idx = '291835'  



========================2019-08-23 14:06:35======================== 
noteurl_start 
parm_app_code = 047 
parm_pc_name = DESKTOP-VS4GE8P 
parm_os_type = �쐢�룄�슦 10 
parm_screen_w = 0 
parm_screen_h = 0 
parm_user_mac = F44D30AEEC860A9A4AF5 
sCDKey = 848717979251 
sName = DESKTOP-VS4GE8P 
========================2019-08-23 14:06:35======================== 
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 = '848717979251' 
			AND r.app_code = '047'
			AND r.app_block = 0 
========================2019-08-23 14:06:35======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'eastps'  
========================2019-08-23 14:06:35======================== 
SELECT idx FROM macs WHERE mac_addr = 'F44D30AEEC860A9A4AF5' AND app_code = '047' 
========================2019-08-23 14:06:35======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '293868' 
========================2019-08-23 14:06:35======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '293868' 
========================2019-08-23 14:06:35======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '293868', 'F44D30AEEC860A9A4AF5', '047', 'DESKTOP-VS4GE8P', '�쐢�룄�슦 10', '0', '0', 'eastps', '¾Æ½Ã¾Æ³Ý[ÁÖµ¿Áø]', '848717979251'  ) 



========================2019-08-23 15:35:10======================== 
noteurl_start 
parm_app_code = 045 
parm_pc_name = WIN-PSJ2MBVU2NK 
parm_os_type = 90 
parm_screen_w = 1680 
parm_screen_h = 1050 
parm_user_mac = 9C5C8E93234C705DE530 
sCDKey = 244076831899 
sName = WIN-PSJ2MBVU2NK 
========================2019-08-23 15:35: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 = '244076831899' 
			AND r.app_code = '045'
			AND r.app_block = 0 
========================2019-08-23 15:35:10======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'hohoinja'  
========================2019-08-23 15:35:10======================== 
SELECT idx FROM macs WHERE mac_addr = '9C5C8E93234C705DE530' AND app_code = '045' 
========================2019-08-23 15:35:10======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '293876' 
========================2019-08-23 15:35:10======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '293876' 
========================2019-08-23 15:35: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	 ( '293876', '9C5C8E93234C705DE530', '045', 'WIN-PSJ2MBVU2NK', '90', '1680', '1050', 'hohoinja', '¼¼¸íÄÄÇ»ÅÍ[±èµ¿Çö]', '244076831899'  )