SourceOP credits database conversion

[TESLA-X4]

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.

[Drunken F00l]

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.

[TESLA-X4]

Yeah, I just need to convert the database once. Cheers.

[Drunken F00l]

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;

[TESLA-X4]

Sweet, thanks DF!