Mort-lemur Posted October 1, 2011 Posted October 1, 2011 Hi, I am using osc affiliate but need to change the code so that it only picks up orders for paying affiliates which are at status 3 ie.delivered. There are several instances of this line of code throughout the mod files: o.orders_id and o.orders_status >= " . AFFILIATE_PAYMENT_ORDER_MIN_STATUS . " Now to change this so that the orders status must match 3 exactly (not 3 or greater) would I just change it to read: o.orders_id and o.orders_status == " . AFFILIATE_PAYMENT_ORDER_MIN_STATUS . " Thanks Now running on a fully modded, Mobile Friendly 2.3.4 Store with the Excellent MTS installed - See my profile for the mods installed ..... So much thanks for all the help given along the way by forum members.
♥kymation Posted October 1, 2011 Posted October 1, 2011 That's SQL, not PHP. So that would be and o.orders_status = " . AFFILIATE_PAYMENT_ORDER_MIN_STATUS . " Regards Jim See my profile for a list of my addons and ways to get support.
Mort-lemur Posted October 1, 2011 Author Posted October 1, 2011 Thanks, Wondering why I was getting sql errors!! Sorted now Many Thanks Now running on a fully modded, Mobile Friendly 2.3.4 Store with the Excellent MTS installed - See my profile for the mods installed ..... So much thanks for all the help given along the way by forum members.
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.