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

[arossphoto]

Hi Bill,

I noticed on your site that the forum stats include total members, as well as total posts and topics. I don't get that with this hack. Is there a way to add total members?

Thanks.

[Billspaintball]

Originally Posted by moethelawn

I checked it out on IE and if you're not logged in, it gives me a "Done, but with errors on page" in the status bar at the bottom. It says for the error:

Line: 27
Char: 1
Error: Expected '('
Code: 0

A couple of other people have reported this, but I'm unable to replicate it.
I've tested it in Avant, IE6, Opera 8.54 and 1.5.0.2

What version of IE and what OS are you running?

Also, have you tried just the sample code in the trouble shooting section in post 2 in this thread?

[Billspaintball]

Originally Posted by arossphoto

Hi Bill,

I noticed on your site that the forum stats include total members, as well as total posts and topics. I don't get that with this hack. Is there a way to add total members?

Thanks.

Yes, I can add it next release.

[Jay...]

How do i edit the way this looks? like the font used, size, layout etc etc?

[Billspaintball]

You edit the login_inc.php file and add CSS or HTML as desired.

[Jay...]

Originally Posted by Billspaintball

You edit the login_inc.php file and add CSS or HTML as desired.

bit too advanced for me lol

[Spinball]

I have posted a problem on the simple version of this hack but without any resolution.
Maybe someone here can help.
I've installed as instructed.
I have two websites on the same server. I want the forums login to be working on pages from a different website.
I have the other domain set in my forums to be allowed to post. And I have set the cookie domain to be blank.
When people log in, the action succeeds and the 'thanks for logging in' message pops up, but then I'm returned to the login screen. Not logged in.
It's possibly a cookie issue. But I don't have a clue how to fix this.
Can anyone help, please?

[erinys]

im still getting that error when i switch from "cookies" to "database" in the vbulletin options, even with the new version.. ;(

only it talks about "posts" instead of "newposts" as error argument

[erinys]

Database error in vBulletin 3.5.4:

Invalid SQL:
SELECT COUNT(*) AS count FROM post AS postLEFT JOIN threadread AS threadread ON (threadread.threadid = post.threadid AND threadread.userid = 2) WHERE dateline >= 1146735048 AND dateline > IF(threadread.readtime IS NULL, 1145877724, threadread.readtime);

MySQL Error : Unknown table 'post' in on clause
Error Number : 1109

[Billspaintball]

Originally Posted by erinys

MySQL Error : Unknown table 'post' in on clause
Error Number : 1109

I will have a look at this over the weekend.