• eCommerce
  • Social and Community Suite
  • Content Management
  • RSS Extensions
  • VirtueMart Extensions
Follow us on Twitter   Join The Factory on the New Digg  
(0) | Login | Register | Lost Password?
Username: Password:  
Home
Our Products
Joomla 1.7.x  (23) & J!1.6.x
Joomla 1.5.x (28)
Joomla 1.0.x (17)
Factory Club Extensions (7)
Drupal, Elxis, MODx (6)
Windows Gadgets for J! (11)
Free Templates (4)
All Products (92)
Documentation
Tweets
Forum
Contact Us
Terms & Conditions
How to Buy Guide
Customers FAQ's
Updates & Upgrades
About Us
The Factory Demo Server for Joomla Extensions
Money Back Guarantee
Payment Methods for Joomla Extensions
Follow us on Facebook

Latest Tweets

  • Join us at the Joomladay UK!
  • The Factory Extensions Joomla Compatibility Chart
  • Love Factory 2.4 for Joomla 1.7
  • Love Factory - Memberships [VIDEO]
  • Love Factory - Custom Fields Integration [VIDEO]
  • Love Factory - Google Maps Integration [VIDEO]
  • Love Factory - Administrator Guide [VIDEO]
  • Love Factory - Memberships
  • Collection Factory for Joomla 1.6 with CB support
  • Reverse Auction Factory 1.5.9
 
   Home   Help Search Login Register  
The Factory > Forum > VirtueMart Extensions & Payment Facilities > VM ePayment Factory > Using 3 letter Coutrycode with VM ePayment
Pages: [1]
« previous next »
  Print  
Author Topic: Using 3 letter Coutrycode with VM ePayment  (Read 1416 times)
Andy - The Factory
Administrator
Hero Member
*****
Posts: 1639



View Profile
Using 3 letter Coutrycode with VM ePayment
« on: May 28, 2010, 05:27:44 pm »

If you use 3 letter country code in VM you can change the submitted code into a 2 letter code following these steps:

EDIT this file : ps_epayment.php


Search for:

Quote
      // Get user billing information
      $dbbt = new ps_DB;

      $qt = "SELECT * FROM #__{vm}_user_info WHERE user_id=".$auth["user_id"]." AND address_type='BT'";

      $dbbt->query($qt);

replace with:
Quote
      // Get user billing information
      $dbbt = new ps_DB;
      $qt = "SELECT a.*,b.country_3_code,b.country_2_code FROM #__{vm}_user_info a
      left join #__{vm}_country b on  b.country_3_code=a.country
      WHERE user_id=".$auth["user_id"]." AND address_type='BT'";

      $dbbt->query($qt);

search for:
Quote
         // Get user billing information
         $dbst =& new ps_DB;
         $qt = "SELECT * FROM #__{vm}_user_info WHERE user_info_id='".$d["ship_to_info_id"]."' AND address_type='ST'";
         $dbst->query($qt);
replace with:
Quote
         // Get user billing information
         $dbst =& new ps_DB;
         $qt = "SELECT a.*,b.country_3_code,b.country_2_code  FROM #__{vm}_user_info a
        left join #__{vm}_country b on  b.country_3_code=a.country
         WHERE user_info_id='".$d["ship_to_info_id"]."' AND address_type='ST'";
         $dbst->query($qt);

search for:
Quote
->f("country");

replace with (2 times):
Quote
->f("country_2_code");
Logged
Pages: [1]
  Print  
« previous next »
 
Jump to:  

Loading...
Joomla Extension - RSS Factory Manager  Joomla Extension - EBook Factory  Joomla Extension - Briefcase Factory  Joomla Extension - Auctions Factory  Joomla Module - RSS Contextual  Joomla Module - Exchange Factory (Europe / EURO)  Joomla Module - Exchange Factory (Romania/ RON)  Joomla Custom Extensions Development   Free Joomla Extensions  Joomla Extension - RSS Factory Pro (Enhanced Version)  Joomla Virtuemart Payment Plugin - Gecad (EPayment.ro)  Joomla Module - Mosimage / Image Module  Joomla Extension - Reverse Auction Factory (Lowest Bidder Auctions)  Joomla Extension - Article Factory Manager  Joomla Module - Lavalamp Menu  Joomla Module - RSS Image Extractor  Joomla Module - Exchange Factory (Europe / EURO) for Joomla 1.0.15  Joomla Module - Exchange Factory (Romania / RON) for Joomla 1.0.15  Joomla Module - Top Movies (IMDB)   Joomla Module - EBay Latest Auctions  Auction Factory Standalone PHP script