Use of undefined constant

[runnerjp]

hey guys... something wired has happend... my forum was working fine untill i added this code to it

 

<?php $forum="Select * from forum_lock";
$forum2 = mysql_query($forum) or die("Could not connect to forum");

while($forum3=mysql_fetch_array($forum2))

{

      $forum_lock=$forum3['locked'];
  
if($forum_lock == 1){ echo 'locked'; }  else {	?>

 

and now its shows Use of undefined constant on all the areas im calling my arrays such as title,auther ect

 

here is full code

 

<link rel="stylesheet" type="text/css" href="http://www.runningprofiles.com/css/login.css">
<link rel="stylesheet" type="text/css" href="http://www.runningprofiles.com/members/include/style.css">


<?php 
require_once '../settings.php';
include "connect.php"; //mysql db connection here
error_reporting(E_ALL); 

$id = $_SESSION['user_id'];  
$puser = get_username($id);

$timestamp = time();
$timeout = $timestamp - 180;
$username= get_username($_SESSION['user_id']);
function selfURL() { 
$s = empty($_SERVER["HTTPS"]) ? '' : ($_SERVER["HTTPS"] == "on") ? "s" : "";
$protocol = strleft(strtolower($_SERVER["SERVER_PROTOCOL"]), "/").$s; 
$port = ($_SERVER["SERVER_PORT"] == "80") ? "" : (":".$_SERVER["SERVER_PORT"]); 
return $protocol."://".$_SERVER['SERVER_NAME'].$port.$_SERVER['REQUEST_URI']; } 
function strleft($s1, $s2) { return substr($s1, 0, strpos($s1, $s2)); }
$filename = (selfURL());
//Insert User
$insert = mysql_query("REPLACE INTO `useronline` SET `timestamp`='$timestamp', `ip`='".$_SERVER['REMOTE_ADDR']."', `file`='$filename',`user`='$username',`user_id`='".$_SESSION['user_id']."'") 
or die(mysql_error()); 

?>
<?php 
$forum="Select * from forum_lock";
$forum2 = mysql_query($forum) or die("Could not connect to forum");

while($forum3=mysql_fetch_array($forum2))

{

      $forum_lock=$forum3['locked'];
  
if($forum_lock == 1){ echo 'locked'; }  else {			 
//This checks to see if there is a page number. If not, it will set it to page 1
if (!(isset($pagenum)))
{
$pagenum = 1;
}

//Here we count the number of results
//Edit $data to be your query
$forum=$_GET['forum']; 
$data = mysql_query("Select * from forumtutorial_posts where parentid='0' AND forum = '$forum' ORDER BY important, lastrepliedto") or die(mysql_error());
$rows = mysql_num_rows($data);

//This is the number of results displayed per page
$page_rows = 25;

//This tells us the page number of our last page
$last = ceil($rows/$page_rows);

//this makes sure the page number isn't below one, or more than our maximum pages
if ($pagenum < 1)
{
$pagenum = 1;
}
elseif ($pagenum > $last)
{
$pagenum = $last;
}

//This sets the range to display in our query
$max = 'limit ' .($pagenum - 1) * $page_rows .',' .$page_rows;
//This is your query again, the same one... the only difference is we add $max into it

{
?>
<p><A href='index.php?page=mainforums'><img src="http://www.runningprofiles.com/images/homeforum.gif" alt="home" border="0"  /></a><A href='index.php?page=post&forum=<?php echo $forum;  ?>'><img src="http://www.runningprofiles.com/images/new_post.gif" border="0"  /></a></p>
<p>users viewing forum = <?php if ($result = mysql_query("SELECT * FROM useronline")) {
  if (mysql_num_rows($result)) {
    while ($row = mysql_fetch_array($result)) {
      $last_active = time() - $row['timestamp'];				
      if ($last_active < 3600) {
        $onlineuser[] = $row['user'];
      }
    }
  }
}

if (isset($onlineuser)) {
  if (count($onlineuser) == 1) {
    echo $onlineuser[0];
  } else {
    for ($i=0;$i<count($onlineuser);$i++) {
      if ($i == count($onlineuser)-1) {
        echo " and " . $onlineuser[$i];
      } else {
        echo "  " . $onlineuser[$i];
      }
    }
  }
}

?>

</p>
<table width="99%" class='forum'>
  <tr>
    <td><table class='maintable'>

<tr class='headline'><td> </td>
  <td> </td>
  <td>Topic</td>
  <td width=15%>Topic Starter</td>
<td width="5%">Replies</td><td width="25%">Last replied time</td></tr>
<?php

$getthreads="Select * from forumtutorial_posts where parentid='0' and forum = '$forum' ORDER BY important ASC, lastrepliedto DESC $max";


$getthreads2=mysql_query($getthreads) or die("Could not get threads");

while($getthreads3=mysql_fetch_array($getthreads2))

{

  $getthreads3[title]=strip_tags($getthreads3[title]);

  $getthreads3[author]=strip_tags($getthreads3[author]);
  $getthreads3[important]=strip_tags($getthreads3[important]);
  }
      $important=$getthreads3['important'];
  
?>
<tr <?php if($important==1) {
    $class = "mainrow1";
} else {
    $class = "mainrow";
}  ?> class="<? echo $class?>"><td width="6%" height="39" align="center" valign="middle"><? if($getthreads3[author] == $puser){ ?> <img src="http://www.runningprofiles.com/images/new_posts_icon.gif" alt="My" /> <? }   else { ?> <img src="http://www.runningprofiles.com/images/last_post.gif" alt="My" /> <?} ?>
   <td width="4%" align="center" valign="middle"><?php  if($getthreads3['forumlock'] == 1){echo' <img src="http://www.runningprofiles.com/images/quick_lock.gif" alt="locked"/>';}  if($getthreads3['important'] == 1){echo'<img src="http://www.runningprofiles.com/images/sticky.gif" alt="sticky"/>';} ?></td>
<td width="45%" valign="top"><div align="left"><a href='index.php?page=message&forum=<?php echo $forum; ?>&id=<?php echo $getthreads3[postid] ?>'><?php echo $getthreads3[title] ?></a>  
  
   <?php if($id == 1){ include 'editforum.php';}; ?>
      </div></td>
  <td align="left" valign="middle"><a href='/members/<?php echo $getthreads3[author]; ?>'><?php echo $getthreads3[author] ?></a></td>
  <td align="center" valign="top"><?php echo $getthreads3[numreplies]?></td>
  <td valign="top"><?php $dbtime=$getthreads3['lastrepliedto']; $time = date("F j Y, g:i a", $dbtime); echo $time;?><br>
  Last post by <b><?php echo $getthreads3[lastposter]?> </b></td></tr>
<?
}
?>
</table></td>
  </tr>
</table>
<br>


</a>
<p>
  <?php
echo "<br>";

echo "<p>";


// Start links for pages
$maxpage = $totalpages == 0 ? 1 : $totalpages; // add this line
echo "<p align=center>Page $pagenum of $maxpage <br /> "; // change this

// Sets link for previous 25 and return to page 1
    if($pagenum != 1){
        $pageprev = ($pagenum - 1);
         echo "<a href=\"".$_SERVER['PHP_SELF']."?page=message&id=$id&pagenum=1\"><<</a>  ";
         echo "<a href=\"".$_SERVER['PHP_SELF']."?page=message&id=$id&pagenum=$pageprev\">PREV </a> ";
    }else{
        echo "";
    }

// Loop thru all the pages and echo out the links
    for($i = 1; $i <= $numofpages; $i++){
        if($i == $pagenum){
            echo "[".$i."] ";
        }else{
            echo "<a href=\"".$_SERVER['PHP_SELF']."?page=message&id=$id&pagenum=$i\">$i</a> ";
        }
    }

// Check for straglers after the limit blocks
    if(($rows % $page_rows) != 0){
        if($i == $pagenum){
            echo "[".$i."] ";
        }else{
            echo "<a href=\"".$_SERVER['PHP_SELF']."?page=message&id=$id&pagenum=$i\">$i</a> ";
        }
    }
// Print out the Next 25 and Goto Last page links
    if(($rows - ($page_rows * $pagenum)) > 0){
        $pagenext = $pagenum++;
          echo "<a href=\"".$_SERVER['PHP_SELF']."?page=message&id=$id&pagenum=$pagenext\">NEXT </a>  ";
          echo "<a href=\"".$_SERVER['PHP_SELF']."?page=message&id=$id&pagenum=$totalpages\">>></a>  ";
          }
?>
</p>
<p></p>
<table width="14%" border="0" align="left" cellpadding="0" cellspacing="0">
  <tr>
    <td height="33" colspan="2" align="center"><strong>forum key</strong></td>
  </tr>
  <tr>
    <td width="22%" align="center"><img src="http://www.runningprofiles.com/images/quick_lock.gif" alt="locked"/></td>
    <td width="78%">Locked Topic</td>
  </tr>
  <tr>
    <td align="center" valign="middle"><img src="http://www.runningprofiles.com/images/sticky.gif" alt="sticky"/></td>
    <td>Sticky Topic</td>
  </tr>
  <tr>
    <td> </td>
    <td> </td>
  </tr>
</table>
<?php }}?>

[ag3nt42]

i duno if this is the problem or not but this code is not right

 

wrong:

<?php if($id == 1){ include 'editforum.php';}; ?>

 

right:

<?php if($id == 1){ include 'editforum.php';} ?>

 

i wana say most likely you have a syntax error.. but i've seen so many different ways of writing this crap.. I don't feel comfortable spotting them out. I can spot my own code sytax problems but like I said I don't wana tell you thats wat it is then have someone else come and tell you its fine..

 

so i'd just go back through and make sure everything has the correct semicolon endings and all your variables arn't quoted and have the $ infront of them.

 

[runnerjp]

hey thanks little typo there.. but it wasnot the answer to my current problem

[trq]

$getthreads3[title] should be $getthreads3['title'] etc etc.

[runnerjp]

i turned them all to $getthreads3['title'] and i shows nothing... blank info... and he date part is set to January 1 1970, 1:00 am

 

 

Any ideas?

[runnerjp]

basicly all i want to do is show my forum if the forum is not locked and if its set to 1 just show a forum locked message...

 

like on here when people are updating areas!

 

the thing is it was all working great untill i added these bits of code

 

 <?php $forum="Select * from forum_lock";
$forum2 = mysql_query($forum) or die("Could not connect to forum");

while($forum3=mysql_fetch_array($forum2))

{

$forum_lock=$forum3['locked'];

if($forum_lock == 1){ echo 'locked'; } else { ?>

and obviusly closing it at the end... i just cant understand how im supposed to solve this

[runnerjp]

bump...help meee lol

[trq]

That code looks like it should work, can you do a print_r() on the $forum3 array for us?

[runnerjp]

humm where about should i stick print_r()  not to sure lol

[trq]

Within the while().

[runnerjp]

ok i did it and got 0

[trq]

Can we actually see the output please?