

========================2018-09-13 15:11:23======================== 
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 = BC5FF40942DFEE1999FD 
sCDKey = 991729901884 
sName = USER-PC 
========================2018-09-13 15:11: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 = '991729901884' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2018-09-13 15:11:23======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'rdk9284'  
========================2018-09-13 15:11:23======================== 
SELECT idx FROM macs WHERE mac_addr = 'BC5FF40942DFEE1999FD' AND app_code = '039' 
========================2018-09-13 15:11:23======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '259975' 
========================2018-09-13 15:11:23======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '259975' 
========================2018-09-13 15:11: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	 ( '259975', 'BC5FF40942DFEE1999FD', '039', 'USER-PC', '90', '1920', '1080', 'rdk9284', '하나 주식회사 농업회사 법인[노동균]', '991729901884'  ) 


========================2018-09-13 16:01:33======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = USER-PC1 
parm_os_type = 90 
parm_screen_w = 1600 
parm_screen_h = 900 
parm_user_mac = 1078D21D052696094CD4 
sCDKey = 945303690342 
sName = USER-PC1 
========================2018-09-13 16:01: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 = '945303690342' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2018-09-13 16:01:33======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'dhhwang71'  
========================2018-09-13 16:01:33======================== 
SELECT idx FROM macs WHERE mac_addr = '1078D21D052696094CD4' AND app_code = '039' 
========================2018-09-13 16:01:33======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '259982' 
========================2018-09-13 16:01:33======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '259982' 
========================2018-09-13 16:01:33======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '259982', '1078D21D052696094CD4', '039', 'USER-PC1', '90', '1600', '900', 'dhhwang71', '내쇼날플라스틱 엔피씨[황대홍]', '945303690342'  ) 


========================2018-09-13 17:27:28======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = HPCOM-PC 
parm_os_type = 90 
parm_screen_w = 1440 
parm_screen_h = 900 
parm_user_mac = 78ACC0B4B3591CEE43FD 
sCDKey = 504321129832 
sName = HPCOM-PC 
========================2018-09-13 17:27:28======================== 
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 = '504321129832' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2018-09-13 17:27:28======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'jesus6018'  
========================2018-09-13 17:27:28======================== 
SELECT idx FROM macs WHERE mac_addr = '78ACC0B4B3591CEE43FD' AND app_code = '039' 
========================2018-09-13 17:27:28======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '259999' 
========================2018-09-13 17:27:28======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '259999' 
========================2018-09-13 17:27:28======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '259999', '78ACC0B4B3591CEE43FD', '039', 'HPCOM-PC', '90', '1440', '900', 'jesus6018', '현대윤활유상사[박노철]', '504321129832'  )