Aurora 4x

Starfire => SA Installation => Topic started by: Steve Walmsley on September 11, 2007, 11:28:59 AM

Title: SA Version v7.10 (Experimental)
Post by: Steve Walmsley on September 11, 2007, 11:28:59 AM
I have created a new patch for Starfire Assistant. However, this is simply a compile of any additional work or bug fixes I have done since v7.02 so I don't think there will be many functional changes and I don't have a record of those changes. In addition, this isn't tested so download and try at your own risk :)

Steve
Title:
Post by: Charlie Beeler on September 13, 2007, 03:24:37 PM
For S&G's I'm running 7.1 with a 7.02 database.  So far no issues and some minor headaches resolved.

Steve, Thank You.
Title:
Post by: Steve Walmsley on September 13, 2007, 05:10:20 PM
Quote from: "Charlie Beeler"
For S&G's I'm running 7.1 with a 7.02 database.  So far no issues and some minor headaches resolved.

Good to hear that. You really should run it with a v7.10 database but to be honest I have no idea what (if anything) has changed in the database since v7.00 so you may well be fine.

Steve
Title:
Post by: coldsteel on September 13, 2007, 09:45:56 PM
Quote from: "Steve Walmsley"
Quote from: "Charlie Beeler"
For S&G's I'm running 7.1 with a 7.02 database.  So far no issues and some minor headaches resolved.
Good to hear that. You really should run it with a v7.10 database but to be honest I have no idea what (if anything) has changed in the database since v7.00 so you may well be fine.

Steve



IIRC and FWIW, you've only fixed bugs, and haven't added anything new (not a bad thing, considering no new ideas yet...) since 7.0's Sypply Depots and the semi-Tac map view.
Title:
Post by: Charlie Beeler on September 14, 2007, 08:28:29 AM
Quote from: "Steve Walmsley"
Quote from: "Charlie Beeler"
For S&G's I'm running 7.1 with a 7.02 database.  So far no issues and some minor headaches resolved.
Good to hear that. You really should run it with a v7.10 database but to be honest I have no idea what (if anything) has changed in the database since v7.00 so you may well be fine.

Steve


I did a quick comparison of the 7.10 and the 7.02 tables in Access.  I didn't find anything that leap out is a format change.  It wasn't a comprehensive evaluation of course.
Title:
Post by: Steve Walmsley on September 14, 2007, 10:10:38 AM
Quote from: "Charlie Beeler"
I did a quick comparison of the 7.10 and the 7.02 tables in Access.  I didn't find anything that leap out is a format change.  It wasn't a comprehensive evaluation of course.

The changes may be in the data in some of the tables, particularly relating to weapons information, tech systems, expendables, etc.

Steve
Title:
Post by: Charlie Beeler on September 14, 2007, 11:02:31 AM
Quote from: "Steve Walmsley"
Quote from: "Charlie Beeler"
I did a quick comparison of the 7.10 and the 7.02 tables in Access.  I didn't find anything that leap out is a format change.  It wasn't a comprehensive evaluation of course.
The changes may be in the data in some of the tables, particularly relating to weapons information, tech systems, expendables, etc.

Steve


That's what I was hoping.  I've made several changes to my database to incorporate me boatbay fighters. As well as other tweeks for personal taste.  

As long as formats remain the same I think I'm in good shape.  If not,  then I'll have some work too do, either hand editting tables into compliance or starting a new game with fresh 7.10 database.  

Charlie
Title:
Post by: Shinanygnz on September 15, 2007, 09:51:44 AM
Here's an SAUpgrade script to upgrade from a 7.02 to the 7.10 database
Not many structural changes.  Note that this copies the Tech and Expendable tables as I've added several.  If you've added no tech, change the lines
table 'TechSystem' copy
table 'Expendables' copy order by 'ExpendID'
to
table 'TechSystem' ignore
table 'Expendables' ignore
Your other alternative is to not copy this tables and manually copy over the stuff you've added, which is doable but a bit of a pain in the bum due to the autocreate of the ID fields.

