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)

vidan 03-11-2011 11:16 AM

what is the main purpose of coupon?
thanks

DevOne5555 03-11-2011 11:31 AM

Quote:

Database error in vBulletin 4.1.2:

Invalid SQL:

UPDATE market_items
SET `order` =
WHERE mid = '5';

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 'WHERE mid = '5'' at line 3
Error Number : 1064
Any ideas?

Also -

Quote:

Parse error: syntax error, unexpected $end in /home/koolaid/public_html/forums/includes/cron/pointmarket_expire.php on line 282

TheMayhem 03-11-2011 03:39 PM

The pointmarket_expire bug I already found and fixed. It was just a missing bracket I did by accident before releasing Alpha 4.

I'll look into the other reported little sql bugs, they shouldn't be that difficult to correct.

The concept of coupons is for allowing additional discounts for users for certain market items that are based off a set criteria that the administrator decides. So for example, if a user was a member of a certain primary usergroup they might get an additional discount of 25% off an item.

Beta 1 comes out this Sunday as I've mentioned several times. In it I'll have all market items fully functional. It doesn't look like I am going to have time to script for the Market Store the ability to purchase items and download them. I also won't get to the coupon listings in this release. Those will come out in a later beta phase.

kesandal 03-11-2011 04:05 PM

Quote:

Originally Posted by TheMayhem (Post 2172282)
Beta 1 comes out this Sunday as I've mentioned several times.

@TheMayhem: Are my 2 reported bugs fixed too? :)

fly 03-11-2011 06:19 PM

Okay, is there something that I can run to clear out all these thread bans? None of them are expiring.

TheMayhem 03-11-2011 07:51 PM

Quote:

Originally Posted by fly (Post 2172330)
Okay, is there something that I can run to clear out all these thread bans? None of them are expiring.

Set the expiration to a day and upgrade to beta 1 sunday night and then run the expirations afterwards. It should clear them.

fly 03-11-2011 07:52 PM

Quote:

Originally Posted by TheMayhem (Post 2172355)
Set the expiration to a day and upgrade to beta 1 sunday night and then run the expirations afterwards. It should clear them.

Man, I hope you make your deadline again! :D

fly 03-11-2011 10:06 PM

And can someone explain the gift cost to me? The price next to the gift says 500.00, but the total up top says 1000.00 - with no real explanation of why the prices are different.

smirkley 03-12-2011 02:49 AM

Running alpha 4


Bug1

When purchasing a gift market item made by another member : this shows up in header,...
Quote:

Warning: include_once([path]/pointmarket/gift_purchase.php) [function.include-once]: failed to open stream: No such file or directory in [path]/market.php on line 436

Warning: include_once() [function.include]: Failed opening '[path]/pointmarket/gift_purchase.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in [path]/market.php on line 436

Bug2
Tried to clear user title color, set to one day expire, ran all maintenance, color will not expire. Will check again tomorrow and report back to see if cron reset it.

Bug3

Using the username color/glow/strikethru items purchased,... they work but they also insert html code into the html alt for the avatar image and a couple of other places.





And btw, thanks for fixing the maintenance link on thread purchases items. That was bugging the crap out of me.

smirkley 03-13-2011 04:33 AM

Report back on Bug2, color still has not expired. Running other tests.

fly 03-13-2011 12:04 PM

Quote:

Originally Posted by smirkley (Post 2172756)
Report back on Bug2, color still has not expired. Running other tests.

Expire was broken.

TheMayhem 03-13-2011 08:41 PM

Quote:

Originally Posted by kesandal (Post 2171850)
Hello,

think I found a bug:

Wenn you open a item which has shipping set to mail you have to fill out the "store shipping information".
  1. forgett to fill out for instance the "full name" and click on "Confirm Purchase: Credits".
    The page reloads, no error is shown and clicking again on the submit-button is impossible.
  1. if you fill out all fields and submit the form the page reloads and nothing happens.

:(

Edit:

Bug No.2
Bank:

Deposit or Withdrawl: (x) Deposit: 25
Reason: Test
Amount: 10
[ SUBMIT ]


Transaction Information
The amount you have requested to deposit is less then the minimum deposit amount. Please deposit at least 5.95.

Check on Beta 1 if you can reduplicate these bugs. I tried on a beta 1 copy that I'm about to release and couldn't reproduce either. Also make sure your templates AND phrases are the most up to date and don't contain any custom edits by you.

TheMayhem 03-13-2011 08:55 PM

This is the official 3.1.0 Beta 1 Release Information:



The beta 1 series has now begun. I have resumed scripting needs to be completed features for the 3.1x series. In this release, all market items should now work with the exception of the vbExperience market item. Also when purchasing the coupon listings, the coupon listing page hasn't been scripted. However, this should not effect the ability to create and use coupons for your forums so users may still use coupons if you have them enabled.

Also, I still haven't scripted the market store downloadable purchase item yet. Those are coming within the next beta or so version.

Lastly, in this release, the ability to upload has been added so make sure you Chmod /customavatars/ and /images/smilies/ to 777 for uploading permissions.


There are several bug fixes in this release. I'm still awaiting to hear on some other bugs so if you feel like you had a bug in Alpha 4, go ahead and test it with the Beta series and if the bug is still not fixed, please rereport it but make sure to give as much detailed information as possible such as what exact page you were viewing, etc.





P.S. I got another release in on time :)

fly 03-13-2011 09:19 PM

Beta 1 Bug: Under the maintenance section, 'Usertitle Update' hangs on the first page. It never ends, nor moves to another page

fly 03-13-2011 09:30 PM

And does 'Donate to Another User' really expire?

TheMayhem 03-13-2011 09:32 PM

Quote:

Originally Posted by fly (Post 2173019)
And does 'Donate to Another User' really expire?

No theres a few that don't expire like Donations or Change Username.

fly 03-13-2011 09:33 PM

And is there a way that the expiration time of the item couldbe displayed on the purchase page?

Sarab 03-14-2011 08:42 AM

Thank you for your update ^^

anyway I'm bored of asking the same question over and over, so at least tell me if you gonna put it in the future update or not, because it's essential for me,

The question was: can I chose the usergroup for the third "Secondary Usergroup Change" Item I made or not?

Best Regards,
Sarab

TheMayhem 03-14-2011 09:48 AM

Quote:

Originally Posted by Sarab (Post 2173177)
Thank you for your update ^^

anyway I'm bored of asking the same question over and over, so at least tell me if you gonna put it in the future update or not, because it's essential for me,

The question was: can I chose the usergroup for the third "Secondary Usergroup Change" Item I made or not?

Best Regards,
Sarab

Eventually I am going to faze out the edit options of choosing a primary usergroup and make it so each time you edit the item you can choose a different usergroup.

kesandal 03-14-2011 09:56 AM

Quote:

Hello,

think I found a bug:

Wenn you open a item which has shipping set to mail you have to fill out the "store shipping information".

1. forgett to fill out for instance the "full name" and click on "Confirm Purchase: Credits".
The page reloads, no error is shown and clicking again on the submit-button is impossible.

1. if you fill out all fields and submit the form the page reloads and nothing happens.




Edit:

Bug No.2

Bank:

Deposit or Withdrawl: (x) Deposit: 25
Reason: Test
Amount: 10
[ SUBMIT ]


Transaction Information
The amount you have requested to deposit is less then the minimum deposit amount. Please deposit at least 5.95.

Possible reason for the error:

The variable which holds the minimum amount in phrase $vbphrase[market_error_bank_3] is wrong.

I did a check:

if ($amount < $minimum_deposit) {
$error = 3; // Amount is less then minimum deposit
}
$amount is correct.
$minimum_deposit is correct too (in my example it was 10.95.

Hope this helps you out buddy. If u have any further questions regarding this 2 bugs let me know.
Quote:

Originally Posted by TheMayhem (Post 2172997)
Check on Beta 1 if you can reduplicate these bugs. I tried on a beta 1 copy that I'm about to release and couldn't reproduce either. Also make sure your templates AND phrases are the most up to date and don't contain any custom edits by you.



Hello TheMayhem
the error still occurs. :(

With beta 1:

Bug1: Now if you send the purchase-form the page simply reloads and nothing happens.

Bug2: templates and phrases are up to date.

Code:

The amount you have requested to deposit is less then
the minimum deposit amount. Please deposit at least 5.95
(here the variable from minimum_withdraw is shown. Should be minimum_deposit).

Code:

Credits Balance: 11
Interest Rate: 2%
Interest Period: 7 Days
Min. Deposit: 10.95
Deposit Fee: 2.99%
Min. Withdrawal: 5.95
Withdrawal Fee: 1.49%

I can send you the login for my adminCP so that you can reproduce the error(s).

Kind regards
Kesandal

TheMayhem 03-14-2011 01:08 PM

Private message me login details as well as exact links to each page and what browser are you using?

Arboristsite 03-14-2011 08:49 PM

So if you have some people who don't want to participate at all. Can you switch them to a different usergroup that doesn't allow the use of credits or something? I have a ton that REALLY want to play and a very select few that want no part of it.

dcg 03-14-2011 08:53 PM

Hi,

I am using your product and I can’t seem to figure out the primary usergroup stuff.

The issue is I have 4 paid usergroups. Your store allows me to put in one price for a primary usergroup purchase but doesn’t allow me to specify what they get after they purchase.

The option should include a primary usergroup purchase and a selection to pick a usergroup to upgrade them to once they complete the purchase.

Primary usergroup: 5000
Usergroup to upgrade to: Platinum or Exclusive etc. It should pull from the usergroups you have setup in the forum already.

Also when I try to purchase the item its not deducting from my points.
I have a registered user account with 50,000 points.
I setup the primary usergroup option at a cost of 10,000 points. It says the item was purchased successfully but it doesn’t deduct the points from the overall balance as well as it doesn’t upgrade the user to another upgroup.

Is this something that’s built in already and I’m just missing it?

I am willing to pay to have this fixed on my system so please PM me.

-=DCG=-

kesandal 03-14-2011 09:38 PM

Quote:

Originally Posted by TheMayhem (Post 2173210)
Private message me login details as well as exact links to each page and what browser are you using?

Done.
Please check your private messages :)

I've tested the shop with Firefox 3.5 and IE 8

Regards
Kesandal

NovoCiv 03-14-2011 11:19 PM

Edit: Spoke too soon, found what I was looking for.

TheMayhem 03-15-2011 12:12 AM

Quote:

Originally Posted by kesandal (Post 2173399)
Done.
Please check your private messages :)

I've tested the shop with Firefox 3.5 and IE 8

Regards
Kesandal

Kesandral, check your pms. One of those was a bug and the other wasn't. I explained in the message.

DCG, your right the way I have it setup now doesn't let you add more then 2 primary usergroups total. I'll tell you what, I will fix this for the next release and make it so you can choose which usergroup they go to for an infinite amount of times. :)

As for why it's not charging the user, link me to the exact purchase item page that you are looking at that never charges. I'll be able to tell by the id number within the link if this is a bug and where it's at.

TheMayhem 03-15-2011 12:14 AM

Quote:

Originally Posted by Arboristsite (Post 2173389)
So if you have some people who don't want to participate at all. Can you switch them to a different usergroup that doesn't allow the use of credits or something? I have a ton that REALLY want to play and a very select few that want no part of it.

I don't know what you mean, can you please explain better and what part or section of the market you are talking about? Theres like 4 or 5 major sections within the Market that by their own right, are independent hacks.

NovoCiv 03-15-2011 12:46 AM

Ok so, it says there's an images forum market category but I don't see it in the market or in the admincp. How do I add these?

Edit: Btw I upgraded from 3.0.0 RC 3

Edit2: I fixed it by exporting market_transactions table and completely uninstalling then reinstalling.

Edit3: Ok items may have shown up but templates are still not correct.

Example: Upload options have no upload field, ban user options have no input field for user, etc.
http://i.imgur.com/9pb9m.png

I completely uninstalled the market and reinstalled it after the update didn't work correctly.

tightjeansforum 03-15-2011 06:44 AM

I get an error when I try to buy any item.

Just got this one trying to buy an item I made myself.
Fatal error: Cannot use object of type mysqli_result as array in /usr/home/jappleton/domains/tightjeansforum.com/public_html/pointmarket/market_store_purchase.php on line 30

Get this one trying to buy a Custom User Title
Fatal error: Cannot use object of type mysqli_result as array in /usr/home/jappleton/domains/tightjeansforum.com/public_html/pointmarket/market_purchase.php on line 58

TheMayhem 03-15-2011 10:30 AM

Quote:

Originally Posted by NovoCiv (Post 2173444)
Ok so, it says there's an images forum market category but I don't see it in the market or in the admincp. How do I add these?

Edit: Btw I upgraded from 3.0.0 RC 3

Edit2: I fixed it by exporting market_transactions table and completely uninstalling then reinstalling.

Edit3: Ok items may have shown up but templates are still not correct.

Example: Upload options have no upload field, ban user options have no input field for user, etc.
http://i.imgur.com/9pb9m.png

I completely uninstalled the market and reinstalled it after the update didn't work correctly.

Something really weird and abnormal is going on with yours. Can you set me up w temp admin access so I can take a look?

NovoCiv 03-15-2011 03:19 PM

Yeah I sent you a PM about it.

MrsTryst 03-17-2011 05:13 PM

***editted***

Resolved and thanx, it's a great mod :up:

kesandal 03-18-2011 07:52 PM

Quote:

Originally Posted by tightjeansforum (Post 2173523)
I get an error when I try to buy any item.

Just got this one trying to buy an item I made myself.
Fatal error: Cannot use object of type mysqli_result as array in /usr/home/jappleton/domains/tightjeansforum.com/public_html/pointmarket/market_store_purchase.php on line 30

I'm getting the same error :(

TheMayham, please help us... :(


Edit:
I was able to fix the bug by myself.

For the other guys encountering the same problem:

1. open /pointmarket/market_store_purchases.php
2. search for
Code:

$cid = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "market_coupons WHERE id ='$getcoupon'");
- should be around line 25

3. replace it with
Code:

$cid = $vbulletin->db->fetch_array($vbulletin->db->query_read("SELECT * FROM " . TABLE_PREFIX . "market_coupons WHERE id ='$getcoupon'"));
4. search for
Code:

$cid = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "market_coupons WHERE id='$getcoupon'");
Approx. Line 31

5. replace with
Code:

$cid = $vbulletin->db->fetch_array($db->query_read("SELECT * FROM " . TABLE_PREFIX . "market_coupons WHERE id='$getcoupon'"));

After this modification I was able to buy products :)

Question to Mayham:
shouldn't
Code:

$has_purchased = $db->num_rows($db->query_read("SELECT * FROM " . TABLE_PREFIX . "market_store_transactions
    where userid='$userid' AND coupon='$cid[id]'"));

be changed to
Code:

$has_purchased = $vbulletin->db->num_rows($db->query_read("SELECT * FROM " . TABLE_PREFIX . "market_store_transactions
    where userid='$userid' AND coupon='$cid[id]'"));

as well?

Best regards
Kesandal

Hall of Famer 03-19-2011 05:48 AM

Dont wanna sound rude, but I dont like the 'steal' feature at all it is just plainly retarded to me. Is there a way to globally get rid of all steal functions?

fly 03-19-2011 11:37 AM

Quote:

Originally Posted by Hall of Famer (Post 2174990)
Dont wanna sound rude, but I dont like the 'steal' feature at all it is just plainly retarded to me. Is there a way to globally get rid of all steal functions?

Uhhh, disable it in the forum items area?

TheMayhem 03-20-2011 05:24 AM

Quote:

Originally Posted by kesandal (Post 2174888)
I'm getting the same error :(

TheMayham, please help us... :(


Edit:
I was able to fix the bug by myself.

For the other guys encountering the same problem:

1. open /pointmarket/market_store_purchases.php
2. search for
Code:

$cid = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "market_coupons WHERE id ='$getcoupon'");
- should be around line 25

3. replace it with
Code:

$cid = $vbulletin->db->fetch_array($vbulletin->db->query_read("SELECT * FROM " . TABLE_PREFIX . "market_coupons WHERE id ='$getcoupon'"));
4. search for
Code:

$cid = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "market_coupons WHERE id='$getcoupon'");
Approx. Line 31

5. replace with
Code:

$cid = $vbulletin->db->fetch_array($db->query_read("SELECT * FROM " . TABLE_PREFIX . "market_coupons WHERE id='$getcoupon'"));

After this modification I was able to buy products :)

Question to Mayham:
shouldn't
Code:

$has_purchased = $db->num_rows($db->query_read("SELECT * FROM " . TABLE_PREFIX . "market_store_transactions
    where userid='$userid' AND coupon='$cid[id]'"));

be changed to
Code:

$has_purchased = $vbulletin->db->num_rows($db->query_read("SELECT * FROM " . TABLE_PREFIX . "market_store_transactions
    where userid='$userid' AND coupon='$cid[id]'"));

as well?

Best regards
Kesandal

Those changes were already applied to the next Beta I just forgot to mention it in this thread. ;)

As for the number rows report, I believe the vBulletin syntax actually is preferred to use $db->num_rows over $vbulletin->db->num_rows; however, I've never been completely positive on that.

Antec_HiveMail 03-21-2011 10:14 AM

Is there any way to access a log of who purchased points with real cash via paypal? The problem I see is, someone makes a purchase with real cash and then says that they didn't get the credits, and right now I can't find anywhere at can show me if they did or not.

TheMayhem 03-22-2011 11:21 PM

The transactions are stored but for whatever reason I didn't script a way to see them. I'll be sure to rectify this and make it so there is a history log for you to view as an Administrator in the near future!

Also, in the next beta due this Sunday I've scripted it so you can now control which usergroup each primary/secondary usergroup change is. This was based off of requests in this thread so you can theoretically now make an unlimited number of change usergroup forum items and each item can have a different usergroup if you like.

elwachiman 03-23-2011 03:50 PM

Code:

Database error in vBulletin 4.1.2:

Invalid SQL:
SELECT * FROM xperience_achievements WHERE canpurchase !=0 ORDER BY title ASC;

MySQL Error  : Table 'elwa*******.xperience_achievements' doesn't exist
Error Number  : 1146
Request Date  : Wednesday, March 23rd 2011 @ 11:34:27 AM
Error Date    : Wednesday, March 23rd 2011 @ 11:34:27 AM
Script        : http://www.elwachiman.com/admincp/market_items.php?do=edititem&id=66
Referrer      : http://www.elwachiman.com/admincp/market_items.php?do=edititem&id=66
IP Address    : 190*******
Username      : *****
Classname    : vB_Database
MySQL Version : 5.0.91-community-log

I CAN USE IN COMBINATION WITH POINTMAKER vBExperience 4 ? SAMPLE ERROR IN DATABASE WHEN I GO TO EDIT vBExperience Achievement

tightjeansforum 03-23-2011 04:32 PM

You fixed it!
Thank you!


All times are GMT. The time now is 12:19 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.04006 seconds
  • Memory Usage 1,868KB
  • 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_code_printable
  • (19)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