vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Major Additions - Casino (w/ 10 player poker) (https://vborg.vbsupport.ru/showthread.php?t=159151)

towermatt 10-20-2007 02:45 PM

Quote:

Originally Posted by sandt38 (Post 1364372)
in .33 I saw apostrophes causing errors. It was with user names, however. It doesn't appear to be an issue with .34 Try removing it.



Here are the 2 big chips you wanted:


And here is the file for the upload. It includes all the markers from 1-10,000, not just the 5,000 and 10,000. Also, if you have a black or dark background the 10,000 chip has an outer glow, to make it stand out.

I kind of feel like an idiot but I am not sure how to get this file from mega upload--not only that, but what to do with it in order to get those chips in my casino if I can figure out the first part. :erm:

Would someone mind spelling that out real quick?

Because I love those chips!

Mark.B 10-20-2007 02:56 PM

Quote:

Originally Posted by towermatt (Post 1364388)
I kind of feel like an idiot but I am not sure how to get this file from mega upload--not only that, but what to do with it in order to get those chips in my casino if I can figure out the first part. :erm:

Would someone mind spelling that out real quick?

Because I love those chips!

You have to download the file, but initially you'll get a countdown timer counting down from 45 to zero...once it's done that, press "Free Download" and save them to your PC.

You'll then need to open them using something that can open RAR files, I've got WinRar which is free to try out.

Then you extract them to your hard drive and upload them to the casino/cards folder.

bobster65 10-20-2007 03:00 PM

Quote:

Originally Posted by towermatt (Post 1364388)
I kind of feel like an idiot but I am not sure how to get this file from mega upload--not only that, but what to do with it in order to get those chips in my casino if I can figure out the first part. :erm:

Would someone mind spelling that out real quick?

Because I love those chips!

just right click on the images and "save as" ... put them in a directory on your local machine and then ftp them to your server.

dyna88 10-20-2007 03:00 PM

You could also just right click on the images and "save image as"

Edit: Looks like bobster65 was a little quicker...lol

Mark.B 10-20-2007 03:04 PM

Quote:

Originally Posted by bobster65 (Post 1364393)
just right click on the images and "save as" ... put them in a directory on your local machine and then ftp them to your server.

Quote:

Originally Posted by dyna88 (Post 1364394)
You could also just right click on the images and "save image as"

Edit: Looks like bobster65 was a little quicker...lol

I did wonder about that. However, it's *possible* the ones in the posts are "for illustrative purposes only", and the real images may be saved in a higher quality format.

towermatt 10-20-2007 03:11 PM

Do you have to have a sign on for mega upload? I let it sit there for 10 mins and got nothing.

File name and description are down there but all the stuff I can click is for ads

Edit--Forgot to say...thanks for all the help you guys :)

Mark.B 10-20-2007 03:19 PM

Quote:

Originally Posted by towermatt (Post 1364400)
Do you have to have a sign on for mega upload? I let it sit there for 10 mins and got nothing.

File name and description are down there but all the stuff I can click is for ads

Edit--Forgot to say...thanks for all the help you guys :)

Ah...there's a step I forgot about!!

When you get the initial MegaUploads page, there is a box at the top where you have to enter a three letter word (like an image verification). For me it always seems to be "ZUG".

Then press the Download button.

Then on the following page you get the download links, but for free download you have to wait for a 45 second timer to count down.

towermatt 10-20-2007 03:38 PM

Sweet! Got them downloaded and uploaded via ftp

Next question would be that the existing chips are .gif and these are .png

do I need to change that somewhere. I went in and they are still the old chips after uploading

Mark.B 10-20-2007 03:41 PM

Quote:

Originally Posted by towermatt (Post 1364406)
Sweet! Got them downloaded and uploaded via ftp

Next question would be that the existing chips are .gif and these are .png

do I need to change that somewhere. I went in and they are still the old chips after uploading

Admin CP > Casino > Casino Settings

At the bottom are the chip denominations and also the URLs to their images...amend them accordingly. If the actual names are the same just change all the suffices to .png

towermatt 10-20-2007 03:50 PM

Wonderful!

I should have investigated that, totally logical. Thanks again for the help, the chips look great

They are on and are perfect. My site has all these black colors so they came across well

Andrew Green 10-20-2007 04:23 PM

Quote:

Originally Posted by Rushty (Post 1364375)
im getting an sql error when trying to install v.34 on vb 3.6.8, error is:

What version of mysql are you using?

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

Quote:

Originally Posted by towermatt (Post 1364365)
I was hoping there could be a way to edit sports pool events. I put in a wrong closing time on one of the football games I added for this Sunday :(

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

Mark.B 10-20-2007 04:55 PM

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.

Mark.B 10-20-2007 05:16 PM

Quote:

Originally Posted by Mark.B (Post 1364444)
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.

Mark.B 10-20-2007 05:26 PM

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?

towermatt 10-20-2007 05:31 PM

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

Andrew Green 10-20-2007 05:34 PM

Quote:

Originally Posted by Mark.B (Post 1364444)
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.

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.

Quote:

Originally Posted by Mark.B (Post 1364460)
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?

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.

towermatt 10-20-2007 05:35 PM

Cool! My server time must be EST.

That works well.

Mark.B 10-20-2007 05:37 PM

Quote:

Originally Posted by towermatt (Post 1364461)
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 dunno anymore. I get totally confused by time zones.

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

Code:

$eventdate = vbdate($vbulletin->options['dateformat'], $eventtime);
$eventtime = vbdate($vbulletin->options['timeformat'], $eventtime);

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.

aztecboi2003 10-20-2007 05:48 PM

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

sandt38 10-20-2007 08:01 PM

Quote:

Originally Posted by towermatt (Post 1364416)
Wonderful!

I should have investigated that, totally logical. Thanks again for the help, the chips look great

They are on and are perfect. My site has all these black colors so they came across well

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.

towermatt 10-20-2007 08:21 PM

They go so well...here's a screen shot

http://img89.imageshack.us/img89/7105/screenia4.jpg

lairnoc 10-21-2007 07:43 AM

Quote:

Originally Posted by bazzup (Post 1364253)
This got answered


THNX :P

Mark.B 10-21-2007 12:33 PM

Something I've just spotted..

In slots, your cash total is updated with your winnings/loss before the reels have stopped spinning.

Could this be made to do so afterwards? As otherwise people will think it's a fix, even though it isn't.

Tulsa 10-21-2007 12:48 PM

Quote:

Originally Posted by Mark.B (Post 1365004)
Something I've just spotted..

In slots, your cash total is updated with your winnings/loss before the reels have stopped spinning.

Could this be made to do so afterwards? As otherwise people will think it's a fix, even though it isn't.

Mine does do so afterwards.

Mark.B 10-21-2007 12:52 PM

Quote:

Originally Posted by Tulsa (Post 1365017)
Mine does do so afterwards.

Yeah I was sure mine did...but it isn't at the moment.

I shall investigate further!

Mark.B 10-21-2007 12:54 PM

Quote:

Originally Posted by Mark.B (Post 1365020)
Yeah I was sure mine did...but it isn't at the moment.

I shall investigate further!

I notice on Andrew's site the chips and total disappear while the reels are spinning.

I reckon this is a template edit I've done, and shall have a play around!

Mark.B 10-21-2007 12:56 PM

Quote:

Originally Posted by Mark.B (Post 1365022)
I notice on Andrew's site the chips and total disappear while the reels are spinning.

I reckon this is a template edit I've done, and shall have a play around!

Yup it's my template edits!

Gaah!

Much messing about needed now...again!

BuckRodgers 10-21-2007 04:21 PM

ok everthing was running fine till about 10 mins ago but now when i enter the casino ang go to texas holdem i get this db error

Code:

Database error in vBulletin 3.6.8:

Invalid SQL:
SELECT * FROM casino_texasholdem_whoisin WHERE userid = 7;

MySQL Error  : Table 'web93-datadrome.casino_texasholdem_whoisin' doesn't exist
Error Number : 1146
Date        : Sunday, October 21st 2007 @ 06:13:33 PM
Script      : http://www.datadrome.co.uk/forum/casino.php?do=texasholdem
Referrer    : http://www.datadrome.co.uk/forum/casino.php
IP Address  : ****
Username    : Samorite
Classname    : vb_database

any ideas any one ?

Andrew Green 10-21-2007 04:36 PM

Texas Hold'em was working though?

And now it doesn't at all?

By that error it looks like one of your tables got erased, but there is nothing in there that could erase a table...

Do you have phpmyadmin access to your DB?

BuckRodgers 10-21-2007 04:38 PM

Quote:

Originally Posted by Andrew Green (Post 1365191)
Texas Hold'em was working though?

And now it doesn't at all?

By that error it looks like one of your tables got erased, but there is nothing in there that could erase a table...

errr is there any way to fix ?
carnt get it to unistall so i am a bit stuck

yes i have phpmyadmin access

Andrew Green 10-21-2007 04:44 PM

Quote:

Originally Posted by samorite (Post 1365195)
errr is there any way to fix ?
carnt get it to unistall so i am a bit stuck

If you have direct access to mysql, most likely through phpmyadmin, run these two queries:

Code:

DROP TABLE casino_texasholdem_whoisin;
CREATE TABLE casino_texasholdem_whoisin (whoisinid integer NOT NULL PRIMARY KEY auto_increment, userid integer, seat integer, lastcheck integer, status integer, bet integer);


BuckRodgers 10-21-2007 04:59 PM

my sql said:

#1064 - You have an er in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

Andrew Green 10-21-2007 05:01 PM

bracket got left off in the copy and paste, fixed now.

BuckRodgers 10-21-2007 05:08 PM

ok that seems to have worked but got this now

Code:

Database error in vBulletin 3.6.8:

Invalid SQL:
INSERT INTO casino_texasholdem_chatlog (msg, msgtime) VALUES ('<b>Samorite joins the game</b>', 1192990049);

MySQL Error  : Table 'web93-datadrome.casino_texasholdem_chatlog' doesn't exist
Error Number : 1146
Date        : Sunday, October 21st 2007 @ 07:07:29 PM
Script      : http://www.datadrome.co.uk/forum/casino.php?do=texasholdem&action=joingame
Referrer    :
IP Address  : 82.22.587.216
Username    : Samorite
Classname    : vb_database


Andrew Green 10-21-2007 05:12 PM

Do your other games work?

Looks almost like it was partially uninstalled...

Anyways, running these should fix the other tables associated with Texas Hold'em

Code:

DROP TABLE casino_texasholdem_chatlog;
CREATE TABLE casino_texasholdem_chatlog (chatlogid integer NOT NULL PRIMARY KEY auto_increment, msg text, msgtime integer);

DROP TABLE casino_texasholdem_dealt;
CREATE TABLE casino_texasholdem_dealt (dealtid integer NOT NULL PRIMARY KEY auto_increment, playerid integer, card integer);


BuckRodgers 10-21-2007 05:22 PM

yaaaay all back working just got the admin error now

Code:

Database error in vBulletin 3.6.8:

Invalid SQL:

                SELECT cs1.switch1 AS gameid, cs1.switch2 AS gamefile, cs2.switch2 AS gamename, cs3.switch2 AS gamedesc, cs4.switch2 AS active
                FROM casino_settings AS cs1, casino_settings AS cs2, casino_settings AS cs3, casino_settings AS cs4   
                WHERE cs1.switch1=cs2.switch1
                AND cs1.switch1= cs3.switch1
                AND cs1.switch1= cs4.switch1
                AND cs1.settingname='gamefile'
                AND cs2.settingname='gamename'
                AND cs3.settingname='gamedesc'
                AND cs4.settingname='gameactive';

MySQL Error  : The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay
Error Number : 1104
Date        : Sunday, October 21st 2007 @ 07:19:50 PM
Script      : http://www.datadrome.co.uk/forum/admincp/casino_settings.php
Referrer    : http://www.datadrome.co.uk/forum/admincp/index.php?loc=plugin.php%3Fdo%3Dproduct
IP Address  : **********
Username    : Samorite
Classname    : vb_database

anyway to sort that ? I know i asked ya earler but while i got ya in the zone :P

Andrew Green 10-21-2007 05:26 PM

Quote:

Originally Posted by samorite (Post 1365229)

anyway to sort that i know i asked ya earler but while i got ya in the zone :P

It's actually fixed, in the next update. As well as everything else that I know about. Plus a new interface for the sportspool setup, and a new game (Let it Ride). Just finishing some stuff up with it, and hopefully will be able to get that out later today.

BuckRodgers 10-21-2007 05:32 PM

OK and a big thanks :D

Donation sent keep up the good work !

towermatt 10-21-2007 07:44 PM

Quote:

Originally Posted by Andrew Green (Post 1365234)
It's actually fixed, in the next update. As well as everything else that I know about. Plus a new interface for the sportspool setup, and a new game (Let it Ride). Just finishing some stuff up with it, and hopefully will be able to get that out later today.

**does big happy banana dance**

Can't wait Andrew

Andrew Green 10-21-2007 07:54 PM

v 0.40 is up :)

Added a new game, redid the sportspool interface, fixed a bunch of bugs, etc


All times are GMT. The time now is 04:57 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03682 seconds
  • Memory Usage 1,856KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (6)bbcode_code_printable
  • (23)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete