Point Market System 3.1x

[TheMayhem]

Sure it's possible, all you have to do is disable the three steal items as well as the stolen point history and thus no one will be able to steal. :)

And yes with v3 you can use ONLY vbexperience if you want with no other combination of any other mod. Or you can use some combinations. That is all up to what suits your forum best. :)

Anyways I got off a 12 hour shift, I'm going to once again work on getting some progress but I have to be in bed by 10 due to an early dayshift tomorrow. If I fail to get it up tonight I'm off from tomorrow afternoon until Friday evening so obviously it will be out.

Thanks for the patience guys :)

[Gun Geek]

Thank you Mayhem. I couldnt talk into a PM when its done could I?

[TheMayhem]

Today's the day :)

[Astyanax]

Today's the day :)

OMFG!!! :D

[CrosseyedGamer]

Don't go teasing us like that now. I mean some of us can't handle such a thing to well.

I guess I will be the first one to ask whether it will be a morning, afternoon or one of those VB releases the come out at like 11:59pm on the day they say it will.

Either way, it is a good day!
Thanks.

[TheMayhem]

Based on my progress I'd say afternoon (EST) time. I am going to dub it a release canidate and leave version 2.1.0 up as a precaution with it, just so I can ensure it gets more testing as undoubtedly there are more bugs since really this mod is basically 4 major mods into one now.

Also, I am going to ask everyone whenever I finally release if your upgrading, overwrite all existing images as we have a brand new image pack for this one that is web 2.0 and much prettier thanks to PixelFX who helped me with that part. :)

[Mopar1973Man]

Today's the day :)

http://forum.mopar1973man.com/images/smilies/drool2.gif

Don't go teasing us like that now. I mean some of us can't handle such a thing to well.

I guess I will be the first one to ask whether it will be a morning, afternoon or one of those VB releases the come out at like 11:59pm on the day they say it will.

Either way, it is a good day!
Thanks.

No kidding... http://forum.mopar1973man.com/images/smilies/gun2.gif

But I'm still patiently waiting the release... :D

[Magz]

throwing a spanner in the works, with the release of vb 4.05, is there likeley to be any "issues" we should be aware of?

[Phoenixgal]

Can't wait!!! WOO HOO!!!

[TheMayhem]

I'm upgrading right now to vb 4.0.5 to make sure there are no surprises like there were with 4.0.4. Also, the developer of vbexperience will be providing us a german translation some time in the next few days. :)

[Senti.Jatt]

omg today is da day.. cnt wait bro... :D

[Mopar1973Man]

Hey Mayhem so you saying it should be safe to run PM 3.0 with VB 4.0.5???

If so I'll upgrade my site as well... Still droolin' :rolleyes:

[TheMayhem]

Go for it, everything seems to be working okay. I am fixing one last glitch, then doing my changelog stuff, zipping this princess up and saying it's time to play... I hope ;)

[Astyanax]

I'm counting down, maybe I can install it before bed time. ;)

[Mopar1973Man]

I'm counting down, maybe I can install it before bed time. ;)

Here here! :up:

As you can tell I'm monitoring the thread closely... :D

[Phalynx]

I suppose you need soon a new F5 key on your keyboard :)

Me too ^^

[capt gary]

I suppose you need soon a new F5 key on your keyboard :)

Me too ^^

Make that three of us. :)

[singsign]

Four of us lol cannot wait.

[Mopar1973Man]

I suppose you need soon a new F5 key on your keyboard :)

Me too ^^

I just need a new keyboard period... Most of the keys are missing letters and numbers... :eek:

But man I feel like a kid waiting for Christmas it just won't get her fast enough... LMAO!

[Phoenixgal]

I feel like such a STALKER!!! LOL

[capt gary]

It's here.....

[Mopar1973Man]

Right on!:up:

[TheMayhem]

HAPPY New Years!!!!



I mean ummm enjoy :)!

[thecelticway]

tell me sir....

should I un-install the old version (last 1) and simply reinstall your new version.....

looking forward to this very much:up:

[PixelFx]

congrats on your release

[capt gary]

TheMayhem

Just uploaded the new system and tried purchasing a tangible item to be sent by mail and got the same error I reported to you earlier saying.

Transaction Information

You have not filled out all required fields needed to ship this product to you.


Any ideas??

[TheMayhem]

tell me sir....

should I un-install the old version (last 1) and simply reinstall your new version.....

looking forward to this very much:up:

You can upgrade from your old version if you want. Ideally everything works best if you do a fresh install versus upgrade; however, both seemed to work well when I had people testing. Really it is up to you but if you upgrade, make sure you overwrite ALL FILES AND IMAGES and click YES to overwrite the product :)

[thecelticway]

You can upgrade from your old version if you want. Ideally everything works best if you do a fresh install versus upgrade; however, both seemed to work well when I had people testing. Really it is up to you but if you upgrade, make sure you overwrite ALL FILES AND IMAGES and click YES to overwrite the product :)

many thanks~~~~~ will reinstall tonight:up:

[CrosseyedGamer]

Wow, it is 80 here in MN on Christmas day. Just freakin Awesome.

Let the uploading begin.
Thanks.

[Astyanax]

It works fine here! :)
Some questions:

1. What is Premium Addon Features and how can I enable/use them?
2. In "Converter" it says: "There are no active conversions available.". What does this mean?
3. What is the best MOD except for vBExperience that works with this MOD (to use in the secondary points field)?
4. This shows up in forum posts:
https://vborg.vbsupport.ru/
Can I remove it/change it so it look better?

[Magz]

Upgraded to vbulletin 4.05, installed v3, so far, so good

:)

[mikem164]

Hey Mayhem I get this error in ACP Category *[]* after upgrade, then uninstalled and fresh install and same thing. here's a screen shot of Error and source, thanks bud, keep up the good work!

[mikem164]

I was going to delete above post, but I'm leaving it as to help others. On occasion, FTP transfer corrupts a file and figured what the heck, I re upped all files and Voila! Error is gone. Always good to go back and re up files when you are the only one having an issue guys, thanks Mayhem.

[TheMayhem]

It works fine here! :)
Some questions:

1. What is Premium Addon Features and how can I enable/use them?
2. In "Converter" it says: "There are no active conversions available.". What does this mean?
3. What is the best MOD except for vBExperience that works with this MOD (to use in the secondary points field)?
4. This shows up in forum posts:
http://www.forumbilder.se/images/59620101216015c13.jpg
Can I remove it/change it so it look better?

1) Premium Addon Features are additional features a user can purchase to play with the store such as the Stolen Point History, where they can pay points to see who has stolen from them or how much that person has stolen. The Gambling / Lottery page is part of the premium addon feature for users to purchase access where they can earn points by gambling. You can choose the prices for users to purchase under the Forum Items page in the admin cp where it is in its own little category.

2) You need to setup conversion or pay for points in the Admin CP and make sure they are enabled. Conversions allows your users to take points from one point field and transfer it to another. The user is charged a fee (either real US money via paypal or points) depending on what you choose.

3) Personally I really like using vbexperience. I'd combine it with either vbcredits or ucash. Vbcredits is far more advanced then uCash on functionality and features, however since it is a secondary point system either or works well. Or you could use vBookie and allow people to earn points through gambling as a secondary point mod.

4) That looks like a gift, and you haven't added or removed categories yet for your gifts to fall under. Part of version 3 was the introduction of gift categories, which helps separate the gifts for a more attractive and better look.

[argothiusz]

Not sure if its conflicted with any other mod but my glowing feature doesnt work. Also, when I hover over the reputation image or a member username I get this

<span class='glow_008000'>TestAccount</span></a><br /><span class='glow_FF0000'><span style='color: #006400'>TestAccount</span></span><a href='www.forums.com'> has a reputation beyond repute

This is my default html for that usergroup
<b><span align='justify' style='border: 1px solid #000; background-color: white; color: #EE0000;'></b></span>

[Mopar1973Man]

So far so good here... I'm digging and playing with the software and seeing how far I can
push it...:up:

Now I got a idea i'm going to insert a field into the "User" database and make it lets say Cash. So I'm going to use the vBEXperience and this dummy cash field and make a conversion for points to cash...

Is this still legit in usage of Point Market? well I'm going to find out really soon...:eek:

[TheMayhem]

Sooo looking for feedback, what do you guys think? :)

[Mopar1973Man]

So far so good...:up: The only thing I found that need a bit of something... Like a delete function is point converter... If you mess up a entry and need to delete one there is no way to delete it only to disable it.

Other than that I love it so far... I'm still working on my design and layout of the functions. So it going to be interesting...

Oh Mayhem... I got another one that pop to mind! Is there any way to buy a subscription and not a actual usergroup? Because I'm building a point system for subscription base... Say you need X amount of points to buy 1 year subscription for premium membership.

