Add-On Releases - vBulletin Slide Show 1.10

About
This mod was commissioned by "The Land of Fu" and approved for release at vbulletin.org. The original goals for developing this mod were:

• To reduce the growing size of vbulletin database;
• To allow members to posts series of images not limited in size, but kept at images hosting sites like photobucket.com, imageshack.com, tinypic.com, etc...;
• To allow continuing discussions within those threads displaying slide shows.

Acknowledgement
The basis codes used in this mod originate from SINA?s, an online media company and MVAS provider in the People's Republic of China and the global Chinese communities, and have been modified to suit the needs of "The Land of Fu". The basis templates have been adapted from the vBulletin Album templates.

What this mod does

It adds a Flash "Slide Show" system to your community, a slide show been a display of a series of chosen pictures, which is done for artistic, instructional or discussion purposes.

How To Use The Slide Show In Your Threads

Open/Create a thread describing the content of your slides (Pictures, Covers, Posters, Lobby Cards, etc...). Once the thread has been successfully created, click on the "Thread Tools" menu and select "Add Slide Show". Follow the instructions afterwards. To edit the content of your slide show, click on the "Thread Tools" menu and select "Edit Slide Show".

Features:

1. Create a slide show from images/pictures kept anywhere on the internet.
2. No limitations in images/pictures sizes.
3. No uploading and storage of images/pictures in your mysql database.
4. Fully phrased to allow (language translation)
5. Displays a flash slide show to the main post of threads.
6. Displays a button for selection of the flash playing speed mode.
7. Displays a button for forward, backward display of images/pictures
8. Displays a button for viewing of images/pictures in flash full screen mode.
9. Displays a button for viewing images/pictures in tabulation mode.
10. Displays a link in the ?Thread Tools? for adding/editing slide shows.
11. Option to add a ?Slide Shows? link on the navigation menu, for displaying all slide shows created.
12. Option to add a quick link to the "Quick Navigation" menu, for displaying all slide shows created.
13. Option to disable the mod on selected forums
14. Option to ban selected usergroups from using the mod.
15. Displays user?s slide show mini-block on user?s profile.
16. Displays user?s slide show statistics on user?s profile.
17. Option to display user?s slide show statistics on postbit.
18. Option to display a mini slide show on forum home.

Installation instructions - Version 1.10.

1. One (1) manual template modification. Perform the following manual template modification (I failed to have it automated).
   

   In SHOWTHREAD template, search for:
   <tr>
   	<td class="vbmenu_option"><img class="inlineimg" src="$stylevar[imgdir_button]/mysticky.gif" />
   	<if condition="in_array($thread['threadid'], $personalstickys)">
   		<a href="showthread.php?$session[sessionurl]do=unpersonalsticky&amp;t=$threadid">$vbphrase[personal_unsticky]</a>
   	<else />
   		<a href="showthread.php?$session[sessionurl]do=personalsticky&amp;t=$threadid">$vbphrase[personal_sticky]</a>
   	</if>
   	</td>
   </tr>
   
   Insert the following right after:
   
   <!-- Slide Show Link -->
   	$slideshow_threadtool_link
   <!-- / Slide Show Link -->

2. Uncompress the archive
3. Upload the content of the "upload" folder into your forum root/main directory
4. Import the "product_slideshow.xml" product via your ACP:
   ACP -> Plugins & Products -> Manage Product -> Add/Import Product
5. Adjust the mod settings as you see fit.
   ACP -> vBulletin Options -> vBulletin Options -> vBulletin Slide Show
6. Save the specified settings.

Working well on vb3.7x - 3.8x

If for some reasons the database columns required by this mod on the "thread" and "user" tables have not been automatically created during this mod installation, please do add those columns manually using the ALTER table command.

ALTER TABLE `thread` ADD `slideshowid` INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL;
ALTER TABLE `user` ADD `slideshows` INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL;

Enjoy

Live demo at: http://www.fuflixbulletin.net
It?s a members only discussion forum and registration is required.

If you have a public board and have installed this mod, please provide a demo link for other users..

Update in v.1.01

1.
In the installation section of the XML:

`cover` varchar(250) NOT NULL),

changed to

`cover` varchar(250) NOT NULL,

Parenthesis removed just after the NULL.

2.
Option not to display the slideshow on forumhome added and checked.

Update in v.1.02

The following piece of code in the XML and PHP files:

query_write("DELETE FROM `". TABLE_PREFIX ."slideshow` WHERE `slideshow`.`slideshowid`=

has been replaced by

query_write("DELETE FROM `". TABLE_PREFIX ."slideshow` WHERE `slideshowid`=

as it affect databases with prefixed tables.


Update in v.1.10

• Option to download active picture on slideshow
• Option for slideshow owner to select/change the background color of its slideshow display
• Option for users to add descriptive text per slide show pictures.

If for some reasons the database new column 'slideshow_bgcolor' required by this mod on the "thread" table has not been automatically created during this mod installation/upgrade, please do add that column manually using the ALTER table command.

ALTER TABLE `TABLE_PREFIXthread` ADD `slideshow_bgcolor` VARCHAR(50) DEFAULT '#fff' NOT NULL

Replace TABLE_PREFIX by your actual table prefix. If you have none, then use the instruction:

ALTER TABLE `thread` ADD `slideshow_bgcolor` VARCHAR(50) DEFAULT '#fff' NOT NULL

Get the attachment from this thread in the vb3.7x section:
https://vborg.vbsupport.ru/showthread.php?t=230476

[Taurus1]

Originally Posted by J98680B2423E

Do you have access to your site's CPanel? If yes, login in there and start phpMyAdmin. Select your database and check the last column of the tables `threads` and `user`. Those should be `slideshowid` and `slideshows`. Also check if there is a table called `slideshow` in the listed tables on the left-hand side.

This is what I see:

Attachment 107793

and on the left this:

Attachment 107794

EDIT: Sorry I browsed those vbthread and vbuser now, and I see the slideshow and slideshowid in the last colums. I just fail to see the slideshow/vbslideshow in the tables on the left.

[J98680Bxxxxx]

1. Click on vbthread
2. This will display the structure of the thread table.
3. Scroll down to the bottom and check if there is slideshowid
4. If there is none, click on SQL tab at the top and paste the table altering code in there
   

   ALTER TABLE `vbthread` ADD `slideshowid` INT( 10 ) UNSIGNED DEFAULT '0'

Do the same with vbuser.

1. Check if there is a vbslideshow on the left hand-side. If there is none, then do the following:
2. Click on your vbulletin database name (top, left hand-side). This will display the structure
3. Click on SQL tab and paste the followingtable creation code in there:
   

   CREATE TABLE IF NOT EXISTS`vbslideshow` (
   				    `slideshowid` INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
   				    `userid` INT(10) NOT NULL,
   				    `username` VARCHAR(50) NOT NULL,
   				    `dateline` INT(10) NOT NULL,
   				    `threadid` INT(10) NOT NULL,
   				    `description` mediumtext NOT NULL,
   				    `cover` varchar(250) NOT NULL,
   				    `title` varchar(250) NOT NULL);
   ALTER TABLE `vbslideshow` ADD INDEX ( `threadid` );

Basically, this must be done automatically at first installation of the mod.

[Taurus1]

OK, fantastic! Thank you so much!! Got that sorted. Now I get this on my homepage:

Attachment 107795

I suppose that is the slideshow (If I had any that would display!) But I have that ticked as "No" in the settings. Anything I can do about that??

[J98680Bxxxxx]

You have not created any slide show yet. Don't forget to upload the content of the upload folder to your main directory.

From your ACP -> vBulletin Options -> vBulletin Slide Shows Options
"Show in Forum Home" -> Click No.

Adjust the settings as you see fit.

Also thank you for pointing out the table creation failure issue. I have updated the XML, as there was an extra parenthesis in the code of the installation section.

[Taurus1]

I created one now, and it just displays 1 pic in there on the homepage. And also the setting is to "NO" in the Vbulletin Slide Shows Options.

Attachment 107800

But it still shows.

Also, why do I have this in Chinese?

Attachment 107799


EDIT: Man I hope you don't get annoyed with me!? I would really just like to get this working!!

I also found that if you click on the "Thread tools" drop down, the slideshow buttons overlaps the drop down like this:

Attachment 107801

[J98680Bxxxxx]

Originally Posted by Taurus1

I created one now, and it just displays 1 pic in there on the homepage. And also the setting is to "NO" in the Vbulletin Slide Shows Options.

Attachment 107800

But it still shows.

Also, why do I have this in Chinese?

Attachment 107799

If you have 1 slideshow created, it will only display that 1 slideshow, as it is displaying the cover of that slideshow. Clicking on it will take you to the thread containing the complete slideshow pictures. If you have more slideshows, it will randomly display 5 (covers) of those slideshows.

Ignore the Chinese image, you can click on the little cross to take it away permanently. I could not create an equivlent image. It says, <- for backward and for forward ->. You can remove that image (e_m_02.png) from the file uploaded, or create an equivalent one and share it with us.

Edit: vBulletin thread tool layer loads first, that's why it is displayed on the background and the slideshow layer on the foreground. It does not prevent to use/select those sub-menus of the thread-tools, at least on my side.

[Taurus1]

Fortunately I live in China! So I thought it had something to do with that! lol

The issue though is the fact that even with the setting to not display on the homepage, it still does. And also the overlapping issue. I put up a screenshot of that in my previous post.

Here you go! It's a bit small to get the text nicely.

Attachment 107802

[J98680Bxxxxx]

Originally Posted by Taurus1

Fortunately I live in China! So I thought it had something to do with that! lol

The issue though is the fact that even with the setting to not display on the homepage, it still does. And also the overlapping issue. I put up a screenshot of that in my previous post.

Here you go! It's a bit small to get the text nicely.

Attachment 107802

Correction made. The piece of code has been added in the new XML file (v.1.01). Just import it and allow overwrite.

Thank you for the feedback. :up:

Originally Posted by Taurus1

Fortunately I live in China! So I thought it had something to do with that! lol

...Here you go! It's a bit small to get the text nicely.

Attachment 107802

That's also a reason why I left it as is. Clicking on the small cross will keep it away permanently for the browser in use. Maybe one of the designer could create that small button for us, with english text?

[Taurus1]

Great stuff! All working now! Thanks for all your help and patience!

And you're welcome. It will definitely come in very handy on my forum. (Looks much better with the English button! lol)

[Taurus1]

OK, when I attempt to delete a slideshow I get this database error:

Database error in vBulletin 3.8.4:

Invalid SQL:
DELETE FROM `vbslideshow` WHERE `slideshow`.`slideshowid`='1' LIMIT 1;

MySQL Error : Unknown column 'slideshow.slideshowid' in 'where clause'
Error Number : 1054
Request Date : Monday, December 21st 2009 @ 12:42:30 AM
Error Date : Monday, December 21st 2009 @ 12:42:30 AM
Script : http://creativx.net/forums/slideshow...deshow&ss_id=1
Referrer : http://creativx.net/forums/slideshow...w&t=1529&u=621
IP Address :
Username : TheBull
Classname : vB_Database
MySQL Version : 5.0.85-community