SourceOP
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! Big Grin