vb.org Archive - vB Timeslip Database - for Automotive websites

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)

Quote:

Originally Posted by hotwheels (Post 1115079)

Okay, i changed the instruction's for uploading the queries, and i changed the instruction's text file to show the same change.........thanks for this information.

queries to run

3.6 Instruction Text

After last count, we have over 40 member's using this update on 3.6........

hotwheels

Alright brother....I think I've waited long enough. I don't see that anyone has put out a specific hack for 3.6.x yet and my patience is done. ;)

I'm gonna give this one a whirl this weekend with your instructions. Now, just because your a Stang enthusiast doesn't mean you gotta stir this Bowtie guy in the wrong direction. :p

Thanks for continuing your work on this Hotwheels. I'll hit you up if I hit some walls brother.

Gonzo

Quote:

Originally Posted by smoknz28 (Post 1120446)

Bro, PLEASE KEEP US INFORMED!!! Us car enthusiast sites need this hack! LOL!

Good luck and if you need a lab rat email me at chris@mustangrodder.com

I used the script and instructions to update my site last week, and I just upgraded the site to 3.6.3 yesterday, and it all appears to be working fine.

Quote:

Now, just because your a Stang enthusiast doesn't mean you gotta stir this Bowtie guy in the wrong direction.

lmao...........I wouldn't do that........hehehehe

Quote:

Originally Posted by 92GreenGT (Post 1120431)

I re-installed the XML file and clicked the overwrite button and it didnt fix it. I took a screenshot to show you what it does, it goes to the "Vehicle Profile" page which isnt even in the User CP options, I believe it used to do this in the 3.5.x version, not sure why its not updated?

Screen:
http://www.fullthrottleforums.com/Pics/Screen.jpg

-Edit-
I dont know if im the only one having this problem(probably is..lol) but if anyone else is having this problem do this:
Open the .xml file in a text editor(I use Notepad II) and go to line 433 and change "edittimeslip" to whatever you want the link to point to, in my case it was just Edit profile so I put in "editprofile" in place of "edittimeslip". Then save the file and upload it with Overwrite selected and your done. :)

Works perfect now, thanks again.

Right on bro, i am very happy that you got it working........only reason i haven't really done much to update this mod, is do to the fact that i never really recieved permission to mess with it. I just wanted to get it working on my website, and after alot of messing around with the code, i got it working and had alot of request's to share what i had done to get it working, hence, my half ass'd update...

K, I tried to help make this a product.......

I need someone with a pretty much a new set up to give this a whirl.....and then let me know what happen's.

I just don't have a way to test at this point since all i have is an online site, i don't have a test site.

Now, If you test this you will need to do all of the file edit's as per my original instructions, accept i added the query's to this, so you hopefully won't need to run the queries seperately......I believe what is happening is that i didn't make a couple change's in death's original .xml file, and when you add the queries, my queries are being overwritten.....Hopefully with the change's i made, you should be able to upload the product, edit your image.php file and it's good to go.....

If you already have this installed but are having issue's with the title's being posted, just upload this .xml and click overwrite......let me know what happens.....

Please remember, i don't claim to be a coder, i am just trying to help make a great product, work again......

This .xml isn't working yet........
hotwheels

I just setup a development site so I can test out mods before putting them on our live site, so I decided to help you out. Well, it didn't get very far...

Code:

Database error in vBulletin 3.6.3:



Invalid SQL:

ALTER TABLE vb_profilefield ADD `title` VARCHAR( 25 ) DEFAULT `aa` NOT NULL AFTER profilefieldid;



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 'aa` NOT NULL AFTER profilefieldid' at line 1

Error Number : 1064

Date         : Sunday, November 19th 2006 @ 09:38:23 AM

Quote:

Originally Posted by wottech (Post 1120847)

I just setup a development site so I can test out mods before putting them on our live site, so I decided to help you out. Well, it didn't get very far...

Code:

Database error in vBulletin 3.6.3:



Invalid SQL:

ALTER TABLE vb_profilefield ADD `title` VARCHAR( 25 ) DEFAULT `aa` NOT NULL AFTER profilefieldid;



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 'aa` NOT NULL AFTER profilefieldid' at line 1

Error Number : 1064

Date         : Sunday, November 19th 2006 @ 09:38:23 AM

okay, that mean's that the query didn't take the 'aa'.......let me do something real quick.....I am helpin smokinZ and if we get this right, i will help ya next.....

I will work on the .xml again and reupload here shortly......

Oh, no need to help me. I have your previous patch working fine on my live site. I was just helping you out since I have a bare 3.6.3 site for development.

I gotcha man..........kewl

The problem with the profile field titles is that the php that generates the timeslip profile page needs changing to pull the names from the phrases not the profilefield table.

Quote:

Originally Posted by Sidewindr (Post 1121293)

The problem with the profile field titles is that the php that generates the timeslip profile page needs changing to pull the names from the phrases not the profilefield table.

I was wondering what the deal with that was. I just looked at the list that was posted a page or 2 ago and entered all of the data manually via phpMyAdmin. Before that, everything just showed up as "aa:" and "a:". I figured it was something I had screwed up or missed in the instructions. I never looked into what the code was doing though...

That's kind of wierd in a way, i just did a fresh install with smokinz28 yesterday, on a site that didn't have timeslips on the site...when completed, it worked out perfectly: http://www.f-bodyhideout.com/forums/timeslips.php?

It has all of the wording, and accept's all of the comands. I even put in my car's timeslip information and it took........I am wondering if my instruction's are kind of confusing since this post is all over the place? I had thought about doing a new thread for vb3.6 since it does update to vb3.6....

The one bit of confusion that i have noticed is about my query run's. If you go to your phpmyadmin, and look in the left hand column for profilefield, you will have to see what your field is named. My profilefield in phpmyadmin is vb3profilefield, some are vbprofilefield, and other's are just profilefield...you need to set the intitial queries to this setting as such:

PHP Code:


		
			
ALTER TABLE `vbprofilefield` ADD `title` VARCHAR( 25 ) DEFAULT 'aa' NOT NULL AFTER `profilefieldid` ;

PHP Code:


		
			
ALTER TABLE `vb3profilefield` ADD `title` VARCHAR( 25 ) DEFAULT 'aa' NOT NULL AFTER `profilefieldid` ;

PHP Code:


		
			
ALTER TABLE `profilefield` ADD `title` VARCHAR( 25 ) DEFAULT 'aa' NOT NULL AFTER `profilefieldid` ;

all this query is doing is adding the word "title" back to the profilefield, it was there on previous version's of vbulletin, but has been removed.

Then the second query is basically the same, you need to see what your profilefield name is, just like above:

PHP Code:


		
			
ALTER TABLE `profilefield` ADD `description` VARCHAR( 250 ) DEFAULT 'a' NOT NULL AFTER `title` ;

PHP Code:


		
			
ALTER TABLE `vb3profilefield` ADD `description` VARCHAR( 250 ) DEFAULT 'a' NOT NULL AFTER `title` ;

PHP Code:


		
			
ALTER TABLE `vbprofilefield` ADD `description` VARCHAR( 250 ) DEFAULT 'a' NOT NULL AFTER `title` ;

All this query is doing is adding the word "description" back to the profile field, again, it was there on previous version's of vbulletin, but has been removed from vb3.6.

These 2 queries, need to be the very first thing you do in order to not get confused on what is happening here. Then, after you run these 2 queries, make the following file edit's:
###### In image.php find:

if ($_REQUEST['type'] == 'profile') // do not modify this $_REQUEST

###### REPLACE IT WITH:

if ($_REQUEST['type'] == 'profile' or $_REQUEST['type'] == 'timeslip') // do not modify this $_REQUEST

###### FIND:

else
{
$table = 'customavatar';
}

###### ABOVE THIS ADD:

else if ($_REQUEST['type'] == 'timeslip')
{
$data = 'timeslippicdata';
$table = 'customfile';
}

###### In member.php find:
// *********************
// CUSTOM PROFILE FIELDS
// CUSTOM PROFILE FIELDS
$profilefields = $db->query_read_slave("
SELECT profilefieldid, required, type, data, def, height
FROM " . TABLE_PREFIX . "profilefield
WHERE form = 0 " . iif(!($permissions['genericpermissions'] & $vbulletin->bf_ugp_genericpermissions['canseehiddencustomfields']), "
AND hidden = 0") . "
ORDER BY displayorder
");

###### Replace it with:

// *********************
// CUSTOM PROFILE FIELDS
$profilefields = $db->query_read_slave("
SELECT profilefieldid, required, title, type, data, def, height
FROM " . TABLE_PREFIX . "profilefield
WHERE profilefieldid NOT IN (50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65) AND form = 0 " . iif(!($permissions['genericpermissions'] & $vbulletin->bf_ugp_genericpermissions['canseehiddencustomfields']), "
AND hidden = 0") . "
ORDER BY displayorder
");

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

'signature',
'profile',

###### Add below:

'vehicleprofile',

###### Find:

// ###################### Start getprofilefields #######################
function fetch_profilefields($formtype = 0) // 0 indicates a profile field, 1 indicates an option field
{

global $vbulletin, $stylevar, $customfields, $bgclass, $show;
global $vbphrase, $altbgclass, $bgclass1, $tempclass;

// get extra profile fields
$profilefields = $vbulletin->db->query_read_slave("
SELECT * FROM " . TABLE_PREFIX . "profilefield
WHERE editable IN (1,2)
AND form " . iif($formtype, '>= 1', '= 0'). "
ORDER BY displayorder
");

###### Replace it with:

// ###################### Start getprofilefields #######################
function fetch_profilefields($formtype = 0) // 0 indicates a profile field, 1 indicates an option field
{

global $vbulletin, $stylevar, $customfields, $bgclass, $show;
global $vbphrase, $altbgclass, $bgclass1, $tempclass;

// get extra profile fields
$profilefields = $vbulletin->db->query_read_slave("
SELECT * FROM " . TABLE_PREFIX . "profilefield
WHERE profilefieldid NOT IN (50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65) AND editable IN (1,2)
AND form " . iif($formtype, '>= 1', '= 0'). "
ORDER BY displayorder
");

###### In your USERCP_SHELL template find:

<tr>
<td class="$navclass[profile]" nowrap="nowrap"><a class="smallfont" href="profile.php?$session[sessionurl]do=editprofile">$vbphrase[edit_profile]</a></td>
</tr>

###### Below it add:

<tr>
<td class="$navclass[vehicleprofile]" nowrap="nowrap"><a class="smallfont" href="profile.php?$session[sessionurl]do=edittimeslip">$vbphrase[edit_timeslip]</a></td>
</tr>

###### In your navbar template find:

<td class="vbmenu_control"><a href="memberlist.php?$session[sessionurl]">$vbphrase[members_list]</a></td>

###### Below it add:

<td class="vbmenu_control"><a href="timeslips.php?$session[sessionurl]">$vbphrase[timeslips]</a></td>

Once these edit's are completed and saved back into your site's database, upload timeslips.php to your forum's root directory (/forums/) then // Upload slipicon.gif to your forum's misc image directory (/forums/images/misc/) or what ever your forums root directory is. Mine happen's to be forums/.....

After all of this has been done, you will now Go to your product link, then add new product by uploading the product-timeslips.xml file.

If you did this step by step, you shoudn't see the "aa" or the "a"......

However, if you have already run the query and are having issue's with this not showing correctly, go back to your phpmyadmin, open the profilefield, and look to see if you have the word "title" and "description" in there. If so, put a check mark in front of "title" and "description", and look up just a bit and click on the word "drop", this will remove "title" and "description" from your server. With that done, run the query that best fit's your site from the above queries (Still in phpmyadmin), look at the left navigation bar, and up at the top, the third icon over "sql", is where you need to run the queries from.

After you have rerun the queries, and you know for sure that you have all the file edit's done, go back to your admincp, and rerun the product timeslips.xml, and select overwrite......now check your www/yoursite/forums/timeslips.php and see what is there, and then click on submit your timeslip at the bottom of the box that appears.....It may take about 15 minutes to reupdate depending on the size of your site, but it WILL work......

hotwheels

I havent stayed up on this thread and am now confused.... what do I need to do to mine? Thanks!!!!!!!!!!!!!!!!!!!!1
http://www.turbo-mopar.com/forums/timeslips.php

Frank

I'm so lost I need a compass to get back. lol
A new thread relating to 3.6.3 would rawk!
Thanks.

Just use this thread that i made a few post's back..... how to

Rather than re-adding the titles into the profilefield it would be far better for soomeone to fix the section of code in the xml that calls the profile fields and titles to address the titles in their new location. I have had a look but it is beyond my abilities :(

Ok, here is an updated product XML. From what I saw, there was an error in the ALTER TABLE syntax when setting the default values. So I just removed that part of the SQL and it worked.

FYI, I am currently running 3.6.3, so it appears to be working on that.

I'll take a look, wottech
Thanks.

Yeah it's pretty confusing. I'd love to get this going on my forum again, but am kind of scared to jack up my site, I'm not too good with this stuff to begin with :D I've still got leftovers from vbendix that I wish I could get rid of... :(

Quote:

Originally Posted by hotwheels (Post 1115079)

I never ran any queries, but I did use your instructions and it worked beautifully.

Kick ass man. Thanks!

For anyone wanting to get this working, open his instructions.txt file and follow it. You can't go wrong.

Right on bro, thanks for letting me know it's workin...........that rocks

Quote:

Originally Posted by Zachariah (Post 1123282)

I'll take a look, wottech
Thanks.

Any update on your progress with a 3.6 version that uses it's own tables instead of custom profile fields?

Thx

<a href="http://forums.maxima.org/timeslips.php?" target="_blank">http://forums.maxima.org/timeslips.php?</a>

Quote:

Originally Posted by doug97gxe (Post 1127262)

http://forums.maxima.org/timeslips.php?

Ok, but you are running vB3.5.2. Most of the discussions now are concerning making it work on vB3.6.x.

Right on rcull, i checked your site and saw you were able to get the timeslip's working.........congrats

I tried upgrading mine and get this when uploading the xml a few posts back

atal error: Call to a member function on a non-object in /home/txxxxxx/public_html/forum/admin/plugin.php(1941) : eval()'d code on line 5

How to
and use the .xml that come's with the original down load up at the top

Quote:

Timeslip 3.5 v1.1.4.zip (15.9 KB, 420 downloads)

That should hook ya up........

Quote:

Originally Posted by hotwheels (Post 1130370)

How to
and use the .xml that come's with the original down load up at the top

That should hook ya up........

I have the tables in the sql database
did the file edits and template edits
and have tried uploading the xml

Just gets same error

Quote:

Importing Product, Please Wait...

[:]

Fatal error: Call to a member function on a non-object in /home/taxxxxx/public_html/forum/admin/plugin.php(1941) : eval()'d code on line 5

Line 1941 of plugin.php is

Quote:

eval($code['installcode']);

line 5 of xml is

Quote:

<description>Time Slips Database for vb3.5</description>

I have mine working sorta http://www.talonclub.com/forum/timeslips.php?

wanted the details link to point to the right page rather than just the usercp the way it does now ...

When you are uploading the .xml, are you selecting override "yes"?

If you are just wanting to change this

Quote:

[Enter your timeslip data by editing your profile in User CP ]

Just go to your admincp, style and templates, and open up your site's main style << >>.......Then scroll down and look for template named "timeslips".....and open it.

Scroll down toward's the bottom of the page and locate this: $timeslipsbit and then replace the code below it with this:

PHP Code:


		
			
<tr>

    <td class="tfoot" colspan="10">

<!-- please don't remove this -->

<font size="1"><center>[vBTimeslipDatabasev2.0 by <b><a href=http://modernmusclecars.net>EvilLS1</a></b>.Converted to vb3.5 by <b><a href="mailto:deathemperor@gmail.com">deathemperor</a></b>]</center></font>

</td>

</tr>

</table>

</table>

<font size="1"><a href="profile.php?$session[sessionurl]&do=edittimeslip">$vbphrase[timeslips_submit]</a></font>

</td></tr></table>

<br />$pagenav

$footer

</body>

</html>

and then save it. Now when you go back to your site, you should see: " Submit your timeslip data" instead of "Enter your timeslip data by editing your profile in User CP"

I think that's what you are wanting to do anyways from looking at your timeslips page.

Thanks for you help
I tried over writing it - no change

Most of the code you posted was commented out

I added it back - it does the same as it used to it opens a plank page...

the hack I did to open peoples profile page at least lets them edit the content - its not pretty but it worked

Hi everyone,

I've upgraded this hack for vb3.6.4 but currently it only supports new installations. I will have to set up the old one, then starting coding the upgrade. I will release both type when I finish it but if you guys want the new one first I will release it first.

Thanks for all of the interests, I was kind of lazy.

Quote:

Originally Posted by deathemperor (Post 1130486)

That is awesome........I would surely hope you post both version's.....anything at this point will be better then my attempt at it.........woot

would this work on 3.6.4

lok up 2 post haha can't wait for this to work on 3.6.4 lookin to upgrade this soon I'm on 3.6.4 now but the timeslips work to an extent not all like the details art.

I have it working on 3.6.4 following hotwheel's installation instructions. I skipped the steps to add the tables as I already had them from my 3.6.0 upgrade. I then edited all php files.

http://www.buckeyestangs.com/vb/timeslips.php? Located here if you want to see it working.

Quote:

Originally Posted by deathemperor (Post 1130486)

where can i get a copy of this??? i just got VB soo this would be a completely fresh install

well I can't wait too. I've just got a new job and is kind of busy, I work 9 hours a day. This is what I've done. Although tested in my localhost for new installation and upgrade, please report if you guys found any problems and I will fix it when I get home.

https://vborg.vbsupport.ru/attachmen...1&d=1165331404

This works with 3.6.3 on my localhost, I beleive it work for 3.6.4 too.

First post edited a bit, I'll be sending update emails for installed users.

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01717 seconds Memory Usage 1,900KB 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 (2)bbcode_code_printable (7)bbcode_php_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
Messages: