[BETA 1.4.1] Fetch Calendar Info 1.0 Bèta

[sylvester]

Code Select Expand

<id>
Fetch Calendar Info</id>

<version>
1.0 Bèta
</version>

<author>
sylvester ([email protected])
</author>

<homepage>
http://www.computerfreakz.net
</homepage>

<mod info>
With this mod, you can fetch info from the calendar (events,holidays,birthdays) with SSI.php

Readme:
   - Install this mod with boardmod or manually ;)
   - Open the page you want the info on it
   - Include SSI.php
   - Use the following functions:
      * FetchCalendar('bdays')
      * FetchCalendar('holidays')
      * FetchCalendar('events')
   - Enjoy :)
</mod info>

<edit file>
SSI.php
</edit file>

<search for>
<tr><td align=right>$pass:&nbsp;</td><td><input type=password name="passwrd" size="9"></td></tr>
<tr><td>&nbsp;</td><td><input type=hidden name="cookielength" value="$txt[yse50]"><input type="submit" value="$txt[34]"></td></tr></table></form>
EOT;
}
</search for>

<add after>
function FetchCalendar($what=NULL) {
   global $db_prefix,$txt,$scripturl,$timeoffset,$scripturl;
   $timeUserOff = (isset($settings[18]) ? $settings[18] : 0);
   list($day,$month,$year) = explode('/',date('d/m/Y',time()+(($timeoffset+$timeUserOff)*3600)));
   
// Birthdates
   if($what == 'bdays') {
      $bdays_query = mysql_query("SELECT realName,memberName,year(birthdate) FROM {$db_prefix}members WHERE (dayofmonth(birthdate) = {$day} AND month(birthdate) = {$month})");
      if(mysql_num_rows($bdays_query) > 0)
         $return = '<B>'.$txt['calendar3'].'</B><BR>';
      while($bdays_result = mysql_fetch_row($bdays_query)) {
         $return .= '<A HREF=\''.$scripturl.'?action=viewprofile;user='.$bdays_result[1].'\'>'.$bdays_result[0].'</A> ('.($year - $bdays_result[2]).')<BR>';
      }
   }

// Events
   if($what == 'events') {
      $events_query = mysql_query("SELECT title,id_board,id_topic FROM {$db_prefix}calendar WHERE (day = {$day} AND month = {$month} AND year = {$year})");
      if(mysql_num_rows($events_query) > 0)
         $return =  '<B>'.$txt['calendar4'].'</B><BR>';
      while($events_result = mysql_fetch_row($events_query)) {
         $return .= '<A HREF=\''.$scripturl.'?action=display;board='.$events_result[1].';threadid='.$events_result[2].'\'>'.$events_result[0].'</A><BR>';
      }
   }

// Holidays
   if($what == 'holidays') {
      $holidays_query = mysql_query("SELECT title FROM {$db_prefix}calendar_holiday WHERE (day = {$day} AND month = {$month} AND (year IS NULL || year = {$year}))");
      if(mysql_num_rows($holidays_query) > 0)
         $return =  '<B>Holidays:</B><BR>';
      while($holidays_result = mysql_fetch_row($holidays_query)) {
         $return .= '<B>'.$holidays_result[0].'</B><BR>';
      }
   }

   if(isset($return)) {
      echo $return;
   }
}
</add after>http://www.yabb.info/community/index.php?board=141;action=display;threadid=12537

[tore-]

this looks cool mate! Ive waited so long for this, thanks!

[Horseman]

i have you mod installed and translated for german users. good work  

thx
hm

[sylvester]

i have you mod installed and translated for german users. good work  

thx
hm

thnx
You're welcome

[tore-]

is this an non-beta now or not*?=

[Thomas]

This is just what I have been looking for. I have problems calling it though. Is it right to use the following code:

<!--#include virtual="/forum/SSI.php?function=FetchCalendar('events')" -->

/MR.T

[Horseman]

This is just what I have been looking for. I have problems calling it though. Is it right to use the following code:

<!--#include virtual="/forum/SSI.php?function=FetchCalendar('events')" -->

/MR.T

in the first line require ssi.php

Code Select Expand

<? require("/homepages/xx/dxxxxxxxx/htdocs/forum/SSI.php"); ?>
and placed this:

Code Select Expand

<? FetchCalendar('bdays') ?> or ('events')
you will see the events, birthdays or holidays

[Thomas]

I am going to use it at an shtml page - not php.

How do I do it then?

/MR.T

[Horseman]

you can make a little php file and view this as a

Code Select Expand

<iframe> link to the php file </iframe> in you shtml page

hm

[Thomas]

Interesting - I'll try that.

Is it not possible to use this with shtml. It works fine for the other stuff which is in ssi.php - for instance:

<!--#include virtual="/forum/SSI.php?function=whosOnline" -->

and

<!--#include virtual="/forum/SSI.php?function=recentTopics" -->

By the way. Is it possible to for instance view the events for the next x-days?

/MR.T

[sylvester]

[..]Is it not possible to use this with shtml. It works fine for the other stuff which is in ssi.php - for instance[..]

No, I use a function with an argument
Perhaps someone else would make this SHTML-compatible

[tore-]

I FOUND A BUG!

For some wierd reason, the month stored in "yabbse_calendar" in the db, uses 0 (januar) to 11 (december).

Therefor, it wont show events. This aint a problem when there is holidays, because there they use 1-12 on the months.

They way i fixed is, was by doing this:
Find:

Code Select Expand

// Events
   if($what == 'events') {
Add after:

Code Select Expand

$month--;
And everything is fixed!

[tore-]

I've made many changed to my version of the script, if there is no event,bday,holiday present, it will return with "No event/bday...."

Here is my full script:

Code Select Expand

function FetchCalendar($what=NULL) {
   global $db_prefix,$txt,$scripturl,$timeoffset,$scripturl;
   $timeUserOff = (isset($settings[18]) ? $settings[18] : 0);
   list($day,$month,$year) = explode('/',date('d/m/Y',time()+(($timeoffset+$timeUserOff)*3600)));
   
// Birthdates
   if($what == 'bdays') {
      $bdays_query = mysql_query("SELECT realName,memberName,year(birthdate) FROM {$db_prefix}members WHERE (dayofmonth(birthdate) = {$day} AND month(birthdate) = {$month})");
     if(mysql_num_rows($bdays_query) == 1) {
      if(mysql_num_rows($bdays_query) > 0)
         $return = '<B>'.$txt['calendar3'].'</B><BR>';
      while($bdays_result = mysql_fetch_row($bdays_query)) {
         $return .= '<A HREF=\''.$scripturl.'?action=viewprofile;user='.$bdays_result[1].'\'>'.$bdays_result[0].'</A> ('.($year - $bdays_result[2]).')<BR>';
     }
      }
     if(mysql_num_rows($bdays_query) == 0) { echo "No birthdays today"; }
   }

// Events
   if($what == 'events') {
     $month--;
      $events_query = mysql_query("SELECT title,id_board,id_topic FROM {$db_prefix}calendar WHERE (day = {$day} AND month = {$month} AND year = {$year})");
     if(mysql_num_rows($events_query) == 1) {
      if(mysql_num_rows($events_query) > 0)
         $return =  '<B>'.$txt['calendar4'].'</B><BR>';
      while($events_result = mysql_fetch_row($events_query)) {
         $return .= '<A HREF=\''.$scripturl.'?action=display;board='.$events_result[1].';threadid='.$events_result[2].'\'>'.$events_result[0].'</ A><BR>';
      }
   }
   if(mysql_num_rows($events_query) == 0) { echo "No events"; }
}
// Holidays
   if($what == 'holidays') {
      $holidays_query = mysql_query("SELECT title FROM {$db_prefix}calendar_holiday WHERE (day = {$day} AND month = {$month} AND (year IS NULL || year = {$year}))");
     if(mysql_num_rows($holidays_query) == 1) {
     if(mysql_num_rows($holidays_query) > 0)
         $return =  '<B>Holidays:</B><BR>';
      while($holidays_result = mysql_fetch_row($holidays_query)) {
         $return .= '<B>'.$holidays_result[0].'</B><BR>';
      }
   }
if(mysql_num_rows($holidays_query) == 0) { echo "No holiday today"; }
   }
   if(isset($return)) {
      echo $return;
   }
}

[tore-]

I think this should be in 1.5.0, dont know with you guys

[DVS]

This is an old topic, but hopefully someone can help.

I just installed this in YaBBSE and it works great if there is only one item (birthday, event, holiday) per day, but if there are more than one birthday, for example, on a day, it doesn't give a result.

Any ideas on how to fix this?

Thanks!

Anthony