Point Market System 3.1x

[bgg]

I am interested in a Lottery system for the Points Market and uCash mods for vb 4.0 CMS.

If I must, I'll hack one myself... anyone willing to program it for pay?

James

[bgg]

Below are screenshots of the Admin CP changes done in the next release. I used my actual site forum so they might not look 100% identical, but it should give you an idea of the direction I am heading. Feedback and suggestions is greatly appreciated before I make this puppy go live.

While these really look great, I think the store really needs to allow the adding of a custom category and a custom item for sale for the admin... For example I'd like to add lottery tickets for sale. Or other such admin controlled items or "payments" that have no direct effect on the forums.

James

[TheMayhem]

While these really look great, I think the store really needs to allow the adding of a custom category and a custom item for sale for the admin... For example I'd like to add lottery tickets for sale. Or other such admin controlled items or "payments" that have no direct effect on the forums.

James

In the next release, I actually have a few included categories with no items that are turned off by default. The same goes with items. This can be used so people can "customize" the hack without screwing around with it too much to the point they will break it on future releases. It will also allow for people to reassign categories and make them how they want it, which is another feature change in 1.1.0

I am interested in a Lottery system for the Points Market and uCash mods for vb 4.0 CMS.

If I must, I'll hack one myself... anyone willing to program it for pay?

James

I am going to be including a gambling area within the Point Market called Gambling. It will be purchased by purchasing access and the controls are within the vbulletin settings for it. Whether or not I include a Lottery system will entirely be dependent on what I see of vbcredits as if they end up scripting one, I probably will not script one. If they don't, then I will be including one.

I like your work a lot. I'm enjoying your market! By the way, I want to remove the cofee gift from my postbit, I've tried the sql querry you have posted for the other user but doesn't work for me. Any idea?
Have you watched the problem with the purchase button in my forum? Or it has been solved yet?
Thanks!

An idea for the next release could be "Buying permissions to see other forum styles" or "permission to see more emoticons or topic icons".

Does the SQL produce errors or does it just not finding any matching rows? Forum permissions is something I've been promising forevor that is on this release. At minimum people will be able to buy special access to restricted forums. I was thinking about adding the option for users to be able to add smileys of their own, however I haven't decided.




With me just now finishing up the Admin CP overhaul, I'll be spending a lot of time on the user interface, main page design changes, and other features that's been requested. I'll also be trying to line it up better so you can turn certain things off or on that will allow for better integration with other point systems.

[Jabong82]

So are people unable to delete gifts etc? That seems like a necessary mod?

[Geez]

it will be in the next release, which should be soon

[literatestylish]

Mayhem,

Is there a way to see which members bought what?

Also, when is the new release coming out?

Great mod by the way!

[Jabong82]

I installed the market fine, and everything seems to be working fine, however when I go to the Admin CP panel and click on the Point Market controls I'm redirected to an error page (404). Am I missing a file somewhere? Thanks in advance.

Edit: Nevermind I somehow placed the market php in the wrong folder. Thanks for this great Mod. Nominated and Installed!

[TheMayhem]

Mayhem,

Is there a way to see which members bought what?

Also, when is the new release coming out?

Great mod by the way!

There's a massive admin CP addition in 1.1.0 related to this. I was kind of hoping to have it up this week however I've been very-very sick and this is the first time I've been on in 2 days.

[Jabong82]

Hey Mayhem love your mod. I noticed though when I was testing it, that the UserName Strikethrough for me is unable to be refunded? Like when I click "yes" to initiate a refund, it tells me that I do not have access (like I'm locked out) of this area, but I can do refunds for other items like glow, color etc. Its just for the strikethrough something is weird. Don't know if thats a bug.

Anyway I look forward to your new release! Thanks again.

[TheMayhem]

Hey Mayhem love your mod. I noticed though when I was testing it, that the UserName Strikethrough for me is unable to be refunded? Like when I click "yes" to initiate a refund, it tells me that I do not have access (like I'm locked out) of this area, but I can do refunds for other items like glow, color etc. Its just for the strikethrough something is weird. Don't know if thats a bug.

Anyway I look forward to your new release! Thanks again.

Yes this is a bug that has been reported and fixed in version 1.1.0

[jacob115]

I am working on some codes and have a question. I am editing my point store to make it work perfectly for me, but I have a question. Here is the code for changing username:
// *********** Change Username ************
if ($itembuy[marketid] == 13) {
$findother = $vbulletin->db->query_read("SELECT * from " . TABLE_PREFIX . "user where username='".addslashes($new_username)."'");
$findother = $vbulletin->db->fetch_array($findother);
if ($findother) {
$error = 10; // Someone has that username.
}
$minchar = $vbulletin->options[minuserlength];
$maxchar = $vbulletin->options[maxuserlength];
if ($minchar > strlen($new_username)) {
$error = 11;
}
if ($maxchar < strlen($new_username)) {
$error = 12;
}
if ($error == 0) {
$vbulletin->db->query_read("update " . TABLE_PREFIX . "user set `username`='".addslashes($new_username)."', `$pointfield`=$points-$amount where userid='$userid'");
$vbulletin->db->query_read("insert into " . TABLE_PREFIX . "market_transactions set `date`='$time', marketid='$itembuy[marketid]', userid='$userid', affecteduser='$userid', amount='$amount'");
$points = $points - $amount;
$purchases = $purchases+1;
}
}
//

I understand I need to change the market ID, but what would the code be to add a specific usergroup (chosen by me, not user, like I would specify the additional usergroup in the code)

Thanks!

[fly]

I'm no SQL expert, but I'd think this would work. You'd obviously need to remove all the stuff that deals with username, as well...

$vbulletin->db->query_read("update " . TABLE_PREFIX . "user set `membergroupids`='6', `$pointfield`=$points-$amount where userid='$userid'");

Don't run that, as it will add the user to the admin group if I'm correct.

[jacob115]

That doesn't seem to work, can I have a full code with it so I can replace the entire thing. Maybe there is another thing bothering it.

Thanks!

[TheMayhem]

I am working on some codes and have a question. I am editing my point store to make it work perfectly for me, but I have a question. Here is the code for changing username:
// *********** Change Username ************
if ($itembuy[marketid] == 13) {
$findother = $vbulletin->db->query_read("SELECT * from " . TABLE_PREFIX . "user where username='".addslashes($new_username)."'");
$findother = $vbulletin->db->fetch_array($findother);
if ($findother) {
$error = 10; // Someone has that username.
}
$minchar = $vbulletin->options[minuserlength];
$maxchar = $vbulletin->options[maxuserlength];
if ($minchar > strlen($new_username)) {
$error = 11;
}
if ($maxchar < strlen($new_username)) {
$error = 12;
}
if ($error == 0) {
$vbulletin->db->query_read("update " . TABLE_PREFIX . "user set `username`='".addslashes($new_username)."', `$pointfield`=$points-$amount where userid='$userid'");
$vbulletin->db->query_read("insert into " . TABLE_PREFIX . "market_transactions set `date`='$time', marketid='$itembuy[marketid]', userid='$userid', affecteduser='$userid', amount='$amount'");
$points = $points - $amount;
$purchases = $purchases+1;
}
}
//

I understand I need to change the market ID, but what would the code be to add a specific usergroup (chosen by me, not user, like I would specify the additional usergroup in the code)

Thanks!

I'll have the code for you to do this shortly, mostly because Additional Usergroups is one of the new options to the Point Market items to be purchased. :)

[jacob115]

Do you mean you will give me the specific code to do it or it will be in the next version of the Point Market System?

If it is the next version of Point Market System, is there anyway I could be a beta tester?

Thanks!!

[DigitalDark]

It could be possible to purchase permissions in order to access certain forums. It would be a great idea. Thanks!

[argothiusz]

It could be possible to purchase permissions in order to access certain forums. It would be a great idea. Thanks!

Here is your answer "mostly because Additional Usergroups is one of the new options to the Point Market items to be purchased." Make a forum, assign new usergroup to it then make that usergroup available for purchase ^_^ and there you go :D

[maidos]

is it possible to create an own purchase merchandise. i want to create a entry fee of a contest which will cost them points but theres no given option to that

[maidos]

and maybe also allow user to purchase a usergroup?

[Forum Lover]

Still tagged and waiting for your v1.1.0 release. Any ETA mate?

[literatestylish]

I hope the update is coming soon! This is an awesome mod but I'm itchin for the new updates!

[mandingo]

Hope you're feeling better bro.

[Pangramma]

Mayhem, GREAT mod, it really suited me when I looked for a new change in my bigboard

The suggestions made before were great... buying additional usergroups it's EXTREMELY potential, meaning some users will see X forum, have Y pm's quota, have more or less restrictions, and so on.

Other NICE suggestion was the "expiration date" for the gifts. That would make users work harder so they can earn more points to spend.

Other ideas in my head, more sadistic :), involve buying attacks to users, like Banning for X days; dismember a user from a usergroup; changing the username, etc


This changes would make the forum experience more "gamer", like an RPG game, buying guns, shields, and potions and stuff :P. I'd LOVE to see a forum so interactive like the one in my head right now :)



SO, Mayhem, I'm sure you're working on 1.1, and I hope that you continue with this GREAT work you're doin'.


Best regards
Laucha

[Forum Lover]

Banning for x days!? Sounds great. :p

[TheMayhem]

Update: It's been a few days since I posted here. As far as I can tell I am pretty much done with the Administrative changes for this version. I'm now working on the user side of things and fixing reported bugs that I haven't already fixed. The version would of been out last week but I got sidelined for several days due to a weird illness that kept me in lala land. Anyways, I have spring break starting Friday so I'll have plenty of free time coming up. Beta testing for this version will begin shortly and I'll be private messaging users based off of glitches they found or features they suggested that I have implimented.

[DigitalDark]

Ok. I hope you have recovered of you illness. If I can help you with something tell me.
See you and thanks for working in that mod!

[Sayid]

Nominated rated 5 tagged for later use
One of the best mods I have seen
Is it allowed to translate this to other languages?
Thanks a lot

[random1231231231]

Quick question, do i need to install ucash first to make this plugin works?

[TheMayhem]

Quick question, do i need to install ucash first to make this plugin works?

In general you need a point system such as ucash, vbcredits, or vbookie. Some people have used the reputation field or even posts field for theres but I don't recommend it.

[random1231231231]

In general you need a point system such as ucash, vbcredits, or vbookie. Some people have used the reputation field or even posts field for theres but I don't recommend it.Thanks, i install ucash then. Your plugin works great :D

Next questions are :


i don't like the stealing idea, i want to disable it for all users, so i've disabled it from admincp > point market > categories & items.
Is it the correct way to avoid stealing?
On usergroup setting, there is "Steal Percentage" field, can i set it to 0? Because it was said to enter value between 1 and 100.
And on the "Market" page and postbit, the points shows as "Points". How do i change it to for example US$, etc.
Do i need to modify the template manually or is there an option maybe in your plugin?

[maidos]

is it possible to create an own purchase merchandise. i want to create a entry fee of a contest which will cost them points but theres no given option to that

hope you can consider these features, it will be proven very useful

[TheMayhem]

Thanks, i install ucash then. Your plugin works great :D

Next questions are :


i don't like the stealing idea, i want to disable it for all users, so i've disabled it from admincp > point market > categories & items.
Is it the correct way to avoid stealing?
On usergroup setting, there is "Steal Percentage" field, can i set it to 0? Because it was said to enter value between 1 and 100.
And on the "Market" page and postbit, the points shows as "Points". How do i change it to for example US$, etc.
Do i need to modify the template manually or is there an option maybe in your plugin?


- By disabling the Steal items, users will not be able to steal from other users. So you did this correct.
- Set it to 1 but honestly as long as the item is disabled it can't be viewed or purchased so this value isn't really needed.
- You could change that by replacing a phrase. I think it'd be a good idea for me to change the Point Value to something that users can control instead of it being a phrase, so I'm going to go ahead and add that feature to 1.1.0




Also, I am now private messaging some users to take part in the beta testing this weekend based off of activity and reported bugs they had.

[random1231231231]

- By disabling the Steal items, users will not be able to steal from other users. So you did this correct.
- Set it to 1 but honestly as long as the item is disabled it can't be viewed or purchased so this value isn't really needed.
- You could change that by replacing a phrase. I think it'd be a good idea for me to change the Point Value to something that users can control instead of it being a phrase, so I'm going to go ahead and add that feature to 1.1.0




Also, I am now private messaging some users to take part in the beta testing this weekend based off of activity and reported bugs they had.Thanks, forgot to mention i marked yours as "installed". The currency option isn't urgent but will be great if somehow you'll put it on next update :up:

[jacob115]

Could I be a beta tester?

[maidos]

hope you can consider these features, it will be proven very useful

along with my above suggestion which i hope you can consider
what about penalty for failing at stealing points that way ppl wont abuse it

[swiftor]

Very cool, any plans to let us price individual colors? I would pay for a Pro version with more features.

[swiftor]

Question: can I gift items made by others? Or convert good gifts made by others easily into official gifts?

[Matt Lathrop]

Is there away to mass remove gifts? For example I want users to buy a gift then have to buy it again next week so they are forced to maintain activity if they want to keep the gift.

[swiftor]

Sounds like you want a rental system.

Is there away to mass remove gifts? For example I want users to buy a gift then have to buy it again next week so they are forced to maintain activity if they want to keep the gift.

[TheMayhem]

I think he is talking about a timeout option, which several users have requested for market items to become deactive over time to encourage user participation.

[jacob115]

Any estimate of when the new version will be out and will it include the option to have additional user groups being sold?

[Matt Lathrop]

Also whenever I try to steal it fails my user group is set at 100 for steal... any help?

[TheMayhem]

Any estimate of when the new version will be out and will it include the option to have additional user groups being sold?

I scripted the usergroup permissions tonight. This is how I setup the new category:

Two Market Items for Individual Forum Access

Two Market Items for a Primary Usergroup Change (You choose the two Usergroups)

Two Market Items for a Secondary Usergroup (You choose the usergroups)



I also scripted today the ability to change an item's category. In addition in the next version there will be three testing categories and three test market items. The test market items can be used to write your own individual market items without interfering with the system. The categories will also allow you to setup different categories then what I've come up with or make the market seem bulkier or thinner.



I'll be sending out the Point Market testing versions to beta testers on Monday, which I'll wait to see how they are doing.

[DigitalDark]

I will online these days in order to help you. Good addons for the point market. I think that this mod is the best I have never seen for vBulletin!!!

[jacob115]

For these:



Two Market Items for a Primary Usergroup Change (You choose the two Usergroups)

Two Market Items for a Secondary Usergroup (You choose the usergroups)



When you say "you choose", do you mean the admin chooses the usergroup (me) or the user chooses the usergroup. Thanks!

[TheMayhem]

For these:



When you say "you choose", do you mean the admin chooses the usergroup (me) or the user chooses the usergroup. Thanks!

The Admin chooses the usergroups. The user pays to join these usergroups.

[jacob115]

Thanks for the explanation!! :)

[TheMayhem]

Just an update, this product should be going live tomorrow for version 1.1.0. I've spent the majority of my morning scripting the new gambling feature, which can allow users to:

Guess the number: You set an amount to charge in the Admin CP and a Payout amount. The user guesses a random number and if that number matches another random number, they get a big payout controlled by you.

Higher Card: Once again you set an amount to charge in the Admin CP and a Payout amount of the user wins. The user gets a random card against the house and if the user's card is higher then the house's, the user wins and gets their payout. If it is a draw or the house wins, the user gets nothing.

Lottery: Due to an overwhelming amount of people asking about it, I've included a lottery option in 1.1.0

I'll post screenshots later today but as I said, expect this product to go live some time tomorrow evening after the vb.org server change.

[DigitalDark]

It would be great that the people can buy points by making a real purchase for example using the subscription system of vbulletin. This could be more complicated. Anyway this mod is taking a good way!!

[jacob115]

Can't wait for the release!!

Thanks!

[random1231231231]

Just an update, this product should be going live tomorrow for version 1.1.0. I've spent the majority of my morning scripting the new gambling feature, which can allow users to:

Guess the number: You set an amount to charge in the Admin CP and a Payout amount. The user guesses a random number and if that number matches another random number, they get a big payout controlled by you.

Higher Card: Once again you set an amount to charge in the Admin CP and a Payout amount of the user wins. The user gets a random card against the house and if the user's card is higher then the house's, the user wins and gets their payout. If it is a draw or the house wins, the user gets nothing.

Lottery: Due to an overwhelming amount of people asking about it, I've included a lottery option in 1.1.0


I'll post screenshots later today but as I said, expect this product to go live some time tomorrow evening after the vb.org server change.Great. Since i deactivated the old version for a while because i believe the newer will come closely :up:

[TheMayhem]

Well it's 2:20 am and I finished up the Point Market 1.1.0. I'll be doing bug testing all morning and afternoon and release it sometime tomorrow night. Below are some screenshots of the gambling addition as well as the Forum Permissions Category I've added. Hopefully, I won't find any issue that is a biggy so I can release this for you guys.

Sleep time!

[jacob115]

So, it will not be released today? :(

[TheMayhem]

I'm down to three bugs and then it is released. I cannot seem to reduplicate the firefox problem that everyone has been having. Can someone please send me a link to their forum with a test account with some points so I can try and figure out why Firefox won't work for some people and will for others as I cannot release this bug until that is fixed!

[Alien]

Really doing a terrific job here.

Look forward to the new version for one of my projects.

[jacob115]

If I can have the new version I can release and tell my users (I have a lot of FireFox users) to report any glitches and I can forward them to you.

[TheMayhem]

My aim is Fishy Sticks 87. Hit me up and I'll give it to you.

[jacob115]

I have added you on AIM.

[maidos]

could u please answer if ucan considerimplementing point fee for entry of a contest or a custom item than admins can serup?

[TheMayhem]

could u please answer if ucan considerimplementing point fee for entry of a contest or a custom item than admins can serup?

There are three custom categories and three custom items included in 1.1.0 that you can use to script a custom market item if you want. By default they are disabled.

[reifegerste]

Hi, i installed the new version but i get the following error message:

Datenbankfehler in vBulletin 4.0.2:

Invalid SQL:
SELECT *, COUNT(marketid) FROM market_transactions
where marketid='42';

MySQL-Fehler : Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
Fehler-Nr. : 1140
Fehler-Zeit : Wednesday, 10.03.2010 @ 08:07:30
Datum : Wednesday, 10.03.2010 @ 08:07:30
Skript : http://www.simsforum.de/vbulletin/market.php
Referrer : http://www.simsforum.de/vbulletin/forum.php

[Jabong82]

Working great for me. Great job on 2.0!! Thank you.

[beacher]

seem to be a bug on lottery, pls look at the screen attacched ;)
I've place a bet on the lottery but it didn't work

[Gnoll]

Hi, i installed the new version but i get the following error message:

Datenbankfehler in vBulletin 4.0.2:

Invalid SQL:
SELECT *, COUNT(marketid) FROM market_transactions
where marketid='42';

MySQL-Fehler : Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
Fehler-Nr. : 1140
Fehler-Zeit : Wednesday, 10.03.2010 @ 08:07:30
Datum : Wednesday, 10.03.2010 @ 08:07:30
Skript : http://www.simsforum.de/vbulletin/market.php
Referrer : http://www.simsforum.de/vbulletin/forum.php

same here :/

Database error in vBulletin 4.0.2:

Invalid SQL:
SELECT *, COUNT(marketid) FROM vb_market_transactions
where marketid='42';

MySQL Error : Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
Error Number : 1140
Request Date : Wednesday, March 10th 2010 @ 11:09:23 AM
Error Date : Wednesday, March 10th 2010 @ 11:09:25 AM
Script : http://localhost/forumydk/market.php
Referrer : http://localhost/forumydk/forum.php
IP Address : 127.0.0.1
Username : Gnoll
Classname : vB_Database
MySQL Version : 5.0.51b-community-nt-log

[DigitalDark]

I've found 2 bugs I think.

1st in admincp the edit.png image doesn't appear because for some reason the "forum" folder is missing so the url is this "www.site.com/images/pointmarket/edit.png" and it must be this "www.site.com/forum/images/pointmarket/edit.png". It only appears in Category & Items section.

2nd bug. In mozilla firefox the purchase button is not working. In IE is working perfectly but I don't know what is wrong.

Thanks TheMayhem for your time!

[Shadawg]

Same problem here with the lottery...... wont let me buy a ticket...

[Shadawg]

The lottery seems to be working now, i think that the first lottery you make doesnt work....

for anyone creating a lottery your first one wont work, make another one and your good to go....

[maidos]

thanks but is it possible to display amount of purchases in organize way like every month?
because the contest i would like to see who is new contester and who iis the older contester so i wont be mixing the older with the new ones or maybe create a market just for contest let it run for x months?

[Jabong82]

I've found 2 bugs I think.

1st in admincp the edit.png image doesn't appear because for some reason the "forum" folder is missing so the url is this "www.site.com/images/pointmarket/edit.png" and it must be this "www.site.com/forum/images/pointmarket/edit.png". It only appears in Category & Items section.

2nd bug. In mozilla firefox the purchase button is not working. In IE is working perfectly but I don't know what is wrong.

Thanks TheMayhem for your time!

I am using FireFox and I have no issues with the purchase buttons. All the purchases so far for me seem to be working fine.

[Forum Lover]

So far, I am not having any issue too. :)

[Athena1984]

I really like this mod. Thank you for adding forum access! That is a great addition and is really useful for getting members to become active.

[TheMayhem]

I've found 2 bugs I think.

1st in admincp the edit.png image doesn't appear because for some reason the "forum" folder is missing so the url is this "www.site.com/images/pointmarket/edit.png" and it must be this "www.site.com/forum/images/pointmarket/edit.png". It only appears in Category & Items section.

2nd bug. In mozilla firefox the purchase button is not working. In IE is working perfectly but I don't know what is wrong.

Thanks TheMayhem for your time!

I repeatedly tested yesterday the purchase buttons using the default style of vBulletin and various versions of Firefox and could not reduplicate the error which means... It's your styles. Try adding the default vbulletin style and seeing if it works in firefox.




For those who had the mysql error on the main page, please send me a private message with a link to your forum. In addition I need a link to your PHP Info, a test username to your forum with some points so I can see what is causing the error for you but not others.

[literatestylish]

Nevermind! my mistake.

Thanks for the great mod Mayhem!

[Kreyg]

Database error in vBulletin 4.0.2:

Invalid SQL:
SELECT *, COUNT(marketid) FROM market_transactions
where marketid='13';

MySQL Error : Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
Error Number : 1140
Request Date : Wednesday, March 10th 2010 @ 10:58:56 AM
Error Date : Wednesday, March 10th 2010 @ 10:58:56 AM
Script : http://www.hotbloodedgaming.com/forum/market.php
Referrer : http://www.hotbloodedgaming.com/forum/forum.php
IP Address : 98.207.68.212
Username : Kreyg
Classname : vB_Database
MySQL Version : 5.0.51a-3ubuntu5.5

I got this after I installed and tried to go to the market

[TheMayhem]

I got this after I installed and tried to go to the market

I believe I found what was causing it and have updated the zip folder. To fix it, redownload the point market zip and upload the market.php file to your root forum folder.

[Kreyg]

I believe I found what was causing it and have updated the zip folder. To fix it, redownload the point market zip and upload the market.php file to your root forum folder.

That worked. Thanks a lot buddy!

[TheMayhem]

No problem. :) I still have yet to look into the broken edit images icon or the lottery system not working initially. I'll play with them after work and maybe release a maintenance release tomorrow that fixes those.

[The Ottoman]

an idea for the next release is to have the users upload their own image for gifts (which can be restricted to 20x20 gifs if need be.)

And then it would be *really* cool if that user generated gift were to stay in the store and anyone else who buys that gift in the future pays the original creator of the gift.



On edit.... really cool modification. closest thing to VbPlaza that I have seen in a while.

[TheMayhem]

an idea for the next release is to have the users upload their own image for gifts (which can be restricted to 20x20 gifs if need be.)

And then it would be *really* cool if that user generated gift were to stay in the store and anyone else who buys that gift in the future pays the original creator of the gift.



On edit.... really cool modification. closest thing to VbPlaza that I have seen in a while.

Currently how it is setup if a user creates a custom gift, they can choose the price to charge. If another user buys that gift, the user earns those credits as a type of revenue.

[The Ottoman]

Currently how it is setup if a user creates a custom gift, they can choose the price to charge. If another user buys that gift, the user earns those credits as a type of revenue.


Yeah, but they can't upload their own images. I was aware of the current setup, I was just adding with my request, in the same way I would have said It would be cool if someone could grind peanuts down so that the oil mixes and forms a pasty butter...

and then it would be REALLY cool to take that peanut butter and mix it with your thing called chocolate.


You've got the chocolate, I just want you to make the peanut butter.



Darnit, now I'm hungry.

[The Ottoman]

Another Question/Request:

I plan on having a couple of hundred gifts, and they are going to be broken out into different categories (think of departments in a store). I've noticed how you have the purchase a gift / create a gift options set up. I was wondering how I would go about creating new fields under the Gift category, and then assigning those gifts to the different categories.

[beacher]

I've installed the PL1 but the problem with the lottery is unfixed, now with two lottery the system add the cost for the ticket to all the lotteries as jackpot, even I place the bet for one only ;)

[Jabong82]

Great mod.

One minor error I get though is when I go to the market page and click anything in the "Top Market Items", I get an admin error saying I don't have permission to access this area.

I believe I changed all the permissions for the market, so not sure why this may be. Any help would be appreciated. Thank you again.

[ZGeek]

Srs, this is my favorite mod. Thank you so much for your work.

[The Ottoman]

Great mod.

One minor error I get though is when I go to the market page and click anything in the "Top Market Items", I get an admin error saying I don't have permission to access this area.

I believe I changed all the permissions for the market, so not sure why this may be. Any help would be appreciated. Thank you again.


Go into the Usergroup Manager and turn it on (it's at the bottom of the Usergroup setting, and turned off of all groups by default). Do this in addition to turning on the hack in the Admin CP.

[jacob115]

How do I remove the color red from the username glow feature?

[Jabong82]

Go into the Usergroup Manager and turn it on (it's at the bottom of the Usergroup setting, and turned off of all groups by default). Do this in addition to turning on the hack in the Admin CP.

Thanks for the response.

I am able to use the market, its just this one particular area can't be accessed. My user permissions are on and I tried resetting it as well.

I can use every other area of the market but this area.

[TheMayhem]

Thanks for the response.

I am able to use the market, its just this one particular area can't be accessed. My user permissions are on and I tried resetting it as well.

I can use every other area of the market but this area.

I'm not really sure where you mean, can you take a screenshot and point your cursor to the link your talking about?


And PL1 only had the fix to the market mysql error. I'll deal with the lottery bugs tomorrow.

[War.Frog]

I'm just waiting on vBCredits. Once it has gone gold, this is going in!

[Jabong82]

I'm not really sure where you mean, can you take a screenshot and point your cursor to the link your talking about?


And PL1 only had the fix to the market mysql error. I'll deal with the lottery bugs tomorrow.

Basically when I click any of the items in the Red Boxes (photo 1), I am taken to the error message (photo 2).

However despite not being able to access these, I can go anywhere else in the store and buy items etc. Only these areas for some reason are off limit to me.

[Switch3130]

Thanks for the update I'm upgrading now.

[TheMayhem]

I'm just waiting on vBCredits. Once it has gone gold, this is going in!

I've tested this on vbcredits a bit this week and the products work very well together. Darkwaltz4 has done an amazing job with vbcredits and I think the market compliments it nicely.






Basically when I click any of the items in the Red Boxes (photo 1), I am taken to the error message (photo 2).

However despite not being able to access these, I can go anywhere else in the store and buy items etc. Only these areas for some reason are off limit to me.

OH! Okay, I now know what you mean. The id variable isn't properly being passed through. I'll mark it as a glitch and include it in the PL 2 release I plan on doing Thursday evening. I just want to give you guys a little more time to find anything else that needs attention before I upload the needed fixes.

[Jabong82]

I've tested this on vbcredits a bit this week and the products work very well together. Darkwaltz4 has done an amazing job with vbcredits and I think the market compliments it nicely.








OH! Okay, I now know what you mean. The id variable isn't properly being passed through. I'll mark it as a glitch and include it in the PL 2 release I plan on doing Thursday evening. I just want to give you guys a little more time to find anything else that needs attention before I upload the needed fixes.


Sounds great. Thanks again for all your help!

[beacher]

thanks Mate for the news about the PL2 release. ;)

[Juggernaut]

I can't seem to find where to delete gifts :(

[TheMayhem]

I can't seem to find where to delete gifts :(

To delete a purchased gift, go into the admin cp. If it is a custom gift go to the custom gifts page and if it is a regular gift go to the normal gifts page. On the gift listing you'll see a purchased icon with the number of people who purchased it. Select the gift you are looking for by clicking the number link. Inside it'll give the list of everyone who has purchased that gift. Simply click the radio button of the person you want to delete the gift purchase and click delete :)

[Juggernaut]

^^ Thank you very much, that worked great, nominated for MOTM :D

[PixelFx]

this system looks promising

[DigitalDark]

I've attached you a screenshot of my Acp. There is something strange in the edit button.

[decipher442]

How can I take the nav bar "Market" link out of my menu?

[TheMayhem]

I've attached you a screenshot of my Acp. There is something strange in the edit button.

It's a reported glitch on the path that I've fixed for the next version.

How can I take the nav bar "Market" link out of my menu?

Go to your Plugin Manager and disable the plugin Point Market: Navigation Tab by checking the checkbox. This will remove the Market tab.

[jacob115]

Is it possible to change the refund time?

[TheMayhem]

Edit the usergroup that you want to change the refund time for and that'll change the refund time of each item.

[decipher442]

I got a question....

Ok so I am interested in this point market mainly so that I can let my users redeem their points for domain names, websites, real cash, etc..

Is there a way to create a market item and have it notify a certain user (me) when purchased?

[TheMayhem]

In version 2.0.0 I installed three test items. Those test items you can custom script to do whatever you like such as that. You'd have to custom script the actions of those test items to do what your asking.

[decipher442]

In version 2.0.0 I installed three test items. Those test items you can custom script to do whatever you like such as that.


I seen that and edited one of them as "Domain name" and purchased it... everything worked but I can not seem to find out where in the admin panel it shows that USER X purchased the item.

You'd have to custom script the actions of those test items to do what your asking.

What do you mean by "custom script the action" please elaborate more on this.

* If you mean editing the title and description of the test ones you created, "I did that."

Is there a way to create a market item and have it notify a certain user (me) when purchased?

UPDATE: I just noticed that after purchasing the item that it did not show in the admin panel under the "Point Market Item History" Why is this?

After I purchased the item it says, "Transaction Information Your item has been purchased successfully." However it does show anywhere that I purchased it on the forum or in the admin panel.. I also noticed that it didn't take the points away from my account either (im using the ucash hack) :(

Any ideas as to what I may be doing wrong?

[TheMayhem]

I seen that and edited one of them as "Domain name" and purchased it... everything worked but I can not seem to find out where in the admin panel it shows that USER X purchased the item.



What do you mean by "custom script the action" please elaborate more on this.

* If you mean editing the title and description of the test ones you created, "I did that."

Is there a way to create a market item and have it notify a certain user (me) when purchased?

UPDATE: I just noticed that after purchasing the item that it did not show in the admin panel under the "Point Market Item History" Why is this?

After I purchased the item it says, "Transaction Information Your item has been purchased successfully." However it does show anywhere that I purchased it on the forum or in the admin panel.. I also noticed that it didn't take the points away from my account either (im using the ucash hack) :(

Any ideas as to what I may be doing wrong?

In order for your test items to work, you need to manually edit market.php file and write the necessary php code for it to work. On the release I am about to give that has a number of fixes it will automatically take off the points for the test purchases, add a transaction purchase, and show up on the history. However, if you want it to physically do something instead of a user just purchasing a blank page that said they purchased something, you need to modify the code and add the actions or tell the script what to do. I'll be releasing this within the next 12 hours or so.

[decipher442]

In order for your test items to work, you need to manually edit market.php file and write the necessary php code for it to work. On the release I am about to give that has a number of fixes it will automatically take off the points for the test purchases, add a transaction purchase, and show up on the history. However, if you want it to physically do something instead of a user just purchasing a blank page that said they purchased something, you need to modify the code and add the actions or tell the script what to do. I'll be releasing this within the next 12 hours or so.

Cool so you updating this within the next 12 hours or so... Awesome Deal!

btw.. whats your paypal so I can give you a DONATION? (I didn't notice an option here)

[TheMayhem]

Cool so you updating this within the next 12 hours or so... Awesome Deal!

btw.. whats your paypal so I can give you a DONATION? (I didn't notice an option here)

I updated it so it appears.

A maintenance 2.0.1 has been released to fix the admin cp image issues, gambling issues, and reported sql issues.

[jacob115]

Another question, do you plan to allow for multi-currency? Like so we can have 2 point fields and users can choose which field to use?

[decipher442]

By any chance can hire you to make the following features...

1. Add a feature in the admin panel to notify a certain member via pm when an item purchase has been made.
2. Option to add new Point Market Items & Categories. (just basic ones like the three test item you added to it)

Also how do I give you a DONATION for your gr8 support..?

[TheMayhem]

Another question, do you plan to allow for multi-currency? Like so we can have 2 point fields and users can choose which field to use?

There is already plans for me to allow for a second currency. I'll be doing a special release when vbcredits is due to allow for a second currency among other changes to make this product work better with vbcredits.


By any chance can hire you to make the following features...

1. Add a feature in the admin panel to notify a certain member via pm when an item purchase has been made.
2. Option to add new Point Market Items & Categories. (just basic ones like the three test item you added to it)

Also how do I give you a DONATION for your gr8 support..?

In my next release I'll add a few additional test items that you can use however you like. As for a feature to notify Administrators, that shouldn't be tough so if I remember I'll add it as a normal feature. To answer your donation question, there is a little Support Developer link under the About the Developer area for the hack that you can use if you like.

[decipher442]

In my next release I'll add a few additional test items that you can use however you like.

Do you have an idea when the next release will be?

[TheMayhem]

If a serious glitch/bug is found I'll roll a release out within a day or so. However, I'd like the next release to feature some new features based off of feedback that the posters make over the next week. Realistically, I would like to get another release before I leave for San Diego so sometime within the next two weeks. I try to get something out once every two weeks to constantly keep this product updated and evolving until people run out of ideas.

[decipher442]

.

Can I pay you to add those 2 features sooner..? :D

1. Add a feature in the admin panel to notify a certain member via pm when an item purchase has been made.
2. Option to add new Point Market Items & Categories. (just basic ones like the three test item you added to it)

To answer your donation question, there is a little Support Developer link under the About the Developer area for the hack that you can use if you like.

Cool deal.. just sent you a $25 donation. :)

[Switch3130]

It would defiantly be nice if a user received a PM when someone buys a gift for them.

[Shadawg]

Would be nice for some more gambling games, like poker, texas hold em, etc.... also guess the number ang higher and lower, shouldnt the user be able to select what to pick instead of being randomly generated?

[Veer]

Hi TheMayhem,

The idea and product is awesome, v2 looks pretty good however you should enhance gifts display area in the market and user profile, currently the display is not good if we add Facebook size gift images, hope you make its template more flexible.

thank you.

[Forum Lover]

Is it there already? Member can customize there thread title?

[KURTZ]

edit: nvm all troubles are fixed :D

[random1231231231]

Awesome. You're the man ! I love the setting to change currency from "Points" to something else.

[Alien]

It would defiantly be nice if a user received a PM when someone buys a gift for them.

This would be a terrific new addition, I've already gotten requests for that!

[TheMayhem]

Well I've figured out what I'm going to do with the next version. Provided there are no bugs found that require me to release something immediately, I plan on working on these areas:

Gifts: I'm going to add Gifts categories, usergroup permissions so that certain gifts can only be purchased by certain usergroups, and the ability to select where the categories appear on the user's postbit. I know some people wanted the postbit location to change so I think by assigning a category to the location will effectively fix that issue.

New Category: Mod Integration. I think it's finally time I begin to start allowing the Point Market to feature addons or integration with other very popular mods. There will be a category release on the next release pertaining to this. In addition, I'll be releasing two addon releases probably to integrate the point market with the Arcade and Downloads 2. I'm not sure what all I'm going to do with each but I'll play with them a bit to see.

There's also a few other little changes/addons that you guys have requested that I'll try my best to get into the release.

[pjdaley]

With the newest update i have gotten:

Sorry, you don't have permission to access the administrative controls on this page.

If you need to access this page, ask your lead administrator to enable your permissions for this page using the Administrator Permissions (http://ex.ploit.net/admincp/adminpermissions.php?do=edit&u=1) section of the control panel.

while trying to edit in the adminCP. I have changed the Admin Permissions and it doesent stick to "Can Point Market"



EDIT:

I was able to fix this issue manually by editing the mysql database table adminstrator and changing the value of market_custom_admin_perms to 1

[Matt Lathrop]

Is it possible to add the ability to delete a gift from everyone who has gotten it rather than one at a time.

[TheMayhem]

With the newest update i have gotten:

Sorry, you don't have permission to access the administrative controls on this page.

If you need to access this page, ask your lead administrator to enable your permissions for this page using the Administrator Permissions (http://ex.ploit.net/admincp/adminpermissions.php?do=edit&u=1) section of the control panel.

while trying to edit in the adminCP. I have changed the Admin Permissions and it doesent stick to "Can Point Market"



EDIT:

I was able to fix this issue manually by editing the mysql database table adminstrator and changing the value of market_custom_admin_perms to 1

Odd...very-very odd. Has anyone else experienced this issue or is it because your bitfields weren't being correctly updated?

Is it possible to add the ability to delete a gift from everyone who has gotten it rather than one at a time.

Unfortunately, no it isn't. Currently you can only go through and delete one gift at a time.

[Radjedef]

Same issue, can't access the pages in the backend. The bitfields weren't correctly updated.

But nice mod!

[Forum Lover]

Mayhem, cant we use vCash from vbookie?

[argothiusz]

Couple of bugs/minor fix needed:

1. I am getting the same admin issue like everyone.
2. Even though I set the point system decimal place to 0 but the price in "guess the number" is still in 5 digits decimal format.
3. Usertitle doesnt seem to work. I am getting < s > Title < / s >

Suggestion:
1. Under the "market addon features" navigation. The features shouldn't be turned on by default. Don't make it appear unless user purchased the feature to prevent confusion or forum owner doesn't want to turn on certain feature.
2. Option to delete the font color/face/bold items in case the user doesn't want it anymore.

I will report more bugs I found any. As always, great stuff!!

[TheMayhem]

Mayhem, cant we use vCash from vbookie?

Yes you can, vCash is supported just enter it in the point field.

Couple of bugs/minor fix needed:

1. I am getting the same admin issue like everyone.
2. Even though I set the point system decimal place to 0 but the price in "guess the number" is still in 5 digits decimal format.
3. Usertitle doesnt seem to work. I am getting < s > Title < / s >

Suggestion:
1. Under the "market addon features" navigation. The features shouldn't be turned on by default. Don't make it appear unless user purchased the feature to prevent confusion or forum owner doesn't want to turn on certain feature.
2. Option to delete the font color/face/bold items in case the user doesn't want it anymore.

I will report more bugs I found any. As always, great stuff!!

Which Point Market Admin Pages is it doing this on? Are you updating the admin permissions and it is not sticking to enabled or is it saying enabled but still not working?

[argothiusz]

Yes you can, vCash is supported just enter it in the point field.



Which Point Market Admin Pages is it doing this on? Are you updating the admin permissions and it is not sticking to enabled or is it saying enabled but still not working?

Oh I got it to work after I logged to root admins and enabled it for all secondary admins. Shouldn't it enabled by default?

[TheMayhem]

Oh I got it to work after I logged to root admins and enabled it for all secondary admins. Shouldn't it enabled by default?

Nah I pretty much disable every option/feature by default on the Point Market. That's to force people to take the time and go through and edit the Admin Options and setup the Point Market the way they want. Otherwise, people won't learn on how truly powerful the Point Market can be with its features and will just use what's in the box.

[swiftor]

Any chance of a feature where individual name colors could be made to have different prices?

[TheMayhem]

Any chance of a feature where individual name colors could be made to have different prices?

No but I was considering on adding a rainbow color effect for usernames, which could be charged more.

[FlameGun]

Could you make a subscription purchase item? Kind of like a timed usergroup change.

[Forum Lover]

Yes you can, vCash is supported just enter it in the point field.



Which Point Market Admin Pages is it doing this on? Are you updating the admin permissions and it is not sticking to enabled or is it saying enabled but still not working?


Database error in vBulletin 4.0.2:

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

MySQL Error : Unknown column 'vCash' in 'field list'
Error Number : 1054
Request Date : Saturday, March 13th 2010 @ 03:27:24 AM
Error Date : Saturday, March 13th 2010 @ 03:27:25 AM
Script : http://mysite.com/forums/admincp/market.php?do=statistics
Referrer : http://mysite.com/forums/admincp/index.php?do=nav
IP Address : 111.220.254.120
Username : me
Classname : vB_Database
MySQL Version : 5.0.89-community


I got this error Mayhem. :( Any Idea mate?

[TheMayhem]

Database error in vBulletin 4.0.2:

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

MySQL Error : Unknown column 'vCash' in 'field list'
Error Number : 1054
Request Date : Saturday, March 13th 2010 @ 03:27:24 AM
Error Date : Saturday, March 13th 2010 @ 03:27:25 AM
Script : http://mysite.com/forums/admincp/market.php?do=statistics
Referrer : http://mysite.com/forums/admincp/index.php?do=nav
IP Address : 111.220.254.120
Username : me
Classname : vB_Database
MySQL Version : 5.0.89-community


I got this error Mayhem. :( Any Idea mate?

That means that vCash doesn't exist. Is that the name of your point field for vBookie and is it located in the user table?

[Alien]

I am absolutely LOVING this feature, mate.

Here's the bugs/requests I have:

1) Please add {vb:raw headinclude_bottom} directly under {vb:raw headinclude} -- This was made a default template in vBulletin 4.0.1 officially. Those who use the additional.css template that vB has as default now to put in all CSS overrides (as not to touch original files), will get a messed up display without this being included in MARKET template!

2) Typo in "$vbphrase[market_error_steal_fail]" - "unsuccessfuly" should be "unsuccessfully" - Missing an l

3) Please consider changing the overall/top table from 95% width to 100% width in "MARKET" template to match all other pages.

4) Please consider a link in the left sidebar to always return to the main market.php summary page. For example, sometimes you do something such as purchase an item, and you're dumped back into the category and have no way back link wise to the main page unless you click back on your browser or re-click a top navigation link.

[TheMayhem]

I am absolutely LOVING this feature, mate.

Here's the bugs/requests I have:

1) Please add {vb:raw headinclude_bottom} directly under {vb:raw headinclude} -- This was made a default template in vBulletin 4.0.1 officially. Those who use the additional.css template that vB has as default now to put in all CSS overrides (as not to touch original files), will get a messed up display without this being included in MARKET template!

2) Typo in "$vbphrase[market_error_steal_fail]" - "unsuccessfuly" should be "unsuccessfully" - Missing an l

3) Please consider changing the overall/top table from 95% width to 100% width in "MARKET" template to match all other pages.

4) Please consider a link in the left sidebar to always return to the main market.php summary page. For example, sometimes you do something such as purchase an item, and you're dumped back into the category and have no way back link wise to the main page unless you click back on your browser or re-click a top navigation link.

Great Findings,

I'll be sure to include fixes for all 4 things on the next release.

[jacob115]

I thought I would make a post here telling people how popular this is on my forum.

I have had this officially released to my members for 2 days now, and I have had 157 purchases.

The gifts are very popular at my forum!!

[Pangramma]

Sorry, but I don't understand how the "Test Category/Test Item" works... let's say... if I want to make another Forum Access, or a "ban user" request, what should I do?

Is any way possible to make some items work with an "expiration time"?



Thanks! :D

[Forum Lover]

That means that vCash doesn't exist. Is that the name of your point field for vBookie and is it located in the user table?

Mayhem, after vCash, I tried uCash.. still the same. :(

The point field has been entered but no data exists in this field name.

Any idea mate?

[TheMayhem]

Mayhem, after vCash, I tried uCash.. still the same. :(

The point field has been entered but no data exists in this field name.

Any idea mate?

Do you have Ucash installed for vbulletin 4 on your forum? If so, does the Point Field Name currently say ucash (Case Sensitive)?

[Juggernaut]

This mod was working great before I changed hosting companies, now all I get is this next to some nicks that used to display correctly before <s>usertitle</s>, I've tried to fix, but only thing that works is changing the usertitles through the admin cp, with html enabled, but can't get users to change color or use strikethrough when I change this this way.

EDIT: I also ran the maintenance on Usertitles, but it didn't fix this :(

[TheMayhem]

This mod was working great before I changed hosting companies, now all I get is this next to some nicks that used to display correctly before <s>usertitle</s>, I've tried to fix, but only thing that works is changing the usertitles through the admin cp, with html enabled, but can't get users to change color or use strikethrough when I change this this way.

EDIT: I also ran the maintenance on Usertitles, but it didn't fix this :(

Send me a pm with your site address, a test account with alot of points so i can test and see what you mean.

[Forum Lover]

Do you have Ucash installed for vbulletin 4 on your forum? If so, does the Point Field Name currently say ucash (Case Sensitive)?

ah!! Dang!! it was uCash, now ucash and working. :D

thanks Mayhem.

[w-elbalad.com]

what the Point Field: ? ? :)

[TheMayhem]

what the Point Field: ? ? :)

Point Field Name: Is the name of the field that you store a numerical value in that the store will use to calculate your purchase money you have to buy items. In general, most of the people use ucash or vbookie currently and there point field names are usually ucash or vbookie. You must have one of those products installed. Additionally, other people have used the reputation field to calculate points for users.

[literatestylish]

I think the statistics might be a bit messed up. I just doubt that one member has over 400 purchases.

[pjdaley]

<a href="https://vborg.vbsupport.ru/member.php?u=22621" target="_blank">TheMayhem</a>

I checked into the admin issues, it seems as though when you change the usergroup permissions to allow admins to access the point market, that setting doesn't stick. Maybe you are missing something in your mysql query that sets that option to 1. An invalid query would be my first guess as to why this issue is happening.

[TheMayhem]

I think the statistics might be a bit messed up. I just doubt that one member has over 400 purchases.

Are you sure the statistic your referring to is not the total purchases of all members? When people visit the Point Market there are two statistics, one for an individual purchases and the other for total transactions. The total transactions is referring to all members.

TheMayhem (https://vborg.vbsupport.ru/member.php?u=22621)

I checked into the admin issues, it seems as though when you change the usergroup permissions to allow admins to access the point market, that setting doesn't stick. Maybe you are missing something in your mysql query that sets that option to 1. An invalid query would be my first guess as to why this issue is happening.

Your the second member two complain about that not working so I think maybe I have a bug somewhere in my code for fresh installs. I'm going to look into it as well as all other bug reports and try to come out with another bug fix dubbed 2.0.2, which will be just another bug fix. Expect it out by the weekend.

[jacob115]

I have 2 questions.

This is my fourth day with the market released to my members. We are going to most likely hit 500 purchases today.

I do have a problem. Some people have 30 gifts in their postbit. Is there a way to show like the newest 10? Or is there a way to set an expiry?

My second question. Lets say there is Usergroup 1 and Usergroup 2. My primary usergroup is Usergroup 1 and it has a discount of 0%. My additonal usergroup is Usergroup 2 and Usergroup 2 has a discount of .2 (20%). However, I still only get a 0% discount rate. Why is this?

[fogjuice]

Is there a way to prevent users from using certain words in their user title? For example, I wouldn't want anyone changing their name to "Administrator" or "Moderator", etc.

Also, is there a way for users to disable their gifts if they don't want them to show up in their profile and postbit?

And finally, do custom gifts work? It seems when I create custom gifts for other users to purchase, they never show up anywhere.

[bigcurt]

Any possible chance of being ported to 3.X? There are thousands of people who still use 3.X, me being one of them. Not because I can't afford 4, just because I do not like the significant damage it seems to have done to the mod community.

[Alien]

I'm unsure if this has been reported already. I noticed on the main market page (just market.php), the Most Purchases, Most Refunds, and Most Steal Attempts while having updated the USER NAMES properly NEVER seems to update the avatar picture. They are always using the unknown.gif

Am I the only one experiencing this?

[TheMayhem]

Any possible chance of being ported to 3.X? There are thousands of people who still use 3.X, me being one of them. Not because I can't afford 4, just because I do not like the significant damage it seems to have done to the mod community.

I truly wish I could but I really don't have the time to rescript this product for version 3.8, which would involve relearning a lot about vBulletin in the 3.x series. This little mod has already become extremely large and there are thousands upon thousands of lines of coding for it. I would consider giving my permission to someone to port the mod to a version 3.8 if the right programmer came a long.

[Jabong82]

Hi this is a great mod but I am concerned about he gift feature.

Is there any way to let these things expire or at least users able to delete them? As someone stated before I don't want to have massive amounts of gifts in the post-bit, profile etc. I guess you can delete them from the admin panel, but that could be problematic if you have a large board? (maybe I missed something)

Please let me know your thoughts regarding this.

Thank you again.

[KiLLWiT]

I'm unsure if this has been reported already. I noticed on the main market page (just market.php), the Most Purchases, Most Refunds, and Most Steal Attempts while having updated the USER NAMES properly NEVER seems to update the avatar picture. They are always using the unknown.gif

Am I the only one experiencing this?

I'm having this same problem.

[bigcurt]

I truly wish I could but I really don't have the time to rescript this product for version 3.8, which would involve relearning a lot about vBulletin in the 3.x series. This little mod has already become extremely large and there are thousands upon thousands of lines of coding for it. I would consider giving my permission to someone to port the mod to a version 3.8 if the right programmer came a long.

Thanks anyway bud :(. Either way, you have a great mod on your hand it seems..thanks a lot.

[maidos]

thanks but is it possible to display amount of purchases in organize way like every month?
because the contest i would like to see who is new contester and who iis the older contester so i wont be mixing the older with the new ones or maybe create a market just for contest let it run for x months?

i hope you can consider oraganising amoun t of ppl who purchase the custom item and sort it by month? or anything better so we list the particpant of the contest?

[unicorn2433]

I love this! Thank you for creating it.

I was wondering in the purchase gift screen where it says choose award to be purchased where can i change that so it reads choose gift to be purchased:)

oh and can custom gifts be any size you want?

[TheMayhem]

I love this! Thank you for creating it.

I was wondering in the purchase gift screen where it says choose award to be purchased where can i change that so it reads choose gift to be purchased:)

oh and can custom gifts be any size you want?

That's controlled by a phrase. Just search for the text and change it as you like.

[Boko577]

How does the lottery work? It doesn't work for me... Every time I try and purchase a ticket or whatever it says ticket number 0 cost 0 payout 0. Is it because I have a %100 discount as an admin?

[Veer]

Hello,

Will this work with [DBTech] vBActivity v1 ?

[worldwidereefer]

how do you know who won the lottery ticket ?

there is no notification or nothing ?......

Is there a way ?

[TheMayhem]

How does the lottery work? It doesn't work for me... Every time I try and purchase a ticket or whatever it says ticket number 0 cost 0 payout 0. Is it because I have a %100 discount as an admin?

Download the latest version Boko. 2.0.0 is out of date and contains several glitches related to the lottery. You need to download 2.0.1.

[paulbhoy]

this is a great mod, good work, But I would absolutely love it if it had a few more things, such as

Username Font
Bank
Bypass flood control

and what ever other cool features you can think of ;)

anyway, keep up the good work, and keep the updates coming!

[Veer]

Hello,

Will this work with [DBTech] vBActivity v1 ?
Waiting for the answer TheMayhem, as it is also a point system.

[unicorn2433]

That's controlled by a phrase. Just search for the text and change it as you like.

TY so much:)

I am sorry to bother everyone again again but I was wondering is there a way to limit how many gifts a person postbit shows?


And how can I get the system to send a PM message when someone recieves a gift with the info on who it came from and why. Like a auto message from the sender to the receiver? Also a pm when someone is getting a donation of points from another user.
So these pms look like they are coming from the person who sent it to the person receiving it. So far no one on my site knows they got a new award or a donation so it would be handy to get a pm.

Does this integrate with ibproarcade?

We had vbplaza before and m users r aking if there could be an option to add music to thier profile

[Juggernaut]

Any way the gifts can be disabled from showing in the postbit, while maintaining the username and usertitle modifications active at the same time? I want the gifts to show in the profiles only, but when I disable the plugins for the postbit, the nick and title modifications disappear as well. :)

[KiLLWiT]

Whenever a user changes his usertitle color or glow, it moves the usertitle up under the username. So instead of it showing the username then his/her online status then the usertitle, it makes it username, usertitle then online status. How can I make it stay in a certain spot in the postbit? When I look in the source of the page, I see that it's making the usertitle as part of the username.

[Juggernaut]

I am having the same problem as KiLLWiT :)

[Jabong82]

Any way the gifts can be disabled from showing in the postbit, while maintaining the username and usertitle modifications active at the same time? I want the gifts to show in the profiles only, but when I disable the plugins for the postbit, the nick and title modifications disappear as well. :)

x2 for this please!

[decipher442]

Are you planning to add these much needed features?

1. Add a feature in the admin panel to notify a certain member via pm when an item purchase has been made.
2. Option to add new Point Market Items & Categories. (just basic ones like the three test item you added to it)

[pjdaley]

Are you planning to add these much needed features?

1. Add a feature in the admin panel to notify a certain member via pm when an item purchase has been made.
2. Option to add new Point Market Items & Categories. (just basic ones like the three test item you added to it)


This would be a handy feature. However you can also do this yourself with very minimal MySQL knowledge via PHPMyAdmin.

It would be a very handy addition the the actual mod though.

[KiLLWiT]

Is there a way we can make the discount work on the gifts as well instead of the "purchase a gift" option only? For example if it is 100 points to purchase a gift and one of the gifts is 300 points and the person has a 10% discount, it's only doing the discount on the purchase a gift, making it be 390.

[unicorn2433]

Can anyone tell me if there is a way i can set up notices to inform someone when a gift and donatation from sender to receiver is being sent on my own?

[decipher442]

Are you planning to add these much needed features?

1. Add a feature in the admin panel to notify a certain member via pm when an item purchase has been made.
2. Option to add new Point Market Items & Categories. (just basic ones like the three test item you added to it)

This would be a handy feature. However you can also do this yourself with very minimal MySQL knowledge via PHPMyAdmin.

It would be a very handy addition the the actual mod though.

Yah it would be a very useful feature to many. I would not mind paying to have it built in but the developer (TheMayhem) told me a while back he would look into doing it..

Assuming he does not build these VERY USEFUL features into it feel free to send me a quote for doing it.

@ - TheMayhem

Do you still plan on adding these features?

1. Add a feature in the admin panel to notify a certain member via pm when an item purchase has been made.
2. Option to add new Point Market Items & Categories. (just basic ones like the three test item you added to it)

[pjdaley]

also can i suggest turning the lotto off unless a current lottery is in place?

[osayidan]

I haven't been able to read all 400+ posts here, but is there a way to completely turn off stealing as if it did not exist? This mod is looking awesome and I've installed it, but the stealing part isn't something we want in our community. If there's something to edit in the code somewhere I have no problem with that.

[TheMayhem]

Hey guys,

I haven't been on in about 10 days. The reason why is because I've been on a business trip in San Diego and it is EXTREMELY expensive where I am staying to get access to the Internet. Anyways a short update,

I have a release set for when I return that will fix pretty much all reported bugs and also have a few highly requested changes such as more control over gift display and number of gifts, private message notification, etc.

I'll be returning on Sunday. Keep the posts coming as I do read each and every one.

[osayidan]

I've been playing around with this all day and it's great. My previous post can be disregarded since I figured out disabling the items for stealing pretty much does what I wanted.

I just have a few questions and suggestions now that I'm more familiar with the system.

Q1 - Are any user group permissions required for custom titles (i.e: if a group a member is in prevents or overrides titles, will the market's title prevail?).

Suggestion 1 - Have admin control over the list of colors, separately for font and for name. Mainly to avoid having users choose the same color as staff, but to not restrict them from having those colors for their posts. I managed to limit name colors by template editing, but it also restricted colors for fonts.

Suggestion 2 - Be able to decide how gifts are listed, the current list (market.php?do=item&id=21) isn't very pleasing to the eyes. Actually we don't even really need control over it, just have it go row by row instead of 2 columns, this way we can easily template edit if we really need anything extra.

Suggestion 3 - allow discounts option as a fixed number or a percentage. Would be cool to give everyone "xx points off for one day only!" events. Would just need to make sure it stops at 0 instead of making an item worth negative points.

Everything else I wanted changed I managed to change fairly easily through phrases or template edits, so that's all I've got to suggest. I'd also like people to be able to buy points via paypal but that's more on the end of ucash and not this mod.

[decipher442]

I have a release set for when I return that will fix pretty much all reported bugs and also have a few highly requested changes such as more control over gift display and number of gifts, private message notification, etc.

I'll be returning on Sunday. Keep the posts coming as I do read each and every one.

AWESOME, I can't wait; getting very excited about the new release!!!

With the new release I will be able to launch this on my forum and will have thousands of VERY HAPPY users. :D:D:D

[Skyrider]

Any way for me to disable the "MARKET" in the navbar?

[maidos]

better logging for usser who purchased a customized items? archive in months?

[ZuFett]

I have a problem:

"Point Field Name"
What i must type there? I have install ucash and write in this filde "ucash" but on Maintenance i get this error:

http://www.imagebanana.com/img/wmz01nx9/mmarkt.jpg

Someone can help me?

[Radjedef]

I have a problem:

"Point Field Name"
What i must type there? I have install ucash and write in this filde "ucash" but on Maintenance i get this error:

http://www.imagebanana.com/img/wmz01nx9/mmarkt.jpg

Someone can help me?

In ucash:
Points Data Location: TP.user.ucash

In Point Market:
Point Field Name: ucash

[ZuFett]

I write this in this fields but the problem is again.

See:

[argothiusz]

I write this in this fields but the problem is again.

See:

That means you haven't use the ucash function or as it said "no data stored in the table"

[TheMayhem]

I write this in this fields but the problem is again.

See:

If you are using ucash, it will give you an error because it is not finding any data in that field on your user table.

Do you have any points or is your points set to 0? You need to have > 0 points by at least a decimal number for that error to go away.

[Reaper255]

I am getting the same error but with vBookie.

Point Field: vbookie The point field has been entered but no data exists in this field name.

[ZuFett]

some users have points or what u mean?

Oh, i make a Post to change MY Points and it works :)

Thanks!

[TheMayhem]

I am getting the same error but with vBookie.

Point Field: vbookie The point field has been entered but no data exists in this field name.

Do you have any current points earned in this field?


I will be releasing a developmental update this Wednesday or Thursday :)

[fernas]

It would be great to create an item to put music in user profiles. And also show the categories in the center instead of left as a list.

Great mod!

[badawidollah]

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.

i am using ucash

[badawidollah]

Enter the fieldname of the point location located inside the user table.

[badawidollah]

The Points Market is currently disabled. Please enter a point field name in the Point Market Control Panel to enable this feature.

[badawidollah]

cant see "point market" at "admin control panel"

[badawidollah]

installing..
excelent

it could be game online for my forum
but i cant see point market in cpanel

maybe it`s good input maybe not.

1. users only can stole from people with same reputation/ucash/points -/+ 60% only.
2. users can only stole 5 times/hours
3. more points they have more price for stolen action

its make look like a real game

[jacob115]

I would be great to create an item to put music in user profiles. And also show the categories in the center instead of left as a list.

Great mod!


I really like the profile music idea!!

[McAtze]

Nice Hack :up:

.. i look for an german translation .. can someone help me ?? :confused:

[kylek]

Can you have the gifts set so they expire in a set time period? This way the gift doesn't stay around forever so it uses up the members points more.

[ZuFett]

@Atze

hab den Hack heute übersetzt. Wenn ich raus bekomme wie man das exportieren kann, dann gebe ich dir die übersetzung (Wenn der Mod-Author zustimmt)

@Mayhem
how i disable the menuepoint in navbar?

[Muazam]

This happens when I enter market.php

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

1. 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?
2. If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.



Where to I set my permission?

[alloutvb]

This happens when I enter market.php

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

1. 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?
2. If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.



Where to I set my permission?

go in your users groups and turn it on for every group you what to see it

[Muazam]

go in your users groups and turn it on for every group you what to see it

Thank you, it worked ^^

[Reaper255]

Do you have any current points earned in this field?


I will be releasing a developmental update this Wednesday or Thursday :)

I have 500 vCash.

[badawidollah]

point market show after i use administrator login

thanks

[decipher442]

Hows the Update status coming along on this TheMayhem, think it will be updated today?

[ZuFett]

i have a style-problem in postbit.

if i deactivate the add-on, the bug is away.
do you have an idea?

[decipher442]

I will be releasing a developmental update this Wednesday or Thursday :)

Hows that update coming along?

[unicorn2433]

I really like the profile music idea!!

I like the profile music idead too:)

I am so excited about the release.

I also would love to see the ability to change other users avatars. We used the plaza up intill the upgrade and we had contests that where we would change other users avatars. I would love to have this feature again:)

[gruftiradio]

Great mod, I nominated for MOTM!

But I have one Problem... I can't administrate the PointMarket. When I go to "Categories&Items", in the ACP, I get the Error that I don't have the right to access this area. But I'm admin, what else does I need?

Greetings,
Andreas

[b4ne]

awesome system thanks for the hard work.

I would like an option that members can buy either customer username (change username) for others... and or buy a Custom User Title for another user..

Dont call me crazy but I think that would be fun

[gruftiradio]

But I have one Problem... I can't administrate the PointMarket. When I go to "Categories&Items", in the ACP, I get the Error that I don't have the right to access this area. But I'm admin, what else does I need?


Can nobody help me?

[TurkYasam]

Thanks for this great hack..
After succesfull instalition and usergroup permissions set up, I wanted to check it on frond-end but I got this error..

Database error in vBulletin 4.0.2:

Invalid SQL:
SELECT *, COUNT(marketid) FROM market_transactions
GROUP BY marketid ORDER BY COUNT( marketid ) DESC LIMIT 0 , 1;

MySQL Error : Invalid use of group function
Error Number : 1111

I was also wondering how to integrate the point market system with vBActivity v1/ Pro (https://vborg.vbsupport.ru/showthread.php?t=236973&highlight=vBActivity)

Regards..

[decipher442]

Is this mod supported any more?

[TheMayhem]

Is this mod supported any more?

Yes the developer has been without internet for a week due to his roommates not paying the Internet bill ;)

[unicorn2433]

Great mod, I nominated for MOTM!

But I have one Problem... I can't administrate the PointMarket. When I go to "Categories&Items", in the ACP, I get the Error that I don't have the right to access this area. But I'm admin, what else does I need?

Greetings,
Andreas

Did you check in administrator permissions?

[gruftiradio]

Did you check in administrator permissions?

Yes, this it was, now it works all great. Thanks :)
I always looked at the Usergroup permissions, don't knewing, that there were extra Admin Permissions...

One more question (sorry that I don't read the whole thread): Is there a way, to get the user infirmed, when he gets a gift? At the moment, they don't notice that....

[unicorn2433]

I dont think there is. That is one option I am looking forward to myself:)

[bigcurt]

Any word on whether this works on 3.8? I am sort of holding out hope as a lot of people are not looking to xfer over to 4.0

[thangveojp]

After Installed Product, i can't see Point Market Control (Settings, Categories & Items, ...) in Admin Control Panel. Help me !

[gruftiradio]

So I have to code a "You got a gift!" message by myself?
The boght Items don't show up in Postbit. Do I have to activate it anywhere (where?)?

I think, I found one small bug. In the ACP in the Pointmarket Settings, is the point "Point Market Active". The Description is: "Turn off the Point Market for maintenance. The usergroup setting will not override this option."
When I chose "Yes", everything works fine. When I choose "No", the Pointmarket is disabled. So the answers work reverse?

[unicorn2433]

So I have to code a "You got a gift!" message by myself?
The boght Items don't show up in Postbit. Do I have to activate it anywhere (where?)?

I think, I found one small bug. In the ACP in the Pointmarket Settings, is the point "Point Market Active". The Description is: "Turn off the Point Market for maintenance. The usergroup setting will not override this option."
When I chose "Yes", everything works fine. When I choose "No", the Pointmarket is disabled. So the answers work reverse?


I think he said pm notify will be in the update but dont quote me on that ..lol

I dont remember if i activated it so the gifts show in postbit or not. I went and looked around and dont see an option. If I figure it out I will let you know:)

[argothiusz]

the html error bug on people with custom user title happened again after upgraded to vb4.3 =x
I tried to reupload the 2.0.1 point market system file but that doesn't seem to fix it.

[eues]

How do i go about changing the Navbar link so it says Points Market? And also moving it from the Tab navbar down to be part of the Forum navigation?

That would be awesome if I could do that!

Great add on btw, loving it. thank you

[unicorn2433]

Just so the developer knows that I am willing to donate to this mod as well:) And will do so as soon as some features are implemented:)
And will donate everytime new features are:)

[mgcom]

Thanks for this great hack..
After succesfull instalition and usergroup permissions set up, I wanted to check it on frond-end but I got this error..

Database error in vBulletin 4.0.2:

Invalid SQL:
SELECT *, COUNT(marketid) FROM market_transactions
GROUP BY marketid ORDER BY COUNT( marketid ) DESC LIMIT 0 , 1;

MySQL Error : Invalid use of group function
Error Number : 1111

I was also wondering how to integrate the point market system with vBActivity v1/ Pro (https://vborg.vbsupport.ru/showthread.php?t=236973&highlight=vBActivity)

Regards..

I am getting the same error

Invalid SQL:
SELECT *, COUNT(marketid) FROM market_transactions
GROUP BY marketid ORDER BY COUNT( marketid ) DESC LIMIT 0 , 1;

MySQL Error : Invalid use of group function
Error Number : 1111
Request Date : Wednesday, April 21st 2010 @ 10:00:31 PM
Error Date : Wednesday, April 21st 2010 @ 10:00:31 PM
Script : http://www.dyp.ie/forums/market.php
Referrer : http://www.dyp.ie/forums/market.php
IP Address :
Username :
Classname : vB_Database
MySQL Version : 4.1.22-Max-log

[hoadiem]

is there any way i can prevent people stealing from a usergroup or no like users cannot steal money from super mod or admin

[decipher442]

Yes the developer has been without internet for a week due to his roommates not paying the Internet bill ;)

You got an ETA on the new update release?

[PixelFx]

I tested this app with vbcredits II beta 3 (current in private testing for vbulletin 4.0) and seems to work good so far.

[Footman]

I've just installed this and it looks like a great mod. However I have a small initial issue...

Point Field Name:
Enter the fieldname of the point location located inside the user table.

Sorry... I have no idea what this is for.

[random1231231231]

I've just installed this and it looks like a great mod. However I have a small initial issue...

Point Field Name:
Enter the fieldname of the point location located inside the user table.

Sorry... I have no idea what this is for.It is the "point" which is considered as cash on the market. Have you installed ucash mod?

[Footman]

It is the "point" which is considered as cash on the market. Have you installed ucash mod?

Yes, I've added the uCash first, then this one. Unfortunately I still don't understand the "Point Field Name."

I'm not normally this dense, I promise.... lol

[unicorn2433]

write ucash in that spot all lower case letters
where it asks point name field

[Footman]

write ucash in that spot all lower case letters
where it asks point name field

Thanks Unicorn...

[unicorn2433]

You are very welcome

[Footman]

Now I just need to figure out how to adjust what's being 'sold' in the store and for how much. :)

[m200RED]

I tried to find the answer on this but no luck.

I am using vBookie as my points system.

What do I put in the Point Field Name

I tried "vcash" and "vbookie"

[random1231231231]

I tried to find the answer on this but no luck.

I am using vBookie as my points system.

What do I put in the Point Field Name

I tried "vcash" and "vbookie"I have not tried to install vbookie. But basically from your phpmyadmin you should check on "user" table, and check on what column vbookie is stored on "user" table.

[PjDaBadMan]

How do i make the "Market Addon Features" clickable?

The list is a list of black text. Shouldnt it be clickable?

[eues]

I would really appreciate some help with fully implementing this mod into my site.

The main problem is custom user titles mess up my Postbit Legacy once they have either a colour or glow added to them (see attachment for comparison)

Any idea how i can fix it?

[eues]

if ($post['market_username_subscript']) {
$post[username] = "<s>$post[username]</s>";
}
if ($post['market_username_color']) {
$post[username] = "<span style='color: #$post[market_username_color]'>$post[username]</span>";
}
if ($post['market_username_glow']) {
$post[username] = "<span class='glow_$post[market_username_glow]'>$post[username]</span>";
}

if ($post['market_usertitle_subscript']) {
$post[usertitle] = "<s>$post[usertitle]</s>";
}
if ($post['market_ct_color'] AND $post[customtitle] == 1) {
$post[usertitle] = "<span style='color: #$post[market_ct_color]'>$post[usertitle]</span>";
}
if ($post['market_ct_color'] AND $post[customtitle] != 1) {
$new_usertitle = "<span style='color: #$post[market_ct_color]'>$post[usertitle]</span>";
}
if ($post['market_ct_glow'] AND $post[customtitle] == 1) {
$post[usertitle] = "<span class='glow_$post[market_ct_glow]'>$post[usertitle]</span>";
}
if ($post['market_ct_glow'] AND $post[customtitle] != 1) {
$new_usertitle = "<span class='glow_$post[market_ct_glow]'>$post[usertitle]</span>";
}
if ($post['market_ct_glow'] AND $post[customtitle] != 1 AND $post[market_ct_color]) {
$new_usertitle = "<span class='glow_$post[market_ct_glow]'><span style='color: #$post[market_ct_color]'>$post[usertitle]</span></span>";
}

if ($new_usertitle != "") {
$post[usertitle] = "";
$post[username] .= "</a><br />$new_usertitle<a href='#'>";
}


if ($post['market_gifts']) {

$gift_tran= $vbulletin->db->query_read("SELECT reason, userid, affecteduser, gift_id, gift_customid from " . TABLE_PREFIX . "market_transactions where `affecteduser`='$post[userid]' AND (gift_id > 0 OR gift_customid > 0)");
while ($gift= $vbulletin->db->fetch_array($gift_tran)) {
if ($gift[gift_customid]) {
$gift[gift_id] = $gift[gift_customid];
}

$gift_info = $vbulletin->db->fetch_array($vbulletin->db->query_read("SELECT icon_small, name from " . TABLE_PREFIX . "market_gifts where `giftid`='$gift[gift_id]'"));

if ($gift[userid] != $gift[affecteduser]) {
$grab_name = $vbulletin->db->fetch_array($vbulletin->db->query_read("SELECT username from " . TABLE_PREFIX . "user where `userid`='$gift[userid]'"));
} else {
$grab_name = "";
}

$reason = ". Reason: ".stripslashes($gift[reason])."";
$templater = vB_Template::create('market_gifts_bit');
$templater->register('icon_big', $gift_info[icon_small]);
$templater->register('name', $gift_info[name]);
$templater->register('givenby', $grab_name[username]);
$templater->register('gift_reason', $reason);
$market_gifts_bit .= $templater->render();

}


$templater = vB_Template::create('postbit_marketgifts');
$templater->register('market_gifts_bit', $market_gifts_bit);
$template_hook['postbit_userinfo_right_after_posts'] .= $templater->render();

}

Im guessing that's where i would have to put my div class. I've tried a few places but its always coming up with errors.

Could anybody help me use the <div class="eti_postbit"> </div> class with the user title styles? Where do i put this?

[Vanion]

Is there a way that I can add new items? I need to have over 100 items in my Market and I am not seeing a Create New Item option anywhere.

[Blackhat]

where can steal from others ? and some Ajax into the card game would be nice

[Olgi]

I'm thinking about it although right now I'm releasing this just to get the core tested. Making new items really doesn't take that long it was the trying to relearn the changes from 3.8 to 4.0 that took me forevor. I had a custom written point store for 3.8 but never released it so I figured I'd make a new version for 4.0 and release it this time.

Is Point Market System actually compatible with vBulletin 3.8.x !?

I would really like to use this on my boards

Cheers!

[mikem164]

Hi, LOVE THIS MOD!! I have one issue though... In the Point Market menu in ACP if I click on "Statistics" I get this Db error:

Database error in vBulletin 4.0.2:

Invalid SQL:
SELECT username, FROM user order by DESC limit 0,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 'FROM user order by DESC limit 0,1' at line 1
Error Number : 1064
Request Date : Monday, May 3rd 2010 @ 04:43:46 AM
Error Date : Monday, May 3rd 2010 @ 04:43:46 AM
Script : http://therighttimeandplace.com/elite/upload/admincp/market.php?do=statistics
Referrer : http://therighttimeandplace.com/elite/upload/admincp/index.php?do=nav
IP Address : 174.54.72.228
Username : Highrise
Classname : vB_Database
MySQL Version : 4.1.22-standard

I re upped all the files and xml, but same issue. Thanks and keep up the good work!!

[mikem164]

Database error in vBulletin 4.0.2:

Invalid SQL:
SELECT *, COUNT(marketid) FROM market_transactions
GROUP BY marketid ORDER BY COUNT( marketid ) DESC LIMIT 0 , 1;

MySQL Error : Invalid use of group function
Error Number : 1111
Request Date : Monday, May 3rd 2010 @ 01:46:04 PM
Error Date : Monday, May 3rd 2010 @ 01:46:06 PM
Script : http://trtap/elite/upload/market.php
Referrer : http://trtap/elite/upload/forum.php
IP Address : 174.54.72.228
Username : Highrise
Classname : vB_Database
MySQL Version : 4.1.22-standard

If I click on Market in the Navbar, I get this sql error as well. I re upped all files to site to make sure nothing got corrupt on the way up, and re imported the xml. Same error. I would really, really like to get this working bro. THANKS and keep up the good work!

[TheMayhem]

MikeM, I believe your suffering from a similar issue to what other people were before I released 2.0.1. I can't fix it right now because I've been away for a few weeks doing finals and a lot of traveling around the country. I'll be home this weekend to start my summer vacation with nothing to do except for a bit of work. I will definately look into it and come up with a fix for you.