Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 3.5 > vBulletin 3.5 Add-ons
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
vB Timeslip Database - for Automotive websites Details »»
vB Timeslip Database - for Automotive websites
Version: 1.2, by deathemperor deathemperor is offline
Developer Last Online: Jul 2011 Show Printable Version Email this Page

Version: 3.5.4 Rating:
Released: 03-17-2006 Last Update: 12-11-2006 Installs: 180
DB Changes Uses Plugins Template Edits
Code Changes Additional Files  
No support by the author.

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.

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.
Благодарность от:
too_cool_3

Comments
  #432  
Old 12-07-2006, 06:48 PM
TurboLaserAWD TurboLaserAWD is offline
 
Join Date: Dec 2005
Posts: 18
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

If I could just get that customfile table to be added I think I'd be okay. At least for that portion.
Reply With Quote
  #433  
Old 12-07-2006, 06:52 PM
hotwheels hotwheels is offline
 
Join Date: May 2005
Location: Cheyenne, wy
Posts: 1,380
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

If you figure it out bro, please feel free to share, so that those wanting to upgrade to the 3.6 version that was just uploaded, can use it......

I have my site running and can't upload this new .xml........I just don't feel like trouble shooting on my site right now.......Since the hacking of my database, it is runnin pretty smoothly right now.........hehehehe
Reply With Quote
  #434  
Old 12-07-2006, 07:37 PM
fkatzenb fkatzenb is offline
 
Join Date: Dec 2005
Posts: 56
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by hotwheels View Post
hey frank (fkatzenb), i stopped by your site to help, but didn't see ya online there......do me a quick favor if you get this note and go to your severs phpmyadmin, and open up "profilefield", and then click on browse toward's the top of the page.......let me know what it say's in there for fields, 64,60,61,62,63, etc............or tell me if those are even in there....

later hotwheels...... you can shoot me an email or a pm if you would like......your's should be an easy fix.
50 thru 65 exist. 63-65 are arrays... a:3:{etc...}
Reply With Quote
  #435  
Old 12-07-2006, 07:44 PM
TurboLaserAWD TurboLaserAWD is offline
 
Join Date: Dec 2005
Posts: 18
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Alright I made some headway but I'm having problems with the $vbphrase. Here's what I did to correct my problem. I couldn't get rid of the old XML file because the SQL wouldn't let it finish. The problem was that it was trying to remove a table that wasnt there. So I simply took the lines out.

Everything highlighted is what I deleted from the XML and then I saved the file and re-uploaded it.

Code:
$db->query_write("CREATE TABLE " . TABLE_PREFIX . "customfile (
	userid INT UNSIGNED NOT NULL DEFAULT '0',
	filedata MEDIUMTEXT NOT NULL,
	dateline INT UNSIGNED NOT NULL DEFAULT '0',
	filename VARCHAR(100) NOT NULL DEFAULT '',
	visible SMALLINT NOT NULL DEFAULT '1',
	filesize INT UNSIGNED NOT NULL DEFAULT '0',
	PRIMARY KEY (userid))");

  ]]> 
  </installcode>
- <uninstallcode>
- <![CDATA[ 			
	$db->query_write("DROP TABLE " . TABLE_PREFIX . "customfile");
	$db->query_write("ALTER TABLE `" . TABLE_PREFIX . "user` DROP `tdban` ");
	$db->query_write("DELETE FROM `" . TABLE_PREFIX . "profilefield` WHERE `profilefieldid` = '50' LIMIT 1");
	$db->query_write("DELETE FROM `" . TABLE_PREFIX . "profilefield` WHERE `profilefieldid` = '51' LIMIT 1");
	$db->query_write("DELETE FROM `" . TABLE_PREFIX . "profilefield` WHERE `profilefieldid` = '52' LIMIT 1");
	$db->query_write("DELETE FROM `" . TABLE_PREFIX . "profilefield` WHERE `profilefieldid` = '53' LIMIT 1");
	$db->query_write("DELETE FROM `" . TABLE_PREFIX . "profilefield` WHERE `profilefieldid` = '54' LIMIT 1");
	$db->query_write("DELETE FROM `" . TABLE_PREFIX . "profilefield` WHERE `profilefieldid` = '55' LIMIT 1");
	$db->query_write("DELETE FROM `" . TABLE_PREFIX . "profilefield` WHERE `profilefieldid` = '56' LIMIT 1");
	$db->query_write("DELETE FROM `" . TABLE_PREFIX . "profilefield` WHERE `profilefieldid` = '57' LIMIT 1");
	$db->query_write("DELETE FROM `" . TABLE_PREFIX . "profilefield` WHERE `profilefieldid` = '58' LIMIT 1");
	$db->query_write("DELETE FROM `" . TABLE_PREFIX . "profilefield` WHERE `profilefieldid` = '59' LIMIT 1");
	$db->query_write("DELETE FROM `" . TABLE_PREFIX . "profilefield` WHERE `profilefieldid` = '60' LIMIT 1");
	$db->query_write("DELETE FROM `" . TABLE_PREFIX . "profilefield` WHERE `profilefieldid` = '61' LIMIT 1");
	$db->query_write("DELETE FROM `" . TABLE_PREFIX . "profilefield` WHERE `profilefieldid` = '62' LIMIT 1");
	$db->query_write("DELETE FROM `" . TABLE_PREFIX . "profilefield` WHERE `profilefieldid` = '63' LIMIT 1");
	$db->query_write("DELETE FROM `" . TABLE_PREFIX . "profilefield` WHERE `profilefieldid` = '64' LIMIT 1");
	$db->query_write("DELETE FROM `" . TABLE_PREFIX . "profilefield` WHERE `profilefieldid` = '65' LIMIT 1");
	$db->query_write("ALTER TABLE `" . TABLE_PREFIX . "userfield` DROP `field51` ,
			DROP `field52` ,
			DROP `field53` ,
			DROP `field54` ,
			DROP `field55` ,
			DROP `field56` ,
			DROP `field57` ,
			DROP `field58` ,
			DROP `field59` ,
			DROP `field60` ,
			DROP `field61` ,
			DROP `field62` ,
			DROP `field63` ,
			DROP `field64` ,
			DROP `field65`");
I had to change "field51" to "field52" and then delete the whole line that has "field52". This may or may not apply to zincpony it just depends on what tables and fields were created for him.

After I re-uploaded it I was able to do a clean uninstallation of the product. After that I uploaded the new product-timeslips1.2.xml and everything worked fine except for the $vbphrase function. For some reason some of them were giving me problems. I couldn't get the following to show up at all:

Code:
$vbphrase[timeslips]
$vbphrase[edit_timeslips]
$vbphrase[yes]
$vbphrase[no]
$vbphrase[timeslips_keep_current_timeslip]
$vbphrase[timeslips_keep_current_timeslip_define]
$vbphrase[timeslips_upload_timeslip_from_computer]
Reply With Quote
  #436  
Old 12-07-2006, 07:58 PM
hotwheels hotwheels is offline
 
Join Date: May 2005
Location: Cheyenne, wy
Posts: 1,380
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by fkatzenb View Post
50 thru 65 exist. 63-65 are arrays... a:3:{etc...}
Are they named? If you follow the line, are their title's and so forth in there?
Reply With Quote
  #437  
Old 12-07-2006, 08:17 PM
zincpony zincpony is offline
 
Join Date: Nov 2006
Location: Media, PA
Posts: 86
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

mine is just crapping on me, the only input field that shows up is the HorsePower field and the ability to upload a timeslip but nothing else, they vanished somewhere.
Reply With Quote
  #438  
Old 12-07-2006, 08:31 PM
TurboLaserAWD TurboLaserAWD is offline
 
Join Date: Dec 2005
Posts: 18
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Okay I dunno how it happened but my phrases worked themselves out so now I'm all good.
Reply With Quote
  #439  
Old 12-07-2006, 08:34 PM
zincpony zincpony is offline
 
Join Date: Nov 2006
Location: Media, PA
Posts: 86
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

im still missing all my fields.
Reply With Quote
  #440  
Old 12-07-2006, 08:41 PM
zincpony zincpony is offline
 
Join Date: Nov 2006
Location: Media, PA
Posts: 86
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

how can i manually remove this from my database completely, cause no uninstall was provided.
Reply With Quote
  #441  
Old 12-07-2006, 10:30 PM
TurboLaserAWD TurboLaserAWD is offline
 
Join Date: Dec 2005
Posts: 18
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Go into your database in phpMyAdmin, then go into the "profilefileds" table and click "Browse" at the top. Delete fields 50-65. Then go to the "userfields" table and do the same thing.

That's actually an incomplete way. I would recommend re-importing the original product-timeslips.xml file and then follow my directions here: https://vborg.vbsupport.ru/showpost....&postcount=434
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 03:31 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05573 seconds
  • Memory Usage 2,345KB
  • Queries Executed 27 (?)
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
  • (2)bbcode_code
  • (1)bbcode_php
  • (3)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_postinfo_query
  • fetch_postinfo
  • 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