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";
