The Arcive of Official vBulletin Modifications Site.

vBGarage v3.1.1 (now with GD-Lib support!) · **Released**: 04-08-2004

[high]***[/high]CLICK HERE FOR vB3.0.5 INSTALLER/UPDATE[high]***[/high]

vBGarage v3.1.1 (now with GD-Lib support!)

Description
This hack will allow your users to create a virtual garage where they can store photos, details, etc.. about their vehicle (this can be modified to suit forums of other interests).

Latest Uploads will be displayed on Garage List.

Forum users can now leave comments in member garages.

Admin functions are available in the AdminCP.

This version contains the ability to limit access by usergroup(s). All templates are 100% XHTML Verified!

Information
Tested and developed on vB 3.0.0 Gold.

Requires
GD 2.0+ Library

Demo
http://www.sffba.net/forum/vbgarage.php?do=list (Temporary)

This hack, as like the rest of my hacks, are FREE. However, if you enjoy this hack and feel the need to donate something for my time you can do so by clicking the icon below:

*NOTE: Those who donate are explicitly granted permission to remove the "Powered by" information from the vBGarage footer.

*NOTE: When donating, please include your forum url. Thanks!

Version History
v3 - Initial release. Let's hope I don't have alot of entries here.

v3.0.1 - Added GD-Lib Support!
v3.1.0 - Added User Comments, Latest Uploads on Garage List, AdminCP Options
v3.1.1 - Added ability for Admin to "edit" users' garages. Use ImageCopyResampled(); over ImageCopyResized(); for better thumbnail quality.

Planned Features
- Multiple entries per user.
- Possible integration with Photopost/Coppermine/etc..

If you use this, please click

* Installation script by John

[hr]-[/hr]
UPGRADES

v3.1.0 -> v3.1.1 UPGRADE INSTRUCTIONS

v3.0.1 -> v3.1.0 UPGRADE INSTRUCTIONS

v3.0 -> v3.0.1 UPGRADE INSTRUCTIONS

[hr]-[/hr]
MODIFICATIONS/ADD-ONS

[high]1. Add "Who's Online" Location by magnus[/high]
[high]2. Organize Your vBGarage Templates by magnus[/high]
[high]3. Increase Thumbnail Image Quality (v3.1.1 and older) by magnus[/high]
[high]4. Alphabetize Garage List by magnus[/high]
[high]5. Add "Latest Uploads" to FORUMHOME by magnus[/high]
[high]6. EvilLS1's Timeslip Database Integration by SVTOA[/high]
[high]7. Installer/Uninstaller by Action-N[/high]
[high]8. vBulletin 3.0.5 Compatible Installer/Update by noppid[/high]

magnus · #**1302** 11-22-2004, 02:15 PM

Action-N, I've edited the initial post and included a link to your uninstaller. If there are any other changes needed to be made, let me know.

Action-N · #**1303** 11-22-2004, 06:25 PM

Quote:

Originally Posted by magnus

Action-N, I've edited the initial post and included a link to your uninstaller. If there are any other changes needed to be made, let me know.

Ok that's cool, that way it doesn't get lost. I thought I'd ask if you have time to look over what I have ready for 3.2. I sent a copy to integra99, but haven't heard back. He wanted me to send him a copy an talk about something before I released anything. Don't know what he wanted, but I'd like some coders to look it over and optimize code or help with the remaing bugs.

magnus · #**1304** 11-22-2004, 06:42 PM

Quote:

Originally Posted by Action-N

Ok that's cool, that way it doesn't get lost. I thought I'd ask if you have time to look over what I have ready for 3.2. I sent a copy to integra99, but haven't heard back. He wanted me to send him a copy an talk about something before I released anything. Don't know what he wanted, but I'd like some coders to look it over and optimize code or help with the remaing bugs.

You've got a Private Message.

hasan2k · #**1305** 11-23-2004, 11:59 PM

Quote:

Originally Posted by magnus

You've got a Private Message.

I can't wait to see the new version released. It will be awesome with multiple vehicle entries.

Silverstangs · #**1306** 11-24-2004, 12:23 PM

Quote:

Originally Posted by magnus

In index.php:

FIND:

PHP Code:


			
// ### WELCOME MESSAGE #################################################

Add ABOVE:

PHP Code:


			
// START VBGARAGE HACK

// ### VBGARAGE #########################################################

$result_latest = $DB_site->query(" 

    SELECT vbgarage_images.* 

    FROM " . TABLE_PREFIX . "vbgarage_images 

    ORDER BY vbgarage_images.vbgarageid DESC 

    LIMIT 5 

"); 

     

while ($latest = $DB_site->fetch_Array($result_latest)) 

{ 

    eval('$latestbits .= "' . fetch_template('vbgarage_latestbits') . '";'); 

} 



$DB_site->free_result($result_latest); 

// END VBGARAGE HACK

FIND:

PHP Code:


			
    'forumhome_subforumseparator_post'

);

REPLACE with:

PHP Code:


			
    'forumhome_subforumseparator_post',

    'vbgarage_latestbits'

);

In template FORUMHOME:

FIND:

HTML Code:

$navbar

Add BELOW:

HTML Code:

<!-- START VBGARAGE HACK -->
<table cellpadding="$stylevar[outerborderwidth]" cellspacing="0" border="0" class="tborder" width="$stylevar[tablewidth]" align="center"><tr><td>
<table cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%">
<tr>
	<td class="tcat" colspan="5"><b>$vbphrase[vbgarage_latest_uploads]</b></td>
</tr>
<tr>
$latestbits
</tr>
</table>
</td></tr></table>
<!-- END VBGARAGE HACK -->

That should do it.

I attempting to install this mod but I get the following error

Quote:

Database error in vBulletin 3.0.3:

Invalid SQL:
SELECT vbgarage_images.*
FROM vb3vbgarage_images
ORDER BY vbgarage_images.vbgarageid DESC
LIMIT 5

mysql error: Unknown table 'vbgarage_images'

mysql error number: 1051

Date: Wednesday 24th of November 2004 08:19:06 AM
Script: http://www.stangcountry.com/forums/index.php?
Referer: http://www.stangcountry.com/forums/a...ex.php?do=head
Username: Silverstangs
IP Address: 69.xxx.xxx.xxx

What did I miss?

Silverstangs · #**1307** 11-24-2004, 01:10 PM

Wadda you know, I left the index.php un modded and just put this part in FORUMHOME under the $navbar ....

PHP Code:


			
<!-- START VBGARAGE HACK --> 

<table cellpadding="$stylevar[outerborderwidth]" cellspacing="0" border="0" class="tborder" width="$stylevar[tablewidth]" align="center"><tr><td> 

<table cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%"> 

<tr> 

    <td class="tcat" colspan="5"><b>$vbphrase[vbgarage_latest_uploads]</b></td> 

</tr> 

<tr> 

$latestbits 

</tr> 

</table> 

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

<!-- END VBGARAGE HACK -->

I get a 1/2inch bar, that says "latest uoloads" but no pic's. Anyone have a idea?

magnus · #**1308** 11-24-2004, 05:56 PM

Quote:

Originally Posted by Silverstangs

Wadda you know, I left the index.php un modded and just put this part in FORUMHOME under the $navbar ....

I get a 1/2inch bar, that says "latest uoloads" but no pic's. Anyone have a idea?

The error you posted earlier indicates that one of the critical databases doesn't exist --

[sql]
mysql error: Unknown table 'vbgarage_images'

mysql error number: 1051
[/SQL]

You need to check and verify that the vbgarage_images database exists, first.

Action-N · #**1309** 11-24-2004, 06:18 PM

Quote:

SELECT vbgarage_images.*
FROM vb3vbgarage_images
ORDER BY vbgarage_images.vbgarageid DESC
LIMIT 5

As you can see from the error, it's trying to grab the information out of "vb3vbgarage_images ". Not knowing if this is a table prefix I'd just do a search for this code an check/ fix that line. I don't use a prefix so maybe this mod doesn't work with prefixes. In the mean time just do a search for "ORDER BY vbgarage_images.vbgarageid DESC" an that should find the above problem query.

magnus · #**1310** 11-24-2004, 10:07 PM

Quote:

Originally Posted by Action-N

As you can see from the error, it's trying to grab the information out of "vb3vbgarage_images ". Not knowing if this is a table prefix I'd just do a search for this code an check/ fix that line. I don't use a prefix so maybe this mod doesn't work with prefixes. In the mean time just do a search for "ORDER BY vbgarage_images.vbgarageid DESC" an that should find the above problem query.

Action-N, have you gotten any of my PM's? I haven't gotten any replies, so I'm just wondering..

Silverstangs · #**1311** 11-24-2004, 10:23 PM

Quote:

Originally Posted by Action-N

As you can see from the error, it's trying to grab the information out of "vb3vbgarage_images ". Not knowing if this is a table prefix I'd just do a search for this code an check/ fix that line. I don't use a prefix so maybe this mod doesn't work with prefixes. In the mean time just do a search for "ORDER BY vbgarage_images.vbgarageid DESC" an that should find the above problem query.

This section is in INDEX.php

PHP Code:


			
/ START VBGARAGE HACK 

// ### VBGARAGE ######################################################### 

$result_latest = $DB_site->query(" 

    SELECT vbgarage_images.* 

    FROM " . TABLE_PREFIX . "vbgarage_images 

    ORDER BY vbgarage_images.vbgarageid DESC 

    LIMIT 5 

"); 

      

while ($latest = $DB_site->fetch_Array($result_latest)) 

{ 

    eval('$latestbits .= "' . fetch_template('vbgarage_latestbits') . '";'); 

} 



$DB_site->free_result($result_latest); 

// END VBGARAGE HACK

and this section is in VBGARAGE.PHP

PHP Code:


			
}

    

    $result_latest = $DB_site->query("

        SELECT * FROM " . TABLE_PREFIX . "vbgarage_images ORDER BY vbgarageid DESC LIMIT 5

    ");

    

    while ($latest = $DB_site->fetch_Array($result_latest))

    {

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.12547 seconds Memory Usage 2,355KB Queries Executed 26 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (2)bbcode_html (7)bbcode_php (9)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (4)pagenav_pagelinkrel (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.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 showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!