vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Major Additions - Point Market System 3.1x (https://vborg.vbsupport.ru/showthread.php?t=232676)

shempsall2009 05-14-2010 01:04 PM

Great Mod :D

Where it says :

Points: 149.30
Purchases: 1
Refunds: 0
Discount: 0%

How can I change "Points" to "?'s"

Installed

Footman 05-14-2010 01:16 PM

Quote:

Originally Posted by shempsall2009 (Post 2036915)
Great Mod :D

Where it says :

Points: 149.30
Purchases: 1
Refunds: 0
Discount: 0%

How can I change "Points" to "?'s"

Installed

ACP > Point Market > Settings > Points Name

Should be able to change it right there.

shempsall2009 05-14-2010 06:14 PM

Quote:

Originally Posted by Footman (Post 2036923)
ACP > Point Market > Settings > Points Name

Should be able to change it right there.

Cheers..

Katoona 05-14-2010 06:47 PM

I am sorry if that has already been mentioned, but I would like to see an option to buy a different user group that expires after X days. Would this be possible?

TheMayhem 05-14-2010 07:11 PM

Just giving you guys the heads up I was able to make some serious progress on the final remaining bugs. Therefore, 2.1.0 will be coming out this weekend for sure, I promise.

Bigj85 05-15-2010 05:03 PM

getting this error after I set permissions for my group and try to visit the market

Database error in vBulletin 4.0.3:

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

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

any ideas what I'm doing wrong?
thx

EDIT: nevermind I just saw some previous posts about it not working on mysql version

FlameGun 05-15-2010 05:24 PM

When can we expect the next release?

TheMayhem 05-15-2010 10:40 PM

Tomorrow afternoon, I'm down to 1 bug. BigJ as far as I know the bug you are experiencing from has been fixed from what one of my testers told me.

Bigj85 05-16-2010 12:25 AM

I just uninstalled,reuploaded all files and then reimported the product and the same error,I've tried with ucash and kbank just to see if it would make a difference but nothing

Quote:

Database error in vBulletin 4.0.3:

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

MySQL Error : Invalid use of group function
Error Number : 1111
Request Date : Sunday, May 16th 2010 @ 01:21:40 AM
Error Date : Sunday, May 16th 2010 @ 01:21:40 AM
Script : xxxxxxxxxxxxxxxxxxxxxx/forum/market.php
Referrer : xxxxxxxxxxxxxxxxxxx/forum/forum.php
IP Address : xxxxxxxxxx
Username : xxxxxxxxxx
Classname : vB_Database
MySQL Version : 4.1.20
gonna just disable it for now but if anyone had this problem and got it fixed plz help,I'll try tomorrows version also and hope it helps

EscapadesBC 05-16-2010 12:27 AM

I just installed (and linked to ucash). I don't have a navbar link though, how do I set one up?

Thanks for writing this, it looks like a great mod.

EscapadesBC 05-16-2010 12:32 AM

Alright, I got the link working but I can't figure out how to modify the permissions. Even I can't access the market.

Juggernaut 05-16-2010 01:54 AM

Quote:

Originally Posted by worldwidereefer (Post 2006568)
how do you know who won the lottery ticket ?

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

Is there a way ?

I haven't been able to figure this out myself :)

TheMayhem 05-16-2010 02:40 PM

For whatever reason I never scripted it for the 2x series soooo this morning I added that feature. :)

TheMayhem 05-16-2010 07:39 PM

2.1.0 is officially released to you guys for using. This is the first time I haven't introduced any new market items; however, there are still many new features (Mostly Administrative). In addition, there are about a dozen bugs that are moderate to severe that have been addressed. I strongly encourage everyone to upgrade to a much more stable Point Market.

Crystal Shards 05-16-2010 07:51 PM

Everytime I try to edit something, I get this:

You currently do not have permissions to access this page.

In order to gain access to this page, please have a Super Administrator setup access for your account in the Settings & Staff Permissions page within the Administrative Control Panel.

TheMayhem 05-16-2010 07:58 PM

You need to have a Super Administrator (defined in config.php in the includes folder) go to the Settings & Staff Permissions page in the Admin CP. They need to add an admin to the market permissions and setup what admin has what access. :) As you can tell after you visit that page, you have far more control over what Admins can and cannot do in comparison to before.

Bigj85 05-16-2010 09:09 PM

deleted all the old files,uninstalled and installed 2.1.0

