========================2022-12-01 11:28:22======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-4U1AUCB 
parm_os_type = 110 
parm_screen_w = 1366 
parm_screen_h = 768 
parm_user_mac = 70CD0DA189B1A201C4A4 
sCDKey = 489985381270 
sName = DESKTOP-4U1AUCB 
========================2022-12-01 11:28:22======================== 
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 = '489985381270' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2022-12-01 11:28:22======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'edh0000'  
========================2022-12-01 11:28:22======================== 
SELECT idx FROM macs WHERE mac_addr = '70CD0DA189B1A201C4A4' AND app_code = '039' 
========================2022-12-01 11:28:22======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '378114' 
========================2022-12-01 11:28:22======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '378114' 
========================2022-12-01 11:28:22======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '378114', '70CD0DA189B1A201C4A4', '039', 'DESKTOP-4U1AUCB', '110', '1366', '768', 'edh0000', '·¦¿¡½î[¾öµ¿Çö]', '489985381270'  ) 



========================2022-12-01 13:09:14======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = USER-PC 
parm_os_type = 90 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = E8039A6E6849F0FD5433 
sCDKey = 852466420496 
sName = USER-PC 
========================2022-12-01 13:09: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 = '852466420496' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2022-12-01 13:09:14======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'gmbelt'  
========================2022-12-01 13:09:14======================== 
SELECT idx FROM macs WHERE mac_addr = 'E8039A6E6849F0FD5433' AND app_code = '039' 
========================2022-12-01 13:09:14======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '252996' 
========================2022-12-01 13:09:14======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '252996' 
========================2022-12-01 13:09: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	 ( '252996', 'E8039A6E6849F0FD5433', '039', 'USER-PC', '90', '1920', '1080', 'gmbelt', '±¤¸íÄÁº£¾î[±èÁ¤ÀÚ]', '852466420496'  ) 



========================2022-12-01 13:49:48======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name =  
parm_os_type = 110 
parm_screen_w = 1024 
parm_screen_h = 819 
parm_user_mac = F4B5202310DDF2D37FF2 
sCDKey = 950239637620 
sName = Á¶´ÞÈ£ 
========================2022-12-01 13:49: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 = '950239637620' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2022-12-01 13:49:48======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'kkj8097'  
========================2022-12-01 13:49:48======================== 
SELECT idx FROM macs WHERE mac_addr = 'F4B5202310DDF2D37FF2' AND app_code = '046' 
========================2022-12-01 13:49:48======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '372746' 
========================2022-12-01 13:49:48======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '372746' 
========================2022-12-01 13:49:48======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '372746', 'F4B5202310DDF2D37FF2', '046', 'Á¶´ÞÈ£', '110', '1024', '819', 'kkj8097', '(ÁÖ)ÇѾç°ÇÀç[±è±âÁØ]', '950239637620'  ) 



========================2022-12-01 14:30:23======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = DESKTOP-1QUCC54 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 309C23E60CB92E87FB70 
sCDKey = 437380760374 
sName = DESKTOP-1QUCC54 
========================2022-12-01 14:30:23======================== 
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 = '437380760374' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2022-12-01 14:30:23======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'hellobang'  
========================2022-12-01 14:30:23======================== 
SELECT idx FROM macs WHERE mac_addr = '309C23E60CB92E87FB70' AND app_code = '046' 
========================2022-12-01 14:30:23======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '378137' 
========================2022-12-01 14:30:23======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '378137' 
========================2022-12-01 14:30:23======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '378137', '309C23E60CB92E87FB70', '046', 'DESKTOP-1QUCC54', '110', '1920', '1080', 'hellobang', '[¹æÁ¤¾Ö]', '437380760374'  )