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

[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]

[Shahrum]

And also... is there a way that in the template, instead of "Check out my ride" I can be like "My Ride: 1999 Ford Mustang" and get that info from the info I put in teh vbgarage?

[Rick Sample]

Originally Posted by magnus

Just an update. v3.2.0 is coming along nicely. There's much more AdminCP control over how vBGarage acts now. I'm also devising a variable template engine, which will sort of allow you to design HOW you want the users detail input to be displayed. The template will be populated by the users input, rather than having the user design the "template" themselves, as they do now.

I'm also considering making some of the variables more 'global', so you can call them rather easily from other portions of the site. For instance, if you wanted to call the "Latest Uploads" from FORUMHOME, etc. Though, this is secondary, at the moment.

Oh, and there is definately going to be a need for database restructuring in v3.2.0. I'm hoping I can devise a "migration"-type script. Otherwise, there's going to be a little (read: repititious/tedious) work involved for the admin (read: YOU!).

If anyone here is a SQL genius, and would like to help with this migration-script, shoot me a PM. I'm decent with SQL, but by no means do I know it inside and out (yet).

I'm just wondering when this new one will come out and whats its new features?

If I can make a suggestion.....it would be cool that you would be able to sort by year of car, make, model, newest car, etc. When our sites get huge and have thousands of cars, it would be hard to sort out all the ones that you want. For example if you loved SVT's, you wouldn't want to look at the V6's and so on

Also, a feature that would be cool would be some kind of a rating system, something like cardomain uses. You know you can rate everything on their ride like the overall appearance, sound, performance, etc.

I think those would be some cool freatures. But hey, I'm lovin this hack so far, one of the best in my books!

[magnus]

Originally Posted by muscle-mustangs

I'm just wondering when this new one will come out and whats its new features?

If I can make a suggestion.....it would be cool that you would be able to sort by year of car, make, model, newest car, etc. When our sites get huge and have thousands of cars, it would be hard to sort out all the ones that you want. For example if you loved SVT's, you wouldn't want to look at the V6's and so on

Also, a feature that would be cool would be some kind of a rating system, something like cardomain uses. You know you can rate everything on their ride like the overall appearance, sound, performance, etc.

I think those would be some cool freatures. But hey, I'm lovin this hack so far, one of the best in my books!

Yes, sorting is implemented. At the momemt, I do have rating, however it's not what I would consider ready to be released. So, I'm not sure if it'll be out in v3.2.0. Possibly as an upgrade.

Keep in mind, v3.2.0 is a major upgrade. I still have to shift alot of focus on (hopefully) developing a migration script for your current database. I'll feel terrible if people are forced to start their databases from scratch.

[magnus]

Originally Posted by Shahrum

I think something's wrong with the variable used in the if statement because w/o the if statement, it works fine!

Use this query instead:

[SQL] $posts = $DB_site->query("
SELECT
post.*, vbgarage_users.*, vbgarage_users.userid AS vbgarage, post.username AS postusername, post.ipaddress AS ip,
user.*, userfield.*, usertextfield.*,
" . iif($forum['allowicons'], 'icon.title as icontitle, icon.iconpath,') . "
" . iif($vboptions['avatarenabled'], 'avatar.avatarpath, NOT ISNULL(customavatar.avatardata) AS hascustomavatar, customavatar.dateline AS avatardateline,') . "
" . iif($vboptions['reputationenable'], 'level,') . "
" . iif(!$deljoin, 'NOT ISNULL(deletionlog.primaryid) AS isdeleted, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,') . "
editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
editlog.reason AS edit_reason,
post_parsed.pagetext_html, post_parsed.hasimages,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
" . iif(!can_moderate(), $datastore['hidprofilecache']) . "
FROM " . TABLE_PREFIX . "post AS post
LEFT JOIN " . TABLE_PREFIX . "user AS user ON(user.userid = post.userid)
LEFT JOIN " . TABLE_PREFIX . "userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
" . iif($forum['allowicons'], "LEFT JOIN " . TABLE_PREFIX . "icon AS icon ON(icon.iconid = post.iconid)") . "
" . iif($vboptions['avatarenabled'], "LEFT JOIN " . TABLE_PREFIX . "avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN " . TABLE_PREFIX . "customavatar AS customavatar ON(customavatar.userid = user.userid)") .
iif($vboptions['reputationenable'], " LEFT JOIN " . TABLE_PREFIX . "reputationlevel AS reputationlevel ON(user.reputationlevelid = reputationlevel.reputationlevelid)") . "
" . iif(!$deljoin, "LEFT JOIN " . TABLE_PREFIX . "deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND deletionlog.type = 'post')") . "
LEFT JOIN " . TABLE_PREFIX . "editlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN " . TABLE_PREFIX . "post_parsed AS post_parsed ON(post_parsed.postid = post.postid)
LEFT JOIN " . TABLE_PREFIX . "vbgarage_users AS vbgarage_users ON(vbgarage_users.userid = user.userid)
WHERE $postids
ORDER BY dateline $postorder
");[/SQL]

Originally Posted by Shahrum

And also... is there a way that in the template, instead of "Check out my ride" I can be like "My Ride: 1999 Ford Mustang" and get that info from the info I put in teh vbgarage?

Then, use this in your postbit:

<if condition="$post['vbgarage']"><br><div><a href="vbgarage.php?$session[sessionurl]do=view&id=$post[userid]">My Ride: $post[year] $post[make] $post[model]</a></div></if>

That should do it!

[spence2]

Since 3.2 will be a major upgrade, for those of us who are holding off installing until it's release...IF WE ALL SWEAR NOT TO HOLD YOU TO IT UNDER PENALTY OF HOT BAMBOOSHOOTS STUCK UNDER OUR FINGERNAILS...could you give us a guesstimate on when you might release 3.2? Days...or weeks?
Thanks.

[magnus]

Originally Posted by spence2

Since 3.2 will be a major upgrade, for those of us who are holding off installing until it's release...IF WE ALL SWEAR NOT TO HOLD YOU TO IT UNDER PENALTY OF HOT BAMBOOSHOOTS STUCK UNDER OUR FINGERNAILS...could you give us a guesstimate on when you might release 3.2? Days...or weeks?
Thanks.

Well, provided your prior disclaimer holds true.. about a week. I'm shooting for next weekend (possibly sooner). I was trying for this weekend, except I've been out of town in training this weekend. /sigh

[Rick Sample]

Originally Posted by magnus

Well, provided your prior disclaimer holds true.. about a week. I'm shooting for next weekend (possibly sooner). I was trying for this weekend, except I've been out of town in training this weekend. /sigh

We aren't in any hurry, just make it easy to install for us Newbes, and we won't mind

[spence2]

Won't mind at all.
Thanks!

[joeychgo]

Geeze, I go away for a few days and there is all this now.........Whew.

Question, has anyone come up with how to place the "latest uploads" panel on other pages, such as the forum home or vba page?

[magnus]

Originally Posted by joeychgo

Geeze, I go away for a few days and there is all this now.........Whew.

Question, has anyone come up with how to place the "latest uploads" panel on other pages, such as the forum home or vba page?

Just place the following code in the respective PHP file:

PHP Code:

$result_latest = $DB_site->query("
    SELECT vbgarage_images.* 
    FROM " . TABLE_PREFIX . "vbgarage_images
    ORDER BY vbgarage_images.id DESC 
    LIMIT 5
");
    
while ($latest = $DB_site->fetch_Array($result_latest))
{
    eval('$latestbits .= "' . fetch_template('vbgarage_latestbits') . '";');
}

$DB_site->free_result($result_latest); 


Be sure to add the following line to the $globaltemplates(); array, too.

PHP Code:

        'vbgarage_latestbits', 


Then, just add [high]$latestbits[/high] into the template you want it displayed in.