Forum Home Enhancements - vBGallery - Forum Home

/* -----------------8/9/2006 6:20am -----------------
Add Gallery Images to your Forum Index v1.8

Tested on:
vBulletin 3.6
PhotoPost vBGallery v2.0 Beta

Zachariah - http://www.gzhq.net

// ---------------------------------------------------------

DEMO

- Feedback Please :squareeyed:

Overview:

• import Product XML
• 1 file edit
• 2 file uploads
• 1 image upload
• Adds 1 Query to FORUMHOME

Hack includes:
- Hack Active (yes / no)
- Enable Navbar (yes / no)
- Image Count (number of images)
- Image Order (Random, Newest, Most Views, Most Comment, Highest Rated)
- Column Span (Choice of column count accross)
- Locations (Above Header, Below Header, Under Navbar, Above What's going on, Inside What's going on, Below What's going on, Custom)
- Exclude Catagories
- Only Catagories
- On/Off options for all of the "info" per image
- If gallery is not active hack will vanish (all usergroups)
- Admin will get "Alert: The gallery is currently turned off!" on FORUMHOME
- If gallery settings of a usergroup does not see "thumbnails" the hack will vanish
- No Template edits

Change Log
===========
1.8 - 8/9/2006
- Column Span: Choice of column count across.
- Locations: (were should be displayed on the forumhome)

• Above Header
• Below Header
• Under Navbar
• Above What's going on
• Inside What's going on
• Below What's going on
• Custom

Select "Custom" and place $vbgallery in FORUMHOME template for custom location.


1.7 Beta 2 - 01.17.06
- Fixed usergroups not able to see the hack
- Fixed sort order problems

1.7
- Install w/ product and 2 edits 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.)

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

[dbarry]

Tried installing this one, I'm getting this error:
Database error in vBulletin 3.6.1:

Invalid SQL:

SELECT imageid, images.title, images.description, filename, thumbname, originalname, extension, images.catid ,images.userid, images.username, images.title, images.description, images.dateline, images.views, images.lastpostdateline, images.lastpostuserid, images.lastpostusername, votenum, votetotal
FROM adv_gallery_images AS images

WHERE valid = 1


ORDER BY dateline DESC
LIMIT 1;

MySQL Error : Table 'electrak_forum.adv_gallery_images' doesn't exist Error Number : 1146

[da420]

Hey Zachariah, thanks for this.

One problem,
Everything seems to work fine when logged in. When showing as an unregistered user it is giving a database error. It only seems to be happening when unregistered, but when logged in it works perfectly. Any suggestions?

[RMS-Chef]

Originally Posted by dbarry

Tried installing this one, I'm getting this error:
Database error in vBulletin 3.6.1:

Invalid SQL:

SELECT imageid, images.title, images.description, filename, thumbname, originalname, extension, images.catid ,images.userid, images.username, images.title, images.description, images.dateline, images.views, images.lastpostdateline, images.lastpostuserid, images.lastpostusername, votenum, votetotal
FROM adv_gallery_images AS images

WHERE valid = 1


ORDER BY dateline DESC
LIMIT 1;

MySQL Error : Table 'electrak_forum.adv_gallery_images' doesn't exist Error Number : 1146

I had the same issue. After a little research on the photopost.com release thread I noticed that with the vBGallery v2.0 GOLD release that there are quite a few database table name changes (if not all of them).

Originally Posted by PhotoPost.com vBGallery v2.0 GOLD Release Thread

In order to not conflict with other vBAdvanced products the tables of the gallery have been renamed. 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

When you upgrade this will stop hacks in your site that use the gallery's old tables. Please disable or repair the add-ons in your site before upgrade.

I imagine users that are running the v2.0 betas with the older database table names are not having this issue but users like us that have installed the latest v2.0 GOLD with the new table names are out of luck with the hack until Zach updates it.

EDIT:
It appears that an updated version has been released by Zach on the PhotoPost forums HERE as it lists the vBGallery version as "v2.0 GOLD". The README.TXT in that download confirms this with the latest version notes. I am out of time tonight but will attempt to install that one tomorrow.

[detalhe]

Didn't find any updates of this hack there..

[RMS-Chef]

Originally Posted by detalhe

Didn't find any updates of this hack there..

Log in on your verified customer account there and you will.

[da420]

Originally Posted by da420

Hey Zachariah, thanks for this.

One problem,
Everything seems to work fine when logged in. When showing as an unregistered user it is giving a database error. It only seems to be happening when unregistered, but when logged in it works perfectly. Any suggestions?

This was fixed by finding and deleting "$privatecatids" out of the gallery_block.php file under modules.

[Zachariah]

This will not be needed in vBGallery 2.1 +

:rambo: :ninja: :banana:

[detalhe]

Originally Posted by RMS-Chef

Log in on your verified customer account there and you will.

Now I did, when I looked for it first it wasn't there

Anyway, just installed it without problems, admicp shows correctly and hack is active but no images show on forum :alien:

[TRR]

yow. does this not work with the "Right Side Column 1.0.2" mod? When I install, it blows up my forum home page. Pictures are all over the place, various bits of html, and other general oddities and foolery.

[Jaxx]

Hmm. I started getting a bunch of these:

Database error in vBulletin 3.6.2:

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 ppgal_images AS images

WHERE Array valid = 1


ORDER BY RAND()
LIMIT 1;

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 RAND()
LIMIT 1' at line 4
Error Number : 1064

I just updated from 3.07 to 3.62.