Welcome to Geeklog, Anonymous Thursday, March 28 2024 @ 03:55 pm EDT

Geeklog Forums

evList is available now!

Page navigation


Status: Banned

machinari

Forum User
Full Member
Registered: 03/22/04
Posts: 1512

find the file here. evList is a calendar alternative. It is an event list.

    features:
  • presents a well formatted list of events foregoing the bulky calendar tables.
  • user friendly admin panels.
  • php block to display various event ranges (default: upcoming events).
  • numerous editor fields to ensure that no information is lacking.
  • flexibility in which fields are required and which are not.
  • supports recurring events and multiple formats for recurring events.
  • supports split events, and all day events.
  • supports gl autotags, stats, search and various other gl integrations.
  • supports event categories and multiple categories per event.
  • a script is provided that can import your current gl calendar events for use alongside or instead of the calendar (will not delete them from the calendar's db table).
  • default events display various functions of evList.
  • ...but I forgot the install instructions.
  • find the file here.
 Quote

geekdude

Anonymous
angry
Too bad it won't install SQL errors... Hacked through those but it won't run either, more SQL errors

Thu Sep 27 14:08:24 2007 - 1242: Subquery returns more than 1 row. SQL in question: SELECT format FROM gl_evlist_dateformat WHERE id = (SELECT date_format FROM gl_evlist_settings)

Did anyone actually test this before released
 Quote

Status: Banned

machinari

Forum User
Full Member
Registered: 03/22/04
Posts: 1512
thanks for your 2cents, but i'm not really interested in your anonymous attitude. it has been uninstalled and installed about 22 times in the last 2 weeks without issue. I've been the only one testing and it works great.

The only bug i've found so far that hasn't been fixed is in the category management page. and it's not one that breaks the plugin, just makes creation an extra click or two.

about your error: your settings table should only have one row, which means you screwed up the install and left the table before you installed it again. remove the extra row(s).
 Quote

Status: Banned

machinari

Forum User
Full Member
Registered: 03/22/04
Posts: 1512
whoops. had a quick look and the last change i made before i tarred it up double up on the default values being installed.
here is what is was:
Text Formatted Code
// Default data
// Insert table name and sql to insert default data for your plugin.
// This will create the block definition and set the default user preferences

$DEFVALUES = array();
$DEFVALUES[] = "INSERT INTO {$_TABLES['evlist_categories']} VALUES ('','General','0'),('','Birthdays','0'),('','Seminars','0')";
$DEFVALUES[] = "INSERT INTO {$_TABLES['evlist_settings']} SET
    usermenu_option='1',
    week_begins='1'";
$DEFVALUES[] = "INSERT INTO {$_TABLES['blocks']} SET
    is_enabled='0',
    name='evlist',
    type='phpblock',
    title='{$LANG_EVLIST05[2]}',
    tid='all',
    blockorder='255',
    onleft='1',
    phpblockfn='phpblock_evlist_upcoming'";
 

remove the categories and settings inserts like so:
Text Formatted Code
// Default data
// Insert table name and sql to insert default data for your plugin.
// This will create the block definition and set the default user preferences

$DEFVALUES = array();
$DEFVALUES[] = "INSERT INTO {$_TABLES['blocks']} SET
    is_enabled='0',
    name='evlist',
    type='phpblock',
    title='{$LANG_EVLIST05[2]}',
    tid='all',
    blockorder='255',
    onleft='1',
    phpblockfn='phpblock_evlist_upcoming'";
 
 Quote

Status: Banned

machinari

Forum User
Full Member
Registered: 03/22/04
Posts: 1512
I've just uploaded the fixed archive. look for version 1.0.1 in the downloads section.
 Quote

chump

Anonymous
Thanks for the work; however I am geting a error on the plugin install. Error stats :1264: Out of range value adjusted for column 'id' at row 1. SQL in question:

Any ideas?

PHP 5.x
MySQL 5.x
IIS 6

 Quote

Chump

Anonymous
Commented out the following from my.ini and restarted MySQL.

#sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

Installed fine.
 Quote

Status: Banned

machinari

Forum User
Full Member
Registered: 03/22/04
Posts: 1512
good to know. Thanks for that.
I was at a loss Oops!
 Quote

Status: Banned

machinari

Forum User
Full Member
Registered: 03/22/04
Posts: 1512
k, not totally lost.
it was caused by the empty strings being inserted (default values) into the INT column of the categories table.

It doesn't hurt to supply id's for those few default inserts (e.g., 1,2, and 3). Removing the default values for the categories all together also wont hurt. They're just examples anyway.

So if you want to run mySQL 5 in strict mode (which really you should want to) then you can expect more of these errors. I'll have to rewrite a small number of queries to deal with it.
 Quote

geekdude

Anonymous
smart

it has been uninstalled and installed about 22 times in the last 2 weeks without issue. I've been the only one testing and it works great.

whoops. had a quick look and the last change i made before i tarred it up double up on the default values being installed.


that answer my question. i would hav done the testing after the changes. no mysql5 support either, nice.
 Quote

Status: Banned

machinari

Forum User
Full Member
Registered: 03/22/04
Posts: 1512
Quote by: geekdude
that answer my question. i would hav done the testing after the changes. no mysql5 support either, nice.[/p]

more anonymous attitude, nice. So go do some testing and quit complaining. nobody's forcing you to use it and you're getting it for free so I really don't understand why you're being such a jerk--though I have a theory.

 Quote

Status: offline

DTrumbower

Forum User
Moderator
Registered: 01/08/03
Posts: 507
When trying to edit an existing event, I get the following.

Text Formatted Code
Fatal error: Call to undefined function: sec_getgroupdropdown() in /var/www/fvyha.com/geeklog14/public_html/evlist/event.php on line 690
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
That function was only introduced in Geeklog 1.4.1. So I guess that's the minimum requirement for this plugin (and should probably be checked during installation).

bye, Dirk
 Quote

Status: Banned

machinari

Forum User
Full Member
Registered: 03/22/04
Posts: 1512
the file name should probably tip you off that 1.4.1 is required. "evlist_1.0.1_1.4.1.tar.gz".
guess I can throw a "if function_exists" check into the routine.
 Quote

Status: offline

Blaine

Forum User
Moderator
Registered: 07/16/02
Posts: 1232
Location:Canada
It's probably best to use this function in the install.php and test for the existance of the function before the user is allowed to install it.

function plugin_compatible_with_this_geeklog_version ()
{
return true;
}
Geeklog components by PortalParts -- www.portalparts.com
 Quote

Status: Banned

machinari

Forum User
Full Member
Registered: 03/22/04
Posts: 1512
found another minor bug: when centerblock is set to appear after featured story it actually appears at the top of the page as well as after the featured story. that kinda sucks.
It was just a misplaced curly brace--sorry.

Find the following in plugin_centerblock_evlist():
Text Formatted Code

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

and change it to this:
Text Formatted Code

    // 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;
                }
            }
        }
    }
 
 Quote

Status: Banned

machinari

Forum User
Full Member
Registered: 03/22/04
Posts: 1512
Confused one more.
a couple of date displays weren't being formatted according to the config's setting.

in event.php, evlist_display_event() find the following:
Text Formatted Code

            $A['date_end1'] = (!empty($A['date_end1']) && $A['date_end1'] != '0000-00-00') ? date("Y-m-d", strtotime($A['date_end1']) + $timediff) : '';
            $A['date_start2'] = (!empty($A['date_start2']) && $A['date_start2'] != '0000-00-00') ? date("Y-m-d", strtotime($A['date_start2']) + $timediff) : '';
            $A['date_end2'] = (!empty($A['date_end2']) && $A['date_end2'] != '0000-00-00') ? date("Y-m-d", strtotime($A['date_end2']) + $timediff) : '';
 

and change to this:
Text Formatted Code

            $A['date_end1'] = (!empty($A['date_end1']) && $A['date_end1'] != '0000-00-00') ? evlist_displayFormatedDate(strtotime($A['date_end1']) + $timediff) : '';
            $A['date_start2'] = (!empty($A['date_start2']) && $A['date_start2'] != '0000-00-00') ? evlist_displayFormatedDate(strtotime($A['date_start2']) + $timediff) : '';
            $A['date_end2'] = (!empty($A['date_end2']) && $A['date_end2'] != '0000-00-00') ? evlist_displayFormatedDate(strtotime($A['date_end2']) + $timediff) : '';
 
 Quote

Status: Banned

machinari

Forum User
Full Member
Registered: 03/22/04
Posts: 1512
Quote by: Blaine

It's probably best to use this function in the install.php and test for the existance of the function before the user is allowed to install it.

function plugin_compatible_with_this_geeklog_version ()
{
return true;
}


apparently I did have this defined in my install.php, but never finished it. Must've been distracted.
 Quote

Status: offline

casper

Forum User
Full Member
Registered: 02/11/04
Posts: 142
Location:Skien, Norway
Hey Machinari!

Nice plugin, have tested it a bit now and found it to suit some needs :ThumbsUp:

One problem though:
I have url_rewrite enabled, and that does not work well in evlist for me.
When clicking on an event I get redirected to the event listing instead of the details for the event,
and the profile-link also gets messed up.
what do I need to do solve this?
 Quote

Status: Banned

machinari

Forum User
Full Member
Registered: 03/22/04
Posts: 1512
My bad--obviously.
I used COM_buildURL() with the intention that I would support url_rewrite and I neglected to follow it through.
I'll fix it up and shoot you a new file probably by tomorrow.

thanks for the heads up.
 Quote

Page navigation

All times are EDT. The time is now 03:55 pm.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content