Deluxe vB User login and access control on non vB pages

Hack Description

This is the deluxe version of the user authentication and access control system I use on the non vB pages on my website.
For the simple no frills version look here.

This uses the vB 3.5 login system to log you in and out. It allows you to move between your forums and other pages on your site while remaining logged in.

It allows you to do things such as restrict pages by usergroup, display different content depending on a user being logged in or not.
For example, you can have banner Adds displying to non members only, and/or let members access to specific content.

It also displays the logged in users Avatar, number of unread PM's, New posts since last visit, total posts and total threads.
It also allows you to specify a maximum Avatar size, and resize any avatars larger than that, while keeping their height/width ratios in proportion!
Its very handy if you allow large avatars, but want a small format display on your non forum pages.

If the user is not logged in, a login box is displayed, along with total posts and total threads in the forums.

I will try and offer support, but work and family commitments mean I dont have much free time.

This code is a mix of my own, and pieces I have used from other hacks that are floating around.

This is a work in progress and currently a beta version. It was a little rushed as a few people were pushing for it Its missing a couple of planned things like newest member etc, but they will be added in a later version.

This script has been confirmed as working on

• vB 3.5.x - All Versions
• vB 3.6.x - All Versions

Known Bugs
Will not display Avatars correctly if they are kept in the file system (database avatars are fine)

Changelog

Version 2.20 (24th April 2007)

• Fixed - // in paths bug
• Fixed - Javascript warning in some browsers
• Fixed - Tidied up some code
• Fixed - Avatar display code bug

Version 2.10 (4th June 2006)

• Fixed - "MySQL Error : Invalid SQL " when using Database thread/forum marking.
• Fixed - Javascrip error in some versions of IE.

Version 2.00 (16th April 2006)

• Fixed - "MySQL Error : Unknown column 'newposts' in 'field list' "
• Fixed - Number of PM's not displaying in all installs.
• Added - Displays date and time of last login.
• Added - Total number of saved PM's.

To upgrade just overwrite the existing login_inc.php file with the new one.
You will need to re-edit the path on line 3 and also redo any formatting changes you may have done for the last version.

Version 1.0 (15th Feb 2006)

• Initial Release

Click on Install
If you have this script installed then please click on the install link because;

• You will get notified if any security issues are reported.
• You will get notified when there are any upgrades to this script
• It gives me a warm fuzzy feeling and motivates me to develop more

Donations
First of all, to be clear. This script is 100% free.

However if you feel an urge to donate I'm not going to say no.
Donations can be made at http://www.billspaintball.com/vb3/bd_donate.php

[Hakaslak]

Quick thing. Any particular reason you used the "+=" operand? I am a newbie so I am guessing, but on my home page, it doubles the value of all my statistics. So instead of 95 posts and 95 threads, the stats say 190 theads and posts. However, when the stat is reporting from a thread in the forums dir, then everything is fine. This is true for the member count stat as well.

Also, I had to change your "+=" operand to "=", and modified your mySQL query in order to get the correct values. Here is what I am using now:

// get total number of posts
$getstats = $db->query_read('SELECT SUM(replycount) AS sumreply FROM ' . TABLE_PREFIX . 'forum');
while ($forum = $db->fetch_array($getstats))
{
	$totposts = $forum['sumreply'];
}
$totposts = vb_number_format($totposts);

In order to get the SUM() working, I had to seperate the threadcount and postcount queries, but I have it all working and reporting the right values now.

[Rated]

This is the best hack i've ever installed on any vB forum. And trust me ive installed lots ^^

Great work bill!, It took me a while to set it up (major issues with file paths, cookies) but the fixes are in this thread.

And example: http://www.snesclassics.com - up top right.

Thanks again mate!

[lsatblu]

Any idea why this isn't working? I installed it on a test page.

http://talesotaku.com/test.php

<?php

   chdir('http://talesotaku.com/forums'); 

   require_once('http://talesotaku.com/forums/global.php');  

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<title>Untitled Document</title>
</head>

<body>

<?php

   require_once('http://talesotaku.com/login_inc.php');

?>   

</body>
</html>

I have everything on that one page and on my login_inc.php I set the values like I was directed.

[N-0p3rz]

=/ I'm having problems with getting it to show the users info once logged in

Test login page = http://www.hiphopfame.com/test.php
Test login = test
Test password = 1Test1

I changed the Suggested Settings for Path to Save Cookies to / btw. And still this problem =(

I was also getting this error

Fatal error: Call to a member function on a non-object in /home/sdot0ne/public_html/hiphopfame/community/login_inc.php on line 150

But I just deleted that little bit of code.

[tandalier]

also can't get it working.
on www.xboxbase.at everything is okay

on the same server there ist a second page, nintendobase, but there I can't get it working:
just see www.nintendobase.at

i'm always getting the message that I'm logged in, but when it get's back to the main-site I'm logged off.

Can anyone help?

[Rated]

Hmm some tips..

Make sure ALL the file paths are absolute.. I.e /home/public_html/website/login_inc.php etc.

If logging into a subdomain.. u need to change the cookie info in vbulletin option to /sitename, not /

[pewp]

now i'm getting this error... anyone got any ideas?

Fatal error: Call to a member function on a non-object in /home/decimato/public_html/login_inc.php on line 150

[Rated]

Whats on line 150?

[N-0p3rz]

Originally Posted by N-0p3rz

=/ I'm having problems with getting it to show the users info once logged in

Test login page = http://www.hiphopfame.com/test.php
Test login = test
Test password = 1Test1

I changed the Suggested Settings for Path to Save Cookies to / btw. And still this problem =(

I was also getting this error



But I just deleted that little bit of code.

still having this error.

..

the paths are absolute.

My only conclusion is that.. the fact that the domain is an addon domain to my host.. is what's causing the problem..

like the forum can be accessed from http://www.sdotproductions.com/hiphopfame/

Would that be why I'm experiencing what I'm experiencing?

[myplacidcasual]

I'd like it to show that you have unread pms

Shouldn't be hard right bill?