Is the randomised list meant to be the same each time? Because every game I've had so far, each civ's city name list—although reordered—repeats itself each game. Is this a glitch or intentional?

>oakland

Even if I change <AffectsSavedGames>0</AffectsSavedGames> to 1, delete cache, start a new game, the game still can't be loaded after saving. Moded civs don't randomize, only vanilla

You need to start a new game after the change is made.

"<AffectsSavedGames>0</AffectsSavedGames> when I changed this to 1, I couldn't load saved game

I'm only using this mod, Hunnic city names and Iroquian city names when it comes to this. Maybe your mod just doesn't reach the custom civilizations I install?

Is it possible you're using whoward69's "Global - Random City Names" or an earlier version of this mod? In which case, it will only randomize mod civs if you're lucky and they happen to be loaded before the mod.

I also just noticed that I didn't enable "Affects saved games" for this mod (which should have been enabled; I wasn't clear at the time what that feature entailed). This oversight could cause issues between saves and loads if, e.g., you don't always load your saves from the mods menu rather than the main menu (which you should always do, BTW, even though it can be time consuming), or if your mod loadout was changed in any way. I'll update soon to fix that oversight, but you can also just edit the .modinfo file and change "<AffectsSavedGames>0</AffectsSavedGames>" from 0 to 1.

Not on them all tho. Not the over 20 historical civs I've tried...

@Foxforch: It does.

It would be nice if this was working on mod civilizations too.

It's on CivFanatics, but the site is down at the moment. There's also a certain non-Valve website that shall go nameless, but it lets you copy the URL of a STEAM WORKSHOP mod and lets a DOWNLOADER get it directly from a .COM address. ;-)

Workshop doesn't feel like downloading it; any chance of a direct download link?

This mod is always so enjoyable, thanks for it.

@Nutzzz: Thanks, I didn't think there would be.

@Scutshakes: I don't know of compatibility issues with ANY mod.

Does this work fine with CBP?

@Nutzzz,
I think this is what I did. Anyway, I will test it again. Thanks.

Look at the original v2 again. You need to run it once for all the civs that have been added up to that point, and set up a trigger to run it again any time a new city is added to the game by another mod after that point. Short answer: Replace lines 5-10 and 16-21 of the original with copies of the code you posted.

I need some help. I would like to keep not only the capital, but also the first 8 cities before the randomizing begins. I found this code on CivFanatics, and inserted this into the sql file:
CREATE TABLE Civilization_CityNames_Temp AS
SELECT * FROM Civilization_CityNames c
WHERE rowid IN (
SELECT rowid FROM Civilization_CityNames n
WHERE c.CivilizationType = n.CivilizationType ORDER BY rowid ASC LIMIT 3
);
This works, but when I add this line to the code for custom civs, it does not work. What am i doing wrong?

Hm. Works for me.

I'm finding this suddenly stopped working in the last month or two. Is it just me?

@Dong:
In SQL syntax, 2 hyphens (--) means that everything following those characters until the end of that line of text is a "comment" and should not be processed.

See line 26 of the file:
"--Use the following instead if you want to randomize the capital as well:"

Make all the lines that are before line 26 comments by adding "--" before (or you can just delete them entirely if you like). Then uncomment (delete the -- in front of) lines 29 through the end of the file except for line 34 (i.e., all of the actual commands that start with capital letters).

@Nutzzz

"Look at the sql file; it's already in there. Just delete the top half and uncomment the bottom half."

I'm looking at the .sql file, but I have literally no idea what to do, considering I'm fucking stupid. Please help.

Thanks

Look at the sql file; it's already in there. Just delete the top half and uncomment the bottom half.

Seems to work, I tried it with Scotland and it randomized the city names. What would be the easiest way to also make it randomize the capitol (could that lead to issues?)

@Yotsuba: Can you give the new version a try with a bunch of modded civs? This could affect load time a bit. Let me know.

I'll give that a try, but you updating it sounds great as well. Thanks!

@Yotsuba: If the order you're checking the circles doesn't seem to help, you might try deleting this mod from your mods folder and then unsubscribe and resubscribe.

However, I was planning on updating this mod to add a SQL trigger so users wouldn't have to worry about that. Thanks for the reminder, I'll look into it soon.

"Should be compatible with new civilization mods as long as this mod is activated after the new civ mod." What exactly do you mean? Activated after? I'm trying to get it to work but I'm having trouble, I downloaded a lot of fanmade CIVs and then this but it doesn't seem to work. I also replaced the code with the one you posted below to randomize the capitol as well.

thanks! now game looks so fresh. this should be in advanced settings.

@anom9n: Just replace the contents of RandomCities.sql with the following code instead:

CREATE TABLE Civilization_CityNames_Temp AS SELECT * FROM Civilization_CityNames;
DELETE FROM Civilization_CityNames;
INSERT INTO Civilization_CityNames SELECT * FROM Civilization_CityNames_Temp ORDER BY RANDOM();
DROP TABLE Civilization_CityNames_Temp;

i want to randomize capitals as well :(

@Nutzz: Hey, that actually fixed the problem for me. Thanks a ton, you're awesome!

@Sloth: Try clearing your cache. You'll have to reactivate all of your mods, though, so if you have a lot you might want to make a list first.

See this thread [forums.civfanatics.com] for instructions to clear your cache, and other common troubleshooting steps for CiV mods.

For some reason this mod is not showing up in my in-game mod list after subscribing. Would really like to use it. :(

It seems this mod does not work somtimes. could just be me though because some of the poland city names seem so random to me and same with some of the other civs. Maybe they are real names though.

Never travel to New Zealand then Mr. Saint if that's the case. Anyway, chiming in here to say "Cheers cuz", because I love playing with this mod. Super cool on TSL maps.

I call it SanfranSICKO because the city is full of sodomites! And Ghetto trash that say words like "Cuz"

I haven't experienced that. Are you sure it's this mod causing the bug?

Are there any plans to update this for BNW? It causes some bugs with trade routes and such.

Good! I cant stand NY, LA, and Sanfransicko always being my first few cities!

Thanks for the confirmation. That's unfortunate.

i hope, i switched tomboktu to timbuktu and got another tomboktu on my 3rd city. i was like "wtf"?

A www. .. Still, thanks.

I'm not sure, as I don't typically rename cities. Because the list is randomized on game creation and not on city creation, you may still see that behavior.

Ohh... This would also keep the same name from coming up repeatedly if you rename a city, wouldn't it? :D

Very useful for testing a mod with a long list of city names; who's got the time to found 30+ cities without a cheat tool? :)