function sitemap_forum_get_threads($forum_fid) { if (!($db = db::get())) { return false; } // If there are any problems with the function arguments we bail out. if (!is_numeric($forum_fid)) { return false; } // Constant for Guest access. $user_perm_guest_access = USER_PERM_GUEST_ACCESS; // Get the table prefix from the forum fid if (!($table_prefix = forum_get_table_prefix($forum_fid))) { return false; } $sql = "SELECT THREAD.TID, UNIX_TIMESTAMP(THREAD.MODIFIED) AS MODIFIED "; $sql .= "FROM `{$table_prefix}THREAD` THREAD "; $sql .= "INNER JOIN `{$table_prefix}FOLDER` FOLDER "; $sql .= "ON (FOLDER.FID = THREAD.FID) "; $sql .= "WHERE FOLDER.PERM & {$user_perm_guest_access} > 0 "; $sql .= "ORDER BY THREAD.TID"; if (!($result = $db->query($sql))) { return false; } if ($result->num_rows == 0) { return false; } return $result; }
function user_get_relationship($uid, $peer_uid) { if (!($db = db::get())) { return 0; } if (!is_numeric($uid)) { return 0; } if (!is_numeric($peer_uid)) { return 0; } if (!($table_prefix = get_table_prefix())) { return 0; } $sql = "SELECT RELATIONSHIP FROM `{$table_prefix}USER_PEER` "; $sql .= "WHERE UID = '{$uid}' AND PEER_UID = '{$peer_uid}'"; if (!($result = $db->query($sql))) { return 0; } if ($result->num_rows == 0) { return 0; } list($peer_relationship) = $result->fetch_row(); return $peer_relationship; }
public static function saveSession() { $engine = EngineAPI::singleton(); $localvars = localvars::getInstance(); $db = db::get($localvars->get('dbConnectionName')); $sql = "INSERT INTO `session`(username,sessionPages,ipAddr) VALUES(?,?,?)"; $validate = new validate(); $username = session::get('username'); $pages = session::get('loggedPages'); $pages = dbSanitize(implode(',', $pages)); $ip = $_SERVER['REMOTE_ADDR']; $sqlArray = array($username, $pages, $ip); $db->beginTransaction(); try { $sqlResult = $db->query($sql, $sqlArray); if ($sqlResult->error()) { throw new Exception("ERROR SQL" . $sqlResult->errorMsg()); } $db->commit(); } catch (Exception $e) { $db->rollback(); $localvars->set('feedback', $e->getMessage()); errorHandle::errorMsg($e->getMessage()); } }
public function getRecords($id = null) { try { // call engine $engine = EngineAPI::singleton(); $localvars = localvars::getInstance(); $db = db::get($localvars->get('dbConnectionName')); $sql = "SELECT * FROM `timeTracking`"; $validate = new validate(); // test to see if Id is present and valid if (!isnull($id) && $validate->integer($id)) { $sql .= sprintf('WHERE timeID = %s LIMIT 1', $id); } // if no valid id throw an exception if (!$validate->integer($id) && !isnull($id)) { throw new Exception("An invalid ID was given!"); } // get the results of the query $sqlResult = $db->query($sql); // if return no results // else return the data if ($sqlResult->rowCount() < 1) { return "There has been no time tracking done up to this point."; } else { $data = array(); while ($row = $sqlResult->fetch()) { $data[] = $row; } return $data; } } catch (Exception $e) { errorHandle::errorMsg($e->getMessage()); } }
function word_filter_get($uid, &$word_filter_array) { if (!($db = db::get())) { return false; } if (!is_numeric($uid)) { return false; } if (!is_array($word_filter_array)) { $word_filter_array = array(); } if (!($table_prefix = get_table_prefix())) { return false; } $sql = "SELECT FID, MATCH_TEXT, REPLACE_TEXT, FILTER_TYPE "; $sql .= "FROM `{$table_prefix}WORD_FILTER` "; $sql .= "WHERE UID = '{$uid}' AND FILTER_ENABLED = 1 "; $sql .= "ORDER BY FID "; if ($uid != 0) { $sql .= "LIMIT 0, 20"; } if (!($result = $db->query($sql))) { return false; } if ($result->num_rows == 0) { return false; } while ($word_filter_data = $result->fetch_assoc()) { $word_filter_array[] = $word_filter_data; } return true; }
public static function init() { session::$db = db::get(true); if (!ini_get('session.gc_probability')) { @ini_set('session.gc_probability', 1); } if (!ini_get('session.gc_divisor')) { @ini_set('session.gc_divisor', 100); } session_set_save_handler(array('session', 'open'), array('session', 'close'), array('session', 'read'), array('session', 'write'), array('session', 'destroy'), array('session', 'gc')); $hash = null; session_name('sess_hash'); if (!html_get_cookie('sess_hash')) { if ($hash = session::restore()) { session_id($hash); } else { html_set_cookie('user_logon', '', time() - YEAR_IN_SECONDS); html_set_cookie('user_token', '', time() - YEAR_IN_SECONDS); } } session_start(); if (!isset($_SESSION['UID'])) { $_SESSION['UID'] = 0; } if (!is_null($hash)) { session::refresh_csrf_token(); } }
public static function get_version() { $db = db::get(); $sql = "SELECT VERSION() AS version"; if (!($result = $db->query($sql))) { return false; } if (!($version_data = $result->fetch_assoc())) { $sql = "SHOW VARIABLES LIKE 'version'"; if (!($result = $db->query($sql))) { return false; } $version_data = $result->fetch_assoc(); } $version_array = explode('.', $version_data['version']); if (!isset($version_array[0])) { $version_array[0] = 3; } if (!isset($version_array[1])) { $version_array[1] = 21; } if (!isset($version_array[2])) { $version_array[2] = 0; } return sprintf('%d.%d.%d', $version_array[0], $version_array[1], intval($version_array[2])); }
function mods_list_forum_leaders() { if (!($db = db::get())) { return false; } $mod_list_array = array(); if (!($table_prefix = get_table_prefix())) { return false; } if (!($forum_fid = get_forum_fid())) { return false; } $user_perm_admin_tools = USER_PERM_ADMIN_TOOLS; $sql = "SELECT USERS.UID, USERS.LOGON, COALESCE(USER_PEER.PEER_NICKNAME, USERS.NICKNAME) AS NICKNAME "; $sql .= "FROM ((SELECT DISTINCT USER.UID, USER.LOGON, USER.NICKNAME FROM USER INNER JOIN GROUP_USERS "; $sql .= "ON (GROUP_USERS.UID = USER.UID) INNER JOIN GROUP_PERMS ON (GROUP_PERMS.GID = GROUP_USERS.GID) "; $sql .= "INNER JOIN GROUPS ON (GROUPS.GID = GROUP_PERMS.GID) WHERE GROUPS.FORUM IN (0, {$forum_fid}) "; $sql .= "AND GROUP_PERMS.FID IN (0) AND GROUP_PERMS.PERM & {$user_perm_admin_tools}) UNION ALL "; $sql .= "(SELECT DISTINCT USER.UID, USER.LOGON, USER.NICKNAME FROM USER INNER JOIN USER_PERM "; $sql .= "ON (USER_PERM.UID = USER.UID) WHERE USER_PERM.FORUM IN (0, {$forum_fid}) AND USER_PERM.FID IN (0) "; $sql .= "AND USER_PERM.PERM & {$user_perm_admin_tools} > 0)) AS USERS LEFT JOIN `{$table_prefix}USER_PEER` USER_PEER "; $sql .= "ON (USER_PEER.PEER_UID = USERS.UID AND USER_PEER.UID = {$_SESSION['UID']})"; if (!($result = $db->query($sql))) { return false; } if ($result->num_rows == 0) { return false; } while (($mod_list_data = $result->fetch_assoc()) !== null) { $mod_list_array[$mod_list_data['UID']] = $mod_list_data; } return $mod_list_array; }
protected function afterInit() { parent::afterInit(); $this->session = session::getInstance(array( 'nameSpace'=>$this->cfg->sessionNameSpace )); $this->table = db::get('table', $this->cfg->table); $this->autoLogin(); }
function replace() { $page_id = params::get('page_id'); db::table('pages'); db::limit(1); db::where('page_id', $page_id); $page_folder = db::get('page_folder'); headers::url($page_folder); //self::loadPage(); }
static function getNameByID($db = NULL, $fach_id) { require_once '/../db/db.class.php'; if ($db == NULL) { $db = new db(); } $result = $db->get('fach_name', 'fach', 'fach_id=' . $fach_id); while ($row = mysql_fetch_assoc($result)) { return $row['fach_name']; } }
function ajax_chat_online_user_count() { if (!($db = db::get())) { return 0; } $config = ajax_chat_get_config(); $ajax_chat_online = $db->escape($config['dbTableNames']['online']); $sql = "SELECT COUNT(*) FROM `{$ajax_chat_online}`"; $result = $db->query($sql); list($ajax_chat_online_users) = $result->fetch_row(); return $ajax_chat_online_users; }
function start() { db::connect(); if (!router::get(1)) { return true; } self::$map = array('mode' => router::get(0), 'app' => router::get(1), 'module' => 'main', 'action' => router::get(2), 'id' => router::get(4)); s::set('SYS_PATH', 'http://' . SERVER . SYS_DIR); define('APP', APPS . self::get('app') . '/'); s::set('APP', APP); define('MODULE', APP . self::get('module') . '/'); s::set('MODULE', MODULE); if (stristr(self::$map['mode'], 'admin')) { self::$map['mode'] = 'admin'; } else { self::$map['mode'] = 'web'; } if (self::$map['mode'] == 'admin') { if (defined('ADMIN_USER_SITE_ID')) { admin::observer(); define('ADMIN_SITE_ID', ADMIN_USER_SITE_ID); s::set('ADMIN_SITE_ID', ADMIN_USER_SITE_ID); db::table('admin_sites'); db::where('site_id', ADMIN_USER_SITE_ID); db::limit(1); $row = db::select(); define('ADMIN_SITE', db::get('site_domain')); s::set('ADMIN_SITE', ADMIN_SITE); } } else { web::getSite(); $lang = lang::gets(LANG_INDEX, SITE_ID); /* Authentification webUser */ web::observer(); } /* Set params */ params::send(); if (router::get(0) == 'feed' || router::get(0) == 'rss') { self::$map['module'] = 'feed'; } if (self::$map['mode'] == 'admin') { load::module(self::get('app'), self::get('module'), self::get('action')); } else { load::handler(self::get('app'), self::get('module'), self::get('action')); } }
static function user() { if (!self::$optionsset) { self::$optionsset = true; $options = db::get()->assoc('SELECT name, value FROM options WHERE user_id = :user_id', array('user_id' => self::$user->id)); foreach ($options as $k => $v) { $k = strtolower($k); self::$user->{$k} = $v; } } if (self::$user->nickname == '') { self::$user->nickname = self::$user->username; } return self::$user; }
function auth($username, $password) { $db = new db("users"); $query = $db->get($username); if (is_array($query)) { if (sha1($password) == $query['password']) { $this->session($query); return true; } else { return false; } } else { return false; } }
public static function init() { session::$db = db::get(true); session_set_save_handler(array('session', 'open'), array('session', 'close'), array('session', 'read'), array('session', 'write'), array('session', 'destroy'), array('session', 'gc')); session_name('sess_hash'); if (!html_get_cookie('sess_hash') && ($hash = session::restore())) { session_id($hash); } session_start(); session::refresh(session::get_value('UID')); if (session::logged_in()) { html_set_cookie('sess_uid', session::get_value('UID')); } else { html_set_cookie('sess_uid', '', time() - YEAR_IN_SECONDS); } }
function git_mysql_output_log($log_filename = null) { if (!($db = db::get())) { return false; } $sql = "SELECT UNIX_TIMESTAMP(DATE) AS DATE, AUTHOR, COMMENTS "; $sql .= "FROM BEEHIVE_GIT_LOG GROUP BY DATE ORDER BY DATE DESC"; if (!($result = $db->query($sql))) { return false; } if ($result->num_rows == 0) { echo "Table BEEHIVE_GIT_LOG is empty. No Changelog generated.\n"; exit; } $git_log_entry_author = ''; $git_log_entry_date = ''; ob_start(); printf("# Beehive Forum Change Log (Generated: %s)\n\n", gmdate('D, d M Y H:i:s')); while ($git_log_entry_array = $result->fetch_assoc()) { if (preg_match_all('/^((Fixed|Changed|Added):)\\s*(.+)/im', $git_log_entry_array['COMMENTS'], $git_log_entry_matches_array, PREG_SET_ORDER) > 0) { if ($git_log_entry_date != $git_log_entry_array['DATE']) { $git_log_entry_date = $git_log_entry_array['DATE']; printf("## Date: %s\n\n", gmdate('D, d M Y', $git_log_entry_date)); } foreach ($git_log_entry_matches_array as $git_log_entry_matches) { $git_log_comment = trim(preg_replace("/(\r|\r\n|\n)/", '', $git_log_entry_matches[3])); $git_log_comment = str_replace('_', '\\_', htmlentities($git_log_comment)); $git_log_comment_array = explode("\n", wordwrap($git_log_comment, 70 - (strlen($git_log_entry_matches[2]) + 4), "\n")); foreach ($git_log_comment_array as $line => $git_log_comment_line) { if ($line == 0) { sprintf('- %s: ', $git_log_entry_matches[2]); } else { echo str_repeat(' ', strlen($git_log_entry_matches[2]) + 4); } echo $git_log_comment_line, "\n"; } } echo "\n"; } } if (isset($log_filename)) { file_put_contents($log_filename, ob_get_clean()); exit; } echo ob_get_clean(); }
/** * Parse values send through POST data and eventually add the new ones * * @param array $values Valeus to parse * @return array Values to use */ protected function addNew(array $values) { $new = isset($values['new']) && is_array($values['new']) ? array_filter($values['new']) : null; unset($values['new']); if ($this->cfg->allowAdd && count($new) && is_array($new)) { $dbList = $this->cfg->dbList; if (is_array($dbList) && $dbList['table']) { $tbl = db::get('table', $dbList['table']); $list = utils::htmlDeOut($this->cfg->list); $i18n = isset($dbList['i18nFields']) && $dbList['i18nFields']; if (!$i18n) { $field = substr($dbList['fields'], strlen($dbList['ident']) + 1); } foreach ($new as $v) { $exists = array_search($v, $list); if ($exists === false) { $row = $tbl->getRow(); if ($i18n) { $i18nRow = $row->getI18nRow(); $i18nRow->set($dbList['i18nFields'], $v); } else { $row->set($field, $v); } $id = $row->save(); $values[] = $id; $list[$id] = $v; } else { $values[] = $exists; } } $this->cfg->list = utils::htmlOut($list); if (is_array($this->cfg->list)) { $this->addRule('in', array_keys($this->cfg->list)); } } } return $values; }
function mods_list_get_mods($fid) { if (!($db = db::get())) { return false; } $mod_list_array = array(); if (!($table_prefix = get_table_prefix())) { return false; } if (!($forum_fid = get_forum_fid())) { return false; } $sql = "SELECT USER.UID, USER.LOGON, USER.NICKNAME FROM USER USER "; $sql .= "LEFT JOIN GROUP_USERS GROUP_USERS ON (GROUP_USERS.UID = USER.UID) "; $sql .= "LEFT JOIN GROUP_PERMS GROUP_PERMS ON (GROUP_PERMS.GID = GROUP_USERS.GID) "; $sql .= "WHERE GROUP_PERMS.FID IN (0, {$fid}) AND GROUP_PERMS.FORUM IN (0, {$forum_fid}) "; if ($fid > 0) { $user_perm_folder_moderate = USER_PERM_FOLDER_MODERATE; $sql .= "AND (GROUP_PERMS.PERM & {$user_perm_folder_moderate}) > 0 "; } else { $user_perm_admin_tools = USER_PERM_ADMIN_TOOLS; $user_perm_folder_moderate = USER_PERM_FOLDER_MODERATE; $sql .= "AND ((GROUP_PERMS.PERM & {$user_perm_admin_tools}) > 0 "; $sql .= "OR (GROUP_PERMS.PERM & {$user_perm_folder_moderate}) > 0) "; } if (!($result = $db->query($sql))) { return false; } if ($result->num_rows == 0) { return false; } while ($mod_list_data = $result->fetch_assoc()) { $mod_list_array[$mod_list_data['UID']] = $mod_list_data; } return $mod_list_array; }
function render($page, $save = false) { $render = new render(); $components = new db("components"); $keys = array_keys($page); $html = ""; foreach ($keys as $key) { if ($key != "page" && $key != "endpoint" && $key != "layout") { $strkey = str_replace("_", " ", $key); $query = $components->get($strkey); if (is_array($query)) { $page[$key]["template"] = $query['filename']; $page[$key]["key"] = $key; } } } $title = $page['page']; $endpoint = $page['endpoint']; $layout = isset($page['layout']) ? $page['layout'] : false; $variables = new db("variables"); $pages = new db("pages"); $layouts = new db("layouts"); $headFoot = false; $array = array(); $names = array(); $values = array(); unset($page['page']); unset($page['endpoint']); unset($page['layout']); foreach ($page as $item) { foreach ($item as $k => $x) { if (is_array($x)) { foreach ($x as $n => $v) { if ($n == "name") { $names[] = $v; } if ($n == "value") { if ($v == "on") { $v = true; } $values[] = $v; } } } } $array = array_combine($names, $values); $array["variables"] = $variables->all(); $array["pages"] = $pages->all(); if ($layout) { $custom = $layouts->get($layout); $array['custom'] = array("js" => $custom['customjs'], "css" => $custom['customcss']); } if ($render->exists("header.twig", "frontend") && $render->exists("footer.twig", "frontend")) { $headFoot = true; $html .= $render->render("layout/header.twig", $array, "frontend"); } if (isset($item['template'])) { $html .= $render->render("component/" . $item['template'], $array, "frontend"); } else { $html .= "<p>Component Not Found.</p>"; } if ($headFoot) { $html .= $render->render("layout/footer.twig", $array, "frontend"); } } if ($save) { return $html; } echo $html; die; }
public function get() { return db::get($this->sql(__FUNCTION__)); }
function forums_get_available_count() { if (!($db = db::get())) { return false; } if (($uid = session::get_value('UID')) === false) { return 0; } $sql = "SELECT COUNT(FORUMS.FID) FROM FORUMS FORUMS "; $sql .= "LEFT JOIN USER_FORUM USER_FORUM ON (USER_FORUM.FID = FORUMS.FID "; $sql .= "AND USER_FORUM.UID = '{$uid}') WHERE FORUMS.ACCESS_LEVEL = 0 "; $sql .= "OR FORUMS.ACCESS_LEVEL = 2 OR (FORUMS.ACCESS_LEVEL = 1 "; $sql .= "AND USER_FORUM.ALLOWED = 1) "; if (!($result = $db->query($sql))) { return false; } list($forum_available_count) = $result->fetch_row(); return $forum_available_count; }
function forums_get_available_count() { if (!($db = db::get())) { return false; } if (!isset($_SESSION['UID']) || !is_numeric($_SESSION['UID'])) { return false; } $sql = "SELECT COUNT(FORUMS.FID) FROM FORUMS FORUMS "; $sql .= "LEFT JOIN USER_FORUM USER_FORUM ON (USER_FORUM.FID = FORUMS.FID "; $sql .= "AND USER_FORUM.UID = '{$_SESSION['UID']}') WHERE FORUMS.ACCESS_LEVEL = 0 "; $sql .= "OR FORUMS.ACCESS_LEVEL = 2 OR (FORUMS.ACCESS_LEVEL = 1 "; $sql .= "AND USER_FORUM.ALLOWED = 1) "; if (!($result = $db->query($sql))) { return false; } list($forum_available_count) = $result->fetch_row(); return $forum_available_count; }
function install_import_dictionary($dictionary_path) { if (!@file_exists("{$dictionary_path}/english.dic")) { return false; } if (!is_readable("{$dictionary_path}/english.dic")) { return false; } if (!($db = db::get())) { return false; } try { $sql = "LOAD DATA INFILE '{$dictionary_path}/english.dic' "; $sql .= "INTO TABLE DICTIONARY LINES TERMINATED BY '\\n' (WORD)"; @$db->query($sql); } catch (Exception $e) { $dictionary_words_array = file("{$dictionary_path}/english.dic"); foreach ($dictionary_words_array as $word) { $word = $db->escape(trim($word)); $sql = "INSERT INTO DICTIONARY (WORD) VALUES('{$word}')"; if (!@$db->query($sql)) { return false; } } } $sql = "UPDATE DICTIONARY SET SOUND = SOUNDEX(WORD)"; if (!@$db->query($sql)) { return false; } return true; }
function links_get_comment_uid($cid) { if (!($db = db::get())) { return false; } if (!is_numeric($cid)) { return false; } if (!($table_prefix = get_table_prefix())) { return false; } $sql = "SELECT UID FROM `{$table_prefix}LINKS_COMMENT` WHERE CID = '{$cid}'"; if (!($result = $db->query($sql))) { return false; } if ($result->num_rows == 0) { return false; } list($comment_uid) = $result->fetch_row(); return $comment_uid; }
function thread_has_attachments(&$thread_data) { if (!isset($thread_data['TID'])) { return false; } if (!is_numeric($thread_data['TID'])) { return false; } if (!($table_prefix = get_table_prefix())) { return false; } if (!($forum_fid = get_forum_fid())) { return false; } if (!($db = db::get())) { return false; } $sql = "SELECT PAI.TID, PAF.AID FROM POST_ATTACHMENT_IDS PAI "; $sql .= "LEFT JOIN POST_ATTACHMENT_FILES PAF ON (PAF.AID = PAI.AID) "; $sql .= "WHERE PAI.FID = '{$forum_fid}' AND PAI.TID = '{$thread_data['TID']}'"; if (!($result = $db->query($sql))) { return false; } while ($attachment_data = $result->fetch_assoc()) { $thread_data['AID'] = $attachment_data['AID']; } return true; }
/** * Gets a database defined in config by name. * * @param string $name The name of the database to get. * * @return db|null An instance of the database, or null if not found. */ public static function db($name) { if (array_key_exists($name, config::$databases)) { return db::get(config::$databases[$name]); } }
function stats_get_mysql_week(&$week_start, &$week_end) { if (!($stats_get_mysql_week = db::get())) { return false; } $sql = "SELECT UNIX_TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL(DAYOFWEEK(CURDATE()) - 1) DAY)) AS WEEK_START, "; $sql .= "UNIX_TIMESTAMP(DATE_ADD(CURDATE(), INTERVAL(7 - DAYOFWEEK(CURDATE())) DAY)) AS WEEK_END"; if (!($result = $db->query($sql))) { return false; } list($week_start, $week_end) = $result->fetch_row(); return true; }
<?php require_once dirname(__FILE__) . '/class.db.php'; require_once dirname(__FILE__) . '/class.tree.php'; if (isset($_GET['operation'])) { $fs = new tree(db::get('mysqli://root@127.0.0.1/test'), array('structure_table' => 'tree_struct', 'data_table' => 'tree_data', 'data' => array('nm'))); try { $rslt = null; switch ($_GET['operation']) { case 'analyze': var_dump($fs->analyze(true)); die; break; case 'get_node': $node = isset($_GET['id']) && $_GET['id'] !== '#' ? (int) $_GET['id'] : 0; $temp = $fs->get_children($node); $rslt = array(); foreach ($temp as $v) { $rslt[] = array('id' => $v['id'], 'text' => $v['nm'], 'children' => $v['rgt'] - $v['lft'] > 1); } break; case "get_content": $node = isset($_GET['id']) && $_GET['id'] !== '#' ? $_GET['id'] : 0; $node = explode(':', $node); if (count($node) > 1) { $rslt = array('content' => 'Multiple selected'); } else { $temp = $fs->get_node((int) $node[0], array('with_path' => true)); $rslt = array('content' => 'Selected: /' . implode('/', array_map(function ($v) { return $v['nm']; }, $temp['path'])) . '/' . $temp['nm']);
function post_delete($tid, $pid) { if (!is_numeric($tid)) { return false; } if (!is_numeric($pid)) { return false; } if (!($table_prefix = get_table_prefix())) { return false; } if (!($db = db::get())) { return false; } if (($approve_uid = session::get_value('UID')) === false) { return false; } $current_datetime = date(MYSQL_DATETIME, time()); if (thread_is_poll($tid) && $pid == 1) { $sql = "UPDATE LOW_PRIORITY `{$table_prefix}THREAD` SET POLL_FLAG = 'N', "; $sql .= "MODIFIED = CAST('{$current_datetime}' AS DATETIME) WHERE TID = '{$tid}'"; if (!$db->query($sql)) { return false; } } $sql = "UPDATE LOW_PRIORITY `{$table_prefix}THREAD` SET DELETED = 'Y', "; $sql .= "MODIFIED = CAST('{$current_datetime}' AS DATETIME) WHERE TID = '{$tid}' AND LENGTH = 1"; if (!$db->query($sql)) { return false; } $sql = "UPDATE LOW_PRIORITY `{$table_prefix}POST_CONTENT` SET CONTENT = NULL "; $sql .= "WHERE TID = '{$tid}' AND PID = '{$pid}'"; if (!$db->query($sql)) { return false; } $sql = "UPDATE LOW_PRIORITY `{$table_prefix}POST` "; $sql .= "SET APPROVED = CAST('{$current_datetime}' AS DATETIME), "; $sql .= "APPROVED_BY = '{$approve_uid}' WHERE TID = '{$tid}' "; $sql .= "AND PID = '{$pid}'"; if (!$db->query($sql)) { return false; } return true; }