The Arcive of Official vBulletin Modifications Site.

vB Timeslip Database - for Automotive websites · **Released**: 03-17-2006

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

Quote:

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.

Sidewindr · #42 03-19-2006, 10:12 PM

Quote:

Originally Posted by garycutri

This is only the case when viewing the details using the admin account. I saw that a while back but didn't worry about it.

Nope .. all users got it .. it's a problem in the template .. see my fix above.

dsotmoon · #43 03-19-2006, 10:53 PM

so just to be sure, since its phrased I can change this over to use it on a 4x4 offroading site and as an example change " 60' " to "lift amount" or "1/8 Mile ET & MPH" to "tire size" etc etc ?

Sidewindr · #44 03-19-2006, 10:56 PM

Quote:

Originally Posted by deathemperor

Hi folk.

#1: I don't quite understand what you mean on this. more explanations would be better.

The option in admin CP to enforce a timeslip pic/scan if the timeslip is under say 13.00 seconds or what ever you choose... I think you're missing some of the necessary edits/checks from profile.php I am looking at them now ... but the enforcement options to stop Timeslips under the value set in the admin cp being submitted without a pic.

etc etc etc

Actually the issue appears to be in the modifytimeslip template, the java validation script appears not to run/execute properly. It should also check that if a link is given it is to a jpg or gif file not to a htm etc.

Quote:

Originally Posted by deathemperor

#2: fixed

#3: fixed

#4: it can't be, you can try looking at the demo site in the above post.

It is possible, trust me .. from a fresh install this does not work. You are missing the following edits in image.php

Find in image.php

Code:

// ######################### REQUIRE BACK-END ############################
if ($_REQUEST['type'] == 'profile') // do not modify this $_REQUEST
{
        require_once('./global.php');
}

REPLACE with

Code:

// ######################### REQUIRE BACK-END ############################
// if ($_REQUEST['type'] == 'profile') // do not modify this $_REQUEST
if ($_REQUEST['type'] == 'profile' or $_REQUEST['type'] == 'timeslip') // do not modify this $_REQUEST
{

FIND

Code:

        if ($vbulletin->GPC['type'] == 'profile')
        {
                $table = 'customprofilepic';
                // No permissions to see profile pics
                if (!$vbulletin->options['profilepicenabled'] OR (!($vbulletin->userinfo['permissions']['genericpermissions'] & $vbulletin->bf_ugp_genericpermissions['canseeprofilepic']) AND $vbulletin->userinfo['userid'] != $vbulletin->GPC['userid']))
                {
                        exec_shut_down();       // Update location with 'No permission to view profile picture'
                        header('Content-type: image/gif');
                        readfile(DIR . '/' . $vbulletin->options['cleargifurl']);
                        exit;
                }
        }

Replace with

Code:

        if ($vbulletin->GPC['type'] == 'profile')
        {
                $table = 'customprofilepic';
                // No permissions to see profile pics
                if (!$vbulletin->options['profilepicenabled'] OR (!($vbulletin->userinfo['permissions']['genericpermissions'] & $vbulletin->bf_ugp_genericpermissions['canseeprofilepic']) AND $vbulletin->userinfo['userid'] != $vbulletin->GPC['userid']))
                {
                        exec_shut_down();       // Update location with 'No permission to view profile picture'
                        header('Content-type: image/gif');
                        readfile(DIR . '/' . $vbulletin->options['cleargifurl']);
                        exit;
                }
        }
        else if ($vbulletin->GPC['type'] == 'timeslip')
        {
                $table = 'customfile';
        }

Quote:

Originally Posted by deathemperor

#5: that was because of my lack of vehicle knowlegde. I will change that if more ppl want it.

Trust me you need to change the DECIMAL values to 6,3 for those fields as there are not many people running under 9.999 seconds on the quarter mile. I'm trying to impart some vehicle knowledge here

Quote:

Originally Posted by deathemperor

#6: There are no other possible ways to remove those file editions AFAIK. If you can do it just point me out. I'll be greatful.

I am unsure as well but there HAS to be a way ... some far more complex hacks manage to do it but it requires reworking of the code.

Quote:

Originally Posted by deathemperor

#7: I'll be more greatful if you keep the credit of timeslips on your site. Please do respect the volunteers. Thank you.

Well it would hardly be accurate would it seeing that the hack is not complete and needs extra work to get it working

Lets get it all working first.

0ptima · #45 03-19-2006, 11:37 PM

Quote:

Originally Posted by deathemperor

Sorry for my bad knowledge on vehicle but is it "1/8 Mile ET & MPH" or "1/4 Mile ET & MPH"

It can be both...

deathemperor · #46 03-20-2006, 01:06 AM

Quote:

Originally Posted by Sidewindr

The option in admin CP to enforce a timeslip pic/scan if the timeslip is under say 13.00 seconds or what ever you choose... I think you're missing some of the necessary edits/checks from profile.php I am looking at them now ... but the enforcement options to stop Timeslips under the value set in the admin cp being submitted without a pic.

etc etc etc

Actually the issue appears to be in the modifytimeslip template, the java validation script appears not to run/execute properly. It should also check that if a link is given it is to a jpg or gif file not to a htm etc.

It is possible, trust me .. from a fresh install this does not work. You are missing the following edits in image.php

Find in image.php

Code:

// ######################### REQUIRE BACK-END ############################
if ($_REQUEST['type'] == 'profile') // do not modify this $_REQUEST
{
        require_once('./global.php');
}

REPLACE with

Code:

// ######################### REQUIRE BACK-END ############################
// if ($_REQUEST['type'] == 'profile') // do not modify this $_REQUEST
if ($_REQUEST['type'] == 'profile' or $_REQUEST['type'] == 'timeslip') // do not modify this $_REQUEST
{

FIND

Code:

        if ($vbulletin->GPC['type'] == 'profile')
        {
                $table = 'customprofilepic';
                // No permissions to see profile pics
                if (!$vbulletin->options['profilepicenabled'] OR (!($vbulletin->userinfo['permissions']['genericpermissions'] & $vbulletin->bf_ugp_genericpermissions['canseeprofilepic']) AND $vbulletin->userinfo['userid'] != $vbulletin->GPC['userid']))
                {
                        exec_shut_down();       // Update location with 'No permission to view profile picture'
                        header('Content-type: image/gif');
                        readfile(DIR . '/' . $vbulletin->options['cleargifurl']);
                        exit;
                }
        }

Replace with

Code:

        if ($vbulletin->GPC['type'] == 'profile')
        {
                $table = 'customprofilepic';
                // No permissions to see profile pics
                if (!$vbulletin->options['profilepicenabled'] OR (!($vbulletin->userinfo['permissions']['genericpermissions'] & $vbulletin->bf_ugp_genericpermissions['canseeprofilepic']) AND $vbulletin->userinfo['userid'] != $vbulletin->GPC['userid']))
                {
                        exec_shut_down();       // Update location with 'No permission to view profile picture'
                        header('Content-type: image/gif');
                        readfile(DIR . '/' . $vbulletin->options['cleargifurl']);
                        exit;
                }
        }
        else if ($vbulletin->GPC['type'] == 'timeslip')
        {
                $table = 'customfile';
        }

Trust me you need to change the DECIMAL values to 6,3 for those fields as there are not many people running under 9.999 seconds on the quarter mile. I'm trying to impart some vehicle knowledge here

I am unsure as well but there HAS to be a way ... some far more complex hacks manage to do it but it requires reworking of the code.

Well it would hardly be accurate would it seeing that the hack is not complete and needs extra work to get it working

Lets get it all working first.

Thanks for those, I did miss the edit on image.php. but as Gary's site I did not. Anyway, added.

Another user has requested to change the decimal range, so I changed it too.

Sidewindr · #47 03-20-2006, 02:22 AM

I am looking at the java code in the modifytimeslip template.

It appears that the if statment cannot evaluate the values for theform.field55.value etc.

I tested the IF with 1==1 and 2<=3 and it behaves as expected ..

Changing the if statement to just

Code:

if (theform.field55.value<=$vboptions[tdsliprequired]) {

does not work.

Sidewindr · #48 03-20-2006, 03:14 AM

Almost fixed it .. will post up when I have

Sidewindr · #49 03-20-2006, 04:22 AM

Ok the problem in the javascript is that where the variable is "theform.field55.value" it should be "theform.ctb_field55.value" and the smae for all other fieldNN.value's ...

I am wrestling with the logic there at the moment as if you have upload slip pic allowed it will not let woy use a url instead.

tommyxv · #50 03-20-2006, 04:31 AM

First I just want to say this hack is awesome and thanks for porting it. I am still testing it on my test board.

I found an issue with removing a timeslip image. It removes the timeslip icon but the image is still there if you follow the original link.

My concern is that the database will hold this data and keep growing.

Can someone try this too. Upload an image, view the image via the timeslip page, save the url, then remove the image and then follow the original URL.

Is it still there?

fkatzenb · #51 03-20-2006, 12:16 PM

I have some problems.... I imported the product, I get the following when visiting the php file and I also found that none of the fields have been imported...

Code:

Database error in vBulletin 3.5.2:

Invalid SQL:
SELECT COUNT(*) AS users
                                     FROM TM_VBuser AS user, TM_VBuserfield AS userfield
                                     
                                      WHERE userfield.field55>0 
                                     AND user.userid = userfield.userid;

MySQL Error  : Unknown column 'userfield.field55' in 'where clause'
Error Number : 1054
Date         : Monday, March 20th 2006 @ 08:09:13 AM
Script       : http://www.turbo-mopar.com/forums/timeslips.php
Referrer     : 
IP Address   : 32.60.71.66
Username     : Frank
Classname    : vb_database

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.06378 seconds Memory Usage 2,356KB Queries Executed 25 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (10)bbcode_code (1)bbcode_php (9)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)pagenav_pagelinkrel (11)post_thanks_box (1)post_thanks_box_bit (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (1)post_thanks_postbit (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.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 showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start fetch_musername post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end post_thanks_function_fetch_thanks_bit_start post_thanks_function_show_thanks_date_start post_thanks_function_show_thanks_date_end post_thanks_function_fetch_thanks_bit_end post_thanks_function_fetch_post_thanks_template_start post_thanks_function_fetch_post_thanks_template_end postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

Благодарность от:
too_cool_3

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!