vb.org Archive

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)

ArchangelX 01-14-2007 11:00 PM

Great mod...I love it!

Is there any way to code a difference in Motorcycles and Cars? Like, an option to Sort by it? I guess you would have to add a check box for Car or Bike?

Silver_2000_)! 01-17-2007 03:15 PM

never mind

deathemperor 01-17-2007 03:24 PM

everyone can see that there're a lot of customises in his templates, aren't you seeing that too ? Even vbulletin.com/forum has their templates customized, the only board that has no customize template is the one you just finished the final vbulletin installation step.

try looking into his HTML source code and you'll see.

Silver_2000_)! 01-17-2007 03:53 PM

Quote:

Originally Posted by deathemperor (Post 1161497)
everyone can see that there're a lot of customises in his templates, aren't you seeing that too ? Even vbulletin.com/forum has their templates customized, the only board that has no customize template is the one you just finished the final vbulletin installation step.

try looking into his HTML source code and you'll see.

yeah my mistake - and I have more xhtml problems than he does

Are there instructions on how to rip out the previous versions ?
Im tired of having db errors and a product that only partly works

when I try to run the xml it errors out with the profile 50 errors

deathemperor 01-17-2007 03:56 PM

paste here the errors and I'll look at it sometimes. I'm too busy with my real life, there're many problems that I've been undergoing...

Silver_2000_)! 01-17-2007 04:35 PM

Quote:

Originally Posted by deathemperor (Post 1161515)
paste here the errors and I'll look at it sometimes. I'm too busy with my real life, there're many problems that I've been undergoing...

I removed the duplicate table entries and got the xml install to run without error - BUT now
just like user on previous page I'm now getting

Code:

Invalid SQL:
SELECT COUNT(*) AS users
                                    FROM user AS user, userfield AS userfield
                                   
                                      WHERE userfield.field55>0
                                    AND user.userid = userfield.userid;

MySQL Error  : Unknown column 'userfield.field55' in 'where clause'
Error Number : 1054


Silver_2000_)! 01-17-2007 04:42 PM

for those of you with duplicate entry errors uploading the xml - I finally gave up on keeping the old data and wiped the following form my db

BACKUP EVERYTHING BEFORE YOU START -
CALL SOMEONE WHO KNOWS WHAT THEY ARE DOING

NO warranty is implied or expected here - this is what I did after waitibg for 18 months to get this working correctly. No I have one error left - above


from settings table remove the
tdsliprequired
'allowtimeslipupload',
'tdmaxwidth',
'tdmaxheight',
tdmaxsize

from profilefield
remove rows 50 and above

remove table
customfile

from usertable
remove tdban

from user field
remove columns 50 and above


tarionyx 01-17-2007 05:09 PM

well i started to get your problem also, and here's what I did to fix it...

Went into the database, and also removed any timelips reference from vB_products, vb_productcode. Then I reinstalled the latest XML and everything is working fine afaik

hope this helps!

Silver_2000_)! 01-17-2007 05:17 PM

Quote:

Originally Posted by tarionyx (Post 1161556)
well i started to get your problem also, and here's what I did to fix it...

Went into the database, and also removed any timelips reference from vB_products, vb_productcode. Then I reinstalled the latest XML and everything is working fine afaik


hope this helps!

YES
that was it - there was a reference to timeslips 1.0 in the products table
so following your advice I removed 2 entries from one table and one from the other and reinstalled and now its working
THANKS

Silver_2000_)! 01-17-2007 05:24 PM

well
the errors are gone and the timeslips.php file now shows correctly - Its blank
And when I try to save an entry
it wont display
Any ideas ?

EDIT

It appears that most of the fields are required but generate no error when left blank

Its working now

zincpony 01-22-2007 08:33 PM

how do i manually remove all traces of the add-on from the database to try to reinstall this cause no matter what something or otherwill not work???

Fastbird 01-27-2007 11:58 PM

I'm having trouble with the TD on vbulletin 3.5.0 (I know, I know). I've spent a lot of time manually cleaning everything out, and got the latest .xml file to load. The timeslip database displays correctly, but whenever anyone clicks to "upload a timeslip" or edit their vehicle profile, the following error comes up:

