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)

Just an FYI...

I am in the process of installing this hack on one of the largest automotive VB sites...

and thought, this would be a great opportunity to update this hack a little bit and fix some of the nagging errors, as well as add some bells and whistles.

the upgrade would incorporate omong other things the features listed here: https://vborg.vbsupport.ru/showpost....&postcount=616

I've tried many times to get in contact with the author but he's obviously abandoned this project.

I'm not quit sure what the rules are here regarding discussing and planning modifications & updates.. so if someone knows what the protocol is, let me know. Ideally I'd like to start a thread to further this discussion, but I'm not sure where to put that thread.. any help?

Post 616 describes the necessary changes to the field in the database, but what would the correct SQL command be to do it manually from within vbadmin?

I'm a MS SQL programmer and have not looked up the MySQL equivalent.

John

Quote:

Originally Posted by john.friel (Post 1376929)

I have direct access to the server and a GUI interface, so it was as a easy as point and click for me.

but being a developer myself, the correct SQL query is:
ALTER TABLE userfield MODIFY COLUMN Field55 Decimal(5,3);

Reference:
http://dev.mysql.com/doc/refman/5.0/en/alter-table.html

Field55 may be different in your installation, so make sure it refers to the data column for the 1/4 ET and/or 1/8 ET

Back up your table/DB before attempting any schema alterations, I take absolutely no responsibility for the code above, and have not tested or verified it's compatibility on any system.

.

Thanks, that is just the ticket. It worked just fine!

John

im having major issues with this mod. i have 3.6.4 and have done exactly as told on here and im running into all these problems now. im getting tons of database errors. from user profiles to admincp im getting nothing. this is a poor hack in that the directions arent very good to begin with, and now im stuck trying to reverse the process of installation. if anyone can help email me at DBYRD@quicksilvertrucks.com please. if nothing else id like to reinstall the stock files, does anyone know how to do this?

I know I've asked in the past, but it kind of got lost in the shuffle.

I'd love to have a vBAdvanced module that shows the top 5 Users, vehicle info and 1/4 mile ET & MPH.

Any chance someone could point me in the right direction as far as how to call this stuff up?...... or better yet, already have something made?

(running vB 3.6.8-rc2 and vBA 3.0-rc2)

EDIT:
Sidwindr made on for the old version back in 2004 (http://www.vbadvanced.com/forum/show...ight=timeslips) be we don't have one that works with the new version

Quote:

Originally Posted by webgod (Post 1376911)

The original author, EvilLS1 gave permission to port this hack
https://vborg.vbsupport.ru/showpost....&postcount=666

So you could start from there, add new features and release it as your own.

Quote:

Originally Posted by webgod (Post 1376937)

Back up your table/DB before attempting any schema alterations, I take absolutely no responsibility for the code above, and have not tested or verified it's compatibility on any system.

.

So does running this query fix the <10.00s times going to the bottom of the list???

Quote:

Originally Posted by too_cool_3 (Post 1380750)

So does running this query fix the <10.00s times going to the bottom of the list???

yes

Quote:

Originally Posted by 0ptima (Post 1212153)

I should have posted the steps I took when I did the conversion, but I did find some notes I took. I highly recommend that you test this out on a backup and use the following as a reference!

Code:

3.0 removal



//All old templates removed



//All old phrases removed



//Delete dfrom admin cp



DELETE FROM `settinggroup` WHERE CONVERT(`settinggroup`.`grouptitle` USING utf8) = 'timeslips' LIMIT 1;



DELETE FROM `setting` WHERE CONVERT(`setting`.`varname` USING utf8) = 'allowtimeslipupload' LIMIT 1;

DELETE FROM `setting` WHERE CONVERT(`setting`.`varname` USING utf8) = 'tdmaxwidth' LIMIT 1;

DELETE FROM `setting` WHERE CONVERT(`setting`.`varname` USING utf8) = 'tdmaxheight' LIMIT 1;

DELETE FROM `setting` WHERE CONVERT(`setting`.`varname` USING utf8) = 'tdmaxsize' LIMIT 1;

DELETE FROM `setting` WHERE CONVERT(`setting`.`varname` USING utf8) = 'tdsliprequired' LIMIT 1;





//userfields to change..... (May only needed if you have the 3.0 - 3.05 version of the //hack. The 3.06 hack has these changes)



ALTER TABLE `userfield` CHANGE `field50` `field50` CHAR(250) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, CHANGE `field57` `field57` CHAR(250) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, CHANGE `field58` `field58` CHAR(250) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, CHANGE `field59` `field59` CHAR(250) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, CHANGE `field60` `field60` CHAR(250) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, CHANGE `field61` `field61` CHAR(250) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, CHANGE `field62` `field62` CHAR(250) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, CHANGE `field63` `field63` CHAR(250) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, CHANGE `temp` `temp` CHAR(250) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, CHANGE `field64` `field64` CHAR(250) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, CHANGE `field65` `field65` CHAR(250) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, CHANGE `field68` `field68` CHAR(250) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, CHANGE `field69` `field69` CHAR(250) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL





RENAME TABLE `tmp`.`customtimeslippic` TO `tmp`.`customfile` ;



// may not be needed!!!!!!!! (dont remember why)

ALTER TABLE `customfile` CHANGE `timeslippicdata` `filedata` MEDIUMTEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL





// needed for 3.6

https://vborg.vbsupport.ru/showp...&postcount=374





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



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

I also had to modify the product file, which I have attached
I remember having problem with the phrases and had to edit and re save one of them and then the all worked. Take a look at this post....
https://vborg.vbsupport.ru/showpost....&postcount=556

I am just now getting around to trying to deleting the 3.0 version of this hack.

Wish me luck!

Thanks!

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (5)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (3)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)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:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01981 seconds Memory Usage 1,763KB 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 (1)bbcode_code_printable (5)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (3)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)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: