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)

Big Kahuna 01-28-2005 04:13 AM

So is it working for you now?

Silver_2000_)! 01-28-2005 04:16 AM

The avatars are appearing correctly in the forum after LS1's suggestion helped me find my screw up

Unfortunatly the avatar upload was still broke - So once again thanks to his suggestion reuploaded the unedited version of that file and the uploads worked. So encouraged by finding my own incompetence I re-applied the updated edits from the beta-3.06 file and its all working fine now...

Have to remember to not try to reapply hacks until I have poured my second cup of coffee

Once again - sorry for the fire drill ... everything is OK NOW -
Doug

EvilLS1 01-28-2005 04:36 AM

No problem Doug. Thanks for letting me know. So everything is working properly now (including uploads)?

Silver_2000_)! 01-28-2005 04:41 AM

Quote:

Originally Posted by EvilLS1
No problem Doug. Thanks for letting me know. So everything is working properly now (including uploads)?

Yep

THANKS SO much for jumping in to try to help

Your prior note helped narrow it down so I could see my errors

EvilLS1 01-28-2005 04:50 AM

Quote:

Originally Posted by Silver_2000_)!
Yep

THANKS SO much for jumping in to try to help

Your prior note helped narrow it down so I could see my errors

Great! :) Glad to hear that all is good b/c now I don't have to install a test forum (I'm lazy). :p

I'll leave the 3.0.6 version tagged as BETA until a couple more people confirm a successful installation (just in-case we've overlooked something).


Dewayne

Big Kahuna 01-30-2005 12:47 AM

I'm testing the 3.0.6 version on my test forum and it appears to be working fine. I'll give a link to the live forum once it is installed there. I think the 3.0.6 people will not have a problem. All went very smooth.

I'd like to be able to display the TOP 10 CONFIRMED (ticket submitted) in my forum index. Any chance of getting a bone rolled to me on the code required?

Big Kahuna 01-30-2005 12:55 AM

Quote:

Originally Posted by SVTBlackLight01
OK. Here are the instructions and an updated file for displaying the top 5 timeslips in vBindex.

What change would I need to make to add the condition of only including those that submitted the proof?

EvilLS1 01-30-2005 01:29 AM

Quote:

Originally Posted by Big Kahuna
I'm testing the 3.0.6 version on my test forum and it appears to be working fine. I'll give a link to the live forum once it is installed there. I think the 3.0.6 people will not have a problem. All went very smooth.

I'd like to be able to display the TOP 10 CONFIRMED (ticket submitted) in my forum index. Any chance of getting a bone rolled to me on the code required?



Well, I've never tried it but it should be just as easy to add the top 10 confirmed to your forum index.

Try this..

In forums/index.php find:
Code:


        'forumhome_pmloggedin',

replace it with:
Code:

        'forumhome_pmloggedin',
        'times',
        'toptimes',


find:
Code:

// ### ALL DONE! SPIT OUT THE HTML AND LET'S GET OUTA HERE... ###

above it add:
Code:

// Top Times add-on
$pos = 0;
$condition.=" AND (userfield.field57!='' OR customtimeslippic.dateline!='') AND userfield.field55>0";

$users=$DB_site->query("SELECT *
                          FROM " . TABLE_PREFIX . "user AS user, " . TABLE_PREFIX . "userfield AS userfield
                          LEFT JOIN " . TABLE_PREFIX . "customtimeslippic AS customtimeslippic ON (customtimeslippic.userid = user.userid)
                          WHERE user.userid = userfield.userid
                          $condition 
                          ORDER BY userfield.field55 ASC
                          LIMIT 10");

// Set up vars
while ($userinfo=$DB_site->fetch_array($users)) {
$tdateline = $userinfo[dateline];
$pos++;
$rank= number_format($pos);
$TDusername= $userinfo[username];
$ride= $userinfo[field50];
if ($userinfo[field52]>0){
  $sixty= $userinfo[field52];
}else{
  $sixty="";
}
if ($userinfo[field55]>0){
  $quarter= $userinfo[field55];
}else{
  $quarter="";
}
if ($userinfo[field56]>0){
  $atmph2="@";
}else{
  $atmph2="";
}
if ($userinfo[field56]>0){
  $quartermph= $userinfo[field56];
}else{
  $quartermph="";
}
$userinfo[field57] = trim($userinfo[field57]);
    if ($userinfo[field57]!="")
      {
          $slip="<a href=\"$userinfo[field57]\" target=\"_blank\"><img src=\"$stylevar[imgdir_misc]//slipicon.gif\"  border=0></a>";
      }
      else
      {
          $slip="";
      }
              eval('$times .= "' . fetch_template('times') . '";');
}  // end while
              eval('$toptimes .= "' . fetch_template('toptimes') . '";');



Create a new template named "toptimes" and add the HTML below:
Code:


                <table align="center" border="0" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" class="tborder" width="100%">
<tr id="cat">
        <td colspan="6" class="tcat" width="100%"><span class="smallfont"><b>?Top 10 1/4 Mile ETs</b></span></td>
</tr>
<tr>
<td class="alt2" align="center"><span class="smallfont"><b>#</b></span></td>
<td class="alt2" align="center"><span class="smallfont"><b>Username</b></span></td>
<td class="alt2" align="center"><span class="smallfont"><b>Ride</b></span></td>
<td class="alt2" align="center"><span class="smallfont"><b>60'</b></span></td>
        <td class="alt2" align="center"><span class="smallfont"><b>1/4 Mile ET & MPH </b></span></td>
        <td class="alt2" align="center"><span class="smallfont"><b>Slip</b></span></td>
</tr>
$times
<tr>
        <td class="tcat" colspan="6"><span class="smallfont"><CENTER>[<a href=$vboptions[bburl]/timeslips.php>Click here to view the complete list</a>]</CENTER></span></td>
</tr>
</table>
<br />


Create a new template named "times" and add the HTML below:
Code:

<tr>
<td class="alt1" align="center"><span class="smallfont">$rank</span></td>
<td class="alt1" align="center"><span class="smallfont"><a href="$vboptions[bburl]/member.php?$session[sessionurl]u=$userinfo[userid]">$TDusername</a></span></td>
<td class="alt1" align="center"><span class="smallfont">$ride</span></td>
<td class="alt1" align="center"><span class="smallfont">$sixty</span></td>
<td class="alt1" align="center"><span class="smallfont">$quarter$atmph2$quartermph</span></td>
<td class="alt1"><if condition="$tdateline!=''">
<a href="image.php?u=$userinfo[userid]&amp;type=timeslip&amp;dateline=$tdateline" target="_blank"><img src="$stylevar[imgdir_misc]/slipicon.gif" border=0></a>
<else />
$slip
</if></td>
</tr>

Then in your forumhome template put $toptimes where ever you want the Top 10 ETs module to show up.


I haven't tested this but it should work.


Dewayne

Big Kahuna 01-30-2005 01:58 PM

Dude -- you is Da man!

I'll play with that in my test forum this afternoon.

Big Kahuna 01-30-2005 04:30 PM

Almost there -- but not quite

I did everything as instructed -- tried twice to make sure -- and I can get the form built on the index page, but no data in it. I have ten test records in the time slip data base (which displays properly on the complete list page) -- three of which have timeslips loaded. It appears to be something in the search for qualifying records criterea. I'm strickly a cut and paster in php and not capable of understanding why the correct records were not selected for the form on the index page.

Any help will be appreciated

Thanx

BK


All times are GMT. The time now is 04:30 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.01882 seconds
  • Memory Usage 1,765KB
  • 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
  • (6)bbcode_code_printable
  • (4)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