SMF user merging script

**Lefteris_D** · December 10th, 2004, 12:17

This is my first real addon for a forum other than Invision or vBulletin3 so some debugging is required. If anyone has an SMF installed as well I'd be very happy if you can have it tested.

Just drop it in the root directory of your forum and log in as any valid administrator account.

Code:

&#60;?php

require&#40;dirname&#40;__FILE__&#41; . &#39;/SSI.php&#39;&#41;;
require_once&#40;&#036;sourcedir . &#39;/ManageMembers.php&#39;&#41;;

// Check if user is Administrator
if &#40;&#33;&#036;context&#91;&#39;allow_admin&#39;&#93;&#41;
{
echo &#39;A valid administrator forum session is required to access this page.&#39;;
exit;
}

?&#62;

&#60;html&#62;
&#60;home&#62;
&#60;title&#62;SMF User Merging Script&#60;/title&#62;
&#60;/home&#62;
&#60;body&#62;
&#60;br /&#62;
&#60;table border=&#34;1&#34; width=&#34;800&#34; align=&#34;center&#34; bgcolor=&#34;lightgray&#34;&#62;
&#60;tr&#62;
&#60;td align=&#34;center&#34;&#62;&#60;b&#62;SMF User Merging Script&#60;/b&#62;&#60;/td&#62;
&#60;/tr&#62;
&#60;?php
if &#40;isset&#40;&#036;_POST&#91;&#39;step&#39;&#93;&#41;&#41; {
//Continue
} else {
?&#62;
&#60;tr&#62;
&#60;td&#62;
This script will allow a forum administrator to merge two users into one. The script currently supports&#58;
&#60;ul&#62;
&#60;li&#62;User topics&#60;/li&#62;
&#60;li&#62;User posts&#60;/li&#62;
&#60;li&#62;User callendar events&#60;/li&#62;
&#60;li&#62;User Attachments&#60;/li&#62;
&#60;li&#62;Private Messages&#60;/li&#62;
&#60;/ul&#62;
Everything else shall be removed once the &#34;source user&#34; has been deleted. To perform the operation you need the source user and destination user ID&#39;s.
&#60;br /&#62;
&#60;/br /&#62;
&#60;span style=&#34;color&#58; darkred;&#34;&#62;&#60;b&#62;Please Note&#58;&#60;/b&#62; This script comes with no support and it might damage your forum. A database backup before continuing is suggested. Also make sure that both user ID&#39;s are valid.&#60;/span&#62;
&#60;br /&#62;
&#60;br /&#62;
&#60;div align=&#34;center&#34;&#62;&#60;FORM action=&#34;smf-merge-users.php&#34; method=&#34;post&#34;&#62;&#60;INPUT type=&#34;hidden&#34; name=&#34;step&#34; value=&#34;dataform&#34;&#62;&#60;INPUT type=&#34;submit&#34; value=&#34;Begin&#34;&#62;&#60;/FORM&#62;&#60;/div&#62;
&#60;/td&#62;
&#60;/tr&#62;
&#60;?php
exit;
}

