[QUESTION] tbl_user

[janvier123]

Hi,

i was wondering if the use of "tbl_user" in account db is needed in order to run a server
while i was writing osdsv2 is was putting all info into tbl_user
when i got to the banning system i noticed that i need 2 tables to pull data from

and all the data is stored into USER_PROFILE
i remembered that tbl_user is only needed for a website
but i cant verify if that is true

and if tbl_user should not be used in future projects
so if there is anyone who deleted there tbl_user or willing to delete it
to bad i dont have a server to test it on

and if tbl_user is useless, should it be used in future projects ?

Thx
PS: plz dont flame, unless you want a infraction
you all know how it ended last time

[Decima]

i can verify, i wiped my tbl_user by accident back a while ago, and it did not affect anything at all, i was gonna get it from a backup i had, but after noticing that it wasnt affecting login, i started creating accounts out of curiosity without having it insert in tbl_user, and all new account also worked perfectly fine, i couldnt find one issue at all with the table empty.

so what i am doing now is actually using it as a storage table for stuff like one-time URL for password change and such, and also store some random info including dotted IP address (i.e. 198.23.34.456) when they register. i even altered the fields to be able to hold more characters, changed one to INT value, and still everything runs perfectly fine.

so yeah, as far as in game, its a useless table, i have done everything but completely ditch the table and did my best to abuse it to see if it actually did affect anything, and so far, no issues at all.

[Zombe]

Just try dropping that table, if something doesn't work, that means you need that table.

[janvier123]

well bye bye tbl_user
i can store all the info i need in user_profile
i can read the user ip's so everything in that table is readable to me so ...
its easy to just dump the table and keep user_profile

and if all servers should do the same they have atleast 1 big security issue out of the way
passwords are more secure, cuz they are all MD5

[freeskier4lif3]

Yep, tbl_user is not needed at all, other than used to verify a players email or get their password in a readable format. You can add that email field to another table though if needed.

[pieter]

lol i renamed tbl_user to something else and everything runs just fine. it's my backup for administrative purposes (see from what ip users registerred, and what their first password was)

[Scotticus]

Why run from the already made-up database.. If you know enough SQL, You can just make a whole new one.. Pretty easy if you know what you are doing..

Then you dont need to worry about how the tables are structured, Because you would of done them yourself..

[janvier123]

cuz i want to
osdsv2 can be used on a already existing database
there is no / or little need of a db for osdsv2

[iAslana]

Janvier knows it now, tbl_user is not needed in order to run a dedicated server.
@ Scott you Uber Programmer?

# CloseRequested

[~Kakkarot~]

#closed