PHP bbld_filter_forums Examples

Example #1

File: bbpress.php Project: slaFFik/l10n-ru

function wp_bb_get_discuss_sidebar()
{
    global $table_prefix, $wpdb;
    $forum_slimit = get_option('wpbb_limit');
    $filter = bbld_filter_forums();
    if (get_option('wpbb_exdb')) {
        $exbbdb = new wpdb(get_option('wpbb_dbuser'), get_option('wpbb_dbpass'), get_option('wpbb_dbname'), get_option('wpbb_dbhost'));
        $bbtopic = $exbbdb->get_results("SELECT * FROM " . get_option('wpbb_bbprefix') . "topics " . $filter . " ORDER BY topic_time DESC LIMIT {$forum_slimit}");
    } else {
        $bbtopic = $wpdb->get_results("SELECT * FROM " . get_option('wpbb_bbprefix') . "topics " . $filter . " ORDER BY topic_time DESC LIMIT {$forum_slimit}");
    }
    if ($bbtopic) {
        echo '
			<h2>' . sprintf(__("Forum Last %d Discussions", 'bbpress'), $forum_slimit) . '</h2>
			<ul>
		';
        foreach ($bbtopic as $bbtopic) {
            $title_text = wpbb_trim($bbtopic->topic_title, get_option('wpbb_slimit'));
            if (get_option('wpbb_exdb')) {
                $bbforum = $exbbdb->get_row("SELECT * FROM " . get_option('wpbb_bbprefix') . "forums WHERE forum_id = '{$bbtopic->forum_id}'");
            } else {
                $bbforum = $wpdb->get_row("SELECT * FROM " . get_option('wpbb_bbprefix') . "forums WHERE forum_id = '{$bbtopic->forum_id}'");
            }
            if (get_option('wpbb_permalink')) {
                echo '<li><a href="' . get_option('wpbb_path') . '/topic/' . $bbtopic->topic_id . '">' . __("{$title_text}", 'bbpress') . '</a><br />';
                $forum_url = get_option('wpbb_path') . '/forum/' . $bbtopic->forum_id;
            } else {
                echo '<li><a href="' . get_option('wpbb_path') . '/topic.php?id=' . $bbtopic->topic_id . '">' . __("{$title_text}", 'bbpress') . '</a><br />';
                $forum_url = get_option('wpbb_path') . '/forum.php?id=' . $bbtopic->forum_id;
            }
            if (get_option('wpbb_intergrated')) {
                $wpuid = $wpdb->get_row("SELECT * FROM " . $table_prefix . "users WHERE user_login = '******'");
                if ($wpuid) {
                    $user_forum_data = "{$bbtopic->topic_last_poster_name}";
                    $user_forum_data = get_userdata($wpuid->ID);
                    bbld_extra_info($user_forum_data->display_name, $bbforum->forum_name, $forum_url);
                    echo "</li>";
                } else {
                    bbld_extra_info($bbtopic->topic_last_poster_name, $bbforum->forum_name, $forum_url);
                    echo "</li>";
                }
            } else {
                bbld_extra_info($bbtopic->topic_last_poster_name, $bbforum->forum_name, $forum_url);
                echo "</li>";
            }
        }
        echo "</ul>";
    }
}

Example #2

File: BBpress.php Project: niamherinoc/rctractors

function bbld_getdata($type,$forum_slimit = 0, $exclude = 0) {
	global $wpdb,$exbbdb,$table_prefix;
	$bbld_option = get_option('bbld_option');
	if ($bbld_option['exdb']) {
		$exbbdb = new wpdb($bbld_option['dbuser'], $bbld_option['dbpass'], $bbld_option['dbname'], $bbld_option['dbhost']);
	}
	if ($type == 'topic') {
		if ($exclude != 0) {
			$filter = "AND ".$bbld_option['prefix']."topics.forum_id IN ('$exclude')";
		}
		else {
			$filter = bbld_filter_forums();
		}
		if (!$bbld_option['share']) {
			$bbld_userdata = "JOIN ".$bbld_option['prefix']."users ON ".$bbld_option['prefix']."topics.topic_last_poster = ".$bbld_option['prefix']."users.ID";
		}
		if ($bbld_option['exdb']) {
			$bbtopic = $exbbdb->get_results("SELECT * FROM ".$bbld_option['prefix']."topics JOIN ".$bbld_option['prefix']."forums ON ".$bbld_option['prefix']."topics.topic_status = '0' AND ".$bbld_option['prefix']."topics.forum_id = ".$bbld_option['prefix']."forums.forum_id ".$bbld_userdata." ".$filter." ORDER BY topic_time DESC LIMIT $forum_slimit");
		}
		else {
			$bbtopic = $wpdb->get_results("SELECT * FROM ".$bbld_option['prefix']."topics JOIN ".$bbld_option['prefix']."forums ON ".$bbld_option['prefix']."topics.topic_status = '0' AND ".$bbld_option['prefix']."topics.forum_id = ".$bbld_option['prefix']."forums.forum_id ".$bbld_userdata." ".$filter." ORDER BY topic_time DESC LIMIT $forum_slimit");
		}
	}
	elseif ($type == 'utf8') {
		if ($bbld_option['exdb']) {
			$bbld_var = $exbbdb->get_var("SELECT count(*) FROM ".$bbld_option['prefix']."topics");
			$bbld_random = rand(1,$bbld_var);
			$bbtopic = $exbbdb->get_row("SELECT * FROM ".$bbld_option['prefix']."topics WHERE topic_id = ".$bbld_random." LIMIT 1");
		}
		else {
			$bbld_var = $wpdb->get_var("SELECT count(*) FROM ".$bbld_option['prefix']."topics");
			$bbld_random = rand(1,$bbld_var);
			$bbtopic = $wpdb->get_row("SELECT * FROM ".$bbld_option['prefix']."topics WHERE topic_id = ".$bbld_random." LIMIT 1");
		}
	}
	elseif ($type == 'meta') {
		if ($bbld_option['exdb']) {
			if ($bbld_option['9.0.4']) {
				$bbtopic = $exbbdb->get_row("SELECT * FROM ".$bbld_option['prefix']."topicmeta WHERE ".$bbld_option['prefix']."topicmeta.meta_key = 'page_topics' LIMIT 1");
			}
			else {
				$bbtopic = $exbbdb->get_row("SELECT * FROM ".$bbld_option['prefix']."meta WHERE ".$bbld_option['prefix']."meta.meta_key = 'page_topics' LIMIT 1");
			}
		}
		else {
			if ($bbld_option['9.0.4']) {
				$bbtopic = $wpdb->get_row("SELECT * FROM ".$bbld_option['prefix']."topicmeta WHERE ".$bbld_option['prefix']."topicmeta.meta_key = 'page_topics' LIMIT 1");
			}
			else {
				$bbtopic = $wpdb->get_row("SELECT * FROM ".$bbld_option['prefix']."meta WHERE ".$bbld_option['prefix']."meta.meta_key = 'page_topics' LIMIT 1");
			}
		}
	}
	else {
		if (!is_admin()) {
			$filter = bbld_filter_forums();
			$filter = str_replace("AND", "WHERE", $filter);
			$filter = str_replace("topics", "forums", $filter);
		}
		if ($bbld_option['exdb']) {
			$bbtopic = $exbbdb->get_results("SELECT * FROM ".$bbld_option['prefix']."forums ".$filter." ORDER BY forum_order ASC");
		}
		else {
			$bbtopic = $wpdb->get_results("SELECT * FROM ".$bbld_option['prefix']."forums ".$filter." ORDER BY forum_order ASC");
		}
	}
	return $bbtopic;
}