x_789

Hi I have a Table I need a script that will look at field user_posts and if it has 5 or more posts. To give 5 points to field user_points. If they do not have 5 posts or more it will not give them any points. Here is what I have that will reset everyone to zero <? define(\'IN_PHPBB\', true); $phpbb_root_path = \'./\'; include($phpbb_root_path . \'extension.inc\'); include($phpbb_root_path . \'common.\'.$phpEx); include($phpbb_root_path . \'includes/functions_selects.\'.$phpEx); $sql=array( \'UPDATE \'.USERS_TABLE.\' SET user_points=0 \' ); $userdata = session_pagestart($user_ip, PAGE_INDEX); init_userprefs($userdata); if ( $userdata[\'user_level\'] != ADMIN ) message_die(GENERAL_ERROR, "You are not Authorised to do this"); $n=0; while($sql[$n]) { if(!$result = $db->sql_query($sql[$n])) $message.="Failed to update line: ".($n+1)." , ".$sql[$n]."<br />"; else $message.="Succes line: ".($n+1)." , ".$sql[$n]."<br />"; $n++; } message_die(GENERAL_MESSAGE, $message); ?> Both fields I listed user_points and user_posts are in the same Table phpbb_users .... Any help is greatly appricated.. As of right now I have to manually add points to each user and its very time consuming. Thanks X