vb.org Archive - Major Additions - Point Market System 3.1x

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)

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

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

Any ideas?

Sorry if I'm not describing myself well enough!

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

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

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

Quote:

Originally Posted by Centrix (Post 2073750)

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

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

Me agian

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

And me again, feeling slightly stupid.

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

Please help revert this!

Posting this for the developer.

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

Code:

Database error in vBulletin 4.0.4:



Invalid SQL:

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



MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' market_purchases=market_purchases+1, customtitle='2', usertitle ='MyNewTitle' where u' at line 1

Error Number  : 1064

Request Date  : Sunday, July 25th 2010 @ 06:12:38 PM

Error Date    : Sunday, July 25th 2010 @ 06:12:38 PM

Script        : http://76.121.10.37/forum/market.php?do=purchase

Referrer      : http://76.121.10.37/forum/market.php?do=item&id=2

IP Address    : 76.121.10.37

Username      : --------

Classname     : vB_Database

MySQL Version : 5.1.47-community

Check file 'market.php'
Change section:

Code:

        // User Edits Own User Title

        if ($itembuy[marketid] != 6) {

            if (!$method != 4) {

To:

Code:

        // User Edits Own User Title

        if ($itembuy[marketid] != 6) {

            if ($method != 4) {

Problem is resolved.

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

Quote:

Originally Posted by bluegoblin7 (Post 2074405)

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

Quote:

Originally Posted by Centrix (Post 2074407)

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

Quote:

Originally Posted by Magz (Post 2074413)

Me agian

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

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

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

Quote:

Originally Posted by bluegoblin7 (Post 2074467)

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

Quote:

Originally Posted by AtomicAcidbath (Post 2074501)

Posting this for the developer.

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

Code:

Database error in vBulletin 4.0.4:



Invalid SQL:

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



MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' market_purchases=market_purchases+1, customtitle='2', usertitle ='MyNewTitle' where u' at line 1

Error Number  : 1064

Request Date  : Sunday, July 25th 2010 @ 06:12:38 PM

Error Date    : Sunday, July 25th 2010 @ 06:12:38 PM

Script        : http://76.121.10.37/forum/market.php?do=purchase

Referrer      : http://76.121.10.37/forum/market.php?do=item&id=2

IP Address    : 76.121.10.37

Username      : --------

Classname     : vB_Database

MySQL Version : 5.1.47-community

Check file 'market.php'
Change section:

Code:

        // User Edits Own User Title

        if ($itembuy[marketid] != 6) {

            if (!$method != 4) {

To:

Code:

        // User Edits Own User Title

        if ($itembuy[marketid] != 6) {

            if ($method != 4) {

Problem is resolved.

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

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

Thanks for getting back to me Mayhem!

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

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

Cheers for being proactive!

Jack

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

Thank you for the update TheMayhem,

Much appreciated

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

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (6)bbcode_code_printable (6)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (5)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)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
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02793 seconds Memory Usage 1,772KB 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 (6)bbcode_code_printable (6)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (5)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)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
Messages: