"Search by display name" function not working

Print Thread

Rate Thread

"Search by display name" function not working #231979 01/05/2003 5:00 PM
Joined: Nov 2001 Posts: 126 BryanDS Junior Member
BryanDS Junior Member Joined: Nov 2001 Posts: 126	Yep, on my board and this one.. the search by display name feature doesnt work.. says "no matches"

Sponsored Links

Re: "Search by display name" function not working

nonomen #231984 01/05/2003 8:27 PM

Joined: Jun 2001

Posts: 3,273

JustDave

That 70's Guy

JustDave

That 70's Guy

Joined: Jun 2001

Posts: 3,273

To fix this edit your dosearch.php script and change this:

Code

<br />	if ($Match == "Username") {<br />		$query = "<br />			SELECT U_Username<br />			FROM	 {$config['tbprefix']}Users<br />			WHERE  U_Number = '$Words'<br />		";<br />		$sth = $dbh -> do_query($query);<br />		list($printwords) = $dbh -> fetch_array($sth);<br />	}<br />

to this:

Code

<br />	if ($Match == "Username") {<br />		$query = "<br />			SELECT U_Number,U_Username<br />			FROM	 {$config['tbprefix']}Users<br />			WHERE  U_Username = '$Words'<br />		";<br />		$sth = $dbh -> do_query($query);<br />		list($searchunum,$printwords) = $dbh -> fetch_array($sth);<br />	}<br />

Change this:

Code

<br />   elseif ($Match == "Username") {<br />      $Words_q = addslashes($Words);<br />      $query = $query."AND B_Posterid = '$Words_q'";<br />      $query = $query."\nAND B_Reged = 'y'\n";<br />   }<br />

to this:

Code

<br />   elseif ($Match == "Username") {<br />      $Words_q = addslashes($searchunum);<br />      $query = $query."AND B_Posterid = '$Words_q'";<br />      $query = $query."\nAND B_Reged = 'y'\n";<br />   }<br />

and that should do the trick.

Re: sjsaunders #231985 01/06/2003 2:45 PM
Joined: Nov 2001 Posts: 126 BryanDS Junior Member
BryanDS Junior Member Joined: Nov 2001 Posts: 126	Thanks! Works Great! :-)

Re: "Search by display name" function not working sjsaunders #231986 01/07/2003 5:57 PM
Joined: Oct 2002 Posts: 165 So Cal USA sportbikes Member
sportbikes Member Joined: Oct 2002 Posts: 165 So Cal USA	This is the only change I made to dosearch and it appears to be fine. This mod works fine... but now when in a user's profile and you choose Show all user's posts.. I get No Matches Anyone else have this experience? Here is the URL that bring that No Match result http://www.esportbike.com/wwwthread...archpage=0&Limit=25&Old=allposts Since the dosearch is in the URL.. I thought this would be where to look. edit Yes, this is it. I reverted back and the show all works and the search doesn't and re hacked the cut and paste and the search works, but the show all does not. Any feedback as to if we can get both working? Last edited by sportbikes; 01/07/2003 6:14 PM.

Re: "Search by display name" function not working alsalmicom #231987 01/08/2003 7:28 AM
Joined: Jun 2001 Posts: 3,273 JustDave That 70's Guy
JustDave That 70's Guy Joined: Jun 2001 Posts: 3,273	Yes I fixed this here as well. To fix this you need to edit showprofile.tmpl and change this: <a href="{$config['phpurl']}/dosearch.php?Cat=$Cat&Forum=All_Forums&Words=$User&Match=Username&Searchpage=0&Limit=25&Old=allposts"> to this: <a href="{$config['phpurl']}/dosearch.php?Cat=$Cat&Forum=All_Forums&Words=$CheckUser&Match=Username&Searchpage=0&Limit=25&Old=allposts"> And that should do the trick.

Re: "Search by display name" function not working sjsaunders #231988 01/08/2003 12:15 PM
Joined: Nov 2001 Posts: 126 BryanDS Junior Member
BryanDS Junior Member Joined: Nov 2001 Posts: 126	[]Yes I fixed this here as well. To fix this you need to edit showprofile.tmpl and change this: <a href="{$config['phpurl']}/dosearch.php?Cat=$Cat&Forum=All_Forums&Words=$User&Match=Username&Searchpage=0&Limit=25&Old=allposts"> to this: <a href="{$config['phpurl']}/dosearch.php?Cat=$Cat&Forum=All_Forums&Words=$CheckUser&Match=Username&Searchpage=0&Limit=25&Old=allposts"> And that should do the trick. [/] Why am I not finding that in showprofile.tmpl?

Sponsored Links

Re: "Search by display name" function not working nonomen #231989 01/08/2003 1:09 PM
Joined: Oct 2002 Posts: 165 So Cal USA sportbikes Member
sportbikes Member Joined: Oct 2002 Posts: 165 So Cal USA	BryanDS, Be sure you are looking at ./templates/default/showprofile.tmpl and not the .php file

Re: alsalmicom #231990 01/08/2003 1:18 PM
Joined: Nov 2001 Posts: 126 BryanDS Junior Member
BryanDS Junior Member Joined: Nov 2001 Posts: 126	hmm, Im at work so I was doing it through the "Edit templates" in the admin section.. still didnt find it. Could be that Im blind.. 8)

Re: nonomen #231991 01/08/2003 1:27 PM
Joined: Oct 2002 Posts: 165 So Cal USA sportbikes Member
sportbikes Member Joined: Oct 2002 Posts: 165 So Cal USA	Go to the bottom and work your way up give or take 20 lines up including spaces. You can also click inside the template section once loaded and use the "Find" under edit in IE. I searched for dosearch and it dound it that way, too.

Re: alsalmicom #231992 01/08/2003 1:49 PM
Joined: Nov 2001 Posts: 126 BryanDS Junior Member
BryanDS Junior Member Joined: Nov 2001 Posts: 126	Its official, I was blind. Found it! Thanks Sportsbikes, and Dave L / justdave for the fix(s). Last edited by BryanDS; 01/08/2003 1:52 PM.

Hop To

Link Copied to Clipboard

UBB.Developers Forums UBB.threads 7 Development How Do I? "Search by display name" function not working