[muukis]

Originally Posted by banz Got this error in logs when someone should get the award scatteringram: SQL Error: Unknown column 'acharger_impacts' in 'field list' (Query: "UPDATE players SET points_infected = points_infected + 40, award_scatteringram = acharger_impacts = charger_impacts + 4 WHERE steamid = 'STEAM_1:1:12345678'" EDIT: with version 1.4B80

You are correct. Thanks! I will upload a fix soon.

[Inf3ct t3D]

Originally Posted by Inf3ct t3D Thanks, much appreciated! Btw.. I am running L4D2.. if that matters.. I just don't understand the whole mysql and php things.. I have a website which supports both, and my server host...

*BUMP*

[Inf3ct t3D]

Originally Posted by r3dw3r3w0lf Its very simple, i'll make a tutorial later.

*BUMP* *BUMP*

[muukis]

New version...

• 7.5.2010 Plugin v1.4B86 and Web Stats
  • General support for all Mutations
  • Bugfixes - Scattering Ram award failed to store to DB because of a bug in query generation. Web stats was still missing some table prefix code and some of the scripts did not take count the new stored stats.

On top of that I did some edits n the web stats. I'm sure some of you will hate it, but you can still continue to use the old template (layout.tpl). Just create your custom layout with only that old file in it.

[Darkimmortal]

On line 6611 you reference a 7th column -

PHP Code:

ClientGameModePoints[client][GAMEMODE_MUTATIONS] = SQL_FetchInt(hndl, GAMEMODE_MUTATIONS); 


However, the query only returns 6: (line 1915)

PHP Code:

    Format(query, sizeof(query), "SELECT points, points_survivors + points_infected, points_realism, points_survival, points_scavenge_survivors + points_scavenge_infected, points_realism_survivors + points_realism_infected FROM %splayers WHERE steamid = '%s'", DbPrefix, SteamID); 


Unless I'm mistaken, it is leading to this error:

L 05/08/2010 - 19:29:17: [SM] Native "SQL_FetchInt" reported: Error fetching data from field 6
L 05/08/2010 - 19:29:17: [SM] Displaying call stack trace for plugin "l4d_stats.smx":
L 05/08/2010 - 19:29:17: [SM]   [0]  Line 6611, /home/groups/alliedmodders/forums/files/5/2/0/8/2/65262.attach::GetClientGameModePoints()
L 05/08/2010 - 19:29:17: [SM]   [1]  Line 2013, /home/groups/alliedmodders/forums/files/5/2/0/8/2/65262.attach::QueryClientStatsDP_1()

[DmanWCG]

OK, I have a stupid Question. I am running two servers and I have them both running off one DB. If player "A" plays on server #1 will it keep the stats? If player "A" then goes to Server #2 will it add to those stats?

[Cookies]

I dont see why not it does that for me or it did untill i had the problem which is posted above your post.

[pompetti]

Originally Posted by muukis I'll look if there is a way to determine if a sound is already precached. Did not know it could cause problems like this.

Any progress on this issue?

[muukis]

Originally Posted by Darkimmortal On line 6611 you reference a 7th column - PHP Code: ClientGameModePoints[client][GAMEMODE_MUTATIONS] = SQL_FetchInt(hndl, GAMEMODE_MUTATIONS);  However, the query only returns 6: (line 1915) PHP Code:     Format(query, sizeof(query), "SELECT points, points_survivors + points_infected, points_realism, points_survival, points_scavenge_survivors + points_scavenge_infected, points_realism_survivors + points_realism_infected FROM %splayers WHERE steamid = '%s'", DbPrefix, SteamID);  Unless I'm mistaken, it is leading to this error: L 05/08/2010 - 19:29:17: [SM] Native "SQL_FetchInt" reported: Error fetching data from field 6 L 05/08/2010 - 19:29:17: [SM] Displaying call stack trace for plugin "l4d_stats.smx": L 05/08/2010 - 19:29:17: [SM] [0] Line 6611, /home/groups/alliedmodders/forums/files/5/2/0/8/2/65262.attach::GetClientGameModePoints() L 05/08/2010 - 19:29:17: [SM] [1] Line 2013, /home/groups/alliedmodders/forums/files/5/2/0/8/2/65262.attach::QueryClientStatsDP_1()

Yes, you are correct! Thanks!

Originally Posted by DmanWCG OK, I have a stupid Question. I am running two servers and I have them both running off one DB. If player "A" plays on server #1 will it keep the stats? If player "A" then goes to Server #2 will it add to those stats?

Yes. Player "A" has one rank for all of the servers running on one database.

Originally Posted by pompetti Any progress on this issue?

Sorry, totally forgot that. I'll dig in right away...

[muukis]

Uploaded a fix for the problems posted above...

• 9.5.2010 Plugin v1.4B87
  • Bugfixes - Precached sounds may have caused problems with other plugins. Forgot to add mutations in one query. Thanks for the feedback Darkimmortal.