AlliedModders

AlliedModders (https://forums.alliedmods.net/index.php)
-   Scripting Help (https://forums.alliedmods.net/forumdisplay.php?f=11)
-   -   plugin nvault to mysql (https://forums.alliedmods.net/showthread.php?t=276051)

wach12 12-13-2015 17:45

plugin nvault to mysql
 
Hello !
I am a new user and already please help :(

Will you help me change the record of nvault to MySQL?
Sorry for the mistakes. I do not speak English very well :/

Code:

#include <amxmodx>
#include <amxmisc>
#include <nvault>

#define PLUGIN        "System Monet"
#define AUTHOR        "kisiel96"
#define VERSION        "1.0.8"

#define ZADANIE_POKAZ_MONETY 666

#define VIP ADMIN_LEVEL_G

new nazwa_gracza[32][64],
identyfikator[32][64];

new monety[32];

new cvar_coins_kill,
cvar_coins_kill_hs,
cvar_coins_kill_vip,
cvar_coins_kill_hs_vip,

cvar_coins_defused,
cvar_coins_defused_vip,
cvar_coins_planted,
cvar_coins_planted_vip,

cvar_coins_rescue_hostage,
cvar_coins_rescue_hostage_vip,
cvar_coins_kill_hostage,
cvar_coins_kill_hostage_vip,

cvar_coins_ff,

cvar_typ_zapisu;

new coins_kill,
coins_kill_hs,
coins_kill_vip,
coins_kill_hs_vip,

coins_defused,
coins_defused_vip,
coins_planted,
coins_planted_vip,

coins_rescue_hostage,
coins_rescue_hostage_vip,
coins_kill_hostage,
coins_kill_hostage_vip,

coins_ff,

typ_zapisu;

new vault;

public plugin_init()
{       
        register_plugin(PLUGIN, VERSION, AUTHOR);
       
        register_event("DeathMsg", "DeathMsg", "a");
        register_event("ResetHUD", "ResetHUD", "abe");
        register_logevent("HostageRescued", 3, "1=triggered", "2=Rescued_A_Hostage");
        register_logevent("HostageKilled", 3, "1=triggered", "2=Killed_A_Hostage");
       
       
        cvar_coins_ff                                        =        register_cvar("cod_coins_friendlyfire", "0");
       
        cvar_coins_kill                                        =        register_cvar("cod_coins_kill", "1");
        cvar_coins_kill_vip                        =        register_cvar("cod_coins_kill_vip", "2");
        cvar_coins_kill_hs                                =        register_cvar("cod_coins_kill_hs", "3");
        cvar_coins_kill_hs_vip                        =        register_cvar("cod_coins_kill_hs_vip", "6");
       
        cvar_coins_planted                                =        register_cvar("cod_coins_planted", "1");
        cvar_coins_planted_vip                        =        register_cvar("cod_coins_planted_vip", "2");
        cvar_coins_defused                                =        register_cvar("cod_coins_defused", "1");
        cvar_coins_defused_vip                        =        register_cvar("cod_coins_defused_vip", "2");
       
        cvar_coins_rescue_hostage                =        register_cvar("cod_coins_rescue_hostage", "1");
        cvar_coins_rescue_hostage_vip        =        register_cvar("cod_coins_rescue_hostage_vip", "2");
        cvar_coins_kill_hostage                        =        register_cvar("cod_coins_kill_hostage", "2");
        cvar_coins_kill_hostage_vip        =        register_cvar("cod_coins_kill_hostage_vip", "1");
       
        cvar_typ_zapisu                                =        get_cvar_pointer("cod_savetype");
       
        vault=nvault_open("monety");
        if(vault == INVALID_HANDLE)
                set_fail_state("Nie mozna otworzyc pliku");
}

public plugin_natives()
{
        register_native("cod_get_user_coins", "PobierzMonety", 1);
        register_native("cod_set_user_coins", "UstawMonety", 1);
}       

public client_authorized(id)
{
        UsunMonety(id);
       
        get_user_name(id, nazwa_gracza[id], 63);
       
        typ_zapisu = get_pcvar_num(cvar_typ_zapisu);
       
        switch(typ_zapisu)
        {
                case 1: copy(identyfikator[id], 63, nazwa_gracza[id]);
                case 2: get_user_authid(id, identyfikator[id], 63);
                case 3: get_user_ip(id, identyfikator[id], 63);
        }
       
        Wczytaj(id);
}

public client_connect(id)
        Wczytaj(id);

public client_disconnect(id)
{
        Zapisz(id);
        UsunMonety(id)
}

public plugin_end()
        nvault_close(vault);

/////RESET MONET/////

public UsunMonety(id)
        monety[id] = 0;

/////ZLICZNIE MONET/////

public DeathMsg()
{
        new kid = read_data(1);
        new vid = read_data(2);
        new hs = read_data(3);
       
        if(kid == vid)
                return;
       
        coins_ff = get_pcvar_num(cvar_coins_ff)
       
        if(coins_ff == 0 && get_user_team(kid) == get_user_team(vid))
                return;
       
        coins_kill = get_pcvar_num(cvar_coins_kill);
        coins_kill_vip        = get_pcvar_num(cvar_coins_kill_vip);
        coins_kill_hs = get_pcvar_num(cvar_coins_kill_hs);
        coins_kill_hs_vip = get_pcvar_num(cvar_coins_kill_hs_vip);
       
        if(get_user_flags(kid) & VIP)
        {
                if(hs == 1)
                        monety[kid] += coins_kill_hs_vip;
                else
                        monety[kid] += coins_kill_vip;
        }
        else
        {
                if(hs == 1)
                        monety[kid] += coins_kill_hs;
                else
                        monety[kid] += coins_kill;
        }
}

public bomb_planted(planter)
{
        coins_planted = get_pcvar_num(cvar_coins_planted);
        coins_planted_vip = get_pcvar_num(cvar_coins_planted_vip);
       
        if(get_user_flags(planter) & VIP)
                monety[planter] += coins_planted_vip;
        else
                monety[planter] += coins_planted;
}

public bomb_defused(defuser)
{
        coins_defused = get_pcvar_num(cvar_coins_defused);
        coins_defused_vip = get_pcvar_num(cvar_coins_defused_vip);       
       
        if(get_user_flags(defuser) & VIP)
                monety[defuser] += coins_defused_vip;
        else
                monety[defuser] += coins_defused;
}

public HostageRescued(id)
{
        new loguser[80], name[32];
        read_logargv(0, loguser, 79);
        parse_loguser(loguser, name, 31);
       
        new id = get_user_index(name);
       
        coins_rescue_hostage = get_pcvar_num(cvar_coins_rescue_hostage);
        coins_rescue_hostage_vip = get_pcvar_num(cvar_coins_rescue_hostage_vip);
       
        if(get_user_flags(id) & VIP)
                monety[id] += coins_rescue_hostage_vip;
        else
                monety[id] += coins_rescue_hostage;
       
        return PLUGIN_CONTINUE
}

public HostageKilled(id)
{
        new loguser[80], name[32];
        read_logargv(0, loguser, 79);
        parse_loguser(loguser, name, 31);
       
        new id = get_user_index(name);
               
        coins_kill_hostage = get_pcvar_num(cvar_coins_kill_hostage);
        coins_kill_hostage_vip = get_pcvar_num(cvar_coins_kill_hostage_vip);
       
        if(get_user_flags(id) & VIP)
                monety[id] -= coins_kill_hostage_vip;
        else
                monety[id] -= coins_kill_hostage;
}


/////NATYWY/////

public UstawMonety(id, wartosc)
{
        monety[id] = wartosc
}

public PobierzMonety(id)
        return monety[id];

/////NVAULT/////

public Zapisz(id)
{
        new vaultkey[64], vaultdata[256];
        format(vaultkey, 63, "%s-monety", identyfikator[id]);
        format(vaultdata, 255, "%d#", monety[id]);
        nvault_set(vault, vaultkey, vaultdata);
       
        return PLUGIN_CONTINUE
}

public Wczytaj(id)
{
        new vaultkey[64], vaultdata[256];
        format(vaultkey, 63, "%s-monety", identyfikator[id]);
        format(vaultdata, 255, "%d#", monety[id]);
        nvault_get(vault, vaultkey, vaultdata,255);
       
        replace_all(vaultdata, 255, "#", " ");
       
        new monetytemp[33];
        parse(vaultdata, monetytemp, 32);
       
        monety[id] = str_to_num(monetytemp);
       
        return PLUGIN_CONTINUE
}


fysiks 12-13-2015 18:01

Re: plugin nvault to mysql
 
Why do you want to switch to MySQL?

You can find some tutorials about using MySQL in AMX Mod X plugins here. Since it's already coded for nvault, it might be easier to use Exolent's SQLVault include.

wach12 12-13-2015 18:13

Re: plugin nvault to mysql
 
I tried to remake himself this plugin. I failed to. MySQL needs to add a record buying coins for php

Please help me :)


All times are GMT -4. The time now is 17:59.

Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.