I had to clean a few rogue entries from the ClassOrdnance and ClassXO tables in the dB to get them to copy, but at least I won't have to redo all my ship Mg and XO loadouts this time.

Stephen
---------------------------------------------------------------------
Code: [Select]
table 'Game' copy
table 'Race' copy
table 'SystemType' ignore
table 'System' copy
table 'RaceMapDisplay' copy
       add 'chkSensorNet' 1
       add 'ZoomLevel' 1
       add 'CentreX' 0
       add 'CentreY' 0
table 'AdminCommand' copy
table 'App' copy
table 'BinaryDistances' ignore
table 'BuildRates' ignore
table 'CFNCost' ignore
table 'CFNTasks' copy order by 'CFNTaskID'
table 'CFNSales' copy
table 'Civilization' copy
table 'Ranks' copy
table 'CommanderList' copy
table 'Commander' copy
table 'CommanderRace' copy
table 'CommunicationState' ignore
table 'ConHistory' copy
table 'CrewGrade' ignore
table 'CrewGradeAdvance' ignore
table 'DesignType' ignore
table 'EconomicLevel' ignore
table 'EconomicTurns' copy
table 'ELResearchType' ignore
table 'EnvValue' ignore
table 'ExpendType' ignore
table 'TechSystem' copy
table 'Expendables' copy order by 'ExpendID'
table 'Fleet' copy
table 'FleetMove' copy
table 'Datagroups' copy
table 'DSBPosition' copy
table 'HullType' copy
table 'ShipDesign' copy
table 'ShipClass' copy
table 'AssociatedClasses' copy
table 'ClassSC' copy
table 'FundTransfer' copy
table 'GovtPool' copy
table 'GovType' copy
table 'GradeAdvancement' ignore
table 'HighTech' ignore
table 'HistoricalData' copy
table 'Inhabited' ignore
table 'JRillRaces' copy
table 'MachineRaces' copy
table 'Message' copy
table 'MessageType' ignore
table 'MinContent' ignore
table 'MissileMods' ignore
table 'Moons' ignore
table 'StarType' ignore
table 'Star' copy
table 'Planet' copy
table 'Moon' copy
table 'MoonChance' ignore
table 'MoonName' copy
table 'MoveImpulses' ignore
table 'SensorNetType' ignore
table 'Notes' ignore
table 'NPRExploration' ignore
table 'NPRTechlevel' ignore
table 'NumOrder' ignore
table 'Ordnance' ignore
table 'PCF' ignore
table 'PlanetDistance' ignore
table 'PlanetName' copy
table 'PlanetType' ignore
table 'PointDefence' ignore
table 'PoliticalState' ignore
table 'PopulationLevel' ignore
table 'PopulationSize' ignore
table 'Progress' ignore
table 'RaceClassName' copy
table 'RaceMessages' copy
table 'RacePCF' copy
table 'RaceSysSurvey' copy
table 'RaceSystemName' copy
table 'AvailTech' copy
table 'RaceTech' copy
add 'Obsolete' 0
table 'WarpPoint' copy
table 'RaceWPSurvey' copy
table 'ReadinessState' ignore
table 'RefitCost' copy
table 'Relationship' copy
table 'ReportClass' copy
table 'ReportTurn' copy
table 'Resolver' copy
table 'MapGroup' copy
table 'MapLabel' copy
table 'Ship' copy
table 'ShipComponent' copy
table 'DesignCompOrder' copy
table 'DamagedComponent' copy
table 'DamagedDesignComp' copy
table 'ShipItem' copy
table 'ShipSC' copy
table 'ShipWeapon' copy
table 'ShipXO' copy
table 'ShipNameType' ignore
table 'ShipNames' ignore
table 'ShipNamesUsed' copy
table 'CompOrderGroups' copy
table 'Shipyards' copy
table 'ShipyardTask' copy
table 'SurveyOptions' ignore
table 'SystemNotes' copy
table 'SystemSurvey' copy
table 'TaskType' ignore
table 'TechResearchType' ignore
table 'TechSystemModifiers' ignore
table 'Theme' ignore
table 'ThemeClass' copy
table 'ThemeRank' copy
table 'ThemeSystem' copy
table 'TotalWarpPoints' ignore
table 'Trade' copy
table 'TurnStatus' ignore
table 'WarpPointDistance' ignore
table 'WarpPointType' ignore
table 'Weapons' ignore
table 'WindowPosition' copy
table 'RacialRelations' copy
table 'RacialRelationStates' ignore
table 'SBMHAWKs' ignore
table 'StandardSysMoons' ignore
table 'StandardSysPlanets' ignore
table 'WPDefences' copy
table 'SystemItem' copy
table 'MaintenanceHistory' copy
table 'ClassOrdnance' copy
table 'ClassXO' copy
table 'GroupItems' copy
table 'GroupPlot' copy
table 'ItemGroup' copy
table 'SurveyTransfer' copy
table 'ShipOrdnance' ignore
table 'DesignItemType' ignore
table 'DPAtmos' ignore
table 'DPBoatbay' ignore
table 'DPCloak' ignore
table 'DPCVArmed' ignore
table 'DPCVPassive' ignore
table 'DPEngineType' ignore
table 'DPJammer' ignore
table 'DPMg' ignore
table 'DPMix' ignore
table 'DPPassive' ignore
table 'DPPassiveSplit' ignore
table 'DPPD' ignore
table 'DPPosition' ignore
table 'DPSurveyFleetSize' ignore
table 'DPSurveyHull' ignore
table 'DPSurveyProtect' ignore
table 'DPTuner' ignore
table 'DPTuner2' ignore
table 'DPWarshipHullTypes' ignore
table 'DPWeaponConfig' ignore
table 'DPWeaponLayout' ignore
table 'DPXr' ignore
table 'DPZ2' ignore
table 'NPR9' ignore
table 'DesignPhil' copy
table 'Paste Errors' ignore
table 'RandomNames' copy
table 'ScrapHistory' copy
table 'TableData' ignore
table 'TempRaces' ignore
table 'TradeHistory' copy


