| ' . esc_html( $name ) . ' |
|
';
}
}
}
}
/**
* array get_counts(array or id(num))
*
* @param array defined arguments array for returning
*
* @return array array('topics' => 0, 'posts' => 0)
* @since 1.0.0
*
*/
function get_counts( $forumids ): array {
$result = [ 'topics' => 0, 'posts' => 0 ];
$forumids = array_filter( array_map( 'intval', (array) $forumids ) );
if( $forumids ) {
$sql = "SELECT SUM(`topics`) as topics, SUM(`posts`) as posts FROM `" . WPF()->tables->forums . "` WHERE `forumid` IN(" . implode( ',', $forumids ) . ")";
$row = (array) WPF()->db->get_row( $sql, ARRAY_A );
$result['topics'] = (int) wpfval( $row, 'topics' );
$result['posts'] = (int) wpfval( $row, 'posts' );
}
return $result;
}
/**
* array get_layout(array)
*
* @param array defined arguments array for returning
*
* @return int layout id
* @since 1.0.0
*
*/
function get_layout( $args = null ) {
if( is_null( $args ) ) $args = WPF()->current_object['forum'];
if( ! $args ) return 1;
if( $layout = (int) wpfval( $args, 'layout' ) ) return $layout;
if( is_array( $args ) ) {
$default = [
'forumid' => null, // forum id
'topicid' => null, // topic id
'postid' => null, // post id
];
} else {
$default = [
'forumid' => $args, // forumid
'topicid' => null, // topic id
'postid' => null, // post id
];
}
$args = wpforo_parse_args( $args, $default );
if( ! empty( $args ) ) {
if( $args['forumid'] ) {
$layout = (int) wpforo_forum( $args['forumid'], 'layout' );
return ( $layout ?: 1 );
} elseif( $args['topicid'] ) {
$sql = "SELECT `forumid` FROM `" . WPF()->tables->topics . "` WHERE `topicid` = " . intval( $args['topicid'] );
$forumid = WPF()->db->get_var( $sql );
return $this->get_layout( [ 'forumid' => $forumid ] );
} elseif( $args['postid'] ) {
$sql = "SELECT `forumid` FROM `" . WPF()->tables->posts . "` WHERE `postid` = " . intval( $args['postid'] );
$forumid = WPF()->db->get_var( $sql );
return $this->get_layout( [ 'forumid' => $forumid ] );
}
}
return 1;
}
function get_forum_url( $forum ) {
if( ! is_array( $forum ) ) {
if( wpforo_is_id( $forum ) ) {
$forum = $this->get_forum( $forum );
} else {
$forum = [ 'slug' => $forum ];
}
}
if( is_array( $forum ) && ! empty( $forum ) ) {
return wpforo_home_url( utf8_uri_encode( $forum['slug'] ) );
} else {
return wpforo_home_url();
}
}
function get_parents( $forumid, &$relative_ids ) {
if( wpforo_is_db_mysql8() ) {
$relative_ids = $this->__get_parents_mysql8( $forumid );
return;
}
$sql = "SELECT `parentid`, `forumid` FROM `" . WPF()->tables->forums . "` WHERE `forumid` = %d";
$sql = WPF()->db->prepare( $sql, $forumid );
if( WPF()->ram_cache->exists( $sql ) ) {
$forum = WPF()->ram_cache->get( $sql );
} else {
$forum = WPF()->db->get_row( $sql, ARRAY_A );
WPF()->ram_cache->set( $sql, $forum );
}
if( $forum ) {
$relative_ids[] = $forum['forumid'];
if( $forum['parentid'] ) {
$this->get_parents( $forum['parentid'], $relative_ids );
} else {
$relative_ids = array_reverse( $relative_ids );
}
}
}
/**
* @param int $forumid
*
* @return array
*/
private function __get_parents_mysql8( $forumid ) {
$sql = "WITH RECURSIVE `forum_path` AS(
SELECT `forumid`, `parentid`, 0 AS `depth`
FROM `" . WPF()->tables->forums . "`
WHERE `forumid` = %d
UNION
SELECT f.`forumid`, f.`parentid`, `depth` + 1
FROM `" . WPF()->tables->forums . "` f
INNER JOIN `forum_path` fp ON fp.`parentid` <> fp.`forumid` AND fp.`parentid` = f.`forumid`
) SELECT `forumid` FROM `forum_path` ORDER BY `depth` DESC";
$sql = WPF()->db->prepare( $sql, intval( $forumid ) );
if( WPF()->ram_cache->exists( $sql ) ) {
$relative_ids = WPF()->ram_cache->get( $sql );
} else {
$relative_ids = (array) WPF()->db->get_col( $sql );
WPF()->ram_cache->set( $sql, $relative_ids );
}
return $relative_ids;
}
function get_count( $args = [] ) {
$sql = "SELECT SQL_NO_CACHE COUNT(*) FROM `" . WPF()->tables->forums . "`";
if( ! empty( $args ) ) {
$wheres = [];
foreach( $args as $key => $value ) $wheres[] = "`$key` = " . intval( $value );
if( $wheres ) $sql .= " WHERE " . implode( ' AND ', $wheres );
}
return WPF()->db->get_var( $sql );
}
function get_lastinfo( $ids = [] ) {
$lastinfo = [];
if( ! empty( $ids ) ) {
$ids = implode( ',', array_map( 'intval', $ids ) );
$lastinfo = WPF()->db->get_row(
"SELECT `userid` as last_userid, `topicid` as last_topicid, `postid` as last_postid, `created` as last_post_date FROM `" . WPF(
)->tables->posts . "` WHERE `status` = 0 AND `private` = 0 AND forumid IN(" . $ids . ") ORDER BY `created` DESC LIMIT 1",
ARRAY_A
);
}
return $lastinfo;
}
function forums() {
$forums = $this->get_forums( [ 'parentid' => 0 ] );
return $this->children( $forums );
}
function children( $forums, $parentId = 0, $level = 0 ) {
if( empty( $forums ) || ! is_array( $forums ) ) return;
$items = [];
$level = $level + 1;
foreach( $forums as $forum ) {
if( ! isset( $forum['forumid'] ) || ! WPF()->perm->forum_can( 'vf', $forum['forumid'] ) ) continue;
$forum['level'] = $level + 1;
if( $forum['parentid'] == $parentId ) {
$children = $this->children( $forums, $forum['forumid'], $level );
if( $children ) {
$forum['children'] = $children;
}
$items[] = $forum;
}
}
return $items;
}
function dropdown( $forums = [] ) {
if( empty( $forums ) ) {
$forums = $this->forums();
}
foreach( $forums as $forum ) {
if( isset( $forum['level'] ) ) $forum['level'] = $forum['level'] - 2;
$prefix = ( $forum['level'] == 0 ) ? '' : str_repeat( '—', $forum['level'] );
echo '