Subversion Repositories general

Compare Revisions

Ignore whitespace Rev 1394 → Rev 1395

/asterisk-stats/trunk/telbook_update.php
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-') {