*edit* Slapped the script into a code block to facilitate copy/paste -Erik
Title:
Post by: Edsel on September 20, 2007, 12:43:52 PM
I can't seem to get the saupgrade script to work properly for my game. Whenever I run it here is what I get:

Quote
saupgrade version 1.02
processing table Game
processing table Race
processing table System
processing table RaceMapDisplay

C:\Starcom\SAUpgrade>

So it just stops and thinks it is done once it gets past the RaceMapDisplay. Obviously this doesn't work and results in a nearly empty database. I can't see any obvious errors in the upgrade script. Does anyone have any suggestions?
Title:
Post by: Charlie Beeler on September 20, 2007, 01:45:46 PM
Did you list the files in the correct order?  Remember that table is getting 4 new columns.  

Stephen thank you for the script.  I used it to tell me what I'd missed in my manual update, and this columns were missed by me.  My database is still small enough for that to be easily done.
Title:
Post by: Edsel on September 20, 2007, 03:25:09 PM
I created the script by just cutting and pasting the stuff that Stephen posted. Since I had not added any new tech systems I made the substitution that he indicated.

Is the order that Stephen posted incorrect? What order does it need to be in?
Title:
Post by: Shinanygnz on September 20, 2007, 05:17:45 PM
The cut and paste has missed the indents.  The Add xxx lines should be tabbed in once.  Might be what is confusing it.

The order is correct.  I've been doing these for quite a while now.  If it was in the wrong order it would throw a SQL error.

If you get stuck you can compact your db, zip it up and email it to me.  I've been known to operate a free rescue service, although if you're feeling grateful I like German beer   :wink:

