Just an update...
So had a day off work today, sat down with a 12 pack and did some more work on the database. I've got the stored procedure for on_server_startup fixed now, and saved the proceedure for you all. I've also been reversing stored procedure information to import to the telecaster tables and columns. Tedious but works.
The DBUpdater.opt still has me puzzled if anyone can try and take at crack at it. I think it will help us populate arcadia db. In either case I'll look at it tomorrow and give the decryptor a try on it. I saw in the DPUpdater.exe code the same des key. At this point even if I have to manually extract data from rdu files, it will be worth it. Worth a try at least.
After work tomorrow, I'll work on telecaster some more til I have a few more tables populated, then post my work. Still might be a couple more days til I get them to you all. I'll have to do a bit more reversing, then drop a lot of stored procedures to re-try them, and package everything up to run smooth for you all.
Also, just for fun, another way to elimate authserver.opt clutter is to add...
S db.auth.connection_string:Provider=sqloledb;Persis t Security Info=True;Initial Catalog=Telecaster;Data Source=127.0.0.1;User id=sa;Password=
This will overwrite the connection string, and since connection string comes before db.auth.account and db.auth.password_ it will automatically take effect without the need of those two commands.
And one more thing, a legend for the opt files... what the s's and n's mean.
Code:
switch( type )
{
case 'S':Set( key, data ); break;
case 'F':Set( key, (float)atof(data) ); break;
case 'V':sscanf( data, "%f;%f;%f", &v.x, &v.y, &v.z ); Set( key, v ); break;
case 'Q':sscanf( data, "%f;%f;%f;%f", &q.x, &q.y, &q.z, &q.w ); Set( key, q ); break;
case 'N':Set( key, atoi(data) ); break;
case 'T':Set( key, (short)atoi(data) ); break;
}
S = String = text
F = Float = Integer with period other integer
N = Interger
T = Short = small #
V = wont use
Q =wont use
