FAP SUPPORT - Counted Comments »  Show posts from    to     

Icy Phoenix


Archived phpBB Topics (Styles, Mods, Support) - FAP SUPPORT - Counted Comments



mipavluk [ Tue 24 Jul, 2007 01:40 ]
Post subject: FAP SUPPORT - Counted Comments
Hi there!
I have installed the FAP 1.4.0 and I have a problem: the album comments is not counted, don't sink, no matter how much I post in album, my post numers continues intact, it is not increased.
I need fixed it!!! Please!!!!
Thanks in advance! and sorry for my fair english!
M.


Artie [ Tue 24 Jul, 2007 23:39 ]
Post subject: Re: Counted Comments
That is correct. Album comments do not increase your post count.

But, I think someone has modded for this..... search here or at MightyGorgon.com


mipavluk [ Wed 25 Jul, 2007 04:47 ]
Post subject: Re: Counted Comments
Artie!!! You are the best! TY!!!!!!!!!!!
Here is the solution:
http://smartor.is-root.com/viewtopi...t+count&start=0


Artie [ Wed 25 Jul, 2007 15:50 ]
Post subject: Re: Counted Comments
You're welcome...glad you found it.


mipavluk [ Sat 01 Sep, 2007 18:37 ]
Post subject: FAP 1.4.1. & Counted Comments
Hi there!

Well... I install FAP 1.4.1. and now... the comments is not counted again!

With my FAP 1.4.0 I use this solution:
http://smartor.is-root.com/viewtopi...t+count&start=0

Code: [Hide]
  1. In album_showpage.php find:  
  2.  
  3. // --------------------------------  
  4. // Insert into DB  
  5. // --------------------------------  
  6.  
  7. $SQL = "INSERT INTO ". ALBUM_COMMENT_TABLE ." (comment_id, comment_pic_id, comment_user_id, comment_username, comment_user_ip, comment_time, comment_text)  
  8. VALUES ('$comment_id', '$pic_id', '$comment_user_id', '$comment_username', '$comment_user_ip', '$comment_time', '$comment_text')";  
  9. if( !$result = $DB->sql_query($SQL) )  
  10. {  
  11. message_die(GENERAL_ERROR, 'Could not insert new entry', '', __LINE__, __FILE__, $SQL);  
  12. }  
  13.  
  14. *****After add*****  
  15.  
  16. $SQL = "UPDATE " . USERS_TABLE . " SET user_posts = user_posts + 1 WHERE user_id = " . $userdata['user_id'];  
  17. if( !$result = $DB->sql_query($SQL) )  
  18. {  
  19. message_die(GENERAL_ERROR, 'Could not update post count', '', __LINE__, __FILE__, $SQL);  
  20. }  


But now... with FAP 1.4.1. my album_showpage.php is different... the only similar line is:

Code: [Hide]
  1. // Insert into DB  
  2. // If user only rated, but didn't enter a comment... only update rating  
  3. if ( $comment_text != '' )  
  4. {  
  5. $sql = "INSERT INTO " . ALBUM_COMMENT_TABLE ." (comment_id, comment_pic_id, comment_cat_id, comment_user_id, comment_username, comment_user_ip, comment_time, comment_text)  
  6. VALUES ('$comment_id', '$pic_id', '$cat_id', '$comment_user_id', '$comment_username', '$comment_user_ip', '$comment_time', '$comment_text')";  
  7. if( !$result = $db->sql_query($sql) )  
  8. {  
  9. message_die(GENERAL_ERROR, 'Could not insert new entry', '', __LINE__, __FILE__, $sql);  
  10. } 


But if I add the solution... I obtain this error:

Quote:
Fatal error: Call to a member function on a non-object in /home/golfplea/public_html/scrapperszone/Forum/album_showpage.php on line 1466


Please, anybody can help me? Thanks in advance!


Artie [ Sun 02 Sep, 2007 18:49 ]
Post subject: Re: FAP 1.4.1. & Counted Comments
In the code you added, change $DB to $db


Merged with previous thread of same topic


mipavluk [ Sun 02 Sep, 2007 23:37 ]
Post subject: Re: Counted Comments
oh Artie!
You are my hero! definitively!
Thanks!!!




Powered by Icy Phoenix