[RESOLVED] PlayerDB

[Silent79]

I am migrating to fcraft from MCStorm and I was using mySQL with MCStorm. My players want to hang on to their stats from MCStorm, their blocks built and time spent on the server. What format is the playerdb.txt file so I can correctly transfer this information? The most important is the time spent on the server as that is the basis for them getting ranks.

[fragmer]

I cannot help you. PlayerDB is a work in progress and I cannot provide any support. The file format is subject to change. There are no plans to make MCStorm-to-fCraft import tools.

[Silent79]

Shoot, that is what I thought, just wanted to hear it from the horses mouth ...

[Ollieboy]

*pony's mouth.

[fragmer]

Woops, you are talking about PlayerDB. I thought you are talking about the things I added 2 days ago (BlockDB). I'll post PlayerDB info.

[Silent79]

Woops, you are talking about PlayerDB. I thought you are talking about the things I added 2 days ago (BlockDB). I'll post PlayerDB info.

LOL ... ok, thanks for that. I know your busy a lot and read things quick, so I understand the mix up.

[xanderortiz]

Perhaps I can help some here. I created an Excel file that pulls the data from the PlayerDB.txt file and separates it into columns.
I can read it better and search for specific fields quickly and easily. I suggest you do that for your old database and for the fields I'm about to tell you.
Then copy time spent from that one single column (in old database) and paste into the time column of the NEW excel file.
Then output into a PlayerDB.txt file.
Here is the format:

playerName,lastIP,rank,rankChangeDate,rankChangeBy,banStatus,banDate,bannedBy,unbanDate,unbannedBy,firstLoginDate,lastLoginDate,lastFailedLoginDate,lastFailedLoginIP,failedLoginCount,totalTimeOnServer,blocksBuilt,blocksDeleted,timesVisited,linesWritten,UNUSED,UNUSED,previousRank,rankChangeReason,timesKicked,timesKickedOthers,timesBannedOthers,UID,rankChangeType,lastKickDate,LastSeen,BlocksDrawn,lastKickBy,lastKickReason,bannedUntil,loggedOutFrozen,frozenBy,mutedUntil,mutedBy,IRCPassword,online,leaveReason

Good Luck!

[fragmer]

The first line of PlayerDB.txt is the header. First number is format version (between 0 and 3). Second number is max player ID. After that, there's a list of columns.

Format versions differ mostly in the way dates are stored:

• 0 - Prior to 0.530 - Dates are in local time, date and time format is locale-dependent.
• 1 - 0.530 to 0.536 (current stable) - Dates are UTC, date and time format is in milliseconds since Unix epoch (like Unix timestamp, but with more precision).
• 2 - old 0.600 dev builds - Dates are UTC, date/time format is Unix timestamp (seconds since Unix epoch).
• 3 - current 0.600 dev builds - PlayerDB sorting by ID (ascending) is now enforced.

The list of columns is in the header. Values are comma-separated. Blank values for numeric columns mean "0". Blank values for date/time columns mean "Never."

[roblikescake]

if its a fairly small amount of players you could always just use the /setinfo command

[fragmer]

There are also /importranks and /importbans commands. The are set up to work with MCZall. I'm not sure if MCForge uses same format.