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]

[rockergrrl]

Originally Posted by magnus

No, there should be no , (comma) after 262144.

I tried that, and I got errors...

When I added a comma, it worked fine.

[magnus]

Originally Posted by rockergrrl

I tried that, and I got errors...

When I added a comma, it worked fine.

Now *that* is weird.. unless of course you've modified the init.php with another hack. This hack assumes that it's an unhacked init.php. The canvbgarage line should be the last line in that array, if not, then you'll have to modify the 262144 as well.

[dede1]

magnus

what is for my error?

Datenbankfehler in vBulletin 3.0.0:

Ungueltige SQL-Abfrage:

CREATE TABLE `vbgarage_images` (
`vbgarageid` smallint(6) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`name` varchar(50) NOT NULL default '',
`data` longblob NOT NULL,
`type` varchar(50) NOT NULL default '',
PRIMARY KEY (`vbgarageid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

mysql error: You have an error in your SQL syntax near ';
' at line 9

[Clb]

what i did wrong was that i removed the 'caneditownusernotes' => 131072 part and i simply replaced it with 'canvbgarage' => 262144 which was wrong...

i should add it after that and not replace it

[magnus]

Originally Posted by dede1

magnus

what is for my error?

Datenbankfehler in vBulletin 3.0.0:

Ungueltige SQL-Abfrage:

CREATE TABLE `vbgarage_images` (
`vbgarageid` smallint(6) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`name` varchar(50) NOT NULL default '',
`data` longblob NOT NULL,
`type` varchar(50) NOT NULL default '',
PRIMARY KEY (`vbgarageid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

mysql error: You have an error in your SQL syntax near ';
' at line 9

Your SQL doesn't like the ; ? I assume you're getting this when you run the install_vbgarage.php?

Try running this query:
[SQL]
CREATE TABLE " . TABLE_PREFIX . "vbgarage_images (
`vbgarageid` smallint(6) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`name` varchar(50) NOT NULL default '',
`data` longblob NOT NULL,
`type` varchar(50) NOT NULL default '',
PRIMARY KEY (`vbgarageid`)
) TYPE=MyISAM AUTO_INCREMENT=1;
[/SQL]

[dede1]

No this error:

Error

SQL-Befehl :

CREATE TABLE " . TABLE_PREFIX . "vbgarage_images(

`vbgarageid` smallint( 6 ) unsigned NOT NULL AUTO_INCREMENT ,
`userid` int( 10 ) unsigned NOT NULL default '0',
`name` varchar( 50 ) NOT NULL default '',
`data` longblob NOT NULL ,
`type` varchar( 50 ) NOT NULL default '',
PRIMARY KEY ( `vbgarageid` )
) TYPE = MYISAM AUTO_INCREMENT = 1

MySQL meldet:

#1064 - You have an error in your SQL syntax near '" . TABLE_PREFIX . "vbgarage_images( `vbgarageid` smallint( 6 ) unsigned NOT ' at line 1

[magnus]

Originally Posted by dede1

No this error:

Error

SQL-Befehl :

CREATE TABLE " . TABLE_PREFIX . "vbgarage_images(

`vbgarageid` smallint( 6 ) unsigned NOT NULL AUTO_INCREMENT ,
`userid` int( 10 ) unsigned NOT NULL default '0',
`name` varchar( 50 ) NOT NULL default '',
`data` longblob NOT NULL ,
`type` varchar( 50 ) NOT NULL default '',
PRIMARY KEY ( `vbgarageid` )
) TYPE = MYISAM AUTO_INCREMENT = 1

MySQL meldet:


#1064 - You have an error in your SQL syntax near '" . TABLE_PREFIX . "vbgarage_images( `vbgarageid` smallint( 6 ) unsigned NOT ' at line 1

Errr.. if you're running this in phpmyadmin, or from mysqladmin, etc.. remove the " . TABLE_PREFIX . "

[SQL]
CREATE TABLE vbgarage_images (
`vbgarageid` smallint(6) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`name` varchar(50) NOT NULL default '',
`data` longblob NOT NULL,
`type` varchar(50) NOT NULL default '',
PRIMARY KEY (`vbgarageid`)
) TYPE=MyISAM AUTO_INCREMENT=1;
[/SQL]

[dede1]

That now registered into the data base over PHPmyadmin

[dede1]

Database is ok per phpmyadmin :

vbgarage_images
vbgarage_users

but how get I now the new Pharasen added?

[rockergrrl]

Originally Posted by magnus

Now *that* is weird.. unless of course you've modified the init.php with another hack. This hack assumes that it's an unhacked init.php. The canvbgarage line should be the last line in that array, if not, then you'll have to modify the 262144 as well.

Init.php is unhacked for me..

The clean init.php file has this 'canseedelnotice' => 262144

So having 'canvbgarage' => 262144, just wouldn't work

what should it be then?