[Tiger50]

@muukis

Hi

The most at this time is 76 members across all my server at any one time using your points system and its so much fun

Your stats plugin gives L4D2 a whole new dimension to the game

What i would like to ask is a couple of players have different account's and would like to add the points the have to their other accounts

Is this possible and how easy is it to do this

Thanks once again

[muukis]

Originally Posted by Tiger50 @muukis Hi The most at this time is 76 members across all my server at any one time using your points system and its so much fun Your stats plugin gives L4D2 a whole new dimension to the game What i would like to ask is a couple of players have different account's and would like to add the points the have to their other accounts Is this possible and how easy is it to do this Thanks once again

You should be able to merge the two players with a bit of SQL skills. You need both steam ids and then add the score from one to the other. Is this what you want to do? If so, I can try to write you a simple query for handling that.

[muukis]

This query will add the points of one SteamID to another SteamID in the database. I have barely tested it, so I can give you no guarantees it works perfectly. All it does is it sums two stats values to the other. Make a backup at least from your players table before executing this. Be careful not to run it more than once! Every time you execute the query the other SteamIDs stats are added to the other.

I hope this helps!

In this example the SteamID STEAM_1:0:AAAAAAAAAA gets all the points of SteamID STEAM_1:0:BBBBBBBBBB. You will want to change those SteamIDs accordingly. BTW, using this kind of logic you can run a temp database and when switched back to the original database, you can copy (add the stats score) the temp database values to the original.

UPDATE
  players p1
  , players p2
SET
  p1.playtime = p1.playtime + p2.playtime
  , p1.playtime_versus = p1.playtime_versus + p2.playtime_versus
  , p1.playtime_realism = p1.playtime_realism + p2.playtime_realism
  , p1.playtime_survival = p1.playtime_survival + p2.playtime_survival
  , p1.playtime_scavenge = p1.playtime_scavenge + p2.playtime_scavenge
  , p1.playtime_realismversus = p1.playtime_realismversus + p2.playtime_realismversus
  , p1.points = p1.points + p2.points
  , p1.points_realism = p1.points_realism + p2.points_realism
  , p1.points_survival = p1.points_survival + p2.points_survival
  , p1.points_survivors = p1.points_survivors + p2.points_survivors
  , p1.points_infected = p1.points_infected + p2.points_infected
  , p1.points_scavenge_survivors = p1.points_scavenge_survivors + p2.points_scavenge_survivors
  , p1.points_scavenge_infected = p1.points_scavenge_infected + p2.points_scavenge_infected
  , p1.points_realism_survivors = p1.points_realism_survivors + p2.points_realism_survivors
  , p1.points_realism_infected = p1.points_realism_infected + p2.points_realism_infected
  , p1.kills = p1.kills + p2.kills
  , p1.melee_kills = p1.melee_kills + p2.melee_kills
  , p1.headshots = p1.headshots + p2.headshots
  , p1.kill_infected = p1.kill_infected + p2.kill_infected
  , p1.kill_hunter = p1.kill_hunter + p2.kill_hunter
  , p1.kill_smoker = p1.kill_smoker + p2.kill_smoker
  , p1.kill_boomer = p1.kill_boomer + p2.kill_boomer
  , p1.kill_spitter = p1.kill_spitter + p2.kill_spitter
  , p1.kill_jockey = p1.kill_jockey + p2.kill_jockey
  , p1.kill_charger = p1.kill_charger + p2.kill_charger
  , p1.versus_kills_survivors = p1.versus_kills_survivors + p2.versus_kills_survivors
  , p1.scavenge_kills_survivors = p1.scavenge_kills_survivors + p2.scavenge_kills_survivors
  , p1.realism_kills_survivors = p1.realism_kills_survivors + p2.realism_kills_survivors
  , p1.jockey_rides = p1.jockey_rides + p2.jockey_rides
  , p1.charger_impacts = p1.charger_impacts + p2.charger_impacts
  , p1.award_pills = p1.award_pills + p2.award_pills
  , p1.award_adrenaline = p1.award_adrenaline + p2.award_adrenaline
  , p1.award_fincap = p1.award_fincap + p2.award_fincap
  , p1.award_medkit = p1.award_medkit + p2.award_medkit
  , p1.award_defib = p1.award_defib + p2.award_defib
  , p1.award_charger = p1.award_charger + p2.award_charger
  , p1.award_jockey = p1.award_jockey + p2.award_jockey
  , p1.award_hunter = p1.award_hunter + p2.award_hunter
  , p1.award_smoker = p1.award_smoker + p2.award_smoker
  , p1.award_protect = p1.award_protect + p2.award_protect
  , p1.award_revive = p1.award_revive + p2.award_revive
  , p1.award_rescue = p1.award_rescue + p2.award_rescue
  , p1.award_campaigns = p1.award_campaigns + p2.award_campaigns
  , p1.award_tankkill = p1.award_tankkill + p2.award_tankkill
  , p1.award_tankkillnodeaths = p1.award_tankkillnodeaths + p2.award_tankkillnodeaths
  , p1.award_allinsafehouse = p1.award_allinsafehouse + p2.award_allinsafehouse
  , p1.award_friendlyfire = p1.award_friendlyfire + p2.award_friendlyfire
  , p1.award_teamkill = p1.award_teamkill + p2.award_teamkill
  , p1.award_left4dead = p1.award_left4dead + p2.award_left4dead
  , p1.award_letinsafehouse = p1.award_letinsafehouse + p2.award_letinsafehouse
  , p1.award_witchdisturb = p1.award_witchdisturb + p2.award_witchdisturb
  , p1.award_pounce_perfect = p1.award_pounce_perfect + p2.award_pounce_perfect
  , p1.award_pounce_nice = p1.award_pounce_nice + p2.award_pounce_nice
  , p1.award_perfect_blindness = p1.award_perfect_blindness + p2.award_perfect_blindness
  , p1.award_infected_win = p1.award_infected_win + p2.award_infected_win
  , p1.award_scavenge_infected_win = p1.award_scavenge_infected_win + p2.award_scavenge_infected_win
  , p1.award_bulldozer = p1.award_bulldozer + p2.award_bulldozer
  , p1.award_survivor_down = p1.award_survivor_down + p2.award_survivor_down
  , p1.award_ledgegrab = p1.award_ledgegrab + p2.award_ledgegrab
  , p1.award_gascans_poured = p1.award_gascans_poured + p2.award_gascans_poured
  , p1.award_upgrades_added = p1.award_upgrades_added + p2.award_upgrades_added
  , p1.award_matador = p1.award_matador + p2.award_matador
  , p1.award_witchcrowned = p1.award_witchcrowned + p2.award_witchcrowned
  , p1.award_scatteringram = p1.award_scatteringram + p2.award_scatteringram
  , p1.infected_spawn_1 = p1.infected_spawn_1 + p2.infected_spawn_1
  , p1.infected_spawn_2 = p1.infected_spawn_2 + p2.infected_spawn_2
  , p1.infected_spawn_3 = p1.infected_spawn_3 + p2.infected_spawn_3
  , p1.infected_spawn_4 = p1.infected_spawn_4 + p2.infected_spawn_4
  , p1.infected_spawn_5 = p1.infected_spawn_5 + p2.infected_spawn_5
  , p1.infected_spawn_6 = p1.infected_spawn_6 + p2.infected_spawn_6
  , p1.infected_spawn_8 = p1.infected_spawn_8 + p2.infected_spawn_8
  , p1.infected_boomer_vomits = p1.infected_boomer_vomits + p2.infected_boomer_vomits
  , p1.infected_boomer_blinded = p1.infected_boomer_blinded + p2.infected_boomer_blinded
  , p1.infected_hunter_pounce_counter = p1.infected_hunter_pounce_counter + p2.infected_hunter_pounce_counter
  , p1.infected_hunter_pounce_dmg = p1.infected_hunter_pounce_dmg + p2.infected_hunter_pounce_dmg
  , p1.infected_smoker_damage = p1.infected_smoker_damage + p2.infected_smoker_damage
  , p1.infected_jockey_damage = p1.infected_jockey_damage + p2.infected_jockey_damage
  , p1.infected_jockey_ridetime = p1.infected_jockey_ridetime + p2.infected_jockey_ridetime
  , p1.infected_charger_damage = p1.infected_charger_damage + p2.infected_charger_damage
  , p1.infected_tank_damage = p1.infected_tank_damage + p2.infected_tank_damage
  , p1.infected_tanksniper = p1.infected_tanksniper + p2.infected_tanksniper
  , p1.infected_spitter_damage = p1.infected_spitter_damage + p2.infected_spitter_damage
  , p1.mutations_kills_survivors = p1.mutations_kills_survivors + p2.mutations_kills_survivors
  , p1.playtime_mutations = p1.playtime_mutations + p2.playtime_mutations
  , p1.points_mutations = p1.points_mutations + p2.points_mutations
WHERE
  p1.steamid = 'STEAM_1:0:AAAAAAAAAA'
  AND p2.steamid = 'STEAM_1:0:BBBBBBBBBB'

[muukis]

This query will add temp database stats to the main database. This will work only for those SteamIDs that exists in both database. If there are players in the temp database that do not exist in the main database, their score will not be added. Another query is required for copying them. You would need to copy the maps table also in similar fashion. If you want me to do you all the remaining queries, just ask.

UPDATE
  MAINDATABASE.players p1
  , TEMPDATABASE.players p2
SET
  p1.playtime = p1.playtime + p2.playtime
  , p1.playtime_versus = p1.playtime_versus + p2.playtime_versus
  , p1.playtime_realism = p1.playtime_realism + p2.playtime_realism
  , p1.playtime_survival = p1.playtime_survival + p2.playtime_survival
  , p1.playtime_scavenge = p1.playtime_scavenge + p2.playtime_scavenge
  , p1.playtime_realismversus = p1.playtime_realismversus + p2.playtime_realismversus
  , p1.points = p1.points + p2.points
  , p1.points_realism = p1.points_realism + p2.points_realism
  , p1.points_survival = p1.points_survival + p2.points_survival
  , p1.points_survivors = p1.points_survivors + p2.points_survivors
  , p1.points_infected = p1.points_infected + p2.points_infected
  , p1.points_scavenge_survivors = p1.points_scavenge_survivors + p2.points_scavenge_survivors
  , p1.points_scavenge_infected = p1.points_scavenge_infected + p2.points_scavenge_infected
  , p1.points_realism_survivors = p1.points_realism_survivors + p2.points_realism_survivors
  , p1.points_realism_infected = p1.points_realism_infected + p2.points_realism_infected
  , p1.kills = p1.kills + p2.kills
  , p1.melee_kills = p1.melee_kills + p2.melee_kills
  , p1.headshots = p1.headshots + p2.headshots
  , p1.kill_infected = p1.kill_infected + p2.kill_infected
  , p1.kill_hunter = p1.kill_hunter + p2.kill_hunter
  , p1.kill_smoker = p1.kill_smoker + p2.kill_smoker
  , p1.kill_boomer = p1.kill_boomer + p2.kill_boomer
  , p1.kill_spitter = p1.kill_spitter + p2.kill_spitter
  , p1.kill_jockey = p1.kill_jockey + p2.kill_jockey
  , p1.kill_charger = p1.kill_charger + p2.kill_charger
  , p1.versus_kills_survivors = p1.versus_kills_survivors + p2.versus_kills_survivors
  , p1.scavenge_kills_survivors = p1.scavenge_kills_survivors + p2.scavenge_kills_survivors
  , p1.realism_kills_survivors = p1.realism_kills_survivors + p2.realism_kills_survivors
  , p1.jockey_rides = p1.jockey_rides + p2.jockey_rides
  , p1.charger_impacts = p1.charger_impacts + p2.charger_impacts
  , p1.award_pills = p1.award_pills + p2.award_pills
  , p1.award_adrenaline = p1.award_adrenaline + p2.award_adrenaline
  , p1.award_fincap = p1.award_fincap + p2.award_fincap
  , p1.award_medkit = p1.award_medkit + p2.award_medkit
  , p1.award_defib = p1.award_defib + p2.award_defib
  , p1.award_charger = p1.award_charger + p2.award_charger
  , p1.award_jockey = p1.award_jockey + p2.award_jockey
  , p1.award_hunter = p1.award_hunter + p2.award_hunter
  , p1.award_smoker = p1.award_smoker + p2.award_smoker
  , p1.award_protect = p1.award_protect + p2.award_protect
  , p1.award_revive = p1.award_revive + p2.award_revive
  , p1.award_rescue = p1.award_rescue + p2.award_rescue
  , p1.award_campaigns = p1.award_campaigns + p2.award_campaigns
  , p1.award_tankkill = p1.award_tankkill + p2.award_tankkill
  , p1.award_tankkillnodeaths = p1.award_tankkillnodeaths + p2.award_tankkillnodeaths
  , p1.award_allinsafehouse = p1.award_allinsafehouse + p2.award_allinsafehouse
  , p1.award_friendlyfire = p1.award_friendlyfire + p2.award_friendlyfire
  , p1.award_teamkill = p1.award_teamkill + p2.award_teamkill
  , p1.award_left4dead = p1.award_left4dead + p2.award_left4dead
  , p1.award_letinsafehouse = p1.award_letinsafehouse + p2.award_letinsafehouse
  , p1.award_witchdisturb = p1.award_witchdisturb + p2.award_witchdisturb
  , p1.award_pounce_perfect = p1.award_pounce_perfect + p2.award_pounce_perfect
  , p1.award_pounce_nice = p1.award_pounce_nice + p2.award_pounce_nice
  , p1.award_perfect_blindness = p1.award_perfect_blindness + p2.award_perfect_blindness
  , p1.award_infected_win = p1.award_infected_win + p2.award_infected_win
  , p1.award_scavenge_infected_win = p1.award_scavenge_infected_win + p2.award_scavenge_infected_win
  , p1.award_bulldozer = p1.award_bulldozer + p2.award_bulldozer
  , p1.award_survivor_down = p1.award_survivor_down + p2.award_survivor_down
  , p1.award_ledgegrab = p1.award_ledgegrab + p2.award_ledgegrab
  , p1.award_gascans_poured = p1.award_gascans_poured + p2.award_gascans_poured
  , p1.award_upgrades_added = p1.award_upgrades_added + p2.award_upgrades_added
  , p1.award_matador = p1.award_matador + p2.award_matador
  , p1.award_witchcrowned = p1.award_witchcrowned + p2.award_witchcrowned
  , p1.award_scatteringram = p1.award_scatteringram + p2.award_scatteringram
  , p1.infected_spawn_1 = p1.infected_spawn_1 + p2.infected_spawn_1
  , p1.infected_spawn_2 = p1.infected_spawn_2 + p2.infected_spawn_2
  , p1.infected_spawn_3 = p1.infected_spawn_3 + p2.infected_spawn_3
  , p1.infected_spawn_4 = p1.infected_spawn_4 + p2.infected_spawn_4
  , p1.infected_spawn_5 = p1.infected_spawn_5 + p2.infected_spawn_5
  , p1.infected_spawn_6 = p1.infected_spawn_6 + p2.infected_spawn_6
  , p1.infected_spawn_8 = p1.infected_spawn_8 + p2.infected_spawn_8
  , p1.infected_boomer_vomits = p1.infected_boomer_vomits + p2.infected_boomer_vomits
  , p1.infected_boomer_blinded = p1.infected_boomer_blinded + p2.infected_boomer_blinded
  , p1.infected_hunter_pounce_counter = p1.infected_hunter_pounce_counter + p2.infected_hunter_pounce_counter
  , p1.infected_hunter_pounce_dmg = p1.infected_hunter_pounce_dmg + p2.infected_hunter_pounce_dmg
  , p1.infected_smoker_damage = p1.infected_smoker_damage + p2.infected_smoker_damage
  , p1.infected_jockey_damage = p1.infected_jockey_damage + p2.infected_jockey_damage
  , p1.infected_jockey_ridetime = p1.infected_jockey_ridetime + p2.infected_jockey_ridetime
  , p1.infected_charger_damage = p1.infected_charger_damage + p2.infected_charger_damage
  , p1.infected_tank_damage = p1.infected_tank_damage + p2.infected_tank_damage
  , p1.infected_tanksniper = p1.infected_tanksniper + p2.infected_tanksniper
  , p1.infected_spitter_damage = p1.infected_spitter_damage + p2.infected_spitter_damage
  , p1.mutations_kills_survivors = p1.mutations_kills_survivors + p2.mutations_kills_survivors
  , p1.playtime_mutations = p1.playtime_mutations + p2.playtime_mutations
  , p1.points_mutations = p1.points_mutations + p2.points_mutations
