========================2023-03-07 17:23:52======================== 
noteurl_start 
parm_app_code = 051 
parm_pc_name = GA 
parm_os_type = 109 
parm_screen_w = 1536 
parm_screen_h = 864 
parm_user_mac = F8A2D65EE1059470A302 
sCDKey = 378736978806 
sName = GA 
========================2023-03-07 17:23: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 = '378736978806' 
			AND r.app_code = '051'
			AND r.app_block = 0 
========================2023-03-07 17:23:52======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'bdirect1'  
========================2023-03-07 17:23:52======================== 
SELECT idx FROM macs WHERE mac_addr = 'F8A2D65EE1059470A302' AND app_code = '051' 
========================2023-03-07 17:23:52======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '383839' 
========================2023-03-07 17:23:52======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '383839' 
========================2023-03-07 17:23:52======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '383839', 'F8A2D65EE1059470A302', '051', 'GA', '109', '1536', '864', 'bdirect1', 'ºÎµ¿»ê´ÙÀÌ·ºÆ®[±èÁØ¿µ]', '378736978806'  ) 



========================2023-03-07 17:26:26======================== 
noteurl_start 
parm_app_code = 051 
parm_pc_name = JAEHONGPARK 
parm_os_type = 109 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = A8A1598089AFAE5411A6 
sCDKey = 378736978806 
sName = JAEHONGPARK 
========================2023-03-07 17:26:26======================== 
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 = '378736978806' 
			AND r.app_code = '051'
			AND r.app_block = 0 
========================2023-03-07 17:26:26======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'bdirect1'  
========================2023-03-07 17:26:26======================== 
SELECT idx FROM macs WHERE mac_addr = 'A8A1598089AFAE5411A6' AND app_code = '051' 
========================2023-03-07 17:26:26======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '338959' 
========================2023-03-07 17:26:26======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '338959' 
========================2023-03-07 17:26:26======================== 
UPDATE mac_detail SET  pc_name = 'JAEHONGPARK', os_type = '109', user_id = 'bdirect1', user_name = 'ºÎµ¿»ê´ÙÀÌ·ºÆ®[±èÁØ¿µ]',
												 screen_w = '1920', screen_h = '1080', cdkey = '378736978806'
								  WHERE mac_idx = '338959'  



========================2023-03-07 17:32:44======================== 
noteurl_start 
parm_app_code = 047 
parm_pc_name = ADMINISTRATOR 
parm_os_type = �쐢�룄�슦 7 
parm_screen_w = 0 
parm_screen_h = 0 
parm_user_mac = 68EDA4365EB4942362F3 
sCDKey = 525192434166 
sName = ADMINISTRATOR 
========================2023-03-07 17:32: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 = '525192434166' 
			AND r.app_code = '047'
			AND r.app_block = 0 
========================2023-03-07 17:32:44======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'jkjk757800'  
========================2023-03-07 17:32:44======================== 
SELECT idx FROM macs WHERE mac_addr = '68EDA4365EB4942362F3' AND app_code = '047' 
========================2023-03-07 17:32:44======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '382118' 
========================2023-03-07 17:32:44======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '382118' 
========================2023-03-07 17:32: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	 ( '382118', '68EDA4365EB4942362F3', '047', 'ADMINISTRATOR', '�쐢�룄�슦 7', '0', '0', 'jkjk757800', 'º¸ÀÏ·¯¹éÈ­Á¡[ÀÌ°æÀÚ]', '525192434166'  )