vB Timeslip Database - for Automotive websites

Yes, finally I can release it here the converted version off Timeslips database for vbulletin 3.5.x. I made it as a product, try to change the file edits into plugin as best as I could but you still need to edit 2 files (optional). I can't think of an easy way to remove that but if anyone can, please pop in.

I've made the timeslips.php page XHTML valid. Of course the look has not been changed. Also made it fully phrased.

The permission is granted here

Please let me copy what EvilLS1 posted in the 3.0 hack

Originally Posted by EvilLS1

This is the newest version of EvilLS1's 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://www.ls6.com.au/forum/timeslips.php?

Installation overview:
Files to edit: (2)- member.php (1), functions_user.php (2), image.php(2)
Files to upload: (2)- timeslips.php, slipicon.gif
Templates to edit: (2)- USERCP_SHELL, navbar
Templates to add: 0
Phrases to add: 0

Why do I still have to edit files ?
The reasons for those editions are because you don't want users to see the timeslips profile fields in the memberlist/member profile/edit profile

and just that. So that means if you exclude those the hack will still work whatever



Installation instructions:

BACK UP EVERYTHING BEFORE INSTALLING ANY HACK

Firstly please read the file Instructions.txt file on how to install this hack.

the steps are: Import the product-timeslips.xml file. Do file and template editions. Upload files to correct folder. Then enjoy it !


I have tried all that I can by installing this hack on a fresh board and solved *almost* all the problem. But if you find any errors, please post it here (just do not duplicate things :P ).


Upgrading

I haven't had a chance to do the upgrade because I convert this for a fresh vb3.5 board. I've set up things that I think it's ready for the upgrade. I'm willing to test the upgrade on your board if anyone can give.

For the upgrade to work, you must use the latest version of timeslips which can be taken from here: https://vborg.vbsupport.ru/showthread.php?t=60945



Support

I'll try my best to give supports. But please understand due to my heavy busy I may miss your post. Please understand.


Screenshots?

The shots from its 3.0 version are fine.
here's the link: https://vborg.vbsupport.ru/showthrea...ight=timeslips


Changes Logs

03/18/2006: version 1.1 Fully phrased the hack.
03/19/2006: fix the problem showing your current timeslip image when editing your timeslip. To upgrade simply re-import product-timeslips.xml.

03/19/2006: fixed a few bugs in this post: https://vborg.vbsupport.ru/showpost....9&postcount=31 . Again to upgrade just reimport the product file.

03/20/2006: Hack version change to 1.1.3: Changed the field of field 52,53,55 to decimal (6,3). Added one more file editions into the instructions file to fix showing proper image. So bad to add another file edit but this is becaus there is no hook in image.php. this is how to do it:

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';
    } 


Again to upgrade you need to import the product file again to overwrite. then do the above edit.

03/23/2006: Update: fix a JS error when submitting the new timeslip. (Thanks Sidewindr). Also the new product will attempt to remove your old vb3.0 options then add the new ones, this is for upgrading from timeslips for vb3.0 to vb3.5 . I didn't test that tho.

12/05/2006: Version 1.2 for vb3.6 released.

12/09/2006: minor fix for missing adding field50.

12/12/2006: fix the error: Fatal error: Call to undefined function build_hiddenprofilefield_cache() in C:\Program Files\xampp\htdocs\folder\admincp\plugin.php(1468) : eval()'d code on line 6

Please click install if you use this hack for updates. https://vborg.vbsupport.ru/vborg_mis...hreadid=110717

This hack is free (why not?) but donation are welcome, my paypal is bloodynightcrawler@gmail.com . Thank you.

end of presentation, hope I don't miss anything.

[92GreenGT]

Originally Posted by hotwheels

That i am not sure of.......when i redid this mod for my site, my site had been hacked and the entire database was gone. So mine was started, again from scratch. Then when i found out how to make the timeslips work, i shared what i did to make it work on my website.
Wish i had more info on that for ya.......

hotwheels

No problems, I'll just get everyone to upload their info again. Racing season is over here for winter now anyways. Thanks for everything.

[Poltergiest]

Originally Posted by 92GreenGT

Hotwheels, I get the same message when I try to run those queries. Wonder why that is.

-Edit-
Just to clarify, I am running them one at a time.

I was getting the same error. I took out the 'vb' from the beginning of the vbprofilefield in the queries and they ran fine and the database is working now.

Thanks hotwheels

[92GreenGT]

Originally Posted by Poltergiest

I was getting the same error. I took out the 'vb' from the beginning of the vbprofilefield in the queries and they ran fine and the database is working now.

Thanks hotwheels

Good point, that would have fixed it for me too. I never thought about that, mine was named just profilefield as well, hopefully this will help others. Good post.

[hotwheels]

Okay, i changed the instruction's for uploading the queries, and i changed the instruction's text file to show the same change.........thanks for this information.

queries to run

3.6 Instruction Text

After last count, we have over 40 member's using this update on 3.6........

hotwheels

[Sidewindr]

There is still an issue with the custom profile fields and their titles. Or is this what your queries do hotwheels and correct this problem. Only prevelant in 3.6+

[Zachariah]

Originally Posted by Sidewindr

There is still an issue with the custom profile fields and their titles. Or is this what your queries do hotwheels and correct this problem. Only prevelant in 3.6+

The titles have been moved on profile fields.

<phrasetype name="Custom Profile Fields" fieldname="cprofilefield">
    <phrase name="field50_desc"><![CDATA[What do you drive ?]]></phrase>
    <phrase name="field50_title"><![CDATA[Ride]]></phrase>
</phrasetype>

[hotwheels]

what zachariah said............yes, my queries do that for ya, that is what the "aa" and the "a" are for.........which should fill in these:

$aa= 'Ride';
$ab= 'Horsepower';
$ac= '60 foot time';
$ad= '1/8 Mile ET';
$ae= '1/8 Mile MPH';
$af= '1/4 Mile ET';
$ag= '1/4 Mile MPH';
$ah= 'Link to Timeslip';
$ai= 'Race weight';
$aj= 'Track Name';
$ak= 'Density Altitude';
$al= 'Engine type and displacement';
$am= 'Major modifications';
$an= 'Tranny type';
$ao= 'Induction';
$ap= 'Tires';

$a= 'What do you drive?';
$b= 'HP at the wheels';
$c= 'Enter your 60 foot time';
$d= 'Enter your 1/8 Mile ET';
$e= 'Enter your 1/8 Mile MPH';
$f= 'Enter your 1/4 Mile ET';
$g= 'Enter your 1/4 Mile MPH';
$h= 'Enter a link to your timeslip (including the http://)';
$i= 'Enter the weight of your vehicle with driver';
$j= 'What is the name of the dragstrip where you race?';
$k= 'What was the density altitude the day you got your best ET?';
$l= 'Enter your engine type and displacement';
$m= 'List only major mods separated by a comma';
$n= 'Auto or Manual?';
$o= 'Select your power adder';
$p= 'What type of tires were you using

[92GreenGT]

When you go to the Timeslip database and then click "Submit timeslip" the page it brings up doesnt have any words on it, just boxes? If you go to your User CP then Profile the words are their? Is this the way its supposed to be?

If so, can I go in and change what the "Submit Timeslip" link points to?

[hotwheels]

It should take you to the user profile, where you can edit your vehicle information and submit a timeslip.....

What happen's since you have this much of it working, if you reinstall the .xml via the admincp and click overwrite.......?

Everything should work since the only thing my upgrade does is add the title and description word back to the profilefield in your mysql....

[92GreenGT]

I re-installed the XML file and clicked the overwrite button and it didnt fix it. I took a screenshot to show you what it does, it goes to the "Vehicle Profile" page which isnt even in the User CP options, I believe it used to do this in the 3.5.x version, not sure why its not updated?

Screen:
http://www.fullthrottleforums.com/Pics/Screen.jpg

-Edit-
I dont know if im the only one having this problem(probably is..lol) but if anyone else is having this problem do this:
Open the .xml file in a text editor(I use Notepad II) and go to line 433 and change "edittimeslip" to whatever you want the link to point to, in my case it was just Edit profile so I put in "editprofile" in place of "edittimeslip". Then save the file and upload it with Overwrite selected and your done.

Works perfect now, thanks again.