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

Yes, just paste those instructions, one at a time.

Thank you! Ehhhh sorry...I get this error though.

An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table 'thebull_CreativX.thread' doesn't exist


EDIT: This is the database error I get,

Database error in vBulletin 3.8.4:

Invalid SQL:
SELECT cover, title, threadid FROM `vbslideshow` WHERE 1;

MySQL Error : Table 'thebull_CreativX.vbslideshow' doesn't exist
Error Number : 1146
Request Date : Sunday, December 20th 2009 @ 02:03:36 AM
Error Date : Sunday, December 20th 2009 @ 02:03:36 AM
Script : http://creativx.net/forums/
Referrer : http://creativx.net/forums/online.php
IP Address :
Username : TheBull
Classname : vB_Database
MySQL Version : 5.0.85-community

[J98680Bxxxxx]

Add your table prefix: vb
The instructions for your table should be:

ALTER TABLE `vbthread` ADD `slideshowid` INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL
ALTER TABLE `vbuser` ADD `slideshows` INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL

[Taurus1]

Yes, I made sure. These are the ones in the file:

product_slideshow.xml

slideshow.php

[Taurus1]

Originally Posted by J98680B2423E

Add your table prefix: vb
The instructions for your table should be:

ALTER TABLE `vbthread` ADD `slideshowid` INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL
ALTER TABLE `vbuser` ADD `slideshows` INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL

When I do that, I get this error:

An error occurred while attempting to execute your query. The following information was returned.
error number: 1060
error desc: Duplicate column name 'slideshowid'

[J98680Bxxxxx]

Let strt with the first message.

MySQL Error : Table 'thebull_CreativX.vbslideshow' doesn't exist
Error Number : 1146

Do you have the table `vbslideshow` created as it should?

If it was not automatically created by the mod, please execute the following (you can find it at the beginning of the product xml file, in the install code):

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)

[Taurus1]

Originally Posted by J98680B2423E

Let strt with the first message.

Do you have the table `vbslideshow` created as it should?

If it was not automatically created by the mod, please execute the following (you can find it at the beginning of the product xml file, in the install code):

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)

I am not sure whether it was created. It boggles my mind! I get a database error saying it doesn't exist, but when I do the query it states that it is a duplicate!!

So should I enter the above code into the XML and re-install?

Thanks for all your help!!:up:

[klaush]

Thanks for this, but it is yet not working properly.

Two issues; first the table "slideshow" is not created by using the plugin; the second issue is, that a deinstallation of the product does not delete one plugin, that would be left in the plugin area and that causes further mysql errors. So you have to delete that plug manually.

[J98680Bxxxxx]

Originally Posted by Taurus1

I am not sure whether it was created. It boggles my mind! I get a database error saying it doesn't exist, but when I do the query it states that it is a duplicate!!

So should I enter the above code into the XML and re-install?

Thanks for all your help!!:up:

The code is already in the XML file. On first installation, when importing the product, you should set the option "Allow Overwrite" to "No". The `slideshow` table should be created automatically. If you see that the table has not been created, for whatever reasons, just create it manually using the code above. It is for your particular database as I added already your table extension.

Originally Posted by klaush

Thanks for this, but it is yet not working properly.

Two issues; first the table "slideshow" is not created by using the plugin; the second issue is, that a deinstallation of the product does not delete one plugin, that would be left in the plugin area and that causes further mysql errors. So you have to delete that plug manually.

When deinstalling (removing/deleting), the product is designed to automatically deleted the tables that it creates. Check the "uninstallcode" specified in the XML. vBulletin also automatically remove all associated plugins defined in the "plugins" section of the XML.

[Taurus1]

I really appreciate your help, but I am a bit unsure on how to create the table manually. Can you please help me with how to do that.

Thank you.

[J98680Bxxxxx]

Originally Posted by Taurus1

I really appreciate your help, but I am a bit unsure on how to create the table manually. Can you please help me with how to do that.

Thank you.

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.