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,

1)I don't know off hand, but I'll put that on my list of things to try and figure out.

2)Are you using the latest version after I updated it to include additionial formating?

3)Headline links would be easy... I could work that into an update within the next couple days...

4)Printable and email functions are beyond what I had even contemplated. but don't sound like they would be too hard. Although including features like that might start taking things beyond the simplicity I was aiming for.

So I guess I'd like to know, do people want this developed further? or don't you think things like vbportal realy fill the top end needs already? I personaly started this as an excuse to start learning php and mysql... not to try and suplant existing projects, and then figured I'd release what I had just to share...

jojo85, thanks. Yes it is sorta, a watered down vbportal wanabe. But it's MINE dag nab it all mine! Muhahahahaha!

[Hooper]

Imperitus,

Thank You for responding.

1) Please do..... Important.
2) No, It was't working for me with the template you had and all. I am using the one you sent me and SSI calling the file into my shtml. I couldn't figure out how to get just the html formatting out of the code in such away that it would function with your original script. If this can be done I'm all for it.
3) I hope so, I can help you sort this out.
4) Oh, we need this too.

"So I guess I'd like to know, do people want this developed further? or don't you think things like vbportal realy fill the top end needs already? I personaly started this as an excuse to start learning php and mysql... not to try and suplant existing projects, and then figured I'd release what I had just to share... "

Answer: Heck ya. vBportal is excellent, but way overblown for what I'm trying to do. The features I am mentioning are the important ones. The date above all of "the days" posts are not even done with vbportal that I know of. And of course you should further develope. Unless of course, you would rather leave the script as is. Id'e be grateful for what you wrote already if this is the case. There isn't that much more that I see. Just a few items. Then..... I personally will be much happier than that of my overblown newspro and hacks.

I think you will be impressed with what I am doing with your scripts. If I get everything going, I'll give you the link.

I think this is the way to do it. I was intending on waiting for a newspro hack because of the intense NP hacking I have, but to be honest, If These few issues can be sorted out, I believe I will be much more happier with what you are doing.
I downloaded and installed vBPortal. It is an excellent hack, however, for the most part it isn't what I am looking for. It has too many bells and whistles for what I am trying to accomplish. I would have to Unhack it to get what I need.

Thanks Imp,
Hooper

Hooper,

If you get a chance please try updating your gvcp.php file with the updated one in this thread. Let me know if that helps with your formating.

I'll try tackling some of the other issues tonight or later this week.

[Hooper]

Donka.... and I'll do.

FYI this is where I'm testing changes as I go.
http://www.onandoffroad.com/GVCP/

[Hooper]

Thank You,
Hooper

i have front page in php3 and inserted

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

print "

";

/* side bar */

chdir("forum/");
require("global.php");

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

$namequery = "SELECT username FROM user WHERE userid = $bbuserid";
$namegrab = mysql_query($namequery);
$name = mysql_result($namegrab,"username");

if ($bbuserid != 0)
{ print "Welcome back, <a href=$path/usercp.php><b>$name</b></a>"; }
else
{ print "Welcome <b>guest</b>"; }

chdir("../");

print "<hr noshade size=1>";

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 "Most active user: <a href=$path/member.php?action=getinfo&userid=$id><b> $daname </b></a>";
print "<hr noshade size=1>";

$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 " Newest Member: <a href=$path/member.php?action=getinfo&userid=$id><b> $daname</b></a>";
print "<hr noshade size=1>";

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

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

print "<hr noshade size=1><b>Last 10 active topics:</b><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 "<CENTER><P>There are no active topics...</CENTER>";
}
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> Posts: <b> $numie </b> Last post by:<b> $lastposter</b></font><br>";

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

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

/* side bar end */
print "
<b>Go to</b>
<a href=$path>forum</a><br>

";

?>

and it does not work.
help !!!!

Try changing

chdir("forum/");

to

chdir("forums/");



BTW Hooper, I have the links and the separation by days working on my test script.

[Hooper]

Major cool.... Heading that way...


Perfect!!!!!!!!!!!!!!!!

They need to cut off at 10 or a certain amount so your tables won't scroll any further than the set value. The rest just get archived in the forums. They are working exactly right!

I don't know if it is possible to have the 10 links to the last 10 articles and yet still be able to post a larger fixed amount of articles below or not. Example: 10 links to 10 last posted articles. But the articles themselves below cut off at 35.

Possible? Lukin Good.

Good Work!

How exactly would you want a print function to work? Perhaps a link on each story that will load a seperate page that includes just that story so you don't waste paper printing the other news stories?