[Fora]

Originally Posted by muukis Yes, but you need to do some queries to your DB: You need to transfer all the data from another player to the other. It is quite simple query string, but right now I cannot access the computer with my DB, so I cannot be sure what the query should be like. If you are not abel to do it on your own and no one here helps you first, I'll try to write the query for you next time I remember this and I'm at the spot I can access my DB. It goes something like this: UPDATE players SET (in here you will write all the fields in the players table like so: BOOMERS_KILLED = BOOMERS_KILLED + t2.BOOMERS_KILLED, HUNTERS_KILLED = HUNTERS_KILLED + t2.HUNTERS_KILLED, ...) FROM players AS t2 WHERE steam_id = 123 AND t2.steam_id = 456 In this case the steam id 123 is the old one and the steam id 456 is the combined one. This is pretty much pseudosyntax, so you'll need to dig up the correct one from Google or get help otherwise, if you are not familiar to the syntax yourself.

Thanks muukis! I've fount this in my DB.

Originally Posted by skull_ Fora, yes. You need to update server's gamedata. Use the latest stable snapshot. This plugin also uses gamedata file, which i think needs to be updated, because the plugin doesn't function right.

I've updated my servers' gamedata file(l4d_stats.txt) but anyway crashing( and no any errors log files..

sm plugins list:

[SM] Listing 41 plugins:
01 "L4D1/2 Remove Lobby Reservation" (1.1.1) by Downtown1
02 "SourceBans" (1.4.9) by SourceBans Development Team
03 "Basic Info Triggers" (1.4.6) by AlliedModders LLC
04 "Basic Votes" (1.4.6) by AlliedModders LLC
05 "Anti-Flood" (1.4.6) by AlliedModders LLC
06 "L4D Force Mission Changer" (1.4.0) by Dionys,Visual77, Viragiste & Chronic1
07 "Basic Comm Control" (1.4.6) by AlliedModders LLC
08 "Player Commands" (1.4.6) by AlliedModders LLC
09 "Votekick Escape Ban" (1.2) by Die Teetasse
10 "[L4D/L4D2] Infected Bots Control" (1.0.0) by djromero (SkyDavid), MI 5
11 "PlayerAddCountryTag" (2.5.0) by n3wton
12 "Reserved Slots" (1.4.6) by AlliedModders LLC
13 "[L4D2] Weapon/Zombie Spawner" (1.0a) by Zuko & McFlurry
14 "No Mercy Elevator Fix" (1.0) by Mr. Zero
15 "Admin File Reader" (1.4.6) by AlliedModders LLC
16 "L4D Kick Load Stuckers" (1.0. by AtomicStryker
17 "Sound Commands" (1.4.6) by AlliedModders LLC
18 "Very Basic High Ping Kicker" (1.4) by msleeper
19 "L4DSwitchPlayers" (1.4) by SkyDavid (djromero)
20 "L4D Broadcast" (0.9.7) by Voiderest
21 "Survivor Bot Takeover" (0. by Mikko Andersson (muukis)
22 "L4D Survivor AI Pounced Fix" (1.0.4) by AtomicStryker
23 "Basic Commands" (1.4.6) by AlliedModders LLC
24 "[L4D2] Weapon Unlock" (0.8.1) by Crimson_Fox
25 "Advertisements" (0.5.5) by Tsunami
26 "ChatLogEx" (1.3.7) by muukis (original author Nephyrin)
27 "L4D No Move Bot Timer" (0.2) by AntiQar
28 "L4D2 Survivor AI Trigger Fix" (1.0.9) by AtomicStryker
29 "[L4D2] Vote Manager" (1.3.5) by McFlurry
30 Disabled: "Nextmap" (1.4.6) by AlliedModders LLC
31 "Fun Votes" (1.4.6) by AlliedModders LLC
32 "Fun Commands" (1.4.6) by AlliedModders LLC
33 "[L4D(2)] AFK and Join Team Commands" (1.1) by MasterMe
34 "Admin Help" (1.4.6) by AlliedModders LLC
35 "L4D2 Score/Team Manager" (1.2.9) by Downtown1 & AtomicStryker
36 "Basic Chat" (1.4.6) by AlliedModders LLC
37 "Admin Menu" (1.4.6) by AlliedModders LLC
38 "Client Preferences" (1.4.6) by AlliedModders LLC
39 "[L4D2] Objects Spawner" (2.0.6) by honorcode23
40 "L4D Assistance System" (1.6) by [E]c & Max Chu, SilverS & ViRaGisTe
41 "AFK Manager" (3.4.3) by Rothgar

sm ext list

[SM] Displaying 8 extensions:
[01] Left 4 Downtown 2 Extension (0.5.4.2): Downtown1's extension to perform useful L4D1/L4D2 calls
[02] BinTools (1.4.6): Low-level C/C++ Calling API
[03] SDK Tools (1.4.6): Source SDK Tools
[04] Top Menus (1.4.6): Creates sorted nested menus
[05] GeoIP (1.4.6): Geographical IP information
[06] Client Preferences (1.4.6): Saves client preference settings
[07] SQLite (1.4.6): SQLite Driver
[08] MySQL-DBI (1.4.6): MySQL driver implementation for DBI

logfile at the moment of crashing:

L 12/15/2012 - 19:59:52: muhammad starting a pounce, 150 damage interrupts
L 12/15/2012 - 19:59:52: (DEATH)"byblik_91<324><STEAM_1:1:57626869><Su rvivor><Coach><ALIVE><79+0><setpos_exact 547.44 4927.07 163.03; setang 10.16 133.83 0.00><Area 507908>" killed "infected<152><><Infected><infected><DEAD ><-37><setpos_exact 511.32 4956.91 101.03; setang -0.00 -43.71 0.00><Area 507908>" with "rifle_desert"
L 12/15/2012 - 19:59:53: muhammad ending a pounce
L 12/15/2012 - 19:59:53: muhammad starting a pounce, 150 damage interrupts
L 12/15/2012 - 19:59:53: (DEATH)"byblik_91<324><STEAM_1:1:57626869><Su rvivor><Coach><ALIVE><77+0><setpos_exact 549.41 4927.07 162.85; setang 16.09 128.70 0.00><Area 507908>" killed "infected<106><><Infected><infected><DEAD ><-37><setpos_exact 547.87 4956.08 99.36; setang -0.00 -86.01 0.00><Area 507908>" with "rifle_desert"
L 12/15/2012 - 19:59:53: muhammad pounced on Ellis, 250 damage interrupts
L 12/15/2012 - 19:59:54: (DEATH)"byblik_91<324><STEAM_1:1:57626869><Su rvivor><Coach><ALIVE><77+0><setpos_exact 548.04 4933.15 162.82; setang 18.37 47.56 0.00><Area 507908>" killed "infected<172><><Infected><infected><DEAD ><-37><setpos_exact 577.73 4958.74 96.03; setang 0.00 231.75 0.00><Area 507914>" with "rifle_desert"
L 12/15/2012 - 19:59:54: muhammad took 71/250 damage while pounced
L 12/15/2012 - 19:59:54: muhammad took 71/178 damage while pounced
L 12/15/2012 - 19:59:54: muhammad took 71/106 damage while pounced
L 12/15/2012 - 19:59:54: (DEATH)"sk(A)z<389><STEAM_1:1:40498768><Survi vor><Gambler><ALIVE><64+0><setpos_exact 917.58 5011.29 148.00; setang 9.19 -142.60 0.00><Area 507909>" killed "muhammad<337><STEAM_1:1:58604912><Infected>< HUNTER><DEAD><1+0><setpos 752.56 4890.63 96.03; setang 334.85 36.18 0.00><Area 507909>" with "rifle_ak47"
L 12/15/2012 - 19:59:55: filinp spawned as a BOOMER
L 12/15/2012 - 19:59:55: FindNearbySpawnSpot: Moving filinp from (825.000000, 4937.500000, 98.21038 to (812.854431, 4911.901367, 108.541679) in a nearby nav area (507909) with max range of 100.000000
L 12/15/2012 - 19:59:56: (DEATH)"Rochelle<408><BOT><Survivor><Producer ><ALIVE><69+0><setpos_exact 783.98 4900.46 158.03; setang 2.57 103.29 0.00><Area 507909>" killed "infected<144><><Infected><infected><DEAD ><-34><setpos_exact 670.34 5370.67 96.03; setang 0.00

[kennyfong19931]

Hi,muukis.
My server is host on a virtual lan (like Tunngle)
and the problem is each time I login to tunngle, I will get a different Lan IP, so the stats cannot continued.
Can you release a version with stats using Player name instead of Steam ID?

[muukis]

Originally Posted by kennyfong19931 Hi,muukis. My server is host on a virtual lan (like Tunngle) and the problem is each time I login to tunngle, I will get a different Lan IP, so the stats cannot continued. Can you release a version with stats using Player name instead of Steam ID?

Hi there! I'm sorry but I wont do an update to the stats plugin containing a player name identification. The reason is that the player name is VERY unreliable. If you're playing L4D(2) with custom player stats plugin on LAN, you should configure the LAN so that you all have static IPs.

Someone made a modification of the plugin earlier, that was identifying players by their names. Search for it and ask for the user kindly if he/she is willing to continue with it?

[eric0279]

If there are people interested in completing the translation of your plugin, he joins me here.

I'm having trouble to finish the translation, I'm not a real coder...

[Sidonicus]

Help needed :

Plug in is superb & working well with slight exceptions. Player IPs are not being posted to my DB, thus flags for player country are all set to international. If I open my PHPadmin and look at the player tables ip is set to 0.0.0.0. If I manually enter an ip into the table the flag then shows ok. Noticed other player table fields are not populating as well: melee_kills, kill_jockey, kill_spitter, kill_charger. As most are working I can only presume the prob is in srcds and it's not feeding some stats through to the plugin ?????

Else everything else working perfectly !

Any ideas?

[el_psycho]

Ummmm... I just made a new copy of my old server and have the same problem as Sidonicus (old servers are working fine).

The console is spamming this:

L 02/05/2013 - 08:37:30: [SM] Native "GetClientIP" reported: Client index 0 is invalid
L 02/05/2013 - 08:37:30: [SM] Displaying call stack trace for plugin "l4d_stats.smx":
L 02/05/2013 - 08:37:30: [SM]   [0]  Line 2682, l4d_stats.sp::UpdatePlayerFull()
L 02/05/2013 - 08:37:30: [SM]   [1]  Line 2706, l4d_stats.sp::UpdatePlayerCallback()

The strange thing is this new server is just a copy of the old one.
I will come back and report when i know more.

edit:
I found the cause. In my case it was an incomplete database. i had added an extra column to store the last used server port to the database in the players table and changed the plugin accordingly. I forgot about this with my new copy of the server.
So i would suggest to Sidonicus to check if you have all nessesary columns in the players table since adding the missing column fixed the problem for me.

[minos]

Hi! Thx for this plugin...

I'm lost with the google map feature :
- how to always show that map in the index page, with S for "server" as shown in your description ?
possible without players in server ?

Thx for help!

[muukis]

Originally Posted by minos Hi! Thx for this plugin... I'm lost with the google map feature : - how to always show that map in the index page, with S for "server" as shown in your description ? possible without players in server ? Thx for help!

First of all, sorry for the late answer. It should work like that? It does not for you?? Works for me.

[Evkval]

Help me pls. link does not work on Steam Profile

[IMG]http://img689.**************/img689/6051/screenshot20130420001q.jpg[/IMG]

[RasterMan]

Tried to compile with the latest Linux SM Snapshot 1.5.0-hg3841

//// l4d_stats.sp
// l4d_stats.sp(3011) : warning 200: symbol "StatsPrintToChatAllPreFormatted" is
truncated to 31 characters
// l4d_stats.sp(3011) : error 035: argument type mismatch (argument 1)
// l4d_stats.sp(7883) : warning 200: symbol "StatsPrintToChatAllPreFormatted" is
truncated to 31 characters
// l4d_stats.sp(7883) : error 035: argument type mismatch (argument 1)
// l4d_stats.sp(7969) : warning 200: symbol "StatsPrintToChatAllPreFormatted" is
truncated to 31 characters
// l4d_stats.sp(7969) : error 035: argument type mismatch (argument 1)
// l4d_stats.sp(8007) : warning 200: symbol "StatsPrintToChatAllPreFormatted" is
truncated to 31 characters
// l4d_stats.sp(8007) : error 035: argument type mismatch (argument 1)
// l4d_stats.sp(8015) : warning 200: symbol "StatsPrintToChatAllPreFormatted" is
truncated to 31 characters
// l4d_stats.sp(8015) : error 035: argument type mismatch (argument 1)
// l4d_stats.sp(11277) : warning 200: symbol "StatsPrintToChatAllPreFormatted" i
s truncated to 31 characters
// l4d_stats.sp(11277) : error 035: argument type mismatch (argument 1)
// l4d_stats.sp(11417) : warning 200: symbol "StatsPrintToChatAllPreFormatted" i
s truncated to 31 characters
// l4d_stats.sp(11417) : error 035: argument type mismatch (argument 1)
// l4d_stats.sp(11433) : warning 200: symbol "StatsPrintToChatAllPreFormatted" i
s truncated to 31 characters
// l4d_stats.sp(11433) : error 025: function heading differs from prototype
// l4d_stats.sp(11433) : error 025: function heading differs from prototype
// l4d_stats.sp(11434) : error 021: symbol already defined: "StatsPrintToChatAll
PreFormatted"
//
// 10 Errors.