Originally Posted by Rokzlive
Here are the functions now, but still not working correctly.
pawn Код:
stock LoadOwnedVehicles() { new String[2000], ModelL, CL[2], PriceL, OwnerL[MAX_PLAYER_NAME], Float:PosL[4], ID, PlateNumL[32];
mysql_query("SELECT * FROM `ownedcars` WHERE `ID`"); mysql_store_result();
while(mysql_fetch_row(String, "|")) { if(!mysql_num_rows()) continue; sscanf(String,"p<|>iiiiis[24]ffffs[32]", ID, ModelL, CL[0], CL[1], PriceL, OwnerL, PosL[0], PosL[1], PosL[2], PosL[3], PlateNumL);//1695 print(String); vehicledata[ID][Model] = ModelL; vehicledata[ID][Color1] = CL[0]; vehicledata[ID][Color2] = CL[1]; vehicledata[ID][Price] = PriceL; format(vehicledata[ID][Owner], 24, "%s", OwnerL); vehicledata[ID][PosX] = PosL[0]; vehicledata[ID][PosY] = PosL[1]; vehicledata[ID][PosZ] = PosL[2]; vehicledata[ID][PosA] = PosL[3]; format(vehicledata[ID][Plate], 32, "%s", PlateNumL);
new ownedcar = CreateVehicle(ModelL, PosL[0], PosL[1], PosL[2], PosL[3], CL[0], CL[1], 500000);//1708 SetVehicleNumberPlate(ownedcar, PlateNumL);
isowned[ID] = ownedcar; printf("Owned vehicle %d spawned!",ID); } mysql_free_result(); return 1; }
pawn Код:
stock AddStoreFromMysql() { new Str[1000], id, Float:X, Float:Y, Float:Z, STotal; mysql_query("SELECT * FROM `stores`"); mysql_store_result();
while(mysql_fetch_row(Str, "|")) { if(!mysql_num_rows()) continue; sscanf(Str, "p<|>ifff",id, X, Y, Z); print(Str); StorePickup = CreateDynamicPickup(1274, 23, X, Y, Z, -1, -1, -1, PICKUPDISTANCE); CreateDynamic3DTextLabel("Store", COLOR_YELLOW, X, Y, Z, 100.0, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, -1, -1, -1, TEXTLABELDISTANCE); CreateDynamicMapIcon(X, Y, Z, 38, 0, -1, -1, -1, MAPICONDISTANCE); printf("Store spawned at %f %f %f!",X,Y,Z); STotal++; } mysql_free_result(); printf("** %i\t<->\tStores Loaded From\t<->\tMySQL\t\t **", STotal); return 1; }
|