AddOn vBookie Actionset

[kyle]

You should probably edit the template to change that sentence - it wont load the amount you have because of the multiple currency issue I said above. It got halbucks from the phrase for vCash you are using. Ignore the amount it says and try placing your bet anyway.

I was unaware they added vBCredits as an option - in any case it should say Custom so that vbcredits handles the multiple currency functionality. The "Currency Amount" setting is for applying effectively fees or bonuses if you set the event to charging or not respectively.

Okay, my question is along the lines of what you mentioned. Just got back into vbcredits II deluxe lite after removing the old vbcredits and have so far got everything working. Now setting up vbookie with the actionset. So far so good.

Now when you look at a bet created with vbookie right below where it says "This event will pay out after 09-25-2010 at 05:00 AM" you get this:

You have 1 chip and have placed 0 bet(s) on this Event.
You may bet more than once on this Event.

(Edited the phrase vbookie_may_bet - cash to chip)

This is the code from vbookie events table for the above:

<div class="blockrow" align="center">
<div class="blockbody" style="width:{vb:stylevar form_maxWidth}" align="left">
<div align="center">{vb:rawphrase vbookie_may_bet{vb:raw user_cash},{vb:raw user_n_bets_placed}}<br />
{vb:raw maybet_times}
</div>

We have a currency of chips set up for bets, using credits_chips for the column. Is there any way to be able to pull the chip amount so it would display here - {vb:raw user_cash}

I can just remove this if not possible as the users will have their amounts in the postbit display but just wanted to ask first if this could be done.


Hope this made sense.

 

[Darkwaltz4]

Due to the way that vbcredits II allows multiple currencies to be tied to an event, there isnt a way that it can be done reliably (even if you are using just one currency). The best option is to just remove that from the template (or edit the phrase)

 

[kyle]

Thanks for the reply, I did remove it from the template and it should be okay as members can see the exact amounts they have to bet by using the currency dropdown.

 

[kyle]

Okay, another puzzlement. Had a bet set up that one admin and one registered member bet on. Settled the bet and the admin's account was credited with the proper win amount, but the one registered members win amount was not added to his total. This was the first bet finished since getting vbookie working with vbcredits II deluxe. I made a test bet and used a registered test account and the bets winning amount was credited to the account so at least this tells me the usergroup settings for our registered members are okay. For now had to manually add the win to the members account. Cant figure out why the win wasn't credited to the registered members account. The bet amount was taken from his account with no problems, this showed checking the records.

 

[Darkwaltz4]

I am assuming you have immediate transactions turned off, in which case the user needed to log in to update his pending transactions (and receive the payout).

 

[kyle]

We have process transactions in real time set to yes. It works as the admin was paid instanltly but the member was not. I have some to settle today so will see if it happens again.

 

[Chase]

So I can't use vbookie 1.0.7 with vbcredits deluxe? I'm on 3.8.4

 

[Bravo]

Anyway this can record to the transaction logs also?

 

[Darkwaltz4]

So I can't use vbookie 1.0.7 with vbcredits deluxe? I'm on 3.8.4

only the latest version contains the hooks that vbcredits II needs to properly integrate. Otherwise, the old way will still work (without logs) if you kept the default credits currency.

Anyway this can record to the transaction logs also?

it will with this actionset, not with the built-in integration

 

[Bravo]

I see, but when using this actionset I get a DB error.

Database error in vBulletin 4.1.0:

Invalid SQL:
SELECT user.userid, (0 + (user.credits * 1) + (user.dbtech_vbactivity_points * 1)) AS cash FROM user AS user WHERE cash < 25;

MySQL Error : Unknown column 'cash' in 'where clause'

If I switch the Cash/Points System to "vbcredit" it works, but as you stated no logs. Any ideas what is causing this error?

 

[Darkwaltz4]

I see, but when using this actionset I get a DB error.

Database error in vBulletin 4.1.0:

Invalid SQL:
SELECT user.userid, (0 + (user.credits * 1) + (user.dbtech_vbactivity_points * 1)) AS cash FROM user AS user WHERE cash < 25;

MySQL Error : Unknown column 'cash' in 'where clause'

If I switch the Cash/Points System to "vbcredit" it works, but as you stated no logs. Any ideas what is causing this error?

Seems the charity query is not correct.

Edit the vBCredits II - Charity plugin and replace

$poor = $vbulletin->db->query_read("SELECT user.userid,  (0$hook_query_fields) AS cash FROM " . TABLE_PREFIX . "user AS user  $hook_query_joins WHERE cash < " .  $vbulletin->options['vbookiegivetopoor']);

with

$poor = $vbulletin->db->query_read("SELECT user.userid,  (0$hook_query_fields) AS cash FROM " . TABLE_PREFIX . "user AS user  $hook_query_joins WHERE (0$hook_query_fields) < " .  $vbulletin->options['vbookiegivetopoor']);

 

[FreshFroot]

I have to say I am a bit disappointed that there is no integration for vB3.8.x.

I tried today and got the same error as a few mentioned though I am using the latest vBookie for 3.8.

Is there no other way to integrate it with vBCredits? Seems like the vB3 users got the low end of the deal for this mod.

 

[rootsxrocks]

Seems the charity query is not correct.

Edit the credits II - Charity plugin and replace

$poor = $vbulletin->db->query_read("SELECT user.userid,  (0$hook_query_fields) AS cash FROM " . TABLE_PREFIX . "user AS user  $hook_query_joins WHERE cash < " .  $vbulletin->options['vbookiegivetopoor']);

with

$poor = $vbulletin->db->query_read("SELECT user.userid,  (0$hook_query_fields) AS cash FROM " . TABLE_PREFIX . "user AS user  $hook_query_joins WHERE (0$hook_query_fields) < " .  $vbulletin->options['vbookiegivetopoor']);

I am going to go have a look at this, but I am going to assume it was corrected in the latest version.
I think I have separated my currencies but using the custom selection payouts generate a PM but do not seem to be reflected in the balance.
I also wonder if gameroom generates anything in the log. I can't imagine it recording every pull of the slot machine but perhaps a session total would show were the money went.
I have sent dark a admin log on so he might see what I am doing wrong and guide me toward enlightenment.

 

[rootsxrocks]

I have to say I am a bit disappointed that there is no integration for vB3.8.x.

I tried today and got the same error as a few mentioned though I am using the latest vBookie for 3.8.

Is there no other way to integrate it with vBCredits? Seems like the vB3 users got the low end of the deal for this mod.

Had you garnered the experience of us "suckers" who upgraded to 4.x you would not be complaining . besides I really don't think its fair to Diss vb-credits deluxe for the shortcomings of vbookie 3.8.
I am still waiting to know if vb 4 has messed up the bases for credits working access 3rd party mods by"changing the hooks"

 

[rootsxrocks]

I suppose this is the best place to bring this back up, I am having issues with this once again were it did appear to work for a while and suddenly stopped without me doing any changes. I am going to revert it to the custom settings and look for the problem again as I was out of town when it occurred and wasn't able to spend my family time on a fix.

 

[Cosmic]

I suppose this is the best place to bring this back up, I am having issues with this once again were it did appear to work for a while and suddenly stopped without me doing any changes. I am going to revert it to the custom settings and look for the problem again as I was out of town when it occurred and wasn't able to spend my family time on a fix.

Is it possible you could re-create this as a new issue? The new system makes sure issues are tracked and the correct people are notified etc ^.^

Cheers,

Cosmic

 

[Darkwaltz4]

If you use the latest hotfixed version of vbc from your customer area, it should bring compatibility of this integration closer.

 

[rootsxrocks]

Well I did make a change that I didn't notice I had changed the charity to 1 and that did it. I reverted and it seems to work great again. Now I am tempted to do that mod I see at .org were the bookie collects and pays that would be great if it will work with a secondary credit.