Add Who's Online Locations From Admin CP

General Info
This hack was requested to be available on Vbulletin 3. Being bored, I figured I would take the task in hand and complete it, to be better than it ever was before.

The original designer of the hack (on Vbulletin 2) is the well known Chen Avinadav, which being the great coder that he is, I dont particularly agree with his methods in this case, which he used a an excess query to select data from a template and loop through. This uses the built in datastore of vb3, therefore using No extra queries.

Therefore this hack is Completely original, in every way. I have used a different method, for accomplishing this, and the control panel I have created is intuitive and utlilizes a great many of vbulletins built in controls and phrases. Looking at the code itself on the admin panel alone you will see I didnt just throw this together and slap it on the site. Total creation time was around 4 hours, the code itself not being the main part, just mainly working out issues with the control panel etc..

Features
My version which is completely new, allows you to add the filename for the who's online along with the location name, and URL Title of the link.

The control panel which was the longest part, is pretty concise in how it works considering what I did to it. Provides a good bit of error checking to keep from accidentally doing stuff you didn't intend to do.

Also should note, the deletion part of the script uses JavaScript to confirm whether or not you wish to delete the selected Location.

I hope this gets a lot of installs, being as that my other 2 hacks/bug fixes were really just something I did in a few minutes and didn't put a great deal of effort into, judging by the fact I didnt have to "edit" any vbulletin files, to do what I wanted.

This is really my first release on this site, that I can say I believe is unique in its effort, and shows some insight on things for the newer coders out there. I have put a great deal of effort into the setup of everything as well as the readme file to be concise and as easy to read and understand as possible.

Hopefully hack of the month, lol.. j/k

Installation
I have provided an readme file inside of the zip, with information on how to install the hack, and what needs to be done to do so. Its a fairly easy installation, as you only have to add things.

Other Misc.
Files To Modify: 2
Total Modifications: 6
Installation Difficulty: Easy

Version Updates
Version 1.0 = First Release
Version 1.1 = Fixed Weird Query Error For Some People
Version 1.2 = Added ability to enable/disable links for locations

Click install if you like. Thanks.

[FleaBag]

Here you go... No table prefixes - I don't like to over-complicate.

Database error in vBulletin 3.0.1:
Invalid SQL:
INSERT INTO datastore
VALUES ('custom_online', 'a:0:{}');
mysql error: You have an error in your SQL syntax near ';
' at line 3
mysql error number: 1064
Date: Saturday 26th of June 2004 02:28:44 PM

[Dean C]

This looks great! Thanks for sharing with the community

[58sniper]

I'm getting an error as well during the first step (running whos_online.php)

Database error in vBulletin 3.0.1:

Invalid SQL: 
			INSERT INTO datastore 
			VALUES ('custom_online', 'a:0:{}');
		
mysql error: You have an error in your SQL syntax near ';
		' at line 3

mysql error number: 1064

[FleaBag]

Same error as myself.

[Trigunflame]

Try This

PHP Code:

Find This:

// Install
$DB_site->query("
    INSERT INTO ".TABLE_PREFIX."datastore 
    VALUES ('custom_online', '".addslashes(serialize($array))."');
");

And replace it with this:

$DB_site->query("INSERT INTO " . TABLE_PREFIX . "datastore VALUES ('custom_online', 'a:0:{}')");

Tell me if that works.. 


[FleaBag]

That worked, thank you.

[Trigunflame]

Ok good, I reuploaded the zip file with the fix. Should work fine now for everyone.

[FleaBag]

Not sure where I went wrong... It doesn't seem to have worked. No errors, it just says that locations I have added are unknown locations.

[Trigunflame]

Show me a screenshot of your current (custom_online.php) in the browser. If you put the modifications where I told you, it should work just fine.

Remember its doing this based on single filenames, I havn't added support for multiple pages via ?this=that etc...

[58sniper]

The first posted fix resolved my issue as well. It's working now.

The one minor thing I'd change it the ability to NOT show a link to the particular location. I've managed to obtain that with this hack by just putting a space in the URL Display field. But a checkbox or something to not show a link would be nice..

Other than that, this was a MUCH needed hack and should become part of vBulletin