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)

Kotsu 07-11-2011 07:08 PM

How do you Delete Store Items/Store Categories?

stamos2003 07-12-2011 09:42 AM

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

runescapian 07-17-2011 02:48 PM

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

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

craigbett 07-17-2011 09:21 PM

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

TimesOut 07-18-2011 06:16 PM

Quote:

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

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

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

I use 4.1.4

I hope the developer will reply to us.

craigbett 07-18-2011 09:36 PM

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

Successfulsteps 07-19-2011 12:21 AM

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

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

stamos2003 07-19-2011 11:33 AM

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

Code:

Database error in vBulletin 4.1.4:

Invalid SQL:

        SELECT IF(userid > 0, 1, 0) as isuser, COUNT(session.userid) as online_users
        , user.market_username_color,
user.market_username_glow, market_username_subscript
        FROM session as session
       
        WHERE session.lastactivity > 1311076856
       
       
       
        GROUP BY isuser;

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


DS MrSinister 07-19-2011 11:57 AM

*Stamos2003

here is a temporary fix.

https://vborg.vbsupport.ru/showpost....postcount=1905

Kotsu 07-19-2011 05:33 PM

Quote:

Originally Posted by Kotsu (Post 2219414)
How do you Delete Store Items/Store Categories?

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

DS MrSinister 07-19-2011 07:39 PM

Quote:

Originally Posted by Kotsu (Post 2222500)
Can anyone tell me how to do this? Not sure if I'm missing something.

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

Successfulsteps 07-19-2011 10:43 PM

Quote:

Originally Posted by stamos2003 (Post 2222392)
error in vbulletin 4.1.4 when you want to go to the "Who is Online" page:

Code:

Database error in vBulletin 4.1.4:

Invalid SQL:

        SELECT IF(userid > 0, 1, 0) as isuser, COUNT(session.userid) as online_users
        , user.market_username_color,
user.market_username_glow, market_username_subscript
        FROM session as session
       
        WHERE session.lastactivity > 1311076856
       
       
       
        GROUP BY isuser;

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


Quote:

Originally Posted by DS MrSinister (Post 2222398)
*Stamos2003

here is a temporary fix.

https://vborg.vbsupport.ru/showpost....postcount=1905

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

TimesOut 07-23-2011 05:21 AM

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

Reycer 07-23-2011 07:20 PM

Quote:

Originally Posted by Successfulsteps (Post 2222627)
Wow, thanks for asking and thanks for the answer! I had that error too and had no idea it was that particular plug-in causing it. Sure saved me some time you asking!

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

tdkmatt 07-24-2011 10:31 AM

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

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

JayCat 07-25-2011 09:23 AM

This mod uses way too many mysql queries.

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

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

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

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

8thos 07-26-2011 04:38 AM

Quote:

Originally Posted by TheMayhem (Post 2197871)
Official 3.1.0 Gold Post

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

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

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

~Brad

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

CODEHX 07-26-2011 06:30 PM

Database error in vBulletin 4.1.4:

Invalid SQL:

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

WHERE session.lastactivity > 1311707591



GROUP BY isuser;

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

Successfulsteps 07-26-2011 06:48 PM

Quote:

Originally Posted by DS MrSinister (Post 2222398)
*Stamos2003

here is a temporary fix.

https://vborg.vbsupport.ru/showpost....postcount=1905

Quote:

Originally Posted by CODEHX (Post 2225296)
Database error in vBulletin 4.1.4:

Invalid SQL:

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

WHERE session.lastactivity > 1311707591



GROUP BY isuser;

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

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

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

Reycer 07-27-2011 12:02 AM

Quote:

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

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

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

Vikingant 07-29-2011 06:37 AM

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

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

Any ideas?

Ant

txsbmw 07-29-2011 11:23 AM

Quote:

Originally Posted by DigitalDark (Post 2177073)
You should force the permissions Again:

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

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

I hope you can fix it.

See you.

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

DonosOdD 07-31-2011 03:33 PM

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

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

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

Thanks in advance.

appleballs 08-02-2011 06:05 PM

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

Quote:

Database error in vBulletin 4.1.4:

Invalid SQL:

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

WHERE session.lastactivity > 1312306442



GROUP BY isuser;

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

appleballs 08-03-2011 12:07 PM

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

Mangia 08-18-2011 10:34 PM

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

Is there another step I'm missing?

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

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

CJFactor 08-19-2011 03:30 PM

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

Scyther 08-25-2011 06:12 AM

Nice one..will install once i upgrade

michal72 08-26-2011 07:25 PM

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

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

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

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

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

Any ideas?

Vbuletin 4.1.5 sp1

Thank you in advance for some advice

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


This code can't be eval
Code:

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


Fixed:
and the source of my problem is copyright sign in file product-pointmarket.xml:
Code:

/***********************************************
* Continuous Reel Slideshow- ? Dynamic Drive (www.dynamicdrive.com)
***********************************************/


dmandem 08-27-2011 01:44 AM

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

Anyone know what's causing this?

Mopar1973Man 08-29-2011 05:28 PM

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

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

LGKeiz 08-30-2011 03:23 PM

Nevermind

LGKeiz 08-30-2011 10:18 PM

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

when going to online.php

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

hoadiem 08-31-2011 12:21 AM

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

fly 09-02-2011 08:18 PM

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

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

Littlerocket 09-03-2011 07:12 PM

Great mod.

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

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

Thanks.

Littlerocket 09-03-2011 10:38 PM

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

hoadiem 09-04-2011 02:06 AM

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

Littlerocket 09-04-2011 02:21 AM

Quote:

Note: The maximum size of your custom image is -1 by -1 pixels or -1 Bytes (whichever is smaller).
Can't seem to change this setting. Any ideas?

Thanks.

Laurvick 09-04-2011 05:15 PM

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

Invalid SQL:

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

WHERE session.lastactivity > 1314829461

GROUP BY isuser;

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


All times are GMT. The time now is 10:32 PM.

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.08465 seconds
  • Memory Usage 1,852KB
  • 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
  • (4)bbcode_code_printable
  • (14)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)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