MongoDB Structure

[JamesJ]

Hiya,
I'm currently making an external application/plugin (that will not run on the forums) that will work with the forums, and sync forum profiles with in-game profiles.
We are currently using MongoDB for our game-server storage and data, therefore have opted to use MongoDB for the forums too.
My main question is, we are looking for player's of our game-server to be able to dynamically register in-game with their email and a password, and it will then insert a document with that data into the collection.
However, I have seen no documentation on the collection structure, or even database structure.
Upon looking at the database from the command line, I can only see search queries and a collection called 'objects', when looking at that collection, it was honestly un-readable.

Any help would be appreciated.

Kind regards,

• James

[jarey]

If i'm not wrong mongodb structure isimplemented in a redis like manner following the key-value approach.
The reason of that is that nodebb development started with redis db as de persistanxe layer and the mongodb structure nowadays reflects that layer compromise.

[yariplus]

Looks like everything is in the 'objects' collection, with a '_key' value to look it up.

Look here for more information on how the different data types are stored and retrieved.

[LuckyRiver]

Hi,

I'm adding also support nodebb using mongodb. I'm facing similar issue retrieving a member profile to synch in my multiplayer texas hold'em game. I got authentication using blowfish working but I also need to grab user gravatar/avatar link to display in game. Thanks for the link, I take a look. It should be a matter of days once I got the info I need to get the demo up using nodebb.

/LR

[LuckyRiver]

@JamesJ

You should be able to see some info, don't recall where I see the data, check for sessions instead of objects.

I have something on my end like below:

...
{ "_id" : ObjectId("55780ca7c711a4ad359e5f2c"), "_key" : "user:1", "banned" : 0,
"birthday" : "", "email" : "[email protected]", "fullname" : "",
"gravatarpicture" : "https://secure.gravatar.com/avatar/f3224ceb7bc2fa75df32e872812868e1?size=128&default=identicon&rating=pg",
"joindate" : 1433930919489, "lastposttime" : 1433930920619, "location" : "",
"password" : "$2a$12$5I2.pZLinAWQpXkhZzP2gumHg.nF9BurcE5eNkO1jXZAr6AUwS1lq", "passwordExpiry" : 0,
"picture" : "https://secure.gravatar.com/avatar/f3224ceb7bc2fa75df32e872812868e1?size=128&default=identicon&rating=pg",
"postcount" : 1, "profileviews" : 0, "reputation" : 0, "signature" : "", "status" : "online", "topiccount" : 1, "uid" : 1,
"uploadedpicture" : "", "username" : "LuckyRiver", "userslug" : "luckyriver", "website" : "" }
...

Now, I have to figure out how programmatically retrieve that!

[LuckyRiver]

Here how I figure out to get the member profile. Assuming looking for a particular user name, if you run the following query on mongo client command line:

db.objects.find( { username: "LuckyRiver" }, { _id: 0, _key: 0, banned: 0, birthday: 0, fullname: 0, joindate: 0, lastposttime: 0, passwordExpiry: 0, profileviews: 0, signature: 0, topiccount: 0, uploadedpicture: 0, userslug: 0, website: 0, reputation:0, status: 0, location:0, username:0 } )

It will return the result of the member if found, I'm skipping all the unwanted fields .

Hope it helps!

[yariplus]

You should also consider using the _key field instead of the username, since the username can change.

Store the _key value on your game when you do authentication and lookup {_key: "user:" + thevalue}

Of course, you won't need to do this if you only need to fetch the data once.

[LuckyRiver]

@yariplus said:

You should also consider using the _key field instead of the username, since the username can change.

Store the _key value on your game when you do authentication and lookup {_key: "user:" + thevalue}

Of course, you won't need to do this if you only need to fetch the data once.

I thought of that but uid was enough for my need and username was a requirement since to authenticate username and password are submitted which I retrieve to authenticate the user, first , I'm looking at username to get the hashed password which I compare with the one the user entered and apply the bcrypt algorithm. I could have use the _key but uid was also as good as _key and I don't need to do extra parsing. You're right the username may change but _key and uid won't.

[LuckyRiver]

Somehow I did need the _key when query avatar, using uid did not go well, so it's a mix of the 2, I'm using _key combining with _key:user:String.valueOf(uid)! Everything works like a charm!

[startech]

The structure looks not friendly at all.