Resolved Threads

[Logikos]

Resolved Threads

====================
Author: Ken 'LiveWire' Iovino
Site: www.initialz.com (http://www.initialz.com/)
Version: 1.0
====================

Updates

None at this moment


Add Ons
Close thread after thread is considered resloved. Click Here for this Addon (https://vborg.vbsupport.ru/showpost.php?p=571428&postcount=28) (Thanks to BeerMonster)

What this does
This will give thread starters the option to click a link to make a thread considered resolved. The way it works is simple. It will change the title of the post from 'I Need Help' to '[resloved] I Need Help'. This works as per forum basis and you can have this turned on/off on any forum you want. Only thread starters will see this option. If you want admins to see this option also, see This Thread Here (https://vborg.vbsupport.ru/showpost.php?p=569584&postcount=6)

If you would like to change the text, open 'resolved.php' look at line 35.

To do list...

Time to install: 3-5 minutes
Queries to run: 2
File Mods: 2

/admincp/forum.php
/showthread.php

Templates to edit: 1

SHOWTHREAD

Templates to add: 1
New Phrases: 2


Please read carefully and make all the necessary changes as stated. This is will work if installed properly.
PLEASE REMEMBER TO BACKUP BEFORE YOU BEGIN! If you like this hack

Click It
https://vborg.vbsupport.ru/ (https://vborg.vbsupport.ru/vborg_miscactions.php?do=installhack&threadid=71415)

Help & Support
Before asking for support Please make sure you have done all necessary changes! If you still need support please post a reply here.

Please post bugs and errors here. Hope you like, feedback welcomed.


https://vborg.vbsupport.ru/external/2004/12/1.gif (https://www.paypal.com/xclick/business=iovinojr%40msn.com&item_name=Initial+Z+Free+Scripts&no_note=1&tax=0&currency_code=USD)

[HiDeo]

Really nice job, thanks Live Wire

[Bozkurtum]

Nice hack. thanks ;)

[SnowBot]

Do admins see the option and change it?

[dethfire]

this will work great for one of my homework forums, anyone try it out, any problems?

[Logikos]

Do admins see the option and change it?
If you want admins to beable to see this option you just need to edit the SHOWTHREAD template and find:

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

And change to:

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

[danrak]

I went to install it but looking at the install file where it says to run this query all I see is this:

+---------------------+

+---------------------+

[Logikos]

Oppsiee, The query you want to run is

ALTER TABLE forum ADD (
isresolved smallint(3) not null default ''
)


Zip Updated.

[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.

[GamerJunk.net]

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

[Guest190829]

Great Job, Live Wire.

[Logikos]

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.


ALTER TABLE thread ADD (
resolved varchar(10) not null default '0'
)

[Logikos]

Can you change the word so it doesn't say "Resolved" but rather "SOLD" ?
Open resolved.php and find


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]

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

[cdoyle]

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]

cdoyle i am having the same problem :(

[Logikos]

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]

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

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]

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

[cdoyle]

duh, have to turn it on first.

that fixed it :)

Thanks
Chris.

[theArchitect]

i don't know how to create a query that will edit the title and delete some text from it.*theArchitect clicks install*.

Cool feature. And if I come across the query that will edit the title and delete some text from it I will post it here.

[Logikos]

Thanks alot guys for all your feedback and support.

[silentwille]

It's possible to add an option to solve/unsolve thread in the thread tools

[Logikos]

Read the few post above yours silentwille

[silentwille]

Ok, thanks.

I have make an icon for resolve thread. Do you like this ?

[Beermonster]

Nice hack, just a little addition to it if possible, could it also automatically close the thread?

[Beermonster]

Nice hack, just a little addition to it if possible, could it also automatically close the thread?

Hope you don't mind I've made this little addition, in the resolved.php

Find:


$DB_site->query("
UPDATE " . TABLE_PREFIX . "thread
SET resolved = '1'
WHERE threadid = " . intval($threadid) . "
");


Add under:


$DB_site->query("
UPDATE " . TABLE_PREFIX . "thread
SET open = '0'
WHERE threadid = " . intval($threadid) . "
");

[Logikos]

Thanks alot, i'll add that post to the first thread! :)

[dethfire]

how can I restrict this fuction for one forum?

[silentwille]

hi, Live Wire
If you use the same code of stick/unstick, it's possible to adapt for resolve/unresolve, no ?

Thx

[Logikos]

No cause stick/unstick doesn't edit the threads title in the database.

[theArchitect]

how can I restrict this fuction for one forum?
Go to your AdminCP and then click on Forums & Moderators. Then select the forum you want to use this feature with.

[Megareus Rex]

Ok, I have a question.

Where in SHOWTHREAD should I insert the code for it? I'd like some suggestions and stuff.

Also, how exactly does this work? In what form does the coding for SHOWTHREAD work?

[silentwille]

The code for resolve thread add anywhere

I have make an icon and i have add the code in the postbit/postbit_legacy

[Logikos]

Ok, I have a question.

Where in SHOWTHREAD should I insert the code for it? I'd like some suggestions and stuff.

Also, how exactly does this work? In what form does the coding for SHOWTHREAD work?
You put the code anywhere you want the link to appear.

[Fargo]

nice hack Live Wire --adding this to my development 'to do' list :)

[Dennis B]

Very nice. Installed. :)

[JohnBee]

*** PROBLEM FIXED [RESOLVED] :squareeyed:

my FTP client timed out and the "showthread.php" edits were not
completed.

Nice hack! I added the custom button and changed the [word]
to [Solved]

Thanks for a nice hack! good work



I installed it, however I see nothing...

Activated it from under the "Forum management" CP area.
I'm just not sure where the option should appear?

is it within the thread?
at the thread post level ex: POST NEW THREAD or what?

I would like this hack for my support section "very unseful"

[JohnBee]

One last question though.

How would I attached a button to the command?
I tried linking the $resolved to the button but that
didn't work :)

I included an image of what I would like it to look like bellow.
any help is appreciated

[ozmazdaclub]

Also can the title change be different on different forum sections? I have a sell section and a website suggestion section and would like to use sold on the sell section and actioned/completed on the website suggestion section. Is this possible?

[Dennis B]

Live Wire,

I installed it and it worked just fine in my tests, but a member just reported that all members that replied in the specific thread can also see the "resolved" link.

Any clues?
Thx

[Moncha]

Anyone have an idea of why I would be getting this message upon redirect?

"Could not find phrase 'resolved_thread'."

It displays in a regular looking redirect message with the link for when you don't want to wait any longer. I've checked all of my set up and went back through all but can't see where that would be coming from.

[dwh]

CAVEAT, I didn't study the code, just glanced at it.

Although I like the idea and if you called it the Resolved / Sold hack, former for tech support type forums and the latter for classified ad type forums, it would get an even bigger audience.

I probably won't install it though because it seems like overkill and too much overhead to add fields to forum and thread. Personally I think the hack would be better if it just changed the title without creating a flag (field) for resolved in the thread table.

As for specifying which forum it belongs in, I believe if you use conditionals, you can achieve the same effect by hard coding which forums you want it to operate in rather than adding isresolved to the forum table.

[j_86]

This hack is VB 3.05 compatiable.

[hotnuts21]

Is it possible to move the thread to a specific forum, after its resolved?

We have a resolved forum! However we have a resolved forum for each section, so it would be good to be able to point which forum topics are moved to which resolved forums.

Thnx

[The Realist]

Can someone give some help in getting this to work with 3.0.7, and how to add a link to the thread tools dropdown so only admins, mods and the thread starter.

Laters

[danrak]

Hmm... I don't get it. I added it, and so far only the thread starter and a certain usergroup can see it. But I never added that usergroup to see the link.

I used the exact code in the instructions:
<if condition="$firstpostinfo[userid] == $bbuserinfo[userid]">
$resolvedlink
</if>

But the usergroup #8 can still see the link.

[danrak]

Can someone give some help in getting this to work with 3.0.7, and how to add a link to the thread tools dropdown so only admins, mods and the thread starter.

Laters


add the following to where you want it. So if you want it under Add a Poll to this Thread search for that and add it under.

<if condition="$firstpostinfo[userid] == $bbuserinfo[userid] OR $bbuserinfo[usergroupid] == 6 OR $bbuserinfo[usergroupid] == 5 OR $bbuserinfo[usergroupid] == 7">
<tr>
<td class="vbmenu_option"><img class="inlineimg" src="$stylevar[imgdir_button]/sortasc.gif" alt="Resolved" /> <a href="resolved.php?do=resolved&threadid=$threadid">Problem Resolved</a></td>
</tr>
</if>

[The Realist]

When I click the resolve link (Im admin) I get the no permission screen?

Any ideas?

[The Realist]

Found it - Gota turn it on as its per forum in the options but........... when I do resolve the post I get this error:

Could not find phrase 'resolved_thread'.

Any ideas what it is?

[The Realist]

Im getting the same here M8

Anyone have an idea of why I would be getting this message upon redirect?

"Could not find phrase 'resolved_thread'."

It displays in a regular looking redirect message with the link for when you don't want to wait any longer. I've checked all of my set up and went back through all but can't see where that would be coming from.

[The Realist]

Does anyone know how to install this for 2 options.

I need 2 links..

One saying [SOLVED]
And one saying [DEAD]

So I need to put an extra link in the dropdown for the [DEAD] but how?

Anyone.

[lasto]

the realist does this work on vb3.0.7 if so will install it as was a good hack.

as for that `Could not find phrase 'resolved_thread'` could`nt u just make a new phrase to cover it ??

[The Realist]

It works fine on 3.0.7 as thats what Im using. I did add a phrase called resolved_thread but it still said "Could not find phrase"

Laters

[lasto]

ok cheers the realist

[JohnBee]

how can i get this to work in the posbit template

[JohnBee]

This hack seems a little problematic.
I installed and uninstalled it several times accross two forums and the same
problems occur.

1) the viewing permissions to toggle the resolved feature is passed down to
whoever answers the thread,
2) The phrases don't seem to come up.

Can anyone say if this hack works properly?

and if so what did you do to correct it.

[Kirk Y]

Mine worked fine. Although I made a little edit, I didn't use the $resolvelink variable, I simply took the URL used in the resolve_link template and put if conditionals around it and stuck the link in the Thread Options drop-down box. This way, I let Administrators be the only ones who can mark a Thread, resolved. Per you Permissions problem, did you enable the ability to Resolve threads? It's a Forum by Forum permissions system, meaning you need to go into the AdminCP and enable it through the Forums and Moderators section. As for the Phrases not showing up... are you sure you made them correctly and that they're in the Global group. See attached image for example.

Question: Is there anyway to do a link that says, "Un-resolve Thread"?

[yoyoyoyo]

I was reading the install info and noticed that the "showthread.php" template makes mention of a template that doesn't exist:

// eval('$resolvedlink = "' . fetch_template('resolved_nolink') . '";');and the install info makes no mention of creating a "resolved_nolink" template, unless I am misreading the code or the instructions.

[Alphawolf83]

*clicks install*

Nice hack :)

[danrak]

Any chance of getting this for vb3.5? Would be willing to donate for it.

[cdoyle]

was a 3.5 version ever developed?

We just upgraded, and this was one of the hacks we lost.

[Logikos]

I just moved to a new place and I'm waiting for the net to be turned on, but I think I can manage to do a 3.5 version for everyone :)

[Beermonster]

Could you port this to 3.5.x?

[Arie]

Has this been ported to 3.5x yet?

[BigMac1111]

Anyone have an idea of why I would be getting this message upon redirect?

"Could not find phrase 'resolved_thread'."

It displays in a regular looking redirect message with the link for when you don't want to wait any longer. I've checked all of my set up and went back through all but can't see where that would be coming from.

You have to add new Front-end Redirect Message

Varname: resolved_thread
Text: You have resolved this thread successfully

[JohnBee]

Can you please bring this awesome hack to 3.5
Our community loved this simple but amazingly useful mod on our forums.

I hope the coder considers it, if not perhaps someone else with his or her permission could look into converting it :)

[lasto]

hope it gets updated - was a good little hack

Come on livewire we know u can do it :)

[-=Sniper=-]

I have already made one (after hours of work, livewire could have done it in less than an hour, hehe) for my forums, maybe livewire can have a look and let me release it?

includes usergroup and forum settings :)

[JohnBee]

WOW! - if not, I would pay you for it privately!
is that legal?!?