Geek Gallery Popup 4.0

From the makers of lint and fuzz come the oh-so-popular-cant-live-with-out Mack that transformed the lives of all whom beheld it.

Yes, this is: Geek Gallery Popup for vBa and PhotoPost*

Gpop will allow your users to easily insert pictures from their gallery into their posts and private messages.

New features include:
Browse by category
Insert aligned images

Installation difficulty: About as hard as a sneeze
File edits: 0
Plugins: 0
template edits: 1

Known issues:
If the editor isnt selected, and you click a pic... it inserts the freaking pic in the page instead of the editor. Odd stuff. Im sure ill figure that out shortly.

*PhotoPost support is built in however please note that I dont have PP any longer and so I cant really test for it. Therefore, if you are a PP user, let me know if it works

Please click install if you install it.

nJoy

[FASherman]

To everyone getting an error like this:

Database error in vBulletin 3.5.0:

Invalid SQL:
SELECT count(id) total FROM [database].photos WHERE userid=[uid];

MySQL Error : Table '[database].photos' doesn't exist
Error Number : 1146
Date : Friday, November 4th 2005 @ 12:56:25 PM
Script : http://www.yoursite.com/forums/g...d=vB_Editor_001
Referrer :
Classname : vb_database

Do this...

FIND

PHP Code:

$pages = $db->query_first("SELECT count(id) total FROM $gallery_db" . $photo_prefix . "photos WHERE userid=$userid "); 


AND REPLACE WITH:

PHP Code:

$pages = $db->query_first("SELECT count(id) total FROM $gallery_db" . $pp_prefix . "photos WHERE userid=$userid "); 


I'm still looking to see what the problem is with the page links.

EDIT...

Okay, found it.

FIND:

PHP Code:

    $query="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 $gallery_db" . $pp_prefix . "photos AS images
        INNER JOIN $gallery_db" .  $pp_prefix . "categories AS c on images.cat=c.id
        WHERE images.userid=$userid and images.approved=1 ORDER BY images.date DESC LIMIT $start ," . ($perpage); 


ADD BEFORE IT:

PHP Code:

$start = ($page-1) * $perpage; 


That should fix the URL problem.

[FASherman]

That only leaves the issue with the image being inserted in the header when the editor looses focus.

[The Geek]

You rock man! Ive just been working on this (tough to do when I dont have PP anymore!) This has saved me loads of time for the PP users.

Thanks again! Ill test and update the package.

[FASherman]

Originally Posted by The Geek

You rock man! Ive just been working on this (tough to do when I dont have PP anymore!) This has saved me loads of time for the PP users.

Thanks again! Ill test and update the package.

You're the one coming up with the killer hacks. I just fixed a few minor things. Hardly worth mentioning.

[j.kramer]

Hi All,

Everything works good untill I start a new thread and try to insert images they all appear on top of site instead of message box.
When just reply to a thread everything works fine!!

Anybody know what could cause this problem?

Geek you already got access to my site so maybe you could also take a look at that one while your at it ;-)

[FASherman]

I can explain the problem. When you start a new thread or even a blank reply, you need to activate the cursor in the editor to give the editor focus, then click on the link for your pictures.

If you just hit the new thread or reply button and then the pic link after the page loads, the editor never has focus so the insert is being done in the document root, which is the page itself.

Note to TheGeek...

I'm sure the answer is in the smilie code. If you take and make a reply, click in the title box and then click on a smilie, focus is returned to the editor and the smilie is inserted in the first character position. That should for your hack too.

[j.kramer]

FASherman that's what happens indeed, so that's why I thought a reply on thread worked because I already focused cursor.

[The Geek]

Package update (thanks Fasherman).

The only outstanding issue I know of now is when the image gets dumped into the page instead of the editor.

[Talisman]

Oh this is really nice.... Thanks so much!

[GrendelKhan{TSU]

I get this error:

Warning: main(./global.php): failed to open stream: No such file or directory in /home/XXXXMYDBXXX/public_html/forums/gallery/geek-gallery-popup.php on line 43

Fatal error: main(): Failed opening required './global.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/XXXMYDBXXXX/public_html/forums/gallery/geek-gallery-popup.php on line 43

this only is when replying to an image in vbaGALLERY itself.

anyone else get this? or does it work for everyone else?