if &#40;&#036;_POST&#91;&#39;step&#39;&#93; == &#39;dataform&#39;&#41;
{
// ok
}
else
{
// Catch 0 bug
if &#40;&#036;_POST&#91;&#39;destinationid&#39;&#93; == &#39;0&#39;&#41;
{
echo &#39;&#60;tr&#62;&#60;td&#62;&#39;;
echo &#39;&#60;div align=&#34;center&#34;&#62;&#60;b&#62;Warning&#58;&#60;/b&#62; Destination User ID cannot be 0&#60;/div&#62;&#39;;
echo &#39;&#60;/td&#62;&#60;/tr&#62;&#39;;
echo &#39;&#60;/table&#62;&#60;/body&#62;&#60;/html&#62;&#39;;
exit;
}
else
{
// do nothing
}
if &#40;&#036;_POST&#91;&#39;sourceid&#39;&#93; == &#39;0&#39;&#41;
{
echo &#39;&#60;tr&#62;&#60;td&#62;&#39;;
echo &#39;&#60;div align=&#34;center&#34;&#62;&#60;b&#62;Warning&#58;&#60;/b&#62; Source User ID cannot be 0&#60;/div&#62;&#39;;
echo &#39;&#60;/td&#62;&#60;/tr&#62;&#39;;
echo &#39;&#60;/table&#62;&#60;/body&#62;&#60;/html&#62;&#39;;
exit;
}
else
{
// do nothing
}

// &#036;_POST&#91;&#39;destinationid&#39;&#93; and &#036;_POST&#91;&#39;sourceid&#39;&#93; must not be the same
if &#40;&#036;_POST&#91;&#39;destinationid&#39;&#93; == &#036;_POST&#91;&#39;sourceid&#39;&#93;&#41;
{
echo &#39;&#60;tr&#62;&#60;td&#62;&#39;;
echo &#39;&#60;div align=&#34;center&#34;&#62;&#60;b&#62;Warning&#58;&#60;/b&#62; Destination User and Source User cannot be the same&#60;/div&#62;&#39;;
echo &#39;&#60;/td&#62;&#60;/tr&#62;&#39;;
echo &#39;&#60;/table&#62;&#60;/body&#62;&#60;/html&#62;&#39;;
exit;
}
else
{
// do nothing
}

if &#40;&#036;_POST&#91;&#39;sourceid&#39;&#93; == &#39;0&#39;&#41;
{
echo &#39;&#60;tr&#62;&#60;td&#62;&#39;;
echo &#39;&#60;div align=&#34;center&#34;&#62;&#60;b&#62;Warning&#58;&#60;/b&#62; Source User ID cannot be 0&#60;/div&#62;&#39;;
echo &#39;&#60;/td&#62;&#60;/tr&#62;&#39;;
echo &#39;&#60;/table&#62;&#60;/body&#62;&#60;/html&#62;&#39;;
exit;
}
else
{
// do nothing
}

// Make sure &#036;_POST&#91;&#39;destinationid&#39;&#93; is not null
if &#40;&#036;_POST&#91;&#39;destinationid&#39;&#93; == NULL&#41;
{
echo &#39;&#60;tr&#62;&#60;td&#62;&#39;;
echo &#39;&#60;div align=&#34;center&#34;&#62;&#60;b&#62;Warning&#58;&#60;/b&#62; Destination User ID cannot be empty&#60;/div&#62;&#39;;
echo &#39;&#60;/td&#62;&#60;/tr&#62;&#39;;
echo &#39;&#60;/table&#62;&#60;/body&#62;&#60;/html&#62;&#39;;
exit;
}
else
{
// do nothing
}

// Make sure &#036;_POST&#91;&#39;sourceid&#39;&#93; is not null
if &#40;&#036;_POST&#91;&#39;sourceid&#39;&#93; == NULL&#41;
{
echo &#39;&#60;tr&#62;&#60;td&#62;&#39;;
echo &#39;&#60;div align=&#34;center&#34;&#62;&#60;b&#62;Warning&#58;&#60;/b&#62; Source User ID cannot be empty&#60;/div&#62;&#39;;
echo &#39;&#60;/td&#62;&#60;/tr&#62;&#39;;
echo &#39;&#60;/table&#62;&#60;/body&#62;&#60;/html&#62;&#39;;
exit;
}
else
{
// do nothing
}
}
// Let&#39;s begin with the steps&#33;

// Data Form &#40;Step 0&#41;
if &#40;&#036;_POST&#91;&#39;step&#39;&#93; == &#39;dataform&#39;&#41;
{
echo &#39;&#60;tr&#62;&#60;td align=&#34;center&#34;&#62;Please insert the required information.&#60;br /&#62;&#39;;
echo &#39;&#60;FORM action=&#34;smf-merge-users.php&#34; method=&#34;post&#34;&#62;Source User&#40;will be deleted&#41;&#58; &#60;INPUT type=&#34;text&#34; name=&#34;sourceid&#34; SIZE=&#34;5&#34; MAXLENGTH=&#34;5&#34;&#62;&#60;br /&#62;Destination User&#40;will remain intact&#41;&#60;INPUT type=&#34;text&#34; name=&#34;destinationid&#34; SIZE=&#34;5&#34; MAXLENGTH=&#34;5&#34;&#62;&#60;br /&#62;&#60;INPUT type=&#34;hidden&#34; name=&#34;step&#34; value=&#34;mergethreads&#34;&#62;&#60;BR&#62;&#60;INPUT type=&#34;submit&#34; value=&#34;Click to proceed to merge topics&#34;&#62;&#60;/FORM&#62;&#39;;
echo &#39;&#60;/td&#62;&#60;/tr&#62;&#39;;
}
else
{
// do nothing
}



