[rezolvat]banca sql

[Ztm.Mihai]

as vrea sa stiu si eu cum pot sa setez o banca sa fie pe sql





Ztm.Freakz.Ro

[EDUTz]

https://forum.wow-freakz.com/PLUGIN-Yet-Another-Ammo-Bank-t298946.html

Uita-te acolo cum e facut.



Pentru pluginuri complicate le fac cu $$ pe paypal/psc. PM

[Ztm.Mihai]

da am mai avut banca asta dar nu imi salva credite trebuie setat cv aici

Code:

get_cvar_string("amx_sql_host", Host, 63)    get_cvar_string("amx_sql_user", User, 63)    get_cvar_string("amx_sql_pass", Pass, 63)    get_cvar_string("amx_sql_db", Db, 63)

daca da ce anume trb sa pun si trebuie sa activez aceste module - mysql
- sqlite din modules.ini ? multumesc





Ztm.Freakz.Ro

[SamDude]

Nu activezi nimic..sunt deja activate cand ai serverul deschis...modifica host,user,pass,db dupa nevoie cu informatiile de la baza ta de date pt a functiona

[TwisTer]

Mysql sã fie activat în modules.ini, deci scoate ; din faþa.

[Ztm.Mihai]

salut am modificat la host pass si resutl dar primesc eroare la compilare





Ztm.Freakz.Ro

[EDUTz]

Daca folosesti 4.3 foloeste direct .amxx-ul din arhiva, daca nu, compileaza varianta originala fara sa modifici decat definurile pt versiunea ta.



Pentru pluginuri complicate le fac cu $$ pe paypal/psc. PM

[Ztm.Mihai]

folosesc zombi plague advance 1.6.1 deci aici nu mai modific nimic?

Code:

get_cvar_string("amx_sql_host", Host, 63)    get_cvar_string("amx_sql_user", User, 63)    get_cvar_string("amx_sql_pass", Pass, 63)    get_cvar_string("amx_sql_db", Db, 63)

P.S. am incercat asa dar nu se salveaza ammo





Ztm.Freakz.Ro

[destroi112]

Foloseste o banca pe nvalut daca chiar nu functioneaza cu sql .


Retired from Amxmodx

[Ztm.Mihai]

da dar tot ce e pe nvalut is momente cand pierde credite la schimbarea mapei sau cand se deconecteaza de pe server toti care a zis ca e mai buna pe sql dar la mne vad ca nu functioneaza asa cv





Ztm.Freakz.Ro

[destroi112]

Poate pierd credite pt ca li se salveaza pe ip iar unii au ip dinamic e mai bine pe nume dar poate sa intre altcineva pe numele lor daca nu e securizat.


Retired from Amxmodx

[Ztm.Mihai]

eu zic ca de salvat salveaza pe nume dar problema e ca se pierd cateodata cate 1000-2000 de ammo

uite arunca tu o privire asta e banca care o folosesc

Spoiler:

#include <amxmodx>
#include <fakemeta>
#include <zombieplague>
#include <nvault>

#define PLUGIN "[ZP] Can Auto Save Ammo"
#define VERSION "0.1.0"
#define AUTHOR "cosi"

new g_save, g_ammo[33], g_ammo_can_save[33]
new cvar_save_in

#define MAX_SAVE 1000000000 //can save....

public plugin_init()
{
register_plugin(PLUGIN, VERSION, AUTHOR)

register_event("DeathMsg","event_deathmsg","a")
register_forward(FM_PlayerPreThink, "fw_PlayerPreThink")

cvar_save_in = register_cvar("zp_ammo_save_in", "0") // 0 = name / 1 = ip / 2 = steam id

g_save = nvault_open("g_ammo_save")
}

// Save Ammo
public zp_user_infected_post(id, infector)
{
if (g_ammo_can_save[infector])
Save_Ammo_date(infector)

if (g_ammo_can_save[id])
Save_Ammo_date(id)
}

public zp_extra_item_selected(id, itemid)
{
if (g_ammo_can_save[id])
Save_Ammo_date(id)
}

public event_deathmsg()
{
new killer = read_data(1)
new victim = read_data(2)

if (!killer && !victim)
return PLUGIN_CONTINUE;

if (g_ammo_can_save[killer])
Save_Ammo_date(killer)

if (g_ammo_can_save[victim])
Save_Ammo_date(victim)

return PLUGIN_CONTINUE;
}

public fw_PlayerPreThink(id)
{
if (g_ammo_can_save[id])
{
new ammo_packs = zp_get_user_ammo_packs(id)
g_ammo[id] = ammo_packs
}

return FMRES_IGNORED;
}

public client_disconnect(id)
{
if(g_ammo_can_save[id])
Save_Ammo_date(id)
}

public client_putinserver(id)
set_task(2.0, "now_can_save", id)

public now_can_save(id)
{
Load_Ammo_date(id)
set_task(0.5, "can_save_true", id)
}

public can_save_true(id)
g_ammo_can_save[id] = true

public Save_Ammo_date(id)
{
new vaultkey[64], vaultdata[256]

switch (get_pcvar_num(cvar_save_in))
{
case 0:
{
new name[33];
get_user_name(id,name,32)

format(vaultkey, 63, "%s-/", name)
}
case 1:
{
new player_ip[33]
get_user_ip(id, player_ip, 32);

format(vaultkey, 63, "%s-/", player_ip)
}
case 2:
{
new AuthID[33];
get_user_authid(id, AuthID, 32);

formatex(vaultkey, 64, "%s-/", AuthID);
}
}

format(vaultdata, 255, "%i#", g_ammo[id])

nvault_set(g_save, vaultkey, vaultdata)
return PLUGIN_CONTINUE;
}

public Load_Ammo_date(id)
{
new vaultkey[64], vaultdata[256]

switch (get_pcvar_num(cvar_save_in))
{
case 0:
{
new name[33];
get_user_name(id,name,32)

format(vaultkey, 63, "%s-/", name)
}
case 1:
{
new player_ip[33]
get_user_ip(id, player_ip, 32);

format(vaultkey, 63, "%s-/", player_ip)
}
case 2:
{
new AuthID[33];
get_user_authid(id, AuthID, 32);

formatex(vaultkey, 64, "%s-/", AuthID);
}
}

format(vaultdata, 255, "%i#", g_ammo[id])

nvault_get(g_save, vaultkey, vaultdata, 255)
replace_all(vaultdata, 255, "#", " ")

new playammo[32]
parse(vaultdata, playammo, 31)
g_ammo[id] = str_to_num(playammo)

set_ammo(id)

return PLUGIN_CONTINUE;
}

public set_ammo(id)
{
if (g_ammo[id] > MAX_SAVE)
{
zp_set_user_ammo_packs(id, MAX_SAVE)
g_ammo[id] = MAX_SAVE
}
else
zp_set_user_ammo_packs(id, g_ammo[id])
client_print(id, print_chat, "Creditele Tale Sunt : %d ", g_ammo[id])
}

Ztm.Freakz.Ro

[destroi112]

Vezi asa.

Spoiler:

#include <amxmodx>
#include <fakemeta>
#include <zombieplague>
#include <nvault>

#define PLUGIN "[ZP] Can Auto Save Ammo"
#define VERSION "0.1.0"
#define AUTHOR "cosi"

new g_save, g_ammo[33]
#define MAX_SAVE 1000000000

public plugin_init()
{
register_plugin(PLUGIN, VERSION, AUTHOR)

register_event("DeathMsg","event_deathmsg","a")
register_forward(FM_PlayerPreThink, "fw_PlayerPreThink")

g_save = nvault_open("g_ammo_save")
}

// Save Ammo
public zp_user_infected_post(id, infector)
{
Save_Ammo_date(infector)
Save_Ammo_date(id)
}

public zp_extra_item_selected(id, itemid)
{
Save_Ammo_date(id)
}

public event_deathmsg()
{
new killer = read_data(1)
new victim = read_data(2)

if (!killer && !victim)
return PLUGIN_CONTINUE;

Save_Ammo_date(killer)
Save_Ammo_date(victim)

return PLUGIN_CONTINUE;
}

public fw_PlayerPreThink(id)
{
new ammo_packs = zp_get_user_ammo_packs(id)
g_ammo[id] = ammo_packs
}

public client_connect(id)
{
Load_Ammo_date(id)
}

public client_disconnect(id)
{
Save_Ammo_date(id)
}

public Save_Ammo_date(id)
{
new vaultkey[64], vaultdata[256]
new name[33];
get_user_name(id,name,32)

format(vaultkey, 63, "%s-/", name)
format(vaultdata, 255, "%i#", g_ammo[id])

nvault_set(g_save, vaultkey, vaultdata)
return PLUGIN_CONTINUE;
}

public Load_Ammo_date(id)
{
new vaultkey[64], vaultdata[256]

new name[33];

get_user_name(id,name,32)
format(vaultdata, 255, "%i#", g_ammo[id])

nvault_get(g_save, vaultkey, vaultdata, 255)
replace_all(vaultdata, 255, "#", " ")

new playammo[32]
parse(vaultdata, playammo, 31)
g_ammo[id] = str_to_num(playammo)

set_ammo(id)
return PLUGIN_CONTINUE;
}

public set_ammo(id)
{
if (g_ammo[id] > MAX_SAVE)
{
zp_set_user_ammo_packs(id, MAX_SAVE)
g_ammo[id] = MAX_SAVE
}
else
zp_set_user_ammo_packs(id, g_ammo[id])
client_print(id, print_chat, "Ai %d Ammo Pack.", g_ammo[id])
}

Retired from Amxmodx