vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)
-   -   Add-On Releases - vBulletin Slide Show 1.10 (https://vborg.vbsupport.ru/showthread.php?t=230536)

Taurus1 12-20-2009 10:39 AM

1 Attachment(s)
Quote:

Originally Posted by J98680B2423E (Post 1933963)
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 12-20-2009 11:00 AM

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

Taurus1 12-20-2009 11:14 AM

1 Attachment(s)
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 12-20-2009 11:25 AM

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 12-20-2009 11:35 AM

1 Attachment(s)
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 12-20-2009 11:54 AM

Quote:

Originally Posted by Taurus1 (Post 1933993)
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 12-20-2009 11:57 AM

1 Attachment(s)
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 12-20-2009 12:24 PM

Quote:

Originally Posted by Taurus1 (Post 1934010)
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:

Quote:

Originally Posted by Taurus1 (Post 1934010)
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 12-20-2009 12:34 PM

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 12-21-2009 04:46 AM

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


All times are GMT. The time now is 10:40 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01286 seconds
  • Memory Usage 1,756KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code_printable
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete