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)

EvilLS1 07-05-2004 09:59 PM

Quote:

Originally Posted by Sidewindr
Roger wilco :)

Any idea on when you might be looking at the next version ?? :nervous: :o

It will probably be a while as I'm working 6 and sometimes 7 days per week right now and don't have much free time to fool with hacks.

In the mean time, if you have basic knowledge of php you can see how to add new fields in this example:
https://vborg.vbsupport.ru/showpost....&postcount=247

The example shows how to add and sort by a "class" field. But that should give you a general idea on how to add your diff. field.

350Chevy 07-05-2004 10:15 PM

Quote:

Originally Posted by EvilLS1
If you recently upgraded to vB 3.0.2 or later and you're having trouble with the timeslips page showing all users regardless if they have an ET or not then please replace your timeslips.php with the correct one for your version (attached below).

Also, if you had already installed vB Timeslip Database before upgrading your forums to v3.0.2 or later you'll need to upload the attached file (TD302.php) to your admincp directory and run it. The upgrade script for vB 3.0.2 sets the custom user fields to medium text. Some of the timeslip fields must be set to DECIMAL in order for the timeslips page to sort them correctly. The attached file (TD302.php) will correct that for you. If you've installed the Timeslip Database AFTER upgrading to 3.0.2 you can skip this part.


Works like a charm on vB 3.0.3 Thnx! :D

PranK 07-05-2004 11:15 PM

Quote:

Originally Posted by EvilLS1
If you recently upgraded to vB 3.0.2 or later .....

Top effort! Thanks EvilS1!

Christian

Sidewindr 07-05-2004 11:20 PM

Thanks EvilLS1 I will have a crack at adding the Diff ratio as field 66 :D

In the interim how would I manually put the timeslip in as a blob in the database directly ?? Really need the admins to be able to upload people's timeslips as well as the user doing it :(

PranK 07-05-2004 11:22 PM

EvilS1 - I get SQL errors when running TD302.php and timeslips.php. This is cause you and I had to change my install to different numbers. My profile ID's for the timeslips are all in the 80's and 90's. What I need to know is what numbers correspond to what, so I can edit the files.

Thanks.

PranK 07-05-2004 11:41 PM

Quote:

Originally Posted by PranK
EvilS1 - I get SQL errors when running TD302.php and timeslips.php. This is cause you and I had to change my install to different numbers. My profile ID's for the timeslips are all in the 80's and 90's. What I need to know is what numbers correspond to what, so I can edit the files.

Thanks.

Ok, I fixed the profile id's, but now I am getting an sql error about the table 'customtimeslipspic' - i dont have it...

EvilLS1 07-05-2004 11:41 PM

Quote:

Originally Posted by Sidewindr
Thanks EvilLS1 I will have a crack at adding the Diff ratio as field 66 :D

In the interim how would I manually put the timeslip in as a blob in the database directly ?? Really need the admins to be able to upload people's timeslips as well as the user doing it :(

Sidewindr,
If you really need the ability to upload timeslips for your users I'd suggest installing the "login as user" hack. Then if someone just can't figure out how to upload a slip for themselves you can login to their account and do it for them. I highly doubt you'll have to do that often anyway b/c most users should be able to figure out how to upload their own slip.


Quote:

Originally Posted by PranK
EvilS1 - I get SQL errors when running TD302.php and timeslips.php. This is cause you and I had to change my install to different numbers. My profile ID's for the timeslips are all in the 80's and 90's. What I need to know is what numbers correspond to what, so I can edit the files.

Thanks.

Prank,
If memory serves, your profile fields are 80-95.

To keep from having to manually edit all the fields in timeslips.php just open your old timeslips.php and find all instances of this:
Code:

'".intval($number)."'
And replace all of them with this:
Code:

0
Then upload the attached TD302.php file to your admincp directory and run it (I already edited the fields for you).

PranK 07-05-2004 11:41 PM

damn it... :D

EvilLS1 07-05-2004 11:42 PM

Quote:

Originally Posted by PranK
Ok, I fixed the profile id's, but now I am getting an sql error about the table 'customtimeslipspic' - i dont have it...

Thats because you uploaded the timeslips.php for version 2.1. You still have v2.0.

PranK 07-05-2004 11:59 PM

ahhhhh ok cool, thanks.

PranK 07-06-2004 12:06 AM

sweet - all fixed now, thanks EvilS1!!

Christian

EvilLS1 07-06-2004 12:10 AM

Glad it worked Christian. :)

BTW, I noticed that the footer of your timeslips page doesn't extend all the way accross now that you've added a link to the vbgarage. To fix it, in your timeslips template find this:
Code:

<td class="tfoot" colspan="10">
and replace it with this:
Code:

<td class="tfoot" colspan="11">
Dewayne

dmark101 07-06-2004 07:02 PM

Quote:

Originally Posted by EvilLS1
If you recently upgraded to vB 3.0.2 or later and you're having trouble with the timeslips page showing all users regardless if they have an ET or not then please replace your timeslips.php with the correct one for your version (attached below).

Also, if you had already installed vB Timeslip Database before upgrading your forums to v3.0.2 or later you'll need to upload the attached file (TD302.php) to your admincp directory and run it. The upgrade script for vB 3.0.2 sets the custom user fields to medium text. Some of the timeslip fields must be set to DECIMAL in order for the timeslips page to sort them correctly. The attached file (TD302.php) will correct that for you. If you've installed the Timeslip Database AFTER upgrading to 3.0.2 you can skip this part.

i just upgraded my site from RC3 to 3.0.3 and i noticed that the timeslips.php wasn't working right, so i did as you suggested and that works fine now.

the only problem i am still having is the 'edit vehicle profile' does not take me to the vehicle profile fields. instead, i get a blank page. now i did notice the vehicle stats are on the regular profile page.

how can i fix that?

EvilLS1 07-06-2004 08:28 PM

Quote:

Originally Posted by dmark101
i just upgraded my site from RC3 to 3.0.3 and i noticed that the timeslips.php wasn't working right, so i did as you suggested and that works fine now.

the only problem i am still having is the 'edit vehicle profile' does not take me to the vehicle profile fields. instead, i get a blank page. now i did notice the vehicle stats are on the regular profile page.

how can i fix that?

That sounds as if you forgot to re-do the file edits in a couple of files (functions_user.php, profile.php, & member.php). Did you re-apply the file edits after upgrading? Even if you did, double check them to make sure they're correct.

If it still doesn't work login to your admincp and go to "manage custom profile fields". Hold your mouse over the timeslip fields and verify that the field IDs are from 50-65. If not, tell me what the IDs are.

dmark101 07-07-2004 01:44 AM

that did the trick. thanks again. this mod rawks! :)

Sidewindr 07-07-2004 01:23 PM

Quote:

Originally Posted by EvilLS1
It will probably be a while as I'm working 6 and sometimes 7 days per week right now and don't have much free time to fool with hacks.

In the mean time, if you have basic knowledge of php you can see how to add new fields in this example:
https://vborg.vbsupport.ru/showpost....&postcount=247

The example shows how to add and sort by a "class" field. But that should give you a general idea on how to add your diff. field.


Ok added the Diff field .. can you reserver field66 for Diff ratio, it's a DECIMAL 3,2 btw ;)

I will have a bit of a poke around and see if I can somehow replicate the upload timeslip into the user admin section of the forum. I don't want to add any hacks like "logon as user" etc as they go against my privacy morals etc. Same as reading users PM's etc.

tteal 07-12-2004 09:33 PM

Evil,
You still have any plans for multiple timeslips per user? That would be great for those of us that drag race and want to compare modifications vs ET and also keep a good running inventory. Have you also thought about modifications per date? If you're like me, I like to find out if modification "X" did anything or not and can compare those mods vs older mods (per date/time).

Just some suggestions.

Thanks once again for writing all of this code and supporting it as well. I very much appreciate your efforts a ton!

Cheers,
Tim

EvilLS1 07-12-2004 09:48 PM

Tim,
I've made notes of requested features for future versions but to be honest it will probably be a while before I release anymore updates b/c I'm working 6 & 7 days per week right now and don't have much free time to work on anything.

I will keep your suggestions in mind though. Thanks. :)

Dewayne

tteal 07-12-2004 09:50 PM

Quote:

Originally Posted by EvilLS1
Tim,
I've made notes of requested features for future versions but to be honest it will probably be a while before I release anymore updates b/c I'm working 6 & 7 days per week right now and don't have much free time to work on anything.

I will keep your suggestions in mind though. Thanks. :)

Dewayne

Dewayne,
Not a problem at all bro, we have plenty of time and they are just that ---- suggestions. By the way, my turd goes to the dyno 20 July so we'll see what kind of #'s she makes with the new combination. Cross fingers and hope for the best.

Tim

EvilLS1 07-12-2004 10:09 PM

Quote:

Originally Posted by tteal
Dewayne,
By the way, my turd goes to the dyno 20 July so we'll see what kind of #'s she makes with the new combination. Cross fingers and hope for the best.

Tim

Good luck @ the dyno! Keep me posted on how it goes. :)

pgp2003 07-20-2004 05:19 PM

I just get a blank page when I try to Edit the timeslip info... http://www.nostreetracing.org/main/

EvilLS1 07-20-2004 06:53 PM

Quote:

Originally Posted by pgp2003
I just get a blank page when I try to Edit the timeslip info... http://www.nostreetracing.org/main/

It can only be one of two things, either a missed edit to profile.php or a misspelled template name. First open profile.php and verify that you added this bit of code:

Code:

// ############################### EDIT VEHICLE PROFILE #######################
if ($_REQUEST['do'] == 'edittimeslip')
{

  if ($bbuserinfo[userid]==0  or $bbuserinfo[tdban]==0)
{
        print_no_permission();
  }


        unset($tempcustom);
        exec_switch_bg();
        // Get Custom profile fields
        $customfields = array();
        fetch_timeslipfields(0);

if ($vboptions[allowtimeslipupload]){
                $timeslippic = $DB_site->query_first("
                        SELECT userid, dateline
                        FROM " . TABLE_PREFIX . "customtimeslippic
                        WHERE userid = $bbuserinfo[userid]
                ");

                if ($timeslippic)
                {
                        $timeslippicchecked[1] = HTML_CHECKED;
                        $timeslippicchecked[0] = '';
                }
                else
                {
                        $timeslippicchecked[1] = '';
                        $timeslippicchecked[0] = HTML_CHECKED;
                }               
}

        // draw cp nav bar
        construct_usercp_nav('vehicleprofile');

        $navbits[''] = $vbphrase['edit_timeslip'];
        $templatename = 'modifytimeslip';
}
// ############################### 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]");
        }
if ($vboptions[allowtimeslipupload]){

        globalize($_POST, array('timeslippic' => INT, 'avatarurl' => STR));

        if ($timeslippic==1)
        {
                require_once('./includes/functions_upload.php');
                process_image_upload('timeslippic', $avatarurl);
        }
        else if ($timeslippic==0)
        {
                $DB_site->query("DELETE FROM " . TABLE_PREFIX . "customtimeslippic WHERE userid = $bbuserinfo[userid]");
        }
}

$url = "timeslips.php?$session[sessionurl]";
        eval(print_standard_redirect('redirect_updatethanks'));

}

If so, check the spelling and contents of your modifytimeslip template.

BTW, I tried to register on your site so that I could see for myself but I just get a blank page when I submit my registration info. This hack makes no edites to register.php so something else is causing that.

pgp2003 07-20-2004 08:03 PM

I already checked both template names and profile.php already... and it seems to be okay.. but I will redo profile.php again..

and as for register.php, thanks for catching that... The only mod that made changes in that file was the award hack... good thing I didn't try it on my other forum :)

I will let you know how things go as soon as I try it again

bmx269 07-27-2004 12:17 AM

Installed it on K-Series.com. Love it. Thanks.

-Trent

Sidewindr 07-27-2004 05:44 AM

Anyone got the Top 5 Times mod working for vBadvanced CMPS ??

Help!! :)

tteal 07-28-2004 01:42 AM

Dewayne (EvilLS1),
FYI I just dyno'd last Tuesday ---- 456.9rwhp/388rwtq and ran out of fuel pump/system at only 6k rpm. Going to upgrade.

Quick question actual request. I somehow mucked up my timeslip database... all of the info exists, however, I think I messed up field55 somehow. Anyway that you could tell me the structure of what belongs in there so I can use phpmyadmin to fix it? all of my timeslips won't show now. That will teach me to try and install another tool :)

Thanks,
Tim

EvilLS1 07-28-2004 02:14 AM

Nice numbers Tim!

To re-add field55, first make sure that field55 has been completely removed from the profilefield and userfield tables. Then upload this script to the admincp directory and run it. Keep in mind that doing this will cause everyone to have to re-enter thier info for that field. If you just want to see the structure open the file and take a look.

Later,
Dewayne

tteal 07-28-2004 02:22 AM

Quote:

Originally Posted by EvilLS1
Nice numbers Tim!

To re-add field55, first make sure that field55 has been completely removed from the profilefield and userfield tables. Then upload this script to the admincp directory and run it. Keep in mind that doing this will cause everyone to have to re-enter thier info for that field. If you just want to see the structure open the file and take a look.

Later,
Dewayne

DeWayne,
Thanks for teh quick resopnse. I figured it out and just manually input'd all of the data. I had custom fields with the ET in there so I used that. I didn't want to lose all that data :) Thanks!!!!!!!!

tbroush 07-28-2004 03:26 AM

I just added this to my website, I try to run the td302.php and I got a database error, but it seems to be working correctly, can you please check it out and let me know if there is something missing thanks.

http://www.modernmustangs-na.com/forums

EvilLS1 07-28-2004 03:33 AM

Quote:

Originally Posted by scroush
I just added this to my website, I try to run the td302.php and I got a database error, but it seems to be working correctly, can you please check it out and let me know if there is something missing thanks.

http://www.modernmustangs-na.com/forums

You don't need to run td302.php since this is a fresh install. Thats only for people who had installed the hack prior to upgrading to VB 3.0.2 or later.

Yours seems to be working just fine. :)

tbroush 07-28-2004 03:47 AM

Quote:

You don't need to run td302.php since this is a fresh install. Thats only for people who had installed the hack prior to upgrading to VB 3.0.2 or later.
Doh, thanks it looks awesome.

Carlos

DJCobol 07-29-2004 03:12 AM

Having a small problem with my install of this mod. After entering my info, nothing shows up on the listing page, even after uploading the new timeslips.php page. Any ideas?

Site is http://www.michiganspeed.com/testforums/timeslips.php?

EvilLS1 07-29-2004 09:50 AM

DJCobol,
Check to make sure that the name of the timeslipsbit template is spelled correctly. Its timeslipsbit not timeslipbit.

DJCobol 07-29-2004 10:47 AM

Well now, dont I feel like an idiot? :)

Thanks for your help man. This is an awesome mod!

EvilLS1 07-29-2004 12:07 PM

Quote:

Originally Posted by DJCobol
Well now, dont I feel like an idiot? :)

Thanks for your help man. This is an awesome mod!

N/P. Glad you like it. :)

0ptima 08-01-2004 10:13 PM

I upgraded from VB 3.01 - 3.03 and upgrade this hack to 2.01. Took a bit of time, but the instructions were easy to follow. Thanks again for a great hack!

EvilLS1 08-01-2004 11:29 PM

Y/W Optima. :)

Sidewindr 08-01-2004 11:37 PM

Any chance of the Top 5 Times Mod/Module for vBadvanced CMPS ?? :)

EvilLS1 08-02-2004 12:11 AM

Sidewindr,
The problem is that I don't use CPMS so I have no way of testing it. But just by looking at the hack I think you'd need to create a php file containing the query for the top 5 addon and upload it to the modules directory. Then add the templates as you normally would and set up the module in the admincp.

Here, I'll attach a file and some instructions to try. I have no idea if it'll work b/c I have no way to test it and I'm not really sure how CPMS works. If it still doesn't work you could try asking Tigga about it at the vbadvanced website.

Limey-YMR 08-05-2004 01:25 AM

Great Hack, Thanks

Can you add our link?

http://www.ymrforums.com/timeslips.php


All times are GMT. The time now is 10:51 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.01608 seconds
  • Memory Usage 1,855KB
  • 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
  • (5)bbcode_code_printable
  • (17)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