vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Add-On Releases - VB Pro Garage Timeslips (https://vborg.vbsupport.ru/showthread.php?t=236888)

BlackJacket 03-01-2010 12:37 AM

Thought of a cool feature -

If the person has not added a vehicle to the garage, a PM, or notification could show up reminding them to add a vehicle.

It could be on a time delay. x number of days after registering they see a notification that they have not yet added their vehicle to the garage.

:)

Dylanblitz 03-01-2010 04:50 AM

Quote:

Originally Posted by BlackJacket (Post 1994156)
Thought of a cool feature -

If the person has not added a vehicle to the garage, a PM, or notification could show up reminding them to add a vehicle.

It could be on a time delay. x number of days after registering they see a notification that they have not yet added their vehicle to the garage.

:)

Yeah, I can put that in 2.2.x
I'll just create a disabled scheduled task to do it, if an admin wants to turn it on then it'll do the work.

BlackJacket 03-01-2010 11:42 AM

Quote:

Originally Posted by Dylanblitz (Post 1994248)
Yeah, I can put that in 2.2.x
I'll just create a disabled scheduled task to do it, if an admin wants to turn it on then it'll do the work.

Thanks. I think that would be a great feature. :)

BlackJacket 03-01-2010 04:32 PM

Also - For the menu tab, we currently have Enabled and Admin Only available. Could you add a "Disabled" option? I use a tab plugin so i see 2 garage tabs lol.

Thanks again! :)

BlackJacket 03-01-2010 04:49 PM

Just got a report from some users that they are getting a Database error when adding a vehicle. I tested this to verify. Here is the error -

Code:

Database error in vBulletin 4.0.2:

Invalid SQL:
INSERT INTO garage_user_vehicle (user_id, made_year, engine_type, veh_class, color, mileage, mileage_unit_new, fuel_preference, price, currency, comments, views, money_spent, avg_rating, date_created, date_updated, make_id, model_id, trim_id, main_vehicle, vehicle_url, purchase_month, purchase_day, purchase_year, active) VALUES ('3', '2009', '7', '', 'Black', '20000', '1', '', '', '', 'Test', '0', '0', '0', '1267469241', '1267469241', '57', '1124', '696', '0', '', '03', '01', '2010', '1');

MySQL Error  : Unknown column 'money_spent' in 'field list'
Error Number  : 1054
Request Date  : Monday, March 1st 2010 @ 11:47:18 AM
Error Date    : Monday, March 1st 2010 @ 11:47:21 AM
Script        : http://www.*edited*.com/community/garage_vehicle.php
Referrer      : http://www.*edited*.com/community/garage_vehicle.php?do=add_vehicle
IP Address    : *edited*
Username      : *edited*
Classname    : vB_Database
MySQL Version : 5.0.67.d7-ourdelta-log


Dylanblitz 03-01-2010 07:41 PM

Quote:

Originally Posted by BlackJacket (Post 1994574)
Just got a report from some users that they are getting a Database error when adding a vehicle. I tested this to verify. Here is the error -

Code:

Database error in vBulletin 4.0.2:

Invalid SQL:
INSERT INTO garage_user_vehicle (user_id, made_year, engine_type, veh_class, color, mileage, mileage_unit_new, fuel_preference, price, currency, comments, views, money_spent, avg_rating, date_created, date_updated, make_id, model_id, trim_id, main_vehicle, vehicle_url, purchase_month, purchase_day, purchase_year, active) VALUES ('3', '2009', '7', '', 'Black', '20000', '1', '', '', '', 'Test', '0', '0', '0', '1267469241', '1267469241', '57', '1124', '696', '0', '', '03', '01', '2010', '1');

MySQL Error  : Unknown column 'money_spent' in 'field list'
Error Number  : 1054
Request Date  : Monday, March 1st 2010 @ 11:47:18 AM
Error Date    : Monday, March 1st 2010 @ 11:47:21 AM
Script        : http://www.*edited*.com/community/garage_vehicle.php
Referrer      : http://www.*edited*.com/community/garage_vehicle.php?do=add_vehicle
IP Address    : *edited*
Username      : *edited*
Classname    : vB_Database
MySQL Version : 5.0.67.d7-ourdelta-log


Dang, thought I got that cleaned out.
I'll fix it in the next update. For a manual fix for now

Open includes/garage_func_var.php
At line 1392 Find

PHP Code:

$adding $db->query_write("INSERT INTO " TABLE_PREFIX "garage_user_vehicle (user_id, made_year, engine_type, veh_class, color, mileage, mileage_unit_new, fuel_preference, price, currency, comments, views, money_spent, avg_rating, date_created, date_updated, make_id, model_id, trim_id, main_vehicle, vehicle_url, purchase_month, purchase_day, purchase_year, active) VALUES ('$data[userid]', '$data[made_year]', '$data[engine_type]', '$data[veh_class]', '$data[color]', '$data[mileage]', '$data[mileage_unit]', '$data[fuel_preference]', '$data[price]', '$data[currency]', '$data[comments]', '$data[views]', '$data[money_spent]', '$data[avg_rating]', '$data[date_created]', '$data[date_updated]', '$data[make_id]', '$data[model_id]', '$data[trim_id]', '$data[main_vehicle]', '$data[vehicle_url]', '$data[purchase_month]', '$data[purchase_day]', '$data[purchase_year]', '$active')"); 

Replace with

PHP Code:

$adding $db->query_write("INSERT INTO " TABLE_PREFIX "garage_user_vehicle (user_id, made_year, engine_type, veh_class, color, mileage, mileage_unit_new, fuel_preference, price, currency, comments, views, avg_rating, date_created, date_updated, make_id, model_id, trim_id, main_vehicle, vehicle_url, purchase_month, purchase_day, purchase_year, active) VALUES ('$data[userid]', '$data[made_year]', '$data[engine_type]', '$data[veh_class]', '$data[color]', '$data[mileage]', '$data[mileage_unit]', '$data[fuel_preference]', '$data[price]', '$data[currency]', '$data[comments]', '$data[views]', '$data[avg_rating]', '$data[date_created]', '$data[date_updated]', '$data[make_id]', '$data[model_id]', '$data[trim_id]', '$data[main_vehicle]', '$data[vehicle_url]', '$data[purchase_month]', '$data[purchase_day]', '$data[purchase_year]', '$active')"); 


Dylanblitz 03-01-2010 07:42 PM

Quote:

Originally Posted by BlackJacket (Post 1994568)
Also - For the menu tab, we currently have Enabled and Admin Only available. Could you add a "Disabled" option? I use a tab plugin so i see 2 garage tabs lol.

Thanks again! :)

Yeah I'll fix that in the next update.

BlackJacket 03-01-2010 10:16 PM

Quote:

Originally Posted by Dylanblitz (Post 1994690)
Dang, thought I got that cleaned out.
I'll fix it in the next update. For a manual fix for now

Open includes/garage_func_var.php
At line 1392 Find

PHP Code:

$adding $db->query_write("INSERT INTO " TABLE_PREFIX "garage_user_vehicle (user_id, made_year, engine_type, veh_class, color, mileage, mileage_unit_new, fuel_preference, price, currency, comments, views, money_spent, avg_rating, date_created, date_updated, make_id, model_id, trim_id, main_vehicle, vehicle_url, purchase_month, purchase_day, purchase_year, active) VALUES ('$data[userid]', '$data[made_year]', '$data[engine_type]', '$data[veh_class]', '$data[color]', '$data[mileage]', '$data[mileage_unit]', '$data[fuel_preference]', '$data[price]', '$data[currency]', '$data[comments]', '$data[views]', '$data[money_spent]', '$data[avg_rating]', '$data[date_created]', '$data[date_updated]', '$data[make_id]', '$data[model_id]', '$data[trim_id]', '$data[main_vehicle]', '$data[vehicle_url]', '$data[purchase_month]', '$data[purchase_day]', '$data[purchase_year]', '$active')"); 

Replace with

PHP Code:

$adding $db->query_write("INSERT INTO " TABLE_PREFIX "garage_user_vehicle (user_id, made_year, engine_type, veh_class, color, mileage, mileage_unit_new, fuel_preference, price, currency, comments, views, avg_rating, date_created, date_updated, make_id, model_id, trim_id, main_vehicle, vehicle_url, purchase_month, purchase_day, purchase_year, active) VALUES ('$data[userid]', '$data[made_year]', '$data[engine_type]', '$data[veh_class]', '$data[color]', '$data[mileage]', '$data[mileage_unit]', '$data[fuel_preference]', '$data[price]', '$data[currency]', '$data[comments]', '$data[views]', '$data[avg_rating]', '$data[date_created]', '$data[date_updated]', '$data[make_id]', '$data[model_id]', '$data[trim_id]', '$data[main_vehicle]', '$data[vehicle_url]', '$data[purchase_month]', '$data[purchase_day]', '$data[purchase_year]', '$active')"); 


That fixed it. Thanks!

Quote:

Originally Posted by Dylanblitz (Post 1994691)
Yeah I'll fix that in the next update.

Thanks again for your hard work. :)

venom2124 03-02-2010 12:49 AM

Okay just was playing with the vehicle options and I went to select a featured vehicle and got the following database error.

Quote:

Database error in vBulletin 4.0.1:

Invalid SQL:
INSERT INTO garage_special_track (vehicle_id, track_type, date_created) VALUES ('11', 'featured', '1267497876');

MySQL Error : Table 'coloradohpj.garage_special_track' doesn't exist
Error Number : 1146
Request Date : Monday, March 1st 2010 @ 07:44:36 PM
Error Date : Monday, March 1st 2010 @ 07:44:36 PM
Script : http://www.coloradohpjunkies.com/for..._vehicle&id=11
Referrer : http://www.coloradohpjunkies.com/for..._vehicle&id=11
IP Address :
Username : fox_body_stang
Classname : vB_Database
MySQL Version : 4.1.22-max-log
When I select VOTM nomination is get the following database error.

Quote:

Database error in vBulletin 4.0.1:

Invalid SQL:
INSERT INTO garage_special_track (vehicle_id, track_type, date_created) VALUES ('11', 'votm', '1267497985');

MySQL Error : Table 'coloradohpj.garage_special_track' doesn't exist
Error Number : 1146
Request Date : Monday, March 1st 2010 @ 07:46:25 PM
Error Date : Monday, March 1st 2010 @ 07:46:25 PM
Script : http://www.coloradohpjunkies.com/for..._vehicle&id=11
Referrer : http://www.coloradohpjunkies.com/for..._vehicle&id=11
IP Address :
Username : fox_body_stang
Classname : vB_Database
MySQL Version : 4.1.22-max-log
So not sure what's missing or causing the error but any help would be great. Now after i get the error if I refresh the previous page it will show me that the vehicle I was trying to make the VOTM is the VOTM.

ChopSuey 03-02-2010 02:53 AM

To get the links to show in custom styles add this
HTML Code:

<vb:if condition="THIS_SCRIPT != 'garage'">
                <li><a href="http://www.pgtrackandsled.ca/forum/garage.php">Garage</a></li>
</vb:if>
<vb:if condition="THIS_SCRIPT == 'garage'">
                <li><a href="#">Garage</a>
                        <ul class="drop">
<li><a href="http://www.pgtrackandsled.ca/forum/garage.php" title="Main">Main</a></li>
<li><a href="http://www.pgtrackandsled.ca/forum/garage_vehicle.php?do=add_vehicle" title="Add Vehicle">New Entry</a></li>
<li><a href="http://www.pgtrackandsled.ca/forum/garage.php?do=browse" title="Browse">Browse</a></li>
<li><a href="http://www.pgtrackandsled.ca/forum/garage.php?do=search" title="Search">Search</a></li>
<li><a href="http://www.pgtrackandsled.ca/forum/garage.php?do=timeslip" title="Timeslips">Timeslips</a></li>
</ul>
</li>
</vb:if>
</li>

Of course change the links to yours.
It drops down on hover, its a drop down menu
view here http://www.pgtrackandsled.ca/forum/garage.php


All times are GMT. The time now is 06:59 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.02043 seconds
  • Memory Usage 1,835KB
  • 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
  • (1)bbcode_html_printable
  • (4)bbcode_php_printable
  • (8)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (4)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