[TheMayhem]

Originally Posted by Aramist

HI,


When i create a new item store, and click it to access...it gives me the following my sql error...

Database error in vBulletin 4.0.5:

Invalid SQL:
select * from market_store_transactions where marketid ='4' and userid='1';

MySQL Error   : Table 'mybd.market_store_transactions' doesn't exist
Error Number  : 1146
Request Date  : Tuesday, August 10th 2010 @ 10:49:11 PM
Error Date    : Tuesday, August 10th 2010 @ 10:49:11 PM
Script        : http://www.mysite.com/forum/market.php?do=storeitem&id=4
Referrer      : http://www.mysite.com/forum/market.php?do=storecat&storeid=3
IP Address    : My IP
Username      : Aramist
Classname     : vB_Database
MySQL Version : 5.0.91-community

He's not inserting the Table prefix

Any fix for it ?

Ty in advance

Looks like I missed this, here is your fix for it or you can wait for the next release:

Open root/market.php

Find:

PHP Code:

// Check to See if User Can Rate
$user_purchase = $db->num_rows($db->query_read("select * from market_store_transactions where marketid ='".addslashes($itemid)."' and userid='".addslashes($userid)."'"));
if ($user_purchase > 0) {
$can_review = $db->num_rows($db->query_read("select * from market_store_review where marketid ='".addslashes($itemid)."' and userid='".addslashes($userid)."'")); 


Change to:

PHP Code:

// Check to See if User Can Rate
$user_purchase = $db->num_rows($db->query_read("select * from " . TABLE_PREFIX . "market_store_transactions where marketid ='".addslashes($itemid)."' and userid='".addslashes($userid)."'"));
if ($user_purchase > 0) {
$can_review = $db->num_rows($db->query_read("select * from " . TABLE_PREFIX . "market_store_review where marketid ='".addslashes($itemid)."' and userid='".addslashes($userid)."'"));
} else { 


Originally Posted by RollaJedi

i noticed that you said you can convert currencies. Can you convert vbexperience points into ucash, so that i may use ucash on your store and also spend the newly converted ucash on other 3rd party shops?

vbexperience points -----> point market system turns them into ucash ----------> able to spend these converted points in another shop

Yes you can use the Point Market Converter to turn a currency such as vBExperience into uCash and then a user could use those points from uCash to use it on another point store other then the market if you like.