// Topic Merging Operation &#40;Step 1&#41;
if &#40;&#036;_POST&#91;&#39;step&#39;&#93; == &#39;mergethreads&#39;&#41;
{
&#036;dstid = &#036;_POST&#91;&#39;destinationid&#39;&#93;;
&#036;srcid = &#036;_POST&#91;&#39;sourceid&#39;&#93;;

echo &#39;&#60;tr&#62;&#60;td&#62;&#60;div align=&#34;center&#34;&#62;Step 1&#58; Μerging Topics&#60;br /&#62;&#39;;
// Add the SQL code here
db_query&#40;&#34;UPDATE {&#036;db_prefix}topics SET ID_MEMBER_STARTED=&#036;dstid WHERE ID_MEMBER_STARTED=&#036;srcid&#34;, __FILE__, __LINE__&#41;;
db_query&#40;&#34;UPDATE {&#036;db_prefix}topics SET ID_MEMBER_UPDATED=&#036;dstid WHERE ID_MEMBER_UPDATED=&#036;srcid&#34;, __FILE__, __LINE__&#41;;
?&#62;
&#60;FORM action=&#34;smf-merge-users.php&#34; method=&#34;post&#34;&#62;&#60;INPUT type=&#34;hidden&#34; name=&#34;sourceid&#34; SIZE=&#34;5&#34; MAXLENGTH=&#34;5&#34; value=&#34;&#60;? echo &#036;_POST&#91;&#39;sourceid&#39;&#93;; ?&#62;&#34;&#62;&#60;INPUT type=&#34;hidden&#34; name=&#34;destinationid&#34; SIZE=&#34;5&#34; MAXLENGTH=&#34;5&#34; value=&#34;&#60;? echo &#036;_POST&#91;&#39;destinationid&#39;&#93;; ?&#62;&#34;&#62;&#60;br /&#62;&#60;INPUT type=&#34;hidden&#34; name=&#34;step&#34; value=&#34;mergeposts&#34;&#62;&#60;INPUT type=&#34;submit&#34; value=&#34;Click to proceed to merge posts&#34;&#62;&#60;/FORM&#62;
&#60;br /&#62;
&#60;?php
echo &#39;&#60;/div&#62;&#60;/td&#62;&#60;/tr&#62;&#39;;
}
else
{
// do nothing
}


// Post Merging Operation &#40;Step 2&#41;
if &#40;&#036;_POST&#91;&#39;step&#39;&#93; == &#39;mergeposts&#39;&#41;
{
&#036;dstid = &#036;_POST&#91;&#39;destinationid&#39;&#93;;
&#036;srcid = &#036;_POST&#91;&#39;sourceid&#39;&#93;;

echo &#39;&#60;tr&#62;&#60;td&#62;&#60;div align=&#34;center&#34;&#62;Step 2&#58; Merging posts&#60;br /&#62;&#39;;
// Add the SQL code here
db_query&#40;&#34;UPDATE {&#036;db_prefix}messages SET ID_MEMBER=&#39;&#036;dstid&#39; WHERE ID_MEMBER=&#39;&#036;srcid&#39;&#34;, __FILE__, __LINE__&#41;;
?&#62;
&#60;FORM action=&#34;smf-merge-users.php&#34; method=&#34;post&#34;&#62;&#60;INPUT type=&#34;hidden&#34; name=&#34;sourceid&#34; SIZE=&#34;5&#34; MAXLENGTH=&#34;5&#34; value=&#34;&#60;? echo &#036;_POST&#91;&#39;sourceid&#39;&#93;; ?&#62;&#34;&#62;&#60;INPUT type=&#34;hidden&#34; name=&#34;destinationid&#34; SIZE=&#34;5&#34; MAXLENGTH=&#34;5&#34; value=&#34;&#60;? echo &#036;_POST&#91;&#39;destinationid&#39;&#93;; ?&#62;&#34;&#62;&#60;br /&#62;&#60;INPUT type=&#34;hidden&#34; name=&#34;step&#34; value=&#34;mergeattachments&#34;&#62;&#60;INPUT type=&#34;submit&#34; value=&#34;Click to proceed to merge attachments&#34;&#62;&#60;/FORM&#62;
&#60;br /&#62;
&#60;?php
echo &#39;&#60;/div&#62;&#60;/td&#62;&#60;/tr&#62;&#39;;
}
else
{
// do nothing
}


// Merge Attachments &#40;Step 3&#41;
if &#40;&#036;_POST&#91;&#39;step&#39;&#93; == &#39;mergeattachments&#39;&#41;
{
&#036;dstid = &#036;_POST&#91;&#39;destinationid&#39;&#93;;
&#036;srcid = &#036;_POST&#91;&#39;sourceid&#39;&#93;;
echo &#39;&#60;tr&#62;&#60;td&#62;&#60;div align=&#34;center&#34;&#62;Step 3&#58; Merging attachments&#60;br /&#62;&#39;;
// Add the SQL code here
db_query&#40;&#34;UPDATE {&#036;db_prefix}attachments SET ID_MEMBER=&#39;&#036;dstid&#39; WHERE ID_MEMBER=&#39;&#036;srcid&#39;&#34;, __FILE__, __LINE__&#41;;
?&#62;
&#60;FORM action=&#34;smf-merge-users.php&#34; method=&#34;post&#34;&#62;&#60;INPUT type=&#34;hidden&#34; name=&#34;sourceid&#34; SIZE=&#34;5&#34; MAXLENGTH=&#34;5&#34; value=&#34;&#60;? echo &#036;_POST&#91;&#39;sourceid&#39;&#93;; ?&#62;&#34;&#62;&#60;INPUT type=&#34;hidden&#34; name=&#34;destinationid&#34; SIZE=&#34;5&#34; MAXLENGTH=&#34;5&#34; value=&#34;&#60;? echo &#036;_POST&#91;&#39;destinationid&#39;&#93;; ?&#62;&#34;&#62;&#60;br /&#62;&#60;INPUT type=&#34;hidden&#34; name=&#34;step&#34; value=&#34;mergepm&#34;&#62;&#60;INPUT type=&#34;submit&#34; value=&#34;Merge Private Messages&#34;&#62;&#60;/FORM&#62;
&#60;br /&#62;
&#60;?php
echo &#39;&#60;/div&#62;&#60;/td&#62;&#60;/tr&#62;&#39;;
}
else
{
// do nothing
}

// Merge Private Messages &#40;Step 4&#41;
if &#40;&#036;_POST&#91;&#39;step&#39;&#93; == &#39;mergepm&#39;&#41;
{
&#036;dstid = &#036;_POST&#91;&#39;destinationid&#39;&#93;;
&#036;srcid = &#036;_POST&#91;&#39;sourceid&#39;&#93;;
echo &#39;&#60;tr&#62;&#60;td&#62;&#60;div align=&#34;center&#34;&#62;Step 4&#58; Merging Private Messages&#60;br /&#62;&#39;;
// Add the SQL code here
db_query&#40;&#34;UPDATE {&#036;db_prefix}instant_messages SET ID_MEMBER_FROM=&#39;&#036;dstid&#39; WHERE ID_MEMBER_FROM=&#39;&#036;srcid&#39;&#34;, __FILE__, __LINE__&#41;;
db_query&#40;&#34;UPDATE {&#036;db_prefix}im_recipients SET ID_MEMBER=&#39;&#036;dstid&#39; WHERE ID_MEMBER=&#39;&#036;srcid&#39;&#34;, __FILE__, __LINE__&#41;;
?&#62;
&#60;FORM action=&#34;smf-merge-users.php&#34; method=&#34;post&#34;&#62;&#60;INPUT type=&#34;hidden&#34; name=&#34;sourceid&#34; SIZE=&#34;5&#34; MAXLENGTH=&#34;5&#34; value=&#34;&#60;? echo &#036;_POST&#91;&#39;sourceid&#39;&#93;; ?&#62;&#34;&#62;&#60;INPUT type=&#34;hidden&#34; name=&#34;destinationid&#34; SIZE=&#34;5&#34; MAXLENGTH=&#34;5&#34; value=&#34;&#60;? echo &#036;_POST&#91;&#39;destinationid&#39;&#93;; ?&#62;&#34;&#62;&#60;br /&#62;&#60;INPUT type=&#34;hidden&#34; name=&#34;step&#34; value=&#34;mergecallevents&#34;&#62;&#60;INPUT type=&#34;submit&#34; value=&#34;Click to merge callendar events&#34;&#62;&#60;/FORM&#62;
&#60;br /&#62;
&#60;?php
echo &#39;&#60;/div&#62;&#60;/td&#62;&#60;/tr&#62;&#39;;
}
else
{
// do nothing
}

