Remove 200+ countries in seconds not hours

[matrix2223]

This is to help new users who want to remove all those countries but your own ex. US

 

First BACKUP BACKUP and BACKUP again.

 

I wont be held responsible for any errors.

 

With that said lets get started.

 

Login to your database using phpmyAdmin

 

>>Click on countries on the left side

 

>>Check countries name then >>click Browse

 

Once you are in the structure of the table simply check all boxes of the name of the countries that you do not wish to use. Then click the red X for Delete under the table rows.

 

Continue the process until you are done.

 

Thats it your finished

[Guest]

if you do that with a seasoned store you going to have lots of troubles

http://www.oscommerce.com/forums/index.php?s=&...st&p=875088

[Guest]

To make the countries removal even faster if you are using phpAdmin... be sure to tell it to show all the rows on one page..

 

if you hover your mouse over the countries link on the left it should tell you how many rows, therefore how many countries you have.

 

Type in where it says show... 0 to (what ever the number of rows). With them all on one page you can click the check all button at the bottom and just uncheck the ones you want to keep, then hit show.

 

Thanx for starting this topic matrix... I had to do this very thing the other day...

[matrix2223]

No Prop. I hated going through each individual country and I knew there had to be an easier way to do this. So with a fresh install of osC and a new database I tried it just for the hek of it and vala worked like a charm.

 

As for having a store already with other things already done to it, contrib and such. I would recomend that you use the old fashion way, click by click. Or you did make a BACKUP right.

 

Remember always backup your files and database before you make any changes.

 

Eric

[Guest]

As for having a store already with other things already done to it, contrib and such. I would recomend that you use the old fashion way, click by click.

why you think this will make a difference?

[matrix2223]

why you think this will make a difference?

 

I didnt want people to hose there data even if they did make a backup. I know it doesnt make a difference.

[boxtel]

No Prop. I hated going through each individual country and I knew there had to be an easier way to do this. So with a fresh install of osC and a new database I tried it just for the hek of it and vala worked like a charm.

 

As for having a store already with other things already done to it, contrib and such. I would recomend that you use the old fashion way, click by click. Or you did make a BACKUP right.

 

Remember always backup your files and database before you make any changes.

 

Eric

 

I would add an "active" field to the countries table, set the onces you do not want anymore to 0, the rest to 1 and alter the tep_get_countries function to only select those having 1.

 

Then your country dropdown boxes should omit those unwanted but those are still present in the tables.

[Guest]

I would add an "active" field to the countries table, set the onces you do not want anymore to 0, the rest to 1 and alter the tep_get_countries function to only select those having 1.

 

Then your country dropdown boxes should omit those unwanted but those are still present in the tables.

And that will do the pretty much the same as some of the existing countries contributions modules.

[locust13]

*sigh* Crap, I didn't backup. Not sure why, I just didn't :(. So now I have all of hte counties except for the United States deleted on the database side.

Now I'm getting an error in the admin panel:

 

Parse error: syntax error, unexpected '}' in /usr/local/psa/home/vhosts/gamewavecomputers.com/httpdocs/admin/includes/classes/split_page_results.php on line 39

 

If I get rid of that } I get this error:

 

Parse error: syntax error, unexpected T_FUNCTION in /usr/local/psa/home/vhosts/gamewavecomputers.com/httpdocs/admin/includes/classes/split_page_results.php on line 41

 

What can I do to either go back to having all of hte older countries or fix this and just keep it with the united states...? *sigh*

 

Please help me fix the problem created by this and the combo of me not backing up the database while in a rush :(

[locust13]

Anyone? Please? I really need help on this.

Here's my admin/includes/classes/split_page_results.php file.

 

<?php

/*

$Id: split_page_results.php,v 1.13 2003/05/05 17:56:50 dgw_ Exp $

 

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

 

Copyright © 2002 osCommerce

 

Released under the GNU General Public License

*/

 

class splitPageResults {

function splitPageResults(&$current_page_number, $max_rows_per_page, &$sql_query, &$query_num_rows) {

if (empty($current_page_number)) $current_page_number = 1;

 

$pos_to = strlen($sql_query);

$pos_from = strpos($sql_query, ' from', 0);

 

$pos_group_by = strpos($sql_query, ' group by', $pos_from);

if (($pos_group_by < $pos_to) && ($pos_group_by != false)) $pos_to = $pos_group_by;

 

$pos_having = strpos($sql_query, ' having', $pos_from);

if (($pos_having < $pos_to) && ($pos_having != false)) $pos_to = $pos_having;

 

$pos_order_by = strpos($sql_query, ' order by', $pos_from);

if (($pos_order_by < $pos_to) && ($pos_order_by != false)) $pos_to = $pos_order_by;

 

$reviews_count_query = tep_db_query("select count(*) as total " . substr($sql_query, $pos_from, ($pos_to - $pos_from)));

$reviews_count = tep_db_fetch_array($reviews_count_query);

$query_num_rows = $reviews_count['total'];

 

$num_pages = ceil($query_num_rows / $max_rows_per_page);

if ($current_page_number > $num_pages) {

$current_page_number = $num_pages;

}

$offset = ($max_rows_per_page * ($current_page_number - 1));

$sql_query .= " limit " . max($offset, 0) . ", " . $max_rows_per_page

}

 

function display_links($query_numrows, $max_rows_per_page, $max_page_links, $current_page_number, $parameters = '', $page_name = 'page') {

global $PHP_SELF;

 

if ( tep_not_null($parameters) && (substr($parameters, -1) != '&') ) $parameters .= '&';

 

// calculate number of pages needing links

$num_pages = ceil($query_numrows / $max_rows_per_page);

 

$pages_array = array();

for ($i=1; $i<=$num_pages; $i++) {

$pages_array[] = array('id' => $i, 'text' => $i);

}

 

if ($num_pages > 1) {

$display_links = tep_draw_form('pages', basename($PHP_SELF), '', 'get');

 

if ($current_page_number > 1) {

$display_links .= '<a href="' . tep_href_link(basename($PHP_SELF), $parameters . $page_name . '=' . ($current_page_number - 1), 'NONSSL') . '" class="splitPageLink">' . PREVNEXT_BUTTON_PREV . '</a>  ';

} else {

$display_links .= PREVNEXT_BUTTON_PREV . '  ';

}

 

$display_links .= sprintf(TEXT_RESULT_PAGE, tep_draw_pull_down_menu($page_name, $pages_array, $current_page_number, 'onChange="this.form.submit();"'), $num_pages);

 

if (($current_page_number < $num_pages) && ($num_pages != 1)) {

$display_links .= '  <a href="' . tep_href_link(basename($PHP_SELF), $parameters . $page_name . '=' . ($current_page_number + 1), 'NONSSL') . '" class="splitPageLink">' . PREVNEXT_BUTTON_NEXT . '</a>';

} else {

$display_links .= '  ' . PREVNEXT_BUTTON_NEXT;

}

 

if ($parameters != '') {

if (substr($parameters, -1) == '&') $parameters = substr($parameters, 0, -1);

$pairs = explode('&', $parameters);

while (list(, $pair) = each($pairs)) {

list($key,$value) = explode('=', $pair);

$display_links .= tep_draw_hidden_field(rawurldecode($key), rawurldecode($value));

}

}

 

if (SID) $display_links .= tep_draw_hidden_field(tep_session_name(), tep_session_id());

 

$display_links .= '</form>';

} else {

$display_links = sprintf(TEXT_RESULT_PAGE, $num_pages, $num_pages);

}

 

return $display_links;

}

 

function display_count($query_numrows, $max_rows_per_page, $current_page_number, $text_output) {

$to_num = ($max_rows_per_page * $current_page_number);

if ($to_num > $query_numrows) $to_num = $query_numrows;

$from_num = ($max_rows_per_page * ($current_page_number - 1));

if ($to_num == 0) {

$from_num = 0;

} else {

$from_num++;

}

 

return sprintf($text_output, $from_num, $to_num, $query_numrows);

}

}

?>

[matrix2223]

Look in the original sql file that came with osC all of the countries are in there

 

Eric

[locust13]

Thanks Eric :). Unfortunattly, I decided to just reinstall, doesn't take too much time. I'm a new store taht hasn't gone live so it's no biggie :P.

[locust13]

Crap.. I even tried to make a new database and install on that but I get hte same error...

What do I do in the sql file to fix this? Please be descriptive, I'm not very good at this :(.

[locust13]

Fixed, I just went back to base 1 after saving what I could :P. I would've hit hte edit button but I can't seem to find it...so, sorry for the extra posts o.O