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 muscle-mustangs

1 last suggestion for the new VBgarage your developing magnus.

I'm more of a show kind of guy than a performance kind of guy. I imagine their are many others, too. Anywase, lets say if our site has been up for years with vbgarage and we have like over 2000 members cars. I'm sure not a single person is going to click each and every car. Most, they want to see a nice exterior, no matter what the engine size is. Is their anyway, in the new version, to like put 1 thumbnail view of the users most current upload right beside their username or something? This will enable people to look for the best rides without having to click each and every one


let us know man!

Well, technically, that can be done already with a couple edits. However, I'll consider making it configurable in 3.2.0.

[magnus]

Originally Posted by MrNase

Dann kann es an ja nur an der neuen vB Version liegen
Oder hast du eventuell ne Datei ?berschrieben?!

magnus:
dede1 has some problems. He can't access the vbgarage but his usergroup setting is set to 'can enter vbgarage'. Everything worked fine for him but than he updated from vB 3.0.0 to vB 3.0.1 and now it's not working anymore.
Can you look into this please?

vB3.0.1 has obviously removed/modified some settings. He may need to manually run the vBGarage 'settings' SQL queries.

[will_lean]

Hi
to edit this to suit my forum can i edit the installer file so it installs the new phrases?

$DB_site->query("
		INSERT INTO " . TABLE_PREFIX . "phrase (languageid, varname, text, phrasetypeid) VALUES(0, 'vbgarage_text', 'Text', 1)
	");

can i change the above sql insert from vbgarage_text to member_info etc to customize it or will this mess with the installer?

thanks again.

[Envy-UK]

I'm still waiting to find out how I can use the vB function to provide me with thumbnails, I'm guessing my requests have been lost in the vast amount of questions.

[magnus]

Originally Posted by will_lean

Hi
to edit this to suit my forum can i edit the installer file so it installs the new phrases?

$DB_site->query("
		INSERT INTO " . TABLE_PREFIX . "phrase (languageid, varname, text, phrasetypeid) VALUES(0, 'vbgarage_text', 'Text', 1)
	");

can i change the above sql insert from vbgarage_text to member_info etc to customize it or will this mess with the installer?

thanks again.

No, you cannot change the "vbgarage_text" unless you edit the script/templates as well to reflect the change. However, you can edit the "Text", to have that phrase return whatever you like. Do that through the Phrase Manager in the AdminCP. There's really no need to change the variable names, since the users never see them. It's just called by [high]$vbphrase[vbgarage_text][/high]. It will return whatever you define it to.

[magnus]

Originally Posted by Envy-UK

I'm still waiting to find out how I can use the vB function to provide me with thumbnails, I'm guessing my requests have been lost in the vast amount of questions.

No, not lost. It's just that I don't want to get involved supporting that, because it's more than just adding that code snippet posted by Jason. You'll need to modify some additional code, templates as well as run additional sql queries. This feature is available in v3.2.0, however.

[Envy-UK]

Originally Posted by magnus

No, not lost. It's just that I don't want to get involved supporting that, because it's more than just adding that code snippet posted by Jason. You'll need to modify some additional code, templates as well as run additional sql queries. This feature is available in v3.2.0, however.

That's fine, thanks Magnus.

[dede1]

Originally Posted by magnus

vB3.0.1 has obviously removed/modified some settings. He may need to manually run the vBGarage 'settings' SQL queries.

magnus

SQL is ok.

MrNase

ich danke dir f?r die Hilfe die SQL sind in Ordnung

[magnus]

Originally Posted by dede1

magnus

SQL is ok.

MrNase

ich danke dir f?r die Hilfe die SQL sind in Ordnung

Then one of your original file edits has been reverted. Did you reapply all the file edits after the upgrade?

[JaNa]

Originally Posted by magnus

Because it's been answered before. The answer you seek lies in vbgarage.php.

PHP Code:

        if (empty($year) OR empty($make))
        {
            eval (print_standard_error('error_requiredfields'));
        } 


Thanks, it's working now.

It's kinda amazing how one line can totally screw something up :nervous:

Btw your giving good, quick, helpful support Magnus

[dede1]

Everything examined, since after the update do not hack run.

Now it however only I runs can see there and the car adjust also can I
now as many pictures stop as I wants

[will_lean]

Hi
ive managed to get this working no problem on 3.0.1
however i just got the error

Invalid SQL:
SELECT vbgarage_users.*,user.username FROM vbgarage_users LEFT JOIN user ON vbgarage_users.userid = user.userid ORDER BY username ASC LIMIT 0,25

mysql error: Table databasename.vbgarage_users' doesn't exist

mysql error number: 1146

i did have it working just before i tried to view the list?
my table is vb3_vbgarage_users not vbgarage_users

if i add in my table prefix it tells me

the table vbulletin.user' doesn't exist

$result_list = $DB_site->query("
		SELECT vbgarage_users.*,user.username FROM vbgarage_users LEFT JOIN user ON vbgarage_users.userid = user.userid ORDER BY username ASC LIMIT $pos,$perpage
	");

anyone help me with this???

[Rick Sample]

joeychgo: Ok, I just saw how you have Vbgarage on your forum homepage, looks nice. Do you think it would look good with my layout?

Also, will this slow down our server dramastically if I only limmit the size to a couple 100 KB's? We're currently running our site off of a old 400Mhz processor. Actually somewhere around their, I'm not sure what the other admin said. It curently has 256MB of ram. We aren't that huge because we just started. So later on this summer we're planning on purchasing a brand new server. if you guys visit my forum: www.muscle-mustangs.com/forums you can see how everything loads on the forum and members rides. Let me know if you guys think our server can handle it. We only have like normally around 2-5 members on at once. Hence, we're new.

Thanks all,

[magnus]

Originally Posted by will_lean

Hi
ive managed to get this working no problem on 3.0.1
however i just got the error

Invalid SQL:
SELECT vbgarage_users.*,user.username FROM vbgarage_users LEFT JOIN user ON vbgarage_users.userid = user.userid ORDER BY username ASC LIMIT 0,25

mysql error: Table databasename.vbgarage_users' doesn't exist

mysql error number: 1146

i did have it working just before i tried to view the list?
my table is vb3_vbgarage_users not vbgarage_users

if i add in my table prefix it tells me

the table vbulletin.user' doesn't exist

$result_list = $DB_site->query("
		SELECT vbgarage_users.*,user.username FROM vbgarage_users LEFT JOIN user ON vbgarage_users.userid = user.userid ORDER BY username ASC LIMIT $pos,$perpage
	");

anyone help me with this???

Eh? I'm confused. The code you pasted doesn't include " . TABLE_PREFIX . ", yet, you say you have a table prefix. So, of course it's not going to work. I have " . TABLE_PREFIX . " included in all SQL queries. Did you remove it or something?

[will_lean]

sorry i meant to say my vb tables use the prefix vb3_
the error popped up after i tried to list the member garages.
ive fixed it now,it seemed to be trying to pull the data from the tables without my prefix "vb3_" causing the error,i simply added my vb3_ prefix and it seems to be fine now :banana:

sorry for the confusion and thanks for the quick reply
:up: