What version of mysql are you using?

(Front page of your admincp has "MySQL Version")

It will, just not yet. That whole setup piece needs reworked.

For some reason my lottery did not set up a new draw for today when the cron ran.

I have tried running the cron manually, and no errors show up, but no new draw gets created.

It's been working ok previously. I'm a bit baffled.

Just an update - I have created a draw manually now for today (nicked bits of the cron script and patched it together), so that's why there's now one showing up, but for some reason it wouldn't create automatically.

Additionally, I'm still struggling with the time zones on the Sports Pool. Something isn't right.

I had an event that I set to close at 19:20hrs BST (GMT +1) today, and just now at 19.20hts it was still open. When I converted the timestamp in a converter, it equated to 01:00 BST. Even though the event did say ion the public screen that it would close at 19:00 BST.

I fixed it by manually changing the timestamp, but I don't think I have ever once managed to get an event to close at the desired time without altering the timestamp afterwards in the database.

When we select a time in the admincp, what timezone is it actually using? And what timezone then displays on the public site?

For me, I am adding games that start at 1PM EST (for instance). I set my site to use Eastern Standard Time

So for me in Colorado (2hrs behind) it shows that it closes at 11am

I assume it is taking that from the board setting

I have a couple ideas, I'll implement them all, should solve this, as well as give you the ability to start a draw if there isn't one.

Right now it's using the server time, not vb time, but the server time. I'm going to slap in a adjustment to use the users time settings though.

Cool! My server time must be EST.

That works well.

I dunno anymore. I get totally confused by time zones.

I have just made some changes to sportspool.php along the following lines:

Then I have gone into the template casino_sportspool_event, and added $eventtime next to $eventdate.

With a test event, if I now create the event with a time six hours before the time I actually want it to close, the close time shows correctly in BST on the public page.

The question then is, will the event actually close at that time or not? Because today's didn't, but that was before I made the changes.

I am assuming this works the same as the add scheduled tasks window, which also requires times to be six hours aheaed (for me anyway) but then shows them in my local time in the management window.

I *hate* timezones!!!!

PS....please don't think I'm criticising you in any way here Andrew. It's my own confusion with timezones that causes this, not your mod! I have the same problem trying to get crons to run at the right time.

Is there a way to add advertising or banners to the blackjack or the slots pages?

Excellent. I am sorry i wasn't here to help you load these, but as long as you got it done that is what matters.

I designed these with my dark BGs in mind as well, although I actually labeled them with my forum's casino name. I have several skins, and most use a dark BG... I find it easier on the eyes. I am glad you like them.