if (isset($_POST['btn_loeschen']) && $_SESSION['allow_delete']) { //Eintrag löschen: $dataB->sql_connect($sql["host"], $sql["dbuser"], $sql["dbpasswd"], $sql["db"]); $sql = sprintf("UPDATE angerufene SET aktive='0' WHERE id=%s", $dataB->sql_checkn($_POST['id'])); $res = $dataB->sql_query($sql); $dataB->sql_close(); if ($_POST['datum'] != "") { $datum = "?datum=" . $_POST['datum']; } else { $datum = ""; } if ($res) { $template->assign_block_vars('del_entry_successfully', array('L_MSG_SUCCESS' => $textdata['del_OK_forward'], 'DATA_DATE' => $datum)); } } if (isset($_GET['id']) && $_SESSION['allow_delete']) { $dataB->sql_connect($sql["host"], $sql["dbuser"], $sql["dbpasswd"], $sql["db"]); $sql = sprintf("SELECT * FROM angerufene WHERE id=%s", $dataB->sql_checkn($_GET['id'])); $result = $dataB->sql_query($sql); $dataB->sql_close(); $daten = $dataB->sql_fetch_assoc($result); $datum1 = mysql_datum($daten['datum']); if (isset($_GET['datum'])) { $to_date = $_GET['datum']; } else { $to_date = ""; } $template->assign_block_vars('check_if_del', array('L_MSG_CHECK_TO_DEL' => $textdata['stat_del_1'] . $_GET['id'] . $textdata['stat_del_2'], 'L_ID' => $textdata['id'], 'L_DATE' => $textdata['stat_anrufer_datum'], 'L_TIME' => $textdata['stat_anrufer_uhrzeit'], 'L_NUMBER' => $textdata['stat_anrufer_rufnummer'], 'DATA_ID' => $daten['id'], 'DATA_DATE' => $datum1, 'DATA_TIME' => $daten['uhrzeit'], 'DATA_NUMBER' => $daten['rufnummer'], 'DATA_FROM_GET' => $to_date, 'L_DELETE' => $textdata['delet'])); } $template->pparse('overall_body'); include "./footer.inc.php";
include "footer.inc.php"; die; } if ($daten['addr_id'] == -1) { $number = $daten['number']; } else { $number = $daten['RUFNR']; } switch ($daten['callback_time']) { case 0: $callback_time = $textdata['callback_soon_as_posible']; break; case 1: $callback_time = $textdata['callback_morning']; break; case 2: $callback_time = $textdata['callback_midday']; break; case 3: $callback_time = $textdata['callback_evening']; break; } if ($daten['addr_id'] == -1) { $full_name = $daten['full_name']; } else { $full_name = "<a href=\"./addressbook.php?id={$daten['addr_id']}#find\">{$daten['name_first']} {$daten['name_last']}</a>"; } $template->assign_vars(array('L_SITE_TITLE' => $textdata['showaddress_deteilansicht'] . " " . $textdata['callback_detail_title'])); $template->assign_block_vars('tab1', array('L_DATE' => $textdata['stat_anrufer_datum'], 'L_CALLBACK_TIME' => $textdata['callback_time'], 'DATA_CALLBACK_TIME' => $callback_time, 'DATA_DATE' => mysql_datum($daten['en_date']), 'L_NAME' => $textdata['showstatnew_name'], 'DATA_NAME' => $full_name, 'L_TIME' => $textdata['stat_anrufer_uhrzeit'], 'DATA_TIME' => $daten['en_time'], 'L_NUMBER' => $textdata['stat_anrufer_rufnummer'], 'DATA_NUMBER' => $number, 'DATA_REASON' => $daten['message'], 'L_REASON' => $textdata['reason'])); $template->pparse('overall_body'); include "./footer.inc.php";
$anz_name = $daten['name']; $anz_rueckruf = "<a href=\"./callback.php?add=yes&addr=\">\n <img src=\"./images/1leftarrow.png\" style=\"border-width:0px;vertical-align:middle;\" alt=\"\"/></a>"; } else { $anz_name = "<a href=\"./addressbook.php?id={$daten['ADDR_ID']}#find\">{$daten['name_first']} {$daten['name_last']}</a>"; $anz_statistik = "<a href=\"./statistic_person.php?id={$daten['ADDR_ID']}\" title=\"{$textdata['showstatnew_zeige_anrufstat']} {$daten['name_first']} {$daten['name_last']}\"><img src=\"./images/data.png\" style=\"border-width:0px;vertical-align:middle;\" alt=\"\" /></a>"; $anz_rueckruf = "<a href=\"./callback.php?add=yes&addr={$daten['ADDR_ID']}\">\n <img src=\"./images/1leftarrow.png\" style=\"border-width:0px;vertical-align:middle;\" alt=\"\"/></a>"; } if ($daten['msn_name'] == NULL) { $anz_msn = $daten['msn']; } else { $anz_msn = $daten['msn_name']; } //MSNS überprüfen: $show_entry_msns = msns_ueberpruefen($_SESSION['msn_listen'], $daten['msn']); //Datum umwandeln, und wegen Heute/Gestern funktion: $anz_datum = anzeige_datum(mysql_datum($daten['datum']), $textdata['today'], $textdata['yesterday']); //ermittle Dienstkennung: $anz_dienst = ermittle_typ_anruf($daten['dienst']); //TEMPLATE FUELLEN ANFANG: if ($show_entry_msns) { if ($i % 2 == 0) { $color = $row_color_1; } else { $color = $row_color_2; } if ($daten['rufnummer'] == "unknown") { $daten['rufnummer'] = $textdata['unknown']; } $template->assign_block_vars('tab1', array('DATA_ROW_COLOR' => $color, 'DATA_SHOW_SINGEL_STAT' => $anz_statistik, 'DATA_SHOW_DATE' => $anz_datum, 'DATA_SHOW_CLOCK' => $daten['uhrzeit'], 'DATA_SHOW_NUMBER' => $anz_rufnr, 'DATA_SHOW_CALLERS_NAME' => $anz_name, 'DATA_TO_ADDR' => $anz_insaddr)); if ($_SESSION['show_sfcallnr'] && !empty($sfcallnr)) { $template->assign_block_vars('tab1.show_sfcallnr', array('DATA_NUMBERTOSF' => $sfcallnr));
if ($result_loeschen) { $template->assign_block_vars('delete_ok', array('L_MSG_DELTE_OK' => 'Löschen erflogreich....')); } else { $template->assign_block_vars('delete_failed', array('L_MSG_DELETE_FAILED' => 'Löschen fehlgeschlagen...')); } } } $dataB->sql_close(); } //if isset absenden $template->assign_block_vars('tab2', array('L_DATE' => $textdata['stat_anrufer_datum'], 'L_TIME' => $textdata['stat_anrufer_uhrzeit'], 'L_NUMBER' => $textdata['stat_anrufer_rufnummer'], 'L_MSN' => $textdata['stat_anrufer_MSN'], 'L_NAME' => $textdata['showstatnew_name'])); $i = 0; $dataB->sql_connect($sql["host"], $sql["dbuser"], $sql["dbpasswd"], $sql["db"]); $result_angerufene = $dataB->sql_query("SELECT id,rufnummer,msn,name,datum,uhrzeit FROM angerufene WHERE rufnummer='unknown' ORDER BY 'id' DESC"); if ($result_angerufene) { while ($daten = $dataB->sql_fetch_assoc($result_angerufene)) { if ($i % 2 == 0) { $color = $row_color_1; } else { $color = $row_color_2; } $template->assign_block_vars('tab3', array('DATA_COLOR' => $color, 'DATA_ID' => $daten['id'], 'DATA_DATE' => mysql_datum($daten['datum']), 'DATA_TIME' => $daten['uhrzeit'], 'DATA_NUMBER' => $daten['rufnummer'], 'DATA_MSN' => msnzuname($daten['msn']), 'DATA_NAME' => $daten['name'])); $i++; } } else { $template->assign_block_vars('no_calls_found', array('L_MSG_CALLS_NOT_FOUND' => 'Keine Anrufe mit Nummer/Name unbekannt gefunden.')); } $dataB->sql_close(); $template->assign_vars(array('L_MSG_DELETE_UNKOWN' => 'Lösche alle unbekannten Einträge', 'L_MSG_DELETE_ONLY_NO_NAME' => 'Lösche nur Einträge mit Nummer unbekannt, wo kein Name vergeben wurde.', 'L_DELETE' => 'Löschen')); $template->pparse('overall_body'); include "./footer.inc.php";
case 1: $callback_time = $textdata['callback_morning']; break; case 2: $callback_time = $textdata['callback_midday']; break; case 3: $callback_time = $textdata[callback_evening]; break; } if ($daten['addr_id'] == -1) { $full_name = $daten['full_name']; } else { $full_name = '<a href="addressbook.php?id=' . $daten['addr_id'] . '">' . $daten['name_first'] . ' ' . $daten['name_last'] . '</a>'; } $template->assign_block_vars('tab2', array('DATA_COLOR' => $color, 'DATA_NAME' => $full_name, 'DATA_ID' => $daten['id'], 'DATA_NUMBER' => $number, 'L_SHOW_REASON' => $textdata['show_reason'], 'DATA_TIME' => $daten['en_time'], 'DATA_DATE' => mysql_datum($daten['en_date']), 'DATA_CALL_BACK_TIME' => $callback_time, 'L_DELETE' => $textdata['delet'])); } $dataB->sql_close(); if (isset($_GET['add']) && $_GET['add'] == "yes") { $dataB->sql_connect($sql["host"], $sql["dbuser"], $sql["dbpasswd"], $sql["db"]); $result_users = $dataB->sql_query("SELECT id,username,name_first,name_last FROM users"); if (!empty($_GET['addr'])) { //user kommt von showstatnew.php und hat id vom addr $query = sprintf("SELECT t1.id,t1.name_first,t1.name_last,t2.number FROM addressbook AS t1 LEFT JOIN phonenumbers AS t2 ON t2.addr_id=t1.id WHERE t1.id=%s LIMIT 1", $dataB->sql_checkn($_GET['addr'])); $result_addr = $dataB->sql_query($query); $daten_addr = $dataB->sql_fetch_assoc($result_addr); $template->assign_block_vars('insert_with_addr', array('L_TITLE_NEW' => $textdata['new_entry'], 'L_NAME' => $textdata['showstatnew_name'], 'L_DATA_NAME' => $daten_addr['name_first'] . " " . $daten_addr['name_last'], 'L_DATA_NUMBER' => $number, 'L_DATA_ID' => $daten_addr['id'], 'L_SAVE_DATA' => $textdata['save'], 'L_NUMBER' => $textdata['stat_anrufer_rufnummer'], 'L_CALL_BACK_TIME' => $textdata['callback_time'], 'L_MORING' => $textdata['callback_morning'], 'L_SOON_AS_POSSIBLE' => $textdata['callback_soon_as_posible'], 'L_EVENING' => $textdata['callback_evening'], 'L_MIDDAY' => $textdata['callback_midday'], 'L_USERNAME' => $textdata['capi2name_user'], 'L_MESSAGE' => $textdata['reason'])); while ($daten_users = $dataB->sql_fetch_assoc($result_users)) { if (empty($daten_users['name_first']) && empty($daten_users['name_last'])) { $full_name = $daten_users['username']; } else {
$daten['number'] = split_cellphone($daten['number']); $template->assign_block_vars('show_cell_phone', array('L_CELL_PHONE' => $textdata['addadress_handy'], 'DATA_CELL_PHONE' => $daten['number'])); } $result = $dataB->sql_query("SELECT t1.number,t2.vorwahlnr FROM phonenumbers AS t1 LEFT JOIN vorwahl AS t2 ON t2.id=t1.areacode WHERE addr_id='{$id}' AND typ='3'"); while ($daten = $dataB->sql_fetch_assoc($result)) { $daten['number'] = split_number($daten['number'], $daten['vorwahlnr']); $template->assign_block_vars('show_fax', array('L_FAX' => $textdata['addadress_fax'], 'DATA_FAX' => $daten['number'])); } $dataB->sql_close(); $template->assign_block_vars('tab2', array('L_STAT_CALLERS_COUNTS' => $textdata['stat_anrufer_zahlen_fakten'], 'L_ALL_CALLS' => $textdata['stat_anrufer_gesamte_anrufe'], 'DATA_ALL_CALLS' => $ges_anzahl, 'L_STAT_TIME' => $textdata['stat_anrufer_geht_ueber'], 'DATA_WEEKS' => $wochen_genau, 'L_WEKKS' => 'Wochen', 'L_LAST_CALL' => $textdata['stat_anrufer_letzter_anruf'], 'DATA_LAST_DATE' => $datum_letzter, 'DATA_LAST_TIME' => $uhrzeit_letzer, 'L_FRIST_CALL' => $textdata['stat_anrufer_erster_anruf'], 'DATA_FIRST_DATE' => $datum_erster, 'DATA_FIRST_TIME' => $uhrzeit_erster, 'L_CALLS_AVERAGE' => $textdata['stat_anrufer_durchschnitt_anrufe'], 'DATA_CALLS_AVERAGE' => $anrufe_woche)); $template->assign_vars(array('DATA_ID_CALLERS' => $id)); $template->assign_block_vars('tab3', array('L_LSIT_ALL_CALLS' => $textdata['stat_anrufer_alle_anrufe_von'] . " " . $data_adressbuch['name_first'] . " " . $data_adressbuch['name_last'], 'L_DATE' => $textdata['stat_anrufer_datum'], 'L_TIME' => $textdata['stat_anrufer_uhrzeit'], 'L_CALL_NUMBER' => $textdata['stat_anrufer_rufnummer'], 'L_CALL_TO_MSN' => $textdata['stat_anrufer_MSN'])); $dataB->sql_connect($sql["host"], $sql["dbuser"], $sql["dbpasswd"], $sql["db"]); $sql_query = "SELECT datum,uhrzeit,msn,rufnummer FROM\n\tangerufene AS t1,\n\tphonenumbers AS t2 WHERE t1.rufnummer=t2.number \n\tAND t2.addr_id={$id} ORDER BY t1.id DESC"; $result = $dataB->sql_query($sql_query); $dataB->sql_close(); $i = 0; while ($data_angerufene = $dataB->sql_fetch_assoc($result)) { if ($i % 2 == 0) { $color = $row_color_1; } else { $color = $row_color_2; } $template->assign_block_vars('tab4', array('DATA_COLOR' => $color, 'DATA_DATE' => mysql_datum($data_angerufene['datum']), 'DATA_TIME' => $data_angerufene['uhrzeit'], 'DATA_NUMBER' => $data_angerufene['rufnummer'], 'DATA_CALL_TO_MSN' => $data_angerufene['msn'])); $i++; } } else { $template->assign_block_vars('no_call_from_user', array('L_MSG_NO_CALL' => $textdata['stat_anrufer_keine_anrufe_gefunden'] . " " . $data_adressbuch['name_first'] . " " . $data_adressbuch['name_last'] . " " . $textdata['stat_anrufer_keine_anrufe_gefunden_ende'])); } $template->pparse('overall_body'); include "./footer.inc.php";
if ($daten_callback[addr_id] == -1) { $number = $daten_callback[number]; } else { $number = $daten_callback[RUFNR]; } switch ($daten_callback[callback_time]) { case 0: $callback_time = $textdata[callback_soon_as_posible]; break; case 1: $callback_time = $textdata[callback_morning]; break; case 2: $callback_time = $textdata[callback_midday]; break; case 3: $callback_time = $textdata[callback_evening]; break; } if ($daten_callback[addr_id] == -1) { $full_name = $daten_callback[full_name]; } else { $full_name = "{$daten_callback['name_first']} {$daten_callback['name_last']}"; } $template->assign_block_vars('tab1', array('L_DATA_NAME' => $full_name, 'L_DATA_NUMBER' => $number, 'L_DATA_CREATED_ON' => $daten_callback[en_time] . " / " . mysql_datum($daten_callback[en_date]), 'L_DATA_CALLBACK_TIME' => $callback_time, 'L_DATA_MESSAGE' => $daten_callback[message])); } $dataB->sql_close(); } else { $template->assign_block_vars('not_found', array('L_MSG_NOT_FOUND' => $textdata[configpage_nicht_berechtigt])); } $template->pparse('overall_body');
if (isset($_GET['sortby']) && $_GET['sortby'] == "up") { $sortby = "ASC"; } else { $sortby = "DESC"; } $dataB->sql_connect($sql["host"], $sql["dbuser"], $sql["dbpasswd"], $sql["db"]); $sql_query = "SELECT COUNT(*) AS anzahl,\n\taddressbook.id,addressbook.name_last,\n\taddressbook.name_first, MAX(angerufene.datum) AS datum\n\tFROM angerufene LEFT \n\tJOIN phonenumbers ON angerufene.rufnummer=phonenumbers.number \n\tLEFT JOIN addressbook ON phonenumbers.addr_id=addressbook.id \n\tWHERE NOT(phonenumbers.typ='null')\n\tGROUP BY addressbook.id,addressbook.name_last,addressbook.name_first \n\tORDER by {$oderby} {$sortby}"; $result_data = $dataB->sql_query($sql_query); //mysql_num_rows $ges_anzahl = $dataB->sql_num_rows($result_data); if (!$ges_anzahl) { $template->assign_block_vars('no_entry_found', array('L_MSG_NOT_FOUND' => $textdata['stat_gesamt_keine_stat'])); $dataB->sql_close(); $template->pparse('overall_body'); include "./footer.inc.php"; exit; } $template->assign_block_vars('tab0', array('L_SORT_OPTION' => $textdata['stat_gesamt_sortierung'], 'L_ADDR_LAST_NAME' => $textdata['addadress_nachname'], 'L_ADDR_FIRST_NAME' => $textdata['addadress_vorname'], 'L_ALL_CALLS' => $textdata['stat_gesamt_anrufe'], 'L_LAST_CALL' => $textdata['stat_anrufer_letzter_anruf'])); $i = 1; while ($data = $dataB->sql_fetch_assoc($result_data)) { if ($i % 2 == 0) { $color = $row_color_1; } else { $color = $row_color_2; } $template->assign_block_vars('tab1', array('DATA_COLOR' => $color, 'DATA_INDEX' => $i, 'DATA_ID' => $data['id'], 'DATA_LAST_NAME' => $data['name_last'], 'DATA_FIRST_NAME' => $data['name_first'], 'DATA_COUNT' => $data['anzahl'], 'DATA_LAST_CALL' => mysql_datum($data['datum']), 'L_SEARCH_ENTRY' => $textdata['search_calls_from'] . $data['name_first'] . ' ' . $data['name_last'])); $i++; } $dataB->sql_close(); $template->pparse('overall_body'); include "./footer.inc.php";