How to limit the number of countries from the shipping estimator page?

[w00gle]

I thought I'd share this one to everyone. From the shipping estimator page, I only wanted to display the U.S. and Canada as selections. I accomplished this by editting includes/functions/functions_lookups.php.

After line 46, I added the line

where (countries_id = 223 || countries_id = 38) 

ORIGINAL PHP CODE:

    if (zen_not_null($countries_id)) {
      if ($with_iso_codes == true) {
        $countries = "select countries_name, countries_iso_code_2, countries_iso_code_3
                      from " . TABLE_COUNTRIES . "
                      where countries_id = '" . (int)$countries_id . "'
                      order by countries_name";
        $countries_values = $db->Execute($countries);
        $countries_array = array('countries_name' => $countries_values->fields['countries_name'],
                                 'countries_iso_code_2' => $countries_values->fields['countries_iso_code_2'],
                                 'countries_iso_code_3' => $countries_values->fields['countries_iso_code_3']);
      } else {
        $countries = "select countries_name
                      from " . TABLE_COUNTRIES . "
                      where countries_id = '" . (int)$countries_id . "'";
        $countries_values = $db->Execute($countries);
        $countries_array = array('countries_name' => $countries_values->fields['countries_name']);
      }
    } else {
      $countries = "select countries_id, countries_name
                    from " . TABLE_COUNTRIES . "
                    order by countries_name"; 

PHP CODE AFTER EDIT:

    if (zen_not_null($countries_id)) {
      if ($with_iso_codes == true) {
        $countries = "select countries_name, countries_iso_code_2, countries_iso_code_3
                      from " . TABLE_COUNTRIES . "
                      where countries_id = '" . (int)$countries_id . "'
                      order by countries_name";
        $countries_values = $db->Execute($countries);
        $countries_array = array('countries_name' => $countries_values->fields['countries_name'],
                                 'countries_iso_code_2' => $countries_values->fields['countries_iso_code_2'],
                                 'countries_iso_code_3' => $countries_values->fields['countries_iso_code_3']);
      } else {
        $countries = "select countries_name
                      from " . TABLE_COUNTRIES . "
                      where countries_id = '" . (int)$countries_id . "'";
        $countries_values = $db->Execute($countries);
        $countries_array = array('countries_name' => $countries_values->fields['countries_name']);
      }
    } else {
      $countries = "select countries_id, countries_name
                    from " . TABLE_COUNTRIES . "
     where (countries_id = 223 || countries_id = 38)
                    order by countries_name"; 

Cheers!

[Mickmo68]

Thank you, I had been searching but skipped this post a few times because there where no replies.
This worked perfectly.