vb.org Archive - Ultimate Forum Stats Integration for Non-VB Page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)

- - Ultimate Forum Stats Integration for Non-VB Page (https://vborg.vbsupport.ru/showthread.php?t=63223)

Ultimate Forum Stats Integration for Non-VB Page

This Hack was a port over from my vb2.x script that pulled information from teh forum to a seperate script which you then could break apart and include into your standard website via PHP includes or SSI.

This version is about the same but it now works with VB3.00 Gold

Features for Logged in Members:

*Users Avatar
*Default Avatar For Members Without a Set Avatar
*Number of Registered Members
*Number of Threads
*Number of Posts
*How Many Posts since last visit
*How Many New PM's
*How Many PM's in your Inbox
*Latest Registered User
*Member with the Most Posts
*Member with the Most Threads

Features for Guests:

*Welcome Text
*VB3 Gold Login Box with option to Remember.
*Newest Member
*Member with the most Posts
*Member with the most Threads

All that is needed to do is download the attached Zip File. Then open the boardstat.php file in any Text Editor. Follow the Commented Portions that have been outlined in there. You will need to change all the PATHS and URLS in that file to match YOUR server. It might take some tweaking on your part but it works just fine as I have tested it with several other websites. When You are Done Editing it, just upload it to your forums directory and call it to your main website using php includes, ssi or iframes.

IF YOUR FORUMS AND SITE ARE ON DIFFERENT SERVERS THEN YOU HAVE TO USE AN IFRAME TO CALL THE FILE OVER. ANYTHING ELSE COULD YIELD HEADER ERRORS.

------------------------------------
Please Remember. Follow the in-file instructions
and edit all the URLS and PATHS. I can't stress this enough.
I just know someone will pop on and say "Why does my links point to http://www.yourdomain.com/forums..... This is a warning lol ;)
------------------------------------

My Next Few Posts Will include Some Images of How the HTML is Built Inside the File.

Snaps of the User Logged in and then when the User is logged out.

You can see a LIVE view of it Here: http://www.mogusland.com/

that's a great hack, now all i need is a decent top10 hack and i can start making my new front page :D

Quote:

Originally Posted by sabret00the

that's a great hack, now all i need is a decent top10 hack and i can start making my new front page :D

theres top x stats available u can change the stats to whatever number hence the 'x' hehe

its the one i use on my homepage :)

Glad you guys like it. The instructions werent too difficult to understand were they?

I dont know yet, what I do know is that I'll be using this.

I checked the paths twice and then a third time, I know that they are all correct and I am getting this error

Warning: main(./includes/init.php): failed to open stream: No such file or directory in /home/rantman/public_html/forums/global.php on line 18

I placed the boardstats.php inside my root folder, is that the correct place to put it?

Well I figured it out that it needs to be in the forums directory and then you can try and use it outside of that but it does not show you logged in when you are outside the forums!

If this can be corrected to work without using an iframe, then it would be one of the best hacks available for people that do not use a vb portal.

If you use a include statement then it will not work, example:

http://www.sportsrant.com/index_tmp.php

sign in test account:

user: nyallsports
pass: sf49ers

Then if you go here:

http://www.sportsrant.com/forums/boardstat.php and sign in and look it works. Something about vb does not like the password outside the forum folder.

Also some of the links that you are using are incorrect in the form, when you check your private messages, usercp and others are incorrect or not updated. I have changed them and it works.

There has to be someone out there that can get this to work outside the forums folder without using an iframe

Mike

I finally was able to get this to work by taking/changing some of the code out of the boardstats.php and adding it to my index.php on my home page http://www.sportsrant.com

If anyone wants to try it out:

user: nyallsports
pass: sf49ers

Let me know what you think?

Yes ill update the hack information when i get home tonight, I seem to have forgot to upload that file that explain the other paths. My bad guys, ill get it up ASAP. If you wish to use this without iframes you need to change the paths in Global.php, init.php ect. msimonds. If you can send me your changes via email ill update the hack infomation for that as well. You guys can troubleshoot it yourselves as well. Just modify the paths in the error script that the file gives you. If it says init.php open init.php and search for all the REQUIRED paths in that file. Ill update with more directions in a little bit.

you can email me at akauth+mogusland.com just replace the + with a @

Sounds interesting. Let me know when everything is working

I dont know MSIMONDS isnt sending me his modifications.

I HAVE FIXED THE SCRIPT.

It will now work just fine with INCLUDING this. I will post instructions tomarrow in full.

