Participate_notController.php

Go to the documentation of this file.

<?php

class Participate_notController extends Controller
{
    public function actionIndex()
    {
        $this->render('index');
    }
        
        public function leave()
        {
            
            Connect_DatabaseController::connect();       
            
            if(Yii::app()->user->id != NULL)
                $usid = Yii::app()->user->id;
            else
                $usid = 0;
            
            
            $confid = $_POST['id'];
            $type = $_POST['type'];


            $sql_delete_conf_user="DELETE FROM conference_user  WHERE conferenceid=$confid AND userid=$usid";
            mysql_query($sql_delete_conf_user) or die (mysql_error());

            $sql_accept_referee="DELETE FROM conference_user_type  WHERE conferenceid=$confid AND userid=$usid AND usertype=$type";
            mysql_query($sql_accept_referee) or die (mysql_error());                      

            $sql_edit_request="UPDATE request_type SET accept=2 WHERE conferenceid=$confid AND userid=$usid AND type=$type";
            mysql_query($sql_edit_request) or die (mysql_error());
            
            $sql_edit_invitation="UPDATE invitations SET accepted_rejected=2 WHERE userid=$usid AND conferenceid=$confid AND usertype=$type";
            mysql_query($sql_edit_invitation) or die (mysql_error());            
        }

    // 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',
            ),
        );
    }
    */
}