//ini_set("session.use_trans_sid", "1");
include_once("attackfilter.php");
// $db_username = "ven_car";
// $db_password = "Tk6379z";
// $db_database = "venturn_carrierewijzer";
// $db_hostname = "mysqlserver:3306";
// $db_username = "website";
// $db_password = "Tk6379z";
// $db_database = "venturn_carrierewijzer";
// $db_hostname = "localhost";
$db_username = "u4937_car_wijzer";
$db_password = "-mimdf04)hoiag";
$db_database = "db4937_carrierewijzer";
$db_hostname = "mysql02-int.cp.hostnet.nl";
$connection = mysql_connect($db_hostname, $db_username, $db_password) or die("Failed to connect to MySQL database");
mysql_select_db($db_database);
function filterString($str)
{
/*
$str = str_replace("è", "è", $str);
$str = str_replace("é", "é", $str);
$str = str_replace("ë", "ë", $str);
$str = str_replace("’", "'", $str);
$str = str_replace("‘", "'", $str);
*/
//NOTE: commented this for Tinymce js plugin. Tinymce is converting linebreaks already
//$str = str_replace("\n", "
", $str);
$str = str_replace("’", "'", $str);
$str = str_replace("‘", "'", $str);
$newstr = "";
$strlen = strlen($str);
for($i = 0; $i < $strlen; $i++)
{
$char = $str[$i];
$byte = ord($char);
if($byte >= 161 && $byte <= 255)
{
$newstr .= "".$byte.";";
}
else
{
$newstr .= $char;
}
}
return $newstr;
}
function parseSessionText($sessionid)
{
$retval = array();
$res = mysql_query("SELECT sessiontext FROM tbl_sessions WHERE id = ".$sessionid) or die(mysql_error());
if($session = mysql_fetch_assoc($res))
{
$sessiontext = $session["sessiontext"];
$elements = explode(";", $sessiontext);
foreach($elements as $element)
{
$item = explode("=", $element);
$retval[$item[0]] = $item[1];
}
return $retval;
}
return "";
}
function getSessionTextItem($sessionid, $str)
{
$items = parseSessionText($sessionid);
if($str == "q1.3.Email adres")
{
// hack, but hey.. it works
$items[$str] = str_replace(",", ".", $items[$str]);
}
return $items[$str];
}
function getSettingsValue($name)
{
$res = mysql_query("SELECT value FROM tbl_settings WHERE name = '".$name."'") or die(mysql_error());
if($val = mysql_fetch_assoc($res))
return $val["value"];
return "INVALID SETTING NAME";
}
?>
Maritieme Carrièrewijzer, powered by Venturn
" />
" />