phpBB.de

Code: Alles auswählen

#--------- [ DATEI ÖFFNEN ] -----------------------------
#
modcp.php
#
#--------- [ FINDE ] -----------------------------
#
         while ( $row = $db->sql_fetchrow($result) )
         {
            $count_sql[] = "UPDATE " . USERS_TABLE . "
               SET user_posts = user_posts - " . $row['posts'] . "
               WHERE user_id = " . $row['poster_id'];
         } 

Code: Alles auswählen

 }

Code: Alles auswählen

$user_updated [] = "SELECT ug.user_id, g.group_id as g_id, u.user_posts, g.group_count, g.group_count_max, ".$row['poster_id']." as u_id FROM " . GROUPS_TABLE . " g, ".USERS_TABLE." u
		LEFT JOIN ". USER_GROUP_TABLE." ug ON g.group_id=ug.group_id AND ug.user_id=".$row['poster_id']."
		WHERE u.user_id=".$row['poster_id']."
		AND g.group_single_user=0
	AND g.group_count_enable=1
	AND g.group_moderator<>".$row['poster_id'];