vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   vB Timeslip Database -for Automotive websites (https://vborg.vbsupport.ru/showthread.php?t=60945)

DigitalEclipse 02-02-2004 03:20 AM

Actually I fixed it myself after I posted, but thanks :up:

BarryA 02-02-2004 10:53 PM

Im not sure if I installed the hack incorrectly or what, but it has destroyed my ability to edit users from the control panel. Can someone verify that they are able to edit users after installing the hack.

This is the error I get;
Quote:

Database error in vBulletin 3.0.0 Release Candidate 3:

Invalid SQL: UPDATE user SET tdban= WHERE userid=65
mysql error: You have an error in your SQL syntax near 'WHERE userid=65' at line 1

mysql error number: 1064

Date: Monday 02nd of February 2004 07:01:19 PM
Script: http://www.fordpower.net/forums/admin/user.php
Referer: http://www.fordpower.net/forums/admi...edit&userid=65
Username: Barry
IP Address: 65.124.87.345

EvilLS1 02-02-2004 11:23 PM

Barry,
Re-check your code edits to admincp/user.php . Theres 3 edits to that file. I think maybe you missed one of them. I just re-added the code from the instructions to my test board and its working fine.

FastAttack 02-03-2004 01:00 AM

new suggestions.. allow users to upload multiple time slips.. ie one with the fastest trap speed and the other with the actual elapsed time.. I am not sure how hard that would be :)
as it well beyond my knowledge of programming vb :)

BarryA 02-03-2004 03:01 AM

Quote:

Originally Posted by EvilLS1
Barry,
Re-check your code edits to admincp/user.php . Theres 3 edits to that file. I think maybe you missed one of them. I just re-added the code from the instructions to my test board and its working fine.

Thanks man... :) I wasnt for sure if it was something I did or if everyone was having the problem...

Quote:

Originally Posted by FastAttack
new suggestions.. allow users to upload multiple time slips.. ie one with the fastest trap speed and the other with the actual elapsed time.. I am not sure how hard that would be :)
as it well beyond my knowledge of programming vb :)

You could just have them put both slips in one image. This would be the easy way around it. Like EvilLS1 said he is not taking any reqests for new features. It would however be easy to do it yourself.

EvilLS1 02-03-2004 07:42 PM

Adding the upload feature shouldn't be too difficult since VB3 already has the ability to upload pictures to your profile. You can probably use that same function for the timeslips. When (if?) I upgrade to VB3 I will look into it.

94DROPTOPZ 02-06-2004 11:19 AM

I finally added it yesterday and this is an awesome hack & it works great thanks alot...

http://www.gmvsford.com/forums/timeslips.php?

EvilLS1 02-06-2004 08:29 PM

Looks great 94DROPTOP.

DigitalEclipse 02-06-2004 11:23 PM

Just FYI. I upgraded to RC4 and it still works like a charm from what I can tell.

higabyte 02-08-2004 08:04 PM

great hack!!!!!! added it with no problems!!

also, if you could please add mine... thanks!

http://board.accordtuner.com/timeslips.php

EvilLS1 02-08-2004 08:42 PM

DigitalEclipse,
Thanks for confirming that it works with RC4.

higabyte,
Looks nice! Added your link.

DeeperImage 02-11-2004 01:31 AM

I am using RC4 as well, I just added it tonight. I love it. It was easy to install. Thanks a bunch.

http://www.240sxforums.com/forums/timeslips.php

Tungsten 02-16-2004 03:23 PM

Hey Evil... how would I modify the code in this latest version for vB3 so that it sorts by 60' times by default? :)

And thanks again for this hack. You rock, man.

EvilLS1 02-16-2004 04:58 PM

Quote:

Originally Posted by Tungsten
Hey Evil... how would I modify the code in this latest version for vB3 so that it sorts by 60' times by default? :)

And thanks again for this hack. You rock, man.

In timeslips.php find:
Code:

// If no action is set order by quarter
if (empty($_REQUEST['do']))
{
  $_REQUEST['do'] ='quarter';
}

Replace it with:
Code:

// If no action is set order by sixty
if (empty($_REQUEST['do']))
{
  $_REQUEST['do'] ='sixty';
}

Find:
Code:

  }
  else
  {
        $cond.=" WHERE userfield.field55>'".intval($number)."'";
        $condition.=" AND userfield.field55>'".intval($number)."'";
        $orderby="userfield.field55";
        $direction=ASC;
        $bracket3="<b>[</b>";
        $bracket4="<b>]</b>";

Replace it with:
Code:

  }
  else
  {
        $cond.=" WHERE userfield.field52>'".intval($number)."'";
        $condition.=" AND userfield.field52>'".intval($number)."'";
        $orderby="userfield.field52";
        $direction=ASC;
        $bracket1="<b>[</b>";
        $bracket2="<b>]</b>";

That should do it. :)


DeeperImage,
Looks great! Added your link.

Tungsten 02-16-2004 06:50 PM

Quote:

Originally Posted by EvilLS1
That should do it. :)

Excellent... thanks! We're running it here:

http://www.tennesspeed.net/forums/timeslips.php

EvilLS1 02-16-2004 08:32 PM

Quote:

Originally Posted by Tungsten
Excellent... thanks! We're running it here:

http://www.tennesspeed.net/forums/timeslips.php

Looks great! Link added. :)

DeeperImage 02-17-2004 01:03 AM

Quote:

Originally Posted by EvilLS1
DeeperImage,
Looks great! Added your link.

Thank you for this excellent hack. One question I had, I am not very familiar with php. When the new RC of VB3 comes out, and I upgraed it, which files do I need to not replace so that they dont erase the hack? thanks again.

EvilLS1 02-17-2004 02:39 AM

Quote:

Originally Posted by DeeperImage
Thank you for this excellent hack. One question I had, I am not very familiar with php. When the new RC of VB3 comes out, and I upgraed it, which files do I need to not replace so that they dont erase the hack? thanks again.

Well, you really should replace all the files with the newer ones when you upgrade.. Then just re-apply the hack to the new files. You won't need to run the installer again or add/edit the templates. Just do the file edites.

BTW, just noticed that you're from Kennesaw GA.. I'm only a few miles from you (Rome GA). :)

cteselle 02-17-2004 06:33 AM

Great Hack!

Is there a way to add the top 5 (or whatever) to a non-vb page?

DeeperImage 02-17-2004 11:38 AM

Quote:

Originally Posted by EvilLS1
Well, you really should replace all the files with the newer ones when you upgrade.. Then just re-apply the hack to the new files. You won't need to run the installer again or add/edit the templates. Just do the file edites.

BTW, just noticed that you're from Kennesaw GA.. I'm only a few miles from you (Rome GA). :)

I guess thats not to bad. That is to funny that you live in Rome. We are just minutes away :nervous:

EvilLS1 02-17-2004 07:55 PM

Quote:

Originally Posted by cteselle
Great Hack!

Is there a way to add the top 5 (or whatever) to a non-vb page?

Thanks. I don't have any of the VB3 portals installed on my test site, but it should be pretty easy to do. In the old v1.3 Timeslip Database thread I posted instructions on how to add it (for VB2). You can probably figure out how to add it to your VB3 portal by looking at that code.

cteselle 03-02-2004 08:41 PM

Here's mine: http://www.socalloc.com/forums/timeslips.php

I modified and added to it a bit. I also wrote my own script to display the stats on the first page, since I'm not using a vB portal.

thanks again for your work on this! My users love it!

corsacrazy 03-02-2004 08:52 PM

all we need is this hack intergrated with a vb garage hack and all car sites will be sorted

EvilLS1 03-03-2004 03:20 AM

cteselle,
Looks great! Added your link. I like what you did with the mod list too. :)

joeychgo 03-08-2004 05:12 AM

Hack installed pretty easily...
(especially considering im learning all this as I go along - one whole week now-)
thanks for your hard work!

One strange thing. My navbar does not show Timeslips it shows Tineslips

LOL Please someone take pity on me and tell me how to fix!!!!! Ive looked EVERYWHERE I can think of and couldnt find it.


Second problem... After completing the Vehicle Profile Data form and clicking "save changes" it takes me to the New Subscribed Threads screen?


Third, the instructions say this should add a "Vehicle Profile" page to my forum - but I cant find anything

Im running vBulletin Version 3.0.0 Release Candidate 4--

www.lincolnvscadillac.com

EvilLS1 03-08-2004 07:18 AM

Quote:

One strange thing. My navbar does not show Timeslips it shows Tineslips
In your admincp under languages & phrases click "phrase manager" then click the "search in phrases" button. Search for "tineslips".. Then click edit and fix the spelling mistake.

Quote:

Second problem... After completing the Vehicle Profile Data form and clicking "save changes" it takes me to the New Subscribed Threads screen?
Thats the main page of your userCP. Thats not an error. Its supposed to go there (goes to the same page after editing your regular profile aswell).. But you can easily change it so that it redirects to somewhere else if you want..

Find this code in profile.php:
Code:

// ############################### start update ###############################
if ($_POST['do'] == 'updatevehicleprofile')
{
       
  if ($bbuserinfo[userid]==0  or $bbuserinfo[tdban]==0)
{
        print_no_permission();
  }
        $userfields = verify_vehiclefields(0);

        // insert custom user fields
        if (!empty($userfields))
        {
                $DB_site->query("UPDATE " . TABLE_PREFIX . "userfield SET userid=$bbuserinfo[userid]$userfields WHERE userid=$bbuserinfo[userid]");
        }
$url = "usercp.php?$session[sessionurl]";
        eval(print_standard_redirect('redirect_updatethanks'));

}

In the code above, find this:
Code:

$url = "usercp.php?$session[sessionurl]";
if you want it to redirect to the timeslip database just replace it with this:
Code:

$url = "timeslips.php?$session[sessionurl]";
..or change it to whatever file that you want to be redirected to.


Quote:

Third, the instructions say this should add a "Vehicle Profile" page to my forum - but I cant find anything
Once you've added your ET to the timeslip database, go to the timeslips page (timeslips.php) and click "Details" next to the username and you'll see the vehicle profile page.

Or you can even add a link to your user's vehicle profile from their regular profile. Just put this link in the memberinfo template:
Code:

<a href="member.php?$session[sessionurl]&do=vehicledetails&userid=$userinfo[userid]">Vehicle Profile</a>

joeychgo 03-08-2004 09:37 AM

Thanks! But the second one didnt do anything......... ???

joeychgo 03-08-2004 06:47 PM

Got a problem~~~~

After installing this, I went to my user manager and tried to change info on a member. When I clicked save I got this.......

[COLOR=Red]There seems to have been a slight problem with the Lincoln vs Cadillac database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.

Database error in vBulletin 3.0.0 Release Candidate 4:

Invalid SQL: UPDATE user SET tdban= WHERE userid=6
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE userid=6' at line 1

mysql error number: 1064

EvilLS1 03-08-2004 07:36 PM

Quote:

Thanks! But the second one didnt do anything......... ???
Make sure you changed the code in the right place. Theres a few places that have that same code. The one you want to change is a few lines below this code:
Code:

if ($_POST['do'] == 'updatevehicleprofile')

EvilLS1 03-08-2004 07:37 PM

Quote:

Originally Posted by joeychgo
Got a problem~~~~

After installing this, I went to my user manager and tried to change info on a member. When I clicked save I got this.......

[COLOR=Red]There seems to have been a slight problem with the Lincoln vs Cadillac database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.

Database error in vBulletin 3.0.0 Release Candidate 4:

Invalid SQL: UPDATE user SET tdban= WHERE userid=6
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE userid=6' at line 1

mysql error number: 1064

You missed something when you edited admincp/user.php. Theres 3 changes in that file. Go back and make sure you did all 3 edits (I think you forgot the second one).

joeychgo 03-08-2004 08:02 PM

Yup, you were right. I missed one change..... got it fixed....thanks! GUess I shouldnt do these things at 4:00am while wired on nothing but coffee!

EvilLS1 03-08-2004 11:56 PM

Glad ya got it workin'. :)

joeychgo 03-08-2004 11:58 PM

Thanks alot --- for the hack and your help.

EvilLS1 03-09-2004 03:02 AM

You're welcome.

BfB 03-11-2004 06:38 PM

Quote:

Originally Posted by corsacrazy
all we need is this hack intergrated with a vb garage hack and all car sites will be sorted

YEAA!!!!!

EvilLS1 03-16-2004 04:37 AM

Add on:
This will show the ET club that each user belongs to in the postbit. For example, if a user has a 12 second ET it will display "12 Second Club Member" in the postbit below his username.

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

Code:

                        $show['reputationlink'] = iif($vboptions['reputationenable'] AND $bbuserinfo['userid'] AND $post['userid'] AND !($usergroupcache["$post[usergroupid]"]['genericoptions'] & ISBANNEDGROUP), true, false);
                        break;
        }

Below it add:
Code:


if ($post[field55]>=14 && $post[field55]<15)
{
$poop = "<font size=\"1\"><a href=\"timeslips.php?$session[sessionurl]&do=14seccars\" STYLE=\"text-decoration: none\">14 Second Club Member</a></font>";
}
else if ($post[field55]>=13 && $post[field55]<14)
{
$poop = "<font size=\"1\"><a href=\"timeslips.php?$session[sessionurl]&do=13seccars\" STYLE=\"text-decoration: none\">13 Second Club Member</a></font>";
}
else if ($post[field55]>=12 && $post[field55]<13)
{
$poop = "<font size=\"1\"><a href=\"timeslips.php?$session[sessionurl]&do=12seccars\" STYLE=\"text-decoration: none\">12 Second Club Member</a></font>";
}
else if ($post[field55]>=11 && $post[field55]<12)
{
$poop = "<font size=\"1\"><a href=\"timeslips.php?$session[sessionurl]&do=11seccars\" STYLE=\"text-decoration: none\">11 Second Club Member</a></font>";
}
else if ($post[field55]>=10 && $post[field55]<11)
{
$poop = "<font size=\"1\"><a href=\"timeslips.php?$session[sessionurl]&do=10seccars\" STYLE=\"text-decoration: none\">10 Second Club Member</a></font>";
}
else if ($post[field55]>0 && $post[field55]<10)
{
$poop = "<font size=\"1\"><a href=\"timeslips.php?$session[sessionurl]&do=singledigitcars\" STYLE=\"text-decoration: none\">Single Digit Club Member</a></font>";
}
else
{
$poop = "";
}

Then put $poop in your postbit & postbit_legacy templates where you want it to show up.

Boofo 03-16-2004 06:01 AM

There you go again, pooping in the postbit. LOL

EvilLS1 03-16-2004 06:11 AM

Quote:

Originally Posted by Boofo
There you go again, pooping in the postbit. LOL

Yeah I'm not very creative when it comes to thinking of variable names. I just use the first thing that comes to mind. :D
$poop ---> https://vborg.vbsupport.ru/external/2004/03/3.gif

joeychgo 03-16-2004 06:29 AM

Hey evil - are you going to update when gold comes out?

EvilLS1 03-16-2004 06:31 AM

Quote:

Originally Posted by joeychgo
Hey evil - are you going to update when gold comes out?

I dunno.. I'm happy with my VB2 board so I'm not sure when I'll upgrade.

{Edit} Do you mean update the hack? Only if it needs to be updated. I'm not sure if any of the code changes from RC4 - Gold will effect this hack.


All times are GMT. The time now is 11:39 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.01822 seconds
  • Memory Usage 1,849KB
  • 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
  • (11)bbcode_code_printable
  • (18)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)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