========================2022-12-13 14:22:40======================== 
noteurl_start 
parm_app_code = 047 
parm_pc_name = DESKTOP-32KLSRM 
parm_os_type = �쐢�룄�슦 10 
parm_screen_w = 0 
parm_screen_h = 0 
parm_user_mac = F0795970D82C40F2E5FA 
sCDKey = 222453983020 
sName = Áß°èÁ¡ 
========================2022-12-13 14:22:40======================== 
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 = '222453983020' 
			AND r.app_code = '047'
			AND r.app_block = 0 
========================2022-12-13 14:22:40======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'loitae79'  
========================2022-12-13 14:22:40======================== 
SELECT idx FROM macs WHERE mac_addr = 'F0795970D82C40F2E5FA' AND app_code = '047' 
========================2022-12-13 14:22:40======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '378767' 
========================2022-12-13 14:22:40======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '378767' 
========================2022-12-13 14:22:40======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '378767', 'F0795970D82C40F2E5FA', '047', 'Áß°èÁ¡', '�쐢�룄�슦 10', '0', '0', 'loitae79', '⼺À̴ϳ×[ÀÌ¿ø½Ä]', '222453983020'  ) 



========================2022-12-13 15:30:54======================== 
noteurl_start 
parm_app_code = 047 
parm_pc_name = DESKTOP-VTGV0NE 
parm_os_type = �쐢�룄�슦 10 
parm_screen_w = 0 
parm_screen_h = 0 
parm_user_mac = F079597289B6C66E21DA 
sCDKey = 222453983020 
sName = ³ë¿øÁ¡ 
========================2022-12-13 15:30: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 = '222453983020' 
			AND r.app_code = '047'
			AND r.app_block = 0 
========================2022-12-13 15:30:54======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'loitae79'  
========================2022-12-13 15:30:54======================== 
SELECT idx FROM macs WHERE mac_addr = 'F079597289B6C66E21DA' AND app_code = '047' 
========================2022-12-13 15:30:54======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '378773' 
========================2022-12-13 15:30:54======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '378773' 
========================2022-12-13 15:30:54======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '378773', 'F079597289B6C66E21DA', '047', '³ë¿øÁ¡', '�쐢�룄�슦 10', '0', '0', 'loitae79', '⼺À̴ϳ×[ÀÌ¿ø½Ä]', '222453983020'  ) 



========================2022-12-13 16:36:42======================== 
noteurl_start 
parm_app_code = 047 
parm_pc_name = DESKTOP-GHTP11R 
parm_os_type = �쐢�룄�슦 10 
parm_screen_w = 0 
parm_screen_h = 0 
parm_user_mac = 68EDA44454200EEF09AE 
sCDKey = 199917511349 
sName = DESKTOP-GHTP11R 
========================2022-12-13 16:36:42======================== 
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 = '199917511349' 
			AND r.app_code = '047'
			AND r.app_block = 0 
========================2022-12-13 16:36:42======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'mongekorea1'  
========================2022-12-13 16:36:42======================== 
SELECT idx FROM macs WHERE mac_addr = '68EDA44454200EEF09AE' AND app_code = '047' 
========================2022-12-13 16:36:42======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '378780' 
========================2022-12-13 16:36:42======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '378780' 
========================2022-12-13 16:36:42======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '378780', '68EDA44454200EEF09AE', '047', 'DESKTOP-GHTP11R', '�쐢�룄�슦 10', '0', '0', 'mongekorea1', '¸óÁöÄÚ¸®¾Æ[½ÉÁØÈñ]', '199917511349'  ) 



========================2022-12-13 17:09:48======================== 
noteurl_start 
parm_app_code = 050 
parm_pc_name = DESKTOP-TEDOHID 
parm_os_type = 109 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 98838985A54C9813AD8B 
sCDKey = 847153978892 
sName = DESKTOP-TEDOHID 
========================2022-12-13 17:09: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 = '847153978892' 
			AND r.app_code = '050'
			AND r.app_block = 0 
========================2022-12-13 17:09:48======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'wogus36'  
========================2022-12-13 17:09:48======================== 
SELECT idx FROM macs WHERE mac_addr = '98838985A54C9813AD8B' AND app_code = '050' 
========================2022-12-13 17:09:48======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '372715' 
========================2022-12-13 17:09:48======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '372715' 
========================2022-12-13 17:09: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	 ( '372715', '98838985A54C9813AD8B', '050', 'DESKTOP-TEDOHID', '109', '1920', '1080', 'wogus36', '¿¥Á¦ÀÌ[ȲÀçÇö]', '847153978892'  )