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

[carpzone]

Yes the block works fine with the datbase call change.

But i get databse error when i'm not logged in.
The block only shows up ( and my website) when a users is registered.

Is there a fix to work this out ? ...

[zetetic]

In case this wasn't clear to anyone, most of the db errors are the result of an incorrect table name in the vbgallery_block.php file.

Make sure to edit vbgallery_block.php

find:

adv_gallery_images

and change to:

ppgal_images

Save changes and upload the file to your server.

[carpzone]

Hm Yes, I did change that database call fom ADV_..... to PPGAL_..... in the vbgalleryblock.

The block works only if logged in.
If i turn the block on for Unlogged visitors. My webpage dont open.

I get follow error by email

Database error in vBulletin 3.6.4:

Invalid SQL:

                SELECT imageid, images.title, images.description, filename, thumbname, originalname, extension, images.catid  ,images.userid, images.username, images.title, images.dateline, images.views, images.posts, images.lastpostdateline, images.lastpostuserid, images.lastpostusername, votenum, votetotal
                FROM vb_ppgal_images AS images
                
                WHERE Array valid = 1 
    
	 	
	              ORDER BY dateline DESC
                LIMIT 6;

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 'valid = 1 
    
	 	
	              ORDER BY dateline DESC
                LIMIT ' at line 4
Error Number : 1064

[zetetic]

Hmm, I spoke to soon. It works fine for me in Firefox, but using IE I get that same db error.

[gunitman247]

any thing like this for photoplog?

[johnstires]

Originally Posted by zetetic

Hmm, I spoke to soon. It works fine for me in Firefox, but using IE I get that same db error.

That fix worked for me in FF and IE7! Thanks!

[gator777]

I'm unable to get this mod working no matter what I do. I've used this block for a long time, and I miss not having it on my site. I hope Zach has the time to fix it. For now, I am using the "Recent Comments Block" to fill the void.

I hope you read this Zach

[johnstires]

Originally Posted by gator777

I'm unable to get this mod working no matter what I do. I've used this block for a long time, and I miss not having it on my site. I hope Zach has the time to fix it. For now, I am using the "Recent Comments Block" to fill the void.

I hope you read this Zach

Make sure the table prefixes match up. That was my problem.

First, make sure to edit vbgallery_block.php

https://vborg.vbsupport.ru/showpost....9&postcount=82

AND

Make this change.

https://vborg.vbsupport.ru/showpost....2&postcount=52

[gator777]

Originally Posted by johnstires

Make sure the table prefixes match up. That was my problem.

First, make sure to edit vbgallery_block.php

https://vborg.vbsupport.ru/showpost....9&postcount=82

AND

Make this change.

https://vborg.vbsupport.ru/showpost....2&postcount=52

Thanks for your help, but I'm still getting the error messages. I am using....

CMPS x2.2.1
VB v3.6.4
Photopost VB Gallery 2.1

All was goon until I installed Photopost VB Gallery 2.1. If I had know it was going to diable my block, I would not have upgraded to Photopost VB Gallery 2.1.

[carpzone]

Originally Posted by carpzone

Hm Yes, I did change that database call fom ADV_..... to PPGAL_..... in the vbgalleryblock.

The block works only if logged in.
If i turn the block on for Unlogged visitors. My webpage dont open.

I get follow error by email

Database error in vBulletin 3.6.4:

Invalid SQL:

                SELECT imageid, images.title, images.description, filename, thumbname, originalname, extension, images.catid  ,images.userid, images.username, images.title, images.dateline, images.views, images.posts, images.lastpostdateline, images.lastpostuserid, images.lastpostusername, votenum, votetotal
                FROM vb_ppgal_images AS images
                
                WHERE Array valid = 1 
    
	 	
	              ORDER BY dateline DESC
                LIMIT 6;

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 'valid = 1 
    
	 	
	              ORDER BY dateline DESC
                LIMIT ' at line 4
Error Number : 1064

Nobody has a clue what the problem is ?