[EvilLS1]

Thanks glo.

Yes its easy to add an extra field for a drop down menu. I have one myself.

If you haven't already done so, install this hack (adds ability to make drop down menus in custom profile fields). Look in the last couple of pages of that thread to find updated instructions for later versions of vbulletin.

Anyway, once you've added that hack, go into your admin panel and add the new profile field w/ drop down menu.

Then hold your mouse over the "edit" link for the new field and make a note of the field ID # (at the end of the URL).

Then open timeslips.php and find:

} else if ($action=="username") {
  $cond.=" WHERE userfield.field55>'".intval($number)."'";
  $condition.=" AND userfield.field55>'".intval($number)."'";
  $orderby="user.username";
  $direction=ASC;

Below it add:

} else if ($action=="make") {
  $cond.=" WHERE userfield.field55>'".intval($number)."'";
  $condition.=" AND userfield.field55>'".intval($number)."'";
  $orderby="userfield.fieldXX";
  $direction=ASC;

In the code above, replace the red Xs with the ID# of the new field you added.

Still in timeslips.php find:

$ride= $userinfo[field50];

Below it add:

$make= $userinfo[fieldXX];

Again, replace the red Xs with the ID# of the new field you added.

Now in your "timeslips" template find:

<option value="$bburl/timeslips.php?s=$session[sessionhash]&action=username">Username</option>

Below it add:

<option value="$bburl/timeslips.php?s=$session[sessionhash]&action=make">Vehicle Make</option>

Find:

	<td bgcolor="{categorybackcolor}" colspan="8"><normalfont color="{categoryfontcolor}"><CENTER><b> Timeslip Database</b></CENTER></normalfont></td>

Replace it with:

	<td bgcolor="{categorybackcolor}" colspan="9"><normalfont color="{categoryfontcolor}"><CENTER><b> Timeslip Database</b></CENTER></normalfont></td>

Find:

<td bgcolor="{tableheadbgcolor}" align="center"><smallfont color="{tableheadtextcolor}"><b>Username</b></smallfont></td>

Below it add:

<td bgcolor="{tableheadbgcolor}" align="center"><smallfont color="{tableheadtextcolor}"><b>Vehicle Make</b></smallfont></td>

Find:

<td bgcolor="{categorybackcolor}" colspan="8">

Replace it with:

<td bgcolor="{categorybackcolor}" colspan="9">

In your "timeslipsbit" template find:

<td bgcolor="{secondaltcolor}"><normalfont><a href="member.php?s=$session[sessionhash]&action=getinfo&userid=$userinfo[userid]">$username</a></normalfont></td>

Below it add:

<td bgcolor="{firstaltcolor}">$make</td>

That will add the extra vehicle make info to the timeslips page and allow you to sort by it (alphabetically). You can experiment with the code a little and make it sort differently or whatever you want.

Dewayne