Official Everybody Edits Forums

Do you think I could just leave this part blank and it'd be okay? We're just going to replace the whole thing with a header image anyway, right?

You are not logged in.

#1 Before February 2015

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)


signature.png
*u stinky*

Offline

#2 Before February 2015

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)

Offline

#3 Before February 2015

XxAtillaxX
Member
Joined: 2015-11-28
Posts: 4,202

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

lrussell wrote:

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.


signature.png
*u stinky*

Offline

#4 Before February 2015

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.

Offline

#5 Before February 2015

Buzzerbee
Forum Admin
From: Texas, U.S.A.
Joined: 2015-02-15
Posts: 4,566

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.


TdQRyz3.png
https://wiki.everybodyedits.com/images/5/5d/135_bee

Offline

#6 Before February 2015

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?

Offline

#7 Before February 2015

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.

Offline

#8 Before February 2015

lrussell
Member
From: Saturn's Titan
Joined: 2015-02-15
Posts: 843
Website

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

Hexagon wrote:

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

Offline

#9 Before February 2015

XxAtillaxX
Member
Joined: 2015-11-28
Posts: 4,202

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

BuzzerBee wrote:

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.


signature.png
*u stinky*

Offline

#10 Before February 2015

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.

Offline

#11 Before February 2015

XxAtillaxX
Member
Joined: 2015-11-28
Posts: 4,202

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

Hexagon wrote:

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)


signature.png
*u stinky*

Offline

XxAtillaxX1423757821203611

Board footer

Powered by FluxBB

[ Started around 1711706313.0545 - Generated in 0.044 seconds, 10 queries executed - Memory usage: 1.54 MiB (Peak: 1.7 MiB) ]