vb.org Archive - vB Timeslip Database -for Automotive websites

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)

- - vB Timeslip Database -for Automotive websites (https://vborg.vbsupport.ru/showthread.php?t=60945)

Quote:

Originally Posted by PranK

Dewayne,

I did this, when I had 2 lots of profile fields, i was able to add/edit etc, but now that i have deleted the lot that i added last (without any entries) the old profile fields cannot be accessed.

Thanks,

Christian

Do this, go to your admincp, click modify custom profile fields, and tell me the field IDs for the timeslip fields.

This hack is a good idea.

Is there something similar that will allow the user to add say 4 images via an upload button, some custom fields & a 500 character description field?

I run an automotive site. This is our current member gallery:
http://www.aussiefrogs.com/gallery/usergallery.htm
It is cluttered & requires a lot of maintenence. If the members could update their own page within the forum software it would be really good :classic:

Quote:

Originally Posted by EvilLS1

Do this, go to your admincp, click modify custom profile fields, and tell me the field IDs for the timeslip fields.

Fields are 80-95, the ones it created the 2nd time were 50-65 (i think).

Christian

Quote:

Originally Posted by EvilLS1

PKRWUD,
Check and make sure you added the html to the timeslipsbit template. Then go into your admin panel and look under the custom profile fields section and make sure that the timeslip fields are there and that the IDs are 50-65. If thats not it, let me know and we'll figure it out. I'm sure its something simple.

This is what's in my timeslipbit template:

<tr align="center">
<td class="alt1">$rank</td>
<td class="alt2""><a href="member.php?$session[sessionurl]u=$userinfo[userid]">$username</a></td>
<td class="alt1">$ride</td>
<td class="alt2">$induction</td>
<td class="alt1"">$avghp$rwhp</td>
<td class="alt2">$avgsf$sixty</td>
<td class="alt1"">$avge$eighth$atmph1$eighthmph$spacer $avgemph</td>
<td class="alt2">$avgq$quarter$atmph2$quartermph$space r$avgqmph</td>
<td class="alt1"">$details</td>
<td class="alt2">$slip</td>
</tr>

And my user fields include 1-10 and 50-65.

Quote:

Originally Posted by EvilLS1

Nothing is wrong. Thats the way it was designed to work. The Timeslip Database is mostly geared toward 1/4 mile ETs since thats the most popular track length.

By default it sorts by 1/4 mile ETs.. So it only shows times of those who have entered something into the 1/4 mile ET field..

If you select "sort by username" it displays the usernames alphabetically of everyone who has entered something into the 1/4 mile ET field. Same with showing naturally aspirated cars only. If the 1/4 mile ET field is left blank, they will not show on the list. Everything is based on the 1/4 mile ET. Of coarse you can easily change it so that it sorts by other things if you want. But thats the way its meant to work.

It will show the 1/8 mile ETs for everyone who has entered them only when sorting by 1/8 mile ET.

how do i go about fixing the sort by username, NA, and those to not require the 1/4 mile time?

Quote:

Originally Posted by gibgib

I think what your asking for is a vB Garage that every car site owner here has been asking for forever.

If you just need a good gallery, there are a few free ones that are good. Coppermine is good. Or if you want to pay for a gallery, check out PhotoPost.

gibgib,
Yeah what you want is the vbgarage that everyone keeps requesting.. Not sure if anyone is developing it or not.. Theres a thread in the request forum about it.

PranK,
So the fields that are still in your database are 80-95 and fields 50-65 no longer exist correct? If so, in member.php, includes/functions_user.php, and profile.php you'll need to make sure the field ID#s match the field IDs that you have in your database.

In those files, find all instances of this (there will be several):

Code:

(50,51,52,53,54,55,56,58,59,60,61,62,63,64,65)

And replace it with this:

Code:

(80,81,82,83,84,85,86,88,89,90,91,92,93,94,95)

Or if I'm misunderstanding you and you're saying that you still have fields 50-65, then you'll need to do just the opposite. Also, make sure you have the correct field #s in timeslips.php.

PKRWUD,
For some reason your timeslipsbit template isn't being displayed. Make sure the template name is spelled correctly (its timeslipsbit not timeslipbit).. If thats not it send me a copy of your timeslips.php file and I'll take a look.

gearshifter47,
This will make it show everyone who has entered something into the ride field when sorting by username:

In timeslips.php find:

Code:

   else if ($_REQUEST['do'] == 'username') 

   {

        $cond.=" WHERE userfield.field55>'".intval($number)."'";

        $condition.=" AND userfield.field55>'".intval($number)."'";

        $orderby="user.username";

        $direction=ASC;

        $bracket11="<b>[</b>";

        $bracket12="<b>]</b>";

   }

Replace it with:

Code:

   else if ($_REQUEST['do'] == 'username') 

   {

        $cond.=" WHERE userfield.field50!=''";

        $condition.=" AND userfield.field50!=''";

        $orderby="user.username";

        $direction=ASC;

        $bracket11="<b>[</b>";

        $bracket12="<b>]</b>";

   }

To make it show all N/A cars (when sorting by N/A) regardless if 1/4 mile ET has been entered find:

Code:

    else if ($_REQUEST['do'] == 'na') 

   {

        $condition.=" AND userfield.field65='$natasp' AND userfield.field55>'".intval($number)."'";

        $cond.=" WHERE userfield.field55!=''";

        $orderby="userfield.field55";

        $direction=ASC;

        $bracket13="<b>[</b>";

        $bracket14="<b>]</b>";

Replace it with:

Code:

    else if ($_REQUEST['do'] == 'na') 

   {

        $condition.=" AND userfield.field65='$natasp' AND userfield.field50!=''";

        $cond.=" WHERE userfield.field50!=''";

        $orderby="userfield.field55";

        $direction=ASC;

        $bracket13="<b>[</b>";

        $bracket14="<b>]</b>";

Heh, my scripts name has surpassed the script itself. vBGarage was short lived, the "powers that be" yanked it, because I used a portion of code from a coder who is no longer around to give consent. /shrug

It was for vB2, anyway. I've been developing a vB3 version, but unfortunately I started a new job and don't have the time to beat on it full time, so I can't really guestimate a release date.

FOCUS: EvilLS1, as always, still diggin' the hack.. the users love it. ;)

this will still keep them in order right?

and how could i make username the default sort when i start up..

Quote:

Originally Posted by magnus

It was for vB2, anyway. I've been developing a vB3 version, but unfortunately I started a new job and don't have the time to beat on it full time, so I can't really guestimate a release date.

I remember your garage for vb2. Looked pretty nice! I'm sure a vb3 version would be very popular with the automotive sites.. I'm in the same boat as you though... Due to work I don't have much spare time to try and make anything like that.

Quote:

Originally Posted by gearshifter47

this will still keep them in order right?

and how could i make username the default sort when i start up..

Yes, they'll still be sorted by username alphabetically.

To make username the default sort method open timeslips.php and find:

Code:

// If no action is set order by quarter

if (empty($_REQUEST['do']))

{

  $_REQUEST['do'] ='quarter';

}

Replace it with:

Code:

// If no action is set order by username

if (empty($_REQUEST['do']))

{

  $_REQUEST['do'] ='username';

}

Find:

Code:

   } 

   else 

   {

        $cond.=" WHERE userfield.field55>'".intval($number)."'";

        $condition.=" AND userfield.field55>'".intval($number)."'";

        $orderby="userfield.field55";

        $direction=ASC;

        $bracket3="<b>[</b>";

        $bracket4="<b>]</b>";

Replace it with:

Code:

   } 

   else

   {

        $cond.=" WHERE userfield.field50!=''";

        $condition.=" AND userfield.field50!=''";

        $orderby="user.username";

        $direction=ASC;

        $bracket11="<b>[</b>";

        $bracket12="<b>]</b>";

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (10)bbcode_code_printable (7)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (3)pagenav_pagelinkrel (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
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01657 seconds Memory Usage 1,767KB 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 (10)bbcode_code_printable (7)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (3)pagenav_pagelinkrel (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
Messages: