wall typo fb o twitter ok ---- ma non vede i post degli amici

S

searedone

Utente Attivo
11 Giu 2010
508
0
0
Ciao a tutti,
mi sono aiutato tramite unoscript già pronto e ho creato finalmente il muro come volevo ...

piccolo problema a differenza di quello che avevo creato io vede solo i post dell'utente loggiato e non quello di quelli che sono amici come dovrebbe ...

Domanda ho una tabella relationship dove chi chiede amicizia e viene accettata viene messo in S altrimenti il campo enum di default e N come se venisse rifiutata....

Lo script vecchio era questo :

PHP: 
<?php  
include 'dbc.php'; 
page_protect(); 


?> 
<html> 
<head> 
<title>My Account</title> 
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> 

<link href="styles.css" rel="stylesheet" type="text/css"> 
</head> 

<body> 
<table width="100%" border="0" cellspacing="0" cellpadding="5" class="main"> 
  <tr>  
    <td colspan="3">&nbsp;</td> 
  </tr> 
  <tr>  
    <td width="160" valign="top"> 
<?php  
/*********************** MYACCOUNT MENU **************************** 
This code shows my account menu only to logged in users.  
Copy this code till END and place it in a new html or php where 
you want to show myaccount options. This is only visible to logged in users 
*******************************************************************/ 
if (isset($_SESSION['user_id'])) {?> 
<div class="myaccount"> 
  <p><strong>My Account</strong></p> 
  <a href="myaccount.php">My Account</a><br> 
  <a href="mysettings.php">Settings</a><br> 
    <a href="logout.php">Logout </a> 
     
  <p>You can add more links here for users</p></div> 
<?php } 
if (checkAdmin()) { 
/*******************************END**************************/ 
?> 
      <p> <a href="admin.php">Admin CP </a></p> 
      <?php } ?> 
      <p>&nbsp;</p> 
      <p>&nbsp;</p> 
      <p>&nbsp;</p></td> 
    <td width="732" valign="top"><p>&nbsp;</p> 
      <h3 class="titlehdr">Welcome <?php echo $_SESSION['user_name'];?></h3>   
      <?php     
      if (isset($_GET['msg'])) { 
      echo "<div class=\"error\">$_GET[msg]</div>"; 
      } 
             
      ?> 
      <p>This is the my account page</p> 
       
      <a href="accetta.php" />Controlla se hai richieste d'amicizia</a> 
       
      <br /> 
      <br /> 
       
      <br /> 
<?php echo $_SESSION['user_name'];   
require ("db_connect.php");  


$user_id = $_POST['user_id'];  



$commento=$_POST["commento"]; 
$commento=ereg_replace("\n","<br>",$commento);  

if(get_magic_quotes_gpc()) {  


$commento=stripslashes($commento);  
}  

$commento =mysql_real_escape_string($commento);  

