Major Additions - PhotoPlog: The Lite Gallery

PhotoPlog: The Lite Gallery

PhotoPlog Lite is a gallery script for GIF, JPG, and PNG images. PhotoPlog Lite comes with categories, permissions, comments, search, moderation. The installation takes care of phrases, templates, tables, etcetera. Just follow the README.txt file for installation.

There is a license agreement that I request that you abide. Thanks!

This thread is organized as follows:

• Post1 contains this here release.
• Post2 contains current add-ons.
• Post3 contains onscreen errors.

Fine Print: see license agreement, no redistribution, copyright retained in full, right reserved to uncheck support box.

Requirements: vB 3.5.0+ (development initially based on having vB 3.5.4 though vB 3.6.0+ and vB 3.7.0+ should be okay, but not every version was personally tested) and MySQL 4.1+ (development based on having MySQL 4.1+ though MySQL 3+ may be okay, but not every version was personally tested) and PHP with GD2 and Safe Mode off

Does it work on vB 3.5 and vB 3.6 and vB 3.7? Yes, it should. See the requirements. Also, there are two product XML files, one for vB 3.5 and one for vB 3.6/3.7, so import the one that matches your vB version.

Live Demo and Official Support: http://www.photoplog.com/

Note on Official Support: With 70 some pages, assuming 15 posts per page, and over 1000 posts, all in one thread, official support for this mod is now held off-site. Apologies in advance for possibly having to register at yet another forum, but IMHO support would be better served elsewhere at this point.

All support requests, except perhaps for proven bugs, may be ignored if posted in this thread.

Comments, suggestions, etcetera are welcome, but please note that further modifications are not being planned, as this is intended as the final release of the lite series.

Fun Fact: PhotoPlog Lite v.2.0.6 had 4330 downloads plus 2262 downloads prior to CSRF protection plus 3031 downloads as of 06 Nov 2010!

[nitro]

It seems the portals global.php is the file. Im pretty sure this is called via a plugin in vbulletin using require_once under global start with vbulletin for the product

The templates with the conditions in the above post is the navbar

The footer has the condition if $show['leftcolum'] then close left column tables /if

[calorie]

If $foo = "bar"; is set in global_start and $foo is used in navbar, then to have "bar" appear in PhotoPlog, global $foo; goes in the PhotoPlog functions. Without knowing your portal script, not sure what else to offer.

[allstar55]

Ok, i have a server problem.. script is ok.
But, can you import in next version, option to delete not used pictures?

Here in the ftp picture you can see it, all pictures are "deletet" per script.
But in the FTP you can see the old "deleted" pictures.

[calorie]

When the last comment issue was fixed, delete got broken for files with no comments, doh, so just manually delete files no longer in the photoplog_fileuploads table, and upgrade to v.1.0.4.4.

# run the following query via phpMyAdmin and view the list of file names

SELECT filename FROM photoplog_fileuploads;

# if a file in the PhotoPlog images directory is not on the list, then
# delete it from the PhotoPlog images directory via FTP

# DO NOT DELETE ANYTHING FROM THE photoplog_fileuploads TABLE

[LJR]

Okay, I just upgraded from 1.0.3 and I get the following SQL error. Looks like superfluous ) after the fileid in the query. Any suggestions? Thanks

Database error in vBulletin 3.5.2:

Invalid SQL:
SELECT *,
											(SELECT COUNT(*) FROM photoplog_ratecomment WHERE fileid = 41) AS num,
											(SELECT IF(SUM(photoplog_ratecomment.rating) > 0, SUM(photoplog_ratecomment.rating) / SUM(IF(photoplog_ratecomment.rating > 0, 1, 0)), 0) FROM photoplog_ratecomment WHERE fileid = 41) AS ave
											FROM photoplog_ratecomment
											WHERE fileid = 41
											AND moderate = 0
											ORDER BY dateline DESC
											LIMIT 1;

MySQL Error  : You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT COUNT(*) FROM photoplog_ratecomment WHERE fileid = 41) A
Error Number : 1064
Date         : Saturday, December 17th 2005 @ 05:28:14 PM
Script       : http://www.ourspaceonthenet.com/osotn/community/photoplog/index.php
Referrer     : http://www.ourspaceonthenet.com/osotn/community/photoplog/index.php

[LJR]

Okay, this might be to do with me not upgrading to 1.0.3.1 and then from that to 1.0.4.4. Is there an archive where I can get hold of 1.0.3.1?

[Sinistra]

Originally Posted by calorie

@Lord Katsuhito: what type of problem, or perhaps a screenshot might help?

I reuploaded everything it works now ^_^

[calorie]

@LJR: just follow the general upgrade instructions about 2/3 down the README.txt file, there's no need to go through all the steps.

[wobbly]

This is a great piece of coding. I installed without a hitch, nice work.

One question though. Is there anyway to add a module or something so you can see the latest images across the top of your forum?

[calorie]

Check the README.txt file, in the comments section.