$q = mysqli_fetch_assoc(mysqli_query($con, "SELECT id FROM cc3_account WHERE name = '{$nickname}'"));

mysqli_query($con, "UPDATE cc3_balance SET balance = balance+$money_per_vote WHERE username_id ='".$q['id']."' AND currency_id = '1'") or die(mysqli_error($con));