Who's Online for PhotoPost vBGallery

If you are upgrading from a previous version, un-install the product first, then re-install the new version. (Yes, even from ver 1.0.0 to ver 1.0.1)

Do not use this product with...
WOL is built into PhotoPost vbGallery from versions 1.0.3 and 2.0.x onwards. Do not use this product with those versions of vbGallery.

Description:
This is a small product that shows locations of users in your PhotoPost vBGallery instead of "Unknown Location" in vB's Who's Online page. I did not add links to the locations.

I had wanted to add links to some of the locations, but it looks complicated (getting the necessary data from the database and working out who should and should not see the links and activity details like image title, id, etc based on user and category permissions). It will take a lot more effort then I'm willing to, or can invest at the moment... so, I will not be adding that in the near future.

Oblivion Knight modified version 1.0.2 of this plugin to add links to the gallery index page. He posted the plugin in post #45.

Locations:
Browsing Image Gallery
Editing Gallery Image
Emailing Gallery Image
Managing Gallery Categories
Moderating Gallery Posts
Moderating Gallery Uploads
Posting Gallery Reply
Printing Gallery Image
Searching Gallery
Sending Gallery Ecard
Uploading To Gallery
Viewing Gallery
Viewing Gallery Image
Viewing Gallery Index
Viewing Gallery Slideshow
Viewing Linked Gallery Image

Credits:
Noppid for this WOL How-To.

Tested on:
vBulletin 3.5.1 and PhotoPost vBGallery (vbAdvanced Gallery) 1.01
vBulletin 3.5.4 and PhotoPost vBGallery 1.02

Effort to install:
1. Download the XML.
2. Import the product at the AdminCP->Plugin System->Manage Products.
(See the vBulletin manual on how to install products.)

What is installed:
- 3 Plugins
- 16 Phrases
(All names of the above are prefixed with "vp_")

Support:
Unfortunately I have to withdraw active support for this mod as I have simply do not have enough time on my hands nowadays.

Notes:
- If you have many plugins installed at the "online_location_unknown", it may interfere with this product. Most likely it's because the other hooks sets a variable that indicates the locations have been successfully processed. I have an "if" statement to catch that to prevent unnecessary processing. All you need to do to fix it is edit the "Process vBaGallery WOL Locations" plugin at that hook and remove:

