[CyberRanger]

Originally Posted by cddw.ltd

then this in the code for the postcounts -

PHP Code:

update forum_rsscount
set posts = posts + 1
where userid = X 


but it didn't work Anyone got any suggestions?

If you want to use this kind of logic, I had trouble too with the "set posts = posts + 1". It didn't work or gave me an error. I forget exactly what. Instead, I went with:

PHP Code:

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


EDIT: well, I just tried the code below (for the user table) instead of the code above and it worked! I must have had a different problem before:

PHP Code:

$db->query_write("
                UPDATE " . TABLE_PREFIX . "user
                set posts = posts + 1
                where userid = ".$postuserid."
            "); 


What part is not working for you? (BTW - it may be better to continue this via PM)