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)

stangger5 10-02-2007 04:12 AM

Still wont let you uninstall:

Invalid SQL:
ALTER TABLE user DROP 'casino_cash';

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''casino_cash'' at line 1
Error Number : 1064

Andrew Green 10-02-2007 04:17 AM

Quote:

Originally Posted by stangger5 (Post 1351153)
Still wont let you uninstall:

Invalid SQL:
ALTER TABLE user DROP 'casino_cash';

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''casino_cash'' at line 1
Error Number : 1064

old version of that line, did you update first then try and uninstall? If not try that as that line in the uninstall code should be changed, if not you can manually change the uninstall code for the product, first line to:

Code:

$query = "ALTER TABLE ". TABLE_PREFIX . "user DROP COLUMN 'casino_cash'";
basically adding "COLUMN" in there.

stangger5 10-02-2007 06:17 AM

Everything is working great now and on all skins !!!!

Thanks Andrew !!!!

kylek 10-02-2007 06:33 AM

Just did two fresh installs of Casino 0.11 on two different sites and both went well with no problems. Lottery looks good, able to buy tickets.

Only thing I can see right now is that it names the casino - Innovative Martial Arts Casino. Will have to search to see where it can be changed.

A question - When setting up first draw in Lottery the jackpot had a number already set, I think in one site it was $24320.00 Is this resettable? It would be nice if we could have a set amount to start out with.

A suggestion or two - instead of showing richest users top 10 could it maybe just show the top 10 members who have made the most in the casino? Have it separate from total points (use vbcredits which has option to keep amounts private) as some members do not like others seeing how much they have.

And the possibility of adding a $25 or $50 token for the big spenders. So poker and blackjack would have $1, $5, $10, and $25 or $50.00

stangger5 10-02-2007 07:35 AM

To edit the Casino name...Look in the casino_index_main template...

