vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)

- - Views (https://vborg.vbsupport.ru/showthread.php?t=40201)

JCDR	06-23-2002 06:49 PM

Views

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

06-23-2002 06:52 PM

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

06-23-2002 07:20 PM

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

06-23-2002 07:29 PM

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 ;)

All times are GMT. The time now is 02:16 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02721 seconds Memory Usage 1,712KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (4)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: