Interests_confirmation_functionController.php

Go to the documentation of this file.

<?php

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

        public function new_confirm($subtopicid)
        {
            Connect_DatabaseController::connect(); 
    
            
                        $subtopicname = mysql_query("SELECT * FROM interests_subtopics_confirmation WHERE id=$subtopicid");
                        
                        while($row2=  mysql_fetch_array($subtopicname))
                        {
                            $subname = $row2['name'];
                            $subtopic_name = $row2['name'];
                            $sql_insert_subtopic="INSERT IGNORE INTO interests_subtopics (name)
                    VALUES
                    ('$subname')";
                    mysql_query($sql_insert_subtopic) or die (mysql_error());
                    
                            $topics = mysql_query("SELECT * FROM interests_topics_confirmation WHERE id IN 
                                     (SELECT DISTINCT topicid FROM topic_subtopic_confirmation WHERE subtopicid=$subtopicid)");


                                 while($row = mysql_fetch_array($topics))
                                         {
                                         $topic_name = $row['name'];
                                         $topicid = $row['id'];
                                         $topicexists = mysql_query("SELECT * FROM interests_topics WHERE name='$topic_name'");
                                         
                                        if(mysql_num_rows($topicexists)!=0) {}
                                        else{
                                         $sql_insert_topic="INSERT IGNORE INTO interests_topics ( name)
                             VALUES
                             ('$topic_name')";
                             mysql_query($sql_insert_topic) 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 topic_subtopic_confirmation SET accepted=1 WHERE topicid=$topicid AND subtopicid=$subtopicid";
            mysql_query($sql_edit_request) or die (mysql_error());
                       
                        $topid = mysql_query("SELECT * FROM interests_topics WHERE name='$topic_name'");

                            while($row3=mysql_fetch_array($topid))
                            {
                                $topicid = $row3['id'];

                                $subid = mysql_query("SELECT * FROM interests_subtopics WHERE name='$subtopic_name'");

                                while($row4=mysql_fetch_array($subid))
                                {
                                    $subtopid = $row4['id'];

                                        $sql_insert_topic_subtopic="INSERT INTO topic_subtopic (topicid, subtopicid)
                            VALUES
                            ('$topicid', '$subtopid' )";
                            mysql_query($sql_insert_topic_subtopic) or die (mysql_error());

                                }

                            }

                       
                       
                       echo $subname . "<br>" . $topic_name . "<br><br><br>";
            
        }
        

        public function existing_confirm($subtopicid)
        {

            Connect_DatabaseController::connect(); 
    
            
                        $subtopicname = mysql_query("SELECT * FROM interests_subtopics_confirmation WHERE id=$subtopicid");
                        
                        while($row2=  mysql_fetch_array($subtopicname))
                        {
                            $subname = $row2['name'];
                            $subtopic_name = $row2['name'];
                            $sql_insert_subtopic="INSERT IGNORE INTO interests_subtopics (name)
                    VALUES
                    ('$subname')";
                    mysql_query($sql_insert_subtopic) or die (mysql_error());
                    
                            $topics = mysql_query("SELECT * FROM interests_topics WHERE id IN 
                                     (SELECT DISTINCT topicid FROM topic_subtopic_existing_confirmation WHERE subtopicid=$subtopicid)");


                                 while($row = mysql_fetch_array($topics))
                                         {
                                         $topic_name = $row['name'];
                                         $topicid = $row['id'];
                  

                        }
                       }


            $sql_edit_request="UPDATE topic_subtopic_existing_confirmation SET accepted=1 WHERE topicid=$topicid AND subtopicid=$subtopicid";
            mysql_query($sql_edit_request) or die (mysql_error());
                       
                        $topid = mysql_query("SELECT * FROM interests_topics WHERE name='$topic_name'");

                            while($row3=mysql_fetch_array($topid))
                            {
                                $topicid = $row3['id'];

                                $subid = mysql_query("SELECT * FROM interests_subtopics WHERE name='$subtopic_name'");

                                while($row4=mysql_fetch_array($subid))
                                {
                                    $subtopid = $row4['id'];

                                        $sql_insert_topic_subtopic="INSERT INTO topic_subtopic (topicid, subtopicid)
                            VALUES
                            ('$topicid', '$subtopid' )";
                            mysql_query($sql_insert_topic_subtopic) or die (mysql_error());

                                }

                            }

                       
                       
                       echo $subname . "<br>" . $topic_name . "<br><br><br>"; 
            
            
            
        }
        
    // 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',
            ),
        );
    }
    */
}