Major Additions - vbBux / vbPlaza v1.5.8 (Points + Store System)

vbBux / vbPlaza v1.5.8 by CMX (http://www.cmgsccc.com)
Official Homepage - http://www.vbplaza.com

v1.5.7 AND HIGHER are now compatible with vBulletin v3.5.x and v3.6.x

Welcome to the largest points/store system for vBulletin! READ THE ENTIRE POST AGAIN AS THERE HAVE BEEN CHANGES SINCE THE CONVERSION TO vbBux / vbPlaza!!

Credits: MrZeropage for ibProArcade Support, John for v3 Arcade Support, Caimakale for various additions including ribbons and his other addons for vbPlaza, defi for the addon for Paypal Subscriptions.

New Premium Modification Forum: https://vborg.vbsupport.ru/forumdisplay.php?f=171
If you post a new thread in there, it will be easier to track the answer to your thread folks!

Now with 135 Options for purchasing at your forums and this is still rising folks!

NOTE: As of this version, there is a Template Patcher helper inside the Admin CP. Admin CP -> vbPlaza Maintenance -> Auto Patch Templates, when you run this the first time, it will just list the changes that it has found/not found. If you press Attempt Auto Patches, it will modify the template changes it has found only. It will also modify all styles for your forums. I have tested this on all 3 of my licensed vBulletin production websites and the patches all worked great.

UPDATED MUST READ NOTES:
1) RE-READ THE UPGRADING OR NEW INSTALLATION INSTRUCTIONS AS THEY HAVE CHANGED FROM THE PREVIOUS VERSIONS!!
2) IF UPGRADING FROM A PREVIOUS VERSION OF eBux / eStore. YOU MUST INSTALL THIS ONE FIRST TO SAVE YOUR SETTINGS. (BUT YOU WOULD KNOW THIS IF YOU READ THE UPGRADING INSTRUCTIONS!! DONT SAY I DIDNT WARN YOU!!)

Branding Free Option
If you have donated in the past, you can get the Branding Free Option for Free by sending CMX a PM on the http://www.vbplaza.com/forums Message Board.
Otherwise, you will need to purchase it by signing up for an account at http://www.vbplaza.com/forums/register.php and then going to http://www.vbplaza.com/forums/payments.php

Features List:
This section has been moved due to its length. Look in the file included insize the zip named features.txt.

Release Notes:
This section will only show the most recent changes. For the rest of the changes, look in the file included inside the zip named changes.txt.

NOTE: If you want ibProArcade, v3 Arcade or vBookie integration now, you'll have to install the appropriate Addon included in the download. The reason for these parts being packaged as Addons, is to make the install a little smaller for users who do not have an Arcade, and because both Arcades cant be installed simultaneously as well. So it saves space only installing the one that you currently have.

v1.5.8 Updates:
1) Bugfix: Quick editing a post with BB Codes, modified the post directly instead of modifying a copy.
2) Bugfix: Some phrases fixed.
3) Bugfix: TABLEPREFIX bug has been fixed.
4) Bugfix: Addon Product XML sheets do not have executionorder in them anymore for vB 3.5 compatibility.

Database Backups Recommended!
Although I have upgraded 3 forums with this script already, it IS recommended that you backup your database before installing this product!!

Upgrading Instructions:
NOTE: THESE INSTRUCTIONS ARE FOR UPGRADING IF YOU HAD A PREVIOUS VERSION OF eBux / eStore INSTALLED!!
1) DO NOT UNINSTALL eBux / eStore (UNLESS YOU WANT TO LOSE ANY AND ALL SETTINGS.)
2) Reupload all of the files in the upload folder to your forum's root folder. Make sure that all files are being overwritten. Do not move on to the next step until all files are transferred successfully!
NOTE: It could take a long time to install if you have a lot of registered users, be PATIENT! It should display the messages as it goes along to let you know that it IS working.
3) After finished with step 2!! Reimport the product-vbbuxplaza.xml file via Admin CP -> Plugin System -> Manage Products -> Add/Import Product. Make sure that Allow Overwrite is set to YES.
4) Refresh the Admin CP and you will see all of the vbBux / vbPlaza Admin CP features at the top.
5) UNINSTALL THE OLD eBux / eStore NOW!! Go to Admin CP -> Plugin System -> Manage Products -> eBux / eStore -> Uninstall.
6) You can delete all files/folders that have the word estore or elottery in them from the FTP as well.
7) You will need to redo the template edits listed below as almost all of them have changed since the previous eBux / eStore.

If upgrading from a previous version of vbBux / vbPlaza follow these instructions:
1) Reupload all of the files in the upload folder to your forum's root folder. Make sure that all files are being overwritten. Do not move on to the next step until all files are transferred successfully!
2) After finished with step 2!! Reimport the product-vbbuxplaza.xml file via Admin CP -> Manage Products -> Add/Import Product. Make sure that Allow Overwrite is set to YES.
3) Refresh the Admin CP and get to checking your settings!
NOTE: You will be happy know that NO templates have been updated from v1.5.0 to v1.5.2!

New Installation Instructions:
1) Upload all of the files/folders in the UPLOAD folder to your forum's root folder.
2) Import the product-vbbuxplaza.xml via Admin CP -> Manage Products -> Add/Import Product.
NOTE: It could take a long time to install if you have a lot of registered users, be PATIENT! It should display the messages as it goes along to let you know that it IS working.
3) Refresh the Admin CP and start setting up your settings!
4) You will need to do all of the template edits listed below as well.

Template Edits:
A) Inside templates 'postbit' AND 'postbit_legacy':

Find:

<div id="postmenu_$post[postid]">

Replace With:

<!-- vbPlaza start -->
<div id="postmenu_$post[postid]" <if condition="$post['namestyle']">style="$post[namestyle]"</if>>
<!-- vbPlaza end -->

Next Find:

<if condition="$post['usertitle']"><div class="smallfont">$post[usertitle]</div></if>

Replace With:

<!-- vbPlaza start -->
<if condition="$post['usertitle']"><div class="smallfont" <if condition="$post['titlestyle']">style="$post[titlestyle]"</if>>$post[usertitle]</div></if>
<!-- vbPlaza end -->

Then Find:

$vbphrase[posts]: $post[posts]

Replace With:

$vbphrase[posts]: $post[posts]
<!-- vbPlaza start -->
<if condition="$show['pointsinpostbit']"><br />
$vbphrase[vbbux_points]: $post[points]<br />
$vbphrase[vbbux_bank]: $post[bank]<br />
<phrase 1="$vbphrase[vbbux_points]">$vbphrase[vbbux_total_points]</phrase>: $post[totalpoints]<br />
<a href="vbplaza.php?do=donate&amp;userid=$post[userid]">$vbphrase[vbplaza_donate]</a><br />
</if>
<!-- vbPlaza end -->

Then Find:

				<div>$post[icqicon] $post[aimicon] $post[msnicon] $post[yahooicon] $post[skypeicon]</div>

Add Below:

<!-- vbPlaza start -->
				<if condition="$post['giftsdisplay']"><div class="smallfont">$post[giftsdisplay]</div></if>
				<if condition="$post['ribbonsdisplay']"><div class="smallfont">$post[ribbonsdisplay]</div></if>
<!-- vbPlaza end -->

B) Inside template 'navbar':

Find:

		<td class="vbmenu_control"><a href="calendar.php$session[sessionurl_q]">$vbphrase[calendar]</a></td>
		<if condition="$show['popups']">

Add Below:

<!-- vbPlaza start -->
			<if condition="$show['member']">
				<if condition="$vboptions['vbplaza_enabled']"><td id="vbplazamenu" class="vbmenu_control"><a href="$show[nojs_link]#vbplazamenu">$vbphrase[vbplaza_name] $vbphrase[vbplaza_menu]</a> <script type="text/javascript"> vbmenu_register("vbplazamenu"); </script></td></if>
			</if>
<!-- vbPlaza end -->

Then Find:

<!-- / NAVBAR POPUP MENUS -->

Add Above:

<!-- vbPlaza start -->
	<if condition="$show['member']">
	<!-- vbplaza tools menu -->
	<div class="vbmenu_popup" id="vbplazamenu_menu" style="display:none">
		<table cellpadding="4" cellspacing="1" border="0">

		<tr><td class="thead"><a href="vbplaza.php?$session[sessionurl]">$vbphrase[vbplaza_name] $vbphrase[vbplaza_main]</a></td></tr>
		<tr><td class="vbmenu_option"><a href="vbplaza.php?$session[sessionurl]do=action&amp;itemid=48">$vbphrase[vbplaza_lottery]</a></td></tr>
		<tr><td class="vbmenu_option"><a href="vbplaza.php?$session[sessionurl]do=action&amp;itemid=27">$vbphrase[vbplaza_give_gifts]</a></td></tr>
		<tr><td class="vbmenu_option"><a href="vbplaza.php?$session[sessionurl]do=action&amp;itemid=118">$vbphrase[vbplaza_give_ribbons]</a></td></tr>
		<tr><td class="vbmenu_option"><a href="vbplaza.php?$session[sessionurl]do=action&amp;itemid=13">$vbphrase[vbbux_bank]</a></td></tr>
		<tr><td class="vbmenu_option"><a href="vbplaza.php?$session[sessionurl]do=action&amp;itemid=7">$vbphrase[vbplaza_donate]</a></td></tr>
		<tr><td class="vbmenu_option"><a href="vbplaza.php?$session[sessionurl]do=action&amp;itemid=16">$vbphrase[vbplaza_thief]</a></td></tr>

		<tr><td class="vbmenu_option"><a href="vbplaza.php?$session[sessionurl]do=richestusers">$vbphrase[vbbux_richest_users]</a></td></tr>
		<tr><td class="vbmenu_option"><a href="vbplaza.php?$session[sessionurl]do=userhistory">$vbphrase[vbplaza_history]</a></td></tr>
		<tr><td class="vbmenu_option"><a href="vbplaza.php?$session[sessionurl]do=mostsold">$vbphrase[vbplaza_most_sold]</a></td></tr>

		<if condition="is_member_of($vbulletin->userinfo, $vboptions['vbplaza_adminusergroups'])">
			<tr><td class="thead">$vbphrase[vbplaza_admin_only]</a></td></tr>
			<tr><td class="vbmenu_option"><a href="vbplaza.php?$session[sessionurl]do=action&amp;itemid=12">$vbphrase[vbplaza_admin_donate]</a></td></tr>
		</if>

		</table>
	</div>
	<!-- / vbplaza tools menu -->
	</if>
<!-- vbPlaza end -->

C) Inside template 'MEMBERINFO':

Find:

				<div class="bigusername">$userinfo[musername] $userinfo[onlinestatus]</div>

Replace With:

<!-- vbPlaza start -->
				<div class="bigusername" <if condition="$userinfo['namestyle']">style="$userinfo[namestyle]"</if>>$userinfo[musername] $userinfo[onlinestatus]</div>
<!-- vbPlaza end -->

Next Find:

				<if condition="$userinfo['usertitle']"><div class="smallfont">$userinfo[usertitle]</div></if>

Replace With:

<!-- vbPlaza start -->
				<if condition="$userinfo['usertitle']"><div class="smallfont" <if condition="$userinfo['titlestyle']">style="$userinfo[titlestyle]"</if>>$userinfo[usertitle]</div></if>
<!-- vbPlaza end -->

Then Find:

			<if condition="$vboptions['usereferrer']">

Add Above:

<!-- vbPlaza start -->
			<if condition="$vboptions['vbbux_enabled']">$show[vbbuxuserinfo]</if>
			<if condition="$show['gifts']">$show[gifts]</if>
			<if condition="$show['ribbons']">$show[ribbons]</if>
<!-- vbPlaza end -->

D) Inside template 'forumrules':

Find:

		<div><phrase 1="$htmlcodeon">$vbphrase[html_code_is_x]</phrase></div>

Add Below:

<!-- vbPlaza start -->
		<if condition="$vboptions['vbbux_enabled']">
			<if condition="!$show['codeonly']">
			<hr />
			<div><phrase 1="$vbphrase[vbbux_points]" 2="$foruminfo[points_perview]">$vbphrase[vbbux_points_perview]</phrase></div>
			<div><phrase 1="$vbphrase[vbbux_points]" 2="$foruminfo[points_perthread]">$vbphrase[vbbux_points_perthread]</phrase></div>
			<div><phrase 1="$vbphrase[vbbux_points]" 2="$foruminfo[points_perreply]">$vbphrase[vbbux_points_perreply]</phrase></div>
			</if>
		</if>
<!-- vbPlaza end -->

E): Inside template 'USERCP_SHELL':

Find:

<if condition="$show['avatarlink']">

Add Above:

<!-- vbPlaza start -->
<if condition="$vboptions['vbplaza_enabled']">
	<tr>
		<td class="$navclass[vbplaza]" nowrap="nowrap"><a class="smallfont" href="vbplaza.php?$session[sessionurl]do=editvbpoptions"><phrase 1="$vbphrase[vbplaza_name]">$vbphrase[edit_vbplaza_options]</phrase></a></td>
	</tr>
</if>
<!-- vbPlaza end -->

F): Inside template 'threadbit':

Find:

		$thread[title_editable]
		<div>

Replace With:

<!-- vbPlaza start -->
		$thread[title_editable]
		<div <if condition="$thread['titlestyle']">style="$thread[titlestyle]"</if>>
<!-- vbPlaza end -->

vBulletin 3.5.x Only Edit:

Next Find:

			<if condition="$show['gotonewpost']">
				<strong><a href="showthread.php?$session[sessionurl]t=$thread[threadid]$thread[highlight]" id="thread_title_$thread[realthreadid]">$thread[threadtitle]</a></strong>
			<else />
				<a href="showthread.php?$session[sessionurl]t=$thread[threadid]$thread[highlight]" id="thread_title_$thread[realthreadid]">$thread[threadtitle]</a>
			</if>

Replace With:

<!-- vbPlaza start -->
			<if condition="$show['gotonewpost']">
				<strong><a href="showthread.php?$session[sessionurl]t=$thread[threadid]$thread[highlight]" id="thread_title_$thread[realthreadid]" <if condition="$thread['titlestyle']">style="$thread[titlestyle]"</if>>$thread[threadtitle]</a></strong>
			<else />
				<a href="showthread.php?$session[sessionurl]t=$thread[threadid]$thread[highlight]" id="thread_title_$thread[realthreadid]" <if condition="$thread['titlestyle']">style="$thread[titlestyle]"</if>>$thread[threadtitle]</a>
			</if>
<!-- vbPlaza end -->

vBulletin 3.6.x Only Edit:

Next Find:

			<a href="showthread.php?$session[sessionurl]t=$thread[threadid]$thread[highlight]" id="thread_title_$thread[realthreadid]"<if condition="$show['gotonewpost']"> style="font-weight:bold"</if>>$thread[threadtitle]</a>

Replace With:

			<a href="showthread.php?$session[sessionurl]t=$thread[threadid]$thread[highlight]" id="thread_title_$thread[realthreadid]"<if condition="$thread['titlestyle']">style="$thread[titlestyle]"</if>>$thread[threadtitle]</a>

G): Inside template 'memberlist_resultsbit':

Find:

		<a href="member.php?$session[sessionurl]u=$userinfo[userid]">$userinfo[musername]</a>
		<if condition="$show['usertitlecol']"><div class="smallfont">$userinfo[usertitle]</div></if>

Replace With:

<!-- vbPlaza start -->
		<div <if condition="$userinfo['namestyle']">style="$userinfo[namestyle]"</if>><a href="member.php?$session[sessionurl]u=$userinfo[userid]" <if condition="$userinfo['namestyle']">style="$userinfo[namestyle]"</if>>$userinfo[musername]</a></div>
		<if condition="$show['usertitlecol']"><div class="smallfont" <if condition="$userinfo['titlestyle']">style="$userinfo[titlestyle]"</if>>$userinfo[usertitle]</div></if>
<!-- vbPlaza end -->

-CMX

[CMX_CMGSCCC]

Originally Posted by shaynehammy

What would be great if there was a history list that displayed who changed anothers user titles. Say the last 20 titles changes.

So where the Most sold catergory is.Clicking on this (Change Others User Title) would take you to who bought what.

This will happen in v1.1.3 when it releases.

Originally Posted by kylek

Can't find this doing a search so,

Can points be removed from a specific member? Or is there a way to reset one members point total to zero?

Yes, you can edit the user in the Admin CP by using the Users -> Search For User admin feature. On the left hand side at the bottom it will display the eBux/eStore options for that individual user.

Originally Posted by caimakale

Are you talking about serializing it and leaving it in the user table or adding it to the datastore?

I'm saying that the gifts field inside of the user database has to be an array of "serialized" fields so that it will not have to query the actual estore_gifts TABLE.

-CMX

[Geser]

I am reinstalled eBux / eStore. Uninstalled and then installed v1.1.2
I still unable to remove items. Still getting "You do not have enough points to perform this action.".
And still not see option to change user title color after i bought this option(fist change is ok, but after this i unable to change. I set "Can Change Always" in admin cp). I see only button "Remove"
Anybody can confirm this problems?

[caimakale]

Originally Posted by Geser

I am reinstalled eBux / eStore. Uninstalled and then installed v1.1.2
I still unable to remove items. Still getting "You do not have enough points
to perform this action.".
And still not see option to change user title color after i bought this option. I see only button "Renove"
Anybody can confirm this problems?

OK here goes.

In order to be able to go back and change your color etc...you had to have that option enabled before you bought the item. If you bought it, then enabled the "Change Always Items" in the item, it won't work unless you set it manually now.

If it is set now, then anybody who purchases it at this point will have the ability to come back and change at any time.

So how do you manually set it? You first need to figure out what the item number is. One way of doing this is finding the item in the store and then hover over it. It will show you the URL and will look something like this:

http://www.yourwebsitehere.com/estore.php?do=action&itemid=6

In that link you can see that the itemid is 6.

So get your itemids that you need to change on your user. Open up your AdminCP >> User area. Find the user you want to change. When you find the user and are viewing their info, scroll to the bottm where you can see their points and other store options. You will want to add the itemid to the "Change Always Items". Separate them by commas. For example, in my personal account I have 5,6,11 in that field so I can continually change my username color, username glow, and usertitle color because I have purchased these things.

If you don't have these numbers in the "Change Always Items" area then it thinks you are either going to need to remove it or repurchase it, those will be your only options until you manually set it. And if you don't have enough eBux to repurchase it again, then you will get the error that you got.

These probably aren't the best instructions but I hope it helps.

[Geser]

Originally Posted by caimakale

OK here goes.

In order to be able to go back and change your color etc...you had to have that option enabled before you bought the item. If you bought it, then enabled the "Change Always Items" in the item, it won't work unless you set it manually now.

If it is set now, then anybody who purchases it at this point will have the ability to come back and change at any time.

So how do you manually set it? You first need to figure out what the item number is. One way of doing this is finding the item in the store and then hover over it. It will show you the URL and will look something like this:

http://www.yourwebsitehere.com/estore.php?do=action&itemid=6

In that link you can see that the itemid is 6.

So get your itemids that you need to change on your user. Open up your AdminCP >> User area. Find the user you want to change. When you find the user and are viewing their info, scroll to the bottm where you can see their points and other store options. You will want to add the itemid to the "Change Always Items". Separate them by commas. For example, in my personal account I have 5,6,11 in that field so I can continually change my username color, username glow, and usertitle color because I have purchased these things.

If you don't have these numbers in the "Change Always Items" area then it thinks you are either going to need to remove it or repurchase it, those will be your only options until you manually set it. And if you don't have enough eBux to repurchase it again, then you will get the error that you got.

These probably aren't the best instructions but I hope it helps.

Thanks alot. It helps.
But what about first problem? I still unable to remove items.

[caimakale]

Originally Posted by Geser

Thanks alot. It helps.
But what about first problem? I still unable to remove items.

It looks like a bug, and in checking it out, I found another bug.

So concerning your problem, unless you have enough money to purchase the item again, you can't return it. Even if it is going to give you a refund.

So when I was testing it. I returned the glowing username and it put the points back into my account. I then hit the back button in my browser and it took me right back to the previous page where I had the option to remove it or change the color. I entered in a color and selected change and it changed it just fine without charging me any money. So not only did I get a refund for the item, but I still ended up with my glowing username. This could be exploited and somebody could earn a ton of points doing it.

***EDIT***
So I just checked something else. It turns out you don't even have to hit the back button. Once it's been purchased you always own it if the "Change Always Items" is active. One of two things needs to happen. Refunds need to be turned off when "Change Always Items" is active on an item, or when an item is removed and a refund issued, the itemid# for the "Change Always Items" needs to be deleted from the database. I know for the time being, I am turning off refunds so people can't rob the bank.

[Geser]

Originally Posted by caimakale

It looks like a bug, and in checking it out, I found another bug.

So concerning your problem, unless you have enough money to purchase the item again, you can't return it. Even if it is going to give you a refund.

So when I was testing it. I returned the glowing username and it put the points back into my account. I then hit the back button in my browser and it took me right back to the previous page where I had the option to remove it or change the color. I entered in a color and selected change and it changed it just fine without charging me any money. So not only did I get a refund for the item, but I still ended up with my glowing username. This could be exploited and somebody could earn a ton of points doing it.

***EDIT***
So I just checked something else. It turns out you don't even have to hit the back button. Once it's been purchased you always own it if the "Change Always Items" is active. One of two things needs to happen. Refunds need to be turned off when "Change Always Items" is active on an item, or when an item is removed and a refund issued, the itemid# for the "Change Always Items" needs to be deleted from the database. I know for the time being, I am turning off refunds so people can't rob the bank.

Ok, thanks for your work. Now i know it's bug and not problem of my installation.

[voleibolmurcia]

This mod allows to create any "shop" to insert items, and users can buy it?

[chairman miaow]

Originally Posted by Frugal

I have now edited this post

https://vborg.vbsupport.ru/showpost....postcount=1389

to include a comprehensive guide to getting vbookie working with eBux using both the sql and file editing methods.

Frugal - thanks for this - it was getting confusing with all the different stuff being quoted about vBookie....mine works perfectly with ebux now.

CMX_CMGSCCC - Many many thanks for this mod...it's amazing how often and quickly you update it ! Also would love it to be integrated with the ibpro arcade ( haven't got a clue about the "hooks" etc though !)

[Sooner95]

Did you reupload all of the files in the UPLOAD folder? That is a common mistake people tend to forget as well.

Yes, I always make sure I do the basics before complaining. This error has never went away, since 1.08. Not a big deal, more than likely you have it fixed, unfiortanetly, I have been unable to fix the table for that user via phpadmin. Got a friend who will check it out for me, see if it can be salvaged, otherwise I'll just delete that user and recreate.

In the future, I'll add it so the Admin CP, search for Users can edit the otherflags and some of the other fields that are added to the usertable in case of corruption too.

excellent, that would be great CMX.

Does IBProArcade have any hooks implemented?

I'm not very code savy, but if you mean a file hooks_ebuxestore.xml in the includes/xml folder, then no. thats in the 2.5.3 release, i know he has released one m ore update since, so woud have to check if their are any in that one.

I know a PM was sent to MR Zeropage (author of ibPro) so hopefully he will contact you about working out this addon.

Thanks again for the support and fine work.

Also, with the help of others, figured out the timestamp thing for creating lottos as well.

[Sooner95]

Got bored, made another gift.

its a dollar..lol

[amykhar]

Sooner's problem with the userid is fixed. To fix it, I had to go in as another admin - I registered a new account and then made it an admin by changing the database since it was his admin account that was hosed.

As the other admin, I cleared the estore history. Then, I set his admin account back to the correct usergroup, and he was good to go.

[Sooner95]

Originally Posted by amykhar

Sooner's problem with the userid is fixed. To fix it, I had to go in as another admin - I registered a new account and then made it an admin by changing the database since it was his admin account that was hosed.

As the other admin, I cleared the estore history. Then, I set his admin account back to the correct usergroup, and he was good to go.

Big time thx Amy. Noted for future issues as well.

[MustangLisa]

Originally Posted by WolfsongNevan

Thank you SO much for all your AWESOME support, seriously.

Just one quick thing (but a big thing to our members) that I didn't see answered .... will the "hover" over gifts (which will show the gift giver's name and message) be added?

Also, you said in reply to my question about missing gifts (in the threads, not in the profile like you mentioned) that it will not show 2 of the same gifts ... would it be possible to make this an option in a future update? We have a board full of ladies that are VERY into the gifts and are disappointed that their gifts aren't showing up in the threads ... especially since there is a only a small selection of gifts at this time (working on adding more ). The rose and bouquet are popular gifts in our forum and because of this, members are getting multiples of them from different members, but can't see them.

Off to donate to PayPal because I am just so completely impressed with your dedication to this project. (no kissing up intended)

Ditto ... my members would love that and I'll donate for it. Thanks for all your hard work on this!!

[Frugal]

Originally Posted by kylek

Frugal - maybe you could include the functions_vbookie.php file in your post, a lot easier for people who are not too sure of what to do.

Yes I thought about that last night but as it was something like 3am when I made the post and I had to get up for work at 7am and lordofgun had already attached the file I decided to make sure the instructions were adequate then hit the sack. I'll drop a pm to the author of vbookie and ask him for permission to post an edited version and once I have his ok I'll attach the file.

Frugal

[Frugal]

Originally Posted by caimakale

If I made a hack calling the ebux field from the user table it wouldn't find it because you have it renamed to ucash. It would have to be a pretty big hack to do that as most hacks will use the functions CMX has built in, but nonetheless it is a possibility.

Hehe anything is possible, but as you say the points field is a user configurable variable, it is not hard coded so one would hope any hacker worth his salt would use the built in functions rather than hard coding it when CMX designed it to be user configurable. However in the event of a fantastic but hard coded hack being released it is just 1 query and the field is again called eBux. Of course until that day I can use several hacks with ebux that were designed for ucash, as well as vbookie I also use the league system that uses the ucash points field.

Mind you, I never really intended to get into a debate on the merits of file editing vs sql queries, which is best is down to the needs and preferences of the individual forum owner. I originally suggested the file edit method on page 24 and when the guy had no success I posted the sql query on page 25 which got him up and running, as lots of others have reported success with those instructions I continued to favour the sql method. My only motivation was to help those wanting to integrate vbookie and eBux and now that there is a comprehensive post giving both options we should find less people having difficulty in this area.

Thanks for your input though, it is always good to have the pro's and cons from many sources so that people can make an informed choice about which method suits them best.

Frugal