vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Show Thread Enhancements - Resolved Threads (https://vborg.vbsupport.ru/showthread.php?t=71415)

Guest190829 11-06-2004 08:06 PM

Great Job, Live Wire.

Logikos 11-06-2004 11:18 PM

Quote:

Originally Posted by danrak
I've run the query and did all the hacks. Now I'm getting
Database error in vBulletin 3.0.3:

Invalid SQL:
SELECT resolved
FROM thread
WHERE threadid = 21760

mysql error: Unknown column 'resolved' in 'field list'

mysql error number: 1054

Date: Saturday 06th of November 2004 01:17:59 PM
Script: http://www.techsupportforum.com/showthread.php?t=21760
Referer: http://www.techsupportforum.com/forumdisplay.php?f=98
Username: danrak
IP Address: 68.200.117.30


Sorry to be a pain. I think this would be a great addition to one of my sites.

You need to run this query and that will fix your problem. I forgot to add the sec query in the install, very sorry. Zip updated again.

[sql]
ALTER TABLE thread ADD (
resolved varchar(10) not null default '0'
)
[/sql]

Logikos 11-06-2004 11:19 PM

Quote:

Originally Posted by RasMasta
Can you change the word so it doesn't say "Resolved" but rather "SOLD" ?

Open resolved.php and find

PHP Code:

require_once('./global.php');

// change the text below that will appear in the title
// of thread default is [resolved] leave a space after
// the text to seperate the thead title with this text
$text '[resolved] '

Thats where your able to change the text.

danrak 11-07-2004 12:22 AM

Got it working now. Thanks. I'm sure this hack will get some use.

cdoyle 11-07-2004 09:12 PM

Hi,
I'm in the process of adding this hack, and got to the part where I'm suppose to enter this code into the showthread template.

<if condition="$firstpostinfo[userid] == $bbuserinfo[userid] OR $bbuserinfo[usergroupid] == 6">
$resolvedlink
</if>

It says to put it wherever I would like to see the link, I tried entering it once and I didn't noticed anything different on my forum. I've done everything else the instructions said to do.

So I'm thinking maybe I'm just entering this code in the wrong place,
where has everyone else been putting it?

Thanks
Chris.

freeshares1 11-08-2004 04:14 PM

cdoyle i am having the same problem :(

Logikos 11-08-2004 04:39 PM

The reason you guys are prolly not seeing anything is cause you need to turn it on, on the forum you want it on. Go to the admincp, and edit the forum you want it to show up on. Click yes to add resloved option, then you will see it there in the post of the forum you have it on.

freeshares1 11-08-2004 04:52 PM

PHP Code:

<a href="showthread.php?$session[sessionurl]t=$threadid&amp;goto=nextnewest">$vbphrase[next_thread]</a>
    <
strong>&raquo;</strong>
<if 
condition="$firstpostinfo[userid] == $bbuserinfo[userid]">
     
$resolvedlink
     
</if>
</
div

That is where i added it, And it works fine thanks "Live Wire"

Freeshares1 clicks install:)

On a side note is it possible for a user to un resolve it?

Logikos 11-08-2004 07:57 PM

I knew someone would ask that, but i don't know how to create a query that will edit the title and delete some text from it.

freeshares1 11-08-2004 08:21 PM

oh well, it still rocks. I have so many uses for this (i just need to work out a way of making it so that i can have a message per forum) as some are resolved some are sold.

Thanks again for such a great hack :)


All times are GMT. The time now is 08:56 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.01437 seconds
  • Memory Usage 1,743KB
  • 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
  • (3)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