[mabaclu]

PHP Code:

new szTemp[512]
format(szTemp,charsmax(szTemp),"UPDATE `ensports` SET `skill` = '%i', `frags` = '%i', `deaths` = '%i', `rounds` = '%i', `winner_matches` = '%i', `matches_played` = '%i', `bombs_exploded` = '%i', `bombs_defused` = '%i',  WHERE `steamid` = '%s';", g_ePlayerData[ id ][ Skill ], g_ePlayerData[ id ][ Frags ], g_ePlayerData[ id ][ Deaths ], g_ePlayerData[ id ][ Rounds  ], g_ePlayerData[ id ][ WinnerMatches ], g_ePlayerData[ id ][ MatchesPlayed ], g_ePlayerData[ id ][ BombsExploded ], g_ePlayerData[ id ][ BombsDefused ], szSteamId) 


If I change "g_ePlayerData[ id ][ Skill ]" to "id" it doesn't freeze anymore and compiles properly so this is probably a line size issue. Any workaround?

[fysiks]

Originally Posted by mabaclu PHP Code: new szTemp[512] format(szTemp,charsmax(szTemp),"UPDATE `ensports` SET `skill` = '%i', `frags` = '%i', `deaths` = '%i', `rounds` = '%i', `winner_matches` = '%i', `matches_played` = '%i', `bombs_exploded` = '%i', `bombs_defused` = '%i',  WHERE `steamid` = '%s';", g_ePlayerData[ id ][ Skill ], g_ePlayerData[ id ][ Frags ], g_ePlayerData[ id ][ Deaths ], g_ePlayerData[ id ][ Rounds  ], g_ePlayerData[ id ][ WinnerMatches ], g_ePlayerData[ id ][ MatchesPlayed ], g_ePlayerData[ id ][ BombsExploded ], g_ePlayerData[ id ][ BombsDefused ], szSteamId)  If I change "g_ePlayerData[ id ][ Skill ]" to "id" it doesn't freeze anymore and compiles properly so this is probably a line size issue. Any workaround?

If you think you know why then change what you think is wrong and test again.

[mabaclu]

It's probably because the line size is too big, but I obviously won't be replacing variables with smaller ones that have nothing to do with what I want. And changing the var name to a smaller one won't work because I'm planning to add more values to that query.

[YamiKaitou]

Break the query into multiple queries and see if that solves your issue

[mabaclu]

Thanks for the sugestion, will give it a try and edit this post with the result.

Worked by dividing the query in parts:

PHP Code:

format(szTemp,charsmax(szTemp),"UPDATE `players` SET ")
format(szAddTemp, charsmax(szAddTemp), "`skill` = '%i', `frags` = '%i', `deaths` = '%i', `rounds` = '%i', `winner_matches` = '%i'", g_ePlayerData[ id ][ Skill ] ,g_ePlayerData[ id ][ Frags ], g_ePlayerData[ id ][ Deaths ], g_ePlayerData[ id ][ Rounds  ], g_ePlayerData[ id ][ WinnerMatches ])
add(szTemp, charsmax(szTemp), szAddTemp)
format(szAddTemp, charsmax(szAddTemp),", `matches_played` = '%i', `bombs_exploded` = '%i', `bombs_defused` = '%i'  WHERE `steamid` = '%s';", g_ePlayerData[ id ][ MatchesPlayed ], g_ePlayerData[ id ][ BombsExploded ], g_ePlayerData[ id ][ BombsDefused ], szSteamId)
add(szTemp, charsmax(szTemp), szAddTemp)