Login   Register  
PHP Classes
elePHPant
Icontem

File: class

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of CÚsar Bruschi  >  Translation and Dictionary  >  class  >  Download  
File: class
Role: Class source
Content type: text/plain
Description: Font code and doc
Class: Translation and Dictionary
Get application texts in several idioms from MySQL
Author: By
Last change: Accessible without user login
Date: 3 years ago
Size: 2,567 bytes
 

Contents

Class file image Download
<?php

class Dictionary {

    public 
$xWords = array();
    private 
$xTheme false;
    private 
$xLangName false;
    
    public function 
Dictionary($xTheme$xLangName "ENG"){

        
$this->xTheme $xTheme;
        
$this->xLangName $xLangName;
        
        return 
$this->getDictionary($xTheme$xLangName);
    }
        
    private function 
getDictionary($xTheme$xLangName){
        
        
$xSQL "SELECT DID.dictio_word as Word, IF((DIE.dictio_traslat IS NOT NULL) and (DIE.dictio_traslat <>''), DIE.dictio_traslat, DID.dictio_traslat) AS Translation
                FROM "
.TABLE_PREFIX."dictio DID
                INNER JOIN "
.TABLE_PREFIX."langs IDE ON (IDE.lang_name LIKE '".$xLangName."')
                INNER JOIN "
.TABLE_PREFIX."themes TE ON (TE.themes_id = DID.dictio_theme)
                LEFT JOIN "
.TABLE_PREFIX."dictio DIE ON (DID.dictio_word = DIE.dictio_word)
                AND (DID.dictio_theme = DIE.dictio_theme)
                AND (DIE.dictio_langid = IDE.lang_id)
                WHERE DID.dictio_langid = '0001'
                AND (TE.themes_theme LIKE '"
.$xTheme."%')";
        
        if(!
$query mysql_query($xSQL)) return mysql_error();
        if(!
mysql_num_rows($query)) return false;
        while(
$data mysql_fetch_assoc($query)){
            
$this->xWords[$data["Word"]] = $data["Translation"];
        }
        
        return 
$this->xWords;
        
    }
    
    public function 
getLanguages(){
        
        
$return = array();
        
        
$xSQL "SELECT * FROM ".TABLE_PREFIX."langs;";
        if(!
$query mysql_query($xSQL)) return 0;
        if(!
mysql_num_rows($query)) return 0;
        
        while(
$data mysql_fetch_assoc($query)){
            
$return[]['lang_id'] = array(
            
'lang_id' => $data["lang_id"],
            
'lang_name' => $data["lang_name"],
            
'lang_flag' => $data["lang_flag"],
            );
        }
        
        return 
$return;
    }
    
    public function 
getLanguagesBar(){
        
        
//El link para adjuntar a la imagen
        
$link "";
        foreach(
$_GET as $key => $value)
        if(
$key!="lang")
            
$link.= $key ."="$value ."&";
        
            
$link substr($link0, -1);
        
//$return = "<table><tr>";
        
$return "";
        
        
$xSQL "SELECT * FROM ".TABLE_PREFIX."langs;";
        if(!
$query mysql_query($xSQL)) return 0;
        if(!
mysql_num_rows($query)) return 0;
        
        while(
$data mysql_fetch_assoc($query)){
        
            
//$return .= "<td>
            
$return .= " <a href=\"".$_SERVER['PHP_SELF']."?lang=".$data['lang_name']."&".$link."\">
            <img src=\""
.$data['lang_flag']."\" border=\"0\" width=\"20\" height=\"15\" align=\"top\">
            </a>"
;
            
//</td>";
            
        
}
        
        
//$return .= "</tr></table>";
        
        
return $return;
    }

}

?>