[N9ne]

Ok I removed the attachment, below is the code from the file functions.php which needs editing.

PHP Code:

// ###################### Start update thread count #######################
function updatethreadcount($threadid) {
  global $DB_site,$threadcache;

    $replies=$DB_site->query_first("SELECT COUNT(*)-1 AS replies, SUM(attachment.visible) AS attachsum
                                    FROM post
                                    LEFT JOIN attachment ON attachment.attachmentid=post.attachmentid
                                    WHERE threadid='$threadid'");

    $lastposts=$DB_site->query_first("SELECT user.username,post.username AS postuser,post.dateline
                                      FROM post
                                      LEFT JOIN user ON user.userid=post.userid
                                      WHERE post.threadid='$threadid' AND visible>0
                                      ORDER BY dateline DESC
                                      LIMIT 1");
    $lastposter=iif($lastposts['username']=="",$lastposts['postuser'],$lastposts['username']);
    $lastposttime=$lastposts['dateline'];

    $firstposts=$DB_site->query_first("SELECT post.userid,user.username,post.username AS postuser,post.dateline
                                       FROM post
                                       LEFT JOIN user ON user.userid=post.userid
                                       WHERE post.threadid='$threadid' AND visible>0
                                       ORDER BY dateline
                                       LIMIT 1");
    $firstposter=iif($firstposts['username']=="",$firstposts['postuser'],$firstposts['username']);
    $firstposterid=$firstposts['userid'];

    $DB_site->query("UPDATE thread SET postusername='".addslashes($firstposter)."',postuserid='$firstposterid',lastpost='$lastposttime',replycount='$replies[replies]',attach='$replies[attachsum]', lastposter='".addslashes($lastposter)."' WHERE threadid='$threadid'");

}

// ###################### Start delete thread #######################
function deletethread($threadid,$countposts=1) {
  global $DB_site;

  // decrement users post counts
  if ($threadinfo=getthreadinfo($threadid)) {
    $postids="";
    $attachmentids="";

    $posts=$DB_site->query("SELECT userid,attachmentid,postid FROM post WHERE threadid='$threadid'");
    while ($post=$DB_site->fetch_array($posts)) {
      if ($countposts) {
        if (!isset($userpostcount["$post[userid]"])) {
          $userpostcount["$post[userid]"] = -1;
        } else {
          $userpostcount["$post[userid]"]--;
        }
      }
      $postids.=$post['postid'].",";
      if ($post['attachmentid'] != 0) {
          $attachmentids .= $post['attachmentid'].",";
      }
      unindexpost($post['postid']);
    }

    if ($attachmentids != '' ) {
      // make sure you don't remove attachments that are already in use!
      $checkattachments=$DB_site->query("SELECT DISTINCT attachmentid FROM post WHERE attachmentid IN ($attachmentids"."0) AND threadid<>'$threadid'");
      $omitattachmentids="";
      while ($omitattach=$DB_site->fetch_array($checkattachments)) {
        $omitattachmentids.=$omitattach['attachmentid'].",";
      }
      $DB_site->query("DELETE FROM attachment WHERE attachmentid IN ($attachmentids"."0) AND NOT attachmentid IN ($omitattachmentids"."0)");
    }

$storeadmin = $DB_site->query_first("SELECT * FROM storeadmin");
$storemin=$storeadmin[newthread];
$DB_site->query("UPDATE user SET storep=storep-'$storemin' WHERE userid='$postuserid'");


    if ($postids!="") {
      $DB_site->query("DELETE FROM post WHERE postid IN ($postids"."0)");
    }
    if ($threadinfo['pollid']!=0) {
      $DB_site->query("DELETE FROM poll WHERE pollid='$threadinfo[pollid]'");
      $DB_site->query("DELETE FROM pollvote WHERE pollid='$threadinfo[pollid]'");
    }
    $DB_site->query("DELETE FROM thread WHERE threadid='$threadid'");
    $DB_site->query("DELETE FROM thread WHERE open=10 AND pollid='$threadid'"); // delete redirects
    $DB_site->query("DELETE FROM threadrate WHERE threadid='$threadid'");
    $DB_site->query("DELETE FROM subscribethread WHERE threadid='$threadid'");
  }
}

// ###################### Start delete post #######################
function deletepost($postid,$countposts=1,$threadid=0) {
  global $DB_site;

  // decrement user post count
  if ($postinfo=getpostinfo($postid)) {
$storeadmin = $DB_site->query_first("SELECT * FROM storeadmin");
$storem=$storeadmin[newreply];
$DB_site->query("UPDATE user SET storep=storep-'$storem' WHERE userid='$postinfo[userid]'");
   
   if ($postinfo['attachmentid']) {
            // make sure you don't remove attachments still in use
            $otherattachs=$DB_site->query("SELECT attachmentid FROM post WHERE attachmentid=$postinfo[attachmentid] AND threadid<>'$postinfo[threadid]'");
            if ($DB_site->num_rows($otherattachs)==0) {
                $DB_site->query("DELETE FROM attachment WHERE attachmentid=$postinfo[attachmentid]");
        $DB_site->query("UPDATE thread SET attach = attach - 1 WHERE threadid = '$threadid'");
            }
    }

    $DB_site->query("DELETE FROM post WHERE postid='$postid'");
  }
}

// ###################### Start make login code #######################
function makelogincode() {
  global $DB_site,$bbuserinfo,$session;

  if ($bbuserinfo['userid']==0) {
    eval("\$logincode = \"".gettemplate("username_loggedout")."\";");
  } else {
    eval("\$logincode = \"".gettemplate("username_loggedin")."\";");
  }

  return $logincode;
}

// ###################### Start un htmlspecialchars #######################