citywebshop_cms/application/helpers/lang.php

<?php

//Language translator layer

class lang {
    
    static function dbconnect() {
        global $config;
        global $conn;
        $conn = mysqli_connect($config['db_host'],$config['db_username'],$config['db_password'],$config['db_name']);
        mysqli_query($conn,"SET NAMES utf8");
        //mysqli_query($conn,"SET CHARACTER utf8");

        return true;
    }


    static function _($txt='') {
        self::dbconnect();
        global $conn;

        if ($txt!='') {
            $res = mysqli_query($conn,"select * from azonics_translations where translation_name='".$txt."' and translation_language='".$_SESSION['admin_lang']."' and translation_status='1' limit 0,1;");
            if (mysqli_num_rows($res)>0) {
                $row = mysqli_fetch_array($res);
                return $row['translation_text'];
            }
            else {
                return $txt;
            }
        }
        else {
            return $txt;
        }
    }


}