Major Additions - Point Market System 3.1x

Hack Summary
The Point Market System 3.1 is a stand alone "store" or "shop" hack for vBulletin 4x series. This hack is considered a major addition that allows for you to install one or multiple point systems, activity systems, or currency systems to use points for forum related item enhancements or a virtual/physical store system for your vBulletin forum.

The Point Market is actually four major hacks combined into one. Those five major hacks are a Forum Enhancement Store, A Virtual & Physical Store, a detailed Banking/Payment System, Currency to Point Converter, and a Lottery/Gambling Center. Below is a little bit more about each section.

Forum Item Enhancement Store
The Point Market Forum Item section is what is considered a traditional forum store. You can use a very comprehensive Admin background to be able to sell a variety of forum items that can help enhance a user's enjoyability on the forums. In addition, there are many forum items that a user can purchase for other users. I should also note that a point donation is possible in this section since many point systems do not offer the ability to donate. Below is a listing of the market items & categories:

Forum Items User can Purchase
Market Features (Additional Market Access Features Users Can Purchased)
- Steal Protection
- Gift Market Access
- Stolen Point History
- Donation History
- Gambling Access
- Coupon Access
User Title
- Custom User Title
- User Title Glow
- User Title Color
- Usertitle Strikethrough
Gifts / Awards / Ribbons
- Purchase a Gift
- Create a Gift
User Permissions
- Primary Usergroup Change
- Secondary Usergroup Change
Username Permissions
- Change Username
- Username Color
- Username Glow
- Username Strikethrough
Forum Permissions
- Special Forum Access
- Forum Password Access
- Moderate a Forum
- Change Forum Description
- Create a Forum
Images
- Create Smiley Category
- Upload Smiley
- Upload Avatar
Other Users
- Change Custom User Title
- Gift a Gift
- Donate to Another User
- Steal From a User
- Fire a Moderator
- Change Avatar
Posts
- Post Font Bold
- Post Font Color
- Post Font Face
- Post Font Italics
Threads
- Sticky a Thread
- Delete a Thread
- Color a Thread
- Thread Strikethrough
- Ban a User From a Thread

In addition to these powerful Forum Items, the Point Market has revolutionized the way shop systems can handle charging items. The Point Market allows for all market items above to be charged in two different currencies. That means you could use a combination of any of the supporting point mods to charge for each forum item. Additional features that have been recently been introduced involves the ability to set when these market items expire, allowing for only tempory or permanent purchases. Furthermore, Administrators can choose whether to enable/disable the refund capabilities of these market items as well as individual usergroup permissions that can set individual access, coupon capabilities, and an individual maximum purchase.

Other powerful enhancements to our forum item store system allows for Administrators to set the ability of charging for category access in order to access these market items. This will give the user's one more way to stay active and motivated on accumulating points in order to use them for store purchases. A recently introduced user requested feature also allows for subcategories and the ability to create an unlimited amount of duplicate forum items by using the above market items as a template for a new item. This means you can choose to set different quotos for each market item and can truly personalize your forum item store section.

Bank & Paycheck Center
The Point Market version 3.1x series has done some extreme enhancements to how point banking is now handled. Users have the classic ability to be able to use a bank to store two different point system currencies of the Administrators choosing. These currencies are stored and can accumulate primary usergroup interest that is set during a specified time period by the Administrator. Below is an exact list of Banking features.

Bank Features
- Store Two Currencies that are protected from all steal protection
- Allow for interest to be earned controlled by Administrators on a payout period
- Set minimum/maximum fees (usergroup controlled)
- Set minimum/maximum withdraw and deposit amounts (usergroup controlled)

A main change in the Point Market that makes it so different is the concept of receiving paychecks. Many forums that use point systems want the ability to pay their staff or special usergroups with a paycheck to say thanks as a form of payment. The Point Market gives you the ability to pay users on a specified period by the Administrator. There best part about this paycheck feature is the Admin can choose two different amounts that a user can earn. Admins can choose a set amount that is guarenteed during each pay period OR Administrators can choose for the user to earn a percentage of Point Market Forum Item Sales during a specified period that is defined by their primary usergroup. This allows for staff to become almost salesman like within the Market and can also guarentee a fluxuating paycheck based off of activiity.

Virtual & Physical Online Store
Based off of user demands, the Point Market has created a store system that users can create virtual and physical items and sell it on the website with users using points to purchase these items. Administrators can create an unlimited amount of store items. These items have the ability to:

Store Features
- Purchase an unlimited products by the Admin
- Multiple shipping methods (Email, Mail, Downloadable, No Shipping)
- Control shipping costs if by Mail based off a user's Country
- Up to 5 screenshots uploaded by the Administrator that can be viewed
- Give detailed reviews of products purchased
- Rate products 1 to 5
- Control Quantity of available products
- Coupons Enabled

