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;
}
