Add-On Releases - vBulletin Raffles

THIS ADD-ON IS NO LONGER AVAILABLE AND IS NOT SUPPORTED

NOTE: This add-on is designed for use with vBulletin 4.1.1 or higher. It may not work with earlier versions of vBulletin.

Raffles, giveaways, and contests, whatever you wish to call them, are a great way to increase traffic on any forum.

Features:

• Define a different prize image for each raffle.
• Set raffle rules on a per raffle basis.
• Set raffles to start in the future or on the day you create the raffle.
• Allow One or more entries per user.
• Allow multiple entries at one time if desired.
• Admin settable time delay between user entries.
• One or more prizes per raffle.
• One or more winners per raffle (multiple winners require multiple prizes).
• Allow members to win multiple times in one raffle if desired.
• Display winning 'ticket' numbers if desired.
• Selectable usergroups
• Post count limit if desired.
• Require Human Verification if desired.
• Will show in Community Menu if desired.
• Show active raffles in forum sidebar and/or in what's going on.
• Automatic raffle draw via vBulletin scheduled tasks.
• Manual raffle draw to override end date and/or scheduled draws.
• Turn raffles on or off via admincp. (Only raffle admins can view raffles when they are turned off)
• Support for just about any credit system such as vBCredits II, ICash, kBank and vbBux.
• Support for AW Coding's Credit Purchase System so member can purchase "raffle tickets".
• XHTML 1.0 Transitional validated (provided your current template passes the tests)

* DISCLAIMER *
----------------
Laws about how raffles should be handled vary from location to location. Be sure to check with local authorities and to comply with any laws that may apply to you. The author of this add-on can not be held responsible if the use of this add-on results in any violation of local laws.
By downloading this add-on, you agree to abide by local laws and to hold the author of this add-on harmless for any damages that may occurr from the use of this add-on.



* INSTALLATION *
-----------------------
1) Upload the contents of the 'upload' folder to your forum's root.
(If your forum's location is http://www.example.com/forums/, the root is /forums/)

2) Import the product XML file (product-raffles.xml) into the Product Manager in AdminCP.

3) If you want to view raffles on your site while the raffle system is turned off, go to AdminCP -> Usergroups -> Administrator Permissions select yourself and set "Can Admin Raffles" to 'Yes'.

4) Anyone you want to be able to administer raffles on your site must also have Administrator Permissions and have "Can Admin Raffles" set to 'Yes' or they will not be able to administer raffles.

5) Take some time to set the options in Raffle Settings.

6) Set up a raffle.

7) Make sure this add-on is marked as 'Installed' on vBulletin.org!
(If you want to get notices from me about updates for this add-on.)

* UPGRADE INSTRUCTIONS *
------------------------------------
1) Upload the contents of the 'upload' folder to your forum's root.
(If your forum's location is http://www.example.com/forums/, the root is /forums/)

2) Import the product XML file (product-raffles.xml) into the Product Manager in AdminCP and be sure 'Allow Overwrite' is set to 'Yes'.

3) If you are already using vBCredits you will need to go into Raffle Settings and set 'Use vBCredits' to 'Yes' and set 'vBCredits Currency' to the currency you are using. If you are using any other credit system, you will need to provide the information on what table, field and userid field are used by that credit system.

* USING RAFFLES *
------------------------
The whole system is pretty self explanatory, but there are a few things to keep in mind...

1) A default raffle image is supplied with the add-on. You must always supply an image for your raffles. You may change the default image if you like.

2) The entry period for raffles always end at 12:00am (midnight) on the day the raffle is to be drawn. (ie: Draw date is set 12/21/2011.. members can enter through 12/20/2011, the moment the date changes to 12/21/2011 no more entries are possible)

3) The scheduled task to draw the raffles is set to take place at 10:00am the day the raffle is to be drawn. You may change this by going to AdminCP->Scheduled Tasks->Scheduled Task Manager, find "Draw raffles", click on Edit and change the time of the draw to what you want it to be.

4) There are replacement variables used in several phrases. These are what the variables are:

raffle_agree: {1} = Forum name
raffle_eligible: {1} = Forum name {2} = Raffle name
raffle_message_body: {1} = Raffle name {2} = Draw date
raffle_message_close: {1} = Raffle admin name {2} = Phrase (raffle_admin_title)
raffle_message_salute: {1} = Winner name
raffle_recent: {1} = Time remaining before a user can enter again
raffle_winner_multi: {1} = Winner names for multiple raffle winners {2} = Raffle name
raffle_winner_one: {1} = Winner name for single raffle winner {2} = Raffle name

5) When adding a custom user profile field for this add-on, be sure to 'Private Field' is set to 'Yes' and 'Field Searchable on Member List' is set to 'No'.

6) If you don't want to have Raffles in the community menu, you can use a forum link to raffles.php.


* History (Changelog) *
-----------------------------
1.4.6 (November 18, 2015)
- Fix - Missing code for sidebar block

1.4.5 (August 6, 2015)
- Fix - Error entering raffles with entry limit.

1.4.4 (August 29, 2013)
- Fix - XHTML 1.0 transitional validation errors in raffle sidebar box.

1.4.3 (March 15, 2013) (Never released on vB.org)
- Change - Moved hard coded day, hour, minute, second words to vB phrases.

1.4.2 (September 1, 2012) (Released February 18, 2013 on vb.org)
(NO NEED TO UPDATE IF YOU DON'T USE THE COMMUNITY MENU FOR RAFFLES)
- Fix - Community menu navigation information missing from install xml.

1.4.1 (August 15, 2012) (NO NEED TO UPLOAD FILES IF YOU ARE RUNNING 1.4.0 JUST IMPORT XML FILE)
- Fix - Raffle sideblock missing from install file (overlooked in version 1.4.0).

1.4.0 (August 13, 2012)
- Fix - Some servers not providing proper responses with direct MySQL calls. (usually nginx)

1.3.9 (June 28, 2012)
- Fix - Wrong phrase used for file upload error.
No need to import XML file if you are running version 1.3.8. Just upload files to server.

1.3.8 (June 27, 2012)
- Add - Ability to upload prize image from ACP.
NOTE: Depending on your server configuration, you may need to make your images/raffles folder writeable (776 or 777)
- Add - Option to prevent additional usergroups from entering a raffle.

1.3.7 (May 21, 2012)
- Add - Option to show old raffles on a different page than currrent raffles.
- Change - Removed raffle_bits template.
- Change - Made compatible with vB 4.2.0.

1.3.6 (March 12, 2012)
- Fix - Active raffle sideblock will no longer show if there are no active raffles.

1.3.5 (February 25, 2012) (Never released on vB.org)
- Code enhancement for expansion.

1.3.4 (December 28, 2011)
- Add - Mass delete raffle entries (you must select a raffle in ACP->Raffles->Manage User Entries. The selection 'All Raffles' will not display a delete all option).

1.3.3 (October 5, 2011) (No need to install xml file if upgrading from 1.32 to 1.33. Just upload files to server)
- Fix raffle ticket purchase link for AWCoding Credit Purchase System Pro.

1.3.2A (September 29, 2011)
- Re-uploaded 1.3.2 with correct cpnav_raffles.xml file.

1.3.2 (September 29, 2011)
- Fix detection of AWCoding Credit Purchase System Lite (problem caused when fixing Pro detection).

1.3.1 (September 28, 2011)
- Improved user entry list in AdminCP.
- Fix detection of AWCoding Credit Purchase System Pro.

1.3.0 (August 29, 2011) (Uploaded a second time with proper sideblock code)
- Code enhancement for future expansion.
- Enabled CSRF protection.

1.2.9 (August 24, 2011) (never uploaded here)
- Code enhancement for future expansion.
- Unregistered users can now see raffles in WGO and forum sidebar if they are allowed.
- Fix members no longer able to view and enter raffles scheduled in the future.

1.2.8 (August 1, 2011) (never uploaded here)
- Code enhancement for future expansion.

1.2.7 (August 1, 2011)
- Restored AWCPS patch to install script.
- Restored forum sidebar block to install script.
- Restored missing option to show image in sidebar block.

1.2.6 (July 20, 2011)
- Moved 'Allow Multiple Wins' from main settings to individual raffle settings. (user requested)

1.2.5 (July 16, 2011)
- Added Debug Logging option to raffle system. (v1.2.4 was never uploaded)

1.2.3 (July 15, 2011)
- MAJOR FIX - Fix raffle draw so no duplicates happen when allow multiple wins is set to no (finally found bug in 3.8.x version).

1.2.2 (July 11, 2011)
- Fix members can no longer enter multiple times by using the back button on their browser. (reported in vB 3.8.7 version)

1.2.1 (July 6, 2011)
- Fix Allow multiple wins to one member now works.
- Fix database error when no members enter raffle.
- Removed un-needed left joins in some DB queries that were needed in original release.

1.2.0 (July 4, 2011)
- Fix raffle draw time now displays in members's usercp chosen time zone format.

1.1.9 (July 3, 2011)
- Fix error in scheduled task when multiple prizes are awarded.
- Changed copyright so it only displays on raffle pages.

1.1.8 (June 17, 2011)
- Fix SQL error when 'Show Raffles Already Drawn' is set to 'No'.

1.1.7 (June 8, 2011)
- Added maximum picture width option for raffle detail page.

1.1.6 (June 6, 2011)
- Fix PMs not being sent with automated draw.
(NO NEED TO IMPORT XML IF YOU ARE ALREADY RUNNING VERSION 1.1.5 - JUST UPLOAD FILES)

1.1.5 (June 2, 2011)
- Fix vBCredits error created in version 1.1.1.
- Minor code change to make system compatible with PHP 5.3.x

1.1.4 (June 1, 2011)
- Database table creation change to make it compatible with MySQL 5.5.8
(NO NEED TO UPDATE IF YOU ARE ALREADY RUNNING VERSION 1.1.3)

1.1.3 (May 30, 2011)
- Added option to show raffle image in forum sidebar block.
- Added sidebar block image width setting.
- Added vBulletin minimum version 4.0.4 check.
- Changed database creation method.

1.1.2 (May 26, 2011)
- Fix system checking for credits when it shouldn't.

1.1.1 (May 26, 2011)
- Fix 'Other Credit System' saying not enough credits when member has enough.

1.1.0 (May 24, 2011)
- Added option to show the scheduled draw time on raffle pages.(user requested)

1.0.9 (May 21, 2011)
- Fix unregistered members unable to see raffles when they are allowed.

1.0.8 (May 16, 2011)
- Fix blank screen after entry.
- Fix redirect error.
- Fix default maximum entries.

1.0.7 (May 12, 2011)
- Added option to show who has entered raffles.(user requested)
- Reduced database queries by 1.
- Moved vBCredits log phrase to vBulletin phrases.
- Fixed bug where raffle sidebar was being displayed when raffles were turned off.

1.0.6 (May 10, 2011)
- Added the ability to allow multiple entries to be submitted at one time.(user requested)
- Added display of the number of entries a member has submitted to raffle detail page.(user requested)
- Added support for AW Coding's Credit Purchase System. (allows use of different payment systems to purchase 'tickets')
- Added transaction logging for vBCredits (thanks to Darkwaltz4 for info)
- Added minimum/maximum value checks.
- Added option to display winning "ticket" number(s) with winner name(s).(user requested)
- Added option to allow members to only win once per raffle.(user requested)
- Added PM to raffle admin if raffle couldn't be drawn when scheduled.
- Added ability to set a start date other than the day raffle was created.(user requested)
- Stray hardcoded phrase moved to vB phrases.
- Fixed bug where sent PMs were being saved in admin sent box when raffle was drawn manually even if option is set to no in settings.
- Fixed bug where only one winner was being displayed in admin area for a multi-prize raffle when raffle was drawn manually.

1.0.5 (May 4, 2011)
- Sidebar and Current Raffle templates now cached
- Fixed bug where entry limits over 999 only allowed 1 entry.
- Fixed missing phrases on new installs.
- Added support for vBCredits, ICash, kBank and vbBux. (user requested)

1.0.4 (May 3, 2011)
- Sidebar block now installs automatically when the add-on is installed.

1.0.3 (May 3, 2011)
- Added option to display current raffles in What's Going On (Displays what raffles are available for the member's usergroup). (user requested)
- Added Sidebar Block template and instructions in ReadMe on how to add a Current Raffle Block. (user requested)
- Added Banned Usergroup setting for usergroups forbidden to use or see the raffle system. (user requested via PM)
- Modified Raffle Admin so banned usergroups do not show up when creating or editing a raffle.

1.0.2 (May 2, 2011)
- Fixed "Enter Through" date display. (was not following vBulletin date display settings)
- Slight change to database routines so they all go directly through vBulletin.

1.0.1 (April 30, 2011)
- Added check to be sure files are uploaded to server (NO NEED TO DOWNLOAD IF YOU ALREADY HAVE 1.0.0 INSTALLED)

1.0.0 (April 30, 2011)
- Initial Release

* Known Working on vB Versions *
-------------------------------------------
4.0.4
4.0.6
4.0.7
4.0.8
4.1.1 through 4.2.1

[Mr Morningstarr]

Originally Posted by nhawk

Not difficult at all.

Edit the phrases in Phrase Manager.

Cheers. Lot of them though.

[Trek]

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]

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]

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

[nhawk]

Originally Posted by chriske

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!

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

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

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]

Originally Posted by RC-Central

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]

Originally Posted by nhawk

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

Originally Posted by nhawk

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

Originally Posted by nhawk

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]

Originally Posted by chriske

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

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]

Chriske.. check your PMs please.

[Trek]

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:

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