$insert = mysql_query("INSERT INTO annunci SET 
commento='$commento', user_id=".$_SESSION['user_id']."");  

  


?> 
      
 <div class="content"> 
    <form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>"> 
      
      <p> 
        <label for="commento"></label> 
        <textarea name="commento" id="commento" cols="55" rows="20"></textarea> 
      </p> 
      <p> 
        <input type="submit" name="submit" id="submit" value="Invia Commento" /> 
      </p> 
    </form> 
    </div> 
     
     
   <?php  
    
    
require ("db_connect.php");  



$result = mysql_query("SELECT * FROM 
        annunci  
       WHERE user_id=".$_SESSION["user_id"]."
     ORDER BY `id_annunci` DESC LIMIT ");  


//recuperiamo i dati da stampare  


while ($records = mysql_fetch_array($result)) {   


$commento = $records['commento']; 
$user_name = $records['user_name']; 
$ts = $records['ts']; 

$query_ut=mysql_query("SELECT * FROM relationship WHERE id ='$id' AND amico='S'");//non so come si chiama esattamente il campo id in user 
            //verifica e correggi eventualmente 
            $riga_ut=mysql_fetch_array($query_ut); 
           
           

echo "<h2> <img src='immagini/.gif' width='30' height='50' /> $user_name</h2> ";  
echo "<h6>$commento</h6> ";  
echo "<h6>$ts</h6> ";  



}  

?> 


   
      
      
      </td> 
    <td width="196" valign="top">&nbsp;</td> 
  </tr> 
  <tr>  
    <td colspan="3">&nbsp;</td> 
  </tr> 
</table> 

</body> 
</html>

Nello script nuovo ho un pannello functions che mi richiama tutte le funzioni...

io ho provato così ma nada vedo solo i post di chi è loggiato e non degli amici..

PHP: 
<?php
//Srinivas Tamada http://9lessons.info
//Wall_Updates

class Wall_Updates {

 // Wall friends  	
	  public function relationship ($uid) 
	{
	   

$query=mysql_query("SELECT * FROM relationship WHERE uid ='$uid' AND amico='S'");//non so come si chiama esattamente il campo id in user 

   while($row=mysql_fetch_array($query))
		$data[]=$row;
	    return $data;
		
    }   
     // Updates   	
	  public function Updates($uid) 
	{
	    $query = mysql_query("SELECT M.msg_id, M.uid_fk, M.message, M.created, U.username FROM messages M, users U  WHERE M.uid_fk=U.uid and M.uid_fk='$uid' order by M.msg_id desc ") or die(mysql_error());
         while($row=mysql_fetch_array($query))
		$data[]=$row;
	    return $data;
		
    }
	//Comments
	   public function Comments($msg_id) 
	{
	    $query = mysql_query("SELECT C.com_id, C.uid_fk, C.comment, C.created, U.username FROM comments C, users U WHERE C.uid_fk=U.uid and C.msg_id_fk='$msg_id' and uid ='$uid' AND amico='S' order by C.com_id asc ") or die(mysql_error());
	   while($row=mysql_fetch_array($query))
	    $data[]=$row;
        if(!empty($data))
		{
       return $data;
         }
	}
	
	//Avatar Image
	public function Gravatar($uid) 
	{
	    $query = mysql_query("SELECT user_email FROM `users` WHERE uid='$uid'") or die(mysql_error());
	   $row=mysql_fetch_array($query);
	   if(!empty($row))
	   {
	    $user_email=$row['user_email'];
        $lowercase = strtolower($user_email);
        $imagecode = md5( $lowercase );
		$data="http://www.gravatar.com/avatar.php?gravatar_id=$imagecode";
		return $data;
         }
		 else
		 {
		 $data="default.jpg";
		return $data;
		 }
	}
	
	//Insert Update
	public function Insert_Update($uid, $update) 
	{
	$update=htmlentities($update);
	   $time=time();
	   $ip=$_SERVER['REMOTE_ADDR'];
        $query = mysql_query("SELECT msg_id,message FROM `messages` WHERE uid_fk='$uid' and uid ='$uid' AND amico='S' order by msg_id desc limit 1") or die(mysql_error());
        $result = mysql_fetch_array($query);
		
        if ($update!=$result['message']) {
            $query = mysql_query("INSERT INTO `messages` (message, uid_fk, ip,created) VALUES ('$update', '$uid', '$ip','$time')") or die(mysql_error());
            $newquery = mysql_query("SELECT M.msg_id, M.uid_fk, M.message, M.created, U.username FROM messages M, users U where M.uid_fk=U.uid and M.uid_fk='$uid' and uid ='$uid' AND amico='S' order by M.msg_id desc limit 1 ");
            $result = mysql_fetch_array($newquery);
			 return $result;
        } 
		else
		{
				 return false;
		}
		
       
    }
	
	//Delete update
		public function Delete_Update($uid, $msg_id) 
	{
	    $query = mysql_query("DELETE FROM `comments` WHERE msg_id_fk = '$msg_id' ") or die(mysql_error());
        $query = mysql_query("DELETE FROM `messages` WHERE msg_id = '$msg_id' and uid_fk='$uid' and uid ='$uid' AND amico='S'") or die(mysql_error());
        return true;
      	       
    }
	
	//Insert Comments
	public function Insert_Comment($uid,$msg_id,$comment) 
	{
	$comment=htmlentities($comment);
	   	    $time=time();
	   $ip=$_SERVER['REMOTE_ADDR'];
        $query = mysql_query("SELECT com_id,comment FROM `comments` WHERE uid_fk='$uid' and msg_id_fk='$msg_id' and uid ='$uid' AND amico='S' order by com_id desc limit 1 ") or die(mysql_error());
        $result = mysql_fetch_array($query);
    
		if ($comment!=$result['comment']) {
            $query = mysql_query("INSERT INTO `comments` (comment, uid_fk,msg_id_fk,ip,created) VALUES ('$comment', '$uid','$msg_id', '$ip','$time')") or die(mysql_error());
            $newquery = mysql_query("SELECT C.com_id, C.uid_fk, C.comment, C.msg_id_fk, C.created, U.username FROM comments C, users U where C.uid_fk=U.uid and C.uid_fk='$uid' and C.msg_id_fk='$msg_id' and uid ='$uid' AND amico='S' order by C.com_id desc limit 1 ");
            $result = mysql_fetch_array($newquery);
         
		   return $result;
        } 
		else
		{
		return false;
		}
       
    }
	
	//Delete Comments
		public function Delete_Comment($uid, $com_id) 
	{
	    $query = mysql_query("DELETE FROM `comments` WHERE uid_fk='$uid' and com_id='$com_id' and uid ='$uid' AND amico='S'") or die(mysql_error());
        return true;
      	       
    }

    

}

?>

Tabella relationship..
PHP: 
-- phpMyAdmin SQL Dump
-- version 3.3.7
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generato il: 09 nov, 2011 at 10:18 PM
-- Versione MySQL: 5.1.44
-- Versione PHP: 5.3.2

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `yes-friends`
--

-- --------------------------------------------------------

--
-- Struttura della tabella `relationship`
--

CREATE TABLE IF NOT EXISTS `relationship` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `user_1` varchar(10) NOT NULL,
  `user_2` varchar(10) NOT NULL,
  `amico` enum('S','N') NOT NULL DEFAULT 'N',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=37 ;

--
-- Dump dei dati per la tabella `relationship`
--

INSERT INTO `relationship` (`id`, `user_1`, `user_2`, `amico`) VALUES
(12, '54', '57', 'S'),
(9, '54', '57', 'S'),
(8, '54', '55', 'S'),
(7, '54', '58', 'N'),
(11, '55', '54', 'S'),
(13, '57', '54', 'S'),
(14, '57', '57', 'N'),
(15, '57', '55', 'S'),
(16, '54', '60', 'N'),
(17, '57', '54', 'S'),
(18, '57', '58', 'N'),
(19, '57', '59', 'N'),
(20, '57', '60', 'N'),
(21, '54', '61', 'S'),
(22, '57', '61', 'N'),
(24, '54', '62', 'N'),
(25, '54', '55', 'S'),
(26, '54', '55', 'S'),
(27, '54', '55', 'S'),
(28, '55', '58', 'N'),
(29, '55', '54', 'S'),
(30, '57', '58', 'N'),
(31, '63', '61', 'S'),
(32, '63', '61', 'S'),
(33, '63', '61', 'S'),
(34, '63', '61', 'S'),
(35, '54', '58', 'N');

Spero che qualcuno mi aiuti a risolvere il problema ...
 
gentilmente nessuno riesce ad aiutarmi ??? ci sbatto la testa da ieri ma non capisco che devo fare :(

ho provato anche così ad inserire relationship ma nulla sempre e solo i post dell'utente loggiato come se fosse la sua bacheca :(

PHP: 
<?php

class Wall_Updates {

 // Wall friends  	
	  public function relationship ($uid) 
	{
	   

$query=mysql_query("SELECT * FROM relationship WHERE uid ='$uid' AND amico='S'");//non so come si chiama esattamente il campo id in user 

   while($row=mysql_fetch_array($query))
		$data[]=$row;
	    return $data;
		
    }   
     // Updates   	
	  public function Updates($uid) 
	{
	    $query = mysql_query("SELECT M.msg_id, M.uid_fk, M.message, M.created, U.username FROM messages M, users U, relationship R  WHERE M.uid_fk=U.uid and M.uid_fk='$uid' and R.uid ='$uid' AND amico='S' order by M.msg_id desc ") or die(mysql_error());
         while($row=mysql_fetch_array($query))
		$data[]=$row;
	    return $data;
		
    }
	//Comments
	   public function Comments($msg_id) 
	{
	    $query = mysql_query("SELECT C.com_id, C.uid_fk, C.comment, C.created, U.username, relationship R FROM comments C, users U , relationship R WHERE C.uid_fk=U.uid and C.msg_id_fk='$msg_id' and R.uid ='$uid' AND amico='S' order by C.com_id asc ") or die(mysql_error());
	   while($row=mysql_fetch_array($query))
	    $data[]=$row;
        if(!empty($data))
		{
       return $data;
         }
	}
	
	//Avatar Image
	public function Gravatar($uid) 
	{
	    $query = mysql_query("SELECT user_email FROM `users` WHERE uid='$uid'") or die(mysql_error());
	   $row=mysql_fetch_array($query);
	   if(!empty($row))
	   {
	    $user_email=$row['user_email'];
        $lowercase = strtolower($user_email);
        $imagecode = md5( $lowercase );
		$data="http://www.gravatar.com/avatar.php?gravatar_id=$imagecode";
		return $data;
         }
		 else
		 {
		 $data="default.jpg";
		return $data;
		 }
	}
	
	//Insert Update
	public function Insert_Update($uid, $update) 
	{
	$update=htmlentities($update);
	   $time=time();
	   $ip=$_SERVER['REMOTE_ADDR'];
        $query = mysql_query("SELECT msg_id,message FROM `messages`, `relationship` WHERE uid_fk='$uid' and uid ='$uid' AND amico='S' order by msg_id desc limit 1") or die(mysql_error());
        $result = mysql_fetch_array($query);
		
        if ($update!=$result['message']) {
            $query = mysql_query("INSERT INTO `messages` (message, uid_fk, ip,created) VALUES ('$update', '$uid', '$ip','$time')") or die(mysql_error());
            $newquery = mysql_query("SELECT M.msg_id, M.uid_fk, M.message, M.created, U.username FROM messages M, users U relationship R where M.uid_fk=U.uid and M.uid_fk='$uid' and R.uid ='$uid' AND amico='S' order by M.msg_id desc limit 1 ");
            $result = mysql_fetch_array($newquery);
			 return $result;
        } 
		else
		{
				 return false;
		}
		
       
    }
	
	//Delete update
		public function Delete_Update($uid, $msg_id) 
	{
	    $query = mysql_query("DELETE FROM `comments` WHERE msg_id_fk = '$msg_id' ") or die(mysql_error());
        $query = mysql_query("DELETE FROM `messages` WHERE msg_id = '$msg_id' and uid_fk='$uid' and uid ='$uid' AND amico='S'") or die(mysql_error());
        return true;
      	       
    }
	
	//Insert Comments
	public function Insert_Comment($uid,$msg_id,$comment) 
	{
	$comment=htmlentities($comment);
	   	    $time=time();
	   $ip=$_SERVER['REMOTE_ADDR'];
        $query = mysql_query("SELECT com_id,comment FROM `comments`, `relationship`  WHERE uid_fk='$uid' and msg_id_fk='$msg_id' and uid ='$uid' AND amico='S' order by com_id desc limit 1 ") or die(mysql_error());
        $result = mysql_fetch_array($query);
    
		if ($comment!=$result['comment']) {
            $query = mysql_query("INSERT INTO `comments`, `relationship` (comment, uid_fk,msg_id_fk,ip,created) VALUES ('$comment', '$uid','$msg_id', '$ip','$time')") or die(mysql_error());
            $newquery = mysql_query("SELECT C.com_id, C.uid_fk, C.comment, C.msg_id_fk, C.created, U.username FROM comments C, users U, relationship where C.uid_fk=U.uid and C.uid_fk='$uid' and C.msg_id_fk='$msg_id' and R.uid ='$uid' AND amico='S' order by C.com_id desc limit 1 ");
            $result = mysql_fetch_array($newquery);
         
		   return $result;
        } 
		else
		{
		return false;
		}
       
    }
	
	//Delete Comments
		public function Delete_Comment($uid, $com_id) 
	{
	    $query = mysql_query("DELETE FROM `comments` WHERE uid_fk='$uid' and com_id='$com_id' and uid ='$uid' AND amico='S'") or die(mysql_error());
        return true;
      	       
    }

    

}

?>
 
Devi accedere o registrarti per poter rispondere.

Discussioni simili

E
  • Bloccata
firewall ip
Risposte
1
Visite
491
Presentati al Forum
Max 1
Max 1
A
[Photoshop] Jpeg per ledwall
Risposte
0
Visite
849
Photoshop
alessandra_maugeri
A
R
Due reti Due firewall Due connessioni e un ponte radio
Risposte
16
Visite
7K
Reti LAN e Wireless
Pieroz
P
P
wall in asp
Risposte
1
Visite
1K
Classic ASP
seemasaiyom
S
A
www.wallproject.it tributo a The Wall dei Pink Floyd
Risposte
0
Visite
1K
Presenta il tuo Sito
aidomike
A
M
[Firewall] Kaspersky 2010: rimuovere blocco applicazione
Risposte
2
Visite
4K
Sicurezza e Virus
maxbossi
maxbossi
V
Chi mi aiuta con un firewall cattivo!!!!
Risposte
4
Visite
2K
Web Server
Vale_Barbato
V
C
Firewall [XP]
Risposte
1
Visite
2K
Windows e Software
maxbossi
maxbossi
E
firewall
Risposte
1
Visite
2K
Windows e Software
GennyX
GennyX
S
All Wall Street
Risposte
2
Visite
814
Presenta il tuo Sito
lukeonweb
lukeonweb
L
outpost firewall---aiuto per problema
Risposte
1
Visite
1K
Windows e Software
open-think
open-think
M
Connessione internet e firewall
Risposte
0
Visite
2K
Hardware
Medardo
M
peppoweb
Il firewall integrato di Windows XP non blocca IPv6
Risposte
0
Visite
2K
Windows e Software
peppoweb
peppoweb
A
Twitter aggiungere tweet a campagna esistente o salvare pubblico
Risposte
0
Visite
1K
Social Media Marketing
al404
A
P
Vendo incrementi fan pagine facebook/instagramm/twitter
Risposte
5
Visite
2K
Annunci servizi di Social Media Marketing
Pasquale D'Alessio
P
megmalamadre
[VENDO] Facebook fan/ Instagram-Twitter follower / Youtube views / ecc ecc...
Risposte
7
Visite
2K
Annunci servizi di Social Media Marketing
megmalamadre
megmalamadre
Nagath
[VENDO] FB Likes/Followers Instagram/Twitter/Views Youtube
Risposte
5
Visite
3K
Annunci servizi di Social Media Marketing
Nagath
Nagath
orl4c
[VENDO] Pagina 220k reali, sito, youtube,twitter inclusi
Risposte
0
Visite
1K
Annunci servizi di Social Media Marketing
orl4c
orl4c
giuspeppesocial
[VENDO] Sito web completo [scontsita.com] + Pagina FB + Twitter
Risposte
0
Visite
1K
Compravendita siti e domini
giuspeppesocial
giuspeppesocial
J
Gestisco e creo Pagine fecebook, instagram, twitter, youtube, massima serietà, crescita garantita!
Risposte
0
Visite
2K
Annunci servizi di Social Media Marketing
join
J
Alto Basso