MySQL Account save problem
#5

On your Windows machine, can you execute:
PHP код:
SHOW CREATE TABLE players
If the output of that query does show default values then your table setup is different.

Also that SQL script is horribly unoptimized. A single table shouldn't contain more than 30 fields or so, much less 300. That whole "accessory" section especially can and should be moved to a different table that has 13 columns rather than 84. Each new accessory constitutes a new row, not a new set of columns. Same thing with guns, licenses, times, inventory item, bans and whatever.
Reply


Messages In This Thread
MySQL Account save problem - by Scofield11 - 08.08.2017, 03:44
Re: MySQL Account save problem - by Storm94 - 08.08.2017, 03:57
Re: MySQL Account save problem - by Scofield11 - 08.08.2017, 04:19
Re: MySQL Account save problem - by Storm94 - 08.08.2017, 06:06
Re: MySQL Account save problem - by Vince - 08.08.2017, 08:20
Re: MySQL Account save problem - by Scofield11 - 08.08.2017, 10:23
Re: MySQL Account save problem - by Scofield11 - 08.08.2017, 13:33
Re: MySQL Account save problem - by Scofield11 - 09.08.2017, 22:26

Forum Jump:


Users browsing this thread: 1 Guest(s)