...

View Full Version : page continues to load without showing any data



runnerjp
10-16-2009, 03:40 PM
I have a calander in which when you click on a date which has entry on it it opens up a popup window and shows the data. This works fine untill i include it onto my profiles page via include
<?php include "diary/cal_show.php";?> and the box opens but continues to load and never shows the results as shown below http://runningprofiles.com/images/error66.jpg the thing is when i open the calander of the url diary/cal_show.php it works.

below i have included the relevant php pages.

here is the calander itself


<script src="http://www.runningprofiles.com/jquery.js" type="text/javascript"></script>
<link href="http://www.runningprofiles.com/members/diary/facebox/facebox.css" media="screen" rel="stylesheet" type="text/css">
<script src="http://www.runningprofiles.com/members/diary/facebox/facebox.js" type="text/javascript"></script>
<script>
jQuery(document).ready(function($) {
$('a[rel*=facebox]').facebox()
}) </script>




<?php


// there is NO NEED to edit ANY of this code

$ev_dat = array();
for ($i=0;$i<32;$i++) {
$ev_dat[$i]=0;
}

$now = date("Y-m-d", time());
list($ty, $tm, $td) = explode('-',$now); // ty=thisyear, etc. used for highlighting 'today'

include("cal_parms.php"); // assorted configuration variables
include($dat_names); // retrieved from cal_parms.php as a 'language' file

if (!isset($_GET['m'])) {
$m = date("m",mktime());
} else {
$m = $_GET['m'];
}
if (!isset($_GET['y'])) {
$y = date("Y",mktime());
} else {
$y = $_GET['y'];
}

/*== get what weekday the first is on ==*/
$tmpd = getdate(mktime(0,0,0,$m,1,$y));
$month = $tmpd["month"];
$firstwday= $tmpd["wday"];
if ($firstDayIsMonday == 1) {
if ($firstwday == 0) {
$firstwday = 6;
} else {
$firstwday--;
}
}
$lastday = mk_getLastDayofMonth($m,$y);

/*== get the last day of the month ==*/
function mk_getLastDayofMonth($mon,$year)
{
for ($tday=28; $tday <= 31; $tday++)
{
$tdate = getdate(mktime(0,0,0,$mon,$tday,$year));
if ($tdate["mon"] != $mon)
{
break;
}
}
$tday--;
return $tday;
}

// compute range of dates for this month to match dates in database in the format yyyy-mm-dd
if (strlen($m)<2) {
$q="0";
$q.=$m;
}
else {
$q = $m;
}
$dats_beg = $y. "-". $q. "-01";
$dats_en = $y. "-". $q. "-". $lastday;

// open db conn and select all records where date is between $dats_beg and $dats_en
include("cal_db_conn.php");
mysql_connect($db_host, $db_login, $db_pass) or die ("Can't connect!");
mysql_select_db($db_name) or die ("Can't open database!");
$query = "SELECT * FROM $db_table WHERE (ev_dat>='$dats_beg') AND (ev_dat<='$dats_en') ";

$result = mysql_db_query($db_name, $query);
// any matches?
if ($result)
{
// handle the matches and pass relevant info to arrays
while ($myrow = mysql_fetch_array($result))
{
$found = $myrow['ev_dat'];
$pieces = explode("-", $found);
$dd = intval($pieces[2]);
$ev_dat[$dd] = $myrow['id'];
}
}
?>
<table cellpadding="1" cellspacing="1" border="0" bgcolor="#<? echo $bg_edge; ?>">
<tr><td colspan="7" bgcolor="#<? echo $bg_top; ?>">
<table cellpadding="1" cellspacing="1" border="0" width="100%">
<tr bgcolor="#<? echo $bg_top; ?>"><th width="20" style="<?php echo $hcell; ?>"><a href="<? echo $username; ?>&m=<?=(($m-1)<1) ? 12 : $m-1 ?>&amp;y=<?=(($m-1)<1) ? $y-1 : $y ?>"><img src='http://www.runningprofiles.com/calendar/images/prev.gif' height='18' width='18' alt='' border='0' /></a></th>
<th style="<?php echo $hcell; ?>">
<?php
echo "<a href='../diary/show-month.php?mon=". $m. "&amp;yr=". $y. "'rel=\"facebox\">";
echo "<span style='text-decoration:none'>". $mo[intval($m)]. " ". $y. "</span></a>";
?>
</th>
<th width="20" style="<? echo $hcell; ?>"><a href="<? echo $username; ?>&m=<?=(($m+1)>12) ? 1 : $m+1 ?>&amp;y=<?=(($m+1)>12) ? $y+1 : $y ?>"><img src='http://www.runningprofiles.com/calendar/images/next.gif' height='18' width='18' border='0' alt='' /></a></th>
</tr>
</table>
</td></tr>
<tr bgcolor="#<? echo $bg_top; ?>">
<th width="20" style="<?php echo $hcell; ?>"><? echo $da[1]; ?></th>
<th width="20" style="<?php echo $hcell; ?>"><? echo $da[2]; ?></th>
<th width="20" style="<?php echo $hcell; ?>"><? echo $da[3]; ?></th>
<th width="20" style="<?php echo $hcell; ?>"><? echo $da[4]; ?></th>
<th width="20" style="<?php echo $hcell; ?>"><? echo $da[5]; ?></th>
<th width="20" style="<?php echo $hcell; ?>"><? echo $da[6]; ?></th>
<th width="20" style="<?php echo $hcell; ?>"><? echo $da[7]; ?></th>
</tr>

