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)

calgdsm 09-17-2007 08:23 PM

Quote:

Originally Posted by Mistamike17 (Post 1317681)
Got it reinstalled by weeding through the MySQL tables. I'm still not sure why the links in both the navbar and USERCP_SHELL aren't showing up.

I am also having this problem. Can someone help.

calgdsm 09-17-2007 08:24 PM

Quote:

Originally Posted by 0ptima (Post 1317708)
Try editing the two phrases in question and saving it without making a change.

Can you explain this a little better? I will give it a go and see what happens

0ptima 09-18-2007 12:58 AM

Quote:

Originally Posted by calgdsm (Post 1341174)
Can you explain this a little better? I will give it a go and see what happens

Languages & Phrases -> Search in Phrases

Search for "timeslip" and then edit and save each timeslip phrase
(I may have had to only edit and save just one, I dont remember)

calgdsm 09-18-2007 03:51 AM

Quote:

Originally Posted by 0ptima (Post 1341371)
Languages & Phrases -> Search in Phrases

Search for "timeslip" and then edit and save each timeslip phrase
(I may have had to only edit and save just one, I dont remember)

What am i going to edit? nothing? just find the phrase "timeslip" and hit edit and then just hit save?

Cars2007 09-19-2007 07:47 PM

Quote:

Originally Posted by calgdsm (Post 1341430)
What am i going to edit? nothing? just find the phrase "timeslip" and hit edit and then just hit save?

I pressed the "copy default phrase" button and saved it. That fixed it for me.

calgdsm 09-20-2007 01:44 AM

Quote:

Originally Posted by Cars2007 (Post 1342647)
I pressed the "copy default phrase" button and saved it. That fixed it for me.

OMG Thanks You Guys So Much!!! Now working just fine.

BackSideSA 09-21-2007 07:21 PM

Quote:

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.
This option doesnt work for me. The user is still able to edit the vehicle profile.

Anyone also experiencing this?

0ptima 09-22-2007 02:11 AM

Quote:

Originally Posted by calgdsm (Post 1341430)
What am i going to edit? nothing? just find the phrase "timeslip" and hit edit and then just hit save?

Yes

BlueBulletRL 09-29-2007 06:55 PM

I am having an issue where if a user submits a timeslip below the number I set in the back end to require the upload of a timeslip it still allows the submition of information WITHOUT the timeslip. Where should I be looking and make sure something didnt mess up?

LCN2007 10-04-2007 05:20 PM

Is ther a way to make the time slip page sort by: default to HP instead of blank?

sunrunner_pei 10-05-2007 10:03 PM

OK, I managed to get this installed on 3.6.8, however I'm getting the error...

Warning: Invalid argument supplied for foreach() in /member.php on line 591

...when viewing user profiles now. I tried both the author's version and 0ptima's 3.6.8 instructions. Does anyone have any suggestions?

LCN2007 10-05-2007 10:43 PM

im using 3.6.8 works great just trying find out if when i go to the timeslip page is there a way to make the page default to HP? I dont want to have to have my members see a blank page and then choose a sort by option see something.

I want them to see HP and then if they want to choose a sort option they can.

DrewzR/T 10-14-2007 10:33 PM

Having some issues here with this hack. Ive gone through and used Optimas instructions, tried editing and saving phrases like mentioned and yet I still get this error.

Code:

Database error in vBulletin 3.6.8:

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
Date        : Sunday, October 14th 2007 @ 06:25:05 PM
Script      : http://www.sova-dakotas.com/forums/timeslips.php?
Referrer    : http://www.sova-dakotas.com/forums/index.php
IP Address  : 71.251.190.84
Username    : DrewzR/T
Classname    : vB_Database


DrewzR/T 10-14-2007 10:37 PM

Also have a problem with being able to edit profile fields. Says I dont have permission?! Any ideas?

0ptima 10-15-2007 12:41 AM

Quote:

Originally Posted by DrewzR/T (Post 1360144)
Having some issues here with this hack. Ive gone through and used Optimas instructions, tried editing and saving phrases like mentioned and yet I still get this error.

Code:


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


You're missing the user profile field field55. You can easily add the field through the user profile field and have attached a screen shot of all the required fields for this hack.

DrewzR/T 10-15-2007 01:26 PM

Looks like you have found where my problem lies. I dont have any of those!!! Screenshot attached.

EDIT...for shits and giggles I tried to add a few of the fields but it seems as if they are already in there because Im starting off at (id 66) when I input myself. Any ideas on how to get em to show up?

0ptima 10-16-2007 01:09 AM

Quote:

Originally Posted by DrewzR/T (Post 1360708)
Looks like you have found where my problem lies. I dont have any of those!!! Screenshot attached.

