hostname, $config->username, $config->password) or die('Unabale to connect to the database'); mysql_select_db($config->db_name) 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 si sinteza 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 homeContent() { echo '

    Position

    Assistant Professor

    Technical University of Cluj-Napoca
    Faculty of Electronics, Telecommunications and Information Technology - Communications Department

    Microprocessors Systems Design, Signal Processors,
    Speech Analysis and Synthesis Group
    Contact
    Dorobantilor 73, room 211b, Cluj-Napoca, Romania Simina.Emerich@com.utcluj.ro
    '; } 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 '
    '; } } ?>