if (!defined('STATUS_ACTIVE')) {
define('STATUS_EDIT', 0x00);
define('STATUS_ACTIVE', 0x01);
define('STATUS_DONE', 0x02);
define('STATUS_DELETED', 0x04);
define('STATUS_TEST', 0x08);
}
if(get_magic_quotes_gpc()) {
function _addslashes($a) { return(db_qstr(stripslashes($a))); }
function _stripslashes($a) { return(stripslashes($a)); }
} else {
function _addslashes($a) { return(db_qstr($a)); }
function _stripslashes($a) { return($a); }
}
set_magic_quotes_runtime(0);
// If there are any errors in the standard libraries we want to know!
error_reporting(E_ALL);
function esp_where($where = null)
{
$cfg =& $GLOBALS['ESPCONFIG'];
if(empty($where))
$where = 'index';
$where = strtolower(ereg_replace(' +','_',$where));
if(!ereg('^[A-Za-z0-9_]+$',$where)) // Valid chars are [A-Za-z0-9_]
$where = 'index';
if(!file_exists($cfg['include_path'].'/where/'.$where.$cfg['extension']))
$where = 'index';
if(!file_exists($cfg['include_path'].'/where/'.$where.$cfg['extension'])) {
echo(''. _('Unable to open include file. Check INI settings. Aborting.'). '');
exit;
}
return($cfg['include_path'].'/where/'.$where.$cfg['extension']);
}
function esp_init_adodb() {
$cfg =& $GLOBALS['ESPCONFIG'];
if(!file_exists($cfg['adodb_path'].'adodb.inc.php')) {
echo(''. _('Unable to open ADODB include file. Check INI settings. Aborting.'). '');
exit;
}
else {
include($cfg['adodb_path'].'adodb.inc.php');
}
if (isset($cfg['adodb_conn'])) {
return;
}
$cfg['adodb_conn'] = &ADONewConnection($cfg['adodb_database_type']);
error_reporting(0); // Hide errors
//$cfg['adodb_conn']->debug=1;
if ($cfg['adodb_database_type'] == "sqlite") {
$dbconnected = $cfg['adodb_conn']->Connect($cfg['adodb_pathto_db']);
}
else {
if (!isset($cfg['adodbi_persist']) or
(isset($cfg['adodb_persist']) && $cfg['adodb_persist'])) {
// Use persistent connection (default)
$dbconnected = $cfg['adodb_conn']->PConnect($cfg['db_host'], $cfg['db_user'], $cfg['db_pass'], $cfg['db_name']);
} else {
// Use single connection
$dbconnected = $cfg['adodb_conn']->Connect($cfg['db_host'], $cfg['db_user'], $cfg['db_pass'], $cfg['db_name']);
}
}
if (!$dbconnected) {
header('HTTP/1.0 503 '. _('Service Unavailable'));
echo('HTTP 503 '. _('Service Unavailable') .'');
echo('
HTTP 503 '. _('Service Unavailable') .'
');
echo(mkerror(_('Connection to database failed. Please check configuration.')));
if ($cfg['DEBUG']) {
echo(" \n". mkerror(ErrorNo().": ".ErrorMsg()));
}
echo('');
exit;
}
error_reporting(E_ALL); // Show errors from now on.
}
// redirect to thank you page for survey ID 'sid'
// exits PHP!
function goto_thankyou($sid,$referer) {
// submitting a survey for good
esp_require_once('/lib/espsurveystat');
survey_stat_decrement(SURVEY_STAT_ABANDONED, $sid);
survey_stat_increment(SURVEY_STAT_COMPLETED, $sid);
// render the thank you page
$cfg =& $GLOBALS['ESPCONFIG'];
$sql = "SELECT thanks_page,thank_head,thank_body FROM ".$cfg['survey_table']." WHERE id=${sid}";
$result = execute_sql($sql);
list($thank_url,$thank_head,$thank_body) = fetch_row($result);
db_close($result);
$thank_url = str_replace("\r", '', $thank_url);
$thank_url = str_replace("%0d", '', $thank_url);
$thank_url = str_replace("\n", '', $thank_url);
$thank_url = str_replace("%0a", '', $thank_url);
$thank_url = str_replace("\t", '', $thank_url);
$thank_url = str_replace("\0", '', $thank_url);
if(!empty($thank_url)) {
if(!headers_sent()) {
header("Location: $thank_url");
exit;
}
?>
$thank_head ";
echo "
$thank_body
";
if ($GLOBALS['ESPCONFIG']['dashboard_enable']) {
?>
Return ";
} else {
$ref = "";
}
}
else {
$ref = check_referer($referer);
}
echo $ref;
return;
}
function check_referer($referer) {
$pos = strpos($referer, $GLOBALS['ESPCONFIG']['autopub_url']);
if ($pos === false) {
if (!empty($_REQUEST['direct']) && $_REQUEST['direct'] === '1') {
$retstr = "";
} else {
if ($GLOBALS['ESPCONFIG']['limit_double_postings']==0) {
$retstr = "Return";
} else {
$retstr = "";
}
}
} else {
$retstr = "";
}
return $retstr;
}
// {{{ blur() Go to a different URL, using the best method possible given the current output state
// NOTE: Does not return.
function blur($url, $forwardingLabel = 'Please click here to continue...') {
// close the session, as it's no longer needed and we don't want to delay waiters
session_write_close();
// make sure the URL is absolute, as the Location: header requires it
if (0 !== strpos($url, 'http')) {
$url = rtrim($GLOBALS['ESPCONFIG']['base_url'], '/') . '/' . ltrim($url, '/');
}
// go elsewhere
if (headers_sent()) {
echo <<
window.location = "$url";
EOHTML;
} else {
header(sprintf('Location: %s', $url));
}
// go no further
exit(0);
}
// }}}
function goto_saved($sid, $url) {
// sticking a survey for later
esp_require_once('/lib/espsurveystat');
survey_stat_decrement(SURVEY_STAT_ABANDONED, $sid);
survey_stat_increment(SURVEY_STAT_SUSPENDED, $sid);
?>