AnnouncementfunctionController.php

Go to the documentation of this file.

<?php

class AnnouncementfunctionController extends Controller
{
    public function actionIndex()
    {
        $this->render('index');
    }

public function sendannouncement()
        {
            Connect_DatabaseController::connect();
            
            $confid = $_POST['confid'];
            $header = $_POST['title'];
            $text = $_POST['content'];
            $usermail = "mrecan06@hotmail.com";
            
            $sql_insert_announcement="INSERT INTO announcements ( header, text)
VALUES
('$header', '$text')";
mysql_query($sql_insert_announcement) or die (mysql_error());

            $last = mysql_insert_id();      
    
            $sql_insert_conf_announcement="INSERT INTO conference_announcement ( conferenceid, announcementid)
VALUES
('$confid', '$last')";
mysql_query($sql_insert_conf_announcement) or die (mysql_error());




        }
        
        public function mailall()
        {
         
            Connect_DatabaseController::connect();

            $confid = $_POST['confid'];
            $header = $_POST['title'];
            $text = $_POST['content'];
            
            $mails = mysql_query("SELECT * FROM users WHERE userid IN
                (SELECT userid FROM conference_user_type WHERE conferenceid=$confid)");
            
            while($row = mysql_fetch_array($mails))
            {
                
                $usermail = $row['email'];
            Yii::import('application.extensions.phpmailer.JPhpMailer');

                $mail = new JPhpMailer;
                $mail->IsSMTP();
                $mail->Host = 'smtp.googlemail.com:465';
                $mail->SMTPSecure = "ssl";
                $mail->SMTPAuth = true;
                $mail->Username = 'jjjuk7@gmail.com';
                $mail->Password = 'klizma23';
                $mail->SetFrom('jjjuk7@gmail.com', 'HackedHard');
                $mail->Subject = $header;
                $mail->AltBody = 'To view the message, please use an HTML compatible email viewer!';
                $mail->MsgHTML($text);
                $mail->AddAddress($usermail, 'Hacked Hard');
                $mail->Send();
            }
            
        }
        
        public function mailauth()
        {
         
            Connect_DatabaseController::connect();

            $confid = $_POST['confid'];
            $header = $_POST['title'];
            $text = $_POST['content'];
            
            $mails = mysql_query("SELECT * FROM users WHERE userid IN
                (SELECT userid FROM conference_user_type WHERE conferenceid=$confid AND usertype=2)");
            
            while($row = mysql_fetch_array($mails))
            {
                
                $usermail = $row['email'];
            Yii::import('application.extensions.phpmailer.JPhpMailer');

                $mail = new JPhpMailer;
                $mail->IsSMTP();
                $mail->Host = 'smtp.googlemail.com:465';
                $mail->SMTPSecure = "ssl";
                $mail->SMTPAuth = true;
                $mail->Username = 'jjjuk7@gmail.com';
                $mail->Password = 'klizma23';
                $mail->SetFrom('jjjuk7@gmail.com', 'HackedHard');
                $mail->Subject = $header;
                $mail->AltBody = 'To view the message, please use an HTML compatible email viewer!';
                $mail->MsgHTML($text);
                $mail->AddAddress($usermail, 'Hacked Hard');
                $mail->Send();
            }
            
        }
        
        public function mailref()
        {
         
            Connect_DatabaseController::connect();

            $confid = $_POST['confid'];
            $header = $_POST['title'];
            $text = $_POST['content'];
            
            $mails = mysql_query("SELECT * FROM users WHERE userid IN
                (SELECT userid FROM conference_user_type WHERE conferenceid=$confid AND usertype=3)");
            
            while($row = mysql_fetch_array($mails))
            {
                
                $usermail = $row['email'];
            Yii::import('application.extensions.phpmailer.JPhpMailer');

                $mail = new JPhpMailer;
                $mail->IsSMTP();
                $mail->Host = 'smtp.googlemail.com:465';
                $mail->SMTPSecure = "ssl";
                $mail->SMTPAuth = true;
                $mail->Username = 'jjjuk7@gmail.com';
                $mail->Password = 'klizma23';
                $mail->SetFrom('jjjuk7@gmail.com', 'HackedHard');
                $mail->Subject = $header;
                $mail->AltBody = 'To view the message, please use an HTML compatible email viewer!';
                $mail->MsgHTML($text);
                $mail->AddAddress($usermail, 'Hacked Hard');
                $mail->Send();
            }
            
        }
        
        public function mailatt()
        {
         
            Connect_DatabaseController::connect();

            $confid = $_POST['confid'];
            $header = $_POST['title'];
            $text = $_POST['content'];
            
            $mails = mysql_query("SELECT * FROM users WHERE userid IN
                (SELECT userid FROM conference_user_type WHERE conferenceid=$confid AND usertype=4)");
            
            while($row = mysql_fetch_array($mails))
            {
                
                $usermail = $row['email'];
            Yii::import('application.extensions.phpmailer.JPhpMailer');

                $mail = new JPhpMailer;
                $mail->IsSMTP();
                $mail->Host = 'smtp.googlemail.com:465';
                $mail->SMTPSecure = "ssl";
                $mail->SMTPAuth = true;
                $mail->Username = 'jjjuk7@gmail.com';
                $mail->Password = 'klizma23';
                $mail->SetFrom('jjjuk7@gmail.com', 'HackedHard');
                $mail->Subject = $header;
                $mail->AltBody = 'To view the message, please use an HTML compatible email viewer!';
                $mail->MsgHTML($text);
                $mail->AddAddress($usermail, 'Hacked Hard');
                $mail->Send();
            }
            
        }
        
        
    // 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',
            ),
        );
    }
    */
}