15.10.2010, 16:30
Quote:
I haven't checked the top part, but the second part was just overkill. You're executing a query for every stat item you're saving, there's no need. If you created one large query, that would be the most efficient way to go. Use format and create a large string and bunch your queries in to one large query (or maybe 2), like so:
pawn Код:
Then get out. |

pawn Код:
stock Masina(playerid)
{
new name[MAX_PLAYER_NAME],row[20],query[200];
GetPlayerName(playerid,name,sizeof(name));
format(query,sizeof(query),"SELECT `AH_Typ` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist[playerid][Typ]=strval(row); mysql_free_result();
format(query,sizeof(query),"SELECT `AH_X` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist[playerid][X]=floatstr(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH_Y` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist[playerid][Y]=floatstr(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH_Z` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist[playerid][Z]=floatstr(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH_Rot` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist[playerid][Rotation]=floatstr(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH_Status` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist[playerid][Status]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH_Lock` FROM `Cars` WHERE `Owner` = '%s'",name);mysql_query(query); mysql_store_result(); mysql_fetch_row(row);Carlist[playerid][Lock]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH_Paintjob` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist[playerid][Paintjob]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH_Color1` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist[playerid][Color1]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH_Color2` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist[playerid][Color2]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH_mod1` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist[playerid][mod1]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH_mod2` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist[playerid][mod2]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH_mod3` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist[playerid][mod3]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH_mod4` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist[playerid][mod4]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH_mod5` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist[playerid][mod5]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH_mod6` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist[playerid][mod6]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH_mod7` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist[playerid][mod7]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH_mod8` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist[playerid][mod8]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH_mod9` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist[playerid][mod9]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH_mod10` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist[playerid][mod10]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH_mod11` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist[playerid][mod11]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH_mod12` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist[playerid][mod12]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH_mod13` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist[playerid][mod13]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH_mod14` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist[playerid][mod14]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH_mod15` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist[playerid][mod15]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH_mod16` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist[playerid][mod16]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH_mod17` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist[playerid][mod17]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `Gas` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist[playerid][Gas]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `Sirena` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist[playerid][Sirena]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH2_Typ` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist2[playerid][Typ]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH2_X` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist2[playerid][X]=floatstr(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH2_Y` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist2[playerid][Y]=floatstr(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH2_Z` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist2[playerid][Z]=floatstr(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH2_Rot` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist2[playerid][Rotation]=floatstr(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH2_Status` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist2[playerid][Status]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH2_Lock` FROM `Cars` WHERE `Owner` = '%s'",name);mysql_query(query); mysql_store_result(); mysql_fetch_row(row);Carlist2[playerid][Lock]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH2_Paintjob` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist2[playerid][Paintjob]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH2_Color1` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist2[playerid][Color1]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH2_Color2` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist2[playerid][Color2]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH2_mod1` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist2[playerid][mod1]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH2_mod2` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist2[playerid][mod2]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH2_mod3` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist2[playerid][mod3]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH2_mod4` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist2[playerid][mod4]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH2_mod5` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist2[playerid][mod5]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH2_mod6` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist2[playerid][mod6]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH2_mod7` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist2[playerid][mod7]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH2_mod8` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist2[playerid][mod8]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH2_mod9` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist2[playerid][mod9]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH2_mod10` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist2[playerid][mod10]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH2_mod11` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist2[playerid][mod11]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH2_mod12` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist2[playerid][mod12]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH2_mod13` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist2[playerid][mod13]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH2_mod14` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist2[playerid][mod14]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH2_mod15` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist2[playerid][mod15]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH2_mod16` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist2[playerid][mod16]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH2_mod17` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist2[playerid][mod17]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `Gas2` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist2[playerid][Gas]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `Sirena2` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist2[playerid][Sirena]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH3_Typ` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist3[playerid][Typ]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH3_X` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist3[playerid][X]=floatstr(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH3_Y` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist3[playerid][Y]=floatstr(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH3_Z` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist3[playerid][Z]=floatstr(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH3_Rot` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist3[playerid][Rotation]=floatstr(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH3_Status` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist3[playerid][Status]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH3_Lock` FROM `Cars` WHERE `Owner` = '%s'",name);mysql_query(query); mysql_store_result(); mysql_fetch_row(row);Carlist3[playerid][Lock]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH3_Paintjob` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist3[playerid][Paintjob]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH3_Color1` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist3[playerid][Color1]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH3_Color2` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist3[playerid][Color2]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH3_mod1` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist3[playerid][mod1]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH3_mod2` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist3[playerid][mod2]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH3_mod3` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist3[playerid][mod3]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH3_mod4` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist3[playerid][mod4]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH3_mod5` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist3[playerid][mod5]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH3_mod6` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist3[playerid][mod6]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH3_mod7` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist3[playerid][mod7]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH3_mod8` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist3[playerid][mod8]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH3_mod9` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist3[playerid][mod9]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH3_mod10` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist3[playerid][mod10]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH3_mod11` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist3[playerid][mod11]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH3_mod12` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist3[playerid][mod12]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH3_mod13` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist3[playerid][mod13]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH3_mod14` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist3[playerid][mod14]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH3_mod15` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist3[playerid][mod15]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH3_mod16` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist3[playerid][mod16]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `AH3_mod17` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist3[playerid][mod17]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `Gas3` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist3[playerid][Gas]=strval(row);mysql_free_result();
format(query,sizeof(query),"SELECT `Sirena3` FROM `Cars` WHERE `Owner` = '%s'",name); mysql_query(query); mysql_store_result(); mysql_fetch_row(row); Carlist3[playerid][Sirena]=strval(row);mysql_free_result();
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);
}
}