[Chris.08i]

Originally Posted by MarkFL

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']
); 


Well that sums it up nicely!

I was going to use if statements to create the effect I needed, turns out I don't need to!

Thanks so much for your help Mark, definitely learned a lot these couple days.

Edit: I just tried it - I'm getting a Server 500 error when I try infract someone. Any ideas?

Edit #2: So I globalised $vbulletin as well and it started running the code properly. However it isn't properly deducting from the table.

Edit #3: I got it to deduct!

It turns out we were missing an 'END' to the case which cause an MySQL syntax error.

However it now seems like it's going through both cases and deducting a total of 525 every time, no matter what! Not sure why the case rules aren't working!

Edit #4:
Okay - I got fed up so I ended up going with this. However, this code for some reason deducts double what I calculate it should do. For example, those with 0 ipoints, gets deducted 300 instead of 150, and those with 1 ipoint get deducted 750 instead of 375.

PHP Code:

global $userinfo, $vbulletin;

if ($userinfo['ipoints'] == 0) {
$base = 150;
$vbulletin->db->query_write("
    UPDATE " . TABLE_PREFIX . "user
    SET reputation = reputation - " . $base . "
    WHERE userid = " . $userinfo['userid']
);
}

if ($userinfo['ipoints'] > 0) {
$imodpp = 150 * ($userinfo['ipoints'] * 2.5);
$vbulletin->db->query_write("
    UPDATE " . TABLE_PREFIX . "user
    SET reputation = reputation - " . $imodpp . "
    WHERE userid = " . $userinfo['userid']
);
} 


I know this isn't the most efficient way - but it's the most working I could get it to so far!