Last Viewed Date

[amykhar]

How much of an extra server hit would it be to mark a thread with a last viewed date when somebody reads it?

I would love to be able to maintain this information, and then prune based on removing threads that have not been viewed in xx number of days.

Amy

[Admin]

You can add this information to the query that is already there, that updates the thread views.

Add a lastview field to the thread table, set it up like dateline field, and then in showthread.php replace this:

PHP Code:

if ($noshutdownfunc) {
  $DB_site->query("UPDATE thread SET views=views+1 WHERE threadid='$threadid'");
} else {
  $shutdownqueries[]="UPDATE LOW_PRIORITY thread SET views=views+1 WHERE threadid='$threadid'";
} 


With this:

PHP Code:

if ($noshutdownfunc) {
  $DB_site->query("UPDATE thread SET views=views+1, lastview=".time()." WHERE threadid='$threadid'");
} else {
  $shutdownqueries[]="UPDATE LOW_PRIORITY thread SET views=views+1, lastview=".time()." WHERE threadid='$threadid'";
} 


[Birdie501]

and what about the server?

[Admin]

What about it?

[amykhar]

Thank you, Chen.

This means I just need to hack the prune routines a bit, and I should be good to go.

Amy

[Birdie501]

Originally posted by FireFly
What about it?

Forget it :-)

[amykhar]

Here is the rest of what I conceived. I am not supporting this as a released hack because I am not set up to test it thorougly. Use at YOUR OWN RISK.
Find:

PHP Code:

doformheader("thread","pruneuser"); 


Paste before:

PHP Code:

  doformheader("thread","pruneviewed");
  maketableheader("Prune by Date Last Viewed");
  makeinputcode("Delete threads with last viewed before x days:<BR>(intensive if deleting a lot of threads)","daysdelete","0");
  //makeforumchoosercode("Forum","forumid",-1,"All forums");
  makeforumchooser("forumid",-1,-1,"","----- all -----","Forum:");
  makeyesnocode("Include sub forums","subforums");
  doformfooter("Prune"); 


Find:

PHP Code:

// ###################### Start Prune by date ####################### 


Paste before:

PHP Code:

// ###################### Start Prune by last viewed #######################
if ($action=="pruneviewed") {
  if ($daysdelete=="") {
    echo "<p>Please enter an age of last view to delete</p>";
    exit;
  }

  if ($confirm!=1) {

    if ($forumid==-1) {
      $forumtitle="all forums";
    } else {
      $forum=$DB_site->query_first("SELECT title FROM forum WHERE forumid=$forumid");
      $forumtitle="the \"$forum[title]\" forum";
      if ($subforums) {
        $forumtitle.=" and sub forums";
      }
    }

    doformheader("thread","pruneviewed");
     maketableheader("Prune All Threads Automatically");
     makehiddencode("forumid", "$forumid");
     makehiddencode("daysdelete", "$daysdelete");
     makehiddencode("subforums", "$subforums");
     makehiddencode("confirm", "1");
     doformfooter("Click Here to Prune All Threads Automatically","",2);

     doformheader("thread","prunedatevie");
     maketableheader("Prune Threads Selectively");
     makehiddencode("forumid", "$forumid");
     makehiddencode("daysdelete", "$daysdelete");
     makehiddencode("subforums", "$subforums");
     doformfooter("Click Here to Prune Threads Selectively","",2);

    //<a 

href=\"thread.php?s=$session[sessionhash]&action=prunedatesel&forumid=$forumid&daysdelete=$daysdelete&subforums=$subforums\"><b>here</b></a> 

to select those to delete.</p>";
    exit;
  }

  if ($forumid!=-1) {
    if ($subforums) {
      $forumcheck="(thread.forumid=$forumid OR INSTR(parentlist,',$forumid,')>0) AND ";
    } else {
      $forumcheck="thread.forumid=$forumid AND ";
    }
  }

  $datecut=time()-($daysdelete*86400);
  $threads=$DB_site->query("SELECT threadid FROM thread LEFT JOIN forum USING (forumid) WHERE $forumcheck thread.lastview<=$datecut AND 

thread.sticky=0");
  while ($thread=$DB_site->fetch_array($threads)) {
    deletethread($thread[threadid],0);
  }

  echo "<p>Posts deleted successfully! It is recommended that you <a href=\"misc.php?s=$session[sessionhash]\">update counters</a> now.</p>";
}

// ###################### Start Prune by date selector #######################
if ($action=="prunedatevie") {

  doformheader("thread","dopruneviewed");

  if ($forumid!=-1) {
    if ($subforums) {
      $forumcheck="(thread.forumid=$forumid OR INSTR(parentlist,',$forumid,')>0) AND ";
    } else {
      $forumcheck="thread.forumid=$forumid AND ";
    }
  }

  echo "<tr class='tblhead'><td><font size='1'><b><span class='tblhead'>Thread Title</span></b></font></td><td><font size='1'><b><span 

class='tblhead'>Delete?</span></b></font></td></tr>\n";

  $datecut=time()-($daysdelete*86400);
  $threads=$DB_site->query("SELECT threadid,thread.title,thread.replycount FROM thread LEFT JOIN forum USING (forumid) WHERE $forumcheck 

thread.lastview<=$datecut ORDER BY thread.lastpost DESC");
  while ($thread=$DB_site->fetch_array($threads)) {
    makeyesnocode("<a href=\"../showthread.php?s=$session[sessionhash]&threadid=$thread[threadid]\" 

target=_blank>$thread[title]($thread[replycount])</a>","delete[$thread[threadid]]",0);
  }

  doformfooter("Submit - only click here if you are ABSOLUTELY certain");
}

// ###################### Start Prune by date selected #######################
if ($HTTP_POST_VARS['action']=="dopruneviewed") {

  echo "<p>Deleting...</p>";

  while (list($key,$val)=each($delete)) {
    if ($val==1) {
      deletethread($key,0);
    }
  }

  echo "<p>Threads deleted successfully! It is recommended that you <a href=\"misc.php?s=$session[sessionhash]\">update counters</a> 

now.</p>";
} 


That's it. It seems to work on my board, but I have only pruned selectively and tested minimally. I will be very cautious using this for a while until it is well proven.

Amy

[amykhar]

One other thing. I am going to set all my lastview amounts to yesterday's date with a single one-time query in phpmyadmin and then start counting from yesterday for prune purposes.

Amy