CalendarNow

[Mandakins]

I purchased a php Calendar program which apparently has been discontinued and I cannot find a support forum for it.

It works great except that today's events do not display (and there are events for today).

If anyone could take a glance through this voluminous code and let me know if you see anything jarring that would explain why this is happening, I'd be extremely appreciative.

Email me if you'd like to see the working example.

Code:

<?
require("engine.inc.php");
if ($nl != ""){
$url = mysql_query ("SELECT FROM cnpBackend
WHERE valid LIKE '1'
LIMIT 1
");
$urlf = mysql_fetch_array($url);
$murl = $urlf["murl"];
$disfind = mysql_query ("SELECT FROM cnpLists
WHERE id LIKE '$nl'
LIMIT 1
");
$display = mysql_fetch_array($disfind);
$cwidth = $display["cwidth"];
$shownum = $display["shownum"];
$popw = $display["popw"];
$poph = $display["poph"];
$cdb = $display["cdb"];
$tdb = $display["tdb"];
$sizem = $display["sizem"];
$sized = $display["sized"];
$sizen = $display["sizen"];
$fontt = $display["fontt"];
if ($cwidth == ""){
$cwidth = "450";
}
if ($shownum == ""){
$cwidth = "0";
}
if ($popw == ""){
$popw = "400";
}
if ($poph == ""){
$poph = "375";
}
if ($cdb == ""){
$cdb = "EEEEEE";
}
if ($tdb == ""){
$tdb = "66CCFF";
}
if ($sizem == ""){
$sizem = "18";
}
if ($sized == ""){
$sized = "9";
}
if ($sizen == ""){
$sizen = "11";
}
if ($fontt == ""){
$fontt = "Arial, Helvetica, sans-serif";
}
$cal_num = $shownum;
$pop_w = $popw;
$pop_h = $poph;
}
?> <?
if($nl == ""){
?>
<table width="100%" border="0" cellspacing="0" cellpadding="1" bgcolor="#EAEAEA">
<tr>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="4" bordercolor="#FFFFFF" align="center" bgcolor="#FFFFFF">
<tr bgcolor="#EAEAEA">
<td bordercolor="#CCCCCC">
<div align="left"><font size="2" face="<? print $fontt; ?>"><b>Calendar
Name </b></font></div>
</td>
</tr>
<?php
$result = mysql_query ("SELECT * FROM cnpLists
WHERE name != ''
ORDER BY name
");
if ($row = mysql_fetch_array($result)) {

do {

?>
<tr <? if ($cpick == 0){ ?>bgcolor="#F3F3F3"<? } else{ ?>bgcolor="#E9E9E9"<? } ?>>
<td bordercolor="#CCCCCC">
<div align="left"><font size="1" face="<? print $fontt; ?>">
<a href="events2t.php?nl=<? print $row["id"]; ?>&login=<?=$login;?>&password=<?=$password;?>">
<font size="2"> <font color="#000000"> <?php print stripslashes($row["name"]); ?>
</font></font></a></font></div>
</td>
</tr>
<?php
if ($cpick == 0){
$cpick = 1;
}
else {
$cpick = 0;
}

} while($row = mysql_fetch_array($result));

} else {
?>
<tr bgcolor="#FFFFFF">
<td bordercolor="#CCCCCC">
<div align="left"><font size="1" face="<? print $fontt; ?>">
<font size="2"> <font color="#000000">There are no
calendars to choose from.</font></font></font></div>
</td>
</tr>
<?php
if ($cpick == 0){
$cpick = 1;
}
else {
$cpick = 0;
}
}
?>
</table>
</td>
</tr>
</table>
<?
die();
}
?> <?
if (!$calstyle) $calstyle = "1";
$nbc="$cdb"; // NORMAL BACKGROUND COLOR
$abc="E9B4A1";
$tbc="$tdb"; // TODAY'S BACKGROUND COLOR
$day[0]="Sun";
$day[1]="Mon";
$day[2]="Tues";
$day[3]="Wed";
$day[4]="Thurs";
$day[5]="Fri";
$day[6]="Sat";
$mth[1]="January";
$mth[2]="February";
$mth[3]="March";
$mth[4]="April";
$mth[5]="May";
$mth[6]="June";
$mth[7]="July";
$mth[8]="August";
$mth[9]="September";
$mth[10]="October";
$mth[11]="November";
$mth[12]="December";
if (!$daystart) $daystart=0;
if (!$ny) $ny=0;
if (!$nt) $nt=0;
//OFFSET TIME +/-
if (!$ctime) $ctime = "-0";
if (!$tw) $tw="595"; // Table Width
$cw="85";
if (!$ch) $ch="$cw"; // Cell Height
if (!$algn) $algn="0";
if (!$fsm) $fsm="$sizem"; // FONT SIZE MONTH
if (!$fsd) $fsd="$sized"; // FONT SIZE DAY NAMES
if (!$fsn) $fsn="$sizen"; // FONT SIZE NUMBERS
if (!$fwm) $fwm="bold"; else $fwm="normal"; // FONT WEIGHT MONTH
if (!$fwd) $fwd="normal"; else $fwd="bold"; // FONT WEIGHT DAY NAMES
if (!$fwn) $fwn="normal"; else $fwn="bold"; // FONT WEIGHT NUMBERS
?>
<style TYPE="text/css">
<!--
.monthyear { font-family: <? print $fontt; ?>; font-size: <?echo$fsm?>px; font-weight: <?echo$fwm?>; color: #000000}
.daynames { font-family: <? print $fontt; ?>; font-size: <?echo$fsd?>px; font-weight: <?echo$fwd?>; color: #000000}
.dates { font-family: <? print $fontt; ?>; font-size: <?echo$fsn?>px; font-weight: <?echo$fwn?>; color: #000000}
-->
</style>
<?
$cw=$tw/7;
if ($algn==0) $algn="align='center' valign='middle'";
else $algn="align='right' valign='top'";
$ctime = $ctime*3600;
$tmo = date("m", time()+$ctime);
$tda = date("j", time()+$ctime);
$tyr = date("Y", time()+$ctime);
$tnum = (intval((date ("U", mktime(20,0,0,$tmo,$tda,$tyr))/86400)))-$daystart; // TODAY'S DAY NUMBER
if (!$mo) $mo=$tmo;
if (!$yr) $yr=$tyr;
$daycount = (intval((date ("U", mktime(20,0,0,$mo,1,$yr))/86400)))-$daystart; // FIRST OF MONTH DAY NUMBER
$mo=intval($mo);
$mn = $mth[$mo]; // SET MONTH NAME
if ($ny!=1) {$mn = $mn." ".$yr;} // ADD YEAR TO MONTH NAME?
$sd = date ("w", mktime(0,0,0,$mo,1-$daystart,$yr));
$cd = 1-$sd;
$nd = mktime (0,0,0,$mo+1,0,$yr);
$nd = (strftime ("%d",$nd))+1;
if ($mrks) {
$mrks = explode ("x",$mrks);
$smc = count ($mrks);
$mrke = explode ("x",$mrke);
$emc = count ($mrke);
if ($smc==1) {
$mrks[1]="3000-01-01";
$mrke[1]="3000-01-01";
}
}
$i=0;
while ($i < $smc) {
$mrks[$i] = ereg_replace('-','/', $mrks[$i]);
$mrke[$i] = ereg_replace('-','/', $mrke[$i]);
$start = intval(strtotime ($mrks[$i])/86400)+1;
$end = intval(strtotime ($mrke[$i])/86400)+1;
if (!$mrke[$i]) $end=$start; // MARK SINGLE DAY WITH ONLY MRKS VARIABLE
if (!$bgc[$start]) {$bgc[$start]=1;} else {$bgc[$start]=4;}
$bgc[$end]=3;
for ($n = ($start+1); $n < $end; $n++) {
$bgc[$n] = 2;}
$i++;
}
?>
Part II follows:

[Mandakins]

<title>Calendar</title>
<div align="center">
<table width="<?echo$tw?>" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="50%"><font size="1" face="<? print $fontt; ?>">
<?
$vmo = $mo - 1;
$vyr = $yr;
if ($vmo < 1){
$vyr = $vyr - 1;
$vmo = "12";
}
?> <a href="<?
print $SERVER['PHP_SELF'];
?>?nl=<? print $nl; ?>&yr=<? print $vyr; ?>&mo=<? print $vmo; ?>">&lt;</a></font></td>
<td width="50%">
<div align="right"><font size="1" face="<? print $fontt; ?>">
<?
$vmo = $mo + 1;
$vyr = $yr;
if ($vmo > 12){
$vyr = $vyr + 1;
$vmo = "1";
}
?> <a href="<?
print $SERVER['PHP_SELF'];
?>?nl=<? print $nl; ?>&yr=<? print $vyr; ?>&mo=<? print $vmo; ?>">&gt;</a></font></div>
</td>
</tr>
</table>
</div>
<table WIDTH="<?echo$tw?>" BORDER="0" CELLSPACING="0" CELLPADDING="2" align="center">
<tr>
<td CLASS="monthyear">
<div ALIGN="center"> <?echo "$mn";?> </div>
</td>
</tr>
</table>
<table WIDTH="<?echo$tw?>" BORDER="0" CELLSPACING="2" CELLPADDING="2" CLASS="daynames" align="center">
<tr ALIGN="center"> <?
for ($I=0;$I<7;$I++) {
$dayprint=$daystart+$I;
if ($dayprint>6) $dayprint=$dayprint-7;
echo"<td WIDTH=$cw valign = top>$day[$dayprint]</td>";
}
?> </tr>
<?
if ($calstyle==1) {
for ($i = 1; $i<7; $i++) {
if ($cd>$nd) break;
?>
<tr <?echo$algn?> CLASS="dates" height=<?echo$ch?>> <?
for ($prow = 1; $prow<8; $prow++) {
if ($daycount==$tnum && $nt!="1" && $cd>0) {echo "<td width=$cw valign = top bgcolor=$tbc>";
$mo2 = sprintf("s",$mo);
$cd2 = sprintf("s",$cd);
$ddd = "$yr-$mo2-$cd2";
$qq = mysql_query ("SELECT * FROM cnpCalendar
WHERE date LIKE '$ddd'
AND nl LIKE '$nl'
ORDER BY header
");

if ($row = mysql_fetch_array($qq)) {
print "<b>"; ?><a href="#" onClick="window.open('<? print $murl; ?>/events2t.php?dayd=<? print $ddd; ?>&nl=<? print $nl; ?>&login=<?=$login;?>&password=<?=$password;?>','win','width=<? print $pop_w; ?>,height=<? print $pop_h; ?>,scrollbars,resizable');">
<? print "$cd</a></b>";
}
else {
print "$cd";
}
if ($cal_num == 1){

print "<br>";
$mo2 = sprintf("s",$mo);

$cd2 = sprintf("s",$cd);

$ddd = "$yr-$mo2-$cd2";

$qq = mysql_query ("SELECT * FROM cnpCalendar

                     WHERE date LIKE '$ddd'
					 AND nl LIKE '$nl'

                   	ORDER BY header

");

if ($row = mysql_fetch_array($qq)) {

$cqq = mysql_num_rows($qq);

if ($cqq != 1){

print "<b>";
?> <a href="#" onClick="window.open('<? print $murl; ?>/events2t.php?dayd=<? print $ddd; ?>&nl=<? print $nl; ?>&login=<?=$login;?>&password=<?=$password;?>','win','width=<? print $pop_w; ?>,height=<? print $pop_h; ?>,scrollbars,resizable');">
<? print "$header - $time</a></b>";
}
else {
print "<b>";
?> <a href="#" onClick="window.open('<? print $murl; ?>/events2t.php?dayd=<? print $ddd; ?>&nl=<? print $nl; ?>&login=<?=$login;?>&password=<?=$password;?>','win','width=<? print $pop_w; ?>,height=<? print $pop_h; ?>,scrollbars,resizable');">
<? print "$header - $time</a></b>";
}

}
}
echo "</td>";$daycount++;$cd++;}

else { ?> <td width="<?echo $cw?>" valign = top <?if ($cd>0 && $cd<$nd) {echo " bgcolor=";if ($bgc[$daycount]) {echo $abc;} else {echo $nbc;} echo ">";$daycount++;} else {echo ">";} if ($cd>0 && $cd<$nd) { $mo2 = sprintf("%02s",$mo);$cd2 = sprintf("%02s",$cd); $ddd = "$yr-$mo2-$cd2";$qq = mysql_query ("SELECT FROM cnpCalendar WHERE date LIKE '$ddd' AND nl LIKE '$nl' ORDER BY header");if ($row = mysql_fetch_array($qq)) {print "<b>"; ?><a href="#" onClick="window.open('<? print $murl; ?>/events2t.php?dayd=<? print $ddd; ?>&nl=<? print $nl; ?>&login=<?=$login;?>&password=<?=$password;?>','win','width=<? print $pop_w; ?>,height=<? print $pop_h; ?>,scrollbars,resizable');">
<? print "$cd</a></b>";
}
else {
print "$cd";
}
}
if ($cal_num == 1){
print "<br><br>";
$qq = "SELECT FROM cnpCalendar WHERE date LIKE '$ddd' AND nl LIKE '$nl' ORDER BY time";

//if ($row = mysql_fetch_array($qq)) {
$result2 = mysql_query($qq);
while($row = mysql_fetch_array($result2)) {
$time = $row["time"];
$header = stripslashes($row["header"]);

if ($cqq != 1){
print "<font size = '1'><b>"; ?><a href="#" onClick="window.open('<? print $murl; ?>/events2t.php?dayd=<? print $ddd; ?>&nl=<? print $nl; ?>&login=<?=$login;?>&password=<?=$password;?>','win','width=<? print $pop_w; ?>,height=<? print $pop_h; ?>,scrollbars,resizable');">
<? print " $header - $time </a></b></font> <BR><BR>";
}
else {
print "<font size = '1'><b>"; ?><a href="#" onClick="window.open('<? print $murl; ?>/events2t.php?dayd=<? print $ddd; ?>&nl=<? print $nl; ?>&login=<?=$login;?>&password=<?=$password;?>','win','width=<? print $pop_w; ?>,height=<? print $pop_h; ?>,scrollbars,resizable');">
<? print " $header - $time </a></b></font> <BR><BR>";
}
//}
}
}
echo "</td>";$cd++;
?> <? }} ?> </tr>
<?
}
}

?>
</table>
<br>
<table width="120" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td width="15" bgcolor="#<? print $tdb; ?>">
<div align="center"></div>
</td>
<td>
<div align="left"><font size="2" face="<? print $fontt; ?>">&nbsp;&nbsp;=
Today </font></div>
</td>
</tr>
</table>
<hr width="<?echo$tw?>" size="1" noshade>
<table width="<?echo$tw?>" border="0" align="center" cellpadding="4" cellspacing="0">
<tr valign="top">
<td width="50%"> <font size="1" face="<? print $fontt; ?>"><b>View
Other Months:</b></font>
<form name="form1" method="post" action="<?
print $_SERVER['PHP_SELF'];
?>">
<select name="mo">
<option value="1" <? if ($mo == "1"){ print "selected"; } ?>>January</option>
<option value="2" <? if ($mo == "2"){ print "selected"; } ?>>February</option>
<option value="3" <? if ($mo == "3"){ print "selected"; } ?>>March</option>
<option value="4" <? if ($mo == "4"){ print "selected"; } ?>>April</option>
<option value="5" <? if ($mo == "5"){ print "selected"; } ?>>May</option>
<option value="6" <? if ($mo == "6"){ print "selected"; } ?>>June</option>
<option value="7" <? if ($mo == "7"){ print "selected"; } ?>>July</option>
<option value="8" <? if ($mo == "8"){ print "selected"; } ?>>August</option>
<option value="9" <? if ($mo == "9"){ print "selected"; } ?>>September</option>
<option value="10" <? if ($mo == "10"){ print "selected"; } ?>>October</option>
<option value="11" <? if ($mo == "11"){ print "selected"; } ?>>November</option>
<option value="12" <? if ($mo == "12"){ print "selected"; } ?>>December</option>
</select>
<select name="yr">
<option value="2002" <? if ($yr == "2002"){ print "selected"; } ?>>2002</option>
<option value="2003" <? if ($yr == "2003"){ print "selected"; } ?>>2003</option>
<option value="2004" <? if ($yr == "2004"){ print "selected"; } ?>>2004</option>
<option value="2005" <? if ($yr == "2005"){ print "selected"; } ?>>2005</option>
<option value="2006" <? if ($yr == "2006"){ print "selected"; } ?>>2006</option>
<option value="2007" <? if ($yr == "2007"){ print "selected"; } ?>>2007</option>
<option value="2008" <? if ($yr == "2008"){ print "selected"; } ?>>2008</option>
<option value="2009" <? if ($yr == "2009"){ print "selected"; } ?>>2009</option>
<option value="2010" <? if ($yr == "2010"){ print "selected"; } ?>>2010</option>
</select>
<input type="submit" name="Submit" value="Submit">
<input name="nl" type="hidden" id="nl" value="<? print $nl; ?>">
</form>
</td>
</tr>
</table>