How about another angle too? (Yeah I'm full of idea) The previous vBexperience was rigged with its market ot buy downloads from Downloads II or simular mod is that possible with PM?

I'm going to help you build the greatest mod for VB4 yet... :D

[deusgog]

Hi, is a little bug (in 3.0) in the admin "do addgift" result "addgiftcat". Is not posible in Admin, add gift in Market Gift, only Categorys.

[fernas]

The only thing that Point Market System needs for be the perfect shop mod is add profile music. Do you have any plan for this?

Sorry my English.

[singsign]

Not trying to be rude at all what so ever I know you have worked hard on this, but would I be able to remove "current version" xxx ? Since all the links in general are on the side users would click and end up here?

[deusgog]

Other problem

In the Lotery and purchases list show "F j, Y, g:i a" not the date

Vb 4.0.4

[Phalynx]

Woohooo! Finally it's here. Impatiently waited yesterday and fall asleep, my head felt down on the keyboard. Now I have the F5-Key printed on my forehead! :D

Gratz for the RC1, it seems very stable to me. Nice presentation with the fresh icons.

Thanks for the promotion to a supporter. Primary I will help people who are using this with vBExperience, as this is the replacement for the good old vBExperience 3 Shop.

[Phalynx]

How about another angle too? (Yeah I'm full of idea) The previous vBexperience was rigged with its market ot buy downloads from Downloads II or simular mod is that possible with PM?

Please click "Mark as Installed", thanks.

I still have the plugins for that and will forward this to TheMayhem.

[Senti.Jatt]

omg god atlst thnxs a lottttttttttttt... :d

[Pamela]

Love the new features and graphics! Awesome job on 3.0! Thanks Mayhem...awesome job! :D

[capt gary]

Mayhem

Just uploaded the new system and tried purchasing a tangible item to be sent by mail and got the same error I reported to you earlier saying.

Transaction Information

You have not filled out all required fields needed to ship this product to you.


Any ideas??

So am I the only one using the Store Feature for Mailing an item? I created the item, place it in the Store, fill out the information...yes ALL boxes..., click buy and get the information above.

Suggestions / Comments / Fixes????

Thanks,
CG

[Combattente]

Point Market Gifts aren't shown below the postbit anymore.. you don't see them below the user's informations in posts anymore.

The settings are ok so I don't really understand why the gifts aren't shown..

Can someone help me?

[Combattente]

I'm using vB 4.0.5 anyways.

[Mopar1973Man]

Please click "Mark as Installed", thanks.

I still have the plugins for that and will forward this to TheMayhem.

Opps... My bad I was waiting for so long for the mod I space it out... (Sorry Mayhem!) :o

[thecelticway]

strange~~~~~ I uninstantiated the old 1.0.4 version and installed the 2.1.0 version, adjusted the admin & user groups permissions and all plug-ins appear to be active ..... but when I enter the "Market" I can see the old 1.0.4 version even though the build IS 2.1.0...... wont let me buy anything or access the lottery /gambling
or give gifts..... what am I missing

HELP~~~~~~
:erm:




mmmmmm :confused:.. still showing the 1.0.4 version in the "Market" even after I've un-installed the product and made a fresh install of the 3.0 version. dont show anything when in the market

Please help~~~~~~:up:

[Phalynx]

mmmmmm :confused:.. still showing the 1.0.4 version in the "Market" even after I've un-installed the product and made a fresh install of the 3.0 version. dont show anything when in the market

Please help~~~~~~:up:

Please check if you have uploaded the PHP files correctly. The file market.php contains the version.

[thecelticway]

Please check if you have uploaded the PHP files correctly. The file market.php contains the version.

I believe I have.....with the exception of these 3 php files showing in the attachment .....
can you tell me where these go as I could have out them in the wrong place

Thanks

[Phalynx]

I believe I have.....with the exception of these 3 php files showing in the attachment .....
can you tell me where these go as I could have out them in the wrong place

Thanks

Place them in the root, also where your forum.php resides.

[thecelticway]

Place them in the root, also where your forum.php resides.

yip~~~~~~ that done it:up:

All now working and looking great........ members will love this

many thanks for your help

[ijuanjor]

I want to raise Point Market's xml System
And this mistake be arranged.

Importing Product, Please It Waits...

[:]

I warn of the Forum

* Unclosed_tag

Help me

[Yellow Slider]

I was using vBc1, and now I'm using vBc2 Deluxe, I don't really need all the store features, just donation that work perfectly, vBc2 isn't supplying that right now, I must have a credits addon in order to store points in the DB? do you create your own 'credits_field' in the users table?

the features I need -
Donations - Immediate donating, without any delays (vBc deluxe is delaying the transfer until the user who got the donation is logging into the forums, this had brought me so many headaches, hundreds of users have complained about that.
Admin Donation
Fees for donations
a decent logging system for donations.

Does this supplies what I need? (+more off course)
Thanks.

by the way,
4) vBCredits 1.5x Gold (vb4) - vBc1.5 doesn't supports vB4 yet :(

[golfing123]

Hey everyone

I tried everything to make the point field work on the point market hack

so can someone help me with this please

[BrightStar]

store_default.png is missing from the images folder?

[ijuanjor]

I want to raise the Market of Point System
But I have a mistake when I raise the XML, load and when it has just loaded this message be arranged

Importing the Product, Please This Waits...

[:]

I notice of the Forum

* Unclosed_tag

Help me since I solve this mistake
Thank you for the market of system point I wait for his response

[PixelFx]

4) vBCredits 1.5x Gold (vb4) - vBc1.5 doesn't supports vB4 yet :(

its in the works

[hcmls.net]

I cant use Lottery / Gambling :| How must I config it?

[golfing123]

Hey everyone

I tried everything to make the point field work on the point market hack

so can someone help me with this please

[TheMayhem]

I cant use Lottery / Gambling :| How must I config it?

Do you mean Administratively in the Admin CP or user related? What errors are you getting? In order for users to access the Lottery / Gambling section, they must purchase access to it under the category called: Market Features. The forum item name is: Gambling Access. Once they purchase that then they need to visit the Gambling / Lottery feature on the left side which then becomes active.

If you want users to be able to access this without having to pay, simply make the Gambling Access forum item price equal to 0 (free). :)


Hey everyone

I tried everything to make the point field work on the point market hack

so can someone help me with this please

1) Go to the Settings & Staff section page
2) Select Point Market: Global Settings
3) Primary Point Field This is your point field. You need to use a point mod and insert the point field into here. So here is an example, if you use the point mod called uCash, which can be downloaded here on vb.org you would type in ucash If you are using vBExperience, you would type in market_xperience. Just remember you need some kind of point mod to make the Point Market work. If you can't get it, let me know what point mod you are using and I'll tell you exactly what to type in.
4) Primary Points Name Type in something like points, money, cash, credits, or any of those for this. You just need to fill this in on what you want to call your currency.

Lastly, the Point Market will still start flagging errors if you don't have any points and everyone is broke. So make sure you have at least .00001 points or more ;)

I want to raise the Market of Point System
But I have a mistake when I raise the XML, load and when it has just loaded this message be arranged

Importing the Product, Please This Waits...

[:]

I notice of the Forum

* Unclosed_tag

Help me since I solve this mistake
Thank you for the market of system point I wait for his response

What do you mean by raise the XML? Please redownload the Point Market and uninstall it. Import the point market product into the Plugin and Product Manager and select YES to overwrite. It should work as the error your getting makes me think your importing something other then the point market since no one else has gotten an unclosed_tag error. That kind of error only occurs if there is an unclosed tag in which case everyone or no one would be getting it so I'm pretty sure you are importing something incorrectly. However if you do what I say and it still doesn't work, pm me with administrative access to your forum if you don't mind and I'll be more then glad to take a look. :)






Lastly, I saw some people donated to me so I wanted to say thanks. Your donations are very appreciated :)

[Magz]

I may be blind, but where does a user deposit or withdrawl?

Usergorups are set to alow, but i see no where to actually do this :)

Thanks

[ijuanjor]

Thank you friend for his response installs everything again, and it follows aparesiendo this type of mistake on having risen,

* Unclosed_tag

Since I do to remove it of unclosed_tad haver if I could help

Thank you for the point of market

[TheMayhem]

Thank you friend for his response installs everything again, and it follows aparesiendo this type of mistake on having risen,

* Unclosed_tag

Since I do to remove it of unclosed_tad haver if I could help

Thank you for the point of market

I don't understand your English???

[Ken Sanders]

Hey everyone

I tried everything to make the point field work on the point market hack

so can someone help me with this please
I am having the same problem. I am using VBxperience and when I set the point field to market_xperience I am getting a database error. I have updated both xperience and point market to no avail.

Here is my DB error:
Database error in vBulletin 4.0.4:

Invalid SQL:
update user set market_xperience=, xperience_done='0' where userid='1';

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' xperience_done='0' where userid='1'' at line 1
Error Number : 1064
Request Date : Friday, July 16th 2010 @ 07:16:17 PM
Error Date : Friday, July 16th 2010 @ 07:16:17 PM
Script : http://mysite.com/forum/market.php
Referrer : http://mysite.com/forum/xperience.php?go=ranking
IP Address :xxx
Username : xxx
Classname : vB_Database
MySQL Version : 5.1.47-community-log


