I dont like the way this hack selects users from the whole database of users and not those who have just chosen a ticket..

With over 1000 users it takes AGEEEEEESSSSSSS..

Why not have it just select from those users who have purchased a ticket :)

Regards

- miSt

how can I change the hardcoded colors ?

And here is how to stop this and it works GREAT

https://vborg.vbsupport.ru/showthrea...956#post263956

Agree 100%!


Woops! There it was.... Thanks m8! :banana:

perfect!!! THANK YOU VERY MUCH :d

Thanks, it works!

But I have one problem - information about Lottery (when I press "Lottery Options) always display twice. The same when I try to edit lottery, or view user who bought tickets - always twice...

Actions
Lottery Name Money In The Jackpot Start Date End Date # Sold Already Modify
Lottery 40 2002-11-15 00:00:00 2002-11-16 00:00:00 1 [Edit] [View Users] [End Lottery/Pick Winner]

Actions
Lottery Name Money In The Jackpot Start Date End Date # Sold Already Modify
Lottery 40 2002-11-15 00:00:00 2002-11-16 00:00:00 1 [Edit] [View Users] [End Lottery/Pick Winner]

<!-- Like this - always the same things twice

Also I have another mistake after end of lottery:
<!--

Updating user, set storeaction to offline and delete lottery and lotteryusers...

'User' is rewarded with 20 points.
'User' is pm'ed with the winner's message.
Lottery action on the store is set to offline.
Lottery and his users are deleted.

Done!

Updating user, set storeaction to offline and delete lottery and lotteryusers...

Database error in vBulletin Control Panel 2.2.8:

Invalid SQL: UPDATE user SET storep=storep+ WHERE userid='1'
mysql error: You have an error in your SQL syntax near 'WHERE userid='1'' at line 1

mysql error number: 1064

--!>

Yes, Lesane PLEASE PLEASE PLEASE make it so when drawing for the winner, it only searches through a list of people who bought a ticket.

nevermind.wrong thread