if (!$handled)
{

and "}" in the last line of the plugin.

Change Log:
Ver 1.0.1 (Beta) - 19 Nov 2005
- Added missing phrases.
Ver 1.0.2 (Beta) - 26 Nov 2005
- Removed an extra line of code.

[vinzphua]

1. Go to Admin->Plugin System->Plugin Manager.
2. Look for "Hook Location: online_location_preprocess".
3. Click on "'PreProcess vBaGallery WOL Activities".
4. The first line of the code should be:
   
   PHP Code:

   if (strpos($loc, '/gallery/') !== false) 

5. Change "gallery" to the folder name you have chosen. Only change this line. Leave the rest alone.
6. Click save and you're done.

[dcpaq2xx]

Thank you vinzphua

Ill give this a try first chance I get.

Doug

[dcpaq2xx]

vinzphua,

Thank you that did work, but I notice that when I go deeper into the folders than just the Main Page the "WOL" shows "Viewing Gallery Index Home Gallery" until I reach the last folder that contains the actual images.

Once I hit that folder with the images it then shows "Browsing Image Gallery Home Gallery" and when I click on the "Home Gallery" link I get a white page cannot be displayed error.

Anything else that needs to be adjusted?

Doug

[vinzphua]

Hi Doug,

Can you PM me your forum/gallery URL? I would like to see how you organise your gallery.

Second thing is, you should not be seeing the words "Home Gallery", unless you changed the phrases that were installed with the Product XML.

Disable the product and see if you still get an error when you click the "Home Gallery" link. When you say "Home Gallery" link, am I correct to assume you are talking about the (originally) "Home" link on the vBGallery menu bar?

[vinzphua]

If you view a Category, for which the "Act as Category" option is set to "No", the WOL will show "Viewing Gallery Index".

[dcpaq2xx]

Originally Posted by vinzphua

I would like to see how you organise your gallery.

I have them organized like a "family tree" kinda like. I have multiple folders and you work your way through them until you get to the catagory you want. Like for example with car manufacturers, youll see a list of all the manufacturers, gm, ford, vw, chrysler, and so on. You click on which one you want, then you see another lists of folders by GM line such as like on GM for example, youd have, Buick, GMC, Chevrolet, and so on. Then you would select which one of these you want and then youd get a list of models and you would pick your model and the list just keeps breaking it down until you select the exact thing you want. Get the idea of how its laid out now?

It would be similar to the way the navigation line at the top of the forums here is or like when your on Ebay.com's site. See attached screen shots for an example.

Originally Posted by vinzphua

Second thing is, you should not be seeing the words "Home Gallery", unless you changed the phrases that were installed with the Product XML.

I have not changed any phrases in the Gallery that I know of.

Originally Posted by vinzphua

Disable the product and see if you still get an error when you click the "Home Gallery" link.

Ill give it a try when I get time.

Originally Posted by vinzphua

When you say "Home Gallery" link, am I correct to assume you are talking about the (originally) "Home" link on the vBGallery menu bar?

NO, I am not.... I am referring to the "Home" link in the WOL, NOT the VB GAllery Menu Bar.

[vinzphua]

I think I got it. You installed the modified one that Oblivion_Knight posted. It's in post #45. That's why you have "Home Gallery". You need to check with him why the link "Home Gallery" does not work.

As for "Viewing Gallery Index", I have answered in my previous post.

[dcpaq2xx]

Originally Posted by vinzphua

You installed the modified one that Oblivion_Knight posted. It's in post #45.

Yes that is correct, I did install his, I did not think there was a difference but apparently there is.

Doug

[mrderanged]

I just uninstalled this mod and my forums are completely hosed!!!!!

Getting the following mysql errors everywhere:

Database error in vBulletin 3.5.3:

Invalid SQL:

		SELECT 
			userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
			IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
			language.phrasegroup_holiday AS phrasegroup_holiday,
			language.phrasegroup_global AS phrasegroup_global,
			language.options AS lang_options,
			language.languagecode AS lang_code,
			language.charset AS lang_charset,
			language.locale AS lang_locale,
			language.imagesoverride AS lang_imagesoverride,
			language.dateoverride AS lang_dateoverride,
			language.timeoverride AS lang_timeoverride,
			language.registereddateoverride AS lang_registereddateoverride,
			language.calformat1override AS lang_calformat1override,
			language.calformat2override AS lang_calformat2override,
			language.logdateoverride AS lang_logdateoverride,
			language.decimalsep AS lang_decimalsep,
			language.thousandsep AS lang_thousandsep
			
		FROM user AS user
		LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
		LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) INNER JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid)) 
		
		WHERE user.userid = 8152;

MySQL Error  : Unknown column 'language.phrasegroup_holiday' in 'field list'
Error Number : 1054
Date         : Thursday, August 31st 2006 @ 10:19:03 PM
Script       : http://www.arachnoboards.com/ab/index.php
Referrer     : 
IP Address   : 24.47.177.239
Username     : 
Classname    : vB_Database

Database error in vBulletin 3.5.3:

Invalid SQL:

					SELECT languageid,
			phrasegroup_holiday AS phrasegroup_holiday,
			phrasegroup_global AS phrasegroup_global,
			options AS lang_options,
			languagecode AS lang_code,
			charset AS lang_charset,
			locale AS lang_locale,
			imagesoverride AS lang_imagesoverride,
			dateoverride AS lang_dateoverride,
			timeoverride AS lang_timeoverride,
			registereddateoverride AS lang_registereddateoverride,
			calformat1override AS lang_calformat1override,
			calformat2override AS lang_calformat2override,
			logdateoverride AS lang_logdateoverride,
			decimalsep AS lang_decimalsep,
			thousandsep AS lang_thousandsep
					FROM language
					WHERE languageid = 1;

MySQL Error  : Unknown column 'phrasegroup_holiday' in 'field list'
Error Number : 1054
Date         : Thursday, August 31st 2006 @ 10:19:02 PM
Script       : http://www.arachnoboards.com/ab/
Referrer     : 
IP Address   : 68.225.182.163
Username     : 
Classname    : vB_Database

PLEASE HELP!!!!!!

[vinzphua]

Apologies for the late response, I don't check in here as often I used to.

This mod is a pure plugin and does not alter any vBulletin codes. And it is only excuted if you go to the WOL page. In both these errors, you are in the forum index page. The plugin has nothing to do with this error. Did you do anything else other then uninstall this product?

I suggest you disable all plugins temporarily and see if you still get this error. You can do this by editing your config.php and:

1. Look for '<?php'. This is usually in the first line of the config.php file.

2. Add 'define('DISABLE_HOOKS', true);' below that line.

If that helps, it means one of the other mods are acting up.

Wish I can help more.