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)

BayLee2 06-06-2011 01:11 AM

I disabled this plugin. Twice now I've installed this and it's worked fine. After a few hours the forum will show this message and everything will get skewed and nothing will work right.

Warning: preg_match() [function.preg-match]: Compilation failed: nothing to repeat at offset 5 in [path]/includes/functions.php(1226) : eval()'d code on line 32

I've tried one by one disabling all plugns and found this one to be the cause of the error. If i overwrite and reinstall the program to the root folder it fixes it but everything needs to be set again and the error shows up again after about a few hours to day or so. Any idea what causes this and how I can fix it?

Kraxell 06-06-2011 04:01 PM

Hello,

i want to create an item whitout any function but i MUST select a function -.- is it possible to change it?

LatinCrib 06-07-2011 01:56 AM

Hello

can you tell me what I need to get this working I dont see no link on the nav bar and for wat is this or wat this can do

kameraderie 06-08-2011 12:56 PM

we installed Point Market System 3.1x and we are loving it. I don't know if this is a bug or not, but we noticed, in one of the forum items, Upload Avatar, in the payment page, there appears this message:

Note: The maximum size of your custom image is -1 by -1 pixels or -1 Bytes (whichever is smaller).

in effect no one can upload an image at all and the process aborts.

What can resolve this issue? I cannot seem to find how to change the point market setting for avatar size requirements.

Thank you in advance.

rob01 06-10-2011 01:29 AM

point market and vb4.1.4 = creates a sql conflict

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

any idea?

thanks
robert

augrunt 06-10-2011 05:36 AM

Well, no one's responded to my issue as of yet... why are the crons failing? why are they not using the vb object to utilise the correct SQL information?

Also, is 4.1.4 compatible?

Suggestion
- Change your SQL queries to use the $vb->sql function instead.
- In the Bank, you aren't told what the maximum possible withdrawl is. Pretty hard when the interest is 1.95% to withdraw and you want to take out 15,000. I doubt many users will want to calculate it before attempting to do that. I can write up the code if you are willing to implement? :) -- Simple math function in PHP.

*edit*
I've just withdrawn 15,000 points and my experience level has not updated. It's completely missing.

Cheers,
augrunt

rob01 06-10-2011 11:18 PM

