func_preference.php

Dokumenacija za ovu datoteku.

<?
/**************************************************************************************
 studentski Informacijski servis, 2004
 **************************************************************************************
 func_preference.php
 repozitorij funkcija za prikupljanje cesto neophodnih podataka
 vezanih za studenta


 Srdjan Segvic - srle
 **************************************************************************************
 **************************************************************************************
 This program is free software; you can redistribute it and/or modify
 it under the terms of the GNU General Public License as published by
 the Free Software Foundation; either version 2 of the License, or
 (at your option) any later version.

 This program is distributed in the hope that it will be useful,
 but WITHOUT ANY WARRANTY; without even the implied warranty of
 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 GNU Library General Public License for more details.

 You should have received a copy of the GNU General Public License
 along with this program; if not, write to the Free Software
 Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
 **************************************************************************************/
 //
 // funkcija vraca podeseni semestar pocetka pracenja predmeta
 //
 function getSemestarPocetak($id){
                                                                        
                        $query = "SELECT semestar_pocetak
                                          FROM  preference_studenta
                                          WHERE student_ID = '$id'";
                                          
                                                                                                 
                        $result = mysql_query($query) or
                                                         die(mysql_error());                                            
                                                                 
                        $row = mysql_fetch_array($result);      
                         
                return($row[0]);
         }

 //
 // funkcija vraca podeseni semestar kraja pracenja predmeta
 //
 function getSemestarKraj($id){                                         
                        
                        $query =
                                "SELECT semestar
                                 FROM  status_studenta
                                 WHERE student_ID = '$id'
                                 AND     datum_kraja = '0000-00-00'";


                        $result = mysql_query($query) or
                                                         die(mysql_error());

                        $row = mysql_fetch_array($result);

                return($row[0]);
         }

 //
 // funkcija vraca odabrani jezik sucelja
 //
 function getLang($id){
                 $query = "SELECT jezik
                                   FROM preference_studenta
                                   WHERE student_ID = '$id'";
                  
                  $result = mysql_query($query) or
                                        die(mysql_error());                                             
                                                                 
                  $row = mysql_fetch_array($result);    
                         
              return($row[0]);
          }

 //
 // funkcija vraca formatirani oblik semestra
 //
 function toRim($broj){
                switch ($broj){
                        case 1: return "I";
                        break;;
                
                        case 2: return "II";
                        break;;
                
                        case 3: return "III";
                        break;;
                
                        case 4: return "IV";
                        break;;
                
                        case 5: return "V";
                        break;;
                
                        case 6: return "VI";
                        break;;
                
                        case 7: return "VII";
                        break;;
                
                        case 8: return "VIII";
                        break;;
                
                        case 9: return "IX";
                        break;;
                
                        case 10: return "X";
                        break;;

                        case "A": return "Apsolventski";
                        break;;
        }
}
 //
 // funkcija vraca direktorij u kojem su slike za odabranu temu
 //
 function getImageDir($id){
                 $query = "SELECT  teme.naziv_teme
                           FROM    teme, preference_studenta
                           WHERE   preference_studenta.student_ID = '$id'
                           AND     teme.teme_ID = preference_studenta.teme_ID";
                  
                  $result = mysql_query($query) or
                                        die(mysql_error());                                             
                                                                 
                  $row = mysql_fetch_array($result);    
                         
              return($row[0]);
          }

 //
 // funkcija vraca odabranu boju teme
 //
function getColor($id, $nr){
                        
                        $select = "color".$nr; 
                        
                        $query_color = "SELECT teme.$select
                                        FROM teme, preference_studenta
                                        WHERE preference_studenta.student_ID = '$id'
                                        AND   teme.teme_ID = preference_studenta.teme_ID";
                                                                                                 
                        $result_color = mysql_query($query_color) or
                                                                         die(mysql_error());                                            
                                                                 
                        $row_color = mysql_fetch_array($result_color);  
                                                                
                return($row_color[0]);
         }

 //
 // funkcija vraca odabranu boju texta teme
 //
function getTextColor($id, $nr){
                        
                        $select = "text_color".$nr; 
                        
                        $query_color = "SELECT teme.$select
                                        FROM teme, preference_studenta
                                        WHERE preference_studenta.student_ID = '$id'
                                        AND   teme.teme_ID = preference_studenta.teme_ID";
                                                                                                 
                        $result_color = mysql_query($query_color) or die(mysql_error());

                        $row_color = mysql_fetch_array($result_color);
                                                                
                return($row_color[0]);
         }

 //
 // funkcija vraca odabranu pozadinsku boju teme
 //
function getBgColor($id, $nr){
                        
                        $select = "bg_color".$nr; 
                        
                        $query_color = "SELECT teme.$select
                                        FROM teme, preference_studenta
                                        WHERE preference_studenta.student_ID = '$id'
                                        AND   teme.teme_ID = preference_studenta.teme_ID";
                                                                                                 
                        $result_color = mysql_query($query_color) or
                                                                         die(mysql_error());                                            
                                                                 
                        $row_color = mysql_fetch_array($result_color);  
                                                                
                return($row_color[0]);
         }

 //
 // funkcija vraca podeseni broj obavjestenja po stranici
 //
function getObavPerPage($id){
                        
                        $query_ppage = "SELECT obav_postranici
                                        FROM   preference_studenta
                                        WHERE  student_ID = '$id'";
         
                        $result_ppage = mysql_query($query_ppage) or die(mysql_error());

                        $row_ppage = mysql_fetch_array($result_ppage);  

                return($row_ppage[0]);
         }

?>       

---