everything went fine with setting it up,doing permissions etc.
but then when I try to go to the market I get this error Database error in vBulletin 4.0.3:

Quote:

Invalid SQL:
SELECT * FROM market_transactions AS mt CROSS JOIN ( SELECT marketid, COUNT(*) AS cnt FROM market_transactions GROUP BY marketid ORDER BY cnt DESC LIMIT 1) AS sq USING (marketid);

MySQL Error : Table 'inv4.market_transactions' doesn't exist
Error Number : 1146
Request Date : Sunday, May 16th 2010 @ 10:04:07 PM
Error Date : Sunday, May 16th 2010 @ 10:04:07 PM
Script : xxxxxxxxxxxxxxx/forum/market.php
Referrer : xxxxxxxxxxxxxxxxx/forum/forum.php
IP Address : xxxxxxxxxxxxxxx
Username : MKZ23
Classname : vB_Database
MySQL Version : 4.1.20

my table prefix is VB,inv4 is the db name,I'm not sure if its using the db name as a prefix or just not using the vb prefix but the table

the table "vbmarket_transactions" exists,any ideas of how I can quick fix this by making it look for the correct table.

btw the product looks great,I havent used it yet but I'm determined this is what I'll be using for my forum,thx


P.S. I took a look at the new main market.php file and noticed that "TABLE_PREFIX ." is missing where it used to be regarding fetching from the market_transactions table but I dont wanna go trying to fix something I know very little about

Juggernaut 05-16-2010 09:14 PM

Just upgraded to 2.1 and everything seems to be going fine, thank you for your work :D

TheMayhem 05-16-2010 09:21 PM

Quote:

Originally Posted by Bigj85 (Post 2038140)
deleted all the old files,uninstalled and installed 2.1.0

everything went fine with setting it up,doing permissions etc.
but then when I try to go to the market I get this error Database error in vBulletin 4.0.3:




my table prefix is VB,inv4 is the db name,I'm not sure if its using the db name as a prefix or just not using the vb prefix but the table

the table "vbmarket_transactions" exists,any ideas of how I can quick fix this by making it look for the correct table.

btw the product looks great,I havent used it yet but I'm determined this is what I'll be using for my forum,thx


P.S. I took a look at the new main market.php file and noticed that "TABLE_PREFIX ." is missing where it used to be regarding fetching from the market_transactions table but I dont wanna go trying to fix something I know very little about

Redownload the zip I have attached. Upload and overwrite all files and it should fix it. It was caused because your database is using a "vb" in front of all tables and I forgot to add the table prefix functionality to the fixed queries.

Bigj85 05-16-2010 09:26 PM

you rock man,already playing with the items and it looks great, thx again :)

Nominated!

Crystal Shards 05-16-2010 09:44 PM

Everything works great now. This is EXACTLY what my members have been wanting for a while. Thank you.

unicorn2433 05-16-2010 10:39 PM

Thank you for the update:)

will the system now send notofications by pm when the user receives a gift or wins lotto etc

TheMayhem 05-16-2010 10:46 PM

It sends on gift and donations. The only thing different about lotto is a fixed a nasty glitch that didn't check if people had enough points to buy an item and also the winners are now stored in the admin cp.

War.Frog 05-16-2010 10:49 PM

I really REALLY wish vbCredits was completed now. I'm dying to get it, and this mod, installed!

TheMayhem 05-16-2010 11:01 PM

You can always install uCash and then just switch the currency when vbcredits comes out. That's what a lot of people are most likely going to do and I plan on making this product support multiple currencies very soon.

unicorn2433 05-16-2010 11:34 PM

Thank you for such a quick reply.

Another question. The test categories? Can I mke it so people can change others avatars in there?

TheMayhem 05-17-2010 12:24 AM

If you want to script it as a custom item then go for it; however, I plan on adding avatar functionality in up and coming releases so you might just want to wait on that. 2.1.0's release was mostly about fixing some serious bugs and producing a far more stable product.

random1231231231 05-17-2010 12:33 AM

Thanks for the new release. Downloaded.. However if i overwrite the old plugin, do old data (purchased item etc) will be lost?

unicorn2433 05-17-2010 01:33 AM

Quote:

Originally Posted by TheMayhem (Post 2038239)
If you want to script it as a custom item then go for it; however, I plan on adding avatar functionality in up and coming releases so you might just want to wait on that. 2.1.0's release was mostly about fixing some serious bugs and producing a far more stable product.

I will def wait for you.

Tested on my forum and users are not recieving a pm when gift is purchased for them. Nor when a donation is .

TheMayhem 05-17-2010 01:47 AM

Quote:

Originally Posted by unicorn2433 (Post 2038272)
I will def wait for you.

Tested on my forum and users are not recieving a pm when gift is purchased for them. Nor when a donation is .

Odd, they are working on mine... I'll await to see how it works with other users before I try and pinpoint why it is or isn't working.

Quote:

Originally Posted by semprot (Post 2038246)
Thanks for the new release. Downloaded.. However if i overwrite the old plugin, do old data (purchased item etc) will be lost?

No they won't be lost. Just overwrite all files and import the product (make sure you select yes for overwrite).

Katoona 05-17-2010 02:29 AM

Is there any way to have users buy access to a usergroup with a time-limit?

After X days the user is shifted back to his old usergroup.

TheMayhem 05-17-2010 03:16 AM

Quote:

Originally Posted by Katoona (Post 2038291)
Is there any way to have users buy access to a usergroup with a time-limit?

After X days the user is shifted back to his old usergroup.

Ask me after the next version as I'm finally implementing timeouts for certain actions.

abqtj 05-17-2010 03:31 AM

I'm getting the:
you do not have permission to access this page. This could be due to one of several reasons
message whenever I click on the Market link

I just installed this, have it active, and I can't seem to get to it on my site. Is there a setting I'm missing?

Thanks

m200RED 05-17-2010 04:32 AM

Is there a way to edit individual user's gifts? I want to either manually add/remove gifts from individual users with Admin CP.

Crystal Shards 05-17-2010 06:09 AM

Quote:

Originally Posted by abqtj (Post 2038309)
I'm getting the:
you do not have permission to access this page. This could be due to one of several reasons
message whenever I click on the Market link

I just installed this, have it active, and I can't seem to get to it on my site. Is there a setting I'm missing?

Thanks

Have you set permissions via the usergroups? You also need to make sure you have something set for the Point Field Name under Global Settings.

Hope that helps!

unicorn2433 05-17-2010 11:04 AM

Quote:

Originally Posted by unicorn2433 (Post 2038272)
I will def wait for you.

Tested on my forum and users are not recieving a pm when gift is purchased for them. Nor when a donation is .


Is anyone else having this problem? Maybe I have it set up wrong in the gift area?
I left it so it says the sender is Point Market System with my user id 1. Would that be why?

abqtj 05-17-2010 12:59 PM

Quote:

Originally Posted by Crystal Shards (Post 2038350)
Have you set permissions via the usergroups? You also need to make sure you have something set for the Point Field Name under Global Settings.

Hope that helps!


Thanks for help.

I've got uCash in the Point Field Name (and installed). But I don't see anything to change/allow in the usergroups.

I've got something below the "Blog Comment Permissions" in the User Group Manager for each user group, but it's not titled and there's nothing there except the "yes" and "no" buttons. Both are marked "no". If I select either to "yes", I get a database error.

Is that the spot?

TheMayhem 05-17-2010 01:23 PM

Quote:

Originally Posted by abqtj (Post 2038496)
Thanks for help.

I've got uCash in the Point Field Name (and installed). But I don't see anything to change/allow in the usergroups.

I've got something below the "Blog Comment Permissions" in the User Group Manager for each user group, but it's not titled and there's nothing there except the "yes" and "no" buttons. Both are marked "no". If I select either to "yes", I get a database error.

Is that the spot?

If you are using uCash type in: ucash (case sensitive) as a point field unless you have renamed it to something else and it will work. And no those aren't related to the Point Market.

abqtj 05-17-2010 01:33 PM

Quote:

Originally Posted by TheMayhem (Post 2038514)
If you are using uCash type in: ucash (case sensitive) as a point field unless you have renamed it to something else and it will work. And no those aren't related to the Point Market.

I mis-typed, I do have it as ucash, all lower case.

Where would the permissions need to be set?

TheMayhem 05-17-2010 01:55 PM

Permissions are to be set in the Usergroup Manager by editing all usergroups and enabling/disabling permissions as needed.

In addition, you will need to setup Administrative permissions for your Administrators (including yourself) in the Admin CP under Settings / CP Permissions within the Point Market.


All times are GMT. The time now is 04:26 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03733 seconds
  • Memory Usage 1,836KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (15)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete