muro tipo fb

[searedone]

Ciao a tutti,
ho uno script tipo fb che ho adattato al mio sito, e tutto funziona correttamente, pero nella classee che vi posto secondo me c'è un problema di correlazione tra gli utenti, mi psiego meglio:

Se pippo scrive nel muro ciao paperina, i mex sono salvati nel db, ma li vede solo paperino, se si logga paperina vede solo i mex che ha postato paperina...

io vorrei che tutti quelli loggati possano vedere i post altrui e commentarli a vicenda.. chi mi puo' aiutare a capire perchè ??

Cavolo ho risolto tutto, ma questo non mi riesce proprio

<?php


class Wall_Updates {

public $perpage = 10; // Uploads perpage
    

    
     // Updates       
      public function Updates($id,$lastid) 
    {
      // More Button
       $morequery="";
        if($lastid)
        $morequery=" and M.msg_id<'".$lastid."' ";
       // More Button End
       
        $query = mysql_query("SELECT M.msg_id, M.id_fk, M.message, M.created, U.username,M.uploads FROM messages M, users U  WHERE M.id_fk=U.id and M.id_fk='$id' $morequery order by M.msg_id desc limit " .$this->perpage) or die(mysql_error());
        
         while($row=mysql_fetch_array($query))
        $data[]=$row;
        return $data;
        
    }
         // Updates       
      public function Total_Updates($id) 
    {
            
        $query = mysql_query("SELECT M.msg_id, M.id_fk, M.message, M.created, U.username,M.uploads FROM messages M, users U  WHERE M.id_fk=U.id and M.id_fk='$id' $morequery order by M.msg_id ") or die(mysql_error());
        $data=mysql_num_rows($query);
        return $data;
        
    }
    
    //Comments
       public function Comments($msg_id,$second_count) 
    {
    $query='';
      if($second_count)
      $query="limit $second_count,2";
        $query = mysql_query("SELECT C.com_id, C.id_fk, C.comment, C.created, U.username FROM comments C, users U WHERE C.id_fk=U.id and C.msg_id_fk='$msg_id' order by C.com_id asc $query") or die(mysql_error());
       while($row=mysql_fetch_array($query))
        $data[]=$row;
        if(!empty($data))
        {
       return $data;
         }
    }
    
    
    //Avatar Image
    //From database
     public function Profile_Pic($id) 
    {
        $query = mysql_query("SELECT profile_pic FROM `users` WHERE id='$id'") or die(mysql_error());
       $row=mysql_fetch_array($query);
       if(!empty($row['profile_pic']))
       {
        $profile_pic_path=$base_url.'profile_pic/';
        $data=    $profile_pic_path.$row['profile_pic'];
        return $data;
         }
         else
         {
         $data="icons/default.jpg";
        return $data;
         }
    }
    //  Gravatar Image
    public function Gravatar($id) 
    {
        $query = mysql_query("SELECT email FROM `users` WHERE id='$id'") or die(mysql_error());
       $row=mysql_fetch_array($query);
       if(!empty($row))
       {
        $email=$row['email'];
        $lowercase = strtolower($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($id, $update,$uploads) 
    {
    $update=mysql_real_escape_string($update);
      $time=time();
       $ip=$_SERVER['REMOTE_ADDR'];
        $query = mysql_query("SELECT msg_id,message FROM `messages` WHERE id_fk='$id' order by msg_id desc limit 1") or die(mysql_error());
        $result = mysql_fetch_array($query);
        
        if ($update!=$result['message']) {
          $uploads_array=explode(',',$uploads);
          $uploads=implode(',',array_unique($uploads_array));
            $query = mysql_query("INSERT INTO `messages` (message, id_fk, ip,created,uploads) VALUES (N'$update', '$id', '$ip','$time','$uploads')") or die(mysql_error());
            $newquery = mysql_query("SELECT M.msg_id, M.id_fk, M.message, M.created, U.username FROM messages M, users U where M.id_fk=U.id and M.id_fk='$id' order by M.msg_id desc limit 1 ");
            $result = mysql_fetch_array($newquery);
        
             return $result;
        } 
        else
        {
                 return false;
        }
        
       
    }
    
    //Delete update
        public function Delete_Update($id, $msg_id) 
    {
        $query = mysql_query("DELETE FROM `comments` WHERE msg_id_fk = '$msg_id' and id_fk='$id' ") or die(mysql_error());
        $query = mysql_query("DELETE FROM `messages` WHERE msg_id = '$msg_id' and id_fk='$id'") or die(mysql_error());
        return true;
                 
    }
    
        //Image Upload
        public function Image_Upload($id, $image) 
    {
    //Base64 encoding
    $path="uploads/";
           $img_src = $path.$image;
     $imgbinary = fread(fopen($img_src, "r"), filesize($img_src));
     $img_base = base64_encode($imgbinary);
     $ids = 0;
        $query = mysql_query("insert into user_uploads (image_path,id_fk)values('$image' ,'$id')") or die(mysql_error());
        $ids = mysql_insert_id();
        return $ids;
    }
    
            //get Image Upload
        public function Get_Upload_Image($id,$image) 
    {    
        if($image)
        {
          $query = mysql_query("select id,image_path from user_uploads where image_path='$image'") or die(mysql_error());
        }
        else
        {
           $query = mysql_query("select id,image_path from user_uploads where id_fk='$id' order by id desc ") or die(mysql_error());
        }
      
         $result = mysql_fetch_array($query);
        
        return $result;
    }
    
        //Id Image Upload
        public function Get_Upload_Image_Id($id) 
    {    
        $query = mysql_query("select image_path from user_uploads where id='$id'") or die(mysql_error());
         $result = mysql_fetch_array($query);
        
        return $result;
    }
    
    //Insert Comments
    public function Insert_Comment($id,$msg_id,$comment) 
    {
    $comment=mysql_real_escape_string($comment);
    
               $time=time();
       $ip=$_SERVER['REMOTE_ADDR'];
        $query = mysql_query("SELECT com_id,comment FROM `comments` WHERE id_fk='$id' and msg_id_fk='$msg_id' 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, id_fk,msg_id_fk,ip,created) VALUES (N'$comment', '$id','$msg_id', '$ip','$time')") or die(mysql_error());
            $newquery = mysql_query("SELECT C.com_id, C.id_fk, C.comment, C.msg_id_fk, C.created, U.username FROM comments C, users U where C.id_fk=U.id and C.id_fk='$id' and C.msg_id_fk='$msg_id' order by C.com_id desc limit 1 ");
            $result = mysql_fetch_array($newquery);
         
           return $result;
        } 
        else
        {
        return false;
        }
       
    }
    
    //Delete Comments
        public function Delete_Comment($id, $com_id) 
    {
        $query = mysql_query("DELETE FROM `comments` WHERE id_fk='$id' and com_id='$com_id'") or die(mysql_error());
        return true;
                 
    }

    

}

?>

[searedone]

un po' di adrenalina per tutti i programmatori .....

ho aggiunto questo:

<?php


class Wall_Updates {

public $perpage = 10; // Uploads perpage
    
      
     // Updates         
      public function Updates($id)   
    {  
      
 $query=mysql_query("SELECT user_1, user_2 FROM relationship WHERE (user_1=$id OR user_2=$id) AND amico='S'");     
while($am=mysql_fetch_assoc($query)){     
    $amici_grezzi[]=$am['user_1'];     
    $amici_grezzi[]=$am['user_2'];     
}     
//ripulisci l'array dei valori duplicati     
$amici=array_unique($amici_grezzi);    
foreach($amici AS $id){   
    $query=mysql_query("SELECT M.msg_id, M.id_fk, M.message, M.created, U.username, M.uploads FROM messages M, users U WHERE M.id_fk=$id and M.uid_fk=$id $morequery order by M.msg_id desc ");   
    $row=mysql_fetch_assoc($query);//qui se vuoi puoi sostituire con mysql_fetch_assoc 
    $data[]=$row['msg_id'];//errore AVEVO MESSO $data[0]  
    array_push($data,$row['id'],$row['message'],$row['created'],$row['username']);   
}   
    
       return $data; 
    
}  
  public function Total_Updates($id) 
    {
            
        $query = mysql_query("SELECT M.msg_id, M.id_fk, M.message, M.created, U.username, M.uploads FROM messages M, users U  WHERE M.id_fk=U.id and M.id_fk='$id' $morequery order by M.msg_id ") or die(mysql_error());
        $data=mysql_num_rows($query);
        return $data;
        
    }

Bene sembra che funzioni, peccato che la funzione total updates non funziona più e non mi posta i post vecchi ??? e come rinfresco la pagina sparisce tutto ciò che avevo postato :-(

public function Total_Updates($id) 
    {
            
        $query = mysql_query("SELECT M.msg_id, M.id_fk, M.message, M.created, U.username, M.uploads FROM messages M, users U  WHERE M.id_fk=U.id and M.id_fk='$id' $morequery order by M.msg_id ") or die(mysql_error());
        $data=mysql_num_rows($query);
        return $data;
        
    } 

qualcuno sa perchè ?????

[searedone]

niente neanche cosi ........

class Wall_Updates {

public $perpage = 10; // Uploads perpage
    

    
     // Updates       
      public function Updates($id,$lastid) 
    {
      // More Button
       $morequery="";
        if($lastid)
        $morequery=" and M.msg_id<'".$lastid."' ";
       // More Button End
       
        $query = mysql_query("SELECT M.msg_id, M.id_fk, M.message, M.created, U.username,M.uploads FROM messages M, users U WHERE M.id_fk=U.id and M.id_fk='$id' $morequery OR M.id_fk=$id IN (SELECT user_1 FROM relationship AS r WHERE r.user_2 = '$uid' AND r.amico = 'S') OR M.id_fk IN (SELECT user_2 FROM relationship AS r WHERE r.user_1 = '$id' AND r.amico = 'S') order by M.msg_id desc limit " .$this->perpage) or die(mysql_error());
        
         while($row=mysql_fetch_array($query))
        $data[]=$row;
        return $data;
        
    }
         // Updates       
      public function Total_Updates($id) 
    {
            
        $query = mysql_query("SELECT M.msg_id, M.id_fk, M.message, M.created, U.username,M.uploads FROM messages M, users U  WHERE M.id_fk=U.id and M.id_fk='$id' $morequery order by M.msg_id ") or die(mysql_error());
        $data=mysql_num_rows($query);
        return $data;
        
    } 

Aiutatemi pleaseeeeeee