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)
-   -   Show Thread Enhancements - Threads Description (https://vborg.vbsupport.ru/showthread.php?t=200259)

kkeezer 02-02-2009 05:59 PM

Works great, TY!

Kyle

fly 02-03-2009 01:00 AM

EEK!

I recently upgraded to 3.8 and simply overwrote this hack with the 3.6 version. Now I have thread descriptions duplicated. What have I done?

edit: Fixed that. I just had to remove my TMS template edits from the 3.6 version. However, I now have this error when trying to enable thread descriptions for a forum.
Code:

Invalid SQL:
UPDATE forum SET
        title_clean = 'Useless Chatter',
        title = 'Useless Chatter',
        description_clean = 'the intarweb den of sin',
        description = 'the intarweb den of sin',
        link = '',
        displayorder = 1,
        parentid = 3,
        daysprune = -1,
        defaultsortfield = 'lastpost',
        defaultsortorder = 'desc',
        showprivate = 0,
        newpostemail = '',
        newthreademail = '',
        ### Bitfield: forum.options ###
                options = IF(options & 8, options - 8, options),
                options = IF(options & 16, options - 16, options),
                options = IF(options & 32, options - 32, options),
                options = IF(options & 32768, options - 32768, options),
                options = IF(options & 8192, options - 8192, options),
                options = IF(options & 4, options, options + 4),
                options = IF(options & 1, options, options + 1),
                options = IF(options & 2, options, options + 2),
                options = IF(options & 16384, options, options + 16384),
                options = IF(options & 256, options - 256, options),
                options = IF(options & 64, options, options + 64),
                options = IF(options & 128, options, options + 128),
                options = IF(options & 512, options, options + 512),
                options = IF(options & 1024, options, options + 1024),
                options = IF(options & 2048, options, options + 2048),
                options = IF(options & 4096, options, options + 4096),
                options = IF(options & 65536, options, options + 65536),
                options = IF(options & 131072, options - 131072, options),
        styleid = 0,
        imageprefix = '',
        password = '',
        requireicon = 1,
        accessf_nb = 0,
        accesst_nb = 0,
        create_nb = 0,
        reply_nb = 0,
        attach_nb = 0,
        linkview_nb = 0,
        linkpost_nb = 5,
        vbbux_perview = 1,
        vbbux_perthread = 1,
        vbbux_perpost = 1,
        ### Bitfield: forum.vbplaza_forum_options ###
                vbplaza_forum_options = IF(vbplaza_forum_options & 16, vbplaza_forum_options - 16, vbplaza_forum_options),
                vbplaza_forum_options = IF(vbplaza_forum_options & 32, vbplaza_forum_options - 32, vbplaza_forum_options),
                vbplaza_forum_options = IF(vbplaza_forum_options & 64, vbplaza_forum_options - 64, vbplaza_forum_options),
                vbplaza_forum_options = IF(vbplaza_forum_options & 128, vbplaza_forum_options - 128, vbplaza_forum_options),
                vbplaza_forum_options = IF(vbplaza_forum_options & 256, vbplaza_forum_options - 256, vbplaza_forum_options),
                vbplaza_forum_options = IF(vbplaza_forum_options & 512, vbplaza_forum_options - 512, vbplaza_forum_options),
                vbplaza_forum_options = IF(vbplaza_forum_options & 1024, vbplaza_forum_options, vbplaza_forum_options + 1024),
                vbplaza_forum_options = IF(vbplaza_forum_options & 2048, vbplaza_forum_options, vbplaza_forum_options + 2048),
                vbplaza_forum_options = IF(vbplaza_forum_options & 4096, vbplaza_forum_options, vbplaza_forum_options + 4096),
                vbplaza_forum_options = IF(vbplaza_forum_options & 8192, vbplaza_forum_options, vbplaza_forum_options + 8192),
                vbplaza_forum_options = IF(vbplaza_forum_options & 16384, vbplaza_forum_options, vbplaza_forum_options + 16384),
                vbplaza_forum_options = IF(vbplaza_forum_options & 32768, vbplaza_forum_options, vbplaza_forum_options + 32768),
                vbplaza_forum_options = IF(vbplaza_forum_options & 65536, vbplaza_forum_options, vbplaza_forum_options + 65536),
                vbplaza_forum_options = IF(vbplaza_forum_options & 131072, vbplaza_forum_options, vbplaza_forum_options + 131072),
                vbplaza_forum_options = IF(vbplaza_forum_options & 262144, vbplaza_forum_options, vbplaza_forum_options + 262144),
                vbplaza_forum_options = IF(vbplaza_forum_options & 524288, vbplaza_forum_options, vbplaza_forum_options + 524288),
                vbplaza_forum_options = IF(vbplaza_forum_options & 1048576, vbplaza_forum_options - 1048576, vbplaza_forum_options),
                vbplaza_forum_options = IF(vbplaza_forum_options & 2097152, vbplaza_forum_options - 2097152, vbplaza_forum_options),
                vbplaza_forum_options = IF(vbplaza_forum_options & 4194304, vbplaza_forum_options - 4194304, vbplaza_forum_options),
                vbplaza_forum_options = IF(vbplaza_forum_options & 8388608, vbplaza_forum_options - 8388608, vbplaza_forum_options),
                vbplaza_forum_options = IF(vbplaza_forum_options & 16777216, vbplaza_forum_options - 16777216, vbplaza_forum_options),
                vbplaza_forum_options = IF(vbplaza_forum_options & 1, vbplaza_forum_options - 1, vbplaza_forum_options),
                vbplaza_forum_options = IF(vbplaza_forum_options & 2, vbplaza_forum_options - 2, vbplaza_forum_options),
                vbplaza_forum_options = IF(vbplaza_forum_options & 4, vbplaza_forum_options - 4, vbplaza_forum_options),
                vbplaza_forum_options = IF(vbplaza_forum_options & 8, vbplaza_forum_options - 8, vbplaza_forum_options),
        vbplaza_cangetaccesscost = 0,
        vbplaza_cangiveaccesscost = 0,
        vbplaza_candenyaccesscost = 0,
        vbplaza_cangetpasswordcost = 0,
        descriptiondefault = '1'
WHERE forumid = 4;

MySQL Error  : Unknown column 'descriptiondefault' in 'field list'


TrucLinh 02-03-2009 02:15 AM

Note: If you can use your db utilities you only add this column 'descriptiondefault' into your forum db

BE SURE TO PERFORM A BACKUP OF YOUR DATABASE BEFORE PROCEEDING.
Please run the following query to add it:
Quote:

ALTER TABLE `forum` ADD `descriptiondefault` SMALLINT(6) NOT NULL DEFAULT '1';
Or ---------------------------------

. Uninstall this mod
. Install news, all way works!

Q.Nhu

fly 02-03-2009 09:25 AM

The SQL query did it. Thanks!

Mihalis 02-04-2009 06:50 AM

I don't see the description field when i try a new thread. But i do see the description field when i edit a thread. Any ideas? Thanx.

Rashdan 02-04-2009 10:15 AM

THANK's

more beautiful

Mihalis 02-05-2009 08:52 AM

I am wondering if everybosy else is getting a description field when you create a new topic and i dont. Am i not getting something right?:confused:

rjnsmith 02-05-2009 04:32 PM

Quote:

Originally Posted by Mihalis (Post 1734981)
I am wondering if everybosy else is getting a description field when you create a new topic and i dont. Am i not getting something right?:confused:

I am seeing the same problem.

dai-kun 02-05-2009 10:27 PM

I am seeing the same problem also.

Aadil 02-06-2009 10:00 AM

mine dont update when i edit it :(


All times are GMT. The time now is 05:44 AM.

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.01248 seconds
  • Memory Usage 1,757KB
  • 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
  • (1)bbcode_code_printable
  • (2)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