========================2019-10-24 10:42:40======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = COM 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = A4DB3082245280151477 
sCDKey = 342918991698 
sName = COM 
========================2019-10-24 10:42: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 = '342918991698' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2019-10-24 10:42:40======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'jun9317718'  
========================2019-10-24 10:42:40======================== 
SELECT idx FROM macs WHERE mac_addr = 'A4DB3082245280151477' AND app_code = '046' 
========================2019-10-24 10:42:40======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '300832' 
========================2019-10-24 10:42:40======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '300832' 
========================2019-10-24 10:42:40======================== 
UPDATE mac_detail SET  pc_name = 'COM', os_type = '110', user_id = 'jun9317718', user_name = 'Çѳ󿬳óÀÚÀ翵³óÁ¶ÇÕ¹ýÀÎ[ÀüÁ¾¼®]',
												 screen_w = '1920', screen_h = '1080', cdkey = '342918991698'
								  WHERE mac_idx = '300832'  



========================2019-10-24 14:25:42======================== 
noteurl_start 
parm_app_code = 045 
parm_pc_name = DESKTOP-LK0T8OG 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 9883897CE2D1FC3354FB 
sCDKey = 342067082511 
sName = DESKTOP-LK0T8OG 
========================2019-10-24 14:25: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 = '342067082511' 
			AND r.app_code = '045'
			AND r.app_block = 0 
========================2019-10-24 14:25:42======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'taesung3939'  
========================2019-10-24 14:25:42======================== 
SELECT idx FROM macs WHERE mac_addr = '9883897CE2D1FC3354FB' AND app_code = '045' 
========================2019-10-24 14:25:42======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '301062' 
========================2019-10-24 14:25:42======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '301062' 
========================2019-10-24 14:25: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	 ( '301062', '9883897CE2D1FC3354FB', '045', 'DESKTOP-LK0T8OG', '110', '1920', '1080', 'taesung3939', 'żºÅ¸ÀÏ[Á¤Á¡±³]', '342067082511'  ) 



========================2019-10-24 14:38:10======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = USER-20191024EY 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = B8975A10BF0F85B0275 
sCDKey = 434202060236 
sName = USER-20191024EY 
========================2019-10-24 14:38: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 = '434202060236' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2019-10-24 14:38:10======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'feel3969'  
========================2019-10-24 14:38:10======================== 
SELECT idx FROM macs WHERE mac_addr = 'B8975A10BF0F85B0275' AND app_code = '039' 
========================2019-10-24 14:38:10======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '301064' 
========================2019-10-24 14:38:10======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '301064' 
========================2019-10-24 14:38: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	 ( '301064', 'B8975A10BF0F85B0275', '039', 'USER-20191024EY', '110', '1920', '1080', 'feel3969', '¿µÇöÅ×Å©[À±Á¤È¯]', '434202060236'  ) 



========================2019-10-24 14:38:45======================== 
noteurl_start 
parm_app_code = 047 
parm_pc_name = SUPERUSER-PC 
parm_os_type = �쐢�룄�슦 7 
parm_screen_w = 0 
parm_screen_h = 0 
parm_user_mac = B8975A045DE13E0E44DE 
sCDKey = 042677545519 
sName = SUPERUSER-PC 
========================2019-10-24 14:38:45======================== 
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 = '042677545519' 
			AND r.app_code = '047'
			AND r.app_block = 0 
========================2019-10-24 14:38:45======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'skp3522'  
========================2019-10-24 14:38:45======================== 
SELECT idx FROM macs WHERE mac_addr = 'B8975A045DE13E0E44DE' AND app_code = '047' 
========================2019-10-24 14:38:45======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '301032' 
========================2019-10-24 14:38:45======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '301032' 
========================2019-10-24 14:38:45======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '301032', 'B8975A045DE13E0E44DE', '047', 'SUPERUSER-PC', '�쐢�룄�슦 7', '0', '0', 'skp3522', '¼­±¤µµÀå°Ç¼³[À̹μ÷]', '042677545519'  ) 



========================2019-10-24 14:38:52======================== 
noteurl_start 
parm_app_code = 047 
parm_pc_name = SUPERUSER-PC 
parm_os_type = �쐢�룄�슦 7 
parm_screen_w = 0 
parm_screen_h = 0 
parm_user_mac = B8975A045DE13E0E44DE 
sCDKey = 042677545519 
sName = SUPERUSER-PC 
========================2019-10-24 14:38: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 = '042677545519' 
			AND r.app_code = '047'
			AND r.app_block = 0 



========================2019-10-24 14:39:29======================== 
noteurl_start 
parm_app_code = 047 
parm_pc_name = SUPERUSER-PC 
parm_os_type = �쐢�룄�슦 7 
parm_screen_w = 0 
parm_screen_h = 0 
parm_user_mac = B8975A045DE13E0E44DE 
sCDKey = 042677545519 
sName = SUPERUSER-PC 
========================2019-10-24 14:39: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 = '042677545519' 
			AND r.app_code = '047'
			AND r.app_block = 0 



========================2019-10-24 14:39:41======================== 
noteurl_start 
parm_app_code = 047 
parm_pc_name = SUPERUSER-PC 
parm_os_type = �쐢�룄�슦 7 
parm_screen_w = 0 
parm_screen_h = 0 
parm_user_mac = B8975A045DE13E0E44DE 
sCDKey = 042677545519 
sName = SUPERUSER-PC 
========================2019-10-24 14:39:41======================== 
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 = '042677545519' 
			AND r.app_code = '047'
			AND r.app_block = 0 



========================2019-10-24 15:32:44======================== 
noteurl_start 
parm_app_code = 045 
parm_pc_name = DESKTOP-LK0T8OG 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 9883897CE2D1B8776072 
sCDKey = 342067082511 
sName = DESKTOP-LK0T8OG 
========================2019-10-24 15: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 = '342067082511' 
			AND r.app_code = '045'
			AND r.app_block = 0 
========================2019-10-24 15:32:44======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'taesung3939'  
========================2019-10-24 15:32:44======================== 
SELECT idx FROM macs WHERE mac_addr = '9883897CE2D1B8776072' AND app_code = '045' 
========================2019-10-24 15:32:44======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '301071' 
========================2019-10-24 15:32:44======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '301071' 
========================2019-10-24 15: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	 ( '301071', '9883897CE2D1B8776072', '045', 'DESKTOP-LK0T8OG', '110', '1920', '1080', 'taesung3939', 'żºÅ¸ÀÏ[Á¤Á¡±³]', '342067082511'  ) 



========================2019-10-24 16:06:06======================== 
noteurl_start 
parm_app_code = 051 
parm_pc_name = SEOWL15H81833 
parm_os_type = 109 
parm_screen_w = 1366 
parm_screen_h = 768 
parm_user_mac = B05ADA39C3D5B2896E22 
sCDKey = 851095746023 
sName = SEOWL15H81833 
========================2019-10-24 16:06: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 = '851095746023' 
			AND r.app_code = '051'
			AND r.app_block = 0 
========================2019-10-24 16:06:06======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'ik549892'  
========================2019-10-24 16:06:06======================== 
SELECT idx FROM macs WHERE mac_addr = 'B05ADA39C3D5B2896E22' AND app_code = '051' 
========================2019-10-24 16:06:06======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '293048' 
========================2019-10-24 16:06:06======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '293048' 
========================2019-10-24 16:06: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	 ( '293048', 'B05ADA39C3D5B2896E22', '051', 'SEOWL15H81833', '109', '1366', '768', 'ik549892', 'Áö¿¡½ºÄÉÀÌ(GSK)[±èÀιè]', '851095746023'  ) 



========================2019-10-24 18:08:42======================== 
noteurl_start 
parm_app_code = 051 
parm_pc_name = SEOWL17H15185 
parm_os_type = 109 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = D4258B944A4914F48463 
sCDKey = 851095746023 
sName = SEOWL17H15185 
========================2019-10-24 18:08: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 = '851095746023' 
			AND r.app_code = '051'
			AND r.app_block = 0 
========================2019-10-24 18:08:42======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'ik549892'  
========================2019-10-24 18:08:42======================== 
SELECT idx FROM macs WHERE mac_addr = 'D4258B944A4914F48463' AND app_code = '051' 
========================2019-10-24 18:08:42======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '290012' 
========================2019-10-24 18:08:42======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '290012' 
========================2019-10-24 18:08:42======================== 
UPDATE mac_detail SET  pc_name = 'SEOWL17H15185', os_type = '109', user_id = 'ik549892', user_name = 'Áö¿¡½ºÄÉÀÌ(GSK)[±èÀιè]',
												 screen_w = '1920', screen_h = '1080', cdkey = '851095746023'
								  WHERE mac_idx = '290012'