phpBB.de

Code: Alles auswählen

?php
// hier den relativen Pfad zur config.php des Forums eintragen
include ("./phpBB2/config.php");

// Parameter für Topic_ID ANPASSEN!!
$topic_to_clean = 22;

// Parameter für minimale Postinganzahl im Topic.
// Es bleibt nur das Starterposting erhalten.
$j = 0;


/*** DO NOT CHANGE CODE BEYOND THIS LINE ***/

$db = @MYSQL_CONNECT($dbhost,$dbuser,$dbpasswd)
      or die ("Konnte keine Verbindung zur Datenbank herstellen");
$db_check = @MYSQL_SELECT_DB($dbname);

$posts_to_kill = '';

$sql = "SELECT post_id
       FROM `" . $table_prefix . "posts`
       WHERE `topic_id` = '" . $topic_to_clean . "'
       ORDER BY post_id ASC";
if ( !($result = mysql_query($sql)) ) {
    message_die(GENERAL_ERROR, 'Konnte die Postdaten nicht auslesen', '', __LINE__, __FILE__, $sql);
}

$kill_post = array();
while ( $row = mysql_fetch_array($result) ) {
    $kill_post[] = $row['post_id'];
}

array_shift($kill_post);

if (count($kill_post) > $j) {
    for ($i=0; $i<(count($kill_post)-$j); $i++) {
           $posts_to_kill .= (($i+1)<(count($kill_post)-$j)) ? ($kill_post[$i] . ",") : $kill_post[$i];
    }
    $sql = array();
    $sql[] = "DELETE FROM `" . $table_prefix . "posts_text`
              WHERE `post_id` IN ($posts_to_kill)";
    $sql[] = "DELETE FROM `" . $table_prefix . "posts`
              WHERE `post_id` IN ($posts_to_kill)";
    for( $i = 0; $i < count($sql); $i++ ) {
        if( !$result = mysql_query ($sql[$i]) ) {
                $error = mysql_error();
        }
    }
}
$db_close = @MYSQL_CLOSE($db);
?>

Code: Alles auswählen

    $sql[] = "DELETE FROM `" . $table_prefix . "posts`
              WHERE `post_id` IN ($posts_to_kill)";

Code: Alles auswählen

    $sql[] = "UPDATE `" . $table_prefix . "topics`
              SET `topic_last_post_id` = `topic_first_post_id`,
              `topic_views` = 0,
              `topic_replies` = 0,
              `topic_vote` = 0,
              `topic_moved_id` = 0
              WHERE `topic_id` = " . $topic_to_clean;