{"error":{"error_code":100,"error_msg":"One of the parameters specified was missing or invalid: code is undefined","request_params":[{"key":"v","value":"5.81"},{"key":"method","value":"appWidgets.update"},{"key":"oauth","value":"1"}]}}
{"error":{"error_code":100,"error_msg":"One of the parameters specified was missing or invalid: code is undefined","request_params":[{"key":"v","value":"5.81"},{"key":"method","value":"appWidgets.update"},{"key":"oauth","value":"1"}]}}
BEGIN
DECLARE coins_take int;
SET coins_take = 1;
UPDATE users
SET users.coins_ready_to_collect = CASE
WHEN users.farmboost_buy='Yes' THEN users.coins_ready_to_collect + coins_take * 2
WHEN users.farmboost_buy='No' THEN users.coins_ready_to_collect + coins_take
END
WHERE users.id > 0
END;
BEGIN
DECLARE @coins_take int;
SET @coins_take = 1;
UPDATE users
SET users.coins_ready_to_collect = CASE
WHEN users.farmboost_buy='Yes' THEN users.coins_ready_to_collect + @coins_take * 2
WHEN users.farmboost_buy='No' THEN users.coins_ready_to_collect + @coins_take
END
WHERE users.id > 0
END;