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.

[Black Hole]

I recently upgraded to 3.6.7 PL1. In an attempt to fix a couple of problems, I reverted a couple of my templates and lost the navbar link to the Timeslip Hack.

In going through this thread, I downloaded the 3.6 version 1.2, unzipped the file, and attempted to import the XML file with overwrite checked and I receive a database error when doing so.

I receive the following error...

Database error in vBulletin 3.6.7:

Invalid SQL:
INSERT INTO profilefield (profilefieldid,required,hidden,maxlength,size,dis playorder,editable,type,data,height,def,optional,s earchable,memberlist,regex,form,html) VALUES
(50,0,0,'20','20','50','1','input','','0','0','0', '0','0','0','','0');

MySQL Error : Duplicate entry '50' for key 1
Error Number : 1062
Date : Sunday, July 22nd 2007 @ 11:45:06 PM
Script : removed
Referrer : removed
IP Address : removed
Username : Black Hole
Classname : vb_database

This is an upgrade as I'm currently running 3.5.0.

Please advise.

Thanks,

Matt.

[webgod]

Originally Posted by Black Hole

I recently upgraded to 3.6.7 PL1. In an attempt to fix a couple of problems, I reverted a couple of my templates and lost the navbar link to the Timeslip Hack.

In going through this thread, I downloaded the 3.6 version 1.2, unzipped the file, and attempted to import the XML file with overwrite checked and I receive a database error when doing so.

I receive the following error...



This is an upgrade as I'm currently running 3.5.0.

Please advise.

Thanks,

Matt.

The error is that you are inserting a duplicate record into the table, that requires it be a unique (primary key)



all you need to do to put the link back into the nav bar is follow this in the instructions:

PHP Code:

###### In your navbar template find:

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



###### Below it add:

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


[webgod]

Originally Posted by calgdsm

from what i can tell there is no support with this product, so i say go for it. Could you start a new thread for it?

I'd love to...


but I'd still like the permission of the author.. or an OK from a Moderator.

I don't want to step on anyones toes.

[Black Hole]

Originally Posted by webgod

The error is that you are inserting a duplicate record into the table, that requires it be a unique (primary key)



all you need to do to put the link back into the nav bar is follow this in the instructions:

PHP Code:

###### In your navbar template find:

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



###### Below it add:

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


Thanks!!!!:up:

[0ptima]

I upgraded my 3.6.4 board to 3.6.8 and there are some differences in the vb code that you need to change.

In the 3.6.x hack it says:

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

In 3.6.8 it should say:

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

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

###### REPLACE IT WITH:

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

In the 3.6.x hack it says:

###### In member.php find:
// *********************
// 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, 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
");

In 3.6.8 it should say:

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

###### Replace it with:
    // CUSTOM PROFILE FIELDS
$profilefield_categories = array(0 => array());
    $profilefields_result = $db->query_read_slave("
        SELECT pf.profilefieldid, pf.profilefieldcategoryid, pf.required, pf.type, pf.data, pf.def, pf.height
        FROM " . TABLE_PREFIX . "profilefield AS pf
        LEFT JOIN " . TABLE_PREFIX . "profilefieldcategory AS pfc ON(pfc.profilefieldcategoryid = pf.profilefieldcategoryid)
        WHERE pf.profilefieldid NOT IN (50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65) AND pf.form = 0 " . iif(!($permissions['genericpermissions'] & $vbulletin->bf_ugp_genericpermissions['canseehiddencustomfields']), "
                AND pf.hidden = 0") . "
        ORDER BY pfc.displayorder, pf.displayorder
    ");

Everything seems to work ok except for the timeslip upload. There are no errors, the slip just does not show up. Ive attached the complete updated instructions.

[Devilbrad]

Everything works fine on my board with 3.6.7 except if I click a username to view their profile I get this error message.

Database error in vBulletin 3.6.7:

Invalid SQL:

SELECT pf.profilefieldid, pf.profilefieldcategoryid, pf.required, pf.type, pf.data, pf.def, pf.height
FROM profilefield AS pf
LEFT JOIN profilefieldcategory AS pfc ON(pfc.profilefieldcategoryid = pf.profilefieldcategoryid)
WHERE pf.profilefieldid NOT IN (50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65 AND pf.form = 0
ORDER BY pfc.displayorder, pf.displayorder;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY pfc.displayorder, pf.displayorder' at line 5
Error Number : 1064
Date : Saturday, August 11th 2007 @ 03:24:25 PM
Script : http://www.devilbrad.com/member.php?find=lastposter&f=5
Referrer : http://www.devilbrad.com/index.php
IP Address : 68.127.148.159
Username : Devilbrad
Classname : vb_database

What have I done wrong???

[0ptima]

There is a missing bracket on this line

PHP Code:

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


It should say this

PHP Code:

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


I update the instructions I posted for VB 3.6.8

[Devilbrad]

Sweet! Got it working now! Thanks! I also upgraded to 3.6.8 and because of all the posts about losing info in this thread, thought I would share what I do. I save a list of all my php edits in a seperate folder thats easy to read, each text file is the name of the php file in my database that needs to be changed (basically cut and paste the specific instructions from each mod). When a new version of vBB comes out, I edit all the php files before uploading to my server and never get a mishap or lose stuff.

[Eclipsed830]

Does anyone know if there is a way to include an if statement in the members profile to display timeslip info?

[webgod]

Originally Posted by Eclipsed830

Does anyone know if there is a way to include an if statement in the members profile to display timeslip info?

Definitely.. I put it in the postbit template.

here is my post with all the info filled in:
http://www.chicagosvt.com/forums/sho...&postcount=127

and here are examples of various stages of completed info:
http://www.chicagosvt.com/forums/sho...d.php3?t=23654


here's a snipet of my postbit template to get you started:

<if condition="$post['field50']">
<p >
<hr color="#000000" size="1" width="100%">
<div class="smallfont">

<if condition="$post['field50']"><b>Vehicle:</b> $post[field50]</if>

&nbsp;&nbsp;&nbsp;

<if condition="$post['field51'] and $post['field51'] != '0.0'"><b>HP:</b> $post[field51]
</if>

&nbsp;&nbsp;&nbsp;

<if condition="$post['field66'] and $post['field66'] != '0.0'"><b>TQ:</b> $post[field66]
</if>

&nbsp;&nbsp;&nbsp;

<if condition="$post['field55'] and $post['field55'] != '0.00'"><b>1/4 Mile:</b> $post[field55]</if><if condition="$post['field56'] and $post['field56'] != '0.00'">@ $post[field56]
</if>

</div>
<hr color="#000000" size="1" width="100%">
</p>
</if>