Scheduled Events Add-On

[april_may]

Yes, I get the same message no matter what code I've tried. Makes me wonder if something else is over-ridding it.

april_may

[dbltoe]

When you look in the database, is the table named events or something else? Perhaps zen_events?

[april_may]

it is zen_events



An unrelated question... you say the events roll off when expired. Is there a way to have an option to have them "reset" if the event is a monthly re-occuring event.
Example: I list 2nd Saturday Art Walk events. They are always on the 2nd sat of the month, so as soon as one expires and "rolls off" can it be programmed to re-set to show it for the next month?

april_may

[dbltoe]

Let's try this as the header_php.php

 <?php
// $Id: header_php.php 2008-12-31 08:07:26Z dbltoe $
require(DIR_WS_MODULES . zen_get_module_directory('require_languages.php'));

// include template specific file name defines
$define_page = zen_get_file_directory(DIR_WS_LANGUAGES . $_SESSION['language'] . '/html_includes/', FILENAME_DEFINE_EVENTS, 'false');

$result = $db->Execute("SELECT * FROM zen_events WHERE (EndDate >= NOW()-1) ORDER BY StartDate");
  $eventData = array();
  while (!$result->EOF) {
    $eventData[] = $result->fields;
    $result->MoveNext();
  }
$breadcrumb->add(NAVBAR_TITLE);  
?>

[april_may]

Tried it. Still does not work - still getting same error message

[april_may]

Could it be in the files where I copied and pasted rather than WinMerging?

in the informatio.php file I copied and pasted this code:

if (DEFINE_EVENTS_STATUS <= 1) {
$information[] = '<a href="' . zen_href_link(FILENAME_EVENTS) . '">' . BOX_INFORMATION_EVENTS . '</a>';
}

is this the ONLY code snip that you added to this file?
Maybe I am missing something here.

[dbltoe]

Tried it. Still does not work - still getting same error message

The EXACT SAME message as before or does it now contain "zen_events"?

[april_may]

exact same message as before... the error message has never changed no matter what code we've tried.

[april_may]

could this be it? In the extra_pages_filenames.php

?php
// $Id: extra_pages_filenames.php 2008-12-31 08:07:26Z dbltoe $
// define the extra page filenames
define('FILENAME_DEFINE_EVENTS', 'define_events');
define('FILENAME_EVENTS', 'events');
?>

should I change it to
define('FILENAME_EVENTS', 'zen_events');

[dbltoe]

No.
If you can hold off to later today after I get out of the flea market my wife talked me into, we'll look at this a little more in depth.