Official Everybody Edits Forums

XxAtillaxX

Member

Joined: 2015-11-28

Posts: 4,202

[Tool] GDAT.DLL - Username to UserID / UserID to Username Converter

This is an open-source library that will convert Everybody Edits UserIDs to Usernames and back.

FAQ:

  How does it work?
  It works by loading a 2MB SQLite DB file that holds around 65,000 EE Usernames and UserIDs.
  These players are known to be active, out of the 800,000 registered usernames on Everybody Edits.

  What are the uses of it?
  You may notice when looking through the lobby with a bot, that the owners are stored as UserIDs...
  Or that the owners in Worlds are stored as UserIDs...
  There weren't any ways of converting UserIDs to Usernames until gDAT was created.

  How fast is it?
  Since it loads the usernames and userids locally, it is very fast. It can load all 65,000 usernames and userids
  with a 'SELECT * FROM usernames' query in 2 seconds or less.

  Why does it contact atil.la/public_projects/gDat ?
  When a Username or UserID is not found in the local .db file, it will contact my site which checks my database to
  see if it exists. If not, it contacts the Everybody Edits server with a special request to get the UserID / Username.

  When the Username or UserID is found, it adds it to the local database for faster future searches.

Example:

using GDAT;

string username = GDATConverter.UserIdToUsername("simpleChris");
string userid = GDATConverter.UsernameToUserId("benjaminsen");

Downloads:
Source-code (v3.2) NOTE: Requires libraries from Compressed Binary
(v3.1) Compressed (ZIP) Binary (.NET 4.0)

Last edited by XxAtillaxX (Jul 15 2014 3:04:12 pm)

---

*u stinky*

lrussell

Member

From: Saturn's Titan

Joined: 2015-02-15

Posts: 843

Website

Re: [Tool] GDAT.DLL - Username to UserID / UserID to Username Converter

Terrible DLL, very bad. Delete now. Virus!

Last edited by lrussell (Jul 1 2014 8:36:15 pm)

XxAtillaxX

Member

Joined: 2015-11-28

Posts: 4,202

Re: [Tool] GDAT.DLL - Username to UserID / UserID to Username Converter

Terrible DLL, very bad. Delete now. Virus!

Yes, a lot of viruses are open-source. Anyway, if anyone is actually concerned here's a scan.

---

*u stinky*

lrussell

Member

From: Saturn's Titan

Joined: 2015-02-15

Posts: 843

Website

Re: [Tool] GDAT.DLL - Username to UserID / UserID to Username Converter

No, but seriously. It does make look-ups quicker for sure if you're willing to have the extra 5MB of bulk.

Buzzerbee

Forum Admin

Joined: 2015-02-15

Posts: 4,575

Re: [Tool] GDAT.DLL - Username to UserID / UserID to Username Converter

This looks fantastic. I agree with LRussell, the 5MB of bulk is a bit of a price to pay, but it should be worth it for most applications that would actually utilize this.

---

Hexagon

Member

Joined: 2015-04-22

Posts: 1,213

Re: [Tool] GDAT.DLL - Username to UserID / UserID to Username Converter

Thinking about making an API for this (looks like there is one but http://atil.la/public_projects/gDat/ doesn't seem to give any instructions). Would I be authorized to create an API?

---

???

Tako

Member

From: Memphis, Tennessee, USA

Joined: 2015-08-10

Posts: 6,663

Website

Re: [Tool] GDAT.DLL - Username to UserID / UserID to Username Converter

This is a lot simpler than you described, haha.

---

Yeah, well, you know that's just like, uh, your opinion, man.

lrussell

Member

From: Saturn's Titan

Joined: 2015-02-15

Posts: 843

Website

Re: [Tool] GDAT.DLL - Username to UserID / UserID to Username Converter

Thinking about making an API for this (looks like there is one but http://atil.la/public_projects/gDat/ doesn't seem to give any instructions). Would I be authorized to create an API?

It is an API, it just lacks the instructions because it was coded quickly one day.

User to ID:
http://atil.la/public_projects/gDat/ind … type=false

ID to User:
http://atil.la/public_projects/gDat/ind … &type=true

XxAtillaxX

Member

Joined: 2015-11-28

Posts: 4,202

Re: [Tool] GDAT.DLL - Username to UserID / UserID to Username Converter

This looks fantastic. I agree with LRussell, the 5MB of bulk is a bit of a price to pay, but it should be worth it for most applications that would actually utilize this.

I compacted and optimized the .db file, I've included the new one in the .zip in the first post, which is a heavy improvement on the 2.0 version. It also has optimizations for GDAT.dll as well which improves the query speeds significantly.

So if you haven't already, download and use v3.2 in the first post.

---

*u stinky*

Hexagon

Member

Joined: 2015-04-22

Posts: 1,213

Re: [Tool] GDAT.DLL - Username to UserID / UserID to Username Converter

I'm thinking about incorporating the gDat.dll library into Rabbit (my library) on github, would I be allowed to? This would include the database and the code for the dll file.

---

???

XxAtillaxX

Member

Joined: 2015-11-28

Posts: 4,202

Re: [Tool] GDAT.DLL - Username to UserID / UserID to Username Converter

I'm thinking about incorporating the gDat.dll library into Rabbit (my library) on github, would I be allowed to? This would include the database and the code for the dll file.

Yes. It's open source so by default it can be modified and distributed in any way.
EDIT: Updated the main post to say that it's 2MB instead of the old version, which was 5MB due to duplicate records.

Last edited by XxAtillaxX (Jul 15 2014 3:05:07 pm)

---

*u stinky*