// Merge Callendar Events &#40;Step 5&#41;
if &#40;&#036;_POST&#91;&#39;step&#39;&#93; == &#39;mergecallevents&#39;&#41;
{
&#036;dstid = &#036;_POST&#91;&#39;destinationid&#39;&#93;;
&#036;srcid = &#036;_POST&#91;&#39;sourceid&#39;&#93;;
echo &#39;&#60;tr&#62;&#60;td&#62;&#60;div align=&#34;center&#34;&#62;Step 3&#58; Merging callendar events&#60;br /&#62;&#39;;
// Add the SQL code here
db_query&#40;&#34;UPDATE {&#036;db_prefix}calendar SET ID_MEMBER=&#39;&#036;dstid&#39; WHERE ID_MEMBER=&#39;&#036;srcid&#39;&#34;, __FILE__, __LINE__&#41;;
?&#62;
&#60;FORM action=&#34;smf-merge-users.php&#34; method=&#34;post&#34;&#62;&#60;INPUT type=&#34;hidden&#34; name=&#34;sourceid&#34; SIZE=&#34;5&#34; MAXLENGTH=&#34;5&#34; value=&#34;&#60;? echo &#036;_POST&#91;&#39;sourceid&#39;&#93;; ?&#62;&#34;&#62;&#60;INPUT type=&#34;hidden&#34; name=&#34;destinationid&#34; SIZE=&#34;5&#34; MAXLENGTH=&#34;5&#34; value=&#34;&#60;? echo &#036;_POST&#91;&#39;destinationid&#39;&#93;; ?&#62;&#34;&#62;&#60;br /&#62;&#60;INPUT type=&#34;hidden&#34; name=&#34;step&#34; value=&#34;deluser&#34;&#62;&#60;INPUT type=&#34;submit&#34; value=&#34;Click to delete user&#34;&#62;&#60;/FORM&#62;
&#60;br /&#62;
&#60;?php
echo &#39;&#60;/div&#62;&#60;/td&#62;&#60;/tr&#62;&#39;;
}
else
{
// do nothing
}

// Delete user and remaining data &#40;Step 6&#41;
if &#40;&#036;_POST&#91;&#39;step&#39;&#93; == &#39;deluser&#39;&#41;
{
echo &#39;&#60;tr&#62;&#60;td&#62;&#60;div align=&#34;center&#34;&#62;Step 6&#58; Deleting User and remaining data&#60;br /&#62;&#39;;
&#036;users = &#036;_POST&#91;&#39;sourceid&#39;&#93;;
// Kill the source user
deleteMembers&#40;&#036;users&#41;
?&#62;
&#60;FORM action=&#34;smf-merge-users.php&#34; method=&#34;post&#34;&#62;
&#60;INPUT type=&#34;hidden&#34; name=&#34;sourceid&#34; SIZE=&#34;5&#34; MAXLENGTH=&#34;5&#34; value=&#34;&#60;? echo &#036;_POST&#91;&#39;sourceid&#39;&#93;; ?&#62;&#34;&#62;
&#60;INPUT type=&#34;hidden&#34; name=&#34;destinationid&#34; SIZE=&#34;5&#34; MAXLENGTH=&#34;5&#34; value=&#34;&#60;? echo &#036;_POST&#91;&#39;destinationid&#39;&#93;; ?&#62;&#34;&#62;
&#60;br /&#62;
&#60;INPUT type=&#34;hidden&#34; name=&#34;step&#34; value=&#34;showfinal&#34;&#62;&#60;INPUT type=&#34;submit&#34; value=&#34;Continue&#34;&#62;&#60;/FORM&#62;
&#60;/div&#62;&#60;br /&#62;&#60;/td&#62;&#60;/tr&#62;
&#60;?
}
else
{
// do nothing
}

// Show Final Message &#40;Step 7&#41;
if &#40;&#036;_POST&#91;&#39;step&#39;&#93; == &#39;showfinal&#39;&#41;
{
echo &#39;&#60;tr&#62;&#60;td&#62;&#60;br /&#62;&#60;div align=&#34;center&#34;&#62;The source user has been deleted&#33;&#60;br /&#62;Please check your forum to ensure that the user merging was a success.&#60;br /&#62;&#60;br /&#62;&#60;a href=&#34;smf-merge-users.php&#34; target=&#34;_self&#34;&#62;Back To Start&#60;/a&#62;&#60;br /&#62;&#60;br /&#62;&#60;/div&#62;&#60;/td&#62;&#60;/tr&#62;&#39;;
}
else
{
// do nothing
}
?&#62;
&#60;/table&#62;
&#60;/body&#62;
&#60;/html&#62;

Code Updated

Currently merges:

User topics
User posts
User callendar events
User Attachments
Private Messages

Everything else shall be removed once the "source user" has been deleted.

Any comments are welcome.

**Jale** · December 13th, 2004, 01:14

How do I put that on my phpbbplanet forum? Can I use a FTP client to do that? (if it's possible)

**Lefteris_D** · December 13th, 2004, 10:59

Sorry, you need to have SMF installed and FTP access.

It does not work on phpBB.

Thread: SMF user merging script

Thread Tools

Search Thread

Thread Information

Users Browsing this Thread

Posting Permissions