[ABD] (Topic &) Post Rating System (with Karma module)

Any abandoned MODs will be moved to this forum.

WARNING: MODs in this forum are not currently being supported or maintained by the original MOD author. Proceed at your own risk.
Forum rules
IMPORTANT: MOD Development Forum rules

WARNING: MODs in this forum are not currently being supported nor updated by the original MOD author. Proceed at your own risk.
I M lost
Registered User
Posts: 23
Joined: Mon Feb 04, 2008 1:49 pm

Re: [DEV]Post Rating System

Post by I M lost »

Yep, sure did.

I have retransfered all the files from root to their appropriate places twice. And verified the code modding 3 times, making sure I pasted it before/after the correct line.

I verified that all the supplied files were in the appropriate directory under root, and I dont seem to be missing any from the compressed archive. I reverified that all the transfered files where in their correct locations on the server, and they were.

Im as stumped as a tree.
User avatar
Alfatrion
Registered User
Posts: 166
Joined: Sat Feb 17, 2007 3:06 am

Re: [DEV]Post Rating System

Post by Alfatrion »

I can confirm this. For know I know of two bugs in 0.3.8:

1. Post with no votes do not get the default rating of 3.
2. When setting display active topics to yes and viewing a forum with no post a SQL error is through through. (Does adding a post help?)

I'll get back on this.

Please next time also report all the steps you taken. In this case you viewed a empty forum. Not having this information might prevent me from conforming a bug.
My abandoned (for own reference). mod: Post Rating System (website | screenshots | demo | support)
User avatar
Alfatrion
Registered User
Posts: 166
Joined: Sat Feb 17, 2007 3:06 am

Re: [DEV]Post Rating System

Post by Alfatrion »

rafee wrote:

Code: Select all

