MYSQL Problem(Unknown Mode)
#1

i have a problem...
i'm setting the new ownership for my Gamemode and i found problem in this script, when i delete this script(undef it in the loading '//') the gamemode is working but when is defined in ongamemode to load the gamemode isn't working it only says Number of vehicle models: 0 :/
pawn Код:
stock LoadPVehicles()
{
    new
        Query[1024],
        vModel2,
        vC[2],
        vPrice2,
        vOwner2[MAX_PLAYER_NAME],
        Float:Pos[4],
        vID,
        PlateNum[32],
        vPaint_Job,
        vModsToLoad[12],
        vLock;

    mysql_query("SELECT * FROM `privateveh` WHERE `vID` < "#MAX_BUYABLE_VEH" ORDER BY vID");
    mysql_store_result();

    if(mysql_num_rows() > 0)
    {
        while(mysql_fetch_row(Query))
        {
            sscanf(Query, "p<|>iiiiis[24]ffffs[32]iiiiiiiiiiiiii",
            vID, vModel2, vC[0], vC[1], vPrice2, vOwner2, Pos[0], Pos[1], Pos[2], Pos[3], PlateNum, vPaint_Job,

            vModsToLoad[0], vModsToLoad[1], vModsToLoad[2], vModsToLoad[3], vModsToLoad[4], vModsToLoad[5],
            vModsToLoad[6], vModsToLoad[7], vModsToLoad[8], vModsToLoad[9], vModsToLoad[10], vModsToLoad[11], vLock);

            vInfo[vID][vModel] = vModel2;
            vInfo[vID][vColor1] = vC[0];
            vInfo[vID][vColor2] = vC[1];
            vInfo[vID][vPrice] = vPrice2;
            strmid(vInfo[vID][vOwner], vOwner2, 0, 24, 24);
            vInfo[vID][vPosX] = Pos[0];
            vInfo[vID][vPosY] = Pos[1];                            
            vInfo[vID][vPosZ] = Pos[2];                        
            vInfo[vID][vPosA] = Pos[3];                            
            strmid(vInfo[vID][vPlate], PlateNum, 0, 32, 32);       
            vInfo[vID][vPaintJ] = vPaint_Job;                      
            vInfo[vID][vLocked] = vLock;                           

            vMods[vID][0] = vModsToLoad[0];                        
            vMods[vID][1] = vModsToLoad[1];                        
            vMods[vID][2] = vModsToLoad[2];                    
            vMods[vID][3] = vModsToLoad[3];                    
            vMods[vID][4] = vModsToLoad[4];
            vMods[vID][5] = vModsToLoad[5];
            vMods[vID][6] = vModsToLoad[6];                        
            vMods[vID][7] = vModsToLoad[7];                        
            vMods[vID][8] = vModsToLoad[8];                        
            vMods[vID][9] = vModsToLoad[9];                        
            vMods[vID][10] = vModsToLoad[10];                      
            vMods[vID][11] = vModsToLoad[11];                      

            new
                vCarID = CreateVehicle(vInfo[vID][vModel], vInfo[vID][vPosX], vInfo[vID][vPosY], vInfo[vID][vPosZ], vInfo[vID][vPosA], vInfo[vID][vColor1], vInfo[vID][vColor2], 500000);
            SetVehicleNumberPlate(vCarID, vInfo[vID][vPlate]);
            ChangeVehiclePaintjob(vCarID, vInfo[vID][vPaintJ]);

            for(new iMod = 0; iMod < MAX_VEH_MODS; ++iMod)
            {
                if(vMods[vCarID][iMod] > 0)
                {
                    AddVehicleComponent(vCarID, vMods[vCarID][iMod]);
                }
            }

            OwnedVeh(vCarID) = vID;

            ++ Total_Veh_Created;
        }
    }
    mysql_free_result();
    printf("** A total of: \"%i\" vehicle(s) were loaded!", Total_Veh_Created);

    print("\n==============================================================");
    print("Dynamic Vehicle Ownership By: [U]214 - MySQL Version Loaded...");
    print("==============================================================\n");
    return Total_Veh_Created;
}
Reply
#2

pawn Код:
format(query, sizeof(query), "SELECT * FROM `privateveh` WHERE `vID` < %d ORDER BY vID", MAX_BUYABLE_VEH);
mysql_query(query);
try this by replacing the mysql_query that u have there
Reply
#3

Thank you,it's fixed!
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)