OciXCrom's Rank System v3.10

[Nordic Warrior]

Djo, в описании её правда нет (модеры поправьте), но в самой теме кидали.

 

[OciXCrom]

Djo, looks like it got lost in the translation. I put it back in its place.

 

[pheronix]

pheronix
It won't and should not transfer automatically.

You can try using this this plugin I made a while ago. Have in mind that if the nVault file is big it can take a long time to transfer. It's not fully tested either.

#include <amxmodx>
#include <crxranks>
#include <nvault_util>
#include <sqlx>

#define PLUGIN_VERSION "1.0"

new g_szTable[32], Handle:g_iTuple

public plugin_init()
{
    register_plugin("CRXRanks: nVault to MySQL", PLUGIN_VERSION, "OciXCrom")
    register_cvar("CRXRanksTransfer", PLUGIN_VERSION, FCVAR_SERVER|FCVAR_SPONLY|FCVAR_UNLOGGED)
    register_srvcmd("crxranks_nvault_to_mysql", "Cmd_Transfer")
}

public Cmd_Transfer()
{
    static bUsed

    if(bUsed)
    {
        server_print("Data has already been transfered once during this map. There's no point in transfering it again.")
        return PLUGIN_HANDLED
    }

    new szHost[32], szUser[32], szPassword[32], szDatabase[32]
    crxranks_get_setting("SQL_HOST", szHost, charsmax(szHost))
    crxranks_get_setting("SQL_USER", szUser, charsmax(szUser))
    crxranks_get_setting("SQL_PASSWORD", szPassword, charsmax(szPassword))
    crxranks_get_setting("SQL_DATABASE", szDatabase, charsmax(szDatabase))
    crxranks_get_setting("SQL_TABLE", g_szTable, charsmax(g_szTable))

    g_iTuple = SQL_MakeDbTuple(szHost, szUser, szPassword, szDatabase)

    new szVault[32]
    crxranks_get_setting("VAULT_NAME", szVault, charsmax(szVault))

    new iVault = nvault_util_open(szVault)
    nvault_util_readall (iVault, "OnVaultRead")
    nvault_util_close(iVault)
    bUsed = true

    return PLUGIN_HANDLED
}

public OnVaultRead (Current, NumEntries, szKey [], szValue [], TimeStamp, Data, Help)
{
    static szQuery[128]
    formatex(szQuery, charsmax(szQuery), "INSERT INTO %s (`Player`,`XP`,`Level`,`Next XP`,`Rank`,`Next Rank`) VALUES ('%s','%s','1','0','n/a','n/a');", g_szTable, szKey, szValue)
    SQL_ThreadQuery(g_iTuple, "QueryHandler", szQuery)
}

public QueryHandler(iFailState, Handle:iQuery, szError[], iErrorCode)
{
    if(iFailState == TQUERY_CONNECT_FAILED || iFailState == TQUERY_QUERY_FAILED)
    {
        server_print(szError)
    }
}

The command is crxranks_nvault_to_mysql. It must be executed through the server's console (or rcon).

Minni
That code requires quite some editing + it doesn't even transfer to MySQL automatically.

Do I Have to create Sql Table Myself ? I Dont know how to create xD

 

[OciXCrom]

pheronix, no. The table is created automatically.

 

[pheronix]

pheronix, no. The table is created automatically.

Error :(

 

[Nordic Warrior]

pheronix, https://dev-cs.ru/forums/plugins-errors/ please create new topic for your problem

 

[pheronix]

pheronix, https://dev-cs.ru/forums/plugins-errors/ please create new topic for your problem

Please Check above which plugin i am talking about

 

[s1ngle]

sbelov020, Привет можно как то сделать под радаром и чтобы указывалась группа в вк?

 

[Nordic Warrior]

s1ngle, как это относится к данному плагину?

 

[s1ngle]

sbelov020, я имею ввиду можно сделать так под радаром ниже указывалась группа в вк
Rank:
Level:
XP:
vk.com/

 

[Nordic Warrior]

s1ngle, можно. Почитай описание, как настроить информер.

 

[s1ngle]

sbelov020, немного не понимаю
HUDINFO_FORMAT = [ Звание: $rank$ | Уровеь: $level$/$max_levels$ | XP: $current_xp$/$next_xp$ ]\nvk.com/
HUDINFO_FORMAT_FINAL = [ Уровень $level$: $rank$ | XP: $current_xp$ ]\nvk.com/
так правильно?

 

[Nordic Warrior]

s1ngle, да.

 

[s1ngle]

sbelov020, благодарю

 

[OciXCrom]

s1ngle, use $br$ for a new line instead of \n (click for a full list of available keywords).
Also, you can use the HUDINFO_POSITION setting to move the HUD message below the radar.

 

[OciXCrom]

Resource OciXCrom's Rank System has been updated:

Update v3.8.1 - optimized name change handling

Click on this link for update details

 

[Djo]

Бонус к вип работает через раз, как рассказали игроки иногда помогает перезаход. Кто-нибудь сталкивался?

 

[OciXCrom]

Бонус к вип работает через раз, как рассказали игроки иногда помогает перезаход. Кто-нибудь сталкивался?

Are you talking about the bonus from the [XP Rewards] section? Can you show how you set up the rewards and the VIP flag?

 

[Nordic Warrior]

OciXCrom, а для чего эта строка?

 

[Djo]

OciXCrom, Как-то так.

Спойлер: Вот

# Users with these flags are considered VIP and will get the extra XP set in the [XP Rewards] section.
VIP_FLAGS = t
kill = 1 2
death = -2
suicide = -4
headshot = 2 3
team_win = 1 2
team_lose = -2 -1
knife = 5 6
grenade = 4 6
bomb_planted = 3 4
bomb_exploded = 4 5
bomb_defused = 3 4