Only minor functionality changes here, as almost everything was behind the scenes. The main thing is that the two text boxes for user and region are now drop-downs populated from the DB.

Next up is system.php, which needs almost identical changes to what I just did for region.php. Not sure when I'll get to that, busy couple days coming up. After that, only the shields/clinched.php page needs updating to complete my initial reorg/refactoring/cleanup/enhancement phase.

There's a andcg (well, the main tunnel route into Andorra that doesn't have a CG number) route in France to connect it to the French network: http://tmtest.teresco.org/hb/?r=fra.tunenvAs such, the system will appear.

OSM indicates that it's CG2 on Andorran territory. I guess it's minimum correct about the tunnel and I think it should be part of Andorra region only. Just my 2c.