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

[mitch84]

hi, the sql data don't run, I can have them in a text file please? because when I click on link in "community" this database error appear,

Database error in vBulletin 4.1.3:

Invalid SQL:
SELECT * FROM raffle

ORDER BY id DESC;

MySQL Error : Table '413.raffle' doesn't exist
Error Number : 1146
Request Date : Sunday, May 1st 2011 @ 05:54:23 PM
Error Date : Sunday, May 1st 2011 @ 05:54:24 PM
Script : http://localhost/413/raffles.php
Referrer : http://localhost/413/forum.php
IP Address : 127.0.0.1
Username : mitch
Classname : vB_Database
MySQL Version : 5.5.9-log

but in acp mod work fine, what's wrong?
thx

[nhawk]

Originally Posted by Britmovie

http://www.britmovie.net/britforum/raffles.php

If you look on the above link you will see the is a text overlap....any way to fix this?:up:

Yes

1) Style Manager->Edit Templates->CSS Templates
Edit raffle.css

Change the value shown for width in this area to 90%:

.raffledata {
	float: {vb:stylevar left};
	clear: {vb:stylevar right};
	color: {vb:stylevar rafflebits_text_color};
	padding: 0;
	width: 100%;
}

[nhawk]

Originally Posted by mitch84

hi, the sql data don't run, I can have them in a text file please? because when I click on link in "community" this database error appear, but in acp mod work fine, what's wrong?
thx

There's no reason it shouldn't run on the main page (no matter where it's linked from) because both admincp and raffles use the same sql query with only one minor difference.

In both admincp and raffles if "Show Raffles Already Drawn" is set to 'Yes':

"SELECT * FROM " . TABLE_PREFIX . "raffle ORDER BY id DESC"

In raffles if "Show Raffles Already Drawn" is set to 'No':

"SELECT * FROM " . TABLE_PREFIX . "raffle WHERE enddate > $timenow ORDER BY id DESC"

[Britmovie]

Worked a treat many thanks.

[mitch84]

I checked in phpmyadmin and table raffle & raffle entries don't exist

[nhawk]

Originally Posted by mitch84

I checked in phpmyadmin and table raffle & raffle entries don't exist

Silly question..

Did you do this?

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

If not, that is when the tables are created.

[nhawk]

Originally Posted by Britmovie

Worked a treat many thanks.

There is one thing I noticed with your raffle...

If you aren't experimenting with the system, you have user entries set to 1 and a time limit of 7 days.

If you want your members to be able to enter every 7 days, increase the number of entries to the maximum total entries you want each member to have.

Either that of set the time limit to zero and your members will only be able to enter once.

It boils down to there's no need to set a time limit if the maximum entries allowed is set to 1.

(I also noticed something I need to fix for our friends outside of north america.. the date format is wrong on the raffle pages for you folks. I'll release a fix for that tomorrow.)

[NoCo7]

Nice plugin, good work!

[mikem164]

Installed, tested and works terrific, one thing though. When a user purchases a chance, nothing is traded, for example, cash, credit. Can you incorporate paypal into this so a user can buy a chance for $5 or whatever price the ticket is? Also, can you make the current raffles appear in the sidebar(forumbllock), and maybe current raffles at footer, just so users know there is actually a raffle going on when they see forumhome? Other then that, it's fundamentally perfect!

[biggeorge]

I've been running raffles for 5 years on my forum and have raffled at over $40,000 worth of products. I've been anxious to see a mod come out, but I would have liked to see some other features - most importantly, the ability for members to actually purchase tickets; perhaps setup with various payment processors. Is this possible? I would be willing to pay for this option. This is also mentioned by mikem164 in the above post.

And please, before anyone mentions it... I know my state laws pertaining to raffles and I know my merchant account rules pertaining to raffles. And I would strongly suggest the same for anyone planning to run raffles on their website.