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]

[magnus]

Originally Posted by dede1

@magnus

I have from vB 3.0.0 to vB 3.0.1 update now get I this error message and can
however nothing find:

Fatal error: Call to undefined function: can_administer() in /var/www/html/Board/vbgarage.php on line 50

Upgrading vB version shouldn't have anything to do with it, either download the latest vBGarage PHP file or see this link:
https://vborg.vbsupport.ru/showpost....&postcount=347

[magnus]

Originally Posted by eoc_Jason

Here's a way to do the thumbnails using vB's function for creating the thumbnails in threads... You have to write a temp file for the image function to work from, not a big deal... I used all the vB variables for the temp directory and such.

		if (!empty($_FILES['src']['tmp_name'])) {
			require_once('./includes/functions_image.php');

			$name = $_FILES['src']['name'];
			$data = addslashes(fread(fopen($_FILES['src']['tmp_name'], "r"), filesize($_FILES['src']['tmp_name'])));
			$type = $_FILES['src']['type'];

			$filename = tempnam(ini_get('upload_tmp_dir'), 'tmpimg');
			$fp = @fopen($filename, 'wb');
			@fwrite($fp, stripslashes($data));
			@fclose($fp);

			$attachment[tmp_name] = $filename;
			$attachment[name] = $name;
			$thumb = addslashes(fetch_thumbnail_from_image($attachment,$imageerror));
			@unlink($filename);
// insert into DB table here...
		}

Hah, beat me to it. I have this implemented in v3.2.0.

BTW, you have a PM.

[dede1]

magnus

thanks

[eoc_Jason]

You can make a little icon (or link, whatever you want) and have it display on the postbits template if they have created a profile.

Just edit showthread.php & find the big query around line 844, add your 'vbgarage_users.userid' to the SELECT part, and add a 'LEFT JOIN " . TABLE_PREFIX . "vbgarage_users AS vbgarage_users ON(vbgarage_users.userid = user.userid)

Then in your postbit (or postbit_legacy) template, you can add something like:

<if condition="$post['vbgarage']"><a href="vbgarage.php?$session[sessionurl]do=view&id=$post[userid]">(image or text here)</a></if>

That way as people read threads, they can go directly to that person's page...

[magnus]

Originally Posted by eoc_Jason

You can make a little icon (or link, whatever you want) and have it display on the postbits template if they have created a profile.

Just edit showthread.php & find the big query around line 844, add your 'vbgarage_users.userid' to the SELECT part, and add a 'LEFT JOIN " . TABLE_PREFIX . "vbgarage_users AS vbgarage_users ON(vbgarage_users.userid = user.userid)

Then in your postbit (or postbit_legacy) template, you can add something like:

<if condition="$post['vbgarage']"><a href="vbgarage.php?$session[sessionurl]do=view&id=$post[userid]">(image or text here)</a></if>

That way as people read threads, they can go directly to that person's page...

lol, you're taking all the fun out of v3.2.0. j/k, keep up the good work.

[Shahrum]

Originally Posted by eoc_Jason

You can make a little icon (or link, whatever you want) and have it display on the postbits template if they have created a profile.

Just edit showthread.php & find the big query around line 844, add your 'vbgarage_users.userid' to the SELECT part, and add a 'LEFT JOIN " . TABLE_PREFIX . "vbgarage_users AS vbgarage_users ON(vbgarage_users.userid = user.userid)

Then in your postbit (or postbit_legacy) template, you can add something like:

<if condition="$post['vbgarage']"><a href="vbgarage.php?$session[sessionurl]do=view&id=$post[userid]">(image or text here)</a></if>

That way as people read threads, they can go directly to that person's page...

Hey, I tried to use your SQL code and while the field I added to the select statement works, the LEFT clause kept giving me errors... would you mind just copy/pasting the full SQL...? Thanks.

[Shahrum]

Here's my code fyi...

$getpostids = $DB_site->query("
			SELECT postid, 'vbgarage_users.userid', NOT ISNULL(deletionlog.primaryid) AS isdeleted
			FROM " . TABLE_PREFIX . "post AS post

LEFT JOIN " . TABLE_PREFIX . "deletionlog AS deletionlog ON(post.postid = deletionlog.primaryid AND type = 'post') 
			WHERE threadid = $threadid AND visible = 1
			ORDER BY dateline $postorder
		");

[magnus]

Originally Posted by Shahrum

Here's my code fyi...

$getpostids = $DB_site->query("
			SELECT postid, 'vbgarage_users.userid', NOT ISNULL(deletionlog.primaryid) AS isdeleted
			FROM " . TABLE_PREFIX . "post AS post

LEFT JOIN " . TABLE_PREFIX . "deletionlog AS deletionlog ON(post.postid = deletionlog.primaryid AND type = 'post') 
			WHERE threadid = $threadid AND visible = 1
			ORDER BY dateline $postorder
		");

Yikes! You're editing the wrong variable/query. You need to be modifying the $posts variable/query. Something like this:

[SQL]
$posts = $DB_site->query("
SELECT
vbgarage_users.userid, post.*, 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]

[Shahrum]

Great, the query works... but no links are showing up for the users who have garages.

from postbit_legacy:

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

[Shahrum]

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