Scheduled Events Add-On

[dbltoe]

@matzgmb - To be more informative, there were plans to move all processes of this mod to the admin, but the changes in 1.5.0 put that on hold till registration is better understood and we can verify that PCI and sanitation will not be broken. All are advised to rename the folder for now and, in some cases, an underscore can be added to the beginning of the directory name. As it is now, the database connection passes PCI scan in all the stores we've installed it in. Of course, you could always put it in it's own database.

@gemae - That would be a major change to the concept that events are helpful "Information" for the customer. Of course, the beauty of open source is that you can "adjust as required."

@slingblade01 - There is no database correlation between the event table and purchases. Even an extraction of orders made during event dates could not provide accurate numbers without knowing if all orders were, in fact, because of the event and not just someone arriving after searching Google.

@jazzman2 - If you are having problems with one-day events or events dropping off the list early, you might find this fix will work.

In includes/modules/pages/events/header_php.php find

$result = $db->Execute("SELECT * FROM " . TABLE_EVENTS . " WHERE (event_stop >= NOW()-1) ORDER BY event_start");

and replace with

$result = $db->Execute("SELECT * FROM " . TABLE_EVENTS . " WHERE (event_stop >= CURDATE()-1) ORDER BY event_start");

Since some ISO's work the date differently, it's a better way of handling the event_stop date anyway.
If we learn from our mistakes, shouldn't I have multiple doctorates by now?

[Serg]

Hello everyone! I was wondering if there's any way to edit the admin. i love the mod and how it looks but there's stuff i don't really need. i just want it to say

Event Name
Location
Date
Time
Details

Can someone help me? My PHP knowledge is very limited.

Thank you!

[dbltoe]

Hello Serg, everyone here.
Scheduled events is set so that some items will not appear in the listing if nothing is added to that field in the database. For instance, Driving Directions will not appear unless something is entered in the map field in the form.
There is one problem in your case. The lack of a Stop Date (event_stop) will break the operation as the mod needs to know the stop date in order to stop showing the event.
The display file that sets the titles of each item is located in includes/templates/YOUR_CUSTOM/templates/tpl_events_default.php. What you are wanting to change starts around line 14.
As an example, if you wanted to say Location instead of Place, you would change

if ($eventInfo['event_location'] != '') echo "<strong>Place: </strong>" . $eventInfo["event_location"] . "<br />";

to

if ($eventInfo['event_location'] != '') echo "<strong>Location: </strong>" . $eventInfo["event_location"] . "<br />";

Changing

if ($eventInfo['event_comments'] != '') echo "<strong>Comments: </strong>" . $eventInfo["Comments"] . "<br />";

to

if ($eventInfo['event_comments'] != '') echo "<strong>Details: </strong>" . $eventInfo["Comments"] . "<br />";

would fix your need for a Details item.
Of course, you can switch the order of any of those to make them show up in the order you want for your site.

[Serg]

Thank you so much everyone! Haha. I will try that tomorrow, my eyes hurt at the moment. I'll see how it goes!

[Serg]

How do i add the event time? and for the 'Details' why is there a limit on how many characters I can have? There's a lot of details i need to put there. thank you!

[Serg]

Nevermind, i figured out the chararecters, But i can't do the time. is there a way to hide the end date? so it only says Start Date?
thank you!

[dbltoe]

Any one of the unused items could be used to report a time. You would have to modify the table and tpl file to accept and display a time element or just use one of them as "Hours" and enter something like "Open from 10 AM till 5 PM."

I'm having a hard time figuring out why you would want to NOT let someone know when the event ended, but, like everything else, it can be hidden in the tpl file. You would just comment out the line.

Please understand that this thread is to assist with general operation of the Scheduled Events Mod versus help in rewriting a mod for your personal use. We're getting deeper into the "how do I customize this for me?" which is outside the scope of the thread.

Open Source means you can take it, reverse it, invert it, flatten it, or whatever your wish. But, if you are unable to do so with the information already provided, it might be time to contract someone who is knowledgeable enough to create your new "masterpiece".

Don't want to cut you off at the knees, but I'm afraid the thread will get too far adrift if we continue with customization versus operation.

Best of luck with this and, when you've gotten it to your liking, consider submitting it to Add Ons so that it could be available for anyone else that might need your particular version.

[Serg]

Any one of the unused items could be used to report a time. You would have to modify the table and tpl file to accept and display a time element or just use one of them as "Hours" and enter something like "Open from 10 AM till 5 PM."

I'm having a hard time figuring out why you would want to NOT let someone know when the event ended, but, like everything else, it can be hidden in the tpl file. You would just comment out the line.

Please understand that this thread is to assist with general operation of the Scheduled Events Mod versus help in rewriting a mod for your personal use. We're getting deeper into the "how do I customize this for me?" which is outside the scope of the thread.

Open Source means you can take it, reverse it, invert it, flatten it, or whatever your wish. But, if you are unable to do so with the information already provided, it might be time to contract someone who is knowledgeable enough to create your new "masterpiece".

Don't want to cut you off at the knees, but I'm afraid the thread will get too far adrift if we continue with customization versus operation.

Best of luck with this and, when you've gotten it to your liking, consider submitting it to Add Ons so that it could be available for anyone else that might need your particular version.

I'm sorry, I'm just learning this whole zen cart situation and I don't know PHP that well. I would love to customize it and add it for everyone to download. I just don't know how. The add-on is great, don't get me wrong. Once again I'm sorry. For the end date, I am not using the events to let people know about sales and stuff like that, it's
more for in store event, so all I need is the date and time. I will try to figure out how to hide the line. Thank you, and I'm
Sorry.

[dbltoe]

No need to be sorry about asking questions. You'll get there one day.
You might want to open a thread in the general questions area and fully explain what you are trying to do. You'll probably find someone will have a workable solution.
The more you explain what exactly you want to do, the better your answers will be.

[robbie269]

I only just discovered your add-on last week and it is perfect for me.
It is working well. Except if I have a multi day event it removes the event from the list on the last day rather than the day after the last day. How can I fix this?