query mania postings?

[g-force2k2]

well i won't confirm anything so far... but i was working on a hack earlier to day and was trying to balance the query effect by using the $templatesused variable only thing was one doesn't exist in the postings.php

now i don't know if this is some mistake or if it was just not done for a reason (could be no?) but anyways take what you want from it... reduces queries on all admin option tasks (moving, deleting, editing, merging, splitting) from 1 - 2 per each action and not to mention all of the errors & redirects... again no confirmation of any sort... im just helping fellow vbhackers

If anyone wants to head it over to vb.com be my guest i don't visit there but maybe one of the staffers here could suggest something...

anyways for the fix open postings.php

find:

PHP Code:

require('./global.php'); 


and above it add:

PHP Code:

$templatesused = 'threads_editthread,threads_deletepostsbit,threads_deleteposts,forumjumpbit,threads_move,threads_merge,threads_splitthreadbit,threads_splitthread';
$templatesused.= ',error_invalidid,threads_displayip,error_moveillegalforum,error_movesameforum,error_mergebadurl,error_mergewithself,error_cantsplitone,error_nosplitposts,error_cantsplitall';
$templatesused.= ',redirect_openclose,redirect_threadclosed,redirect_deletethread,redirect_deleteposts,redirect_movethread,redirect_editthread,redirect_mergethread,redirect_splitthread,redirect_sticky'; 


regards... hope someone finds some use for this

g-force2k2

[Scott MacVicar]

Thats because there is barely any templates used in postings.php and its hardly ever called, there will be a bigger overhead with that large query than just loading the two or three templates seperately.

[TECK]

g-forece, if you do this, you load the cache with unneeded templates (extra server memory used). PPN's explanation is very true.