EDIT...for shits and giggles I tried to add a few of the fields but it seems as if they are already in there because Im starting off at (id 66) when I input myself. Any ideas on how to get em to show up?

What happens when you try to enter a field called 'field50'?

too_cool_3 10-16-2007 12:17 PM

Quote:

Originally Posted by LCN2007 (Post 1352951)
Is ther a way to make the time slip page sort by: default to HP instead of blank?

I agree, is there a way to make all users that input information show up by default instead of only the ones that entered 1/4 mile times????

This would be greatly appreciated! :D

too_cool_3 10-16-2007 11:41 PM

also, can users enter more then one vehicle to display in the timeslips section? this would be a great additional feature!

0ptima 10-17-2007 12:14 AM

Quote:

Originally Posted by too_cool_3 (Post 1361926)
also, can users enter more then one vehicle to display in the timeslips section? this would be a great additional feature!

1 car per user only

too_cool_3 10-17-2007 05:33 AM

Is there a way to make all users that input information show up by default instead of only the ones that entered 1/4 mile times????

studio59 10-19-2007 02:52 PM

I installed this mod on 3.6.8 and I don't have any errors however, its not showing up in my navbar..

The template im using the navbar is in the header instead of navbar but it isn't showing even though i added.. now you can goto forum/timeslips.php manually but it still doesn't look right
http://www.cartoyztxk.com/forum/

0ptima 10-20-2007 01:07 AM

Quote:

Originally Posted by studio59 (Post 1363774)
I installed this mod on 3.6.8 and I don't have any errors however, its not showing up in my navbar..

The template im using the navbar is in the header instead of navbar but it isn't showing even though i added.. now you can goto forum/timeslips.php manually but it still doesn't look right
http://www.cartoyztxk.com/forum/

Go and edit any timeslip phrase and do a save. THis should fix the problem.

b00k 10-22-2007 05:33 PM

-----------

0ptima 10-24-2007 01:15 AM

Quote:

Originally Posted by TSR (Post 1366076)
On an upgrade from 3.5.2 -> 3.6.8 on importing the pluggin i get this error:

You already have a profile field called '50'. Is this the first time you are installing the hack on your board?

accord2nrz 10-24-2007 11:18 AM

I uploaded this program into my board and nothing happened. I am already running the vbgarage hack. Followed the instructions to the letter and no errors but nothing happened

accord2nrz 10-24-2007 11:26 AM

I am also using vb 3.6.x

uglyduck 10-24-2007 07:26 PM

Installed! Works great for 3.6.8 here. Installation was a little tricky with several "duplicate field" errors but I was able to work through it by installing the xml, going to ACP and deleting all of the new user profile fields created by the timeslip mod installation. Then I would go back and install the xml again. Each time I was able to get a little further and eventually it ran all the way through without errors.

Is there anyway to fix the following:

members posting single digit 1/4mi times are sorted to the bottom of the list. A user with a 10.0 would be listed at the top but anyone 9.99 and lower would be at the bottom.

Extra brackets [like these] around the 1/4mi column header.

I have alot of members who only run the 1/8th mile. I have noticed that if they do not enter a time in the 1/4mi field then they do not show up on the timeslip page.

page can be seen at http://www.mafia-motorsports.com/forums/timeslips.php

slosupra 10-25-2007 05:14 AM

i just installed the on 3.6.4, i have install everything to the t. I am not getting any errors and i can open timeslips.php just fine. but the link in the header is not showing and neither is the link in the user cp panel

my site is http://www.nemotorsport.com/boards/index.php

please help i really want to use this mod

*edit* got it working thanks

SVTCobraLTD 10-26-2007 04:18 PM

Looks like this is working on 3.6.8... I will try and install this weekend. Have seen this on other sites and works great.

SVT

john.friel 10-29-2007 01:18 PM

Quote:

Originally Posted by webgod (Post 1297010)
I PM'd him on the 18th.. he read it the same day, but did not respond

Well, I for one would love to see the XML patch to this. At least I now know what to tell my 9 second users as to why they are so low on the list!

In the mean time, I'm having all sub 10.000 E/T times enter a leading ZERO (09.911x etc..) so that they sort correctly.

John

uglyduck 10-29-2007 07:58 PM

I can now see what's going on with my 1/8mi guys. The conditional check in timeslips.php is only looking for values greater than 0 to produce the list....and the list currently sorts by 1/4mi ET by default.

else if ($_REQUEST['do'] == 'quarter')
{
$cond.=" WHERE userfield.field55>0";
$condition.=" AND userfield.field55>0";

$orderby="userfield.field55";
$direction=ASC;
$bracket3="<b>[</b>";
$bracket4="<b>]</b>";

I could change the list to default the sort by 1/8mi but I would rather default to 'username'. Unfortunately the 'username' sort also requires field55 to be greater than 0. Field55 is 1/4mi ET.

else if ($_REQUEST['do'] == 'username')
{
$cond.=" WHERE userfield.field55>0";
$condition.=" AND userfield.field55>0";

$orderby="user.username";
$direction=ASC;
$bracket11="<b>[</b>";
$bracket12="<b>]</b>";

too_cool_3 10-30-2007 02:35 AM

Quote:

Originally Posted by uglyduck (Post 1367689)
Is there anyway to fix the following:

members posting single digit 1/4mi times are sorted to the bottom of the list. A user with a 10.0 would be listed at the top but anyone 9.99 and lower would be at the bottom.

Same problem here... I hope there is a way to fix this soon so all my users running 9's aren't listed at the BOTTOM :(

Tru2Chevy 10-30-2007 12:51 PM

Quote:

Originally Posted by uglyduck (Post 1367689)
Extra brackets [like these] around the 1/4mi column header.

The brackets just show what the list is sorted by. If you change the sort to 1/8 mile or 60 foot time, the brackets will move to that column.


Quote:

Originally Posted by uglyduck (Post 1371379)
I can now see what's going on with my 1/8mi guys. The conditional check in timeslips.php is only looking for values greater than 0 to produce the list....and the list currently sorts by 1/4mi ET by default.

else if ($_REQUEST['do'] == 'quarter')
{
$cond.=" WHERE userfield.field55>0";
$condition.=" AND userfield.field55>0";

$orderby="userfield.field55";
$direction=ASC;
$bracket3="<b>[</b>";
$bracket4="<b>]</b>";

I could change the list to default the sort by 1/8mi but I would rather default to 'username'. Unfortunately the 'username' sort also requires field55 to be greater than 0. Field55 is 1/4mi ET.

else if ($_REQUEST['do'] == 'username')
{
$cond.=" WHERE userfield.field55>0";
$condition.=" AND userfield.field55>0";

$orderby="user.username";
$direction=ASC;
$bracket11="<b>[</b>";
$bracket12="<b>]</b>";

The reason that it always requires 1/4 mile ET to be greater than 0 is because all members have a default entry of 0.00 for all of their times on the list. You could change it so that 1/8 mile ET would have to be greater than 0, but then you would have to go through your entire list and make sure that all the users with 1/4 mile times also included their 1/8 mile times, or else they won't be listed.

- Justin

Tru2Chevy 10-30-2007 12:52 PM

Quote:

Originally Posted by too_cool_3 (Post 1371631)
Same problem here... I hope there is a way to fix this soon so all my users running 9's aren't listed at the BOTTOM :(

There is a way to fix it, I just can't remember how I did it. It must be listed in this thread somewhere though....

Mine: http://www.njfboa.org/forums/timeslips.php?

- Justin

uglyduck 10-30-2007 01:49 PM

10-4 on the brackets, thanks

I started reading back at page 1 and found a reference to a decimal value change on page2 but I can't determine if that is for this particular issue. Also, can't determine where exactly to change the values or I would give it a shot.

Look back at post #s 26, 29, (post #31 bug#5). Is this what we're dealing with?

Thanks Tru2Chevy!!

USAMustangs.com 11-01-2007 03:36 AM

Yes, it would be nice to figure how to fix the 9 second problem. The quickest cars are dead last on the list. This needs to be fixed.

Tru2Chevy 11-01-2007 09:01 PM

Back in March of '06 I got a version of this with bug fixes from Sidewindr. That is prolly where the fixes I have came from.

- Justin

rdrunnr 11-03-2007 01:15 AM

Any ideas on this? I installed this on my 3.6.4 and everything works except for user profiles now give this error:

Invalid SQL:

SELECT profilefieldid, required, title, type, data, def, height
FROM profilefield
WHERE profilefieldid NOT IN (50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65) AND form = 0
ORDER BY displayorder;

MySQL Error : Unknown column 'title' in 'field list'
Error Number : 1054
Date : Friday, November 2nd 2007 @ 07:13:47 PM
Script : http://www.clickclickracing.com/foru...lastposter&f=8
Referrer : http://www.clickclickracing.com/forums/
IP Address : 76.99.159.63
Username : RdRunnr
Classname : vb_database

0ptima 11-03-2007 02:29 AM

Quote:

Originally Posted by rdrunnr (Post 1374552)
Any ideas on this? I installed this on my 3.6.4 and everything works except for user profiles now give this error:


MySQL Error : Unknown column 'title' in 'field list'

You're missing the 'title' field. Take a look at this

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

Probably need to run these two queries
Code:


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`



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

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.01828 seconds
  • Memory Usage 1,846KB
  • 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
  • (3)bbcode_code_printable
  • (20)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