[Whosat]

Delete the row in the mysql table.

Map stats will probably retain though.

@dominic1:
I sent a PM. Which is your server provider? sgwargames? fragnetics?

[dominic1]

Originally Posted by ShambleS it dosent look like you have a database selected, you dont seem to have all the files and the folders in the right places. and i would imagine you have not set the files to 777 after you uploaded.. You should read the instructions verry carefully and do everything 1 step at a time.

it worked alrdy, i thought it's hard but actually pretty easy.. i was just confused bcoz it's 1st time for me to setup db in msql.

[IMG]http://img33.**************/img33/7339/l4dproblem.jpg[/IMG]

[IMG]http://img411.**************/img411/4308/l4dproblem2.jpg[/IMG]

[Whosat]

Ah alright glad you got it working

[ShambleS]

Originally Posted by Whosat Delete the row in the mysql table. Map stats will probably retain though.

i dont think i can delete just 1 row...

[crazydog]

Just a quick bug report:
I've noticed that if I have in-game notifications off, people are still shown messages when they save others from hunters/smokers.

Edit:
Line 1790

    PrintToChat(Savior, "\x04[\x03RANK\x04] \x01You have earned \x04%i \x01points for saving \x05%s\x01 from a \x04%s!", Score, VictimName, SaveFrom);

doesn't have an "if(mode) clause around it, and HunterSmokerSave() doesn't declare Mode.

To anyone who wants to fix it themselves:

1) Go to line 1771 (decl String:SaviorName[MAX_LINE_WIDTH];)
2) Add the following on the previous line: new Mode = GetConVarInt(cvar_AnnounceMode);
3) Go to line 1790
4) Add the following on the previous line: if (Mode)

I've also attached the plugin with that quick change to this post.

[muukis]

I did some modifications to the plugin and some of the PHP-scripts.

Short descriptions:
Writes stats for custom maps (campaigns). The stats for custom maps are readable from the web stats.

Installation:
Overwrite the web stats PHP-scripts and run the updatetable.php before installing the customized plugin.

Technical stuff:
This will not reset any current stats. New field "custom" (bit) was added in table Maps. This will not cause problems when msleeper finally updates the plugin. Everytime the server loads a map in COOP mode, it checks if that map is in the DB. If it is not, it inserts it and sets the "custom" to true (1). The original maps are inserted with "custom" set to false (0). The PHP scripts lists all the custom maps at the bottom of the Campaign Stats -page. I don't know how to detect in which campaign they belong to.

I also included crazydogs "Line 1790" edit.

I hope everything works...

EDIT(1): Uploaded a version with an improved map detection.
EDIT(2): Uploaded modified player.php. Requested by Whosat.
EDIT(3): Uploaded modified maps.php. Added some checks that hopefully prevents occurance of some PHP-errors and if not then give a more detailed error message.

[poli21]

another great program, but its a pain in the ass for me to install this can someone make a vid tut on how to do this ? would be fantastic!

[Whosat]

Hey muukis

Could you add support for weird-character names as well, by using UTF-8 as the encoding?

This was mentioned in the PounceRecord plugin and here, here's the main fix in the sp, and this is for the web frontend.

And also when viewing a specific player's stats, there's a typo at the bottom, City Buster achivement. "That is alomst more than..."
And in that same section I guess its more right to use "<Playername> has killed more zombies than the entire population" than "You have killed more zombies than the entire population", because the person viewing the stats profile may not be the owner of the profile himself.

Will be most grateful

[muukis]

Originally Posted by Whosat ...

That UTF-8 encoding is already in there. Maybe you have set the browser or your web server incorrectly?

PHP Code:

public ConnectDB()
{
    if (SQL_CheckConfig("l4dstats"))
    {
        new String:Error[256];
        db = SQL_Connect("l4dstats", true, Error, sizeof(Error));

        if (db == INVALID_HANDLE)
            LogError("Failed to connect to database: %s", Error);
        else
            SendSQLUpdate("SET NAMES 'utf8'");
    }
    else
        LogError("Database.cfg missing 'l4dstats' entry!");
} 


About the rest of the stuff you mentioned... Download the attachment and overwrite the older file.

I will not take over the support or the development of this plugin. I just wanted to upload some improvements I sought useful for me atleast. SPeaking of which... I uploaded an improved version of the customized plugin right back HERE. If you already downloaded the customized plugin, please redownload the new one.

EDIT: uploaded player.php

[pF.VoOdoO]

@ muukis

Installed your modified files, ran updatetable.php, deleted updatetable.php and createtable.php, then installed the plugin.

I'm getting this error on the Campaign page

Warning:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /public_html/l4d/maps.php on line 50

and again at

Warning:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /public_html/l4d/maps.php on line 103

And it looks like it's wiped the total kills too

I have backups, but would rather resolve the issue

Edit - Just occured to me, reason for this is likely that we've not played any games with new stats as yet (shouldn't take long, all we play these days is custom maps) I'll leave this message as is incase I'm wrong or someone else has the same issue.