dir|^|Packages
file|^|Packages/modification.php|^|643|^|1054832918
<?

global $db_prefix, $YaBBversion;

$pos = strpos($YaBBversion, "YaBB SE 1.5");
if (!($pos === false))
  $myversion = '1.5+';

if ($myversion == '1.5+')
{
  rename('Packages/modification1.5.x.mod', 'Packages/modification.mod');
  unlink('Packages/modification1.4.1.mod');
}
else
{
  rename('Packages/modification1.4.1.mod', 'Packages/modification.mod');
  unlink('Packages/modification1.5.x.mod');
}

if (file_exists("Packages/uninstall.php"))
  unlink("Packages/uninstall.php");
if (file_exists("Packages/uninstall.txt"))
  unlink("Packages/uninstall.txt");
if (file_exists("Packages/uninstall.sql"))
  unlink("Packages/uninstall.sql");

?>file|^|Packages/modification.txt|^|78|^|1054832918
This mod adds the ability to remove all posts (and Topics) of a selected user.file|^|Packages/modification1.4.1.mod|^|2191|^|1054832919
<file>
english.lng
</file>

<search>
$txt[1] =
</search>

<before>
$txt['removepostsbymember1'] = "Remove Posts By Member";
$txt['removepostsbymember2'] = "Remove Topics Too";
$txt['removepostsbymember3'] = "Report Progress";
$txt['removepostsbymember4'] = "Delete Selected Member's Posts";
$txt['removepostsbymember5'] = "Are you sure you want to remove all posts made by this user?";
$txt['removepostsbymember6'] = "Deleting All Posts By Member: ";
$txt['removepostsbymember7'] = "Attempting to delete ";
$txt['removepostsbymember8'] = " is the first message in an active topic ";
$txt['removepostsbymember9'] = "Deleted ";
$txt['removepostsbymember10'] = "Skipping ";
$txt['removepostsbymember11'] = " is the first message in an empty topic";

</before>

<file>
german.lng
</file>

<search>
$txt[1] = 
</search>

<before>
//entferne alle Beitrgäe und eröffnete Themen eines Mitglieds
$txt['removepostsbymember1'] = "Entferne Beiträge eines Mitglieds";
$txt['removepostsbymember2'] = "Entferne auch dessen eröffnete Themen";
$txt['removepostsbymember3'] = "Bericht anzeigen";
$txt['removepostsbymember4'] = "Lösche die Beiträge des ausgewählten Mitglieds";
$txt['removepostsbymember5'] = "Bist Du sicher das Du alle Beiträge dieses Mitglieds Löschen willst?";
$txt['removepostsbymember6'] = "Lösche alle Beiträges eines Mitglieds: ";
$txt['removepostsbymember7'] = "Löschversuch für  ID_MSG ";
$txt['removepostsbymember8'] = " ist der erste Beitrag in einem Aktiven Thema ";
$txt['removepostsbymember9'] = "Lösche ";
$txt['removepostsbymember10'] = "Überspringe ";
$txt['removepostsbymember11'] = " ist der erste Beitrag in  einem leeren Thema";

</before>

<file>
Sources/Admin.php
</file>

<search>
<a href="$cgi;action=viewmembers">$txt[5]</a><br>
</search>

<add>
        <a href="$cgi;action=removepostsbymember">$txt[removepostsbymember1]</a><br>
</add>

<file>
index.php
</file>

<search>
#END FASTFIND R*
</search>

<before>
	else if ($action == 'removepostsbymember') { include_once "$sourcedir/RemovePostsByMember.php"; RemovePostsByMember(); }
	else if ($action == 'removepostsbymember2') { include_once "$sourcedir/RemovePostsByMember.php"; RemovePostsByMember2(); }
</before>
file|^|Packages/modification1.5.x.mod|^|2679|^|1054832919
<id>
Remove Posts By Member
</id>

<version>
1.0 (YabbSE 1.5.x)
</version>

<author>
Jack.R.Abbit
</author>

<email>
<a href="http://www.yabb.info/community/index.php?board=;action=imsend&to=Jack.R.Abbit">Jack.R.Abbit</a>
</email>

