The user purchases section does only show the active purchases, honestly this was a mistake on my part - I realize now that it'd be useful to be able to see all purchases, present and past. This will be fixed in the next version, with the option to filter them and only show non-expired, or both. Temporarily you can find this code in library/Ice/Shop/Model/Purchase.php
public function getPurchasesUnlimited(){
return $this->_getDb()->fetchAll('
SELECT username, xf_ice_shop_purchases.purchase_id, xf_user.user_id, xf_ice_shop_purchases.product_id, purchase_date, product_name, expired, term_length, purchase_date
FROM xf_ice_shop_purchases
LEFT JOIN xf_ice_shop_products
ON xf_ice_shop_purchases.product_id = xf_ice_shop_products.product_id
LEFT JOIN xf_user
ON xf_ice_shop_purchases.user_id = xf_user.user_id
WHERE expired=0
ORDER BY purchase_date DESC
');
}
Not with only this add-on, systems like BdBank let you transfer money.
The user purchases section does only show the active purchases, honestly this was a mistake on my part - I realize now that it'd be useful to be able to see all purchases, present and past. This will be fixed in the next version, with the option to filter them and only show non-expired, or both. Temporarily you can find this code in library/Ice/Shop/Model/Purchase.php
And remove the line that says "WHERE expired=0". I don't have time at the moment to push out a full update with a front end for the filters, but expect it within a few days. Again, sorry for requiring it to be hot-fixed for nowPHP:public function getPurchasesUnlimited(){ return $this->_getDb()->fetchAll(' SELECT username, xf_ice_shop_purchases.purchase_id, xf_user.user_id, xf_ice_shop_purchases.product_id, purchase_date, product_name, expired, term_length, purchase_date FROM xf_ice_shop_purchases LEFT JOIN xf_ice_shop_products ON xf_ice_shop_purchases.product_id = xf_ice_shop_products.product_id LEFT JOIN xf_user ON xf_ice_shop_purchases.user_id = xf_user.user_id WHERE expired=0 ORDER BY purchase_date DESC '); }
Suffixes would be very possible, easy addition. As for the database tables I've seen it done both ways (both with and without the xf_ prefix). It's really just personal preference, for whatever reason I put xf_ in front of them when I started out. I have a few add-ons with the xf_ and a few without - I just chose one (if there is a "correct" way to do it, someone please tell me
)I agree completely - it would be great if the CSS for user groups could cascade (as an option). I'll see what I can do in terms of custom styling - this seems to be a pretty common request, and if it isn't too much of a hassle I could probably add it into the core of the add-on. Another common issue seems to be having a ton of extra user groups - if I can get the username styles worked out there'd be significantly less groups.
it's not just personal preference
Ok great, I honestly wasn't sure - I hadn't read that thread. I figured since it was directly related to the forum software that it ought to be grouped with all the other tables. Thanks.
)
If you updated to 1.0.1, please install this update as soon as possible. There was a small code change in 1.0.1 that accidentally limits who can purchase for other users - they will get a "A server error occurred" message.
You do not have to update via the ACP, just upload the new library folder. Sorry if this caused any trouble for your forums - I'm surprised I haven't gotten any messages about it
