Jujubins Lottery

[jujubins]

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:
Upload the files in the forum folder to your vBulletin root.
Import the product_jlottery.xml via Product Manager system.Upgrading:
Upload the files in the forum folder to your vBulletin root.
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 (https://vborg.vbsupport.ru/vborg_miscactions.php?do=installhack&threadid=201437)
Nominate for MOTM (https://vborg.vbsupport.ru/vborg_miscactions.php?do=nominate&threadid=201437&type=1)


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 (https://www.paypal.com/cgi-bin/webscr?cmd=_donations&business=hermes_e_renato%40hotmail%2ecom&lc=BR&item_name=Jujubins&currency_code=USD&bn=PP%2dDonationsBF%3abtn_donateCC_LG%2egif%3aNonH osted)
https://vborg.vbsupport.ru/external/2010/07/4.gif

:)

[GlamRockTalk]

Demo has no permission for visitors.

Also, can you share in English?

[jujubins]

The default language is English.

Added screenshot in English.

[cafenetland]

Você não tem permissão para participar.

yeah i got that ??

do i have to register to see ur demo ?

[adhmwagde]

great but i have problem in SQL


Invalid SQL:
SELECT * FROM `jlottery` WHERE `userid` = 1 AND `winner` = '1';

MySQL Error : Table '3omda.jlottery' doesn't exist
Error Number : 1146
Request Date : Monday, January 12th 2009 @ 02:01:20 PM
Error Date : Monday, January 12th 2009 @ 02:01:20 PM
Script : http://localhost/vb/lottery.php
Referrer : http://localhost/vb/index.php

[adhmwagde]

Not Supported !!!

[RedeemedWarrior]

15 minutes between your two posts? and you declare it unsupported?

[R-D]

Oh man, that's funny. I doubt even a paid modification would manage 15 minute support.

Looks like he just forgot to use the tableprefix when initially installing (and also uninstalling) the database table. A simple edit should fix it.

Note: It's probably best to uninstall before you make this change, then re-install the product again, otherwise the old db table probably won't be removed.

Open the product and find:
<codes>
<code version="1.0.0">
<installcode><![CDATA[$db->reporterror = false;
$db->query("CREATE TABLE `jlottery` (
`ticket` int(8) NOT NULL AUTO_INCREMENT,
`userid` varchar(500) NOT NULL,
`username` varchar(500) NOT NULL,
`email` varchar(500) NOT NULL,
`usertitle` varchar(500) NOT NULL,
`time` int(10) NOT NULL,
`day` int(2) NOT NULL,
`winner` int(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`ticket`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1");
$db->reporterror = true;]]></installcode>
<uninstallcode><![CDATA[$db->reporterror = false;
$db->query("DROP TABLE `jlottery`");
$db->reporterror = true;]]></uninstallcode>
</code>
</codes>

Replace with:
<codes>
<code version="1.0.0">
<installcode><![CDATA[$db->reporterror = false;
$db->query("CREATE TABLE " . TABLE_PREFIX . "jlottery (
ticket int(8) NOT NULL AUTO_INCREMENT,
userid varchar(500) NOT NULL,
username varchar(500) NOT NULL,
email varchar(500) NOT NULL,
usertitle varchar(500) NOT NULL,
time int(10) NOT NULL,
day int(2) NOT NULL,
winner int(1) NOT NULL DEFAULT '0',
PRIMARY KEY (ticket)
) ENGINE=MyISAM DEFAULT CHARSET=latin1");
$db->reporterror = true;]]></installcode>
<uninstallcode><![CDATA[$db->reporterror = false;
$db->query("DROP TABLE " . TABLE_PREFIX . "jlottery");
$db->reporterror = true;]]></uninstallcode>
</code>
</codes>

[jujubins]

@cafenetland:
My demo is being used in a draw. If someone who has installed and doesn't use the Jujubins Lottery, please post a demo link for me to post here.

@adhmwagde:
Fixed.

[beduino]

Congrats jujubins!
Installed ! :)
all the best
beduino

[jujubins]

Updated

v1.2.0 - Jan 12. 2009
Added "see all" tickets link
Added option to enable link to see all tickets

[Idawg]

How often does it draw??

Nevermind, saw it in the initial post LOL

[sparky5693]

I currently hold a manually done lottery for new members. I have a drawing monthly for users that registered that month, and have 25 or more posts. Can this handle that? From what I read, it sounds like the exact opposite.

[edermix]

Very good boy. Is installed on my forum and I'm enjoying.

Excellent!

[iBardia]

Could this work for contests?

[jujubins]

@sparky5693
It's what you do.

@iBardia
Sure.
I did for this.

[dxflw]

you have PM

[dxflw]

if i have a winner how i show it?
I have set the shedulled task to (example) 4:15 for today and i wait to view the winner in the thread of the lottery but nothing.
I have all ready set the minimum post to 10 ,allowed usergroups 2,6 and and for topic 3914.

I need litle help please.
Thanks nice Hack!

[jujubins]

To reset the draw you need to run two times the product scheduled task, but if you already have a winner, you just need to run once.

You did that?

[dxflw]

no,i will check this out.

[VFKWorld09]

When I set the lotto up on my forum, and the schedule task was preformed, it still showed the "Take a Ticket", but the person who won, it showed they won. Is this a bug or something?

[jujubins]

When I set the lotto up on my forum, and the schedule task was preformed, it still showed the "Take a Ticket", but the person who won, it showed they won. Is this a bug or something?
v1.2.5 - Feb 1. 2009
Fixed: Show winners

:)

[marianoblesa]

Hello

Here is a small bug when the winner of the draw.

http://www.miforo.net/user.php?u=X

Should be

http://www.miforo.net/member.php?u=X

As exchange rate?

Thanks

[jujubins]

Hello

Here is a small bug when the winner of the draw.

http://www.miforo.net/user.php?u=X

Should be

http://www.miforo.net/member.php?u=X

As exchange rate?

Thanks
Thanks.

v1.2.6 - Feb 6. 2009
Fixed: Winner link (member.php)

[marianoblesa]

Thanks.

v1.2.6 - Feb 6. 2009
Fixed: Winner link (member.php)

Thanks.

[dxflw]

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

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

I get this if i try to reset the shedulled rask after upgrage to 1.2.6!!

My board 3.7.3

[Artes_Marciales]

Amazing!!!

[Noblefist]

Q: Have it installed and is working ok, I would like to post the results in a thread or group, At a loss on how to do this. Kind of a newbe admin for our guild, and new to vB. BTW: this rocks.

[sparky5693]

I see how to reset the lottery, but it still shows the number of tickets from the previous drawing. Shouldn't it discard all the old tickets? As it currently is, the "statistics" can actually list members that aren't part of the current lottery.

[sparky5693]

Is it possible to allow members who aren't part of the lottery see who won?

[pipibunny]

I installed it. But I had a error.

When a new person access to lottery, it's display "Only members registred before of 13:47 of the date 23/02/2009 and have 0 posts can participate. ". But I disable Members Allowed funtion.

[jujubins]

No, you not disabled.
To disable you need set 0.

[pipibunny]

Dear Jujubins,

I had set 0 in function but it didn't work. Pls see image

http://img11.imageshack.us/img11/2169/lottery.jpg

[cynthetiq]

I see how to reset the lottery, but it still shows the number of tickets from the previous drawing. Shouldn't it discard all the old tickets? As it currently is, the "statistics" can actually list members that aren't part of the current lottery.

Is it possible to allow members who aren't part of the lottery see who won?
I have the same questions.

Also, is it possible to make it so that they need to post once that day to get the ticket for the day?

[itsIAN]

I have similar questions as well.

Whenever I clear the lottery it saves the tickets from last week. Though it wasn't hard just going into the database and deleting them, shouldn't this be automatic?

Also, I noticed it keeps counting up in the ticket numbers. Maybe I'm wrong, but shouldn't it start over for each week?

[DobieGillis?]

I have similar questions as well.

Whenever I clear the lottery it saves the tickets from last week. Though it wasn't hard just going into the database and deleting them, shouldn't this be automatic?

Also, I noticed it keeps counting up in the ticket numbers. Maybe I'm wrong, but shouldn't it start over for each week?

yep, still bugged rendering this thing useless

[kaderith]

I'm having the same issue reported by 'pipibunny'

The script is set to "0" for both the Members Allowed and Posts Required options, so that it should allow all members who are registered on the forum (and I do have my user groups set correctly) to take part however, even though its set for 0 posts, its not letting people get a ticket until they've posted at least once on the board.

Which is in turn, causing a great deal of irritation for me since I'm being bombarded with complaints.

[marianoblesa]

How good would be possible if it is not much trouble to add the option to delete all tickets in the database or set to 0.

Thank you.

[kaderith]

I reset the drawing after its first use following the directions as listed. Now, I'm sitting here trying to pick a winner for tonight.. and it isn't working. At all.

[Rob Hephner]

I can't figure out how to clear tickets from the previous lottery, it seems they just stay.

How can I make it start with a clean slate each time.

Thanks

[Rob Hephner]

Um,,,,Hello??

[Adderz]

I cant seem to get this thing working at all :(

Shame as it would have been really useful to me :(


I seem to lose everything after "Take Ticket" including the footer etc

[Phosphorus]

how to clear tickets from the previous lotterys ...................

PLEASE REPLY

[cynthetiq]

uninstalled until author returns.

[DobieGillis?]

uninstalled until author returns.

will never happen.

[kaderith]

I can't figure out how to clear tickets from the previous lottery, it seems they just stay.

How can I make it start with a clean slate each time.

Thanks


The only way I've been able to clear the tickets from previous drawings is to use phpMyAdmin and manually empty the 'jlottery' table which holds the tickets. Its a little bit of a pain but, since we wanted to offer bi-monthly and sometimes weekly drawings with prizes for our group members this was the best way to do it and not have to worry about someone accusing the moderators and administrative staff of picking "favorites" for the winners.

I am still having the problem with the "Number of posts required to participate." option, in that even though its set for 0 posts, it members have to post at least once in order to be able to get a ticket for the current drawing. I think that what is happening is that its set so that it thinks members must have more than X number of posts, so if you set it for 0 thinking you're effectively disabling the minimum number of posts required what is happening is the thing is viewing it as "must have more than X posts" to participate so its still going to give the 'You are not allowed to participate' message until someone posts once. (It is operating I think, with the parameter set to require more than X number of posts, so if you put in 0 its telling the script users must have more than 0 posts (ie at least 1) in order to take part).

Which is fine, except for those members of our group (which is a crafting/crochet/knitting group) who are too special to read the instructions posted regularly at our YahooGroups mailing list, and which are posted on the board itself.. don't bother to read any of the information there and just complain that they can't get it to work. :P

If there's someone out there who knows how to write the code, can look at the information in the php files and figure out how to change that section so that it works as it should that would be great. I've tried, but I have a way to go and each time I tried to modify the code all I did was break it and have to revert back to the backup copy to get things working again.

I'm willing to just leave it with members having to post at least once in order to take part. What I would really like to be able to do is run more than one drawing at the same time. If there was a way to be able to offer more than one drawing running concurrently that would be a huge plus for our group.

[ragarcia87]

Thank you. Insalled :D

[Jhonnydc]

One question... i have installed this mod but i see the error in attach...

How can resolve it???

https://vborg.vbsupport.ru/attachment.php?attachmentid=101732&d=1247123873

[Silver740]

Very promising. Will reserve this until problems are fixed.

[Jhonnydc]

Ok.. thanks... another question for this problem...
The permission of the files in ftp...
I have 755 for all files and folders that i have upload... is it correct???

[ragarcia87]

I've moved my website to a different server and now when I go to /lottery.php all I see is a white page. Any help would be appreciated.

[LilPimp]

awsome ive been looking for this for awhile .. you are the man.

[Jhonnydc]

news???

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

[kaderith]

So...did the developer for this just.. I dunno die or what?

This script has issues...like..now.. after upgrading to the 3.8 version of vBulletin..

It doesn't work anymore. It won't pick a winner.

Is the developer for this going to address any of the many questions posted or .. should we all just uninstall and consider this a lesson learned?

[paul41598]

I'd like to pick this up and work on it if the author doesn't mind. I've already solved a few issues

[TheChaosFactor]

I'd like to pick this up and work on it if the author doesn't mind. I've already solved a few issues
That'd be awesome. I have so many uses for this, but I'm not installing an unsupported piece of software that obviously doesn't work right already. My forum is too new to be introducing features that don't even work right. Especially when I'm considering using it for cash prizes.

Talk about back lash. :o

[kalisekj]

Paul Please Do Since the author has been MIA for over 8 months. My First Lottery will end on the 30th and I'd hate to run into some of these issues listed. Thank You!

[mhackl]

Can't wait to see this one up and running. This could be very useful this Christmas.

[kaderith]

I'd like to pick this up and work on it if the author doesn't mind. I've already solved a few issues

Definitely! Please do.. I'd love to have this working with less bugs on my board.

[NTMID8]

Agreed.... would love to see this fixed and updated.

[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 (https://www.paypal.com/cgi-bin/webscr?cmd=_donations&business=hermes_e_renato%40hotmail%2ecom&lc=BR&item_name=Jujubins&currency_code=USD&bn=PP%2dDonationsBF%3abtn_donateCC_LG%2egif%3aNonH osted)
https://vborg.vbsupport.ru/external/2010/07/4.gif

[chriske]

Hi,
Good to see you will be giving support again :)

I am waiting for Vbulletin 4 before I install any mods again. Will you make this mod work with V4? I would support you with a donation cause I really need it!

I have a lottery each month where users can win prizes, but it's not automatic :( and since more and more users are privileged each month to play the lottery it's getting more time consuming..

Greetz

[kaderith]

Oh wow! Thank you so much for the update and bug fix!

Downloaded, installed..and its working great! You're my hero!

[jujubins]

Hi,
Good to see you will be giving support again :)

I am waiting for Vbulletin 4 before I install any mods again. Will you make this mod work with V4? I would support you with a donation cause I really need it!
Thanks.
Yes, I will make this mod work with V4 ;P I already bought.
I really need and appreciate donations if you can do it.

Oh wow! Thank you so much for the update and bug fix!

Downloaded, installed..and its working great! You're my hero!
Thanks ;D

[paul41598]

We should use the threadman function and use that to our advantage. Use it to make a post in the thread about the winners...

[jujubins]

We should use the threadman function and use that to our advantage. Use it to make a post in the thread about the winners...
Good idea, I'm doing this function.

[need2fart]

Good idea, I'm doing this function.

That is so cool I'm totally installing this mod if you do that. That is awesome bro!

[jujubins]

New version v2.1.0.
Added the congratulations post in the thread (editable)
Fixed: Some insignificant bugs

Please help my keep supporting the project by donating in Paypal (https://www.paypal.com/cgi-bin/webscr?cmd=_donations&business=hermes_e_renato%40hotmail%2ecom&lc=BR&item_name=Jujubins&currency_code=USD&bn=PP%2dDonationsBF%3abtn_donateCC_LG%2egif%3aNonH osted)
https://vborg.vbsupport.ru/external/2010/07/4.gif

[lazyseller]

After i install this and give it a whirl ill be back for a donation to the paypal.

[pipibunny]

I had set Posts Required is 10. But it not effect.
A new meber or member has 0 posts , but they still participate lottery. So Why ?

[jujubins]

I had set Posts Required is 10. But it not effect.
A new meber or member has 0 posts , but they still participate lottery. So Why ?
Thanks, I fixed it.

v2.1.1 - Out 30. 2009
Fixed: Posts limit


Please help my keep supporting the project by donating in Paypal (https://www.paypal.com/cgi-bin/webscr?cmd=_donations&business=hermes_e_renato%40hotmail%2ecom&lc=BR&item_name=Jujubins&currency_code=USD&bn=PP%2dDonationsBF%3abtn_donateCC_LG%2egif%3aNonH osted)
https://vborg.vbsupport.ru/external/2010/07/4.gif

[Jhonnydc]

I have installed and configured the mod...

I have a little problem...

Not work the "Automatically post the winner in thread"

I have enable the option, but the mod don't post the winner in thread...

[jujubins]

You need to fill the userid in "Poster userid" field and the threadid in "Topic" field.

[kalisekj]

WooHoo! Thank you very Much!

Couple things to Note, I lost all lottery tickets when I Updated, I thought ahead and print screened all tickets gotten before upgrade then logged in as each user and gave them their ticket again. Also After Update Make sure you set the scheduled task again.

Bug: See all tickets option took me back to my main page and I could no longer see who all had a ticket any more. :(
Changed jlottery_shell template and put lottery.php in front of ?do=alltickets so it will look like this href="lottery.php?do=alltickets">$vbphrase[jlottery_seeall]</a>
I also had to do the same for the Menu Option home to just go back to the Lottery page instead of the Site Home page.
I also Made the Same change to Reset just in case it also had same issue as the other 2 options.

Bug: Lottery was stating 1 user out of 10 tickets or 14 users out of 10 tickets , so I went into lottery.php and changed 10 to 100 and now it displays correctly the 14 users out of 14 tickets or 5 users out of 5 tickets.

Bug: Only Showing 2 of the 14 users in the proper Usergroup Coloring http://i34.tinypic.com/2nb5cgm.jpg.
This worked perfectly before the update. Version 1 : http://i36.tinypic.com/ivuyj5.jpg
As you can see the Ver 1 was ?do=all and showed things perfectly in Ver 2 you will see the Usergrp Color Markup is not working right plus the number of tickets should all be 1 and the User Ticket Number does Not show up to the left of their name. Anyway you can fix the Show All too Look more like your Version 1?

Not sure if this is an issue but when I installed the update and checked I could see a reset option under menu. But When I started adding the tickets back in for the users the reset lottery option went away. I am assuming it will show back up after the scheduled task runs tomorrow night? If Not I will Let you Know.
Ok Choosing more than one user group for rest IE: 5,6 or 5, 6 makes the Reset feature not Show Up. I changed it to just 1 usergroup and the reset shows Back up.

Thanks again for a Great Mod!

[MandachuvA]

Parab?ns jujubin ? um ?timo mod sem duvida, mais estou tendo problemas aqui com ele, veja na imagem apenas o primeiro esta sendo reconhecido como membro ( em cor roxa ) os outros dois n?o
sendo que s?o membros iguais ao primeiro ( em cor roxa ) o que poderia ser isso meu querido.

imagem - http://img504.imageshack.us/img504/6559/erroloteria.png

desde j? agrade?o.

[jujubins]

WooHoo! Thank you very Much!

Couple things to Note, I lost all lottery tickets when I Updated, I thought ahead and print screened all tickets gotten before upgrade then logged in as each user and gave them their ticket again. Also After Update Make sure you set the scheduled task again.

After version 2.0.0, updates will have to delete the tickets, to not have problems with incompatibility in the database.
I fixed it now. Who already has the version 2.0.0 or above, the tickets will not be reset.

Bug: See all tickets option took me back to my main page and I could no longer see who all had a ticket any more. :(
Changed jlottery_shell template and put lottery.php in front of ?do=alltickets so it will look like this href="lottery.php?do=alltickets">$vbphrase[jlottery_seeall]</a>
I also had to do the same for the Menu Option home to just go back to the Lottery page instead of the Site Home page.
I also Made the Same change to Reset just in case it also had same issue as the other 2 options.

Fixed in 2.1.3

Bug: Lottery was stating 1 user out of 10 tickets or 14 users out of 10 tickets , so I went into lottery.php and changed 10 to 100 and now it displays correctly the 14 users out of 14 tickets or 5 users out of 5 tickets.

You can stop the problem just by disabling the option of rounding.

Bug: Only Showing 2 of the 14 users in the proper Usergroup Coloring http://i34.tinypic.com/2nb5cgm.jpg.
This worked perfectly before the update. Version 1 : http://i36.tinypic.com/ivuyj5.jpg
As you can see the Ver 1 was ?do=all and showed things perfectly in Ver 2 you will see the Usergrp Color Markup is not working right plus the number of tickets should all be 1 and the User Ticket Number does Not show up to the left of their name. Anyway you can fix the Show All too Look more like your Version 1?

Fixed in 2.1.3.

Not sure if this is an issue but when I installed the update and checked I could see a reset option under menu. But When I started adding the tickets back in for the users the reset lottery option went away. I am assuming it will show back up after the scheduled task runs tomorrow night? If Not I will Let you Know.
Ok Choosing more than one user group for rest IE: 5,6 or 5, 6 makes the Reset feature not Show Up. I changed it to just 1 usergroup and the reset shows Back up.

Fixed in 2.1.3.

Thanks again for a Great Mod!
Thank you to reported all errors ;)

Parab?ns jujubin ? um ?timo mod sem duvida, mais estou tendo problemas aqui com ele, veja na imagem apenas o primeiro esta sendo reconhecido como membro ( em cor roxa ) os outros dois n?o
sendo que s?o membros iguais ao primeiro ( em cor roxa ) o que poderia ser isso meu querido.

imagem - http://img504.imageshack.us/img504/6559/erroloteria.png

desde j? agrade?o.
Consertado na 2.1.3.

[kalisekj]

Thank you For fixing everything, The all tickets view is now showing the usergroup color mark up like it should. 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.

Thank You

[NTMID8]

Thanks for picking this back up. I'll check it out again ASAP.

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

[jujubins]

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.

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]

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

https://vborg.vbsupport.ru/attachment.php?attachmentid=105883&stc=1&d=1257329706

https://vborg.vbsupport.ru/attachment.php?attachmentid=105884&stc=1&d=1257329706

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

https://vborg.vbsupport.ru/attachment.php?attachmentid=105881&stc=1&d=1257329706

https://vborg.vbsupport.ru/attachment.php?attachmentid=105882&stc=1&d=1257329706

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]

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/forums/admincp/cronadmin.php?do=runcron&cronid=45
Referrer : http://www.thegatheringroom.org/forums/admincp/cronadmin.php?do=modify
IP Address : 68.0.17.55
Username : admin
Classname : vB_Database
MySQL Version : 5.0.81-community-log

[jimsflies]

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]

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.

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/forums/admincp/cronadmin.php?do=runcron&cronid=45
Referrer : http://www.thegatheringroom.org/forums/admincp/cronadmin.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')");

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

[KProjects]

tagged