18.11.2010, 14:41
Well do some counting and some analyzing, lets see the string:
The length of this string is 50 without any of the inserted values. So now lets check the values that will go into it:
Username: Max length of 24, so that makes the maximum length of the query, 74.
Money: How much money can a user have in your server? You've only used a maximum of 74 out of your specified 200, so unless a player can have over 125 digits in their money, then your string is definitely long enough, if not too long for this query, as I doubt a player should have over 125 digits in their money.
Edit: I made a slight error in calculation with the string length, without any inserted values from the format, it would be 46
pawn Код:
UPDATE `Test` SET Money = %i WHERE Username = '%s'
Username: Max length of 24, so that makes the maximum length of the query, 74.
Money: How much money can a user have in your server? You've only used a maximum of 74 out of your specified 200, so unless a player can have over 125 digits in their money, then your string is definitely long enough, if not too long for this query, as I doubt a player should have over 125 digits in their money.
Edit: I made a slight error in calculation with the string length, without any inserted values from the format, it would be 46