The World of Avlis

Code: Select all

void TakeGoldAndStore( object oPC, object oOwner, int iPrice, float fProfit=1.0)
{
 //Chest related variables
 string sContainerTag = GetTag(oOwner)+"PrChest";
 object oChest = GetObjectByTag(sContainerTag);
 object oGold;
 object oGoldNew;
 string sItemTag = "NW_IT_GOLD001";
 int iAmount;
 int iTakeGold = iPrice;


 TakeGoldFromCreature(iTakeGold, oPC, TRUE);

 // Add the amount (price * %profit) to the owner's chest
  if (GetIsObjectValid(oChest))
  {
        float fProduct = fProfit*iTakeGold;
        int iTotal;

        oGold = GetFirstItemInInventory();
        while (GetIsObjectValid(oGold))
        {
            if (GetTag(oGold) == sItemTag)
                iAmount += GetNumStackedItems(oGold);
            oGold = GetNextItemInInventory();
        }


        if (iAmount > 50000)
            PrintString ("Possible Gold overflow");

        iTotal = iAmount + FloatToInt(fProduct);


        // Check if total is greater than 50k. if it is create a new stack
        if (iTotal>50000)
        {
            oGoldNew = CreateItemOnObject("nw_it_gold001",oChest, iTotal-50000);
            SetItemStackSize(oGold, 50000 );
            SetItemStackSize(oGoldNew, iTotal-50000 );
         }
         else
            SetItemStackSize(oGold, iTotal );


    string sSQL;

    // store new gold amount in database
    sSQL = "SELECT * FROM containers WHERE container='" + sContainerTag +
              "' AND item='" + sItemTag + "'";
    SQLExecDirect(sSQL);
    if (SQLFetch() == SQL_SUCCESS)
        sSQL = "UPDATE containers SET count=" + IntToString(iTotal) +
               " WHERE container='" + sContainerTag + "' AND item='" + sItemTag + "'";
    else
        sSQL = "INSERT INTO containers (container,item,count,identified) VALUES " +
               "('" + sContainerTag + "','" + sItemTag + "'," + IntToString(iTotal) + ",1)";

    SQLExecDirect(sSQL);
   }
}