Forum Useful Post Ratings

Nice. Great Job. :) Keep it on.

very nice , thanks

That reminds me I need to use output replacement for Ajax Forum Post ratings next version.

I better get started. :)

Good :)

But I am still confused to do it in that way people are asking... in the Bottom/Footer of the Post... :o

very very very good work!
;)

Thanks to you... :D

In this Infusion, I am replacing the Line which contains the Post ID, i.e,
[syntaxhighlighter brush=php,first-line=1,highlight=0,collapse=false,html-script=false]echo "<a href='#post_".$data['post_id']."' name='post_".$data['post_id']."' id='post_".$data['post_id']."'>";[/syntaxhighlighter]
And I am doing this for All Posts for a particular Thread by evaluating them one by one.

But don't know How to Replace Each of the <!--sub_forum_post--> one by one for different Post ID's... :(

I am Stuck... :@

Forum Useful Post Ratings v 1.0 using SMALLINT only.
[syntaxhighlighter brush=php,first-line=1,highlight=3,collapse=false,html-script=false]$inf_newtable[1] = DB_FORUM_USEFUL_RATINGS." (
rating_id SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT,
post_id SMALLINT(5) UNSIGNED NOT NULL,
user_id SMALLINT(5) UNSIGNED NOT NULL,
rating_value TINYINT(1) UNSIGNED NOT NULL,
PRIMARY KEY (rating_id)
) ENGINE=MyISAM;";[/syntaxhighlighter]

SMALLINT does not match the Fusion v7.02.05
[syntaxhighlighter brush=sql,first-line=1,highlight=4,collapse=false,html-script=false]CREATE TABLE IF NOT EXISTS fusion2013_posts (
forum_id mediumint(8) unsigned NOT NULL DEFAULT '0',
thread_id mediumint(8) unsigned NOT NULL DEFAULT '0',
post_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
post_message text NOT NULL,
post_showsig tinyint(1) unsigned NOT NULL DEFAULT '0',
post_smileys tinyint(1) unsigned NOT NULL DEFAULT '1',
post_author mediumint(8) unsigned NOT NULL DEFAULT '0',
post_datestamp int(10) unsigned NOT NULL DEFAULT '0',
post_ip varchar(45) NOT NULL DEFAULT '',
post_ip_type tinyint(1) unsigned NOT NULL DEFAULT '4',
post_edituser mediumint(8) unsigned NOT NULL DEFAULT '0',
post_edittime int(10) unsigned NOT NULL DEFAULT '0',
post_editreason text NOT NULL,
post_hidden tinyint(1) unsigned NOT NULL DEFAULT '0',
post_locked tinyint(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (post_id),
KEY thread_id (thread_id),
KEY post_datestamp (post_datestamp)
) ENGINE=MyISAM DEFAULT CHARSET=latin2 AUTO_INCREMENT=1 ;[/syntaxhighlighter]


Temporary fix Temporary fix Temporary fix
\infusions\forum_useful_post_rating_panel\infusion.php
[syntaxhighlighter brush=php,first-line=1,highlight=3,collapse=false,html-script=false]$inf_newtable[1] = DB_FORUM_USEFUL_RATINGS." (
rating_id SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT,
post_id MEDIUMINT(8) UNSIGNED NOT NULL,
user_id SMALLINT(5) UNSIGNED NOT NULL,
rating_value TINYINT(1) UNSIGNED NOT NULL,
PRIMARY KEY (rating_id)
) ENGINE=MyISAM;";[/syntaxhighlighter]

Features are not clear

[syntaxhighlighter brush=plain,first-line=1,highlight=5,collapse=false,html-script=false]Features:-
- Easy Installation
- No Core Files Editing
- Disable/Enable anytime from Admin Page
- Shows Top 10 Helpful Posters in Admin Page[/syntaxhighlighter]
It shows something in Admin Page

I was changed Helpful post 1:0 to unhelpfull 0:1 by thumb down.
Statistics - Top 10 Forum Helpers still shows Helpful posts = 1 and Post URL to unhelpful forum post in table

Nice one BUT...if people choose the thumb down,...... in admin it counts one up.
Why not a database table with a plus and minus rating so that the admin can see the usefull posts and the less usefull posts....?