function sql_query($sql)
{
if ($sql == "") {
return true;
}
if (DEBUG_SQL and !sys_strbegins($sql, "select ") and !strpos($sql, "simple_sys_stats")) {
debug_sql("INFO " . $sql, "");
}
if (SETUP_DB_TYPE == "mysqli") {
return mysqli_query(sys::$db, $sql);
} else {
if (SETUP_DB_TYPE == "pgsql") {
return @pg_query(sys::$db, $sql);
} else {
if (SETUP_DB_TYPE == "sqlite") {
return sys::$db->query($sql);
}
}
}
return true;
}
/**
* The function which calls everything from the controller
* and render the template(s).
* @param mixed template The template variable, holds all current
* template information
* @param mixed session The session variable, holds all current
* session information
* @return method template render
* @see Template
* @see Session
*/
function Execute(&$template)
{
global $_DBA, $_URL, $_SETTINGS;
/**
* General Variable Setting
*/
/* Start the timer */
$this->timer =& new Timer();
/* Merge the post and get arrays */
$request = array_merge($this->get, $this->post, $this->cookie);
/* Strip annoying slashes on everything */
foreach ($request as $key => $val) {
if (!is_array($val)) {
$request[$key] = stripslashes($val);
}
}
$result = FALSE;
/* Get the act var */
$act_var = get_setting('application', 'action_var') or $act_var = 'act';
/* get the session and user variables */
$session =& $_SESSION;
$user =& $_SESSION['user']->info;
/**
* Member/Guest Settings
*/
/* Figure out which styleset, imageset and templateset to use */
$styleset = is_a($session['user'], 'Member') && $user['styleset'] != '' || is_a($session['user'], 'Guest') && $user['styleset'] != '' ? $user['styleset'] : $template->getVar('styleset');
$imageset = is_a($session['user'], 'Member') && $user['imgset'] != '' ? $user['imgset'] : $template->getVar('imageset');
$templateset = is_a($session['user'], 'Member') && $user['tplset'] != '' ? $user['tplset'] : $template->getVar('templateset');
/* Set the style, template and image sets */
$this->template->setVar('css_styles', get_cached_styleset($styleset, $template->getVar('styleset')));
$template_dir = FORUM_BASE_DIR . DIRECTORY_SEPARATOR . 'templates' . DIRECTORY_SEPARATOR;
$imgs_dir = FORUM_BASE_DIR . DIRECTORY_SEPARATOR . 'Images' . DIRECTORY_SEPARATOR;
/* Should we get the template set that goes with this styleset? */
$templateset = is_dir($template_dir . $styleset) ? $template_dir . $styleset : $template_dir . $templateset;
/* Should we get the image set that goes with this styleset? */
$imageset = is_dir($imgs_dir . $styleset) ? $styleset : $imageset;
/* Check to see if our templates directory exists */
if (!is_dir($templateset)) {
exit('Invalid template set for: ' . $templateset);
}
/* Check to see if our images directory exists */
if (!is_dir($imgs_dir . $imageset)) {
exit('Invalid image set for: ' . $imageset);
}
/* Set the template an image sets */
$this->template->setDirname($templateset);
$this->template->setVar('IMG_DIR', $imageset);
/* Determine which language to get, and then include the appropriate file */
$language = is_a($session['user'], 'Member') ? strtolower($user['language']) : strtolower(get_setting('application', 'lang'));
/* Check to see if this is an invalid language file */
if (!file_exists(FORUM_BASE_DIR . '/includes/lang/' . $language . '/lang.php')) {
exit('Invalid Language file.');
}
/* Require the language file */
include FORUM_BASE_DIR . '/includes/lang/' . $language . '/lang.php';
/* Set the language variable to the template */
$template->setVar('LANG', $language);
global $lang;
/* Check if the language function exists */
if (!isset($lang) || !is_array($lang) || empty($lang)) {
exit('Invalid Language file.');
}
/* Set the locale to which language we are using */
setlocale(LC_ALL, $lang['locale']);
/* Set the language array */
$template->setVarArray($lang);
/* Memory Saving */
unset($lang);
/**
* Event Execution
*/
if (get_map($user, 'can_see_board', 'can_view', array()) > $user['perms']) {
/* This user doesn't have permission to see the bb */
$template = BreadCrumbs($template, $template->getVar('L_INFORMATION'));
$template->setInfo('content', $template->getVar('L_YOUNEEDPERMS'));
} else {
if (intval($_SETTINGS['bbactive']) == 0 && $user['perms'] < SUPERMOD) {
/* The board is closed */
$template = BreadCrumbs($template, $template->getVar('L_INFORMATION'));
$template->setInfo('content', $_SETTINGS['bbclosedreason']);
} else {
/* get the result of our event call */
if (isset($request[$act_var]) && isset($this->events[$request[$act_var]])) {
$result = $this->events[$request[$act_var]]->Execute(&$template, $request, &$_DBA, &$session, &$user);
}
/* If the result is false, execute our defaultevent class */
if ($result == FALSE) {
$this->default->Execute(&$template, $request, &$_DBA, &$session, &$user);
}
}
}
/**
* User Information
*/
/* Clear the session and user variables */
$session =& $_SESSION;
$user =& $_SESSION['user']->info;
/**
* Filters
*/
/* Apply each Filter to the request */
for ($i = 0; $i < count($this->filters); $i++) {
$this->filters[$i]->Execute(&$template, &$session, $this->cookie, $this->post, $this->get);
}
/* If the user is logged in, set all of his user info to the template */
if (is_a($session['user'], 'Member')) {
foreach ($user as $key => $val) {
$this->template->setVar('user_' . $key, $val);
}
}
/* Set the number of queries */
$template->setVar('num_queries', $_DBA->num_queries);
/* Set the Load time */
$template->setVar('load_time', $this->timer->__toString());
if (DEBUG_SQL) {
$debug_url =& new Url($_URL->__toString());
$debug_url->args['debug'] = 1;
$template->setVar('debug_url', $debug_url->__toString());
$template->show('sql_debug');
if (isset($request['debug']) && $request['debug'] == 1) {
/* Output our debugged SQL */
debug_sql();
}
}
/* Do the mail queue */
execute_mail_queue();
/* Do the topic queue */
execute_topic_queue();
/**
* Render the template
*/
error::reset();
$template->Render();
if (error::grab()) {
critical_error();
}
}
