[shavit]

Originally Posted by wer1K "Databases" { "driver_default" "mysql" // When specifying "host", you may use an IP address, a hostname, or a socket file path "default" { "driver" "default" "host" "localhost" "database" "sourcemod" "user" "root" "pass" "" //"timeout" "0" //"port" "0" } "storage-local" { "driver" "sqlite" "database" "sourcemod-local" } "shavit" { "driver" "mysql" "host" "31.28.170.XXX" "database" "shavit_bhop" "user" "shavit_bhop" "pass" "XXXXXXXXX" } "clientprefs" { "driver" "sqlite" "host" "localhost" "database" "clientprefs-sqlite" "user" "root" "pass" "" //"timeout" "0" //"port" "0" } } Btw, connect to database is OK.

i fail to understand how people just skip the requirements and go straight to installing.

Requirements: A MySQL database. Hosted at the same machine the CS server is hosted at. I won't help with any MySQL related errors if your MySQL server isn't local.

[tuan206]

Anyone got a shavits_chat.cfg already setted up for ranking with points that they are willing to share? I would be very thankful

[wer1K]

Requirements: A MySQL database. Hosted at the same machine the CS server is hosted at. I won't help with any MySQL related errors if your MySQL server isn't local.

It's very sad, cuz I can't do this, my server on gamehosting and webserver on differend node.

[shavit]

Originally Posted by tuan206 Anyone got a shavits_chat.cfg already setted up for ranking with points that they are willing to share? I would be very thankful

here's my ugly csgo config:

"Chat"
{
    "[U:1:204506329]" // me
    {
        "prefix"        "{green}/dev/"
        "name"          "{default}{team}{clan}{name}"
    }

    "-1" // lookup is due, shouldn't happen unless there's some error!
    {
        "rank_from"     "-1"
        "rank_to"       "-1"

        "prefix"        ""
        "name"          "{team}{name}"
        "message"       "{message}"
    }

    "0" // unranked
    {
        "rank_from"     "0"
        "rank_to"       "0"

        "prefix"        "[Unranked]"
        "name"          "{team}{name}"
        "message"       "{message}"
    }

    "1"
    {
        "rank_from"     "1"
        "rank_to"       "1"

        "prefix"        "{orchid}strafe"
        "name"          "{clan}{gold}{name}"
        "message"       "{message}"
    }

    "2"
    {
        "rank_from"     "2"
        "rank_to"       "2"

        "prefix"        "{grey}EXPERT"
        "name"          "{lime}{name}"
        "message"       "{message}"
    }

    "3"
    {
        "rank_from"     "3"
        "rank_to"       "3"

        "prefix"        "{grey2}Deluxe"
        "name"          "{team}{name}"
        "message"       "{message}"
    }

    "4"
    {
        "rank_from"     "4"
        "rank_to"       "4"

        "prefix"        "{team}Senior"
        "name"          "{name}"
        "message"       "{message}"
    }

    "5"
    {
        "rank_from"     "5"
        "rank_to"       "5"

        "prefix"        "{darkblue}Legend"
        "name"          "{team}{name}"
        "message"       "{message}"
    }

    "6"
    {
        "rank_from"     "6"
        "rank_to"       "8"

        "prefix"        "{yellow}Ultra"
        "name"          "{name}"
        "message"       "{message}"
    }

    "7"
    {
        "rank_from"     "9"
        "rank_to"       "14"

        "prefix"        "{lightred}Bloody"
        "name"          "{team}{name}"
        "message"       "{message}"
    }

    "8"
    {
        "rank_from"     "15"
        "rank_to"       "25"

        "prefix"        "{default}Famous"
        "name"          "{team}{name}"
        "message"       "{message}"
    }

    "9"
    {
        "rank_from"     "26"
        "rank_to"       "35"

        "prefix"        "{bluegrey}Jumpy"
        "name"          "{team}{name}"
        "message"       "{message}"
    }

    "10"
    {
        "rank_from"     "36"
        "rank_to"       "50"

        "prefix"        "{darkblue}Best"
        "name"          "{team}{name}"
        "message"       "{message}"
    }

    "11"
    {
        "rank_from"     "51"
        "rank_to"       "75"

        "prefix"        "{darkred}Good"
        "name"          "{team}{name}"
        "message"       "{message}"
    }

    "12"
    {
        "rank_from"     "76"
        "rank_to"       "125"

        "prefix"        "{default}Decent"
        "name"          "{team}{name}"
        "message"       "{message}"
    }

    "13"
    {
        "rank_from"     "126"
        "rank_to"       "200"

        "prefix"        "{default}Gangster"
        "name"          "{team}{name}"
        "message"       "{message}"
    }

    "14"
    {
        "rank_from"     "201"
        "rank_to"       "500"

        "prefix"        "{default}Casual"
        "name"          "{team}{name}"
        "message"       "{message}"
    }

    "15"
    {
        "rank_from"     "501"
        "rank_to"       "1000"

        "prefix"        "{default}Player"
        "name"          "{team}{name}"
        "message"       "{message}"
    }

    "16"
    {
        "rank_from"     "1001"
        "rank_to"       "infinity"

        "prefix"        "{default}"
        "name"          "{team}{name}"
        "message"       "{message}"
    }
}

[wer1K]

Originally Posted by wer1K I have some errors, what I miss? L 07/20/2016 - 19:38:58: SourceMod error session started L 07/20/2016 - 19:38:58: Info (map "bhop_arcane_b2_rg3_csgo") (file "errors_20160720.log") L 07/20/2016 - 19:38:58: [SM] Exception reported: Invalid database Handle 0 (error: 4) L 07/20/2016 - 19:38:58: [SM] Blaming: shavit-rankings.smx() L 07/20/2016 - 19:38:58: [SM] Call stack trace: L 07/20/2016 - 19:38:58: [SM] [0] Database.Query L 07/20/2016 - 19:38:58: [SM] [1] Line 492, F:\CSGO\SourceMod Compiler\shavit-rankings.sp::UpdatePointsCache() L 07/20/2016 - 19:38:58: [SM] [2] Line 231, F:\CSGO\SourceMod Compiler\shavit-rankings.sp::OnMapStart() I'm using latest version from Github

I know solution this problem: I'm just set poins (sm_setpoints) on the map, then table was not empty and error's is gone.

[wer1K]

I have new question about shavit-timelimit.smx, in fresh version from Github they don't work, but plugin loaded and no error logs.

[shavit]

Originally Posted by wer1K I have new question about shavit-timelimit.smx, in fresh version from Github they don't work, but plugin loaded and no error logs.

your mapchooser plugin doesn't support it then

[wer1K]

your mapchooser plugin doesn't support it then

I'm using default mapchooser.smx from SourceMod 1.8 (with old version shavit-timelimit.smx work perfectly). Please, give me advice, what mapchooser I'm must using?

[shavit]

Originally Posted by wer1K I'm using default mapchooser.smx from SourceMod 1.8 (with old version shavit-timelimit.smx work perfectly). Please, give me advice, what mapchooser I'm must using?

actually i could've fix this issue by running a non-threaded query as it's only being ran once per map
i'll fix it soon

[tuan206]

No offense shavit, but ur config is really ugly thanks anyways though, anyone else wants to share?
*edit* also how does rank to and rank from work? Is it like point 501 to point above that gets the rank?