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.

[The Geek]

Originally Posted by tormodg

Geek - is there any hope that a version with the ability to add image captions will surface? Or at least a custom BB tag for captions?

It would make my editorial staff very happy.

what - for the popup hack? Im not sure I get you. Cant you just type them in after inserting the image?

[tormodg]

No, I mean captions aligned to the image - like on this page:

http://www.hypography.com/article.cfm?id=34288

It would require a table with two rows.

[ricker]

Using VBA RC4, I had to use the alternate php file and do the search thing for the phrases to show up. Working great after that!! Excellent hack!
Sarah

[TwinsForMe]

[high]* TwinsForMe clicks install
[/high]

Thanks.

ETA: I've also installed the pop-up link in the Signature area and the quick reply.

For the signature, in /profile.php find:

$phrasegroups = array('user', 'timezone', 'posting')

Change to:

$phrasegroups = array('user', 'timezone', 'posting', 'Geek_Gallery_Popup')

For the quick reply, edit template showthread_quickreply:

Find:

							<label for="qr_quickreply"><input type="checkbox" name="quickreply" value="1" id="qr_quickreply" accesskey="w" tabindex="4" />$vbphrase[quote_message_in_reply]</label>
						</div>
					</fieldset>

Then after add:

	<fieldset id="photobox" title="My Photos">
	    <legend>$vbphrase[geek_gallery_my_pictures]</legend>
	    <table cellpadding="4" cellspacing="0" border="0" align="center">
	    <tr>
	        <td class="smallfont" colspan="$vboptions[smcolumns]">[<a href="#" onclick="window.open('geek-gallery-popup.php','geekgallery','scrollbars=yes,resizable=yes,width=550,height=500'); return false" title="Pick">$vbphrase[geek_gallery_select]</a>]</td>
	    </tr>
	    </table>
	</fieldset>

AND open file, /showthread.php and find:

$phrasegroups = array('posting', 'postbit', 'showthread')

Change to:

$phrasegroups = array('posting', 'postbit', 'showthread', 'Geek_Gallery_Popup');

[aberg]

Several times to try making the script working.
But when the popup venster show up, it have this error:

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,images.storecat storecat
FROM bouv_nl_-_fotopost.pp_photos AS images
INNER JOIN bouv_nl_-_fotopost.pp_categories AS c on images.cat=c.id
WHERE images.userid=1 and images.approved=1 ORDER BY images.date DESC LIMIT 0 ,13
mysql error: You have an error in your SQL syntax near '-_fotopost.pp_photos AS images
INNER JOIN bouv_nl_-_fotopost.pp_' at line 4

mysql error number: 1064

I have for vbulletin and photopost a seperate database.
Any idea what is wrong ??

[The Geek]

Originally Posted by aberg

Several times to try making the script working.
But when the popup venster show up, it have this error:

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,images.storecat storecat
FROM bouv_nl_-_fotopost.pp_photos AS images
INNER JOIN bouv_nl_-_fotopost.pp_categories AS c on images.cat=c.id
WHERE images.userid=1 and images.approved=1 ORDER BY images.date DESC LIMIT 0 ,13
mysql error: You have an error in your SQL syntax near '-_fotopost.pp_photos AS images
INNER JOIN bouv_nl_-_fotopost.pp_' at line 4

mysql error number: 1064

I have for vbulletin and photopost a seperate database.
Any idea what is wrong ??

whats the other db name and what is your prefix?

[Lizard King]

Geek I just want my members to post thumbnails as some images are really large. So I have to edit geek-gallery-popup.php but what do i have to remove

[The Geek]

Originally Posted by Lizard King

Geek I just want my members to post thumbnails as some images are really large. So I have to edit geek-gallery-popup.php but what do i have to remove

Just set the default method in the php file and remove the other options from the template.

HTHs

[larryd]

I just installed this and it does not work for me. Under the smilies box all i have is []. Can I get some help?

[KTBleeding]

larryd, you need to make sure you edited the files that needed phrase inserts. What files are you browsing when you see " [ ] "??