forked from science-ation/science-ation
47 lines
1.1 KiB
PHP
47 lines
1.1 KiB
PHP
|
<?php
|
||
|
|
|
||
|
|
require_once('email.inc.php');
|
||
|
|
|
||
|
|
function conv_emails($mysqli, $old_prefix)
|
||
|
|
{
|
||
|
|
print("Converting Emails...\n");
|
||
|
|
|
||
|
|
print(" - Delete existing emails from new database\n");
|
||
|
|
$mysqli->real_query("DELETE FROM emails WHERE Section != 'System'");
|
||
|
|
|
||
|
|
$c = 0;
|
||
|
|
$q = $mysqli->query("SELECT * FROM {$old_prefix}emails WHERE type='user'");
|
||
|
|
print(" - Importing Emails...\n");
|
||
|
|
while($e = $q->fetch_assoc()) {
|
||
|
|
|
||
|
|
|
||
|
|
$id = email_create($mysqli);
|
||
|
|
$new_e = email_load($mysqli, '', $id);
|
||
|
|
|
||
|
|
$new_e['name'] = $e['name'];
|
||
|
|
$new_e['section'] = 'Uncategorized';
|
||
|
|
$new_e['description'] = $e['description'];
|
||
|
|
|
||
|
|
if(preg_match("/([^<]*) *<([^>]*)>/", $e['from'], $matches)) {
|
||
|
|
$from_name = $matches[1];
|
||
|
|
$from_email = $matches[2];
|
||
|
|
} else {
|
||
|
|
$from_email = $e['from'];
|
||
|
|
$from_name = NULL;
|
||
|
|
}
|
||
|
|
$new_e['from_name'] = trim($from_name);
|
||
|
|
$new_e['from_email'] = trim($from_email);
|
||
|
|
$new_e['subject'] = $e['subject'];
|
||
|
|
$new_e['body'] = $e['body'];
|
||
|
|
$new_e['bodyhtml'] = $e['bodyhtml'];
|
||
|
|
|
||
|
|
email_save($mysqli, $new_e);
|
||
|
|
|
||
|
|
print(" - {$new_e['name']} From: {$new_e['from_name']} <{$new_e['from_email']}>\n");
|
||
|
|
$c++;
|
||
|
|
}
|
||
|
|
print(" - Converted $c emails\n");
|
||
|
|
}
|
||
|
|
|
||
|
|
?>
|