insanctus hat geschrieben:Ach das is mir zuviel aufwand für die ganzen spamposts

Als irgendwas.php abspeichern, aufrufen und die Beitrags-ID eingeben
Code: Alles auswählen
<?php
define('IN_PHPBB', true);
$phpbb_root_path = './';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);
//
// Start session management
//
$userdata = session_pagestart($user_ip, PAGE_INDEX);
init_userprefs($userdata);
//
// End session management
//
if( $userdata['user_level'] != ADMIN )
{
message_die(GENERAL_MESSAGE, 'You are not authorised to access this page');
}
include($phpbb_root_path . 'includes/page_header.'.$phpEx);
if(isset($_POST['start']) && isset($_POST['topic_id']))
{
$topic_id = $_POST['topic_id'];
$sql = "SELECT DISTINCT poster_id
FROM ". POSTS_TABLE ."
WHERE topic_id = '$topic_id'
AND poster_id != '-1'";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not get post user', '', __LINE__, __FILE__, $sql);
}
$user = array();
while ( $row = $db->sql_fetchrow($result) )
{
$user[] = $row;
}
for($i = 0; $i < count($user); $i++)
{
$sql = "SELECT COUNT(*) as post_count
FROM ". POSTS_TABLE ."
WHERE poster_id = '". $user[$i]['poster_id'] ."'
AND topic_id = '$topic_id'";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not count user postss', '', __LINE__, __FILE__, $sql);
}
$row = $db->sql_fetchrow($result);
$sql = "UPDATE ". USERS_TABLE ."
SET user_posts = (user_posts - '". $row['post_count'] ."')
WHERE user_id = '". $user[$i]['poster_id'] ."'";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not update user posts', '', __LINE__, __FILE__, $sql);
}
}
message_die(GENERAL_MESSAGE, "<b>$i</b> User aktualisiert</font>");
}
else
{
echo '<table width="100%" border="0" class="forumline"><tr><td width="100%" align="center" class="row1"><form method="post"><br /><span class="genmed">ID des Beitrags eingeben: <input type="text" name="topic_id" /><br /><br /><input type="submit" name="start" value=" los " class="mainoption" /></span></form><br /></td></tr></table>';
}
include($phpbb_root_path . 'includes/page_tail.'.$phpEx);
?>
@EraZor Finde
Code: Alles auswählen
if ( $mode != 'poll_delete' && in_array($forum_id, $fid) == false )
Ersetze mit
Finde
Code: Alles auswählen
if ($mode != 'poll_delete')
{
$sql = "UPDATE " . USERS_TABLE . "
SET user_posts = user_posts $sign
WHERE user_id = $user_id";
Ersetze mit
Code: Alles auswählen
if ($mode != 'poll_delete' && in_array($forum_id, $fid) == false )
{
$sql = "UPDATE " . USERS_TABLE . "
SET user_posts = user_posts $sign
WHERE user_id = $user_id";