1. We have added a Gift Upgrades feature that allows you to gift an account upgrade to another member, just in time for the holiday season. You can see the gift option when going to the Account Upgrades screen, or on any user profile screen.
    Dismiss Notice

The Shadow Agency - sponsor's template (entirely SQL based)

Discussion in 'CivBE - New Sponsors' started by Artisanix, Nov 26, 2014.

  1. Artisanix

    Artisanix Warlord

    Oct 6, 2013
    The Shadow Agency - sponsor's template (entirely SQL based)

    This mod adds fully working Sponsor/Civilization to CBE. It does not contain any fancy tricks or black magic, but should cover all the basics.

    What could make this mod useful for someone is its structure. I tried to get rid off of many unecesseray things that don't work in game (well working with original CBE files/DB can cause you a headache ten times over ;p).

    This mod's properties:
    (contains only 3 folders - ART, SQL, XML)

    In ART folder there are all necessary (well, almost) DDS files.
    - all are saved as DXT5 files without MIP MAPS (mip maps are completely unecessary for such kind of mods like sponsors, and take some disk space)
    - there are no glow and gradient files - the game doesn't use them
    - files are properly named to avoid confusion

    In SQL folder there are 4 files that cover all basic and necessary data for a new sponsor (Civilization.sql, Leader.sql, Texts.sql, Visuals.sql)

    All SQL files have useful comments that explain what to change to create a new sponsor, and some of the files even contain reference values from original game to make our choices easier.

    XML folder has the only files I've found that can't be replaced by SQL equivalents (if I'm wrong here, please correct me) - and these are the files for displaying a leader scene and environments.

    If you have questions about this template or you've spotted some bug or error - please share the info here immediately ;]

    Attached Files:

  2. Inawordyes

    Inawordyes In a word: Illyria

    Jul 19, 2013
    East Coast, US
    Even though it appears that this sponsor was made as a proof-of-concept, the concept behind the actual sponsor itself, while obviously basic and barebones, is actually quite intriguing.

    I'm not a modder, so I can't say anything for the coding and stuff, but +1 for a cool sponsor idea!
  3. Gorbles

    Gorbles Load Balanced

    Nov 24, 2014
    A selfish request would be to have an XML set of the SQL files, but that's not a priority. Great work, thanks!
  4. Artisanix

    Artisanix Warlord

    Oct 6, 2013

    Yes, even while this mod is sort of a concept, or template, it is actual a fully playable mod as well. The leader's trait used here is that new founded cities claim an additional territory - so we could say that in this aspect, this one is just a "space version" of the Shoshone from CivV ;]


    The reason for lack of xml files here is that there are already many mods released with sponsors that use xml only - so those can be used as reference/templates.
    Though the main point of this mod is that SQL is considered by many modders as "black magic" while in fact it's far more transparent, clear and easier to work with than xml data - of course you need to learn couple of basics at first, but it will pay off later.
  5. DanielUA

    DanielUA Chieftain

    Sep 25, 2012
    Artisanix thanks for your work! I created a new mod and it seems to work just fine :)
    Only one question - what does this line in Civilization.sql mean?


    What is the difference between those personalities?
  6. Patrick Pelikan

    Patrick Pelikan Chieftain

    Feb 19, 2015
    Somewhere beyond the sea
    Thank you very much for this! Actually gives me some perspective for the civ I wanted to do. Being a noob I had no idea how to start... Thanks for the great work! Also really like the idea of the "ShadowAgency"

Share This Page