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)

White Knight 04-12-2004 01:13 AM

Nice work. I accually customized it for my Sportbike website. Had to change a few things in the database and code but otherwise the setup is the same.. Mostly the detail information needed to be suited for sportbikes but after i found out where your installed put the entries it was pretty simple. Thanks for sharing!

EvilLS1 04-12-2004 02:13 AM

Quote:

Originally Posted by White Knight
Nice work. I accually customized it for my Sportbike website. Had to change a few things in the database and code but otherwise the setup is the same.. Mostly the detail information needed to be suited for sportbikes but after i found out where your installed put the entries it was pretty simple. Thanks for sharing!

Thanks. Nice to see that its useful for the two wheeled bunch aswell. :)

I guess I should mention (for everyone else who hasn't noticed) that all of the fields can be easily edited or customized in the admincp under custom profile fields once the hack is installed.

VBDev 04-14-2004 11:45 AM

I've installed this for someone but there are small bugs in timeslips.php file

You need to rename tables name in your query coz if there is a prefix, the table's name will not be correct

Replace

PHP Code:

// Get total number of users
$userscount=$DB_site->query_first("SELECT COUNT(*) AS users
FROM " 
TABLE_PREFIX "user, " TABLE_PREFIX "userfield 
$cond 
AND user.userid = userfield.userid"
); 

with

PHP Code:

// Get total number of users
$userscount=$DB_site->query_first("SELECT COUNT(*) AS users
FROM " 
TABLE_PREFIX "user AS user, " TABLE_PREFIX "userfield AS userfield
$cond 
AND user.userid = userfield.userid"
); 


And

PHP Code:

// Get users
$users=$DB_site->query("SELECT *
FROM " 
TABLE_PREFIX "user, " TABLE_PREFIX "userfield
WHERE user.userid = userfield.userid
$condition 
ORDER BY 
$orderby $direction
LIMIT 
$pos,$perpage"); 


with :

PHP Code:

// Get users
$users=$DB_site->query("SELECT *
FROM " 
TABLE_PREFIX "user AS user, " TABLE_PREFIX "userfield AS userfield
WHERE user.userid = userfield.userid
$condition 
ORDER BY 
$orderby $direction
LIMIT 
$pos,$perpage"); 

Now corrected and it works fine :)

EvilLS1 04-14-2004 08:35 PM

Good catch VBDev. Thanks. :) I'll change that in the next update. That didn't even cross my mind. I never paid much attention to the table prefix stuff b/c I don't use them.

SVTBlackLight01 04-16-2004 05:29 PM

I searched the thread, but didn't see this question. How hard would it be to display the user's rank by ET in the postbit?

EvilLS1 04-16-2004 09:04 PM

Quote:

Originally Posted by SVTBlackLight01
I searched the thread, but didn't see this question. How hard would it be to display the user's rank by ET in the postbit?

That would be really easy. Take a look at this post:
https://vborg.vbsupport.ru/showpost....4&postcount=76

That shows the user's ET club in the postbit, but it would be really simple to change it so that it displays a rank image based on the ET. All you would need to do is change what the variable displays to an image instead of showing the club. For example:

If the member has a 10 second car,

$poop = "<img src=\"rankimage1.jpg\">";

else if the member has an 11 second car show:

$poop = "<img src=\"rankimage2.jpg\">";

etc, etc.

SVTOA 04-16-2004 09:43 PM

Has anyone installed this with 3.0.1 yet? Any issues?

SVTBlackLight01 04-16-2004 09:59 PM

Thanks for pointing out that post. That gives me a few ideas I might try. What I was thinking of though was having something like this in the postbit.

Join Date: Nov 2002
Location: Houston, TX
Age: XX
Posts: 1247

Best Time: 12.984@104.39
Ranked: #8

using their placement on the the timeslips list sorted by ET.

(I'm liking the rank image thing though :D )

EvilLS1 04-16-2004 10:14 PM

Quote:

Originally Posted by SVTOA
Has anyone installed this with 3.0.1 yet? Any issues?

Yes, I've installed it on 3.0.1 with no problems.

SVT,
That should be fairly easy to do also. If you can't get it I'll look into it after I finish upgrading my site.

SVTBlackLight01 04-17-2004 01:23 AM

You finally decided to take the plunge huh? I can't wait to check it out.

I may be able to figure the rank issue out. I just need to spend a little more time digging through the code. Thanks!


All times are GMT. The time now is 11:12 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.01360 seconds
  • Memory Usage 1,754KB
  • 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
  • (4)bbcode_php_printable
  • (3)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