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.

[T3MEDIA]

Originally Posted by BrentWilson

In template editor_smiliebox_quickreply add at the end:

	<fieldset id="photobox" title="My Photos">
	    <legend>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">Open</a>]</td>
	    </tr>
	    </table>
	</fieldset>

<if condition="$show['wysiwyg']">
	<script type="text/javascript">
	<!--
	// init the WYSIWYG smilie box
	open_smilie_window($wysiwyg);
	//-->
	</script>
</if>

All we need now is a pop up for An Net's journal and were GOOD!

[Mr.D]

Originally Posted by The Geek

That could be a little difficult - well - not as much difficult as just really time consuming. Ill see what I can do though. Saying that - I wont even get to the next version until my next couple of hacks are completed.

You have my support this could be a very big feature to the Popup Hack

[Mr.D]

Hey Geek can you do a estimate time when will new pop up version be with categories and all...

[The Geek]

Originally Posted by MadMan

Hey Geek can you do a estimate time when will new pop up version be with categories and all...

nope. I havent planned a version with categories. That was a feature suggestion - but I havnt even looked into implimenting it. Right now I have my hands full devloping some other hacks and Ill most likely wait until after vb3.5 to do much more.

[GlitterKill]

I would REALLY like to get this hack working since our gallery is a very important part of the site. I have followe all directions to the T. This is what I see when I click the "Open" link under "My Pictures". What is realyl strange is that if you look at the file it is trying to open "sparkswillfly.jpg" the file is actually there under the thumbs folder BUT there is a number one in front of teh real file ("1sparkswillfly.jpg"). Why is it looking for the wrong file?

EDIT// I just realized it was pullign info from the forums db (old tables not yet deleted) before i split the gallery db off into it's own db. HOWEVER, my gallery db is named "pimprig_com_-_gallery". How can I get this gallery db name to work right? What code needs to go where?

[GlitterKill]

Originally Posted by GlitterKill

I would REALLY like to get this hack working since our gallery is a very important part of the site. I have followe all directions to the T. This is what I see when I click the "Open" link under "My Pictures". What is realyl strange is that if you look at the file it is trying to open "sparkswillfly.jpg" the file is actually there under the thumbs folder BUT there is a number one in front of teh real file ("1sparkswillfly.jpg"). Why is it looking for the wrong file?

EDIT// I just realized it was pullign info from the forums db (old tables not yet deleted) before i split the gallery db off into it's own db. HOWEVER, my gallery db is named "pimprig_com_-_gallery". How can I get this gallery db name to work right? What code needs to go where?

Noone knows? I have everythign else ready to go but the way my database is named is breaking the script.

[The Geek]

hmmm.... had another user who had the same problem and I am trying to remember what the solution was.

If I remember right - mysql hated calling that DB by the fully qualified name as it thought you were trying to use the - operator (it too had _-_ in it). Seems like the solution was to take the db prefix out, then set the DB before the query and return it back after the query.

I would personally avoid using hyphens as object names for this reason (though I know that doesnt help )

[GlitterKill]

Originally Posted by The Geek

hmmm.... had another user who had the same problem and I am trying to remember what the solution was.

If I remember right - mysql hated calling that DB by the fully qualified name as it thought you were trying to use the - operator (it too had _-_ in it). Seems like the solution was to take the db prefix out, then set the DB before the query and return it back after the query.

I would personally avoid using hyphens as object names for this reason (though I know that doesnt help )

Can you tell me what code to change and where? I really didn't have a choice in the naming scheme of the DBs since that is the way Ensim wanted them named.

[The Geek]

Just out of curiosity - can you see what happens if you put ` around the name ie `pimprig_com_-_gallery`

[GlitterKill]

This is what I got when I added those around the field for database name (Ex: "'pimprig_com_-_gallery'"):

Database error in vBulletin 3.0.6:

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 'pimprig_com_-_gallery'.photos AS images
INNER JOIN 'pimprig_com_-_gallery'.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. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''pimprig_com_-_gallery'.photos AS images
INNER JOIN 'p

mysql error number: 1064

Date: Wednesday 25th of May 2005 05:40:38 PM
Script: http://forums.pimprig.com/geek-gallery-popup.php
Referer:
Username: GlitterKill
IP Address: 68.53.59.67