CNIT wrote: >> > > Unfortunately I cannot provide any idea, but I wonder whether > anniversaries (historical events of the day, > events of the month) are of interest to you? > > I think historical wikis can much benefit from that. I've had an idea > to add three numerical fields to > 'smw_atts2' table: orddate_leap, orddate_non_leap, value_year > corresponding to each value of Date type. > These fields would be updated with every storage of property of Date > type. > > Then the queries of historical events of the day/month/year would be > much simplier and efficient. > > Though I think there's a problem with multiple calendars, which would > require different orddate and year > values.. gregorian_orddate_leap, hebrev_orddate_leap (are there leap > years in another calendars? > I should look at...) > > Probably would needs the whole new table instead of just adding few > fields to 'smw_atts2'.. > Dmitriy >
Anniversaries certainly /would/ be of interest. That would require a query process that could take the numerical value, resolve it into day, month, and year, and then search for a month and a day. It would /also/ require a specification of which calendar the anniversary is in. For example: My birthday is November 24, 1957 in the Gregorian calendar. (I believe you still use the Julian calendar, and so it would be November 12.) In the /Hillel II/ calendar, it was 1 Kislev 5718. And in the Biblical AM calendar (based on Floyd N. Jones' /Chronology of the Old Testament/ and other commentaries on the calendar of the ancient Israelites), it is 2 Kislev 5961 AM. As you can readily see, I could celebrate my birthday on three different days in any given year, depending on what type of anniversary I preferred. For example, if I decided to observe the Hillel II anniversary this year, then I would celebrate my birthday on November 28, not November 24. So you see, the calendar determines the anniversary. Why, I know for a fact that some of my Jewish acquaintances mark births (and even deaths) according to the Hillel II calendar, not the Gregorian. All this is quite a challenge. I realize that. Of course, that's why I have shared my code with the developer in charge of the official SMW date datatype. (If anyone else needs to see it, let me know and I'll send it in a separate e-mail. The Developer's List e-mail address cannot accept an attachment of that size.) Temlakos ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ Semediawiki-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/semediawiki-devel
