SourceOP credits database conversion - Printable Version
+- SourceOP (
http://forums.sourceop.com)
+-- Forum: SourceOP Plugin (
http://forums.sourceop.com/SourceOP-Plugin-forum)
+--- Forum: General Chat (
http://forums.sourceop.com/General-Chat-forum)
+---- Forum: Ideas (
http://forums.sourceop.com/Ideas-forum)
+---- Thread: SourceOP credits database conversion (
/SourceOP-credits-database-conversion-thread)
SourceOP credits database conversion -
TESLA-X4 - Jan 12, 2010
Hi all, I'd like to know if there's a way to convert the SourceOP credits database into another format (e.g. SQLite)? The rationale behind it being that some features such as buying a single gun are not implemented, and that expanding the use of credits is currently impossible.
Thanks.
SourceOP credits database conversion -
Drunken F00l - Jan 12, 2010
To convert once? Maybe. I can give you the format if it helps.
If you want SourceOP to actually read and save to SQLite, then you're out of luck.
SourceOP credits database conversion -
TESLA-X4 - Jan 12, 2010
Yeah, I just need to convert the database once. Cheers.
SourceOP credits database conversion -
Drunken F00l - Jan 12, 2010
There's a version header followed by credits entries until the end of the file.
Version header (type should be SOPCRED, ver should be 1):
Code:
typedef struct creditsver_s
{
char type[12];
int ver;
} creditsver_t;
Credits entry:
Code:
typedef struct credits_t
{
char szSteamID[24]; //player's SteamID
int credits; //amount of credits
int timeonserver; //the time the player has been on the server
unsigned long lastsave; //time in seconds since UTC 1/1/70
int totalconnects; //previously total credits
int iuser1; //stores flags
char emptyspace[64]; //for future use
char FirstName[36]; //stores the player's first ever name used
char LastName[36]; //stores the player's last used name
char CurrentName[36];//stores the player's name during save
} credits_t;
SourceOP credits database conversion -
TESLA-X4 - Jan 12, 2010
Sweet, thanks DF!