Scheduled Events Add-On

This add-on provides the admin/owner the ability to display upcoming events where their product(s) can be seen or purchased.

It allows the admin/owner to display- The name of the event

• The address or name of the event place.
• The start date for the event.
• The ending date for the event.
• Comments for the event (i.e. Parking is free next door)
• Special information for the event (We'll have fribbitts at 50% off OR Tell us you love Zen Cart and get a 10% discount on any purchase).
• Your location at the event, i.e. Second floor next to the escalator.
• Lastly, you can enter a link generated by any map program like Google that will be presented as a link.Included in the add-on is a simple enter/edit program to enter and edit items in the database table "events" that is created by an included sql patch.

The add-on consists of two folders. One folder (includes), contains several folders with a total of seven files to be uploaded to your site. All files are in override areas but MAY have already been modified with some other item on your site.

Those of you familiar with database updates and inserts may not need to upload the other folder (eventz) as it is only used to enter/edit events.

A read_me file and installation/user's guide is included in the zip. It's been tested with several different templates and settings but ONLY in version 1.3.8a.

As always... BACKUP! BACKUP! BACKUP!

Where might we download this?
Thanks

http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=1230

Hi There

Sounds like a great tool but I just installed this mod, when I go to the eventz url, I get the following:

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

phpMyEdit error: invalid SQL query
SELECT PMEtable0.EventID AS qf0,PMEtable0.Event AS qf1,PMEtable0.Place AS qf2,PMEtable0.StartDate AS qf3,PMEtable0.EndDate AS qf4,PMEtable0.Comments AS qf5,PMEtable0.Special AS qf6,PMEtable0.Location AS qf7,PMEtable0.Map_Txt AS qf8 FROM events AS PMEtable0 ORDER BY PMEtable0.EventID LIMIT 0, 159.532 miliseconds

Im using the latest version of zen and installed it as described

Any ideas?

Thanks in advance

dbltoe:

This add-on provides the admin/owner the ability to display upcoming events where their product(s) can be seen or purchased.

It allows the admin/owner to display- >

• The name of the event

• The address or name of the event place.

• The start date for the event.

• The ending date for the event.

• Comments for the event (i.e. Parking is free next door)

• Special information for the event (We'll have fribbitts at 50% off OR Tell us you love Zen Cart and get a 10% discount on any purchase).

• Your location at the event, i.e. Second floor next to the escalator.

• Lastly, you can enter a link generated by any map program like Google that will be presented as a link.

Included in the add-on is a simple enter/edit program to enter and edit items in the database table "events" that is created by an included sql patch.

The add-on consists of two folders. One folder (includes), contains several folders with a total of seven files to be uploaded to your site. All files are in override areas but MAY have already been modified with some other item on your site.

Those of you familiar with database updates and inserts may not need to upload the other folder (eventz) as it is only used to enter/edit events.

A read_me file and installation/user's guide is included in the zip. It's been tested with several different templates and settings but ONLY in version 1.3.8a.

As always... BACKUP! BACKUP! BACKUP!

Perhaps the sql file did not work. Did you apply the patch from the admin, PhPmyAdmin, or.....?

Dbltoe,

Sounds like a great mod! Can I see it in action somewhere?

Tina

Third link in the sig (toads) will get you to one. Fifth link (vinegar) will show one that is modified to use for recipes. I hope to finalize the events mod into spin-offs for recipes and business outlets.

Dbltoe ~

thanks for the lnks! This mod looks like something I'm gonna have to have!

Tina

One thing about this that I may not have emphasized enough in the directions. Be sure to rename the eventz directory to something that will work for you and keep prying eyes out.

dbltoe:

Perhaps the sql file did not work. Did you apply the patch from the admin, PhPmyAdmin, or.....?

Hi There

Thanks for getting back to me,

Yes I installed it from zen admin, first by pasting the sql, then when that did not work by browsing and uploading the sql.

Just to check, zen using by default the templates "classic" and "template_default" which should I have set the CUSTOM folder to ?, I set it to classic - was this right....

Thanks again.

Please don't take this the wrong way, but you should not be using classic or template default. Any upgrades will wipe out all your hard work and make your life miserable.:no:

There might be one small argument for not using a custom directory, but the only one I can think of is that you will totally abandon your current cart on upgrade.

Anyway, if you do a View Page Source in your browser by right-clicking on your site, you should see what folder the system looks in for the stylesheet.css. There will be a line near the top of the view source that shows it loads the stylesheet.css. That folder should be your custom, but, if you see classic or template_default, that is what you would use in your case.

I'd still investigate the override system in the Tutorials?FAQs section. As Monk says, "You'll thank me later."

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

Thanks! Glad it's working for you.

The beautiful thing about Zen Cart is that we take the cart or a mod and tweak a little here and there. Next thing you know, we have a unique presence on the web.

Lookin' good, mate!:bigups:

Hello again,

Hey not taken in the wrong way at all, im glad of the advice !

I will try and see if I cant get this working over the weekend.

Many Thanks

dbltoe:

Please don't take this the wrong way, but you should not be using classic or template default. Any upgrades will wipe out all your hard work and make your life miserable.:no:

There might be one small argument for not using a custom directory, but the only one I can think of is that you will totally abandon your current cart on upgrade.

Anyway, if you do a View Page Source in your browser by right-clicking on your site, you should see what folder the system looks in for the stylesheet.css. There will be a line near the top of the view source that shows it loads the stylesheet.css. That folder should be your custom, but, if you see classic or template_default, that is what you would use in your case.

I'd still investigate the override system in the Tutorials?FAQs section. As Monk says, "You'll thank me later."

Hi there,

Just downloaded the schedule.
All seems to be working except I still get a blank page.
I have the link, I have the admin portion under extras okay as well as the eventz portion working too.
I am using 1.3.8a and have no other mods in play.

Any reason why my mainpage for the events is blank?
I am workin on my local server for testing.

Bill

Hi,

I also went to phpMyAdmin and saw the table and the 2 listings I added, so the sql patch worked out.

Bill

I am using a Template By ZenCart-jQuery

Bill

Bill,
Do you still have the no-go when you switch back to Classic?
I notice the site you gave is pulling that template.
I haven't had time to really research, but I think you may find it smoothes out with classic.
Also, it would be nice to see a page source for your events page to see where it stops.

Thank you for your speedy reply,

If I remember correctly I tried the classic template, and no link showed up.
I am not at home but will confirm tonight, because I am testing it locally.

Am I also to assume that the eventz folder is optional as well?

Bill

I was in a hurry myself and failed to mention that you would need to load the files designed for a custom folder into the template_default directory when switching to classic.
The eventz folder (which should be renamed if installed) is for those folks who aren't comfortable with the phpMyAdmin manipulations. phpMyAdmin on your local machine is probably faster.