vb.org Archive
Page 172 of 223 « First 72122162170171 172 173174182222 Last »
Show 40 post(s) from this thread on one page

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)

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 02:31 AM.
Page 172 of 223 « First 72122162170171 172 173174182222 Last »
Show 40 post(s) from this thread on one page

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.03014 seconds
  • Memory Usage 1,756KB
  • 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
  • (13)bbcode_code_printable
  • (3)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