https://www.icyphoenix.com/viewtopic.php?f=26&t=2517
-----------------------------------
mipavluk
Tue 24 Jul, 2007 01:40

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

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 [url=http://www.mightygorgon.com]MightyGorgon.com


-----------------------------------
mipavluk
Wed 25 Jul, 2007 04:47

Re: Counted Comments
-----------------------------------
Artie!!! You are the best! TY!!!!!!!!!!!
Here is the solution: 
http://smartor.is-root.com/viewtopic.php?t=11661&postdays=0&postorder=asc&highlight=post+count&start=0


-----------------------------------
Artie
Wed 25 Jul, 2007 15:50

Re: Counted Comments
-----------------------------------
You're welcome...glad you found it.  8)


-----------------------------------
mipavluk
Sat 01 Sep, 2007 18:37

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/viewtopic.php?t=11661&postdays=0&postorder=asc&highlight=post+count&start=0

[code]In album_showpage.php find:

 // --------------------------------  
 // Insert into DB  
 // --------------------------------  
 
 $SQL = "INSERT INTO ". ALBUM_COMMENT_TABLE ." (comment_id, comment_pic_id, comment_user_id, comment_username, comment_user_ip, comment_time, comment_text)  
     VALUES ('$comment_id', '$pic_id', '$comment_user_id', '$comment_username', '$comment_user_ip', '$comment_time', '$comment_text')";  
 if( !$result = $DB->sql_query($SQL) )  
 {  
   message_die(GENERAL_ERROR, 'Could not insert new entry', '', __LINE__, __FILE__, $SQL);  
 }  

*****After add*****

$SQL = "UPDATE " . USERS_TABLE . " SET user_posts = user_posts + 1 WHERE user_id = " . $userdata['user_id'];  
 if( !$result = $DB->sql_query($SQL) )  
 {  
   message_die(GENERAL_ERROR, 'Could not update post count', '', __LINE__, __FILE__, $SQL);  
 } [/code]

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

[code]		// Insert into DB
		// If user only rated, but didn't enter a comment... only update rating
		if ( $comment_text != '' )
		{
			$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)
					VALUES ('$comment_id', '$pic_id', '$cat_id', '$comment_user_id', '$comment_username', '$comment_user_ip', '$comment_time', '$comment_text')";
			if( !$result = $db->sql_query($sql) )
			{
				message_die(GENERAL_ERROR, 'Could not insert new entry', '', __LINE__, __FILE__, $sql);
			}[/code]

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[/quote]

Please, anybody can help me? Thanks in advance!


-----------------------------------
Artie
Sun 02 Sep, 2007 18:49

Re: FAP 1.4.1. & Counted Comments
-----------------------------------
In the code you added, change [highlight=#FF0000]$DB[/highlight] to [highlight=#00ff00]$db[/highlight]


[size=10][color=red]Merged with previous thread of same topic [/color][/size]


-----------------------------------
mipavluk
Sun 02 Sep, 2007 23:37

Re: Counted Comments
-----------------------------------
oh Artie!
You are my hero! definitively!  :love:  :love:  :love: 
Thanks!!!


