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.

[djwins]

Originally Posted by mclark2112

Is there any way to retain my users old vCash from before the 3.5 upgrade? I haven't updated vBookie yet, so I'm sure it is still in the database.

Originally Posted by xug

Yeah, any info for people who have this already in their database?

Any upgrade path for people using the pre-3.5vB version?

[Adam21]

thanks to psybernaut,i've vbookie events paying out from the vbookies themselves.works great!thanks alot!

[Baudman]

I just installed this hack and can't get it to except my attempts to change the usergroups permissions. I click on a usergroup and set everything to yes and then save it. It says it saves but then I check to see if its set to yes and they arn't. Has anyone else had this proble? or am I doing something wrong?

[Andreas]

> Has anyone else had this proble?
Everyone has because the install code is "broken".
Just import the XML again and select override

[Baudman]

Originally Posted by Andreas

> Has anyone else had this proble?
Everyone has because the install code is "broken".
Just import the XML again and select override

thanks I acually found another thread that said to rebuild the bitfields and it worked. My only other question is how do I delete an event from the event list? I have deleted the original thread but it still shows on the list.

[Andreas]

Should have been deleted too, though as it has not been deleted ... not possible.

[VodkaFish]

On the main vbookie page, the dropdown to show different events:
Currently showing * Events. Switch to * Events
If you choose "settled", it brings my forum down. mysql gets a too many connections error. I do have a lot of settled events, but I can't understand why one query would bring it down. Either way, just thought I'd report it. I took the option off of my forums for the meantime. I'm using the latest version of vbookie.

[Andreas]

Edit vbookie.php and replace

PHP Code:

LEFT JOIN " . TABLE_PREFIX . "thread AS thread ON thread.vbookie_item_id = item.item_id 


with

PHP Code:

LEFT JOIN " . TABLE_PREFIX . "thread AS thread ON (thread.threadid = item.threadid) 


[sql]ALTER TABLE vbookie_items ADD INDEX (item_status);
UPDATE vbookie_items, thread SET vbookie_items.threadid=thread.threadid WHERE thread.vbookie_item_id=vbookie_items.item_id;
[/sql]
Execute these queries and check if it does help.

[Freesteyelz]

I'm currently testing this mod. I think you've done an awesome job, Andreas. Is it possible to add (either in XML or SQL Query) variance in the amount of cash (default 500) by Usergroup upon registration and current registries? This is what I'm thinking:

In XML:

$db->query_write("ALTER TABLE " . TABLE_PREFIX . "user ADD vbookie_cash BIGINT UNSIGNED DEFAULT '500' AFTER pmunread WHERE usergroupid='x'");
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "user ADD vbookie_cash BIGINT UNSIGNED DEFAULT '1500' AFTER pmunread WHERE usergroupid='y'");
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "user ADD vbookie_cash BIGINT UNSIGNED DEFAULT '5000' AFTER pmunread WHERE usergroupid='z'");

And:

	$db->query_write("UPDATE " . TABLE_PREFIX . "user SET vbookie_cash=500" WHERE usergroupid='x');
	$db->query_write("UPDATE " . TABLE_PREFIX . "user SET vbookie_cash=1500" WHERE usergroupid='y');
	$db->query_write("UPDATE " . TABLE_PREFIX . "user SET vbookie_cash=5000" WHERE usergroupid='z');

Where "x", "y" and "z" are the specified UserIDs will be set. I realize that there isn't a "usergroupid" TABLE but I'm not sure of the workaround.

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

EDITED: I modified the code bit and this part worked in SQL Query. Well, sort of. It only changes curent registered members upon usergroupid definition. New registries still inherit default vcash settings:

UPDATE user SET vbookie_cash='500' WHERE usergroupid='x';
UPDATE user SET vbookie_cash='1000' WHERE usergroupid='y';
UPDATE user SET vbookie_cash='5000' WHERE usergroupid='z';

For ALTER TABLE in SQL Query I'm trying to figure out this:

ALTER TABLE vbtest_user ADD vbookie_cash BIGINT UNSIGNED DEFAULT '5000' WHERE usergroupid='z' AFTER pmunread;

I'm getting a syntax error at "WHERE usergroupid='z'". Then again, do I need this portion for new and current registries to work properly?

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

Edited Again: I could set SQL Query for userids such as:

UPDATE vbtest_user SET vbookie_cash='5000' WHERE userid='z';

Although I'd prefer doing it mass in XML or SQL Query. If it's not possible, by setting individual variance in SQL Query will it create a DB problem?

[majoreyeswater]

Love this mod, adds such value to my board.

Wondering if might be able to get a bit of help.

A member created an event in vBookie, then my some mistake, they deleted the thread before they had closed the event.

The event is now still listed in vBookie, and can't be closed or deleted.

Any help appreciated.