class ListenSubActions { 

    private $nc_core;



    public function __construct () { 

        $this->nc_core = nc_Core::get_object(); 

        $this->nc_core->event->bind($this, array('updateSubdivision' => 'update_sub'));

    }



    public function  update_sub ( $Catalogue_ID, $Subdivision_ID ) { 

        

        $sql = "select concat('/',EnglishName,'/') as name from Sub_Class where Subdivision_ID = ".$Subdivision_ID." and Class_ID = 2012 AND Catalogue_ID = ".$Catalogue_ID;



        $query = $this->nc_core->db->query($sql );

        $arr = $this->nc_core->db->last_result; 

        if(isset($arr[0]->name))

        {

            $url = $arr[0]->name;

            $sql2 = "UPDATE Subdivision

                    SET

                    Hidden_URL = '".$url."'

                    WHERE

                    Subdivision_ID  = ".$Subdivision_ID."

                    ";



            $query = $this->nc_core->db->query($sql2);



        }

	    #$as = $nc_core->subdivision->update($Subdivision_ID, array("EnglishName"=>$name));

        #$this->nc_core->subdivision->update($Subdivision_ID, array("Subdivision_Name"=>$name));

        return 0;

    }  

}