vb.org Archive
Page 76 of 108 « First 26667475 76 777886 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Add-On Releases - vBookie for vBulletin 4 (https://vborg.vbsupport.ru/showthread.php?t=233473)

dartho 01-04-2012 01:27 PM
eDIT THE VCASH PHRASE i THINK (oops - caps lock)

EasyEazy 01-07-2012 10:28 AM
Is there a solution for removing the navbar tab but not the subnav options?

I tried both in the options and the plug in but its removes the sub nav options.

Thanks in advance

Killabee 01-12-2012 12:13 AM
Running 4.1.9 vbulletin

installed mod and once filling out all information and trying to submit the event i get the following error message.

Code:
Database error in vBulletin 4.1.9:

Invalid SQL:
UPDATE vb_user SET credits=6 WHERE credits < 6;

MySQL Error  : Unknown column 'credits' in 'where clause'
Error Number  : 1054
Request Date  : Wednesday, January 11th 2012 @ 06:06:16 PM
Error Date    : Wednesday, January 11th 2012 @ 06:06:16 PM
Script        : http://***********.com/vbookie.php
Referrer      : http://**********.com/vbookie.php
IP Address    : *************
Username      : *******
Classname    : vB_Database_MySQLi
MySQL Version : 5.1.60-community-log

dartho 01-12-2012 02:29 AM
looks like a vbcredits or otehr money add-on integration issue

Killabee 01-13-2012 02:35 AM
does this work with vbplaza / vbbux?

dartho 01-13-2012 05:12 AM
Hooks are there so that others can integrate with it - check with the developers

acast 01-15-2012 02:16 PM
Edit: It is working the code por Functions_vbookie.php to integrate vbbux in Custom.

Code:
<?php
// Last updated version 4.0.7 19-02-2010 10:07


function vbookie_get_user_bet_count($item_id=0)
{
        global $vbulletin;

        $user_n_bets_placed_result = $vbulletin->db->query_first("
                SELECT COUNT(bet_id) AS user_n_bets_placed
                FROM " . TABLE_PREFIX . "vbookie_bets_placed
                WHERE userid = " . $vbulletin->userinfo['userid'] . " AND item_id = $item_id
        ");
       
        return (int)$user_n_bets_placed_result['user_n_bets_placed'];

}

function vbookie_get_user_cash()
{
        global $vbulletin;

        switch ($vbulletin->options['vbookiecash'])
        {
                case 'vCash':
                        $cash = (int)$vbulletin->userinfo['vbookie_cash'];
                        break;
                case 'uCash':
                        $cash = (int)$vbulletin->userinfo['ucash'];
                        break;
                case 'eBux':
                        $cash = (int)$vbulletin->userinfo['ebux'];
                        break;
                case 'vbCredits':
                        $cash = (int)$vbulletin->userinfo['credits'];
                        break;
                case 'Reputation':
                        $cash = (int)$vbulletin->userinfo['reputation'];
                        break;
                case 'Custom':
                        $cash = (int)$vbulletin->userinfo['vbbux'];
                        break;
               
        }
       
        return $cash;
}

function vbookie_take_user_cash($amount)
{
        global $vbulletin;

        switch ($vbulletin->options['vbookiecash'])
        {
                case 'vCash':
                        $vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET vbookie_cash=vbookie_cash-$amount WHERE userid=" . $vbulletin->userinfo['userid']);       
                        break;
                case 'uCash':
                        $vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET ucash=ucash-$amount WHERE userid=" . $vbulletin->userinfo['userid']);       
                        break;
                case 'eBux':
                        $vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET ebux=ebux-$amount WHERE userid=" . $vbulletin->userinfo['userid']);       
                        $cash = (int)$vbulletin->userinfo['ebux'];
                        break;
                case 'vbCredits':
                        $vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET credits=credits-$amount WHERE userid=" . $vbulletin->userinfo['userid']);       
                        $cash = (int)$vbulletin->userinfo['credits'];
                        break;
                case 'Reputation':
                        $vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET reputation=reputation-$amount WHERE userid=" . $vbulletin->userinfo['userid']);       
                        $cash = (int)$vbulletin->userinfo['reputation'];
                        break;
                case 'Custom':
                        $vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET vbbux=vbbux-$amount WHERE userid=" . $vbulletin->userinfo['userid']);       
                        $cash = (int)$vbulletin->userinfo['vbbux'];
                        break;
               
        }
}

function vbookie_give_user_cash($userid, $amount)
{
        global $vbulletin;

        switch ($vbulletin->options['vbookiecash'])
        {
                case 'vCash':
                        $vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET vbookie_cash=vbookie_cash+$amount WHERE userid=$userid");       
                        break;
                case 'uCash':
                        $vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET ucash=ucash+$amount WHERE userid=$userid");       
                        break;
                case 'eBux':
                        $vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET ebux=ebux+$amount WHERE userid=$userid");       
                        $cash = (int)$vbulletin->userinfo['ebux'];
                        break;
                case 'vbCredits':
                        $vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET credits=credits+$amount WHERE userid=$userid");       
                        $cash = (int)$vbulletin->userinfo['credits'];
                        break;
                case 'Reputation':
                        $vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET reputation=reputation+$amount WHERE userid=$userid");       
                        $cash = (int)$vbulletin->userinfo['reputation'];
                        break;
                case 'Custom':
                        $vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET vbbux=vbbux+$amount WHERE userid=$userid");       
                        $cash = (int)$vbulletin->userinfo['vbbux'];
                        break;
               
        }
}

function vbookie_abandon_event($item_id=0)
{
        global $vbulletin;

        if ((int)$item_id)
        {
                $q = "UPDATE ". TABLE_PREFIX . "vbookie_items SET item_status='ABANDONED' WHERE item_id=$item_id";
                $vbulletin->db->query($q);

                // update running totals
                $q = "UPDATE " . TABLE_PREFIX . "vbookie_item_options SET option_amount_staked=0, option_n_bets_placed=0 WHERE item_id=$item_id";       
                $vbulletin->db->query($q);

                // update running totals
                $q = "UPDATE " . TABLE_PREFIX . "vbookie_items SET item_n_bets_placed=0, item_amount_staked=0 WHERE item_id=$item_id";       
                $vbulletin->db->query($q);

                $result = $vbulletin->db->query_read("SELECT p.userid, p.bet_amount_placed FROM " . TABLE_PREFIX . "vbookie_bets_placed AS p LEFT JOIN " . TABLE_PREFIX . "user AS u ON(u.userid = p.userid) WHERE p.item_id=$item_id");

                while ($bet = $vbulletin->db->fetch_array($result))
                {
                        // pay the money back
                        vbookie_give_user_cash($bet['userid'], $bet['bet_amount_placed']);
                }
        }
}

function vbookie_get_richest()
{
        global $vbulletin;

        switch ($vbulletin->options['vbookiecash'])
        {
                case 'vCash':
                        $q = "SELECT username, vbookie_cash AS cash FROM " . TABLE_PREFIX . "user ORDER BY cash DESC LIMIT 5";       
                        break;
                case 'uCash':
                        $q = "SELECT username, ucash AS cash FROM " . TABLE_PREFIX . "user ORDER BY cash DESC LIMIT 5";       
                        break;
                case 'eBux':
                        $q = "SELECT username, ebux AS cash FROM " . TABLE_PREFIX . "user ORDER BY cash DESC LIMIT 5";       
                        break;
                case 'vbCredits':
                        $q = "SELECT username, credits AS cash FROM " . TABLE_PREFIX . "user ORDER BY cash DESC LIMIT 5";       
                        break;
                case 'Reputation':
                        $q = "SELECT username, reputation AS cash FROM " . TABLE_PREFIX . "user ORDER BY cash DESC LIMIT 5";       
                        break;
                case 'Custom':
                        $q = "SELECT username, vbbux AS cash FROM " . TABLE_PREFIX . "user ORDER BY cash DESC LIMIT 5";       
                        break;
       
        }

        return $vbulletin->db->query_read($q);
}

function vbookie_do_charity()
{
        global $vbulletin;


        if ($vbulletin->options['vbookiegivetopoor'])
        {
                switch ($vbulletin->options['vbookiecash'])
                {
                        case 'vCash':
                                $vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET vbookie_cash=" . $vbulletin->options['vbookiegivetopoor'] . " WHERE vbookie_cash < " . $vbulletin->options['vbookiegivetopoor']);       
                                break;
                        case 'uCash':
                                $vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET ucash=" . $vbulletin->options['vbookiegivetopoor'] . " WHERE ucash < " . $vbulletin->options['vbookiegivetopoor']);       
                                break;
                        case 'eBux':
                                $vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET ebux=" . $vbulletin->options['vbookiegivetopoor'] . " WHERE ebux < " . $vbulletin->options['vbookiegivetopoor']);       
                                break;
                        case 'vbCredits':
                                $vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET credits=" . $vbulletin->options['vbookiegivetopoor'] . " WHERE credits < " . $vbulletin->options['vbookiegivetopoor']);       
                                break;
                        case 'Reputation':
                                $vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET reputation=" . $vbulletin->options['vbookiegivetopoor'] . " WHERE reputation < " . $vbulletin->options['vbookiegivetopoor']);       
                                break;
                        case 'Custom':
                                $vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET vbbux=" . $vbulletin->options['vbookiegivetopoor'] . " WHERE vbbux < " . $vbulletin->options['vbookiegivetopoor']);       
                                break;
               
                }
        }
}

function vbookie_delete_event($eventinfo)
{
        global $vbulletin;
        ($hook = vBulletinHook::fetch_hook('vbookie_delete_event')) ? eval($hook) : false;
        // if we're deleting an event that has bets on it but hasn't yet been settled,
        // we must give people their money back.
        if ($eventinfo['item_status'] == 'OPEN' OR $eventinfo['item_status'] == 'CLOSED')
        {
                // abandon the bet
                vbookie_abandon_event($eventinfo['item_id']);
        }

        $vbulletin->db->query_write("DELETE FROM ". TABLE_PREFIX . "vbookie_bets_placed WHERE item_id=$eventinfo[item_id]");
        $vbulletin->db->query_write("DELETE FROM ". TABLE_PREFIX . "vbookie_item_options WHERE item_id=$eventinfo[item_id]");
        $vbulletin->db->query_write("DELETE FROM ". TABLE_PREFIX . "vbookie_items WHERE item_id=$eventinfo[item_id]");

        // update the thread this was attached to to remove the event.
        $vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "thread SET vbookie_item_id=0 WHERE vbookie_item_id=$eventinfo[item_id]");
}

function vbookie_reset_vcash($amount)
{
        global $vbulletin;
                $q = "UPDATE " . TABLE_PREFIX . "user SET vbookie_cash =".$amount;       
        return $vbulletin->db->query($q);
               
       
}

function vbookie_set_default_vcash($amount)
{
        global $vbulletin;
                $q = "ALTER TABLE " . TABLE_PREFIX . "user CHANGE COLUMN vbookie_cash vbookie_cash BIGINT(20) UNSIGNED NULL DEFAULT ".$amount;       
        return $vbulletin->db->query($q);
}

function vbookie_give_users_vcash($amount)
{
        global $vbulletin;
                $q="UPDATE " . TABLE_PREFIX . "user SET vbookie_cash=vbookie_cash+$amount";
        return $vbulletin->db->query($q);

}
// Additional pay/debit bookie
function vbookie_take_bookie_cash($userid, $amount)
{
        global $vbulletin;

        $bookie = $vbulletin->db->query_first("SELECT * FROM " . TABLE_PREFIX . "user WHERE userid=$userid");

        switch ($vbulletin->options['vbookiecash'])
        {
                case 'vCash':
               
               
                        if($amount > $bookie['vbookie_cash'])
                        {
                                $vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET vbookie_cash=0 WHERE userid=$userid");
                        }
                        else
                        {
                                $vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET vbookie_cash=vbookie_cash-$amount WHERE userid=$userid");
                        }
                        break;
                case 'uCash':
                        if($amount > $bookie['ucash'])
                        {
                                $vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET ucash=0 WHERE userid=$userid");
                        }
                        else
                        {
                                $vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET ucash=ucash-$amount WHERE userid=$userid");
                        }
                        break;
                case 'eBux':
                        if($amount > $bookie['ebux'])
                        {
                                $vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET ebux=0 WHERE userid=$userid");
                        }
                        else
                        {
                                $vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET ebux=ebux-$amount WHERE userid=$userid");
                        }
                        break;
                case 'Custom':
                                if($amount > $bookie['vbbux'])
                        {
                                $vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET vbbux=0 WHERE userid=$userid");
                        }
                        else
                        {
                                $vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET vbbux=vbbux-$amount WHERE userid=$userid");
                        }
                        break;
        }
}
?>

ukgamblingforum 01-23-2012 10:33 PM
Freshly installed on 4.0.4 - didn't do any template edits as instructed, activated everything, set usergroups ok and i still am not seeing anything under threads to create a bookie event (however i DO see a vbulletin menu up top).

When i go into usergroup perms for admins / supermods (groups who should be able to create events) - vbookie/vbulletin won't save the allow vbulletin options. HELP.!

ProFifaLeagues 01-23-2012 10:37 PM
Quote:
Originally Posted by ukgamblingforum (Post 2291552)
Freshly installed on 4.0.4 - didn't do any template edits as instructed, activated everything, set usergroups ok and i still am not seeing anything under threads to create a bookie event (however i DO see a vbulletin menu up top).

When i go into usergroup perms for admins / supermods (groups who should be able to create events) - vbookie/vbulletin won't save the allow vbulletin options. HELP.!

rebuild bit fields.... append this to your forums domain ...

/admincp/index.php?do=buildbitfields __________________:up:

dartho 01-24-2012 05:08 AM
Quote:
Originally Posted by ukgamblingforum (Post 2291552)
Freshly installed on 4.0.4 - didn't do any template edits as instructed, activated everything, set usergroups ok and i still am not seeing anything under threads to create a bookie event (however i DO see a vbulletin menu up top).

When i go into usergroup perms for admins / supermods (groups who should be able to create events) - vbookie/vbulletin won't save the allow vbulletin options. HELP.!
You create a new thread, and just around the usual "add poll to thread" check box, there should be an add vbokie event to trhead option


All times are GMT. The time now is 01:00 AM.
Page 76 of 108 « First 26667475 76 777886 Last »
Show 40 post(s) from this thread on one page

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.02089 seconds
  • Memory Usage 1,820KB
  • 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
  • (2)bbcode_code_printable
  • (2)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
  • (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