edit list o' countries in .php file

[Guest]

Hello -

 

Can anyone direct me to the .php file (I trust this is not some type of pre-populated SQL file?) that contains the array of countries? I am trying to delete all but Canada & the USA, and my mouse finger is getting numb!

 

Thank you!

 

- Rob

[Rob123]

Yes, infact the countries were inserted in the database with a pre-populated SQL file.

 

The list of countries can be found in the countries table of the database... :blush:

You can run the following query to remove all but two countries.

DELETE * FROM countries WHERE countries_name != 'United States' AND countries_name != 'Canada';

 

HTH,

Robert

 

Edit: BTW, most everything in the admin can be modified easily with sql.

[Guest]

Excellent! Thank you very much for your help, Robert!

 

- Rob

 

Yes, infact the countries were inserted in the database with a pre-populated SQL file.

 

The list of countries can be found in the countries table of the database...  :blush:

You can run the following query to remove all but two countries.

DELETE * FROM countries WHERE countries_name != 'United States' AND countries_name != 'Canada';

 

HTH,

Robert

 

Edit:  BTW, most everything in the admin can be modified easily with sql.

<{POST_SNAPBACK}>

[Guest]

Ugh.

 

Now, I cannot acces my Admin panel - I am getting this error:

 

---

Warning: mysql_connect(): Access denied for user: '[email protected]' (Using password: YES) in /var/www/html/catalog/admin/includes/functions/database.php on line 19

Unable to connect to database server!

---

 

line 19 in database.php reads like this:

 

$$link = mysql_connect($server, $username, $password);

 

Is there a, uh, "undo" function in a MySQL Admin? :'(

 

- Rob

 

Yes, infact the countries were inserted in the database with a pre-populated SQL file.

 

The list of countries can be found in the countries table of the database...  :blush:

You can run the following query to remove all but two countries.

DELETE * FROM countries WHERE countries_name != 'United States' AND countries_name != 'Canada';

 

HTH,

Robert

 

Edit:  BTW, most everything in the admin can be modified easily with sql.

<{POST_SNAPBACK}>

[Guest]

NEVER MIND >_<

 

FWIW - I edited line 19 with the actual user name and password instead of the variables and all seems well now! My "Admin" directory on my hosting providers' server is "protected", so I ought to be safe, correct?

 

- Rob

 

Yes, infact the countries were inserted in the database with a pre-populated SQL file.

 

The list of countries can be found in the countries table of the database...  :blush:

You can run the following query to remove all but two countries.

DELETE * FROM countries WHERE countries_name != 'United States' AND countries_name != 'Canada';

 

HTH,

Robert

 

Edit:  BTW, most everything in the admin can be modified easily with sql.

<{POST_SNAPBACK}>

[Guest]

Oh, crap... Am I ever learning the ropes in public... OK... In case *anyone* is following along with a vested interest in the mass removal of countries, here is how this saga played itself out:

 

1) I went into the MySQL admin via my hosting provider, (and had to create an admin password... ?)

 

2) I executed the query.

 

3) I was then unable to access the database. It couldn't have been because I CHANGED THE FRIGGIN' MYSQL PASSWORD, EH? :blush:

 

4) I edited the database.php files with the actual user name/ pass to reflect the "new" (?) password i was prompted to create upon entering the MySQL admin for the first time (back in Step 1)... Then the little hamster in my head started to run real fast and turn the wheel and I...

 

5) Edited the *configure.php" files with the correct variable values (and changed the database.php files *back*). Strangely, that seemed to work.

 

- Rob

 

NEVER MIND  >_<

 

FWIW - I edited line 19 with the actual user name and password instead of the variables and all seems well now! My "Admin" directory on my hosting providers' server is "protected", so I ought to be safe, correct?

 

- Rob

<{POST_SNAPBACK}>