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

[BadgerDog]

Just tried to install this on 4.1.3 ....

Received an SQL error during install ...

Seemed to go through first part of import and install process fine....

Importing Product, Please Wait...

[:]
Start Installing Active Raffle List Forum Block

Active Raffle List Forum Block Install Finished

... then it updated style information ...

Updating style information for each style

Light ... (Templates) (StyleVars) (Replacement Variables) (CSS) (Controls) Done.

Dark ... (Templates) (StyleVars) (Replacement Variables) (CSS) (Controls) Done.

Medium ... (Templates) (StyleVars) (Replacement Variables) (CSS) (Controls) Done.

... then it CRASHED .....

I put xxx's in some places for privacy ....

Sapporo, Yakutsk\";s:22:\"timezone_gmt_plus_0930\";s:28:\"( GMT +9:30) Adelaide, Darwin\";s:22:\"timezone_gmt_plus_1000\";s:49:\"(G MT +10:00) Eastern Australia, Guam, Vladivostok\";s:22:\"timezone_gmt_plus_1100\";s:52 :\"(GMT +11:00) Magadan, Solomon Islands, New Caledonia\";s:22:\"timezone_gmt_plus_1200\";s:50:\ "(GMT +12:00) Auckland, Wellington, Fiji, Kamchatka\";}' WHERE languageid = 1;

Database error in vBulletin 4.1.3:

Invalid SQL:
UPDATE language SET title = title, phrasegroup_cprofilefield = 'a:31:{s:25:\"eznl_we_send_forum_digest\"; Note: long set of field statements... carries on through several fields ... didn't bother to put them here ...

MySQL Error : Got a packet bigger than 'max_allowed_packet' bytes
Error Number : 1153
Request Date : Friday, June 3rd 2011 @ 11:39:33 AM
Error Date : Friday, June 3rd 2011 @ 11:39:58 AM
Script : http://www.xxxx.com/admincp/plugin.php?do=productimport
Referrer : http://www.xxxx.com/admincp/plugin.php?do=productadd
IP Address : xx.xx.xx.xxxx
Username : Badger
Classname : vB_Database
MySQL Version : 5.0.77

Any ideas what to do next, or how I can un-install this half baked install?

Thanks ...

Regards,
Doug

ps: It appears some pieces installed in spite of the SQL crash. (see pic). Is the blank field under Administrator Permissions yours and should it say "Can Admin Raffles"? Hope this stuff reported helps you troubleshoot the problem as we'd like to use this mod.

[ChromeDome]

Thanks.

Another question. Any tips on how to align my raffle image in the center?
http://www.chromebookuser.com/raffle...do=raffle&id=1

In IE and FF it shows up on the right. In Chrome and Safari it shows up on the left. Whenever I edit the default raffle css, the image then appears under the section that displays the raffle status.

[nhawk]

Originally Posted by BadgerDog

Sapporo, Yakutsk\";s:22:\"timezone_gmt_plus_0930\";s:28:\"( GMT +9:30) Adelaide, Darwin\";s:22:\"timezone_gmt_plus_1000\";s:49:\"(G MT +10:00) Eastern Australia, Guam, Vladivostok\";s:22:\"timezone_gmt_plus_1100\";s:52 :\"(GMT +11:00) Magadan, Solomon Islands, New Caledonia\";s:22:\"timezone_gmt_plus_1200\";s:50:\ "(GMT +12:00) Auckland, Wellington, Fiji, Kamchatka\";}' WHERE languageid = 1;

Database error in vBulletin 4.1.3:

The statements about timezone are not part of my mod. I don't know where that's coming from. It may be part of one of your templates and that's throwing the error.

Originally Posted by BadgerDog

"MySQL Error : Got a packet bigger than 'max_allowed_packet' bytes"

This error is a problem with your MySQL configuration. It's probably always been there, but it reared it's ugly head now.

See this for more info..

http://dev.mysql.com/doc/refman/5.0/...too-large.html

Originally Posted by BadgerDog

Any ideas what to do next, or how I can un-install this half baked install?

I'd go into the database with phpMyAdmin and delete the two raffle tables if they exist. But, I'd also be very careful about doing that. If you fix whatever the problem is with your template, you could just try installing again and it will just complete the install.

Originally Posted by BadgerDog

ps: It appears some pieces installed in spite of the SQL crash. (see pic). Is the blank field under Administrator Permissions yours and should it say "Can Admin Raffles"? Hope this stuff reported helps you troubleshoot the problem as we'd like to use this mod.

It could be, but I can't be sure without the label.

[ChromeDome]

NVM, I figured out a fix.

[nhawk]

Originally Posted by ChromeDome

Thanks.

Another question. Any tips on how to align my raffle image in the center?
http://www.chromebookuser.com/raffle...do=raffle&id=1

In IE and FF it shows up on the right. In Chrome and Safari it shows up on the left. Whenever I edit the default raffle css, the image then appears under the section that displays the raffle status.

I don't normally support customization of the templates. But try

display:block
clear:both

[ChromeDome]

Sorry... I figured out all of my problems, thanks. I was using HTML in the raffle description and it was causing some problems... * sighs *

[nhawk]

Originally Posted by ChromeDome

Sorry... I figured out all of my problems, thanks. I was using HTML in the raffle description and it was causing some problems... * sighs *

Gotcha

FYI, BB Codes will work in raffle descriptions.

[Harley D]

Originally Posted by ChromeDome

NVM, I figured out a fix.

Care to share that fix?

[BadgerDog]

Originally Posted by nhawk

This error is a problem with your MySQL configuration. It's probably always been there, but it reared it's ugly head now.

See this for more info..

http://dev.mysql.com/doc/refman/5.0/...too-large.html

Thanks ...

Increased the variable to 16Mb and the re-install went fine. :up:

Mod seems to be working fine but I haven't done any real testing. I'll report any anomalies to you ... appreciate the support ....

Regards,
Doug

[BadgerDog]

Are there any instructions anywhere to show how to define and setup the profile fields (type etc) for the address, phone number and PayPal data?

Thanks ..

Regards,
Doug