9,6 → 9,7 |
$db->query_params("delete from telbook_entries_export where entry_id" |
. " in (select entry_id from telbook_entries where entry_person=$1)", array($id)); |
$db->query_params("delete from telbook_entries where entry_person=$1", array($id)); |
$db->query_params("delete from telbook_persons_export where person_id=$1", array($id)); |
$db->query_params("delete from telbook_persons where person_id=$1", array($id)); |
$db->commit_transaction(); |
|
43,8 → 44,23 |
$db->query_params("delete from telbook_entries_export where entry_id" |
. " = (select entry_id from telbook_entries where entry_person=$1)", array($id)); |
$db->query_params("delete from telbook_entries where entry_person=$1", array($id)); |
$db->query_params("delete from telbook_persons_export where person_id=$1", array($id)); |
|
# save entries |
foreach($_POST as $key => $value) { |
if(substr($key, 0, strlen('export_title-')) == 'export_title-') { |
$export_id = substr($key, strlen('export_title-')); |
|
if($value) { |
$db->query_params("insert into telbook_persons_export" |
. " (export_id, person_id, person_export_title)" |
. " values ($1, $2, $3)", |
array($export_id, $id, $value)); |
} |
} |
} |
|
# save entries |
$entries_id = array(); |
foreach($_POST as $key => $value) { |
if(substr($key, 0, strlen('entry_title-')) == 'entry_title-') { |