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

[jimsflies]

Originally Posted by 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.

Same issue here...no post was created after drawing complete.

Also would it be possible to modify the script to allow multiple drawings concurrently...for different user groups?

[Yehoshua Sofer]

Since the task scheduler does not seem to have a month option does that mean we can only set the lottery to run within the month and not span say two months? If anyone can help I would greatly appreciate it. Thanks

Yehoshua

[Yehoshua Sofer]

Last month I ran the lottery on my forum and it worked perfectly. Now I am trying again but I get the error message below


Warning: Cannot use a scalar value as an array in [path]/lottery.php on line 86

Anyone know what I am doing wrong?

[Yehoshua Sofer]

It appears no one is supporting this mod. I guess I will uninstall it. Does anyone know of a similar mod.

[kaderith]

Any news on whether or not this mod will be updated for compatibility with vB 4.x?

It's a huge favorite with the members of my board.. I really want to to upgrade to use vB 4.x but if I was to do so and loose the drawings we run every month I think our members might mutiny ...

[bgg]

Originally Posted by kaderith

Any news on whether or not this mod will be updated for compatibility with vB 4.x?

It's a huge favorite with the members of my board.. I really want to to upgrade to use vB 4.x but if I was to do so and loose the drawings we run every month I think our members might mutiny ...

I also would be interested in it's migration... I may be forced to attempt it myself but I'm not exprienced with VB mods yet... Is updating it just a matter of remapping fields and finding new templates and all that... or is it more complicated then that?

I'd be willing to pay someone... I need a mod to allow my to give away a board game once a month to active/subscribing/purchsining members...

James

[bada_bing]

I am getting an error when my lottery cron job runs, does anyone know how to fix this

Warning: array_fill() [function.array-fill]: Number of elements must be positive in [path]\includes\cron\lottery.php on line 17

Warning: array_rand() [function.array-rand]: First argument has to be an array in [path]\includes\cron\lottery.php on line 18
Winner created.

Done

[clubcivic.com]

I just installed this on my 3.8.5 board and had these issues as well. I posted how I fixed them below if you didn't figure it out yet.

Originally Posted by 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

On line 31 and 32 of includes/cron/lottery.php replace the $create = $vbulletin->db->query_write("INSERT INTO .... ");

with

$create = $vbulletin->db->query_write("INSERT INTO `".TABLE_PREFIX."post` (`postid`, `threadid`, `parentid`, `username`, `userid`, `title`, `dateline`, `pagetext`, `allowsmilie`, `showsignature`, `ipaddress`, `iconid`, `visible`, `attach`, `infraction`, `reportthreadid`)
VALUES (NULL, '".$vbulletin->options['jlottery_topic']."', '".$thread['firstpostid']."', '".$user['username']."', '".$vbulletin->options['jlottery_userid']."', '', '".$time."', '".$congratulationpost."', '1', '0', '127.0.0.1', '0', '1', '0', '0', '0')");

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.

In the 'jlottery_SHELL' template.

before:
$footer

add:
<div style="clear:both;"></div>

[fevredsuk]

would be brilliant edition to vb4 this, says hes going to update it, but nothing yet

[WEBDosser]

interesting