1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help
  4. Help Archive

Linear Mode
A Little mysql optimization
wups
High-roller
*****
Posts: 1,216
Threads: 59
Joined: Apr 2010
Reputation: 0
#10

15.10.2010, 16:43
( Последний раз редактировалось wups; 15.10.2010 в 17:04. )
pawn Код:
stock SaveMasina(playerid)
{
    new name[MAX_PLAYER_NAME];
    new var[2048],query[300];
    GetPlayerName(playerid, name, sizeof(name));
    format(var, 100,"SELECT * FROM `Cars` WHERE `Owner` = '%s'",name);
    mysql_query(var);
    mysql_store_result();
    if(!mysql_num_rows())
    {
        format(query,300,"INSERT INTO `Cars` (`Owner`,`AH_Typ`,`AH2_Typ`,`AH3_Typ`,`AH_X`,`AH_Y`,`AH_Z`,`AH_Rot`,`AH2_X`,`AH2_Y`,`AH2_Z`,`AH2_Rot`,`AH3_X`,`AH3_Y`,`AH3_Z`,`AH3_Rot`) VALUES ('%s',-1,-1,-1,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000)",name);
        mysql_query(query);
    }
    mysql_free_result();
    format(var,sizeof(var),"UPDATE `Cars` SET AH_Typ=%i,AH_X='%f',AH_Y='%f',AH_Z='%f',AH_Rot='%f',AH_Status=%i,AH_Lock=%i,AH_Paintjob=%i,AH_Color1=%i,AH_Color2=%i,AH_mod1=%i,AH_mod2=%i,AH_mod3=%i,AH_mod4=%i,AH_mod5=%i,AH_mod6=%i,AH_mod7=%i,AH_mod8=%i,AH_mod9=%i,AH_mod10=%i,AH_mod11=%i,AH_mod12=%i,AH_mod13=%i,AH_mod14=%i,AH_mod15=%i,AH_mod16=%i,AH_mod17=%i WHERE Owner='%s'",
    Carlist[playerid][Typ],Carlist[playerid][X],Carlist[playerid][Y],Carlist[playerid][Z],Carlist[playerid][Rotation],Carlist[playerid][Status],Carlist[playerid][Lock],Carlist[playerid][Paintjob],Carlist[playerid][Color1],Carlist[playerid][Color2],
    Carlist[playerid][mod1],Carlist[playerid][mod2],Carlist[playerid][mod3],Carlist[playerid][mod4],Carlist[playerid][mod5],Carlist[playerid][mod6],Carlist[playerid][mod7],Carlist[playerid][mod8],Carlist[playerid][mod9],Carlist[playerid][mod10],
    Carlist[playerid][mod11],Carlist[playerid][mod12],Carlist[playerid][mod13],Carlist[playerid][mod14],Carlist[playerid][mod15],Carlist[playerid][mod16],Carlist[playerid][mod17],name);
    mysql_query(query);
    if(Carlist[playerid][Carid]!=-1)
    {
        format(var, sizeof(var), "UPDATE `Cars` SET Sirena=%i,Gas=%i WHERE `Owner` = '%s'", alarmed[Carlist[playerid][Carid]],vehicleDB[Carlist[playerid][Carid]][gas],name); mysql_query(var);
    }
    
    format(var,sizeof(var),"UPDATE `Cars` SET AH2_Typ=%i,AH2_X='%f',AH2_Y='%f',AH2_Z='%f',AH2_Rot='%f',AH2_Status=%i,AH2_Lock=%i,AH2_Paintjob=%i,AH2_Color1=%i,AH2_Color2=%i,AH2_mod1=%i,AH2_mod2=%i,AH2_mod3=%i,AH2_mod4=%i,AH2_mod5=%i,AH2_mod6=%i,AH2_mod7=%i,AH2_mod8=%i,AH2_mod9=%i,AH2_mod10=%i,AH2_mod11=%i,AH2_mod12=%i,AH2_mod13=%i,AH2_mod14=%i,AH2_mod15=%i,AH2_mod16=%i,AH2_mod17=%i WHERE Owner='%s'",
    Carlist2[playerid][Typ],Carlist2[playerid][X],Carlist2[playerid][Y],Carlist2[playerid][Z],Carlist2[playerid][Rotation],Carlist2[playerid][Status],Carlist2[playerid][Lock],Carlist2[playerid][Paintjob],Carlist2[playerid][Color1],Carlist2[playerid][Color2],
    Carlist2[playerid][mod1],Carlist2[playerid][mod2],Carlist2[playerid][mod3],Carlist2[playerid][mod4],Carlist2[playerid][mod5],Carlist2[playerid][mod6],Carlist2[playerid][mod7],Carlist2[playerid][mod8],Carlist2[playerid][mod9],Carlist2[playerid][mod10],
    Carlist2[playerid][mod11],Carlist2[playerid][mod12],Carlist2[playerid][mod13],Carlist2[playerid][mod14],Carlist2[playerid][mod15],Carlist2[playerid][mod16],Carlist2[playerid][mod17],name);
    mysql_query(query);
    if(Carlist2[playerid][Carid]!=-1)
    {
        format(var, sizeof(var), "UPDATE `Cars` SET Sirena2=%i,Gas2=%i WHERE `Owner` = '%s'", alarmed[Carlist2[playerid][Carid]],vehicleDB[Carlist2[playerid][Carid]][gas],name); mysql_query(var);
    }
    format(var,sizeof(var),"UPDATE `Cars` SET AH3_Typ=%i,AH3_X='%f',AH3_Y='%f',AH3_Z='%f',AH3_Rot='%f',AH3_Status=%i,AH3_Lock=%i,AH3_Paintjob=%i,AH3_Color1=%i,AH3_Color2=%i,AH3_mod1=%i,AH3_mod2=%i,AH3_mod3=%i,AH3_mod4=%i,AH3_mod5=%i,AH3_mod6=%i,AH3_mod7=%i,AH3_mod8=%i,AH3_mod9=%i,AH3_mod10=%i,AH3_mod11=%i,AH3_mod12=%i,AH3_mod13=%i,AH3_mod14=%i,AH3_mod15=%i,AH3_mod16=%i,AH3_mod17=%i WHERE Owner='%s'",
    Carlist3[playerid][Typ],Carlist3[playerid][X],Carlist3[playerid][Y],Carlist3[playerid][Z],Carlist3[playerid][Rotation],Carlist3[playerid][Status],Carlist3[playerid][Lock],Carlist3[playerid][Paintjob],Carlist3[playerid][Color1],Carlist3[playerid][Color2],
    Carlist3[playerid][mod1],Carlist3[playerid][mod2],Carlist3[playerid][mod3],Carlist3[playerid][mod4],Carlist3[playerid][mod5],Carlist3[playerid][mod6],Carlist3[playerid][mod7],Carlist3[playerid][mod8],Carlist3[playerid][mod9],Carlist3[playerid][mod10],
    Carlist3[playerid][mod11],Carlist3[playerid][mod12],Carlist3[playerid][mod13],Carlist3[playerid][mod14],Carlist3[playerid][mod15],Carlist3[playerid][mod16],Carlist3[playerid][mod17],name);
    mysql_query(query);
    if(Carlist3[playerid][Carid]!=-1)
    {
        format(var, sizeof(var), "UPDATE `Cars` SET Sirena2=%i,Gas2=%i WHERE `Owner` = '%s'", alarmed[Carlist3[playerid][Carid]],vehicleDB[Carlist3[playerid][Carid]][gas],name); mysql_query(var);
    }
    return 1;
}
Is this ok?

And this
pawn Код:
stock Masina(playerid)
{
        new name[MAX_PLAYER_NAME],row[2048],query[100];
        GetPlayerName(playerid,name,sizeof(name));
        format(query,sizeof(query),"SELECT * FROM `Cars` WHERE `Owner` = '%s'",name);
        mysql_query(query);
        mysql_store_result();
        mysql_fetch_row_format(row," ");
        mysql_free_result();
        
        sscanf(row,"iffffiiiiiiiiiiiiiiiiiiiiiiiiiffffiiiiiiiiiiiiiiiiiiiiiiiiiffffiiiiiiiiiiiiiiiiiiiiiiii",
        Carlist[playerid][Typ],
        Carlist[playerid][X],
        Carlist[playerid][Y],
        Carlist[playerid][Z],
        Carlist[playerid][Rotation],
        Carlist[playerid][Status],
        Carlist[playerid][Lock],
        Carlist[playerid][Paintjob],
        Carlist[playerid][Color1],
        Carlist[playerid][Color2],
        Carlist[playerid][mod1],
        Carlist[playerid][mod1],
        Carlist[playerid][mod1],
        Carlist[playerid][mod1],
        Carlist[playerid][mod1],
        Carlist[playerid][mod1],
        Carlist[playerid][mod1],
        Carlist[playerid][mod1],
        Carlist[playerid][mod1],
        Carlist[playerid][mod1],
        Carlist[playerid][mod1],
        Carlist[playerid][mod1],
        Carlist[playerid][mod1],
        Carlist[playerid][mod1],
        Carlist[playerid][mod1],
        Carlist[playerid][mod1],
        Carlist[playerid][mod1],
        Carlist[playerid][Gas],
        Carlist[playerid][Sirena],
        
        Carlist2[playerid][Typ],
        Carlist2[playerid][X],
        Carlist2[playerid][Y],
        Carlist2[playerid][Z],
        Carlist2[playerid][Rotation],
        Carlist2[playerid][Status],
        Carlist2[playerid][Lock],
        Carlist2[playerid][Paintjob],
        Carlist2[playerid][Color1],
        Carlist2[playerid][Color2],
        Carlist2[playerid][mod1],
        Carlist2[playerid][mod1],
        Carlist2[playerid][mod1],
        Carlist2[playerid][mod1],
        Carlist2[playerid][mod1],
        Carlist2[playerid][mod1],
        Carlist2[playerid][mod1],
        Carlist2[playerid][mod1],
        Carlist2[playerid][mod1],
        Carlist2[playerid][mod1],
        Carlist2[playerid][mod1],
        Carlist2[playerid][mod1],
        Carlist2[playerid][mod1],
        Carlist2[playerid][mod1],
        Carlist2[playerid][mod1],
        Carlist2[playerid][mod1],
        Carlist2[playerid][mod1],
        Carlist2[playerid][Gas],
        Carlist2[playerid][Sirena],
        
        Carlist3[playerid][Typ],
        Carlist3[playerid][X],
        Carlist3[playerid][Y],
        Carlist3[playerid][Z],
        Carlist3[playerid][Rotation],
        Carlist3[playerid][Status],
        Carlist3[playerid][Lock],
        Carlist3[playerid][Paintjob],
        Carlist3[playerid][Color1],
        Carlist3[playerid][Color2],
        Carlist3[playerid][mod1],
        Carlist3[playerid][mod1],
        Carlist3[playerid][mod1],
        Carlist3[playerid][mod1],
        Carlist3[playerid][mod1],
        Carlist3[playerid][mod1],
        Carlist3[playerid][mod1],
        Carlist3[playerid][mod1],
        Carlist3[playerid][mod1],
        Carlist3[playerid][mod1],
        Carlist3[playerid][mod1],
        Carlist3[playerid][mod1],
        Carlist3[playerid][mod1],
        Carlist3[playerid][mod1],
        Carlist3[playerid][mod1],
        Carlist3[playerid][mod1],
        Carlist3[playerid][mod1],
        Carlist3[playerid][Gas],
        Carlist3[playerid][Sirena]
        );

        if(Carlist[playerid][Typ]!=-1 && Carlist[playerid][Status]==1)
        {
            Carlist[playerid][Carid]=CreateTunedCar(playerid);
        }

        if(Carlist2[playerid][Typ]!=-1 && Carlist2[playerid][Status]==1)
        {
            Carlist2[playerid][Carid]=CreateTunedCar2(playerid);
        }
        if(Carlist3[playerid][Typ]!=-1 && Carlist3[playerid][Status]==1)
        {
            Carlist3[playerid][Carid]=CreateTunedCar3(playerid);
        }
}
Find
Reply
« Next Oldest | Next Newest »


Messages In This Thread
A Little mysql optimization - by wups - 15.10.2010, 16:19
Re: A Little mysql optimization - by Calgon - 15.10.2010, 16:25
Re: A Little mysql optimization - by wups - 15.10.2010, 16:30
Re: A Little mysql optimization - by Sergei - 15.10.2010, 16:32
Re: A Little mysql optimization - by Leeroy. - 15.10.2010, 16:33
Re: A Little mysql optimization - by Relixious - 15.10.2010, 16:35
Re: A Little mysql optimization - by Leeroy. - 15.10.2010, 16:38
Re: A Little mysql optimization - by Calgon - 15.10.2010, 16:40
Re: A Little mysql optimization - by Leeroy. - 15.10.2010, 16:43
Re: A Little mysql optimization - by wups - 15.10.2010, 16:43

Forum Jump:


Users browsing this thread: 4 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help
  4. Help Archive