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

[Alfatrion]

I've looked in to the SQL error, but can not confirm the bug for 0.3.5. Would you please upgrade to 0.3.5? If copying includes/functions_posts_ratings.php doesn't help would you please add before:

FILE: includes/functions_posts_ratings.php
LINE: 1420
CALL: is_voteround_open()

the following:
print "topic=$topic_id post=$post_id user=$user_id<br>";

I'm guessing that $row['topic_first_post_id'] doesn't get set some how in viewtopic.php.

The forth note will be in 0.3.6 (I usually copy the lines, then this doesn't happen) Thanks for reporting it.

@tupeu: That's just a bug update. New features will not be included before 0.4.0

[f.palagiano]

Hi again.
I've done some debugging, and it seems the problem is here:

$template->assign_vars(posts_ratings_display_rating_topics($topic_info, $posts_ratings_data));

The $topic_info array is empty (there's no place in viewtopic.php where it is declared or initialized or populated), so nothing is passed to the posts_ratings_display_rating_topics() function.

PS - I've upgraded to version 0.3.5 but the error is still there.

[f.palagiano]

Ok, so: I've replaced $topic_info with $topic_data and all went fine.

[Alfatrion]

I've included your translation for 0.3. Tanks again for your efforts.

[phpDummie]

Alfatrion, I've but three questions:

• what karma MOD are you using
• how is karma calculated
• how about freezing the feature set and getting it out for approval

[Alfatrion]

1. I don't understand the question. I'm using my own karma mod.

2. Karma is calculated through a weighted algorithme. You can set the interval period and the number of intervals. Ratings within the last interval get a weight of 1 and the first get a interval of N^2 - (N-1)^2 = 2*N - 1 Thus we get a weighted average.

3. I don't understand what you mean by this. Karma is indirectly calculated, you can invluence it by changing the ratings of posts.

[Kalapuikkoja]

hey, maybe I didn't read it, but I want to use that MOD for a Fanfiction-Competion.
So is that possible that the users ONLY can vote in a specific forum?
and just for a time the admin sets?
Maybe just for may, and june not?


thanks for answers

edit

[dlt123]

link for this great mod please

I agree, nice mod.
Dennis

[Alfatrion]

No ratings are enabled for the whole board. If you want this then you should modify the code. I agree that this would be nice feature to have.

Yes users can only vote for a time the admin sets. This is relative to date of the post.

@Dennis: Tanks Dennis.

[phpDummie]

1. I don't understand the question. I'm using my own karma mod.

OK, there are other karma MODs out there, so I thought you may have used somebody else's. Yours is fine - keeps it all in the same hands.

2. Karma is calculated through a weighted algorithme. You can set the interval period and the number of intervals. Ratings within the last interval get a weight of 1 and the first get a interval of N^2 - (N-1)^2 = 2*N - 1 Thus we get a weighted average.

eh... So if I rate Joe Q. Public's post at one star it lowers his karma... right? By how much?
And if I rate it at five stars, it will raise his karma? By how much?

3. I don't understand what you mean by this. Karma is indirectly calculated, you can invluence it by changing the ratings of posts.

I mean the Post Rating System MOD. Looking at MOD's features, it has plenty and it's all good. You should release it if it doesn't have any bugs.

[dlt123]

[NOTE] Please read two more posts ahead, I am at a point where I need help populating my SQL DB with the templates. [/NOTE]

You know the more I look at your avatar Alfatrion, the more tired it looks... Hang in there.

I was going to install another MOD, but decided this was higher on my priority list so I am going to do this one first... and this will be my first MOD attempt... I'm a MOD vrgn.

I have one question before I begin the install of this MOD... I have MSSql and not MySql, so running phpMyAdmin will not work for installing the SQL portion of this MOD.

In order to do the SQL database population, can I just copy the SQL code from the INSTALL.XML file and pop it in a php file of my choosing, i.e. Post_Rate_Mod_SQL_Install_db.php, then copy it to the root of my web site, (or do I need to copy it to the phpBB3 folder), then run it using my Firefox browser?

Note: Just so you know, I am going to make backup copies of ALL pre-edited files along with making a copy of my SQL Database so I can revert back in case I goof up this MOD installation.

Anything else I need to be aware of before starting this install?

Thanks,
Dennis

[dlt123]

Well all went fine until I tried to edit my viewforum.php file and searched for... (this was the 3rd find in file)

[EDIT] FOUND>>> the strings, they are really jumbled in the install.xml file... Just do a search for S_TOPIC_TYPE_SWITCH and you'll find the whole line... then add the ADD code where you're supposed to...[/EDIT]

Code: Select all

                        'S_TOPIC_TYPE_SWITCH'   => ($s_type_switch == $s_type_sw
itch_test) ? -1 : $s_type_switch_test)
                );

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

[EDIT] FOUND >>> Again text in install.xml file is really jumbled and spaced out... doing a search for one of the strings in the FIND text will locate where you need to insert... [/EDIT]

Could not find the following text in the memberlist.php file...(this is the 2nd find)

Code: Select all

// a_user admins
and founder are able to view inactive users and bots to be able to manage them m
ore easily
// Normal users are able to see at least users having only changed their profile
 settings but not yet reactivated.

These were the only two files I had problems with... BUT did manage to find the strings and make changes...

ooooohhh, talk about delayed gratification...

Thanks,
Dennis

[dlt123]

OK I copied my files over, but I'm not sure how to populate my SQL DB... I tried to run my iPost_Rate_Mod_SQL_Install_db.php file and it didn't work... So I am not sure what to do now.

I logged onto my forum and tried to create a post and got the following error message when I processed the post...

Code: Select all

SQL ERROR [ mysql4 ]

Table 'roadt2.phpbb_posts_ratings_modpoints' doesn't exist [1146]

SQL

DELETE FROM phpbb_posts_ratings_modpoints WHERE time < 1200632179

BACKTRACE

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

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

FILE: includes/functions_posts_ratings.php
LINE: 2276
CALL: clean_modpoints()

FILE: posting.php
LINE: 1008
CALL: posts_ratings_new_posts()

I would have to say I need my DB populated with the SQL code from the code in install.xml. As mentioned earlier, I created a file called, Post_Rate_Mod_SQL_Install_db.php and added the SQL code text from install.xml... I then uploaded it to my phpBB3 root, and tried to launch it from my browser... No deal it didn't work. Guess it shows you what I know about SQL databases...

I don't know how I am going to do this since I am using MSSQL and can't use phpMyAdmin... any suggestions?

Also on a final note, I manually copied over the root/styles/prosilver/imageset star files. Not sure if I should have done this but I did.

Dennis

[Alfatrion]

eh... So if I rate Joe Q. Public's post at one star it lowers his karma... right? By how much?
And if I rate it at five stars, it will raise his karma? By how much?

First there are votes and there a ratings. A rating is the average vote for a post. The karma will stay between 1 and 5. If someone post has only 5 star ratings then his karma will be 5.

I can't say by how much it would raise or lower the karma of someone. It depends on the number of posts a users has (each post has a default rating of 3) and on the votes of other users.

[Alfatrion]

You know the more I look at your avatar Alfatrion, the more tired it looks... Hang in there.

It must be all that cheese. You could make it in to a gif with a transparent layer with photoshop or the gimp to lose all that white.

In order to do the SQL database population, can I just copy the SQL code from the INSTALL.XML file and pop it in a php file of my choosing, i.e. Post_Rate_Mod_SQL_Install_db.php, then copy it to the root of my web site, (or do I need to copy it to the phpBB3 folder), then run it using my Firefox browser?

You need to run it with the client for your database. You could write a php file to do this for you, but it not as simple a just copy-past.

Anything else I need to be aware of before starting this install?

Take it one step at a time. If you have trouble with the SQL then don't continue until your insert the SQL.

I don't know how I am going to do this since I am using MSSQL and can't use phpMyAdmin... any suggestions?

I can't help you with using MSSQL. Perhaps you can get support from on of the other forums on this board for that.

Also on a final note, I manually copied over the root/styles/prosilver/imageset star files. Not sure if I should have done this but I did.

You should copy all files within root/ for this mod to work.