The size now works, so thanks Nutty 
!!
Still having probs with the slinger's sound and the Heqetai; will experiment further tomorrow.
!!Still having probs with the slinger's sound and the Heqetai; will experiment further tomorrow.
Add a new unit in the game (using SQL)
- Thread starter Gedemon
- Start date
Nutty
Deity
As for the Heqetai, the part you haven't posted is your entries for the Units table. I assume you've made sure UnitArtInfo is set to ART_DEF_UNIT_HEQETAI?
I have indeed. In the units.xml, I've used the tag:
<UnitArtInfo>ART_DEF_UNIT_HEQETAI</UnitArtInfo>
JFD
Kathigitarkh
Having successfully implemented a unique skin for a unit, I was wondering now how to make said unit use the sounds of its replacement: the Marine.
Nutty
Deity
JFD
Kathigitarkh
Thanks very much.
I've sorted out the Heqetai, and, as these things often are, the solution was staring me in the face. I needed to use "ART_DEF_UNIT_U_GREEK_HOPLITE" and "ART_DEF_UNIT_MEMBER_U_GREEK_HOPLITE". Adding the extra "U_" made all the difference and so now I'm up and running!
The next thing for me to try is to add a unit as a flavour unit rather than an actual unit in the game; there's the code earlier in the thread, so I'll get experimenting. Thanks again to Nutty in particular (as well as everyone else who helped).
The next thing for me to try is to add a unit as a flavour unit rather than an actual unit in the game; there's the code earlier in the thread, so I'll get experimenting. Thanks again to Nutty in particular (as well as everyone else who helped).
I have a strange problem. I noticed that when I got done with my units and testing them in game, they cannot be purchased with faith. So, I added FaithCost, RequiresFaith PurchaseEnabled, to the unit SQL. However for some reason my Arabian Longswordsman end up in the civilopedia as a religious unit. Do you have any idea why this would be?
Here is my SQL code for that unit. It is the first one I have tried to change by adding add a faith purchase cost.
Am I missing anything that should be added? Is this updated code for GnK? Anyway, since this mod is in a time of religious upheaval, the units should be able to be purchased with faith like any unit in the game from the Medieval era. I just want them to be listed in the right place in the unit civilopedia. All units should be listed in the Medieval era, not in the religious category with missionary and the inquisitor.
For this Mod all I have added is ethnic units to civs, a pike, crossbow, knight, and longsword with the unit graphics currently available from danrell.
Here is my SQL code for that unit. It is the first one I have tried to change by adding add a faith purchase cost.
Spoiler :
Am I missing anything that should be added? Is this updated code for GnK? Anyway, since this mod is in a time of religious upheaval, the units should be able to be purchased with faith like any unit in the game from the Medieval era. I just want them to be listed in the right place in the unit civilopedia. All units should be listed in the Medieval era, not in the religious category with missionary and the inquisitor.
For this Mod all I have added is ethnic units to civs, a pike, crossbow, knight, and longsword with the unit graphics currently available from danrell.
Hypereon
He was a Consul of Rome!
Hi! I have been doing successful custom units with this tutorial, but now I have a problem. Does anybody know how to add new units which have several (4) different unit members?
I've been trying to make a Bandeirante unit for my Portugal mod that consists of a "leader soldier", "basic soldiers", "native soldiers" and a flagbearer. Could somebody help me to get it working, because I can't relly do/understand SQL myself, apart from a basic one-member unit creation? Bandeirante uses a Great Artist as a base unit, with musketeer, minuteman, musketman and the great artist flagbearer as the member models. In the game, it just shows up as a "invisible" unit. Here's the code:
I've been trying to make a Bandeirante unit for my Portugal mod that consists of a "leader soldier", "basic soldiers", "native soldiers" and a flagbearer. Could somebody help me to get it working, because I can't relly do/understand SQL myself, apart from a basic one-member unit creation? Bandeirante uses a Great Artist as a base unit, with musketeer, minuteman, musketman and the great artist flagbearer as the member models. In the game, it just shows up as a "invisible" unit. Here's the code:
Spoiler :
Sorry, I can't help with that, hopefully someone else have the answer.
When adding entries that are not based on part of another unit (IE all columns have new values), you should use a simple:
Code:
INSERT INTO tablename (column1, column2, ...) VALUES ('string1', number, ...);example:
Code:
-- V1
INSERT INTO ArtDefine_UnitInfoMemberInfos (UnitInfoType, UnitMemberInfoType, NumMembers)
VALUES ('ART_DEF_UNIT__WARRIOR_SONGHAI', 'ART_DEF_UNIT_MEMBER_WARRIOR_ZULU_IMPI', 3);
-- V2
INSERT INTO ArtDefine_UnitInfoMemberInfos (UnitInfoType, UnitMemberInfoType, NumMembers)
VALUES ('ART_DEF_UNIT__WARRIOR_SONGHAI', 'ART_DEF_UNIT_MEMBER_WARRIOR_ZULU_IMPI_V2', 2);
-- V3
INSERT INTO ArtDefine_UnitInfoMemberInfos (UnitInfoType, UnitMemberInfoType, NumMembers)
VALUES ('ART_DEF_UNIT__WARRIOR_SONGHAI', 'ART_DEF_UNIT_MEMBER_WARRIOR_ZULU_IMPI_V3', 3);
-- V4
INSERT INTO ArtDefine_UnitInfoMemberInfos (UnitInfoType, UnitMemberInfoType, NumMembers)
VALUES ('ART_DEF_UNIT__WARRIOR_SONGHAI', 'ART_DEF_UNIT_MEMBER_WARRIOR_ZULU_IMPI_V4', 2);Also note that the tutorial had sadly a bad SQL syntax about the use of double-quotes, please refer to the now corrected code in post #1 and #6 of the thread (see here for details), they should only be used when SQL reserved keywords are used as table or column name (like the column named "Index" in post 6)
For your problem itself, the code you use seems to be correct, so try first with an ART_DEFINE_UNIT_MEMBER_* that you know is working in game for all slot.
Hypereon
He was a Consul of Rome!
Thanks!
So, should I use "INSERT INTO tablename (column1, column2, ...) VALUES ('string1', number, ...);" for doing the base Bandeirante unit, instead of the Great Artist. I will also try the corrected codes in the first posts.
I'll try these later this day, and 'll post then whether I got them working.
So, should I use "INSERT INTO tablename (column1, column2, ...) VALUES ('string1', number, ...);" for doing the base Bandeirante unit, instead of the Great Artist. I will also try the corrected codes in the first posts.
I'll try these later this day, and 'll post then whether I got them working.
@Gedemon, It's ok I figured out the problem. The solution was obvious, surprised you did not notice what I did wrong. 
You cannot add values, to those values already linked to a unit, you' re replacing. Otherwise, it thinks the unit is unique. That is why my Arabian Longsword was set apart and made into a religious unit.
Ok, if anyone is adding a unit via SQL. Use this corrected code. This will add the "FaithCost", and "RequiresFaithPurchaseEnabled" fields to unit infos. This code is for Gods and Kings, if you do not have GnK, use the SQL code in the 1st post from Gedemon, for CiV vanilla.
You cannot add values, to those values already linked to a unit, you' re replacing. Otherwise, it thinks the unit is unique. That is why my Arabian Longsword was set apart and made into a religious unit.Ok, if anyone is adding a unit via SQL. Use this corrected code. This will add the "FaithCost", and "RequiresFaithPurchaseEnabled" fields to unit infos. This code is for Gods and Kings, if you do not have GnK, use the SQL code in the 1st post from Gedemon, for CiV vanilla.
Spoiler :
Hypereon
He was a Consul of Rome!
OK, now I've done what you suggested, Gedemon.
Well it is now even worse - a spearman
.
Yes, I did also try the code with existing working unit members, but it had no effect. I've now written the code completely again with the corrected syntax and haven't managed to find any error from the code, but could you check it too.
Thanks for any help in advance.
Well it is now even worse - a spearman
.Yes, I did also try the code with existing working unit members, but it had no effect. I've now written the code completely again with the corrected syntax and haven't managed to find any error from the code, but could you check it too.
Spoiler :
Thanks for any help in advance.
you missed the ";" at the end of the first INSERT statement
Edit : and DamageStates have to be defined (when using the "direct" INSERT syntax, you can't refer to a column name from the SELECT as you've not selected anything), replace it by 1
Edit : and DamageStates have to be defined (when using the "direct" INSERT syntax, you can't refer to a column name from the SELECT as you've not selected anything), replace it by 1
Code:
INSERT INTO ArtDefine_UnitInfos (Type, DamageStates, Formation)
VALUES ('ART_DEF_UNIT_PORTUGUESE_BANDEIRANTE', 1, 'HonorableGunpowder');Hypereon
He was a Consul of Rome!
Thank you very much! It's now working.
The thing there that didn't work, that was the Flagbearer member. It seems that it isn't possible to easily combine a civilian member to a military unit. But now it works with just the military units.
How do you merge all units into a single mod? I clicked build solution, which I thought created a mod that encompassed them all. However in game in Mods, I still have to click a folder for each unit. Sorry for being smart earlier. This stuff is not all that easy sometimes.
I only use the WB to work on blank maps to add city and territory in my scenarios, the rest I handle in Lua (which is why I can't answer your last PM), so I never tried to fix that. I think there is a post or tutorial somewhere about how to set icons for strategic view, I suppose it's the same icons used in WB placement. Maybe someone can point you to that post...
