36 replies to this topic

[dontera]

This is something I had wrestled with for some time, until the obvious hit me..

I tried various ways to output a sorted countries list, changing the country I wanted at top to be ID 0 and whatnot, didnt work. Finally I relaized I was overlooking the obvious of using <option .... selected>

Thankfully, the requisite functions have built-in "selected" handling, thus setting your default country is easy.

Edit create_account.php and find

              <tr>
                <td class="main"><?php echo ENTRY_COUNTRY; ?></td>
                <td class="main"><?php echo tep_get_country_list('country') . '&nbsp;' . (tep_not_null(ENTRY_COUNTRY_TEXT) ? '<span class="inputRequirement">' . ENTRY_COUNTRY_TEXT . '</span>': ''); ?></td>
              </tr>

you want to change this line

php echo tep_get_country_list('country') .

to be

php echo tep_get_country_list('country','223') .

223 == the country ID for United States. YOu can set that to be any country by looking either in the database countries list for your countries ID, or even easier, look at the HTML of the create_account.php page and find where the country drop down list is, search for your country and grab the "value".

Hope this helps.

[Bruin_03]

Ah, just what I was looking for. Thank you.

[Bruin_03]

[duplicate post ]

Edited by Bruin_03, 05 April 2004 - 09:20 PM.

[efficiondave]

So is there a way to make US states drop down appear initially? Otherwise it makes the user go back and select it after they submit... can be confusing.

[efficiondave]

In addition, you'll also have edit /includes/modules/address_book_details.php to change the following line:

<td class="main"><?php echo tep_get_country_list('country', $entry['entry_country_id']) . '&nbsp;' . (tep_not_null(ENTRY_COUNTRY_TEXT) ? '<span class="inputRequirement">' . ENTRY_COUNTRY_TEXT . '</span>': ''); ?></td>

to:

            <td class="main"><?php echo (($entry['entry_country_id'] == '') ? tep_get_country_list('country', 223) : tep_get_country_list('country', $entry['entry_country_id'])) . '&nbsp;' . (tep_not_null(ENTRY_COUNTRY_TEXT) ? '<span class="inputRequirement">' . ENTRY_COUNTRY_TEXT . '</span>': ''); ?></td>

Edited by efficiondave, 07 April 2004 - 11:41 PM.

[mutter]

Hi, to add the drop down list of your country states in create_account.php.

I changed this:

<?php
      if ($process == true) {
      $entry_state_has_zones = ($revisar['total'] > 0);
      if ($entry_state_has_zones == true) {
        $zones_array = array();
        $zones_query = tep_db_query("select zone_name from " . TABLE_ZONES . " where zone_country_id = '" . (int)$country . "' order by zone_name");
        while ($zones_values = tep_db_fetch_array($zones_query)) {
          $zones_array[] = array('id' => $zones_values['zone_name'], 'text' => $zones_values['zone_name']);        }
        echo tep_draw_pull_down_menu('state', $zones_array);
      } else {
        echo tep_draw_input_field('state');
      }
    } else {
      echo tep_draw_input_field('state');
    }

    if (tep_not_null(ENTRY_STATE_TEXT)) echo '&nbsp;<span class="inputRequirement">' . ENTRY_STATE_TEXT;
?>

To:

<?php
//    if ($process == true) {
$revisar_query = tep_db_query("select count(*) as total from " . TABLE_ZONES . " where zone_country_id = 138");
      $revisar = tep_db_fetch_array($revisar_query);
      $entry_state_has_zones = ($revisar['total'] > 0);
      if ($entry_state_has_zones == true) {
        $zones_array = array();
        $zones_query = tep_db_query("select zone_name from " . TABLE_ZONES . " where zone_country_id = 138 order by zone_name");
        while ($zones_values = tep_db_fetch_array($zones_query)) {
          $zones_array[] = array('id' => $zones_values['zone_name'], 'text' => $zones_values['zone_name']);        }
        echo tep_draw_pull_down_menu('state', $zones_array);
      } else {
        echo tep_draw_input_field('state');
      }
//    } else {
//      echo tep_draw_input_field('state');
//    }

    if (tep_not_null(ENTRY_STATE_TEXT)) echo '&nbsp;<span class="inputRequirement">' . ENTRY_STATE_TEXT;
?>

[mutter]

ohh, 138 is for Mexico, change the country id number in the code to your country id.

bye...

[mutter]

To the modules/addres_book_details.php

I change this:

<?php
     if ($process == true) {
      $entry_state_has_zones = ($revisar['total'] > 0);
      if ($entry_state_has_zones == true) {
        $zones_array = array();
        $zones_query = tep_db_query("select zone_name from " . TABLE_ZONES . " where zone_country_id = '" . (int)$country . "' order by zone_name");
        while ($zones_values = tep_db_fetch_array($zones_query)) {
          $zones_array[] = array('id' => $zones_values['zone_name'], 'text' => $zones_values['zone_name']);
        }
        echo tep_draw_pull_down_menu('state', $zones_array);
      } else {
        echo tep_draw_input_field('state');
      }
    } else {
      echo tep_draw_input_field('state', tep_get_zone_name($entry['entry_country_id'], $entry['entry_zone_id'], $entry['entry_state']));
    }

    if (tep_not_null(ENTRY_STATE_TEXT)) echo '&nbsp;<span class="inputRequirement">' . ENTRY_STATE_TEXT;
?></td>

To:

<?php
 //   if ($process == true) {
$revisar_query = tep_db_query("select count(*) as total from " . TABLE_ZONES . " where zone_country_id = 138");
      $revisar = tep_db_fetch_array($revisar_query);
      $entry_state_has_zones = ($revisar['total'] > 0);
      if ($entry_state_has_zones == true) {
        $zones_array = array();
        $zones_query = tep_db_query("select zone_name from " . TABLE_ZONES . " where zone_country_id = 138 order by zone_name");
        while ($zones_values = tep_db_fetch_array($zones_query)) {
          $zones_array[] = array('id' => $zones_values['zone_name'], 'text' => $zones_values['zone_name']);
        }
        echo tep_draw_pull_down_menu('state', $zones_array, tep_get_zone_name($entry['entry_country_id'], $entry['entry_zone_id'], $entry['entry_state']));
      } else {
        echo tep_draw_input_field('state');
      }
//    } else {
//      echo tep_draw_input_field('state', tep_get_zone_name($entry['entry_country_id'], $entry['entry_zone_id'], $entry['entry_state']));
//    }

    if (tep_not_null(ENTRY_STATE_TEXT)) echo '&nbsp;<span class="inputRequirement">' . ENTRY_STATE_TEXT;
?></td>

[pinbrook]

I want to ship to one country only, what's the best way to acheive this?

[bluepony]

You could just delete the other countries, but then if you ever change your mind you would have to load back in the countries you want to ship to.  

I set a filter on my site. I just added another column to the Countries table called Show_Country (int) and then marked the ones that I wanted to include with a 1.

Then I just added that condition (WHERE Show_Country=1) to the SQL statement in the tep_get_countries function in includes/functions/general.php

[PopTheTop]

In the pull-down list of US states, where can I edit this list? I can not find them.

[pcwaredirect]

mutter, on Apr 8 2004, 12:40 AM, said:

To the modules/addres_book_details.php

I change this:

<?php
     if ($process == true) {
      $entry_state_has_zones = ($revisar['total'] > 0);
      if ($entry_state_has_zones == true) {
        $zones_array = array();
        $zones_query = tep_db_query("select zone_name from " . TABLE_ZONES . " where zone_country_id = '" . (int)$country . "' order by zone_name");
        while ($zones_values = tep_db_fetch_array($zones_query)) {
          $zones_array[] = array('id' => $zones_values['zone_name'], 'text' => $zones_values['zone_name']);
        }
        echo tep_draw_pull_down_menu('state', $zones_array);
      } else {
        echo tep_draw_input_field('state');
      }
    } else {
      echo tep_draw_input_field('state', tep_get_zone_name($entry['entry_country_id'], $entry['entry_zone_id'], $entry['entry_state']));
    }

    if (tep_not_null(ENTRY_STATE_TEXT)) echo '&nbsp;<span class="inputRequirement">' . ENTRY_STATE_TEXT;
?></td>

To:

<?php
 //   if ($process == true) {
$revisar_query = tep_db_query("select count(*) as total from " . TABLE_ZONES . " where zone_country_id = 138");
      $revisar = tep_db_fetch_array($revisar_query);
      $entry_state_has_zones = ($revisar['total'] > 0);
      if ($entry_state_has_zones == true) {
        $zones_array = array();
        $zones_query = tep_db_query("select zone_name from " . TABLE_ZONES . " where zone_country_id = 138 order by zone_name");
        while ($zones_values = tep_db_fetch_array($zones_query)) {
          $zones_array[] = array('id' => $zones_values['zone_name'], 'text' => $zones_values['zone_name']);
        }
        echo tep_draw_pull_down_menu('state', $zones_array, tep_get_zone_name($entry['entry_country_id'], $entry['entry_zone_id'], $entry['entry_state']));
      } else {
        echo tep_draw_input_field('state');
      }
//    } else {
//      echo tep_draw_input_field('state', tep_get_zone_name($entry['entry_country_id'], $entry['entry_zone_id'], $entry['entry_state']));
//    }

    if (tep_not_null(ENTRY_STATE_TEXT)) echo '&nbsp;<span class="inputRequirement">' . ENTRY_STATE_TEXT;
?></td>

<{POST_SNAPBACK}>

why do you edit the address_book_details.php ?  Is this necessary? i made my state drop down box using  something different but it never mentioned having to edit the address book. is this ok?

                                      Jeremy

[Analyser]

So helpful, just what I needed, thanks

Edited by Analyser, 29 January 2005 - 05:08 PM.

[atouk]

Most excellent thread!

The only thing that got me was not changing the country code for the state dropdown to 223 (US) from 138 (Mexico) after a straight cut and paste of the code.

OSC Lesson #654: Pay attention to what you are pasting, even if it seems simple.

[NeoNiko]

Bluepony -
Could you post how you did that? That sounds like a really cool idea and I would love to give it a try.

[Earth Bizz]

Anyway to delete the Country drop down box alltogether and hardcode just one Country into the create_account file?

I'm an ex Cube cart user and I did it there .. but I'm still a newbie to OC .. not sure if its possible.

[tsheffie]

bluepony, on Apr 16 2004, 01:07 AM, said:

You could just delete the other countries, but then if you ever change your mind you would have to load back in the countries you want to ship to. 

I set a filter on my site. I just added another column to the Countries table called Show_Country (int) and then marked the ones that I wanted to include with a 1.

Then I just added that condition (WHERE Show_Country=1) to the SQL statement in the tep_get_countries function in includes/functions/general.php

<{POST_SNAPBACK}>

That sounds pretty cool but can you give a bit more detail. Some of us aren't quite up to your speed.  

[dnfhosting]

bluepony, on Apr 15 2004, 07:07 AM, said:

You could just delete the other countries, but then if you ever change your mind you would have to load back in the countries you want to ship to.  

I set a filter on my site. I just added another column to the Countries table called Show_Country (int) and then marked the ones that I wanted to include with a 1.

Then I just added that condition (WHERE Show_Country=1) to the SQL statement in the tep_get_countries function in includes/functions/general.php

Hi bluepony,
I added the table column, but am not sure where to add the sql statement (i.e. which line(s)).  I tried several things and none worked, so if you could specify where the WHERE goes, it would be greatly appreciated.

Thanks!

[scranmer]

Quote

edit create_account... edit address_book....

  NO NEED!

Just edit includes\functions\html_output.php and amend the following bit to default ALL country LOVs to your shops country.

HTH

Si.

////
// Creates a pull-down list of countries
  function tep_get_country_list($name, $selected = '', $parameters = '') {

//**si**
if ( strlen($selected)==0 ) $selected = STORE_COUNTRY;
//**si**

	$countries_array = array(array('id' => '', 'text' => PULL_DOWN_DEFAULT));
	$countries = tep_get_countries();

	for ($i=0, $n=sizeof($countries); $i<$n; $i++) {
	  $countries_array[] = array('id' => $countries[$i]['countries_id'], 'text' => $countries[$i]['countries_name']);
	}

	return tep_draw_pull_down_menu($name, $countries_array, $selected, $parameters);
  }

[bmw000]

This was an easy change, both for the country and state dropdown edits.

I think one more edit would make it perfect.

With the new state drop down mod, how can it be made to default to "Please Select" in lieu of Alabama?

I noticed that "Please select" is not in the list at all.

How can I add "Please select" to the state dropdown and make that the default selection?

Thanks,
Brian

Edited by bmw000, 13 May 2007 - 11:38 PM.