Quote:

xxxx, you do not have permission to access this page. This could be due to one of several reasons:

1. Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
2. If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.
Ideas???? It's frustrating because this is SO close to working on our site again. Thanks.

*Edit* I've been searching and searching, and even tried uninstalling and reinstalling and it still won't work, same error every time.

*Edit #2* Never mind, I got it working. There was an old piece of coding in the profile.php file from the vb2.0 era. Found and deleted that and all is well. GREAT JOB!!!!

0ptima 01-28-2007 05:30 PM

I have 3.0 version of the timeslip hack on my site and I just upgraded my VB to 3.6.4. Id I upgrade the hack to the 3.5 version and then the 3.6 version, will my timslip data be preserved? Did anyone upgrade their timeslips from 3.0 to 3.5 ?

burntire 01-30-2007 05:19 AM

My 1/4 and 1/8 mile ET's are not sorting correctly.

It is placing the double digits ET's above the single digits.

9.75 is the fastest time, but it is listed as the slowest.

If I make it 09.75 it sorts correctly.

Also the single digit cars are not showing up when selected.

Any suggestion?

Here is a link

http://www.highperformancestangs.com...timeslips.php?

burntire 01-30-2007 09:41 PM

Anyone?

Eclipsed830 02-02-2007 01:12 AM

I'm also having issues with mine, this is what it looks like at the page at the button of the user cp...

https://vborg.vbsupport.ru/external/2007/02/36.gif

And after I hit submit, it looks like this, should I get like a notice that it was successful?

https://vborg.vbsupport.ru/external/2007/02/37.gif

??

The site address is http://clevelandracing.com/forums/

deathemperor 02-02-2007 01:20 AM

it's because the phrases aren't displaying. To fix this search for "timeslips" in phrases manager and then edit and just click save even you don't modify anything. That should fix it.

Eclipsed830 02-02-2007 02:17 AM

Yep, that fixxed it, thanks. :)

Eclipsed830 02-02-2007 02:48 AM

Ok, now is their a way to allow people to enter more info for the What do you drive field? Right now it seems like its limited to 25 charactors

deathemperor 02-02-2007 02:53 AM

you can edit the "what do you drive" profile field in ACP to allow more characters input.

HMBeaty 02-02-2007 02:55 AM

This DOES work on 3.6.4 for a fresh install of the timeslip database with no issues right?

deathemperor 02-02-2007 03:14 AM

Quote:

Originally Posted by Sal Collaziano (Post 1157816)
My Cadillac Timeslips page isn't extending all the way to the right. It sort of cuts off a little past midway on my screen. I suppose it'll look different depending on your resolution..

Does anyone know what could have gone wrong?

Thanks...

I found that the problem is from my hack, to fix it you can replace "timeslips" template with this:

HTML Code:

$stylevar[htmldoctype]
<html dir="$stylevar[textdirection]" lang="$stylevar[languagecode]">
<head>
<meta name="description" content="$foruminfo[description]" />
<title>$vboptions[bbtitle] - $vbphrase[timeslips_database]</title>
$headinclude
</head>
<body>
$header
$navbar
<table class="tborder" cellpadding="0" cellspacing="0" border="0" bgcolor="0" width="100%" align="center">
<tr><td>
        <table cellpadding="$stylevar[cellpadding]" cellspacing="0" border="0" width="100%">
                <tr id="cat">
                        <td class="tcat"><b> $vbphrase[timeslips_database]</b>
                        </td>
                        <td align="$stylevar[right]" class="tcat">
                                <form name="whatever" style="display:inline;">
                                <script language="javascript" type="text/javascript">
                                <!--
                                function go()
                                {
                                location=document.whatever.example.
                                options[document.whatever.example.selectedIndex].value
                                }
                                //-->

                                </script>
                                <select name="example" size="1" onchange="go()">
                                <option value="">$vbphrase[timeslips_sort_by]:</option>
                                <option value="timeslips.php?$session[sessionurl]&amp;do=quarter">1/4 Mile ET</option>
                                <option value="timeslips.php?$session[sessionurl]&amp;do=quartermph">1/4 Mile MPH</option>
                                <option value="timeslips.php?$session[sessionurl]&amp;do=eighth">1/8 Mile ET</option>
                                <option value="timeslips.php?$session[sessionurl]&amp;do=eighthmph">1/8 Mile MPH</option>
                                <option value="timeslips.php?$session[sessionurl]&amp;do=sixty">60' Time</option>
                                <option value="timeslips.php?$session[sessionurl]&amp;do=rwhp">Horsepower</option>
                                <option value="timeslips.php?$session[sessionurl]&amp;do=slip">Cars w/proof of ET</option>
                                <option value="timeslips.php?$session[sessionurl]&amp;do=na">N/A cars only</option>
                                <option value="timeslips.php?$session[sessionurl]&amp;do=singledigitcars">Single Digit Club</option>
                                <option value="timeslips.php?$session[sessionurl]&amp;do=10seccars">10 Sec Club</option>
                                <option value="timeslips.php?$session[sessionurl]&amp;do=11seccars">11 Sec Club</option>
                                <option value="timeslips.php?$session[sessionurl]&amp;do=12seccars">12 Sec Club</option>
                                <option value="timeslips.php?$session[sessionurl]&amp;do=13seccars">13 Sec Club</option>
                                <option value="timeslips.php?$session[sessionurl]&amp;do=14seccars">14 Sec Club</option>
                                <option value="timeslips.php?$session[sessionurl]&amp;do=slowcars">15+ Sec Cars</option>
                                <option value="timeslips.php?$session[sessionurl]&amp;do=username">$vbphrase[username]</option>
                                <option value="timeslips.php?$session[sessionurl]&amp;do=averages">$vbphrase[timeslips_site_averages]</option>
                                </select>
                                </form>
                        </td>
                </tr>
                <tr>
                        <td colspan="2">
                                <table cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" width="100%" bordercolordark="#808080" style="border-collapse: collapse;background-color:white" border="1">
                                $timeslipsbit
                                <tr>
                                        <td class="tfoot" colspan="2">
                                        <!-- please don't remove this -->
                                        <font size="1"><center>[vBTimeslipDatabasev2.0 by <b><a href="http://modernmusclecars.net">EvilLS1</a></b>.Converted to vb3.5 by <b><a href="mailto:deathemperor@gmail.com">deathemperor</a></b>]</center></font>
                                        </td>
                                </tr>
                                </table>
                        </td>
                </tr>
        </table>
<font size="1"><a href="profile.php?$session[sessionurl]do=edittimeslip">$vbphrase[timeslips_submit]</a></font>
</td></tr>
</table>
<br />$pagenav
$footer
</body>
</html>

that would fix it.

burntire 02-04-2007 05:38 AM

Quote:

Originally Posted by burntire (Post 1170351)
My 1/4 and 1/8 mile ET's are not sorting correctly.

It is placing the double digits ET's above the single digits.

9.75 is the fastest time, but it is listed as the slowest.

If I make it 09.75 it sorts correctly.

Also the single digit cars are not showing up when selected.

Any suggestion?

Here is a link

http://www.highperformancestangs.com...timeslips.php?


Bump can anyone help?

BlueBulletRL 02-05-2007 04:29 AM

Is there anyone here that could possibly walk me through doing this manually one night. I'm no noobie but I'm really kinda worried about doing it manually by myself. I can even shoot you some money via paypal for helping or possibly doing it for me. Please let me know thanks!

0ptima 02-15-2007 12:20 AM

Quote:

Originally Posted by BlueBulletRL (Post 1174980)
Is there anyone here that could possibly walk me through doing this manually one night. I'm no noobie but I'm really kinda worried about doing it manually by myself. I can even shoot you some money via paypal for helping or possibly doing it for me. Please let me know thanks!

Its very simple to install. Set up a test site and try it out, you will learn a lot about vbulletin and hacks.

0ptima 02-15-2007 12:21 AM

I finally converted my 3.0 timeslips to the VB 3.6 version.

0ptima 02-15-2007 12:29 AM

