vb.org Archive - TOTW: Thread of the Week Poll

Page 3 of 5

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)

- - TOTW: Thread of the Week Poll - Version 1.16 (https://vborg.vbsupport.ru/showthread.php?t=74737)

Romeos Tune

02-27-2005 02:34 PM

Yep, that was the problem...... I'm sorry for the confusion....... Thankyou! :)

deb0	03-01-2005 09:54 PM

I have this hack installed, and it appears to be partially working:

the poll starts as schedule, but Isn't a new poll supposed to begin every week or x days?

What does it do to the last poll results? I don't see it anywhere.

Also, I don't see an option for UCash integration.

Marco van Herwaarden

03-02-2005 03:46 PM

Quote:

Originally Posted by deb0

Quote:

Originally Posted by MarcoH64

@all who have problems.
What version are you running?
If you have problems, please post the version you're running, the settings for schedule you're using, the settings for the weights, and how often the cronjob is run.

uCash You should find in the new Thread of teh Week option group in your vB settings.

MikaK

03-03-2005 07:57 AM

I would like to run a poll every Friday GMT 10 pm or so. How should I set the timer and the cron?

Thanks for any ideas,
-Mika

Marco van Herwaarden

03-03-2005 06:41 PM

- Create the Cronjob to run every day around 10PM.
- Set the schedule to run every 1 week.
- Make sure you create the rule (or set to active) the first time on a friday.

PS I might add a "Run every day X of the week" schedule type in the next release.

MikaK

03-04-2005 01:59 AM

Quote:

Originally Posted by MarcoH64

Thanks Marco.

-Mika

deb0	03-04-2005 11:01 AM

Quote:

Originally Posted by MarcoH64

uCash You should find in the new Thread of teh Week option group in your vB settings.

Ok, I got that part now. But I still don't see full functionality:

Ok, people vote, and I see that clearly, but at the end of the week, where does it post results of which thread won?

All cron and weight settings are set to default.
I'm running VB306

Marco van Herwaarden

03-04-2005 11:12 AM

When it is time to rune the Rule again according to the schedule, it will close the current poll, post the results (and give away the uCash points if set) and create a new Poll.

MikaK

03-06-2005 08:35 AM

Any idea why trying to run the cron via ACDP scheduled tasks by pressing "run now!" gives this sql error:

Database error in vBulletin 3.0.3:

Invalid SQL: UPDATE scll
SET =+0 WHERE userid=11
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '=+0 WHERE userid=11' at line 2

mysql error number: 1064

Date: Sunday 06th of March 2005 02:17:50 AM
Script: http://www.soundchilds.net/loud_lounge/admincp/cronadmin.php?do=runcron&cronid=24
Referer: http://www.soundchilds.net/loud_lounge/admincp/index.php?

Username: MikaK
IP Address: nono

Thanks for any ideas,
-Mika

Marco van Herwaarden

03-06-2005 08:54 AM

Please tell me which version you're running, also php and MySQL versions.

scll is your uCash points table? Do you have uCash installed? How is the uCash integration set in the vB settings for Thread of the Week?

MikaK

03-06-2005 10:59 AM

Quote:

Originally Posted by MarcoH64

scll is the data table prefix in my vBulletin database.

I have ToW 1.13 installed on vB 3.0.3. I tried to install ucash but rolled back to a previous backup since I had trouble with it.

uCash setting in your script for this poll are the default ones: first three fields as 0 and the fourth empty.

PHP version 4.3.10

MySQL version 4.0.23-standard.

Regs,

-Mika

Marco van Herwaarden

03-06-2005 12:01 PM

ACP->vBulletin Settings-->Thread of the Week-->uCah integration: No

That should solve your problem.

MikaK

03-06-2005 12:13 PM

Quote:

Originally Posted by MarcoH64

ACP->vBulletin Settings-->Thread of the Week-->uCah integration: No

That should solve your problem.

Thanks Marco,

The message changed shape a tad: Warning: Invalid argument supplied for foreach() in /home/soundchi/public_html/loud_lounge/includes/cron/threadoftheweek.php on line 358

my file looks from row 358 like:

PHP Code:


		
			
foreach ($svotes AS $key=>$values)
{
if ($count != 0)
{
--$count;
++$position;
continue 1;
}
if ($values['votes'] == 0)     // No more winners
break;
 
++$position;
$winners[$position] = $values['polloption'];
 
// More sharing the same number of votes?
$count = 0;
while (++$count)
{
if ($svotes[$key + $count]['votes'] == $values['votes'])
{
    $winners[$position] .= "," . $svotes[$key + $count]['polloption'];
}
else
{
    --$count;
    break 1;
}
 
}
}

How critical is this? The cron was executed ok and the poll apeaed at the wanted forum.

Regs,
-Mika

jzewatsky

03-10-2005 01:06 AM

What a great hack! I'm sure my thread count will increase by installing this. Thank you!

Side note.

Does anyone know how to give ucash for responding to polls?

Thanks again!!!!!

Lionel

03-11-2005 02:35 PM

Hi,

I was wondering if the thread title could be automated to say "thread of the week for week of xxx to xxx" ?

This way, while being specific, it will change the monotomy of title.

Marco van Herwaarden

03-11-2005 03:47 PM

Quote:

Originally Posted by Lionel

Hi,

I was wondering if the thread title could be automated to say "thread of the week for week of xxx to xxx" ?

This way, while being specific, it will change the monotomy of title.

Hmm sounds like a good suggestion, will try to implement in a next version.

Lionel

03-11-2005 04:20 PM

Quote:

Originally Posted by MarcoH64

Hmm sounds like a good suggestion, will try to implement in a next version.

Thanks for considering it. Real nice hack! Couldn't that be achieved now by doing something like:

Best thread for week ending $lastrundate (something to that extent using that parameter)

Marco van Herwaarden

03-11-2005 05:51 PM

Well that parameter is not implemented, only start weeknumber and i think start date if i remember correct.

Kru	03-15-2005 03:55 AM

I am getting the following error message, too: Warning: Invalid argument supplied for foreach() in /includes/cron/threadoftheweek.php on line 358 if I run it in the Scheduled Task Manager. I am using vBulletin. 3.0.7

Marco van Herwaarden

03-15-2005 05:53 AM

Edit your includes/cron/threadoftheweek.php.

Find:

PHP Code:


		
			
if ($pollid)

Add above:

PHP Code:


		
			
        $svotes = array();

Please report back if this is solving anything.

1 Question, did the current poll maybe never get any votes?

Kru	03-15-2005 02:07 PM

Quote:

Originally Posted by MarcoH64

Edit your includes/cron/threadoftheweek.php.

Find:

PHP Code:


		
			
if ($pollid)

Add above:

PHP Code:


		
			
        $svotes = array();

Please report back if this is solving anything.

1 Question, did the current poll maybe never get any votes?

Made the change but still same error message.

I installed the hack last week. Told it that the poll should happen every 1 week.

Because I wanted to start with the poll directly after I installed the hack I run it in the Scheduled Task Manager but nothing happened. It still said poll never run.

Because I was busy with other stuff I didn't check any longer at it but then on saturday the poll started automatically but instead to show 3 poll options it just showed 2. I thought I made something wrong and deleted the thread. I reset date last run and reset previous polled threads.

Again I tried to run it in the Scheduled Task Manager but this time I got the error message mentioned above.

Marco van Herwaarden

03-15-2005 02:17 PM

Quote:

Originally Posted by Kru

Thank you very much for this description. Think i finally got an old bug out now. The reason for the error is that the cron job is trying to close a thread that don't exist anymore (you deleted it).

I will post an update in an hour.

Marco van Herwaarden

03-15-2005 03:14 PM

Quote:

Originally Posted by Kru

Updated version posted. Just upload all files, no upgrade scripts to be run.

Marco van Herwaarden

03-15-2005 03:15 PM

About only selecting 2 options, maybe there where not enough posts to select from based on the criteria.

Please test again, if your problems continue send me a PM and we will look at it.

Kru	03-16-2005 04:34 AM

Quote:

Originally Posted by MarcoH64

About only selecting 2 options, maybe there where not enough posts to select from based on the criteria.

Please test again, if your problems continue send me a PM and we will look at it.

The error message is gone. Thank you. :)

But if I run the Scheduled Task Manager manually nothing is happening. Well it says DONE but in the Thread of the Weeks option it says that the poll is never run and it doesn't make any new poll at the forum. :(

SnowBot

03-19-2005 02:59 AM

is their a way to uninstall this?

Lionel

03-19-2005 07:20 AM

I have none of the problems described in this thread. The second poll ran itself as scheduled in cron while closing the first one.

2 minor details:

1-The closed thread says below are the winners and is empty
2-on forumdisplay.php the "Last Post" by has no username.

I keep on manually adjusting the thread title to say Week Ending {today} instead of the plain Thread of the Week Poll.

Marco van Herwaarden

03-19-2005 02:38 PM

@lionel

Thanks, i will look inti that second issue. Can you PM me the config for the winners post, so i can look at your first problem.

@snowbot
Run the installer again, choose to uninstall and follow instructions. If you added the Manager to your ACP menu, you will have to manually remove that edit. The scheduled task also needs to be removed manually.

Lionel

03-19-2005 07:19 PM

Quote:

Originally Posted by Lionel

OK, I did not realize that there were more options about variables in the question mark help to be included with #1

fiber1

04-05-2005 12:35 AM

Here is the biggest problem with this hack. One cannot exclude certain forums not to choose from for the Thread of the week. Besides this it would be a great hack!

Marco van Herwaarden

04-05-2005 03:50 AM

Quote:

Originally Posted by fiber1

Here is the biggest problem with this hack. One cannot exclude certain forums not to choose from for the Thread of the week. Besides this it would be a great hack!

I don't understand what you mean. You can select the forums from which the threads are selected.

Marco van Herwaarden

04-07-2005 07:13 PM

Small update, see change log.

@lionel
I have not forgotten your request, but i am a bit short on time atm. It will come as soon as i got a bit more time.

Lionel

04-08-2005 02:41 AM

Marco, there is a small typo in upgrade_queries.php, the last line

Quote:

selectdays smallint(6) unsigned NOT NULL default 0,

sould be

Quote:

selectdays smallint(6) unsigned NOT NULL default \'0\'

Marco van Herwaarden

04-08-2005 04:02 AM

Quote:

Originally Posted by Lionel

Marco, there is a small typo in upgrade_queries.php, the last line sould be

Did you get an error on that? What MySQL version are you using?

Shouldn't get an error it is a numerical row, so no quotes needed. Oops i see it now, a comma on the end, will update in a few minutes.

Edit: Updated.

Lionel

04-08-2005 04:07 AM

I followed your advice and upgraded to the latest.

I did get an error and fixed as per above.

Quote:

Invalid SQL: ALTER TABLE threadofweekrules ADD COLUMN (
selectdays smallint(6) unsigned NOT NULL default 0,
) ;
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 3

mysql error number: 1064

Marco van Herwaarden

04-08-2005 06:20 AM

Quote:

Originally Posted by Lionel

I followed your advice and upgraded to the latest.

I did get an error and fixed as per above.

Yes this error was because of the trailing comma. Is removed and zip file updated.

fiber1

04-08-2005 09:27 PM

Quote:

Originally Posted by MarcoH64

I don't understand what you mean. You can select the forums from which the threads are selected.

This is what I am refering too, unless I am missing something here?

Thread Selection Options:

Select forums to analyze for selecting threads.

You can only highlight the ones that are ordered together.

For example:

Forums named:

My forum1

My forum2

My forum3

My forum4

My forum5

I only wanted to use forum1, forum2, and forum5 there is no way just to select those particualr ones.

You can only select the ones that are all order together.

Hope you understand what I mean?

jzewatsky

04-09-2005 12:21 AM

Try pressing the Control key while useing your mouse to select the thread (ctrl + Left mouse). You should then be able to select (highlight) any thread you wish. To unselect, use the control+left mouse again to un highlight. Hope I'm understanding what your asking and that the above helps.

fiber1

04-09-2005 12:35 AM

Thanks I guess that works... Sorry never seen that approach yet! :D

jzewatsky

04-09-2005 12:48 AM

Sorry, in my post above replace "thread" with "forum"

thread = forum

Sorry if there was any confusion.

All times are GMT. The time now is 05:12 PM.

Page 3 of 5

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01609 seconds Memory Usage 1,859KB 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 (5)bbcode_php_printable (20)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 (40)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
Messages: