Geeklog Forums

function COM_numArgs(){
    global $_URL;

    return $_URL->numArguments();
}
 

    // get position from stories query to account for 'after featured' position.
    if ($position == 2) {
        if (($where == 1) && ($_CONF['showfirstasfeatured'] == 0)) {
            if (!empty($topic)) {
                if (DB_count($_TABLES['stories'], array('featured', 'tid'), array(1, $topic)) < 1) {
                    // no featured story found - redefine position
                    $position = 1;
                }
            }
        }
    }

    // get position from stories query to account for 'after featured' position.
    if ($position == 2) {
        if (($where == 1) && ($_CONF['showfirstasfeatured'] == 0)) {
            if (!empty($topic)) {
                if (DB_count($_TABLES['stories'], array('featured', 'tid', 'draft_flag'), array(1, $topic, 0)) < 1) {
                    // no featured story found in topic - redefine position
                    $position = 1;
                }
            } else {//redefine position if no featured story on front page
                if (DB_count($_TABLES['stories'], array('featured', 'frontpage', 'draft_flag'), array(1, 1, 0)) < 1) {
                    // no featured story found - redefine position
                    $position = 1;
                }
            }
        } elseif ($where == 1) {
            if (!empty($topic)) {//redifine position if no featured story in topic page
                if (DB_count($_TABLES['stories'], array('featured', 'tid', 'draft_flag'), array(1, $topic, 0)) < 1) {
                    // no featured story found - redefine position
                    $position = 1;
                }
            } else {//redifine position if no featured story on front page
                if (DB_count($_TABLES['stories'], array('featured', 'frontpage', 'draft_flag'), array(1, 1, 0)) < 1) {
                    // no featured story found - redefine position
                    $position = 1;
                }
            }
        }
    }
 

COM_setArgNames(array('op','range','cat'));
$op = COM_applyFilter(COM_getArgument('op'));
$range = COM_applyFilter(COM_getArgument('range'),true);
$cat = COM_applyFilter(COM_getArgument('cat'),true);

if (!empty($cat)) {
    $catname = DB_getItem($_TABLES['evlist_categories'], 'name', "id = '$cat'");
}
 

COM_setArgNames(array('op','range','cat'));
$op = COM_applyFilter(COM_getArgument('op'));
$range = COM_applyFilter(COM_getArgument('range'),true);
$category = COM_applyFilter(COM_getArgument('cat'),true);

if (!empty($category)) {
    $catname = DB_getItem($_TABLES['evlist_categories'], 'name', "id = '$category'");
}
 

Sun 28 Oct 2007 07:54:30 MST - Registering evList plugin with Geeklog
Sun 28 Oct 2007 07:54:30 MST - Successfully installed the evList plugin!
Sun 28 Oct 2007 07:59:51 MST - 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT date_format FROM gl_evlist_settings)' at line 1. SQL in question: SELECT format FROM gl_evlist_dateformat WHERE id = (SELECT date_format FROM gl_evlist_settings)
Sun 28 Oct 2007 08:02:19 MST - 1062: Duplicate entry 'Birthday' for key 2. SQL in question: INSERT INTO gl_evlist_categories SET name = 'Birthday', status = '1'
Sun 28 Oct 2007 08:14:15 MST - 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIKE gl_evlist_events)' at line 2. SQL in question: CREATE TEMPORARY TABLE evlist_temp_events
                (LIKE gl_evlist_events)
Sun 28 Oct 2007 08:18:45 MST - 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT date_format FROM gl_evlist_settings)' at line 1. SQL in question: SELECT format FROM gl_evlist_dateformat WHERE id = (SELECT date_format FROM gl_evlist_settings)
Sun 28 Oct 2007 08:38:51 MST - 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIKE gl_evlist_events)' at line 2. SQL in question: CREATE TEMPORARY TABLE evlist_temp_events
                (LIKE gl_evlist_events)
Sun 28 Oct 2007 08:39:04 MST - 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIKE gl_evlist_events)' at line 2. SQL in question: CREATE TEMPORARY TABLE evlist_temp_events
                (LIKE gl_evlist_events)