Add-On Releases - Jujubins Lottery

Coder(s): jujubins (Nando)

Compatibility: 3.6.x, 3.7.x, 3.8.x

Product Info:
Files to upload - 2
Files to import - 1
Templates - 8
Plugins - 2
Phrases - 33

Languages:
English
Portuguese

Purpose: Drawn awards for your forum users or if you want, just to one usergroup.

How it works: The users whom have permission to participate, those who have more than "x" posts, registered before "y" and members of "z" group, can take one ticket for day, until the day you set your scheduled tasks of your forum to close the lottery and drawn. As soon as drawn, there will be a congratulation message to the winner and disseminating him.


Demo: http://forum.glords.com/lottery.php

Installing:

1. Upload the files in the forum folder to your vBulletin root.
2. Import the product_jlottery.xml via Product Manager system.

Upgrading:

1. Upload the files in the forum folder to your vBulletin root.
2. Import the product_jlottery.xml via Product Manager system.

Setting:
Go to Admin CP > vBulletin Options > Jujubins Lottery and type in the fields:

• Enable: Set this option to yes to enable Jujubins Lottery.
• Topic: Topic ID with details of the lottery.
• Members Allowed: This option prevent new users to participate in the lottery. Only users before the date chosen could participate. Use Unix time.
• Posts Required: Number of posts required to participate.
• Usergroups Allowed: Usergroups allowed to participate. Separate with comma the usergroups.
• Round tickets:Example:
  14 tickets will appear 20 tickets.
  34 tickets will appear 40 tickets.
• Moderators: Now you can choose the moderator's group to reset in the lottery's page
• Post the winner? Automatically post the winner in thread.
• Poster userid: The userid that will post the congratulations.
• Post message: Post message.
  Variables: {winner}, {ticket}, {hour} and {date}

To change the date of the lottery go to Admin CP> Scheduled Taks> Scheduled Task Manager> Jujubins Lottery and modify the fields of the Day of month, Hour and Minute.


Requirements:
PHP 4.3.3 and MySQL 4.0.16 or later.

History:
v0.5.0 - Dec 29. 2008
First Release
v0.7.0 - Dec 31. 2008

Added Phrases
Added option to reset when repeated the scheduled task

v0.7.1 - Jan 01. 2009
Correction in the variables of phrases
Correction in pharses
Added language in Portuguese
v0.8.0 - Jan 10. 2009
Added option to choose which usergroups can participate
Compatible with version 3.8.0
v1.0.0 - Jan 11. 2009

Added auto-link in the quick links, pop-up of community and navbar

Added option of types of drawn, "per day", "per drawn", "without limits"
v1.1.0 - Jan 12. 2009
Fixed: SQL table prefix
v1.2.0 - Jan 12. 2009
Added "see all" tickets link
Added option to enable link to see all tickets
v1.2.5 - Feb 1. 2009
Fixed: Show winners
v1.2.6 - Feb 6. 2009
Fixed: Winner link (member.php)
v1.2.6 - Feb 6. 2009
Fixed: Winner link (member.php)
v2.0.0 - Out 27. 2009
Re-writted the mod's intire code
Simplified code
SQL with fewer fields
2 new settings: Round tickets and moderators
Now you reset in lottery's page
Fixed: All known bugs
v2.1.0 - Out 29. 2009
Added: Automatic congratulations post in the thread (editable) (thanks paul41598)
Fixed: Some insignificant bugs
v2.1.1 - Out 30. 2009
Fixed: Posts limit (thanks pipibunny)
v2.1.3 - Out 30. 2009
Fixed: Usergroups colors in "See all" (thanks kalisekj)
Fixed: Links in menu (thanks kalisekj)
Fixed: Reset link to moderators (thanks kalisekj)
Fixed: Update version 2.0.0 to above will not reset your lottery (thanks kalisekj)

Quick support in english/portuguese: http://forum.glords.com/showthread.php?t=8927

Mark as Installed
Nominate for MOTM

Originally Posted by jujubins

I apologize to everybody who have donwloaded and waited for the Jujubins Lottery's updates. Today, I've re-writted the mod's intire code, making it simplier and with an easy lecture. I've tested it and no bug was found, I ask for help for everyone of you to make it better.
I promise that, starting from today, I'll be giving support about the mod.

The version 2.0.0 have been lauched, and it's in the topic.

Please help my keep supporting the project by donating in Paypal

[jujubins]

Originally Posted by kalisekj

Although Ticket # is still not showing to the left of usernames that have a ticket. Unless Tickets Column is supposed to be Ticket Number and not Number of tickets the user has, for in case a person enabled Multiple tickets allowed per user in a month.

You're saying about "Your status?
To switch the side of the columns you need to edit the template jlottery_alltickets and jlottery_alltickets_bit.

Originally Posted by NTMID8

I have a formatting issue with the footer as seen in the attached screen shot. The time stamp is not wrapping correctly. Though this phrase is part of the footer template, it only has this issue on the lottery.php page, so I'm sure it is formatting with this mod. I've looked, but don't seem to see the issue.

This problem occurs in your skin. You need to adjust the mods templates according to your skin.

[NTMID8]

Originally Posted by jujubins

This problem occurs in your skin. You need to adjust the mods templates according to your skin.

The templates are setup the same as all of my other pages. Unless there is something in lottery.php throwing it off, I can't figure it out. I would have assumed it would be in lottery_SHELL template, but it is fine. I can't seem to get this formatting error fixed.

[kalisekj]

Ok Just an FYI My First Lottery completed yesterday and I have Thread ID and Posters ID set and no Post Was created in the thread. Although it does say to see the post on the winner check here and lists the thread for the Lottery.

[MagicThemeParks]

Definitely watching this one

What does the thread that is automatically started supposed to say or display?

[kalisekj]

Magic,
You create a thread giving your rules to the contest, then you place the thread id of your thread within the JUJUBins Lottery ACP options. In There you also Have Winner Post Msgs which you can modify to your liking.

[Jhonnydc]

I have some problems...

1 - If I set One ticket for a day....I take a ticket, but the system answer like photo...





2 - I have set all details but the system not post in the select 3ead the post's winner.





The forum section for this try is locked to register member...is this the problem?
because the poster userd ID is of the staff member... allowed for that forum section.

[Jhonnydc]

News?

[Welshy2008]

Originally Posted by JTS2005

anyway to incorporate paypal system so that we can charge per # of tickets bought? I think this would be a great idea for those that need a way to sell lottery tickets.

Is it possible for you to do the above mention quote, please?

What is the latest on this Please?

Just read through 6 pages. (Will install as soon as it is fixed).

[isatice]

so what's the award ?

[kaderith]

The lottery script is sort of working, when I run the drawing it will pick a winner and display the winner but..

At the same time I'm getting an SQL error as follows:

MySQL Error : Unknown column 'lastedit' in 'field list'
Error Number : 1054
Request Date : Wednesday, December 2nd 2009 @ 06:44:47 PM
Error Date : Wednesday, December 2nd 2009 @ 06:44:47 PM
Script : http://www.thegatheringroom.org/foru...cron&cronid=45
Referrer : http://www.thegatheringroom.org/foru....php?do=modify
IP Address : 68.0.17.55
Username : admin
Classname : vB_Database
MySQL Version : 5.0.81-community-log