========================2018-06-25 09:11:55======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = WINDOWS-00 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = F44D30BB9BB8860AE08C 
sCDKey = 058337428659 
sName = WINDOWS-00 
========================2018-06-25 09:11:55======================== 
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 = '058337428659' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2018-06-25 09:11:55======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'ljb1479024'  
========================2018-06-25 09:11:55======================== 
SELECT idx FROM macs WHERE mac_addr = 'F44D30BB9BB8860AE08C' AND app_code = '039' 
========================2018-06-25 09:11:55======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '252777' 
========================2018-06-25 09:11:55======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '252777' 
========================2018-06-25 09:11:55======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '252777', 'F44D30BB9BB8860AE08C', '039', 'WINDOWS-00', '110', '1920', '1080', 'ljb1479024', 'Á¤È£Á¤¹Ð[ÀÌÀçºÀ]', '058337428659'  ) 



========================2018-06-25 14:02:34======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = 0512-PC 
parm_os_type = 90 
parm_screen_w = 1280 
parm_screen_h = 1024 
parm_user_mac = 1078D27B3FA1BE5A3C3E 
sCDKey = 454717149262 
sName = 0512-PC 
========================2018-06-25 14:02:34======================== 
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 = '454717149262' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2018-06-25 14:02:34======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'ja4692'  
========================2018-06-25 14:02:34======================== 
SELECT idx FROM macs WHERE mac_addr = '1078D27B3FA1BE5A3C3E' AND app_code = '039' 
========================2018-06-25 14:02:34======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '184656' 
========================2018-06-25 14:02:34======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '184656' 
========================2018-06-25 14:02:34======================== 
UPDATE mac_detail SET  pc_name = '0512-PC', os_type = '90', user_id = 'ja4692', user_name = '´ë¼º°ø±¸¹éÈ­Á¡[ÀÌÀçÈÄ]',
												 screen_w = '1280', screen_h = '1024', cdkey = '454717149262'
								  WHERE mac_idx = '184656'  



========================2018-06-25 14:05:10======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DAESUNG 
parm_os_type = 110 
parm_screen_w = 1280 
parm_screen_h = 1024 
parm_user_mac = E0D55EA578F7FA14CAE4 
sCDKey = 454717149262 
sName = DAESUNG 
========================2018-06-25 14:05: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 = '454717149262' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2018-06-25 14:05:10======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'ja4692'  
========================2018-06-25 14:05:10======================== 
SELECT idx FROM macs WHERE mac_addr = 'E0D55EA578F7FA14CAE4' AND app_code = '039' 
========================2018-06-25 14:05:10======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '252809' 
========================2018-06-25 14:05:10======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '252809' 
========================2018-06-25 14:05: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	 ( '252809', 'E0D55EA578F7FA14CAE4', '039', 'DAESUNG', '110', '1280', '1024', 'ja4692', '´ë¼º°ø±¸¹éÈ­Á¡[ÀÌÀçÈÄ]', '454717149262'  ) 



========================2018-06-25 14:58:33======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = KCG-PC 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = F44D304C7862A6138453 
sCDKey = 224661081956 
sName = KCG-PC 
========================2018-06-25 14:58:33======================== 
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 = '224661081956' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2018-06-25 14:58:33======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'gyu1001'  
========================2018-06-25 14:58:33======================== 
SELECT idx FROM macs WHERE mac_addr = 'F44D304C7862A6138453' AND app_code = '039' 
========================2018-06-25 14:58:33======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '200150' 
========================2018-06-25 14:58:33======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '200150' 
========================2018-06-25 14:58:33======================== 
UPDATE mac_detail SET  pc_name = 'KCG-PC', os_type = '110', user_id = 'gyu1001', user_name = 'â±ÔÀÚµ¿Â÷[±Çâ±Ô]',
												 screen_w = '1920', screen_h = '1080', cdkey = '224661081956'
								  WHERE mac_idx = '200150'