I was working with someone in the forums on using the correct syntax in my plugin, so that it's compatable with various database types.
This is the origional line that I used:
Code:
format(query, 350, "REPLACE INTO %s VALUES ( '%s','%s', '1' )", sql_table, authid, tag)
This is the line that I was told I should use. However, it doesn't update the database, or throw any error.
Code:
format(query, 350, "UPDATE %s SET steamid='%s', tag='%s', toggle='1'", sql_table, authid, tag)
Comments, or suggestions please?
__________________