BlueGreycalmElegant

Català-Valencià – Catalan中文 – Chinese (Simplified)中文 – Chinese (Traditional)Česky – CzechDansk – DanishNederlands – DutchEnglish – EnglishSuomi – FinnishFrançais – FrenchDeutsch – Germanעברית – Hebrewहिंदी – HindiMagyar – HungarianBahasa Indonesia – IndonesianItaliano – Italian日本語 – Japanese한국어 – KoreanМакедонски – Macedonianमराठी – MarathiNorsk – NorwegianPolski – PolishPortuguês – PortuguesePortuguês – Portuguese (Brazil)Русский – RussianSlovenčina – SlovakSlovenščina – SlovenianEspañol – SpanishSvenska – SwedishTürkçe – TurkishУкраїнська – UkrainianOëzbekcha – Uzbek

Compare Revisions

• This comparison shows the changes necessary to convert path

  → /asterisk-stats/trunk/telbook_update.php @ 1392

  → /asterisk-stats/trunk/telbook_update.php @ 1393

  ↔ Reverse comparison

• Compare Path:	Rev

  With Path:	Rev

Ignore whitespace Rev 1392 → Rev 1393

/asterisk-stats/trunk/telbook_update.php
6,6 → 6,8
if(array_key_exists('delete', $_POST)) {
$id = $_POST['id'];
$db->begin_transaction();
$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 where person_id=$1", array($id));
$db->commit_transaction();
13,7 → 15,7
header("Location: telbook_list.php");
$g_display->add_text('Information deleted successfully');
}
else if(array_key_exists('update', $_POST)) {
elseif(array_key_exists('update', $_POST)) {
$id = $_POST['id'];
$person_name = $_POST['person_name'];
$person_comment = $_POST['person_comment'];
38,7 → 40,12
}
}
$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));
# save entries
$entries_id = array();
foreach($_POST as $key => $value) {
if(substr($key, 0, strlen('entry_title-')) == 'entry_title-') {
$entry_count = substr($key, strlen('entry_title-'));
52,10 → 59,35
. " (entry_value, entry_title, entry_person, entry_comment)"
. " values ($1, $2, $3, $4)",
array($entry_value, $entry_title, $id, $entry_comment));
$db->query("select currval('telbook_entries_entry_id_seq')");
if($line = $db->fetch_row_idx()) {
$entries_id[$entry_count] = $line[0];
}
}
}
}
# save entries export targets
foreach($_POST as $key => $value) {
if(substr($key, 0, strlen('entry_export-')) == 'entry_export-') {
$substr_len = strlen('entry_export-');
$pos = strpos($key, '-', $substr_len);
if($pos) {
$entry_count = substr($key, $substr_len, $pos - $substr_len);
$export_id = substr($key, $pos+1);
$entry_id = $entries_id[$entry_count];
if($export_id && $entry_id) {
$db->query_params("insert into telbook_entries_export"
. " (export_id, entry_id)"
. " values ($1, $2)",
array($export_id, $entry_id));
}
}
}
}
$db->commit_transaction();
header("Location: telbook_list.php");