& Matías Parodi # # This program is free software: you can redistribute it and/or modify # it under the terms of the GNU Affero General Public License as # published by the Free Software Foundation, either version 3 of the # License, or (at your option) any later version. # # This program is distributed in the hope that it will be useful, # but WITHOUT ANY WARRANTY; without even the implied warranty of # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the # GNU Affero General Public License for more details. # # You should have received a copy of the GNU Affero General Public License # along with this program. If not, see . # ## if (!defined("SECURITY")) { exit; } if (SECTION == 'profile') { $sql = "SELECT * FROM `users` WHERE (`users`.`username` = '$username') LIMIT 1;"; $result = mysql_query($sql); $row = mysql_fetch_assoc($result); mysql_free_result($result); if (mysql_affected_rows() == 1) { $id_user = $row['id_user']; $username = $row['username']; $name = (!empty($row['name'])) ? $row['name'] : '-'; $location = (!empty($row['location'])) ? $row['location'] : '-'; $web = (!empty($row['web'])) ? $row['web'] : '-'; $bio = (!empty($row['bio'])) ? $row['bio'] : '-'; $karma = (!empty($row['karma'])) ? $row['karma'] : '-'; @ $register_date = date('d/m/Y', $row['register_date']); $avatar = 'images/avatar/' . $username . '/thumb_side.' . $row['avatar']; $avatar = (file_exists($avatar) === true) ? $avatar : 'images/avatar/default_side.png'; echo '

' . $username . '
'; if (($_SESSION['LOGIN'] === true) and ($username != $_SESSION['USERNAME'])) { $sql = "SELECT * FROM `followers` WHERE ((`followers`.`id_user` = '" . $_SESSION['ID_USER'] . "') AND (`followers`.`id_follower` = '" . $id_user . "')) LIMIT 1;"; $result = mysql_query($sql); $row = mysql_fetch_assoc($result); mysql_free_result($result); if (mysql_affected_rows() == 0) { echo '


'; } else { echo '


