Function not calling - Printable Version

Function not calling - 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: Function not calling (/showthread.php?tid=663146)

Function not calling - akib - 23.01.2019

I don't know why function OnDoorsLoad calling...

Code:

PHP Code:



CMD:door(playerid, params[])

{

    if(PlayerInfo[playerid][pAdmin] < 3) return    SendClientMessage(playerid, COLOR_ORANGE, "Error: {ffffff}You're not authorized to use this command.");

    new Float:x, Float:y, Float:z;

    new str[280],m[512];

    for(new i = 1; i < MAX_DOORS; i++)

    {

      if(DynamicDoor[i][dUsed] == 0)

      {

            GetPlayerPos(playerid, x, y, z);

            DynamicDoor[i][dUsed] = 1;

            DynamicDoor[i][posX] = x;

            DynamicDoor[i][posY] = y;

            DynamicDoor[i][posZ] = z;

            DynamicDoor[i][dOutWorld] = GetPlayerVirtualWorld(playerid);

            DynamicDoor[i][dOutInt] = GetPlayerInterior(playerid);


            format(m, sizeof(m), "INSERT INTO doors (posX,posY,posZ,dOutWorld,dOutInt) VALUES ('%f','%f','%f','%i','%i')", DynamicDoor[i][posX],DynamicDoor[i][posY],DynamicDoor[i][posZ],DynamicDoor[i][dOutWorld],DynamicDoor[i][dOutInt]);

            printf("%s", m);

            mysql_function_query(dbhandle,m,true,"OnDoorsLoad","");

            printf("%d", mysql_function_query(dbhandle,m,true,"OnDoorsLoad",""));

            format(str, sizeof(str), "Sucess: {ffffff}You created Door ID: %d.", i);

            SendClientMessage(playerid, COLOR_LIME, str);

            return 1;

       }

    }

       return 1;

}

Data inserting in MYSQL but function not calling

Re: Function not calling - SyS - 23.01.2019

what's mysql_function_query (Show the definition)? Also show OnDoorsLoad

Re: Function not calling - akib - 23.01.2019

Quote:

Originally Posted by SyS

what's mysql_function_query ? Also show OnDoorsLoad

mysql_function_query is now mysql_tquery

Code OnDoorsLoad

PHP Code:



public OnDoorsLoad()

{

    new num_fields,num_rows,str[512];

    cache_get_data(num_rows,num_fields,dbhandle);

    if(!num_rows)return 1;

    print("========================| Loading Doors |=========================");

    for(new i=1;i<sizeof(DynamicDoor);i++){

        DestroyPickup(DynamicDoor[i][dPickup]);

        DestroyPickup(DynamicDoor[i][dOPickup]);

        Delete3DTextLabel(DynamicDoor[i][dLabel]);

    }

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

    {

        new id=GetFreeDoorID();

        DynamicDoor[id][doorID]=id;

        DynamicDoor[id][dUsed]=1;

        DynamicDoor[id][doorSQLID]=cache_get_field_content_int(i, "id", dbhandle);

        DynamicDoor[id][posX]=cache_get_field_content_float(i, "posX", dbhandle);

        DynamicDoor[id][posX]=cache_get_field_content_float(i, "posX", dbhandle);

        DynamicDoor[id][posY]=cache_get_field_content_float(i, "posY", dbhandle);

        DynamicDoor[id][posZ]=cache_get_field_content_float(i, "posZ", dbhandle);

        DynamicDoor[id][posi][0]=cache_get_field_content_float(i, "posiX", dbhandle);

        DynamicDoor[id][posi][1]=cache_get_field_content_float(i, "posiY", dbhandle);

        DynamicDoor[id][posi][2]=cache_get_field_content_float(i, "posiZ", dbhandle);

        DynamicDoor[id][dBarOne]=cache_get_field_content_int(i, "bar", dbhandle);

        DynamicDoor[id][dTreasury]=cache_get_field_content_int(i, "dTreasury", dbhandle);

        DynamicDoor[id][dFee]=cache_get_field_content_int(i, "dFee", dbhandle);

        DynamicDoor[id][dOutWorld]=cache_get_field_content_int(i, "dOutWorld", dbhandle);

        DynamicDoor[id][dOutInt]=cache_get_field_content_int(i, "dOutInt", dbhandle);

        DynamicDoor[id][dOwner]=cache_get_field_content_int(i, "dOwner", dbhandle);

        DynamicDoor[id][dWorld]=cache_get_field_content_int(i, "dWorld", dbhandle);

        DynamicDoor[id][dInterior]=cache_get_field_content_int(i, "dInterior", dbhandle);

        DynamicDoor[id][dLock]=cache_get_field_content_int(i, "dLock", dbhandle);

        cache_get_field_content(i, "dName", DynamicDoor[i][dName], dbhandle);


        DynamicDoor[id][dPickup] = CreatePickup(1239, 1, DynamicDoor[id][posX], DynamicDoor[id][posY], DynamicDoor[id][posZ], -1);

        DynamicDoor[id][dOPickup] = CreatePickup(1239, 1, DynamicDoor[id][posi][0], DynamicDoor[id][posi][1], DynamicDoor[id][posi][2], -1);

        format(str, sizeof(str), "%s\n{ffffff}Type /enter to enter.", DynamicDoor[i][dName]);

        DynamicDoor[id][dLabel] = CreateDynamic3DTextLabel(str ,COLOR_ORANGE, DynamicDoor[id][posX], DynamicDoor[id][posY], DynamicDoor[id][posZ],30.0, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, -1, -1, -1, 7.0);


        printf("Door %i[%i]: %f,%f,%f", DynamicDoor[id][doorSQLID],id,DynamicDoor[id][posX], DynamicDoor[id][posY], DynamicDoor[id][posZ]);

    }

    printf("========================| Total Biz: %i |============================",num_rows);

    return 1;

}

Re: Function not calling - akib - 23.01.2019

Defination of mysq_function_query :
mysql_function_query( connectionHandle, query[], bool:cache, callback[], format[], {Float,_}:... )

Source: https://sampforum.blast.hk/showthread.php?tid=56564 (BlueG's post)

Re: Function not calling - SyS - 23.01.2019

You are performing INSERT query no result is returned
So basically your function is calling but it get stopped at if(!num_rows)return 1;

PHP Code:



public OnDoorsLoad()

{

    new num_fields,num_rows,str[512];

    cache_get_data(num_rows,num_fields,dbhandle);

    if(!num_rows)return 1;//here 

    //..............

}

as there are no rows returned num_rows is zero

Re: Function not calling - akib - 23.01.2019

Quote:

Originally Posted by SyS

You are performing INSERT query no result is returned
So basically your function is calling but it get stopped at if(!num_rows)return 1;

PHP Code:



public OnDoorsLoad()

{

    new num_fields,num_rows,str[512];

    cache_get_data(num_rows,num_fields,dbhandle);

    if(!num_rows)return 1;//here 

    //..............

}

as there are no rows returned num_rows is zero

ahh shit, lemme change the code and try again, i will call select after inserting data?

Re: Function not calling - akib - 23.01.2019

Fixed, thanks!