Add-On Releases - Module CMPS: PhotoPost vBGallery

/* ----------------- 8/28/2007 6:41pm -----------------

Add Gallery Images to your vBAdvanced CMPS 3.x
Do you have PhotoPost vBGallery v2.0 + installed ?

Looking @ changes in the gallery. This hack will work with vbgallery 2.2, 2.3 out of the box.
- you can get a patch if you have 2.0, 2.1 - here.

Tested on:
- vBulletin 3.6.8
- PhotoPost vBGallery v2.3
- vBadvanced CMPS v3.0 RC1

1 query added to CMPS

Zachariah @ http://www.szone.us/

EX: 3 CMPS blocks 3 different settings
http://www.szone.us/index.php?id=gallery

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


Change Log
===========
2.6
- Added option for module title.
- Added option for module link.
- Added option to choose from thumbnail, normal, origianal


2.5
- Added Template: adv_portal_vbgallery_imagebit
- Edited Template: adv_portal_vbgallery_nav - added search dropdown
- Edited Template: adv_portal_vbgallery - changed to work with standard CMPS wrapper
- Multi-Modules can be used on the same page using the same php file with different settings
EX: 3 CMPS blocks 3 different settings http://www.szone.us/index.php?id=gallery


2.2
- reworked to work on CMPS 3.0

2.1
- Package added to: imagegallery.module
- Block settings per CMPS page
- Permissions fixed


2.0
- adv_gallery_images -> ppgal_images

1.9
- Added vb3.6

1.8
- Added functions_gallery_store.php
- Added column span support

1.7
- Install w/ product in 1 file.
- Killed the need for FORUMHOME template edit.
- 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.)


1.5
- <If> usergroup can not see thunbnails FORUMHOME edit will not show up.

1.4
- Removed Phrase to name gallery <table> now use $vba_options[gallery_title]
- Added 3 prases in "global" - filesize,category,dimensions

1.3
- Display images from specific categories.

1.2
- added Phrase support

[ZGeek]

me too!

[Zachariah]

The tables have changed in vBGallery 2.0.
The prefix of tables changed from adv_gallery_ to ppgal_.

• adv_gallery_categories --> ppgal_categories
• adv_gallery_customfields --> ppgal_customfields
• adv_gallery_customfields_entries --> ppgal_customfields_entries
• adv_gallery_ecards --> ppgal_ecards
• adv_gallery_exif --> ppgal_exif
• adv_gallery_favorites --> ppgal_favorites
• adv_gallery_filetypes --> ppgal_filetypes
• adv_gallery_images --> ppgal_images
• adv_gallery_moderator --> ppgal_moderator
• adv_gallery_permissions --> ppgal_permissions
• adv_gallery_posts --> ppgal_posts
• adv_gallery_rate --> ppgal_rate
• adv_gallery_search --> ppgal_search
• adv_setting --> ppgal_setting
• adv_settinggroup --> ppgal_settinggroup
• adv_gallery_subscribecat --> ppgal_subscribecat
• adv_gallery_subscribeimage --> ppgal_subscribeimage

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

FROM " . TABLE_PREFIX . "adv_gallery_images

Is now: Ver 2.0 +

FROM " . TABLE_PREFIX . "ppgal_images

Please take note if you have problems with old hacks or want to work on new projects.

[johnstires]

This code change is for the vbgallery_block.php file. It fixed it for me. Thanks! Anyone have the vertical template for this?

[elsupremo]

Thanks for that fix, it did work.
Unfortunately, another problem has come up.

If I am logged in under my administrator account, the site loads and the portal shows up fine.

If I am logged in under a regular account or if I am logged out completely, I only get a database error and the site does not load.

Any help will be immensely appreciated - I installed and used this addition for a long time without any trouble under VB 3.5, and am hoping to continue using it under 3.6.

Thanks!

[TRR]

Originally Posted by joerns

Have created the module as per instructions, activated it and added it to the home page but nothing shows up - blank. Went into the CP and set the options to one column and one picture. The module is set to display in the right column. Wrecked my brain, but couldn't figure out what the problem may/could be. Any ideas? I'm running vBulletin 3.6.1, PhotoPost vBGallery v2.0 (vB 3.6) and vBadvanced CMPS v2.2.0 (vB 3.6.) I see you tested it on vBadvanced CMPS v2.2.1 (vB 3.6) but that does not seem to be availalbe for download on vbadvanced,.com yet?

Had the same problem until I updated the init.php file.

[TRR]

Originally Posted by Zachariah

The tables have changed in vBGallery 2.0.
The prefix of tables changed from adv_gallery_ to ppgal_.

• adv_gallery_categories --> ppgal_categories
• adv_gallery_customfields --> ppgal_customfields
• adv_gallery_customfields_entries --> ppgal_customfields_entries
• adv_gallery_ecards --> ppgal_ecards
• adv_gallery_exif --> ppgal_exif
• adv_gallery_favorites --> ppgal_favorites
• adv_gallery_filetypes --> ppgal_filetypes
• adv_gallery_images --> ppgal_images
• adv_gallery_moderator --> ppgal_moderator
• adv_gallery_permissions --> ppgal_permissions
• adv_gallery_posts --> ppgal_posts
• adv_gallery_rate --> ppgal_rate
• adv_gallery_search --> ppgal_search
• adv_setting --> ppgal_setting
• adv_settinggroup --> ppgal_settinggroup
• adv_gallery_subscribecat --> ppgal_subscribecat
• adv_gallery_subscribeimage --> ppgal_subscribeimage

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

FROM " . TABLE_PREFIX . "adv_gallery_images

Is now: Ver 2.0 +

FROM " . TABLE_PREFIX . "ppgal_images

Please take note if you have problems with old hacks or want to work on new projects.

I am still new to this; where do I make the corrections so that I don't get the "table does not exist" error?

[elsupremo]

Originally Posted by TRR

I am still new to this; where do I make the corrections so that I don't get the "table does not exist" error?

You need to open the vbgallery_block.php file included in the mod download. Find "adv_gallery_images" in the line of code given above and replace it with "ppgal_images". Save file, reupload to to server/forums/modules/.

[elsupremo]

Originally Posted by elsupremo

Thanks for that fix, it did work.
Unfortunately, another problem has come up.

If I am logged in under my administrator account, the site loads and the portal shows up fine.

If I am logged in under a regular account or if I am logged out completely, I only get a database error and the site does not load.

Any help will be immensely appreciated - I installed and used this addition for a long time without any trouble under VB 3.5, and am hoping to continue using it under 3.6.

Thanks!

I would still love some help with this problem...or at least a suggestion? I would hate to permanently lose the use of this mod!

[WZZZ]

Invalid SQL:

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

WHERE Array valid = 1


ORDER BY RAND()
LIMIT 4;

Ошибка MySQL : 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 'valid = 1


ORDER BY RAND()
LIMIT 4' at line 4

[Jaxx]

Wow, you're not the only one getting that error WZZZ.

I had to disable it because my users couldnt' log in due to that.