vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   Search Templates by Title (https://vborg.vbsupport.ru/showthread.php?t=33748)

Hooper 01-04-2002 01:17 AM

Absolutely.

-.valkyre 01-04-2002 01:29 AM

Damn designed behaviors :D

bbaddons 01-04-2002 07:07 AM

Thanks, this hack saves me some time in having to click the links, instead I just search for em.

Great hack, very useful to those that do a lot of hacking and those that just make small template mods :) :)

Great Job (this should be in the next vB release ;))

Stretchr 01-16-2002 04:59 PM

Nah, with MS, it's a feature---And you'd have to pay extra for it!
:D
Great hack. Thank you!
Quote:

Originally posted by Hooper
That's just plain impossible. vBulletin has never had bugs. Just designed behaviors.

djr 01-27-2002 04:33 PM

TommyBoy,

Can you enhance it a bit more where you have two input boxes: one where you can search only for occurences of the string inside a template and one inputbox for template titles only.

pls see attached picture

- djr

Princeton 01-28-2002 10:58 PM

worked the first time around ... thank you

great addition

kippesp 02-02-2002 08:42 AM

Quote:

Can you enhance it a bit more where you have two input boxes: one where you can search only for occurences of the string inside a template and one inputbox for template titles only.
Done.

SemperFidelis 01-03-2003 01:22 AM

kippesp - great addition to an already great hack.
:)

Any ideas on how to fix this :
(on vb 2.2.9)

kippesp 01-03-2003 03:43 AM

This file hasn't changed since 2.2.6. But what you're seeing looks very familure to what I saw with the template backup system.
And I think version 2.2.6 fixes what you're seeing in template.php. You'll need to incorporate my changes into 2.2.6's changes (see below).

Can you compare your code against 2.2.9 again--especially the query at line 471.

This is what those lines should look like:
Code:

    $templates=$DB_site->query("SELECT t1.title AS title,t2.templateid, NOT ISNULL(t2.templateid) AS found" . iif(isset($searchstring), ",INSTR(t1.".$searchtype.",'".addslashes($searchstring)."') AS globalcontain,INSTR(t2.".$searchtype.",'".addslashes($searchstring)."') AS localcontain","")."
                                                            FROM template AS t1
                                                            LEFT JOIN template AS t2 ON (t1.title=t2.title AND t2.templatesetid=$templateset[templatesetid])
                                                            WHERE t1.templatesetid=-1 AND t1.title<>'options'
                                                            ORDER BY t1.title");

Let me know if this works. I can also post the full set
of changes against 2.2.9 (mine and TommyBoy's) for this hack since it's been so long.

Be sure you to use the code in this post. I had to edit this post.

(Not that it matters, but the file really did change in 2.2.8--fixed a bug that TommyBoy found 10 months ago and has long been in my code.)

SemperFidelis 01-05-2003 01:35 PM

Cheers for the assitance there kippesp

It actually turned out to be a typo on my behalf where:
PHP Code:

'FROM template AS t1' 

wasnt on a new line but tacked on the end of :
PHP Code:

$templates=$DB_site->query("SELECT t1.title AS title,t2.templateid, NOT ISNULL(t2.templateid) AS found" iif(isset($searchstring), ",INSTR(t1.".$searchtype.",'".addslashes($searchstring)."') AS globalcontain,INSTR(t2.".$searchtype.",'".addslashes($searchstring)."') AS localcontain","").

So thanks again, its all working fine now.


All times are GMT. The time now is 01:46 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01177 seconds
  • Memory Usage 1,740KB
  • 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
  • (1)bbcode_code_printable
  • (2)bbcode_php_printable
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete