dart user database for dast for all servers

[Shaneuk]

Its a shame DAST haven't got a way to link the db file from dart to the server information on the website so we could upload all the guids that have ever played on our servers and then if we wanted to search for a guid it would show which servers that guid had been on that way if I caught a hacker on my server I could see which other DAST servers that guid had been on ....


The database would need to record the guid, the user ip, the server ip, the user name, and date last visited, maybe then we could find users with multiple guids on one ip etc etc

this database would search all the DAST registered server files when you do a search for a guid or ip address or in game name or steam id maybe ?

not sure if it makes sense what I have put I am happy to explain better if I need to

[TheKronnY]

Well, that would be no problem, I would just need to see how does that file look like. Could you add at least fragment of this file here, so I can see how does it look like? After I see it's structure I will be able to think of the way to implement this to DAST (if it'd be possible ).

[Shaneuk]

here is the file from my dart .....

do you have a email as its a .db file it wont allow me to upload it here

[TheKronnY]

I've added .db extension to board, so you can upload it. Try it now

[Shaneuk]

sorry I had no power so couldn't upload but back on now so here is the file

There are 2 ip address for the !TTM! server as we had to change ip at one point due to performance issues

doesn't look like my file will upload its 13.1MB it has a warning triangle when I upload it

[TheKronnY]

It looks like it did not work either huh . Whatever, send the file to admin/at/dayz-ast.com and I will check it

[Shaneuk]

you should have it by email now

[TheKronnY]

Yes, perfect, I am trying to figgure out, how to implement this I have sent you a response, so be sure to read it.

[Shaneuk]

well I think you would need to only copy over the following bits

IP: Varchar 255
Date last seen: DateTime
GUID: Varchar 255
In Game Name: Varchar 255
Server IP: Varchar 255

you could add server name ... but if like !TTM! the server ip changes when you have issues with GSP then the name wouldn't match the ip anymore

This may fill a database as my file is 83,525 entries but some of these are the same guids but using new names or ips

[TheKronnY]

Well, I would link it to the unique DAST Server ID - this way it would never got lost.

[Shaneuk]

which email did you reply to ? as I haven't got anything yet

I have facebook online if you want to chat on there

[TheKronnY]

I've sent it now. I had problems with email sync.

[TheKronnY]

Suggestion discussion moved to this topic.