Raised This Month: $ Target: $400
 0% 

plugin nvault to mysql


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
wach12
New Member
Join Date: Dec 2015
Old 12-13-2015 , 17:45   plugin nvault to mysql
Reply With Quote #1

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
}
__________________
Help Me
wach12 is offline
fysiks
Veteran Member
Join Date: Sep 2007
Location: Flatland, USA
Old 12-13-2015 , 18:01   Re: plugin nvault to mysql
Reply With Quote #2

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.
__________________

Last edited by fysiks; 12-13-2015 at 18:01.
fysiks is offline
wach12
New Member
Join Date: Dec 2015
Old 12-13-2015 , 18:13   Re: plugin nvault to mysql
Reply With Quote #3

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

Please help me
__________________
Help Me

Last edited by wach12; 12-13-2015 at 18:16.
wach12 is offline
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


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


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