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.

[Andreas]

When I ran that query after upgrading vB from 3.0.1 to 3.5.0, and upgrading Bookie as well, it reset everyone to 500. Not sure how or why.

That's default behaviour of the Install Code for a fresh install (it can't detect that a 3.0 Version was already installed, so it is a fresh install).

To avoid this, edit the XML and remove/comment out

PHP Code:

if ($installed_version === null)
{
    $db->query_write("UPDATE " . TABLE_PREFIX . "user SET vbookie_cash=500");
    $db->query_write("INSERT INTO " . TABLE_PREFIX . "vbookie_news (news_text,news_type,news_time) VALUES('vBookie installed!','general',".mktime().")");
} 


before you are importing it.

[wcbryant]

I see. Not a big deal since I still have all the old vCash data in the old database.

Obviously it's above and beyond providing support for the hack, but can you suggest a way I might pull that vbookie_cash data out of the one dbase, and import it as ucash into the live one?

Thanks again, Kirby, apologies for all the questions.

[Andreas]

If you are lucky and have mySQL 4:
- Copy the User Table to another Table incl. Data
- In this new Table, drop all columns except Userid and vbookie_cash (optional)
- Export this new Table
- Import the exported Table in the other Database
- [sql]update user, imported_user_copy set user.vbookie_cash=imported_user_copy.vbookie_cash where user.userid=imported_user_copy.userid[/sql]

... or write an ImpEx Module for it

[Kurisu]

That's strange. I installed uCash and vBookie, set all required settings and permissions but I'm not able to post vBookie Events. All vBookie Event permissions of the administrator group are set to "yes", yet I don't get the option to post a vBookie Event with a new thread.
I got curious and set the member's usergroup permissions to "yes", logged in with a user account and got the option "post a vBookie Event with this thread". But I didn't got to set-up a vBookie Event either...

[Andreas]

Check your Permissions.
When you checked he Box, did a Form to post an Event come up afterwards?

[Kurisu]

I triple checked the permissions.

I tried again and now it worked for my user account (the form came up) but not for my admin account, although both should have the same permissions.

[Andreas]

Check your Permissions is all I can say.

[Kurisu]

Thought you'd say that *g*
Well, adding a secondary usergroup did the trick.

Btw: How do I chance the "vBookie:" before a thread?

[Andreas]

Phrase vbookie_event_thread_prefix in Phrasegroup Forum Display

[Kurisu]

Thanks
Now it's working finde