Infraction Hook

[Chris.08i]

Hello,

It's me again - I was wondering if anyone could tell me which hook to latch my plugin onto if I wanted to modify a column within the users table.

I have tried the hooks 'infractiondata_postsave, infractiondata_presave, and memberinfraction_complete".

Either I have the wrong hook, or something in my code is wrong (which is probably the case)

PHP Code:

<?php
global $vbulletin, $prepared;
$usersid = $prepared['userid'];

$ipoints = $vbulletin->db->query_first("
    SELECT COUNT(*)
    FROM " . TABLE_PREFIX . "user.ipoints
    WHERE userid = " . $usersid . " 
");

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



?>