View Full Version : SourceOP credits database conversion

Jan 11, 2010, 11:36 PM
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.


Drunken F00l
Jan 12, 2010, 02:21 AM
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.

Jan 12, 2010, 05:48 AM
Yeah, I just need to convert the database once. Cheers.

Drunken F00l
Jan 12, 2010, 11:05 AM
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):

typedef struct creditsver_s
char type[12];
int ver;
} creditsver_t;

Credits entry:

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;

Jan 12, 2010, 11:42 AM
Sweet, thanks DF! :D