For vBull 2 - Generic vBull Comunity Page

Here is an easy setup to put a lot of Vbull content onto another page. You can use it to make an easy index page with some quick modification or just to access information quickly...

I realize that there are already a lot of similar hacks out there, but I felt like sharing.

You can see an example of this script here:
http://www.onandoffroad.com/GVCP/

You can get the files by downing them from the posts later in this thread where I have them in an attatched zip.

( I used to have the code posted here, but it has grown enough since then as to not fit as posted code anymore. )

Hooper, I'll reply in PM.

Juan, unfortunatly I don't think I know enough to diagnose your problem by just looking at the page and the output. If you're willing to trust me pm or email me a login pass and ip to your server and I'll try to figure it out directly... if not I can send you a side bar without the welcome section... that way at least you won't get errors.

[Hooper]

I posted reply. I'll be in here for a bit.

Thank You.

[Juan]

Hi

I've solved the problem by removing side.php.

The news works so well, there wasn't any point in adding the last 10 posts.

Thank you very much for your help.

[Hooper]

It does work well doesn't it. Imperitus does nice coding. Really helpful too.

Hooper

Juan, Sorry about that. Here is a version of the side bar without the welcome message stuff that is causing your problem. It should work and give you everything else from that part of the script.

side.php
--------

<?php
error_reporting(0);
require("GVCP_Config.php");

mysql_connect($DBhost,$DBuser,$DBpass) or die("Unable toconnect to database");
mysql_select_db("$DBName") or die("Unable to access the News");

$sqlquery = "SELECT username FROM user ORDER by posts desc LIMIT 0,1";
$latest = mysql_query($sqlquery);
$daname = mysql_result($latest,"username");

$sqlquery2 = "SELECT userid FROM user ORDER by posts desc LIMIT 0,1";
$latest2 = mysql_query($sqlquery2);
$id = mysql_result($latest2,"userid");

print "<font color=$sidetextcolor> Most active user:</font> <a href=$path/member.php?action=getinfo&userid=$id><b> $daname </b></a>";
print "<hr noshade size=1 color=$hrcolor>";

$sqlquery = "SELECT username FROM user ORDER by joindate desc LIMIT 0,1";
$latest = mysql_query($sqlquery);
$daname = mysql_result($latest,"username");

$sqlquery2 = "SELECT userid FROM user ORDER by joindate desc LIMIT 0,1";
$latest2 = mysql_query($sqlquery2);
$id = mysql_result($latest2,"userid");

print "<font color=$sidetextcolor> Newest Member:</font> <a href=$path/member.php?action=getinfo&userid=$id><b> $daname</b></a>";
print "<hr noshade size=1 color=$hrcolor>";

$sqlquery = "SELECT * FROM user";
$result = mysql_query($sqlquery);
$number = mysql_numrows($result);

print "<font color=$sidetextcolor> Number of users:</font> <a href=$path/memberlist.php><b> $number </b></a>";

print "<hr noshade size=1 color=$hrcolor><font color=$sidetextcolor><b>Last 10 active topics:</b></font><br>";

$sqlquery = "SELECT * FROM thread WHERE visible !=0 ORDER by lastpost DESC LIMIT 0,$active";
$result = mysql_query($sqlquery);
$number = mysql_numrows($result);

$i = 0;

if ($number < 1) {
print "<font color=$sidetextcolor><CENTER><P>There are no active topics...</CENTER></font>";
}
else {
while ($number > $i) {

$title = mysql_result($result,$i,"title");
$theid = mysql_result($result,$i,"threadid");
$numcheck = mysql_result($result,$i,"replycount");
$numie = ($numcheck+1);
$lastposter = mysql_result($result,$i,"lastposter");



print " <a href=$path/showthread.php?threadid=$theid>$title </a><br><font size=-2 color=$sidetextcolor> Posts: <b> $numie </b> Last post by:<b> $lastposter</b></font><br>";


$i++;
}
}
print"<hr noshade size=1 color=$hrcolor>";

$sqlquery = "SELECT threadid FROM thread WHERE forumid !=36 AND visible !=0 ORDER by replycount desc LIMIT 0,1";
$result = mysql_query($sqlquery);
$threadid = mysql_result($result,"threadid");

$titquery = "SELECT title FROM thread WHERE threadid = $threadid";
$titresult = mysql_query($titquery);
$title = mysql_result($titresult,"threadid");

$postquery = "SELECT replycount FROM thread WHERE threadid = $threadid";
$postresult = mysql_query($postquery);
$posts = mysql_result($postresult,"replycount");

$viewquery = "SELECT views FROM thread WHERE threadid = $threadid";
$viewresult = mysql_query($viewquery);
$views = mysql_result($viewresult,"views");

$posterquery = "SELECT postusername FROM thread WHERE threadid = $threadid";
$posterresult = mysql_query($posterquery);
$poster = mysql_result($posterresult,"postusername");

print "<font color=$sidetextcolor><b>Most active topic ever:</b></font><br>
<a href=$path/showthread.php?threadid=$threadid>$title</a><br>
<font size=-2 color=$sidetextcolor>By: <b>$poster</b> Replies: <b>$posts</b> Views: <b>$views</b></font>";

?>

[Juan]

Thank you very much. You are a star!

What happened to the download?

The downloads should still work, are they not? The download counts next to them are still going up... check back a few posts till you see an attatchment in one of my posts...

Downloads worked for me. I had to jack with a lot of stuff to get it to work, but it didn't turn out too bad. Just need to get "Most active topic ever" to work, but that shouldn't be hard.

EDITED to say: My site is now using vBulletin. Harder to install, but worth the effort.

The polls comes up empty.
how strange...

Originally posted by Imperitus
Here is the poll script.

Just stick it in the GVCP and call it from the index page with an include.

You'll have to rename in to something.php