'; } } $sql = "SELECT COUNT(`notes`.`id_note`) FROM `notes` WHERE (`notes`.`id_user` = '$id_user')"; $result = mysql_query($sql); $row = mysql_fetch_array($result); mysql_free_result($result); $notes = $row[0]; $sql = "SELECT COUNT(`followers`.`id_follow`) FROM `followers` WHERE (`followers`.`id_user` = '$id_user')"; $result = mysql_query($sql); $row = mysql_fetch_array($result); mysql_free_result($result); $friends = $row[0]; $sql = "SELECT COUNT(`followers`.`id_follow`) FROM `followers` WHERE (`followers`.`id_follower` = '$id_user')"; $result = mysql_query($sql); $row = mysql_fetch_array($result); mysql_free_result($result); $followers = $row[0]; $sql = "SELECT COUNT(`favorites`.`id_user`) FROM `favorites` WHERE (`favorites`.`id_user` = '$id_user')"; $result = mysql_query($sql); $row = mysql_fetch_array($result); mysql_free_result($result); $favorites = $row[0]; echo '
' . _('Acerca de') . '
' . _('Nombre') . ' ' . $name . '
' . _('Localización') . ' ' . $location . '
' . _('Página web') . ' ' . $web . '
' . _('Karma') . ' ' . $karma . '
' . _('Bio') . ' ' . $bio . '
' . _('Desde') . ' ' . $register_date . '
'; if ((!empty($location)) and ($location != '-')) { $map->addAddress($location, 'Localización de ' . $name); $map->showMap(); } echo '
' . _('Estadísticas') . '
' . _('Amigos') . ' ' . $friends . '
' . _('Seguidores') . ' ' . $followers . '
' . _('Favoritos') . ' ' . $favorites . '
' . _('Notas') . ' ' . $notes . '
'; if ($friends != 0) { $sql = " SELECT `users`.`avatar`, `users`.`username` FROM `followers` INNER JOIN `users` ON `users`.`id_user` = `followers`.`id_follower` WHERE (`followers`.`id_user` = '" . $id_user . "') LIMIT 0, 25;"; $result = mysql_query($sql) or die (mysql_error()); echo '
' . _('Amigos') . '
'; while ($row = mysql_fetch_assoc($result)) { $avatar = 'images/avatar/' . $row['username'] . '/thumb_follow.' . $row['avatar']; $avatar = (file_exists($avatar) === true) ? $avatar : 'images/avatar/default_follow.png'; echo ' '; } mysql_free_result($result); echo '
'; } echo '
' . _('Feeds') . '
' . _('General') . '
' . _('Respuestas (@)') . '
' . _('Amigos') . '
'; if ($_SESSION['LOGIN'] !== true) { do_login_form(false); } } else { /* echo _('Usuario no encontrado.'); */ } } else { if ($_SESSION['LOGIN'] !== true) { do_login_form(true); } else if ($_SESSION['LOGIN'] === true) { $sql = "SELECT * FROM `users` WHERE (`users`.`username` = '" . $_SESSION['USERNAME'] . "') LIMIT 1;"; $result = mysql_query($sql); $row = mysql_fetch_assoc($result); mysql_free_result($result); $name = (!empty($row['name'])) ? $row['name'] : '-'; $location = (!empty($row['location'])) ? $row['location'] : '-'; $web = (!empty($row['web'])) ? $row['web'] : '-'; $bio = (!empty($row['bio'])) ? $row['bio'] : '-'; $karma = (!empty($row['karma'])) ? $row['karma'] : '-'; @ $register_date = date('d/m/Y', $row['register_date']); $avatar = 'images/avatar/' . $_SESSION['USERNAME'] . '/thumb_side.' . $row['avatar']; $avatar = (file_exists($avatar) === true) ? $avatar : 'images/avatar/default_side.png'; $invitations = $row['invitations']; $sql = "SELECT COUNT(`notes`.`id_note`) FROM `notes` WHERE (`notes`.`id_user` = '" . $_SESSION['ID_USER'] . "')"; $result = mysql_query($sql); $row = mysql_fetch_array($result); mysql_free_result($result); $notes = $row[0]; $sql = "SELECT COUNT(`followers`.`id_follow`) FROM `followers` WHERE (`followers`.`id_user` = '" . $_SESSION['ID_USER'] . "')"; $result = mysql_query($sql); $row = mysql_fetch_array($result); mysql_free_result($result); $friends = $row[0]; $sql = "SELECT COUNT(`followers`.`id_follow`) FROM `followers` WHERE (`followers`.`id_follower` = '" . $_SESSION['ID_USER'] . "')"; $result = mysql_query($sql); $row = mysql_fetch_array($result); mysql_free_result($result); $followers = $row[0]; $sql = "SELECT COUNT(`favorites`.`id_user`) FROM `favorites` WHERE (`favorites`.`id_user` = '" . $_SESSION['ID_USER'] . "')"; $result = mysql_query($sql); $row = mysql_fetch_array($result); mysql_free_result($result); $favorites = $row[0]; echo '

' . $_SESSION['USERNAME'] . '
' . _('Acerca de') . '
' . _('Nombre') . ' ' . $name . '
' . _('Localización') . ' ' . $location . '
' . _('Página web') . ' ' . $web . '
' . _('Karma') . ' ' . $karma . '
' . _('Bio') . ' ' . $bio . '
' . _('Desde') . ' ' . $register_date . '
' . _('Estadísticas') . '
' . _('Amigos') . ' ' . $friends . '
'; if ($followers > 0) { echo '' . _('Seguidores') . ' ' . $followers . '
'; } else { echo '' . _('Seguidores') . ' ' . $followers . '
'; } echo ' ' . _('Favoritos') . ' ' . $favorites . '
' . _('Notas') . ' ' . $notes . '
'; if ($friends != 0) { $sql = " SELECT `users`.`avatar`, `users`.`username` FROM `followers` INNER JOIN `users` ON `users`.`id_user` = `followers`.`id_follower` WHERE (`followers`.`id_user` = '" . $_SESSION['ID_USER'] . "') LIMIT 0, 25;"; $result = mysql_query($sql) or die (mysql_error()); echo '
' . _('Amigos') . '
'; while ($row = mysql_fetch_assoc($result)) { $avatar = 'images/avatar/' . $row['username'] . '/thumb_follow.' . $row['avatar']; $avatar = (file_exists($avatar) === true) ? $avatar : 'images/avatar/default_follow.png'; echo ' '; } mysql_free_result($result); echo '
'; } echo '
' . _('Feeds') . '
' . _('General') . '
Feed ' . _('Respuestas (@)') . '
Feed ' . _('Amigos') . '
'; if ($invitations >= 1) { echo '
' . _('Invitaciones') . '
' . _('Escribe un e-mail') . ':
' . sprintf(_("%s disponibles"), $invitations) . '
'; } } } ?>