vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   vBookie - vBulletin Betting Hack (https://vborg.vbsupport.ru/showthread.php?t=65844)

djohn 06-06-2004 05:03 PM

Awesome. Before i install this, does it have any group and forum specific permissions, so that only specified groups can bet or post vBookie events in specified forums?

tjdrico 06-06-2004 05:19 PM

Quote:

Originally Posted by djohn
Awesome. Before i install this, does it have any group and forum specific permissions, so that only specified groups can bet or post vBookie events in specified forums?

Yes. You can use the standard permissions system to grant/revoke rights to:

- add/edit an event
- edit someone else's events
- bet on events

These can be applied to user groups, or turned on/off on specific forums.

On my forums I have Registered Users allowed to bet, Bookies allowed to add/edit anyone's, and Restricted Bookies allowed to add/edit their own.

tjdrico 06-06-2004 05:33 PM

Just updated for 1.0.2 which is a minor fix. I tidied up some stuff and deleted something I shouldn't have. Just upload the includes/functions_vbookie.php file, or do the following change:

Find:

PHP Code:

function vbookie_do_charity()
{
    global 
$DB_site$vbookiesettings

Change to:

PHP Code:

function vbookie_do_charity()
{
    global 
$DB_site$vboptions$vbookiesettings

This would only have affected you if you had the "charity mode" on, and had any users with less than 25 money.

Wolffman 06-06-2004 07:25 PM

When I tried to edit the permissions this came up:

Code:

Database error in vBulletin 3.0.1:

Invalid SQL: UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
        title = 'Members',
        description = '',
        usertitle = '',
        opentag = '',
        closetag = '',
        passwordexpires = '0',
        passwordhistory = '0',
        attachlimit = '0',
        canpostvbookieevent = '1',
        caneditothersvbookieevents = '1',
        canbet = '1',
        avatarmaxwidth = '150',
        avatarmaxheight = '150',
        avatarmaxsize = '50000',
        profilepicmaxwidth = '200',
        profilepicmaxheight = '200',
        profilepicmaxsize = '65535',
        pmquota = '40',
        pmsendmax = '5',
        uttstore_discount = '0',
        forumpermissions = '127487',
        pmpermissions = '3',
        calendarpermissions = '17',
        wolpermissions = '1',
        adminpermissions = '0',
        genericpermissions = '7879',
        genericoptions = '30',
        shoutboxpermissions = '0',
        siguploaderpermissions = '0',
        arcadepermissions = '0'
WHERE usergroupid=2
mysql error: Unknown column 'canpostvbookieevent' in 'field list'

mysql error number: 1054


tjdrico 06-06-2004 07:45 PM

Quote:

Originally Posted by Wolffman
When I tried to edit the permissions this came up:

Code:

Database error in vBulletin 3.0.1:

Invalid SQL: UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
        title = 'Members',
        description = '',
        usertitle = '',
        opentag = '',
        closetag = '',
        passwordexpires = '0',
        passwordhistory = '0',
        attachlimit = '0',
        canpostvbookieevent = '1',
        caneditothersvbookieevents = '1',
        canbet = '1',
        avatarmaxwidth = '150',
        avatarmaxheight = '150',
        avatarmaxsize = '50000',
        profilepicmaxwidth = '200',
        profilepicmaxheight = '200',
        profilepicmaxsize = '65535',
        pmquota = '40',
        pmsendmax = '5',
        uttstore_discount = '0',
        forumpermissions = '127487',
        pmpermissions = '3',
        calendarpermissions = '17',
        wolpermissions = '1',
        adminpermissions = '0',
        genericpermissions = '7879',
        genericoptions = '30',
        shoutboxpermissions = '0',
        siguploaderpermissions = '0',
        arcadepermissions = '0'
WHERE usergroupid=2
mysql error: Unknown column 'canpostvbookieevent' in 'field list'

mysql error number: 1054


According to my local mySQL, those columns shouldn't be in usergroup anyway:

Code:

mysql> show columns from vb_usergroup;
+---------------------+----------------------+------+-----+---------+----------------+
| Field              | Type                | Null | Key | Default | Extra          |
+---------------------+----------------------+------+-----+---------+----------------+
| usergroupid        | smallint(5) unsigned |      | PRI | NULL    | auto_increment |
| title              | varchar(100)        |      |    |        |                |
| description        | varchar(250)        |      |    |        |                |
| usertitle          | varchar(100)        |      |    |        |                |
| passwordexpires    | smallint(5) unsigned |      |    | 0      |                |
| passwordhistory    | smallint(5) unsigned |      |    | 0      |                |
| pmquota            | smallint(5) unsigned |      |    | 0      |                |
| pmsendmax          | smallint(5) unsigned |      |    | 5      |                |
| pmforwardmax        | smallint(5) unsigned |      |    | 5      |                |
| opentag            | varchar(100)        |      |    |        |                |
| closetag            | varchar(100)        |      |    |        |                |
| canoverride        | smallint(5) unsigned |      |    | 0      |                |
| ispublicgroup      | smallint(5) unsigned |      |    | 0      |                |
| forumpermissions    | int(10) unsigned    |      |    | 0      |                |
| pmpermissions      | int(10) unsigned    |      |    | 0      |                |
| calendarpermissions | int(10) unsigned    |      |    | 0      |                |
| wolpermissions      | int(10) unsigned    |      |    | 0      |                |
| adminpermissions    | int(10) unsigned    |      |    | 0      |                |
| genericpermissions  | int(10) unsigned    |      |    | 0      |                |
| genericoptions      | int(10) unsigned    |      |    | 0      |                |
| pmpermissions_bak  | int(10) unsigned    |      |    | 0      |                |
| attachlimit        | int(10) unsigned    |      |    | 0      |                |
| avatarmaxwidth      | smallint(5) unsigned |      |    | 0      |                |
| avatarmaxheight    | smallint(5) unsigned |      |    | 0      |                |
| avatarmaxsize      | int(10) unsigned    |      |    | 0      |                |
| profilepicmaxwidth  | smallint(5) unsigned |      |    | 0      |                |
| profilepicmaxheight | smallint(5) unsigned |      |    | 0      |                |
| profilepicmaxsize  | int(10) unsigned    |      |    | 0      |                |
| arcadepermissions  | int(10) unsigned    | YES  |    | 0      |                |
| uttstore_discount  | varchar(20)          |      |    | 0      |                |
+---------------------+----------------------+------+-----+---------+----------------+
30 rows in set (0.02 sec)

It looks like you didn't follow the installation instructions correctly. Those three columns (canpostvbookieevent, caneditothersvbookieevents, canbet) should have gone directly below "'canseedelnotice' => 262144," in init.php which would make them part of the 'forumpermissions' group.

I recommend that you go through the installation instructions again, double-checking them against what you've actually done.

Wolffman 06-06-2004 07:57 PM

That was my fault. All I did was forget to add a phrase.

Thanks anyway. :)

tjdrico 06-06-2004 08:02 PM

Quote:

Originally Posted by Wolffman
That was my fault. All I did was forget to add a phrase.

Thanks anyway. :)

Cool! =) Odd error to happen as a result of a missing phrase though.

lordnex 06-06-2004 08:07 PM

Good hack, thanks for posting it! It does take a bit of careful editing as it does go into a few hacks and someone not very observant might overwrite those hacks.

Good job though!

tjdrico 06-06-2004 08:13 PM

Quote:

Originally Posted by lordnex
Good hack, thanks for posting it! It does take a bit of careful editing as it does go into a few hacks and someone not very observant might overwrite those hacks.

I agree. Unfortunately it's impossible to write instructions that cover every available hack, so it's only really possible to write them assuming an 'as new' unhacked installation. If something like v3Arcade has already been added, or uCash perhaps, or Petz, or... or... or... then the instructions might clash; particularly when it comes to bitfield permissions where the next available number in an original installation might be 16, but that might already have been used by another hack. The savvy hacker would know to use 32 instead, but not everyone has such knowledge.

I've tried to stress in the installation instructions the importance of prior backups, but that's advice not everyone will heed. Sensible people would read through all the instructions first, and compare them to their own files before starting, but this is the real world and people aren't that cautious. =)

I think I might update the installation instructions to stress these points though.

Additional:

OK, updated installation instructions:

http://www.kop.nildram.co.uk/images/vbinstall.gif

I think that's about all I can reasonably do. =)

GamerzWorld 06-06-2004 08:49 PM

what do you get to start with? Also can you loose all your cash?


All times are GMT. The time now is 03:31 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.01485 seconds
  • Memory Usage 1,774KB
  • 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
  • (2)bbcode_php_printable
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)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