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

[erinys]

Thanks, cause i really wanna switch to database handling of read posts etc

btw im also getting the javascript error, with the old and new version when someone is logged out.

if you wanna check it yourself;
http://www.bunnybunch.nl

[Quarterbore]

I have a project that this may work with... Thanks for sharing this and I hope to try using it this weekend... :knockedout:

[Paprika]

Edited:
Bah Nevermind!

[Billspaintball]

Originally Posted by erinys

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

Now that is just a weird error.
'post' is a standard vB table so it should be there.

umm... just a thought, are you using a table prefix for your forums?
It should still work for that, but I dont have a prefixed forum to test it on.

[Billspaintball]

Originally Posted by erinys

btw im also getting the javascript error, with the old and new version when someone is logged out.

if you wanna check it yourself;
http://www.bunnybunch.nl

This javascript error that is appearing for a couple of people is driving be :banana: as I cant replicate it on my live or test forums in Firefox, IE6, Opera 8.54 or Avant.

What OS are you using?
What browser (and what version) are you using?
What webserver are you using?
Are your users reporting the same error or just you?

[erinys]

Nopes, no profixes at all are being used and i just checked in phpmyadmin and the table "post" is there, with offcourse all the records/posts in it :S

About the javascript error.. i only get it @ work..
windowsxp
ie 6.0.2900.xxxx
dont know if my users are reporting the same.. never heard about it, and i only get this error at my work pc.. not at home
webserver is a linux one, but i dont know much more specs.

this is the error:
line 104
expected '('

weird thing is.. if i check the source, and line 104.. its an empty line..

====
<input name=vb_login_username type=text id=navbar_username onfocus=if (this.value == 'Gebruikersnaam') this.value = ''; size=10 />
line 104 is here
<br>Wachtwoord:<br>
<input name=vb_login_password type=password size=10 />

====

[Billspaintball]

Originally Posted by erinys

About the javascript error.. i only get it @ work..
windowsxp
ie 6.0.2900.xxxx
dont know if my users are reporting the same.. never heard about it, and i only get this error at my work pc.. not at home

At a guess its probably a firewall or javascript restriction that your work has implemented. Which would explain why this problem is only reported by a couple of people.

[Quarterbore]

I am just starting to play with the code but I got this error...

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

I called the file from inside another script using the following line:

include("../forums/login_inc.php");

Now, when I enter my forums username and password I am getting signed into my forums but when it returns to the script I never see the rest of the file where I tried to use the include from...

I am still trying to figure it out though...

The line of code that is causing the error is this:

$getstats = $db->query_read('SELECT threadcount, replycount FROM ' . TABLE_PREFIX . 'forum');

EDIT:

OK, I removed all the code after:

// +++++++++++++++++++++++++++++++++++++++++++++++++++
// we want do display stats either way so they go here
// +++++++++++++++++++++++++++++++++++++++++++++++++++

Now I can see if I can get my usergroups to cover the permissions needed for the other script... What I am trying to do is integrate the following program with vBulletin using your hack as a starting point:

http://lythgoes.net/genealogy/software.php

[Billspaintball]

Quarterbore,
Combining two scripts can at times be very problematic.
I suggest that you try the simple version of this script https://vborg.vbsupport.ru/showthread.php?t=100992 and see if you can get that working first.

Also, I recommend trying just the test login listed in part five of troubleshooting (post 2), to rule out any thing besides a clash between this script and the other one.

If we can get the basic one working, then we can work on finding out where the problem is here.

[erinys]

Aye billspainball, i think so too, its a weird problem

Do you get an error btw if you switch the way your forum handles "read" posts?