Integer isn't loading in its enum

Integer isn't loading in its enum - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Integer isn't loading in its enum (/showthread.php?tid=609173)

Integer isn't loading in its enum - justjamie - 09.06.2016

Hello.
Every variable is loading correctly, but when i wanna use the ID from the database, it keeps printing 0.

this is my onplayercarload:

PHP код:



forward onPlayerCarLoad(playerid);

public onPlayerCarLoad(playerid)

{

    new num_fields,num_rows;

    new string [ 20 ],string2[35];

    cache_get_data(num_rows,num_fields,dbhandle);

if(num_rows!=0)

{

    for(new i=0; i<num_rows; i++)

    {

        for(new v = 0; v < MAX_VEHICLES; v++)

        {

            cInfo[v][carmodelid]=cache_get_field_content_int(i,"model",dbhandle);

            cInfo[v][c_x]=cache_get_field_content_float(i,"x",dbhandle);

            cInfo[v][c_y]=cache_get_field_content_float(i,"y",dbhandle);

            cInfo[v][c_z]=cache_get_field_content_float(i,"z",dbhandle);

            cInfo[v][c_r]=cache_get_field_content_float(i,"a",dbhandle);

            cInfo[v][c_color1]=cache_get_field_content_int(i,"color1",dbhandle);

            cInfo[v][c_color2]=cache_get_field_content_int(i,"color2",dbhandle);

            cInfo[v][c_respawntime]=cache_get_field_content_int(i,"autorespawn",dbhandle);

            cInfo[v][carteam]=cache_get_field_content_int(i,"carteam",dbhandle);

            cInfo[v][cnitro]=cache_get_field_content_int(i, "nitro", dbhandle);

            cInfo[v][db_id]=cache_get_field_content_int(i, "id", dbhandle);


            cache_get_field_content(i, "plate", string);

            format(cInfo[v][plate], 20, "%s", string);

            

            cache_get_field_content(i, "owner", string2);

            format(cInfo[v][carowner], 35, "%s", string2);


            CreateVehicle2(v);

            //CreateVehicle(cInfo[v][carmodelid],cInfo[v][c_x],cInfo[v][c_y],cInfo[v][c_z],cInfo[v][c_r],cInfo[v][c_color1],cInfo[v]        [c_color2],cInfo[v][c_respawntime]);

            //AddVehicleComponent(v, cInfo[v][cnitro]);

            //SetVehicleNumberPlate(v, cInfo[v][plate]);

            //SetVehicleToRespawn(v);

        break;

        }

    }

}

else

 {

 return 1;

 }

    return 1;

}

this is the command i try to load the database id:

PHP код:



    else if(!strcmp(tmp, "info", true, 4))

    {

        if(GetAdminLevel(playerid) < 4) return SendClientError(playerid, CANT_USE_CMD);

        if(!IsPlayerInAnyVehicle(playerid)) return SendClientError(playerid, "You are not in any vehicle!");

        new vid = GetPlayerVehicleID(playerid);

        new lockstr[40];

        if(cInfo[vid][tmplocked]) myStrcpy(lockstr, "Yes");

        else myStrcpy(lockstr, "No");

        new string[ MAX_STRING ];

        format(string, sizeof(string), "Car id[%d] Database id[%i] Owner[%s] Colors[%d/%d] Locked[%s] Faction[%d]", vid,cInfo[vid][db_id], cInfo[cInfo[vid][data1337]][carowner],cInfo[vid][c_color1],cInfo[vid][c_color2],lockstr, cInfo[vid][carteam]);

        SendMessageToPlayer(playerid, COLOR_HELPEROOC, string);

    }

this doesn't load:

PHP код:



Database id[%i]   cInfo[vid][db_id]

Someone any idea why?

Re: Integer isn't loading in its enum - TwinkiDaBoss - 09.06.2016

Add these on your OnPLayerLoad and show us the results

PHP код:



printf("ID without handler: %i",cache_get_field_content_int(i, "id"));

printf("ID with handler: %i",cache_get_field_content_int(i, "id", dbhandle));

Also why bother making a loop for car ids too?
Loops start at SQL at 1 (AUTO_INCREMENT) if im correct and MAX_VEHICLES start at 0.
So there will be 1 ID difference in it.

For example

PHP код:



#define MAX_SOMETHING 255 //starts at 0, ends at 255


new MyVar[MAX_SOMETHING];


public SomeCallback() {

    new rows = cache_num_rows();

    for(new i=0; i < rows; i++) {

        new calc = i-1; //calling row 1 at start and our MAX_SOMETHNIG starts at 0, therefore sub 1 to the MAX_SOMETHING

        MyVar[calc] = cache_get_field_content_int(i,"Something");

    }

}

EDIT: proper calculation is actually new calc = i-1; since rows start at 1 and car ids at 0

Re: Integer isn't loading in its enum - justjamie - 09.06.2016

Quote:

Originally Posted by TwinkiDaBoss

Add these on your OnPLayerLoad and show us the results

PHP код:



printf("ID without handler: %i",cache_get_field_content_int(i, "id"));

printf("ID with handler: %i",cache_get_field_content_int(i, "id", dbhandle));

Also why bother making a loop for car ids too?
Loops start at SQL at 1 (AUTO_INCREMENT) if im correct and MAX_VEHICLES start at 0.
So there will be 1 ID difference in it.

For example

PHP код:



#define MAX_SOMETHING 255 //starts at 0, ends at 255


new MyVar[MAX_SOMETHING];


public SomeCallback() {

    new rows = cache_num_rows();

    for(new i=0; i < rows; i++) {

        new calc = i-1; //calling row 1 at start and our MAX_SOMETHNIG starts at 0, therefore sub 1 to the MAX_SOMETHING

        MyVar[calc] = cache_get_field_content_int(i,"Something");

    }

}

EDIT: proper calculation is actually new calc = i-1; since rows start at 1 and car ids at 0

"Also why bother making a loop for car ids too?"

maybe cars get removed and the ID doesn't load anymore because it doesn't fill up that ID anymore.
i'll try the printf right now, sec

EDIT: http://prntscr.com/beavcz

hm, the ids are correct

Re: Integer isn't loading in its enum - TwinkiDaBoss - 09.06.2016

What about other stuff such as color etc? Does that load properly in that command?

Like if you do
cInfo[vid][c_color1]
Will it print the proper value?

Re: Integer isn't loading in its enum - justjamie - 09.06.2016

Quote:

Originally Posted by TwinkiDaBoss

What about other stuff such as color etc? Does that load properly in that command?

Like if you do
cInfo[vid][c_color1]
Will it print the proper value?

Yes, everything loads, even the name of the player

EDIT: colors dont load in that command, didn't notice that hmm.

Re: Integer isn't loading in its enum - justjamie - 09.06.2016

welp it loads now, but it loads the info wrong, and it spawns 2 vehicles on the place.
hm