Hello, sometime my server has a problem with showxp and earning xp when they get kill!!! can anyone help me how to fix that?
here is the error
L 03/29/2011 - 17:17:36: [SM]
- Line 113, W3SIncs/gameevents.inc::War3Source_PlayerSpawnEvent()
L 03/29/2011 - 17:17:36: [SM] Native "War3_ShowXP" reported: Plugin owning this native is currently paused.
L
Seems like some of engine's is missing.
Also, ownz, I finally found the problem why my players get connection problem on map end. It happens when race file is changed and I think war3source is quite slow to reload this race (or maybe its reloading everything).
For example if I change racecode of night elf, give him 15% evade instead of 20% and reupload it, players will get connection problem.
Also I was reporting errors here before like:
L 03/06/2011 - 14:26:25: [w3s/War3Source_Engine_DatabaseSaveXP.smx] SQL error: [T_CallbackUpdatePDataMain] 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 'doom',gold='11',total_level='256',total_xp='37681',last_seen='1299410774',levelb' at line 1
L 03/06/2011 - 14:28:23: [w3s/War3Source_Engine_DatabaseSaveXP.smx] SQL error: [T_CallbackUpdatePDataMain] 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 'doom',gold='1',total_level='257',total_xp='36493',last_seen='1299410894',levelba' at line 1
L 03/06/2011 - 14:30:24: [w3s/War3Source_Engine_DatabaseSaveXP.smx] SQL error: [T_CallbackUpdatePDataMain] 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 'doom',gold='1',total_level='257',total_xp='36713',last_seen='1299411015',levelba' at line 1
b7
This happens coz of */* and *\* characters in player nickname, it can be fixed by using SQL_EscapeString (instead of replase, how its done now). Also this SQL_EscapeString fixes "levelbank bug" (it happens when player spend levels to race, reconnects, but he didnt lose any levels from war3source table coz *\* breaks sql query).
Logged
DarkEnergy