Stephen
Title:
Post by: coldsteel on September 20, 2007, 08:21:05 PM
Stephen is and has been the Upgrade Gawd. lol.
Title:
Post by: Edsel on September 20, 2007, 08:45:43 PM
I checked and you were right the "add" lines had no tabs. I edited the file so each such line has a single tab in front of it. Unfortunately this seems to have had no effect, I still get the same result.

This mystifies me. I have used saupgrade many times over the years and this is the first time I have had it fail. This is a relatively new game it was started in v7.02 and is only 17 game turns along.

Stephen, if you are willing to take a look at it I can send you a copy of the database. What email address do I need to sent it to? You can send me a private message if you wish.

Unfortunately I know next to nothing about beer (German or otherwise) I am a teetotaler.

- Eddie
Title:
Post by: Shinanygnz on September 22, 2007, 04:46:01 AM
Eddie's dB is upgraded.

Bit of a strange problem...
The four fields that were added/populated by the script in RaceMapDisplay already existed in his database.  I've checked the base v7.0 dB too and they're not in that (v7.01 & 7.02 were code releases with no dB changes).
Once those four Add lines were removed the script ran without a problem, so if anyone else has the same issue, that's the fix.

Stephen
Title:
Post by: Þórgrímr on September 22, 2007, 09:33:11 AM
Being the noob around here I feel kinda dumb. I never knew about a program that updated the DB. I always figured we just replaced the DB and lost all previous games.  :shock:

So my question is this, what is this SAUpgrade you folks are chatting about, and how can I edit the DB since it is PW protected?




Cheers,
Title:
Post by: Shinanygnz on September 22, 2007, 12:52:10 PM
SAUpgrade was a small program written by Jim.... errr, it's been so long I've forgotten his surname, which is bad as it's proven a most useful utility.
It reads a text file that tells it what tables to copy over from your old database to the new one and has options for ignoring old fields, adding new ones and so on.
When Jim dropped of the Starfire list I started writing update scripts so I could keep my game up to date.  I released these via the Starfire mailing list so others could too.  You can get SAUpgrade and the update scripts (the SAUpgrade zip has them all to save you downloading it and all the scripts separately) from my old website
http://www.stephen.cooke.dsl.pipex.com/starfire.htm (http://www.stephen.cooke.dsl.pipex.com/starfire.htm)
I haven't maintained this site for over a year and a half, because I switched ISP.  I just looked and it appears to still be there though.
There's also some tech, optional rules and the Haggi Confederation game info on there.

There was no detailed readme by Jim so I had to work out what to do by looking at old scripts Jim had put out.  I think the util is actually quite a bit more powerful than what I've managed, but what I have produced usually works.
As all it does is read and copy Access tables, it may work to upgrade Aurora's DB too.  Have to give it a try sometime.

Being the nice (I expect that word to be on my grave marker) person that people tell me I am, I've sorted out upgrade issues for various fellow gamers.  It's usually fairly simple, just deleting rogue entries from some tables in the dB.  SA is sometimes a bit messy with what it leaves around from previous games.

Steve has never publically released the dB password and requested long ago that noone who knew do so either.  A number of people know what it is, in my case from using a password cracker so I could get in and fix my dB to run an upgrade.  I've never seen anyone publically state what it is.

Stephen
Title:
Post by: Þórgrímr on September 22, 2007, 01:24:56 PM
Shinanygnz, thanks much for the link to the upgrade program. I see you were a Fleet Action player to. Glad I went there because I was able to snag that juicy looking fleet builder program.   :wink:




Cheers,
Title:
Post by: Edsel on September 22, 2007, 02:22:19 PM
Thanks for your help. I wonder if one of my earlier failed attempts added those fields and then failed...

