Invalid character constant

lexzor · **Author**

hello i have this code

PHP Code:


			
formatex(g_iPlayersInfo[iPlayer][PlayedTime], charsmax(g_iPlayersInfo[][PlayedTime]), "^"%s^":^"%s^":^"%s^"", g_iPlayedTime[iPlayer][Hours], g_iPlayedTime[iPlayer][Minutes], g_iPlayedTime[iPlayer][Seconds])

        

            formatex(szQuery, charsmax(szQuery), "UPDATE `%s` SET `frags` = ^"%i^" , `deaths` = ^"%i^ , `played_time` = ^"%s^" WHERE `name` = ^"%s^"",

            g_szTables[0], g_iPlayersInfo[iPlayer][Frags], g_iPlayersInfo[iPlayer][Deaths], g_iPlayersInfo[iPlayer][Name], g_iPlayersInfo[iPlayer][PlayedTime])

and i get this:

Code:

Error: Invalid character constant on line 520
Error: Invalid character constant on line 522

lexzor · 05-04-2021 , 19:44 Re: Invalid character constant

from.

^"%i^ to ^"%i^"

**Bugsy** · 05-04-2021 , 21:32 Re: Invalid character constant

1. Don't use quotations around numbers.
2. Your Name and PlayedTime variables are placed incorrectly, which could be the cause.
3. You have g_iPlayersInfo[iPlayer][PlayedTime] as a string which I assume is an integer as well
4. Use steam id as the key, not name. I can join your server using someone elses name and have all of their stats, it makes no sense.

Try:

PHP Code:


			
formatex(szQuery, charsmax(szQuery), "UPDATE `%s` SET `frags`=%i , `deaths`=%i , `played_time`=%d WHERE `name` = ^"%s^";",

            g_szTables[0], g_iPlayersInfo[iPlayer][Frags], g_iPlayersInfo[iPlayer][Deaths], g_iPlayersInfo[iPlayer][PlayedTime] , g_iPlayersInfo[iPlayer][Name] )