========================2019-04-16 07:55:45======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = WIN-LPIT1TKRFGR 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = FCAA14D4B4ECFC979DCE 
sCDKey = 982834938334 
sName =  
========================2019-04-16 07:55: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 = '982834938334' 
			AND r.app_code = '039'
			AND r.app_block = 0 



========================2019-04-16 07:55:52======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = WIN-LPIT1TKRFGR 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = FCAA14D4B4ECFC979DCE 
sCDKey = 982834938334 
sName = ¸ÚÁö´Ù 
========================2019-04-16 07:55: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 = '982834938334' 
			AND r.app_code = '039'
			AND r.app_block = 0 



========================2019-04-16 08:15:41======================== 
noteurl_start 
parm_app_code = 048 
parm_pc_name = ±è¿Á³à 
parm_os_type = �쐢�룄�슦 10 
parm_screen_w = 0 
parm_screen_h = 0 
parm_user_mac = 24F5AAEB832C5262F991 
sCDKey = 434133617514 
sName = ±è¿Á³à 
========================2019-04-16 08:15: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 = '434133617514' 
			AND r.app_code = '048'
			AND r.app_block = 0 



========================2019-04-16 11:15:07======================== 
noteurl_start 
parm_app_code = 048 
parm_pc_name = ±è¿Á³à 
parm_os_type = �쐢�룄�슦 10 
parm_screen_w = 0 
parm_screen_h = 0 
parm_user_mac = 24F5AAEB832C5262F991 
sCDKey = 434133617514 
sName = ±è¿Á³à 
========================2019-04-16 11:15:07======================== 
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 = '434133617514' 
			AND r.app_code = '048'
			AND r.app_block = 0 



========================2019-04-16 11:18:12======================== 
noteurl_start 
parm_app_code = 048 
parm_pc_name = ±è¿Á³à 
parm_os_type = �쐢�룄�슦 10 
parm_screen_w = 0 
parm_screen_h = 0 
parm_user_mac = 24F5AAEB832C5262F991 
sCDKey = 434133617514 
sName = ±è¿Á³à 
========================2019-04-16 11:18:12======================== 
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 = '434133617514' 
			AND r.app_code = '048'
			AND r.app_block = 0 
========================2019-04-16 11:18:12======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'weblink'  
========================2019-04-16 11:18:12======================== 
SELECT idx FROM macs WHERE mac_addr = '24F5AAEB832C5262F991' AND app_code = '048' 
========================2019-04-16 11:18:12======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '254561' 
========================2019-04-16 11:18:12======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '254561' 
========================2019-04-16 11:18:12======================== 
UPDATE mac_detail SET  pc_name = '±è¿Á³à', os_type = '�쐢�룄�슦 10', user_id = 'weblink', user_name = '´ë¼ºÈ°¾î[°­Á¤¹Ì]',
												 screen_w = '0', screen_h = '0', cdkey = '434133617514'
								  WHERE mac_idx = '254561'  



========================2019-04-16 11:54:45======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name =  
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 0C9D9264F60872E316D1 
sCDKey = 873699848852 
sName =  
========================2019-04-16 11:54: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 = '873699848852' 
			AND r.app_code = '039'
			AND r.app_block = 0 



========================2019-04-16 11:55:26======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name =  
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 0C9D9264F60872E316D1 
sCDKey = 873699848852 
sName = Ȳ¼±Èñ-PC 
========================2019-04-16 11:55: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 = '873699848852' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2019-04-16 11:55:26======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'kibc0236'  
========================2019-04-16 11:55:26======================== 
SELECT idx FROM macs WHERE mac_addr = '0C9D9264F60872E316D1' AND app_code = '039' 
========================2019-04-16 11:55:26======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '283532' 
========================2019-04-16 11:55:26======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '283532' 
========================2019-04-16 11:55:26======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '283532', '0C9D9264F60872E316D1', '039', 'Ȳ¼±Èñ-PC', '110', '1920', '1080', 'kibc0236', '°¡¿ÂºñÁê¾ó[Ȳ¼±Èñ]', '873699848852'  ) 



========================2019-04-16 16:37:35======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = OKPOS 
parm_os_type = 110 
parm_screen_w = 1024 
parm_screen_h = 768 
parm_user_mac = 68EDA41CDFE468C7CAFB 
sCDKey = 460021804127 
sName = OKPOS 
========================2019-04-16 16:37:35======================== 
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 = '460021804127' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2019-04-16 16:37:35======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'sd5553022'  
========================2019-04-16 16:37:35======================== 
SELECT idx FROM macs WHERE mac_addr = '68EDA41CDFE468C7CAFB' AND app_code = '046' 
========================2019-04-16 16:37:35======================== 
°ªÀÌ ¾øÀ» °æ¿ì 



========================2019-04-16 16:57:29======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = OKPOS 
parm_os_type = 110 
parm_screen_w = 1024 
parm_screen_h = 768 
parm_user_mac = 68EDA41CDFE468C7CAFB 
sCDKey = 852599218062 
sName = OKPOS 
========================2019-04-16 16:57: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 = '852599218062' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2019-04-16 16:57:29======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'sd3022'  
========================2019-04-16 16:57:29======================== 
SELECT idx FROM macs WHERE mac_addr = '68EDA41CDFE468C7CAFB' AND app_code = '046' 
========================2019-04-16 16:57:29======================== 
°ªÀÌ ¾øÀ» °æ¿ì 



========================2019-04-16 17:12:49======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = OKPOS 
parm_os_type = 110 
parm_screen_w = 1024 
parm_screen_h = 768 
parm_user_mac = 68EDA41CDFE468C7CAFB 
sCDKey = 852599218062 
sName = OKPOS 
========================2019-04-16 17:12:49======================== 
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 = '852599218062' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2019-04-16 17:12:49======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'sd3022'  
========================2019-04-16 17:12:49======================== 
SELECT idx FROM macs WHERE mac_addr = '68EDA41CDFE468C7CAFB' AND app_code = '046' 
========================2019-04-16 17:12:49======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '283566' 
========================2019-04-16 17:12:49======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '283566' 
========================2019-04-16 17:12:49======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '283566', '68EDA41CDFE468C7CAFB', '046', 'OKPOS', '110', '1024', '768', 'sd3022', '¼ºµµ¹°»ê[°ûÈ¿½Å]', '852599218062'  ) 



========================2019-04-16 17:44:26======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = DESKTOP-IRDDH28 
parm_os_type = 110 
parm_screen_w = 1366 
parm_screen_h = 768 
parm_user_mac = 54271E46E1EFAC7DF286 
sCDKey = 475467945095 
sName = DESKTOP-IRDDH28 
========================2019-04-16 17:44: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 = '475467945095' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2019-04-16 17:44:26======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'bookpang'  
========================2019-04-16 17:44:26======================== 
SELECT idx FROM macs WHERE mac_addr = '54271E46E1EFAC7DF286' AND app_code = '046' 
========================2019-04-16 17:44:26======================== 
°ªÀÌ ¾øÀ» °æ¿ì 



========================2019-04-16 17:44:40======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = DESKTOP-IRDDH28 
parm_os_type = 110 
parm_screen_w = 1366 
parm_screen_h = 768 
parm_user_mac = 54271E46E1EFAC7DF286 
sCDKey = 475467945095 
sName = DESKTOP-IRDDH28 
========================2019-04-16 17:44: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 = '475467945095' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2019-04-16 17:44:40======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'bookpang'  
========================2019-04-16 17:44:40======================== 
SELECT idx FROM macs WHERE mac_addr = '54271E46E1EFAC7DF286' AND app_code = '046' 
========================2019-04-16 17:44:40======================== 
°ªÀÌ ¾øÀ» °æ¿ì 



========================2019-04-16 17:46:06======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = DESKTOP-IRDDH28 
parm_os_type = 110 
parm_screen_w = 1366 
parm_screen_h = 768 
parm_user_mac = 54271E46E1EFAC7DF286 
sCDKey = 475467945095 
sName = DESKTOP-IRDDH28 
========================2019-04-16 17:46: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 = '475467945095' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2019-04-16 17:46:06======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'bookpang'  
========================2019-04-16 17:46:06======================== 
SELECT idx FROM macs WHERE mac_addr = '54271E46E1EFAC7DF286' AND app_code = '046' 
========================2019-04-16 17:46:06======================== 
°ªÀÌ ¾øÀ» °æ¿ì 



========================2019-04-16 17:50:38======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = DESKTOP-IRDDH28 
parm_os_type = 110 
parm_screen_w = 1366 
parm_screen_h = 768 
parm_user_mac = 54271E46E1EFAC7DF286 
sCDKey = 475467945095 
sName = DESKTOP-IRDDH28 
========================2019-04-16 17:50:38======================== 
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 = '475467945095' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2019-04-16 17:50:38======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'bookpang'  
========================2019-04-16 17:50:38======================== 
SELECT idx FROM macs WHERE mac_addr = '54271E46E1EFAC7DF286' AND app_code = '046' 
========================2019-04-16 17:50:38======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '283570' 
========================2019-04-16 17:50:38======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '283570' 
========================2019-04-16 17:50:38======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '283570', '54271E46E1EFAC7DF286', '046', 'DESKTOP-IRDDH28', '110', '1366', '768', 'bookpang', 'ºÏÆÎ[±èºÎÇö]', '475467945095'  ) 



========================2019-04-16 17:50:58======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = DESKTOP-IRDDH28 
parm_os_type = 110 
parm_screen_w = 1366 
parm_screen_h = 768 
parm_user_mac = 54271E46E1EFAC7DF286 
sCDKey = 475467945095 
sName = DESKTOP-IRDDH28 
========================2019-04-16 17:50:58======================== 
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 = '475467945095' 
			AND r.app_code = '046'
			AND r.app_block = 0