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:
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:

$threads=$DB_site->query("SELECT $dotuserid icon.title as icontitle,icon.iconpath,thread.threadid,thread.tit le,
lastpost,forumid,pollid,open,replycount,postuserna me,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 ;)