Geek Gallery Popup for vBadvanced Gallery or PhotoPost 4 or higher

IMPORTANT:
Please note that I can no longer support this project. Primarily as it is designed for vb3.0.x and I no longer use that version (im obviously on vb3.5x ). There is a version for vb3.5 over here . This project is left here for the community.
-----------------------


Inspired by mpdev's photopost popup modifcation.
I used photopost and had his modification installed. When I moved from photopost to vBadvanced Gallery, I needed the same type of hack - so here it is!

This lil doofer is designed to allow your users to open up a popup window while creating a post. The popup window will display all of the users images in thier gallery (vba or photopost) and allow them to click on an image to insert it into their post (inline). They can insert the image as a thumbnail, large image, or a clickable thumbnail that will open the large image in a seperate window. The real cool thing here is that all this works no matter which editor they are using.

You must have vBadvanced Gallery installed and working or PhotoPost 4 or higher duh.

Difficulty: Easy
File modifications: A few (only for phrases).
Time: About 5 minutes
Sign: Libra

Known issues:
Mozilla wysiwyg editor does not allow for html inserts which limits their options to thumbs or original pics only.

Change Log
v. 3 Update 20/2/05
Rewrote most of file to include support for PhotoPost. You can now set up your installation to use either vBadvanced Gallery or PhotoPost 4 or 5. This is determined by the settings in your geek-gallery-popup.php file. Special thanks goes to MPdev for helping sort out the PP integration.

v.2.01 update 11/2/05
fixed mozilla support

v.2 update 3/1/05

1. Added a couple more insertion methods
2. Tidied up UI big time
3. Auto sized popup window
4. Finished the phrasing (found a hard coded phrase)

v.1.1 updated 21/12/04

1. Added phrasegroup additions to newreply, newthread and private as phrases were not appearing there (easy edits).
2. Made the $mediaext easier to edit (types of images allowed in popup)
3. Fixed typo in template that always showed the Next button (took me ages to find the stupid thing)
4. Fixed Back phrase as it was overwritten during the install
5. Fixed problem where in non wysiwyg editor, the clickable thumb was screwing up

To upgrade: Follow instructions in the Readme

Make sure you click the freaking Install button. Otherwise you will run the risk of being skipped over in my Christmas Card Mail Out.

[GamerzWorld]

Now im getting

Database error in vBulletin 3.0.7:

Invalid SQL:
mysql error: Query was empty

mysql error number: 1065

Date: Wednesday 16th of March 2005 05:48:57 AM
Script: http://www.mirzone.net/forum/geek-gallery-popup.php
Referer: http://www.mirzone.net/forum/newrepl...uote=1&p=53445
Username: Merlin

[The Geek]

Originally Posted by GamerzWorld

Now im getting

Database error in vBulletin 3.0.7:

Invalid SQL:
mysql error: Query was empty

mysql error number: 1065

Date: Wednesday 16th of March 2005 05:48:57 AM
Script: http://www.mirzone.net/forum/geek-gallery-popup.php
Referer: http://www.mirzone.net/forum/newrepl...uote=1&p=53445
Username: Merlin

Thanks - I just recieved your file. It looks like the problem is that all of the settings are commented out.

Uncomment the settings that are applicible to you (in this case the photopost settings) and let me know if that sorts it.

Thanks

[GamerzWorld]

Originally Posted by The Geek

Thanks - I just recieved your file. It looks like the problem is that all of the settings are commented out.

Uncomment the settings that are applicible to you (in this case the photopost settings) and let me know if that sorts it.

Thanks

Database error in vBulletin 3.0.7:

Invalid SQL: SELECT
images.id AS imageid,images.cat,c.catname AS cattitle,'' AS extention,images.title,
images.bigimage AS filename,images.medsize,images.width owidth, images.height oheight,images.medwidth width,images.medheight height
FROM photo.pp_photos AS images
INNER JOIN photo.pp_categories AS c on images.cat=c.id
WHERE images.userid=171 and images.approved=1 ORDER BY images.date DESC LIMIT 0 ,13
mysql error: select command denied to user: 'merlin@localhost' for table 'pp_photos'

mysql error number: 1142

[The Geek]

Originally Posted by GamerzWorld

Database error in vBulletin 3.0.7:

Invalid SQL: SELECT
images.id AS imageid,images.cat,c.catname AS cattitle,'' AS extention,images.title,
images.bigimage AS filename,images.medsize,images.width owidth, images.height oheight,images.medwidth width,images.medheight height
FROM photo.pp_photos AS images
INNER JOIN photo.pp_categories AS c on images.cat=c.id
WHERE images.userid=171 and images.approved=1 ORDER BY images.date DESC LIMIT 0 ,13
mysql error: select command denied to user: 'merlin@localhost' for table 'pp_photos'

mysql error number: 1142

Huh. That error is saying that you do not have select permissions on that table? This hack uses the vB DB permissions. It may be that you installed the PP DB under a different user.

Can you check your permissions?

[GamerzWorld]

Originally Posted by The Geek

Huh. That error is saying that you do not have select permissions on that table? This hack uses the vB DB permissions. It may be that you installed the PP DB under a different user.

Can you check your permissions?

How?

[The Geek]

Originally Posted by GamerzWorld

How?

Do you have phpMyAdmin? There you can click on the Privlidges link on the home page.

[msimplay]

Originally Posted by msimplay

hmm mozilla doesn't allow for html insert but why notjust make it insert the bbcode the same way the standard editor does?

any news on this ?

[The Geek]

So far - none. In all fairness I havent been able to spend too much time on it - but my initial investigation (when you brought it up) didnt pan out.

Im just polishing off a new version of GAS and will look into it then.

[GamerzWorld]

Im having a problem with the button on new thread. When making a new thread i get no text and link only

[]

I have done the phrase thing you mentioned (finding and saving) so im thinking its a file/template error on my part. To narrow it down can you tell me which step its likly to be?

[The Geek]

Originally Posted by GamerzWorld

Im having a problem with the button on new thread. When making a new thread i get no text and link only

[]

I have done the phrase thing you mentioned (finding and saving) so im thinking its a file/template error on my part. To narrow it down can you tell me which step its likly to be?

Hey there - sorry I missed you (went off on business). Are you sure you added to the phrasegroups correctly? If not - you can always just edit the smilie template in the instructions and switch to a hard coded phrase.