[MarkFL]

Originally Posted by Chris.08i

What if ipoints = 0?

I still want to deduct 150 from their reputation.

Your original code indicated that a deduction only occurs when ipoints > 0. But, if you want 150 rep deducted when ipoints = 0, and otherwise 375 * ipoints rep deducted then our code would be (since we don't have a nice linear relationship):

PHP Code:

global $userinfo;

$vbulletin->db->query_write("
    UPDATE " . TABLE_PREFIX . "user
    SET reputation = CASE ipoints
        WHEN 0 THEN (reputation - 150)
        ELSE (reputation - (375*ipoints))
    WHERE userid = " . $userinfo['userid']
);