}
print '</select>' . "\n";
print '</form>' . "\n";
// now generate claendar, the peer_name_id is hard-coded - this avoids of displaying chats with no-username
$query_days = "select distinct(substring(at,8,9)) as days from `logdb_stats_{$xmpp_host}` where owner_id = '{$user_id}' and at like '{$mo}%' and peer_name_id!='{$ignore_id}' order by str_to_date(at,'%Y-%m-%d') desc";
$result_for_days = mysql_query($query_days);
$i = 0;
// array of days
while ($row_d = mysql_fetch_array($result_for_days)) {
$i++;
$days[$i] = str_replace("-", "", $row_d[days]);
// hack for bad parsing
}
// display calendar
list($y, $m) = split("-", $mo);
echo pl_znaczki(calendar($user_id, $xmpp_host, $y, $m, $days, $token, $url_key, $months_name_eng, $left, $right, $selected, $lang, $view_type, 1, $null_a = 0, $null_b = 0, $cal_days));
unset($days);
// generate table name
$tslice_table = 'logdb_messages_' . $tslice . '_' . $xmpp_host;
// if we got day, lets display chats from that day...
if ($tslice) {
$result = db_q($user_id, $server, $tslice, $talker, $search_p, "2", $start, $xmpp_host);
mysql_query("create temporary table tslice_temp (\n\t\troster_name varchar(255),\n\t\tusername varchar(255),\n\t\tserver_name varchar(255),\n\t\ttodaytalk integer,\n\t\tserver integer,\n\t\tlcount integer\n\t\t)") or die;
while ($sort_me = mysql_fetch_array($result)) {
$roster_name = pg_escape_string(query_nick_name($bazaj, $token, pg_escape_string($sort_me[username]), pg_escape_string($sort_me[server_name])));
mysql_query("insert into tslice_temp (roster_name,username,server_name,todaytalk,server,lcount) values (\n\t\t\t'{$roster_name}',\n\t\t\t'{$sort_me['username']}',\n\t\t\t'{$sort_me['server_name']}',\n\t\t\t'{$sort_me['todaytalk']}',\n\t\t\t'{$sort_me['server']}',\n\t\t\t'{$sort_me['lcount']}'\n\t\t\t)") or die;
}
mysql_free_result($result);
if ($result == "f") {
header("Location: calendar_view.php");
}
$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";
$fav_desc[eng] = "List of chats marked as favorites";
$fav_add[pol] = pl_znaczki("Dodaj t± rozmowê do ulubionych");
$fav_add[eng] = "Add this chat to favorites";
$fav_success[pol] = pl_znaczki("Rozmowa zosta³a dodana do Twoich <i>Ulubionych</i> !");
$fav_success[eng] = "This chat had been succesfully added to your <i>Favorites</i> !";
$fav_discard[pol] = pl_znaczki("Ukryj t± informacje");
$fav_discard[eng] = "Discard this message";
$fav_exist[pol] = pl_znaczki("Ooops...Ta rozmowa juz znajduje siê w Twoich <i>Ulubionych</i>");
$fav_exist[eng] = "Ooops...This chat is already in your <i>Favorites</i>";
$fav_contact[pol] = pl_znaczki("Kontakt");
$faf_contact[eng] = "Contact";
$fav_when[pol] = pl_znaczki("Kiedy");
$fav_when[eng] = "When";
$fav_comment[pol] = pl_znaczki("Komentarz");
$fav_comment[eng] = "Comment";
$fav_add_comment[pol] = pl_znaczki("Dodaj komentarz");
$fav_add_comment[eng] = "Add comment";
$fav_remove[pol] = pl_znaczki("Usuñ zaznaczone");
$fav_remove[eng] = "Remove selected";
$fav_removed[pol] = pl_znaczki("Zaznaczone rozmowy zosta³y usuniête z <i>Ulubionych</i>");
$fav_removed[eng] = "Selected chats were removed from <i>Favorites</i>";
$fav_empty[pol] = pl_znaczki("Nie masz aktualnie zapisanych ¿adnych <i>Ulubionych</i> rozmów");
$fav_empty[eng] = "You dont have any <i>Favorites</i> chats saved";
$ajax_error[pol] = pl_znaczki("Oooups...There was a problem during processing your request");
$ajax_error[eng] = "Oooups...There was a problem during processing your request";
$reset_sort[pol] = pl_znaczki("resetuj sortowanie");
$reset_sort[eng] = "reset sorting";
$cont_chat[pol] = pl_znaczki("rozmowa kontynuowana jest nastêpnego dnia >>>");
$cont_chat[eng] = "chat continues on next day >>>";
$cont_chat_p[pol] = pl_znaczki("<<< rozmowa jest kontynuacj± z dnia poprzedniego");
$cont_chat_p[eng] = "<<< this chat is continuation from last day";
// folder - begin
print '<ul rel="' . $rel . '">' . "\n";
// folder content
$query = "select distinct(at) from `logdb_stats_{$xmpp_host}` where owner_id = '{$user_id}' and substring(at,1,7) = '{$entry['at_m']}' order by str_to_date(at,'%Y-%m-%d') desc";
$result2 = mysql_query($query);
while ($ent = mysql_fetch_array($result2)) {
$to_base = "{$ent['at']}@";
$to_base = encode_url($to_base, $token, $url_key);
if ($tslice == $ent["at"]) {
$bold_b = "<b>";
$bold_e = "</b>";
} else {
$bold_b = "";
$bold_e = "";
}
print '<li><a href="?a=' . $to_base . '">' . $bold_b . pl_znaczki(verbose_date($ent["at"], $lang, "m")) . $bold_e . '</a></li>' . "\n";
// days..
}
print '</ul>' . "\n";
// end folder content
print '</li>' . "\n";
// folder - end
}
// end - arch
?>
</ul>
<script type="text/javascript">
ddtreemenu.createTree("treemenu2", false, 1)
</script>