Błąd parsowania XML: nieprawidłowo sformowany
Obszar: file:///D:/xxxx/xxxxxxxxxxx/xxxxxxxxxxxxx/Post_Rating_System/templates/prosilver.xml
Numer linii 113, kolumna 8:			<!-- IF S_POSTS_RATINGS_ENABLED -->
----------------------------^
Please Help :(

Open You mods :(
This will be fixed in 0.3.9 or maybe if you download 0.3.8 again. Reading the XML with a editor should be doable.
My abandoned (for own reference). mod: Post Rating System (website | screenshots | demo | support)
I M lost
Registered User
Posts: 23
Joined: Mon Feb 04, 2008 1:49 pm

Re: [DEV]Post Rating System

Post by I M lost »

Tried to delete one of my posts and got this error. Dont know what or how I got it, because I cannot get this mod to work for me. It does not show stars anywhere!! But none the less, it seems to be tracking points or something.

Code: Select all

General Error
SQL ERROR [ mysql4 ]

Out of range value adjusted for column 'points' at row 1 [1264]

SQL

UPDATE phpbb_posts_ratings_modpoints SET points = -2 WHERE user_id = 2 AND time = 1202160014

BACKTRACE

FILE: includes/db/mysql.php
LINE: 158
CALL: dbal->sql_error()

FILE: includes/functions_posts_ratings.php
LINE: 2208
CALL: dbal_mysql->sql_query()

FILE: includes/functions_posts_ratings.php
LINE: 2231
CALL: reduce_modpoints()

FILE: includes/functions_posts_ratings.php
LINE: 2283
CALL: reduce_modpoints_deleted_post()

FILE: posting.php
LINE: 1452
CALL: posts_ratings_delete_post()

FILE: posting.php
LINE: 283
CALL: handle_post_delete()

**edit**

Ok, I figured out how I got that error. I have two user names on my board. One being my admin account, the other being my "normal" account. Sometimes I forget I am logged in as Admin when I post. So I will use the "Info" button and change the post author to my "Normal" account username. Then I tried to delete the post and guess I did not rack up enough points with that username. Once I changed the post author back, I was able to delete the post and did not get this error.



Can anyone make a suggestion why this rating system seems to be working on the back end, but not on the visual side? Is there a way to check my post ratings without the use of visual stars?

**/edit**
User avatar
Alfatrion
Registered User
Posts: 166
Joined: Sat Feb 17, 2007 3:06 am

Re: [DEV]Post Rating System

Post by Alfatrion »

Did you refresh the templates?
My abandoned (for own reference). mod: Post Rating System (website | screenshots | demo | support)
User avatar
Libor
Registered User
Posts: 33
Joined: Tue Jul 03, 2007 8:12 pm

Re: [DEV]Post Rating System

Post by Libor »

Alfatrion wrote:What did you see when you run these SQL commands with a sql client?
How can I run these commands with sql client? I use phpMyAdmin and I don´t know where exactly I must run these commands and which exactly commands.
My czech forum about mp3 players: http://www.mujprehravac.cz/forum/
I use many of items here in forum. Thanks all for help and mods.
User avatar
Alfatrion
Registered User
Posts: 166
Joined: Sat Feb 17, 2007 3:06 am

Re: [DEV]Post Rating System

Post by Alfatrion »

Select the right database on the left. Then enter the sql tab and enter eacht query one at a time. Your bug seems to be related to one I have conformed from I M lost. Does this bug only happens for you with forum without any threats or posts?
My abandoned (for own reference). mod: Post Rating System (website | screenshots | demo | support)
I M lost
Registered User
Posts: 23
Joined: Mon Feb 04, 2008 1:49 pm

Re: [DEV]Post Rating System

Post by I M lost »

yep, refreshed / cleared cache on everything except imagesets.
User avatar
Alfatrion
Registered User
Posts: 166
Joined: Sat Feb 17, 2007 3:06 am

Re: [DEV]Post Rating System

Post by Alfatrion »

I will be a couple of weeks away.

@I M lost: I'm clueless. Its sound like the template wasn't refreshed. What you need to do is look for things that tell you (know) whats going on. You could check the html it puts out (show it here), you could check the database if it got the right template files. (Look for the table phpbb_styles_template_data.)
Is there a way to check my post ratings without the use of visual stars?
Yes though the database interface. These are the tables your looking for:
# Browse phpbb_posts
# Browse phpbb_posts_ratings_modpoints
# Browse phpbb_posts_ratings_penalty
# Browse phpbb_posts_ratings_votes
# Browse phpbb_posts_ratings_votes_chi

You could check if the link on the stars work. You can work out what it would be from my demo site.
My abandoned (for own reference). mod: Post Rating System (website | screenshots | demo | support)
BeautyGal
Registered User
Posts: 249
Joined: Sun Jul 01, 2007 4:44 pm

Re: [DEV]Post Rating System

Post by BeautyGal »

Ok, So I downloaded and installed this - How can I activate now - through ACP?
I M lost
Registered User
Posts: 23
Joined: Mon Feb 04, 2008 1:49 pm

Re: [DEV]Post Rating System

Post by I M lost »

BeautyGal wrote:Ok, So I downloaded and installed this - How can I activate now - through ACP?

http://www.phpbb.com/community/viewtopi ... 5#p4176805


Thats where I started. A little confusing at first, but a couple of tries and I got it figured out.
I M lost
Registered User
Posts: 23
Joined: Mon Feb 04, 2008 1:49 pm

Re: [DEV]Post Rating System

Post by I M lost »

Ok, looked at DB and found the tables. Only the phpbb_posts and phpbb_posts_ratings_modpoints have records, the rest say Zero.

Table = Records
phpbb_posts = 210
phpbb_posts_ratings_modpoints = 106
phpbb_posts_ratings_penalty = 0
phpbb_posts_ratings_votes = 0
phpbb_posts_ratings_votes_chi = 0

So it appears it is tracking modpoints; but because there are no stars on the posts, people cannot vote which would explain why there are 0 records for the votes table. Not sure what the penalty or vote chi is.

I am going to try to view source on one of my posts and see if it is even trying to display the stars.
BeautyGal
Registered User
Posts: 249
Joined: Sun Jul 01, 2007 4:44 pm

Re: [DEV]Post Rating System

Post by BeautyGal »

Alrighty, I will be waiting for the fix!
I M lost
Registered User
Posts: 23
Joined: Mon Feb 04, 2008 1:49 pm

Re: [DEV]Post Rating System

Post by I M lost »

Your page says:

Code: Select all

			<div class="pagination">
			First post: <img src="./styles/prosilver/imageset/posts_ratings_star_s_10.gif" width="8" height="9" alt="" title="" /><img src="./styles/prosilver/imageset/posts_ratings_star_s_10.gif" width="8" height="9" alt="" title="" /><img src="./styles/prosilver/imageset/posts_ratings_star_s_10.gif" width="8" height="9" alt="" title="" /><img src="./styles/prosilver/imageset/posts_ratings_star_s_05.gif" width="8" height="9" alt="" title="" /><img src="./styles/prosilver/imageset/posts_ratings_star_s_00.gif" width="8" height="9" alt="" title="" />									&bull;

				4 posts			 &bull; Page <strong>1</strong> of <strong>1</strong>		</div>
	
</div>
<div class="clear"></div>

	<div id="p2" class="post bg2 online">
		<div class="inner"><span class="corners-top"><span></span></span>

		<div class="postbody">
							<ul class="profile-icons">
					<li class="edit-icon"><a href="./posting.php?mode=edit&f=3&p=2" title="Edit post"><span>Edit post</span></a></li>					<li class="posts_ratings_star_uv_10"><a title="Voting round closed. Score: 3.5 # 2"><span>1 star</span></a></li>
					<li class="posts_ratings_star_uv_10"><a title="Voting round closed. Score: 3.5 # 2"><span>2 stars</span></a></li>
					<li class="posts_ratings_star_uv_10"><a title="Voting round closed. Score: 3.5 # 2"><span>3 stars</span></a></li>
					<li class="posts_ratings_star_uv_5"><a title="Voting round closed. Score: 3.5 # 2"><span>4 stars</span></a></li>

					<li class="posts_ratings_star_uv_0"><a title="Voting round closed. Score: 3.5 # 2"><span>5 stars</span></a></li>
					<li class="report-icon"><a href="./report.php?f=3&p=2" title="Report this post"><span>Report this post</span></a></li><li class="quote-icon"><a href="./posting.php?mode=quote&f=3&p=2" title="Reply with quote"><span>Reply with quote</span></a></li>				</ul>
			
			<h3 class="first">
My page says:

Code: Select all

			<div class="pagination">

			3 posts			 &bull; Page <strong>1</strong> of <strong>1</strong>		</div>
	
</div>
<div class="clear"></div>

	<div id="p68" class="post bg2">
		<div class="inner"><span class="corners-top"><span></span></span>

		<div class="postbody">
							<ul class="profile-icons">
					<li class="edit-icon"><a href="./posting.php?mode=edit&f=38&p=68" title="Edit post"><span>Edit post</span></a></li><li class="delete-icon"><a href="./posting.php?mode=delete&f=38&p=68" title="Delete post"><span>Delete post</span></a></li><li class="report-icon"><a href="./report.php?f=38&p=68" title="Report this post"><span>Report this post</span></a></li><li class="warn-icon"><a href="./mcp.php?i=warn&mode=warn_post&f=38&p=68&sid=162856a1618550aa19d77a202aae3986" title="Warn user"><span>Warn user</span></a></li><li class="info-icon"><a href="./mcp.php?i=main&mode=post_details&f=38&p=68&sid=162856a1618550aa19d77a202aae3986" title="Information"><span>Information</span></a></li><li class="quote-icon"><a href="./posting.php?mode=quote&f=38&p=68" title="Reply with quote"><span>Reply with quote</span></a></li>				</ul>
			
			<h3 class="first">

Mine is not even trying to display the stars!!!

Again, for the 5th time, checked that I modified the correct files at the correct place, I did. Just for the cause, I reuploaded all the supplied files and overwrote the existing ones. Again, I cleared all my cache except imagesets. Then I went to the General tab in my ACP and pured it there as well. And still nothing. I refrehed all my templates/styles. I made sure that the Rating module was still on, and it is, and still nothing.

There were two files in the zip that I downloaded that I do not recognize: stage1.sh and stage2.sh Do these have any significance?
BeautyGal
Registered User
Posts: 249
Joined: Sun Jul 01, 2007 4:44 pm

Re: [DEV]Post Rating System

Post by BeautyGal »

I M lost wrote:Your page says:

Code: Select all

			<div class="pagination">
			First post: <img src="./styles/prosilver/imageset/posts_ratings_star_s_10.gif" width="8" height="9" alt="" title="" /><img src="./styles/prosilver/imageset/posts_ratings_star_s_10.gif" width="8" height="9" alt="" title="" /><img src="./styles/prosilver/imageset/posts_ratings_star_s_10.gif" width="8" height="9" alt="" title="" /><img src="./styles/prosilver/imageset/posts_ratings_star_s_05.gif" width="8" height="9" alt="" title="" /><img src="./styles/prosilver/imageset/posts_ratings_star_s_00.gif" width="8" height="9" alt="" title="" />									&bull;

				4 posts			 &bull; Page <strong>1</strong> of <strong>1</strong>		</div>
	
</div>
<div class="clear"></div>

	<div id="p2" class="post bg2 online">
		<div class="inner"><span class="corners-top"><span></span></span>

		<div class="postbody">
							<ul class="profile-icons">
					<li class="edit-icon"><a href="./posting.php?mode=edit&f=3&p=2" title="Edit post"><span>Edit post</span></a></li>					<li class="posts_ratings_star_uv_10"><a title="Voting round closed. Score: 3.5 # 2"><span>1 star</span></a></li>
					<li class="posts_ratings_star_uv_10"><a title="Voting round closed. Score: 3.5 # 2"><span>2 stars</span></a></li>
					<li class="posts_ratings_star_uv_10"><a title="Voting round closed. Score: 3.5 # 2"><span>3 stars</span></a></li>
					<li class="posts_ratings_star_uv_5"><a title="Voting round closed. Score: 3.5 # 2"><span>4 stars</span></a></li>

					<li class="posts_ratings_star_uv_0"><a title="Voting round closed. Score: 3.5 # 2"><span>5 stars</span></a></li>
					<li class="report-icon"><a href="./report.php?f=3&p=2" title="Report this post"><span>Report this post</span></a></li><li class="quote-icon"><a href="./posting.php?mode=quote&f=3&p=2" title="Reply with quote"><span>Reply with quote</span></a></li>				</ul>
			
			<h3 class="first">
My page says:

Code: Select all

			<div class="pagination">

			3 posts			 &bull; Page <strong>1</strong> of <strong>1</strong>		</div>
	
</div>
<div class="clear"></div>

	<div id="p68" class="post bg2">
		<div class="inner"><span class="corners-top"><span></span></span>

		<div class="postbody">
							<ul class="profile-icons">
					<li class="edit-icon"><a href="./posting.php?mode=edit&f=38&p=68" title="Edit post"><span>Edit post</span></a></li><li class="delete-icon"><a href="./posting.php?mode=delete&f=38&p=68" title="Delete post"><span>Delete post</span></a></li><li class="report-icon"><a href="./report.php?f=38&p=68" title="Report this post"><span>Report this post</span></a></li><li class="warn-icon"><a href="./mcp.php?i=warn&mode=warn_post&f=38&p=68&sid=162856a1618550aa19d77a202aae3986" title="Warn user"><span>Warn user</span></a></li><li class="info-icon"><a href="./mcp.php?i=main&mode=post_details&f=38&p=68&sid=162856a1618550aa19d77a202aae3986" title="Information"><span>Information</span></a></li><li class="quote-icon"><a href="./posting.php?mode=quote&f=38&p=68" title="Reply with quote"><span>Reply with quote</span></a></li>				</ul>
			
			<h3 class="first">

Mine is not even trying to display the stars!!!

Again, for the 5th time, checked that I modified the correct files at the correct place, I did. Just for the cause, I reuploaded all the supplied files and overwrote the existing ones. Again, I cleared all my cache except imagesets. Then I went to the General tab in my ACP and pured it there as well. And still nothing. I refrehed all my templates/styles. I made sure that the Rating module was still on, and it is, and still nothing.

There were two files in the zip that I downloaded that I do not recognize: stage1.sh and stage2.sh Do these have any significance?
Are you talking about me?

Return to “[3.0.x] Abandoned MODs”