AlliedModders

AlliedModders (https://forums.alliedmods.net/index.php)
-   Scripting Help (https://forums.alliedmods.net/forumdisplay.php?f=11)
-   -   vault crash my server, need mysql? (https://forums.alliedmods.net/showthread.php?t=60888)

Miczu 09-15-2007 16:24

vault crash my server, need mysql?
 
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 :down: .Serwer got ower 2200 players in rank -> soo my plug need over 17600 line of code with players stats :shock: - end every new player make a big mess :evil:

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);
}


Roach 09-15-2007 17:58

Re: vault crash my server, need mysql?
 
What the hell are you asking?

Miczu 09-15-2007 18:19

Re: vault crash my server, need mysql?
 
I need a way to make this code into a sql/mysql database instead of vault.

Miczu 09-16-2007 05:03

Re: vault crash my server, need mysql?
 
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

Miczu 09-17-2007 11:36

Re: vault crash my server, need mysql?
 
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 :cry:

Miczu 09-17-2007 11:49

Re: vault crash my server, need mysql?
 
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 09-18-2007 14:53

Re: vault crash my server, need mysql?
 
Oww you all are very halpfull. No, no, it's true :grrr:

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


All times are GMT -4. The time now is 16:06.

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