<?
$d = 1;
$wday = $firstwday;
$firstweek = true;
/*== loop through all the days of the month ==*/
while ( $d <= $lastday)
{
/*== set up blank days for first week ==*/
if ($firstweek)
{
if ($wday!=0) {
echo "<tr bgcolor='#". $bg_tabl. "'>\n";
for ($i=1; $i<=$firstwday; $i++) {
echo "<td style='". $tcell. "' bgcolor='#". $bg_fill. "'>&nbsp;</td>\n";
}
}
/*== Sunday start week with <tr> ==*/
else {
echo "<tr bgcolor='#". $bg_tabl. "'>\n";
}
$firstweek = false;
}
/*== check for event ==*/
echo "<td style='". $tcell. "' ";
// is this day 'today' AND there's no event today
if (($ty==$y) && ($tm==$m) && ($td == $d) && (!$ev_dat[$d])) {
echo "bgcolor='#". $bg_now. "'>". $d;
}
elseif ($ev_dat[$d]) {
// get what's happening that day and use as 'mouseOver' for the link
$query = "SELECT * FROM $db_table WHERE id=$ev_dat[$d] ";
$result = mysql_query($query);
$ev = mysql_fetch_array($result);
$titl = $ev['ev_title'];
echo "bgcolor='#". $bg_act. "'>";
$url = "../diary/show.php?event=". $ev_dat[$d]. "&amp;sho=". $win_sho;

echo "<a href=' $url' rel=\"facebox\" title=\"". $titl. "\">". $d. "</a>";

}
else {
echo "bgcolor='#". $bg_days. "'>". $d;
}
echo "</td>\n";

/*== Saturday end week with </tr> ==*/
if ($wday==6) {
echo "</tr>\n";
}
$wday++;
$wday = $wday % 7;
if (($wday==0) AND ($d!=$lastday)){ echo "<tr bgcolor='#". $bg_tabl. "'>\n"; }
$d++;
}
// and close off the table
if (($wday!=7) AND ($wday!=0)) {
for ($i=$wday; $i<=6; $i++) {
echo "<td style='". $tcell. "' bgcolor='#". $bg_fill. "'>&nbsp;</td>\n";
}
echo "</tr>";
}
echo "\n</table>";
include("win_open.php");


?>


row 104 = echo "<a href='../diary/show-month.php?mon=". $m. "&amp;yr=". $y. "'rel=\"facebox\">"; is one of the areas im talking about.

now like i said this all works fine on its own but as soon as i add it to this page it dosent work

profiles.php


<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html lang="en">
<link rel="stylesheet" type="text/css" href="http://www.runningprofiles.com/css/login.css">
<link rel="stylesheet" type="text/css" href="include/profiletab/ajaxtabs/ajaxtabs.css">
<script type="text/javascript" src="include/profiletab/ajaxtabs/ajaxtabs.js"></script>
<script type="text/javascript" src="http://www.runningprofiles.com/popup.js"></script>
<script src="http://www.runningprofiles.com/jquery.js" type="text/javascript"></script>
<link href="http://www.runningprofiles.com/members/diary/facebox/facebox.css" media="screen" rel="stylesheet" type="text/css">
<script src="http://www.runningprofiles.com/members/diary/facebox/facebox.js" type="text/javascript"></script>

<script>
jQuery(document).ready(function($) {
$('a[rel*=facebox]').facebox()
}) </script>
<?php
require_once '../settings.php';
checkLogin('1 2');

include "../info.php"; // sets username/id ect
include "../getuser.php"; // records user view on page
ini_set('error_reporting', E_ALL);

$getuser = mysql_fetch_assoc(mysql_query("SELECT * from users where Username='$profilename'"));
$getuserprofile = mysql_fetch_assoc(mysql_query("SELECT * from profile where ID='".$getuser['ID']."'"));

$sql1 = "Select * FROM diary where author = '$profilename' ORDER BY `ev_dat` DESC LIMIT 0, 5";
$postsresult1 = mysql_query($sql1) or die("Could not get diary");
$num1 = mysql_num_rows($postsresult1);

$sql = "Select DISTINCT title FROM forumtutorial_posts where author = '$profilename' ORDER BY `showtime` DESC LIMIT 0, 5";
$postsresult = mysql_query($sql) or die("Could not get threads");
$num = mysql_num_rows($postsresult);

?><table width="99%" cellspacing="0" cellpadding="0">
<tr>
<td colspan="2"></td>
<td width="21%">&nbsp;</td>
</tr>
<tr>
<td width="22%" height="381" align="center" valign="top"><div align="center">
<table width="100%" cellspacing="0" cellpadding="0" class="loggedin">
<tr>
<td><div align="center"><br />
<img src='http://www.runningprofiles.com/members/images/thumbs/<?php echo $getuser['image'];?>' border="1" align="middle" /> </div>
<p align="center">Name : <?php echo $getuserprofile['first_name'];echo ' ';echo $getuserprofile['last_name'];?><br />
Status:
<?php $result =mysql_query("SELECT * FROM useronline WHERE(user='". $getuser['Username'] ."')");
while ($row = mysql_fetch_array($result))
{

$last_active = time() - $row['timestamp'];
}
echo ($last_active < 300) ? 'Online <img src="/images/useron.gif" width="12" height="11" />' : 'Offline <img src="/images/useroff.gif" width="12" height="11" />';

?>
<br />
Age :<?php $dob = $getuserprofile['dob'];

// GET TIMESTAMPS
$ts_dob = strtotime($dob);
$ts_now = time();

// DIFFERENCE IN YEARS
$years = date('Y', $ts_now) - date('Y', $ts_dob);

// IF BEFORE THE BIRTHDAY
$mdnow = date('m-d', $ts_now);
$mddob = date('m-d', $ts_dob);
if ($mdnow < $mddob) $years--;

// SHOW THE ANSWER
echo $years; ?> <br />
Gender : <?php echo $getuserprofile['gender']?><br />
Club : <?php echo $getuserprofile['club']?></p></td>
</tr>
</table>
<table width="90%" cellspacing="0" cellpadding="0">
<tr>
<td>&nbsp;</td>
</tr>
</table>
<table width="100%" cellspacing="0" cellpadding="0" class="loggedin">
<tr>
<td height="174"><p align="center"><strong>Contact </strong></p>
<div align="center">
<table cellspacing="0" cellpadding="0">
<tr>
<td height="30" align="center" valign="middle"><div align="center"><a href="index.php?page=sendmessage&usr=<?php echo $profilename;?>">Send message</a></div></td>
</tr>
<tr>
<td align="center" valign="middle"><div align="center"><img src="http://x.myspacecdn.com/modules/common/static/img/clear.gif" border="0" width="1" height="2" /></div></td>
</tr>
<tr>
<td height="30" align="center" valign="middle"><?php $result = mysql_query("SELECT * FROM `friends` WHERE `username` = '$profilename' AND `friendname` = '$username'") or die(mysql_error());
if ($username !== $profilename && mysql_num_rows($result) == 0) { ?><div align="center"><a href="http://www.runningprofiles.com/members/include/friendrequest.php?username=<?php echo $profilename ?>"
onclick="popUp(this.href,'console',200,500);return false;"
target="_blank">Add to frinds list</a></div><?php }?></td>
</tr>
<tr>
<td align="center" valign="middle"><div align="center"><img src="http://x.myspacecdn.com/modules/common/static/img/clear.gif" border="0" width="1" height="2" /></div></td>
</tr>
<tr>
<td height="30" align="center" valign="middle"><div align="center"></div></td>
</tr>
<tr>
<td><img src="http://x.myspacecdn.com/modules/common/static/img/clear.gif" border="0" width="1" height="2" /></td>
</tr>
<tr>
<td height="5" align="center" valign="top" nowrap="nowrap">&nbsp;</td>
</tr>
</table>
</div></td>
</tr>
</table>
<table width="90%" cellspacing="0" cellpadding="0">
<tr>
<td>&nbsp;</td>
</tr>
</table>
<table width="100%" cellspacing="0" cellpadding="0" class="loggedin">
<tr>
<td><div align="center">Friends</div><br/>
<?php include'include/myfriends.php';?></td>
</tr>
</table>
<table width="90%" cellspacing="0" cellpadding="0">
<tr>
<td>&nbsp;</td>
</tr>
</table>
<table width="100%" cellspacing="0" cellpadding="0" class="loggedin">
<tr>
<td align="center" valign="top"><div align="center">My Training Diary</div>

