vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Add-On Releases - vBulletin Raffles (https://vborg.vbsupport.ru/showthread.php?t=262901)

Mr Morningstarr 07-03-2011 01:47 PM

Quote:

Originally Posted by nhawk (Post 2216195)
Not difficult at all.

Edit the phrases in Phrase Manager.

Cheers. Lot of them though. :D

Trek 07-04-2011 05:47 PM

First, thank you nHawk for helping me out and looking into things. =)

Now, a few suggestions.
  • Post Winners to Thread, option. - This would simply reply to an existing thread with a custom message as defined by the admin. Post things like the raffle, draw date, prize and winners.
  • Time to wait to send out winning PMs/Manual notification. Sometimes, I'd like to verify things before the winners are announced. This would accomplish that.
  • Redraw option - Posts to the above mentioned winners thread that we've had an issue and will be performing a redraw. Have the option to simply redraw as is, or invalidate the current raffle and open a new raffle window with the old raffle window values prefilled into the form to make it easier.
  • When clicking Manage User Entries in the ACP, have a dropdown that has "All" and then each raffle name in it so we can only view the entrants for that raffle. After awhile, this screen is going to get really messy and require a lot of hunting around.
  • Display how many entrants there are option - On the main raffle screen that the users see, display how many people have entered the raffle. (Not necessarily who has entered like it is now)
  • If an image is included in the forum block, auto center it.
  • Move "Allow One Member Multiple Wins" to per raffle instead of a global setting.
  • Add in the ability to draw each raffle at a specific time. I know that would require the cron running more often, but even if it's close, say it only checks every hour, I think that'd be good.

I know that's a lot of stuff and some of it isn't probably all that quick/easy to do, I'm just asking for you to consider these options in any future release you do. Thanks again, the mod is awesome and I think some of these changes would just make it even better if you have the time/desire to do it. =)

chriske 07-04-2011 10:23 PM

Thanks for the update Nhawk,

I just updated to 1.2.0 And the raffle now draws when I run the scheduled task.
There is only one problem:

I have set the option "Allow One Member Multiple Wins" to No. But still there is 1 user that won all 3 prizes :S Now the raffle of last month has to be redrawn...
Is there a way to solve this?

RC-Central 07-05-2011 01:09 AM

I am curious how you set the colors like the last screenshot??

nhawk 07-05-2011 11:07 AM

Quote:

Originally Posted by chriske (Post 2216761)
Thanks for the update Nhawk,

I just updated to 1.2.0 And the raffle now draws when I run the scheduled task.
There is only one problem:

I have set the option "Allow One Member Multiple Wins" to No. But still there is 1 user that won all 3 prizes :S Now the raffle of last month has to be redrawn...
Is there a way to solve this?

You folks are driving me nuts! :D

I am unable to duplicate this on any test or live server I have access to. :(

If you don't have enough unique entries to draw the raffle this is what is logged in the scheduled task log..
Quote:

28 Draw raffles 07:28, 5th Jul 2011 Start drawing raffles
29 Draw raffles 07:28, 5th Jul 2011 Raffle Test Date 5 Not Drawn - 2 members 3 prizes
30 Draw raffles 07:28, 5th Jul 2011 Finished Drawing Raffles
If I draw a raffle by either letting the task run on it's own or manually run it, it draws the proper number of winners even if there are only 3 members that have entered (as shown a couple posts back, but with 3 members.. 1 with 20 entries). And this is what is logged in the scheduled task log..
Quote:

41 Draw raffles 08:04, 5th Jul 2011 Start drawing raffles
42 Draw raffles 08:04, 5th Jul 2011 Draw raffle Test Date 5 - winner MY$T3R!OUZ
43 Draw raffles 08:04, 5th Jul 2011 Draw raffle Test Date 5 - winner Snog
44 Draw raffles 08:04, 5th Jul 2011 Draw raffle Test Date 5 - winner imauser
45 Draw raffles 08:04, 5th Jul 2011 Finished Drawing Raffles
Could I get more information please?

vBulletin version
PHP version
MYSQL version
Any other information you feel might be relevant

thanks!

EDIT: OK, now I'm really confused!

After installing the Raffle system on a fresh server with the latest versions of PHP and MYSQL and being unable to duplicate the problem described by you folks, I did a line by line check of the code for the Scheduled Task Raffle Draw.

What I found was just the opposite of what you describe as happening. No matter if 'Allow One Member Multiple Wins' was set to 'Yes' or 'No', and multiple prizes were to be awarded, it would not allow multiple wins to one member!

I suggest you double check that /includes/cron/raffledraw.php has been overwritten with the most current version. It might be possible that you either didn't upload all of the files at some point, or it somehow never got overwritten. Also, if your server is running any kind of PHP caching, try clearing the cache.

I will issue an update that WILL 'Allow One Member Multiple Wins' in the next day or two.

nhawk 07-05-2011 11:08 AM

Quote:

Originally Posted by RC-Central (Post 2216819)
I am curious how you set the colors like the last screenshot??

If you mean this image..

https://vborg.vbsupport.ru/attachmen...5&d=1304177740

That is the skin on the site that was running that raffle.

If you mean the entry list a few posts back, that's the default ACP skin.

chriske 07-05-2011 04:35 PM

Quote:

Originally Posted by nhawk (Post 2216983)
Could I get more information please?

vBulletin version
PHP version
MYSQL version
Any other information you feel might be relevant

thanks!

Vbulletin: 4.1.4
PHP: 5.2.x
mysql: 5.1.24


Quote:

Originally Posted by nhawk (Post 2216983)
EDIT: OK, now I'm really confused!

After installing the Raffle system on a fresh server with the latest versions of PHP and MYSQL and being unable to duplicate the problem described by you folks, I did a line by line check of the code for the Scheduled Task Raffle Draw.

What I found was just the opposite of what you describe as happening. No matter if 'Allow One Member Multiple Wins' was set to 'Yes' or 'No', and multiple prizes were to be awarded, it would not allow multiple wins to one member!

I wish that was the case with my raffle :)

I just made an other test raffle:

- 5 prizes
- Maximum Entries Permitted 1
- Number of contestants: 7

Winners: 1 x (Ticket #70) 4 x (Ticket #74)??

Quote:

Originally Posted by nhawk (Post 2216983)
I suggest you double check that /includes/cron/raffledraw.php has been overwritten with the most current version. It might be possible that you either didn't upload all of the files at some point, or it somehow never got overwritten. Also, if your server is running any kind of PHP caching, try clearing the cache.

I am sure the raffledraw.php was overwritten. I see that in the files I downloaded from the 1.2.0 version of raffledraw.php it says (vBulletin Raffles 1.1.9)

nhawk 07-05-2011 04:53 PM

Quote:

Originally Posted by chriske (Post 2217082)
I just made an other test raffle:

- 5 prizes
- Maximum Entries Permitted 1
- Number of contestants: 7

Winners: 1 x (Ticket #70) 4 x (Ticket #74)??

I am sure the raffledraw.php was overwritten. I see that in the files I downloaded from the 1.2.0 version of raffledraw.php it says (vBulletin Raffles 1.1.9)

The version shown in raffledraw.php would be correct because that was the last version where it was changed.

I just duplicated the raffle you described with 5 prizes and 7 entries and here's what the scheduled task produced..

Quote:

42 Draw raffles 13:48, 5th Jul 2011 Start drawing raffles
43 Draw raffles 13:48, 5th Jul 2011 Draw raffle Test Raffle 2 - winner Member3 (Ticket #26)
44 Draw raffles 13:48, 5th Jul 2011 Draw raffle Test Raffle 2 - winner Snog (Ticket #23)
45 Draw raffles 13:48, 5th Jul 2011 Draw raffle Test Raffle 2 - winner Member6 (Ticket #29)
46 Draw raffles 13:48, 5th Jul 2011 Draw raffle Test Raffle 2 - winner Member2 (Ticket #25)
47 Draw raffles 13:48, 5th Jul 2011 Draw raffle Test Raffle 2 - winner Member5 (Ticket #28)
48 Draw raffles 13:48, 5th Jul 2011 Finished Drawing Raffles

nhawk 07-05-2011 05:06 PM

Chriske.. check your PMs please.

Trek 07-06-2011 03:57 PM

Just found the following in my email, looks like some PHP code made it into the SQL query. This happened during the CRON job.

Invalid SQL:
UPDATE dhv_raffle
SET winner = fetch_phrase('raffle_noentries','global')
WHERE id = '2';

MySQL Error : Cannot load from mysql.proc. The table is probably corrupted
Error Number : 1548

To fix, replace line 78 of /includes/cron/raffledraw.php with:

Code:

                                                                SET winner = '".fetch_phrase('raffle_noentries','global')."'


All times are GMT. The time now is 03:23 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.01553 seconds
  • Memory Usage 1,762KB
  • 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
  • (10)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (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