<homepage>
<a href="http://www.yabb.info/community/index.php?board=;action=viewprofile;user=Jack.R.Abbit">Jack.R.Abbit</a>
</homepage>

<info>
This mod adds the ability to remove all posts (and Topics) of a selected user.
</info>

<approved>
no
</approved>

<file>
english.lng
</file>

<search>
$txt[1] =
</search>

<before>
$txt['removepostsbymember1'] = 'Remove Posts By Member';
$txt['removepostsbymember2'] = 'Remove Topics Too';
$txt['removepostsbymember3'] = 'Report Progress';
$txt['removepostsbymember4'] = 'Delete Selected Member\'s Posts';
$txt['removepostsbymember5'] = 'Are you sure you want to remove all posts made by this user?';
$txt['removepostsbymember6'] = 'Deleting All Posts By Member: ';
$txt['removepostsbymember7'] = 'Attempting to delete ';
$txt['removepostsbymember8'] = ' is the first message in an active topic ';
$txt['removepostsbymember9'] = 'Deleted ';
$txt['removepostsbymember10'] = 'Skipping ';
$txt['removepostsbymember11'] = ' is the first message in an empty topic';

</before>

<file>
german.lng
</file>

<search>
$txt[1] = 
</search>

<before>
//entferne alle Beitrgäe und eröffnete Themen eines Mitglieds
$txt['removepostsbymember1'] = 'Entferne Beiträge eines Mitglieds';
$txt['removepostsbymember2'] = 'Entferne auch dessen eröffnete Themen';
$txt['removepostsbymember3'] = 'Bericht anzeigen';
$txt['removepostsbymember4'] = 'Lösche die Beiträge des ausgewählten Mitglieds';
$txt['removepostsbymember5'] = 'Bist Du sicher das Du alle Beiträge dieses Mitglieds Löschen willst?';
$txt['removepostsbymember6'] = 'Lösche alle Beiträges eines Mitglieds: ';
$txt['removepostsbymember7'] = 'Löschversuch für  ID_MSG ';
$txt['removepostsbymember8'] = ' ist der erste Beitrag in einem Aktiven Thema ';
$txt['removepostsbymember9'] = 'Lösche ';
$txt['removepostsbymember10'] = 'Überspringe ';
$txt['removepostsbymember11'] = ' ist der erste Beitrag in  einem leeren Thema';

</before>

<file>
Sources/Admin.php
</file>

<search>
<a href="' . $scripturl . '?action=viewmembers">' . $txt[5] . '</a><br />
</search>

<add>
									<a href="' . $scripturl . '?action=removepostsbymember">' . $txt['removepostsbymember1'] . '</a><br />
</add>

<file>
index.php
</file>

<search>
	$actionArray = array(
</search>

<add>
		'removepostsbymember' => array("$sourcedir/RemovePostsByMember.php", 'RemovePostsByMember'),
		'removepostsbymember2' => array("$sourcedir/RemovePostsByMember.php", 'RemovePostsByMember2'),
</add>
file|^|Packages/uninstall.php|^|594|^|1054832920
<?

global $db_prefix, $YaBBversion;

$pos = strpos($YaBBversion, "YaBB SE 1.5");
if (!($pos === false))
  $myversion = '1.5+';

echo 'Building modification.mod<br />';
if ($myversion == '1.5+')
{
  rename('Packages/modification1.5.x.mod', 'Packages/modification.mod');
  unlink('Packages/modification1.4.1.mod');
}
else
{
  rename('Packages/modification1.4.1.mod', 'Packages/modification.mod');
  unlink('Packages/modification1.5.x.mod');
}

if (file_exists("Sources/RemovePostsByMember.php"))
{
	echo 'Removing RemovePostsByMember.php<br />';
  unlink("Sources/RemovePostsByMember.php");
}
?>file|^|Packages/uninstall.txt|^|64|^|1054832920
Trying to run uninstall files for removepostsbymember.mod.yp....dir|^|Sources
file|^|Sources/RemovePostsByMember.php|^|13890|^|1054834849
<?php
/*****************************************************************************/
/* RemovePostsByMember.php                                                   */
/*****************************************************************************/
/* YaBB: Yet another Bulletin Board                                          */
/* Open-Source Project started by Zef Hemel (zef@zefnet.com)                 */
/* Software Version: YaBB SE                                                 */
/* ========================================================================= */
/* Software Distributed by:    http://www.yabb.info                          */
/* Support, News, Updates at:  http://www.yabb.info/community                */
/*                             http://yabb.xnull.com/community               */
/* ========================================================================= */
/* Copyright (c) 2001-2002 The YaBB Development Team                         */
/* Software by: The YaBB Development Team                                    */
/* This Mod by: Jack R. Abbit                                                */
/*****************************************************************************/
/* This program is free software; you can redistribute it and/or modify it   */
/* under the terms of the GNU General Public License as published by the     */
/* Free Software Foundation; either version 2 of the License, or (at your    */
/* option) any later version.                                                */
/*                                                                           */
/* This program is distributed in the hope that it will be useful, but       */
/* WITHOUT ANY WARRANTY; without even the implied warranty of                */
/* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU General */
/* Public License for more details.                                          */
/*                                                                           */
/* The GNU GPL can be found in gpl.txt in this directory                     */
/*****************************************************************************/

$removepostsbymemberplver="YaBB SE 1.5.1";

function RemovePostsByMember()
{
	global $imagesdir,$cgi,$settings,$txt,$db_prefix,$modSettings,$maxdays;

	if($settings[7] != "Administrator")
		fatal_error($txt[1]);

	template_header();
	echo '
<table border="0" width="300" cellspacing="1" cellpadding="2" bgcolor="' . $color['bordercolor'] . '" class="bordercolor" align="center">
  <tr>
    <td class="titlebg" bgcolor="' . $color['titlebg'] . '">
    <script language="javascript" TYPE="text/javascript">
		<!--
		function reqWin(desktopURL){
        desktop =window.open(desktopURL,"name","toolbar=no,location=no,status=no,menubar=no,scrollbars=yes,width=400,height=200,resizable=no");
        }
		// -->
	</script>
<script language="JavaScript1.2" type="text/javascript"><!--
	function DoConfirm(message, url) {
		if(confirm(message)) return true;

    return false;
	}
//-->
</script>
    <font size="2" class="text1" color="' . $color['titletext'] . '"><b>' . $txt['removepostsbymember1'] . '</b></font></td>
  </tr><tr>
    <td class="windowbg" bgcolor="' . $color['windowbg'] . '" align="left" width="95%">
    <form action="' . $cgi . ';action=removepostsbymember2" method="POST" onSubmit="return DoConfirm(\'' . $txt['removepostsbymember5'] . '\');">
    <table border="0" cellspacing="4" cellpadding="0" align="center" width="95%">
    <tr>
      <td align="center" valign="top">
        <select name="spamember">';

	$request = mysql_query("SELECT memberName,realName,ID_MEMBER FROM {$db_prefix}members WHERE 1 ORDER BY memberName") or database_error(__FILE__, __LINE__);
	while ($curmem = mysql_fetch_array($request))
  {
		$rname = isset($curmem['realName']) ? "($curmem[realName])" : '';
		$euser=urlencode($curmem['memberName']);
    echo '<option value="' . $curmem['ID_MEMBER'] . '">' . $curmem['memberName'] . '</option>';
	}
	echo '
      </select></td><td>
			<input type="checkbox" name="removeTopics" value="1"> ' . $txt['removepostsbymember2'] . '<br><br>
			<input type="checkbox" name="reportProgress" value="1"> ' . $txt['removepostsbymember3'] . '<br><br>
    </td>
  </tr>
	<tr>
	<td colspan="2" class="windowbg" bgcolor="' . $color['windowbg'] . '" align="center">
    <input type="submit" value="' . $txt['removepostsbymember4'] . '">
  </td>
  </tr>
</table>
</form>
</td>
  </tr>
    </table>';

	footer();
	obExit();
}

function RemovePostsByMember2()
{
	global $spamember,$removeTopics,$reportProgress,$settings,$txt,$db_prefix,$modSettings,$maxdays;

	if($settings[7] != "Administrator")
		fatal_error($txt[1]);
	$request = mysql_query("SELECT memberName FROM {$db_prefix}members WHERE ID_MEMBER=$spamember") or database_error(__FILE__, __LINE__);
	$curmem = mysql_fetch_array($request);

	template_header();
	$request = mysql_query("SELECT ID_MSG,ID_TOPIC,ID_MEMBER,subject,posterName FROM {$db_prefix}messages WHERE ID_MEMBER=$spamember") or database_error(__FILE__, __LINE__);

	if ($reportProgress)
		echo $txt['removepostsbymember6'] . ' ' . $curmem['memberName'] . '<br><br>';
	while ($curpost = mysql_fetch_array($request))
	{
		if ($reportProgress)
			echo $txt['removepostsbymember7'] . ' ID_MSG(' . $curpost['ID_MSG'] . ') - ' . $curpost['subject'] . '<br>';
		$postid = $curpost['ID_MSG'];
		$threadid = $curpost['ID_TOPIC'];

  	$request2 = mysql_query("SELECT m.*,t.locked,t.ID_FIRST_MSG,t.ID_LAST_MSG,t.ID_TOPIC,t.ID_BOARD,t.ID_POLL,t.numReplies FROM {$db_prefix}messages AS m, {$db_prefix}topics AS t WHERE (m.ID_MSG=$postid AND m.ID_TOPIC=t.ID_TOPIC) LIMIT 1") or database_error(__FILE__, __LINE__);
  	$row = mysql_fetch_assoc($request2);

		if ($row['ID_FIRST_MSG']==$row['ID_MSG'])	// this is the first message
		{
			if ($row['numReplies'] != 0)
			{
				if ($reportProgress)
					echo 'ID_MSG(' . $curpost['ID_MSG'] . ')' . $txt['removepostsbymember8'] . '<br>';

				if ($removeTopics == 1)
				{
					if ($reportProgress)
						echo '&nbsp;&nbsp;' . $txt['removepostsbymember7'] . ' ID_TOPIC(' . $curpost['ID_TOPIC'] . ')<br>';
					//Lines 38-45 all there to delete attachments on thread deletion - Jeff
					$request3 = mysql_query("SELECT attachmentFilename FROM {$db_prefix}messages WHERE (ID_TOPIC=$threadid AND (attachmentFilename IS NOT NULL))") or database_error(__FILE__, __LINE__);
					if (mysql_num_rows($request3)>0)
					{
						while($row2 = mysql_fetch_array($request3))
							unlink($modSettings['attachmentUploadDir'] . "/" . $row2['attachmentFilename']);
					}
					$request3 = mysql_query("SELECT ID_BOARD,numReplies,ID_POLL FROM {$db_prefix}topics WHERE ID_TOPIC=$threadid") or database_error(__FILE__, __LINE__);
					$row2 = mysql_fetch_array($request3);
					$request3 = mysql_query("DELETE FROM {$db_prefix}polls WHERE ID_POLL='$row2[ID_POLL]' LIMIT 1") or database_error(__FILE__, __LINE__);
					$row2['numReplies']++;
					$request3 = mysql_query("UPDATE {$db_prefix}boards SET numTopics=numTopics-1,numPosts=numPosts-$row2[numReplies] WHERE ID_BOARD=$row2[ID_BOARD]") or database_error(__FILE__, __LINE__);
					$request3 = mysql_query("DELETE FROM {$db_prefix}topics WHERE ID_TOPIC=$threadid") or database_error(__FILE__, __LINE__);
					$request3 = mysql_query("DELETE FROM {$db_prefix}messages WHERE ID_TOPIC=$threadid") or database_error(__FILE__, __LINE__);
					$request3 = mysql_query("Delete From {$db_prefix}calendar Where id_topic=$threadid") or database_error(__FILE__, __LINE__);
					$request3 = mysql_query("DELETE FROM {$db_prefix}log_topics WHERE ID_TOPIC=$threadid") or database_error(__FILE__, __LINE__);
					if ($reportProgress)
						echo '&nbsp;&nbsp;' . $txt['removepostsbymember9'] . ' ID_TOPIC(' . $curpost['ID_TOPIC'] . ')<br>';
					if ($reportProgress)
						echo $txt['removepostsbymember9'] . ' ID_MSG(' . $curpost['ID_MSG'] . ')<br><br>';
				}
				else if ($removeTopics != 1)
				{
					if ($reportProgress)
						echo '&nbsp;&nbsp;' . $txt['removepostsbymember10'] . ' ID_TOPIC(' . $curpost['ID_TOPIC'] . ')<br>';
					if ($reportProgress)
						echo $txt['removepostsbymember10'] . ' ID_MSG(' . $curpost['ID_MSG'] . ')<br><br>';
				}
			}
			else if ($row['numReplies'] == 0)
			{
				if ($reportProgress)
					echo 'ID_MSG(' . $curpost['ID_MSG'] . ')' . $txt['removepostsbymember11'] . '<br>';
				if ($reportProgress)
					echo '&nbsp;&nbsp;' . $txt['removepostsbymember7'] . ' ID_TOPIC(' . $curpost['ID_TOPIC'] . ')<br>';
				$request3 = mysql_query("DELETE FROM {$db_prefix}topics WHERE ID_TOPIC=$row[ID_TOPIC] LIMIT 1") or database_error(__FILE__, __LINE__);
				$request3 = mysql_query("DELETE FROM {$db_prefix}polls WHERE ID_POLL='$row[ID_POLL]' LIMIT 1") or database_error(__FILE__, __LINE__);
				$request3 = mysql_query("UPDATE {$db_prefix}boards SET numPosts=numPosts-1,numTopics=numTopics-1 WHERE ID_BOARD=$row[ID_BOARD] $doLimitOne") or database_error(__FILE__, __LINE__);
				$request3 = mysql_query("DELETE FROM {$db_prefix}calendar WHERE id_topic = '$row[ID_TOPIC]'") or database_error(__FILE__, __LINE__);
				$request3 = mysql_query("DELETE FROM {$db_prefix}messages WHERE ID_MSG=$postid LIMIT 1") or database_error(__FILE__, __LINE__);
				if ($reportProgress)
					echo '&nbsp;&nbsp;' . $txt['removepostsbymember9'] . ' ID_TOPIC(' . $curpost['ID_TOPIC'] . ')<br>';
				if ($reportProgress)
					echo $txt['removepostsbymember9'] . ' ID_MSG(' . $curpost['ID_MSG'] . ')<br><br>';
			}
		}
		else if ($row['ID_FIRST_MSG']==$row['ID_LAST_MSG'])	// this is the only post
		{
			$request3 = mysql_query("DELETE FROM {$db_prefix}topics WHERE ID_TOPIC=$row[ID_TOPIC] LIMIT 1") or database_error(__FILE__, __LINE__);
			$request3 = mysql_query("DELETE FROM {$db_prefix}polls WHERE ID_POLL='$row[ID_POLL]' LIMIT 1") or database_error(__FILE__, __LINE__);
			$request3 = mysql_query("UPDATE {$db_prefix}boards SET numPosts=numPosts-1,numTopics=numTopics-1 WHERE ID_BOARD=$row[ID_BOARD] $doLimitOne") or database_error(__FILE__, __LINE__);
			if ($reportProgress)
				echo $txt['removepostsbymember9'] . ' ID_MSG(' . $curpost['ID_MSG'] . ')<br><br>';
		}
		else if ($row['ID_LAST_MSG']==$row['ID_MSG'])	// this is the last message
		{
			$request3 = mysql_query("SELECT ID_MSG FROM {$db_prefix}messages WHERE (ID_TOPIC=$row[ID_TOPIC] AND ID_MSG!=$row[ID_MSG]) ORDER BY ID_MSG DESC LIMIT 1") or database_error(__FILE__, __LINE__);
			$row2 = mysql_fetch_assoc($request3);
			$request3 = mysql_query("UPDATE {$db_prefix}topics SET ID_LAST_MSG=$row2[ID_MSG],numReplies=numReplies-1 WHERE ID_TOPIC=$row[ID_TOPIC] $doLimitOne") or database_error(__FILE__, __LINE__);
			$request3 = mysql_query("UPDATE {$db_prefix}boards SET numPosts=numPosts-1 WHERE ID_BOARD=$row[ID_BOARD] $doLimitOne") or database_error(__FILE__, __LINE__);
			// I don't think it's possible to ever reach this "if" condition. The first IF will always catch this
			// case before it gets to here. I added the calendar code just in case, but....
			$request3 = mysql_query("DELETE FROM {$db_prefix}calendar WHERE ID_TOPIC = '$row[ID_TOPIC]'") or database_error(__FILE__, __LINE__);
			$request3 = mysql_query("DELETE FROM {$db_prefix}messages WHERE ID_MSG=$postid LIMIT 1") or database_error(__FILE__, __LINE__);
			if ($reportProgress)
				echo $txt['removepostsbymember9'] . ' ID_MSG(' . $curpost['ID_MSG'] . ')<br><br>';
		}
		else // this is just "some" message
		{
			$request3 = mysql_query("UPDATE {$db_prefix}topics SET numReplies=numReplies-1 WHERE ID_TOPIC=$row[ID_TOPIC] $doLimitOne") or database_error(__FILE__, __LINE__);
			$request3 = mysql_query("UPDATE {$db_prefix}boards SET numPosts=numPosts-1 WHERE ID_BOARD=$row[ID_BOARD] $doLimitOne") or database_error(__FILE__, __LINE__);
			$request3 = mysql_query("DELETE FROM {$db_prefix}messages WHERE ID_MSG=$postid LIMIT 1") or database_error(__FILE__, __LINE__);
			if ($reportProgress)
				echo $txt['removepostsbymember9'] . ' ID_MSG(' . $curpost['ID_MSG'] . ')<br><br>';
		}
		if( $row['ID_MEMBER'] != '-1')
			$request3 = mysql_query("UPDATE {$db_prefix}members SET posts=posts-1 WHERE (ID_MEMBER=$row[ID_MEMBER] && posts > 0) $doLimitOne;") or database_error(__FILE__, __LINE__);

		#delete attachment, by Meriadoc
		if ($row['attachmentSize'] > 0)
			unlink($modSettings['attachmentUploadDir'] . "/" . $row['attachmentFilename']);
	}

	// Recount all the boards
	global $sourcedir,$subsphpver;

  $pos = strpos($subsphpver, "YaBB SE 1.5");
  if (!($pos === false))
    $myversion = '1.5+';

	$request = mysql_query("SELECT ID_BOARD FROM {$db_prefix}boards WHERE 1;") or database_error(__FILE__, __LINE__);
	while ($row = mysql_fetch_row($request))
	{
		$result = mysql_query("SELECT ID_TOPIC FROM {$db_prefix}topics WHERE ID_BOARD=$row[0];") or database_error(__FILE__, __LINE__);
		$topics = mysql_num_rows($result);
		while ($row2 = mysql_fetch_row($result))
		{
			$result2 = mysql_query("SELECT COUNT(*) AS count FROM {$db_prefix}messages WHERE ID_TOPIC=$row2[0];") or database_error(__FILE__, __LINE__);
			$row3 = mysql_fetch_row($result2);
			$result2 = mysql_query("UPDATE {$db_prefix}topics SET numReplies=$row3[0]-1 WHERE ID_TOPIC=$row2[0];") or database_error(__FILE__, __LINE__);
		}
		$result = mysql_query("SELECT COUNT(*) FROM {$db_prefix}messages AS m, {$db_prefix}topics AS t WHERE (m.ID_TOPIC=t.ID_TOPIC AND t.ID_BOARD=$row[0]);") or database_error(__FILE__, __LINE__);
		$tmp = mysql_fetch_row($result);
		$posts = $tmp[0];
		$result = mysql_query("UPDATE {$db_prefix}boards SET numTopics=$topics, numPosts=$posts WHERE ID_BOARD=$row[0];") or database_error(__FILE__, __LINE__);
		if ($myversion == '1.5+')
			updateLastMessage($row[0]);
	}
	if ($myversion == '1.5+')
	{
		updateStats('member');
		updateStats('message');
		updateStats('topic');
		echo $txt[503] . '<br><br>';
	}

	echo $txt[51] . '<br><br>';
	footer();
	obExit();
}
?>