function emailprop($emailid)
{
global $First_Name, $Last_Name, $Organization, $Address, $Address2, $City, $State, $PostalCode, $Country, $WebPage, $Phone, $Fax;
if ($FirstName) {
emailat(1, $FirstName, $emailid);
}
if ($LastName) {
emailat(12, $LastName, $emailid);
}
if ($Organization) {
emailat(19, $Organization, $emailid);
}
if ($Address) {
emailat(13, $Address, $emailid);
}
if ($Address2) {
emailat(26, $Address2, $emailid);
}
if ($City) {
emailat(14, $City, $emailid);
}
if ($PostalCode) {
emailat(20, $PostalCode, $emailid);
}
if ($Country) {
emailat(2, $Country, $emailid);
}
if ($Phone) {
emailat(25, $Phone, $emailid);
}
if ($Fax) {
emailat(24, $Fax, $emailid);
}
if ($WebPage) {
emailat(27, $WebPage, $emailid);
}
if ($State) {
$State = getstate($State);
emailat(22, $State, $emailid);
}
}
function moveemail()
{
global $dbcon;
$empty = $dbcon->Execute("delete from phplist_user_user") or die($dbcon->ErrorMsg());
$empty = $dbcon->Execute("delete from phplist_user_user_attribute") or die($dbcon->ErrorMsg());
$sql = "select * from email ";
$allemails = $dbcon->Execute("{$sql}") or die($dbcon->ErrorMsg());
while (!$allemails->EOF) {
$recid = $allemails->Fields("id");
$email = $allemails->Fields("email");
//move attributes
if ($allemails->Fields("firstname")) {
emailat(1, $allemails->Fields("firstname"), $recid);
}
if ($allemails->Fields("lastname")) {
emailat(12, $allemails->Fields("lastname"), $recid);
}
if ($allemails->Fields("organization")) {
emailat(19, $allemails->Fields("organization"), $recid);
}
if ($allemails->Fields("address1")) {
emailat(13, $allemails->Fields("address1"), $recid);
}
if ($allemails->Fields("address2")) {
emailat(26, $allemails->Fields("address2"), $recid);
}
if ($allemails->Fields("city")) {
emailat(14, $allemails->Fields("city"), $recid);
}
if ($allemails->Fields("state")) {
emailat(22, $allemails->Fields("state"), $recid);
}
if ($allemails->Fields("zip")) {
emailat(20, $allemails->Fields("zip"), $recid);
}
if ($allemails->Fields("country")) {
emailat(2, $allemails->Fields("country"), $recid);
}
if ($allemails->Fields("phone")) {
emailat(25, $allemails->Fields("phone"), $recid);
}
if ($allemails->Fields("fax")) {
emailat(24, $allemails->Fields("fax"), $recid);
}
if ($allemails->Fields("url")) {
emailat(27, $allemails->Fields("url"), $recid);
}
$MM_insert = 1;
$randval = md5(uniqid(mt_rand()));
$MM_editTable = "phplist_user_user";
$MM_fieldsStr = "recid|value|email|value|confirmed|value|randval|value|htmlemail|value|entered|value";
$MM_columnsStr = "id|',none,''|email|',none,''|confirmed|none,1,1|uniqid|',none,''|htmlemail|none,1,1|entered|',none,now()";
require "../Connections/insetstuff.php";
require "../Connections/dataactions.php";
$allemails->MoveNext();
}
}
