-Calypso-
|
I have no idea how this critical portion of code has eluded me for so long. As you may or may not know, I am unable to accurately test this with other currencies due to my paypal and banking currency is USD. I apologize for this error, however this will (tested on a board using EUR currency) correct paypal selling currencies and county codes for items listed.
Open: source/components_public/commerce.php
Find ( in function items() ):
CODE $r = $this->ipsclass->DB->build_and_exec_query( array( 'select' => 'c.*',
'from' => array( 'commerce' => 'c' ),
'where' => 'c.item_id='.$this->ipsclass->input['item_id'],
'add_join' => array( 0 => array( 'select' => 'cp.*',
'from' => array( 'commerce_profiles' => 'cp' ),
'where' => 'cp.prof_id=c.seller_id',
'type' => 'left' ),
1 => array( 'select' => 'm.posts, m.joined, m.last_visit',
'from' => array( 'members' => 'm' ),
'where' => 'm.id=cp.prof_id',
'type' => 'left' ),
2 => array( 'select' => 'me.avatar_location, me.avatar_size, me.avatar_type, me.signature',
'from' => array( 'member_extra' => 'me' ),
'where' => 'me.id=m.id',
'type' => 'left' ) ),
) );
Replace With:
CODE $r = $this->ipsclass->DB->build_and_exec_query( array( 'select' => 'c.*',
'from' => array( 'commerce' => 'c' ),
'where' => 'c.item_id='.$this->ipsclass->input['item_id'],
'add_join' => array( 0 => array( 'select' => 'cp.*',
'from' => array( 'commerce_profiles' => 'cp' ),
'where' => 'cp.prof_id=c.seller_id',
'type' => 'left' ),
1 => array( 'select' => 'cur.*',
'from' => array( 'commerce_currency' => 'cur' ),
'where' => 'cur.cur_id=cp.prof_cur',
'type' => 'left' ),
2 => array( 'select' => 'cc.*',
'from' => array( 'commerce_cc' => 'cc' ),
'where' => 'cc.cc_id=cp.prof_cc',
'type' => 'left' ),
3 => array( 'select' => 'm.posts, m.joined, m.last_visit',
'from' => array( 'members' => 'm' ),
'where' => 'm.id=cp.prof_id',
'type' => 'left' ),
4 => array( 'select' => 'me.avatar_location, me.avatar_size, me.avatar_type, me.signature',
'from' => array( 'member_extra' => 'me' ),
'where' => 'me.id=m.id',
'type' => 'left' ) ),
) );
Save & Upload
If you need further help, feel free to send me a PM.
|
Verified IPS Customers: 372
FrontPage System Users
