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]

LuBi · #**792** 05-15-2004, 05:05 PM

Quote:

Originally Posted by Odoin

Yeah... but you need GD 2.0 or better for the thumbnails to work...

I don't think you're following what I said. I emailed my host:

"I need at least version 2.0 for this php script I want to run"

They replied:

"We do support php GD Library version 1.6.2 or higher."

So that would lead me to believe I can run script that calls for 1.6.2 or higher, ie. including 2.0.. But then again who knows.. the host is Xeran. :speechless:

Odoin · #**793** 05-16-2004, 10:54 PM

No I am 99% sure your hosting provider only supports GD 1.6.2 not 2.0+ like you need. Alot of new things in 2.0 that were not in 1.6.2. I am not a huge linux guru so there is room for error :P.

joeychgo · #**794** 05-16-2004, 11:51 PM

I got a DB error today. Dont know whym this has been running fine.

here is what got

Code:

Database error in vBulletin 3.0.0:

Invalid SQL: 
                INSERT INTO vbgarage_images (userid, name, data, type) VALUES (419, 'Cody's First Day, Lorry's '95 Lincoln Mark VIII 015.jpg', '????qExif\0\0II*\0\0\0\0
\0\0 \0\0\0?\0\0\0\0\0\0\0?\0\0\0\0
\0\0\0?\0\0\0\0\0\0\0\0\0\0\0\0\0\0?\0\0\0\0\0\0

(I eliminated most of the picture code for simplicity)

6X??׮
zZ??R???+|??t~?Ɵ/O?c??', 'image/pjpeg')
            
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 's First Day, Lorry's '95 Lincoln Mark VIII 015.jpg', '????qExi

mysql error number: 1064

Date: Sunday 16th of May 2004 01:51:22 PM
Script: http://www.lincolnvscadillac.com/vbgarage.php
Referer: http://www.lincolnvscadillac.com/vbg...?do=editgarage
Username: hintsclue
IP Address: 69.29.166.103

Anyone have ideas as to what this could be?

magnus · #**795** 05-17-2004, 01:54 PM

I LIVE! (well, sort of)

UPDATE (05/17/2004):

I've got my new PC up and running (for the most part.. damn thing is quirky, but such is life). v3.2.0 seems to be running strong, and I would consider it release worthy. However, I still haven't got a DB converter. You're existing database will not work correctly with v3.2.0.

Yes, I realize this is a problem.

It's not that it's incredibly hard, it's just that my SQL skills aren't quite up to that level yet. So, if anyone here knows SQL well enough -- and would like to help -- shoot me a PM.

As it sits, I can probably release v3.2.0, however, until there's a conversion script, there's really no "upgrade" available (unless you want to do all your entries by hand -- which I seriously doubt).

While I tried to get as much stuffed into v3.2.0 as possible, the demise of my PC was an unfortunate setback. So, at the moment, v3.2.0 really only offers multiple garages and slightly more efficient SQL (both of which have been tested).

While I do have vBulletin's internal thumbnail processing working, I'm not quite sure I want to include it in v3.2.0 yet (which still remains untested, for the most part).

I don't want anyone to think I've abandoned the project, I assure you, I haven't. I do have ALOT of things going on right now (working on getting a new job, which may require me to relocate to New Jersey), so I don't have the same time I used to. This in no way means I'm not going to release new versions or not fix bugs. It just means it might take longer than it has in the past, unfortunately.

But, for the time being, what I *really* need is a SQL guru to whip up a conversion script.

magnus · #**796** 05-17-2004, 01:55 PM

Quote:

Originally Posted by joeychgo

I got a DB error today. Dont know whym this has been running fine.

here is what got

Code:

Database error in vBulletin 3.0.0:

Invalid SQL: 
                INSERT INTO vbgarage_images (userid, name, data, type) VALUES (419, 'Cody's First Day, Lorry's '95 Lincoln Mark VIII 015.jpg', '????qExif\0\0II*\0\0\0\0
\0\0 \0\0\0?\0\0\0\0\0\0\0?\0\0\0\0
\0\0\0?\0\0\0\0\0\0\0\0\0\0\0\0\0\0?\0\0\0\0\0\0

(I eliminated most of the picture code for simplicity)

6X??׮
zZ??R???+|??t~?Ɵ/O?c??', 'image/pjpeg')
            
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 's First Day, Lorry's '95 Lincoln Mark VIII 015.jpg', '????qExi

mysql error number: 1064

Date: Sunday 16th of May 2004 01:51:22 PM
Script: http://www.lincolnvscadillac.com/vbgarage.php
Referer: http://www.lincolnvscadillac.com/vbg...?do=editgarage
Username: hintsclue
IP Address: 69.29.166.103

Anyone have ideas as to what this could be?

Remove the , (comma) from the filename, and try again.

P.Jackson · #**797** 05-17-2004, 03:16 PM

Hey just remember you come first! yuove done a great job to start with

Quote:

Originally Posted by magnus

I LIVE! (well, sort of)

UPDATE (05/17/2004):

I've got my new PC up and running (for the most part.. damn thing is quirky, but such is life). v3.2.0 seems to be running strong, and I would consider it release worthy. However, I still haven't got a DB converter. You're existing database will not work correctly with v3.2.0.

Yes, I realize this is a problem.

It's not that it's incredibly hard, it's just that my SQL skills aren't quite up to that level yet. So, if anyone here knows SQL well enough -- and would like to help -- shoot me a PM.

As it sits, I can probably release v3.2.0, however, until there's a conversion script, there's really no "upgrade" available (unless you want to do all your entries by hand -- which I seriously doubt).

While I tried to get as much stuffed into v3.2.0 as possible, the demise of my PC was an unfortunate setback. So, at the moment, v3.2.0 really only offers multiple garages and slightly more efficient SQL (both of which have been tested).

While I do have vBulletin's internal thumbnail processing working, I'm not quite sure I want to include it in v3.2.0 yet (which still remains untested, for the most part).

I don't want anyone to think I've abandoned the project, I assure you, I haven't. I do have ALOT of things going on right now (working on getting a new job, which may require me to relocate to New Jersey), so I don't have the same time I used to. This in no way means I'm not going to release new versions or not fix bugs. It just means it might take longer than it has in the past, unfortunately.

But, for the time being, what I *really* need is a SQL guru to whip up a conversion script.

Envy-UK · #**798** 05-17-2004, 03:48 PM

Quick question.

I'm looking to set the height and width of thumbnails in the imagebits template, however, I can never seem to set the height correctly, anyone?

Odoin · #**799** 05-17-2004, 04:54 PM

Hi Magnus,

I can make a DB upgrade script if you could provide me with the DB layout and PHP files. Please let me know your thoughts.

Mark

magnus · #**800** 05-17-2004, 07:15 PM

Quote:

Originally Posted by Odoin

Hi Magnus,

I can make a DB upgrade script if you could provide me with the DB layout and PHP files. Please let me know your thoughts.

Mark

Odoin, that sounds great. I'll put together an example when I get home and PM it to you. Thanks.

Odoin · #**801** 05-17-2004, 07:48 PM

Sounds great. I can test it on a live site as well and make sure everything goes correctly before I send it back to you.

Mark

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.13246 seconds Memory Usage 2,325KB 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_code (4)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!