Raised This Month: $ Target: $400
 0% 

vault crash my server, need mysql?


Post New Thread Reply   
 
Thread Tools Display Modes
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
Roach
Writes love letters to sawce Daily
Join Date: Jul 2006
Location: Internet
Old 09-15-2007 , 17:58   Re: vault crash my server, need mysql?
Reply With Quote #2

What the hell are you asking?
__________________
Quote:
Originally Posted by Brad View Post
That sounds like a really good idea!
Now replace the word "good" with "dumb".
What was your rationale for proposing such a thing?
Roach is offline
Miczu
Member
Join Date: Jul 2007
Old 09-15-2007 , 18:19   Re: vault crash my server, need mysql?
Reply With Quote #3

I need a way to make this code into a sql/mysql database instead of vault.

Last edited by Miczu; 09-16-2007 at 04:48.
Miczu is offline
Miczu
Member
Join Date: Jul 2007
Old 09-16-2007 , 05:03   Re: vault crash my server, need mysql?
Reply With Quote #4

I need a code for store data [public SaveXP(id)] and read data [public LoadXP(id)] (sql/mysql):

player_class[id]
player_xp[id]
player_lvl[id]
player_intelligence[id]
player_strength[id]
player_point[id]
player_agility[id]
player_dextery[id]

By player name (nick in game).

BTW. Sorry for my anglish

Last edited by Miczu; 09-16-2007 at 05:07.
Miczu is offline
Miczu
Member
Join Date: Jul 2007
Old 09-17-2007 , 11:36   Re: vault crash my server, need mysql?
Reply With Quote #5

OK. I ask in other way.

Is ther a way to save and read:
player_class[id]
player_xp[id]
player_lvl[id]
player_intelligence[id]
player_strength[id]
player_point[id]
player_agility[id]
player_dextery[id]

in Mysql datebase by player name? Is ther anyone that know a little how to use mysql in amxx
Miczu is offline
Miczu
Member
Join Date: Jul 2007
Old 09-17-2007 , 11:49   Re: vault crash my server, need mysql?
Reply With Quote #6

Code:
public SaveXP(id){

     new name[32];     
     get_user_name(id,name,31);   

     new query[256]
     format(query,255,"UPDATE `armymod` SET 'player_class' = %i, 'player_xp' = %i, `player_lvl` = %i, `player_intelligence` = %i, `player_strength` = %i, `player_point` = %i, `player_agility` = %i, `player_dextery` = %i WHERE name='%s'",player_class[id], player_xp[id], player_lvl[id], player_intelligence[id], player_strength[id], player_point[id], player_agility[id], player_dextery[id], name)
     mysql_query(mysql,query)
     mysql_error(mysql,merror,255)
     server_print("[AMX] Wykonano: %s",merror)
     if (merror[0]){
	server_print("[AMX] MYSQL error: %s",merror)
     	return PLUGIN_HANDLED
     }
     return PLUGIN_CONTINUE
}
Is that good?
Miczu is offline
Miczu
Member
Join Date: Jul 2007
Old 09-18-2007 , 14:53   Re: vault crash my server, need mysql?
Reply With Quote #7

Oww you all are very halpfull. No, no, it's true

Is ther a plug that do somelike this? If nobody can help me, then i need to lern it by my self
Miczu is offline
Reply



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