
<?php 
$result = dbquery("SELECT * FROM ".$db_prefix."users");
while ($datax = dbarray($result)) {
$id = $datax['user_id'];
$posts = dbcount("(post_id)", "".$db_prefix."posts", "post_author='$id'");
dbquery("UPDATE ".$db_prefix."users SET user_posts='$posts' WHERE user_id='$id'");
} ?>