virtual rating to make Indexu a quality index
Hello,
so finally here are all steps to make Indexu a quality index which lists links by there ratings. This hack also includes a virtual rating of 2.5 (neutral - neither good nor bad link) for every link.
Instruction:
1. Search within browse.php and search.php for the word "bid" and ad to $query:
2. Now you need to add a neutral value to every link which has no votes. Execute the following query in phpmyadmin or Indexu query box:PHP Code:$query .= " order by bid desc, rating desc";
3. The default value of 2.50 shouln't be displayed as a vote caus it was automatically generated. Links with no votes (but a default rating) should be handeled like regular links.Code:UPDATE idx_link SET rating='2.50' WHERE votes='0';
modify link.class.php (about line 1190):
4. New added links must have a default rating value of 2.50 too!PHP Code:if(($avgr<1)or($votes==0)) { $rating_image = $this->not_yet_rated; $rating_image2 = $rating_image; }
modify link.class.php (about line 1420):
That's it!PHP Code:elseif($field=='rating') $custom_fields_value .= 2.50;
I also set my editor pick to a rating of 5.0. Can be easily done by executing the following sql-statement
greetsCode:UPDATE idx_link SET rating='5.0' WHERE pick ='1';
Joerg