EDIT: Scratch all this. I was having a senior moment. Once I named Primary Points Name to market, all is well. Sorry for the non post here :(

[Kamor]

Database error in vBulletin 4.0.4:

Invalid SQL:
update user set market_xperience=, xperience_done='0' where userid='1';

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' xperience_done='0' where userid='1'' at line 1
Error Number : 1064
Request Date : Friday, July 16th 2010 @ 12:10:17 PM
Error Date : Friday, July 16th 2010 @ 12:10:17 PM
Script : http://mysite.com/forum/market.php
Referrer : http://mysite.com/forum/xperience.php?go=ranking
IP Address :xxx
Username : xxx
Classname : vB_Database
MySQL Version : 5.1.47-community-log
///////////////////////////////////////////////////

Any fix to this? I did market_xperience and it's still not working.
Primary Points is named Plox but it's not going through.

-------------------------

Nevermind. I read above.
I didn't have any Plox. XD

[ijuanjor]

Spanish

disculpe solo hablo espa?ol pero me gustaria. que me ayudara como deshabilitar Unclosed_tag , se le agradeceria mucho, he desinstalado el Point Market System y he vuelto a instalarlo y me sale el mismo error.
Foto :

https://vborg.vbsupport.ru/external/2010/07/36.jpg

gracias por el Point Market System

English :

sorry I only speak Spanish but I would like. help me how to disable Unclosed_tag, would greatly appreciate it, I uninstalled the Point Market System and I have reinstalled and I get the same error.

Photo:

https://vborg.vbsupport.ru/external/2010/07/36.jpg

thanks for the Market Point System

[Combattente]

Point Market Gifts aren't shown below the postbit anymore.. you don't see them below the user's informations in posts anymore.

The settings are ok so I don't really understand why the gifts aren't shown..

Can someone help me?

I'm using vB 4.0.5 anyways.

Can anyone please help me?

[Senti.Jatt]

Can someone help me plz.
how can i add more gifts in "Point Market Gifts" all i can add is new category..
where to check the gifts we purchased from the gifts created by others..
N how to access Bank..
thnxs

[DigitalDark]

TheMayhem I've translated the PointMarket to spanish. It's my first job in traslating vBulletin products. I've seen other translations and I've writed a xml file that I don't know if has the correct syntax in order to allow vBulletin recognize it.

And I've an error while I'm trying to update user titles:

Database error in vBulletin 4.0.5:

Invalid SQL:
update vbuser set `customtitle`=2, usertitle='Lord O'Donnell' where userid='20';

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Donnell' where userid='20'' at line 1
Error Number : 1064
Request Date : Saturday, July 17th 2010 @ 08:06:54 AM
Error Date : Saturday, July 17th 2010 @ 08:06:54 AM
Script : http://www.page.net/foro/admincp/market.php?do=updateusertitle
Referrer : http://www.page.net/foro/admincp/market.php?do=maintenance
IP Address : 83.40.220.210
Username : Dark
Classname : vB_Database
MySQL Version : 5.1.47-community-log

Thanks

[Yellow Slider]

I was using vBc1, and now I'm using vBc2 Deluxe, I don't really need all the store features, just donation that work perfectly, vBc2 isn't supplying that right now, I must have a credits addon in order to store points in the DB? do you create your own 'credits_field' in the users table?

the features I need -
Donations - Immediate donating, without any delays (vBc deluxe is delaying the transfer until the user who got the donation is logging into the forums, this had brought me so many headaches, hundreds of users have complained about that.
Admin Donation
Fees for donations
a decent logging system for donations.

Does this supplies what I need? (+more off course)
Thanks.

by the way,
4) vBCredits 1.5x Gold (vb4) - vBc1.5 doesn't supports vB4 yet :(

....

[Yellow Slider]

tried to Install, it stuck when we're trying to import the XML.. 4.0.4
:\

[Juggernaut]

Great work TheMayhem, the new store looks very nice :D
Only thing is, the title and username modifications still don't appear with CSS saved as files option. :(

[Gun Geek]

donations dont appear to be working. Donated amount does not get subtracted from donating member or added to the user getting the donation.Yet it is on the history.

EDIT: Never mind it appears to take some time.

[Gun Geek]

Color a thread does not give you a box to input the forum id.

[TheMayhem]

Color a thread does not give you a box to input the forum id.

Color a thread actually colors all threads of that user. I gotta redo the naming of it for future releases but it is like a colored user title or colored username only it displays on the forumdisplay page.

tried to Install, it stuck when we're trying to import the XML.. 4.0.4
:\

PM me your forum url and if possible give me temp admin access so I can see why it won't work for you but will for everyone else.

[Gun Geek]

Found a few more bugs or maybe I configured something wrong.

Custom Gifts - Creating a gift to sell works great. However when someone buys the gift it does not seem to give it to them. Also in the purchases history it shows up blank. Look at the picture below, See the two blank entries, those are custom gifts. Also it would be nice to allow the user creating a custom gift to set how many they want to sell. Also it does not give the points to the user selling the custom gift.

[ImagenSkins]

Eventhough the percent rate for steals is set to 100%, It won't steal.
I am using vbExperience with the Points Market. Please help, thanks in advance.

[ladycroft]

Hello
I have installed the market and wanted to ask whether this is a German languagepack?

[Budget101]

Uninstall doesn't appear to stop the following database error:

Database error in vBulletin 4.0.2:

Invalid SQL:

SELECT languageid,
phrasegroup_global AS phrasegroup_global,
phrasegroup_pointmarket AS phrasegroup_pointmarket,
options AS lang_options,
languagecode AS lang_code,
charset AS lang_charset,
locale AS lang_locale,
imagesoverride AS lang_imagesoverride,
dateoverride AS lang_dateoverride,
timeoverride AS lang_timeoverride,
registereddateoverride AS lang_registereddateoverride,
calformat1override AS lang_calformat1override,
calformat2override AS lang_calformat2override,
logdateoverride AS lang_logdateoverride,
decimalsep AS lang_decimalsep,
thousandsep AS lang_thousandsep
FROM language
WHERE languageid = 1;

MySQL Error : Unknown column 'phrasegroup_pointmarket' in 'field list'
Error Number : 1054
Request Date : Sunday, July 18th 2010 @ 04:07:49 AM
Error Date : Sunday, July 18th 2010 @ 04:07:49 AM
Script : http://www.mysite.com/market.php?do=cat&id=27

[Phoenixgal]

Database error in vBulletin 4.0.2:

Invalid SQL:

SELECT languageid,
phrasegroup_global AS phrasegroup_global,
phrasegroup_pointmarket AS phrasegroup_pointmarket,
options AS lang_options,
languagecode AS lang_code,
charset AS lang_charset,
locale AS lang_locale,
imagesoverride AS lang_imagesoverride,
dateoverride AS lang_dateoverride,
timeoverride AS lang_timeoverride,
registereddateoverride AS lang_registereddateoverride,
calformat1override AS lang_calformat1override,
calformat2override AS lang_calformat2override,
logdateoverride AS lang_logdateoverride,
decimalsep AS lang_decimalsep,
thousandsep AS lang_thousandsep
FROM language
WHERE languageid = 1;

MySQL Error : Unknown column 'phrasegroup_pointmarket' in 'field list'
Error Number : 1054
Request Date : Sunday, July 18th 2010 @ 04:07:49 AM
Error Date : Sunday, July 18th 2010 @ 04:07:49 AM
Script : http://www.mysite.com/market.php?do=cat&id=27

I get this same database error....

[TheMayhem]

Budget101 and PhoenixGal, do you two use multiple language packs on your forum?

Also, I noticed you guys BOTH are using vb 4.0.2. Would an upgrade to 4.0.5 fix your problem?

[Phalynx]

Hello
I have installed the market and wanted to ask whether this is a German languagepack?

A german translation is already in work.

[TheMayhem]

I'm going to be releasing RC 2 later today I think. I am traveling to Santa Monica & LA, California on Tuesday and will be gone all week so I wanted you guys to have the most updated version with less bugs. As of right now I have 8 bug fixes for RC 2. If I replied to one of your reported bugs, please reply answering my questions so I can include a fix for it in the release. Otherwise it will have to wait til RC 3 / Gold.

[Budget101]

Budget101 and PhoenixGal, do you two use multiple language packs on your forum?

Also, I noticed you guys BOTH are using vb 4.0.2. Would an upgrade to 4.0.5 fix your problem?

No, I don't use multiple languages, only 1.

As for upgrading, not a possibility, 4.0.5 appears to have enough problems.

It appears that the removal of the product does not remove the database fields that it created. Perhaps you could create Kill Market like the Kill-Experience that phalynx created.

[ladycroft]

A german translation is already in work.
Thanks for the info.
When do you think the translation will be ready?

[TheMayhem]

No, I don't use multiple languages, only 1.

As for upgrading, not a possibility, 4.0.5 appears to have enough problems.

It appears that the removal of the product does not remove the database fields that it created. Perhaps you could create Kill Market like the Kill-Experience that phalynx created.

The reason you are getting the error you are is because the phrases aren't being included correctly which is why you get the database error that you do. Do this, install the point market. If you still get the errors send me a pm and I'll create a custom phrase file and send it to you. That should fix the error your suffering from. If it doesn't then we'll go from there and force it to work ;)

[kylek]

This was asked in the thread but I cant find the answer so will ask again?

Can a custom made gift have an expiry time? Example - you create a drink and once purchased it expires after one week and is removed from the user. This way more points or credits would be consumed by members.

[TheMayhem]

No as of now there is no way to cutoff based on time. I was going to script it for the 3.0 version; however, I simply just ran out of time. I still fully plan on having time limits on gifts and certain purchases in the 3x series but it won't be on the initial release.

There are ways you can limit the amount of gifts being displayed to a set number such as 10, which would constantly make the user have to keep repurchasing.

RC 2 is now released. There are 9 total bug fixes in it to give you a more stable product.

[Juggernaut]

The only thing that does't seem to work is the name and title glow features with styles as files, otherwise, exelent mod :D

[TheMayhem]

The only thing that does't seem to work is the name and title glow features with styles as files, otherwise, exelent mod :D

I didn't come up with a fix for that yet and I was trying to nail down as many bugs in one day as possible. I'll get it working before Gold, I promise. :)

[Gun Geek]

Mayhem, what about the custom gifts post that I had made was that fixed in RC2? It looks like the image is just missing, that it is not inserting the url to the image.

[Gun Geek]

Also as an admin if someone chooses a horrible thread color, how can we change it.

[random1231231231]

Thanks for the new RC.2 release :D

[lemonadesoda]

typo noticed in screenshot: withdrawel withdrawal

[random1231231231]

typo noticed in screenshot: withdrawel withdrawalYou're right..

However, version of "RC2" is still "RC1" on admincp.
The version hasn't been updated on the XML file.

[Arae]

I cant use the Market.

The Points Market is currently disabled. This can occur for a number of reasons. The most likely reason is that you currently do not have any earned points. In order to access the Point Market you must have at least 1 point. Another reason you could be seeing this error is the point field entered into the Point Market Control Panel is incorrect or was not found.

But I've entered vBExperience on that fieldname.
I don't know what I did something wrong.

[Gemma]

I cant use the Market.



But I've entered vBExperience on that fieldname.
I don't know what I did something wrong.

Did you enter vbExperience or market_xperience in the points field?

It should be market_xperience

[Arae]

Thank you very much :)

And this has happened now. Anything I need to do?

Trish, you do not have permission to access this page. This could be due to one of several reasons:

Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.

[VipQBoy]

https://vborg.vbsupport.ru/

can u fix that :-/

[TheMayhem]

You're right..

However, version of "RC2" is still "RC1" on admincp.
The version hasn't been updated on the XML file.

Go ahead and import it anyways and select YES to overwrite. I think I changed one template and a few phrases on the product file and that was it. Almost all bugs I found were file related.

http://img834.imageshack.us/img834/6784/21686232.png

can u fix that :-/

Tell me, what point systems are you using and what browser were you viewing your forums on when you took that screenshot?

[Budget101]

Does this mod have a notification system - to notify the admins/mods when a purchase is made?