WHERE
  p1.steamid = p2.steamid

[SpiritBob]

Hello!

I've been using this since 2013 I believe, and I noticed this problem just now. After the server runs for quite a long time (Like 3-4 hours, always active with players). All commands work, but the connection with the Database has been dropped. NO longer do you see messages about how many points you get or anything like that, yet you can use commands like RANKMENU and view your points. I've checked and the points are not updating, so its not some chat issue, it really does not update/have connection with the database. No errors or anything like that. I've heard a person complain about this too before me. Is this our problem, or from the plugin? I've never had such problem with my database, and it could be an update issue.


EDIT: Compiling the .sp given in github is giving me 2 errors about GetClientAuthID. What am I missing, why can't I compile the newest version? Ah it's because of my sourcemod version, I will update it now. Hope it doesn't break anything

[muukis]

Originally Posted by SpiritBob Hello! I've been using this since 2013 I believe, and I noticed this problem just now. After the server runs for quite a long time (Like 3-4 hours, always active with players). All commands work, but the connection with the Database has been dropped. NO longer do you see messages about how many points you get or anything like that, yet you can use commands like RANKMENU and view your points. I've checked and the points are not updating, so its not some chat issue, it really does not update/have connection with the database. No errors or anything like that. I've heard a person complain about this too before me. Is this our problem, or from the plugin? I've never had such problem with my database, and it could be an update issue. EDIT: Compiling the .sp given in github is giving me 2 errors about GetClientAuthID. What am I missing, why can't I compile the newest version? Ah it's because of my sourcemod version, I will update it now. Hope it doesn't break anything

It can be, that the plugin code with the database connection is bugged. Maybe the connection needs to be recreated or refreshed etc. It still seems that the SourceMod is bugged too, if the queries doesn't work yet no error occurs? I can try to Google similar cases with MySQL. I'm sorry but I don't have anything better to offer, at the moment. The GitHub version should be fine. The only thing I have updated are the warnings. I haven't uploaded it here yet, because I have not tested that version properly.

[SpiritBob]

Originally Posted by muukis It can be, that the plugin code with the database connection is bugged. Maybe the connection needs to be recreated or refreshed etc. It still seems that the SourceMod is bugged too, if the queries doesn't work yet no error occurs? I can try to Google similar cases with MySQL. I'm sorry but I don't have anything better to offer, at the moment. The GitHub version should be fine. The only thing I have updated are the warnings. I haven't uploaded it here yet, because I have not tested that version properly.

Just to clarify things up, I have skipped installing webstats. I imported the .sql file present in your attachments and that was all I've ever done. Stats are recording without problem, so It shouldn't be from the .sql dump file.

[muukis]

Originally Posted by SpiritBob Just to clarify things up, I have skipped installing webstats. I imported the .sql file present in your attachments and that was all I've ever done. Stats are recording without problem, so It shouldn't be from the .sql dump file.

I think the dump is deprecated. I'll do a complete reinstall and create a dump from there, and then upload it in the first post.

[Parallax83]

Hello placed Statistics okay but error logs out how to fix it?

errors_20150704.log

L 07/04/2015 - 15:10:20: SourceMod error session started
L 07/04/2015 - 15:10:20: Info (map "l4d_smalltown05_houseboat") (file "errors_20150704.log")
L 07/04/2015 - 15:10:20: [l4d_stats.smx] GetClientPointsWorker Query failed: Can't connect to MySQL server on '127.0.0.1' (10061)
L 07/04/2015 - 15:10:21: [l4d_stats.smx] GetClientPointsWorker Query failed: Can't connect to MySQL server on '127.0.0.1' (10061)
L 07/04/2015 - 15:10:22: [l4d_stats.smx] GetClientPointsWorker Query failed: Can't connect to MySQL server on '127.0.0.1' (10061)
L 07/04/2015 - 15:25:53: [l4d_stats.smx] GetClientPointsWorker Query failed: Can't connect to MySQL server on '127.0.0.1' (10061)
L 07/04/2015 - 15:25:55: [l4d_stats.smx] SQL Error: Can't connect to MySQL server on '127.0.0.1' (10061) (Query: "UPDATE players SET melee_kills = melee_kills + 1 WHERE steamid = 'STEAM_1:0:1726582740'")
L 07/04/2015 - 152:05: Error log file session closed.

[muukis]

Originally Posted by Parallax83 Hello placed Statistics okay but error logs out how to fix it? errors_20150704.log L 07/04/2015 - 15:10:20: SourceMod error session started L 07/04/2015 - 15:10:20: Info (map "l4d_smalltown05_houseboat") (file "errors_20150704.log") L 07/04/2015 - 15:10:20: [l4d_stats.smx] GetClientPointsWorker Query failed: Can't connect to MySQL server on '127.0.0.1' (10061) L 07/04/2015 - 15:10:21: [l4d_stats.smx] GetClientPointsWorker Query failed: Can't connect to MySQL server on '127.0.0.1' (10061) L 07/04/2015 - 15:10:22: [l4d_stats.smx] GetClientPointsWorker Query failed: Can't connect to MySQL server on '127.0.0.1' (10061) L 07/04/2015 - 15:25:53: [l4d_stats.smx] GetClientPointsWorker Query failed: Can't connect to MySQL server on '127.0.0.1' (10061) L 07/04/2015 - 15:25:55: [l4d_stats.smx] SQL Error: Can't connect to MySQL server on '127.0.0.1' (10061) (Query: "UPDATE players SET melee_kills = melee_kills + 1 WHERE steamid = 'STEAM_1:0:1726582740'") L 07/04/2015 - 152:05: Error log file session closed.

It seems that your MySQL server is not responding on '127.0.0.1', which is the same machine you are running the game server. If I've not totally forgotten how the plugin works, the plugin should go in fail state when it's starting, if it cannot connect to the server. In your case, it seems that the plugin was able to connect MySQL on starting up. The log message you've provided seems to me that for some reason your SQL has stopped responding while you were playing. My knowledge on how to configure a MySQL server is very limited. I suggest you try googling your problem.