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

[49er]

Hack is work great, thx.
But can you explain what i do to remove one of the cash (points) sum figures from view on my postbit. :ermm:

[OAndrea]

Originally Posted by OAndrea

can I install this on VB3.5.2?

Hello Anyone got an answer for me, are you guys installing this on 3.5.2 also?

[49er]

Originally Posted by OAndrea

Hello Anyone got an answer for me, are you guys installing this on 3.5.2 also?

I have!! no problem. :squareeyed:

[OAndrea]

Thanks Teepeg!

[redtailboa]

Ok, I setup a test site and copied all my data over and did a upgrade to VB 3.5.3. I then upgraded ebux from 1.0.3 to 1.0.5a and it still messes up my forum. I cannot login, I cannot do anything. I also tried uninstalling the product, then reinstalling. Directly after the uninstall I try to post a message and it messes up. Again, here is a sql error I get via email.

Database error in vBulletin 3.5.3:

Invalid SQL:

SELECT filename, attachment.postid, attachment.userid, attachmentid,
attachment.dateline, SUBSTRING(filedata, 1, 2097152) AS filedata, filesize,
attachment.visible, mimetype, thread.forumid, thread.threadid, thread.postuserid,
post.visible AS post_visible, thread.visible AS thread_visible

FROM attachment AS attachment
LEFT JOIN attachmenttype AS attachmenttype ON (attachmenttype.extension = attachment.extension)
LEFT JOIN post AS post ON (post.postid = attachment.postid)
LEFT JOIN thread AS thread ON (post.threadid = thread.threadid)

WHERE attachmentid =;

MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at $
Error Number : 1064
Date : Sunday, February 5th 2006 @ 04:12:48 PM
Script : http://old.redtailboa.net/forums/att...1&d=1138976009
Referrer : http://old.redtailboa.net/forums/t20...d-up-news.html
IP Address : 72.64.68.35
Username : natas
Classname : vb_database
================================================== ===

[OAndrea]

BTW I would LOVE to see the option for buying gifts on this, that is what my forum members are really wanting! I mean they want it BAD!

[redtailboa]

FYI, I am willing to give the creator of this hack full admin access to the test site to work out the problem, PM me or email me at natas@spamcop.net

[caimakale]

Originally Posted by Sai01

sorry if i offened anybody... i didn't mean to compare it to ushop. it's just my stupid opinion and would be best if i didn't bring it up...

in fact i think the feature are equal(plus it's still a baby)! when i said i prefer ushop i meant as in the looks and layout of it. But doing this hacks for us in only 3 days? that's something very great and awesome!

also thanks for the reply, so... searhcing for "Points" in phrase huh? i'll do that. and thank you CMX! for making a fantasy(ushop) into a reality!

I wasn't trying to single you out, there have been quite a few others on here saying the same thing and the last thing any of us want is CMX getting frustrated and giving up on this project because negativity towards it. Sorry if it appeared that way though.

I just say sit back and enjoy the ride for the next week or so, things will start happening. Others will start releasing hacks for it, ChurchMedia released his products hack for it here https://vborg.vbsupport.ru/showpost....&postcount=274 , I am working on some things for it, and CMX hasn't given up on it either.

[CMX_CMGSCCC]

A lot of posts here to read, I've read all of them now. I've fixed the bugs I have come across in the posts that I could replicate.

No idea how redtailboa's bug is coming about because this hack doesnt even do anything to any attachment plugins at all :/

As far as "giving up"? Why would I give up over some negative comments? There is simply no reason too, everyone is entitled to their own opinion. And just because some dont like it doesnt mean that there arent a lot of people who do like it!

I've did a little bit of work on it over the past day or so, I've really improved the Add Option for the Admin CP. I'm doing more testing on it today, and if all goes well and all are working, it will be released later today. (Probably about 8 to 10 hours after this post.)

I realize that some of the templates that I've created are not the most elegant looking, I'm a coder, not a graphic artist. If someone can redesign the estore_main template and make it nice and purrrrrrrrrrty, I'm all for adding it in. Someone posted a screen shot of a bank that looks awesome and I will incorporate that into the release very soon.

Here are a list of things that I have done so far for the v1.0.6 to be released later today:

v1.0.6 Update:
1) Bugfix: View Richest Member setting was always displaying top 30, it now displays how many you have the eBux Setting for.
2) eStore Main: Displays the item description in the database when it lists the items for sale.
3) Bugfix: Donate, Admin Donate, Thief & Bank eStore Options check that the amount is numeric properly now.
4) When eStore is not enabled now, it displays a closed message.
5) eStore Options: Lose Reputation Points on Successful Thief & Failed Thief. (2 Different Settings, Use a value of 0 for no loss.)
6) Custom User Title eStore Options now set the user table field customtitle = 1.
7) eStore Option: Sticky Thread, lets a user sticky a thread. (Requires them to enter the threadid)
8) eStore Option: Unticky Thread, lets a user unsticky a thread. (Requires them to enter the threadid)
9) eStore option Set Type field has a new drop down called 'Add Integer' which will add to the field setname. Useful for making an eStore Option to buy more post counts, or anything that you just want to increase.
10) Backend Changes: A VERY Major change has occurred in the back end. There was a LOT of database changes done to the estoreitems table and the items contained in it. One that is so great now you can almost add actions for anything you want. I won't go into detail of what this means, but lets just say something like this. The table named 'thread' has threadid, visible, sticky, sticky_expiry, votenum, etc..

Well with the new system in place, I'll demonstrate how to add a new eStore Option for say example, Sticky Thread... (NOTE this is not a perfect example because the sticky thread has its own field for 'sticky_expiry' and has to be accounted for to make it expire properly. But for the sake of this example, it will set the sticky = 1 where threadid = id the person entered.

First you go to the Admin CP and choose Add New Option. Type Sticky Thread for the Item Name and type a description you want it to use, setup all the costs, expire days, refill, usergroups, etc.. Then use the following settings:
Item Script Location: blank (Meaning do not type anything in this field!)
Item Table Name: thread
Where Name: threadid
Where Value: $action['threadid']
Set Type: Choose Bitfield
Set Name: sticky
Set Value: 1
Phrase Name 1: estore_threadid
Field Name 1: threadid

Then choose Add Option and there you have it. As you can see these back end changes allow for lots of tables to be modified via eStore Options.

With this kind of system in place, its almost virtually endless of the possibilities to add/modify the tables/fields.

-CMX

[Frugal]

Originally Posted by Deimos

There are usergroup permissions, they're done per ITEM
You have to go into the item manager section, click the first item and in there there's a field to put in the "allowed usergroups" (you need to note down the number of the user group or groups you want added to that list)

Thanks man, that's just what I needed

Frugal