Robbie,
Check out post 172 in this thread.

171:blush:

dbltoe:

171:blush:

I tried that and it did not work.
I had an event that finished yesterday that disappeared prematurely so I used the CURDATE option. It solved it disappearing yesterday but it didn't disappear today when it should have.
I will try again in case I did something wrong.

No it is still not working.
The page is: http://www.thehorsestall.com.au/store/index.php?main_page=events still with the CURDATE. Where does it pick up the current date? From the PC or somewhere else?

With your server in Sydney, there shouldn't be a problem with your time matching the server.
Must be an error in the code as it doesn't even flip at midnight here.
Can you post your header_php.php here?

dbltoe:

With your server in Sydney, there shouldn't be a problem with your time matching the server.
Must be an error in the code as it doesn't even flip at midnight here.
Can you post your header_php.php here?

<?php
/**
 * @package Header for Scheduled Events 1.6
 * @copyright Copyright 2003-2006 Zen Cart Development Team
 * @copyright Portions Copyright 2003 osCommerce
 * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
 * @version $Id: header_php.php 3001 2012-01-18 11:45:06Z 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 " . TABLE_EVENTS . " WHERE (event_stop >= CURDATE()-1) ORDER BY event_start");
  $eventData = array();
  while (!$result->EOF) {
    $eventData[] = $result->fields;
    $result->MoveNext();
  }
$breadcrumb->add(NAVBAR_TITLE);  
?>

It is the latest one with only the CURDATE change.

gemae:

I am having the same problem as some others have had regarding the DB is saving but NOT displaying on the site. I have tried all the updated files in the posts and it is still not working... please help, my url is http://azadapparel.com/index.php?main_page=events

Check how you are entering your dates: I was having the same problem I was entering 03 09 2012 but I should have been entering the year first- Basically It wouldn't show up because it was saying the event ended already.

BethDog:

Check how you are entering your dates: I was having the same problem I was entering 03 09 2012 but I should have been entering the year first- Basically It wouldn't show up because it was saying the event ended already.

Each time a date is required, the form clearly shows yyyy-mm-dd as the example:mellow:

dbltoe:

You can add them one of two ways.

Create an extra field in the events table called images or enter the image into one of the other categories. Comments, Special, and Location will all accept 200 or more characters so a link should work in any of those.

If you create an extra field, make sure the type is varchar, the length is 255, and the Allow Null is checked. Then, you'd need to edit the includes/templates/CUSTOM/templates/tpl_events_default.php to add the display of the image field.

Either way, you'll enter html link code for the picture you plan to use. Enclosing them in a div with an id or class will allow you to control the image with the stylesheet.

Remember to use relative links and that the image must be in an accessible directory of your site.

HTH

I would like a little more direction with this please I don't know SQL very well, however, I am good at following directions and I can edit the php files pretty well... I have gotten this wonderful addon to work with my site now and would love to be able to put at least one image (preferably multiple images) for the events on the page with the descriptions. I'm probably making this too difficult but please help, thank you!

my site is http://azadapparel.com/index.php?main_page=events

Very useful plugin... Thanks dbltoe...

However... I just downloaded and unzipped it, and after installing, found that the COMMENTS field was not showing on the web page.

So I looked in the SQL and see:

CREATE TABLE zen_events (
event_id bigint(20) NOT NULL auto_increment,
event_name varchar(100) default NULL,
event_location varchar(75) default NULL,
event_start datetime default NULL,
event_stop datetime default NULL,
**event_comment** varchar(255) default NULL,
event_booth_location varchar(255) default NULL,
special_text varchar(200) default NULL,
map varchar(255) default NULL,

Then I look in tpl_events_default.php and see:

• if ($eventInfo['event_location'] != '') echo "<strong>Place: </strong>" . $eventInfo["event_location"] . "<br />";
  if ($eventInfo['event_start'] != '') echo "<strong>Start Date: </strong>" . zen_date_long($eventInfo["event_start"]) . "<br />";
  if ($eventInfo['event_stop'] != '') echo "<strong>Stop Date: </strong>" . zen_date_long($eventInfo["event_stop"]) . "<br />";
  if ($eventInfo['event_comments'] != '') echo "<strong>Comments: </strong>" . $eventInfo["Comments"] . "<br />";
  if ($eventInfo['event_booth_location'] != '') echo "<strong>Booth Location: </strong>" . $eventInfo["event_booth_location"] . "<br />";
  if ($eventInfo['special_text'] != '') echo "<strong>Special: </strong>" . $eventInfo["special_text"] . "<br />";
  if ($eventInfo['map'] != '') echo "<strong><a href=" . $eventInfo["map"] . ' target="_blank">Driving Directions</a></strong>';
  echo "</blockquote><hr />";*

So I change to:-

*// Display the text of each event in a paragraph
foreach($eventData as $eventInfo) {
echo "<h5>" . $eventInfo["event_name"] . "</h5><hr />";
echo "<blockquote>";
if ($eventInfo['event_location'] != '') echo "<strong>Place: </strong>" . $eventInfo["event_location"] . "<br />";
if ($eventInfo['event_start'] != '') echo "<strong>Start Date: </strong>" . zen_date_long($eventInfo["event_start"]) . "<br />";
if ($eventInfo['event_stop'] != '') echo "<strong>Stop Date: </strong>" . zen_date_long($eventInfo["event_stop"]) . "<br />";
if ($eventInfo['event_comment'] != '') echo "<strong>Comments: </strong>" . $eventInfo["event_comment"] . "<br />";
if ($eventInfo['event_booth_location'] != '') echo "<strong>Booth Location: </strong>" . $eventInfo["event_booth_location"] . "<br />";
if ($eventInfo['special_text'] != '') echo "<strong>Special: </strong>" . $eventInfo["special_text"] . "<br />";
if ($eventInfo['map'] != '') echo "<strong><a href=" . $eventInfo["map"] . ' target="_blank">Driving Directions</a></strong>';
echo "</blockquote><hr />";
} *

... and everything now works...

Can't remember if I ever thanked you for making this Mod/Add-on. Works great with an easy enough set-up.
After playing around with it I have the layout just the way I want, for now anyway...

Thanks again Billy

Thanks for the add on, I installed to blue cart zen 1.5, It is working well. Question. How can I change some of the DB fields like words start time for instance.

Great Mod - not much happening since July I see.

I installed the mod on 1.5 downloaded from the plugin area which states it is for 1.5 - it works fine on pretty much every aspect, however the Google Maps do not work regardless of the URL I use from Google Maps.

It shows as text (As the entire URL) and NOT a clickable link.

the tpl_events_default.php shows that it SHOULD show as a link as the code appears correct (at least to me):

if ($eventInfo['map'] != '') echo "<strong><a href=" . $eventInfo["map"] . ' target="_blank">Driving Directions</a></strong>';

Any suggestions?

IGNORE PREVIOUS LACK OF SLEEP POST!
I was looking at eventz/index.php where you enter and not the actual LISTING link... I have been at this too long

bubbadan:

IGNORE PREVIOUS LACK OF SLEEP POST!
I was looking at eventz/index.php where you enter and not the actual LISTING link... I have been at this too longGlad you got it going.

Just a suggestion to help with your entries.

When you click on the link button in Google Maps, also check the box for Short URL. That way the church's URL would be http://goo.gl/maps/hmZNQ. You'll note the absence of special characters. That can make a big difference depending on the encoding of the database. There are no special characters in the Google short URL.:yes:

pageblair:

Thanks for the add on, I installed to blue cart zen 1.5, It is working well. Question. How can I change some of the DB fields like words start time for instance.
All those are in the includes/templates/CUSTOM/templates/tpl_events_default.php. After each echo in the if statements you'll find the item title in quotes. i.e., > echo "<strong>Start Date: </strong>"could become > echo "<strong>Start Time: </strong>"HOWEVER, you will also need to change the zen_date_long as you would no longer be showing a date.

Sorry, I've missed some of the comments in this thread but I have not been receiving notices for some reason. Working on it now.

schoolboy -- thanx for the heads up. I am going with changing the sql setup as I want folks to know it can take more than one comment.

hi there,
i am installing this mod on a xampp local server for testing purposes and i get the exact same error message:

MySQL error 1054

Unknown column 'PMEtable0.event_comment' in 'field list'

[/HR]

phpMyEdit error: invalid SQL query

[/HR]SELECT PMEtable0.event_id AS qf0,PMEtable0.event_name AS qf1,PMEtable0.event_location AS qf2,PMEtable0.event_start AS qf3,PMEtable0.event_stop AS qf4,PMEtable0.event_comment AS qf5,PMEtable0.event_booth_location AS qf6,PMEtable0.special_text AS qf7,PMEtable0.map AS qf8 FROM zen_events AS PMEtable0 ORDER BY PMEtable0.event_id LIMIT 0, 1530.182 miliseconds

I am running ZC 1.5.1, installed the very latest update mod (already checked that the index.php is correct)
Xampp 1.8.1
PHP 5.4.7
MySQL 5.5.27

i have installed all from scratch and dont seem to get rid of the error above.
appreciate any suggestions, thanks a lot!

pukram:

hi there,
i am installing this mod on a xampp local server for testing purposes and i get the exact same error message:
MySQL error 1054

Unknown column 'PMEtable0.event_comment' in 'field list'

[/HR]phpMyEdit error: invalid SQL query

[/HR]SELECT PMEtable0.event_id AS qf0,PMEtable0.event_name AS qf1,PMEtable0.event_location AS qf2,PMEtable0.event_start AS qf3,PMEtable0.event_stop AS qf4,PMEtable0.event_comment AS qf5,PMEtable0.event_booth_location AS qf6,PMEtable0.special_text AS qf7,PMEtable0.map AS qf8 FROM zen_events AS PMEtable0 ORDER BY PMEtable0.event_id LIMIT 0, 1530.182 miliseconds

I am running ZC 1.5.1, installed the very latest update mod (already checked that the index.php is correct)
Xampp 1.8.1
PHP 5.4.7
MySQL 5.5.27

i have installed all from scratch and dont seem to get rid of the error above.
appreciate any suggestions, thanks a lot!

hmmm... got it solved - despite the new index the field "event_comments" was written "event_comment" somehow (figured out when entering data in the DB directly, it had the right spelling |event_comments" but the comment itself would not appear on the scheduled event page of the web site...

well, sorted out by now! thanks for the mod :)

Does anyone have this working (with actual upcoming events) where i can see what it looks like? Thanks, Leslie