ViewusermessageController.php

Go to the documentation of this file.

<?php

class ViewusermessageController extends Controller
{
    public function actionIndex()
    {
        $this->render('index');
    }
        
        public function viewall()
        {
            Connect_DatabaseController::connect();

            
            if(Yii::app()->user->id != NULL)
                $usid = Yii::app()->user->id;
            else
                $usid = 0;
            
            
            $userid = $_GET['userid'];
            

            // AND receiverid='$userid') OR (senderid='$userid' AND receiverid='$usid')
            $mess = mysql_query("SELECT * FROM message WHERE (senderid=$usid AND receiverid=$userid) OR (senderid=$userid AND receiverid=$usid)");
            
            $i=0;

            while($row = mysql_fetch_array($mess))
                    {

                    $asd = $row['id'];
                    $senderid = $row['senderid'];
                    $sender = mysql_query("SELECT * FROM users WHERE userid=$senderid");
                    
                    while($row2 = mysql_fetch_array($sender))
                    {
                        $sendername = $row2['username'];
                        $date = $row['date'];
                            echo "(". $date . ") " . "<B>". $row2['firstname'] . " " . $row2['lastname'] ." :</B>" . " " . $row['content'];
                            echo "<br>";
                            
                    }
            
            if($row['receiverid'] == $usid)
            {        
            }
            else
            {
                
            $sql_read="UPDATE message SET read_unread=1 WHERE (receiverid='$usid' AND senderid='$userid')";
            mysql_query($sql_read) or die (mysql_error());

            }
            //  echo "<br />";
            //  echo "Conference ID   : " . $row['conferenceid'];                    echo "<br />";
            //      echo CHtml::link("View Conference",array('conference/index', '&va'=>$co));

                    echo "<br>";
            $i++;
                    }
                    
            if($i==0) echo "You don't have any message history with this user.";
            
        }

        

    // Uncomment the following methods and override them if needed
    /*
    public function filters()
    {
        // return the filter configuration for this controller, e.g.:
        return array(
            'inlineFilterName',
            array(
                'class'=>'path.to.FilterClass',
                'propertyName'=>'propertyValue',
            ),
        );
    }

    public function actions()
    {
        // return external action classes, e.g.:
        return array(
            'action1'=>'path.to.ActionClass',
            'action2'=>array(
                'class'=>'path.to.AnotherActionClass',
                'propertyName'=>'propertyValue',
            ),
        );
    }
    */
}