Gah .. i seem to have the database problem others have.

vBulletin 3.5.1:

Invalid SQL:
SELECT *,
(SELECT COUNT(*) FROM photoplog_ratecomment WHERE fileid = 1) 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 = 1) AS ave
FROM photoplog_ratecomment
WHERE fileid = 1
AND moderate = 0
ORDER BY dateline DESC
LIMIT 1;

MySQL Error : You have an error in your SQL syntax near 'SELECT COUNT(*) FROM photoplog_ratecomment WHERE fileid = 1) AS num,
' at line 2
Error Number : 1064
Date : Thursday, December 15th 2005 @ 02:05:53 PM



I checked the "view PHP info" in the admin CP to check on what version of mysql and it's 3.23.58 according to the print out. It's a unix system from what I understand and my webhosts seem to be twits at times. I fear asking them to upgrade the version ... :D
It worked up to the categories before, just installed the 1.0.4 patch and got this error. Yay for outdated computers!

Oh.. also, will we be able to, in the future, restrict categories based on usergroups? So we can make a category that specifically is forbidden to everyone but one or two groups of users?

@nitro: you need to do the globals thing, plus use the variable in a PhotoPlog template if said variable is not part of your vB header, navbar, or footer already.

FYI: PhotoPlog 1.0.4.1 released: divided queries, template changes, pound in letter bar, who's online, not sure what the future holds. See the README.txt in the new ZIP archive for upgrade instructions.

Thank you.

Works great

descriptions for the tcat bars would be cool.
For memberinfo and the 5 random pics in the photoplog index ;)

Updatet:
http://www.nfs-center.de/showroom/index.php

Please make in next version in File List Information only ~30 characters, rest with ....
In Upload Area, max kb filesize specify for users.

Bugs:
I can't see not all stars full.


otherwise nice work :)

Works great! Thanks!

@allstar55: what browser are you using (see attachment)?

I am having a problem with the admin CP adding catagories. my Vb version is 3.5.2

Works fantastic now except any comments that I place say "Not Available" .. any ideas on that one?

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

@lordnex: check category and user permissions for allowing/viewing comments.