' : '

'; if($row['type'] == 'twitter'){ $note_style = 'note_t'; } elseif($row['type'] == 'group'){ $note_style = 'note_g'; } else { $note_style = 'note'; } if (($_SESSION['LOGIN']) and ($_SESSION['USERNAME'] != $row['username'])) { echo (strstr(strtolower($row['to']), strtolower($_SESSION['USERNAME']))) ? '

' : '

'; } else { echo '

'; } if($row['type'] == 'twitter') $user_profile = 'http://twitter.com/'.$row['username']; else $user_profile = $row['username']; echo '

' . $row['username']. '

'; if (!empty($row['attached_file']) && $row['type'] != 'twitter') echo '

'; if ($row['username'] == $_SESSION['USERNAME']) echo '

'; if (($_SESSION['LOGIN']) and ($row['type'] != 'private') and ($row['type'] != 'twitter' )) { $sql = " SELECT * FROM `favorites` WHERE ((`id_user` = '" . $_SESSION['ID_USER'] . "') AND (`permalink` = '" . $row['permalink'] . "'));"; mysql_query($sql); if (mysql_affected_rows() == 0) { echo '

'; } else { echo '

'; } } if ($row['type'] != 'private' && $row['type'] != 'twitter') echo '

'; elseif($row['type'] == 'twitter') echo '

'; if (($_SESSION['LOGIN']) and ($row['type'] != 'twitter' )) echo '

'; else echo '

'; echo '

' . get_difference($row['date'], $get_difference_lang) . ' (' . $row['from'] . ')

' . $note . '

'; } else if (($first_note) and ($action == 'general')) { // echo ($row['type'] == 'group') ? '

' : '

'; echo '

' . $row['username'] . '

'; if (!empty($row['attached_file'])) echo '

'; echo '

'; if (($_SESSION['LOGIN']) and ($row['type'] != 'private')) { $sql = " SELECT * FROM `favorites` WHERE ((`id_user` = '" . $_SESSION['ID_USER'] . "') AND (`permalink` = '" . $row['permalink'] . "'));"; mysql_query($sql); if (mysql_affected_rows() == 0) { echo '

'; } else { echo '

'; } } if ($row['type'] != 'private') echo '

'; if (($_SESSION['LOGIN']) and ($row['id_user'] != $_SESSION['ID_USER'])) echo '

'; echo '

' . get_difference($row['date'], $get_difference_lang) . ' (' . $row['from'] . ')

' . $note . '

'; $first_note = false; } } mysql_free_result($result); switch ($action) { case 'all'; $sql = "SELECT COUNT(*) AS val FROM `followers` INNER JOIN `notes` ON `notes`.`id_user` = `followers`.`id_follower` INNER JOIN `users` ON `users`.`id_user` = `followers`.`id_follower` WHERE (`followers`.`id_user` = '" . $_SESSION['ID_USER'] . "') AND (`notes`.`type` IN ('', 'reply', 'group')) ) AS tmp) UNION DISTINCT (( SELECT COUNT(*) AS val FROM `notes` INNER JOIN `users` ON `users`.`id_user` = `notes`.`id_user` WHERE (`notes`.`id_user` = '" . $_SESSION['ID_USER'] . "') AND (`notes`.`type` IN ('', 'reply', 'group')) )) UNION DISTINCT (( SELECT COUNT(*) AS val FROM `twitter` WHERE (`twitter`.`to` = '" . $_SESSION['ID_USER'] . "') ))"; $sql = "SELECT SUM(val) FROM ( ( SELECT COUNT(*) AS val FROM `followers` INNER JOIN `notes` ON `notes`.`id_user` = `followers`.`id_follower` INNER JOIN `users` ON `users`.`id_user` = `followers`.`id_follower` WHERE ((`followers`.`id_user` = '" . $_SESSION['ID_USER'] . "') AND (`notes`.`type` != 'private')) ) UNION DISTINCT ( SELECT COUNT(*) FROM `notes` INNER JOIN `users` ON `users`.`id_user` = `notes`.`id_user` WHERE ((`notes`.`id_user` = '" . $_SESSION['ID_USER'] . "') AND (`notes`.`type` IN('', 'reply', 'group'))) ) ) AS tmp;"; $result = mysql_query($sql); // or die(mysql_error()) $count1 = mysql_fetch_array($result); $count1 = $count1[0]; $sql = "SELECT count(*) FROM twitter WHERE `to` = " . $_SESSION['ID_USER']; $result = mysql_query($sql) or die(mysql_error()); $count2 = mysql_fetch_array($result); $count = $count2[0] + $count1; break; case 'general': $sql = " SELECT COUNT(*) FROM `notes` WHERE (`notes`.`id_user` = '" . $_SESSION['ID_USER'] . "');"; $result = mysql_query($sql) or die(mysql_error()); $count = mysql_fetch_array($result); $count = $count[0]; break; case 'private': $sql = " SELECT COUNT(*) FROM `notes` WHERE ((`notes`.`type` = 'private') AND ((`notes`.`id_user` = '" . $_SESSION['ID_USER'] . "') OR (`notes`.`to` = '" . $_SESSION['USERNAME'] . "')));"; $result = mysql_query($sql) or die(mysql_error()); $count = mysql_fetch_array($result); $count = $count[0]; break; case 'replies': $sql = " SELECT COUNT(*) FROM `notes` WHERE ((`notes`.`type` = 'reply') AND ((`notes`.`id_user` = '" . $_SESSION['ID_USER'] . "') OR (`notes`.`to` LIKE '" . $_SESSION['USERNAME'] . "')));"; $result = mysql_query($sql) or die(mysql_error()); $count = mysql_fetch_array($result); $count = $count[0]; break; case 'friends': $sql = " SELECT SUM(val) FROM ( ( SELECT COUNT(*) AS val FROM `followers` INNER JOIN `notes` ON `notes`.`id_user` = `followers`.`id_follower` INNER JOIN `users` ON `users`.`id_user` = `followers`.`id_follower` WHERE ((`followers`.`id_user` = '" . $_SESSION['ID_USER'] . "') AND (`notes`.`type` != 'private')) ) UNION DISTINCT ( SELECT COUNT(*) FROM `notes` INNER JOIN `users` ON `users`.`id_user` = `notes`.`id_user` WHERE ((`notes`.`id_user` = '" . $_SESSION['ID_USER'] . "') AND (`notes`.`type` IN('', 'reply', 'group'))) ) ) AS tmp;"; $result = mysql_query($sql) or die(mysql_error()); $count = mysql_fetch_array($result); $count = $count[0]; break; case 'favorites': $sql = " SELECT COUNT(*) FROM `favorites` INNER JOIN `notes` ON `notes`.`permalink` = `favorites`.`permalink` WHERE (`favorites`.`id_user` = '" . $_SESSION['ID_USER'] . "');"; $result = mysql_query($sql) or die(mysql_error()); $count = mysql_fetch_array($result); $count = $count[0]; break; } if ($count > $CONFIG['NOTES_2p']) { $pagination_href = array ("action" => $action, "p" => "[-]"); require("./includes/pagination_class.php"); $pagination = new pagination($page, $count, $CONFIG['NOTES_2p'], 'notes' , $pagination_components_enabled, $pagination_components_text, $pagination_href, $pagination_classes, true); $result_pagination = $pagination->show_pagination(); echo '

' . $result_pagination . '

'; } } else { echo '

' . _('No se encontraron notas en esta sección.') . '

'; } } ?>