08.02.2019, 14:49
First and foremost, why do you select everything just to retrieve only `Password` and `DBID`? Select only these two columns.
An account name is unique, therefore set `Name` as UNIQUE KEY.
`DialogPassword` can be overwritten because of threaded queries. You need a player-array.
When the two passwords match, select the rest (`Skin`, `Admin`) and not everything again. But more importantly, you now know the `DBID` so replace WHERE `Name` with WHERE `DBID`
An account name is unique, therefore set `Name` as UNIQUE KEY.
`DialogPassword` can be overwritten because of threaded queries. You need a player-array.
When the two passwords match, select the rest (`Skin`, `Admin`) and not everything again. But more importantly, you now know the `DBID` so replace WHERE `Name` with WHERE `DBID`