}
}
$result = mysql_query("select * from pending_del where owner_id = '{$user_id}' order by str_to_date(date,'%Y-%m-%d') desc");
if (mysql_num_rows($result) == 0) {
print '<center><div class="message" style="width: 250px;">' . $trash_empty[$lang] . '</div></center>';
} else {
print '<center>';
print '<table id="maincontent" class="ff" align="center" border="0" cellspacing="0">';
print '<tr class="header"><td style="padding-right: 15px;">' . $my_links_chat[$lang] . '</td><td style="padding-right: 15px;">' . $logger_from_day[$lang] . '</td><td>' . $del_time[$lang] . '</td></tr>';
print '<tr class="spacer"><td colspan="5"></td></tr>';
print '<tbody id="searchfield">';
while ($entry = mysql_fetch_array($result)) {
$talker = get_user_name($entry["peer_name_id"], $xmpp_host);
$server_name = get_server_name($entry["peer_server_id"], $xmpp_host);
$tslice = $entry["date"];
$nickname = query_nick_name($bazaj, $token, $talker, $server_name);
print '<tr><td style="padding-left: 10px; padding-right: 10px;"><b>' . htmlspecialchars($nickname) . '</b> (<i>' . htmlspecialchars($talker) . '@' . htmlspecialchars($server_name) . '</i>)</td><td style="text-align: center;">' . $tslice . '</td>';
print '<td style="padding-left: 5px; padding-right: 5px; font-size: x-small;">' . $entry[timeframe] . '</td>';
$reconstruct_link = encode_url("{$tslice}@{$entry['peer_name_id']}@{$entry['peer_server_id']}@", $token, $url_key);
// try to reconstruct oryginal link
$undelete_link = "{$tslice}@{$entry['peer_name_id']}@{$entry['peer_server_id']}@@@{$reconstruct_link}@undelete@";
$undelete_link = encode_url($undelete_link, $token, $url_key);
$delete_link = "{$tslice}@{$entry['peer_name_id']}@{$entry['peer_server_id']}@@@{$reconstruct_link}@delete@";
$delete_link = encode_url($delete_link, $token, $url_key);
print '<td style="padding-left: 10px;"><a href="trash.php?a=' . $undelete_link . '">' . $trash_undel[$lang] . '</a></td>';
print '<td style="padding-left: 10px;"><a href="trash.php?a=' . $delete_link . '" onClick="if (!confirm(\'' . $del_conf[$lang] . '\')) return false;">' . $trash_del[$lang] . '</a></td>';
print '</tr>';
}
print '</tbody>';
print '<tr class="spacer"><td colspan="5"></td></tr>';
print '<tr class="foot"><td colspan="5" height="15"></td></tr>';
} else {
$html->set_body('
<center>
<table id="maincontent" class="ff" align="center" border="0" cellspacing="0">
<tr class="header"><td style="padding-right: 15px;">' . $my_links_chat[$lang] . '</td><td style="padding-right: 15px;">' . $logger_from_day[$lang] . '</td><td>' . $del_time[$lang] . '</td></tr>
<tr class="spacer"><td colspan="5"></td></tr><tbody id="searchfield">
');
$db->get_trashed_items();
$result = $db->result;
foreach ($result as $entry) {
$db->get_user_name($entry[peer_name_id]);
$talker = $db->result->username;
$db->get_server_name($entry[peer_server_id]);
$server_name = $db->result->server_name;
$tslice = $entry["date"];
$nickname = query_nick_name($ejabberd_roster, $talker, $server_name);
if (!$nickname) {
$nickname = $not_in_r[$lang];
unset($malpa);
} else {
$malpa = "@";
}
$reconstruct_link = $enc->crypt_url("tslice={$tslice}&peer_name_id={$entry['peer_name_id']}&peer_server_id={$entry['peer_server_id']}");
$undelete_link = $enc->crypt_url("tslice={$tslice}&peer_name_id={$entry['peer_name_id']}&peer_server_id={$entry['peer_server_id']}&lnk={$reconstruct_link}&action=undelete");
$delete_link = $enc->crypt_url("tslice={$tslice}&peer_name_id={$entry['peer_name_id']}&peer_server_id={$entry['peer_server_id']}&lnk={$reconstruct_link}&action=delete");
$idx = $enc->crypt_url("single=" . $entry[idx] . "");
$html->set_body('
<tr><td style="padding-left: 10px; padding-right: 10px;"><b>' . $nickname . '</b> (<i>' . htmlspecialchars($talker) . $malpa . htmlspecialchars($server_name) . '</i>)</td>
<td style="text-align: center;">' . $tslice . '</td>
<td style="padding-left: 5px; padding-right: 5px; font-size: x-small;">' . $entry[timeframe] . '</td>
<td style="padding-left: 10px;"><a href="trash.php?a=' . $undelete_link . '&idx=' . $idx . '">' . $trash_undel[$lang] . '</a></td>
print '<center>' . "\n";
print '<span id="fav_result"></span>' . "\n";
print '<form style="margin-bottom: 0;" id="fav_form" action="req_process.php" method="post">' . "\n";
print '<input type="hidden" name="req" value="2">' . "\n";
print '<table id="maincontent" bgcolor="#e8eef7" class="ff" cellspacing="0" cellpadding="3">' . "\n";
print '<tr class="header"><td>' . $fav_contact[$lang] . '</td><td>' . $fav_when[$lang] . '</td>';
// print '<td>'.$fav_comment[$lang].'</td>'."\n"; // comments disabled for now
print '<td><input class="submit" type="Submit" value="' . $fav_remove[$lang] . '"></td></tr>' . "\n";
print '<tr class="spacer" height="1px"><td colspan="3"></td></tr>' . "\n";
print '<tbody id="searchfield">' . "\n";
$i = 0;
while ($row = mysql_fetch_array($result)) {
$i++;
$username = get_user_name($row[peer_name_id], $xmpp_host);
$server = get_server_name($row[peer_server_id], $xmpp_host);
$nickname = htmlspecialchars(query_nick_name($bazaj, $token, pg_escape_string($username), pg_escape_string($server)));
$to_base = "{$row['tslice']}@{$row['peer_name_id']}@{$row['peer_server_id']}@";
$to_base = encode_url($to_base, $token, $url_key);
print '<tr id="' . $i . '"><td class="rowspace"> <a href="' . $view_type . '?a=' . $to_base . '&loc=3"><u><b>' . $nickname . '</b> (<i>' . htmlspecialchars($username) . '@' . htmlspecialchars($server) . '</i>)</u></a></td>';
print '<td class="rowspace">' . $row[tslice] . '</td>';
// comments disabled for now
/*
if ($row[comment]==NULL) {
print '<td class="rowspace">'.$fav_add_comment[$lang].'</td>';
}
else {
print '<td class="rowspace">'.$row[comment].'</td>';
}
*/
print '<td style="text-align: center;">';
print '<input name="' . $i . '" type="checkbox" value="' . $to_base . '" onclick="toggle(this,\'' . $i . '\')" />';
// get the name of user that we was talking to
$db->get_user_name($dat[peer_name_id]);
$talk = $db->result->username;
// get it's server name
$db->get_server_name($dat[peer_server_id]);
$sname = $db->result->server_name;
// cleanup jid
$jid = htmlspecialchars($talk);
// color every second line...
if ($col == "e0e9f7") {
$col = "e8eef7";
} else {
$col = "e0e9f7";
}
// get username from user roster:
$talk = query_nick_name($ejabberd_roster, $talk, $sname);
// if user is not in list, advise about that
if ($talk === "") {
$talk = $not_in_r[$lang];
}
// now we want to know who was talking to who...
if ($dat["direction"] == "to") {
$fr = $to_u[$lang];
} else {
$fr = $from_u[$lang];
}
// ... and what was talking, and format that ...
$body_talk = wordwrap(str_replace("\n", "<br>", htmlspecialchars(base64_decode($dat["body"]))), 107, "<br>", true);
// advise user if chat is deleted. Extension=1 stands for "Chat temporary deleted" or "Chat awaiting deletion"
if ($dat[ext] == 1) {
$html->set_body('<tr bgcolor="b5b5b5"><td colspan="4" style="text-align: center; font-weight: bold;">' . $marked_as_d[$lang] . '</td></tr>');
$html->status_message($my_links_no_links[$lang]);
} else {
$html->set_body('
<center><table id="maincontent" class="ff" cellspacing="0">
<tr class="header"><td>' . $my_links_link[$lang] . '</td><td>' . $my_links_chat[$lang] . '</td><td>' . $my_links_desc[$lang] . '</td></tr>
<tr class="spacer" height="1px"><td colspan="4"></td></tr>
<tbody id="searchfield">
');
$db->get_mylink();
$result = $db->result;
foreach ($result as $entry) {
$db->get_user_name($entry[peer_name_id]);
$peer_name = $db->result->username;
$db->get_server_name($entry[peer_server_id]);
$peer_server = $db->result->server_name;
$nickname = query_nick_name($ejabberd_roster, $peer_name, $peer_server);
$desc = htmlspecialchars($entry[description]);
$jid = $peer_name . '@' . $peer_server;
if (!$nickname) {
$nickname = $not_in_r[$lang];
$jid = $peer_server;
}
$html->set_body('
<tr style="cursor: pointer;" bgcolor="#e8eef7" onMouseOver="this.bgColor=\'c3d9ff\';" onMouseOut="this.bgColor=\'#e8eef7\';">
<td onclick="window.location=\'' . $view_type . '?loc=4&a=' . $entry['link'] . '\';" style="padding-left: 10px; padding-right: 10px">' . verbose_date($entry['datat'], $months_names) . '</td>
<td onclick="window.location=\'' . $view_type . '?loc=4&a=' . $entry['link'] . '\';"> <b>' . cut_nick(htmlspecialchars($nickname)) . '</b> (' . htmlspecialchars($jid) . ') </td>
<td onclick="window.location=\'' . $view_type . '?loc=4&a=' . $entry['link'] . '\';"> ' . $desc . '</td>
<td><a href="my_links.php?del=t&link_id=' . $entry[id_link] . '" onClick="if (!confirm(\'' . $del_conf_my_link[$lang] . '\')) return false;" > ' . $del_my_link[$lang] . ' </a></td>
</tr>
');
}
// personal stats
print '<br><small><b>' . $stats_personal_d[$lang] . '</b></small>';
$total_messages = number_format($total_messages = do_sel_quick("select sum(count) from `logdb_stats_{$xmpp_host}` where owner_id='{$user_id}'"));
if ($total_messages == "f") {
$total_messages = "0";
}
print '<p style="font-size: x-small;">' . $stats_personal[$lang] . '<b> ' . $total_messages . '</b></p>';
$top_ten_personal = do_sel("select peer_name_id,peer_server_id,at,count from `logdb_stats_{$xmpp_host}` where owner_id='{$user_id}' and peer_name_id!='{$ignore_id}' and ext is NULL order by count desc limit 10");
print '<small><b>' . $stats_personal_top[$lang] . '</b></small><br><br>';
if (mysql_num_rows($top_ten_personal) != 0) {
print '<table bgcolor="#ffffff" class="ff" cellspacing="0" cellpadding="3"><tr style="background-image: url(img/bar_new.png); background-repeat:repeat-x; color: #fff; font-weight: bold;"><td>' . $stats_personal_count[$lang] . '</td><td style="text-align: center;">' . $stats_peer[$lang] . '</td><td>' . $stats_when[$lang] . '</td></tr>';
while ($result = mysql_fetch_array($top_ten_personal)) {
print '<tr><td style="text-align: center; font-weight: bold;">';
print $result[count];
print '</td><td>';
$nickname = htmlspecialchars(query_nick_name($bazaj, $token, pg_escape_string(get_user_name($result[peer_name_id], $xmpp_host)), pg_escape_string(get_server_name($result[peer_server_id], $xmpp_host))));
print '<b>' . $nickname . '</b>';
print ' <small>(' . htmlspecialchars(get_user_name($result[peer_name_id], $xmpp_host)) . '@' . htmlspecialchars(get_server_name($result[peer_server_id], $xmpp_host)) . ')</small>';
print '</td><td>';
$to_base = "{$result['at']}@{$result['peer_name_id']}@{$result['peer_server_id']}@";
$to_base = encode_url($to_base, $token, $url_key);
print '<a id="pretty" title="' . $stats_see[$lang] . '" href="' . $view_type . '?a=' . $to_base . '"><u>' . $result[at] . '</u></a>';
print '</td></tr>';
}
print '<tr height="15" style="background-image: url(img/bar_new.png); background-repeat:repeat-x; color: #fff;"><td colspan="3"></td></tr>';
print '</table>';
} else {
print '<div class="message">' . $no_archives[$lang] . '</div>';
}
print '</center>' . "\n";
print '<br /><br /><br />';
$query = "select * from jorge_mylinks where owner_id='{$user_id}' and ext is NULL order by str_to_date(datat,'%Y-%m-%d') desc";
$result = mysql_query($query);
// head
print '<h2>' . $my_links_desc_m[$lang] . '</h2>';
print '<small>' . $my_links_desc_e[$lang] . '</small>';
if (mysql_num_rows($result) == "0") {
print '<center><div class="message" style="width: 250px;">' . $my_links_no_links[$lang] . '</div></center>';
} else {
print '<center>' . "\n";
print '<table id="maincontent" class="ff" cellspacing="0">' . "\n";
print '<tr class="header"><td>' . $my_links_link[$lang] . '</td><td>' . $my_links_chat[$lang] . '</td><td>' . $my_links_desc[$lang] . '</td></tr>' . "\n";
print '<tr class="spacer" height="1px"><td colspan="4"></td></tr>';
print '<tbody id="searchfield">';
while ($entry = mysql_fetch_array($result)) {
print '<tr style="cursor: pointer;" bgcolor="#e8eef7" onMouseOver="this.bgColor=\'c3d9ff\';" onMouseOut="this.bgColor=\'#e8eef7\';">' . "\n";
print '<td onclick="window.location=\'' . $view_type . '?a=' . $entry['link'] . '\';" style="padding-left: 10px; padding-right: 10px">' . pl_znaczki(verbose_date($entry['datat'], $lang)) . '</td>' . "\n";
$nickname = query_nick_name($bazaj, $token, get_user_name($entry[peer_name_id], $xmpp_host), get_server_name($entry[peer_server_id], $xmpp_host));
$jid = get_user_name($entry[peer_name_id], $xmpp_host) . '@' . get_server_name($entry[peer_server_id], $xmpp_host);
print '<td onclick="window.location=\'' . $view_type . '?a=' . $entry['link'] . '\';"> <b>' . cut_nick(htmlspecialchars($nickname)) . '</b> (' . htmlspecialchars($jid) . ') </td>' . "\n";
$opis = htmlspecialchars($entry[description]);
print '<td onclick="window.location=\'' . $view_type . '?a=' . $entry['link'] . '\';"> ' . $opis . '</td>' . "\n";
print '<td><a href="my_links.php?del=t&link_id=' . $entry[id_link] . '" onClick="if (!confirm(\'' . $del_conf_my_link[$lang] . '\')) return false;" > ' . $del_my_link[$lang] . ' </a></td>' . "\n";
print '</tr>' . "\n";
}
print '</tbody>';
print '<tr class="spacer"><td colspan="4"></td></tr>';
print '<tr class="foot"><td colspan="4" height="15"></td></tr>';
print '</table>' . "\n";
print '</center>' . "\n";
}
include "footer.php";
$to_base = "{$dat['time_slice']}@{$dat['peer_name_id']}@{$dat['peer_server_id']}@";
$to_base = encode_url($to_base, $user_id, $url_key);
// get the name of user that we was talking to
$talk = get_user_name($dat["peer_name_id"], $xmpp_host);
// get it's server name
$sname = get_server_name($dat["peer_server_id"], $xmpp_host);
// cleanup jid
$jid = htmlspecialchars($talk);
// color every second line...
if ($col == "e0e9f7") {
$col = "e8eef7";
} else {
$col = "e0e9f7";
}
// get username from user roster:
$talk = htmlspecialchars(query_nick_name($bazaj, $token, $talk, $sname));
// remove if there are performance issues
// if user is not in list, advise about that
if ($talk == "f") {
$talk = $not_in_r[$lang];
}
// now we want to know who was talking to who...
if ($dat["direction"] == "to") {
$fr = $to_u[$lang];
} else {
$fr = $from_u[$lang];
}
// ... and what was talking, and format that ...
$body_talk = wordwrap(str_replace("\n", "<br>", htmlspecialchars(base64_decode($dat["body"]))), 107, "<br>", true);
// advise user if chat is deleted. Extension=1 stands for "Chat temporary deleted" or "Chat awaiting deletion"
if ($dat[ext] == 1) {
