Random Image on Vba CMPS index

kvnband · February 27th, 2007, 12:04 PM

Just upgraded a client's board last night to vb 3.6.4, and of course this broke vba gallery. So today I upgraded vba gallery, but now the random image code that he had present on the old installation isn't working. Here is that code:

Code:

Content visible to verified customers only.

I really need to get just a single random image to display on the vba cmps index as soon as possible. I've checked out the other threads, but they don't look like they're doing what I need.
Kevin

Sybaris · February 27th, 2007, 12:26 PM

Not being funny but if you are getting paid should you not have thought about this before starting and have some idea what is needed to fix any issues...

kvnband · February 27th, 2007, 01:31 PM

You're right - you're not being funny. You're being unhelpful. I actually was not informed that he had vba gallery installed until this morning when he found that it was broken.
If there is anyone who actually has an idea of how to place a random photo on the vba cmps index page, and has something useful to say, unlike the jerk above this post, please reply...

Zachariah · February 27th, 2007, 04:05 PM

Find:

Code:

Content visible to verified customers only.

Change To:

Code:

Content visible to verified customers only.

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

Code:

Content visible to verified customers only.

Is now: Ver 2.0 +

Code:

Content visible to verified customers only.

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

kvnband · February 27th, 2007, 04:56 PM

Awesome!
Thanks for the help man.