Combine two lists into one

[Pavel]

I wonder if there is a simple way to combine subs from 2 lists into 1 saving their unique IPs?

[DW]

Here you go!

1. Copy and paste the code below into a new file, ie. custom.php
2. Upload the file to your ListMail folder
3. Browse to it

Code: [Select]

<?php
// place this script in your ListMail folder and browse to it
include('./config.php');
include('./admin.php');

$move_from_list = '1';
$move_to_list = '2';

// cycle all users on "from" list
echo "moving users from list $move_from_list to list $move_to_list - please wait<br>";
flush();
$rows = mysql_query("select id,email from $utable where list = '$move_from_list';");
echo @mysql_num_rows($rows).' users to process<br>';
while(list($id,$em)=mysql_fetch_row($rows)){
 $row = mysql_query("select id from $utable where list = '$move_to_list' and email like '$em';");
 // if not on list move user
 if(@mysql_num_rows($row)==0) mysql_query("update $utable set list = '$move_to_list' where id = '$id';");
 else echo "duplicate email $em<br>";
}
echo "done!<br>";
?>

[BGSWebDesign]

Hi DW,

1. Copy and paste the code below into a new file, ie. custom.php

Thanks a million, this was long overdue and will help tremendously!!!  As we discussed before, this is one of those 'Extras' you could sell as part of a membership, or as an 'add-on', think about it...  we've talked about it many times - I want to see you making a good living from LMP  

What we really would need is a selector box, select list 1, select list 2, instead of manually updating the php file every time ...
also - another option is really needed to make this script fully functional:
Move To, or Copy To - preserving the old users in the original List so they are not removed from the other list, just copied to the new list...

What do you think, DW?

[DW]

When checkboxes, selections, and 'all list' or 'all result' operations come to the user database page this will all be very easy.

[Pavel]

Thanks a lot Dean, you are very helpful.

I think this feature has long been awaited, especially in the form of a button somewhere in the "User Database" window

Thanks.