Help on creating a furniture on furniture system
#1

This is the code when you confirm the purchase on a specific furniture:
pawn Код:
else if(dialogid == DIALOG_FURNITURE_CONFIRM)
    {
        new str[256];
        if(!response) return SendClientMessage(playerid, -1, "Purchase Cancelled");
        new chosenFurn = GetPVarInt(playerid, "ChosenFurn");
        if(GetPlayerCash(playerid) < Furnitures[chosenFurn][Price]) return SendClientMessage(playerid, -1, "Insufficient funds.");
        GivePlayerCash(playerid, -Furnitures[chosenFurn][Price]);
        GetPlayerPos(playerid, hFurn[inHouse[playerid]][X], hFurn[inHouse[playerid]][Y], hFurn[inHouse[playerid]][Z]);
        hFurn[inHouse[playerid]][CustomID] = CreateDynamicObject(Furnitures[chosenFurn][Object], hFurn[inHouse[playerid]][X] , hFurn[inHouse[playerid]][Y] , hFurn[inHouse[playerid]][Z], 0.0, 0.0, 0.0, inHouse[playerid], hInfo[Interior[inHouse[playerid]][INT_ID]][InteriorID]);
        hFurn[inHouse[playerid]][ObjectID] = Furnitures[chosenFurn][Object];
        hFurn[inHouse[playerid]][Authority] = Furnitures[chosenFurn][Authority];
        new Float:pos[6];
        hFurn[inHouse[playerid]][X] = pos[0];
        hFurn[inHouse[playerid]][Y] = pos[1];
        hFurn[inHouse[playerid]][Z] = pos[2];
        hFurn[inHouse[playerid]][rX] = 0.0;
        hFurn[inHouse[playerid]][rY] = 0.0;
        hFurn[inHouse[playerid]][rZ] = 0.0;
        new pos_string[32];
        format(pos_string, 256, "%f,%f,%f,%f,%f,%f", pos[0], pos[1], pos[2], pos[3], pos[4], pos[5]);
        EditingFurn[playerid]=true;
        EditDynamicObject(playerid, hFurn[inHouse[playerid]][CustomID]);
        create_furniture(playerid, hFurn[inHouse[playerid]][ObjectID], hFurn[inHouse[playerid]][Authority], pos_string);
        format(str, sizeof(str), "Successful purcahase on %s!", Furnitures[chosenFurn][Name]);
        SendClientMessage(playerid, -1, str);
    }
And this is the create_furniture:
pawn Код:
stock create_furniture(playerid, objectid, authority, spawn[])
{
    if(inHouse[playerid])
    {
        if(hInfo[inHouse[playerid]][OwnerID] == pInfo[playerid][ID])
        {
            new Float:pos[6];
            hFurn[inHouse[playerid]][X] = pos[0];
            hFurn[inHouse[playerid]][Y] = pos[1];
            hFurn[inHouse[playerid]][Z] = pos[2];
            hFurn[inHouse[playerid]][rX] = pos[3];
            hFurn[inHouse[playerid]][rY] = pos[4];
            hFurn[inHouse[playerid]][rZ] = pos[5];
            new pos_string[256];
            format(pos_string, 256, "%f,%f,%f,%f,%f,%f", pos[0], pos[1], pos[2], pos[3], pos[4], pos[5]);
            format(szQuery, sizeof(szQuery), "INSERT INTO `newrp_furnitures`(`houseid`, `customid` `objectid`, `authority`, `spawn`) VALUES (%d, %d, %d, %d, %s)", inHouse[playerid], hFurn[inHouse[playerid]][CustomID], objectid, authority, pos_string);
            mysql_pquery(sql, szQuery);
        }
    }
    return 1;
}
The problem is it doesn't register on the MYSQL and it doesn't create the object.
Reply
#2

please.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)