kylek,,,We must be thinking a like....I`ve allready add a $25 and $50 token...lol..

acegames 10-02-2007 09:26 AM

Just installed but now my site wont load due to a database error ???

stangger5 10-02-2007 09:29 AM

What kind of error ??

If you cant get rid of the error..

Go into your ftp: includes/config.php and put this at the top,, right under <?php

define('DISABLE_HOOKS', true);

acegames 10-02-2007 09:40 AM

It was just a database error , I restarted my mysql services and its fine now , thankyou

Now im going to try this casino :)

acegames 10-02-2007 09:53 AM

Working great here :)

How do I set it up to use vcash ?

Andrew Green 10-02-2007 11:56 AM

as in vbookie_cash?

in the setup change the cash field to "vbookie_cash"

Andrew Green 10-02-2007 12:02 PM

Quote:

Originally Posted by kylek (Post 1351234)
Only thing I can see right now is that it names the casino - Innovative Martial Arts Casino. Will have to search to see where it can be changed.

I'll track that down and fix it for the next update, thought I'd go all of them.

Quote:

A question - When setting up first draw in Lottery the jackpot had a number already set, I think in one site it was $24320.00 Is this resettable? It would be nice if we could have a set amount to start out with.
Draw amount is based off of the range and number of balls and price, it's setup to calculate a jackpot that will maintain about 100% win, and increases over time until it's won. I could add a option to manually edit it though.

Quote:

A suggestion or two - instead of showing richest users top 10 could it maybe just show the top 10 members who have made the most in the casino? Have it separate from total points (use vbcredits which has option to keep amounts private) as some members do not like others seeing how much they have.
Yes, it does track a number of stats that aren't being used for anything yet, so in later versions there should be more available.

Quote:

And the possibility of adding a $25 or $50 token for the big spenders. So poker and blackjack would have $1, $5, $10, and $25 or $50.00
Yes, it's in the plans, as well as a switch to allow each amount in the admincp.

kiril_cvetkov 10-02-2007 12:34 PM

When i want to uninstall this modification - i get mysql error :(

HTML Code:

Database error in vBulletin 3.6.8:

Invalid SQL:
ALTER TABLE user DROP 'casino_cash';

MySQL Error  : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''casino_cash'' at line 1
Error Number : 1064
Date        : Tuesday, October 2nd 2007 @ 07:29:01 AM
Script      : http://www.bryansrequestsite.com/forum/admincp/plugin.php?do=productkill
Referrer    : http://www.bryansrequestsite.com/forum/admincp/plugin.php?do=productdelete&productid=casino&s=
IP Address  : 85.30.68.39
Username    : kiril_Cvetkov
Classname    : vb_database

Can i uninstall this when i disable the hooks
HTML Code:

define('DISABLE_HOOKS', true);

Andrew Green 10-02-2007 12:52 PM

Quote:

Originally Posted by kiril_cvetkov (Post 1351405)
When i want to uninstall this modification - i get mysql error :(

The update to .11 should fix that. You can also manually fix the uninstall code:

Change the uninstall code for the product, first line to:

Code:

$query = "ALTER TABLE ". TABLE_PREFIX . "user DROP COLUMN 'casino_cash'";
Adding "COLUMN" in between "DROP" and "'casino_cash'"

acegames 10-02-2007 01:26 PM

Quote:

Originally Posted by Andrew Green (Post 1351381)
as in vbookie_cash?

in the setup change the cash field to "vbookie_cash"


Perfect thankyou :)

ChU v2 10-02-2007 02:10 PM

Looks good, I'll be watching this mod for a texas hold em integration and multiplayer will be great.

ArchangelX 10-02-2007 05:53 PM

Anyway to integrate this with the other casino mod available? Thanks!

And will this work on 3.5? Thanks again!

Andrew Green 10-02-2007 05:57 PM

Quote:

Originally Posted by ArchangelX (Post 1351591)
Anyway to integrate this with the other casino mod available? Thanks!

I'm not sure which other casino mod you mean, but I imagine that they would have no problem sharing the same cash. In the admincp you can set the name of the cash field to match the one the other casino uses.

Quote:

And will this work on 3.5? Thanks again!
I see no reason why it shouldn't, but haven't actually tried it.

ArchangelX 10-02-2007 06:01 PM

Thanks for the quick response!

It's here: https://vborg.vbsupport.ru/showthread.php?t=158139

It's been out for a while now...and has been constantly updated for each new version of VB. One of the oldest hacks, I believe.

I'll try it out...unfortunately, I'll have to change the casino.php file's name. Thanks!

Andrew Green 10-02-2007 06:03 PM

Quote:

Originally Posted by ArchangelX (Post 1351595)
I'll try it out...unfortunately, I'll have to change the casino.php file's name. Thanks!

Might be trickier then it sounds, all of the links go through "casino.php", so changing it without also changing any reference to it in the templates and files will break it. Which of course would need to be done again with every update...

stangger5 10-02-2007 06:08 PM

I have them both installed with no problems...

Casino for vBulletin uses casino.php
and
vbcasino uses lottery.php

ArchangelX 10-02-2007 06:30 PM

Quote:

Originally Posted by Andrew Green (Post 1351598)
Might be trickier then it sounds, all of the links go through "casino.php", so changing it without also changing any reference to it in the templates and files will break it. Which of course would need to be done again with every update...


Shouldn't be too hard with a complete Find/Replace command for all the calls to casino.php.

I already have a lottery system installed, so when I installed the first vBCasino, I had to change all the instances of lottery.php to casino.php. I'll have to do the same here in order to use it.

But great addition! Kudos for the work on it!

Mark.B 10-02-2007 08:18 PM

This is excellent....

Only thing I've spotted is that all the templates are uncached.

aztecboi2003 10-02-2007 09:34 PM

Anyway to make this a little easier for novices to install? I haven't tried it but it looks complex.

Mark.B 10-02-2007 09:34 PM

In template casino_error, the conditional:
Code:

<if condition="$nomoneyslot">
should be....
Code:

<if condition="$slotnomoney">

Mark.B 10-02-2007 09:35 PM

Quote:

Originally Posted by aztecboi2003 (Post 1351711)
Anyway to make this a little easier for novices to install? I haven't tried it but it looks complex.

It isn't...it's as easy as any other modification. Import the product, upload the files and make a couple of easy template edits.

ArchangelX 10-02-2007 10:38 PM

It was a pretty painless install...really easy. Just import the product. If you already have a cash mod in, you don't even have to edit the templates.

Anyways, I believe there's a bug in the Blackjack program. When you split it...the totals don't come out ahead. As soon as you split, you're refunded 10 (if you do a 10 token)...which is a little weird. Might want to take a look at that again!

Instead of taking away another 10 for the split, it gives you 10.

Mark.B 10-02-2007 11:02 PM

It would be handy to specify the time of lottery draws...I'm in the UK so the lottery draw seems to be at 3am!

Andrew Green 10-03-2007 02:40 AM

Quote:

Originally Posted by Mark.B (Post 1351751)
It would be handy to specify the time of lottery draws...I'm in the UK so the lottery draw seems to be at 3am!

Well, not yet. It's a labelled .11 for a reason, I still have a lot of features I need to add in. SOme small things like that, others fairly big things (other games)

Quote:

Originally Posted by ArchangelX (Post 1351738)
Instead of taking away another 10 for the split, it gives you 10.

Hadn't noticed that, thanks :)

Hornstar 10-03-2007 07:45 AM

WOW, this is so fantastic, I am going to watch the progress like an eagle, as this is something that I have always wanted

Thanks so much for sharing this with all of us.

+1 for multiplayer :D

wilburshere 10-03-2007 10:02 AM

i like the sport pool feature awesome

merismus 10-03-2007 10:53 AM

I installed the mod and when trying to access the casino page in my website i had error messages all the time saying that the page could not be found and so on i tired to find out where the issue is coming form but no way! When i tried to uninstall the Mod i received an DATABASE error message disallowing to uninstall the mod!

Andrew Green 10-03-2007 12:50 PM

Quote:

Originally Posted by merismus (Post 1352039)
I installed the mod and when trying to access the casino page in my website i had error messages all the time saying that the page could not be found and so on i tired to find out where the issue is coming form but no way! When i tried to uninstall the Mod i received an DATABASE error message disallowing to uninstall the mod!


What where the error messages? Hard to try and fix it for you without something more specific.

stangger5 10-03-2007 01:04 PM

Quote:

Originally Posted by merismus (Post 1352039)
I installed the mod and when trying to access the casino page in my website i had error messages all the time saying that the page could not be found

Did you upload the casino.php file ??

Theres three folders (admincp,,casino,,includes) and the casino.php to upload...

bhen13 10-03-2007 02:14 PM

everything works great except for poker... I get this error..

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /casino/vidpok_redeal.php on line 151

Warning: Wrong parameter count for max() in /casino/vidpok_redeal.php on line 187

Warning: Wrong parameter count for min() in /casino/vidpok_redeal.php on line 187

Andrew Green 10-03-2007 02:23 PM

Can you confirm that the table "casino_vidpok_dealt" exists in your database?

bhen13 10-03-2007 02:25 PM

I would , but How??:o

Andrew Green 10-03-2007 02:28 PM

Quote:

Originally Posted by bhen13 (Post 1352154)
I would , but How??:o

Do you have phpmyadmin? Or any other way to get into your DB directly?

bhen13 10-03-2007 02:31 PM

yes

Andrew Green 10-03-2007 02:36 PM

You can use that to check whether or not the table exists, if not or you're still not sure what I meant I can send you a updated copy of the file that won't fix the problem, but should at least be more descriptive on what the problem is :)

bhen13 10-03-2007 02:39 PM

please and thank you :D


All times are GMT. The time now is 12:59 PM.

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.02388 seconds
  • Memory Usage 1,835KB
  • 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
  • (4)bbcode_code_printable
  • (2)bbcode_html_printable
  • (17)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (2)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