No update to DB ,

FiveM Server Development Server Discussion
1

Hi there ,
im using vRP atm , and editig some stuff here and there ,
there is a system in it that alows the business owner to deposit money to the business capital ,
but not remove it from the capital , it is saved to the DB ,
im not really good and familiar with the mysql coding etc, so i hoped u could get some answers here , what i did was :

added on vrp/modules/business :

MySQL.createCommand(“vRP/remove_capital”,“UPDATE vrp_user_business SET capital = capital + @capital WHERE user_id = @user_id”)

and

    menu[lang.business.removecapital.title()] = {function(player,choice)
      vRP.prompt(player,lang.business.removecapital.prompt(),"",function(player,amount)
        amount = parseInt(amount)
        if amount > 0 then
          if vRP.giveMoney(user_id,amount) then
            MySQL.execute("vRP/remove_capital", {user_id = user_id, capital = amount})
            vRPclient.notify(player,{lang.business.removecapital.removed({amount})})
          else
            vRPclient.notify(player,{lang.money.not_enough()})
          end
        else
          vRPclient.notify(player,{lang.common.invalid_value()})
        end
      end)
    end,lang.business.removecapital.description()}

Now it does give money but doesnt update the DB , so it gives free money at the moment ,.

i think it has to do with the update code for the DB ? , but im not familiar with that part .

someone that has an idea ?