This hack needs to be re-written to handle multiple cars and use separate tables. Right now, the default sort is on the 1/4 mile and if a member only enters a 1/8 mile, the member wont show up. I then changed the default sort by ride and got many entries with no timeslip data at all. By using separate tables for the timeslip data, only entries with timeslips would show up and users could enter multiple cars.

burntire 02-15-2007 02:24 AM

Quote:

Originally Posted by 0ptima (Post 1182882)
This hack needs to be re-written to handle multiple cars and use separate tables. Right now, the default sort is on the 1/4 mile and if a member only enters a 1/8 mile, the member wont show up. I then changed the default sort by ride and got many entries with no timeslip data at all. By using separate tables for the timeslip data, only entries with timeslips would show up and users could enter multiple cars.

Try entering a single digit time 9.9 or something and tell me how it sorts.

It keeps going after at the double digit 12.0 times on mine.

But if I put a zero 09.9 it sorts ok.

zincpony 02-20-2007 04:34 AM

aynone know how i can add a secondary page to the system that lists modifications RWHP and RWTQ and users can upload a DYNO chart??

wottech 02-21-2007 12:27 AM

Does it need to be on a 2nd page? If not, it would be really easy, esp since WHP is already there. All you would have to do is duplicate WHP in the code and change it to WTQ, then duplicate the slip part of the code, rename one timeslip and the other dynochart. Change some field numbers, add a couple more fields to the DB, and its done. Only problem I see doing it that way is that it makes the table pretty wide. I could possibly create another page, but I'm not sure how well integrated the 2 pages would be.

zincpony 02-25-2007 02:03 AM

without integrating them how would i create a different page that includes a Dyno Sheet sumbision and two input fields for RWHP and RWTQ and one field box for a summary of modifications.

wottech 02-25-2007 02:14 AM

I won't gaurantee anything, but I will try to mess around with it this week and see what I can come up with. So it sounds like you want a completely seperate hack, but for dyno sheets instead of timeslips? Hmm... that might actually be fairly simple to do.

tbroush 02-27-2007 12:24 PM

How can I get permissions setup for only a certain usergroup to be able to input information in the timeslips database or maybe the edit vehicle profile to not show for certain usergroups in the usercp, I know about the edit profile that you can turn off for that particular usergroup but I don't want them to not update their profile in case they need too.

tommyxv 03-11-2007 02:12 PM

Quote:

Originally Posted by 0ptima (Post 1182882)
This hack needs to be re-written to handle multiple cars and use separate tables..

Absolutely! Much cleaner way. :up:

garysawy 03-18-2007 12:42 PM

I have a problem with mine done everythig right but it dont display the link on the navbar or the link to edit the thing in the profile any ideas??

deathemperor 03-18-2007 12:45 PM

Quote:

Originally Posted by garysawy (Post 1206337)
I have a problem with mine done everythig right but it dont display the link on the navbar or the link to edit the thing in the profile any ideas??

go to phrase and language manager, search for "timeslips", choose edit and just press save (without modifying anything). This will rebuild your phrases so that it will show up correctly. I did rebuild it on my php code but I don't know why it's not working.

zincpony 03-19-2007 09:25 PM

i had that problem also, but i uploaded the xml twice the 2nd upload worked perfectly.

grecostimpy 03-25-2007 12:13 AM

Quote:

Originally Posted by 0ptima (Post 1182879)
I finally converted my 3.0 timeslips to the VB 3.6 version.

Please share.....I'm using a modified php file to make the 3.0.x version still work on my 3.6.5 board. I'd rather update then continue this rather buggy band-aid.

burntire 03-25-2007 12:38 AM

I am using this version and it is buggy. With all the auto sites out there I was hoping we could find a bug free solution.

0ptima 03-25-2007 08:45 PM

Quote:

Originally Posted by grecostimpy (Post 1211468)
Please share.....I'm using a modified php file to make the 3.0.x version still work on my 3.6.5 board. I'd rather update then continue this rather buggy band-aid.

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!

Quote:

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/showpost....&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


All times are GMT. The time now is 03:41 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02128 seconds
  • Memory Usage 1,881KB
  • 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
  • (1)bbcode_html_printable
  • (13)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)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