setpubstatus.php

//start

<html>
<head>
<title>
   Pubstatus hack by quodlibet
</title>
</head>
<body>

<?
if (! $threadid)
{
   echo "You must supply a threadid";
   die;
}

if (! $pubstatus)
{
   if ($pubstatus != 0)
   {
      echo "You must supply a pubstatus";
      die;
   }
}

include once("./admin/config.php");

$db = @mysql connect("$servername", "$dbusername", "$dbpassword") or die("here
we die at connection");

@mysql select db("$dbname",$db) or die("pubstatus hack error 02 :Error finding
config file or something else");

$sql = "update thread set pubstatus = $pubstatus where threadid=$threadid";

mysql query($sql, $db) || die ("pubstatus hack error 03 :error updating status,
does the pubstatus field exist in the thread table?");

echo "<br><br><br><br><br><center>";
echo "<a href=$return?s=$s&postid=$threadid>Go back to where you came from</a>";

echo "</center>";
?>
<script>
window.location ="<? echo "$return?s=$s&postid=$threadid" ?>";
</script>
</body>
</html>

//end



in forumdisplay.php

find this


      if ($thread[attach]>0) {
        $paperclip="<img src=\"images/paperclip.gif\"
alt=\"$thread[attach] Attachment(s)\" border=\"0\" align=\"absmiddle\">";
      }



add underneath

      //
      //
      //
      // start updown hack by quodlibet
      //
      //
      //

      $pub = $DB site->query("select pubstatus from thread where threadid =
".$thread['threadid']) || die ("pubstatus hack error 01 : could not select
pubstatus from table thread, make sure you added the field 'ADD `pubstatus`
TINYINT(1)'");
      if ($pubstatus = $DB site->fetch array($pub))
      {

         if ($pubstatus[pubstatus] != 0) // is no pubstatus is set, we are not
going to dispay it
         {
               if ($pubstatus[pubstatus] == '1') // this pub is still up
               {
                  $thread[updown] = "<img
src=\"images/icons/icon14.gif\" alt=\"This pub is up \" border=\"0\"
align=\"absmiddle\">";
               }
               else
               {
                  if ($pubstatus[pubstatus] == '2') // this pub is down
                  {
                     $thread[updown] = "<img
src=\"images/icons/icon13.gif\" alt=\"This pub is down \" border=\"0\"
align=\"absmiddle\">";
                 }
                }
                //$thread[updown] = "select pubstatus from thread where threadid
= ".$thread['threadid'].$pubstatus['pubstatus'];

          }
       }
      //
      //
      //
      // end updown hack by quodlibet
      //
      //
      //




run this query to alter the thread table you need to put the name of your
database where the XXXXX is

ALTER TABLE `XXXXXX`.`thread` ADD `pubstatus` TINYINT(1) NOT NULL;




template modification's

replace all the code in the forumdisplaybit with this

<!---- start--->

<tr align="center">
   <td bgcolor="#F1F1F1"><img
src="images/$thread[newoldhot].gif" border="0" alt=""></td>
   <td bgcolor="#DFDFDF">$thread[icon] $thread[updown]</td>
   <td bgcolor="#F1F1F1" align="left"
width="70%"><normalfont>$thread[gotonew]
$paperclip$thread[movedprefix]$thread[typeprefix]<a
href="showthread.php?s=$session[sessionhash]&threadid=$thread[threadid]">$thread
[title]</a></normalfont> <smallfont>$thread[pagenav]</smallfont></td>
   <td bgcolor="#DFDFDF" width="30%"
nowrap><normalfont>$thread[postedby]</normalfont></td>
   <td bgcolor="#F1F1F1"><normalfont><a
href="java script:who($thread[threadid])">$thread[replycount]</a></normalfont></t
d>
   <td bgcolor="#DFDFDF"><normalfont>$thread[views]</normalfont></td>
   $threadrating
   <td bgcolor="$backcolor">
      <table cellpadding="0" cellspacing="0" border="0" width="100%"
id="ltlink"><tr align="right">
         <td nowrap><smallfont>$thread[lastreplydate] <font
color="#a62a2a">$thread[lastreplytime]</font><br>
         by <a
href="member.php?action=getinfo&find=lastposter&threadid=$thread[threadid]"><b>$
thread[lastposter]</b></a></smallfont></td>
         <td nowrap> <a
href="showthread.php?s=$session[sessionhash]&goto=lastpost&threadid=$thread[thre
adid]"><img src="images/lastpost.gif" border="0" alt="Go to last
post"></a></td>
      </tr></table>
   </td>
</tr>

<!------end----->


in the editpost template

find this

<b>Show Signature:</b> include your profile signature.  Only registered users
may have signatures.
   </smallfont>

add underneath this

<!-- start of pubstatus hack -->
   <br>

Pub Status :
<a href=./setpubstatus.php?threadid=$thread[threadid]&pubstatus=1&return=$PHP
SELF&s=$s>
<img src="images/icons/icon14.gif" alt="This pub is up " border="0"
align="absmiddle">
</a>||
<a href=./setpubstatus.php?threadid=$thread[threadid]&pubstatus=2&return=$PHP
SELF&s=$s>
<img src="images/icons/icon13.gif" alt="This pub is down "border="0"
align="absmiddle">

</a>||
<a href=./setpubstatus.php?threadid=$thread[threadid]&pubstatus=0&return=$PHP
SELF&s=$s>NO PUB</a>


   <!-- end of pubstatus hack -->