Update Post/Thread Count with DataManager

[CyberRanger]

Originally Posted by maximux1

I need something like, update_post_count() where the post count of the user is incrimented. As it is now, I dont believe it is doing anything. Post Count simply shows 0 even though the userid does have a few posts on it.

This isn't a neat function, but it will get it done!

PHP Code:

// update post count for user
    $posts = $vbulletin->db->query_first("
        SELECT posts
        FROM " . TABLE_PREFIX . "user
        WHERE userid = ".$postuserid."
    ");
    
    $newpostcount = $posts['posts'] + 1;
    
    $vbulletin->db->free_result($posts);
    
    $vbulletin->db->query_write("
        UPDATE " . TABLE_PREFIX . "user
        SET posts = ".$newpostcount."
        WHERE userid = ".$postuserid."
    "); 


Edit: sorry ... you probably already knew that. That's not using the datamanager now is it.