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).
   
   Code:

   ---

   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.

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:
has been replaced by
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.


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

demo link is need registeration i cant see >>>thank you

Demo link works not...

make my own slideshow and works fine ...

reg

macc

Can we get some screenshots? Sorry not to sound rude but some will not even try it without them and some of us simply don't want to register on yet another site to be honest.

[high]* TheLastSuperman tags for now...[/high]
Thanks regardless!

Mike

The product xml files and screenshots within vBulletin environment are available on the "vBulletin 3.7 Add-ons -> vBulletin Slide Show 1.0" thread .

Outside vBulletin environment, you can find a raw slide show example here, and a sample display of all slide shows here.

Can u create Test Login?

Thanks! This seems awesome. One thing though! Can you please help me on where to alter those tables. I get a database error regarding that. So I suppose I will have to make those edits.

Thanks!

Start your phpMyAdmin and execute those two queries respectively on the tables `thread` and `user`. You can also execute these queries from your ACP -> Maintenance -> Execute SQL Query.

Thank you very much! If you would permit me to just ask this last, probably dumb, question?

So when doing the query in my ACP, do I just enter this:

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

and run it?

and then the next one?

I appreciate your help!!

:) 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

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

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

product_slideshow.xml

slideshow.php

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'

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):

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:

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.

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.

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.

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.

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.

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
   
   Code:

   ---

   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:
   
   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);
ALTER TABLE `vbslideshow` ADD INDEX ( `threadid` );

   ---

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

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??

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.

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

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. :)

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:

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?

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)

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

Thank you for the feedback. It has been implemented.

Update in v.1.02

The following piece of code in the XML and PHP files:
has been replaced by
as it affects databases with prefixed tables.

I will test it now. Thanks! I just want to ask something else here! If my members enter, well, let's say 10 wallpapers to the slideshow. If other members want to download the wallpaper, how do they do that from within the slideshow?

EDIT: Also, is there a way to change the white background?

At the current state, there is no option to download from within the slideshow. I will add that option to a forecoming version. :up:

The background color is defined in the css style sheets associated with the mod. In a forecoming version, I will add an inline style option to overwrite it and allow a user defined background color. :up:

Thank you! I can confirm that the delete slideshow is now working properly. I hope to see those added features soon! :p Those are really very important to me, and I guess others too.

How about an option to enable a slide show at the top of the forum index page?

That'd be awesome! :D

There is already an option included for displaying, above the forums on the index page, a small slideshow window containing as pictures 5 randomly selected covers from existing slideshows.

If you mean something else, please be specific. :)

Installed and working well.

How/where do I change/remove the text ".A total of 16 pictures. Current set, picture." at the top of the slide show?

Thanks!

O.k., we got it working! Once again thanks for this fine mod!

One question, is it possible to get this to work with the vb albums?

You can change/empty the content of the phrases variables x_eTitle and xy_eTitle :)