Tools To Use Wiki As a Pim

Last edited by DanieleCruciani
Sun, 28 Jun 2009 17:03 UTC [diff]

One use of Wikka is as a Personal Information Manager. For some things the free-form writing nature of a wiki is useful (and, dare-I-say, liberating). However, as some of our usage at this site suggests, there are tools that can be developed AS actions in wikka that can make some aspects of information management a bit easier. In the past six months I've modified/developed two tools (with more forthcoming) with this purpose. One tool is a collection of actions so that schedules can be kept and organized on line. Its components include a "rapid entry" tool (scheduler.php, which should be kept on a page called ScheDuler), a monthly schedule view (monthschedule.php which should be kept on a page called MonthSchedule) and a day view (dayview.php which should be kept on a page called DaySchedule). These actions depend on a function which must be included as a file in the scripts directory. A year-view calendar is also available at GmBowenCalendar.

The other available action is a task manager (based on gbtask). The badwordfunction is at the bottom of the page (and currently is needed by the task manager & must be included in wikka.php).

Scheduler

Scheduler is an action which allows a person to keep a day calendar (or diary for that matter). Although the entry formatting is simple, at the same time it provides flexibility. A user can enter a day schedule.....

8:00 am - meeting with joe
9:00 am - coffee with angie
10:00 am - clients from budapest

or use it to keep a to-do list, or even a diary for the day. The schedule for a day can be viewed with the entry tool, in the monthly view, or in the day view. The day viewer is formatted for printing out usable schedules, & you can designate a specific user with it and see somebody else's schedule (I intend on modifying this so that there will be an easy-to-use text entry box for entering user names).
http://gmbtst.msvu.ca/wikitest/scheduler.jpg

Code for table in data base.....
CREATE TABLE `wakka_scheduler` (
  `id` INT(10) NOT NULL AUTO_INCREMENT,
  `user` VARCHAR(80) NOT NULL DEFAULT '',
  `day` tinyint(2) NOT NULL DEFAULT '0',
  `month` tinyint(2) NOT NULL DEFAULT '0',
  `year` mediumint(4) NOT NULL DEFAULT '0',
  `dayschedule` text,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;


These actions rely on a "bad word function" which must be placed as a file called badwordfunction.php located in a directory called scripts located in the wiki root directory.
  1. <?php
  2. //remove bad word filter
  3. //Must be called badwordfunction.php and be placed in a directory called "scripts" in wakka root.
  4.  
  5. function BadWordFunction($RemoveBadWordText) {
  6.     $RemoveBadWordText = eregi_replace("fuc?k|[kc]unt|motherfucker|cocksucker|bitch|son of a bitch|asshole|shit|fag|wank|dick|pu[zs]?[zs][yi]|bastard|s[kc]rew|mole[zs]ter|mole[sz]t|coc?k", "", $RemoveBadWordText);
  7. return $RemoveBadWordText;
  8. }
  9. ?>


below code added to actions directory as scheduler.php. The action should be placed on a page called "ScheDule".
  1. <?php
  2. // Scheduler Version 1.1f - Jan 7, 2005 - bad word function call
  3. // The original parts of this script were developed by G. Michael Bowen And Mark Kasper for a SSHRC research project using wikka wiki.
  4. // As far as it is possible to tell (because the code exists all over the web), we provide credit to the original calendar code for the
  5. // to Marcus Kazmierczak and released at www.blazonry.com, although this script builds considerably on that code.
  6. // Code additions copyright GMBowen & Mark Kasper, 2004. Released to public domain under GPL. Modify, improve, change as you wish.
  7. // There are two complementary actions. dayschedule.php allows anyone to designate an owner & date to see their schedule (see line 140)
  8. // and the should be placed on a page named "DaySchedule". The other action, monthschedule.php, is a
  9. // larger version of the dayschedule action which shows entries for an entire month on one page.
  10. ?>
  11. <div align="center">
  12. <P><TABLE BORDER=0>
  13.    <TR>
  14.       <TD>
  15.          <P>
  16. <?php
  17. $month = (!isset($_GET['month'])) ? date("n",mktime()) : $_GET['month'];    
  18. $year = (!isset($_GET['year'])) ? date("Y",mktime()) : $_GET['year'];
  19. $today = (!isset($_GET['day'])) ? date("d",mktime()) : $_GET['day'];
  20.  
  21. $site_base = $this->GetConfigValue("base_url");
  22. $thispage=$this->GetPageTag();
  23.  
  24. // badword array for replacing badwords (not initialized as currently using added function in wakka.php)
  25. //$badwords = Array ('/motherfucker/i', '/cunt/i', '/fuck/i', '/cocksucker/i', '/bitch/i', '/son of a bitch/i', '/asshole/i', '/shit/i', '/fag/i', '/wank/i', '/dick/i', '/pussy/i', '/bastard/i', '/molester/i', '/molezter/i', '/cock/i');
  26. //$changeto = '****';
  27.  
  28. // gets username
  29. $username = $this->GetUserName();
  30.  
  31. // kasper
  32. //  NOTE VERY IMPORTANT,  if the table is totally empty the function will not work, you
  33. //                        must add one in maually, for this function to work
  34. //                        I could add it in the code but very messy, will come up with better way.
  35.  
  36. $dayschedule = $_POST['dayscheduleX'];
  37.  
  38. include_once("./scripts/badwordfunction.php");
  39. $dayschedule = BadWordFunction($dayschedule);
  40. $dayschedule = addslashes($dayschedule);  // for single quotes to work
  41.  
  42.  
  43. // replace above function call with line below if wakka.php doesn't have a bad word function code in it
  44. //$dayschedule = preg_replace($badwords, $changeto, $dayschedule);
  45.  
  46. $query = "select * from ".$this->config['table_prefix']."scheduler";
  47. $result = mysql_query($query);
  48.  
  49. if ($_POST['save']){
  50.     // Kasper added to delete the empty schedule
  51.   $del = "delete from ".$this->config['table_prefix']."scheduler where dayschedule = ''";
  52.   $delresult = mysql_query($del);
  53.   $up = 0;
  54.     while ($row = mysql_fetch_object($result))
  55.     {      
  56.         if($row->user == $username && $row->month == $month && $row->day == $today && $row->year == $year)
  57.         {
  58.          $up = 1;      
  59.          $ro = $row->id;      
  60.         }                    
  61.     }
  62.  
  63.     if($up == 1)
  64.     {        
  65.         $query = "UPDATE ".$this->config['table_prefix']."scheduler SET dayschedule='$dayschedule' WHERE user='$username' AND id='$ro'";
  66.         $result = mysql_query($query);
  67.     }else{      
  68.         $query = "INSERT into ".$this->config['table_prefix']."scheduler (user,dayschedule,month,day,year) VALUES ('$username','$dayschedule','$month','$today','$year')";
  69.         $result = mysql_query($query);              
  70.     }
  71. }
  72.  
  73. // end kasper
  74. ?>
  75.  
  76. <table BGCOLOR="#DDccbb">
  77.     <tr>
  78.         <td valign="top">
  79. <?php
  80.     /*== get what weekday the first is on ==*/
  81.     $tmpd = getdate(mktime(0,0,0,$month,1,$year));
  82.     $monthname = $tmpd["month"];
  83.     $firstwday= $tmpd["wday"];
  84.     $lastday = mk_getLastDayofMonth($month,$year);
  85. ?>
  86. <table cellpadding="2" cellspacing="0" border="1">
  87.     <tr BGCOLOR="#ffffff">
  88.         <td colspan="7">
  89.             <table cellpadding="0" cellspacing="0" border="0" width="100%">
  90.                 <tr  BGCOLOR="#ffffff">
  91.                     <td width="20"><a href="<?php echo $this->href("", "", "month="); echo (($month-1)<1) ? 12 : $month-1 ; ?>&amp;year=<?php echo (($month-1)<1) ? $year-1 : $year ; ?>">&lt;&lt;&lt;</a></td>
  92.                     <td align="center"><font size="2"><?php echo "$monthname $year"; ?></font></td>
  93.                     <td width="20"><a href="<?php echo $this->href("", "", "month="); echo (($month+1)>12) ? 1 : $month+1 ; ?>&amp;year=<?php echo (($month+1)>12) ? $year+1 : $year ; ?>">&gt;&gt;&gt;</a></td>
  94.                 </tr>
  95.             </table>
  96.       </td>
  97.     </tr>
  98.     <tr BGCOLOR="#DDccbb">
  99.         <td width="22">Su</td>
  100.         <td width="22">Mo</td>
  101.         <td width="22">Tu</td>
  102.         <td width="22">We</td>
  103.         <td width="22">Th</td>
  104.         <td width="22">Fr</td>
  105.         <td width="22">Sa</td>
  106.     </tr>
  107.     <?php
  108.     $day = 1;
  109.     $wday = $firstwday;
  110.     $firstweek = true;
  111.  
  112.     /*== loop through all the days of the month ==*/
  113.     while ( $day <= $lastday)
  114.     {
  115.         /*== set up blank days for first week ==*/
  116.         if ($firstweek) {
  117.             print "    <tr  BGCOLOR=\"#ffffff\">";
  118.             for ($i=1; $i<=$firstwday; $i++)
  119.             { print "        <td><font size=\"2\">&nbsp;</font></td>"; }
  120.             $firstweek = false;
  121.         }
  122.  
  123.         /*== Sunday start week with <tr> ==*/
  124.         if ($wday==0) { print "    <tr BGCOLOR=\"#ffffff\">\n"; }
  125.  
  126.          /*== check for event ==*/
  127.          print "        <td>";
  128.         if($day<10) {
  129.             if($month<10) {
  130.                 $tag = "$year:0$month:0$day";
  131.             } else {
  132.                 $tag = "$year:$month:0$day";
  133.             }
  134.         } else {
  135.             if($month<10) {
  136.                 $tag = "$year:0$month:$day";
  137.             } else {
  138.                 $tag = "$year:$month:$day";
  139.             }
  140.         }
  141.        
  142.         $todaydate = date("Y:m:d",mktime());
  143.         if($tag==$todaydate)
  144.         {
  145.             $font1 = "<font color=\"#FF0000\"><b>";
  146.             $font2 = "</b></font>";
  147.         }
  148.         else
  149.         {
  150.             $font1 = "";
  151.             $font2 = "";
  152.         }
  153.         print "<a href=".$site_base.$thispage."&day=$day&month=$month&year=$year>$font1$day$font2</a>";
  154.         print "</td>\n";
  155.  
  156.         /*== Saturday week with </tr> ==*/
  157.         if ($wday==6) { print "    </tr>\n"; }
  158.  
  159.         $wday++;
  160.         $wday = $wday % 7;
  161.         $day++;
  162.     }
  163. ?>
  164.     </tr>
  165. </table>
  166.  
  167.         </td>
  168.     </tr>
  169. </table>
  170.  
  171. <?php
  172. /*== get the last day of the month ==*/
  173. function mk_getLastDayofMonth($mon,$year)
  174. {
  175.   for ($tday=28; $tday <= 31; $tday++)
  176.   {
  177.     $tdate = getdate(mktime(0,0,0,$mon,$tday,$year));
  178.     if ($tdate["mon"] != $mon) break;
  179.   }
  180. $tday--;
  181. return $tday;
  182. }
  183. ?>
  184. <!-- Comment line below out if you don't want to link to the formatted schedule page-->
  185. <center><a href=<? echo $site_base; ?>DaySchedule&amp;<? echo "month=".$month."&amp;day=".$today."&amp;year=".$year; ?>><small>Day Schedule</small></a>
  186. &nbsp;|&nbsp;
  187. <a href=<? echo $site_base; ?>MonthSchedule&amp;<? echo "month=".$month."&amp;day=".$today."&amp;year=".$year; ?>><small>Month Schedule</small></a></center>
  188.       </TD>
  189.       <TD WIDTH=500>
  190.     <P>
  191.  
  192. <?php
  193. if ($user = $this->GetUser())
  194. {
  195.   $dayschedule = str_replace("\n", ",", $_POST['dayschedule']);
  196.  
  197.     // title over textarea box
  198.   $printowner = $username."'s Schedule for ";
  199.   $dayschedule = $this->LoadSingle("SELECT dayschedule FROM ".$this->config["table_prefix"]."scheduler WHERE user='".$username."' AND day='".$today."' AND month='".$month."' AND year='".$year."'");
  200. // replaced a comma with XXZXX below....I don't know what the purpose of the code is...
  201.   $dayschedule = str_replace("XXZXX", "\n", $dayschedule[dayschedule]);
  202.   $output = str_replace(",", " ", $dayschedule[dayschedule]);
  203. ?>
  204.          <br><a href="<?php echo $this->href("", "", "day="); echo (($today-1)<1) ? $lastday : $today-1 ; ?>&amp;year=<?php echo $year; ?>&amp;month=<?php echo $month; ?>">&lt;&lt;</a>
  205.         <b><? echo "$printowner$monthname $today, $year:"; ?></b>
  206.         <a href="<?php echo $this->href("", "", "day="); echo (($today+1)>$lastday) ? 1 : $today+1 ; ?>&amp;year=<?php echo $year; ?>&amp;month=<?php echo $month; ?>">&gt;&gt;</a>
  207.         <form action="" method="post">
  208.             <textarea cols="65" rows="12" name="dayscheduleX"><?php echo $dayschedule; ?></textarea>
  209.             <input type="submit" value="Submit" />
  210.                <input type="hidden" name="save" value="true" />
  211.         </form>
  212. <?
  213. }
  214. else
  215. {
  216. echo "<em>The Scheduler only works for logged-in users.</em>";
  217. } ?>
  218. </P>
  219.       </TD>
  220.    </TR>
  221. </TABLE>
  222. </div>


The following is the action which shows a formatted output for a selected day....the current day (by default) or for any other day (using a link from the scheduler.php & monthview.php actions)....it should be saved into the actions directory as dayschedule.php and for proper functioning with scheduler.php should be placed on a page called DaySchedule.
  1. <?php
  2. // This script was developed by G. Michael Bowen for a SSHRC research project using wikka wiki.
  3. // This action complements the scheduler.php action showing the day schedule for that user.
  4. // DaySchedule Version 1c -- Jan 6, 2005
  5. // This action should be placed on a page called "DaySchedule" to work with the scheduler.
  6. // Code copyright GMBowen. Released to public domain under GPL. Modify, improve, change as you wish.
  7.  
  8. $month = (!isset($_GET['month'])) ? date("n",mktime()) : $_GET['month'];    
  9. // $monthname = $month;
  10. $tmpd = getdate(mktime(0,0,0,$month,1,$year));
  11. $monthname = $tmpd["month"];
  12. $year = (!isset($_GET['year'])) ? date("Y",mktime()) : $_GET['year'];
  13. $today = (!isset($_GET['day'])) ? date("d",mktime()) : $_GET['day'];
  14. $site_base = $this->GetConfigValue("base_url");
  15. $thispage=$this->GetPageTag();
  16. $lastday = getLastDayofMonth($month,$year);
  17.  
  18. /*== get the last day of the month ==*/
  19. function getLastDayofMonth($mon,$year)
  20. {
  21.   for ($tday=28; $tday <= 31; $tday++)
  22.   {
  23.     $tdate = getdate(mktime(0,0,0,$mon,$tday,$year));
  24.     if ($tdate["mon"] != $mon) break;
  25.   }
  26. $tday--;
  27. return $tday;
  28. }
  29.  
  30. // gets username
  31. $username = $this->GetUserName();
  32. $user = $username;
  33.  
  34. $dayschedule = $this->LoadSingle("SELECT dayschedule FROM ".$this->config["table_prefix"]."scheduler WHERE user='".$username."' AND day='".$today."' AND month='".$month."' AND year='".$year."'");
  35. $printout = str_replace("\n", "<HR></TD></TR><TR ALIGN='left'><TD>", $dayschedule[dayschedule]);   
  36. $printowner = $username."'s entries for ";
  37. ?>
  38. <div align="center">
  39. <center>      <a href="<?php echo $this->href("", "", "day="); echo (($today-1)<1) ? $lastday : $today-1 ; ?>&amp;year=<?php echo $year; ?>&amp;month=<?php echo $month; ?>">&lt;&lt;</a>
  40.         <b><? echo "$printowner$monthname $today, $year:"; ?></b>
  41.         <a href="<?php echo $this->href("", "", "day="); echo (($today+1)>$lastday) ? 1 : $today+1 ; ?>&amp;year=<?php echo $year; ?>&amp;month=<?php echo $month; ?>">&gt;&gt;</a>
  42.  
  43. <TABLE class='box' width='600' border='1' CELLSPACING='1' CELLPADDING='7' BGCOLOR='#DDccbb'>
  44.    <TR>
  45.       <TD>
  46. <P><TABLE class='box' width='100%' border='0' CELLSPACING='0' CELLPADDING='2' BGCOLOR='#ffffff'>
  47.    <TR ALIGN='left'>
  48.       <TD>
  49.          <P>
  50. <?
  51. if ($user = $this->GetUser())
  52. {
  53.     if(!empty($printout))
  54.         {
  55.         echo $printout;
  56.         }
  57.         else
  58.         {
  59.         echo "There are no entries on this day.";
  60.         }
  61. }
  62. else
  63. {
  64. echo "<em>Showing the day schedule only works for logged-in users.</em>";
  65. }
  66. ?>
  67. </P>
  68.       </TD>
  69.    </TR>
  70. </TABLE>
  71.       </TD>
  72.    </TR>
  73. </TABLE>
  74. <center><a href=<? echo $site_base; ?>ScheDuler&amp;<? echo "month=".$month."&amp;day=".$today."&amp;year=".$year; ?>><small>Small Scheduler</small></a>
  75. &nbsp;|&nbsp;
  76. <a href=<? echo $site_base; ?>MonthSchedule&amp;<? echo "month=".$month."&amp;day=".$today."&amp;year=".$year; ?>><small>Month Scheduler</small></a></center>
  77. </center></div>

This is a screenshot of the dayschedule.php output...
http://gmbtst.msvu.ca/wikitest/dayschedule.jpg

This final action show a month-view with all of the entries. It should be saved into the actions directory as monthscheduler.php and for proper functioning with scheduler.php the action should be placed on a page called MonthSchedule.
  1. <?php
  2. // Month Scheduler Version 1.0c - Jan 7, 2005 - bad word function call
  3. // The original parts of this script were developed by G. Michael Bowen And Mark Kasper for a SSHRC research project using wikka wiki.
  4. // As far as it is possible to tell (because the code exists all over the web), we provide credit for the original calendar code
  5. // to Marcus Kazmierczak which was released at www.blazonry.com, although this script builds considerably on that code.
  6. // Code additions copyright GMBowen & Mark Kasper, 2004. Released to public domain under GPL. Modify, improve, change as you wish.
  7. // There are two complementary actions. dayschedule.php allows anyone to designate an owner & date to see their schedule (see line 140)
  8. // and it should be placed on a page named "DaySchedule". The other action, scheduler.php, is a small version of the calendar action
  9. // which allows easy and fast entering of data on different days.
  10. ?>
  11. <div align="center">
  12. <P><TABLE BORDER=0 width=100%>
  13.    <TR>
  14.       <TD>
  15.          <P>
  16. <?php
  17. $month = (!isset($_GET['month'])) ? date("n",mktime()) : $_GET['month'];    
  18. $year = (!isset($_GET['year'])) ? date("Y",mktime()) : $_GET['year'];
  19. $today = (!isset($_GET['day'])) ? date("d",mktime()) : $_GET['day'];
  20.  
  21. $site_base = $this->GetConfigValue("base_url");
  22. $thispage=$this->GetPageTag();
  23. $username = $this->GetUserName();
  24.  
  25. // badword array for replacing badwords (not initialized as currently using added function in wakka.php)
  26. //$badwords = Array ('/motherfucker/i', '/cunt/i', '/fuck/i', '/cocksucker/i', '/bitch/i', '/son of a bitch/i', '/asshole/i', '/shit/i', '/fag/i', '/wank/i', '/dick/i', '/pussy/i', '/bastard/i', '/molester/i', '/molezter/i', '/cock/i');
  27. //$changeto = '****';
  28.  
  29. // gets username
  30. $username = $this->GetUserName();
  31.  
  32. // kasper
  33. //  NOTE VERY IMPORTANT,  if the table is totally empty the function will not work, you
  34. //                        must add one in maually for this function to work.
  35. //                        I could add it in the code but very messy, will come up with better way.
  36.  
  37. $dayschedule = $_POST['dayscheduleX'];
  38. include_once("./scripts/badwordfunction.php");
  39. $dayschedule = BadWordFunction($dayschedule);
  40. $dayschedule = addslashes($dayschedule);  // for single quotes to work
  41.  
  42.  
  43. // replace above function call with line below if wakka.php doesn't have a bad word function code in it
  44. //$dayschedule = preg_replace($badwords, $changeto, $dayschedule);
  45.  
  46. $query = "select * from ".$this->config['table_prefix']."scheduler";
  47. $result = mysql_query($query);
  48.  
  49. if ($_POST['save']){
  50.     // Kasper added to delete the empty schedule
  51.   $del = "delete from ".$this->config['table_prefix']."scheduler where dayschedule = ''";
  52.   $delresult = mysql_query($del);
  53.   $up = 0;
  54.     while ($row = mysql_fetch_object($result))
  55.     {      
  56.         if($row->user == $username && $row->month == $month && $row->day == $today && $row->year == $year)
  57.         {
  58.          $up = 1;      
  59.          $ro = $row->id;      
  60.         }                    
  61.     }
  62.  
  63.     if($up == 1)
  64.     {        
  65.         $query = "UPDATE ".$this->config['table_prefix']."scheduler SET dayschedule='$dayschedule' WHERE user='$username' AND id='$ro'";
  66.         $result = mysql_query($query);
  67.     }else{      
  68.         $query = "INSERT into ".$this->config['table_prefix']."scheduler (user,dayschedule,month,day,year) VALUES ('$username','$dayschedule','$month','$today','$year')";
  69.         $result = mysql_query($query);              
  70.     }
  71. }
  72. // end kasper
  73. ?>
  74. <table>
  75.     <tr>
  76.         <td valign="top">
  77. <?php
  78.     /*== get what weekday the first is on ==*/
  79.     $tmpd = getdate(mktime(0,0,0,$month,1,$year));
  80.     $monthname = $tmpd["month"];
  81.     $firstwday= $tmpd["wday"];
  82.     $lastday = mk_getLastDayofMonth($month,$year);
  83. ?>
  84. <table cellpadding="2" cellspacing="0" border="1">
  85.     <tr>
  86.         <td colspan="7">
  87.             <table cellpadding="0" cellspacing="0" border="0" width="100%">
  88.                 <tr>
  89.                     <td width="20"><a href="<?php echo $this->href("", "", "month="); echo (($month-1)<1) ? 12 : $month-1 ; ?>&amp;year=<?php echo (($month-1)<1) ? $year-1 : $year ; ?>">&lt;&lt;&lt;</a></td>
  90.                     <td align="center"><font size="2"><strong><? echo $username ?>'s Calendar for <?php echo "$monthname $year"; ?></strong></font></td>
  91.                     <td width="20"><a href="<?php echo $this->href("", "", "month="); echo (($month+1)>12) ? 1 : $month+1 ; ?>&amp;year=<?php echo (($month+1)>12) ? $year+1 : $year ; ?>">&gt;&gt;&gt;</a></td>
  92.                 </tr>
  93.             </table>
  94.       </td>
  95.     </tr>
  96.     <tr BGCOLOR="#DDccbb">
  97.         <td>Sunday</td>
  98.         <td>Monday</td>
  99.         <td>Tuesday</td>
  100.         <td>Wednesday</td>
  101.         <td>Thursday</td>
  102.         <td>Friday</td>
  103.         <td>Saturday</td>
  104.     </tr>
  105.     <?php
  106.     $day = 1;
  107.     $wday = $firstwday;
  108.     $firstweek = true;
  109.  
  110.     /*== loop through all the days of the month ==*/
  111.     while ( $day <= $lastday)
  112.     {
  113.         /*== set up blank days for first week ==*/
  114.         if ($firstweek) {
  115.             print "    <tr>";
  116.             for ($i=1; $i<=$firstwday; $i++)
  117.             { print "        <td VALIGN=top ALIGN=left HEIGHT=70><font size=\"2\">&nbsp;</font></td>"; }
  118.             $firstweek = false;
  119.         }
  120.  
  121.         /*== Sunday start week with <tr> ==*/
  122.         if ($wday==0) { print "    <tr>\n"; }
  123.  
  124.          /*== check for event ==*/
  125.          print "        <td VALIGN=top ALIGN=left WIDTH=150 HEIGHT=70>";
  126.         if($day<10) {
  127.             if($month<10) {
  128.                 $tag = "$year:0$month:0$day";
  129.             } else {
  130.                 $tag = "$year:$month:0$day";
  131.             }
  132.         } else {
  133.             if($month<10) {
  134.                 $tag = "$year:0$month:$day";
  135.             } else {
  136.                 $tag = "$year:$month:$day";
  137.             }
  138.         }
  139.        
  140.         $todaydate = date("Y:m:d",mktime());
  141.         if($tag==$todaydate)
  142.         {
  143.             $font1 = "<font color=\"#FF0000\"><b>";
  144.             $font2 = "</b></font>";
  145.         $token="yes";  
  146.         }
  147.         else
  148.         {
  149.             $font1 = "";
  150.             $font2 = "";
  151.         $token="no";
  152.         }
  153. // code to determine what data should be entered into each cell
  154.     $thisdayschedule = $this->LoadSingle("SELECT dayschedule FROM ".$this->config["table_prefix"]."scheduler WHERE user='".$username."' AND day='".$day."' AND month='".$month."' AND year='".$year."'");
  155.     $dayoutput = str_replace("\n", "<br> ", $thisdayschedule[dayschedule]);
  156.     if ($token=="yes")
  157.         {
  158.         $printme="<a href=".$site_base."DaySchedule&month=".$month."&amp;day=".$today."&amp;year=".$year."><small>[Print Day]</small></a>";
  159.         }
  160.         else
  161.         {
  162.         $printme="";
  163.         }
  164.         print "<table width=\"100%\"><TR BGCOLOR=\"#E4DFDA\"><td><a href=".$site_base.$thispage."&day=$day&month=$month&year=$year#EntryBox>&nbsp;$font1$day$font2</a>&nbsp;$printme</td</tr><tr><td><small>$dayoutput</small></td></tr></table>";
  165.         print "</td>\n";
  166.  
  167.         /*== Saturday week with </tr> ==*/
  168.         if ($wday==6) { print "    </tr>\n"; }
  169.  
  170.         $wday++;
  171.         $wday = $wday % 7;
  172.         $day++;
  173.     }
  174. ?>
  175.     </tr>
  176. </table>
  177.  
  178.         </td>
  179.     </tr>
  180. </table>
  181. <?php
  182. /*== get the last day of the month ==*/
  183. function mk_getLastDayofMonth($mon,$year)
  184. {
  185.   for ($tday=28; $tday <= 31; $tday++)
  186.   {
  187.     $tdate = getdate(mktime(0,0,0,$mon,$tday,$year));
  188.     if ($tdate["mon"] != $mon) break;
  189.   }
  190. $tday--;
  191. return $tday;
  192. }
  193. ?>
  194. <!-- Comment below 3 lines out if you don't want to link to the formatted schedule page & scheduler page.-->
  195. <center><a href=<? echo $site_base; ?>DaySchedule&amp;<? echo "month=".$month."&amp;day=".$today."&amp;year=".$year; ?>><small>Formatted Day Page</small></a>
  196. &nbsp;|&nbsp;
  197. <a href=<? echo $site_base; ?>Scheduler&amp;<? echo "month=".$month."&amp;day=".$today."&amp;year=".$year; ?>><small>Small Monthly Calendar</small></a></center>
  198.  
  199.        </TD>
  200.     </tr><tr>
  201.       <TD WIDTH=500>
  202.     <P>
  203. <?
  204. if ($user = $this->GetUser())
  205. {
  206.   $dayschedule = str_replace("\n", ",", $_POST['dayschedule']);
  207.  
  208.     // title over textarea box
  209.   $printowner = $username."'s Schedule for ";
  210.   $dayschedule = $this->LoadSingle("SELECT dayschedule FROM ".$this->config["table_prefix"]."scheduler WHERE user='".$username."' AND day='".$today."' AND month='".$month."' AND year='".$year."'");
  211. // replaced a comma with XXZXX below....I don't know what the purpose of the code is...
  212.   $dayschedule = str_replace("XXZXX", "\n", $dayschedule[dayschedule]);
  213.   $output = str_replace(",", " ", $dayschedule[dayschedule]);
  214. ?>
  215. <center><A NAME=EntryBox></A>
  216.       <a href="<?php echo $this->href("", "", "day="); echo (($today-1)<1) ? $lastday : $today-1 ; ?>&amp;year=<?php echo $year; ?>&amp;month=<?php echo $month; ?>">&lt;&lt;</a>
  217.         <b><? echo "$printowner$monthname $today, $year:"; ?></b>
  218.         <a href="<?php echo $this->href("", "", "day="); echo (($today+1)>$lastday) ? 1 : $today+1 ; ?>&amp;year=<?php echo $year; ?>&amp;month=<?php echo $month; ?>">&gt;&gt;</a>
  219.         <center><form action="" method="post">
  220.             <textarea cols="65" rows="12" name="dayscheduleX"><?php echo $dayschedule; ?></textarea>
  221.             <input type="submit" value="Submit" />
  222.                <input type="hidden" name="save" value="true" />
  223.         </form></center>   
  224. </center>
  225. <?
  226.     }
  227.     else
  228.     {
  229. echo "<em>The Scheduler only works for logged-in users.</em>";
  230.     }
  231. ?>
  232. </P>
  233.       </TD>
  234.    </TR>
  235. </TABLE>
  236. </div>

The following is a screen shot of the monthscheduler.
http://gmbtst.msvu.ca/wikitest/monthview.jpg

Task Manager

The task manager has two components. One is called mytasks.php which shows the task list of the logged in user & allows you to edit your task lists. The other is a (highly) modified version called usertasks.php which can be used to look at the task list of other users. It allows multiple instances of the action on the same page (so you can keep the task lists of all 3 people on the project in one page at once). It REQUIRES the usertasksfunctions.php file to be placed in a directory called "scripts" in the wiki root directory. The functions in it have been re-named from those in mytasks.php so you can have mytasks.php & usertasks.php on the same page (but only ONE copy of mytasks.php).
http://gmbtst.msvu.ca/wikitest/taskmanager.jpg

Note that there is a function code conflict in the mytasks.php action that causes problems if two copies are put on one page. JavaWoman steered me towards include_once() and require_once() which I implemented in wikkaforum & usertasks.php which works quite well. I'll work at implementing it here for the mytasks.php manager code in the coming week.


Save the below code as mytasks.php and place in the actions directory (REMEMBER, it needs the Bad Word Function included in wakka.php for now...the code is at the bottom of the page).
  1. <?
  2. // This {{action}} script for derivations of wakka wiki is heavily modified from a standalone single-script package
  3. // produced by and provided by the author identified in the text box below....although it is released by her as a "free to use"
  4. // script, no mention is made of any problems with commercial use. If you intend on using this action script modified from the
  5. // geniusbug code, especially for commercial purposes, you should contact the original author for permission to use the original
  6. // components. All modifications of the original script by G. Michael Bowen & Mark Kasper are provided under a GPL license.
  7. // Ongoing attribution of authorial contributions in any future modifications would be appreciated.
  8. ////////////////////////////////////////
  9. //  GBTask Task Manager               //
  10. //  Naomi C. Martinson                //
  11. //  2002 © http://www.geniusbug.com   //
  12. //  Don't remove this message         //
  13. //  Contact: naomi@geniusbug.com      //
  14. ////////////////////////////////////////
  15. if ($this->method == "show") {
  16. global $linktm;
  17. $linktm = $this->config["base_url"].$this->MiniHref($method, $tag);
  18. $delete_id = $_REQUEST['delete_id'];
  19. $edit_id = $_REQUEST['edit_id'];
  20. $task_id = $_REQUEST['task_id'];
  21. $add_id = $_POST['add_id'];
  22. $task_title = $_POST['task_title'];
  23. $task_content = $_POST['task_content'];
  24. $task_status = $_POST['task_status'];
  25. $order1 = $_REQUEST['order1'];
  26. $dir1 = $_REQUEST['dir1'];
  27.  
  28. $task_owner = $this->GetUserName();
  29.  
  30. // kasper
  31. if($_REQUEST['tm_page'] == '' || $_REQUEST['tm_page'] == NULL){$tm_page = '1';}else{$tm_page = $_REQUEST['tm_page'];}
  32.  
  33. $update_id = $_POST[update_id];
  34. $tm_direction = $_REQUEST[dir];
  35. $keyword = $_POST[keyword];
  36. if ($items == '' || $items =='0') { $items = 10;}
  37. $items_per_page = $items;
  38. session_start();
  39.  
  40. session_register("records_page");
  41. $records_page = $items_per_page;
  42.  
  43. if(isset($tm_order)){
  44.     session_register("list_order");
  45.     $list_order = $tm_order;
  46. }
  47.  
  48. if(isset($tm_direction)){
  49.     session_register("list_dir");
  50.     $list_dir = $tm_direction;
  51. }
  52.  
  53. if(isset($set_theme)){
  54.     session_register("theme");
  55.     $theme = $set_theme;
  56. }
  57.  
  58. if (isset($showsource)) {
  59.     show_source($HTTP_SERVER_VARS["SCRIPT_FILENAME"]);
  60.     exit;
  61. }
  62.  
  63. //delete statement
  64. if (strlen($delete_id) > 0){
  65.     $strSQL = "UPDATE ".$this->config["table_prefix"]."task SET task_delete = '1' WHERE task_id = ".$delete_id;
  66.     mysql_query($strSQL);
  67. }
  68.  
  69. if (strlen($update_id) > 0){
  70.  
  71. // Bad Word Filter For Messages - Just erase the below line if you want people to be able to enter bad words.
  72. $task_content = BadWordFunc($task_content);
  73. $task_title = BadWordFunc($task_title);
  74.  
  75.     $strSQL = "UPDATE ".$this->config["table_prefix"]."task SET user = '".$task_owner."', task_title = '".$task_title."', task_content = '".$task_content."', task_status = '".$task_status."' WHERE task_id=".$update_id;
  76.     mysql_query($strSQL);
  77.  
  78. //redirect sending a header to the server
  79. header("Location: ".$linktm."&tm_page=".$tm_page);
  80. exit;
  81. }
  82.  
  83. $delete_id = $_REQUEST['delete_id'];
  84. $edit_id = $_REQUEST['edit_id'];
  85. //$tm_page = $_REQUEST['tm_page'];
  86. $task_id = $_REQUEST['task_id'];
  87. $add_id = $_POST['add_id'];
  88. $task_title = $_POST['task_title'];
  89. $task_content = $_POST['task_content'];
  90. $task_status = $_POST['task_status'];
  91. //$task_owner = $this->GetPageOwner();
  92.  
  93. //add statement
  94. if (strlen($add_id) > 0){
  95.     $task_timestamp = date("Y-m-d H:i:s",mktime());    
  96.  
  97. //$task_status = "Incomplete";
  98.  
  99. // Bad Word Filter For Messages - Just erase the below line if you want people to be able to enter bad words.
  100. $task_content = BadWordFunc($task_content);
  101. $task_title = BadWordFunc($task_title);
  102.  
  103.     $strSQL = "INSERT Into ".$this->config["table_prefix"]."task (user, task_timestamp, task_title, task_content, task_status) VALUES ('$task_owner','$task_timestamp', '$task_title', '$task_content', '$task_status')";
  104.     mysql_query($strSQL);
  105.  
  106. //redirect sending a header to the server    
  107. header("Location: ".$linktm."&tm_page=".$tm_page);
  108. exit;
  109. }
  110.  
  111. //resume to 10 items per page
  112. if(!isset($records_page)){
  113.     $records_page = 10;
  114. }
  115.  
  116. // GMB Changed below line to include "where" statement
  117.  
  118. $strSQL = "SELECT * From ".$this->config["table_prefix"]."task WHERE user = '$task_owner' AND task_delete = '0'";
  119. $query = mysql_query($strSQL);
  120.  
  121. $total_records = mysql_num_rows($query);
  122. mysql_free_result($query);
  123.  
  124. if (!isset($tm_page)) {
  125.     $tm_page=1;
  126. }
  127. $num_pages = ceil($total_records / $records_page);
  128. for ($i=1;$i<=$num_pages;$i++) {
  129.     $tm_page_nav = $tm_page_nav."[<a href=\"".$linktm."&tm_page=".$i."\">".$i."</a>]&nbsp;\n";
  130. }
  131.  
  132. //header
  133. echo "<html><head>\n";
  134. //echo "<style type=\"text/css\">\n";
  135. echo "<!-- \n";
  136. echo "body {color:gray; font-size:10px; font-family:verdana,arial;}\n";
  137. echo "td {color:gray; font-size:10px; font-family:verdana,arial;}\n";
  138. echo "--> \n";
  139. echo "</style>\n";
  140. echo "</head>\n";
  141. echo "<body bgcolor=\"white\">\n";
  142.  
  143. echo "<table width=90% cellpadding=0 cellspacing=0 border=0 align=center><tr><td bgcolor=white align=\"center\" valign=top>\n";
  144.  
  145. //html header, search form items, per page form
  146. echo "<form method=post action=\"".$linktm."\">\n";
  147. echo "<span style='color:gray; font-size:10px; font-family:verdana,arial;'> Task Owner: $task_owner </span>";
  148. echo "<table width=75% cellpadding=0 cellspacing=0 border=0 valign=bottom><tr>\n";
  149. echo "<td bgcolor=\"#949AE7\" valign=bottom><img src=\"images/trs.gif\" width=1 height=1></td>\n";
  150. echo "</tr></table>\n";
  151. echo "<table width=75% cellpadding=0 cellspacing=0 border=0><tr>\n";
  152. echo "<td bgcolor=\"E9EBF3\">
  153.        <table width=100%><tr>
  154.           <td align=left>
  155.           <span style='color:gray; font-size:10px; font-family:verdana,arial;'> <!-- Page Owner: $task_owner -->
  156.           Pages: $tm_page_nav <a href=\"$linktm#tip1\"><font color=\"red\"><b><u>*</u></b></font></a> (Pg: $tm_page)</td>
  157.           <td align=center><a href=\"$linktm\"><b>
  158.           <span style='color:gray; font-size:10px; font-family:verdana,arial;'>
  159.           [HOME]</b></a>&nbsp;&nbsp;<a href=\"".$linktm."&task_id=ALL&tm_page=$tm_page&order1=task_title&dir1=DESC\"><b><span style='color:gray; font-size:10px; font-family:verdana,arial;'>[SHOW ALL]</b></a></td>
  160.           <td align=right><input type=text size=15 value=\"keyword\" name=\"keyword\"><input type=submit value=\"Search\"></td>
  161.         </tr></table>
  162.       </td>\n";
  163. echo "</tr></table>\n";
  164. echo "</form>\n";
  165.  
  166. //search function
  167. function get_results($keyword, $linktm, $tm_page, $task_owner, $owner) {        
  168.     //search the database
  169.     $strSQL = "SELECT * From ".$this->config["table_prefix"]."task WHERE task_delete = '0' AND user = '$task_owner' AND task_title LIKE '%".$keyword."%' OR task_content LIKE '%".$keyword."%'";
  170.     $results = mysql_query($strSQL);
  171.    
  172.     if (mysql_num_rows($results) > 0) {
  173.        
  174.         echo "<br>Your keyword is: <b>".$keyword."</b><P>\n";
  175.         echo "<table width=75% cellpadding=4 cellspacing=2 border=0>\n";
  176.         while($mykey = mysql_fetch_array($results)){
  177.            
  178.             //list the results
  179.             echo "<tr>\n";
  180.             echo "<td bgcolor=\"#E9E9E9\" align=left valign=top><font color=white><img src=\"images/trs.gif\" width=70 height=1><br><nobr>\n";
  181.            
  182.             switch ($mykey["task_status"]) {
  183.             case "Incomplete":
  184.             echo "<font color=red>".$mykey["task_status"]."</font>\n";
  185.             break;
  186.            
  187.             case "In Progress":
  188.             echo "<font color=blue>".$mykey["task_status"]."</font>\n";
  189.             break;
  190.            
  191.             case "Complete":
  192.             echo "<font color=green>".$mykey["task_status"]."</font>\n";
  193.             break;
  194.             }
  195.            
  196.             echo "</nobr></font></td>\n";
  197.             echo "<td bgcolor=\"#F3F0F9\" align=left valign=top width=75%><a href=\"".$linktm."&task_id=".$mykey["task_id"]."&tm_page=$page\">".$mykey["task_title"]."</a> (posted on:".$mykey["task_timestamp"].")</td>\n";
  198.             echo "</tr>\n";
  199.         }
  200.         echo "</table>\n";
  201.     }else{
  202.         echo "<P><font color=red>SORRY, NO MATCH!</font><P>\n";
  203.     }
  204.     mysql_free_result($results);
  205. }
  206.  
  207. //view item after search function
  208. function item($task_id, $linktm, $tm_page, $task_owner, $owner, $order1, $dir1) {
  209.     if($task_id == 'ALL'){
  210.    
  211.      $strSQL = "SELECT * From ".$this->config["table_prefix"]."task WHERE task_delete = '0' AND user='$task_owner' ORDER By $order1 $dir1"; //kasper AND task_id =".$task_id;
  212.      $query = mysql_query($strSQL);
  213.    
  214.     echo "<table width=75% cellpadding=4 cellspacing=2 border=0>\n";
  215.     echo "<tr>";
  216.     echo "<td bgcolor=\"#BBBDD9\" width=112px valign=top><b>STATUS&nbsp;<a href=\"".$linktm."&task_id=ALL&order1=task_title&dir1=DESC&num=\"><img src=\"images/up.gif\" width=11 height=16 border=0></a> <a href=\"".$linktm."&task_id=ALL&order1=task_title&dir1=ASC\"><img src=\"images/down.gif\" width=11 height=16 border=0></a></td>\n";
  217.     echo "<td bgcolor=\"#BBBDD9\" valign=top><b>TASK</b> <a href=\"".$linktm."&task_id=ALL&order1=task_status&dir1=DESC\"><img src=\"images/up.gif\" width=11 height=16 border=0></a> <a href=\"".$linktm."&task_id=ALL&order1=task_status&dir1=ASC\"><img src=\"images/down.gif\" width=11 height=16 border=0></a></td>\n";
  218.     echo "<td bgcolor=\"#BBBDD9\" width=192px valign=top><b>ENTERED ON</b> <a href=\"".$linktm."&task_id=ALL&order1=task_timestamp&dir1=DESC\"><img src=\"images/up.gif\" width=11 height=16 border=0></a> <a href=\"".$linktm."&task_id=ALL&order1=task_timestamp&dir1=ASC\"><img src=\"images/down.gif\" width=11 height=16 border=0></a></td>\n";
  219.     echo "  
  220.           </tr>
  221.           </table>";
  222.            
  223.            
  224.       while ($item = mysql_fetch_object($query)){
  225.            
  226.            echo "<table width=76% cellpadding=4 cellspacing=2 border=0><tr><td>\n";
  227.            echo "<table width=100% cellpadding=1 cellspacing=1 border=0>\n";
  228.            echo "<tr><td bgcolor=\"#E9E9E9\" width=120px align=left valign=top><font color=white><img src=\"images/trs.gif\" width=70 height=1><br><nobr>&nbsp;&nbsp;\n";
  229.  
  230.            switch ($item->task_status) {
  231.               case "Incomplete":
  232.               echo "<font color=red>".$item->task_status."</font>\n";
  233.               break;
  234.    
  235.               case "In Progress":
  236.               echo "<font color=blue>".$item->task_status."</font>\n";
  237.               break;
  238.    
  239.               case "Complete":
  240.               echo "<font color=green>".$item->task_status."</font>\n";
  241.               break;
  242.            }
  243.    
  244.            echo "</nobr></font></td>\n";
  245.            echo "<td bgcolor=\"#BBBDD9\" align=left valign=top ><font color=white><b>&nbsp; ".strtoupper($item->task_title)."</b></font></td>";    
  246.            echo "<td width=200px bgcolor=\"#E9E9E9\" align=left valign=top ><center><font color=black>".$item->task_timestamp."</font></center></td></tr></table>\n";
  247.            echo "<table width=100% cellpadding=1 cellspacing=1 border=0><tr><td colspan=3 bgcolor=\"#E9E9E9\" align=left valign=top colspan=2> &nbsp; &nbsp;".str_replace("\n", "<br>", $item->task_content)."</td></tr>\n";
  248.            echo "</table></tr></td></table>\n";
  249.       }
  250.     }
  251.     else
  252.     {
  253.        $strSQL = "SELECT * From ".$this->config["table_prefix"]."task WHERE task_delete = '0' AND user='$task_owner' AND task_id =".$task_id;
  254.        $query = mysql_query($strSQL);
  255.        $item = mysql_fetch_array($query);
  256.        echo "<table width=75% cellpadding=4 cellspacing=2 border=0>\n";
  257.        echo "<td width=5% bgcolor=\"#E9E9E9\" align=left valign=top><font color=white><img src=\"images/trs.gif\" width=70 height=1><br><nobr>\n";
  258.  
  259.        switch ($item["task_status"]) {
  260.        case "Incomplete":
  261.        echo "<font color=red>".$item["task_status"]."</font>\n";
  262.        break;
  263.  
  264.        case "In Progress":
  265.        echo "<font color=blue>".$item["task_status"]."</font>\n";
  266.        break;
  267.  
  268.        case "Complete":
  269.        echo "<font color=green>".$item["task_status"]."</font>\n";
  270.        break;
  271.        }
  272.        echo "</nobr></font></td>\n";    
  273.        echo "<td bgcolor=\"#BBBDD9\" align=left valign=top width=75%><font color=white><b>".strtoupper($item["task_title"])."</b> (posted on: ".$item["task_timestamp"].")</font></td></tr>\n";
  274.        echo "<tr><td bgcolor=\"#F3F0F9\" align=left valign=top colspan=2>".str_replace("\n", "<br>", $item["task_content"])."</td></tr>\n";
  275.          
  276.           echo "<tr><td bgcolor=\"#F3F0F9\" align=left valign=top colspan=2><nobr><a href=\"".$linktm."&edit_id=".$item["task_id"]."&tm_page=$tm_page\"><b>EDIT</b></a> | \n";
  277.           echo "<a href=\"javascript: if(confirm('Are you sure you want to delete this item?')){ window.self.location='$linktm&delete_id=".$item["task_id"]."&tm_page=$tm_page' }\"><b>DELETE</b></a></nobr></td></tr>\n";    
  278.        
  279.        echo "</table>\n";
  280.     }
  281. }
  282.  
  283. //list items function
  284. function list_todo($tm_order, $tm_direction, $linktm, $tm_page, $records_page, $task_timestamp, $task_status, $task_owner, $owner) {
  285.  
  286.     if (!isset($tm_order)) {
  287.         $tm_order = "task_timestamp";
  288.     }
  289.    
  290.     if (!isset($tm_direction)) {
  291.         $tm_direction = "DESC";
  292.     }
  293.  
  294.     $begin = (($tm_page-1)*$records_page);
  295.     $strSQL = "SELECT * From ".$this->config["table_prefix"]."task WHERE task_delete = '0' AND user = '$task_owner' ORDER By $tm_order $tm_direction LIMIT $begin,$records_page";
  296.     $query = mysql_query($strSQL);
  297.  
  298. //ECHO 'START of list of items in the cell header information';
  299.  
  300.     echo "<table width=75% cellpadding=2 cellspacing=2 border=0>\n";
  301.     echo "<tr>\n";
  302.     echo "<td bgcolor=\"#BBBDD9\" valign=top>\n";
  303.     echo "<b>TASK <a href=\"".$linktm."&order=task_title&dir=DESC&num=\"><img src=\"images/up.gif\" width=11 height=16 border=0></a> <a href=\"".$linktm."&order=task_title&dir=ASC\"><img src=\"images/down.gif\" width=11 height=16 border=0></a></td>\n";
  304.     echo "<td bgcolor=\"#BBBDD9\" valign=top>\n";
  305.     echo "<b>ENTERED ON</b> <a href=\"".$linktm."&order=task_timestamp&dir=DESC\"><img src=\"images/up.gif\" width=11 height=16 border=0></a> <a href=\"".$linktm."&order=task_timestamp&dir=ASC\"><img src=\"images/down.gif\" width=11 height=16 border=0></a></td>\n";
  306.     echo "<td bgcolor=\"#BBBDD9\" valign=top>\n";
  307.     echo "<b>STATUS</b> <a href=\"".$linktm."&order=task_status&dir=DESC\"><img src=\"images/up.gif\" width=11 height=16 border=0></a> <a href=\"".$linktm."&order=$task_status&dir=ASC\"><img src=\"images/down.gif\" width=11 height=16 border=0></a></td>\n";
  308.      
  309.         echo "<td bgcolor=\"#BBBDD9\" valign=top><b>MODIFY</b> <img src=\"images/trs.gif\" width=11 height=16 border=0></td>\n";
  310.    
  311.     echo "</tr>\n";
  312.  
  313. //ECHO 'START of list of items after HEADER information (why is this in the wrong place??)';
  314.     //list todo items
  315.     while ($todo = mysql_fetch_array($query)) {
  316.     echo "<tr>\n";
  317.     echo "<td align=left bgcolor=\"#F3F0F9\" valign=top><span title=\"Description: ".$todo["task_content"]."\">".$todo["task_title"]."</span></td>\n";
  318.  
  319.     echo "<td bgcolor=\"#F3F0F9\" valign=top>".$todo["task_timestamp"]."</td>\n";
  320.        
  321.         //items status case
  322.         switch ($todo["task_status"]) {
  323.             case "Incomplete":        
  324.             echo "<td bgcolor=\"#E9E9E9\" valign=top><font color=red>".$todo["task_status"]."</font></td>\n";
  325.             break;
  326.  
  327.             case "In Progress":
  328.             echo "<td bgcolor=\"#E9E9E9\" valign=top><font color=blue>".$todo["task_status"]."</font></td>\n";
  329.             break;
  330.  
  331.             case "Complete":
  332.             echo "<td bgcolor=\"#E9E9E9\" valign=top><font color=green>".$todo["task_status"]."</font></td>\n";
  333.             break;
  334.         }
  335.        
  336.     //modify action
  337.      
  338.         echo "<td bgcolor=\"#F3F0F9\" valign=top><nobr>[<a href=\"".$linktm."&task_id=".$todo["task_id"]."&tm_page=$tm_page\"><b>view</b></a>|<a href=\"".$linktm."&edit_id=".$todo["task_id"]."&tm_page=$tm_page\"><b>edit</b></a></font>|";
  339.         echo "<a href=\"javascript: if(confirm('Are you sure you want to delete this item?')){ window.self.location='$linktm&delete_id=".$todo["task_id"]."&tm_page=$tm_page' }\"><b>delete</b></a>]</nobr></td>\n";
  340.  
  341.     echo "</tr>\n";    
  342.     }
  343.     echo "</table>\n";
  344.     mysql_free_result($query);
  345.    
  346.     //add todo item form
  347.  
  348.  
  349.     echo "<form method=post action=\"$linktm\">\n";
  350.     echo "<input type=hidden name=\"add_id\" value=1>\n";
  351.     echo "<input type=hidden name=\"page\" value=\"$page\">\n";
  352.     echo "<table width=75% cellpadding=4 cellspacing=1 border=0>\n";
  353.     echo "<tr><td bgcolor=\"#DADBEB\" align=right valign=top>\n";
  354.     echo "<font color=\"#000000\"><b>\n";
  355.     echo "NEW TITLE: </b></font></td>\n";
  356.     echo "<td bgcolor=\"#DADBEB\" align=left valign=top>\n";
  357.     echo "<input type=text size=30 name=\"task_title\"></td>\n";
  358.     echo "</tr><tr>\n";
  359.     echo "<td bgcolor=\"#DADBEB\" align=right valign=top>\n";
  360.     echo "<font color=\"#000000\"><b>\n";
  361.     echo "DESCRIPTION: </b></font></td>\n";
  362.     echo "<td bgcolor=\"#DADBEB\" align=left valign=top>\n";
  363.     echo "<textarea rows=10 cols=60 name=\"task_content\"></textarea> </td>\n";
  364.     echo "</tr><tr>\n";
  365.     echo "<td bgcolor=\"#DADBEB\" align=right valign=top>\n";
  366.     echo "<font color=\"#000000\"><b>\n";
  367.     echo "SELECT STATUS: </b></font></td>\n";
  368.     echo "<td bgcolor=\"#DADBEB\" align=left valign=top>\n";
  369.  
  370.     echo "<select name=task_status>\n";
  371.     echo "<option selected>Incomplete</option>\n";
  372.     echo "<option>In Progress</option>\n";
  373.     echo "<option>Complete</option>\n";
  374.     echo "</select> </td>\n";
  375.     echo "</tr><tr>\n";
  376.     echo "<td bgcolor=\"#DADBEB\" align=left valign=bottom>
  377.            <span style='color:gray; font-size:10px; font-family:verdana,arial;'>
  378.            Modified from code<br> &copy; <a href=\"http://www.geniusbug.com\" target=\"_new\">geniusbug</a>\n";
  379.     echo "</td>\n";
  380.     echo "<td bgcolor=\"#DADBEB\" align=left valign=top>
  381.           <span style='color:gray; font-size:10px; font-family:verdana,arial;'>\n";
  382.     echo "<input type=submit value=\"Add\"><div align=\"right\"><a name=\"tip1\"><font color=red><b><u>*</u></b></font></a> Each page holds ".$records_page." items.</div></td>\n";
  383.     echo "</form>\n";
  384.     echo "</td><tr>\n";
  385.     echo "</table>\n";    
  386.     }
  387.  
  388. //edit item function    
  389.   function edit_todo($edit_id, $linktm, $tm_page, $edittodo, $task_status, $task_owner, $owner) {
  390.     $strSQL = "SELECT * From ".$this->config["table_prefix"]."task WHERE user = '$task_owner' AND task_id = ".$edit_id;
  391.     $query = mysql_query($strSQL);
  392.     $edittodo = mysql_fetch_array($query);
  393.    
  394.    
  395.     //edit item form
  396.    
  397.     echo "<table width=75% cellpadding=4 cellspacing=1 border=0>\n";
  398.      echo "<div align=left> EDITING: <b>".strtoupper($edittodo["task_title"])." </b></div>\n";
  399.     echo "<form method=post action=\"$linktm\">\n";
  400.     echo "<input type=hidden name=\"update_id\" value=\"".$edittodo["task_id"]."\">\n";
  401.     echo "<input type=hidden name=\"page\" value=\"$tm_page\">\n";
  402.     echo "<tr><td bgcolor=\"#DADBEB\" align=right valign=top>\n";
  403.     echo "<font color=\"#000000\"><b>\n";
  404.     echo "TITLE: </b></font></td>\n";
  405.     echo "<td bgcolor=\"#DADBEB\" align=left valign=top>\n";
  406.     echo "<input type=text size=30 name=\"task_title\" value=\"".$edittodo["task_title"]."\"> </td>\n";
  407.     echo "</tr><tr>\n";
  408.     echo "<td bgcolor=\"#DADBEB\" align=right valign=top>\n";
  409.     echo "<font color=\"#000000\"><b>\n";
  410.     echo "DESCRIPTION: </b></font></td>\n";
  411.     echo "<td bgcolor=\"#DADBEB\" align=left valign=top>\n";
  412.     echo "<textarea rows=15 cols=40 name=\"task_content\">".$edittodo["task_content"]."</textarea> </td>\n";
  413.     echo "</tr><tr>\n";
  414.     echo "<td bgcolor=\"#DADBEB\" align=right valign=top>\n";
  415.     echo "<font color=\"#000000\"><b>\n";
  416.     echo "SELECT STATUS: </b></font></td>\n";
  417.     echo "<td bgcolor=\"#DADBEB\" align=left valign=top>\n";
  418.     echo "<select name=\"task_status\">\n";
  419.    
  420.     if ($edittodo["task_status"] == "Incomplete") {
  421.     echo "<option selected>Incomplete</option>\n";
  422.     }else{
  423.     echo "<option>Incomplete</option>\n";
  424.     }
  425.    
  426.     if ($edittodo["task_status"] == "In Progress") {
  427.     echo "<option selected>In Progress</option>\n";
  428.     }else{
  429.     echo "<option>In Progress</option>\n";
  430.     }
  431.    
  432.     if ($edittodo["task_status"] == "Complete") {
  433.     echo "<option selected>Complete</option>\n";
  434.     }else{
  435.     echo "<option>Complete</option>\n";
  436.     }
  437.    
  438.     echo "</select> </td>\n";
  439.     echo "</tr><tr>\n";
  440.     echo "<td bgcolor=\"#DADBEB\" valign=top>\n";
  441.     echo "&nbsp; </td>\n";
  442.     echo "<td bgcolor=\"#DADBEB\" align=left valign=top>\n";
  443.     echo "<input type=submit value=\"Update\">\n";
  444.     echo "</form>\n";
  445.     echo "</td><tr>\n";
  446.     echo "</table>\n";        
  447.  
  448. mysql_free_result($query);    
  449. }
  450.  
  451. //organize events order
  452. if (strlen($edit_id) > 0) {
  453.     edit_todo($edit_id, $linktm, $tm_page, $edittodo, $task_status, $task_owner, $owner);
  454.    
  455. }elseif(strlen($keyword) > 0) {
  456.     get_results($keyword, $linktm, $tm_page, $task_owner, $owner);
  457.  
  458. }elseif(strlen($task_id) > 0) {
  459.     item($task_id, $linktm, $tm_page, $task_owner, $owner, $order1, $dir1);
  460.    
  461. }else{
  462.     list_todo($list_order, $list_dir, $linktm, $tm_page, $records_page, $task_timestamp, $task_status, $task_owner, $owner);
  463. }
  464.  
  465. $fd = fopen ($HTTP_SERVER_VARS["SCRIPT_FILENAME"], "r");
  466.  
  467. $line=0;
  468. if($fd){
  469.     while (!feof ($fd)) {
  470.         $buffer = fgets($fd, 4096);
  471.         $line++;
  472.     }
  473.     fclose ($fd);
  474.  
  475. }
  476. echo "</table>";
  477. echo "</body>";
  478. echo "</html>";
  479. }
  480. ?>


NOTE that usertasks.php also requires the file usertasksfunctions.php (code farther below) to be placed in a directory called scripts in the wikka root.

The following code is for usertasks.php which should be placed in the actions directory...it allows you to look at others' schedules using the parameter="username" as in {{usertasks owner="username"}}...you can place several copies of it on the same page to see task lists for several people (like all members of a working group) at once.

The code requires three gif files: up.gif, down.gif and trs.gif.

  1. <?
  2. <?
  3. // usertasks.php Version 2.0 - January 7, 2005 - removed code for editing, removed functions
  4. // USE: {{usertasks [owner="UserName"] [items="#"]}}, owner & items parameters are optional
  5. // Multiple instances may occur on a single page.
  6. // REQUIRES usertasksfunctions.php which should be placed in the "scripts" directory in the wikka root
  7. // Owner parameter is to allow seeing someone else's to-do list, items parameter is for # items on a page (default 10)
  8. // Modified by GmBowen for use in wikka wiki for a SSHRC researh project. Modifications copyright 2005, provided under a GPL license.
  9. // Ongoing attribution of authorial contribution in any future modifications would be appreciated.
  10. // This {{action}} script for derivations of wakka wiki is heavily modified from a standalone single-script package
  11. // produced by and provided by the author identified in the text box below....although it is released by her as a "free to use"
  12. // script, no mention is made of any problems with commercial use. If you intend on using this action script modified from the
  13. // geniusbug code, especially for commercial purposes, you should contact the original author for permission to use
  14. // the original components.
  15. ////////////////////////////////////////
  16. //  GBTask Task Manager               //
  17. //  Naomi C. Martinson                //
  18. //  2002 © http://www.geniusbug.com   //
  19. //  Don't remove this message         //
  20. //  Contact: naomi@geniusbug.com      //
  21. ////////////////////////////////////////
  22. $table=$this->config["table_prefix"];
  23. global $linktm, $use;
  24. $linktm = $this->config["base_url"].$this->MiniHref($method, $tag);
  25. $task_id = $_REQUEST['task_id'];
  26. $task_title = $_POST['task_title'];
  27. $task_content = $_POST['task_content'];
  28. $task_status = $_POST['task_status'];
  29. $order1 = $_REQUEST['order1'];
  30. $dir1 = $_REQUEST['dir1'];
  31. $dir = $_REQUEST['dir'];
  32.  
  33. if($owner != NULL){$task_owner = $owner; }else { $task_owner = $this->GetPageOwner();}
  34.  
  35. if($_REQUEST['tm_page'] == '' || $_REQUEST['tm_page'] == NULL){$tm_page = '1';}else{$tm_page = $_REQUEST['tm_page'];}
  36.  
  37. $tm_direction = $_REQUEST[dir];
  38. $tm_order = $_REQUEST[order];
  39. $keyword = $_POST[keyword];
  40. if ($items == '' || $items =='0') { $items = 10;}
  41. $items_per_page = $items;
  42. session_start();
  43.  
  44. session_register("records_page");
  45. $records_page = $items_per_page;
  46.  
  47. if(isset($tm_order)){
  48.     session_register("list_order");
  49.     $list_order = $tm_order;
  50. }
  51.  
  52. if(isset($tm_direction)){
  53.     session_register("list_dir");
  54.  
  55.     $list_dir = $tm_direction;
  56. }
  57.  
  58. if(isset($set_theme)){
  59.     session_register("theme");
  60.     $theme = $set_theme;
  61. }
  62.  
  63. if (isset($showsource)) {
  64.     show_source($HTTP_SERVER_VARS["SCRIPT_FILENAME"]);
  65.     exit;
  66. }
  67.  
  68.  
  69.  
  70. $task_id = $_REQUEST['task_id'];
  71. $add_id = $_POST['add_id'];
  72. $task_title = $_POST['task_title'];
  73. $task_content = $_POST['task_content'];
  74. $task_status = $_POST['task_status'];
  75.  
  76. //resume to 10 items per page
  77. if(!isset($records_page)){
  78.     $records_page = 10;
  79. }
  80.  
  81. $strSQL = "SELECT * From ".$this->config["table_prefix"]."task WHERE user = '$task_owner' AND task_delete = '0'";
  82. $query = mysql_query($strSQL);
  83.  
  84. $total_records = mysql_num_rows($query);
  85. mysql_free_result($query);
  86.  
  87. if (!isset($tm_page)) {
  88.     $tm_page=1;
  89. }
  90. $num_pages = ceil($total_records / $records_page);
  91. for ($i=1;$i<=$num_pages;$i++) {
  92.     $tm_page_nav = $tm_page_nav."[<a href=\"".$linktm."&tm_page=".$i."\">".$i."</a>]&nbsp;\n";
  93. }
  94.  
  95. echo "<table width=95% cellpadding=0 cellspacing=0 border=0 align=center><tr><td bgcolor=white align=\"center\" valign=top>\n";
  96.  
  97. //html header, search form items, per page form
  98. echo "<form method=post action=\"".$linktm."\">\n";
  99. echo "<span style='color:gray; font-size:10px; font-family:verdana,arial;'> <strong>Task Owner: $task_owner </strong></span>";
  100. echo "<table width=75% cellpadding=0 cellspacing=0 border=0 valign=bottom><tr>\n";
  101. echo "<td bgcolor=\"#949AE7\" valign=bottom><img src=\"images/trs.gif\" width=1 height=1></td>\n";
  102. echo "</tr></table>\n";
  103. echo "<table width=75% cellpadding=0 cellspacing=0 border=0><tr>\n";
  104. echo "<td bgcolor=\"E9EBF3\">
  105.        <table width=100%><tr>
  106.           <td align=left>
  107.           <span style='color:gray; font-size:10px; font-family:verdana,arial;'> <!-- Page Owner: $task_owner -->
  108.           Pages: $tm_page_nav (Pg: $tm_page)</td>
  109.           <td align=center><a href=\"$linktm\"><b>
  110.           <span style='color:gray; font-size:10px; font-family:verdana,arial;'>
  111.           [HOME]</b></a>&nbsp;&nbsp;SHOW:[<a href=\"".$linktm."&task_id=ALL&tm_page=$tm_page&order1=task_title&dir1=DESC\"><b><span style='color:gray; font-size:10px; font-family:verdana,arial;'>ALL</b></a>|<a href=\"".$linktm."&task_id=INCOMPLETE&tm_page=$tm_page&order1=task_title&dir1=DESC\"><b><span style='color:gray; font-size:10px; font-family:verdana,arial;'>INCOMPLETE</b></a>|<a href=\"".$linktm."&task_id=INPROGRESS&tm_page=$tm_page&order1=task_title&dir1=DESC\"><b><span style='color:gray; font-size:10px; font-family:verdana,arial;'>IN PROGRESS</b></a>|<a href=\"".$linktm."&task_id=COMPLETE&tm_page=$tm_page&order1=task_title&dir1=DESC\"><b><span style='color:gray; font-size:10px; font-family:verdana,arial;'>COMPLETE</b></a>]
  112.         </td>
  113.           <td align=right><input type=text size=10 value=\"keyword\" name=\"keyword\"><input type=submit value=\"Search\"></td>
  114.         </tr></table>
  115.       </td>\n";
  116. echo "</tr></table>\n";
  117. echo "</form>\n";
  118.  
  119. // functions include
  120. include_once("./scripts/usertasksfunctions.php");
  121.  
  122. //organize events order
  123. if (strlen($keyword) > 0) {
  124.     get_results2($keyword, $linktm, $tm_page, $task_owner, $owner, $table);
  125.  
  126. }elseif(strlen($task_id) > 0) {
  127.     item2($task_id, $linktm, $tm_page, $task_owner, $owner, $order1, $dir1, $table);
  128.    
  129. }else{
  130.     list_todo2($list_order, $list_dir, $linktm, $tm_page, $records_page, $task_timestamp, $task_status, $task_owner, $owner, $table);
  131. }
  132.  
  133. $fd = fopen ($HTTP_SERVER_VARS["SCRIPT_FILENAME"], "r");
  134.  
  135. $line=0;
  136. if($fd){
  137.     while (!feof ($fd)) {
  138.         $buffer = fgets($fd, 4096);
  139.         $line++;
  140.     }
  141.     fclose ($fd);
  142.  
  143. }
  144. echo "</table>";
  145. ?>


In addition the following file (usertasksfunctions.php) must be placed in a directory called scripts in the wikka root.
  1. <?
  2. // usertasksfunctions.php Version 1.0 - January 7, 2005
  3. // USE: REQUIRED for usertasks.php
  4. // Modifications for use in wikka wiki by GmBowen copyright 2005, provided under a GPL license.
  5. // Ongoing attribution of authorial contribution in any future modifications would be appreciated.
  6. // The functions in this script derive from GBTask produced by and provided by the author identified in the text box below
  7. // ....although it is released by her as a "free to use" script, no mention is made of any problems with commercial use.
  8. // If you intend on using this action script modified from the geniusbug code, especially for commercial purposes,
  9. // you should contact the original author for permission to use the original components.
  10. ////////////////////////////////////////
  11. //  GBTask Task Manager               //
  12. //  Naomi C. Martinson                //
  13. //  2002 © http://www.geniusbug.com   //
  14. //  Don't remove this message         //
  15. //  Contact: naomi@geniusbug.com      //
  16. ////////////////////////////////////////
  17.  
  18. //search function
  19. function get_results2($keyword, $linktm, $tm_page, $task_owner, $owner, $table) {        
  20.     //search the database
  21.     $strSQL = "SELECT * From ".$table."task WHERE task_delete = '0' AND user = '$task_owner' AND task_title LIKE '%".$keyword."%' OR task_content LIKE '%".$keyword."%'";
  22.     $results = mysql_query($strSQL);
  23.    
  24.     if (mysql_num_rows($results) > 0) {
  25.        
  26.         echo "<br>Your keyword is: <b>".$keyword."</b><P>\n";
  27.         echo "<table width=75% cellpadding=4 cellspacing=2 border=0>\n";
  28.         while($mykey = mysql_fetch_array($results)){
  29.            
  30.             //list the results
  31.             echo "<tr>\n";
  32.             echo "<td bgcolor=\"#E9E9E9\" align=left valign=top><font color=white><img src=\"images/trs.gif\" width=70 height=1><br><nobr>\n";
  33.            
  34.             switch ($mykey["task_status"]) {
  35.             case "Incomplete":
  36.             echo "<font color=red>".$mykey["task_status"]."</font>\n";
  37.             break;
  38.            
  39.             case "In Progress":
  40.             echo "<font color=blue>".$mykey["task_status"]."</font>\n";
  41.             break;
  42.            
  43.             case "Complete":
  44.             echo "<font color=green>".$mykey["task_status"]."</font>\n";
  45.             break;
  46.             }
  47.            
  48.             echo "</nobr></font></td>\n";
  49.  
  50.             echo "<td bgcolor=\"#F3F0F9\" align=left valign=top width=75%><a href=\"".$linktm."&task_id=".$mykey["task_id"]."&tm_page=$page\">".$mykey["task_title"]."</a> X(posted:".$mykey["task_timestamp"].")</td>\n";
  51.             echo "</tr>\n";
  52.         }
  53.         echo "</table>\n";
  54.     }else{
  55.         echo "<P><font color=red>SORRY, NO MATCH!</font><P>\n";
  56.     }
  57.     mysql_free_result($results);
  58. }
  59.  
  60. //view item after search function
  61. function item2($task_id, $linktm, $tm_page, $task_owner, $owner, $order1, $dir1, $table) {
  62.     if($task_id == 'ALL'){
  63.    
  64.      $strSQL = "SELECT * From ".$table."task WHERE task_delete = '0' AND user='$task_owner' ORDER By $order1 $dir1"; //kasper AND task_id =".$task_id;
  65.      $query = mysql_query($strSQL);
  66.    
  67.     echo "<table width=75% cellpadding=4 cellspacing=2 border=0>\n";
  68.     echo "<tr>";
  69.     echo "<td bgcolor=\"#BBBDD9\" width=112px valign=top><b>STATUS&nbsp;<a href=\"".$linktm."&task_id=ALL&order1=task_status&dir1=DESC\"><img src=\"images/up.gif\" width=11 height=16 border=0></a> <a href=\"".$linktm."&task_id=ALL&order1=task_status&dir1=ASC\"><img src=\"images/down.gif\" width=11 height=16 border=0></a></td>\n";
  70.     echo "<td bgcolor=\"#BBBDD9\" valign=top><b>TASK</b> <a href=\"".$linktm."&task_id=ALL&order1=task_title&dir1=DESC\"><img src=\"images/up.gif\" width=11 height=16 border=0></a> <a href=\"".$linktm."&task_id=ALL&order1=task_title&dir1=ASC\"><img src=\"images/down.gif\" width=11 height=16 border=0></a></td>\n";
  71.     echo "<td bgcolor=\"#BBBDD9\" width=192px valign=top><b>ENTERED ON</b> <a href=\"".$linktm."&task_id=ALL&order1=task_timestamp&dir1=DESC\"><img src=\"images/up.gif\" width=11 height=16 border=0></a> <a href=\"".$linktm."&task_id=ALL&order1=task_timestamp&dir1=ASC\"><img src=\"images/down.gif\" width=11 height=16 border=0></a></td>\n";
  72.     echo "  
  73.           </tr>
  74.           </table>";
  75.            
  76.            
  77.       while ($item = mysql_fetch_object($query)){
  78.            
  79.            echo "<table width=76% cellpadding=4 cellspacing=2 border=0><tr><td>\n";
  80.            echo "<table width=100% cellpadding=1 cellspacing=1 border=0>\n";
  81.            echo "<tr><td bgcolor=\"#E9E9E9\" width=120px align=left valign=top><font color=white><img src=\"images/trs.gif\" width=70 height=1><br><nobr>&nbsp;&nbsp;\n";
  82.  
  83.            switch ($item->task_status) {
  84.               case "Incomplete":
  85.               echo "<font color=red>".$item->task_status."</font>\n";
  86.               break;
  87.    
  88.               case "In Progress":
  89.               echo "<font color=blue>".$item->task_status."</font>\n";
  90.               break;
  91.    
  92.               case "Complete":
  93.               echo "<font color=green>".$item->task_status."</font>\n";
  94.               break;
  95.            }
  96.    
  97.            echo "</nobr></font></td>\n";
  98.            echo "<td bgcolor=\"#BBBDD9\" align=left valign=top ><font color=white><b>&nbsp; ".strtoupper($item->task_title)."</b></font></td>";    
  99.            echo "<td width=200px bgcolor=\"#E9E9E9\" align=left valign=top ><center><font color=black>".$item->task_timestamp."</font></center></td></tr></table>\n";
  100.            echo "<table width=100% cellpadding=1 cellspacing=1 border=0><tr><td colspan=3 bgcolor=\"#E9E9E9\" align=left valign=top colspan=2> &nbsp; &nbsp;".str_replace("\n", "<br>", $item->task_content)."</td></tr>\n";
  101.            echo "</table></tr></td></table>\n";
  102.       }
  103.     }
  104.     elseif ($task_id == 'INCOMPLETE'){
  105.    
  106.     $strSQL = "SELECT * From ".$table."task WHERE task_delete = '0' AND user='$task_owner' AND task_status='Incomplete' ORDER By $order1 $dir1"; //kasper AND task_id =".$task_id;
  107.     $query = mysql_query($strSQL);
  108.    
  109.     echo "<table width=75% cellpadding=4 cellspacing=2 border=0>\n";
  110.     echo "<tr>";
  111.     echo "<td bgcolor=\"#BBBDD9\" width=112px valign=top><b>STATUS&nbsp;<a href=\"".$linktm."&task_id=INCOMPLETE&order1=task_status&dir1=DESC\"><img src=\"images/up.gif\" width=11 height=16 border=0></a> <a href=\"".$linktm."&task_id=INCOMPLETE&order1=task_status&dir1=ASC\"><img src=\"images/down.gif\" width=11 height=16 border=0></a></td>\n";
  112.     echo "<td bgcolor=\"#BBBDD9\" valign=top><b>TASK</b> <a href=\"".$linktm."&task_id=INCOMPLETE&order1=task_title&dir1=DESC\"><img src=\"images/up.gif\" width=11 height=16 border=0></a> <a href=\"".$linktm."&task_id=INCOMPLETE&order1=task_title&dir1=ASC\"><img src=\"images/down.gif\" width=11 height=16 border=0></a></td>\n";
  113.     echo "<td bgcolor=\"#BBBDD9\" width=192px valign=top><b>ENTERED ON</b> <a href=\"".$linktm."&task_id=INCOMPLETE&order1=task_timestamp&dir1=DESC\"><img src=\"images/up.gif\" width=11 height=16 border=0></a> <a href=\"".$linktm."&task_id=INCOMPLETE&order1=task_timestamp&dir1=ASC\"><img src=\"images/down.gif\" width=11 height=16 border=0></a></td>\n";
  114.     echo "  
  115.           </tr>
  116.           </table>";
  117.            
  118.            
  119.       while ($item = mysql_fetch_object($query)){
  120.            
  121.            echo "<table width=76% cellpadding=4 cellspacing=2 border=0><tr><td>\n";
  122.            echo "<table width=100% cellpadding=1 cellspacing=1 border=0>\n";
  123.            echo "<tr><td bgcolor=\"#E9E9E9\" width=120px align=left valign=top><font color=white><img src=\"images/trs.gif\" width=70 height=1><br><nobr>&nbsp;&nbsp;\n";
  124.  
  125.            switch ($item->task_status) {
  126.               case "Incomplete":
  127.               echo "<font color=red>".$item->task_status."</font>\n";
  128.               break;
  129.    
  130.               case "In Progress":
  131.               echo "<font color=blue>".$item->task_status."</font>\n";
  132.               break;
  133.    
  134.               case "Complete":
  135.               echo "<font color=green>".$item->task_status."</font>\n";
  136.               break;
  137.            }
  138.    
  139.            echo "</nobr></font></td>\n";
  140.            echo "<td bgcolor=\"#BBBDD9\" align=left valign=top ><font color=white><b>&nbsp; ".strtoupper($item->task_title)."</b></font></td>";    
  141.            echo "<td width=200px bgcolor=\"#E9E9E9\" align=left valign=top ><center><font color=black>".$item->task_timestamp."</font></center></td></tr></table>\n";
  142.            echo "<table width=100% cellpadding=1 cellspacing=1 border=0><tr><td colspan=3 bgcolor=\"#E9E9E9\" align=left valign=top colspan=2> &nbsp; &nbsp;".str_replace("\n", "<br>", $item->task_content)."</td></tr>\n";
  143.            echo "</table></tr></td></table>\n";
  144.       }
  145.     }
  146.     elseif ($task_id == 'INPROGRESS'){
  147.    
  148.     $strSQL = "SELECT * From ".$table."task WHERE task_delete = '0' AND user='$task_owner' AND task_status='In Progress' ORDER By $order1 $dir1"; //kasper AND task_id =".$task_id;
  149.     $query = mysql_query($strSQL);
  150.    
  151.     echo "<table width=75% cellpadding=4 cellspacing=2 border=0>\n";
  152.     echo "<tr>";
  153.     echo "<td bgcolor=\"#BBBDD9\" width=112px valign=top><b>STATUS&nbsp;<a href=\"".$linktm."&task_id=INPROGRESS&order1=task_status&dir1=DESC\"><img src=\"images/up.gif\" width=11 height=16 border=0></a> <a href=\"".$linktm."&task_id=INPROGRESS&order1=task_status&dir1=ASC\"><img src=\"images/down.gif\" width=11 height=16 border=0></a></td>\n";
  154.     echo "<td bgcolor=\"#BBBDD9\" valign=top><b>TASK</b> <a href=\"".$linktm."&task_id=INPROGRESS&order1=task_title&dir1=DESC\"><img src=\"images/up.gif\" width=11 height=16 border=0></a> <a href=\"".$linktm."&task_id=INPROGRESS&order1=task_title&dir1=ASC\"><img src=\"images/down.gif\" width=11 height=16 border=0></a></td>\n";
  155.     echo "<td bgcolor=\"#BBBDD9\" width=192px valign=top><b>ENTERED ON</b> <a href=\"".$linktm."&task_id=INPROGRESS&order1=task_timestamp&dir1=DESC\"><img src=\"images/up.gif\" width=11 height=16 border=0></a> <a href=\"".$linktm."&task_id=INPROGRESS&order1=task_timestamp&dir1=ASC\"><img src=\"images/down.gif\" width=11 height=16 border=0></a></td>\n";
  156.     echo "  
  157.           </tr>
  158.           </table>";
  159.            
  160.            
  161.       while ($item = mysql_fetch_object($query)){
  162.            
  163.            echo "<table width=76% cellpadding=4 cellspacing=2 border=0><tr><td>\n";
  164.            echo "<table width=100% cellpadding=1 cellspacing=1 border=0>\n";
  165.            echo "<tr><td bgcolor=\"#E9E9E9\" width=120px align=left valign=top><font color=white><img src=\"images/trs.gif\" width=70 height=1><br><nobr>&nbsp;&nbsp;\n";
  166.  
  167.            switch ($item->task_status) {
  168.               case "Incomplete":
  169.               echo "<font color=red>".$item->task_status."</font>\n";
  170.               break;
  171.    
  172.               case "In Progress":
  173.               echo "<font color=blue>".$item->task_status."</font>\n";
  174.               break;
  175.    
  176.               case "Complete":
  177.               echo "<font color=green>".$item->task_status."</font>\n";
  178.               break;
  179.            }
  180.    
  181.            echo "</nobr></font></td>\n";
  182.            echo "<td bgcolor=\"#BBBDD9\" align=left valign=top ><font color=white><b>&nbsp; ".strtoupper($item->task_title)."</b></font></td>";    
  183.            echo "<td width=200px bgcolor=\"#E9E9E9\" align=left valign=top ><center><font color=black>".$item->task_timestamp."</font></center></td></tr></table>\n";
  184.            echo "<table width=100% cellpadding=1 cellspacing=1 border=0><tr><td colspan=3 bgcolor=\"#E9E9E9\" align=left valign=top colspan=2> &nbsp; &nbsp;".str_replace("\n", "<br>", $item->task_content)."</td></tr>\n";
  185.            echo "</table></tr></td></table>\n";
  186.       }
  187.     }
  188.     elseif ($task_id == 'COMPLETE'){
  189.    
  190.     $strSQL = "SELECT * From ".$table."task WHERE task_delete = '0' AND user='$task_owner' AND task_status='Complete' ORDER By $order1 $dir1"; //kasper AND task_id =".$task_id;
  191.     $query = mysql_query($strSQL);
  192.    
  193.     echo "<table width=75% cellpadding=4 cellspacing=2 border=0>\n";
  194.     echo "<tr>";
  195.     echo "<td bgcolor=\"#BBBDD9\" width=112px valign=top><b>STATUS&nbsp;<a href=\"".$linktm."&task_id=COMPLETE&order1=task_status&dir1=DESC\"><img src=\"images/up.gif\" width=11 height=16 border=0></a> <a href=\"".$linktm."&task_id=COMPLETE&order1=task_status&dir1=ASC\"><img src=\"images/down.gif\" width=11 height=16 border=0></a></td>\n";
  196.     echo "<td bgcolor=\"#BBBDD9\" valign=top><b>TASK</b> <a href=\"".$linktm."&task_id=COMPLETE&order1=task_title&dir1=DESC\"><img src=\"images/up.gif\" width=11 height=16 border=0></a> <a href=\"".$linktm."&task_id=COMPLETE&order1=task_title&dir1=ASC\"><img src=\"images/down.gif\" width=11 height=16 border=0></a></td>\n";
  197.     echo "<td bgcolor=\"#BBBDD9\" width=192px valign=top><b>ENTERED ON</b> <a href=\"".$linktm."&task_id=COMPLETE&order1=task_timestamp&dir1=DESC\"><img src=\"images/up.gif\" width=11 height=16 border=0></a> <a href=\"".$linktm."&task_id=COMPLETE&order1=task_timestamp&dir1=ASC\"><img src=\"images/down.gif\" width=11 height=16 border=0></a></td>\n";
  198.     echo "  
  199.           </tr>
  200.           </table>";
  201.            
  202.            
  203.       while ($item = mysql_fetch_object($query)){
  204.            
  205.            echo "<table width=76% cellpadding=4 cellspacing=2 border=0><tr><td>\n";
  206.            echo "<table width=100% cellpadding=1 cellspacing=1 border=0>\n";
  207.            echo "<tr><td bgcolor=\"#E9E9E9\" width=120px align=left valign=top><font color=white><img src=\"images/trs.gif\" width=70 height=1><br><nobr>&nbsp;&nbsp;\n";
  208.  
  209.            switch ($item->task_status) {
  210.               case "Incomplete":
  211.               echo "<font color=red>".$item->task_status."</font>\n";
  212.               break;
  213.    
  214.               case "In Progress":
  215.               echo "<font color=blue>".$item->task_status."</font>\n";
  216.               break;
  217.    
  218.               case "Complete":
  219.               echo "<font color=green>".$item->task_status."</font>\n";
  220.               break;
  221.            }
  222.    
  223.            echo "</nobr></font></td>\n";
  224.            echo "<td bgcolor=\"#BBBDD9\" align=left valign=top ><font color=white><b>&nbsp; ".strtoupper($item->task_title)."</b></font></td>";    
  225.            echo "<td width=200px bgcolor=\"#E9E9E9\" align=left valign=top ><center><font color=black>".$item->task_timestamp."</font></center></td></tr></table>\n";
  226.            echo "<table width=100% cellpadding=1 cellspacing=1 border=0><tr><td colspan=3 bgcolor=\"#E9E9E9\" align=left valign=top colspan=2> &nbsp; &nbsp;".str_replace("\n", "<br>", $item->task_content)."</td></tr>\n";
  227.            echo "</table></tr></td></table>\n";
  228.       }
  229.     }
  230.     else
  231.     {
  232.        $strSQL = "SELECT * From ".$table."task WHERE task_delete = '0' AND user='$task_owner' AND task_id =".$task_id;
  233.        $query = mysql_query($strSQL);
  234.        $item = mysql_fetch_array($query);
  235.        echo "<table width=75% cellpadding=4 cellspacing=2 border=0>\n";
  236.        echo "<td width=5% bgcolor=\"#E9E9E9\" align=left valign=top><font color=white><img src=\"images/trs.gif\" width=70 height=1><br><nobr>\n";
  237.  
  238.        switch ($item["task_status"]) {
  239.        case "Incomplete":
  240.        echo "<font color=red>".$item["task_status"]."</font>\n";
  241.        break;
  242.  
  243.        case "In Progress":
  244.        echo "<font color=blue>".$item["task_status"]."</font>\n";
  245.        break;
  246.  
  247.        case "Complete":
  248.        echo "<font color=green>".$item["task_status"]."</font>\n";
  249.        break;
  250.        }
  251.        echo "</nobr></font></td>\n";    
  252.        echo "<td bgcolor=\"#BBBDD9\" align=left valign=top width=75%><font color=black><b>".strtoupper($item["task_title"])."</b> (posted: ".$item["task_timestamp"].")</font></td></tr>\n";
  253.        echo "<tr><td bgcolor=\"#F3F0F9\" align=left valign=top colspan=2>".str_replace("\n", "<br>", $item["task_content"])."</td></tr>\n";
  254.     echo "</table>\n";
  255.     }
  256. }
  257.  
  258. //list items function
  259. function list_todo2($tm_order, $tm_direction, $linktm, $tm_page, $records_page, $task_timestamp, $task_status, $task_owner, $owner, $table) {
  260.  
  261.     if (!isset($tm_order)) {
  262.         $tm_order = "task_timestamp";
  263.     }
  264.    
  265.     if (!isset($tm_direction)) {
  266.         $tm_direction = "DESC";
  267.     }
  268.  
  269.     $begin = (($tm_page-1)*$records_page);
  270.     $strSQL = "SELECT * From ".$table."task WHERE task_delete = '0' AND user = '$task_owner' ORDER By $tm_order $tm_direction LIMIT $begin,$records_page";
  271.     $query = mysql_query($strSQL);
  272.  
  273. //ECHO 'START of list of items in the cell header information';
  274.  
  275.     echo "<table width=75% cellpadding=2 cellspacing=2 border=0>\n";
  276.     echo "<tr>\n";
  277.     echo "<td bgcolor=\"#BBBDD9\" valign=top>\n";
  278.     echo "<b>TASK <a href=\"".$linktm."&order=task_title&dir=DESC\"><img src=\"images/up.gif\" width=11 height=16 border=0></a> <a href=\"".$linktm."&order=task_title&dir=ASC\"><img src=\"images/down.gif\" width=11 height=16 border=0></a></td>\n";
  279.     echo "<td bgcolor=\"#BBBDD9\" valign=top width=192px>\n";
  280.     echo "<b>ENTERED ON</b> <a href=\"".$linktm."&order=task_timestamp&dir=DESC\"><img src=\"images/up.gif\" width=11 height=16 border=0></a> <a href=\"".$linktm."&order=task_timestamp&dir=ASC\"><img src=\"images/down.gif\" width=11 height=16 border=0></a></td>\n";
  281.     echo "<td bgcolor=\"#BBBDD9\" valign=top width=112px >\n";
  282.     echo "<b>STATUS</b> <a href=\"".$linktm."&order=task_status&dir=DESC\"><img src=\"images/up.gif\" width=11 height=16 border=0></a> <a href=\"".$linktm."&order=task_status&dir=ASC\"><img src=\"images/down.gif\" width=11 height=16 border=0></a></td>\n";
  283.     echo "<td bgcolor=\"#BBBDD9\" valign=top width=112px><b>View?</b> <img src=\"images/trs.gif\" width=11 height=16 border=0></td>\n";
  284.     echo "</tr>\n";
  285.  
  286. //ECHO 'START of list of items after HEADER information (why is this in the wrong place??)';
  287.     //list todo items
  288.     while ($todo = mysql_fetch_array($query)) {
  289.     echo "<tr>\n";
  290.     echo "<td align=left bgcolor=\"#F3F0F9\" valign=top><span title=\"Description: ".$todo["task_content"]."\">".$todo["task_title"]."</span></td>\n";
  291.     echo "<td bgcolor=\"#F3F0F9\" valign=top>".$todo["task_timestamp"]."</td>\n";
  292.        
  293.         //items status case
  294.         switch ($todo["task_status"]) {
  295.             case "Incomplete":        
  296.             echo "<td bgcolor=\"#E9E9E9\" valign=top><font color=red>".$todo["task_status"]."</font></td>\n";
  297.             break;
  298.  
  299.             case "In Progress":
  300.             echo "<td bgcolor=\"#E9E9E9\" valign=top><font color=blue>".$todo["task_status"]."</font></td>\n";
  301.             break;
  302.  
  303.             case "Complete":
  304.             echo "<td bgcolor=\"#E9E9E9\" valign=top><font color=green>".$todo["task_status"]."</font></td>\n";
  305.             break;
  306.         }
  307.     echo "<td bgcolor=\"#F3F0F9\" valign=top><nobr>[<a href=\"".$linktm."&task_id=".$todo["task_id"]."&tm_page=$tm_page\"><b>view</b></a>]";
  308.     echo "</tr>\n";    
  309.     }
  310.     echo "</table>\n";
  311.     mysql_free_result($query);
  312. }
  313. ?>


Ultimately, it is intended that a text entry box and a submit button will be added to this code for entering user names so the schedule of any user can be easily obtained without editing the page.

Remember, multiple copies of mytasks.php cannot be on the same page at once.

And, of course, you need to create a new table in your database....
Remember that you may need to replace wikka_ (first line) with your wikkas table prefix
CREATE TABLE `wikka_task` (
  `task_id` INT(11) NOT NULL AUTO_INCREMENT,
  `user` text NOT NULL,
  `task_timestamp` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `task_title` VARCHAR(255) NOT NULL DEFAULT '',
  `task_content` text NOT NULL,
  `task_status` VARCHAR(255) DEFAULT NULL,
  `task_delete` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY  (`task_id`)

) TYPE=MyISAM;

The mytasks.php function on this page use a "bad word function" that should be placed in the wakka.php file in the wiki root directory. The following code needs to be placed in the wakka.php file (just after the microtime function which starts "function getmicrotime" and ends with a "}". This code is placed immediately after the "}".

//GMB remove bad word filter
function BadWordFunc($RemoveBadWordText) {
    $RemoveBadWordText = eregi_replace("fuc?k|[kc]unt|motherfucker|cocksucker|bitch|son of a bitch|asshole|shit|fag|wank|dick|pu[zs]?[zs][yi]|bastard|s[kc]rew|mole[zs]ter|mole[sz]t|coc?k", "", $RemoveBadWordText);
return $RemoveBadWordText;



In mytasks.php use something like this:
if ($this->method == "show") {
  global $tableprefix;
  $tableprefix = $this->config["table_prefix"];


and inside function use global $tableprefix; and in query "... FROM ${tableprefix}task ...." do not use $this->config["table_prefix"] inside function PHP 5.1.x do not understand

CategoryUserContributions
Comments
Comment by ChristianBarthelemy
2004-12-09 21:58:39
This is going to be very useful. I like it a lot. 3 questions:
- I cannot find the BadWordFunc() function.
- Why not using the table prefix defined in the config instead of forcing it to Wakka_ ?
- What would be the effort to display the contents (dayschedule and task_content) through the Wiki engine so that we can use the formatting capability of the Wiki?
Thanks
Comment by GmBowen
2004-12-09 22:32:05
1) whoops....sorry. There now @ the end. Of course, you can just remove the reference to it (like just commenting out //$task_content = BadWordFunc($task_content); ) I doubt the function is useful to most users, but I work with kids remember, in school settings, so, sadly, it's kinda "required" for my code.
2) ah, my tables are wakka_ .....I just dumped the table content. I run several wiki's in the same database....my main development one is prefaced Wakka_ ....you can change the code to whatever you'd like in the tablemaking statement. Oh, I see, some of the code is absolute references to wakka, not relative to the table preface in the config file. oooops. ....feel free to correct that if you'd like.
3) Um, I'm not sure what you mean....you mean through css?? Good question....I've never taken the time to figure css out, so I'm not sure. Some of the formatting IS driven by the wiki engine.
Hope you find it useful. Oh, and I noticed you seeing if you could play with the scheduler action in the sandbox.....you'd probably have to ask jason to build the table and put the action in his directory. (Mike)
Comment by ChristianBarthelemy
2004-12-09 22:38:20
Thank you for the answers Mike.
For the 3rd point, I would just like to be able to write an event like this:
===kick-off meeting===
**Agenda:** {{include MeetingAgenda}}
And then to have it displayed like a normal Wiki content and not as simple text.
Comment by GmBowen
2004-12-09 22:51:55
oh I think I see what you mean....There's still an action that I'm writing to go with the scheduler that would show just a day schedule broken down by rows. If the agenda was the only item on that day, then what you're suggesting would work with it because it's intended to be like {{showschedule}} defaulting to current day for YOUR schedule, or {{showschedule owner="name"}} for that user defaulted to that day OR {{showschedule year="year" month="month" day="day" owner="name"}} with year/month/day defaulting to the current one if not stated. I'm also going to play with the scheduler.php file so at the bottom of the calendar it'll show Week: 1|2|3|4|5 AND Month: J|F|M|A|M|J|J|A|S|O|N|D so that an easy click will show everything in the schedule for the whole week or month of that year at the bottom of the page.
Comment by NilsLindenberg
2005-01-08 02:24:40
"I'll work at implementing it here for the task manager code in the coming week."

If you want, Mike, I can send you my files with a working version. Not with a class like your solution for the forum and the layout of the "taskmanager.php" needs improvement but perhaps in inspiration?
Comment by GmBowen
2005-01-08 03:50:34
Thanks Nils. I've actually re-worked the usertasks code so it now uses an include....it works quite nicely. I took out lots of other (now redundant) code too....and incorporated your inclusion of $this->config["table_prefix"] as well. I tried doing the functions include with mytasks.php but could not get the edit submit to work at all (it WSOD'd the screen)....so reverted to the functions being internal.
Comment by NilsLindenberg
2005-01-09 09:56:57
I tried to simplify the code yesterday but haven't finished. But I used the old code, so I will try the new one, when I have time.

Btw, to have valid html, it is necessary to use \" \" around every parameter of the html-tags, i.e. valign=\"top\" instead of valign=top.

For you BadWordFunc: if you change your code to:
if (function_exists(BadWordFunc))
{
$task_content = BadWordFunc($task_content);
$task_title = BadWordFunc($task_title);
}

the code will only be executed if you have defined the function. So it would not be necessary to copy the function. Only users who already have copied the function and forget to remove that could get a problem ;-)
Comment by PolVazo
2005-02-10 20:46:46
To get mytasks to work I had to replace .$this->config["table_prefix"]. with the table prefix e.g. ."wikka_".
I'm not sure why...
Comment by GmBowen
2005-02-10 21:26:36
you had to do the "Create Table" (in MYSQL) with the first line changed from wikka_task (CREATE TABLE `wikka_task` (...) to whatever the prefix for tables was that you set in your config file. You can pretty much either hardcode the table name to match wikka_ in the mytasks file (which is what you did), or change the prefix in table reference when you create the tables.
Comment by JavaWoman
2005-02-12 12:46:44
A table prefix definitely should *not* be "hard-coded" in code that needs to access a Wikka table, but instead use $this->config["table_prefix"].

But that also means *additional* tables created for Wikka should use the *configured* prefix so *all* code will be able to actually find that table. A prefix (and a consistent one) is essential in those hosting situations where Wikka cannot be given its own database; the confuguration value is there to allow all Wikka code to find its "own" tables.
Comment by JavaWoman
2005-02-12 12:58:20
@Nils:
"Btw, to have valid html, it is necessary to use \" \" around every parameter of the html-tags, i.e. valign=\"top\" instead of valign=top."

Much easier instead to use *single* quotes around strings that are echoed (or HEREDOC syntax), so you can write readable HTML code with normal double quotes around attribute values:

echo '<td valign="top">';

is a lot more readable than:

echo "<td valign=\"top\">";

If you need to include variables or special characters, just use concatenation:

echo '<td width="'.$width.'" valign="top">'."\n";

You'll get better syntax highlighting that way, too.
Comment by NilsLindenberg
2005-02-12 18:07:03
Would be the best to have a page like HowToWriteValidxHtml :)
Comment by JavaWoman
2005-02-12 19:17:30
@Nils,
Already planned :) See WikkaHowto.
Comment by GmBowen
2005-02-12 22:19:38
phewww, finally.....it's not like INTEND to violate conventions you know.....;)
Comment by JavaWoman
2005-02-13 20:33:51
I know. That's why I'm writing pages for those willing to learn. :)
Comment by JamesMcl
2005-03-24 11:27:00
Oops forgot to log in before adding my comment above.
Comment by SeanOmlor
2005-03-25 11:38:02
Everything is working but mytasks.php for me.

I'm getting the following types of warnings left and right:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/somlor/public_html/pim/actions/mytasks.php on line 315

Any ideas? Thanks.
Comment by SeanOmlor
2005-03-25 11:44:10
Oops. Just noticed PolVazo's comment. Oddly enough this worked for me as well. Inelegant to hardcode the table prefix but I couldn't fix another way to make it work.
Comment by JamesMcl
2005-03-25 17:21:25
I got it working when hard coding the wikka table prefix too.
Should the code not have something like $table = ".$this->config["table_prefix"]." at the beginning and the sql statements use $table or am I getting it totally wrong
Comment by c-24-22-193-119.hsd1.wa.comcast.net
2005-10-21 08:34:58
Ok, so I've saved the files and they're on the server. How do I actually execute the thing? If I just try http://mydomain.org/wiki/actions/mytasks.php, nothing happens.
Comment by DarTar
2005-10-21 11:36:19
Open a page for editing and add {{mytasks}} in the page body.
Comment by GmBowen
2005-10-23 23:21:53
NOTE: A problem in this code is that a mysql error occurs if there are no entries for a user. Fix to follow soon.
Comment by TomSalzer
2005-12-05 20:27:38
Has anyone given thought to using GmBowenWikkaAsPIM as a group scheduling tool? I'm trying to wrap my head around pulling an array of all registered users, or groups of users, and parsing the array through the daily/weekly/monthly views. This would be a "rollup" approach, for use on an intranet. I'm quite familiar with PHP arrays, but less comfortable with the OO coding style used in Wikka. Any suggestions will be most welcome.
Comment by GmBowen
2005-12-05 21:06:17
I've got an "upgraded" version of this that uses a feature called "mybuddies" (itself a separate feature allowing you to keep a buddy list...which links to a "filter" in pageindex & recentchanges). Mybuddies allows you to view your buddies' calendars/schedules easily. It wouldn't be much work to change the scheduler to allow someone to contribute to the calendars of others as well. However, attributing individual submissions to individual authors would be more difficult because of how I decided to store info in the first place (basically, a day is a single cell in the MYSQL table). I also have a calendar "handler" that allows a small popup to provide easy viewing of individual calendars (and the associated day schedule).
Comment by TomSalzer
2005-12-06 05:58:43
Would love to examine your code upgrades/features...In general, I don't need others to add to calendars they don't own, but it would be extremely helpful to be able to check the schedule of other team members.
Comment by TomSalzer
2005-12-06 16:37:12
BTW, I couldn't get actions/mytasks.php to display more than three items in the to do list...I commented out the line that starts "if ($items == '' || $items =='0' " and added "$items = 10;"...that change allowed me to add and display more than three to do items.
Comment by GmBowen
2005-12-06 17:38:40
Hmmm, I don't see why that code wouldn't work. The point was allowing you to set a parameter indicating the number of items {{mytasks items="15"}} and I'm not clear why there'd be a limit of 3 if unspecified.

Um, I don't mind sending you the appropriate files, or to refer you to a test site. Use my username here at yahoo dot com and that will get an email to me.
Comment by RaffaelePaparella
2006-06-29 05:24:37
Hi GmBowen,

I'm getting the following types of warnings in local:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in c:\programmi\easyphp1-8.1\www\wiki\actions\mytasks.php on line 315
and
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in c:\programmi\easyphp1-8.1\www\wiki\actions\mytasks.php on line 344

In wikka.config I have:
'table_prefix' => 'wikka_',

And the name of table is:
wikka_task

you can help me? Thanks.
Comment by WazoO
2006-06-29 16:06:59
Sounds like a "MySQL version" issue ......
Comment by RaffaelePaparella
2006-06-30 02:10:26
WazoO My "MySQL versione" is: 4.1.9
Comment by FrankK
2006-07-23 16:43:13
I like the month view a lot. It is perfect for what our group is looking for, which is a way to display scheduled events that are of interest to the entire group (monthly club meetings, etc.).

However, we need a single calendar that is visible by all users (and ideally editable based on the ACLs), so I would want to modify monthscheduler.php accordingly.

I've been reading through the code a bit and I've come up with an approach that might work. but if someone can validate my assumptions it might help me avoid spinning my wheels...

First of all though, I don't understand why the statement "$username = $this->GetUserName();" is in the code twice. It's on lines 23 and 30. Is there a reason for this, or is it just a typo in the code?

As for modifying the action, it occured to me that I might be able to simply set constants for $thispage and $username (i.e., hardcode them) in order to get a single calendar that everyone can see. Am I on the right track here, or is that too simplistic?
Comment by NilsLindenberg
2006-07-24 09:21:52
It should work without the second GetUsername - but you can comment it out and try if you have doubts.

To your second question: depends on what you want. hardcoding the username would allow users only to see all of his entries, as far as I have looked at the code, so you would have to add all entries with this user.
Comment by FrankK
2006-07-25 21:07:15
OK, commenting out the second "$username = $this->GetUserName();" line worked fine, as expected.

And setting a static name for $username worked as well. The static name becomes the name of the calendar. I am able to have a calendar that everyone can view, and that only registered users can modify.

Thanks again for the pointers. This is going to work very well for our group.
Valid XHTML :: Valid CSS: :: Powered by WikkaWiki