New Event Calendar v1.21b up to V1.3

[Bennie_wijs]

Oke, We have a new version for module event calendar  

You can download it here: event_v1_21.zip

A view how it looks like is here here


/* Version 1.21
 Whats New (Bennie Wijs 2005/06/21)
  + Added option to tell how many days a event has and it will create the extra days (Max 7 days)
  - Added date switching also for view all events

/* Version 1.2
 Whats New (Bennie Wijs 2005/06/20)
  + Added language.php file for month and text change (other language)

/* Version 1.1
 Whats New (Bennie Wijs 2005/06/20)
  + Added date switching between Year-Month-Day and Day-Month-Year
  + Added Link option per event entered
  - Created upgrade_event.php for the database changes for version 1.1

[Hans]

Thanks Bennie, works great now!
Hans

[ruebenwurzel]

Wow    
great modul, good work, thank you very much.

for all Germans, you can download a 100% translated Version of Event Calendar here

Have fun

[pchop]

Hello,

Let me begin by saying this is a great module.  It is very helpful.  I am new to Website Baker but I like it very much.  I can't get the event description to show up.  I check my MySql DB and the 'event_desc' never makes it in the db.  Do you have any ideas why?  I also had the same problem with the earlier version of this module.  Everything else works ok.  All of my permissions are set correctly in the DB.

Thanks for your help in this.

Ok I added an event with a five day time limit, the four days after today were added no problem. Any ideas?

[Bennie_wijs]

Hello,

Let me begin by saying this is a great module.  It is very helpful.  I am new to Website Baker but I like it very much.  I can't get the event description to show up.  I check my MySql DB and the 'event_desc' never makes it in the db.  Do you have any ideas why?  I also had the same problem with the earlier version of this module.  Everything else works ok.  All of my permissions are set correctly in the DB.

Thanks for your help in this.

Ok I added an event with a five day time limit, the four days after today were added no problem. Any ideas?

This is very strange, I cannot reproduce this. not on linux or on windows.

So I realy don't have any ideas

[Bennie_wijs]

There is also a special version of the event calendar.

This is specially created for cyberjoker.

It is called Cabin Rental Calendar, it is made for renting out a room or cabin.

The differents are:
- It displays all the days in the month
- No link option The location is used to give a color (green for not rented and red for rented)
- The empty days description is a link to 1 default page ( like a form page )
- event days it last is upgraded to 21 days

You can download it here cabin.zip

A test page is here.

[pjcarmen]

Nice work, thanks!

Can anyone tell me how to change the date format? I would rather it to be:

MM/DD/YYYY

Thanks

[Bennie_wijs]

Nice work, thanks!

Can anyone tell me how to change the date format? I would rather it to be:

MM/DD/YYYY

Thanks

That option is not coded. I only ceated the option Day-Month-Year or Year-Month-Day.

If you want this you need to edit several files on several places.

If you really want this I can do it for you.

[pjcarmen]

Nice work, thanks!

Can anyone tell me how to change the date format? I would rather it to be:

MM/DD/YYYY

Thanks

That option is not coded. I only ceated the option Day-Month-Year or Year-Month-Day.

If you want this you need to edit several files on several places.

If you really want this I can do it for you.

It would be a nice option for us stubborn Americans. If you are able to make it an option that would be very much appreciated.

-PJC

[Bennie_wijs]

New Version: 1.21b

You can download it here: event_v1_21b.zip

How to upgrade from 1.21 to 1.21b:
There is no database change so unzip and place the files in /modules/event/ directory.

 Version 1.21b
 Whats New (Bennie Wijs 2005/07/19)
  + Changed the date format selection to dropdown box and added Month-Day-Year to the list

 Version 1.21
 Whats New (Bennie Wijs 2005/06/21)
  + Added option to tell how many days a event has and it will create the extra days (Max 7 days)
  - Added date switching also for view all events

[jmoffat]

Is there a way to call the events to another page?  An example would be to have an "events" page, but maybe like on the homepage, it pull like the next 5 events and display them?

I wasn't sure if this was a possibility or not.

[Bennie_wijs]

Is there a way to call the events to another page?  An example would be to have an "events" page, but maybe like on the homepage, it pull like the next 5 events and display them?

I wasn't sure if this was a possibility or not.

Possible yes, made no.

Basicely you can write some php code for it. the data is in mysql.

I will think about it.

[Bennie_wijs]

Is there a way to call the events to another page?  An example would be to have an "events" page, but maybe like on the homepage, it pull like the next 5 events and display them?

I wasn't sure if this was a possibility or not.

Well here is a code snipet.
This code displays the next 5 days.

You can make a section page and select module code and past this in.
Only have 1 problem. inside the code I give up the page and section id of the event page to get the data. Do not know how to get this info a other way.

You can properly paste this code inside your template ( have not tested that ) aswell

Code:

$page_id = 8;
$section_id= 8;
require(WB_PATH.'/modules/event/language.php');

$query_content = $database->query("SELECT * FROM
".TABLE_PREFIX."mod_event_settings WHERE section_id = '$section_id'");

if($query_content->numRows() > 0) {
$fetch_content = $query_content->fetchRow();
$date_view = $fetch_content['date_view'];
}

$today = date("Y-m-j");
$month = date("m");
$day = date("j");
$year = date("Y");
$theday = mktime (0,0,0,$month ,$day+6 ,$year);
$lastday=date("Y-m-d",$theday);

echo "<center>";
echo " ----- Listing Next 5 days of Events + Events Today ----- <BR>";
$query_dates = $database->query("SELECT * FROM
`".TABLE_PREFIX."mod_event_dates` WHERE section_id = '$section_id' && date
>= '$today' && date < '$lastday' order by date");

while($result = $query_dates->fetchRow()) {
  $alt2date=$result['date'];
  if ($date_view == 1 ) {
    list($a2year, $a2month, $a2day) = split('[/.-]', $alt2date);
    $altdate=$a2day."-".$a2month."-".$a2year;
  } elseif ($date_view == 2 ) {
    list($a2year, $a2month, $a2day) = split('[/.-]', $alt2date);
    $altdate=$a2month."-".$a2day."-".$a2year;
  } else { $altdate=$alt2date; }

   echo $altdate." Event: ".$result['event_desc']."<BR>";
}
echo "</center>";

You can see a demo here.

I need to think about how to get the next 5 event-days.
The problem is that you can have several events on 1 day.

[beate]

Just testet event_v1_21b.zip.

It doesn't save neither my Event-Name nor my Link

And, one idea, it would be better after inserting/editing an entry, that it would display the calender-site again for inserting more events, not the admin/pages/index.php.

And, one other problem ist the html-code, it's not valid

@Ruebenwurzel: Hast du diese Version auch übersetzt?

[ruebenwurzel]

@beate
nein arbeite noch dran. Will Benni Wijs noch überzeugen, dass er seine language.php erweitert, so dass alles dort übersetzt werden kann. Außerdem sind da nochj ein paar kleine Ungereimtheiten, hoffe dass er diese noch beseitigen kann.

[beate]

Stimmt, auch das Datumsformat sollte einfacher zu konfigurieren zu sein. Und etwas HTML-Codeaufräumung

[jschor]

Thank you very much for the calender module!
I want to use it for a company who sells tickets for events www.evenemententick ets.nl/wb
I made some changes in the view.php and the css (although some things are a bit difficult to figure out - see my later remarks)

I have a few remarks and ideas so the calender module can be used in more situations.

First a agree about the remarks about the language file (($TEXT['DATE'] is used in the script, but not in the language file for instance) and the html code (i find it difficult to align everything to the left so all parts align under each other and i couldn't find a way to remove the underlining under the today link).

A nice (and probably not so difficult to implement) option would be if there would be a choice in the settings that it is only possible to look forward and not backward in time (in a lot of cases, for instance in my example and calenders for artists and bands that is not necessary and can be confusion for visitors)

In stead of showing one month and the possibility to show all events an option in the settings where you can choose to show all events (or the events of a whole year) presented in the same way as the monthly events are now (so including the link option).

use the link option a more than one way. So it can go to another website but it can also be used to give more information about the event (for instance expanding like the news module). This can also be an extra field so the link is to go to another website and there is a field for more info (this can expand or go to another automatically created page).

For last (but this may be more difficult to implement) it would be nice to set up more fields to show (for instance a field for location etc etc).

So no critics but only remarks to make the module can be used in more cases. I know we can make hacks (unfortunately not be me because i don't have any php-knowledge........yet) but i think it is better to improve the original module than all kind of hacks. I see that more for other modules and i is very difficult to figure out which of these things are already in the wb-core and what are the latest versions of modules etc.

[ruebenwurzel]

New Version of Event-Calendar released

Whats new:
+ Added some lines to language.php. The Modul is now 100% multilingual (I hope  )
+ Uninstall now deletes Search Table Entries
# Cleaned the html-code ( there was a little bit confusion with <table>, <tr> and <td>  )
# Minor changes in view.php

How to update:
There are no database changes so you can unzip it and place the files in /modules/event if you already have older version installed.

Edit:
look at completed modules for the latest version.

[jschor]

Does that mean that when i update the module i have to add all events again?

[ruebenwurzel]

sorry,

I forgot, there are no changes in the tables, so the easiest way to update is unzip the new-event-modul and copy the files over the old files in modules/event. ( Be sure you have write permissons to this files )

Have fun

P.S. I've updatet my post before

[jschor]

Thanx for you quick reply. I will try out the new version. What do you think of my ideas about extending the module?
http://www.wbhome.org/forum/index.php?topic=1189.msg7612#msg7612

[Bennie_wijs]

@Bennie Wijs
Thanks for this great modul. Please look at the code. Hope the changes are ok for you. Changed the following files:
info.php, language.php, change_event.php, modify.php, modify_event.php and view.php

All changes that is for the better is always oke 

[i2Paq]

Can someone please help me to get it installed manualy?
I have PHP-safe-mode and can't get it to update my database and wich files should be were

[Bennie_wijs]

Can someone please help me to get it installed manualy?
I have PHP-safe-mode and can't get it to update my database and wich files should be were

Oke, all the files in the zip file needs to go to wb/modules/event/

one off these files is the install.php inside there is the info about the database tables and fields

[i2Paq]

Can someone please help me to get it installed manualy?
I have PHP-safe-mode and can't get it to update my database and wich files should be were

Oke, all the files in the zip file needs to go to wb/modules/event/

one off these files is the install.php inside there is the info about the database tables and fields

[offtopic]saw you visited my website  [/offtopic]

Thanks Bennie, with some help form the sql-guys here I will manage

// Create table 1

Check!

// Create table 2

Check!

// Insert info into the search table
   // Module query info
   $field_info = array();
   $field_info['page_id'] = 'page_id';
   $field_info['title'] = 'page_title';
   $field_info['link'] = 'link';
   $field_info = serialize($field_info);
   $database->query("INSERT INTO ".TABLE_PREFIX."search (name,value,extra) VALUES ('module', 'event', '$field_info')");
   // Query start
   $query_start_code = "SELECT [TP]pages.page_id, [TP]pages.page_title,   [TP]pages.link   FROM [TP]mod_event_settings, [TP]pages WHERE ";
   $database->query("INSERT INTO ".TABLE_PREFIX."search (name,value,extra) VALUES ('query_start', '$query_start_code', 'event')");
   // Query body
   $query_body_code = " [TP]pages.page_id = [TP]mod_event_settings. page_id AND [TP]mod_event_settings. galtitle

• \'[W][STRING][W]\' AND [TP]pages.searching = \'1\'

   OR [TP]pages.page_id = [TP]mod_event_settings. page_id AND [TP]mod_event_settings. adminname

• \'[W][STRING][W]\' AND [TP]pages.searching = \'1\'";

   $database->query("INSERT INTO ".TABLE_PREFIX."search (name,value,extra) VALUES ('query_body', '$query_body_code', 'event')");
   // Query end
   $query_end_code = "";   
   $database->query("INSERT INTO ".TABLE_PREFIX."search (name,value,extra) VALUES ('query_end', '$query_end_code', 'event')");
   
   // Insert blank row (there needs to be at least on row for the search to work
   $database->query("INSERT INTO ".TABLE_PREFIX."mod_event_settings (page_id,section_id) VALUES ('0','0')");

Help!  How do I get this into my DB?

  Table    Action    Records    Type    Collation    Size    Overhead   
   groups                1   MyISAM    latin1_swedish_ci      2.5 KB      -   
   mod_code                1   MyISAM    latin1_swedish_ci      2.0 KB      -   
   mod_event_dates                0   MyISAM    latin1_swedish_ci      1.0 KB      -   
   mod_event_settings                0   MyISAM    latin1_swedish_ci      1.0 KB      -   
   mod_form_fields                1   MyISAM    latin1_swedish_ci      2.4 KB     440 Bytes 
   mod_form_settings                2   MyISAM    latin1_swedish_ci      2.4 KB      -   
   mod_form_submission s                2   MyISAM    latin1_swedish_ci      2.2 KB      -   
   mod_news_comments                1   MyISAM    latin1_swedish_ci      2.0 KB      -   
   mod_news_groups                1   MyISAM    latin1_swedish_ci      2.0 KB      -   
   mod_news_posts                1   MyISAM    latin1_swedish_ci      2.0 KB      -   
   mod_news_settings                1   MyISAM    latin1_swedish_ci      2.0 KB      -   
   mod_wrapper                0   MyISAM    latin1_swedish_ci      1.0 KB      -   
   mod_wysiwyg                8   MyISAM    latin1_swedish_ci      2.4 KB     32 Bytes 
   pages                8   MyISAM    latin1_swedish_ci      3.0 KB     88 Bytes 
   search                23   MyISAM    latin1_swedish_ci      7.4 KB      -   
   sections                8   MyISAM    latin1_swedish_ci      2.3 KB     24 Bytes 
   settings                5   MyISAM    latin1_swedish_ci      2.2 KB      -   
   users                1   MyISAM    latin1_swedish_ci      2.2 KB      -   
  18 table(s)   Sum  64  --   latin1_swedish_ci     42.1 KB    584 Bytes 

Thanks!