Search Users module in the Search navbar drop down

it's pretty simple to do

<!-- header quick search form -->
  	<div class="vbmenu_popup" id="navbar_search_menu" style="display:none">
  		<table cellpadding="4" cellspacing="1" border="0">
  		<tr>
 			<td class="thead">$vbphrase[search_forums]</td>
  		</tr>
  		<tr>
  			<td class="vbmenu_option" title="nohilite">
 			<form action="$vboptions[bburl]/search.php" method="post">
 		 	<input type="hidden" name="do" value="process" />
 		 	<input type="hidden" name="showposts" value="0" />
 		 	<input type="text" class="bginput" name="query" size="20" />$gobutton<br />
  			</form>
  			</td>
  		</tr>
  		<tr>
 			<td class="vbmenu_option"><a href="$vboptions[bburl]/search.php?$session[sessionurl]">$vbphrase[advanced_search]</a></td>
  		</tr>
  		<tr>
 			<td class="thead">Find a Member</td>
  		</tr>
  		<tr>
  			<td class="vbmenu_option" title="nohilite">
 			<form action="$vboptions[bburl]/memberlist.php" method="post">
 		 	<input type="hidden" name="s" value="$session[sessionhash]" />
 		 	<input type="hidden" name="do" value="getall" />
 		 	<input type="text" class="bginput" name="ausername" size="20" value="$ltr" title="$vbphrase[username]" />$gobutton
  			</form>
  			</td>
  		</tr>
  		<tr>
 			<td class="vbmenu_option"><a href="$vboptions[bburl]/memberlist.php?$session[sessionurl]do=search">$vbphrase[advanced_search]</a></td>
  		</tr>
  		</table>
  	</div>
  	<!-- / header quick search form -->

PHP:

it's the bottom portion, i basically just copy and pasted it from the memberlist.php, it's really quick and simple to use. but if you've removed it for the server load aspect, then i guess it's not a good idea

but it just adds a Search Member and Advanced Options box under the search forums ones

 

but you have to type out forums.digitalpoint.com/memberlist.php because it's not in the navbar (at least not to me )

i usually just find them through my PM box

 

oooh.

i do know some people recommend to turn it off to ease the server load..does it really have that much of an impact?

i do have most of my mysql tabled indexed, dunno if that makes a difference

 

oy vay...hmmmmmmmm i guess i'll deindex them and compare

 

hmmm i had this queries done

ALTER TABLE `post` ADD INDEX `datelineuserid` ( `userid` , `dateline` );

Code (markup):

ALTER TABLE `thread` ADD INDEX ( `lastposter` );

ALTER TABLE `thread` ADD INDEX ( `lastpost` );

Code (markup):

alter table forum add index (displayorder);

alter table forumpermission add index (forumid);
alter table forumpermission add index (usergroupid);
alter table forumpermission add index (canadminedit);

alter table post add index (threadid);
alter table post add index (username);
alter table post add index (userid);
alter table post add index (dateline);

alter table session add index (userid);
alter table session add index (location);

alter table thread add index (lastpost);
alter table thread add index (forumid);
alter table thread add index (lastpost); 
alter table user add index (usergroupid); 
alter table user add index (username); 

Code (markup):

 

do you know if any of those have an index by default? how do you check if it has an index or not?

alter table <table> drop index (<index>); 

Code (markup):

to remove them right?

they said it's for bigger boards with more posts, etc. it might actually impede performance on smaller boards, but i think my board counts as a bigger one.

hmmm....bleh i'll ask the vbulletin people

 

well i guess it'd be small-medium if you consider this one medium

i don't believe there are any special queries that need those indexes...hmmm...well I made a post on the vbulletin boards so I'll see what they say.

 

thanks!

i'll take a look at that.

i'm trying to learn PHP so i might as well umm...yeah

 

hmmm...

if they were to install an index by default would they have "ADD INDEX" within the code?

or this

CREATE [UNIQUE|FULLTEXT|SPATIAL] INDEX index_name
    [USING index_type]
    ON tbl_name (index_col_name,...

Code (markup):

$schema['CREATE']['query']['forumpermission'] = "
CREATE TABLE " . TABLE_PREFIX . "forumpermission (
	forumpermissionid SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
	forumid SMALLINT UNSIGNED NOT NULL DEFAULT '0',
	usergroupid SMALLINT UNSIGNED NOT NULL DEFAULT '0',
	forumpermissions INT UNSIGNED NOT NULL DEFAULT '0',
	PRIMARY KEY (forumpermissionid),
	UNIQUE KEY ugid_fid (usergroupid, forumid)

Code (markup):

i believe that's the setup for the forumpermission table, but I don't believe I see anything about indexes

hmm

$schema['CREATE']['query']['subscribeforum'] = "
CREATE TABLE " . TABLE_PREFIX . "subscribeforum (
	subscribeforumid INT UNSIGNED NOT NULL AUTO_INCREMENT,
	userid INT UNSIGNED NOT NULL DEFAULT '0',
	forumid SMALLINT UNSIGNED NOT NULL DEFAULT '0',
	emailupdate SMALLINT UNSIGNED NOT NULL DEFAULT '0',
	PRIMARY KEY (subscribeforumid),
	[b]UNIQUE KEY subindex (userid, forumid),[/b]
	KEY forumid (forumid)
)

Code (markup):

a sub index?

 

hmmm this is going to take some time then

are those the only two notifier that it's an index or are there more?

 

cool, thanks