|
Member
|

09-15-2007
, 16:24
vault crash my server, need mysql?
|
#1
|
I got a hard problem with a plug. When ever new player connect to my serwer (new nick), server crash. I think vault do it  .Serwer got ower 2200 players in rank -> soo my plug need over 17600 line of code with players stats  - end every new player make a big mess
I think: if plug would save all in a database (mysql,sql) then it would go faster and without any problems.
How to meke this from vault to sql/mysql.
Code:
public SaveXP(id)
{
new name[32];
get_user_name(id,name,31);
new vaultkey[64], vaultdata[64];
format(vaultkey,63,"Diablo-%s-class",name);
format(vaultdata,63,"%d",player_class[id]);
set_vaultdata(vaultkey,vaultdata);
format(vaultkey,63,"Diablo-%s-xp",name);
format(vaultdata,63,"%d",player_xp[id]);
set_vaultdata(vaultkey,vaultdata);
format(vaultkey,63,"Diablo-%s-level",name);
format(vaultdata,63,"%d",player_lvl[id]);
set_vaultdata(vaultkey,vaultdata);
format(vaultkey,63,"Diablo-%s-Inteligence",name);
format(vaultdata,63,"%d",player_intelligence[id]);
set_vaultdata(vaultkey,vaultdata);
format(vaultkey,63,"Diablo-%s-Strenght",name);
format(vaultdata,63,"%d",player_strength[id]);
set_vaultdata(vaultkey,vaultdata);
format(vaultkey,63,"Diablo-%s-Point",name);
format(vaultdata,63,"%d",player_point[id]);
set_vaultdata(vaultkey,vaultdata);
format(vaultkey,63,"Diablo-%s-Agility",name);
format(vaultdata,63,"%d",player_agility[id]);
set_vaultdata(vaultkey,vaultdata);
format(vaultkey,63,"Diablo-%s-Dextery",name);
format(vaultdata,63,"%d",player_dextery[id]);
set_vaultdata(vaultkey,vaultdata);
}
public LoadXP(id)
{
new name[32];
get_user_name(id,name,31);
new vaultkey[64], vaultdata[64];
format(vaultkey,63,"Diablo-%s-class",name);
get_vaultdata(vaultkey,vaultdata,63);
player_class[id] = str_to_num(vaultdata);
format(vaultkey,63,"Diablo-%s-xp",name);
get_vaultdata(vaultkey,vaultdata,63);
player_xp[id] = str_to_num(vaultdata);
format(vaultkey,63,"Diablo-%s-level",name);
get_vaultdata(vaultkey,vaultdata,63);
player_lvl[id] = str_to_num(vaultdata);
format (vaultkey,63,"Diablo-%s-Inteligence",name);
get_vaultdata(vaultkey,vaultdata,63);
player_intelligence[id] = str_to_num(vaultdata);
format (vaultkey,63,"Diablo-%s-Strenght",name);
get_vaultdata(vaultkey,vaultdata,63);
player_strength[id] = str_to_num(vaultdata);
format(vaultkey,63,"Diablo-%s-Points",name);
get_vaultdata(vaultkey,vaultdata,63);
player_point[id] = str_to_num(vaultdata);
format(vaultkey,63,"Diablo-%s-Agility",name);
get_vaultdata(vaultkey,vaultdata,63);
player_agility[id] = str_to_num(vaultdata);
format(vaultkey,63,"Diablo-%s-Dextery",name);
get_vaultdata(vaultkey,vaultdata,63);
player_dextery[id] = str_to_num(vaultdata);
}
Last edited by Miczu; 09-16-2007 at 04:53.
|
|