Index.php File Loads Up To <Head> Only Made Changes To Dwt.php Template.

Raptor829 · October 8, 2012

This website that has been running for a few years now. I needed to add two menu items to the dwt template and ever since I made the changes the site loads up to the <head> tag.

Here is the dwt,php file

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<?php require('..Connections/qmbl.php');

$sqlstr = "select i_html from SiteInfo where i_type = 'NEWS_SCROLL'";

$rs_scroll = mysq1_query($sqlstr, $cid);

$scroll = mysql_result($rs_scroll,0,0);

$sqlstr = "select team_id, t_name from Team t, Settings s where t.t_season = s.cur_season order by t_name";

$rs_teams = mysql_query($sqlstr, $cid);

$count=0;

$templateTeams="";

while($row = mysql_fetch_assoc($rs_teams)){$templateTeams .= '<a href="team.php?t='.$row['team_id'].'">'.$row['t_name'].'</a><br />';

} //end while ?>

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<title>Untitled Document</title>

</head>

<body>

<tr>

<td>

<tr>

<td align="center" valign="middle"><a href="../field.php">Weather</a></td>

<td align="center" valign="middle"><a href="../sponsors.php">Sponsors</a></td>

<td align="center" valign="middle"><a href="../advertising.php">Advertising</a></td>

<td align="center" valign="middle"><a href="../contact.php">Contact</a></td>

<td width="65" align="right" valign="middle"><a href="../register.php">Register</a> </td>

<td width="45" align="left" valign="middle"><a href="../login.php"> Login</a> </td>

</tr>

</table>

</div>

<tr>

<td height="100%" align="center" valign="middle"><a href="../about.php">league</a></td>

<td height="100%" align="center" valign="middle"><a href="../standings.php">standings</a></td>

<td height="100%" align="center" valign="middle"><a href="../schedule.php">schedules</a></td>

<td height="100%" align="center" valign="middle"><a href="../scorecard.php">scorecard</a></td>

<td height="100%" align="center" valign="middle"><a href="../thedugout.php">the dugout</a></td>

<td height="100%" align="center" valign="middle"><a href="../products.php">products</a></td>

<td height="100%" align="center" valign="middle"><a href="../rules.php">rules</a></td>

<td height="100%" align="center" valign="middle"><a href="../wavier.php">wavier</a></td>

<td height="100%" align="center" valign="middle"><a href="../events.php">events</a></td>

</tr>

</table>

</div>

</div></td>

</tr>

<tr>

</td>

</tr>

<tr>

</tr>

<tr>

<tr>

<th scope="col"><a href="../thedugout.php">The Dugout</a></th>

<th scope="col">QMBL League</th>

<th scope="col">QMBL Links</th>

<th scope="col">QMBL Office</th>

</tr>

<tr>

</tr>

<tr>

<td><a href="../about.php">About</a><br />

<a href="../awards.php">Awareds</a><br />

<a href="../events.php">Special Events</a><br />

<a href="../products.php">Products</a><br />

<a href="../field.php">Weather</a></td>

<td><a href="../scorecard.php">Scorecard</a><br />

<a href="../standings.php">Standings</a><br />

<a href="../schedule.php">Schedules</a></td>

<td><a href="../contact.php">Contact</a><br />

<a href="../advertising.php">Advertise with us</a><br />

<a href="../sponsors.php">Sponsors</a><br />

</tr>

</table></td>

</tr>

</table>

</body>

</html>

It error checks but it wont load. Thanks in advance for you help.

Kohron J Burton

Kohron J Burton LLC

Pikachu2000 · October 8, 2012

When posting code, enclose it within the forum's

 . . .

BBCode tags.

Look very closely at this line and you should see something wrong with it: $rs_scroll = mysq1_query($sqlstr, $cid);. Is that one of the lines you edited?

Did you check your error logs for any clues?

Edited October 8, 2012 by Pikachu2000

Raptor829 · October 8, 2012

Actually no I didnt edit it but I did get a error pointing to it. I figured since I didnt change it I was ok. I still dont see whats the issue.

Raptor829 · October 8, 2012

The error said line 9. Here is 8 and 9.

$rs_scroll = mysq1_query($sqlstr, $cid);
$scroll = mysql_result($rs_scroll,0,0);

Pikachu2000 · October 8, 2012

What is the error message?

Are you sure you didn't edit that line at all? Perhaps an errant key stroke, that turned an l (ell) into a 1 (one) in mysq1_query?

Raptor829 · October 8, 2012

Oct 7 11:52:47 10.2.150.63: 47062:[error] [client 64.69.210.40] PHP Fatal error: Call to undefined function mysq1_query() in /home/cluster1/data/d/q/a1418840/html/index.php on line 9

I just got that from the log.

Raptor829 · October 8, 2012

I fixed and still

 . . .

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>[/code]

Thats all that loaded.

ManiacDan · October 8, 2012

So...as he said, you changed mysqli to mysql1. change it back.

Raptor829 · October 8, 2012

Changed it to what you suggested, so now its the following:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head>

<?php require('..Connections/qmbl.php');
$sqlstr = "select i_html from SiteInfo where i_type = 'NEWS_SCROLL'";
$rs_scroll = mysql_query($sqlstr, $cid);
$scroll = mysql_result($rs_scroll,0,0);

$sqlstr = "select team_id, t_name from Team t, Settings s where t.t_season = s.cur_season order by t_name";

$rs_teams = mysql_query($sqlstr, $cid);

$count=0;

$templateTeams="";

while($row = mysql_fetch_assoc($rs_teams)){$templateTeams .= '<a href="team.php?t='.$row['team_id'].'">'.$row['t_name'].'</a><br />';

} //end while ?>

<!-- TemplateBeginEditable name="head" -->

<!-- TemplateEndEditable --><meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<!-- TemplateBeginEditable name="doctitle" -->

<title>Untitled Document</title>

<!-- TemplateEndEditable -->

<link href="../html/qmbl2010.css" rel="stylesheet" type="text/css" />

</head>

<body>



<table id="page" width="960" border="0" align="center" >

 <tr>

   <td><img src="../html/images/1ptTrans.gif" width="1" height="200" alt="image"/></td>

   <td>

  <div id="header">

 <div id="topMenu">

   <table width="100%" border="0">

  <tr>

    <td align="center" valign="middle"><img src="../html/images/1ptTrans.gif" width="1" height="24" alt="image"/></td>

    <td align="center" valign="middle"><a href="../html/field.php">Weather</a></td>

    <td align="center" valign="middle"><a href="../html/sponsors.php">Sponsors</a></td>

    <td align="center" valign="middle"><a href="../html/advertising.php">Advertising</a></td>

    <td align="center" valign="middle"><a href="../html/contact.php">Contact</a></td>

    <td width="25" align="center" valign="middle">  </td>

    <td width="65" align="right" valign="middle"><a href="../html/register.php">Register</a> </td>

    <td align="center" valign="middle">|</td>

    <td width="45" align="left" valign="middle"><a href="../html/login.php"> Login</a> </td>

  </tr>

   </table>

 </div>

 <div id="mainMenu">

   <table width="100%" border="0">

  <tr>

    <td height="100%" align="center" valign="middle"><img src="../html/images/1ptTrans.gif" width="1" height="30" alt="image"/></td>

    <td height="100%" align="center" valign="middle"><a href="../html/about.php">league</a></td>

    <td height="100%" align="center" valign="middle"><a href="../html/standings.php">standings</a></td>

    <td height="100%" align="center" valign="middle"><a href="../html/schedule.php">schedules</a></td>

    <td height="100%" align="center" valign="middle"><a href="../html/scorecard.php">scorecard</a></td>

    <td height="100%" align="center" valign="middle"><a href="../html/thedugout.php">the dugout</a></td>

    <td height="100%" align="center" valign="middle"><a href="../html/news.php">news</a></td>

    <td height="100%" align="center" valign="middle"><a href="../html/products.php">products</a></td>
    <td height="100%" align="center" valign="middle"><a href="../html/rules.php">rules</a></td>
 <td height="100%" align="center" valign="middle"><a href="../html/wavier.php">wavier</a></td>	  
    <td height="100%" align="center" valign="middle"><a href="../html/events.php">events</a></td>

  </tr>

   </table>

 </div>

 <div id="homelink"><a href="../html/index.php"><img src="../html/images/1ptTrans.gif" width="184" height="177" border="0" alt="image" /></a></div>
  </div></td>

 </tr>
 <tr>
  <td colspan="2"><div id="scroll"><?php echo $scroll; ?></div>
   </td>
 </tr>
 <tr>

   <td><img src="../html/images/1ptTrans.gif" width="1" height="250" alt="image"/></td>

   <td class="body"><!-- TemplateBeginEditable name="body" --><!-- TemplateEndEditable --></td>

 </tr>

 <tr>

   <td><img src="../html/images/1ptTrans.gif" width="1" height="150" alt="image"/></td>

   <td valign="top" class="bottomMenu"><table width="100%" border="0">

  <tr>

    <th scope="col"><a href="../html/index.php">QMBL</a></th>

    <th scope="col"><a href="../html/thedugout.php">The Dugout</a></th>

    <th scope="col">QMBL League</th>

    <th scope="col">QMBL Links</th>

    <th scope="col">QMBL Office</th>

  </tr>

  <tr>

    <td> </td>

    <td> </td>

    <td> </td>

    <td> </td>

    <td> </td>

  </tr>

  <tr>

    <td><a href="../html/about.php">About</a><br />

	  <a href="../html/awards.php">Awareds</a><br />

	  <a href="../html/news.php">News</a><br />

	  <a href="../html/events.php">Special Events</a><br />

	  <a href="../html/products.php">Products</a><br />

	  <a href="../html/field.php">Weather</a></td>

    <td><?php echo $templateTeams; ?></td>

    <td><a href="../html/scorecard.php">Scorecard</a><br />

	  <a href="../html/standings.php">Standings</a><br />

	  <a href="../html/schedule.php">Schedules</a></td>

    <td><a href="http://www.mlb.com">MLB</a><br />

	  <a href="http://www.nfl.com">NFL</a><br />

	  <a href="http://www.nba.com">NBA</a><br />

	  <a href="http://www.nhl.com">NHL</a><br />

	  <a href="http://www.espn.com">ESPN</a><br />

	  <a href="../html/games.php">Fun</a></td>

    <td><a href="../html/contact.php">Contact</a><br />

	  <a href="../html/advertising.php">Advertise with us</a><br />

	  <a href="../html/sponsors.php">Sponsors</a><br />

	  <a href="../html/poll.php">Poll</a></td>

  </tr>

   </table></td>

 </tr>

</table>

</body>

</html>

Still no Change. Is there a tool or software I could use?

ManiacDan · October 8, 2012

Still no Change.

You're getting the error message about the undefined function even though your code no longer includes the bad code?

Raptor829 · October 8, 2012

I get the same results and same message I dont do SQL can some one take the scroll out so I can get get the page up. I still need the sql connection cause there are other sql element on this page and others. Its mon site been down for two days everyone is calling me going crazy.

ManiacDan · October 8, 2012

This isn't SQL. This is still PHP.

You fixed the code and still get the same error message? That's impossible. Are you sure the code isn't cached? Did you put the fixed code in the wrong place?

Jessica · October 8, 2012

Is there a tool or software I could use?

We have a board for hiring freelancers.

Raptor829 · October 8, 2012

I m trying to learn this but I checked the log and it said :

12:42:39 10.2.150.73: 47062:[error] [client 157.55.32.144] PHP Fatal error: Call to undefined function mysq1_query() in /home/cluster1/data/d/q/a1418840/html/player.php on line 9

So I figured since its a template file that I must have to update the entire site for changes to take effect. But I didnt want to give it a try and make a bigger problem.

ManiacDan · October 8, 2012

mysq1_query is not a function. There are two possible explanations:

1) Someone once had a mysq1_query function, which you have somehow deleted. Very unlikely

2) Someone, through malice or ignorance, made a site-wide change that switched mysql and mysq1. This is probably what happened.

Either way, find all instances of mysq1 and change them to mysql. That's the solution. There is no other.

Raptor829 · October 8, 2012

Also Whats a unblanced head tag error mean?

I get that when I am updating.

Jessica · October 8, 2012

It means your head is unbalanced, and you can usually fix it by doing a handstand, putting the computer on the floor upside down, and then very quickly drop your head onto the computer real hard.

ManiacDan · October 8, 2012

Where are you getting that? From what?

Raptor829 · October 8, 2012

LOL I changed the sq1 to sql in the template file and I am attempts to update the site but the files are saying unblanced head in dreamweaver as per the screen shot.

Heres my new template file.

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head>

<?php require('..Connections/qmbl.php');
$sqlstr = "select i_html from SiteInfo where i_type = 'NEWS_SCROLL'";
$rs_scroll = mysql_query($sqlstr, $cid);
$scroll = mysql_result($rs_scroll,0,0);

$sqlstr = "select team_id, t_name from Team t, Settings s where t.t_season = s.cur_season order by t_name";

$rs_teams = mysql_query($sqlstr, $cid);

$count=0;

$templateTeams="";

while($row = mysql_fetch_assoc($rs_teams)){$templateTeams .= '<a href="team.php?t='.$row['team_id'].'">'.$row['t_name'].'</a><br />';

} //end while ?>

<!-- TemplateBeginEditable name="head" -->

<!-- TemplateEndEditable --><meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<!-- TemplateBeginEditable name="doctitle" -->

<title>Untitled Document</title>

<!-- TemplateEndEditable -->

<link href="../html/qmbl2010.css" rel="stylesheet" type="text/css" />

</head>

<body>



<table id="page" width="960" border="0" align="center" >

 <tr>

   <td><img src="../html/images/1ptTrans.gif" width="1" height="200" alt="image"/></td>

   <td>

  <div id="header">

 <div id="topMenu">

   <table width="100%" border="0">

  <tr>

    <td align="center" valign="middle"><img src="../html/images/1ptTrans.gif" width="1" height="24" alt="image"/></td>

    <td align="center" valign="middle"><a href="../html/field.php">Weather</a></td>

    <td align="center" valign="middle"><a href="../html/sponsors.php">Sponsors</a></td>

    <td align="center" valign="middle"><a href="../html/advertising.php">Advertising</a></td>

    <td align="center" valign="middle"><a href="../html/contact.php">Contact</a></td>

    <td width="25" align="center" valign="middle">  </td>

    <td width="65" align="right" valign="middle"><a href="../html/register.php">Register</a> </td>

    <td align="center" valign="middle">|</td>

    <td width="45" align="left" valign="middle"><a href="../html/login.php"> Login</a> </td>

  </tr>

   </table>

 </div>

 <div id="mainMenu">

   <table width="100%" border="0">

  <tr>

    <td height="100%" align="center" valign="middle"><img src="../html/images/1ptTrans.gif" width="1" height="30" alt="image"/></td>

    <td height="100%" align="center" valign="middle"><a href="../html/about.php">league</a></td>

    <td height="100%" align="center" valign="middle"><a href="../html/standings.php">standings</a></td>

    <td height="100%" align="center" valign="middle"><a href="../html/schedule.php">schedules</a></td>

    <td height="100%" align="center" valign="middle"><a href="../html/scorecard.php">scorecard</a></td>

    <td height="100%" align="center" valign="middle"><a href="../html/thedugout.php">the dugout</a></td>

    <td height="100%" align="center" valign="middle"><a href="../html/news.php">news</a></td>

    <td height="100%" align="center" valign="middle"><a href="../html/products.php">products</a></td>
    <td height="100%" align="center" valign="middle"><a href="../html/rules.php">rules</a></td>
 <td height="100%" align="center" valign="middle"><a href="../html/wavier.php">wavier</a></td>	 
    <td height="100%" align="center" valign="middle"><a href="../html/events.php">events</a></td>

  </tr>

   </table>

 </div>

 <div id="homelink"><a href="../html/index.php.2"><img src="../html/images/1ptTrans.gif" width="184" height="177" border="0" alt="image" /></a></div>
  </div></td>

 </tr>
 <tr>
  <td colspan="2"><div id="scroll"><?php echo $scroll; ?></div>
   </td>
 </tr>
 <tr>

   <td><img src="../html/images/1ptTrans.gif" width="1" height="250" alt="image"/></td>

   <td class="body"><!-- TemplateBeginEditable name="body" --><!-- TemplateEndEditable --></td>

 </tr>

 <tr>

   <td><img src="../html/images/1ptTrans.gif" width="1" height="150" alt="image"/></td>

   <td valign="top" class="bottomMenu"><table width="100%" border="0">

  <tr>

    <th scope="col"><a href="../html/index.php.2">QMBL</a></th>

    <th scope="col"><a href="../html/thedugout.php">The Dugout</a></th>

    <th scope="col">QMBL League</th>

    <th scope="col">QMBL Links</th>

    <th scope="col">QMBL Office</th>

  </tr>

  <tr>

    <td> </td>

    <td> </td>

    <td> </td>

    <td> </td>

    <td> </td>

  </tr>

  <tr>

    <td><a href="../html/about.php">About</a><br />

	  <a href="../html/awards.php">Awareds</a><br />

	  <a href="../html/news.php">News</a><br />

	  <a href="../html/events.php">Special Events</a><br />

	  <a href="../html/products.php">Products</a><br />

	  <a href="../html/field.php">Weather</a></td>

    <td><?php echo $templateTeams; ?></td>

    <td><a href="../html/scorecard.php">Scorecard</a><br />

	  <a href="../html/standings.php">Standings</a><br />

	  <a href="../html/schedule.php">Schedules</a></td>

    <td><a href="http://www.mlb.com">MLB</a><br />

	  <a href="http://www.nfl.com">NFL</a><br />

	  <a href="http://www.nba.com">NBA</a><br />

	  <a href="http://www.nhl.com">NHL</a><br />

	  <a href="http://www.espn.com">ESPN</a><br />

	  <a href="../html/games.php">Fun</a></td>

    <td><a href="../html/contact.php">Contact</a><br />

	  <a href="../html/advertising.php">Advertise with us</a><br />

	  <a href="../html/sponsors.php">Sponsors</a><br />

	  <a href="../html/poll.php">Poll</a></td>

  </tr>

   </table></td>

 </tr>

</table>

</body>

</html>

Jessica · October 8, 2012

Ah, you need to uninstall Dreamweaver.

http://google.com/search?q=PHP+IDE

Raptor829 · October 8, 2012

Now check this one out. Here is the new error log.

/home/cluster1/data/d/q/a1418840/html/news.php on line 9, referer: http://www.google.com/url?sa=t&rct=j&q=jard%20jaroonarm&source=web&cd=3&ved=0CCgQFjAC&url=http%3A%2F%2Fqmbl.com%2Fnews.php&ei=5QxzUOfbNYSz0QHZrYGoAQ&usg=AFQjCNEZH_neprBArYO6QXIrE1oWJtnJzQ

Oct 8 13:29:43 10.2.150.163: 47062:[error] [client 24.90.90.140] PHP Fatal error: Call to undefined function mysq1_query() in /home/cluster1/data/d/q/a1418840/html/index.php on line 9

Oct 8 13:30:04 10.2.150.73: 47062:[error] [client 24.90.90.140] File does not exist: /home/cluster1/data/d/q/a1418840/html/favicon.ico

Oct 8 13:30:09 10.2.150.74: 47062:[error] [client 184.77.15.158] PHP Fatal error: Call to undefined function mysq1_query() in /home/cluster1/data/d/q/a1418840/html/index.php on line 9

Oct 8 13:30:11 10.2.150.162: 47062:[error] [client 24.193.68.246] PHP Fatal error: Call to undefined function mysq1_query() in /home/cluster1/data/d/q/a1418840/html/team.php on line 9, referer: http://leaguelineup.com/welcome.asp?url=queensangels

Oct 8 13:30:12 10.2.150.52: 47062:[error] [client 184.77.15.158] File does not exist: /home/cluster1/data/d/q/a1418840/html/favicon.ico

Oct 8 13:30:15 10.2.150.52: 47062:[error] [client 184.77.15.158] PHP Fatal error: Call to undefined function mysq1_query() in /home/cluster1/data/d/q/a1418840/html/index.php on line 9

Oct 8 13:31:00 10.2.150.62: 47062:[error] [client 24.90.90.140] File does not exist: /home/cluster1/data/d/q/a1418840/html/favicon.ico

Oct 8 13:31:59 10.2.150.62: 47062:[error] [client 66.249.71.218] File does not exist: /home/cluster1/data/d/q/a1418840/html/robots.txt

What does this mean?

ManiacDan · October 8, 2012

What does what mean? The exact same error you keep having and we keep telling you how to fix?

You don't have a favico or a robots file. Ignore those. Fix the PHP FATAL ERROR

Jessica · October 8, 2012

Maybe it needs to be mysq2_query. Isn't that the next version up?

Raptor829 · October 8, 2012

I did and here is what the new index.php file looks like after merging with the template file.

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml"><!-- InstanceBegin template="/Templates/qmbl2010.dwt.php" codeOutsideHTMLIsLocked="false" -->
<head>

<?php require('..Connections/qmbl.php');
$sqlstr = "select i_html from SiteInfo where i_type = 'NEWS_SCROLL'";
$rs_scroll = mysql_query($sqlstr, $cid);
$scroll = mysql_result($rs_scroll,0,0);

$sqlstr = "select team_id, t_name from Team t, Settings s where t.t_season = s.cur_season order by t_name";

$rs_teams = mysql_query($sqlstr, $cid);

$count=0;

$templateTeams="";

while($row = mysql_fetch_assoc($rs_teams)){$templateTeams .= '<a href="team.php?t='.$row['team_id'].'">'.$row['t_name'].'</a><br />';

} //end while ?>

<!-- InstanceBeginEditable name="head" -->

<!-- InstanceEndEditable --><meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<!-- InstanceBeginEditable name="doctitle" -->

<title>QMBL</title>

<style type="text/css">

#panels {

   position:relative;

   width:957px;

   height:391px;

   z-index:1;

   top: 20px;

}

