$_userInfo['csvTime'] = time();
foreach ($_userInfo['csv'] as $row) {
if (!isset($row[1])) {
$row[1] = '';
}
if (!empty($row[0]) && is_valid_email($row[0])) {
$sql = "INSERT INTO " . DB_PREPEND . "phpwcms_address (";
$sql .= "address_email, address_name, address_key, address_subscription, address_verified, address_tstamp) VALUES (";
$sql .= "'" . aporeplace($row[0]) . "', ";
$sql .= "'" . aporeplace($row[1]) . "', ";
$sql .= "'" . aporeplace(shortHash($row[0] . time())) . "', ";
$sql .= "'" . ($_userInfo['subscribe_all'] ? '' : aporeplace(serialize($_userInfo['subscribe_select']))) . "', ";
$sql .= $_userInfo['subscribe_active'] . ", FROM_UNIXTIME(" . $_userInfo['csvTime'] . ") )";
$sql = _dbQuery($sql, 'INSERT');
if (empty($sql['INSERT_ID'])) {
$_userInfo['nonImported'][$c] = $row[0] . '; ' . $row[1] . ' (' . mysql_error() . ')';
}
} else {
$_userInfo['nonImported'][$c] = $row[0] . '; ' . $row[1];
}
$c++;
}
}
break;
default:
$_userInfo['csvError'] = 'False MIME TYPE. Be sure to upload CSV file only.';
@unlink($_FILES['cvsfile']['tmp_name']);
}
} elseif ($_FILES['cvsfile']['error']) {
$_userInfo['csvError'] = return_upload_errormsg($_FILES['cvsfile']['error']);
}
$guestbook['image']['hash'] = '';
$guestbook['image']['file'] = '';
unlink($_FILES['guestbook_image']['tmp_name']);
} else {
chmod($guestbook['image_dir'] . '/' . $guestbook['image']['file'], 0666);
}
} else {
$guestbook['error']['image']['writable'] = "Image directory is not writable. Send a notice to the webmaster of this site.";
}
}
} else {
$guestbook['error']['image']['format'] = "Proof image format: only JPG, GIF, PNG allowed.";
}
} else {
if ($_FILES['guestbook_image']['error']) {
$guestbook['error']['image']['system'] = return_upload_errormsg($_FILES['guestbook_image']['error']);
}
$guestbook['error']['image']['general'] = "Proof uploaded image file (only JPG, GIF, PNG allowed).";
}
} elseif (!empty($_POST['guestbook_hiddenfile'])) {
//same file was just uploaded
$guestbook['hidden'] = unserialize(base64_decode($_POST['guestbook_hiddenfile']));
$guestbook['image']['name'] = $guestbook['hidden']['name'];
$guestbook['image']['hash'] = $guestbook['hidden']['hash'];
$guestbook['image']['file'] = $guestbook['hidden']['file'];
if (!file_exists($guestbook['image_dir'] . '/' . $guestbook['image']['file'])) {
$guestbook['image']['name'] = '';
$guestbook['image']['hash'] = '';
$guestbook['image']['file'] = '';
}
}
