29.04.2014, 18:42
Quote:
Код:
[OnQueryError] Error ID: 1064 [OnQueryError] Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'p_armure = 10, p_cagoule = 0, p_cigarettes = 0, p_tabac = 0, p_feuilles = 0, p_c' at line 1 [OnQueryError] Callback: [OnQueryError] Query: p_armure = 10, p_cagoule = 0, p_cigarettes = 0, p_tabac = 0, p_feuilles = 0, p_combat = 0, p_marche = 0, p_compte = 0 WHERE p_id = 1p_faction = 0, p_rang = 0, p_maison = 0, p_commerce = 0, p_crash_x = 0.000000, p_crash_y = 0.000000, p_crash_z = 0.000000 [OnQueryError] Connection handle: 1 |
@Above posters ShivRp and [MWR]Blood:
You don't really need to add those ' ' or ` `, simple query works fine too. Usually scripters make them to look fancy, but it is wastage of time anyway. Although ' ' needs to be used only for strings, it is still needed. Do like this '%s' to every string specifier.
@Macronix: That won't work because the formatted string cannot be that longer, and it will give silly errors. You need to strcat them if they're long. This doesn't applies for the patched compiler by Zeex/xeeZ.