PhotoPlog

PhotoPlog (http://www.photoplog.com/forum/index.php)
-   Bugs & Issues Tracker (http://www.photoplog.com/forum/forumdisplay.php?f=8)
-   -   [Closed via Lite v.2.0.0] Comment Counts dont get updated (http://www.photoplog.com/forum/showthread.php?t=107)

theguywhoknowz 03-03-2006 06:13 PM

[Closed via Lite v.2.0.0] Comment Counts dont get updated
 
When you move the file to different category, you can see it abvious on my testing website http://www.GameReviews.com

Morgan 03-03-2006 08:11 PM

In the PhotoPlog edit.php file find:
Code:

                if ($photoplog_file_old && $photoplog_file_edit)
And beforehand add the following:
Code:

                $db->query_write("UPDATE photoplog_ratecomment
                                SET catid = ".intval($photoplog_file_catid)."
                                WHERE fileid = ".intval($photoplog_file_id)."
                ");

Then from your browser edit the image and save, and next cache update the counts will correct.

Also, as an aside, in the PhotoPlog comment.php and delete.php files find:
Code:

                        $db->query_first("DELETE FROM photoplog_ratecomment
And replace query_first with query_write as follows:
Code:

                        $db->query_write("DELETE FROM photoplog_ratecomment


All times are GMT. The time now is 07:04 AM.

Powered by vBulletin® Version 3.8.5
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.