#panel1 {

   position:relative;

   width:290px;

   height:391px;

   z-index:2;

   left: 22px;

   top: 0px;

   background-image: url(images/panel.jpg);

}

#panel2 {

   position:absolute;

   width:290px;

   height:391px;

   z-index:2;

   left: 333px;

   /*top: 530px;*/

   background-image: url(images/panel.jpg);

   top: 0px;

}

#panel3 {

   position:absolute;

   width:290px;

   height:391px;

   z-index:2;

   left: 644px;

   top: 0px;

   background-image: url(images/panel.jpg);

}



#apDiv1 {

   position:relative;

   width:284px;

   height:60px;

   z-index:1;

   left: 3px;

   top: 10px;

   font-size: 36px;

   font-family: "Palatino Linotype", "Book Antiqua", Palatino, serif;

   text-align: center;

   vertical-align: middle;

}



#apDiv2 {

   position:relative;

   width:957px;

   height:288px;

   z-index:1;

   left: 0px;

   top: 0px;

   color: #FFF;

}





#page tr .body table tr td #apDiv2 table tr td p u {

   font-size: 24px;

}

#page tr .body table tr td #apDiv2 table tr td p {

   font-size: 22px;

}



#standings {

   position:absolute;

   width:285px;

   height:285px;

   z-index:2;

   left: 1px;

   top: 73px;

   overflow: auto;

   color: #333;

}

#standings table tr td {

   color: #000;

   font-size: 11px;

}

#scorecard {

   position:absolute;

   width:285px;

   height:285px;

   z-index:2;

   left: 2px;

   top: 74px;

   overflow: auto;

   color: #333;

}

#scorecard table tr td {

   color: #000;

   font-size: 11px;

}

<?

   if(isset($s)){

       $season = $s;

   }else{

       $sqlstr = "select cur_season from Settings";

       $rs_curseason = mysql_query($sqlstr,$cid);

       $season = mysql_result($rs_curseason,0,0);

   }



   //get colors

   $sqlstr = "select * from SiteInfo where i_type like '%_".$season."_COLOR'";

   $rs_colors = mysql_query($sqlstr, $cid);

   if($rs_colors && mysql_num_rows($rs_colors) > 0){

       while($row = mysql_fetch_assoc($rs_colors)){

           $colors[substr($row['i_type'],0,strpos($row['i_type'],"_"))] = $row['i_html'];

       }

   }else{

       $colors = Array();

   }

   foreach($colors as $team => $color){

       print "#scorecard .c".$team." {\n\tcolor: ".$color.";\n}\n";

   }

?>

</style>



<!-- InstanceEndEditable -->

<link href="qmbl2010.css" rel="stylesheet" type="text/css" />

</head>

<body>



<table id="page" width="960" border="0" align="center" >

 <tr>

   <td><img src="images/1ptTrans.gif" width="1" height="200" alt="image"/></td>

   <td>

  <div id="header">

 <div id="topMenu">

   <table width="100%" border="0">

  <tr>

    <td align="center" valign="middle"><img src="images/1ptTrans.gif" width="1" height="24" alt="image"/></td>

    <td align="center" valign="middle"><a href="field.php">Weather</a></td>

    <td align="center" valign="middle"><a href="sponsors.php">Sponsors</a></td>

    <td align="center" valign="middle"><a href="advertising.php">Advertising</a></td>

    <td align="center" valign="middle"><a href="contact.php">Contact</a></td>

    <td width="25" align="center" valign="middle">  </td>

    <td width="65" align="right" valign="middle"><a href="register.php">Register</a> </td>

    <td align="center" valign="middle">|</td>

    <td width="45" align="left" valign="middle"><a href="login.php"> Login</a> </td>

  </tr>

   </table>

 </div>

 <div id="mainMenu">

   <table width="100%" border="0">

  <tr>

    <td height="100%" align="center" valign="middle"><img src="images/1ptTrans.gif" width="1" height="30" alt="image"/></td>

    <td height="100%" align="center" valign="middle"><a href="about.php">league</a></td>

    <td height="100%" align="center" valign="middle"><a href="standings.php">standings</a></td>

    <td height="100%" align="center" valign="middle"><a href="schedule.php">schedules</a></td>

    <td height="100%" align="center" valign="middle"><a href="scorecard.php">scorecard</a></td>

    <td height="100%" align="center" valign="middle"><a href="thedugout.php">the dugout</a></td>

    <td height="100%" align="center" valign="middle"><a href="news.php">news</a></td>

    <td height="100%" align="center" valign="middle"><a href="products.php">products</a></td>
    <td height="100%" align="center" valign="middle"><a href="rules.php">rules</a></td>
 <td height="100%" align="center" valign="middle"><a href="wavier.php">wavier</a></td>	  
    <td height="100%" align="center" valign="middle"><a href="events.php">events</a></td>

  </tr>

   </table>

 </div>

 <div id="homelink"><a href="index.php.2"><img src="images/1ptTrans.gif" width="184" height="177" border="0" alt="image" /></a></div>
  </div></td>

 </tr>
 <tr>
  <td colspan="2"><div id="scroll"><?php echo $scroll; ?></div>
   </td>
 </tr>
 <tr>

   <td><img src="images/1ptTrans.gif" width="1" height="250" alt="image"/></td>

   <td class="body"><!-- InstanceBeginEditable name="body" --><div id="index"><table><tr valign="top"><td width="1"><img src="images/1ptTrans.gif" width="1" height="733" /></td><td><div id="apDiv2"><table width="90%" border="0" align="center" cellpadding="10">

 <tr>

   <th id="index" scope="row"><img src="ktmllite/images/uploads/teams/Fall_Championship.jpg" width="521" height="268" /></th>

   <td align="center" valign="middle"><p><u>Fall 2010 Champions</u></p>

  <p>Bayside Bulldogs</p></td>

 </tr>

</table>

    </div>

    <div id="panels">

		  <div id="panel1">

    <div id="apDiv1"> News</div><br /><font color="black"> Coming Soon...</font>

  </div>

  <div id="panel2"><div id="apDiv1"> Standings</div>

    <div id="standings"><?php include('includes/functions.php');

$sortedTeams=getStandings();

       $seasonStr = "select s_name from Season, Settings where season_id = cur_season";

       $rs_season = mysql_query($seasonStr, $cid) or die(mysql_error());

       $sname = mysql_result($rs_season,0,0);



?>

<table cellspacing="1" cellpadding="0" width="95%" border="0" align="center">

     <tr><td colspan="5" align="center" style="background-color:#000000; color:#FFFFFF; font-size:14px; font-weight:bold;"><strong><?= $sname ?></strong></td></tr>

<?php

$lastDivision = "";

foreach ($sortedTeams as $key => $value){

   if ($sortedTeams[$key]['t_division'] != $lastDivision){

       if ($lastDivision != ""){

?>

<?php

       } //end if $lastDivision != ""

       $lastDivision = $sortedTeams[$key]['t_division'];

       $leadWins = $sortedTeams[$key]['wins'];

       $leadLoss = $sortedTeams[$key]['loss'];

?>

   <tr align="center">

  <td colspan="5" align="left"><strong><?= $sortedTeams[$key]['d_name'] ?></strong></td>

   </tr>

   <tr align="center">

  <td width="7"> </td>

  <td align="left"><strong>Team

    Name</strong></td>

  <td align="right"><strong>Wins</strong></td>

  <td align="right"><strong>Losses</strong></td>

  <td align="right"><strong>Games<br>

    Behind</strong></td>

   </tr>

<?php

   } // end if new division

   $sortedTeams[$key]['gamesback'] = (($leadWins - $sortedTeams[$key]['wins'])+ ($sortedTeams[$key]['loss'] - $leadLoss)) / 2;

   if( $sortedTeams[$key]['homewins'] == "" ){ $sortedTeams[$key]['homewins']=0;}

   if( $sortedTeams[$key]['homeloss'] == "" ){ $sortedTeams[$key]['homeloss']=0;}

   if( $sortedTeams[$key]['awaywins'] == "" ){ $sortedTeams[$key]['awaywins']=0;}

   if( $sortedTeams[$key]['awayloss'] == "" ){ $sortedTeams[$key]['awayloss']=0;}

?>

   <tr>

  <td> </td>

  <td align="left"><?= $sortedTeams[$key]['t_name'] ?></td>

  <td align="right"><?= $sortedTeams[$key]['wins'] ?></td>

  <td align="right"><?= $sortedTeams[$key]['loss'] ?></td>

  <td align="right"><? if($sortedTeams[$key]['gamesback'] == 0){ print("--"); }else{ print($sortedTeams[$key]['gamesback']);} ?></td>

   </tr>

<?php

}//end loop for teams

?>

</table></div>



  </div>

  <div id="panel3">

    <div id="apDiv1">Scorecard</div>

  <div id="scorecard">

 <?

   $SQL = "SELECT `game_id` , `g_home_team` , `g_home_score` , `g_away_team` , `g_away_score` , `g_location` , `g_memo`, date_format(`g_date`,'%m-%d-%Y') as g_date,time_format(`g_time`,'%l:%i %p') as g_time, `g_status` , `hl_home`, `hl_away`

           FROM `Game` left join `Highlight`

           ON game_id=hl_game

           WHERE game_id > '0' and g_season = '$season' and g_date <= NOW() ORDER BY `g_date` desc, `g_time` ASC";

   $retid = mysql_query($SQL, $cid);

   if (!$retid) { echo( mysql_error()); }

   $games=true;

   if (mysql_num_rows($retid) < 1){

       print '<div align="center><font size="5" face="Verdana, Arial, Helvetica, sans-serif">';

       print "No Games have been scheduled for this season yet.";

       print "</font></div>";        

       $games=false;

   }

   if($games){    

?>        <table border="1" align="center" width="90%">

   <?php

   $datecount=0;

   while ( $row = mysql_fetch_array($retid, MYSQL_BOTH) )

   {

       $ht = $row["g_home_team"];

       $at = $row["g_away_team"];

       $hs = $row["g_home_score"];

       $as = $row["g_away_score"];

       $locate = $row["g_location"];

       $highlight = $row["g_memo"];

       $date = $row["g_date"];

       $time = $row["g_time"];

       $status = $row["g_status"];

       $hl_home = addcslashes(str_replace("\r\n","<BR>",$row["hl_home"]),"'");

       $hl_away = addcslashes(str_replace("\r\n","<BR>",$row["hl_away"]),"'");



       $atquery = "SELECT `t_name` FROM `Team` WHERE `team_id` = $at and t_season = $season";

       $htquery = "SELECT `t_name` FROM `Team` WHERE `team_id` =  $ht and t_season = $season";

       $locquery = "SELECT `location_id`, `l_name` FROM    `Location` WHERE `location_id` = $locate" ;



       $hometeam = mysql_query($htquery,$cid);

           $htrow = mysql_fetch_array($hometeam);

       $awayteam = mysql_query($atquery,$cid);

           $atrow = mysql_fetch_array($awayteam);

       if($locate != ""){

           $field = mysql_query($locquery,$cid);

               $locrow = mysql_fetch_array($field);

       }else{

           $locrow = "";

       }

       if ($date != $lastdate){

           if($datecount>1) break;

           if($count % 2 == 0){

           ?>

               <tr>

                  <th align="center" bgcolor="#000000"><font color="#FFFFFF"><a name="<?= $date ?>" id="<?= $date ?>"><?= $date ?></a></font></th>

               </tr>

           <?

           }else{

           ?>

               <tr>

                  <th align="center" bgcolor="#000000"><font color="#FFFFFF"><a name="<?= $date ?>" id="<?= $date ?>"><?= $date ?></a></font></th>

               </tr>

           <?

           }

           $count = 0;

           $datecount++;

       } //end if new date



       if($count % 2 == 0){

       ?>

   <tr>

  	   <td>

    <table width="100%" border="0">

	  <tr>

	    <td align="left" bgcolor="#CCCCCC" class="<?= isset($colors[$at]) ? "c".$at : "defaultColor" ?>"><strong><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><?= $as > $hs ? "<i>" : "" ?><?php echo ($atrow[0]) ?><?= $as > $hs ? "</i>" : "" ?></font></strong></td>

	    <td width="20%" align="center" bgcolor="#CCCCCC"><font color="#000000" size="1" face="Verdana, Arial, Helvetica, sans-serif"><?= $as > $hs ? "<i><span class=\"box\">" : "" ?><strong><?php echo ($as) ?><?= $as > $hs ? "</span></i>" : "" ?></strong></font></td>

           <td width="22" align="center" valign="middle" bgcolor="#CCCCCC"><?= empty($hl_away) ? " " : '<a href="#" onmouseover="doTooltip(event,\''.$hl_away.'\')" onmouseout="hideTip()"><img src="images/bulb.gif" width="19" height="20" border="0"></a>' ?></td>

	  </tr>

	  <tr>

	    <td align="left" bgcolor="#CCCCCC" class="<?= isset($colors[$ht]) ? "c".$ht : "defaultColor" ?>" style="text-decoration:underline"><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><strong><?= $hs > $as ? "<i>" : "" ?><?php echo ($htrow[0]) ?><?= $hs > $as ? "</i>" : "" ?></strong></font></td>

	    <td width="20%" align="center" bgcolor="#CCCCCC"><font color="#000000" size="1" face="Verdana, Arial, Helvetica, sans-serif"><strong><?= $hs > $as ? "<i><span class=\"box\">" : "" ?><?php echo ($hs) ?><?= $hs > $as ? "</span></i>" : "" ?></strong></font></td>

           <td width="22" align="center" valign="middle" bgcolor="#CCCCCC"><?= empty($hl_home) ? " " : '<a href="#" onmouseover="doTooltip(event,\''.$hl_home.'\')" onmouseout="hideTip()"><img src="images/bulb.gif" width="19" height="20" border="0"></a>' ?></td>

	  </tr>

         <tr>

        	 <td bgcolor="#CCCCCC"><font color="#009900" size="1" face="Verdana, Arial, Helvetica, sans-serif"><strong>Location: <?php echo ($locrow[1]) ?></strong></font></td>

      	 <td width="20%" align="right" bgcolor="#CCCCCC"><strong><font color="#000000" size="1" face="Verdana, Arial, Helvetica, sans-serif"> <? if($status == ""){print($time);}else{print($status);} ?></font></strong></td>

           <td width="22" align="center" valign="middle" bgcolor="#CCCCCC"rks="rks"> </td>

         </tr>

         <tr>

      	 <td colspan="2"><strong><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><?php echo ($highlight)?> </font></strong></td>

         </tr>

    </table>

   <?php

       }else{

   ?>

    <table width="100%" border="0">

	  <tr>

	    <td align="left" bgcolor="#CCCCCC" class="<?= isset($colors[$at]) ? "c".$at : "defaultColor" ?>"><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><strong><?= $as > $hs ? "<i>" : "" ?><?php echo ($atrow[0]) ?><?= $as > $hs ? "</i>" : "" ?></strong></font></td>

	    <td width="20%" align="center" bgcolor="#CCCCCC"><font color="#000000" size="1" face="Verdana, Arial, Helvetica, sans-serif"><strong><?= $as > $hs ? "<i><span class=\"box\">" : "" ?><?php echo ($as) ?><?= $as > $hs ? "</span></i>" : "" ?></strong></font></td>

           <td width="22" align="center" valign="middle" bgcolor="#CCCCCC"><?= empty($hl_away) ? " " : '<a href="#" onmouseover="doTooltip(event,\''.$hl_away.'\')" onmouseout="hideTip()"><img src="images/bulb.gif" width="19" height="20" border="0"></a>' ?></td>

	  </tr>

	  <tr>

	    <td align="left" bgcolor="#CCCCCC" class="<?= isset($colors[$ht]) ? "c".$ht : "defaultColor" ?>" style="text-decoration:underline"><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><strong><?= $hs > $as ? "<i>" : "" ?><?php echo ($htrow[0]) ?><?= $hs > $as ? "</i>" : "" ?></strong></font></td>

	    <td width="20%" align="center" bgcolor="#CCCCCC"><font color="#000000" size="1" face="Verdana, Arial, Helvetica, sans-serif"><strong><?= $hs > $as ? "<i><span class=\"box\">" : "" ?><?php echo ($hs) ?><?= $hs > $as ? "</span></i>" : "" ?></strong></font></td>

           <td width="22" align="center" valign="middle" bgcolor="#CCCCCC"><?= empty($hl_home) ? " " : '<a href="#" onmouseover="doTooltip(event,\''.$hl_home.'\')" onmouseout="hideTip()"><img src="images/bulb.gif" width="19" height="20" border="0"></a>' ?></td>

	  </tr>

         <tr>

        	 <td bgcolor="#CCCCCC"><font color="#009900" size="1" face="Verdana, Arial, Helvetica, sans-serif"><strong>Location: <?php echo ($locrow[1]) ?></strong></font></td>

      	 <td width="20%" align="right" bgcolor="#CCCCCC"><strong><font color="#000000" size="1" face="Verdana, Arial, Helvetica, sans-serif"> <? if($status == ""){print($time);}else{print($status);} ?></font></strong></td>

           <td width="22" align="center" valign="middle" bgcolor="#CCCCCC"> </td>

         </tr>

         <tr>

      	 <td colspan="2"><strong><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><?php echo ($highlight)?> </font></strong></td>

         </tr>

    </table>

   </td>

   </tr>

   <?

       }

       $count++;

       $lastdate=$date;

   }

?>

</table>

<?php } ?>

       </div>

  </div>

  </div>

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



  <script src="includes/dw_event.js" type="text/javascript"></script>

<script src="includes/dw_viewport.js" type="text/javascript"></script>

<script src="includes/dw_tooltip.js" type="text/javascript"></script>

     <!-- InstanceEndEditable --></td>

 </tr>

 <tr>

   <td><img src="images/1ptTrans.gif" width="1" height="150" alt="image"/></td>

   <td valign="top" class="bottomMenu"><table width="100%" border="0">

  <tr>

    <th scope="col"><a href="index.php.2">QMBL</a></th>

    <th scope="col"><a href="thedugout.php">The Dugout</a></th>

    <th scope="col">QMBL League</th>

    <th scope="col">QMBL Links</th>

    <th scope="col">QMBL Office</th>

  </tr>

  <tr>

    <td> </td>

    <td> </td>

    <td> </td>

    <td> </td>

    <td> </td>

  </tr>

  <tr>

    <td><a href="about.php">About</a><br />

	  <a href="awards.php">Awareds</a><br />

	  <a href="news.php">News</a><br />

	  <a href="events.php">Special Events</a><br />

	  <a href="products.php">Products</a><br />

	  <a href="field.php">Weather</a></td>

    <td><?php echo $templateTeams; ?></td>

    <td><a href="scorecard.php">Scorecard</a><br />

	  <a href="standings.php">Standings</a><br />

	  <a href="schedule.php">Schedules</a></td>

    <td><a href="http://www.mlb.com">MLB</a><br />

	  <a href="http://www.nfl.com">NFL</a><br />

	  <a href="http://www.nba.com">NBA</a><br />

	  <a href="http://www.nhl.com">NHL</a><br />

	  <a href="http://www.espn.com">ESPN</a><br />

	  <a href="games.php">Fun</a></td>

    <td><a href="contact.php">Contact</a><br />

	  <a href="advertising.php">Advertise with us</a><br />

	  <a href="sponsors.php">Sponsors</a><br />

	  <a href="poll.php">Poll</a></td>

  </tr>

   </table></td>

 </tr>

</table>

</body>

<!-- InstanceEnd --></html>

Still no load

and hear is the new error code with time stamps.\

8 14:56:02 10.2.150.73: 47062:[error] [client 24.47.160.229] PHP Warning:  require(..Connections/qmbl.php) [<a href='function.require'>function.require</a>]: failed to open stream: No such file or directory in /home/cluster1/data/d/q/a1418840/html/index.php on line 6
Oct  8 14:56:02 10.2.150.73: 47062:[error] [client 24.47.160.229] PHP Fatal error:  require() [<a href='function.require'>function.require</a>]: Failed opening required '..Connections/qmbl.php' (include_path='.:/usr/share/pear') in /home/cluster1/data/d/q/a1418840/html/index.php on line 6
Oct  8 14:56:16 10.2.150.53: 47062:[error] [client 24.47.160.229] PHP Warning:  require(..Connections/qmbl.php) [<a href='function.require'>function.require</a>]: failed to open stream: No such file or directory in /home/cluster1/data/d/q/a1418840/html/index.php on line 6
Oct  8 14:56:16 10.2.150.53: 47062:[error] [client 24.47.160.229] PHP Fatal error:  require() [<a href='function.require'>function.require</a>]: Failed opening required '..Connections/qmbl.php' (include_path='.:/usr/share/pear') in /home/cluster1/data/d/q/a1418840/html/index.php on line 6
Oct  8 14:56:22 10.2.150.63: 47062:[error] [client 24.47.160.229] PHP Warning:  require(..Connections/qmbl.php) [<a href='function.require'>function.require</a>]: failed to open stream: No such file or directory in /home/cluster1/data/d/q/a1418840/html/schedule.php on line 6
Oct  8 14:56:22 10.2.150.63: 47062:[error] [client 24.47.160.229] PHP Fatal error:  require() [<a href='function.require'>function.require</a>]: Failed opening required '..Connections/qmbl.php' (include_path='.:/usr/share/pear') in /home/cluster1/data/d/q/a1418840/html/schedule.php on line 6

Now I checked and the qmbl.php is there so is this something of a bug? My head is spinning and I just need a fresh pair of eyes.

ManiacDan · October 8, 2012

Now I checked and the qmbl.php is there so is this something of a bug?

everything we've discussed so far has been bugs.

Your include statement is missing a slash. ../Connections/qmbl.php

I can't tell if that's it though, this is WAY too much code and you're using a code generation product we've said is known to be bad.

Sign In

Index.php File Loads Up To <Head> Only Made Changes To Dwt.php Template.

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Join the conversation

Important Information