Raised This Month: $ Target: $400
 0% 

[L4D & L4D2] Custom Player Stats v1.4B121


  
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
RasterMan
Senior Member
Join Date: Mar 2004
Location: Luton, UK
Old 06-30-2013 , 05:20   Re: [L4D & L4D2] Custom Player Stats v1.4B117
Reply With Quote #11

Have 1 problem stats keep adding 1 bot to rankings always any idea's why?

I've also tried using both v1.4B117 & github v1.4B120


Also getting loads of errors:

L 06/30/2013 - 10:17:27: SourceMod error session started
L 06/30/2013 - 10:17:27: Info (map "c1m1_hotel") (file "errors_20130630.log")
L 06/30/2013 - 10:17:27: [l4d_stats.smx] SQL 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 'e + playtime_versus + playtime_realism + playtime_survival + plaUPDATE players S' at line 1 (Query: "UPDATE players SET points_mutations = points_mutations + 5 WHERE steamid = 'e + playtime_versus + playtime_realism + playtime_survival + plaUPDATE players SET points_mutations = points_mutations + 5 WHERE steamid = 'e + playtime_versus + playtime_realism ")
L 06/30/2013 - 10:179: [l4d_stats.smx] SQL 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 'e + playtime_versus + playtim'' at line 1 (Query: "UPDATE players SET points_mutations = points_mutations + 6 WHERE steamid = 'e + playtime_versus + playtime_realism + playtime_survival + plaUPDATE players SET points_mutations = points_mutations + 6 WHERE steamid = 'e + playtime_versus + playtim'")
L 06/30/2013 - 10:17:49: [l4d_stats.smx] SQL 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 '''' at line 1 (Query: "UPDATE players SET melee_kills = melee_kills + 1 WHERE steamid = 'oints_infected + points_realism + points_survival + points_scavenge_survivors + points_scavenge_infected + points_realism_survivors + points_realism_infected + points_mutations FROM players")
L 06/30/2013 - 10:18:25: [l4d_stats.smx] SQL 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 '''' at line 1 (Query: "UPDATE players SET points = points + 20 WHERE steamid = '= ''' ")
L 06/30/2013 - 10:18:25: [l4d_stats.smx] SQL 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 '''' at line 1 (Query: "UPDATE players SET points = points + 20 WHERE steamid = '= ''' ")
L 06/30/2013 - 10:18:25: [l4d_stats.smx] SQL 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 '''' at line 1 (Query: "UPDATE players SET points = points + 20 WHERE steamid = '= ''' ")
L 06/30/2013 - 10:18:25: [l4d_stats.smx] SQL 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 '''' at line 1 (Query: "UPDATE players SET points = points + 20 WHERE steamid = '= ''' ")
L 06/30/2013 - 10:18:52: [l4d_stats.smx] GetClientRankMute failed! Reason: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
L 06/30/2013 - 10:19:10: [l4d_stats.smx] SQL 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 'UPDATE players SET points_mutations = points_mutations + 12 WHERE steamid = 'rs ' at line 1 (Query: "UPDATE players SET points_mutations = points_mutations + 12 WHERE steamid = 'rs SET infected_spawn_2 = infected_spawn_2 + 1 WHERE steamid = 'UPDATE players SET points_mutations = points_mutations + 12 WHERE steamid = 'rs SET infected_spawn_2 = in'")
L 06/30/2013 - 10:19:22: [l4d_stats.smx] SQL 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 'e + playtime_versus + playtime_realism + playtime_survival + plaUPDATE players S' at line 1 (Query: "UPDATE players SET points_mutations = points_mutations + 2 WHERE steamid = 'e + playtime_versus + playtime_realism + playtime_survival + plaUPDATE players SET points_mutations = points_mutations + 2 WHERE steamid = 'e + playtime_versus + playtime_realism ")
L 06/30/2013 - 10:21:55: [l4d_stats.smx] SQL 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 'e + playtime_versus + playtime_realism + playtime_survival + plaUPDATE players S' at line 1 (Query: "UPDATE players SET points_mutations = points_mutations + 8 WHERE steamid = 'e + playtime_versus + playtime_realism + playtime_survival + plaUPDATE players SET points_mutations = points_mutations + 8 WHERE steamid = 'e + playtime_versus + playtime_realism ")
L 06/30/2013 - 10:232: Error log file session closed.
L 06/30/2013 - 10:24:40: SourceMod error session started
L 06/30/2013 - 10:24:40: Info (map "c1m2_streets") (file "errors_20130630.log")
L 06/30/2013 - 10:24:40: [l4d_stats.smx] SQL 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 'UPDATE players SET points_mutations = points_mutations + 3 WHERE steamid = 'rs S' at line 1 (Query: "UPDATE players SET points_mutations = points_mutations + 3 WHERE steamid = 'rs SET infected_spawn_3 = infected_spawn_3 + 1 WHERE steamid = 'UPDATE players SET points_mutations = points_mutations + 3 WHERE steamid = 'rs SET infected_sp'")
L 06/30/2013 - 10:268: [l4d_stats.smx] SQL 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 'e + playtime_versus + playtim'' at line 1 (Query: "UPDATE players SET points_mutations = points_mutations + 1 WHERE steamid = 'e + playtime_versus + playtime_realism + playtime_survival + plaUPDATE players SET points_mutations = points_mutations + 1 WHERE steamid = 'e + playtime_versus + playtim'")
L 06/30/2013 - 10:271: [l4d_stats.smx] SQL 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 '''' at line 1 (Query: "UPDATE players SET points = points + 0, award_charger = award_charger + 1 WHERE steamid = 'points + 5, award_protect = award_protect + 1 WHERE steamid = '''")
L 06/30/2013 - 10:271: [l4d_stats.smx] SQL 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 '''' at line 1 (Query: "UPDATE players SET points_mutations = points_mutations + 1 WHERE steamid = '= '''")
L 06/30/2013 - 10:29:24: [l4d_stats.smx] SQL 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 '''' at line 1 (Query: "UPDATE players SET points_mutations = points_mutations + 23 WHERE steamid = '= '''")
L 06/30/2013 - 100:25: [l4d_stats.smx] SQL 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 '''' at line 1 (Query: "UPDATE players SET points_mutations = points_mutations + 3 WHERE steamid = '= '''")
L 06/30/2013 - 100:25: [l4d_stats.smx] SQL 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 '''' at line 1 (Query: "UPDATE players SET points_mutations = points_mutations + 17 WHERE steamid = '= '''")
L 06/30/2013 - 100:44: [l4d_stats.smx] SQL 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 'time_versus + playtime_realism + playtime_survival + playtime_scU'' at line 1 (Query: "UPDATE players SET infected_boomer_vomits = infected_boomer_vomits + 1 WHERE steamid = 'time_versus + playtime_realism + playtime_survival + playtime_scUPDATE players SET infected_boomer_vomits = infected_boomer_vomits + 1 WHERE steamid = 'time_versus + p")
L 06/30/2013 - 101:04: [l4d_stats.smx] SQL 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 'oints_infected + points_realism + points_survival + points_scavenge_survivors + ' at line 1 (Query: "UPDATE players SET melee_kills = melee_kills + 1 WHERE steamid = 'oints_infected + points_realism + points_survival + points_scaveUPDATE players SET melee_kills = melee_kills + 1 WHERE steamid = 'oints_infected + points_realism + points_survival + points_")
L 06/30/2013 - 101:06: [l4d_stats.smx] SQL 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 'oints_infected + points_realism + points_survival + points_scaveUPDATE players S' at line 1 (Query: "UPDATE players SET melee_kills = melee_kills + 1 WHERE steamid = 'oints_infected + points_realism + points_survival + points_scaveUPDATE players SET melee_kills = melee_kills + 1 WHERE steamid = 'oints_infected + points_realism + points_survival + points_")
L 06/30/2013 - 101:14: [l4d_stats.smx] SQL 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 '''' at line 1 (Query: "UPDATE players SET points = points + 14 WHERE steamid = '= ''' ")
L 06/30/2013 - 101:14: [l4d_stats.smx] SQL 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 '''' at line 1 (Query: "UPDATE players SET points = points + 14 WHERE steamid = '= ''' ")
L 06/30/2013 - 101:14: [l4d_stats.smx] SQL 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 '''' at line 1 (Query: "UPDATE players SET points = points + 14 WHERE steamid = '= ''' ")
L 06/30/2013 - 101:15: [l4d_stats.smx] SQL 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 '''' at line 1 (Query: "UPDATE players SET points = points + 14 WHERE steamid = '= ''' ")
L 06/30/2013 - 1037: [l4d_stats.smx] SQL 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 '''' at line 1 (Query: "UPDATE players SET points = points + 0, award_charger = award_charger + 1 WHERE steamid = 'points + 4, award_protect = award_protect + 1 WHERE steamid = '''")
__________________

Last edited by RasterMan; 06-30-2013 at 06:09.
RasterMan is offline
Send a message via MSN to RasterMan
 



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 22:00.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode