<?php
class LangClass {
    
    var $connection;
    
    public function get_lang() {
        $user_lang = array();
        if (isset($_SERVER['HTTP_ACCEPT_LANGUAGE'])) {
            $http_lang_str = strtolower($_SERVER['HTTP_ACCEPT_LANGUAGE']);
            $http_lang_array = explode(",",$http_lang_str);
            $tag_lang_array = explode("-",$http_lang_array[0]);
        }
        if (isset($_COOKIE['lang_pref'])) {
            $user_lang[] = $_COOKIE['lang_pref'];
        } elseif (isset($http_lang_array)) {
            $user_lang[] = $http_lang_array[0];
        } else {
            $user_lang[] = "en";
        }
        $primary_lang = explode("-",$user_lang[0]);
        if (!isset($tag_lang_array[0])) {
            $user_lang[] = $user_lang[0];
        } elseif ($tag_lang_array[0] == $primary_lang[0]) {
            if (isset($tag_lang_array[1])) {
                $user_lang[] = $tag_lang_array[0]."-".strtoupper($tag_lang_array[1]);
            } else {
                $user_lang[] = $tag_lang_array[0];
            }
        } else {
            $user_lang[] = $user_lang[0];
        }
        return $user_lang;
    }

    function load_db($db) {
        $this->connection = mysql_connect($db['host'], $db['user'], $db['pass'], "SET NAMES 'utf8'") or die ("Unable to connect!");
        mysql_select_db($db['db_lang'], $this->connection) or die ("Unable to select database!");
        $utf8 = mysql_query("SET NAMES UTF8");
        return $this->connection;
    }
    
    public function load_lang($lang, $page) {
        $lang = mysql_real_escape_string($lang, $this->connection);
        $query = mysql_query("SELECT * FROM `$page` WHERE `lang`='$lang'", $this->connection);
        if (mysql_num_rows($query) == 0) {
            $lang_array = explode("-",$lang);
            $lang = $lang_array[0];
            $query = mysql_query("SELECT * FROM `$page` WHERE `lang`='$lang'", $this->connection);
            if (mysql_num_rows($query) == 0) {
                $query = mysql_query("SELECT * FROM `$page` WHERE `lang`='en'", $this->connection) or die("Unable to load lang set: en");
            }
        }
        $lang_array = mysql_fetch_array($query);
        return $lang_array;
    }

    public function close_db() {
        mysql_close($this->connection);
    }

}
?>