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)

nhawk 07-14-2011 08:22 PM

Quote:

Originally Posted by clutchthese (Post 2220612)
oops... that was a type on my part. But i fixed the type and now the block breaks the forum. :(

Database error in vBulletin 4.1.4:

Invalid SQL:
SELECT country FROM geo_blocks
WHERE begin_num <= '212508165' AND end_num >= '212508165';

MySQL Error : Table 'gameru5_gamerumors.geo_blocks' doesn't exist
Error Number : 1146
Request Date : Thursday, July 14th 2011 @ 05:20:04 PM
Error Date : Thursday, July 14th 2011 @ 05:20:05 PM
Script : http://www.gamerumors.net/forums/forum.php?styleid=5
Referrer : http://www.gamerumors.net/forums/forum.php?styleid=3
IP Address : 12.170.158.5
Username : ClutchThese
Classname : vB_Database
MySQL Version : 5.0.91-community-log

LOL, use the code that shown above now.

I edited it after posting the incorrect code.

The code I posted the first time is for a private version of Raffles. Sorry.

clutchthese 07-14-2011 08:24 PM

PERFECT!!! That time it worked! Thank you VERY much!

nhawk 07-15-2011 07:16 PM

MAJOR BUG finally found and fixed. I suggest EVERYONE update to v1.2.3.

Oh how I hate when the problem was staring me in the face all this time, but I couldn't see the forest through the trees. :(

chriske 07-16-2011 01:51 AM

Just installed v1.2.3. uploaded all files, imported plugin (with overwrite).
Made a new raffle with 5 prizes (multiple wins is set to no). Only 1 ticket per member, 5 members took part in the raffle.

This means everyone should win 1 prize but (Ticket #103) still won 3 prizes.

I am curious who did or did not encounter the same problem when creating the same raffle (with the latest version of this mod). I run VB 4.1.4.

Thanks for the update though, I am sorry to ruin your celebration lol.

nhawk 07-16-2011 10:31 AM

Quote:

Originally Posted by chriske (Post 2221051)
Just installed v1.2.3. uploaded all files, imported plugin (with overwrite).
Made a new raffle with 5 prizes (multiple wins is set to no). Only 1 ticket per member, 5 members took part in the raffle.

This means everyone should win 1 prize but (Ticket #103) still won 3 prizes.

I am curious who did or did not encounter the same problem when creating the same raffle (with the latest version of this mod). I run VB 4.1.4.

Thanks for the update though, I am sorry to ruin your celebration lol.

The only thing I can think of now is the files aren't getting overwritten on your server. Or, you're running PHP caching software and the cache needs to be cleared. Or, when you ticked the 'No' selection you didn't save the settings.

In reality, the draw scheduled task would go into an infinite loop if it couldn't find a different winner. That's why the unique entry count check is in the routine.

As a matter of fact I just ran a 10 prize/10 entry raffle on my site and not one duplicate happened. You'll need to register to see the results... http://www.snogssite.com/showthread....Raffle-Winners

You could try one more thing, that's download version 1.2.4 which is on my server now. However, it really doesn't change the core operation of the raffle system and that's why it's not uploaded here, but hey.. you've got a problem that needs to be solved.

nhawk 07-16-2011 04:41 PM

For those still having trouble with multiple wins, please download and install v1.2.5 and then enable debug mode in raffle settings.

This will put a detailed log of the actions taken by the raffle draw scheduled task into the scheduled task log.

When you have a problem, upload a copy or screenshot of the full log for the problem draw.

chriske 07-16-2011 09:59 PM

Just made a new raffle, 7 prizes and 7 different winners :D
Dont know what did the trick, the debug setting was on.
I will perform some more tests to make sure everything is all right.

Thanks!

nhawk 07-17-2011 11:41 AM

Once you're certain all is working the way it should, turn off debug. Otherwise your scheduled task log will grow substantially in size.

nhawk 07-20-2011 06:31 PM

Quote:

Originally Posted by Trek (Post 2216683)
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.

Post to new thread is available as an add-on on my site.

Quote:

Originally Posted by Trek (Post 2216683)
  • Move "Allow One Member Multiple Wins" to per raffle instead of a global setting.

Done in version 1.2.6.

Quote:

Originally Posted by Trek (Post 2216683)
  • 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.

Draw at specific time is available as an add-on on my site.

nhawk 07-20-2011 06:36 PM

Quote:

Originally Posted by ChromeDome (Post 2208294)
Nhawk, I'd be interested in hearing what will be in the "pro" version of the script. It's a great script!

Thanks MTP! ;)

Chrome...

I've decided to take a different approach.

From this point forward anything other than fixes or core program changes will be in the form of an add-on to the raffle system.

That way people can pick and choose what they want to add into the system.


All times are GMT. The time now is 09:56 AM.

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.01462 seconds
  • Memory Usage 1,746KB
  • 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
  • (6)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