

========================2018-08-16 09:05:04======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = MYPC 
parm_os_type = 110 
parm_screen_w = 1536 
parm_screen_h = 864 
parm_user_mac = 24F5AAD7ACD870900801 
sCDKey = 215205657284 
sName = MYPC 
========================2018-08-16 09:05:04======================== 
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 = '215205657284' 
			AND r.app_code = '039'
			AND r.app_block = 0 


========================2018-08-16 09:05:23======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = MYPC 
parm_os_type = 110 
parm_screen_w = 1536 
parm_screen_h = 864 
parm_user_mac = 24F5AAD7ACD870900801 
sCDKey = 212505657284 
sName = MYPC 
========================2018-08-16 09:05: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 = '212505657284' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2018-08-16 09:05:23======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'irem'  
========================2018-08-16 09:05:23======================== 
SELECT idx FROM macs WHERE mac_addr = '24F5AAD7ACD870900801' AND app_code = '039' 
========================2018-08-16 09:05:23======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '257132' 
========================2018-08-16 09:05:23======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '257132' 
========================2018-08-16 09:05: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	 ( '257132', '24F5AAD7ACD870900801', '039', 'MYPC', '110', '1536', '864', 'irem', '아이렘에듀[김지후]', '212505657284'  ) 


========================2018-08-16 09:05:34======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = MYPC 
parm_os_type = 110 
parm_screen_w = 1536 
parm_screen_h = 864 
parm_user_mac = 24F5AAD7ACD870900801 
sCDKey = 212505657284 
sName = MYPC 
========================2018-08-16 09:05: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 = '212505657284' 
			AND r.app_code = '039'
			AND r.app_block = 0 


========================2018-08-16 10:39:12======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = TITAN-S260 
parm_os_type = 90 
parm_screen_w = 1024 
parm_screen_h = 768 
parm_user_mac = B8975AFC592B20A240CA 
sCDKey = 827806997089 
sName = whenguss1 
========================2018-08-16 10:39: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 = '827806997089' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2018-08-16 10:39:12======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'whenguss1'  
========================2018-08-16 10:39:12======================== 
SELECT idx FROM macs WHERE mac_addr = 'B8975AFC592B20A240CA' AND app_code = '046' 
========================2018-08-16 10:39:12======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '257307' 
========================2018-08-16 10:39:12======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '257307' 
========================2018-08-16 10:39:12======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '257307', 'B8975AFC592B20A240CA', '046', 'whenguss1', '90', '1024', '768', 'whenguss1', '안다트레이딩[조두현]', '827806997089'  ) 


========================2018-08-16 13:31:47======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = WIN-G29BO9RKPOJ 
parm_os_type = 90 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 54EE758EF0A92E448524 
sCDKey = 971342867571 
sName = WIN-G29BO9RKPOJ 
========================2018-08-16 13:31:47======================== 
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 = '971342867571' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2018-08-16 13:31:47======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'mtdst30'  
========================2018-08-16 13:31:47======================== 
SELECT idx FROM macs WHERE mac_addr = '54EE758EF0A92E448524' AND app_code = '039' 
========================2018-08-16 13:31:47======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '257329' 
========================2018-08-16 13:31:47======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '257329' 
========================2018-08-16 13:31:47======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '257329', '54EE758EF0A92E448524', '039', 'WIN-G29BO9RKPOJ', '90', '1920', '1080', 'mtdst30', '주식회사에스하이테크[유용훈]', '971342867571'  ) 


========================2018-08-16 17:03:11======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = USER-PC 
parm_os_type = 90 
parm_screen_w = 1024 
parm_screen_h = 768 
parm_user_mac = C07CD1A52C57A41C65F 
sCDKey = 636408434291 
sName = GNG02 
========================2018-08-16 17:03:11======================== 
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 = '636408434291' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2018-08-16 17:03:11======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'smkw2015'  
========================2018-08-16 17:03:11======================== 
SELECT idx FROM macs WHERE mac_addr = 'C07CD1A52C57A41C65F' AND app_code = '046' 
========================2018-08-16 17:03:11======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '171783' 
========================2018-08-16 17:03:11======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '171783' 
========================2018-08-16 17:03:11======================== 
UPDATE mac_detail SET  pc_name = 'GNG02', os_type = '90', user_id = 'smkw2015', user_name = '스마트종합주방[심성희]',
												 screen_w = '1024', screen_h = '768', cdkey = '636408434291'
								  WHERE mac_idx = '171783'  


========================2018-08-16 17:03:38======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = USER-PC 
parm_os_type = 90 
parm_screen_w = 1024 
parm_screen_h = 768 
parm_user_mac = C07CD1A52B9EA41C65F 
sCDKey = 636408434291 
sName = GNG01 
========================2018-08-16 17:03: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 = '636408434291' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2018-08-16 17:03:38======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'smkw2015'  
========================2018-08-16 17:03:38======================== 
SELECT idx FROM macs WHERE mac_addr = 'C07CD1A52B9EA41C65F' AND app_code = '046' 
========================2018-08-16 17:03:38======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '171786' 
========================2018-08-16 17:03:38======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '171786' 
========================2018-08-16 17:03:38======================== 
UPDATE mac_detail SET  pc_name = 'GNG01', os_type = '90', user_id = 'smkw2015', user_name = '스마트종합주방[심성희]',
												 screen_w = '1024', screen_h = '768', cdkey = '636408434291'
								  WHERE mac_idx = '171786'