Module CMPS: PhotoPost vBGallery

/* -----------------12/31/2005 6:41pm -----------------

Add Gallery Images to your CMPS v1.8

This hack is an add-on to a gallery made by PhotoPost.com called vBGallery.
- This is not a gallery, but a way to display the images from the gallery to your forums.

Do you have vBGallery installed ?

Tested on:
- vBulletin 3.5.2
- PhotoPost vBGallery v1.0.2 (vB 3.5)
- vBadvanced CMPS v2.0.0 (vB 3.5)

Zachariah - http://www.gzhq.net

Product XML
1 file edit
Upload file
Create Module
Change settings

1 query added to CMPS

DEMO

--------------------------------------------------*/

Change Log
===========
1.8
- Added functions_gallery_store.php
- Added column span support

1.7
- Install w/ product in 1 file.
- AdminCP options to change the hack settings
- Added: Parts of the gallery's Nav bar w/ dropdowns
(My Stuff*, What's New, What's Popular,Search) to the hack with on/off option.

* My Stuff will not be seen if you are a guest.

1.6
- Added: If the gallery is off or disabled the hack not show up.
- Added: templates to support the hack vs. gallery templates
(allows you to customize the templates for the look and feel you want vs. mess up the way your gallery templates look.)

[techenigma]

I get the following error when I tried to install this:

Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT imageid, images.title, filename, thumbname, originalname, extension, images.catid ,images.userid, images.username, images.title, images.description, images.dateline ,filesize, originalfilesize ,width, height, originalwidth, originalheight, images.views, images.posts, images.lastpostdateline, images.lastpostuserid, images.lastpostusername, votenum, votetotal
FROM adv_gallery_images AS images

WHERE valid = 1
AND images.catid IN (2)

ORDER BY RAND()
LIMIT 4;

MySQL Error : Table '***********.adv_gallery_images' doesn't exist
Error Number : 1146
Date : Thursday, December 7th 2006 @ 12:30:42 AM
Script : http://********/index2.php
Referrer :
IP Address : ***********
Username : ***********
Classname : vb_database

what on earth is causing that, the forums work, and my gallery works just the CMPS shows up as a big database error screen.

[Zachariah]

Originally Posted by techenigma

I get the following error when I tried to install this:

Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT imageid, images.title, filename, thumbname, originalname, extension, images.catid ,images.userid, images.username, images.title, images.description, images.dateline ,filesize, originalfilesize ,width, height, originalwidth, originalheight, images.views, images.posts, images.lastpostdateline, images.lastpostuserid, images.lastpostusername, votenum, votetotal
FROM adv_gallery_images AS images

WHERE valid = 1
AND images.catid IN (2)

ORDER BY RAND()
LIMIT 4;

MySQL Error : Table '***********.adv_gallery_images' doesn't exist
Error Number : 1146
Date : Thursday, December 7th 2006 @ 12:30:42 AM
Script : http://********/index2.php
Referrer :
IP Address : ***********
Username : ***********
Classname : vb_database

what on earth is causing that, the forums work, and my gallery works just the CMPS shows up as a big database error screen.

I am working on something new for this hack. The tables have changed names.

EX: Ver. 1.0, 1.0.1, 1.0.2, 1.0.3, 2.0B1/B2

FROM " . TABLE_PREFIX . "adv_gallery_images

v 2.0 +, v1.1+

FROM " . TABLE_PREFIX . "ppgal_images

[techenigma]

so what do I have to change to make this work?

[+buG]

Originally Posted by techenigma

so what do I have to change to make this work?

Try going into the php (/modules/vbgallery_block.php) and searching for:

PHP Code:

FROM " . TABLE_PREFIX . "adv_gallery_images 


Replace with

PHP Code:

FROM " . TABLE_PREFIX . "ppgal_images 


That's all I did and the module works nicely, you'll have to really dig into it to repair the templates for the most current vb and gallery though.

[Jesakos]

i have this error

Warning: main(./includes/functions_gallery.php) [function.main]: failed to open stream: No such file or directory in /modules/vbgallery_block.php on line 17

Fatal error: main() [function.require]: Failed opening required './includes/functions_gallery.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/gwgrirc/public_html/forum/modules/vbgallery_block.php on line 17

anyone know?

i use 3.6.5v

[Jesakos]

anyone?

[Gayble]

i get this error:

XML Error: not well-formed (invalid token) at Line 1

Some one help me?

[triff]

Great mod and works perfectly!

Just one question: Is there anyway to stop the thumbnails linking to the gally? Just showing the thumbnails but no links?

SGL.

[mortydot]

I get this error after installation (following the txt instructions)

Warning: unserialize() expects parameter 1 to be string, array given in [path]/modules/vbgallery_block.php on line 20

Warning: unserialize() expects parameter 1 to be string, array given in [path]/modules/vbgallery_block.php on line 21

Warning: unserialize() expects parameter 1 to be string, array given in [path]/modules/vbgallery_block.php on line 22

Warning: array_merge() [function.array-merge]: Argument #2 is not an array in [path]/modules/vbgallery_block.php on line 26

[Polo]

Originally Posted by mortydot

I get this error after installation (following the txt instructions)

Warning: unserialize() expects parameter 1 to be string, array given in [path]/modules/vbgallery_block.php on line 20

Warning: unserialize() expects parameter 1 to be string, array given in [path]/modules/vbgallery_block.php on line 21

Warning: unserialize() expects parameter 1 to be string, array given in [path]/modules/vbgallery_block.php on line 22

Warning: array_merge() [function.array-merge]: Argument #2 is not an array in [path]/modules/vbgallery_block.php on line 26

I got the same exact Error