Oak?s vGallery 1.0

The Gallery?s features:
- Forum users can add their own images
- Forum users rate/comment the images (not rate their own)
- Admin can add/delete categories/subcategories
- Admin can move images between categories/subcategories
- Admin can delete images and comments
- A toplist sortable in rating, votes, views, comments
- Automatic Thumbnail creation through ImageMagick?s Convert function
- Images info is stored in MySQL
- Images is stored in a directory of the webserver (not in MySQL)

Coming soon:
- More Admin features
- More data fields
- More sorting options

You want some new feature to the next version ?

------------------------------------------------------------------------------

What you need:
- Licenced vBulletin forum
- PhpMyAdmin to import database structure http://www.phpmyadmin.net/
- ImageMagick (Convert) installed on server http://imagemagick.sourceforge.net/
- "register_globals" in php.ini turned to "On"
- Webservers User must have write access to "images" and "thumbnails" directories

------------------------------------------------------------------------------

How to install:
- UnZip "Oak vGallery 1.0.zip"
- Import database structure from "InstallDB\Oak_vGallery.sql" with PhpMyAdmin
- Configure DB User/Pass in "Upload\sql.php"
- Configure your vGallery in "Upload\galleryconfig.php"
- Configure the text and link styles in "Upload\gallery.css"
- Upload the files from "Upload" to your vGallery directory on the webserver
- Give the webservers User write access in "images" and "thumbnails" directories
- Start your vGallery and Upload your image categories
- Please post your vGallery link here
- Finished !

------------------------------------------------------------------------------

Here is some screenshots:







------------------------------------------------------------------------------

Direct link to my vGallery (This one is Swedish):
http://websociety.wm.net/~wmanbem/fi...leri/index.php

------------------------------------------------------------------------------

Please post questions, comments and suggestions here !

[SpeedStreet]

Originally posted by kuska
is there anyway to show the newest pic (thumb) on forum home page?

Id like to intergrate it with the welcome panel.

Yes, you would have to query the table for the most recent dated photo thumb and post it that way.

[kuska]

Hey thanks for the help but i just re-did the whole header and it looks pimp now .
I have a question, how do i delete categories? Or am i missing something? Can seem to find any link or page for it
And about the most recent photo on forum home page, lol can you write that in newbie language? If its not too much trouble, i understand what you mean... My question now is how ?

[SpeedStreet]

The only way I have been able to do it is through the database manually.

[Aaow AnD wHiTe]

I keep getting this error. What could be wrong? I've double checked paths and everything...

Database error in vBulletin 2.2.8:

Invalid SQL: UPDATE session SET lastactivity=1046692121,location='/foro/galeria/' WHERE sessionhash='da9b268fe73a463df8c27e4783da4329'
mysql error:

mysql error number:

Date: Monday 03rd of March 2003 05:48:41 AM
Script: http://www.xxxxxxxxxxxxxxxxxx.com/foro/foro/galeria/
Referer:

[SpeedStreet]

OK, I need some help.

I'm working on a hack, and I need someone to give me just ONE tidbit of information, then I can release it to all of you.

I need to have $iUserID link correlate to the UserID of the owner of a picture in a gallery located in post_comment.php

I have tried a million little things, and nothing seems to be working. The quicker I get this done the better.

[Bergman]

Originally posted by kuska
Hey thanks for the help but i just re-did the whole header and it looks pimp now .
I have a question, how do i delete categories? Or am i missing something? Can seem to find any link or page for it
And about the most recent photo on forum home page, lol can you write that in newbie language? If its not too much trouble, i understand what you mean... My question now is how ?

Hi,

version 1.0 does not support the Editing features. You must do it through PhpMyAdmin for now. In the next version all Cathegories and data will be editable.

[Bergman]

Originally posted by kuska
is there anyway to show the newest pic (thumb) on forum home page?

Id like to intergrate it with the welcome panel.

In version 1.5 there is a Include-script doing this. Can you wait for next version ?

[SideFX]

Database error in vBulletin 2.3.0:

Invalid SQL: DELETE FROM session WHERE sessionhash=''
mysql error:

mysql error number:

Date: Friday 07th of March 2003 03:23:14 PM
Script: http://www.sytedesigns.com/forumsd/vGallery/index.php
Referer: http://sytedesigns.com/vGallery/index.php

[SideFX]

ok i fixed the other problem now i got a new one when users try to post a comment to something they get this error

Comment Failed (Database) - Please use the back button INSERT INTO tblComment (sComment,iImageID,iUserID,sUserName,dateSent) VALUES ('I really like. It's time to start teaching Steven how to do...hehe... ;-)',1,20,':: LiNuX ::',NOW());

and when they try to upload they get this

Upload Failed (Database) - Please use the back button INSERT INTO tblImage (iCategoryID,iSubCategoryID,iUserID,sUserName,sFil e,sTitle,dateAdded) VALUES (5, 0, 20, ':: LiNuX ::', '20-jackson.jpg', 'My Picture...don't laugh please.',NOW());

[SpeedStreet]

It happens when you put an ' into one of the fields.

I have a fix I will post Monday.