Real Eurekas 5.0.1

[Infixo]

Some Eurekas will be hard. This is by design. You are not supposed to get all of them. Having them „practical and always easy to get” defies the purpose of having an eureka in the first place.

 

[Tovarish]

Bronze working: Settle first 2 cities on 5 rainforest tiles. Close to impossible.

 

[Tovarish]

Out of 3 options, I want to choose option A.
"-- INSTRUCTIONS
-- There are 3 lines with INSERT statement. It contains so called 'random seed' that determines what boosts will be selected.
-- Depending on your preference and if you play MP or SP games, uncomment ONLY ONE statement. The other two must be commented out."

- apparently I am too dumb to understand this instruction. What I did was deleting descriptions and all text for options B and C and changed text line for "--INSERT INTO GlobalParameters (Name, Value) VALUES ('REU_RANDOM_SEED', '987654321');" to "--INSERT INTO GlobalParameters (Name, Value) VALUES ('REU_RANDOM_SEED', '987654322');
<-- Please, tell what did I do wrong.

 

[Infixo]

@Tovarish You are supposed only to use comments, not delete anything. Comment in SQLite is a double hyphen at the begining of the line, i.e. --.
So, 2 options should be commented out using --, and the one you want to use must not be commented.

 

[Tovarish]

A suggestion: there is an option to see the trigger when the tech is progressing.
Would it be possible to see the trigger when say 20% tech is complete? Would make complete sense because one has to give thought and only then is possible to have educated guess - what actions might boost the tech or civic.
The purpose for 20% barrier would be avoiding revealing the trigger after very first turn.
More realistic and more competitive way with the AI too.

 

[ezzlar]

This mod makes gameplay a bit more interesting. Two questions:

1. Wouldn´t be more natural to have the eurekas fixed at beginning the game as the default option? When it changes every time you reload it´s like "ok, that´s it for today. Next session I will complete the X and get the eureka for Y." But no, now it´s something else. You can also end up in the situation that you need Feudalism for the Stirrups eureka. But you already have stirrups so you can´t discover it again and the eureka req was something else when you discovered it.
2. I usually play without city states, I guess there is no simple way of deleting CS related boosts?

 

[Infixo]

@ezzlar
ad. 1. the manual option requires you to change the file anyway, so if you want to do so, then you can also change the option. the default option is for people who dont want to mess up with the mod.
ad. 2. theoretically possible, but requires a lot work. you need to remove all boosts and then change sequence numbers to make sure there are no gaps, otherwise a non-existent boost would be assigned. possible, but very tedious.

 

[Infixo]

Works with June 2019 Patch.

 

[Hirwo]

What does it mean to settle a capital on 2 (hills, floodplains) when a city center only takes 1 tile?

Edit: Nevermind. Does it include the tile the city is on? There might be a bug with settling on floodplains for Pottery.

Floodplains_bug

• Hirwo
• Jul 21, 2019

 

[Infixo]

@Hirwo Yes, it includes city center. Basically all plots that belong to a city or cities matter.
Floodplains have changed in GS. Eureka is for „old” floodplains which are now named „desert floodplains”.

 

[Tovarish]

I admit I am still clueless what to do if I want to choose option A.

I do not understand even if I have to open the file in SQLite (browser extension is probably enough but I got error: the text file is not a SQL database file)
OR is it enough to open it in notepad and change the text somehow.

So I want to choose option A.

Could you please edit the text below in a proper way so that option A would stay?

(the following is a quote from RealEurekas_0_Setup file)

-- OPTION A - for SP & MP
-- Use this option when you want to randomize boosts once and play entire game with this set.
-- Enable it and put any number instead of 987654321. As long as this number stays the same, the mod will generate the same set of boosts.
-- Different number will give a different set. Please use numbers that have 6 to 9 digits.
-- This is an option for MultiPlayer games. Select a number and make sure that other players also use the same number.
-- That way all players will have the same boosts and they will stay the same through the entire game.
-- This option is also for SinglePlayer if you want to play entire game with the same set of boosts.

--INSERT INTO GlobalParameters (Name, Value) VALUES ('REU_RANDOM_SEED', '987654321');



-- OPTION B - for SP
-- This option rolls randomly new set of boosts each time the game is started or re-loaded.
-- It is basically the same as the mod has been working so far.
-- If you don't mind that boosts change very often then use it.
-- Please do NOT change anything in the statement (except comment ofc).

--INSERT INTO GlobalParameters (Name, Value) VALUES ('REU_RANDOM_SEED', STRFTIME("%d%H%M%S"));



-- OPTION C - for SP
-- This option rolls randomly new set of boosts but it will change every day.
-- If you start a new game or reload a game within the same day - the boosts will be the same.
-- This option is for people who don't like when boosts change every time the game is reloaded, but would like some variety. New day - new boosts
-- Please do NOT change anything in the statement (except comment ofc).

INSERT INTO GlobalParameters (Name, Value) VALUES ('REU_RANDOM_SEED', STRFTIME("%Y%m%d"));


////////////////////////////
I am certain most people are unable to use those options as you intend. I ask you to consider 3 seperate versions of Real eurekas, that are already usable without messing with SQLite.

 

[Atlas627]

You can just open it in Notepad and make the edit. It may not seem straightforward to someone who does not mod or even code at all, but it really is that easy to change.

 

[Tovarish]

You can just open it in Notepad and make the edit. It may not seem straightforward to someone who does not mod or even code at all, but it really is that easy to change.

Would you care to give me an example how the text shall look like please?

The text is copied from Setup file above.

 

[Atlas627]

Would you care to give me an example how the text shall look like please?

The text is copied from Setup file above.

Can you tell me the filepath of the file so I can look at the whole file myself to make sure I give you the correct info?

 

[Tovarish]

Can you tell me the filepath of the file so I can look at the whole file myself to make sure I give you the correct info?

Of course.
The file "RealEurekas_0_Setup" is located in:

C:\Users\Tovarish\Documents\My Games\Sid Meier's Civilization VI\Mods\Real Eurekas (v4.0.1)\Real Eurekas

 

[Infixo]

Works with September 2019 Patch.

 

[Tovarish]

Writing: To boost: meet 4 city-states.
Well, this boost I got at the very first turn even before my 1st city was settled.
It also had weird description: "The ingenuity of your great person has unlocked new scientific ideas" - it has nothing to do with city states.

Clearly, something is very wrong with this particular boost.

 

[Atlas627]

@Tovarish Ok so you can open up the Setup file in any text editor and make the change. By default, the line at the bottom after "Option C" which says "INSERT INTO..." is the only one that is doing anything in this file. All of the other lines are simply comments, which you can determine by the "--" at the beginning of each of them. To pick a different option, insert the "--" in front of Option C's "INSERT INTO" line, and remove the "--" from the "INSERT INTO" line from the option you actually want to use. So to pick option A...

Spoiler Option A Example :

--------------------------------------------------------------
-- Real Eurekas
-- Author: Infixo
-- 2019-03-14: Created
--------------------------------------------------------------



-- INSTRUCTIONS
-- There are 3 lines with INSERT statement. It contains so called 'random seed' that determines what boosts will be selected.
-- Depending on your preference and if you play MP or SP games, uncomment ONLY ONE statement. The other two must be commented out.



-- OPTION A - for SP & MP
-- Use this option when you want to randomize boosts once and play entire game with this set.
-- Enable it and put any number instead of 987654321. As long as this number stays the same, the mod will generate the same set of boosts.
-- Different number will give a different set. Please use numbers that have 6 to 9 digits.
-- This is an option for MultiPlayer games. Select a number and make sure that other players also use the same number.
-- That way all players will have the same boosts and they will stay the same through the entire game.
-- This option is also for SinglePlayer if you want to play entire game with the same set of boosts.

INSERT INTO GlobalParameters (Name, Value) VALUES ('REU_RANDOM_SEED', '987654321');



-- OPTION B - for SP
-- This option rolls randomly new set of boosts each time the game is started or re-loaded.
-- It is basically the same as the mod has been working so far.
-- If you don't mind that boosts change very often then use it.
-- Please do NOT change anything in the statement (except comment ofc).

--INSERT INTO GlobalParameters (Name, Value) VALUES ('REU_RANDOM_SEED', STRFTIME("%d%H%M%S"));



-- OPTION C - for SP
-- This option rolls randomly new set of boosts but it will change every day.
-- If you start a new game or reload a game within the same day - the boosts will be the same.
-- This option is for people who don't like when boosts change every time the game is reloaded, but would like some variety. New day - new boosts
-- Please do NOT change anything in the statement (except comment ofc).

--INSERT INTO GlobalParameters (Name, Value) VALUES ('REU_RANDOM_SEED', STRFTIME("%Y%m%d"));

Edit: Note that option A uses the same seed every time to give you a random set of boosts. That is what lets it give you the same ones on reload every time too. But to get a NEW random set of boosts, you will need to change the seed in the setup file every time you start a new game. So for example...

INSERT INTO GlobalParameters (Name, Value) VALUES ('REU_RANDOM_SEED', '987654321');

should be replaced with

INSERT INTO GlobalParameters (Name, Value) VALUES ('REU_RANDOM_SEED', '123456789');

or any other 9-digit number. If you want to play multiple games with different consistent random boosts simultaneously, you will need to remember which games used which seeds and swap the seed back and forth between loads.

 

[ezzlar]

Writing: To boost: meet 4 city-states.
Well, this boost I got at the very first turn even before my 1st city was settled.
It also had weird description: "The ingenuity of your great person has unlocked new scientific ideas" - it has nothing to do with city states.

Clearly, something is very wrong with this particular boost.

Playing Dido?

 

[Tovarish]

@Tovarish Ok so you can open up the Setup file in any text editor and make the change. By default, the line at the bottom after "Option C" which says "INSERT INTO..." is the only one that is doing anything in this file. All of the other lines are simply comments, which you can determine by the "--" at the beginning of each of them. To pick a different option, insert the "--" in front of Option C's "INSERT INTO" line, and remove the "--" from the "INSERT INTO" line from the option you actually want to use. So to pick option A...

Spoiler Option A Example :

--------------------------------------------------------------
-- Real Eurekas
-- Author: Infixo
-- 2019-03-14: Created
--------------------------------------------------------------



-- INSTRUCTIONS
-- There are 3 lines with INSERT statement. It contains so called 'random seed' that determines what boosts will be selected.
-- Depending on your preference and if you play MP or SP games, uncomment ONLY ONE statement. The other two must be commented out.



-- OPTION A - for SP & MP
-- Use this option when you want to randomize boosts once and play entire game with this set.
-- Enable it and put any number instead of 987654321. As long as this number stays the same, the mod will generate the same set of boosts.
-- Different number will give a different set. Please use numbers that have 6 to 9 digits.
-- This is an option for MultiPlayer games. Select a number and make sure that other players also use the same number.
-- That way all players will have the same boosts and they will stay the same through the entire game.
-- This option is also for SinglePlayer if you want to play entire game with the same set of boosts.

INSERT INTO GlobalParameters (Name, Value) VALUES ('REU_RANDOM_SEED', '987654321');



-- OPTION B - for SP
-- This option rolls randomly new set of boosts each time the game is started or re-loaded.
-- It is basically the same as the mod has been working so far.
-- If you don't mind that boosts change very often then use it.
-- Please do NOT change anything in the statement (except comment ofc).

--INSERT INTO GlobalParameters (Name, Value) VALUES ('REU_RANDOM_SEED', STRFTIME("%d%H%M%S"));



-- OPTION C - for SP
-- This option rolls randomly new set of boosts but it will change every day.
-- If you start a new game or reload a game within the same day - the boosts will be the same.
-- This option is for people who don't like when boosts change every time the game is reloaded, but would like some variety. New day - new boosts
-- Please do NOT change anything in the statement (except comment ofc).

--INSERT INTO GlobalParameters (Name, Value) VALUES ('REU_RANDOM_SEED', STRFTIME("%Y%m%d"));

Edit: Note that option A uses the same seed every time to give you a random set of boosts. That is what lets it give you the same ones on reload every time too. But to get a NEW random set of boosts, you will need to change the seed in the setup file every time you start a new game. So for example...

INSERT INTO GlobalParameters (Name, Value) VALUES ('REU_RANDOM_SEED', '987654321');

should be replaced with

INSERT INTO GlobalParameters (Name, Value) VALUES ('REU_RANDOM_SEED', '123456789');

or any other 9-digit number. If you want to play multiple games with different consistent random boosts simultaneously, you will need to remember which games used which seeds and swap the seed back and forth between loads.

It is easy as childsplay! THANK YOU VERY MUCH! This explanation is logical, easy to understand and easy to implement!
However, I am no programmer and without this explanation it is no wonder I would have no clue what to do.
I am certain and I ask Infixo to consider to put this explanation into main description page.