[KessMan]

It is best to use only one string for all MySQL updates in my GameMode with "tquery"?

[AndySedeyn]

Can you provide an example of what you mean?

[KessMan]

Make a global string. = "new queryUpdate[200];".

System 1 = "mysql_format(SQLCon, queryUpdate, sizeof(queryUpdate), " ... etc "", "mysql_tquery(SQLCon, queryUpdate);"
System 2 = "mysql_format(SQLCon, queryUpdate, sizeof(queryUpdate), " ... etc etc "", "mysql_tquery(SQLCon, queryUpdate);"

All MYSQL updates in my GM.

[AndySedeyn]

Oh. No, that's never a good idea. The more scripts you create, the sooner you'll find yourself creating queries longer than 200 characters. But you'll also find yourself creating a lot of queries much smaller than 50 characters. All of the remaining indices will be wasted space.

[SickAttack]

don't "use only one string for all MySQL updates in my GameMode with "tquery""

[KessMan]

The problem would only be used space used?

[Freaksken]

Quote:

Originally Posted by KessMan The problem would only be used space used?

Read my post on a topic with a similar question here.

[AndySedeyn]

No. If you format the query somewhere and forget about it, it's globally formatted. It's still a global variable! This will lead to long debug sessions trying to find the reason why something is malfunctioning. Moreover, wasting space like that is frowned upon because it's very bad practice.

[SickAttack]

Quote:

Originally Posted by AndySedeyn No. If you format the query somewhere and forget about it, it's globally formatted. It's still a global variable! This will lead to long debug sessions trying to find the reason why something is malfunctioning. Moreover, wasting space like that is frowned upon because it's very bad practice.

It's just not convenient...