[stevieboy]

Originally Posted by willy1234x1 I can translate it to Portuguese if there's enough demand.

If you do it for yourself it would be great if you provide the file for all.

[Natalya[AF]]

I've been trying to install this on my server (CS:S running Zombie Mod) but it seems that the plugin won't load at all. !maprate and !maprating return the unknown command error in console.

Are the install instructions really just to copy those two files? It seems like there should be a lot more given what you have this plugin do.

[stevieboy]

Originally Posted by Natalya[AF] Are the install instructions really just to copy those two files? It seems like there should be a lot more given what you have this plugin do.

No, of course you have to have a working SQL-Connection to store the ratings. This might not be clear from the 2 installation points given but reading the cvars and the usage of this plugin it may was kinda implicitly declared.

Anyway: Setup a working default-database, create the table and then try to reload the plugin. Maybe it helps if you try to issue "sm_resetratings" to test the connection.

[willy1234x1]

K for those who don't know SQL here's a simple solution to install it.

Step one. download the maprate.sp file (click on get source.)

Step two. open the maprate.sp in a text editor such as notepad++ or even notepad (can be done by right clicking and clicking on open with then selecting the program)

step three. find the cvar maprate_db_config and change it's value to "maprate" take this time to edit any other cvars you want changed.

 g_cvars[CVAR_DB_CONFIG] = CreateConVar(
    "maprate_db_config",
    "maprate",
    "Database configuration to use for Map Rate plugin",
    FCVAR_PLUGIN);

Should look like this once edited.

step four. find your databases.cfg and add the following database

   "maprate"
    {
        "driver"            "sqlite"
        "database"            "maprate"
    }

step five. compile your maprate.sp either with the one in the scripting folder or with this one http://www.sourcemod.net/compiler.php

step six. place the maprate.sp in your scripting folder and the maprate.smx you just compiled in the plugins folder and restart your server.

Congratulations you have maprate working now.
Credits for this tutorial go to Redheadkid since he helped me out back when I just started with SM (last month haha.)

P.S. Stevieboy I'll post up the Portugeuse translations soon. They're going to be in the BR-Portugeuse so if anyone wanted standard Portugal Portugeuse sorry. I'm Brazilian not Portugeuse.

P.S.S. Sorry to anyone who thinks that the tutorial is talking down I just wanted to make it as easy as possible.

[stevieboy]

Originally Posted by willy1234x1 K for those who don't know SQL here's a simple solution to install it. ...

Thank you for your description, but...

Do you rly think THAT is simple?

You don't have to edit any sourcecode line, you just have to make a config and edit it.

Originally Posted by willy1234x1 P.S. Stevieboy I'll post up the Portugeuse translations soon. They're going to be in the BR-Portugeuse so if anyone wanted standard Portugal Portugeuse sorry. I'm Brazilian not Portugeuse.

Thank you but I don't need it since i'm German. I just wanted to encourage you (as everyone else) to contribute sth back.


@FLOOR_MASTER

Would you mind to use

AutoExecConfig(true);

in your

OnPluginStart()

(after all CVARs are set) from the next release on?

This will greatly improve the configuration and installation process since it creates and reads a config with all possible values.

This might have been the reason for willy1234 to choose such a way of installation...

[willy1234x1]

Nah my reason is because I like looking at source code I learn a lot from it.

[stevieboy]

Originally Posted by willy1234x1 Nah my reason is because I like looking at source code I learn a lot from it.

So I did it too. BUT: To post this as a "simple installation" is quite... well... ... erm ... let's say strange.

[Natalya[AF]]

Willy's tutorial was weird but I followed it and it worked for me so thanks for posting it. ;)

[riuthamus]

CONSOLE LOG:

22:24:05 [SM] Plugin Map Rate unloaded successfully.
22:24:09 sm plugins load maprate
22:24:09 [MAPRATE] Using table name "map_ratings"
22:24:09 L 07/16/2008 - 22:24:14: [maprate.smx] Error establishing database connection: [2003]: Can't connect to MySQL server on 'external-db.s14844.gridserver.com' (111)
22:24:09 L 07/16/2008 - 22:24:14: [maprate.smx] FATAL: An error occurred while connecting to the database.
22:24:09 [SM] Loaded plugin maprate.smx successfully.

DATABASE.CFG:

"Databases"
{
    "storage-local"
    {
        "driver"            "sqlite"
        "database"            "sourcemod-local"
    }
    
    "maprate"
    {
        "driver"           "default"
        "host"            "external-db.s14844.gridserver.com"
        "database"      "db14844_slaughterhouse"
        "user"            "************"
        "pass"            "********"
        //"timeout"       "0"
        //"port"            "0"
    }

    "stats"
    {
        "driver"            "default"
        "host"             "external-db.s14844.gridserver.com"
        "database"       "db14844_slaughterhouse"
        "user"              "*********"
        "pass"            "*********"
        //"timeout"            "0"
        //"port"            "0"
    }
}

SERVER.CFG
// Rate Map
maprate_db_config "maprate"
maprate_autorate_time "300"
maprate_autorate_delay "2"

[stevieboy]

riuthamus: Did you check if your game host allows to connect to a remote database and your mysql host allows external connects?!