Deleting countries

[Terje]

Is there a way to delete all countries in once instead of deleting one by one?

I'm going to use it so the customer can locate/tell us their closest location to our radiotransmitters/recivers.

 

This services is in one country only so I don't really need all countries in the world listede up.

 

Thanx

[GraphicsGuy]

If you have access to use phpMyAdmin on your database, you could open the Countries table, select the "Empty" tab and empty that table. Then add back the country that you want by using the "Insert" tab.

[RocksIT]

sure just edit the html on your create account.php page where it lists all the options for countries only leave in the one you want ie.. US.

[GraphicsGuy]

sure just edit the html on your create account.php  page where it lists all the options for countries only leave in the one you want  ie..  US.

Just curious. Could you post the code in create_account.php that you would edit?

[Terje]

If you have access to use phpMyAdmin on your database, you could open the Countries table, select the "Empty" tab and empty that table.  Then add back the country that you want by using the "Insert" tab.

Thanks! That helped me a lot :D

But I have some more problem. The footer is placing it self right under Currencies (Valuta) on the right side. Why is it doing that? And how can I fix it so it always will be at the bottom?

 

If I don't find a solution I have to take it away 'cause now it's just anoying.

 

Hope you can help me out here as well :D

 

Thanx

 

[Edited]

Here's the link to the site: http://www.sms-tele.com/1

[GraphicsGuy]

Could you post the last few lines of your "column_right.php" and the first 20 lines or so of "footer.php"?

[Terje]

Last lines in column_right.php

  }

 require(DIR_WS_BOXES . 'reviews.php');

 if (substr(basename($PHP_SELF), 0, 8) != 'checkout') {
   include(DIR_WS_BOXES . 'languages.php');
   include(DIR_WS_BOXES . 'currencies.php');
 }
?>

 

First lines in footer.php

<?php
/*
 $Id: footer.php,v 1.26 2003/02/10 22:30:54 hpdl Exp $

 osCommerce, Open Source E-Commerce Solutions
 http://www.oscommerce.com

 Copyright (c) 2003 osCommerce

 Released under the GNU General Public License
*/

 require(DIR_WS_INCLUDES . 'counter.php');
?>
<table border="0" width="100%" cellspacing="0" cellpadding="1">
 <tr class="footer">
   <td class="footer">  <?php echo strftime(DATE_FORMAT_LONG); ?>  </td>
   <td align="right" class="footer">  <?php echo $counter_now . ' ' . FOOTER_TEXT_REQUESTS_SINCE . ' ' . $counter_startdate_formatted; ?>  </td>
 </tr>
</table>

[GraphicsGuy]

A real head scratcher here.

 

I can find nothing wrong with the html source code of that part of the page that is being rendered in the browser as compared to a stock 2.2ms2 code.

 

But, and this is interesting because I can't remember ever making the change, but I must have, my working model has an additional </table> tag in index.php that makes the difference.

 

So, without really thinking out why, here is a suggestion for something to try if you want. Open index.php and find this:

 

<!-- right_navigation_eof //-->

    </table></td>

 

and change it to this:

<!-- right_navigation_eof //-->

    </table></table></td>

 

If it works, great. If it doesn't, hopefully someone else can spot the problem, because I don't see anything else that stands out different.

[Terje]

Amazing!! :o

It seems that this solved the problem :P

 

Thanx a lot :D

 

[Edited]

But the problem are still there when I'm inn product_info and review

[Terje]

And the links under "Informasjon" (Information) try yhe seccond link and look at the flags on the right side. Funny? hehe

 

The script is living a life on it's own LoL

[GraphicsGuy]

Isn't life fun! ;)

 

On the footer problem, on any page exhibiting it, make the same change and that should do it.

 

On the flags issue, when I do that in English they look the same as on the main page. When I change languages to the Norsk, and then click on any info link, other than forum, the flags stack vertically. I don't have any idea why. I only use a single language in mine so I am not the familiar with the effects of multi languages on OSC.

 

One thing else (as if you needed something else), when you click a manufacturer while in English, check out what happens to your currencies box. :o That must be something wrong or missing in english.php I would think.

[Terje]

Yes! This did the trick :D

But the flags is still the clue here. I can try to have a lock in the codes there.

 

And it's correct regatrding currencies -> I don't have currensies for english lang_pack yet. I don't need it either so the only language who will bee there is norwegian (so the flags won't be any problems at all) :P

 

Thanks again for your help :lol:

[SGershon]

ANyway, if the site as it is now has so much design problems, what may say that some files has something wrong; and you didn't changed that much (it seems)... Why don't you just start over from scratch? ;)