hostname_logon, $this->username_logon, $this->password_logon) or die ('Unabale to connect to the database'); mysql_select_db($this->database_logon) or die ('Unable to select database!'); return; } //prevent injection function qry($query) { $this->dbconnect(); $args = func_get_args(); $query = array_shift($args); $query = str_replace("?", "%s", $query); $args = array_map('mysql_real_escape_string', $args); array_unshift($args,$query); $query = call_user_func_array('sprintf',$args); $result = mysql_query($query) or die(mysql_error()); if($result){ return $result; }else{ $error = "Error"; return $result; } } function homemenu() { $this->dbconnect(); $result = $this->qry("SELECT * FROM menu_element WHERE Hidden=0 ORDER BY Position, Date DESC"); while($row = mysql_fetch_array($result)) { if($row != "Error") echo '
  • '.$row['Name'].'
    • '; } } function topmenu() { $this->dbconnect(); $result = $this->qry("SELECT * FROM menu_element WHERE Hidden=0 ORDER BY Position Desc, Date Desc"); while($row = mysql_fetch_array($result)) { if($row != "Error") echo '> '.strtolower($row['Name']).''; } } function homeContent() { echo'

    Prof. Dr. Ing. Eugen Lupu

    Colectiv
    - Sisteme cu microprocesoare
    - Procesoare de semnal
    - Analiza, sinteza si recunoasterea semnalului vocal

    in cadrul Departamentului Comunicatii la
    Universitatea Tehnica din Cluj-Napoca, Cluj-Napoca, Romania

    Contact

    Adresa birou: Str. Dorobantilor nr.73, Cluj-Napoca,Romania
    Adresa postala: Catedra Comunicatii, Universitatea Tehnica din Cluj-Napoca, str. G. Baritiu, nr 26-28, 400027, Cluj-Napoca, Romania
    Email: Eugen.Lupu@com.utcluj.ro
    Pagina web: http://users.utcluj.ro/~elupu
    '; } function fromMenu($MenuCode){ $this->dbconnect(); $resTitle = $this->qry("SELECT HasSubmenu FROM menu_element WHERE MenuCode=".stripslashes($MenuCode)); $row = mysql_fetch_array($resTitle); if($row != "Error") if($row['HasSubmenu']==1) $this->submenu($MenuCode); else $this->page($MenuCode,"MenuCode"); } function submenu($MenuCode){ //$this->dbconnect(); $resTitle = $this->qry("SELECT Name FROM menu_element WHERE MenuCode=".stripslashes($MenuCode)); $row = mysql_fetch_array($resTitle); if($row != "Error") { echo '

    '.$row['Name'].'

    '; } $result = $this->qry("SELECT * FROM submenu_element WHERE MenuCode=".stripslashes($MenuCode)." AND Hidden=0 ORDER BY Position, Date DESC"); echo'
    '; } function page($Code,$codeType) { $resTitle = $this->qry("SELECT Title, PageCode FROM page WHERE ".$codeType."=".stripslashes($Code)); $row = mysql_fetch_array($resTitle); if($row != "Error") { echo '

    '.$row['Title'].'

    '; echo '

    '; } $result = $this->qry("SELECT * FROM page_object WHERE PageCode=".stripslashes($row['PageCode'])." AND Hidden=0 ORDER BY Position, Date DESC"); while($row = mysql_fetch_array($result)) { if($row != "Error") { if($row['Info']=="cv") echo '
    '.$row['Title'].'
    '.$row['Description'].'
    '; else { echo '
    '.$row['Title'].'
    '.$row['Description']; $this->getLinks($row['PageObjCode'], "PageObjCode", "right"); $this->getFiles($row['PageObjCode'], "PageObjCode", "right"); echo '
    '; $this->getLinks($row['PageObjCode'], "PageObjCode", "bottom"); $this->getFiles($row['PageObjCode'], "PageObjCode", "bottom"); } } } } function fromSubmenu($SubmenuCode) { $this->dbconnect(); $resTitle = $this->qry("SELECT HasPage, SubmenuName FROM submenu_element WHERE SubmenuCode=".stripslashes($SubmenuCode)); $row = mysql_fetch_array($resTitle); if($row != "Error") { if($row['HasPage']==0) { echo'

    '.$row['SubmenuName'].'

    '; $this->course($SubmenuCode); $this->lab($SubmenuCode); $this->bottomLinks($SubmenuCode); } else { $this->page($SubmenuCode,"SubmenuCode"); } } } function course($SubmenuCode) { $result = $this->qry("SELECT * FROM course WHERE SubmenuCode=".stripslashes($SubmenuCode)." AND Hidden=0 ORDER BY LENGTH(CourseNo), CourseNo"); if(mysql_num_rows($result)>0) echo'

    Curs

    '; else echo'

    Momentan nu exista cursuri.
    '; while($row = mysql_fetch_array($result)) { if($row != "Error") { $fileAddress = $this->qry("SELECT Address FROM files WHERE CourseCode=".$row['CourseCode']." AND Position='left' AND Hidden=0"); $rowFile = mysql_fetch_array($fileAddress); $fileName=""; if($rowfile != "Error") { $fileName=$rowFile['Address']; } echo '
    '.$row['CourseNo'].'
    '.$row['Name'].'
    '.$row['Description'].'
    '; $this->getLinks($row['CourseCode'], "CourseCode", "bottom"); $this->getFiles($row['CourseCode'], "CourseCode", "bottom"); echo '
    '; } } echo'

    '; } function lab($SubmenuCode) { $result = $this->qry("SELECT * FROM laboratory WHERE SubmenuCode=".stripslashes($SubmenuCode)." AND Hidden=0 ORDER BY LENGTH(LabNo), LabNo"); if(mysql_num_rows($result)>0) echo'

    Laborator

    '; //else //echo'

    Momentan nu exista laboratoare.
    '; while($row = mysql_fetch_array($result)) { if($row != "Error") echo '
    '.$row['LabNo'].'
    '.$row['Name'].'
    '.$row['Description'].'
    '; } } function getFiles($code, $codeType, $position) { $result = $this->qry("SELECT Name, Address FROM files WHERE ".$codeType."=".$code." AND Position='".$position."' AND Hidden=0"); while($row = mysql_fetch_array($result)) { if($row != "Error") { $path_parts = pathinfo($row['Name']); $ext = strtolower($path_parts["extension"]); if($position=="right") { if($row['Hidden']!=1) echo '['.$ext.'] '; } else { if($position=="bottom") echo '
    '; else echo '
    '; if($ext=="pdf") echo ''; else if($ext=="doc" || $ext=="docx") echo ''; else if($ext=="ppt" || $ext=="pptx") echo ''; else echo ''; echo ''.$row['Name'].'
    '; } } } } function getLinks($code, $codeType, $position) { $result = $this->qry("SELECT Name, Address FROM links WHERE ".$codeType."=".$code." AND Position='".$position."' AND Hidden=0"); while($row = mysql_fetch_array($result)) { if($row != "Error") { if($position=="right") { if($row['Hidden']!=1) echo '['.$row['Name'].'] '; } else { if($position=="bottom") echo '
    '; echo ''.$row['Name'].'
    '; } } } } function bottomLinks($SubmenuCode) { $result = $this->qry("SELECT Name, Address FROM links WHERE SubmenuCode=".$SubmenuCode." AND Position='bottomend' AND Hidden=0"); $numrow=mysql_num_rows($result); if($numrow > 0) { echo '

    Link-uri/Fisiere

    '; echo '
    '; while($row = mysql_fetch_array($result)) { if($row != "Error") { echo '
    '; echo ''.$row['Name'].'
    '; } } } $result = $this->qry("SELECT Name, Address FROM files WHERE SubmenuCode=".$SubmenuCode." AND Position='bottomend' AND Hidden=0"); if($numrow == 0 && mysql_num_rows($result) > 0) { echo '

    Link-uri/Fisiere

    '; echo '
    '; } else if($numrow > 0 && mysql_num_rows($result) > 0) //echo '
    '; $numrow2=mysql_num_rows($result); while($row = mysql_fetch_array($result)) { $path_parts = pathinfo($row['Name']); $ext = strtolower($path_parts["extension"]); echo '
    '; if($ext=="pdf") echo ''; else echo ''; echo ''.$row['Name'].'
    '; } if($numrow >0 || $numrow2 >0) echo '
    '; } } ?>