vBookie for vBulletin 3.5

vBookie

Introduction

This is a Port of the original vBookie Hack created by tdjrico; full credits to him for the idea and the kind permission to port his work

A t t e n t i o n
This Hack is unsopported and incompatible with vBulletin 3.6+
You are hereby advised to not use it.
Please do not ask me about support and/or updates - there will be none.

[dartho]

I said unsupported, but ...

I think I see what the problem is there, you've obviously lost and gone into negative but the vcash column is unsigned. You need to make teh vbookie_cash column on the user table signed. Make it a bigint(20) and you should have plenty of scope for growth ...?
SQL Command:

ALTER TABLE `user` CHANGE `vbookie_cash` `vbookie_cash` BIGINT( 20 ) NULL DEFAULT '500'

or do it via PhpMyAdmin

[BenWCF]

Originally Posted by dartho

I said unsupported, but ...

I think I see what the problem is there, you've obviously lost and gone into negative but the vcash column is unsigned. You need to make teh vbookie_cash column on the user table signed. Make it a bigint(20) and you should have plenty of scope for growth ...?
SQL Command:

ALTER TABLE `user` CHANGE `vbookie_cash` `vbookie_cash` BIGINT( 20 ) NULL DEFAULT '500'

or do it via PhpMyAdmin

thanks for your help.

where do I find vbookie_cash within the admincp?

[dartho]

not in your admincp - in your database

[BenWCF]

Originally Posted by dartho

not in your admincp - in your database

can i not access the database through the admincp or is it something i have to do through ftp?

I apologise for all the questions - I've never dealt with anything like this before.

[BenWCF]

right, I've been looking around on here, logged onto my hosts cpanel and put that bit of code into the Phpmyadmin section.

I now have a total of 9223372036854775807.

Where have I gone wrong now?

[dartho]

That sounds right - that number is half of the previous balance as a bit is now use for the sign. Now change your balance to what you want by editing the 'user_cash' figure against your name in the user table of your database. You could manually work out how much people won against you if you want it to be accurate, or just start with 500 again

[BenWCF]

where is the user table situated so i can edit it?

[dartho]

In your database - use phpmyadmin in cPanel

[nickk96]

Removed.

[nickk96]

Removed.