[TheMayhem]

Does this mod have a notification system - to notify the admins/mods when a purchase is made?

No :( I dropped the ball on that :(

[txsbmw]

Just a quick question to make sure I set this up right as far as users being able to buy points via paypal. I clicked create on Payment Converter. In the point field I put market_xperience (is this correct?) Set Amount I put 5000.00 (they will get 5000.00 points) Paypal Email (my paypal email address) Fee, I put 50.00 (It will cost them 50.00 real money to buy 5000.00 in points).

Is this all I need to do in order for users to purchase points using real money and did I fill it out correctly?

[svvish]

when upgrading from 3.0rc1 to 3.0rc2 do we uninstall or just overwrite?

[TheMayhem]

Just a quick question to make sure I set this up right as far as users being able to buy points via paypal. I clicked create on Payment Converter. In the point field I put market_xperience (is this correct?) Set Amount I put 5000.00 (they will get 5000.00 points) Paypal Email (my paypal email address) Fee, I put 50.00 (It will cost them 50.00 real money to buy 5000.00 in points).

Is this all I need to do in order for users to purchase points using real money and did I fill it out correctly?

You got it :). Don't forget to put your userid for the person to notify :)

when upgrading from 3.0rc1 to 3.0rc2 do we uninstall or just overwrite?

Just overwrite :)

[Magz]

Mayhem, where do we see a link to the banking section. My usergorup is set to use it, but for life of me, cant see where link to it is.

[TheMayhem]

Mayhem, where do we see a link to the banking section. My usergorup is set to use it, but for life of me, cant see where link to it is.

Look at the navbar, you should see the Market tab and underneath it you should see:

Market Bank Transactions Converter

[Bombera]

Thanks for you work.Have one problem.Create store item in admin and if I can buy in Market I have this error:

I upgrade from version 2.1
Database error in vBulletin 4.0.4:

Invalid SQL:
select * from market_store_transactions where marketid ='1' and userid='1';

MySQL Error : Table '3696-mobil-cesti.market_store_transactions' doesn't exist
Error Number : 1146
Request Date : Monday, July 19th 2010 @ 07:37:23 PM
Error Date : Monday, July 19th 2010 @ 07:37:23 PM
Script : http://www.mobil-cestiny.cz/market.php?do=storeitem&id=1
Referrer :
IP Address : 88.102.3.122
Username : Bombera
Classname : vB_Database
MySQL Version : 5.0.51a-24+lenny2-log

[MichelangeloITA]

Thanks for you work.Have one problem.Create store item in admin and if I can buy in Market I have this error:

I upgrade from version 2.1

Same here ;)

Is there any easier way to put and update images of item/products?

What about a registration form (address etc.) to fill in order to recieve real goods???

Great job anyway :D

[txsbmw]

You got it :). Don't forget to put your userid for the person to notify :)


Awesome. I do have a suggestion, because it was hard for me to find on the user end the link to buy points. Could we have a tab that says Purchase (or Buy) Points next to Earn Points, so users could easily find it instead of having to click the Converter link and going from there. Also, when you go to buy points (clicking the converter link) the currency name shows the field name, is there anyway to get it to show maybe a title that we can set instead? As of right now it shows market_xperience, instead could you maybe add an option for the admin to add their own title so instead of it showing market_xperience I could set it to show Buy Points or whatever. I know this is just a cosmetic issue, but I still wanted to bring it up :D

[Magz]

Look at the navbar, you should see the Market tab and underneath it you should see:

Market Bank Transactions Converter

My Bad,

I was expecting to see banking link in Left side Options. I also had my navbar link off, due to me having custom drop down menu.

:up:

[Magz]

Hmm, possible bug

I just made a deposit in the bank, and although it went through ok, I still had the same amount left as before i banked some.

I was then able to bank the same amount again, effectiveley Doubling my points.

Hope that makes sense.

[random1231231231]

Go ahead and import it anyways and select YES to overwrite. I think I changed one template and a few phrases on the product file and that was it. Almost all bugs I found were file related.
Please check the latest "product-pointmarket.xml" file, and i got this line.

<version>3.0.0 RC 1</version>

I guess it should be "3.0.0 RC 2"? :)

[Gun Geek]

Is anybody else having an issue with custom gifts or the lottery. I dont show the lotto paying out or custom gifts on profile or postbit.

Here is the source code I get on the postbit for custom gifts.
<div class="block">
<h5 class="blocksubhead smaller">Market Gifts</h5>
<div class="blockbody">
<div class="blockrow">



<img src="" title="">





<img src="" title="">



</div>

[maf1973]

Any chance that this addon will work with ibProArcade?

[VipQBoy]

Go ahead and import it anyways and select YES to overwrite. I think I changed one template and a few phrases on the product file and that was it. Almost all bugs I found were file related.



Tell me, what point systems are you using and what browser were you viewing your forums on when you took that screenshot?

I'm using ucash, FF browser after member change custom title

[Arae]

Thanks. :) This is addicting

[RollaJedi]

testing items right now. Is there a way to either disable the shipping dropdown, or perhaps put 'virtual item' on the dropdown? I dont want my members to have to enter their emails or put real shipping addresses on things that are just for fun on the computer that arent actually "shipped". thanks!

[jacob115]

If I upgrade, will all the gifts that have been purchased stay?

Thanks!

[concreteweb]

Sticky Threads! How can I make them expire in 30 or 60 days? Is this an option?

[FoW]

Installed 3.0.0 rc2 and love it. One issue with the buying points aspect.

When I try to set this up, it tells me to complete all required fields. I am not missing any fields. Am I missing something somewhere else.

[Combattente]

Is anybody else having an issue with custom gifts or the lottery. I dont show the lotto paying out or custom gifts on profile or postbit.

Here is the source code I get on the postbit for custom gifts.
<div class="block">
<h5 class="blocksubhead smaller">Market Gifts</h5>
<div class="blockbody">
<div class="blockrow">



<img src="" title="">





<img src="" title="">



</div>


Yeah, I'm having problems with gifts, too. Buying one takes your points but doesn't show below the profile in posts. It only shows in the profile's full page.

I have other postbit modifications anyways. Tried reverting them, but it didn't work.

[BrightStar]

What does it mean "This user is not worth stealing from."

[concreteweb]

Color a thread actually colors all threads of that user. I gotta redo the naming of it for future releases but it is like a colored user title or colored username only it displays on the forumdisplay page.

Hi Mayhem,

I now have thousands of threads with a funky color. I did a "refund" - but all the threads are still colored. How to fix?

How can we make this so only *one thread is colored? Thanks!

[mmfgamer5]

I love this mod, but whenever I purchase an item, I get the following error:

Database error in vBulletin 4.0.3:

Invalid SQL:
update xperience_stats set points_xperience=points_xperience-90, points_shop=points_shop+90 where userid='4';

MySQL Error : Unknown column 'points_shop' in 'field list'
Error Number : 1054
Request Date : Wednesday, July 21st 2010 @ 07:40:16 PM
Error Date : Wednesday, July 21st 2010 @ 07:40:16 PM
Script : http://theeyeofthestorm.net/market.php?do=purchase
Referrer : http://theeyeofthestorm.net/market.php?do=item&id=38
IP Address : 217.129.154.168
Username : mmfgamer5
Classname : vB_Database
MySQL Version : 5.0.91-community

How do I fix this? I am using vBExperience for the points, and I have 345 points. The item I purchased was 90 points.

[Phalynx]

Which version of vBExperience do you have installed?

[BrightStar]

I can't seem to steal points.....how does stealing work?

I am also having problem with points being shown with upto 5 leading decimals

https://vborg.vbsupport.ru/external/2010/08/44.jpg

[TheMayhem]

Some of you guys have reported problems that makes me think the upgrades aren't going as smoothly as they should of. I'm going to release an RC 3 when I get back from vacation that will have in the maintenance table a section that checks to ensure all tables are in the database and all columns have been added properly. That should massively help some of the reported bugs by running that.

And Mike007 it appears you found a tiny glitch where it is not reading the decimal places correctly. I will adjust this for RC 3. :)

[Ken Sanders]

Hi Mayhem, I am also getting "this user is not worth stealing from" and he is ranked #1 in points with over 4,000. How can we steal from him?

[leeman]

I upgraded and now I can't see the points int the postbit any more ...

Point me in the right direction please.

Ps.

Marvelous mod

Ds

[BrightStar]

Hi Mayhem, I am also getting "this user is not worth stealing from" and he is ranked #1 in points with over 4,000. How can we steal from him?

I've asked this question two times but no answer yet :(

[PixelFx]

FLY: Brad is currently out of town, I'm sure he'll reply to you once he's back

[TheMayhem]

I've asked this question two times but no answer yet :(

It's a bug, I'll fix it in RC 3 but as mentioned previously, I'm out of town :)

[xixxon]

can you convert to vbb 3.8.

thanks a lot :)

[Arae]

Some images are broken.

I re-upload the images folder but still, some of them are not working.

[TheMayhem]

Some images are broken.

I re-upload the images folder but still, some of them are not working.

Which images?

[Arae]

http://i25.tinypic.com/ws0ehh.jpg

here is the sample image TheMayhem. :)

[Centrix]

Will there be a version where the admin can select which individual items can be purchased by certain usergroups?

I want my normal users to use this too, but I don't want them to have all the features, such as change username color. I only want my VIP members to be able to change their username color (and some other things).

[stwan]

When final version? :)

[Tony Huỳnh]

<my english is not good ^^>

I think you should add option "Expire" for Market Item.
Ex: Item "Change Color Username"
It change to Red ... after 30days, it return to initial :)

--------------- First Error --------------
| Error: display gift item in postbit with "Big Icon"
| Although, it have been display well in Market site
| Like as: root_forum_folder/gift[icon_big]
| haven't image extension and the path is wrong.


------------- Second Error --------------
| Item "Change Username"
| Change username ---> Error
| Invalid SQL: insert into vbb_market_transactions set `date`='1279980127', marketid='13', userid='1', affecteduser='1', `credits`=93677.8075-21.0375;
MySQL Error : Unknown column 'credits' in 'field list'

[osayidan]

upgraded to 2.1 from 2.0.1 and now none of my users icons show up under their avatar. New purchases still show up though. Doing the maintenance things as shown in the readme do not help. Using vb 4.0.4.

[pipibunny]

I have a some problem that I want to ask:
- How can I set refundable function for products ?
- When users purchase gift, can they manage their gifts ? Do they can delete, hide gifts ? If yes, how to do it ?
Please answer for me. Thank you so much.

[Aramist]

Hi,


I have just installed.

And created one store item, but when i click the item in my board..i get this erro:

Database error in vBulletin 4.0.5:

Invalid SQL:
select * from market_store_transactions where marketid ='1' and userid='1';

MySQL Error : Table 'mytable.market_store_transactions' doesn't exist
Error Number : 1146
Request Date : Saturday, July 24th 2010 @ 10:22:41 PM
Error Date : Saturday, July 24th 2010 @ 10:22:41 PM
Script : http://www.myboard.com/forum/market.php?do=storeitem&id=1
Referrer : http://www.myboard.com/forum/market.php?do=storecat&storeid=2



My database uses a prefix on tables...but the script is not inlcuding the prefix.

How can i fix it?

Ty in advance

[Bombera]

You must wait. TheMayhem release version RC3 and fix this problem

[Aramist]

You must wait. TheMayhem release version RC3 and fix this problem

Ty Bombera

Let's wait :D

[bluegoblin7]

I installed this yesterday and I must say that it is excellent! It's made a big difference to the forum in 24 hours, so I'm very grateful for the mod!

However, a few things:
*Firstly, the "Colour thread" option isn't giving users a thread ID to colour and won't let them refund themselves. Is this something from my end or a bug?
*Second up, I have things such as bold, italic and underlined post text, custom user title etc enabled outside of the Points Market, but also have them enabled as possible purchases. Does it create any problems/matter? I.e. can someone change it without the purchase?

Any and all help is appreciated!

Regards,

Jack

[bluegoblin7]

Sorry for the double-post, a users just been telling me of some more problems.

He's bought 6 items today, but it's only showing up as two on the Market homepage. One of those is also coloured thread.

Any ideas?

Sorry if I'm not describing myself well enough!

[Centrix]

I think I've asked this twice already and I'd still like to know if this is something you will or would like to implement in the mod.

This is a very interesting mod and I use it too, but I think it would be even better with this implemented.

If you'll consider putting this in I'd be very happy.

Will there be a version where the admin can select which individual items can be purchased by certain usergroups?

I want my normal users to use this too, but I don't want them to have all the features, such as change username color. I only want my VIP members to be able to change their username color (and some other things).

[Magz]

Me agian

When a gift is purchased, a notification is sent, telling user to look in the Gift Market section for more details. Nothing is shown there though, am I missing a setting somewhere?

[bluegoblin7]

And me again, feeling slightly stupid.

Found out what the coloured thread one does now - not what the user expected! It's also applied the change forum wide and seemingly irrevocably - the result being that all my threads are coloured orange.

Please help revert this!

[AtomicAcidbath]

Posting this for the developer.

Buying "Title Change" with two funding sources required (Points & Cash, aka- method 4) throws this database error:

Database error in vBulletin 4.0.4:

Invalid SQL:
update lc_user set `market_xperience`=1027.00-, market_purchases=market_purchases+1, customtitle='2', usertitle ='MyNewTitle' where userid='1';

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' market_purchases=market_purchases+1, customtitle='2', usertitle ='MyNewTitle' where u' at line 1
Error Number : 1064
Request Date : Sunday, July 25th 2010 @ 06:12:38 PM
Error Date : Sunday, July 25th 2010 @ 06:12:38 PM
Script : http://76.121.10.37/forum/market.php?do=purchase
Referrer : http://76.121.10.37/forum/market.php?do=item&id=2
IP Address : 76.121.10.37
Username : --------
Classname : vB_Database
MySQL Version : 5.1.47-community


Check file 'market.php'
Change section:

// User Edits Own User Title
if ($itembuy[marketid] != 6) {
if (!$method != 4) {


To:

// User Edits Own User Title
if ($itembuy[marketid] != 6) {
if ($method != 4) {


Problem is resolved.

[TheMayhem]

Okay I am now home from my plane ride :) With that being said I see you guys have been doing a lot of little bug finding, which is good. RC 3 will be released this week, sometime during the mid week. I gotta split my programming time between this and vBcredits for Pixel so it's kind of half and half right now. Below are my answers.


Sorry for the double-post, a users just been telling me of some more problems.

He's bought 6 items today, but it's only showing up as two on the Market homepage. One of those is also coloured thread.

Any ideas?

Sorry if I'm not describing myself well enough!

Which six items did he purchase? I believe the Admin CP has a user transaction purchase updater under the maintenance section which recalculates for situations like this. I will definately look into it though after I see your reply and fix whatever is occurying on RC 3 but letting me know which forum items &/or store items (need to know which) will help me.

I think I've asked this twice already and I'd still like to know if this is something you will or would like to implement in the mod.

This is a very interesting mod and I use it too, but I think it would be even better with this implemented.

If you'll consider putting this in I'd be very happy.

I believe your talking about usergroup permissions, the answer is YES I will be implementing that. Possibly before I dub 3.0 a gold release.

Me agian

When a gift is purchased, a notification is sent, telling user to look in the Gift Market section for more details. Nothing is shown there though, am I missing a setting somewhere

The gift section is supposed to tell you what gifts you have purchased as well as who has purchased you gifts, and any
?

That's a poor written phrase on my part telling the user to purchase the gift section for more information. I am going to update it on RC 3 to tell them the correct info related to the gift donation to clear up the confusion.

And me again, feeling slightly stupid.

Found out what the coloured thread one does now - not what the user expected! It's also applied the change forum wide and seemingly irrevocably - the result being that all my threads are coloured orange.

Please help revert this!

I made a poor mistake when releasing 3x on how I named the Color thread option, I will add something in the maintenance section to revert thread colors on the next release and change the forum item name to Color Threads instead of Color a Thread. It's only supposed to color the threads of that user that they post and not color all threads or just one thread. It'll be corrected in RC 3.

Posting this for the developer.

Buying "Title Change" with two funding sources required (Points & Cash, aka- method 4) throws this database error:

Database error in vBulletin 4.0.4:

Invalid SQL:
update lc_user set `market_xperience`=1027.00-, market_purchases=market_purchases+1, customtitle='2', usertitle ='MyNewTitle' where userid='1';

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' market_purchases=market_purchases+1, customtitle='2', usertitle ='MyNewTitle' where u' at line 1
Error Number : 1064
Request Date : Sunday, July 25th 2010 @ 06:12:38 PM
Error Date : Sunday, July 25th 2010 @ 06:12:38 PM
Script : http://76.121.10.37/forum/market.php?do=purchase
Referrer : http://76.121.10.37/forum/market.php?do=item&id=2
IP Address : 76.121.10.37
Username : --------
Classname : vB_Database
MySQL Version : 5.1.47-community


Check file 'market.php'
Change section:

// User Edits Own User Title
if ($itembuy[marketid] != 6) {
if (!$method != 4) {


To:

// User Edits Own User Title
if ($itembuy[marketid] != 6) {
if ($method != 4) {


Problem is resolved.

Good find, I'll be sure to correct it. Sorry about any issues.






Hopefully that helps you guys. Like I said my time is split and I just got back tonight from California. I'm sunburned but in a very good mood. I'll try and get something out later this week. Keep up the bug searching :)

[bluegoblin7]

Thanks for getting back to me Mayhem!

Regarding the first quote, the six items have dropped to five as I have removed manually the purchase of colour threads in the hope of fixing the problem, but it didn't work. So the five forum items are Gift Market Access, Gambling Access, Custom User Title, Purchase a Gift and Username Glow. There are no store iteams. I've run both the transaction and refund maintenane scripts and it has made no differences. Also, Gambling Access is showing up as the most expensive item (Which is it) but is saying it's not been purchased when it has been purchased twice.

Regarding the second one, any ideas when that will be released? Just that it looks a bit awful at the moment! Thanks for the fix, though.

Cheers for being proactive!

Jack

[RollaJedi]

just re-bumping my question about the 'shipping' dropdown. Could you possibly make a 'no shipping' option or something so members dont have to fill out an email or fill out their address and such. I'm just selling virtual items, so both of those things are irrelevant

[Magz]

Thank you for the update TheMayhem,

Much appreciated

[RollaJedi]

I have not been able to buy anything yet because when i do, it gives me a database error. What i'd like to know though, is where do your store items you buy show up at? Is there a screenshot maybe of this? I was hoping maybe a page that acts as a gallery maybe with each item side by side or something, and maybe something in the postbit. Can someone help me see a screenshot please? Thanks!

[leeman]

Here's from mine working.

[RollaJedi]

Thank you leeman, but i need a screenshot of the where it puts all the items you buy once you've already bought them from the market.

that screenshot you posted is what it looks like where you buy the items in the market
:)

[leeman]

Thank you leeman, but i need a screenshot of the where it puts all the items you buy once you've already bought them from the market.

that screenshot you posted is what it looks like where you buy the items in the market
:)

You know what, after the upgrade they don't show in the post bit for me either.

[RollaJedi]

everytime i try to buy something, it gives me a database error so i cant ever buy anything. I'd just like to see what the screen looks like that shows all of your bought items right now though

[Centrix]

I believe your talking about usergroup permissions, the answer is YES I will be implementing that. Possibly before I dub 3.0 a gold release.



Yeah I guess we're on the same page here. I think you understand what I mean.

Like, per-item usergroun permissions. So usergroups 1,2 and 3 (example) can purchase Change Username Color, but usergroup 4 can't. etc

Cool, awesome can't wait :)

[TheMayhem]

everytime i try to buy something, it gives me a database error so i cant ever buy anything. I'd just like to see what the screen looks like that shows all of your bought items right now though

What's your database error again?

[capt gary]

just re-bumping my question about the 'shipping' dropdown. Could you possibly make a 'no shipping' option or something so members dont have to fill out an email or fill out their address and such. I'm just selling virtual items, so both of those things are irrelevant

Forum Items can handle virtual items for sale? You can create custom gifts/items which will be placed them under Gifts. I've created virtual items under Custom Gifts which will show up in Market Items Once created they will show up for sale in Forum Items.

I had to play with it a little bit to get the flow, but once I noticed what was happening it seems to work fine. When a virtual item is bought it is placed in the users profile for the amount of time you set in the Points Market:Gifts Maximum Gift Age field under the admincp.

So basically Forum Items are for virtual items and Store Items is for tangible items.

Hope this helps.

CP

[RollaJedi]

thank you capt gary! :)

here is my database error. sorry i forgot to post it:

Database error in vBulletin 4.0.4:

Invalid SQL:

UPDATE user SET

`market_xperience`=412293.00-5,
``=-0,
`market_purchases`=market_purchases+1
where userid='1';

MySQL Error : Unknown column '' in 'field list'
Error Number : 1054
Request Date : Tuesday, July 27th 2010 @ 06:07:49 AM
Error Date : Tuesday, July 27th 2010 @ 06:07:50 AM
Script : http://www.coreplanets.com/forums/market.php?do=storepurchase
Referrer : http://www.coreplanets.com/forums/market.php?do=storeitem&id=1
IP Address : ############
Username : RollaJedi
Classname : vB_Database
MySQL Version : 5.0.91-log

[RollaJedi]

i'm using vb 4.0.4 pl 1

[FoW]

When I try to set it up so people can buy points, I get an error stating I must enter all information. I am entering all information... lol. Ive triple checked. Has anyone else has this issue?

[Footman]

Is there a way to remove the "Premium Addon Features" box at the bottom here? I won't need to have the members see that as I won't have all those features enabled.

[bluegoblin7]

Another error on this from me I'm afraid!

It seems that there might be some issue with the refunds system - members are asking for refunds but nothing is happening - changes are not reverting and I don't think the amount of points are being returned?

All help appreciated!

[Kayden]

Adding a username color to a user manually doesn't seem to be working.

[paulvev]

Using 4.0.5 and Vbexperience4 and all working sweet except for one thing...

when i purchase something, the points are correctly taken from my points total in the market, but when i click on vbexperience in profile, they havent been deducted and therefore dont match.

If i do a recount using Experience admincp, the experience points in profile upate to match the correct total in the market. Thats all fair and well, but it's slightly frustrating having to do a manual count each day to keep members happy.

Only 1 suggestion.....members LOVE to be able to tweak their abilities on the forum. I would love to see:
a) Being able to buy more PM space.
b) Being able to buy Signature permissions.

FANTASTIC mod! Cant praise you enough and hopefully above will be addressed in next update.

[Phalynx]

Using 4.0.5 and Vbexperience4 and all working sweet except for one thing...

when i purchase something, the points are correctly taken from my points total in the market, but when i click on vbexperience in profile, they havent been deducted and therefore dont match.

If i do a recount using Experience admincp, the experience points in profile upate to match the correct total in the market. Thats all fair and well, but it's slightly frustrating having to do a manual count each day to keep members happy.

Only 1 suggestion.....members LOVE to be able to tweak their abilities on the forum. I would love to see:
a) Being able to buy more PM space.
b) Being able to buy Signature permissions.

FANTASTIC mod! Cant praise you enough and hopefully above will be addressed in next update.
There is an automatic recount which occurs every 10 minutes. The changes are queued until then.

[paulvev]

Do i need to "switch on" that automated recount or does it do it without touching anything?
(I forgot to say my bulletin board is currently switched off whilst i test this, so maybe the recount didnt automatically go due to that?)

Vbexperience is an awesome mod too!

[hoadiem]

when i click place a bet it giving me database error

[TheMayhem]

when i click place a bet it giving me database error

Can you post the error for me?

[FoW]

When I try to set it up so people can buy points, I get an error stating I must enter all information. I am entering all information... lol. Ive triple checked. Has anyone else has this issue?

Maybe the third time is a charm? Im not getting any specific error besides the one saying i need to enter all info. (Which i am doing)

[FoW]

Just noticed that everytime i install RC2, it comes up as RC1. Ive uninstalled and deleted everything. But when I install is says current version is RC1.

[Veer]

I like the product but honestly I will go with DBTech vBShop. Why?

Well, main reason is the gift placement and gift purchase interface in Market system. it is too much confusing, If you see vBShop they just make separate areas for "Forum items" and "Gift items" with separate categories. simply choose category and purchase gift for self or others, thats it. but here in market you make me confused with interface and options like first purchase gift market then go to the gift market add-one, where you give user ability to create gift, then go to that page and see your created gifts and others, then choose and purchase. this really doesn't make sense, sorry.

[capt gary]

Just noticed that everytime i install RC2, it comes up as RC1. Ive uninstalled and deleted everything. But when I install is says current version is RC1.

I think this didn't get changed this in the xml file. I edited the xml file and changed the RC1 to RC2, which is where this is set to display version in the admincp under Point Market / Maintenance. I'm sure it was an oversight as all the bug fixes are in the Point Market 3.0rc2.zip download.

CG

[Phalynx]

Do i need to "switch on" that automated recount or does it do it without touching anything?
(I forgot to say my bulletin board is currently switched off whilst i test this, so maybe the recount didnt automatically go due to that?)

Vbexperience is an awesome mod too!

The recount is a standard vBulletin Cronjob that runs every 10 minutes - if there is someone visiting the site..

[TheMayhem]

I like the product but honestly I will go with DBTech vBShop. Why?

Well, main reason is the gift placement and gift purchase interface in Market system. it is too much confusing, If you see vBShop they just make separate areas for "Forum items" and "Gift items" with separate categories. simply choose category and purchase gift for self or others, thats it. but here in market you make me confused with interface and options like first purchase gift market then go to the gift market add-one, where you give user ability to create gift, then go to that page and see your created gifts and others, then choose and purchase. this really doesn't make sense, sorry.

The Gift Market is a concept that was requested by members early on in the Point Market history. Members wanted the ability for people to use the Point Market to "create" gifts of their choosing and sell it for points with an earning of their choosing. There are three ways you can get gifts with the Point Market
1) Purchase yourself a gift (Under Gifts Category)
2) Have someone purchase you a gift (Under Other Users Category)
3) Purchase yourself a customly created gift (Under Gift Market Addon)

If the Gift Market confused you, you simply could of disabled the idea of users creating a custom gift and purchasing gift market access to buy those gifts. Then all you would have is the normal buy yourself a gift or buy someone else a gift option, which is essentially a basic gift shop. I've just added extra features and tweaks throughout the releases based on member's feedback or wants/needs.


We shall have RC 3 released Saturday.

[paulvev]

Im enjoying this mod but i have one question.

How do you Steal points from other members? i.e where do you do this? I must have missed the button or link somewhere on my site?

I see the upgrades in the Market and Steal History / Protection and i've entered the % on my usergrou permissions.

[TheMayhem]

Im enjoying this mod but i have one question.

How do you Steal points from other members? i.e where do you do this? I must have missed the button or link somewhere on my site?

I see the upgrades in the Market and Steal History / Protection and i've entered the % on my usergrou permissions.

Under the Other Users category. Any item that involves another user is found under the Other Users category.

[kylek]

Any plans down the road to allow the order of gifts to be changed around? Right now it looks like the gifts are displayed in the order they were added.

[FoW]

OK ILL TRY TYPING REALLY BIG THIS TIME

When I try to set up the ability to buy points, it tells me I must enter all feilds. I HAVE entered all feilds.

Any idea whats going on here?

[TheMayhem]

Any plans down the road to allow the order of gifts to be changed around? Right now it looks like the gifts are displayed in the order they were added.

Do you mean custom sorting based on a number you give the gift or a priority?

OK ILL TRY TYPING REALLY BIG THIS TIME

When I try to set up the ability to buy points, it tells me I must enter all feilds. I HAVE entered all feilds.

Any idea whats going on here?

Can you please post a screenshot of the page you are entering all fields? The reason I ask you this is there are several pages within the Market mod that can give that kind of error because its a generic error related to purchasing points. If you post a screenshot of the page your entering the information in and then post the error, I'll be able to fix it for the RC 3 release on saturday. As of right now I'm not sure which page is giving you this error and that is why I ask.

[FoW]

Not a problem.

This is the page im trying to fill the information on (Point Market/Converter)

http://img686.imageshack.us/img686/2172/ss1market.jpg

And this is what I get on the submit

http://img31.imageshack.us/img31/614/ss2market.jpg

[General of the]

How do you earn points? Noob question, but I can't figure it out

[paulvev]

You need a points system installed first. See ucash or vbcredits.
This Point Market is best used with a points system although it can be used just with reputation.

If you're a noob, start with a search for ucash or vbcredits thread (or vbexperience).....install one of those and then consider this as an excellent upgrade.

[paulvev]

I have a quick question.....

What is going to be included in the RC3 release? Just curious.

[Juggernaut]

I got this database error a couple of days ago.

Database error in vBulletin 4.0.5:

Invalid SQL:
update user set market_xperience=, xperience_done='0' where userid='153';

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' xperience_done='0' where userid='153'' at line 1
Error Number : 1064
Request Date : Thursday, July 29th 2010 @ 06:31:31 PM
Error Date : Thursday, July 29th 2010 @ 06:31:31 PM
Script : http://www.xxxx.com/market.php (http://www.cuscatlekos.com/market.php)
Referrer : http://www.xxxxx.com/private.php (http://www.cuscatlekos.com/private.php)
IP Address : 200.55.139.106
Username : Nicke
Classname : vB_Database
MySQL Version :

[TheMayhem]

I have a quick question.....

What is going to be included in the RC3 release? Just curious.

About 15 bug fixes, a few changes/tweaks based on feedback to the new currency system, usergroup permissions per item, and a Mysql Table checker for the maintenance section to ensure everything has been installed correctly.

[capt gary]

About 15 bug fixes, a few changes/tweaks based on feedback to the new currency system, usergroup permissions per item, and a Mysql Table checker for the maintenance section to ensure everything has been installed correctly.

Great job!! I know it's a work in progress and thanks for listening to us by incorporating our feedback. Look forward to the new release.

CG

[iJay]

Hey, i was wondering.
How can i make purchased items (image files) appear in the post bit and profile.
In the test category i added an image of a gun, i purchased the gun in the market. How can i make those purchases appear in my post bit. (kinda like how vbshop has)

[sticky]

I like the layout of this mod but you can't do things with it like buy increased PM capacity?

[paulvev]

Thats a great idea. I'd love users to be able to buy more PM space.

[Phalynx]

Point Market System has been nominated for the Mod of the Month August 2010!

Please vote for your favourite modification:
https://vborg.vbsupport.ru/showthread.php?t=247706

[Juggernaut]

^^ Voted for point market :D

[Aramist]

+1 .

[TheMayhem]

I slept in by accident until 5 today (long night last night )) Anyways I'll try and see if I can get something released for tonight if not then for tomorrow since I'm off. If you didn't notice in my sig, Phalynx and I are saving up for a second vb license. I thought I had enough on paypal donations to buy one; however, I wasn't aware vb's pricing had changed so much so therefore if anyone wants to donate to get us our own support forums / bug tracker it'd be appreciated. Oh yes and were a MOTM nominee for the third time :)

[sticky]

Is there any way to do things like buy increased PM storage capacity?

[iJay]

Marked As Installed and Voted for MOTM August
please anwser my inquiry :D

Hey, i was wondering.
How can i make purchased items (image files) appear in the post bit and profile.
In the test category i added an image of a gun, i purchased the gun in the market. How can i make those purchases appear in my post bit. (kinda like how vbshop has)

[Footman]

I slept in by accident until 5 today (long night last night )) Anyways I'll try and see if I can get something released for tonight if not then for tomorrow since I'm off. If you didn't notice in my sig, Phalynx and I are saving up for a second vb license. I thought I had enough on paypal donations to buy one; however, I wasn't aware vb's pricing had changed so much so therefore if anyone wants to donate to get us our own support forums / bug tracker it'd be appreciated. Oh yes and were a MOTM nominee for the third time :)

Sent some in the other day... did you get the email I sent?

I hope you can get the second license. Having your own board would be great.

[capt gary]

I slept in by accident until 5 today (long night last night )) Anyways I'll try and see if I can get something released for tonight if not then for tomorrow since I'm off. If you didn't notice in my sig, Phalynx and I are saving up for a second vb license. I thought I had enough on paypal donations to buy one; however, I wasn't aware vb's pricing had changed so much so therefore if anyone wants to donate to get us our own support forums / bug tracker it'd be appreciated. Oh yes and were a MOTM nominee for the third time :)

How much more do you need Brad? PM me and I'll see what I can do. I really like this system and want to see it grow and supported.

CG

[Sarcoth]

I must be missing something somewhere. I set up a few items for my members to purchase plus enabled some of the username and user title features. When I look at the username and user title features at the Point Market, they have a line titled, Item Refundable and are set to yes. Yet, I don't see a place to change this to no. The Yes is a link and when I click on it, it takes me to a Refund item page with information on Purchase date, expiration date, time remaining, initial cost, and refund. Is this just not added yet or am I blind?

Any help would be appreciated. Maybe it is from the 3.0.0 RC2 version. Should I go back to the 2.1.0? Thank you.

[TheMayhem]

I must be missing something somewhere. I set up a few items for my members to purchase plus enabled some of the username and user title features. When I look at the username and user title features at the Point Market, they have a line titled, Item Refundable and are set to yes. Yet, I don't see a place to change this to no. The Yes is a link and when I click on it, it takes me to a Refund item page with information on Purchase date, expiration date, time remaining, initial cost, and refund. Is this just not added yet or am I blind?

Any help would be appreciated. Maybe it is from the 3.0.0 RC2 version. Should I go back to the 2.1.0? Thank you.

Ah the refund section is a bit messed up in the 3x series. I've attempted to fix it in RC 3 which is due within hours rather then days :)

[Sarcoth]

Cool, thanks Mayhem.

[teamsupra]

I was just about to install 2.x but I see the newest RC is coming.. So ill just wait it out

[argothiusz]

For some reason, my members custom usertile keep getting revert back to normal. Everytime it does that I have to update it manually with the build in function from point market system. However, it keeps on happening every 1 or 2 days. Now, not all members are effected by that but only like 10. Any fix for this?

[dale09]

I am getting this "Unclosed tag" when trying to install. Any suggestions?

[elwachiman]

DO SOME POINT MARKET SISTEM UPDATE TO LATEST VERSION, BUT A DETAIL NOTE: THE BOX IN THE CATEGORY OF DEFAULT POSTBIT, BUT ALSO TO NOTE THAT THE BOX IS PRESENTED IN ATTACHMENTS IN THE POST AS WELL AS IN THE VBADVANCE SPECIFICALLY ALSO IN ATTACHMENTS , WAY THAT YOU CAN SOLVE THAT BOX AND SEE EVIL IN THE postbit LEGACY AND ATTACHMENTS, LEFT SOME SCREENSHOTS SO YOU KNOW WHAT I MEAN, THANKS
PD:SAME PLACE HAPPENS WHEN AN POST IN ADVANCED EDITION

[ayam]

Finally, a converter system has been implimented allowing for your users to use paypal to pay for points and earn points for it.

how to add other payment processor such as moneybookers, liberty reserve or other else?

thank you.

installed and testing now

[sticky]

Is there any way to do things like buy increased PM storage capacity?
May I please have an answer to my question?

[smirkley]

May I please have an answer to my question?

I wouldnt be surprised if this is addressed after it goes gold.

[mimi123]

i've done everything except i dont understand number 3:

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

I don't know what that is or how/where to do it, please help!!!

[argothiusz]

i've done everything except i dont understand number 3:

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

I don't know what that is or how/where to do it, please help!!!

What point system are you using?

[mimi123]

What point system are you using?

um? this one is the one i installed Point Market 3.0rc2.zip

[Phalynx]

Point Market is a shop that uses points from other modifications. You will need to install also a point system like vBExperience (see my signature), uCash, etc...

[elwachiman]

DO SOME POINT MARKET SISTEM UPDATE TO LATEST VERSION, BUT A DETAIL NOTE: THE BOX IN THE CATEGORY OF DEFAULT POSTBIT, BUT ALSO TO NOTE THAT THE BOX IS PRESENTED IN ATTACHMENTS IN THE POST AS WELL AS IN THE VBADVANCE SPECIFICALLY ALSO IN ATTACHMENTS , WAY THAT YOU CAN SOLVE THAT BOX AND SEE EVIL IN THE postbit LEGACY AND ATTACHMENTS, LEFT SOME SCREENSHOTS SO YOU KNOW WHAT I MEAN, THANKS
PD:SAME PLACE HAPPENS WHEN AN POST IN ADVANCED EDITION

Point Market is a shop that uses points from other modifications. You will need to install also a point system like vBExperience (see my signature), uCash, etc...
sorry, no answer to my question I saw you do it again, I expect a response back at least. thanks

[DS MrSinister]

DO SOME POINT MARKET SISTEM UPDATE TO LATEST VERSION, BUT A DETAIL NOTE: THE BOX IN THE CATEGORY OF DEFAULT POSTBIT, BUT ALSO TO NOTE THAT THE BOX IS PRESENTED IN ATTACHMENTS IN THE POST AS WELL AS IN THE VBADVANCE SPECIFICALLY ALSO IN ATTACHMENTS , WAY THAT YOU CAN SOLVE THAT BOX AND SEE EVIL IN THE postbit LEGACY AND ATTACHMENTS, LEFT SOME SCREENSHOTS SO YOU KNOW WHAT I MEAN, THANKS
PD:SAME PLACE HAPPENS WHEN AN POST IN ADVANCED EDITION

If your talking about the boxes around everything right? I had that same problem.

I just figured it out.. for what ever reason i was missing vbulletin-chrome.css template.
so i took the one from my test site and overwrite the template. hope this works for you.

[elwachiman]

the problem is that I have no test site, locate the template vbulletin-chrome.css will place the original code chrome.css vbulletin-style template I currently use the forum and did not work anyway thanks for the suggestion.

[smirkley]

Patiently looking forward to Point Market 3.0rc3.zip as this mod is not yet ready for me to take live, but definetly holds very much promise as being exactly what I have been looking for.

***fingers crossed ***

( and yes, voted for MOTM as it stands now )

[David Regimbal]

Hi,

First off amazing mod! I was wondering if it would be possible to also sell custom avatars which users could unlock in the gallery since I don't allow custom avatars unless paid for by points.

[Glenn Paradis]

When i import Point Market System 3.0, i have an error : unclosed_tag

[elwachiman]

If your talking about the boxes around everything right? I had that same problem.

I just figured it out.. for what ever reason i was missing vbulletin-chrome.css template.
so i took the one from my test site and overwrite the template. hope this works for you.
worked, thanks overwrote the code and it works wonderfully, thanks again brother
editing
reload the page and performed the same problem, the truth is not to be anyway thanks

[ayam]

i tried the converter to add more credits (vbookie cash) from paypal, and when all transaction are done, when trying to return back to the forum, it shows this error

Your submission could not be processed because a security token was missing.

i'm using point market 3.0 RC2 with vb 4.0.5

did i miss anything?

[DS MrSinister]

worked, thanks overwrote the code and it works wonderfully, thanks again brother
editing
reload the page and performed the same problem, the truth is not to be anyway thanks

Ok the problem is when someone purchase a gift it messed something up. it overwrites something.

I disable this mod and overwritten the template and its back to normal.

[jeremyricci]

Is there currently a problem with the gambling portion of the mods? I've been trying to figure out why I get a payout, but it never allocates to my account. I keep spending money, and even though I win occasionally, it never deposites to the users accounts. Ideas?

Also, is there anyway to disable the bank? It doesn't work at all.

[capt gary]

Ah the refund section is a bit messed up in the 3x series. I've attempted to fix it in RC 3 which is due within hours rather then days :)

Any updates?

[TheMayhem]

I'm narrowing in on finishing, I've seen a lot of reports from users related to the steal functions are not working. The problem I am having with dealing some of these bugs is the Point Market has become so big and some problems are really isolated. So if you were suffering from like steal errors or other things that have been commonly reported, PLEASE-PLEASE-PLEASE in the future do this:

- When reporting a bug, give me the exact URL of the error (it massively helps me pinpoint)
- What kind of point system are you using for your PRIMARY point field
- What kind of point system are you using for your SECONDARY point field (If Any)
- If it is a market purchase error, please let me know how you are charging users (Primary Point Field, Secondary Point Field, Either/Or Point Fields, Both Point Fields)

Once again, anyone who had an error that it wouldn't let you steal from users. I need more info because I cannot find the stupid bug and I know it exists.

[Centrix]

Does the 3.0 RC1 have that feature I mentioned before?

Will there be a version where the admin can select which individual items can be purchased by certain usergroups?

I want my normal users to use this too, but I don't want them to have all the features, such as change username color. I only want my VIP members to be able to change their username color (and some other things).

[TheMayhem]

Just giving everyone the heads up, I have officially released RC 3. There is over 16 different bug fixes as well as several new features/changes. There still are a few known bug changes I didn't fix such as broken tag when importing the product, stealing isn't working correctly, storing style as a file, and the postbit html getting messed up for colored usertitles/usernames for the online/offline images. All other ones such as the banking bugs, lottery, some mysql errors, I was able to correct as far as I know. :)


Anyways, please repost bug reports following the updated support policy guide where I need specific information such as your primary and secondary point fields, url, etc. The more information the better for me to be able to fix the remaining bugs. The next release will either be RC 4 or Gold and will also feature usergroup control over which market items can be purchased.

Finally, sorry about the wait between RC 2 and RC 3 :)

[Aramist]

HI,


When i create a new item store, and click it to access...it gives me the following my sql error...

Database error in vBulletin 4.0.5:

Invalid SQL:
select * from market_store_transactions where marketid ='4' and userid='1';

MySQL Error : Table 'mybd.market_store_transactions' doesn't exist
Error Number : 1146
Request Date : Tuesday, August 10th 2010 @ 10:49:11 PM
Error Date : Tuesday, August 10th 2010 @ 10:49:11 PM
Script : http://www.mysite.com/forum/market.php?do=storeitem&id=4
Referrer : http://www.mysite.com/forum/market.php?do=storecat&storeid=3
IP Address : My IP
Username : Aramist
Classname : vB_Database
MySQL Version : 5.0.91-community


He's not inserting the Table prefix

Any fix for it ?

Ty in advance

[RollaJedi]

i noticed that you said you can convert currencies. Can you convert vbexperience points into ucash, so that i may use ucash on your store and also spend the newly converted ucash on other 3rd party shops?

vbexperience points -----> point market system turns them into ucash ----------> able to spend these converted points in another shop

[Bigj85]

Just installed RC3,so far so good,its nice for the users to see the names of the currencies in the converter instead of the field names,a lot less confusing.
The banking seems okay so far but I havent really played with it to much,will give more feedback soon.

great work

[Bigj85]

RollaJedi yes you may,I am converting Experiencde into credits no problem,I mentioned this to you in a previous post in the vbexperience thread in your hunt to use exp. points as triple triad cash

[TheMayhem]

HI,


When i create a new item store, and click it to access...it gives me the following my sql error...

Database error in vBulletin 4.0.5:

Invalid SQL:
select * from market_store_transactions where marketid ='4' and userid='1';

MySQL Error : Table 'mybd.market_store_transactions' doesn't exist
Error Number : 1146
Request Date : Tuesday, August 10th 2010 @ 10:49:11 PM
Error Date : Tuesday, August 10th 2010 @ 10:49:11 PM
Script : http://www.mysite.com/forum/market.php?do=storeitem&id=4
Referrer : http://www.mysite.com/forum/market.php?do=storecat&storeid=3
IP Address : My IP
Username : Aramist
Classname : vB_Database
MySQL Version : 5.0.91-community


He's not inserting the Table prefix

Any fix for it ?

Ty in advance

Looks like I missed this, here is your fix for it or you can wait for the next release:

Open root/market.php

Find:

// Check to See if User Can Rate
$user_purchase = $db->num_rows($db->query_read("select * from market_store_transactions where marketid ='".addslashes($itemid)."' and userid='".addslashes($userid)."'"));
if ($user_purchase > 0) {
$can_review = $db->num_rows($db->query_read("select * from market_store_review where marketid ='".addslashes($itemid)."' and userid='".addslashes($userid)."'"));

Change to:

// Check to See if User Can Rate
$user_purchase = $db->num_rows($db->query_read("select * from " . TABLE_PREFIX . "market_store_transactions where marketid ='".addslashes($itemid)."' and userid='".addslashes($userid)."'"));
if ($user_purchase > 0) {
$can_review = $db->num_rows($db->query_read("select * from " . TABLE_PREFIX . "market_store_review where marketid ='".addslashes($itemid)."' and userid='".addslashes($userid)."'"));
} else {

:)





i noticed that you said you can convert currencies. Can you convert vbexperience points into ucash, so that i may use ucash on your store and also spend the newly converted ucash on other 3rd party shops?

vbexperience points -----> point market system turns them into ucash ----------> able to spend these converted points in another shop

Yes you can use the Point Market Converter to turn a currency such as vBExperience into uCash and then a user could use those points from uCash to use it on another point store other then the market if you like. :)

[Aramist]

Ty u a lot Mayhem!

It fixed the front-end stuff...but now...when i click "store Items" in admin cp...it gives me another mysql error :P....again no prefix

Database error in vBulletin 4.0.5:

Invalid SQL:
select userid, username from user where userid='1';

MySQL Error : Table 'mytable.user' doesn't exist
Error Number : 1146
Request Date : Wednesday, August 11th 2010 @ 12:27:55 AM
Error Date : Wednesday, August 11th 2010 @ 12:27:55 AM
Script : http://www.mysite.com/forum/admincp/market.php?do=store
Referrer : http://www.mysite.com/forum/admincp/index.php?do=nav
IP Address : MyIP
Username : Aramist
Classname : vB_Database
MySQL Version : 5.0.91-community


Sry for many reports....

ty man

[Aramist]

Me again....

I have solved my last report.

Changing at line 525 and 526 in admincp/market.php:

$finduser = $db->fetch_array($db->query_read("select userid, username from user where userid='$category[userid]'"));
$finditem = $db->fetch_array($db->query_read("select name, type from market_store where marketid='$category[marketid]'"));

To:

$finduser = $db->fetch_array($db->query_read("select userid, username from " . TABLE_PREFIX . "user where userid='$category[userid]'"));
$finditem = $db->fetch_array($db->query_read("select name, type from " . TABLE_PREFIX . "market_store where marketid='$category[marketid]'"));


I'm not sure if I'm correct, but, in my case, solved the problem.

Ty

[TheMayhem]

Me again....

I have solved my last report.

Changing at line 525 and 526 in admincp/market.php:

$finduser = $db->fetch_array($db->query_read("select userid, username from user where userid='$category[userid]'"));
$finditem = $db->fetch_array($db->query_read("select name, type from market_store where marketid='$category[marketid]'"));

To:

$finduser = $db->fetch_array($db->query_read("select userid, username from " . TABLE_PREFIX . "user where userid='$category[userid]'"));
$finditem = $db->fetch_array($db->query_read("select name, type from " . TABLE_PREFIX . "market_store where marketid='$category[marketid]'"));


I'm not sure if I'm correct, but, in my case, solved the problem.

Ty

The way you fixed the error is the correct way, I've already applied both of your findings for the next release. Keep up the good work on finding bugs as I truly believe the next release will be the last before I mark this thing completely stable.

[Aramist]

TY u Man !!!

This Mod is fantástic ! Nominate it !

I'm not sure if there is, but would be great if u create an option, to automatic email an admin when someone buy an store item.

And i don't know if this is a bug, but i bought an store item to test...and the "Top Store Market Items" keep showing "0"....i guess this should show 1 now.....cause is was the only store item bought till the moment.

Best Regards

[TheMayhem]

TY u Man !!!

This Mod is fant?stic ! Nominate it !



Thank you, it actually already is a current Mod of the Month for this month. :)



I'm not sure if there is, but would be great if u create an option, to automatic email an admin when someone buy an store item.



There already kind of is. If you go to Settings and Staff Permissions and click on the Point Market: Market Items link. The very first setting asks you for a User ID to send a PM to when a user buys a store item. Now there isn't an option to do an email but it a PM should give you some notification.


And i don't know if this is a bug, but i bought an store item to test...and the "Top Store Market Items" keep showing "0"....i guess this should show 1 now.....cause is was the only store item bought till the moment.

Best Regards

Yes that was a bug. I'm not sure how it wasn't reported before but I have fixed it for the next release. Good find :)

[Combattente]

Err.. the Gifts still aren't shown below the user's profile in the posts.. :(

[Storyteller69]

Many thanks, absolute great addon.
Just one question: Are there any news about the german translation?

Thanks in advance
Storyteller

[Phalynx]

Many thanks, absolute great addon.
Just one question: Are there any news about the german translation?

Thanks in advance
Storyteller

It's still in work. There are over 500 phrases, thats much of work.

[fly]

Thank you TheMayhem. We appreciate all your hard, free work. :) I shall be donating again as soon as I can.

You will be missed when the vB community eventually burns you out. :p

[TheMayhem]

Many thanks, absolute great addon.
Just one question: Are there any news about the german translation?

Thanks in advance
Storyteller

I'm planning on giving permission to a few people to do some language translations. Unfortunately or fortunately, the Point Market is one of the biggest 4x mod in terms of size and data so there is a crap load to translate and make look right. Phalynx is making progress on your german translation.