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

[ruebenwurzel]

Hello John,

for better compatibility with mysql 4 and mysql 5 stefan meant to change the install scripts. The main changes where to delete at all INT fields the NOT NULL and to add to all TEXT and VARCHAR fields DEFAULT \'\'. In different posts we now have problems with creating tables depending on the mysql (i think in combination with the php version) versions. So I'm not shur how to get this solved in the modules. As i See we need different install scripts to get the modules correct installing on all versions. Or is it possible to check in the install script wich mysql version is installed and depending on the result create the tables in different ways. The script you released above is a mixture from the old install scripts and the new install scripts. Did you think we solve this for all other modules with a similar mixture too?

Matthias

[pcwacht]

This was the error I corrected:

All parts of a PRIMARY KEY must be NOT NULL

So when using something as a primary ley the NOT NULL must be there!


I allso included some code right after the db code to show errors if there are any, wich is handy for (module)developers...

Code:

  $database->query($mod_event);

// Check if there is a db error
if($database->is_error()) { 
   echo 'Table settings : '.$database->get_error();
}

The first is definitly a must, the second is just handy...

 
John

PS Will dig into this when I have diff mysql servers running so I can see what is the best practice to create tables from within php

[ruebenwurzel]

Thanks John,

so it could be, that only give the primary the value NOT NULL could solve this problems? will try and look, because I've changed this in different modules.

Matthias

[cmiper]

Hey guys, I hate to float this one up to the top again, but I have an older install of WB running one a site that never used the Event Calendar since I set it up.  It was updated to 1.21c and I would like to bring it up to date, but cannot find the 1.21b - 1.3 update anywhere, which I need before I can run the 1.62 version.

Any help would be appreciated.

Thanks


*by "older install of WB" I meant that it is current, just an install that I had done a while back..just to clarify 

[kweitzel]

now, if that site never used the eventcalendar, the quickest way is to uninstall and then reinstall the latest available version.

On the other hand, I have some older modules on my personal webspace here: Nethome of Claudia & Klaus - Download Section but since it has not been maintained since about march this year, no guarantee that you find what you need. Also lot's of modules from the 2.5.2 times and modules which never made it out of release state.

cheers

Klaus

[cmiper]

Thanks Klaus, found what I needed and got up to date.

They had a few old event posts so I went with the update method.

Thanks again.

[YeShakka]

Hi!

* When I am in the actual (current) month the shouldn't be a message saying "Back to current month"

The current month is still shown when I am on the events page.

E.g.: When I view the Events page for January I get the message "Back to current month".

Greetings,
YeShakka

[ruebenwurzel]

Hello,

Again did you use the latest version of this modul?

Matthias

[YeShakka]

I am just updating every think on my page.
So these are the new files downloaden from addons.* today.

EDIT: here goes the code of the view.php as stored on my server:

Code:

<table border="0" cellpadding="0" cellspacing="0" width="95%">
<tr>
<td class="eventheading" width="5%">
<?php
$monthchange = $monthno-1; $yearchange=$year;
if ($monthchange==0) {
$monthchange=12;
$yearchange=$year-1;
} else {
$yearchange=$year;
}
?>
<a href="<?php echo '?monthno=' . $monthchange . '&amp;year=' . $yearchange; ?>"><img src="<?php echo $WB_URL; ?>/modules/event/leftarrow.gif" border="0" alt="<?php echo date(M, mktime(0, 0, 0, $monthchange, 1, $yearchange))." ".$yearchange ?>"></img></a>
</td>
<td class="eventheading" width="90%">
<a href="<?php echo '?'; ?>"><?php echo $EVTEXT['TODAY'] ?></a>
</td>
<td class="eventheading" width="5%">
<?php
$monthchange = $monthno+1;
if ($monthchange==13) {
$monthchange=1;
$yearchange=$year+1;
} else {
$yearchange=$year;
}
?>
<a href="<?php echo '?monthno=' . $monthchange . '&amp;year=' . $yearchange; ?>"><img src="<?php echo $WB_URL; ?>/modules/event/rightarrow.gif" border="0" alt="<?php echo date(M, mktime(0, 0, 0, $monthchange, 1, $yearchange))." ".$yearchange ?>"></img></a>
</td>
</tr>
</table>

My suggestion is to use a css like style=display:none if we are in the current month.
Do you know how to switch style=display:none to style=display:inline via PHP?

Code:

<td class="eventheading" width="90%" style=display:none>
<a href="<?php echo '?'; ?>"><?php echo $EVTEXT['TODAY'] ?></a>

... just an idea...
Maybe you know better how to do this.

[ruebenwurzel]

Hello,

so the modul is working as it should and you only wanna have the additional feature that of you are in the current month the message "Back to current month" isn't displayed?

Maybe in a next version we could add this.

Matthias

[YeShakka]

Sorry, Mathias.

We were misunderstanding each other.

Yes, that's want I am suggesting.

My PHP-knowledge is too limited too do this now...

[bgg]

Is there a way to mix-up both this Event calendar module with the Calendar module?? i.e. clickable dates (when there is any event) to the event details ,, and the calendar .. we can choose to place on the homepage..

[ruebenwurzel]

Hello,

as this are two different modules a mixing is not possibel.

Sorry

Matthias

[bgg]

or can a events be displayed within a calendar format?

[ruebenwurzel]

Hello,

again no, for this please use the calendar modul. I hope we release in the next days (weekend) a new version of calendar modul with a lot of fixes and new features from funky_mf.

Matthias

[bgg]

I just figured it out with the calendar module: http://www.wb.asiasrc.org/pages/events.php

but the default display it not nice and does not  look like a WB type module (dirty URL!!)

May be the  Event Calendar Module can give a similar solution!

Thanks

[ruebenwurzel]

Hello,

as i said, Event Calendar does not get this output!!

For better results in Calendar Modul search the forum or wait to the next release as i wrote above.

Matthias