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.

[hotwheels]

I gotcha man..........kewl

[Sidewindr]

The problem with the profile field titles is that the php that generates the timeslip profile page needs changing to pull the names from the phrases not the profilefield table.

[wottech]

Originally Posted by Sidewindr

The problem with the profile field titles is that the php that generates the timeslip profile page needs changing to pull the names from the phrases not the profilefield table.

I was wondering what the deal with that was. I just looked at the list that was posted a page or 2 ago and entered all of the data manually via phpMyAdmin. Before that, everything just showed up as "aa:" and "a:". I figured it was something I had screwed up or missed in the instructions. I never looked into what the code was doing though...

[hotwheels]

That's kind of wierd in a way, i just did a fresh install with smokinz28 yesterday, on a site that didn't have timeslips on the site...when completed, it worked out perfectly: http://www.f-bodyhideout.com/forums/timeslips.php?

It has all of the wording, and accept's all of the comands. I even put in my car's timeslip information and it took........I am wondering if my instruction's are kind of confusing since this post is all over the place? I had thought about doing a new thread for vb3.6 since it does update to vb3.6....

The one bit of confusion that i have noticed is about my query run's. If you go to your phpmyadmin, and look in the left hand column for profilefield, you will have to see what your field is named. My profilefield in phpmyadmin is vb3profilefield, some are vbprofilefield, and other's are just profilefield...you need to set the intitial queries to this setting as such:

PHP Code:

ALTER TABLE `vbprofilefield` ADD `title` VARCHAR( 25 ) DEFAULT 'aa' NOT NULL AFTER `profilefieldid` ; 


or

PHP Code:

ALTER TABLE `vb3profilefield` ADD `title` VARCHAR( 25 ) DEFAULT 'aa' NOT NULL AFTER `profilefieldid` ; 


or

PHP Code:

ALTER TABLE `profilefield` ADD `title` VARCHAR( 25 ) DEFAULT 'aa' NOT NULL AFTER `profilefieldid` ; 


all this query is doing is adding the word "title" back to the profilefield, it was there on previous version's of vbulletin, but has been removed.

Then the second query is basically the same, you need to see what your profilefield name is, just like above:

PHP Code:

ALTER TABLE `profilefield` ADD `description` VARCHAR( 250 ) DEFAULT 'a' NOT NULL AFTER `title` ; 


or

PHP Code:

ALTER TABLE `vb3profilefield` ADD `description` VARCHAR( 250 ) DEFAULT 'a' NOT NULL AFTER `title` ; 


or

PHP Code:

ALTER TABLE `vbprofilefield` ADD `description` VARCHAR( 250 ) DEFAULT 'a' NOT NULL AFTER `title` ; 


All this query is doing is adding the word "description" back to the profile field, again, it was there on previous version's of vbulletin, but has been removed from vb3.6.

These 2 queries, need to be the very first thing you do in order to not get confused on what is happening here. Then, after you run these 2 queries, make the following file edit's:
###### 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';
}



###### 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
");




###### In includes/functions_user.php find:

'signature',
'profile',



###### Add below:

'vehicleprofile',


###### Find:

// ###################### Start getprofilefields #######################
function fetch_profilefields($formtype = 0) // 0 indicates a profile field, 1 indicates an option field
{

global $vbulletin, $stylevar, $customfields, $bgclass, $show;
global $vbphrase, $altbgclass, $bgclass1, $tempclass;

// get extra profile fields
$profilefields = $vbulletin->db->query_read_slave("
SELECT * FROM " . TABLE_PREFIX . "profilefield
WHERE editable IN (1,2)
AND form " . iif($formtype, '>= 1', '= 0'). "
ORDER BY displayorder
");




###### Replace it with:

// ###################### Start getprofilefields #######################
function fetch_profilefields($formtype = 0) // 0 indicates a profile field, 1 indicates an option field
{

global $vbulletin, $stylevar, $customfields, $bgclass, $show;
global $vbphrase, $altbgclass, $bgclass1, $tempclass;

// get extra profile fields
$profilefields = $vbulletin->db->query_read_slave("
SELECT * 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 editable IN (1,2)
AND form " . iif($formtype, '>= 1', '= 0'). "
ORDER BY displayorder
");


###### In your USERCP_SHELL template find:

<tr>
<td class="$navclass[profile]" nowrap="nowrap"><a class="smallfont" href="profile.php?$session[sessionurl]do=editprofile">$vbphrase[edit_profile]</a></td>
</tr>



###### Below it add:

<tr>
<td class="$navclass[vehicleprofile]" nowrap="nowrap"><a class="smallfont" href="profile.php?$session[sessionurl]do=edittimeslip">$vbphrase[edit_timeslip]</a></td>
</tr>




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

Once these edit's are completed and saved back into your site's database, upload timeslips.php to your forum's root directory (/forums/) then // Upload slipicon.gif to your forum's misc image directory (/forums/images/misc/) or what ever your forums root directory is. Mine happen's to be forums/.....

After all of this has been done, you will now Go to your product link, then add new product by uploading the product-timeslips.xml file.

If you did this step by step, you shoudn't see the "aa" or the "a"......

However, if you have already run the query and are having issue's with this not showing correctly, go back to your phpmyadmin, open the profilefield, and look to see if you have the word "title" and "description" in there. If so, put a check mark in front of "title" and "description", and look up just a bit and click on the word "drop", this will remove "title" and "description" from your server. With that done, run the query that best fit's your site from the above queries (Still in phpmyadmin), look at the left navigation bar, and up at the top, the third icon over "sql", is where you need to run the queries from.

After you have rerun the queries, and you know for sure that you have all the file edit's done, go back to your admincp, and rerun the product timeslips.xml, and select overwrite......now check your www/yoursite/forums/timeslips.php and see what is there, and then click on submit your timeslip at the bottom of the box that appears.....It may take about 15 minutes to reupdate depending on the size of your site, but it WILL work......

hotwheels

[fkatzenb]

I havent stayed up on this thread and am now confused.... what do I need to do to mine? Thanks!!!!!!!!!!!!!!!!!!!!1
http://www.turbo-mopar.com/forums/timeslips.php



Frank

[rx_1badbird]

I'm so lost I need a compass to get back. lol
A new thread relating to 3.6.3 would rawk!
Thanks.

[hotwheels]

Just use this thread that i made a few post's back..... how to

[Sidewindr]

Rather than re-adding the titles into the profilefield it would be far better for soomeone to fix the section of code in the xml that calls the profile fields and titles to address the titles in their new location. I have had a look but it is beyond my abilities

[wottech]

Ok, here is an updated product XML. From what I saw, there was an error in the ALTER TABLE syntax when setting the default values. So I just removed that part of the SQL and it worked.

FYI, I am currently running 3.6.3, so it appears to be working on that.

[Zachariah]

I'll take a look, wottech
Thanks.