vB Timeslip Database -for Automotive websites

This is the newest version of my Timeslip Database hack. If you don't have an automobile related website ya might as well stop reading here because this will probably be of no use to you.. But if you do, read on!

What does it do? This hack does a few things. First, it will add a separate "Vehicle Profile" page to your forum where your users can enter their type of vehicle, engine, tranny, tires, horsepower, best 60' time, 1/8 mile time, 1/4 mile time, upload thier timeslip and more. Once the data is entered the timeslips.php page will display the info sorted by the best times, highest trap speeds, highest horsepower #s, proof of ET, or ET brackets (user selectable).

You can also ban users from editing their Vehicle Profile. This comes in handy if you have some users who insist on entering false data into the Timeslip Database just to be funny. To use this feature, just click on the user's vehicle profile, then click "user options" and set "Can edit vehicle profile" to no. The user will still be able to edit his regular profile, but not his vehicle profile.


Features include:
*The ability to sort by:
-1/4 Mile ET
-1/4 Mile MPH
-1/8 Mile ET
-1/8 Mile MPH
-60' Time
-Horsepower
-Cars with proof of ET (actual timeslip)
-N/A cars only
-Username
-ET brackets
*Show the average ET, MPH, and HP for your site.
*Vehicle Profile (separate from user profile)
*Ability to ban users from editing their vehicle profile
*Users can upload their timeslip in the vehicle profile. (New!)
*Timeslip uploads can be disabled in the admincp. (New!)
*Admin can delete user's uploaded timeslip. (New!)
*Maximum width, height and filesize for timeslip uploads can be set in the admincp. (New!)
*Admin can set an ET for which a timeslip is required if user's ET is quicker. (New!)
*Installer


Demo:
http://modernmusclecars.net/forums/timeslips.php

vb.org member sites w/Timeslip Database installed:
http://srtforums.com/forums/timeslips.php
http://www.fordpower.net/forums/timeslips.php
http://www.al-club3g.org/forums/timeslips.php
http://www.gmvsford.com/forums/timeslips.php
http://board.accordtuner.com/timeslips.php
http://www.240sxforums.com/forums/timeslips.php
http://www.tennesspeed.net/forums/timeslips.php
http://www.socalloc.com/forums/timeslips.php
http://www.lincolnvscadillac.com/timeslips.php
http://fordvschevy.com/forum/timeslips.php
http://www.skylinesaustralia.com/forums/timeslips.php
http://www.lonestarstangs.com/forum/timeslips.php
http://www.tallahasseemusclecar.com/forum/timeslips.php
http://www.ricehatersclub.com/vbulletin/timeslips.php
http://www.highertuning.com/forums/timeslips.php4
http://www.mx5roadsters.com/forums/timeslips.php
http://www.stangcountry.com/forums/timeslips.php
http://www.lssix.com/forums/timeslips.php
http://gpfanatix.com/forums/timeslips.php
http://tealnet.com/ipw-web/forum/timeslips.php
http://www.eurotechniks.com/forums/timeslips.php
http://k-series.com/forum/timeslips.php
http://www.ymrforums.com/timeslips.php
http://www.modernengineuity.com/forums/timeslips.php
http://t6p.com/forums/timeslips.php
http://www.turborides.com/forums/timeslips.php
http://www.mr2oc.com/timeslips.php
http://host41.hrwebservices.net/~wac...timeslips.php?
http://www.moparstyle.net/forums/timeslips.php
http://www.fullthrottleforums.com/timeslips.php
http://www.ozhonda.com/forum/timeslips.php
http://www.fordforums.com.au/timeslips.php
http://www.commodorecarclubwa.com/timeslips.php
http://www.forabodiesonly.com/mopar/timeslips.php
http://www.carolinarides.com/forum/timeslips.php
http://www.sicgmtrucks.com/forum/timeslips.php
http://www.micra.org.uk/timeslips.php
http://www.carforums.net/

If you'd like me to add a link to your VB3 Timeslip Database for others to see, please post it in this thread.

I've also attached some screenshots from my test board below so that you can see what the standard VB3 version looks like. The screenshots only show 10 entries, but it does have pagination and will display 25 per page by default.

Screenshots:
Timeslips main page
Vehicle Profile
Edit Vehicle Profile
Upload a timeslip
Admincp settings


Installation overview:
Files to edit: (7)- admincp/user.php, image.php, member.php, includes/functions_user.php, profile.php, includes/functions_upload.php, includes/functions_online.php
Files to upload: (3)- TDinstaller.php, timeslips.php, slipicon.gif
Templates to edit: (2)- USERCP_SHELL, navbar
Templates to add: (5)- timeslips, timeslipsbit, getvehicleinfo, timeslips_customfields, modifytimeslip
Phrases to add: (6) *see instructions


Support: (Updated: 8-6-05)
Due to my busy scedule and the release of vB 3.5 this version of the Timeslip Database will no longer be supported or developed. Please do not PM me with questions about when the next version will be released because I honestly have no idea.. But when I do start working on it I'll be sure to let you guys know.
Read more here:
https://vborg.vbsupport.ru/showpost....&postcount=666

Please search this thread before posting questions. Theres a good chance that your question has already been posted and answered.

Also, reading through the old thread for vB Timeslip Database v1.3 can probably answer some of your questions about adding new features or customizing.

The VB2 version of this hack is located here:
https://vborg.vbsupport.ru/showthread.php?t=58076


Add-ons & How to's:
*Show the Top 5 ETs on your vB Advanced Homepage.
*Show the Top 5 ETs on your vB Advanced CMPS page. (by coolmody)
*Show the Top 5 ETs on your vBindex page. (by SVTBlackLight01)
*Change the default sort method
*Show the ET club that users belong to in the postbit.
*Show the 1/4 mile ET in the postbit only for users who have added it.
*Set permissions for editing the Vehicle Profile per usergroup.
*Require a link to the actual timeslip for all ETs that are 11.99 or quicker (for v2.0 only.. this comes standard in v2.1)


This hack has been confirmed to work with vB versions 3.0.0 - 3.0.8.

Many thanks to my beta testers: 350Chevy and Corsacrazy :up:


Version History:
v2.1: -Added the ability for users to upload timeslips in their vehicle profile. Added the ability for admins to require an actual timeslip for specified ETs. New Timeslip Database settings added to the admincp to control maximum upload sizes and turn the upload feature on & off. (current version)
(Check this post for more info about the new features.)
v2.0: -Ported hack over for VB3 and added a few new fields to the vehicle profile.
v1.3: -Added the ability to sort by ET brackets or "clubs". (ie. show 10 second cars only. 11 second cars only, 13 sec cars, etc).
v1.2: -Added a new action that will show the average ET, trap speed, and horsepower for your site.
v1.1: -Added the seperate vehicle profile page to input timeslip data. Added a few new fields to the vehicle profile page (race weight, track, D/A, mods, tranny type, etc). Added a "details" column to the Timeslip Database page which lets you view all vehicle profile fields when clicked.
v1.0: -Initial release. (VB2)


NOTE: If you've recently upgraded your forum software and you're having trouble with timeslips.php showing all users (regardless if they have an ET) or it not sorting correcty, Read This!


If you find this script useful please click install.

[rcull]

Mmmm...

I was running vb3.5.4 with timeslip v1.1.4, I have upgraded to vb3.6.2.

So in order to get my timeslips back up and running, I shouldn't upgrade to timelslip 2.1?

I should just go back and check all the "phrases to add" and continue with the timeslip v1.1.4?

[hotwheels]

v2.1 is for 3.0............

You will just need to use the one in the link from right above your last post.......

[rcull]

Sorry, the first instal went so well, this fix ain't...

When I click on a users name in the timeslip list, I get:

Invalid SQL:

SELECT profilefieldid, required, title, type, data, def, height
FROM vb3_profilefield
WHERE profilefieldid NOT IN (50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65) AND form = 0
ORDER BY displayorder;

MySQL Error : Unknown column 'title' in 'field list'
Error Number : 1054
Date : Wednesday, November 15th 2006 @ 04:05:15 PM
Script : http://www.teambuick.com/forums/member.php?u=3645
Referrer : http://www.teambuick.com/forums/timeslips.php?
IP Address : 24.66.129.166
Username : rcull
Classname : vb_database


It seems for whatever reason, I now need a profile field "title".
I have clicked on add a field, and find:

1 If field type is "enum" or "set", please enter the values using this format: 'a','b','c'...
If you ever need to put a backslash ("\") or a single quote ("'") amongst those values, precede it with a backslash (for example '\\xyz' or 'a\'b').

2 For default values, please enter just a single value, without backslash escaping or quotes, using this format: a


I have never done this before?!? or.... maybe I am just lost trying to fix this!

ALSO:
The descriptions are missing over all textboxes?

[hotwheels]

Rcull, you will need to follow these new instruction's to make it work correctly. https://vborg.vbsupport.ru/showpost....&postcount=354

What that error is telling you, is that you don't have the word "title" in the profilefield. You may need to make sure that your change's go with your mysql. My profilefield is named vb3profilefield, your's might be profilefield, without the vb3 in the front, so you would have to make the change's to the query as such.
Let me know if that make's sense man, i will stop by once in a while to see how thing's are going with the query run....

[rcull]

Hotwheels,

Thanks! I really enjoyed adding the title and description to the database. I learned a lot (twice nothing is still nothing...).

I still am experienceing a problem with fields not showing up. They now have aa and a over each textbox. Have I lost something else in my database?

http://www.teambuick.com/forums/prof...o=edittimeslip

I looks like it has something to do with the install TDinstaller.php which didn't run. It looks like I now have to add some data to the tables?

Thanks

[hotwheels]

Try going into your vbulletin admincp, and rerunning the .xml.......and click overwrite. Let me know what happens.
If you made the file edit's and then did the queries, (which it sounds like you did). You will need to run the .xml as the last step, this way it will run the rest of the queries that are in deathemperor's file.....

[rcull]

That doesn't seem to have solved the problem, and it sounded like such a good thing to do! What should I try next?
The aa seems to be coming from the Default2 in the title table
The a seems to be coming from the Default2 in the description table

It would appear that my tables need more development. I know this will work, I just wish I wasn't having so much difficulty.

Thanks

[hotwheels]

Okay rcull, i registered on your site today and had a look at your timeslip's......

First question, and without seeing your database and mysql, i won't know, but did you do all of the updated file need's?

PHP Code:

###### In image.php find:

if ($_REQUEST['type'] == 'profile') // do not modify this $_REQUEST


###### REPLACE IT WITH:

if ($_REQUEST['type'] == 'profile' or $_REQUEST['type'] == 'timeslip') // do not modify this $_REQUEST


###### FIND:

    else
    {
        $table = 'customavatar';
    }

###### ABOVE THIS ADD:

    else if ($_REQUEST['type'] == 'timeslip')
    {
        $data = 'timeslippicdata';
        $table = 'customfile';
    } 


etc............?

and etc......

PHP Code:

###### In member.php find:
// *********************
// CUSTOM PROFILE FIELDS
// CUSTOM PROFILE FIELDS
$profilefields = $db->query_read_slave("
    SELECT profilefieldid, required, type, data, def, height
    FROM " . TABLE_PREFIX . "profilefield
    WHERE form = 0 " . iif(!($permissions['genericpermissions'] & $vbulletin->bf_ugp_genericpermissions['canseehiddencustomfields']), "
        AND hidden = 0") . "
    ORDER BY displayorder
");



###### Replace it with:

// *********************
// CUSTOM PROFILE FIELDS
$profilefields = $db->query_read_slave("
    SELECT profilefieldid, required, title, type, data, def, height
    FROM " . TABLE_PREFIX . "profilefield
    WHERE profilefieldid NOT IN (50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65) AND form = 0 " . iif(!($permissions['genericpermissions'] & $vbulletin->bf_ugp_genericpermissions['canseehiddencustomfields']), "
        AND hidden = 0") . "
    ORDER BY displayorder
"); 


[hotwheels]

K, I tried to help make this a product.......

I need someone with a pretty much a new set up to give this a whirl.....and then let me know what happen's.

I just don't have a way to test at this point since all i have is an online site, i don't have a test site.

Now, If you test this you will need to do all of the file edit's as per my original instructions, accept i added the query's to this, so you hopefully won't need to run the queries seperately......I believe what is happening is that i didn't make a couple change's in death's original .xml file, and when you add the queries, my queries are being overwritten.....Hopefully with the change's i made, you should be able to upload the product, edit your image.php file and it's good to go.....

If you already have this installed but are having issue's with the title's being posted, just upload this .xml and click overwrite......let me know what happens.....

Please remember, i don't claim to be a coder, i am just trying to help make a great product, work again......

hotwheels

[rcull]

Hotwheels,

I checked the file edits, then I imported your new .xml and am still stalled.

I do have a test site that is still running 3.5.4 and I just installed timeslips 1.1.4 and it seems to be running. I could try the upgrade and see what happens, but I would be happy to send you the log in info. If you would like to contact me here, I will send the info to you.

I know your trying hard to help.

Thanks