function lista($user) { global $dateformat; $user = protect($user); requirelogin(); $title = "Mensagens de {$user}"; include "libs/accounts.php"; // listar todas as mensagens de $user onde hidden = 'n' (para outro user ver) $output = menu($user) . url("message/send/{$user}", "[enviar mensagem]") . "<br>\n"; $usr = resolveuser($user); $qry = mysql_query("SELECT `from`,`content`,`data` FROM messages WHERE `to`='{$usr}' AND `hidden`='n' ORDER BY id DESC LIMIT 30"); if (mysql_numrows($qry) == 0) { $output .= 'Nenhuma mensagem!'; } else { while ($row = mysql_fetch_array($qry)) { $user = mysql_query("SELECT login,foto FROM accounts WHERE id='{$row['from']}'"); $user = mysql_fetch_array($user); $output .= '<p class="row">' . t("De") . ': ' . url("user/profile/{$user['login']}", $user['login']) . '<br/>'; $output .= '<blockquote> ' . bbcode($row['content']) . ' </blockquote> <hr size="1"><i>' . date($dateformat, $row['data']) . '</i> </p>'; } } section($output, $title); }
function notes($user) { global $url; $output = null; $id_user = resolveuser($user); $qry = mysql_query("SELECT content FROM notes WHERE account='{$id_user}'"); $output = menu($user); if (mysql_num_rows($qry) == 0) { $output .= 'Nenhuma notificação!'; } else { while ($row = mysql_fetch_array($qry)) { $output .= "\n" . '<p class="note"> ' . url("user/profile/{$user}", $user) . ' ' . $row['content'] . ' </p>'; } } section($output, "Notificações de {$user}"); }
function lista($user) { global $dateformat, $home; requirelogin(); include "libs/accounts.php"; $output = menu($user); $owner = resolveuser($user); $qry = mysql_query("SELECT * FROM blog WHERE `owner`='{$owner}' ORDER BY `id` DESC LIMIT 30"); if (mysql_num_rows($qry) == 0) { $output .= infobox($user . ' ' . t("ainda não postou em seu blog."), false); } else { while ($post = mysql_fetch_array($qry)) { $post_author = mysql_fetch_array(mysql_query("SELECT * FROM accounts WHERE `id`='{$post['owner']}'")); // begin post $output .= '<div class="row"> <h3><a name="post_' . $post['id'] . '">' . $post['title'] . '</a></h3> <p><i>' . date($dateformat, $post['date']) . '</i><br/> ' . bbcode($post['text']) . ' </p>'; // end post $commnt = mysql_query("SELECT * FROM blog_comments WHERE `post`='{$post['id']}' ORDER BY `id` DESC LIMIT 20"); if (mysql_num_rows($commnt) != 0) { while ($comment = mysql_fetch_array($commnt)) { $comment_author = mysql_fetch_array(mysql_query("SELECT * FROM accounts WHERE `id`='{$comment['owner']}'")); // begin comments $output .= "\n" . '<blockquote>' . url("user/profile/{$comment_author['login']}", $comment_author['login']) . ': ' . bbcode($comment['content']) . '</blockquote><br/>'; // end comments } } $output .= '<p> <form action="' . $home . 'blog/commentpost" method="post"> <input type="hidden" name="post" value="' . $post['id'] . '"> <input type="hidden" name="post_author" value="' . $post_author['login'] . '"> <textarea rows="3" cols="25" name="content"></textarea><br> <input type="submit" value="Comentar"> </form> </p> </div>'; } } section($output, t("Blog de") . ' ' . $user); }
function lista($user) { requirelogin(); include "libs/video.php"; include "libs/accounts.php"; $user = protect($user); $output = menu($user) . '<br>'; $id = resolveuser($user); $qry = mysql_query("SELECT * FROM videos WHERE id='{$id}'"); if (mysql_num_rows($qry) == 0) { $output .= infobox($user . ' ' . t("ainda não possui vídeos."), true); } else { while ($row = mysql_fetch_array($qry)) { $video = youtube($row['video']); $output .= '<div class="row"> <h3>' . protect($video['title']) . '</h3> <p><i>' . protect($video['desc']) . '</i><br/> ' . $video['code'] . '</p> </div><br>'; } } section($output, t("Vídeos de") . ' ' . $user); }
function lista($user) { global $home, $url; requirelogin(); $id = resolveuser($user); $qry = mysql_query("SELECT * FROM photo_album WHERE owner='{$id}'"); if (mysql_numrows($qry) != 0) { while ($row = mysql_fetch_array($qry)) { $output .= url("photos/viewalbum/{$row['id']}", $row['title']) . ' <br>'; } section($output, t('Álbuns de') . " {$user}"); } else { infobox($user . ' ' . t("ainda não possui álbuns de fotos.")); } }
function lista($user) { requirelogin(); $user = protect($user); $usr = resolveuser($user); $output = null; $qry = mysql_query("SELECT g.url AS u, g.title AS t FROM groups g LEFT JOIN groups_join j ON g.id=j.account WHERE g.id='{$_SESSION['id']}'"); if (mysql_numrows($qry) != 0) { while ($row = mysql_fetch_array($qry)) { $output .= "\n" . url("groups/view/{$row['u']}", $row['t']) . '<br>'; } } else { if ($_SESSION['id'] === $usr) { $output .= infobox(t("Você ainda não está em nenhum grupo.")); } else { $output .= infobox($user . ' ' . t("ainda não participa de nenhum grupo.")); } } section($output, t("Grupos")); }
function unsetadmin($member) { // tira alguem de admin $member = resolveuser($member); mysql_query("UPDATE accounts SET `admin`='n' WHERE `id`='{$member}'"); infobox(t("Esta pessoa não possui mais direitos administrativos.")); }