Posted 30 October 2003 - 03:49 AM
Hello you guys down under,
this is my 1st thread, and the first in english after quite some time, so be prepared ;-).
as you know, you have to install the ms-sqlserver to have access to the editing features, and of cause to the game's constants. to gain access to these, you have to create an "odbc-data source" with your win xp/2k, just look for "Data-Sources (ODBC), its somewhere in the systems-settings (in the same place with "computer-management"). its quite self-explanatory, just keep an eye for the "change the default database to:"-option, check it an choose "a5game" in the rolldown.
if you ve suceeded (there is a test option in the last dialogue), you just have to start your ms-access to gain, nomen est omen, access:
file->open->the choose "file-type" "odbc-databases"->in the next one click "computer data-sources" & choose the further created one.
in the next dialogue "select all", then okay. after this you have to click sometimes okay, after a while you will see the complete lists of dbs.
to understand the schematics, you will have to know, that some of these tables are just composed out of others, for example
"dbo_ammosort" or "dbo_weapons".
so lets do some basic modding, just for understanding-purpose:
at first, launch your console and move to your SStorm dir, subdir "tools".
there are 4 tools, the one we like at the moment is "dataimport.exe", which you will need to create the "game.db", which includes the changed constants.
okay, here is the should work on all machines command-line (keep in mind, that you have to type this in your command-prompt!):
"dataimport original.db -dbserver 127.0.0.1 -database a5game" (without quotas, of course).
after some seconds, you will have a file named "original.db" in your tools-folder, this thing is important, because its the export of the original, unmodded db, you will need it later.
now switch back to access, just for fun we will tweak the good old sea devil, give it an average range and really good damage.
to understand wepaons damage, two things are important:
a) the ammo type, which delieveres the basics damages
B) the weapons modificator to min/max damage
so, take a look into the table "dbo_rpgammos", its really easy to understand. at position 43 you will find the entry, an in the 8th & 9th row the corresponding damage. just change it as you like and close the window. after this, open "dbo_rpgweapons", and scroll down to position/id 142, "sea devil". change the position 11 &12 (column) as you like, to tweak the range.
by the way, column 9&10 represent the weapons modificator of the use ammo-type, but its more important for ammunition, which is used by several guns. now close the windows'. before we can export the settings, we have to update de db, to do so, you must right-click on one of the tables, an the left-click the last menu-entry, something like "tableconnection-manager". there choose "select everything", then okay, after some seconds all corresponding tables have been altered.
now you can close access, and change to the command-prompt window.
you have to type the following with the following command-line:
"dataimport full-mod.db -dbserver 127.0.0.1 -database a5game"
after some secs you have a ~38Mb file, which is an import of the now modded database. basically you can rename this file and use it as a mod, but its not the stylish way, we are only interested in the things which really changed, so we we have to run another command-line:
"dataimport game.db -diff full_mod.db original.db"
after this, we have a small file, named "game.db" in the tools dir, which is our mod. now create a subfolder beneath your s2-main-dir, example "testmod", copy the new "game.db" to this place, and create a txt.-file in this dir, called "description.txt", in it a short explanation of the mood (a few words).
now start your silent storm (by the way, you can speed it up when you edit "sstormcfgintro.seq" and remove everything except "exec mainmenu") and run a new campagne. then spawn a sea devil with "getitem 382".
if it hasnt worked, no problem, after this you should have a basic idea how modding the ss-'s constants works!