========================2021-02-23 13:21:57======================== 
noteurl_start 
parm_app_code = 051 
parm_pc_name = CHOISH-PC 
parm_os_type = 109 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 305A3A58E5C6C0282EB2 
sCDKey = 563021616762 
sName = CHOISH-PC 
========================2021-02-23 13:21: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 = '563021616762' 
			AND r.app_code = '051'
			AND r.app_block = 0 
========================2021-02-23 13:21:57======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'mjdev'  
========================2021-02-23 13:21:57======================== 
SELECT idx FROM macs WHERE mac_addr = '305A3A58E5C6C0282EB2' AND app_code = '051' 
========================2021-02-23 13:21:57======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '314005' 
========================2021-02-23 13:21:57======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '314005' 
========================2021-02-23 13:21:57======================== 
UPDATE mac_detail SET  pc_name = 'CHOISH-PC', os_type = '109', user_id = 'mjdev', user_name = '¿¥Á¦À̼ÒÇÁÆ®[ÃÖ»óÈ£]',
												 screen_w = '1920', screen_h = '1080', cdkey = '563021616762'
								  WHERE mac_idx = '314005'  



========================2021-02-23 14:32:29======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-F5GLQOG 
parm_os_type = 110 
parm_screen_w = 1024 
parm_screen_h = 768 
parm_user_mac = E8113238C0C6EC7F1213 
sCDKey = 109592113375 
sName = DESKTOP-F5GLQOG 
========================2021-02-23 14:32:29======================== 
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 = '109592113375' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2021-02-23 14:32:29======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'dhfurniture'  
========================2021-02-23 14:32:29======================== 
SELECT idx FROM macs WHERE mac_addr = 'E8113238C0C6EC7F1213' AND app_code = '039' 
========================2021-02-23 14:32:29======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '337614' 
========================2021-02-23 14:32:29======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '337614' 
========================2021-02-23 14:32:29======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '337614', 'E8113238C0C6EC7F1213', '039', 'DESKTOP-F5GLQOG', '110', '1024', '768', 'dhfurniture', '(ÁÖ)´ëÇÑÆÛ´Ïó[±èº´Âù]', '109592113375'  ) 



========================2021-02-23 17:33:06======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = LABNPART 
parm_os_type = 110 
parm_screen_w = 2048 
parm_screen_h = 1152 
parm_user_mac = 8CB0E915A0F5800D8269 
sCDKey = 432114869519 
sName = LABNPART 
========================2021-02-23 17:33: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 = '432114869519' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2021-02-23 17:33:06======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'labnpart'  
========================2021-02-23 17:33:06======================== 
SELECT idx FROM macs WHERE mac_addr = '8CB0E915A0F5800D8269' AND app_code = '039' 
========================2021-02-23 17:33:06======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '337632' 
========================2021-02-23 17:33:06======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '337632' 
========================2021-02-23 17:33: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	 ( '337632', '8CB0E915A0F5800D8269', '039', 'LABNPART', '110', '2048', '1152', 'labnpart', '·¦¾ØÆÄÆ®ÄÚ¸®¾Æ[ÃÖ¿µÀÏ]', '432114869519'  )