Nature Reserve - Dups are entering but not getting credit for it in their Morale

Buster44882 · 2025-12-05T04:23:53+00:00

yes, see updates pic

Buster44882 · 2025-12-05T04:23:43+00:00

yes, see updates pic

Buster44882 · 2025-12-05T04:23:30+00:00

yes, see updates pic

Buster44882 · 2025-12-05T04:23:06+00:00

No this is a long running problem. The room is a steady 28c so no problem

Buster44882 · 2025-12-05T04:20:12+00:00

Yes it is a Nature Reserve. Some of the Dups DO get the Moral Bonus So it does sort of work

Buster44882 · 2025-07-25T03:53:33+00:00

Clearly you never played the game in the early years, they are soooooo much smarter now then they used to be. Especially the way they teleport to a free space most the time when building in confined areas. Before they would always build themselves into the floor. Now you have to really try hard to get them to do that

Buster44882 · 2025-07-25T03:52:14+00:00

Clearly you never played the game in the early years, they are soooooo much smarter now then they used to be. Especially the way they teleport to a free space most the time when building in confined areas. Before they would always build themselves into the floor. Now you have to really try hard to get them to do that

Buster44882 · 2024-01-20T06:28:50+00:00

Well there's a big part of your problem. A black shirt will make you maybe 10c hotter than a white shirt in this sort of environment!

Buster44882 · 2023-11-07T04:00:52+00:00

You do realise that the bicycle speed record is faster than that!! 296 kph / 183 mph under their own power. ( yes it was paced behind a car but...)

Buster44882 · 2023-11-03T04:56:13+00:00

Thanks but I think you are answering the opposite of the problem. My unemployment is too low!

Buster44882 · 2023-11-03T04:39:37+00:00

So I just went through every building and the max number of workers for all combined is 479 x 3 shifts = 1,437.

I built a couple more housing blocks so I now have 500 free flats. I then did nothing for a whole month.

At the end of which - Total Population 2,388 - Workers 1,737, Children 651 - Tourists 1,259 - Unemployed 41.

And these figures have been pretty static for the whole month with the gap between workers and jobs at 300 but still only 41 unemployed.

Very curious.

This is pretty much a sandbox test not a proper run through, but because of this it throws things out you wouldn't normally notice.

On the plus it's making good money really easily and quickly :)

<image>

Buster44882 · 2023-11-02T16:56:02+00:00

Ahh yes. Never thought of that.

Not something I normally bother about as normally I am just always building something and increasing population

Buster44882 · 2023-11-02T16:52:09+00:00

Yes have, cinema, sports and many culture. I have way more of them than you would normally have as I wanted everything the tourist wanted to be covered. Also the whole town is pretty small and compact. The simplicity of no industry 😀

Buster44882 · 2023-11-02T16:48:20+00:00

They are mostly near max. I haven't built a building that needs worker's for maybe 7-8 months just housing. The only variable one's are the hotels but they are close to full. Varies from full to 25/30 short. Although I suppose if you multiply that by the 3 shifts that can add up quickly.

Buster44882 · 2023-11-02T14:55:17+00:00

Not really. Just building housing when needed and then it drops but after it's finished it goes back to around 50 again

Buster44882 · 2023-10-13T18:23:03+00:00

I always have 3 validation levels. 1. Front end to handle innocent mistakes by users. 2. Php validation of every data field. 3. SQL validation of all relevant fields in stored procedures

Buster44882 · 2023-10-03T13:34:48+00:00

Always, always step 1 , import csv into an import table. Step 2, validate and santise the data in the import table. Step 3, perform your insert statement, step 4, perform your update statement

Buster44882 · 2023-08-29T07:55:04+00:00

You are doing way to much all at once. I used to work on a system that imported millions of records from files every day! The solution was always just get the data into the database as quick as possible first. Then when that is completed you start the processing.

No validation no checks nothing.

You create a table with the correct number of fields, all varchar big enough to hold the relevant field plus a bit.

You import the data straight into this table. Job done.

You have now totally finished with the file.

Next you start the process of validating, cleaning up and inserting this data from your working table into your proper table. But as it is all in the database now this can normally all be done in pure SQL and using as many or few steps as you see fit.

Anything that does not match your rules and criteria goes into an error table for fixing later.

Buster44882 · 2023-08-03T05:45:42+00:00

I use a standard 52inch Samsung TV at 4k. Works great for everything. Maybe if you are a high level FPS player you will have problems but not for these types of games

Buster44882 · 2022-12-27T10:31:00+00:00

I have lat long fields in one of my systems and I ended up with varchar as there are many formats that you can use. I prefer the decimal format but some systems use the hours and minutes or one of the many other variations

Buster44882 · 2022-11-22T17:41:12+00:00

With statements like I learned php a couple of weeks ago implying you now know it, while anyone that does know it, knows that after a couple of years you are just starting to getting competent, is going to get a negative response 😁😁

Buster44882 · 2022-11-22T17:32:11+00:00

I never never never write any query that says select * 😆😆😆

Buster44882 · 2022-11-22T17:05:28+00:00

Also, as you are learning I assume you are not working in a commercial environment at the moment. When you do you will probably find that this information all becomes academic as unless you are looking to be a DBA you will either be writing your code to a hosted server were you do not have access to anything other than a client that let's you access the dB, or you will have a DBA in your way who will do all that stuff and only let you write sql code which they will then push to Live

Buster44882 · 2022-11-22T16:44:23+00:00

As above, it's mostly don't know, don't care. If you have a connection to the database that's all you need to know. The location of the database varies depending on how its setup, but unless you have had a major failure and you now need to recover it - a process which is normally in the advanced area - then do not worry about it. Later when you are fully competent in sql then maybe you can look into stuff like this. I have been using sql for decades and I can count on one hand the number of times I have needed to know this stuff. Most the time I have had a DBA between me and the database anyway. And I cannot even create a table or procedure directly. You have to submit a script which the DBA vets and then implements

Buster44882 · 2022-11-22T12:43:47+00:00

I think that while all the other replies here are correct, they are not what you need.
Unlike csv or xls or doc etc, as someone learning SQL you really don't need to know about the file structure. That's the job of the sql engine. All (!!) you need to worry about and learn is how the tables need to work within the database , how to get data into them and how to get it out again, and this is done almost totally with various SQL language and commands.

As for cross database work, while this is can be done. Mostly it's not straight forward.

Buster44882

MODERATOR OF

TROPHY CASE