table structure would be nice...

Event Calendar

Hi - running PHPFUSION v6.00.306, and I can`t get the Event Calendar to work.... can someone please help me?

I installed it on .1x and upgraded to .3 - works perfectly. Well, almost perfectly. Is this infusion still in active development? php-fusion could really use an integrated calendar, but this is as close as it gets just now. I'm loving this, but is it still active?

# Table structure for table `fusion_kalender_settings`
#

CREATE TABLE `fusion_kalender_settings` (
`set_id` smallint(6) unsigned NOT NULL auto_increment,
`b_day` varchar(4) NOT NULL default '',
`c_hight` smallint(6) unsigned NOT NULL default '0',
`c_width` smallint(6) unsigned NOT NULL default '0',
`show_where` varchar(6) NOT NULL default '',
`show_for` varchar(15) NOT NULL default '',
PRIMARY KEY (`set_id`)
) TYPE=MyISAM AUTO_INCREMENT=4 ;

#
# Dumping data for table `fusion_kalender_settings`
#

INSERT INTO `fusion_kalender_settings` VALUES (1, 'Ja', 100, 18, 'Top', 'Guest';
INSERT INTO `fusion_kalender_settings` VALUES (2, 'Ja', 100, 18, 'Top', 'Guest';
INSERT INTO `fusion_kalender_settings` VALUES (3, 'Ja', 100, 18, 'Top', 'Guest';

This should work

I'm having a nasty error whenever I input more than 3 events...
I'll post a thread right now on the forum with an image to explain it in a better way.

Cheers.

Ps: I really like this calendar, though there's a lot of room for improvements.

can't get the calendar to show properly, this is the error i get. Checked all the files I don't see this

Table 'mysql.fusion_kalender' doesn't exist

Installed without problems! thanks a lot!
I changed color in tooltips.js, works perfectly!
dutch local send to pirdani_AT_pirdani.de, and put in forum

File: calendar_events_panel.php

Line:
$result_vis = dbquery("SELECT * FROM ".$db_prefix."kalender WHERE jahr >= $p_year AND monat >= $p_month ORDER BY (monat+0), (tag+0), (jahr+0) ASC LIMIT 5";

Replacement:
$result_vis = dbquery("SELECT * FROM ".$db_prefix."kalender WHERE (jahr > $p_year) || (jahr = $p_year && monat > $p_month) || (jahr = $p_year && monat = $p_month && tag >= $p_day) ORDER BY (jahr+0), (monat+0), (tag+0), (stunden+0), (minuten+0) ASC LIMIT 5";


File: show_event.php

Line:
$result_vis = dbquery("SELECT * FROM ".$db_prefix."kalender WHERE privat = 'N' AND jahr >= $m_year AND monat = $m_month ORDER BY tag DESC";

Replacement:
$result_vis = dbquery("SELECT * FROM ".$db_prefix."kalender WHERE privat = 'N' AND jahr >= $m_year AND monat = $m_month ORDER BY (tag+0) ASC";

Nice Calendar. The sort function in the display under the calendar doesnt sort correctly. 2 am comes after 7 pm and 3am up to 9 am comes last. Anyway to get the time function in a true 24 hour clock were 1am = 01 2 am = 02 and so on

Anyone have any idea how to change the date background colour?