Help with changing price after deduction

[chrisj]

This works successfully:

$wallet = $user->wallet;
$upwallet = ($sell_video == 0 && $wallet >= 1 ? 0.5 : 0);
$db->rawQuery("UPDATE ".T_USERS." SET `wallet` = `wallet`- '".$upwallet."' WHERE `id` = '".$video->user_id."'");

(when the sell_video amount is 0 and the wallet amount >= 1, deduct .5 from the wallet). Works successfully.

I'd like guidance with adding after that code:
When the sell_video amount is 0 and the wallet amount = 0.5, change/update the sell_video to X.
Any assistance is welcomed.

 

[Josmellon]

To add the additional code you described, you can do the following:

if ($sell_video == 0 && $wallet == 0.5) {
  $sell_video = X; // Replace X with the desired value for sell_video
  $db->rawQuery("UPDATE ".T_USERS." SET `sell_video` = '".$sell_video."' WHERE `id` = '".$video->user_id."'");
}

This code checks if the sell_video amount is 0 and the wallet amount is 0.5. If both conditions are true, it updates the sell_video value to the desired value (X) in the database.

I hope this helps! Let me know if you have any questions or need further clarification.

 

[MeMate]

I do this for quite some time (actually since AOL beeep dialed in), but i have no clue what you guys are taling about.

What class is $user attached to? What am i missing?
Please don't let me die dull.