Remove a city from being able to purchase product

So in my explorations I’ve found that Magento only has the States stored in the back end, but I don’t want to remove the entire state, just one city in that state. I’ve seen options to include a city option, or remove city drop down, but I can’t seem to find a way to just remove one city.

Am I just over looking something really basic, or am I going to need to dive into the code and log all the cities in every state and then exclude the one city I don’t want to allow to order?

Thanks in advance for reading this, and I’m sorry if I’m asking a dumb question but I just can’t seem to find an answer.

Which road shall I take from Denver, CO to Salt Lake City, UT: I-80 or I-70 w/ US-6?

I’m interested in what route to take between Denver, Colorado and Salt Lake City, Utah, and vice-versa.

http://maps.google.com/maps?q=Denver,+CO++to++Salt+Lake+City,+UT

It would seem like there is one northern option and two southern options.

  • In the north, I-25 in Colorado to Wyoming, and then I-80 throughout Wyoming and into Utah.

  • In the south, I-70 in Colorado, then

    • either SH 13 and SH 64 in Colorado, and US-40 in Utah,
    • or, more I-70 / US-50, through Grand Junction, CO, and US-6 in Utah.

What’s the difference between these ways, and which one is better, or best avoided? I’m driving in the summer (June 2013); interested in a short route; a little scenery wouldn’t hurt; too much engine and tyre wear, bad roads and bad fuel economy is best avoided (driving own car), but high highway speeds are welcome; planning to drive in one or two days, possibly stopping along the highway to get some sleep (spots with night temperatures of around 20°C are welcome, and so are spots where you can get some shade during the daytime). Also, last, but not least, it wouldn’t hurt if the route has some T-Mobile USA UMTS, EDGE or GPRS coverage (without classified as roaming).

As far as Google Maps go, it seems like all three routes are roughly the same, in both the time and the distance, so, looking for some more feedback. For DEN⇆SLC, I’ve so far taken I-80 once when eastbound and I-70 w/ US-6 once when westbound (I’ve only had one SLC⇆DEN trip).

Best summer driving Route from Salt Lake City, Utah, to Houston Texas

We are driving a 1999 Toyota 4-runner with 200,000 miles from Salt Lake City, Utah to Houston, Texas in 24 hours. We will be having a 5×8 U-haul attached to the Toyota. We don’t know whether to go up I-80 to Laramie. Or go south on I-70 through the mountains to Denver. We cannot take a lot of mountain roads, because of the weight of the U-haul.

In the Shackled City, what is the relevance of the polymorphed Otyugh?

In section M4 the party encounter an otyugh polymorphed into an ogre. The encounter is straight to combat, so there is no real way of knowing it is anything other than an ogre, but a dispel magic reveals the true form.

I don’t know 3rd edition, and am reading this because I am trying to convert it to 5e, but what is the relevance of the polymorph, is there something I am missing as to why this isn’t just an ogre, and how are the party supposed to find this out at a time when it could be of any use?

In the Shackled City, what is the relevance of the polymorphed Otyugh?

In section M4 the party encounter an otyugh polymorphed into an ogre. The encounter is straight to combat, so there is no real way of knowing it is anything other than an ogre, but a dispel magic reveals the true form.

I don’t know 3rd edition, and am reading this because I am trying to convert it to 5e, but what is the relevance of the polymorph, is there something I am missing as to why this isn’t just an ogre, and how are the party supposed to find this out at a time when it could be of any use?

What are the plot holes in the Shackled City adventure path?

I am looking to convert the Shackled City adventure path into 5e and one of the things I have found in my research is that the first few chapters don’t necessarily connect very well to the story.

I want to remedy this as part of my planning (Because lack of story information sucks), but reading a 446 page book and trying to tie the whole thing together in my head is a daunting task.

So: what plot threads, NPC’s, factions, groups or other things that a party would usually interact with or be curious about appear (mostly I expect in the early chapters), then vanish with little (or no) explanation only to appear again later on the adventure path?

I don’t mind spoilers (obviously), and if anyone has any suggestions (Backed up by experience in a good subjective/bad subjective way) on how to help avoid these dead ends it would be great, but is outside of the scope of the question.

Want to refactor working methods that return id of inserted row of query for country, city, and address tables

These are the 3 methods and I am just wondering what would be the right way to remove all the duplication? I want to use this example to learn how to do it to clean up the rest of my code. Please note that I am not allowed to use any external libraries or frameworks for this project outside of the standard java libraries. Thank you.

private void handleSaveButton() throws SQLException {     countryId = getCountryId();     cityId = getCityId();     addressId = getAddressId(); }  /**  *  * @return @throws SQLException  */ private long getCountryId() throws SQLException {     getConnection();     param = toTitleCase(countryTextField.getText());     System.out.println("country param: " + param);     String query = "insert into country (country) values (?)";     ps = con.prepareStatement(query, Statement.RETURN_GENERATED_KEYS);     ps.setString(1, param);     try {         ps.executeUpdate();         rs = ps.getGeneratedKeys();         rs.next();         primaryKey = rs.getLong(1);         System.out.println("inserted country id: " + primaryKey);     } catch (SQLIntegrityConstraintViolationException e) {         ps = con.prepareStatement("select countryId from country where country = ?");         ps.setString(1, param);         rs = ps.executeQuery();         rs.next();         primaryKey = (long) rs.getInt(1);         System.out.println("existing country id: " + primaryKey);     } finally {         closeConnection(ps);     }     return primaryKey; }  /**  *  * @return @throws SQLException  */ private long getCityId() throws SQLException {     getConnection();     param = toTitleCase(cityTextField.getText());     System.out.println("city param: " + param);     String query = "insert into city (city, countryId) values (?, ?)";     ps = con.prepareStatement(query, Statement.RETURN_GENERATED_KEYS);     ps.setString(1, param);     ps.setLong(2, countryId);     try {         ps.executeUpdate();         rs = ps.getGeneratedKeys();         rs.next();         primaryKey = rs.getLong(1);         System.out.println("inserted city id: " + primaryKey);     } catch (SQLIntegrityConstraintViolationException e) {         ps = con.prepareStatement("select cityId from city where city = ?");         ps.setString(1, param);         rs = ps.executeQuery();         rs.next();         primaryKey = (long) rs.getInt(1);         System.out.println("existing city id: " + primaryKey);     } finally {         closeConnection(ps);     }     return primaryKey; }  /**  *  * @return @throws SQLException  */ private long getAddressId() throws SQLException {     getConnection();     param = toTitleCase(addressTextField.getText());     System.out.println("address param: " + param);     String query = "insert into address (address, cityId, postalCode, phone) values (?,?,?,?)";     ps = con.prepareStatement(query, Statement.RETURN_GENERATED_KEYS);     ps.setString(1, param);     ps.setLong(2, cityId);     ps.setString(3, postalTextField.getText());     ps.setString(4, phoneTextField.getText());     try {         ps.executeUpdate();         rs = ps.getGeneratedKeys();         rs.next();         primaryKey = rs.getLong(1);         System.out.println("inserted address id: " + primaryKey);     } catch (SQLIntegrityConstraintViolationException e) {         ps = con.prepareStatement("select addressId from address where address = ? and cityId = ?");         ps.setString(1, param);         ps.setLong(2, cityId);         rs = ps.executeQuery();         rs.next();         primaryKey = (long) rs.getInt(1);         System.out.println("existing address id: " + primaryKey);     } finally {         closeConnection(ps);     }     return primaryKey; }