Known bugs:
For Vbulletin 4.1.4
(1) User online: sql bug error (#Error-link)

- all versions
- Withdraw & experience update (Error-link)
- preg_match() (Error-Link)

Suggestions:
- all versions
(1) maximum possible withdraw (link)

just writing some bugs,updates, in a more efficient way, i will try to update it asap.

btw, I'm not part of the mod dev team

augrunt 06-11-2011 12:28 AM

I think I've realised the problem here with my points not updating after withdrawl.

It is currently integrated with vBExperience. When I withdrew 15,000 points. vBExperience did it's count a few minutes later and subtracted the amount of points I withdrew (14,733~) for 'misc'.

I thought these were perfectly integrated? What gives? This would affect all versions I believe. I am still running off 4.1.3.

Cheers,
Steve

P.S. Good mod, members love it!

Paul M 06-12-2011 10:32 AM

FYI, an exploit was recently reported in this mod, however, upon checking, it was determined it does not exist in the released (gold) version. It was part of an old Alpha version. Please make sure you are running the current version.

KHALIK 06-12-2011 06:41 PM

I am using VB 4.1.4 version.
I upgraded to the GOLD paid version of 3.1.1

I get MySQL error messages (when clicked on Who's Online) while there are members online using fancy coloured usernames brought from the market.

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 > 1307906505
       
       
       
        GROUP BY isuser;

MySQL Error  : Unknown column 'user.market_username_color' in 'field list'
Error Number  : 1054
Request Date  : Sunday, June 12th 2011 @ 08:36:45 PM
Error Date    : Sunday, June 12th 2011 @ 08:36:45 PM
Script        : http://www.fragmasters.co.uk/online.php
Referrer      : http://www.fragmasters.co.uk/forum.php


bmc 06-13-2011 07:03 PM

What is the closest modification (feature-wise, e.g. with the ability to purchase forum and username permissions) to this one that is compatible with vB 3.7.4?

rob01 06-13-2011 10:02 PM

any update to the vb4.1.4 errors? :S


and for vb3.7, i doubt you will be able to find one, there is one -> https://vborg.vbsupport.ru/showthrea...ghlight=vbshop (but is for 3.8)

haiduongbk 06-14-2011 11:47 AM

Does it work with vbb 4.1.4 ?

mmacrypt 06-15-2011 04:07 AM

Quote:

Originally Posted by haiduongbk (Post 2207552)
Does it work with vbb 4.1.4 ?

I would say no, it seems to be working but when I try to view "Who's Online", I get the SQL error. I'm sure it's an easy fix for the writer but I have to disable it for now.

ProjectD 06-15-2011 06:53 AM

Upgraded from 3.0.1 to this, and it instantly killed my forum. Every page was just blank white. No errors, no nothing. Luckily I backed up database before hand, and restoring that fixes it. Tried upgrading a second time just to make sure... and as soon as i import the .xml the forum goes blank, on every page. Running vb 4.1.1. Ah well, shoulda stuck to 3.0.1.

8thos 06-15-2011 11:05 AM

Quote:

Originally Posted by mmacrypt (Post 2207922)
I would say no, it seems to be working but when I try to view "Who's Online", I get the SQL error. I'm sure it's an easy fix for the writer but I have to disable it for now.

Yeah same thing happened to me. Disabled for now.

just.b.jealous 06-16-2011 09:19 AM

@TheMayhem

I'm having an issue on my end and hopefully you can be of some help..

Some details 1st-
I'm currently using vBulletin 4.1.3PL1..
I'm no noob, I've been using vB since 3.8.3- so I'm used to my admincp, templates, plugins and what-nots.
I'm currently using vBExperience 4 Gold (The most current version at this time, I just installed it for this Mod.)
This is a new installation of Points Market, I've never even had the older versions installed. So I'm doing a fresh install of version 3.1.0.

So here's the problem/s I'm having..

In your README/installation file you state-

Quote:

************************************************** *************************
Installation
************************************************** *************************

1. Upload all files from the upload folder to your forums directory.

2. Go to AdminCP -> Plugins & Products -> Manage Products ->
Add/Import Product and import: product-pointmarket.xml

3. The following folders must be Chmodded to 777 for uploading permissions:
/customavatars/
/images/smilies/
/images/pointmarket/store/

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

5. Add Administrator permissions on the Settings & Staff Permission.

6. Edit all usergroup permissions. By default the Point Market system is
turned off for all usergroups. Please make sure all secondary usergroups
have been edited as well.

Steps 1-4, no problems there.

Step 5, I don't have "Settings & Staff Permission" located anywhere in my admincp.

It's not in "Administrator Permissions", it's not in "Usergroup manager", it's not in the regular "vbulletin settings/options", it's not on the "side pane" of the cp itself. Yes I'm a super-admin. User no 1. Also set that way in config.php.

Of course I can't complete step 6 until step 5 is completed. All market pages result in no permissions are set- you are not allowed here error (since step 5 was never finished).

Here's a picture someone else provided- showing the fields I'm missing completely. I'm actually missing both sections from the picture. I'm missing the whole "Point Market" section, and the "Point Market Bank" section. They're nowhere to be found.

https://vborg.vbsupport.ru/attachmen...6&d=1308227306


I've tried-

Deleting the files from the server, re-downloading them again... re-upload them and then re-import it. No success. Rebuilding my bitfields, no success. Installing with all other mods/products/plugins disabled except vBExperience (to insure no conflicts of other mods), no success.

I need some help or I've found a bug,.. any ideas/help is appreciated from those who reply back. Thanks peoples.

RedTrinity 06-16-2011 11:28 AM

1 Attachment(s)
Quote:

Originally Posted by just.b.jealous (Post 2208408)
Step 5, I don't have "Settings & Staff Permission" located anywhere in my admincp.

It's not in "Administrator Permissions", it's not in "Usergroup manager", it's not in the regular "vbulletin settings/options", it's not on the "side pane" of the cp itself. Yes I'm a super-admin. User no 1. Also set that way in config.php.

Of course I can't complete step 6 until step 5 is completed. All market pages result in no permissions are set- you are not allowed here error (since step 5 was never finished).

You don't have this (see attached screenshot)? That's where it should be..... :)

Tinnie 06-16-2011 11:38 AM

how do i fix this

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 > 1308226966

GROUP BY isuser;

MySQL Error : Unknown column 'user.market_username_color' in 'field list'
Error Number : 1054
Request Date : Thursday, June 16th 2011 @ 02:37:46 PM
Error Date : Thursday, June 16th 2011 @ 02:37:47 PM
Script : online.php
Referrer : forum.php
IP Address :
Username :
Classname :
MySQL Version : 5.1.43

just.b.jealous 06-16-2011 06:43 PM

Quote:

Originally Posted by RedTrinity (Post 2208447)
You don't have this (see attached screenshot)? That's where it should be..... :)

Nope, I have neither of those 2 sections showing in the picture you provided.

I don't have the "Point Market" section, or the "Point Market Bank" section. I've even rebuilt bitfields in order to show any new changes and it still doesn't update with the sections I need. I do know that it's actually rebuilding the bits (from testing) and it's rebuilding the sidepane in admincp, but still no sections needed to update the permissions for this product.

EDIT: I have figured it all out. There was a missing file that somehow got broken in the download.

mmacrypt 06-16-2011 11:32 PM

Quote:

Originally Posted by Tinnie (Post 2208452)
how do i fix this

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 > 1308226966

GROUP BY isuser;

MySQL Error : Unknown column 'user.market_username_color' in 'field list'
Error Number : 1054
Request Date : Thursday, June 16th 2011 @ 02:37:46 PM
Error Date : Thursday, June 16th 2011 @ 02:37:47 PM
Script : online.php
Referrer : forum.php
IP Address :
Username :
Classname :
MySQL Version : 5.1.43

by waiting until the mod author fixes it, a few of us are having the same issues. This mod isn't working with 4.1.4.

just.b.jealous 06-18-2011 12:01 AM

Quote:

Originally Posted by mmacrypt (Post 2208753)
by waiting until the mod author fixes it, a few of us are having the same issues. This mod isn't working with 4.1.4.

Same goes for vB version 4.1.3,.. I guess were waiting for the author to do another bug update.

Smak Runner 2K 06-19-2011 06:52 PM

I have two issues. First one is the 'Who's Online?' error with 4.1.4...but the other is how do I get the achievement to work with vbExperience? It doesn't seem to adding to users accounts when purchased...

RedTrinity 06-22-2011 04:56 AM

Ok, so I'm a little confused. If I want to offer features like changing user title and username etc. through the points market, do I need to disable the options first in the UserCP? Otherwise they are just going to do it for free via their UserCPs, instead of needing/spending points to do it through the market?

Will these options still work correctly through the market if the UserCP options are disabled via the ACP?

rob01 06-22-2011 05:33 AM

Problem: User Online sql
- Temporal solution: (for version vb4.1.4)
1) go to your plugins
2) search for Point Market: Users Online Colors Query
3) disable it

and that all!

is just a temporal fix.. I will try to post a solution asap

Webrunner 06-25-2011 07:53 AM

Mayhem, did you already find a solution for the colors in the social group discussions?

just.b.jealous 06-27-2011 12:27 AM

Is there a way for the Username Color to show on all pages? From what I am seeing it only shows in the posts, correct?

SteveBoogie 06-27-2011 12:03 PM

Thank you for clearing up the converter's "please complete all required fields" problem way earlier in the thread. This was killing me lol... people want to buy vCash at my board!

RedTrinity 06-28-2011 10:45 PM

The point field for VBCreditsII is still "credits", right?

I have it installed and running correctly, but for some reason I'm getting "The point field has been entered but no data exists in this field name." in the Market whenever I set my points field as "credits".

Help please :confused:

DigitalDark 06-30-2011 08:17 AM

Quote:

Originally Posted by Webrunner (Post 2212488)
Mayhem, did you already find a solution for the colors in the social group discussions?

I'm Having this problem. I think is the same that yours. Look at this:

http://www.emudigital.net/foro/group...ficial%5D.html

First discussion, the HTML code "<span glow...>" is appearing in last awnser.

There is any fix for that? Thanks.

mmacrypt 07-01-2011 09:14 PM

I'm surprised no fix for this yet. Mayhem must be really busy right now. This mod seems so close to being finished.

Hall of Famer 07-07-2011 01:37 PM

According to VB staff team, the point market system is not compatible with VB 4.1.4. Any way to fix this?

https://www.vbulletin.com/forum/show...3-umm-this-bug...

ivanov73 07-09-2011 12:22 AM

Hello i install plugin all work corect only after i buy product from mi forum store i get this ERROR: DIV with ID "storeslideshow" not found on page product have uploaded all images and alslo in mi purchases store items i see date that F j, Y, g:i a any help Thanks Sory for mi english

Reycer 07-09-2011 02:47 AM

Quote:

Originally Posted by Hall of Famer (Post 2217778)
According to VB staff team, the point market system is not compatible with VB 4.1.4. Any way to fix this?

https://www.vbulletin.com/forum/show...3-umm-this-bug...

huh?? Just do the fix mentioned above and it works just fine. I have it shut down to the public right now, but from what I can tell everything seems to be running smooth as ever.

Where exactly in that post that you linked to does it say that "The point market system is not compatible with VB4.1.4" ???? Just do the fix and it IS compatible.

Hall of Famer 07-09-2011 04:41 PM

What fix are you talking about?

mmacrypt 07-09-2011 05:34 PM

Yes, I would also like to see this "fix", I'm surprised no feedback from the author yet. Hope all is ok, my members were really starting to dig the bank system.

jojojijijojo1 07-09-2011 06:23 PM

Anyone else got his forum hacked by sql injection after installing this? my forum got hacked right away after installing this with sql injection.

Reycer 07-09-2011 09:06 PM

Quote:

Originally Posted by Hall of Famer (Post 2218559)
What fix are you talking about?

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

It works fine, I am using it.

mmacrypt 07-10-2011 03:50 AM

Quote:

Originally Posted by mdelcour (Post 2218658)

Thank you, I'll try that in the morning.

mmacrypt 07-10-2011 04:39 PM

That did seem to fix mine also, thanks again mdelcour.


All times are GMT. The time now is 11:10 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.04551 seconds
  • Memory Usage 1,843KB
  • 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
  • (1)bbcode_code_printable
  • (11)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