[Shockey HD]

Quote:

Originally Posted by Stefand Hello Community! I have finally fixed all my MYSQL errors so I can finally continue with my RP script. I just finished my Ownable Vehicle System but now I got a problem. When I do /mycars it has to load all the cars from the database that the player owns. Currently I got this, but it only loads one car. ( the first one it finds) pawn Код: command(mycars, playerid, params[]) {     if(Player[playerid][Adminlevel] == 6)     {         new Data[150],Field[258],idx;         new MyCarPlate[10], MyCarModel, MyCarStoreID;         mysql_queryS("SELECT * FROM `OwnedVehicles` WHERE `VehicleOwner` = '%s'",GetName(playerid));         mysql_store_result();         if(mysql_num_rows() == 1){             mysql_fetch_rowEx(Data);             Field = strtuk( Data, idx, '|' );             for(new s = 0; s < 17; s++)             {                 switch(s)                 {                     case 0: MyCarStoreID = strval(Field);                     case 1: MyCarModel = strval(Field);                     case 10: strmid(MyCarPlate,Field,0,strlen(Field),10);                 }                 Field = strtuk( Data, idx, '|' );             }             fSendClientMessage(playerid, WHITE, "> #%d, ModelID: %d, Plate: %s",MyCarStoreID, MyCarModel, MyCarPlate);         }         if(mysql_num_rows() == 0){             SCM(playerid, YELLOW, "> You do not own any vehicles yet!");         }     }     return 1; } How can I make it so it checks all the players cars? (Max is going to be 10 if you will need that anywhere)

Loops.

I'mma use MAX_VEHICLES for this..

pawn Код:

command(mycars, playerid, params[])
{
    if(Player[playerid][Adminlevel] == 6)
    {
        for(new i=0; i<MAX_VEHICLES; i++)
        {
            new Data[150],Field[258],idx;
            new MyCarPlate[10], MyCarModel, MyCarStoreID;
            mysql_queryS("SELECT * FROM `OwnedVehicles` WHERE `VehicleOwner` = '%s'",GetName(playerid));
            mysql_store_result();
            if(mysql_num_rows() == 1)
            {
                mysql_fetch_rowEx(Data);
                Field = strtuk( Data, idx, '|' );
                for(new s = 0; s < 17; s++)
                {
                    switch(s)
                    {
                        case 0: MyCarStoreID = strval(Field);
                        case 1: MyCarModel = strval(Field);
                        case 10: strmid(MyCarPlate,Field,0,strlen(Field),10);

                    }
                    Field = strtuk( Data, idx, '|' );
                }
                fSendClientMessage(playerid, WHITE, "> #%d, ModelID: %d, Plate: %s",MyCarStoreID, MyCarModel, MyCarPlate);
            }
            if(mysql_num_rows() == 0)
            {
                SCM(playerid, YELLOW, "> You do not own any vehicles yet!");
            }
        }
    }
    return 1;
}