MySQL database saving problem
#2

Normalize your database. You're not using a file system. If columns names have numbers in them you are doing databases wrong. https://sampforum.blast.hk/showthread.php?tid=505081

A single table should under normal circumstances not contain more than 30 or so columns; anything that is not directly related to the account should not be in the table. Anything that does not apply to the majority of players should also not be in the accounts table.

Each player can have one account (that is one table). An account can have zero or more warns (that's another table). An account can have zero or more characters (that's yet another table). A character can have zero or more guns (yes, yet another table). I hope you get my drift.
Reply


Messages In This Thread
MySQL database saving problem - by GloomY - 04.06.2015, 22:02
Re: MySQL database saving problem - by Vince - 04.06.2015, 22:34
Re: MySQL database saving problem - by GloomY - 04.06.2015, 22:48
Re: MySQL database saving problem - by PowerPC603 - 05.06.2015, 06:21
Re: MySQL database saving problem - by GloomY - 05.06.2015, 19:43

Forum Jump:


Users browsing this thread: 1 Guest(s)