No, that command does a completely different thing.Guardian Angel написа: ↑08 Мар 2019, 07:36 It's writen in some of Ocix posts with information for sql version. Just create new table with SQL_TABLE and after that u can take all the information from the previous table with command crxranks_update_mysql CRXRanks ( CRXRanks is your old table name, if you chaged that name just put yours) . You have to put this command in server console, if you dont have acces to it you have to write amx_rcon crxranks_update_mysql CRXRanks in your CStrike client.
I didn't upload such a plugin yet. I started making it, but I didn't really test it out. If you want, you can test it:
Код за потвърждение: Избери целия код
#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(iCurrent, iNumEntries, szKey[], szValue[], iTimeStamp, iData, iSize)
{
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)
}
}