A designated Administrator will immediately be notified via Private Message of a purchase. From there an Admin can enter the Admin Control Panel and choose to ship the product in whatever method the user chose. A log of this purchase is also available for the user who can view it in their User Purchase history as well as the shipping status of the item.

Point Currency Converter
Sometimes you need to generate actual cash revenue. Many users are willing to purchase points for money. So what better way then to introduce a cash transaction center that will allow for the Administrator to set an amount to charge for a set amount of points? This feature is supported via Paypal and allows for a great income method.

Furthermore, some sites like to use more then two currency systems and the Point Market is designed to meet those needs. Users can be able to select from a specified currency list by the Admin and change points from one system to the next at a fee chosen by the Administrator. This is a pretty convinient method to use every point system possible and allow for user's main goal to be as active as possible so that they can adjust their points to their liking.


Lottery & Gambling
Gambling these days are in high demand and the Point Market has set to address it. The Point Market has created 3 seperate games to allow user's to gamble their points on multiplying their points. Those 3 games are:

- Match The Card
- Higher Card
- Lottery

The Lottery has a built in expiration set by the Administrators and can also be used with coupons for discounts. Massive jackpots can be set at a starting amount or at 0 and an adjustable charge price as well. Administrators can also control the odds of the other two games. Finally a powerful Administrative backend will allow for Admins to see information and statistics related to the lottery.


Other Administrative Features
The Point Market has a series of features in addition to the main 5 hacks that creates the Point Market. The author truly believes the reason the Point Market is truly the best shop system is the easy Admin system combined with the powerful feature capabilities. Below are some of the main Administrative features:

- Advanced individual Administrative Access features (controlled by superadmin)
- Detailed Moderator/Supermoderator Control Panel (features controlled by superadmin)
- Informative statistics related to purchases & activity within the market
- History & Transaction log of all Forum Market Items
- Controllable Coupon creation with pages of advanced controls
- Maintenance section used for debugging purposes and serious updates
- Detailed Gift/Ribbon/Award section
- Banking paycheck creation & transaction history


vBulletin.org Mods This Works With
1) vBExperience (Point Market v3.0+)
2) uCash
3) vBookie
4) Kbank
5) vBCredits Deluxe II
6) vBActivity

Integration With Other Mods
This hack has been intended to be integrated with a 3rd party point system. You can choose to either use a hack added on vBulletin.org or write your own point system. The hack is dependent on the user table having a point/credit/cash field within the user control panel. Please note that vBExperience will only work with the Point Market version 3x series.

In addition, if you do not want to integrate this hack directly with another point system. You can still install this hack and use the reputation field, which will allow user's to purchase items based off of their reputation. I suggest if you choose this option that you set all prices to not include any decimals, as it will be useless and cause unwanted errors.

As of the 3.1x series, the Point Market has begun to create individual forum items related to other modifications offered on vBulletin.org. If you would like your hack to have a special feature &/or capability that can be purchased within the Point Market, just let the developer of this modification know. I will gladly work with any developer to create purchaseable forum items within the Point Market that enhances your modification.


Support Policy
The only available modification that can be downloaded now is the 3.1x alpha/beta series. The reason why I have it marked in such titles is because the bugs that are remaining seem to be very minimal and the product is pretty stable. That being said their are still a few features that have not been scripted and are marked in a lime green color above in my post. Those features still might not correctly function once they are introduced into the beta series of the 3.1x series and users should use some caution. That being said, I will do my best to offer support in this thread. In order to gain support, you must have downloaded the Point Market product and be listed as installed with the latest available version. PLEASE NOTE: if you are having an issue, please provide the following information
- URL to the page you are experiencing problems or a database error
- Primary Point Field name (What point system are you using)
- Secondary Point Field name (What point system are you using
I need to know these in order to fix the majority of problems I need to know this information as there are so many combinations and point systems that can cause different problems, this is the only way I can help replicate an error in order to fix it


IMPORTANT UPGRADE INFORMATION: After you have upgraded from version 1.0.4 to version 2x, please visit the Maintenance section of the Admin CP. Please update the transaction counter and refund counter so that user's information is displayed accurately. Do not use the User Title updater unless you have recently run vBulletin's User Title and Rank Updater in the maintenance section of vBulletin's Admin CP. Please note that only purchases after 2.0.1 is installed can be fixed on the User Title Updater within the Market Admin CP. If you are upgrading to the 3.1x series for the first time, please run the update Maintenance scrippted called Forum Expirations to deal with expired forum items.

Screenshot and release information: To view specific information about the historical releases of the Point Market, please visit this post:
https://vborg.vbsupport.ru/showpost....14&postcount=2
This includes a changelog summary and screenshots of the latest version of the Point Market.

Lastly, I ask all users who install it to kindly click the install button and please rate my product as it is my motivation for future versions of this product.

3.1.0 Gold Release Information
Visit https://vborg.vbsupport.ru/showpost....postcount=1861 for 3.1.0 Gold Release. This Upgrade IS REQUIRED!

The following directories must be chmodded to 777
/customavatars/
/images/smilies/
/images/pointmarket/store/
/pointmarket/downloads/

[Sai01]

how can you get it to install? i can't even get it to install on my 4.1.3 vbulletin. database error all the time is all i get.

*is waiting for beta4 for the fix*

[Skyrider]

Originally Posted by Sai01

how can you get it to install? i can't even get it to install on my 4.1.3 vbulletin. database error all the time is all i get.

*is waiting for beta4 for the fix*

Check a few pages back, someone attached the plugin as a temp fix.

[netpants]

I am getting this error, anyone know how to fix it?

vB 4.1.3

Cannot use object of type mysqli_result as array in /home/username/public_html/pointmarket/market_purchase.php

[djdog]

Uploading Beta 3, I get the SQL Error:

Database error in vBulletin 4.0.1:

Invalid SQL:
ALTER TABLE market_store ADD `image_big_3` INT( 12 ) NOT NULL AFTER `image_big_3`;

MySQL Error   : Duplicate column name 'image_big_3'
Error Number  : 1060
Request Date  : Wednesday, April 20th 2011 @ 02:10:08 AM
Error Date    : Wednesday, April 20th 2011 @ 02:10:09 AM
Script        : http://hostedtalk.com/admincp/plugin.php?do=productimport
Referrer      : http://hostedtalk.com/admincp/plugin.php?do=productadd
IP Address    : 99.35.212.62
Username      : Cory
Classname     : vB_Database
MySQL Version : 5.0.91-community-log

I've read back a few posts:

Originally Posted by guest9

Ok this is how I solved the issue

0. Dropped the tables/database which was created on my first attempt of the importing the xml file (starts with the market_)
1. Downloaded the latest version & uploaded the files except the xml
2. Downloaded version 3.1.0 beta 2.zip and imported this version of xml
3. Now I have imported the latest version xml file by setting the overwrite to "Yes".
Success!

Originally Posted by TheMayhem

Or you could just edit the product file and take:

ALTER TABLE market_store ADD `image_big_3` INT( 12 ) NOT NULL AFTER `image_big_3`;

And make it

ALTER TABLE market_store ADD `image_big_3` INT( 12 ) NOT NULL AFTER `image_big_2`;

Save and done I can't confirm if it'll work but I'm 99% sure it will

Tried these with and without reading (first try), but to no avail - This did not work.

Edited to use Code Tags:

Originally Posted by tandalier

so i checked the xml and here's the solution - maybe you can change it in the download.

you must change one part in the product-pointmarket.xml

change

$db->query_write("ALTER TABLE " . TABLE_PREFIX . "market_store ADD `image_big_3` INT( 12 ) NOT NULL AFTER `image_big_2`");
print "<b>3.1.0:</b> Updating Market Store Table... Adding `image_big_3` column";
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "market_store ADD `image_big_3` INT( 12 ) NOT NULL AFTER `image_big_3`");
print "<b>3.1.0:</b> Updating Market Store Table... Adding `image_big_4` column";
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "market_store ADD `image_big_3` INT( 12 ) NOT NULL AFTER `image_big_4`");
print "<b>3.1.0:</b> Updating Market Store Table... Adding `image_big_5` column";

to

$db->query_write("ALTER TABLE " . TABLE_PREFIX . "market_store ADD `image_big_3` INT( 12 ) NOT NULL AFTER `image_big_2`");
print "<b>3.1.0:</b> Updating Market Store Table... Adding `image_big_3` column";
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "market_store ADD `image_big_4` INT( 12 ) NOT NULL AFTER `image_big_3`");
print "<b>3.1.0:</b> Updating Market Store Table... Adding `image_big_4` column";
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "market_store ADD `image_big_5` INT( 12 ) NOT NULL AFTER `image_big_4`");
print "<b>3.1.0:</b> Updating Market Store Table... Adding `image_big_5` column";

Download is altered product file (Same edits as above)

Originally Posted by Staxed

for anyone that doesn't want to edit the file themselves, here's an updated product

This is what is happening each time; They do 'Import', but their is no 'admin settings' and market.php shows 'database error'.

When doing the alterations from what I've tried and what people asked, I get the same error from Alpha, Beta 1, Beta 2 and Altered Beta 3's. (Originally gives me the big_image error)

I get 'undisclosed_tag' - Which I assume means some where in the XML Code there must be an undisclosed tag causing it not install.

I'm hoping a beta4 (or final) will be released soon.

or at least a temporary fix.

[Webrunner]

Originally Posted by Webrunner

Hi,
I will have two servers available in a week or so. If you want i can donate one of them for this project. (just the server, not the hosting, i can arrange for hosting if you want or maybe someone else wants to help you with that)

They are about 4 years old but still running perfectly (i hosted my 4million page-views a month forum on them)

Also i have a few questions which i can't seem to figure out:

1. How do i add font faces to a product that changes for instance the post font face?
2. When i purchase a topic color it shows me a drop-down with colors. Also it states me to enter a topic ID to identify the topic that needs to be colored. But there is no field to enter a topic ID.
What am idoing wrong?

Anyone?

I have another question.
My users are complaining that they "bought" a post color and that the post color isn't visible in the social group discussions.
Does anyone know how to get this done?

[TheMayhem]

Yeah it just needs a plugin, I never really paid attention to the social groups but if I remember I'll get it on the next beta for you

I was able to get my hosting/test site up today finally so I've been working through the bugs. I'm going to schedule Beta 4 for Sunday as an Easter day release

[Webrunner]

That is great news, thanks for your support!
So i guess you won't be needing one of my servers?

[TheMayhem]

Okay I'm still planning on releasing Beta 4 this coming Sunday.

However, I was working on the Market tonight and decided to release Beta 3 again updated that corrects the product import bug as well as the store pages in the ACP. The reason you were getting that is between Beta 2 and Beta 3 I was reworking how I store images related to the Market Store and how they are viewed. I wanted to create a little slideshow for each market store product that could be scrolled through. I never completed it though and always intended releasing it on beta 4 to be tried. However, I made an error with the mysql part and never remembered to check it before I released Beta 3.

So if your using Beta 3 and already corrected the sql error, I still ask you download the updated beta3r2 zip and upgrade your database as well as the files. I'll include a more detailed release on Sunday but I want to make sure my fix works on users who experienced this bug as well as new users and the only way for me to tell is if you test it.

Keep up with the bug reports so that I can include it on Sunday's release for Beta 4. Hope all is well for all the users using this mod.

[djdog]

Downloaded.

Uploaded new files.

Uninstalled old version from Product Manager.

Result: unclosed_tag

Point Market, Admin panel doesn't display.

market.php still has a 'Database Error'.

Uninstalled using the "Newer Beta 3r2" and didn't work, I doubled check the MySQL database;

These tables were still intacted.

`market_bank_paycheck`, `market_coupons`, `market_currency`, `market_currency_transactions`;

So, I dropped them and imported the database and same error unclosed_tag.

Point Marked, admin panel doesn't show.

Uninstalled it again and;

`market_bank_paycheck`, `market_coupons`, `market_currency`, `market_currency_transactions`;

Remains, possible for converting reasons?

I'll wait for beta 4.

I'm on 4.0.1 - So wondering if this is the issue.

I have a few friends who own their own vBulletin license and I told I'm going to install it and see if it works.

Tested: 4.0.1 - Doesn't Work
Tested: 4.1.x - Works!

I would like this corrected to work on vBulletin 4.0.1 - Thanks.

[TheMayhem]

Originally Posted by djdog

Downloaded.

Uploaded new files.

Uninstalled old version from Product Manager.

Result: unclosed_tag

Point Market, Admin panel doesn't display.

market.php still has a 'Database Error'.

Uninstalled using the "Newer Beta 3r2" and didn't work, I doubled check the MySQL database;

These tables were still intacted.

`market_bank_paycheck`, `market_coupons`, `market_currency`, `market_currency_transactions`;

So, I dropped them and imported the database and same error unclosed_tag.

Point Marked, admin panel doesn't show.

Uninstalled it again and;

`market_bank_paycheck`, `market_coupons`, `market_currency`, `market_currency_transactions`;

Remains, possible for converting reasons?

I'll wait for beta 4.

I'm on 4.0.1 - So wondering if this is the issue.

I have a few friends who own their own vBulletin license and I told I'm going to install it and see if it works.

Tested: 4.0.1 - Doesn't Work
Tested: 4.1.x - Works!

I would like this corrected to work on vBulletin 4.0.1 - Thanks.

I am not going to be able to fix this error unless you provide temporary admin access for me via private message. I've had people report this bug throughout the existance of the market but no one ever provides me access to physically be able to test it and since it only occurs to a very small percent of people there is no way for me to be able to track down where the error is actually occurying.