Get into someone else account bug?

[tutifruti]

Hi, I was just wondering how you guys prevent people from logging into someone else account. Seems like there's a bug with the login server? or something that makes you get into someone else account even if you did login with your credentials.

[MentaL]

[aqua512]

Odin files right? Just another Odin bug. It is on the list that never ends.

[tutifruti]

How do I fix it?

[Evildarkang]

Well like others have said its a common bug; however this is to do with the id of the person (its a number) you can modify the table to make it +1 each time (although that'd require some nasty work to the tables) rest assured its quite easy on MSSQL;

go down to the columns of the accounts database, click on the user accounts (it would be tUser or tAccounts). Change the nUserID properties to include identity and increment of 1

It might error and ask you to drop, but i'm not going to tell you how to bypass that (thats a google thing for ya to discover).

Otherwise go through the tAccounts/tUser table and make sure the ID (number) DOES NOT Match another account.

[tutifruti]

Are you sure this is whats causing it?

[Evildarkang]

Look i used Odin Files i know the issue each database uses nUserNo instead so just do what i said and everything will be FINE! Make sure you have NO DUPLICATES!

[Delius]

I use to use a really, really nasty workaround. I would setup a cron job that ran on the database table once or twice a day that would fix any duplicates. Worked great in the sense that it fixed the error, but when the server got a couple hundred thousand characters it was very inefficient. Ended up having to move the database to it's own server.

Pretty simple cron job script to write, I'd give to you but I no longer have it.

Preferably though, do the fix provided above. Gl :)