Geeklog Forums

<?php

$_languages = array (
  'en' => 'English',
  'he' => 'Hebrew'
);

$_languagefiles = array (
  'en' => 'english_utf-8',
  'he' => 'hebrew'
);

?>


 

function language() {
    global $_CONF, $_USER;
    if ( !empty ($_USER['language']))
        $retval = $_USER['language'];
    else if ( !empty ($_COOKIE['language']))
        $retval = $_COOKIE['language'];
    else
        $retval = $_CONF['language'];

    return $retval;
}


 

function phpblock_language()
{
    global $_CONF;
    include($_CONF['path'].'languages.php');

    $retval = '';

if ( !isset( $_COOKIE[$_CONF['cookie_language']]))
        $need_cookies_for_lang = '<br><font size=1>(Requires cookies)</font>';

        $lang = language();

    $retval .= '<form name="change" action="'. $_CONF['site_url'] . '/switchlang.php">';
    $retval .= '<input type="hidden" name="oldlang" value="' . substr($lang, 0, 2) . '">';
    $retval .= '<select onchange="change.submit()" name="lang">';

foreach ($_languages as $key=>$value) {
if ($lang == $_languagefiles[$key])
$selected = " selected";
else $selected = "";
    $retval .= '<option value="' . $key . '"' . $selected. '>' . $value . '</option>';
}
    $retval .= '</select>';
if (isset($need_cookies_for_lang)) $retval .= $need_cookies_for_lang;
    $retval .= '</form>';

    return $retval;
}


 

<?php

/* Reminder: always indent with 4 spaces (no tabs). */
// +---------------------------------------------------------------------------+
// | Geeklog 1.4                                                               |
// +---------------------------------------------------------------------------+
// | switchLang.php                                                            |
// | Switches between translation files.                                       |
// |                                                                           |
// | Copyright (C) 2006 by the following author:   |
// | http://lior.weissbrod.com                                      |
// +---------------------------------------------------------------------------+
// | Copyright (C) 2000-2003 by the following authors:                         |
// |                                                                           |
// | Authors: Stratos Gerakakis     - admin@stratosgear.com                    |
// |          Robert Dobozy         - robogl7@robod.net                        |
// +---------------------------------------------------------------------------+
// |                                                                           |
// | 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 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.           |
// |                                                                           |
// +---------------------------------------------------------------------------+
//

include_once('lib-common.php');
include($_CONF['path'].'languages.php');

//If not allowed, just ignore and return
if ($_CONF['allow_user_language'] == 1) {

    if (isset($_REQUEST['oldlang'])) {
        $oldlang = strtolower(COM_applyFilter($_REQUEST['oldlang']));
    }

    // do we really have a new language to switch to?
    if (isset($_REQUEST['lang'])) {
        $lang = strtolower(COM_applyFilter($_REQUEST['lang']));

    // does it exist in our current translation list?
        if( is_file( $_CONF['path_language'] . $_languagefiles[$lang] . '.php' )) {

        // Set the language cookie.
        // Mainly used for the anonymous user so the rest of his session
        // will remain in his selected language
            setcookie ($_CONF['cookie_language'], $_languagefiles[$lang],
                       time() + 31536000, $_CONF['cookie_path'],
                       $_CONF['cookiedomain'], $_CONF['cookiesecure']);

        // if he is not anonymous, store the preference in the database
            if ($_USER['uid'] > 1) {
                DB_query("UPDATE {$_TABLES['users']} SET language='{$_languagefiles[$lang]}'

WHERE uid = {$_USER['uid']}");
            }
        }
    }
}

// If the user came from within your site, send them back to the referrer page
if (isset($_SERVER['HTTP_REFERER']))
if (strpos($_SERVER['HTTP_REFERER'], $_CONF['site_url']) !== false) {
$ret = $_SERVER['HTTP_REFERER'];

// Change the language's ID if needed
if (isset($lang) && isset($oldlang)) {
if (strpos($ret, '&') !== false) {
$ret = split("&", $ret);
$extra_vars = "&" . $ret[1];
$ret = $ret[0];
} else $extra_vars = '';

if (substr($ret, -3) == '_' . $oldlang)
$ret = substr_replace($ret, $lang, -2);

$ret .= $extra_vars;
}
}

// If the user didn't come from within your site, send them to your main page
if (!isset($ret))
$ret = $_CONF['site_url'] . '/';

Header("Location: $ret");
?>


 

$sql = " (date <= NOW()) AND (draft_flag = 0)";

// custom code - start
if (empty($topic)) {

    $lang = "%_" . substr(language(), 0, 2);

    $sql .= " AND s.tid LIKE '$lang' ";
}
// custom code - end

// if a topic was provided only select those stories.
if (!empty($topic)) {


 

    $sql = "SELECT tid,topic,imageurl FROM {$_TABLES['topics']}";
// custom code - start
    $lang = "%_" . substr(language(), 0, 2);
    $sql .= " WHERE tid LIKE '$lang' ";
// custom code - end
    if( $_USER['uid'] > 1 )
    {
        $tids = DB_getItem( $_TABLES['userindex'], 'tids',
                            "uid = '{$_USER['uid']}'" );
        if( !empty( $tids ))
        {
// custom code - start
            $sql .= " AND (tid NOT IN ('" . str_replace( ' ', "','", $tids )
                 . "'))" . COM_getPermSQL( 'AND' );
// custom code - end
        }
        else
        {
// custom code - start
            $sql .= COM_getPermSQL( 'AND' );
// custom code - end
        }
    }
    else
    {
// custom code - start
            $sql .= COM_getPermSQL( 'AND' );
// custom code - end
    }
    if( $_CONF['sortmethod'] == 'alpha' )


 

    else
    {
// custom code - start
    $lang = "%_" . substr(language(), 0, 2);
    $sql = "AND qid LIKE '$lang' ";
        $result = DB_query( "SELECT qid from {$_TABLES['pollquestions']} WHERE display = 1 $sql ORDER BY date DESC" );
// custom code - end
        $nrows = DB_numRows( $result );


 

// custom code - start
    $lang = "%_" . substr(language(), 0, 2);
    $sql = "AND qid LIKE '$lang' ";
    $question = DB_query( "SELECT question,voters,commentcode,owner_id,group_id,perm_owner,perm_group,perm_members,perm_anon FROM {$_TABLES['pollquestions']} WHERE qid='$qid' $sql" );
// custom code - end
    $Q = DB_fetchArray( $question );


 

// custom code - start
    $lang = "%_" . substr(language(), 0, 2);
    $sql = "qid LIKE '$lang' ";
        $query_arr = array('table' => 'pollquestions',
                           'sql' => $sql = "SELECT *,UNIX_TIMESTAMP(date) as unixdate, display FROM {$_TABLES['pollquestions']} WHERE $sql",
// custom code - end
                           'query_fields' => array('question'),