Raised This Month: $ Target: $400
 0% 

vault crash my server, need mysql?


  
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
Author Message
Miczu
Member
Join Date: Jul 2007
Old 09-15-2007 , 16:24   vault crash my server, need mysql?
Reply With Quote #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.
Miczu is offline
 


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 16:06.


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