13.06.2018, 07:08
Bad design. Your tables have duplicates.
Table "accounts" should have only the main data of player (id, name, ip, password etc.)
Table "houses" is enough for you to extract data only once and having the same data on another table is not good.
Column "Owner" should have been an integer (userid) and be a FOREIGN KEY to link the two tables. Using JOINs, you can retrieve name of owner and/or which house (if any) the player owns upon logging in.
Table "accounts" should have only the main data of player (id, name, ip, password etc.)
Table "houses" is enough for you to extract data only once and having the same data on another table is not good.
Column "Owner" should have been an integer (userid) and be a FOREIGN KEY to link the two tables. Using JOINs, you can retrieve name of owner and/or which house (if any) the player owns upon logging in.