Views

[JCDR]

Hi we are after removing the view queries from the database, the column's have already been edited out of the templates and any help would me appreciated if someone could post what code needs removing from what php files.

Cheers

[Xenon]

showthread.php
delete this code:

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'";
} 


[Smoothie]

Is this the only file which needs to be edited? BTW, after removing the views columns, is it necessary to remove them from the database?

[Xenon]

no it isnt necessary, but why let them in the db when you don't need em ?

usercp.php:

PHP Code:

$threads=$DB_site->query("SELECT $dotuserid icon.title as icontitle,icon.iconpath,thread.threadid,thread.title,
    lastpost,forumid,pollid,open,replycount,postusername,postuserid,lastposter,thread.dateline,views,
    thread.iconid,notes,thread.visible
    FROM thread
    LEFT JOIN icon ON (icon.iconid = thread.iconid)
    $dotjoin
    WHERE $threadids
    ORDER BY lastpost DESC
"); 


take out the ,views

theoretically there are 8 files which work with views, just use the windows-searchfunction and you can see which files