In the mean time, do you guys want to be able to edit this file directly or resort to VBulletin templates? I personally like leaving vbulletin templates out of this add on but who knows.

Tomarrow i will post a Fix for everyone! :)

Really nice hack, can't wait for for your instructions today ;)
[high]* mmw clicks install[/high]

I'd say leave out vBulletin. I for one prefer it without as it makes for far easier customisation.

Can't wait for the fix - I'm not really liking the iframe system I've got running.

www.roller-coaster.com.au

Anyluck with the fix :o

okay my fixes are a little different becuase I removed some stuff like the avatar and a few of the options.

Should I still post them here

Mike

I personally wouldn't mind it - I removed a lot of the stuff also. :)

This is what I have on my index.php in my root folder

PHP Code:


		
			
<?php

error_reporting(7);

//////////////////////////////////////

// You need to EDIT your PATHS or this will not WORK properly

//////////////////////////////////////

//  STEP #1

chdir('/home/yourpath/to/forums');

//chdir('..');

//////////////////////////////////////////////////////////////////

//You WILL Need to Enter your full path to global.php, below is just a Generic Version

//////////////////////////////////////////////////////////////////

//require_once("/home/rantman/public_html/forums/global.php");

require_once('./global.php');

//////////////////////////////////////////////////////////////////

//

// NO NEED TO EDIT ANYTHING IN THIS AREA!  PLEASE SCROLL DOWN!!

//

//////////////////////////////////////////////////////////////////

//

?>

and where I wanted to place the login form, I have this

PHP Code:


		
			
<?

                            $getnewestusers=$DB_site->query_first("SELECT userid,username FROM user ORDER BY joindate DESC LIMIT 1");

                            $newusername=$getnewestusers['username'];

                            $newuserid=$getnewestusers['userid'];

                            $numbersmembers=$DB_site->query_first('SELECT COUNT(*) AS users,MAX(userid) AS max FROM user');

                            $numbermembers=number_format($numbersmembers['users']);

                            if ($enablepms==1 and $permissions['canusepm'] and $bbuserinfo['receivepm']) {

                              $ignoreusers="";

                              if (trim($bbuserinfo['ignorelist'])!="") {

                                $ignoreusers='AND fromuserid<>'.implode(' AND fromuserid<>',explode(' ', trim($bbuserinfo['ignorelist'])));

                              }

                              $allpm=$DB_site->query_first("SELECT COUNT(*) AS messages FROM privatemessage WHERE userid=$bbuserinfo[userid] $ignoreusers");

                              $newpm=$DB_site->query_first("SELECT COUNT(*) AS messages FROM privatemessage WHERE userid=$bbuserinfo[userid] AND dateline>$bbuserinfo[lastvisit] AND folderid=0 $ignoreusers");

                              $unreadpm=$DB_site->query_first("SELECT COUNT(*) AS messages FROM privatemessage WHERE userid=$bbuserinfo[userid] AND messageread=0 AND folderid=0 $ignoreusers");

                              if ($newpm['messages']==0) {

                                echo "";

                              } else {

                                echo "";

                              }

                            } else {

                              $pminfo='';

                            }

                            require_once('/home/rantman/public_html/forums/includes/functions_user.php');

                            $indexpage = true;

                            $bbuserinfo['avatarurl'] =

                            fetch_avatar_url($bbuserinfo['userid']);

                            $newposts = $DB_site->query_first("

                                SELECT COUNT(*) AS count

                                FROM ".TABLE_PREFIX."post

                                WHERE dateline > '".$bbuserinfo['lastvisit']."'

                            ");

                            $activethreads = $DB_site->query_first("

                                SELECT COUNT(*) AS count

                                FROM ".TABLE_PREFIX."thread

                                WHERE lastpost > '".$bbuserinfo['lastvisit']."'

                            ");

                            fetch_options_overrides($bbuserinfo);

                            $newdate = vbdate($vboptions['timeformat'], $bbuserinfo['lastvisit'], 0);

                            $pmbox = array();

$pmbox['lastvisitdate'] = vbdate($vboptions['dateformat'], $bbuserinfo['lastvisit'], 1);

$pmbox['lastvisittime'] = vbdate($vboptions['timeformat'], $bbuserinfo['lastvisit']);

$pmunread_html = iif($bbuserinfo['pmunread'], "<strong>$bbuserinfo[pmunread]</strong>", $bbuserinfo['pmunread']);

$vbphrase['unread_x_nav_compiled'] = construct_phrase($vbphrase['unread_x_nav'], $pmunread_html);

$vbphrase['total_x_nav_compiled'] = construct_phrase($vbphrase['total_x_nav'], $bbuserinfo['pmtotal']);

                            // ########## \\__> Added from Hwulex's Welcome Hack THANKS!!!<__// ########## \\

                            $getnewthread=$DB_site->query_first("SELECT COUNT(*) AS threads FROM thread WHERE lastpost > '$bbuserinfo[lastvisit]'");

                            $getnewpost=$DB_site->query_first("SELECT count(*) AS posts FROM post WHERE dateline > '$bbuserinfo[lastvisit]'");

                            if ($bbuserinfo['userid']!=0) {

                              $username=$bbuserinfo['username'];

                            ?>

                            <?                                   

                            echo "

                        

                            <td width=\"33%\" class=\"RantMenuLight\"><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"1\" color=\"#EEEEEE\">Welcome Back, <strong><b>$username!</b></strong><br><phrase 1=\"$pmbox[lastvisitdate]\" 2=\"$pmbox[lastvisittime]\">Last visited: $pmbox[lastvisitdate] at $pmbox[lastvisittime]</phrase><br></font></td>

                            <td width=\"33%\" align=\"center\"><div align=\"center\">

                            <a class=\"RantMenuLight\" href=\"http://www.sportsrant.com/forums/login.php?do=logout\" target=\"_parent\"><b>Logout</b></a>&nbsp;|&nbsp;

                            <a class=\"RantMenuLight\" href=\"http://www.sportsrant.com/forums/search.php?&do=getnew\" target=\"_parent\"><b>View New Posts</b></a>&nbsp;|&nbsp;

                            <a class=\"RantMenuLight\" href=\"http://www.sportsrant.com/forums/usercp.php\" target=\"_parent\"><b>User CP</b></a>&nbsp;

                            </div></td>

                                                

                            <td width=\"33%\"><div align=\"right\">

                                  <font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"1\" color=\"#EEEEEE\"><b>$bbuserinfo[pmunread] new message(s)<br>

                                  <a class=\"RantMenuLight\" href=\"http://www.sportsrant.com/forums\" target=\"_parent\">Go To The Forums</a>

                            </div></td>

                                  <td width=\"1%\">&nbsp;

                                                

                            

                            ";

                            

                            } else {

                            echo "

                            

                            

                            <td>

                            

                              <form action=\"http://www.sportsrant.com/forums/login.php\" method=\"post\" onsubmit=\"md5hash(vb_login_password,vb_login_md5password)\">

                                               <script type=\"text/javascript\" src=\"http://www.sportsrant.com/forums/clientscript/vbulletin_md5.js\"></script>

                            

                                                <td width=\"0%\">&nbsp;</td>

                                                <td><table width=\"400\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">

                                                    <tr> 

                                                      <td width=\"150\"><strong><font color=\"#EEEEEE\" size=\"1\" face=\"Verdana, Arial, Helvetica, sans-serif\">Nickname: 

                                                        </font></strong>

                                                      <input type=\"text\"  class=\"RantMenuTop\" name=\"vb_login_username\" id=\"navbar_username\" size=\"10\" accesskey=\"u\" tabindex=\"1\" value=\"User Name\" onfocus=\"if (this.value == 'User Name') this.value = '';\" /></td>

                                                      <td width=\"150\"><strong><font color=\"#EEEEEE\" size=\"1\" face=\"Verdana, Arial, Helvetica, sans-serif\">Password:</font></strong> 

                                                        <input type=\"password\" class=\"RantMenuTop\" name=\"vb_login_password\" size=\"10\" accesskey=\"p\" tabindex=\"2\" /></td>

                                                      <td><input type=\"image\" src=\"images/srlogin.gif\" value=\"Log in\" tabindex=\"4\" title=\"Enter your username and password in the boxes provided to login, or click the 'register' button to create a profile for yourself.\" accesskey=\"s\" /></td>

                                                       <td class=\"RantMenuLight\"><label for=\"cb_cookieuser_navbar\"><input type=\"checkbox\" name=\"cookieuser\" value=\"1\" tabindex=\"3\" id=\"cb_cookieuser_navbar\" accesskey=\"c\" checked=\"checked\" />Remember?</label></td>

                                                       </tr>

                                                  </table></td>

                                    <input type=\"hidden\" name=\"s\" value=\"\" />

                                    <input type=\"hidden\" name=\"do\" value=\"login\" />

                                    <input type=\"hidden\" name=\"forceredirect\" value=\"1\" />            

                                    <input type=\"hidden\" name=\"vb_login_md5password\" />

                                    </form>

                                    </td>

                            <td width=\"60%\" class=\"RantMenuLight\"><div align=\"right\">Welcome Guest!<br>

                            <a class=\"RantMenuLight\" href=\"http://www.sportsrant.com/forums/register.php\" target=\"_parent\">Register</a>

                            </div></td>

                                                <td width=\"1%\">&nbsp;

                                            

                            ";

                            }                            

                            echo "

                            </td>

                            ";

                            ?>

I can make modifications to work to try and help anyone out that wants to get this to work and I also attahed a modified login.php that can go into your root folder, NOT THE FORUMS FOLDER

Mike

yes one thing i forgot was the CHDIR thing. That was one of the things i added but my computer was overtaken by college freaks finishing up homeworks. Ill look over MSIMONDS stuff and finish it up in about an hour or so.

hey if this works for anyone else then that is great. I fI Can help out in anyway just let me know. I have been trying to correct a different login for months becuase of a javescript error, but if it was not for your code, BlackxRam, then I would have never been able to get this to work. Great job man, really!!

One problem I am upset about is the seemingly longer loading time. It was MUCH faster with VB2... Im not sure if its a VB3 issue but I would like to try to get it more streamlined.

Updated the Zip File so everyone can understand it better.

Quote:

Originally Posted by BlackxRam

One problem I am upset about is the seemingly longer loading time. It was MUCH faster with VB2... Im not sure if its a VB3 issue but I would like to try to get it more streamlined.

I actually have to agree with you there. It does seem to load slower, I will also look into this and see if I can somehow speed it up

Gave it a go.
All works fine except it wont display an avatar.
Just the little box with a red cross in it.

If I look at the html page produced I get

HTML Code:

 <a href="http://www.billspaintball.com/vb3/profile.php?&do=editavatar"><img src="image.php?u=1&amp;dateline=1036410394" border="0"></a>

However, If I use the image part of that and enter it straight into the browser like

HTML Code:

http://www.billspaintball.com/vb3/image.php?u=1&dateline=1036410394" border="0"

The image will display.

What wrong???

EDIT:

Doh!!
Stupid mistake on my part.
FIxed :)

Great script, using on my site. :D

Quote:

Originally Posted by Billspaintball

Gave it a go.
All works fine except it wont display an avatar.
Just the little box with a red cross in it.

If I look at the html page produced I get

HTML Code:

 <a href="http://www.billspaintball.com/vb3/profile.php?&do=editavatar"><img src="image.php?u=1&amp;dateline=1036410394" border="0"></a>

However, If I use the image part of that and enter it straight into the browser like

HTML Code:

http://www.billspaintball.com/vb3/image.php?u=1&dateline=1036410394" border="0"

The image will display.

What wrong???

EDIT:

Doh!!
Stupid mistake on my part.
FIxed :)

Great script, using on my site. :D

That seems to be a server issue or perhaps you should put the ENTIRE url into the IMG tag if your forums are on subdomains.

Im using this on my site now.
There was one thing that was annoying me a little. That was some of my users have large avatars that messed up the formatting on the non VBb pages when they were displayed because they were so large.

Ive added a few lines to this to resize any oversized avatars to a desired max size (keeping everything in proportion of course).

Anyone interested?

Should I post it here?

Hi!

Text from guide.txt

"If your website uses a CMS (Content Management System) this script
might not function as well because it does call information from a
another database"

Well, I can assure it doesn't work with mambo.

I think the problem is caused by chdir('/home/yourpath/to/forums');

I have searched the forum and have not found a login-huck that will work with Mambo.

I currently use phpBB2 (before I transfer to VB3) and I have a nice hack which works fine.

Do you guys think that the code can be more flexible and work with CMS?

Any ideas?

Thank you.

Nektarios

By All means bill share it. :)

About the CMS, its really hard to get something like that to work in a CMS if:

A) the CMS is in a different Database

B) the CMS doesnt allow php scripting to take place

C) the CMS has its own cookie system therefore the script might conflict with the CMS

There has been some luck in programs like PHPnuke that allows for Custom User "blocks" some CMS's also feature custom blocks as well. Those are the easiest to be able to make work. Otherwise if you use a CMS and are unable to integrate the code directly into your CMS by modifying your core files the best course of action would have to be an iframe.

You would have better luck incorporating the two if they were on the same database name and the CMS allowed full php scripting. Most CMS's dont allow it cause its too much of a risk. Coding it for a CMS would be different every time cause every CMS is different. I personally wouldnt know about Mambo I am using a early build of a brand new CMS called IONcms and this hack will work perfectly with that CMS as i built it alongside the cms development.

You would need someone who knows Mambo well to integrate it.

Ok here is my little avatar max size hack.
It works fine on my site but no promisies that it will work elsewhere.

Sorry about the messy code, (Im sure there is a neater more efficent way of doing this but, hey, it works) but im a php n00b, this is my first hack :D

Anyone can use this in their hack if they wish, just keep the commented credit intact.

Anyhow, this is the code.

PHP Code:


		
			
// display avatar - resize if too big

// By Bill - [url]http://www.billspaintball.com[/url]

$file = "http://www.yourdomain.com/pathto/forums/$bbuserinfo[avatarurl]"; // Path to pic

$maxw = 130; // Max thumbnail width

$maxh = 140; // Max thumbnail height

list($width, $height, $type) = getimagesize($file);



if ( $width <= $maxw AND $height <= $maxh )// check width and height

   {// if width and height under size display unchanged

       echo "<img src=\"$file.$type\" align=\"center\" border=\"0\">";

   }

   else 

   {  

    if ($width > $maxw)//check if width is too wide

        { // if it is, resize

        $ratio = $width / $maxw; //work out resize ratio

        $newwidth = $maxw; // new width

        $newheight = ($height / $ratio); // new height at this resize

        }

        else

        {

        $newheight = $height; // if width is ok, set this cos we need it later

        $newwidth = $width; // if width was ok, set this cos we ned it later

        }

    If ($newheight <= $maxh )        

        {

        // if current height is ok, were done.

        } 

        

        else // either origional or resized height is too big

            if( $newheight >= $maxh )

            { // if resized height is still too big we resize it

            $ratio2 = $newheight / $maxh; //work out resize ratio

            $newheight = $maxh; // give $newheight a new value

            $newwidth = ($newwidth / $ratio2); // new width at this resize

            } // the value of $newwidth has just been changed

            else

            {// if were here then origional height is too big so we resize it

            $ratio2 = $newheight / $maxh; //work out resize ratio

            $newheight = $maxh; // give $newheight a new value

            $newwidth = ($newwidth / $ratio2); // new width at this resize

            }



        // now we can finally display resized pic

        echo "<img src=\"$file.$type\" border=\"0\" width = \"$newwidth\" height = \"$newheight\" align=\"center\">"; // display resized pic

   }

Instructions.

Find this section in the origional code.
Its about half way through the step 2 section.

PHP Code:


		
			


</td></tr><tr><td width=10%><a href=\"http://www.yourdomain.com/forums/profile.php?$session[sessionurl]&do=editavatar\"><img src=\"$bbuserinfo[avatarurl]\" border=\"0\"></a></td><td width=50%>

Change it to

PHP Code:


		
			
</td></tr><tr><td width=10%><a href=\"http://www.yourdomain.com/forums/profile.php?$session[sessionurl]&do=editavatar\">";



//insert my new code here!!!



echo "</a></td><td width=50%>

You need to edit 2 lines in my code
$maxw is the maximum width of the avatar. Anything bigger will be resized to this.
$maxh is the maximum height of the avatar. Anything bigger will be resized to this.

Anything smaller will not be resized up since that can make them look ugly and pixelated.

All resized pics will retain their origional width/height proportions.

The pic will be resized so that both width and height will fix in the max sizes you have choosen.

if i have a login.php and index.html, what the cm insert .php to .html, i used <?include, but it don't work, who can help me???

i get the following error on my page:
Database error in vBulletin 3.0.3:

Invalid SQL: SELECT userid,username FROM user ORDER BY joindate DESC LIMIT 1
mysql error: Table 'gobbas1.user' doesn't exist

mysql error number: 1146

It looks to me that you have entered some invalid table information to the page.

Are you adding this to a normal PHP page or a CMS SCRIPT?

CMS script, Mira server.
the thing is that gobbas1 is the database name for my forums, i don't know what table gobbas1.user is though since my vB tables are called vB3_.

try changing all the Database Fields to match your VB Named Fields, it looks like the script is pulling from the CMS tables... in the stats script change any and all mysql info to vb3.user see if that helps.

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01422 seconds Memory Usage 1,946KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (4)bbcode_html_printable (5)bbcode_php_printable (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (40)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: