for an upcoming cnbya feature: what calender do you use?

Worker Joined: Nov 10, 2004 Posts: 110

In the next version of CNBYA we would like to feature a birthday field in the userinfo.
It would then also be nice to be able to have the user birthday be inserted into the calender of choice.

Therefor I would like to ask you what calender system you use, and (is possible), the structure of the dabatse field that holds the event information.
The one I mostly use is KalenderMx ( http://www.pragmamx.de/ ) and the DB layout for the events looks like this:

Quote:

CREATE TABLE `myprefix_events` (
`eid` int(11) NOT NULL auto_increment,
`aid` varchar(25) NOT NULL default '',
`title` varchar(150) NOT NULL default '',
`posteddate` datetime NOT NULL default '0000-00-00 00:00:00',
`hometext` text,
`topic` int(3) NOT NULL default '1',
`informant` varchar(25) NOT NULL default '',
`startDate` date NOT NULL default '0000-00-00',
`endDate` date NOT NULL default '0000-00-00',
`startTime` time default NULL,
`endTime` time default NULL,
`alldayevent` int(1) NOT NULL default '0',
`categorie` char(2) default NULL,
`activ` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`eid`),
KEY `topic` (`topic`),
KEY `categorie` (`categorie`),
KEY `title` (`title`),
KEY `activ` (`activ`),
KEY `evbegin` (`startDate`,`startTime`),
KEY `evtime` (`startTime`,`endTime`)
) TYPE=MyISAM AUTO_INCREMENT=58 ;

INSERT INTO `myprefix_events` VALUES (57, '', 'birthday Richard van Oosterhout', '0000-00-00 00:00:00', 'birthday: 1974-9-8', 1, 'cnbya', '2005-09-08', '2005-09-08', '00:00:00', '00:00:00', '1', '1', '1', '', '', '', '', '', '', '0');

I think you get the point.

BTW. We are working very hard on the next version of CNBYA which, due to the dramatic improvements will be numbered version 5.0.0 Smile

Cheers,
Richard

Posted: Fri Mar 11, 2005 9:58 am

I thoroughly enjoy and recommend the ported phpbb my calendar

Code:

-- 


-- Table structure for table `nuke_bbmycalendar_event_types`


-- 





CREATE TABLE `nuke_bbmycalendar_event_types` (


  `forum_id` mediumint(8) unsigned NOT NULL default '0',


  `event_type_id` tinyint(4) NOT NULL default '0',


  `event_type_text` varchar(255) NOT NULL default '',


  `highlight_color` varchar(7) NOT NULL default ''


) TYPE=MyISAM;

Posted: Fri Mar 11, 2005 10:02 am

Can you give me an example of an insert as well?

Thanks!

Posted: Fri Mar 11, 2005 10:30 am

Yes, I'll have to do it this afternoon when I am off work. Smile

Sells PC To Pay For Divorce Joined: Posts: 5661

i dont use a calendar....

Posted: Sun Mar 20, 2005 9:03 am

menelaos61 wrote:

Can you give me an example of an insert as well?

Thanks!

Well my PC that held the initial install with the SQL is out of service for a while. I will have to get back to you on this as soon as I can find the SQl again. I am sorry for the delay. Sad

Posted: Sun Mar 20, 2005 9:13 am

take your timeeeeeee....

Posted: Sun Mar 20, 2005 7:09 pm

I like Event Calendar. (Like CalendarMX) There is also a birthday mod and block for it... so I have a block called Birthday's This Month. Basically, birthdays becomes a Topic item and the block just calls those items. It's very cool.
The db looks like this:

Quote:

CREATE TABLE `nuke_events` (
`eid` bigint(20) NOT NULL auto_increment,
`aid` varchar(30) NOT NULL default '',
`title` varchar(150) default NULL,
`time` datetime default NULL,
`hometext` blob,
`comments` int(11) default '0',
`counter` mediumint( Cool

unsigned default NULL,
`topic` int(3) NOT NULL default '1',
`informant` varchar(20) NOT NULL default '',
`eventDate` date NOT NULL default '0000-00-00',
`endDate` date NOT NULL default '0000-00-00',
`startTime` time default NULL,
`endTime` time default NULL,
`alldayevent` int(1) NOT NULL default '0',
`barcolor` char(1) default NULL,
PRIMARY KEY (`eid`)
) TYPE=MyISAM AUTO_INCREMENT=642 ;

A birthday sql insert looks like this:

Quote:

INSERT INTO `nuke_events` (`eid`, `aid`, `title`, `time`, `hometext`, `comments`, `counter`, `topic`, `informant`, `eventDate`, `endDate`, `startTime`, `endTime`, `alldayevent`, `barcolor`) VALUES (582, 'janette', 'Happy Birthday Charlies Angel!', '2005-01-26 11:59:50', 0x436861726c69657320416e67656c732042697274686461792e, 0, 0, 11, 'janette', '2005-01-30', '2005-01-30', '09:00:00', '11:00:00', 1, 'y');

I'm also using NuCalendar on a couple of other sites. It's good because it allows recurring events. But I don't like it because one actually has to go into the admin area of the mod to see if there are events requiring approval. And, unlike Event Calendar, it doesn't have a comments section which is another Event Calendar mod.

Posted: Mon Mar 21, 2005 3:54 am

will this do any good for something as ..."your account".. ?

Posted: Mon Mar 21, 2005 4:42 am

it still doesnt kick out new registered that havent activated their account within 24 hours.
It should, but it doesnt work yet.
so isnt it better to make sure that all functions in cnby work properly?
And do watch out for any "overdevelopment"...

Posted: Mon Mar 21, 2005 11:06 am

Hi Hitwalker, you are absolutely right.
In the upcoming 500 beta series most of the functionality requests that we got in are working. Also the activation period is something we worked out.

This birthday field and export to n existing calendar just seemed something nice as a side thing. A little mod that can go in the extras folder in the package. Sometimes there has to be a variety in coding subjects, to give the brain some fresh air...

Posted: Mon Mar 21, 2005 1:40 pm

hi menelaos61,

yeah well,i believe that a calendar and/or birthfield will only be used by some sites.
From my point of view....why should someone be interested in my birthday?
as for the activations...i thought it worked cause i tried it with six...
but yesterday i had someone still in the system,that was 2 days.

Posted: Mon Mar 21, 2005 3:48 pm

Thats why we intend to continue to update the 4.4.0 Stable version from time to time.

Posted: Mon Mar 21, 2005 4:03 pm

well i already expected an update...
but nothing yet...

Posted: Mon Mar 21, 2005 5:50 pm

Yeah we've been working on it. I'm going to dig into the 4.4.0 files again soon. My Desktop died unexpectedly and its taken a while to get everything updated on my relic server (Dual P3 500 katamai's pushing a fresh 36Gb IBM 10,000 RPM SCSI HD) so it was safe to use as a workstation temporarily. I guess what I'm saying is that your not the only one who expected another update by now... one nice thing is I'll be able to test the windows compatability directly on IIS lol!!

Posted: Mon Mar 21, 2005 6:13 pm

well im just happy if it works and kicks out lazy people after 42 hours of non activity.....lol

Posted: Fri Apr 08, 2005 2:39 pm

I use NuCalendar, which I'm still working on modding to fix all bugs/errors.

Now it should be noted that there are a couple of versions. The default version uses the properties of table: PREFIX_nucalendar_events, while the TechGFX (PHP-Nuke Platinum Version) calls it simply: PREFIX_calendar_events.

The PHP-Nuke Platinum 7.6 events table looks like this:

Code:




CREATE TABLE `PREFIX_calendar_events` (


  `id` int(11) NOT NULL auto_increment,


  `title` varchar(50) NOT NULL default '',


  `location` varchar(64) NOT NULL default '',


  `starttime` time NOT NULL default '00:00:00',


  `duration` time NOT NULL default '00:00:00',


  `fulldesc` text NOT NULL,


  `isactive` tinyint(1) NOT NULL default '1',


  `isrecurring` tinyint(1) NOT NULL default '0',


  `categoryid` int(11) NOT NULL default '1',


  `isapproved` tinyint(1) NOT NULL default '0',


  `onetime_date` date NOT NULL default '0000-00-00',


  `recur_weekday` tinyint(4) NOT NULL default '0',


  `recur_schedule` enum('weekly','monthly','yearly') NOT NULL default 'weekly',


  `recur_period` tinyint(4) default NULL,


  `recur_month` tinyint(4) default NULL,


  KEY `id` (`id`)


) TYPE=MyISAM AUTO_INCREMENT=21 ;

An example birthday insert (as a non-recurring event) would look like this:

Code:

INSERT INTO `PREFIX_calendar_events` VALUES (21, 'Joe''s Birthday', 'Manchester, New Hampshire, USA', '24:00:00', '00:00:00', 'Joe''s Birthday', 1, 0, 1, 1, '2005-04-28', 0, 'weekly', 0, 0);

In the default NuCalendar configuration, again, the only difference would be the table names.

Now the real problem with NuCalendar is that it support re-occurring events, but NOT annual ones. It supports them being x day of the week, x day of the month, but not on x day of the year. (Kind of a bitch, isn't it?).

registered · Site Admin Joined: Jun 04, 2004 Posts: 6437

NuCalendar .61 supports annual events - I have several birthdays set up there... You just create a one-time event and select ALL for the year. A little confusing if you're expecting to set it up as a recurring event, but it works...

You can do the same thing for events that recur on the same day each month - just set the month to ALL.

The SQL for a birthday:

Code:

INSERT INTO `nuke_nucal_events` VALUES (28, 'Christ''s Birthday', '', '24:00:00', '24:00:00', '', 1, 0, 3, 1, '2000-12-25', 0, 'weekly', 0, 0);

New Member Joined: May 15, 2006 Posts: 2

I don't use a calendar yet becaue I've been searching for a birthday mod to go with the Calendar. Anybody know why PHPNuke has NEVER included a birthday field?

Anyways, this CNBYA Birthday/Calendar mod will fix it all in one sweep, I love it! Sorry I can't suggest a calendar but any ideas when it will be released?

Great mod, thanks!

Worker Joined: Feb 01, 2006 Posts: 129

i just really want to see that new versionnnnnnnnn Sad

((((((((((((( am gona dieee Sad

jeeje too much init.. Razz