CCTP We need you, we need support.

[Pioneer Boyscou]

FINALLY!

Which now brings me back to my original question:
Since in the real world there is not a technology called Maximus, I had to make something up.
Is this OK?
Maximus, also called Maximus Tyrannus, was a Roman usurper (409 - 411) in Hispania (the Iberian Peninsula - modern Spain and Portugal). With this technology it was possible to build Roman Circus, as well as the hippodromes (Greek: ἱππόδρομο&#962, which was an ancient Grecian stadium for horse racing and chariot racing.

If yes, I will start creating the texts... in SDK, right the way you requested.

 

[Pioneer Boyscou]

well.. I assume I am doing it right this time. Let's see if I can make it ready by Monday.

 

[gyogen2]

Gilga is probably busy, and hasn't had time to reply yet. I can't say for sure exactly what he ahs in mind for all the techs, but what you are doing looks good so far.

 

[Pioneer Boyscou]

I am advancing with these and I think I actually am on a right track with these.

But then there are some odd titles.

Spoiler :

For example tech called Exploration. I feel it is something that you do with the scouts or ships. But it allows you to build hotels and ski resorts. Shouldn't the tech be then named tourism instead?

 

[Artisanix]

Well, decided to give it a go, and remade couple of splashes for wonders, especially for this project. Are you interested in such kind of a style? Should I continue? ;>

 

[Gilgamesch]

I am advancing with these and I think I actually am on a right track with these.

But then there are some odd titles.

IIRC there is already a Tourism technology, at least in some hidden file, it creates some issues time ago.

Well, decided to give it a go, and remade couple of splashes for wonders, especially for this project. Are you interested in such kind of a style? Should I continue? ;>

All help is welcome, but we have still some wonders that miss a splash or in the worst case the splash is years old and needs a new rework.

Since i started with arts, i added a bunch of them but just splashes no digital rework or so what

 

[Artisanix]

Since i started with arts, i added a bunch of them but just splashes no digital rework or so what

If you could list specific wonders that need a rework then I could start with them first, otherwise I can proceed "randomly" with the splashes - the point is whether you want to use some of these I've shown, and in similar style. If not, then I won't bother with this that much ;]

As for graphic I can do other things as well (see attachment - I have such Icon Atlases for over 200 various wonders already made for my personal project).

And your mod needs SQL, I can do that as well ;] (see first link in my sig).

 

[Gilgamesch]

If you could list specific wonders that need a rework then I could start with them first, otherwise I can proceed "randomly" with the splashes - the point is whether you want to use some of these I've shown, and in similar style. If not, then I won't bother with this that much ;]

As for graphic I can do other things as well (see attachment - I have such Icon Atlases for over 200 various wonders already made for my personal project).

And your mod needs SQL, I can do that as well ;] (see first link in my sig).

Sorry for the late response iam very busy.

Since the icons for CCTP are all finished (dont ask me how many something over 800 now), there are still some Splashes like i said (i need the time to get a list of the ones that need a rework) and images for the policy branches that we need.

For the SQL, yes we use XML and SQL..
This is related to many factors and i know that SQL is much better to handle then XML.
But i dont have the time to change that many files from XML into SQL.

What really needs attention are the resources, this files should all be merged into one SQL file.

The most important part, that needs to be done is a complete rework of the flavors, which also is the reason for some strange ai behaviors, but with more then 5000 entries this is a huge project.

Nearly all flavors are already SQL files, only the ones from other mods/addons can be XML.

 

[Artisanix]

Sorry for the late response iam very busy.

Just take your time, I don't mind. I have many other things to do as well ;]

This is related to many factors and i know that SQL is much better to handle then XML.

Hm, from my experiences it is not just "much better", but for bigger project is A MUST. You have so much work with this mod because XML files simply hold you back

But i dont have the time to change that many files from XML into SQL.

The point is that you don't need to touch any of XML files at all to have almost all content converted to SQL. The game uses SQLite database, and loads all those information by itself. In short, all you need to do is to enable you mod, copy game's merged database file (core data + your mod's data), and with the tool like SQLite Manager (plugin for Firefox) you can browse through tables, delete, update, add data. You can export whole tables to SQL queries that are fully compatible with the game. You can export the data to CSV and process it in Excel, etc.
Many information are visible right away, so to control and manage everything for your mod, you don't even need to test things in game or inspect the logs that often.

As for XML files, well... these are mostly useless here - you only look at them to check whether everything has been properly imported to database, and if it so, then you may get rid of them for good

And this all is not just a theory, it really works, and makes a life of a modder much much easier - and you definitely deserve this Gilgamesch after so many years of hard work with maintaining this project

Just an example: it took me one day to combine 170+ different mods with wonders to one mod based on SQL, and fix all the issues or missing info. And additional three days were needed to process graphic, and other things.
Summary of this:
- downloaded content: folders > 1000, files > 2000, size on disk > 1.3 GB
- final merged mod: folders = 9, files = 289, size on disk: ~83 MB.
Nice, isn't it? Well, without SQL I wouldn't even bother to do such a thing at all.

What really needs attention are the resources, this files should all be merged into one SQL file.

Then PM me them if you like. I can convert any XML you throw at me to SQL in no time* ;]

* well, almost ;]

The most important part, that needs to be done is a complete rework of the flavors, which also is the reason for some strange ai behaviors, but with more then 5000 entries this is a huge project.

I presume that it will be more handy for you to edit all those data in Excel? If so we may discuss how to convert it there and back again, if you like ;]

Nearly all flavors are already SQL files, only the ones from other mods/addons can be XML.

As I mentioned, it doesn't matter what files you have on disk. The game uses only the data from database - so if you open Civ5DebugDatabase.db file with SQLite MGR after the game processes the data from the mods you have enabled - then you can export all merged content to .sql file. Merged content means: original content + .sql files from your mod + data from other mods with xml files. And it is easy to delete original content, so this way you have "all that hard" work with all those merging done by the game itself ;]

 

[gyogen2]

I have a file where I had converted the database (used it for some sqls I converted) I hadn't converted everything because Gilga was still working on files, and he seemed to prefer working in xml before.

But I can say it is pretty easy to convert. However, when doing so, you may want to disable the dll mod as a dependency, and load the game w/o it, or make sure you also remove all the related entries, because the dll mod will still need to be ran when playing, and duplicate entries causes issues.

Also, you won't need to remove all the vanilla stuff, many tables in cctp replace vanilla, so just need to add the "drop table" command above "create table"

 

[Artisanix]

gyogen, You're right with all this stuff, and those are details of working with SQL.
Though my point is not about technical differences that much, but rather how more convenient (easier, faster, more accurate) is to process, maintain, and work with all those data by using SQL than XML.


But now... something completely different.
I've gave it a shot and remastered tech images a bit. Had no idea whether some of these are placeholders (I suppose so), but I processed all of them anyway. The goal was to make images more uniform in colour and to better blend with default UI.
Are these any good? Do you want dds files then?

 

[Pioneer Boyscou]

DONE!
With them tech translations.
There were, however, couple, that I was not sure enough what they were.

Spoiler :

Supply Management
Nephelin
Budda
Supply Management
Environment
Exploration (how about Attractions or Toursim Attractions?)
Poseidon
Military Confrontation
Grand Idea
Gravitation? (I think it was there already, but there is still "upps"
Vertical Integration
Doctrine Initiative
Conversation
Ancient Machinery
Stones
Astaria
Melting
Waterworking

The actual file is https://dl.dropboxusercontent.com/u/20825496/CCTP_Text_Technologies.xml (if I was able to do it correctly.)

Please review my file and text and see if there is anything you need me to change/fix.

 

[gyogen2]

Just so you know, the file does not seem to be there:

Not Found

The requested URL /here. was not found on this server.

 

[Artisanix]

File is there but you need to make a simple trick to download it ;]

Anyway, here is the fixed link: file.

Pioneer Boyscou, just exchanged url with the text.

 

[gyogen2]

gyogen, You're right with all this stuff, and those are details of working with SQL.
Though my point is not about technical differences that much, but rather how more convenient (easier, faster, more accurate) is to process, maintain, and work with all those data by using SQL than XML.


But now... something completely different.
I've gave it a shot and remastered tech images a bit. Had no idea whether some of these are placeholders (I suppose so), but I processed all of them anyway. The goal was to make images more uniform in colour and to better blend with default UI.
Are these any good? Do you want dds files then?

They look good to me

I'm not sure as to most of the originals, but the prehistoric ones were just placeholders I put in when I redid the lua.

I actually prefer working with sql, so you won't get any arguments from me.

 

[Gilgamesch]

The download link for the text files seems still broken;(

Yes the pictures are very nice

The images are from the time when chrome was still working on the mod.
Since that time a lot of technologies are added and some branch images should be replaced, because they doesnt fit with all the technologies in it.

Back to the SQL discussion, as much as i like to change the XML files into SQL, i need to say that i would prefer to finish my current work.

Its so hard for me to keep the overview of all the new content, that any changes yet would make me crazy

For this i will try to push my work forwards, and would upload my changes in the next days (maybe next week it depends on my free time).

While i still need to write (endless) flavors (did i said that i hate to write flavors), i would really appreciate if someone else could convert the XML files in SQL (if needed).

With the time i would need to do it (yes iam a XML nerd), i could do other thing like the flavors.

 

[gyogen2]

I already have a file with many of the tables converted, however most will probably be obsolete when we add new changes.

I could do it if you like, however if Artisanix wanted to do it, that is fine with me.

Also, if you want to use new images, I can add them to the build if Artisanix wants to sen me a link.

 

[Artisanix]

I'm not sure as to most of the originals, but the prehistoric ones were just placeholders I put in when I redid the lua.

The prehistoric ones are quite decent, because those landscapes fit together nicely. However I think I'll rework half the others, to better match.

The download link for the text files seems still broken;(

I posted fixed version two posts below ;]

Yes the pictures are very nice

The images are from the time when chrome was still working on the mod.
Since that time a lot of technologies are added and some branch images should be replaced, because they doesnt fit with all the technologies in it.

All I need then are the technology names. Are those from 4.05 accurate? Or with the version you have something has changed?

Back to the SQL discussion, as much as i like to change the XML files into SQL, i need to say that i would prefer to finish my current work.

No pressure there ;] If you have your goals set, finish them first.

While i still need to write (endless) flavors (did i said that i hate to write flavors), i would really appreciate if someone else could convert the XML files in SQL (if needed).

With SQL this task can be almost automated, because all data can be processed in Excel or similar program. And spreadsheet can be set with functions that do almost all job for you:
- first column has Building Types listed (you use it as reference which building is that),
- second one has flavor types, which you can choose from the predefined list,
- third column will be with the simple list which indicates how much this building favors particular flavor (e.g. minor, moderate, major, immensely), and each option will put certain values in the last column flavor value.
In such spreadsheet you don't have to write anything at all, but only choose values from lists for two columns - flavor type, and how strong the flavor is.
You can even use conditional formating to highlight incorrect values in red to quickly spot oddities or something.

After you finish to review all things this way, then it's easy to convert such data to one .sql file which you include in your mod.

With the time i would need to do it (yes iam a XML nerd), i could do other thing like the flavors.

Technically I could help you with those flavors ;] All I need is to have the current version of game's database with your mod enabled (file Civ5DebugDatabase.db from cache folder - make sure to copy this file while you're in game with your mod enabled after the game processes the data!).
So the final decision is yours ;] Whether you want to do those flavors your known way, or you may want to try Excel like approach with SQL behind the scenes ;]
And I can make such Excel file for you too, though I need that db file for this to provide the most accurate data.

 

[Pioneer Boyscou]

So, all is good now with that tech translation file?

 

[Gilgamesch]

So, all is good now with that tech translation file?

For some reasons your link and the other link provided above are not working for me.

So please post the link again.