EU Countries (Out of date)

For Articles relating to more than one ISC version
Post Reply
Martin
Site Admin
Site Admin
Posts: 1854
Joined: Wed Jun 17, 2009 6:30 pm
Location: South Yorkshire UK
Contact:

EU Countries (Out of date)

Post by Martin »

This most likely won't affect everyone but in the process of tweaking my KashFlow accounting module for ISC I discovered that it wasn't marking customers from EU states as actually living there.

It was only when I dug into the isc_countries db table that I realised that someone really didn't do their homework...

While Bulgaria (added to EU in 2007) was set with a countrycouregid value corresponding to the EU region, there were a slew who joined as early as 1973 that weren't.

Typical sloppy work but here's a fix for those where it matters...

Code: Select all

UPDATE isc_countries SET countrycouregid = 1 WHERE countryid IN (33, 176, 193, 194, 21, 171, 103, 150, 225, 199, 58, 205, 57, 56, 105, 67, 83, 73, 132, 72, 117, 97, 80, 124, 123, 14, 172)
Of course that fix relies on you not having messed with the countries table and the values not changing during some ISC update.


EDIT: Looking into this further it seems that some island states are also part of the EU, including places like Reunion, Gibraltar, Guadaloupe, etc... so there's further edits pending... I soooo love politics... :roll: :?

Martin
Site Admin
Site Admin
Posts: 1854
Joined: Wed Jun 17, 2009 6:30 pm
Location: South Yorkshire UK
Contact:

Re: EU Countries (Out of date)

Post by Martin »

For the island states (already in the DB) here's an amended code nugget:

Code: Select all

UPDATE isc_countries SET countrycouregid = 1 WHERE countryid IN (97, 150, 172, 117, 225, 193, 194, 176, 58, 57, 56, 175, 205, 105, 199, 103, 171, 21, 83, 72, 134, 73, 132, 242, 82, 74, 80, 67, 33, 14, 86, 123, 124)

Martin
Site Admin
Site Admin
Posts: 1854
Joined: Wed Jun 17, 2009 6:30 pm
Location: South Yorkshire UK
Contact:

Re: EU Countries (Out of date)

Post by Martin »

Had to laugh at the timing of my post yesterday and the fact that the EU suddenly did a belly up routine on the UK...

Conspiracy theories that Interspire staged this coup d'etat to hide their embarrassing omission over EU country membership in the Interspire Shopping Cart product have been strenuously denied...

...but do you believe them?!!! :o :shock: :roll:






ROFLMAO... :lol: :twisted:

Post Reply