Oh well, whatever the cause thanks for the fix.
Title:
Post by: Shinanygnz on September 22, 2007, 05:38:33 PM
[quote="
Title:
Post by: MWadwell on September 23, 2007, 05:47:20 PM
Quote from: "Shinanygnz"
SAUpgrade was a small program written by Jim.... errr, it's been so long I've forgotten his surname, which is bad as it's proven a most useful utility.


Jim Randall?
Title:
Post by: Shinanygnz on September 24, 2007, 11:23:10 AM
Quote from: "MWadwell"
Quote from: "Shinanygnz"
SAUpgrade was a small program written by Jim.... errr, it's been so long I've forgotten his surname, which is bad as it's proven a most useful utility.

Jim Randall?


That sounds right, I think.

Stephen
Title:
Post by: Steve Walmsley on September 24, 2007, 03:08:10 PM
Quote from: "MWadwell"
Quote from: "Shinanygnz"
SAUpgrade was a small program written by Jim.... errr, it's been so long I've forgotten his surname, which is bad as it's proven a most useful utility.

Jim Randall?

Yes, Jim Randall

Steve
Title:
Post by: Edsel on February 17, 2008, 01:04:43 PM
The URL in the first post of this thread (the locater for the 7.10 patch) is pointing at the old address for the website. Could someone fix this?
Title:
Post by: Edsel on February 23, 2008, 10:38:27 AM
Quote from: "Edsel"
The URL in the first post of this thread (the locater for the 7.10 patch) is pointing at the old address for the website. Could someone fix this?
I see it has been fixed. Thanks!
Title: Re: SA Version v7.10 (Experimental)
Post by: Tregonsee on November 22, 2008, 05:38:49 PM
OK, I have seen some posts about SA Upgrade Utility.  Is it possible to upgrade 3.8 to 7.0 or so?  Does it have to be done in stages, or can it be done all at once?

I have seen SA Upgrade scripts up to version 5.2 or so, but that is it.  I assume there are scripts for newer versions.  Any help would be appreciated.
Title: Re: SA Version v7.10 (Experimental)
Post by: Shinanygnz on November 24, 2008, 12:31:04 PM
Matt's got the ones that will get you to v6.5 available at
http://au.geocities.com/mwadwell/SAML.html (http://au.geocities.com/mwadwell/SAML.html)

I've got the others (seeing as I wrote the little blighters).  My old site has finally disappeared - took about two years for the ISP to clean it away.  If your DB survives to v6.5, drop me a note and I'll send them to you.

Stephen
Title: Re: SA Version v7.10 (Experimental)
Post by: Shinanygnz on December 01, 2008, 03:07:38 PM
Erik has kindly hosted the upgrade scripts here...
viewtopic.php?f=25&t=1338 (http://aurora.pentarch.org/viewtopic.php?f=25&t=1338)

Stephen
Title: Re: SA Version v7.10 (Experimental)
Post by: Tregonsee on December 02, 2008, 10:16:33 AM
OK folks, I must be really stupid here.  I got the old database, I got a copy of SAUpgrade, I have the upgrade script.

It also says I need a blank new database (the new.mdb).  Where do I get that?

I guess then the program will take the info from the old database and put it in the new empty database, thus creating a new database of the new version.


Steve G
Title: Re: SA Version v7.10 (Experimental)
Post by: Shinanygnz on December 02, 2008, 05:04:14 PM
The new database for each version was in the SA patch file for it.  So you need each patch file to do a step by step upgrade.
Steve had a sensible naming scheme.  v6.xy where x is the database version and y is the code version, so 6.30 then 6.40 (a database change) followed by 6.41 (a code but not db change).
I've looked and I still have them all from the original v6.00 install through all the patches to 7.10 (which is available earlier in this thread).

Erik, the zip files with blank databases are 41.5Mb in all (v6.10 through to 6.90 then 7.00), actually just 16.4Mb if I take the .exe and other gumpf out of the zips.  If you've got the space to host and are willing, I can send them to you (or straight to you Tregonsee if you have the inbox space available).

Stephen
Title: Re: SA Version v7.10 (Experimental)
Post by: Erik L on December 02, 2008, 05:54:40 PM
I've got the space, and others might need them at some point :)
Title: Re: SA Version v7.10 (Experimental)
Post by: Tregonsee on December 06, 2008, 04:33:54 PM
Does anyone (Shinanygnz) have patches, etc for versions 6.0 thru 7.0?  Any help is appreciated.
Title: Re: SA Version v7.10 (Experimental)
Post by: MWadwell on December 07, 2008, 03:02:06 PM
Quote from: "Tregonsee"
Does anyone (Shinanygnz) have patches, etc for versions 6.0 thru 7.0?  Any help is appreciated.

I've got up to version 6.5 ( http://au.geocities.com/mwadwell/SAML.html (http://au.geocities.com/mwadwell/SAML.html) ) - however I do not have 6.6, 6.7, 6.8, 6.9 or 7.0. For 7.1 I believe that there is the script at the start of this thread....
Title: Re: SA Version v7.10 (Experimental)
Post by: Edsel on December 09, 2008, 09:37:30 PM
Quote from: "MWadwell"
Quote from: "Tregonsee"
Does anyone (Shinanygnz) have patches, etc for versions 6.0 thru 7.0?  Any help is appreciated.

I've got up to version 6.5 ( http://au.geocities.com/mwadwell/SAML.html (http://au.geocities.com/mwadwell/SAML.html) ) - however I do not have 6.6, 6.7, 6.8, 6.9 or 7.0. For 7.1 I believe that there is the script at the start of this thread....

I have the patches 6.6, 6.7, 6.71, 6.8, 6.9, 6.91, 6.92, 7.01, but not 7.00. All of the patches I have are in Winrar, instead of the original Zip format. If you want them let me know and I can email them to you.
Title: Re: SA Version v7.10 (Experimental)
Post by: Tregonsee on December 10, 2008, 06:53:10 AM
I would indeed like the patches, but maybe Erik could post them so everyone could enjoy them...
Title: Re: SA Version v7.10 (Experimental)
Post by: Shinanygnz on December 11, 2008, 04:14:35 PM
I've got them ready to roll.  If Erik lets me know where, they'll be on their way.

Tregonsee, if you're inbox can take about 17Mb, I'll send them to you.
Title: Re: SA Version v7.10 (Experimental)
Post by: alanwebber on May 05, 2011, 08:43:11 AM
Is the patch for SA 7.10 still available? I've looked through the board and carried out a search but I can't find it anywhere. I've currently got 7.02 up and running.

Thanks

Alan
Title: Re: SA Version v7.10 (Experimental)
Post by: golfnut40 on September 28, 2013, 03:23:30 AM
stupid question if i have version 6 of sa do i need all the other upgrades to download 7. 1
Title: Re: SA Version v7.10 (Experimental)
Post by: Edsel on April 30, 2014, 11:54:05 AM
If you have SA 6.0 you need the update patch for 7.02 and then 7.10 to convert the game.  The 7.02 patch is an amalgamation of the 7.0 through 7.02 patches (7.01 and 7.02 were merely bug fixes). The 7.10 patch is simply a new exe file and starfire database.  This will work fine if you are starting a new game.

If you have a game that is underway then you have to do the upgrade scripts progressively on the database to get to version 7.10 and there is always the possibility of odd complications.

The actual SAUpgrade executable can still be found here: http://www.dreadfest.com/satools/saupgrade.html (http://www.dreadfest.com/satools/saupgrade.html)   Along with many of the older upgrade scripts.  I have copies of all of the upgrade scripts from version 6 to 7.10 in my own archives.  These files are pretty ancient by now and hopefully not corrupted.  If you need any of them let me know and I can upload them.  I also have all the files needed to install version 6 and upgrad it all the way to 7.10.  In fact I am currently playing a 2-player game with a friend of mine.