[n3wton]

Figured it would be the geo-location as there's a lot of locations in the world these days

I'll have a mess around, and i know that my server only excepts people from Europe, so i could remove all database entries from out of Europe? which must improve query time?

I'm also pretty sure that the host is pretty slow (it is free after all) but I will try contacting them see if anything can be done.

One last thing is, could it be that the mysql/php might be out of date, would that make much of a difference in speed?

Thanks for any input.

Yours
N3wton

[muukis]

Originally Posted by n3wton Figured it would be the geo-location as there's a lot of locations in the world these days I'll have a mess around, and i know that my server only excepts people from Europe, so i could remove all database entries from out of Europe? which must improve query time? I'm also pretty sure that the host is pretty slow (it is free after all) but I will try contacting them see if anything can be done. One last thing is, could it be that the mysql/php might be out of date, would that make much of a difference in speed? Thanks for any input. Yours N3wton

I don't think updating PHP and/or MySQL will speed up things much. I was able to drop a single location query time to 0.1 seconds in my system. This means 10 players would take about 1 second to query their locations. My system is quite fast, so I don't think you can do much better in any normal server system. But you can easily do a lot worse.

By cleaning the database from unnecessary rows to you (like Asia, Africa, NA and SA), you should get the boost you require.

[rava]

Hi,

L 07/07/2011 - 17:46:59: SourceMod error session started L 07/07/2011 - 17:46:59: Info (map "c1m2_streets") (file "errors_20110707.log") L 07/07/2011 - 17:46:59: [SM] Plugin encountered error 15: Array index is out of bounds L 07/07/2011 - 17:46:59: [SM] Displaying call stack trace for plugin "l4d_stats.smx": L 07/07/2011 - 17:46:59: [SM] [0] Line 6399, /home/groups/alliedmodders/forums/files/5/2/0/8/2/80462.attach::cmd_Say() L 07/07/2011 - 17:547: Error log file session closed. L 07/07/2011 - 19:12:48: SourceMod error session started L 07/07/2011 - 19:12:48: Info (map "c2m1_highway") (file "errors_20110707.log") L 07/07/2011 - 19:12:48: [SM] Plugin encountered error 15: Array index is out of bounds L 07/07/2011 - 19:12:48: [SM] Displaying call stack trace for plugin "l4d_stats.smx": L 07/07/2011 - 19:12:48: [SM] [0] Line 6399, /home/groups/alliedmodders/forums/files/5/2/0/8/2/80462.attach::cmd_Say() L 07/07/2011 - 19:28:12: Error log file session closed.

Is it serious doctor?

Yet all goes well, and I get errors in the logs!

Sorry for my bad english

[muukis]

Originally Posted by rava Hi, Is it serious doctor? Yet all goes well, and I get errors in the logs! Sorry for my bad english

There still seems to be some buggy remnants from the original plugin. I have now fixed this to the next version, but won't release new version for such a minor bug fix, sorry. You can however fix it yourself -> Find and replace cmd_Say with this:

PHP Code:

// Parse chat for RANK and TOP10 triggers.
public Action:cmd_Say(client, args)
{
    decl String:Text[192];
    new String:Command[64];
    new Start = 0;

    GetCmdArgString(Text, sizeof(Text));

    new TextLen = strlen(Text);

    // This apparently happens sometimes?
    if (TextLen <= 0)
    {
        return Plugin_Continue;
    }

    if (Text[TextLen-1] == '"')
    {
        Text[TextLen-1] = '\0';
        Start = 1;
    }

    // Command is never set? This will always result to false.
    //if (strcmp(Command, "say2", false) == 0)
    //    Start += 4;

    return HandleCommands(client, Text[Start]);
} 


[rava]

ok, thank you I test

[MonkeyDrone]

Did a setup on my dedicated L4D2 server. Works incredibly awesome. I'm ranked #2 on my own server!!! <3

[Crotan]

Originally Posted by muukis There still seems to be some buggy remnants from the original plugin. I have now fixed this to the next version, but won't release new version for such a minor bug fix, sorry. You can however fix it yourself -> Find and replace cmd_Say with this: PHP Code: // Parse chat for RANK and TOP10 triggers. public Action:cmd_Say(client, args) {     decl String:Text[192];     new String:Command[64];     new Start = 0;     GetCmdArgString(Text, sizeof(Text));     new TextLen = strlen(Text);     // This apparently happens sometimes?     if (TextLen <= 0)     {         return Plugin_Continue;     }     if (Text[TextLen-1] == '"')     {         Text[TextLen-1] = '\0';         Start = 1;     }     // Command is never set? This will always result to false.     //if (strcmp(Command, "say2", false) == 0)     //    Start += 4;     return HandleCommands(client, Text[Start]); }

where's or in what file is cmd say located?

[muukis]

Originally Posted by Crotan where's or in what file is cmd say located?

It is in plugin sourcecode. You will then need to compile the modified sourcecode. To do that, you have at least two options: 1) Using server sourcemod compiler. 2) Using the online SourceMod Plugin Compiler.

[Feindflug]

How does it get and save the Information? Via Steam id? Or Name?
And it is changeable?

[muukis]

Originally Posted by Feindflug How does it get and save the Information? Via Steam id? Or Name? And it is changeable?

Using Steam ID as player identifier, because it is the only sure method to specify a player. While on LAN, it identifies the player using IP.