Closed Poll thread title

A user requested that if a poll is closed the thread be preceeded by Closed Poll: instead of just Poll:.

Here's a few lines of code that did it for us. (see attachment )

All you have to do is insert a few lines of code to forumdisplay.php.

Good luck, hope it helps.

History:

• 1.4
  Added closed poll functionality to search.php in showresult function.
• 1.3
  Added field to poll table lookup.
  Added condition to show poll closed when timeout has occured.
  Elimiated HTML tags for bold since the default vB prefixes are not bold.
• 1.2
  Removed HTML tag for font color.
• 1.1
  Added condition to show poll closed if thread or poll is closed.
• 1.0
  Initial release.

[Attrox]

Cool addition, small, yet very useful. *clicks install*

Nice idea.

[WEForums]

Yesterday at 11:46 PM Boofo said this in Post #18
Does it say Closed Poll: before you close the thread?

It only says "Closed Poll:" when the poll is closed via the moderator edit button. When closing the entire thread all that appears is "Poll:" like normal.

[noppid]

Yesterday at 08:35 PM WEForums said this in Post #22
It only says "Closed Poll:" when the poll is closed via the moderator edit button. When closing the entire thread all that appears is "Poll:" like normal.

A new version 1.1 is posted with a new condition to show the poll closed if the thread is closed.

Thanks for the feedback.

Regards

[noppid]

Yesterday at 07:06 PM Boofo said this in Post #20
Here is the link to my poll hack. Let me know if you think we can combine the two.

https://vborg.vbsupport.ru/attachmen...&postid=372862

I was toast last night and really couldn't see well enough to read your code. I'll look closer at it today.

[Boofo]

Today at 09:09 AM noppid said this in Post #24
I was toast last night and really couldn't see well enough to read your code. I'll look closer at it today.

No problem. Just when you get some time.

[noppid]

OK to this line you need to add the active column name.

PHP Code:

FROM:
  $polldatetime = $DB_site->query_first("SELECT dateline, timeout from poll where pollid = $thread[pollid];");

TO:
  $polldatetime = $DB_site->query_first("SELECT dateline, timeout,active from poll where pollid = $thread[pollid];"); 


That will enable you to do this conditional check and output or similar...

PHP Code:


if($polldatetime['active']==0 || $thread[open]==0) {
    $thread[typeprefix]="<b><font color=#567688>Closed Poll:</b></font> ";
}   
else
    $thread[typeprefix]=$pollthreadprefix; 


Hope that helps.

Regards

[Boofo]

I almost have it. I am working on a small problem. How do I go about get the total votes on a poll. I can pull them out but they look like this:

3|||2|||3|||2|||4|||

Like that. How do I get them into a total?

[noppid]

You can use a foreach loop with an explode statement .

PHP Code:

$totalvotes=0;
$myvotes = explode("|||",$votesstring);
foreach($myvotes as $v ) {
    $totalvotes = $totalvotes + $v;
} 


That should work though I didn't test it.


EDIT:
repaired code

[Boofo]

Just tried it. It gives me 0 as the total votes and there are 10.

[noppid]

Does $votesstring exist for you? If not did you substitute you var name that contains the ||| delimited string?