Scheduled Events Add-On

Hi,

Just went through the same process with the classic template.
have the same situation.

Not sure where I am going wrong, walking through your steps.
Will continue to decipher.

Bill

JenRed, I was wondering how you made it so that the WHEN: Field on your site https://www.redinstead.com.au/index.php?main_page=events looked like: Saturday 23 May, 2009 instead of 07/19/2000

JenRed:

Nice one. Thanks a lot! I have just installed it - I tweaked a little with the layout etc.

https://www.redinstead.com.au/index.php?main_page=events

Hello,

This could be a long shot but since "Events" was the last mod I added yesterday I thought I'd ask for your help.

First, love the mod plus everything on it is working well.... But all of a sudden after entering new info in the Define Pages Editor, for Privacy and Conditions, these EZ- Pages disappeared (actually all ezpages are gone) form the footer nav bar and showed up in the sideboxs. Yet, I have the EZ-Pages Select set to "Green" for "Footer" and "Red" for "Sideboxs" Also, for these pages I have the Define Page Status set to 1 and the pages are ordered.

So my question, did I possible place a file in the wrong spot that may disable the ez-pages. Say the "Sideboxs"? The links for these pages work, they just can't be moved or placed were I would like them.

Thanks in advance for any ideas!

I'm confused...
The mod does not touch the ez pages.
Privacy and Conditions are not ez pages.
You may have entered a bad character in the Privacy or Conditions page editor that is causing bad things to happen.
A URL would be helpful in looking at the problem.

Your confused, I'm confused...

I thought it was a long shot, as to the "Scheduled Events" mod doing something.

Here's the site: http://74.220.219.77/~thirstyi/huntface

Thanks for the reply.

solved it. forgot to go back into the ez-pages settings and change the 0's to 2's for the pages in question. i will read on so that i understand the difference between ez-page and define page.

thanks again for the post as well as the great mod.....

Glad you got it going. And, thanks for letting folks know what it took to get it going.

brenjt:

JenRed, I was wondering how you made it so that the WHEN: Field on your site https://www.redinstead.com.au/index.php?main_page=events looked like: Saturday 23 May, 2009 instead of 07/19/2000

hi Brent - I didn't see this question so I'm sorry it took a while to get your answer!

In the file includes/templates/YOUR_TEMPLATES/templates/tpl_events_default.php change this:

    if ($eventInfo['StartDate'] != '') echo "<strong>Start Date:  </strong>" . zen_date_short($eventInfo["StartDate"]) .  "<br />"; 

to this:

    if ($eventInfo['StartDate'] != '') echo "<strong>Start Date:  </strong>" . zen_date_long($eventInfo["StartDate"]) .  "<br />"; 

ie. change zen_date_short to ```
zen_date_long

(in my case I also changed "Start Date:" to "when:" to fit more with the style of my site)


Hope that helps!  :)



Jen

Thanks for this great mod - It came along at a great time!

A bit of a problem on install: Everything seems to be in place, including a green light on the SQL install. However, I am getting a MySQL error 1146 when I click on the Scheduled Events link sidebox link. It also also apparent when I visit my http://www.yoursite.com/eventz page:

MySQL error 1146
Table 'xxxxxxxx_zc2.events' doesn't exist

I've re-uploaded extra_pages_filenames.php and confirmed that other files are in place. What else could be causing a 1146 error?

Thanks in advance

Check to make sure the events table got added to your database. If it's not there, go to in the admin Tools >> Install SQL Patches and reload the events.sql file.

You can also use phpMyAdmin to load the file. Open phpMyAdmin and click on your database. In the right-hand window click on the Import tab. Use the Browse button to browse your computer for the events.sql file and let it do the work for you.

Good call on using phpMyAdmin - I had re-installed the SQL numerous time without success but using phpMyAdmin made the difference!

I hope I'm not stepping on any toes but I wanted to make a suggestion / comment: It is necessary to slightly modify includes/languages/CUSTOM/english.php (just one define must be added), a file that will almost certainly have been modified previously. To achieve this you have included an updated version of the original english.php with the define in place. My fear is that those new to Zen Cart might inadvertently over-write the all-important english.php with that version, wreaking havoc on their site (Although you have indeed given the proper warnings). Rather, maybe you could just include the following instructions in the events_installation_users_guide:
In includes/languages/CUSTOM/english.php, Under the heading:

// information box text in sideboxes/information.php
add this define:
define('BOX_INFORMATION_EVENTS', 'Scheduled Events');
The same could even be said for includes/modules/sideboxes/CUSTOM/information.php, since it is just one if statement.
In includes/modules/sideboxes/CUSTOM/information.php, Under the heading:
unset($information);
add this if statement:
if (DEFINE_EVENTS_STATUS <= 1) {
$information[] = '<a href="' . zen_href_link(FILENAME_EVENTS) . '">' . BOX_INFORMATION_EVENTS . '</a>';
}
To my way of thinking, making 2 minor additions is quicker, easier and less daunting of a task then comparing files using Win-Merge etc. if indeed the files have been modifed previously.

Thanks again for this great add-on!

Good Call.
I'm tweaking things now to try to get this where all can be done in the admin. Will include dual instructions with the next upgrade.
I have found that most folks fear inserting/changing/removing code and went that way at first.
However, I understand that warnings are like operating instructions. Often read AFTER the problem occurs.:no:

Ahhh to be once again in the pre-Alps of Friuli........

dbltoe:

Ahhh to be once again in the pre-Alps of Friuli........

Things change slowly here, they will be awaiting your return more-or-less just as they were when you left... :P

If I could inject one more item for the wish-list: It would be nice to be able to turn this mod off and on from the admin.

...would it be possible to have it turn off automatically if there are no scheduled events? I can imagine that it might be difficult because of the if statement added to information.php. Although maybe the if statement itself could be set to not display if there are no events? :huh:

But Porcia, Roveredo and Pordenone have left me behind.:(

The move to the admin will include the on/off switch and the ability add/change/delete columns.

When this is where I want it, it will next morph into Recipes and Retail Outlets. It's already easy to modify events to do both of these, but I want to wait till I like Events a little better.

ciao

One of my zen carts is a dual language site, the second language being Italian. Unless I'm missing something, this mod doesn't really lend itself well to multiple languages, correct? It does have an includes/english file that houses the events.php file, allowing me to properly name the NAVBAR_TITLE & HEADING_TITLE in both languages. However, the content itself is defined in tpl_events_default.php at templates/CUSTOM/templates/, which, unless I'm mistaken cannot have a language over-ride.

Is this true, or am I not seeing something obvious? :huh:

Sorry for the late reply, been recovering from the Rodeo.
You are correct and I apologize that I didn't take into consideration other languages with this version.
I'll be taking this and your other suggestion into account when looking at this mod again this month.

dbltoe:

Sorry for the late reply, been recovering from the Rodeo.
You are correct and I apologize that I didn't take into consideration other languages with this version.
I'll be taking this and your other suggestion into account when looking at this mod again this month.

Hey, don't sweat it - I appreciate the effort you and other folks put into these community modules, often while juggling day jobs, family life and some semblance of a social life at the same time. :D

:oops:

Some have reported errors when using "Install SQL Patches" in the admin to install the included .sql file

A problem occurs when you have a database prefix set in your two configure.php files.

Install SQL Patches will automatically add the DB_PREFIX to the database events table name. For example, events becomes zen_events if your DB_+PREFIX is "zen_".

The mod files are set to access the events table without any prefix.

The quickest fix is to rename the table after it is loaded.

If you are using phpMyAdmin, do the following:

1. Open phpMyAdmin and click on the database containing the table.
2. Click on the table to rename. (probably zen_events)
3. Click on the Operations Tab in the right-hand screen.
4. Under the "Table Options" section, enter "events" (without the quotes" in the "Rename table to" block.
5. Click the "Go" at the bottom-right of the "Table Options" section.
6. You should get a message in yellow background stating, "Table events has been renamed to events"
7. Your events should now be working.
   The next release will include a check to see if a DB_PREFIX exists and cure this problem.

I love this mod so thank you very much! I just wondered... (it can't hurt to ask, right?)

I have a wordpress blog at https://www.jenleheny.com and I would love to have a sidebar widget to display the events list that is at my zen cart shop site at https://www.redinstead.com.au/index.php?main_page=events

Do you have any experience with widget making or does anybody else know how (or if) this is possible?