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

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

- vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)

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

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

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.

Not working.

Is this an upgrade, or for fresh installs????

Thanks, all installed and seems to work fine so far! :)

Been testing this hack for over a month and it all works great

http://www.ls6.com.au/forum/timeslips.php

When trying to import product-timeslips.xml I get this error:

Code:

Invalid SQL:

SELECT * FROM user WHERE tban=1;



MySQL Error  : Unknown column 'tban' in 'where clause'

I do not have an existing installation of vbTimeslips.

Quote:

Originally Posted by kahmeal

When trying to import product-timeslips.xml I get this error:

Code:

Invalid SQL:

SELECT * FROM user WHERE tban=1;



MySQL Error  : Unknown column 'tban' in 'where clause'

I do not have an existing installation of vbTimeslips.

Please do it again using this xml file.

the above zip is updated too.

Thanks! I can finally upgrade to VB 3.5!!!!

deathemperor,

I just made a donation to your paypal (listed above) for $50US as a big "THANK YOU".

Gary

Excellent, your new .xml file worked flawlessly! One last issue, you forgot to include slipicon.gif with the zip file. I grabbed it from garycutri's ls6.com link but you might want to throw it in the original zip ;) Great work and thanks!!!

@Gary: Thanks a bunch !

@kahmeal: thanks for pointing it out. There always seems to have problems :(

First and foremost, thank you for providing this hack. I've been waiting for this one for a while. Now hopefully we can get mine working. :banana:

Here is an error that I'm getting:

Quote:

Database error in vBulletin 3.5.0:

Invalid SQL:

INSERT INTO vb3_setting
(varname, grouptitle, value, defaultvalue, datatype, optioncode, displayorder, advanced, volatile, product)
VALUES
(
'allowtimeslipupload',
'timeslips',
'1',
'1',
'boolean',
'yesno',
10,
0,
1,
'timeslips'
),
(
'tdmaxwidth',
'timeslips',
'600',
'600',
'free',
'',
20,
0,
1,
'timeslips'
),
(
'tdmaxheight',
'timeslips',
'600',
'600',
'free',
'',
30,
0,
1,
'timeslips'
),
(
'tdmaxsize',
'timeslips',
'80000',
'',
'free',
'80000',
40,
0,
1,
'timeslips'
),
(
'tdsliprequired',
'timeslips',
'10.00',
'',
'free',
'',
50,
0,
1,
'timeslips'
);

MySQL Error : Duplicate entry 'allowtimeslipupload' for key 1
Error Number : 1062
Date : Saturday, March 18th 2006 @ 12:49:18 PM

Any help would be greatly appreciated!

Thank you,
Tim

That means you are upgrading from the old version. As mentioned above I never had a chance to try the upgrade. If anyone can give me a test site (forum 3.5 with timeslips 3.0), that would be great for making the installer work on upgrade.

Quote:

Originally Posted by deathemperor

< DOH! >

My site would be a good tester :-) I have a lot of prior timeslips in the database :banana:

Feel free to contact me on AOL IM: Blown284

thanks,
Tim

Quote:

Originally Posted by garycutri

Been testing this hack for over a month and it all works great

http://www.ls6.com.au/forum/timeslips.php

Nice site!

Is this Hack Phrased where it could be ported to other Community Themes?

Quote:

Originally Posted by tteal

< DOH! >

My site would be a good tester :-) I have a lot of prior timeslips in the database :banana:

Feel free to contact me on AOL IM: Blown284

thanks,
Tim

I don't user AIM. you can pm me information needed for testing.

@MillerLight: it is not fully phrased I think. that can be changed, soon :).

Quote:

Originally Posted by MillerLight

Is this Hack Phrased where it could be ported to other Community Themes?

It is now fully phrased. I didn't make the vehicle tech words to be phrase because I think in whatever language they are still so.

Death,

Thanks for the quick turn around. This hack now that it is fully phrased can be used for a large variety of community themes :banana:

Clicked Install!

Death,

What did you mean to express by the below statement? The actual part of your statement that I didn't get your meaning to is highlighted below.

Quote:

It is now fully phrased. I didn't make the vehicle tech words to be phrase because I think in whatever language they are still so.

I meant the values like:
1/4 Mile MPH, 10 Sec Club, etc.

Death,

Just so I am clear, those values you listed above, are they Changeable or Non Changeable by altering the phrases?

Thanx ;)

they are changeable by editing the templates for now.

Question #1: Do you have to have attachments enable for members in order for the upload timeslip feature to work?

Because I am getting a blank page when trying to view a time slip image.

Question #2: Can you or anyone make hooks/plugins for these code modifications?

Question #3: Is there a way to get a confirmation that the info has been saved instead of defaulting back to the edit page? It fooled me the first time as I re-entered the info again thinking I missed something.

Thanks in advance.

#1: No
#2: For what purpose ?
#3: Are you using firefox ? firefox save input fields, try it on IE which does not.

Hi death, absolutely spectacular work here, however I'm having a small issues, seems whenever my members input an ET above 10 it reverts it to 9.999. Just wondering how I get around this?

Regardz :)

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

I have the modd'ed 3.5 version installed.. ill click install that way i can help with questions..

Yeah, I seemed to have fixed it by changing the data type to decimal (6,3)

Regardz :)

Quote:

Originally Posted by tteal

Nice site!

Thanks :)

There's a few bugs ..

1. The enforcement for uploading of image if under the set time does not appear to work.
2. The maximum timeslip image size is not changeable in the admincp
3. The users hopepage on the Details page shows up as the user looking at the details not the user.
4. The timeslip pic that comes up is the users avatar in my case.
5. The DECIMAL values for fields 52,53 and 55 should be DECIMAL(6,3) NOT DECIMAL(4,3) in the XML Installer File.
6. Hooks would be much better than file edits :)

The fix for #3 is to change the following in getvehicleinfo template..

FROM

Code:

<tr>

        <td class="alt1" width="50%">

                <strong>$vbphrase[timeslips_homepage]</strong>:

</td>

<td class="alt2" width="50%">

                $homepage

        </td>

</tr>

Code:

<if condition="$show['homepage']">

        <tr>

                <td class="alt1" width="50%">

                        <strong>$vbphrase[timeslips_homepage]</strong>:

                </td>

        <td class="alt2" width="50%">

                <a href="$userinfo[homepage]" target="_blank" dir="ltr">$userinfo[homepage]</a>

        </td>

        </tr>

</if>

Brilliant!!! Worked first time on 3.5.4 no problems at all :banana:

Just put in a test entry and seems to be working all good!

http://www.ozls1.com.au/forum/timeslips.php?

Great install instructions...especially for a VB NOOB!!!

Thx again!!

I'm using the patched version of vB 3.5.3 and it works like a charm
(The link is in my sig if anyone cares)

It's a really simple install, which is a nice bonus too.

Thanks man!

Quote:

Originally Posted by Sidewindr

3. The users hopepage on the Details page shows up as the user looking at the details not the user.

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.

Mine works just fine so thanks and great hack.

If I can be cheeky and suggest some additions -

Change the HP to BHP as opposed to Power at wheels. (or add another section).

Have another choice - Front Wheel Drive, 4 Wheel Drive, Rear Wheel Drive

Have another choice for car models, with Admin being allowed to add new Car Models in the Admin CP.

:banana:

Quote:

Originally Posted by MoveOver.cc

From admincp go to "User Profile Fields" and select "User Profile Field Manager" and you can make changes to the fields (e.g. Add extra options to the Induction drop down box etc.). I also removed altitude and added a Tuner/Workshop field.

Quote:

Originally Posted by Sidewindr

Code:

<tr>

        <td class="alt1" width="50%">

                <strong>$vbphrase[timeslips_homepage]</strong>:

</td>

<td class="alt2" width="50%">

                $homepage

        </td>

</tr>

Code:

<if condition="$show['homepage']">

        <tr>

                <td class="alt1" width="50%">

                        <strong>$vbphrase[timeslips_homepage]</strong>:

                </td>

        <td class="alt2" width="50%">

                <a href="$userinfo[homepage]" target="_blank" dir="ltr">$userinfo[homepage]</a>

        </td>

        </tr>

</if>

Hi folk.

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

#2: fixed

#3: fixed

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

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

#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.

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

@Thanks Gary for helping me support this hack while I'm away :up:

Quote:

Originally Posted by deathemperor

#1: No
#2: For what purpose ?
#3: Are you using firefox ? firefox save input fields, try it on IE which does not.

#1, For reason I get a blank screen. hrrrmmm

#2 For the purpose of not having to re-edit files everytime I upgrade vBulletin.

#3 I am using IE, it does save the info, It just doesn't let you know it did. Is there anyway to make it show a "all info saved page" then redirect to the timeslip page?

I'm found one hiccup.

When I'm trying to get to the timeslip database from CMPS, which is outside of the forum directory, it brings up

Quote:

Warning: main(./global.php): failed to open stream: No such file or directory in /home/xxxxxxx/public_html/timeslips.php on line 35

Fatal error: main(): Failed opening required './global.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/xxxxxxxx/public_html/timeslips.php on line 35

To fix this, change the line that you put into your navbar to:
(I've hilighted the part you need to add if you just want to add it in)

Code:

<td class="vbmenu_control"><a href="/forum/timeslips.php?$session[sessionurl]">$vbphrase[timeslips]</a></td>

Quote:

Originally Posted by tommyxv

#1. I can't hardly tell what's the problem then because as for the demo site it is working without any problem for a month before it is released here.

#2. You know I hate the truth that hack need file editions. But this hack does requires 2 and those are not possible to remove AFAIK. Anyway try reading my first post for the reason why. Those editions are still optional = without it the hack still works.

#3. To see the saved message notification, make sure to enable "redirect message" on your vbulletin options.

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02216 seconds Memory Usage 1,872KB 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 (7)bbcode_code_printable (1)bbcode_php_printable (15)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (40)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: