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

[kevinrstruck]

Does any one have any idea what I could have done wrong?

Originally Posted by kevinrstruck

When anyone clicks on the VBplaza menu they get this error:


"The action you are trying to do is not found."


When I go into the admincp and try to create a new lottery, this is the error I get after I click "Add Lottery".

Database error in vBulletin 3.5.4:

Invalid SQL:
SELECT * FROM vbp_option WHERE active = 1;

MySQL Error  : Unknown column 'active' in 'where clause'
Error Number : 1054
Date         : Wednesday, June 14th 2006 @ 09:02:41 PM
Script       : http://www.autumnthunder.com/forums/admincp/vblottery.php
Referrer     : http://www.autumnthunder.com/forums/admincp/vblottery.php?do=addlottery
IP Address   : 24.9.176.21
Username     : administrator
Classname    : vb_database

[steadicamop]

I've uninstalled this and keep getting this DB error - and it's at least twice daily:

Database error in vBulletin 3.5.4:
 
Invalid SQL:
 
      SELECT languageid,
    phrasegroup_vbplaza AS phrasegroup_vbplaza,
    phrasegroup_global AS phrasegroup_global,
    options AS lang_options,
    languagecode AS lang_code,
    charset AS lang_charset,
    locale AS lang_locale,
    imagesoverride AS lang_imagesoverride,
    dateoverride AS lang_dateoverride,
    timeoverride AS lang_timeoverride,
    registereddateoverride AS lang_registereddateoverride,
    calformat1override AS lang_calformat1override,
    calformat2override AS lang_calformat2override,
    logdateoverride AS lang_logdateoverride,
    decimalsep AS lang_decimalsep,
    thousandsep AS lang_thousandsep
      FROM language
      WHERE languageid = 1;
 
MySQL Error  : Unknown column 'phrasegroup_vbplaza' in 'field list'
Error Number : 1054
Date         : Friday, June 16th 2006 @ 11:43:21 AM
Script       : http://www.steadiforum.com/vbplaza.php?do=donate&userid=7
Referrer     :
IP Address   : 72.30.107.155
Username     :
Classname    : vb_database

I've looked to see if there's any cron jobs running, but nothing for this - it's been totally removed - what the hell is going on?

Cheers

[jbd]

looks like the "donate" option is still available somewhere on your forum. When this is selected, it makes a call to a db table that no longer exists. Simplest thing to do would be to disable the donate option, and wherever the option to donate exists (probably in multiple places)

[ehsanix]

Originally Posted by ehsanix

thanks,
is that posible to disable some actions for users in this mode like unlock or lock treads or els?

answer?

[mcyates]

when betting on a vbookie even i bet 100 but it takes 300 from my points and only puts 100 onto the bet. Weird!!!

[Britainy]

ok I have every down loaded but any tiem we click BAnk or anything below it this message comes up

Warning: main(./vbplaza/action.bank.php): failed to open stream: No such file or directory in /vbplaza.php on line 502

Fatal error: main(): Failed opening required './vbplaza/action.bank.php' (include_path='.:/usr/local/lib/php') in /home/content/M/o/m/MommiesUnited/html/forums/vbplaza.php on line 502

I have all contents downloaded and they are all in there right folder

[Britainy]

OK never mind I figured it out I had my folders named wrong stupid me lol I had it named vdplaza no vbplaza

[Lewis1234]

When i try to buy a product i get this error:

Database error in vBulletin 3.5.4:

Invalid SQL:

UPDATE user
SET
`vbbux` = `vbbux` - 4.12, vbp_history = 'a:2:{i:0;a:5:{s:6:\"itemid\";s:2:\"48\";s:9:\"fin alcost\";d:5.3044999999999999928945726423989981412 8875732421875;s:8:\"dateline\";i:1150550681;s:7:\" expires\";s:1:\"0\";s:6:\"reason\";s:53:\"Lottery Name: OurHabbo Lottery - Number of Tickets: 1\";}i:1;a:4:{s:6:\"itemid\";s:2:\"20\";s:9:\"fina lcost\";d:4.12000000000000010658141036401502788066 864013671875;s:8:\"dateline\";i:1150655648;s:7:\"e xpires\";s:1:\"0\";}}', coffee table = (coffee table | 45)
WHERE userid = '1';

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 'table = (coffee table | 45)
WHERE userid = '1'' at line 3
Error Number : 1064
Date : Sunday, June 18th 2006 @ 02:34:08 PM
Script : http://www.ourhabboforum.be/vbplaza.php
Referrer : http://www.ourhabboforum.be/vbplaza....tion&itemid=20
IP Address : 82.45.103.18
Username : xRoyal15
Classname : vb_database

Anyone got a fix?

[chkdgate]

Yes this is my first post but I really need help with this noob problem. I'm following the "New Installation" directions to a T but when I attempt to upload the product-vbbuxplaza.xml file I get this error:

Could not find phrase 'vbplaza_functions_vbplaza_not_uploaded'.

[basilrath]

have you made sure your paths totally correct ...............double check

[Ragnor]

hey, maybe this has been adressed already but i cant seem to find it.

ive instealled this mod and it works perfectly but im having some problems with vbbux and giving out points for subscriptions.

ive set everything up and its showing when purchasing a subscription that u get xx vbbux when you purchase it but it never credits there account.

if anyone can help me out, thanks!

[chkdgate]

Originally Posted by basilrath

have you made sure your paths totally correct ...............double check

I'm pretty sure that I've placed every file where they're supposed to be but then again I could be wrong.

Edit:
I correctly installed all the files in it's proper folder. I uploaded the product-vbbuxplaza.xml file and then I refreshed the adminCP. Now, where do I go to edit the necessary templates? I spent over an hour looking for both 'postbit' AND 'postbit_legacy'. It's so late right now, I'll try again tomorrow. Thanks to all in advance.

[kevinrstruck]

Anyone have any idea what I should do here????

Database error in vBulletin 3.5.4:

Invalid SQL:
SELECT * FROM vbp_option WHERE active = 1;

MySQL Error  : Unknown column 'active' in 'where clause'
Error Number : 1054
Date         : Wednesday, June 14th 2006 @ 09:02:41 PM
Script       : http://www.autumnthunder.com/forums/admincp/vblottery.php
Referrer     : http://www.autumnthunder.com/forums/admincp/vblottery.php?do=addlottery
IP Address   : 24.9.176.21
Username     : administrator
Classname    : vb_database

[chkdgate]

Before I continue any further, is vbbuxplaza a stand alone plugin or do I need something else to run it. I'm not getting or finding the options to edit these templates:
'postbit' AND 'postbit_legacy'

[wolfyman]

I'm trying to allow users to upgrade memberships with vbplaza, but I get this when I try to upgrade:

The vbPlaza option you are trying to purchase has an invalid Set Name.