14.01.2018, 16:33
Few things:
- I doubt you need 2048 cells; the string isn't that long.
- You should use threaded queries, especially if you save with this often. Use mysql_tquery(zMySQL, query2, "") instead and that's it.
- If you're saving by username, you're doing something wrong. Each account should have a unique ID (A.I/PRIMARY settings are good), which you use to reference for most database actions (them connecting being an exception, as you need to look it up that way).
- I don't get why you're selecting, only to save, when you don't even check if the account exists? (which you should know without as you should have some type of logged in and account ID reference stored).
- mysql_log.log in the server directory will show any MySQL errors, depending on if logging is enabled within the plugin.
- I doubt you need 2048 cells; the string isn't that long.
- You should use threaded queries, especially if you save with this often. Use mysql_tquery(zMySQL, query2, "") instead and that's it.
- If you're saving by username, you're doing something wrong. Each account should have a unique ID (A.I/PRIMARY settings are good), which you use to reference for most database actions (them connecting being an exception, as you need to look it up that way).
- I don't get why you're selecting, only to save, when you don't even check if the account exists? (which you should know without as you should have some type of logged in and account ID reference stored).
- mysql_log.log in the server directory will show any MySQL errors, depending on if logging is enabled within the plugin.