vb.org Archive - Major Additions - Casino (w/ 10 player poker)

Hi,

I'm getting this error when importing the product:

Invalid SQL:
ALTER TABLE user ADD casino_cash integer default 250;

MySQL Error : Duplicate column name 'casino_cash'
Error Number : 1060

I've deleted all the casino referrences in sql, any ideas?

Thanks

It means you still have a "casino_cash" field in your user table, you can remove it through phpmyadmin.

tigrattack

01-07-2008 06:04 PM

Quote:

Originally Posted by Andrew Green (Post 1417316)

It means you still have a "casino_cash" field in your user table, you can remove it through phpmyadmin.

It's not there...I even did a search and it came up empty :(

Andrew Green

01-07-2008 06:08 PM

pretty sure it's there, would likely be the last column in the table.

But you can also do this, find these lines in the product_casino.xml file (line 140 / 141)

Code:

$query = "ALTER TABLE ". TABLE_PREFIX . "user DROP casino_cash";



$db->query_write(($query);

and delete them, then try importing the product again.

tigrattack

01-07-2008 06:23 PM

Quote:

Originally Posted by Andrew Green (Post 1417321)

pretty sure it's there, would likely be the last column in the table.

But you can also do this, find these lines in the product_casino.xml file (line 140 / 141)

Code:

$query = "ALTER TABLE ". TABLE_PREFIX . "user DROP casino_cash";



$db->query_write(($query);

and delete them, then try importing the product again.

Still getting the same error :erm:

Since I'm using an outside credit system (vbcredits), can I delete this line:

$query = "ALTER TABLE ". TABLE_PREFIX . "user ADD casino_cash integer default 250";
$db->query($query);

I deleted that line and it imported fine...thanks

skcyber

01-07-2008 07:37 PM

thank you very much andrew ! it works nice

this hack is better every update ! :D

wolfyman

01-07-2008 08:17 PM

no known issues with the new update?

punchbowl

01-07-2008 08:26 PM

Seems a lot snappier now.

One minor thing is the table just seems a bit big especially in hold'em. Could we tighten it up easily or is that a major thing?

Andrew Green

01-07-2008 08:31 PM

Quote:

Originally Posted by wolfyman (Post 1417396)

no known issues with the new update?

Only thing I've heard back so far is a missing link on the add event page, should point to the new add / edit groups page. It's located here: casino.php?do=sportspool&action=editgroups

Quote:

Originally Posted by punchbowl (Post 1417402)

Seems a lot snappier now.

One minor thing is the table just seems a bit big especially in hold'em. Could we tighten it up easily or is that a major thing?

Not much, 10 players on the screen is going to take up a fair bit of room no matter how it's laid out. The entire board is visible on 1024x768, can always hit the full screen button as well to get a little more. But I don't have any plans to try and shrink it beyond that.

punchbowl

01-07-2008 08:45 PM

Quote:

Originally Posted by Andrew Green (Post 1417403)

Only thing I've heard back so far is a missing link on the add event page, should point to the new add / edit groups page. It's located here: casino.php?do=sportspool&action=editgroups

Not much, 10 players on the screen is going to take up a fair bit of room no matter how it's laid out. The entire board is visible on 1024x768, can always hit the full screen button as well to get a little more. But I don't have any plans to try and shrink it beyond that.

i'm on 1280x800 and it doesn't - i have a couple of toolbars. No big deal at all just thought there was a bit of excess space up top.

Oh and if someones name is john's_mate then their name will appear as john\\'s_mate at the table and john\'s_mate in the text window.

Again very minor. Anyway I've left the members loose on it some if they can't break it no one can:D

I'd love the sporting pool to be thread based. People won't see the bets otherwise.

I'll probably give it a go on 3.7 in about 2 weeks too.

Great work and happy new year.

Freesteyelz

01-07-2008 10:16 PM

Quote:

Originally Posted by Andrew Green (Post 1417110)

Editing groups looks like a missing link, go to: casino.php?do=sportspool&action=editgroups to add / edit.

In my test I didn't get the effect you get for #1, but I'll try a few other things when I have more time.

In Template casino_sportspool_main I've changed (in red):

Code:

<if condition="! $recentevents">

<tr>

<td style='text-align:center' class='alt1'>

<a href='casino.php?do=sportspool&action=editgroups'>Edit Groups</a>

&nbsp;&nbsp;

<a href='casino.php?do=sportspool&action=addevent'>$vbphrase[casino_addevent]</a>

</td>

</tr>

</if>

Friendly suggestion: $vbphrase[casino_edit_group] should be added in next release. :)

----------------------

1) The #1 issue of edting events (adding the last option in all blank option fields) is confirmed (at least by me :D). I've done an upgrade, several fresh installs, dropped all Casino tables in process to start fresh with all the same result. *Attachments below.

2) I also confirmed that when adding an event and leaving out a required field (ex. didn't select group), the entries (questions and answers) are cleared.

----------------------

3) The ability to remove groups is non-existent.

----------------------

I've been testing it on vB versions 3.6.4, 3.6.8 and 3.7 Beta 3. :)

Again, I hope you don't mind my postings. I know you work very hard on this script and it's much appreciated. I just want to help if I can. :)

All times are GMT. The time now is 06:45 AM.

Page 246 of 353

246

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04841 seconds Memory Usage 1,756KB 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 (3)bbcode_code_printable (7)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (6)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)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
Messages: