'', 'host'=>gethostname(), //Database Settings 'datahost'=>'localhost', // Refer to database on either server 'database'=>'ultraflix', 'datauser'=>'root', 'datapass'=>'razo5-wire', ); //Update Dynamic Settings $settings['prot'] = (isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] != "off") ? "https" : "http"; if(strripos($settings['host'],'data1') === false && strripos($settings['host'],'data2') === false) $settings['datahost'] = "data1.ultraflix.com"; //So we can run locally - force host name to data1. $uid = request('uid'); $eem = request('eem'); $mysqli = mysqli_connect($settings['datahost'], $settings['datauser'], $settings['datapass'], $settings['database']); echo "

Unsubscribe Email

"; if(($uid !== '') && ($eem !== '')) { if(mysqli_query($mysqli, "UPDATE users SET emailsubscribe=0 WHERE SHA1(id)='$uid' AND SHA1(emailaddress)='$eem'")) echo "Unsubscribe Successful."; else echo "Unsubscribe Failed - Please Contact Support."; } else { echo "To unsubscribe, click the link in your email."; } ?>