vb.org Archive
Page 4 of 18 « First 23 4 5614 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Miscellaneous Hacks - Featured Threads (https://vborg.vbsupport.ru/showthread.php?t=320387)

thenicehorizon 10-08-2015 06:00 PM
thank you but i got this database error:

PHP Code:
Database error in vBulletin 4.2.1:

Invalid SQL:

    SELECT thread.*
    FROM thread AS thread
    INNER JOIN featuredthreads AS featuredthreads
    ON thread.threadid = featuredthreads.threadid
        ORDER BY featuredthreads.thread_order ASC, featuredthreads.dateline ASC;

MySQL Error   : Unknown column 'featuredthreads.dateline' in 'order clause'
Error Number  : 1054
Request Date  : Thursday, October 8th 2015 @ 09:57:32 PM
Error Date    : Thursday, October 8th 2015 @ 09:57:32 PM
Script        : http://www.tomohna.net/vb/featurepage.php
Referrer      : 
IP Address    : 41.100.204.198
Username      : tomohna.com
Classname     : vB_Database
MySQL Version : 5.5.45-cll-lve 

MarkFL 10-08-2015 06:17 PM
Quote:
Originally Posted by thenicehorizon (Post 2556601)
thank you but i got this database error:

PHP Code:
Database error in vBulletin 4.2.1:

Invalid SQL:

    SELECT thread.*
    FROM thread AS thread
    INNER JOIN featuredthreads AS featuredthreads
    ON thread.threadid = featuredthreads.threadid
        ORDER BY featuredthreads.thread_order ASC, featuredthreads.dateline ASC;

MySQL Error   : Unknown column 'featuredthreads.dateline' in 'order clause'
Error Number  : 1054
Request Date  : Thursday, October 8th 2015 @ 09:57:32 PM
Error Date    : Thursday, October 8th 2015 @ 09:57:32 PM
Script        : http://www.tomohna.net/vb/featurepage.php
Referrer      : 
IP Address    : 41.100.204.198
Username      : tomohna.com
Classname     : vB_Database
MySQL Version : 5.5.45-cll-lve 
I am not finding how that query is generated by my product. The "featuredthreads" table does not have that column, and it is not referenced in any location that I find.

edit: I spoke too soon...I found the problem, and have fixed it in the following update:

Version 1.3:
  • Database error fixed when using sorting options for the featured threads from the settings.

smirkley 10-12-2015 04:42 PM
Mark. Love the product.

Hey, I made a couple mistakes and want to uninstall everything, and start fresh with a clean install.

But I cannot get rid of reminant templates the product installed originally.

MarkFL 10-12-2015 05:26 PM
Quote:
Originally Posted by smirkley (Post 2556883)
Mark. Love the product.

Hey, I made a couple mistakes and want to uninstall everything, and start fresh with a clean install.

But I cannot get rid of reminant templates the product installed originally.
The templates should have been removed when you uninstalled, unless you edited them. In that case they will have to be reverted twice (once to restore to original, and then once to remove) I think to remove them.

Elixar 10-14-2015 05:03 PM
Marked as installed.

MarkFL 10-17-2015 02:55 PM
Update Version 1.5:
  • Fixed minor CSS issues.
  • Extra thread information is now displayed in the supplemental lists.
  • Added the option to use "Most Replied" threads as candidates for the "Featured Threads" list.

MarkFL 10-23-2015 03:11 PM
Update Version 1.6:
  • Fixed typo on settings page.
  • Tooltip for thread authors in "Most Replied" list shows correct thread creation date/time.

InSite 11-05-2015 09:10 AM
Hi Mark,

I installed this and you've done a really nice job so far, thank you so much! I have a few suggestions for a future release if you are interested. Here is my installation so that you can see where I'm at with it: http://www.cyrus-gaming.com/forums/featurepage.php

1. Some things are hardcoded into the PhP files, such as the alternating column colour and the display order of the columns. This isn't so great for websites with a dark background or if you want to change the order of the columns. Maybe these options could be changed to variables in the admin settings?

2. The integration with the new icons on the forums are excellent! But the static page itself comes out as quite underwhelming. Maybe it would be a nice addition to allow a brief description of each thread, so it's not just a list with no context? An image option would also be very nice. It would be great to really make this a page that stands on its own and encourages people to check out the best threads / most important news items on a forum.

3. Do you happen to know whether it would be possible to make this a page on vBA CMPS (vBulletin Advanced)?

Great work again, and thanks so much!

Edit to add: This is my homepage: http://www.cyrus-gaming.com. My idea for the standalone page would be to have a similar layout, but with much shorter (new) descriptions of each article, and a small image. This would allow the page to hold around 15 - 20 articles on it.

MarkFL 11-06-2015 05:21 PM
Update: Version 1.7:
  • Added setting for background color of product elements.
  • Added setting for alternate row background color.
  • Added setting for whether users can nominate their own threads.
  • Added setting for minimum post count requirement for users allowed to nominate threads.

MarkFL 11-07-2015 03:39 PM
Update: Version 1.8:
  • Added setting that allows the "Most Replied" list to either be by the number of replies or by the number of posters.


All times are GMT. The time now is 08:58 AM.
Page 4 of 18 « First 23 4 5614 Last »
Show 40 post(s) from this thread on one page

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.01418 seconds
  • Memory Usage 1,758KB
  • 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_php_printable
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (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