Comparing revisions for GmBowenWikkaAsPIM
- [5944] 2005-02-12 12:50:29 by JavaWoman (unregistered user) [Added warning about using the correct prefix for table creation]
- [19363] 2008-01-28 00:15:26 by GmBowen (unregistered user) [Modified links pointing to docs server]
Additions:
http://gmbowen.educ.unb.ca/wikitest/scheduler.jpg
<P>
if($row->user == $username && $row->month == $month && $row->day == $today && $row->year == $year)
{
$up = 1;
$ro = $row->id;
}
$query = "UPDATE ".$this->config['table_prefix']."scheduler SET dayschedule='$dayschedule' WHERE user='$username' AND id='$ro'";
$result = mysql_query($query);
$query = "INSERT into ".$this->config['table_prefix']."scheduler (user,dayschedule,month,day,year) VALUES ('$username','$dayschedule','$month','$today','$year')";
$result = mysql_query($query);
<td valign="top">
<td colspan="7">
<table cellpadding="0" cellspacing="0" border="0" width="100%">
<tr BGCOLOR="#ffffff">
<td width="20"><a href="<?php echo $this->href("", "", "month="); echo (($month-1)<1) ? 12 : $month-1 ; ?>&year=<?php echo (($month-1)<1) ? $year-1 : $year ; ?>"><<<</a></td>
<td align="center"><font size="2"><?php echo "$monthname $year"; ?></font></td>
<td width="20"><a href="<?php echo $this->href("", "", "month="); echo (($month+1)>12) ? 1 : $month+1 ; ?>&year=<?php echo (($month+1)>12) ? $year+1 : $year ; ?>">>>></a></td>
</tr>
</table>
<td width="22">Su</td>
<td width="22">Mo</td>
<td width="22">Tu</td>
<td width="22">We</td>
<td width="22">Th</td>
<td width="22">Fr</td>
<td width="22">Sa</td>
/*== set up blank days for first week ==*/
if ($firstweek) {
print " <tr BGCOLOR=\"#ffffff\">";
for ($i=1; $i<=$firstwday; $i++)
{ print " <td><font size=\"2\"> </font></td>"; }
$firstweek = false;
}
/*== Sunday start week with <tr> ==*/
if ($wday==0) { print " <tr BGCOLOR=\"#ffffff\">\n"; }
/*== check for event ==*/
print " <td>";
if($day<10) {
if($month<10) {
$tag = "$year:0$month:0$day";
} else {
$tag = "$year:$month:0$day";
}
} else {
if($month<10) {
$tag = "$year:0$month:$day";
} else {
$tag = "$year:$month:$day";
}
}
$todaydate = date("Y:m:d",mktime());
if($tag==$todaydate)
{
$font1 = "<font color=\"#FF0000\"><b>";
$font2 = "</b></font>";
}
else
{
$font1 = "";
$font2 = "";
}
print "<a href=".$site_base.$thispage."&day=$day&month=$month&year=$year>$font1$day$font2</a>";
print "</td>\n";
/*== Saturday week with </tr> ==*/
if ($wday==6) { print " </tr>\n"; }
$wday++;
$wday = $wday % 7;
$day++;
</td>
<br><a href="<?php echo $this->href("", "", "day="); echo (($today-1)<1) ? $lastday : $today-1 ; ?>&year=<?php echo $year; ?>&month=<?php echo $month; ?>"><<</a>
<P>
http://gmbowen.educ.unb.ca/wikitest/dayschedule.jpg
<P>
if($row->user == $username && $row->month == $month && $row->day == $today && $row->year == $year)
{
$up = 1;
$ro = $row->id;
}
$query = "UPDATE ".$this->config['table_prefix']."scheduler SET dayschedule='$dayschedule' WHERE user='$username' AND id='$ro'";
$result = mysql_query($query);
$query = "INSERT into ".$this->config['table_prefix']."scheduler (user,dayschedule,month,day,year) VALUES ('$username','$dayschedule','$month','$today','$year')";
$result = mysql_query($query);
<td valign="top">
<td colspan="7">
<table cellpadding="0" cellspacing="0" border="0" width="100%">
<tr>
<td width="20"><a href="<?php echo $this->href("", "", "month="); echo (($month-1)<1) ? 12 : $month-1 ; ?>&year=<?php echo (($month-1)<1) ? $year-1 : $year ; ?>"><<<</a></td>
<td align="center"><font size="2"><strong><? echo $username ?>'s Calendar for <?php echo "$monthname $year"; ?></strong></font></td>
<td width="20"><a href="<?php echo $this->href("", "", "month="); echo (($month+1)>12) ? 1 : $month+1 ; ?>&year=<?php echo (($month+1)>12) ? $year+1 : $year ; ?>">>>></a></td>
</tr>
</table>
<td>Sunday</td>
<td>Monday</td>
<td>Tuesday</td>
<td>Wednesday</td>
<td>Thursday</td>
<td>Friday</td>
<td>Saturday</td>
/*== set up blank days for first week ==*/
if ($firstweek) {
print " <tr>";
for ($i=1; $i<=$firstwday; $i++)
{ print " <td VALIGN=top ALIGN=left HEIGHT=70><font size=\"2\"> </font></td>"; }
$firstweek = false;
}
/*== Sunday start week with <tr> ==*/
if ($wday==0) { print " <tr>\n"; }
/*== check for event ==*/
print " <td VALIGN=top ALIGN=left WIDTH=150 HEIGHT=70>";
if($day<10) {
if($month<10) {
$tag = "$year:0$month:0$day";
} else {
$tag = "$year:$month:0$day";
}
} else {
if($month<10) {
$tag = "$year:0$month:$day";
} else {
$tag = "$year:$month:$day";
}
}
$todaydate = date("Y:m:d",mktime());
if($tag==$todaydate)
{
$font1 = "<font color=\"#FF0000\"><b>";
$font2 = "</b></font>";
}
else
{
$font1 = "";
$font2 = "";
}
print "<table width=\"100%\"><TR BGCOLOR=\"#E4DFDA\"><td><a href=".$site_base.$thispage."&day=$day&month=$month&year=$year#EntryBox> $font1$day$font2</a> $printme</td</tr><tr><td><small>$dayoutput</small></td></tr></table>";
print "</td>\n";
/*== Saturday week with </tr> ==*/
if ($wday==6) { print " </tr>\n"; }
$wday++;
$wday = $wday % 7;
$day++;
</td>
http://gmbowen.educ.unb.ca/wikitest/monthview.jpg
http://gmbowen.educ.unb.ca/wikitest/taskmanager.jpg
<td align=left>
<td align=right><input type=text size=15 value=\"keyword\" name=\"keyword\"><input type=submit value=\"Search\"></td>
</tr></table>
echo "<br>Your keyword is: <b>".$keyword."</b><P>\n";
echo "<table width=75% cellpadding=4 cellspacing=2 border=0>\n";
while($mykey = mysql_fetch_array($results)){
//list the results
echo "<tr>\n";
echo "<td bgcolor=\"#E9E9E9\" align=left valign=top><font color=white><img src=\"images/trs.gif\" width=70 height=1><br><nobr>\n";
switch ($mykey["task_status"]) {
case "Incomplete":
echo "<font color=red>".$mykey["task_status"]."</font>\n";
break;
case "In Progress":
echo "<font color=blue>".$mykey["task_status"]."</font>\n";
break;
case "Complete":
echo "<font color=green>".$mykey["task_status"]."</font>\n";
break;
}
echo "</nobr></font></td>\n";
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";
echo "</tr>\n";
}
echo "</table>\n";
echo "<P><font color=red>SORRY, NO MATCH!</font><P>\n";
echo "<table width=100% cellpadding=1 cellspacing=1 border=0>\n";
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> \n";
switch ($item->task_status) {
case "Incomplete":
echo "<font color=red>".$item->task_status."</font>\n";
break;
case "In Progress":
echo "<font color=blue>".$item->task_status."</font>\n";
break;
case "Complete":
echo "<font color=green>".$item->task_status."</font>\n";
break;
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";
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";
$tm_order = "task_timestamp";
$tm_direction = "DESC";
echo "<td bgcolor=\"#BBBDD9\" valign=top><b>MODIFY</b> <img src=\"images/trs.gif\" width=11 height=16 border=0></td>\n";
//items status case
switch ($todo["task_status"]) {
case "Incomplete":
echo "<td bgcolor=\"#E9E9E9\" valign=top><font color=red>".$todo["task_status"]."</font></td>\n";
break;
case "In Progress":
echo "<td bgcolor=\"#E9E9E9\" valign=top><font color=blue>".$todo["task_status"]."</font></td>\n";
break;
case "Complete":
echo "<td bgcolor=\"#E9E9E9\" valign=top><font color=green>".$todo["task_status"]."</font></td>\n";
break;
}
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>|";
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";
<span style='color:gray; font-size:10px; font-family:verdana,arial;'>
<span style='color:gray; font-size:10px; font-family:verdana,arial;'>\n";
$buffer = fgets($fd, 4096);
$line++;
<td align=left>
<td align=right><input type=text size=10 value=\"keyword\" name=\"keyword\"><input type=submit value=\"Search\"></td>
</tr></table>
$buffer = fgets($fd, 4096);
$line++;
echo "<br>Your keyword is: <b>".$keyword."</b><P>\n";
echo "<table width=75% cellpadding=4 cellspacing=2 border=0>\n";
while($mykey = mysql_fetch_array($results)){
//list the results
echo "<tr>\n";
echo "<td bgcolor=\"#E9E9E9\" align=left valign=top><font color=white><img src=\"images/trs.gif\" width=70 height=1><br><nobr>\n";
switch ($mykey["task_status"]) {
case "Incomplete":
echo "<font color=red>".$mykey["task_status"]."</font>\n";
break;
case "In Progress":
echo "<font color=blue>".$mykey["task_status"]."</font>\n";
break;
case "Complete":
echo "<font color=green>".$mykey["task_status"]."</font>\n";
break;
}
echo "</nobr></font></td>\n";
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";
echo "</tr>\n";
}
echo "</table>\n";
echo "<P><font color=red>SORRY, NO MATCH!</font><P>\n";
echo "<table width=100% cellpadding=1 cellspacing=1 border=0>\n";
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> \n";
switch ($item->task_status) {
case "Incomplete":
echo "<font color=red>".$item->task_status."</font>\n";
break;
case "In Progress":
echo "<font color=blue>".$item->task_status."</font>\n";
break;
case "Complete":
echo "<font color=green>".$item->task_status."</font>\n";
break;
echo "<table width=100% cellpadding=1 cellspacing=1 border=0>\n";
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> \n";
switch ($item->task_status) {
case "Incomplete":
echo "<font color=red>".$item->task_status."</font>\n";
break;
case "In Progress":
echo "<font color=blue>".$item->task_status."</font>\n";
break;
case "Complete":
echo "<font color=green>".$item->task_status."</font>\n";
break;
echo "<table width=100% cellpadding=1 cellspacing=1 border=0>\n";
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> \n";
switch ($item->task_status) {
case "Incomplete":
echo "<font color=red>".$item->task_status."</font>\n";
break;
case "In Progress":
echo "<font color=blue>".$item->task_status."</font>\n";
break;
case "Complete":
echo "<font color=green>".$item->task_status."</font>\n";
break;
echo "<table width=100% cellpadding=1 cellspacing=1 border=0>\n";
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> \n";
switch ($item->task_status) {
case "Incomplete":
echo "<font color=red>".$item->task_status."</font>\n";
break;
case "In Progress":
echo "<font color=blue>".$item->task_status."</font>\n";
break;
case "Complete":
echo "<font color=green>".$item->task_status."</font>\n";
break;
$tm_order = "task_timestamp";
$tm_direction = "DESC";
//items status case
switch ($todo["task_status"]) {
case "Incomplete":
echo "<td bgcolor=\"#E9E9E9\" valign=top><font color=red>".$todo["task_status"]."</font></td>\n";
break;
case "In Progress":
echo "<td bgcolor=\"#E9E9E9\" valign=top><font color=blue>".$todo["task_status"]."</font></td>\n";
break;
case "Complete":
echo "<td bgcolor=\"#E9E9E9\" valign=top><font color=green>".$todo["task_status"]."</font></td>\n";
break;
}
<P>
if($row->user == $username && $row->month == $month && $row->day == $today && $row->year == $year)
{
$up = 1;
$ro = $row->id;
}
$query = "UPDATE ".$this->config['table_prefix']."scheduler SET dayschedule='$dayschedule' WHERE user='$username' AND id='$ro'";
$result = mysql_query($query);
$query = "INSERT into ".$this->config['table_prefix']."scheduler (user,dayschedule,month,day,year) VALUES ('$username','$dayschedule','$month','$today','$year')";
$result = mysql_query($query);
<td valign="top">
<td colspan="7">
<table cellpadding="0" cellspacing="0" border="0" width="100%">
<tr BGCOLOR="#ffffff">
<td width="20"><a href="<?php echo $this->href("", "", "month="); echo (($month-1)<1) ? 12 : $month-1 ; ?>&year=<?php echo (($month-1)<1) ? $year-1 : $year ; ?>"><<<</a></td>
<td align="center"><font size="2"><?php echo "$monthname $year"; ?></font></td>
<td width="20"><a href="<?php echo $this->href("", "", "month="); echo (($month+1)>12) ? 1 : $month+1 ; ?>&year=<?php echo (($month+1)>12) ? $year+1 : $year ; ?>">>>></a></td>
</tr>
</table>
<td width="22">Su</td>
<td width="22">Mo</td>
<td width="22">Tu</td>
<td width="22">We</td>
<td width="22">Th</td>
<td width="22">Fr</td>
<td width="22">Sa</td>
/*== set up blank days for first week ==*/
if ($firstweek) {
print " <tr BGCOLOR=\"#ffffff\">";
for ($i=1; $i<=$firstwday; $i++)
{ print " <td><font size=\"2\"> </font></td>"; }
$firstweek = false;
}
/*== Sunday start week with <tr> ==*/
if ($wday==0) { print " <tr BGCOLOR=\"#ffffff\">\n"; }
/*== check for event ==*/
print " <td>";
if($day<10) {
if($month<10) {
$tag = "$year:0$month:0$day";
} else {
$tag = "$year:$month:0$day";
}
} else {
if($month<10) {
$tag = "$year:0$month:$day";
} else {
$tag = "$year:$month:$day";
}
}
$todaydate = date("Y:m:d",mktime());
if($tag==$todaydate)
{
$font1 = "<font color=\"#FF0000\"><b>";
$font2 = "</b></font>";
}
else
{
$font1 = "";
$font2 = "";
}
print "<a href=".$site_base.$thispage."&day=$day&month=$month&year=$year>$font1$day$font2</a>";
print "</td>\n";
/*== Saturday week with </tr> ==*/
if ($wday==6) { print " </tr>\n"; }
$wday++;
$wday = $wday % 7;
$day++;
</td>
<br><a href="<?php echo $this->href("", "", "day="); echo (($today-1)<1) ? $lastday : $today-1 ; ?>&year=<?php echo $year; ?>&month=<?php echo $month; ?>"><<</a>
<P>
http://gmbowen.educ.unb.ca/wikitest/dayschedule.jpg
<P>
if($row->user == $username && $row->month == $month && $row->day == $today && $row->year == $year)
{
$up = 1;
$ro = $row->id;
}
$query = "UPDATE ".$this->config['table_prefix']."scheduler SET dayschedule='$dayschedule' WHERE user='$username' AND id='$ro'";
$result = mysql_query($query);
$query = "INSERT into ".$this->config['table_prefix']."scheduler (user,dayschedule,month,day,year) VALUES ('$username','$dayschedule','$month','$today','$year')";
$result = mysql_query($query);
<td valign="top">
<td colspan="7">
<table cellpadding="0" cellspacing="0" border="0" width="100%">
<tr>
<td width="20"><a href="<?php echo $this->href("", "", "month="); echo (($month-1)<1) ? 12 : $month-1 ; ?>&year=<?php echo (($month-1)<1) ? $year-1 : $year ; ?>"><<<</a></td>
<td align="center"><font size="2"><strong><? echo $username ?>'s Calendar for <?php echo "$monthname $year"; ?></strong></font></td>
<td width="20"><a href="<?php echo $this->href("", "", "month="); echo (($month+1)>12) ? 1 : $month+1 ; ?>&year=<?php echo (($month+1)>12) ? $year+1 : $year ; ?>">>>></a></td>
</tr>
</table>
<td>Sunday</td>
<td>Monday</td>
<td>Tuesday</td>
<td>Wednesday</td>
<td>Thursday</td>
<td>Friday</td>
<td>Saturday</td>
/*== set up blank days for first week ==*/
if ($firstweek) {
print " <tr>";
for ($i=1; $i<=$firstwday; $i++)
{ print " <td VALIGN=top ALIGN=left HEIGHT=70><font size=\"2\"> </font></td>"; }
$firstweek = false;
}
/*== Sunday start week with <tr> ==*/
if ($wday==0) { print " <tr>\n"; }
/*== check for event ==*/
print " <td VALIGN=top ALIGN=left WIDTH=150 HEIGHT=70>";
if($day<10) {
if($month<10) {
$tag = "$year:0$month:0$day";
} else {
$tag = "$year:$month:0$day";
}
} else {
if($month<10) {
$tag = "$year:0$month:$day";
} else {
$tag = "$year:$month:$day";
}
}
$todaydate = date("Y:m:d",mktime());
if($tag==$todaydate)
{
$font1 = "<font color=\"#FF0000\"><b>";
$font2 = "</b></font>";
}
else
{
$font1 = "";
$font2 = "";
}
print "<table width=\"100%\"><TR BGCOLOR=\"#E4DFDA\"><td><a href=".$site_base.$thispage."&day=$day&month=$month&year=$year#EntryBox> $font1$day$font2</a> $printme</td</tr><tr><td><small>$dayoutput</small></td></tr></table>";
print "</td>\n";
/*== Saturday week with </tr> ==*/
if ($wday==6) { print " </tr>\n"; }
$wday++;
$wday = $wday % 7;
$day++;
</td>
http://gmbowen.educ.unb.ca/wikitest/monthview.jpg
http://gmbowen.educ.unb.ca/wikitest/taskmanager.jpg
<td align=left>
<td align=right><input type=text size=15 value=\"keyword\" name=\"keyword\"><input type=submit value=\"Search\"></td>
</tr></table>
echo "<br>Your keyword is: <b>".$keyword."</b><P>\n";
echo "<table width=75% cellpadding=4 cellspacing=2 border=0>\n";
while($mykey = mysql_fetch_array($results)){
//list the results
echo "<tr>\n";
echo "<td bgcolor=\"#E9E9E9\" align=left valign=top><font color=white><img src=\"images/trs.gif\" width=70 height=1><br><nobr>\n";
switch ($mykey["task_status"]) {
case "Incomplete":
echo "<font color=red>".$mykey["task_status"]."</font>\n";
break;
case "In Progress":
echo "<font color=blue>".$mykey["task_status"]."</font>\n";
break;
case "Complete":
echo "<font color=green>".$mykey["task_status"]."</font>\n";
break;
}
echo "</nobr></font></td>\n";
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";
echo "</tr>\n";
}
echo "</table>\n";
echo "<P><font color=red>SORRY, NO MATCH!</font><P>\n";
echo "<table width=100% cellpadding=1 cellspacing=1 border=0>\n";
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> \n";
switch ($item->task_status) {
case "Incomplete":
echo "<font color=red>".$item->task_status."</font>\n";
break;
case "In Progress":
echo "<font color=blue>".$item->task_status."</font>\n";
break;
case "Complete":
echo "<font color=green>".$item->task_status."</font>\n";
break;
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";
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";
$tm_order = "task_timestamp";
$tm_direction = "DESC";
echo "<td bgcolor=\"#BBBDD9\" valign=top><b>MODIFY</b> <img src=\"images/trs.gif\" width=11 height=16 border=0></td>\n";
//items status case
switch ($todo["task_status"]) {
case "Incomplete":
echo "<td bgcolor=\"#E9E9E9\" valign=top><font color=red>".$todo["task_status"]."</font></td>\n";
break;
case "In Progress":
echo "<td bgcolor=\"#E9E9E9\" valign=top><font color=blue>".$todo["task_status"]."</font></td>\n";
break;
case "Complete":
echo "<td bgcolor=\"#E9E9E9\" valign=top><font color=green>".$todo["task_status"]."</font></td>\n";
break;
}
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>|";
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";
<span style='color:gray; font-size:10px; font-family:verdana,arial;'>
<span style='color:gray; font-size:10px; font-family:verdana,arial;'>\n";
$buffer = fgets($fd, 4096);
$line++;
<td align=left>
<td align=right><input type=text size=10 value=\"keyword\" name=\"keyword\"><input type=submit value=\"Search\"></td>
</tr></table>
$buffer = fgets($fd, 4096);
$line++;
echo "<br>Your keyword is: <b>".$keyword."</b><P>\n";
echo "<table width=75% cellpadding=4 cellspacing=2 border=0>\n";
while($mykey = mysql_fetch_array($results)){
//list the results
echo "<tr>\n";
echo "<td bgcolor=\"#E9E9E9\" align=left valign=top><font color=white><img src=\"images/trs.gif\" width=70 height=1><br><nobr>\n";
switch ($mykey["task_status"]) {
case "Incomplete":
echo "<font color=red>".$mykey["task_status"]."</font>\n";
break;
case "In Progress":
echo "<font color=blue>".$mykey["task_status"]."</font>\n";
break;
case "Complete":
echo "<font color=green>".$mykey["task_status"]."</font>\n";
break;
}
echo "</nobr></font></td>\n";
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";
echo "</tr>\n";
}
echo "</table>\n";
echo "<P><font color=red>SORRY, NO MATCH!</font><P>\n";
echo "<table width=100% cellpadding=1 cellspacing=1 border=0>\n";
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> \n";
switch ($item->task_status) {
case "Incomplete":
echo "<font color=red>".$item->task_status."</font>\n";
break;
case "In Progress":
echo "<font color=blue>".$item->task_status."</font>\n";
break;
case "Complete":
echo "<font color=green>".$item->task_status."</font>\n";
break;
echo "<table width=100% cellpadding=1 cellspacing=1 border=0>\n";
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> \n";
switch ($item->task_status) {
case "Incomplete":
echo "<font color=red>".$item->task_status."</font>\n";
break;
case "In Progress":
echo "<font color=blue>".$item->task_status."</font>\n";
break;
case "Complete":
echo "<font color=green>".$item->task_status."</font>\n";
break;
echo "<table width=100% cellpadding=1 cellspacing=1 border=0>\n";
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> \n";
switch ($item->task_status) {
case "Incomplete":
echo "<font color=red>".$item->task_status."</font>\n";
break;
case "In Progress":
echo "<font color=blue>".$item->task_status."</font>\n";
break;
case "Complete":
echo "<font color=green>".$item->task_status."</font>\n";
break;
echo "<table width=100% cellpadding=1 cellspacing=1 border=0>\n";
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> \n";
switch ($item->task_status) {
case "Incomplete":
echo "<font color=red>".$item->task_status."</font>\n";
break;
case "In Progress":
echo "<font color=blue>".$item->task_status."</font>\n";
break;
case "Complete":
echo "<font color=green>".$item->task_status."</font>\n";
break;
$tm_order = "task_timestamp";
$tm_direction = "DESC";
//items status case
switch ($todo["task_status"]) {
case "Incomplete":
echo "<td bgcolor=\"#E9E9E9\" valign=top><font color=red>".$todo["task_status"]."</font></td>\n";
break;
case "In Progress":
echo "<td bgcolor=\"#E9E9E9\" valign=top><font color=blue>".$todo["task_status"]."</font></td>\n";
break;
case "Complete":
echo "<td bgcolor=\"#E9E9E9\" valign=top><font color=green>".$todo["task_status"]."</font></td>\n";
break;
}
Deletions:
%%(php;1)
%%(php;1)
<P>
if($row->user == $username && $row->month == $month && $row->day == $today && $row->year == $year)
$up = 1;
$ro = $row->id;
}
$query = "UPDATE ".$this->config['table_prefix']."scheduler SET dayschedule='$dayschedule' WHERE user='$username' AND id='$ro'";
$result = mysql_query($query);
$query = "INSERT into ".$this->config['table_prefix']."scheduler (user,dayschedule,month,day,year) VALUES ('$username','$dayschedule','$month','$today','$year')";
$result = mysql_query($query);
<td valign="top">
<td colspan="7">
<table cellpadding="0" cellspacing="0" border="0" width="100%">
<tr BGCOLOR="#ffffff">
<td width="20"><a href="<?php echo $this->href("", "", "month="); echo (($month-1)<1) ? 12 : $month-1 ; ?>&year=<?php echo (($month-1)<1) ? $year-1 : $year ; ?>"><<<</a></td>
<td align="center"><font size="2"><?php echo "$monthname $year"; ?></font></td>
<td width="20"><a href="<?php echo $this->href("", "", "month="); echo (($month+1)>12) ? 1 : $month+1 ; ?>&year=<?php echo (($month+1)>12) ? $year+1 : $year ; ?>">>>></a></td>
</tr>
</table>
<td width="22">Su</td>
<td width="22">Mo</td>
<td width="22">Tu</td>
<td width="22">We</td>
<td width="22">Th</td>
<td width="22">Fr</td>
<td width="22">Sa</td>
/*== set up blank days for first week ==*/
if ($firstweek) {
print " <tr BGCOLOR=\"#ffffff\">";
for ($i=1; $i<=$firstwday; $i++)
{ print " <td><font size=\"2\"> </font></td>"; }
$firstweek = false;
/*== Sunday start week with <tr> ==*/
if ($wday==0) { print " <tr BGCOLOR=\"#ffffff\">\n"; }
/*== check for event ==*/
print " <td>";
if($day<10) {
if($month<10) {
$tag = "$year:0$month:0$day";
} else {
$tag = "$year:$month:0$day";
}
} else {
if($month<10) {
$tag = "$year:0$month:$day";
} else {
$tag = "$year:$month:$day";
}
$todaydate = date("Y:m:d",mktime());
if($tag==$todaydate)
$font1 = "<font color=\"#FF0000\"><b>";
$font2 = "</b></font>";
$font1 = "";
$font2 = "";
print "<a href=".$site_base.$thispage."&day=$day&month=$month&year=$year>$font1$day$font2</a>";
print "</td>\n";
/*== Saturday week with </tr> ==*/
if ($wday==6) { print " </tr>\n"; }
$wday++;
$wday = $wday % 7;
$day++;
<br><a href="<?php echo $this->href("", "", "day="); echo (($today-1)<1) ? $lastday : $today-1 ; ?>&year=<?php echo $year; ?>&month=<?php echo $month; ?>"><<</a>
%%(php;1)
<P>
http://gmbtst.msvu.ca/wikitest/dayschedule.jpg
%%(php;1)
<P>
if($row->user == $username && $row->month == $month && $row->day == $today && $row->year == $year)
$up = 1;
$ro = $row->id;
}
$query = "UPDATE ".$this->config['table_prefix']."scheduler SET dayschedule='$dayschedule' WHERE user='$username' AND id='$ro'";
$result = mysql_query($query);
$query = "INSERT into ".$this->config['table_prefix']."scheduler (user,dayschedule,month,day,year) VALUES ('$username','$dayschedule','$month','$today','$year')";
$result = mysql_query($query);
<td valign="top">
<td colspan="7">
<table cellpadding="0" cellspacing="0" border="0" width="100%">
<tr>
<td width="20"><a href="<?php echo $this->href("", "", "month="); echo (($month-1)<1) ? 12 : $month-1 ; ?>&year=<?php echo (($month-1)<1) ? $year-1 : $year ; ?>"><<<</a></td>
<td align="center"><font size="2"><strong><? echo $username ?>'s Calendar for <?php echo "$monthname $year"; ?></strong></font></td>
<td width="20"><a href="<?php echo $this->href("", "", "month="); echo (($month+1)>12) ? 1 : $month+1 ; ?>&year=<?php echo (($month+1)>12) ? $year+1 : $year ; ?>">>>></a></td>
</tr>
</table>
<td>Sunday</td>
<td>Monday</td>
<td>Tuesday</td>
<td>Wednesday</td>
<td>Thursday</td>
<td>Friday</td>
<td>Saturday</td>
/*== set up blank days for first week ==*/
if ($firstweek) {
print " <tr>";
for ($i=1; $i<=$firstwday; $i++)
{ print " <td VALIGN=top ALIGN=left HEIGHT=70><font size=\"2\"> </font></td>"; }
$firstweek = false;
/*== Sunday start week with <tr> ==*/
if ($wday==0) { print " <tr>\n"; }
/*== check for event ==*/
print " <td VALIGN=top ALIGN=left WIDTH=150 HEIGHT=70>";
if($day<10) {
if($month<10) {
$tag = "$year:0$month:0$day";
} else {
$tag = "$year:$month:0$day";
}
} else {
if($month<10) {
$tag = "$year:0$month:$day";
} else {
$tag = "$year:$month:$day";
}
$todaydate = date("Y:m:d",mktime());
if($tag==$todaydate)
$font1 = "<font color=\"#FF0000\"><b>";
$font2 = "</b></font>";
$font1 = "";
$font2 = "";
print "<table width=\"100%\"><TR BGCOLOR=\"#E4DFDA\"><td><a href=".$site_base.$thispage."&day=$day&month=$month&year=$year#EntryBox> $font1$day$font2</a> $printme</td</tr><tr><td><small>$dayoutput</small></td></tr></table>";
print "</td>\n";
/*== Saturday week with </tr> ==*/
if ($wday==6) { print " </tr>\n"; }
$wday++;
$wday = $wday % 7;
$day++;
http://gmbtst.msvu.ca/wikitest/monthview.jpg
http://gmbtst.msvu.ca/wikitest/taskmanager.jpg
%%(php;1)
<td align=left>
<td align=right><input type=text size=15 value=\"keyword\" name=\"keyword\"><input type=submit value=\"Search\"></td>
</tr></table>
echo "<br>Your keyword is: <b>".$keyword."</b><P>\n";
echo "<table width=75% cellpadding=4 cellspacing=2 border=0>\n";
while($mykey = mysql_fetch_array($results)){
//list the results
echo "<tr>\n";
echo "<td bgcolor=\"#E9E9E9\" align=left valign=top><font color=white><img src=\"images/trs.gif\" width=70 height=1><br><nobr>\n";
switch ($mykey["task_status"]) {
case "Incomplete":
echo "<font color=red>".$mykey["task_status"]."</font>\n";
break;
case "In Progress":
echo "<font color=blue>".$mykey["task_status"]."</font>\n";
break;
case "Complete":
echo "<font color=green>".$mykey["task_status"]."</font>\n";
break;
}
echo "</nobr></font></td>\n";
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";
echo "</tr>\n";
echo "</table>\n";
echo "<P><font color=red>SORRY, NO MATCH!</font><P>\n";
echo "<table width=100% cellpadding=1 cellspacing=1 border=0>\n";
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> \n";
switch ($item->task_status) {
case "Incomplete":
echo "<font color=red>".$item->task_status."</font>\n";
break;
case "In Progress":
echo "<font color=blue>".$item->task_status."</font>\n";
break;
case "Complete":
echo "<font color=green>".$item->task_status."</font>\n";
break;
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";
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";
$tm_order = "task_timestamp";
$tm_direction = "DESC";
echo "<td bgcolor=\"#BBBDD9\" valign=top><b>MODIFY</b> <img src=\"images/trs.gif\" width=11 height=16 border=0></td>\n";
//items status case
switch ($todo["task_status"]) {
case "Incomplete":
echo "<td bgcolor=\"#E9E9E9\" valign=top><font color=red>".$todo["task_status"]."</font></td>\n";
break;
case "In Progress":
echo "<td bgcolor=\"#E9E9E9\" valign=top><font color=blue>".$todo["task_status"]."</font></td>\n";
break;
case "Complete":
echo "<td bgcolor=\"#E9E9E9\" valign=top><font color=green>".$todo["task_status"]."</font></td>\n";
break;
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>|";
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";
<span style='color:gray; font-size:10px; font-family:verdana,arial;'>
<span style='color:gray; font-size:10px; font-family:verdana,arial;'>\n";
$buffer = fgets($fd, 4096);
$line++;
%%(php;1)
<td align=left>
<td align=right><input type=text size=10 value=\"keyword\" name=\"keyword\"><input type=submit value=\"Search\"></td>
</tr></table>
$buffer = fgets($fd, 4096);
$line++;
%%(php;1)
echo "<br>Your keyword is: <b>".$keyword."</b><P>\n";
echo "<table width=75% cellpadding=4 cellspacing=2 border=0>\n";
while($mykey = mysql_fetch_array($results)){
//list the results
echo "<tr>\n";
echo "<td bgcolor=\"#E9E9E9\" align=left valign=top><font color=white><img src=\"images/trs.gif\" width=70 height=1><br><nobr>\n";
switch ($mykey["task_status"]) {
case "Incomplete":
echo "<font color=red>".$mykey["task_status"]."</font>\n";
break;
case "In Progress":
echo "<font color=blue>".$mykey["task_status"]."</font>\n";
break;
case "Complete":
echo "<font color=green>".$mykey["task_status"]."</font>\n";
break;
}
echo "</nobr></font></td>\n";
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";
echo "</tr>\n";
echo "</table>\n";
echo "<P><font color=red>SORRY, NO MATCH!</font><P>\n";
echo "<table width=100% cellpadding=1 cellspacing=1 border=0>\n";
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> \n";
switch ($item->task_status) {
case "Incomplete":
echo "<font color=red>".$item->task_status."</font>\n";
break;
case "In Progress":
echo "<font color=blue>".$item->task_status."</font>\n";
break;
case "Complete":
echo "<font color=green>".$item->task_status."</font>\n";
break;
echo "<table width=100% cellpadding=1 cellspacing=1 border=0>\n";
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> \n";
switch ($item->task_status) {
case "Incomplete":
echo "<font color=red>".$item->task_status."</font>\n";
break;
case "In Progress":
echo "<font color=blue>".$item->task_status."</font>\n";
break;
case "Complete":
echo "<font color=green>".$item->task_status."</font>\n";
break;
echo "<table width=100% cellpadding=1 cellspacing=1 border=0>\n";
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> \n";
switch ($item->task_status) {
case "Incomplete":
echo "<font color=red>".$item->task_status."</font>\n";
break;
case "In Progress":
echo "<font color=blue>".$item->task_status."</font>\n";
break;
case "Complete":
echo "<font color=green>".$item->task_status."</font>\n";
break;
echo "<table width=100% cellpadding=1 cellspacing=1 border=0>\n";
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> \n";
switch ($item->task_status) {
case "Incomplete":
echo "<font color=red>".$item->task_status."</font>\n";
break;
case "In Progress":
echo "<font color=blue>".$item->task_status."</font>\n";
break;
case "Complete":
echo "<font color=green>".$item->task_status."</font>\n";
break;
$tm_order = "task_timestamp";
$tm_direction = "DESC";
//items status case
switch ($todo["task_status"]) {
case "Incomplete":
echo "<td bgcolor=\"#E9E9E9\" valign=top><font color=red>".$todo["task_status"]."</font></td>\n";
break;
case "In Progress":
echo "<td bgcolor=\"#E9E9E9\" valign=top><font color=blue>".$todo["task_status"]."</font></td>\n";
break;
case "Complete":
echo "<td bgcolor=\"#E9E9E9\" valign=top><font color=green>".$todo["task_status"]."</font></td>\n";
break;