<?php include "diary/cal_show.php";?></td>
</tr>
</table> </td>
<td colspan="2" rowspan="2" align="center" valign="top"><table width="90%" height="108" cellpadding="3" cellspacing="5" >
<tr>
<td valign="top" bgcolor="#FFFFFF"><div align="center" class="style5">
<p class="style9"><u>Welcome to Admins profile</u></p>
<p class="style9">&nbsp;</p>
</div>
<ul id="countrytabs" class="shadetabs">
<li><a href="#" rel="#default" class="selected">About me</a></li>
<li><a href="include/profiletab/showgoals.php?username=<?php echo $profilename;?>" rel="countrycontainer">Goals</a></li>
<li><a href="include/profiletab/showidols.php?username=<?php echo $profilename;?>" rel="countrycontainer">Idols</a></li>
<li><a href="include/profiletab/showthanks.php?username=<?php echo $profilename;?>" rel="countrycontainer">Thanks to</a> </li>
</ul>

<div id="countrydivcontainer" style="border:1px solid gray; width:800px; margin-bottom: 1em; padding: 10px">
<?php echo $getuserprofile['about_me']?></div>
<script type="text/javascript">

var countries=new ddajaxtabs("countrytabs", "countrydivcontainer")
countries.setpersist(true)
countries.setselectedClassTarget("link") //"link" or "linkparent"
countries.init()

</script></td>
</tr>
</table>
<table width="90%" cellspacing="0" cellpadding="0">
<tr>
<td>&nbsp;</td>
</tr>
</table>
<table width="90%" height="568" cellpadding="0" cellspacing="0">
<tr>
<td height="566" align="center" valign="top"><table width="100%" cellspacing="0" cellpadding="0">
<tr>
<td width="44%" height="481" align="left" valign="top"><div align="center">
<?php
$result = mysql_query("SELECT * FROM pb where uid='".$getuser['ID']."' Order by distance ASC") or die(mysql_error());
$num2 = mysql_num_rows($result);

echo "<table class=\"profilepbs\" width=195 align=\"center\" cellpadding=\"0\" cellspacing=\"0\">
<tr><td width=105 ><div align=\"center\">Distance</div></td><td width=125><div align=\"center\">Pb</div></td></tr>
<tr>
<td height=\"1\" colspan=\"2\" bgcolor=\"#000000\"></td>
<td height=\"1\" colspan=\"2\" bgcolor=\"#000000\"></td>
</tr>
";
while ( $row = mysql_fetch_array($result) ) {
$text = $row["distance"];
$text2 = substr($text, 2,30);

echo "<tr><td bgcolor=\"#FFFFFF\"><center>" . $text2 . "</center></td><td bgcolor=\"#FFFFFF\"><center>" . $row["pb"] . "</center></td></tr>";
}
if($num2 < 1)
{echo "<tr><td bgcolor=\"#FFFFFF\" ><center> N/A
</center></td><td bgcolor=\"#FFFFFF\"><center> N/A
</center></td></tr>";}
echo "</table>
<p>";
?>

<br />
</div>
<table class="profilepbs" width="80%" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="1" align="center" valign="top">My Forum Posts </td>
</tr>
<tr>
<td height="1" colspan="2" bgcolor="#000000"></td>
</tr>
<tr>
<td height="49" align="center" valign="top" bgcolor="#FFFFFF" ><?php if($num < 1)
{echo 'User has yet to make a post.';}else{
while($row = mysql_fetch_assoc($postsresult)) { echo ' <a id="posts" href="http://www.runningprofiles.com/members/index.php?page=message&forum='.$row['forum'].'&id='.$row['postid'].'&pagenum=last">'.$row['title'].'</a> <br />' ;}
}?></td>
</tr>
</table>
<p>&nbsp;</p>
<table class="profilepbs" width="80%" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="97" align="center" valign="top" h="h">My Recent Training Log's
<table width="99%" cellspacing="0" cellpadding="0">
<tr>
<td height="1" bgcolor="#000000"> </td>
</tr>
<tr>
<td height="75" align="center" valign="top" bgcolor="#FFFFFF"><?php if($num1 < 1)
{echo 'User has yet post their training diary.';}else{
while($row1 = mysql_fetch_assoc($postsresult1)) {
$date = $row1['ev_dat'];
list($year, $month, $day) = split('[-.-]', $date);
?>
<?
echo ' <a id="posts" href="http://www.runningprofiles.com/members/diary/cal_show.php?m='.$month.'&y='.$year.'">'.$row1['ev_title'].'</a> <br />' ;

}
}


?>
</td>
</tr>
</table></td>
</tr>
</table>

<p>&nbsp;</p></td>
<td width="56%" valign="top" >
<?php include "shoutbox/index.php";

?></td>
</tr>

</table> </td>
</tr>
</table>

<p>&nbsp;</p>
<p>&nbsp;</p></td>
</tr>
<tr>
<td align="center" valign="top"> </td>
</tr>


</table>


why?



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum