Geeklog Forums

SELECT STRAIGHT_JOIN s.*, UNIX_TIMESTAMP(s.date) as day, u.username, u.fullname, u.photo, t.topic, t.imageurl FROM gl_stories as s, gl_users as u, gl_topics as t WHERE (s.uid = u.uid) AND (s.tid = t.tid) AND (date <= NOW()) AND (draft_flag = 0) AND s.tid = 'filmfests' AND s.tid != '' AND (s.perm_anon >= 2) AND (s.tid IN ('General','casting','reviews','fgroup','techtips','filmfests')) ORDER BY featured DESC, date DESC LIMIT 0, 5

SELECT STRAIGHT_JOIN s.*, UNIX_TIMESTAMP(s.date) as day, u.username, u.fullname, u.photo, t.topic, t.imageurl FROM gl_stories as s, gl_users as u, gl_topics as t WHERE (s.uid = u.uid) AND (s.tid = t.tid) AND (date <= NOW()) AND (draft_flag = 0) AND s.tid = 'General' AND s.tid != '' AND (s.perm_anon >= 2) AND 0 ORDER BY featured DESC, date DESC LIMIT 0, 5

if (!empty($U['aids'])) {
    if ($topic != $_CONF['archivetopic']) {
    $sql .= " AND s.tid != '{$_CONF['archivetopic']}' ";
}
}

SELECT tid FROM gl_topics WHERE (((owner_id = '69') AND (perm_owner >= 2)) OR ((group_id IN (2,17,13,3,18,16,15)) AND (perm_group >= 2)) OR (perm_members >= 2))

 if( sizeof( $tids ) > 0 )
    {
        $topicsql .= "({$table}tid IN ('" . implode( "','", $tids ) . "'))";
    }
    else
    {
        $topicsql .= '0';
    }

// +---------------------------------------------------------------------------+
// | LOCALE SETTINGS                                                           |
// |                                                                           |
// | see docs/config.html#locale for details                                   |
// +---------------------------------------------------------------------------+

$_CONF['language']        = 'english';
$_CONF['default_charset'] = 'iso-8859-1';

// Note: You may want to consider using 'utf-8' as the default character set
// for new sites, especially when using the multi-language support (see below).
// Make sure to use a matching language file, e.g. 'english_utf-8' then.

$_CONF['locale']          = 'en_GB';
$_CONF['date']            = '%A, %B %d %Y @ %I:%M %p %Z';
$_CONF['daytime']         = '%m/%d %I:%M%p';
$_CONF['shortdate']       = '%x';
$_CONF['dateonly']        = '%d-%b';
$_CONF['timeonly']        = '%I:%M%p';
$_CONF['week_start']      = 'Sun'; // can be 'Sun' or 'Mon'
$_CONF['hour_mode']       = 12;    // 12 hour am/pm or 24 hour format

// Number formatting
$_CONF['thousand_separator'] = ",";  // could be ' , . etc.
$_CONF['decimal_separator']  = ".";  // could be , . etc.
$_CONF['decimal_count']      = "2";  // if a number has decimals,
                                     //  force to this depth

// Multi-language support
// (note that this section is commented out - remove the '/*' and '*/' lines
//  below to activate it and make sure you understand what it does)
/*

// IMPORTANT!
// 1) Both the $_CONF['language_files'] and the $_CONF['languages'] arrays
//    (see below) must have the same number of elements.
// 2) The shortcuts used must be the same in both arrays.
// 3) All shortcuts must have the same length, e.g. 2 characters.

// The shortcuts are to be used in IDs of objects that are multi-language
// aware, e.g. /article.php/introduction_en and /article.php/introduction_de
// for the English and German version of an introductory article.

// Supported languages
// Maps a shortcut to a Geeklog language file (without the '.php' extension)
$_CONF['language_files'] = array (
    'en' => 'english_utf-8',
    'de' => 'german_formal_utf-8'
);

// Display names of supported languages
// Maps the same shortcuts as above to a language name. The language names
// are used to let users switch languages, e.g. in a drop-down menu.
$_CONF['languages'] = array (
    'en' => 'English',
    'de' => 'Deutsch'
);

*/