Loading...
Skip to main content
Navigation and related functionality and content
Features
Requirements
Download
Install
Backup
Upgrade
Help
FAQs
Need Assistance ? Join-us live this Thursday, click for info !
Related content
Find
History: Simple Wiki Ratings
View published page
Source of version: 22
(current)
!Stub This page is a stub of information related to the not-very-well-documented simple wiki ratings feature. !!Enabling and Configuration Set "Simple wiki ratings" under Admin Home, Wiki, Features (tiki-admin.php?page=wiki&cookietab=2) !!FAQ #Where are the results displayed? +tiki-poll_results.php ? Seems to not list Simple Wiki Rating results. +tiki-old_polls.php ? Seems to not list Simple Wiki Rating results. +The results are tabulated in the database table __tiki_user_votings__. The site pages for which the votes are applied are in field "__id__" with __values__ like "wiki2". "Wiki2" in this example, is the Rating Type, "wiki" (as opposed to "article"), and the "2" indicates the "__page_id__" from database table__ tiki_pages__. +Don't know yet if there is a page to display the results. #Why doesn't the rating bar show up on pages for users with lower permissions? +Because templates/tiki-show_page.tpl requires $tiki_p_assign_perm_wiki_page eq 'y' . This appears to be a bug. Consider changing that to " $tiki_p_wiki_vote_ratings eq 'y' ". #Can the collected votes be deleted somehow to reset the tally? !!From lib/prefs/wiki.php: {CODE(wrap="0")}'wiki_simple_ratings' => array( 'name' => tra('Simple wiki ratings'), 'description' => tra('Enable users to rate articles based on a simple numeric scale.'), 'type' => 'flag', 'default' => 'n', ), 'wiki_simple_ratings_options' => array( 'name' => tra('Wiki rating options'), 'description' => tra('List of options available for the rating of wiki pages.'), 'type' => 'text', 'separator' => ',', 'filter' => 'int', 'default' => range(1, 5), ),{CODE} !!From tiki-admin.php: {CODE(wrap="0")}"rating" => array( 'position' => '-300px -215px;', 'icon' => 'img/icons/large/rating.png', 'title' => tr('Rating'), 'help' => 'Advanced+Rating', 'disabled' => $prefs['wiki_simple_ratings'] !== 'y' && $prefs['rating_advanced'] !== 'y' && $prefs['article_user_rating'] !== 'y', ),{CODE} !!From lib/rating/ratinglib.php References database table "tiki_user_votings". {CODE(wrap="0")}function get_options( $type ) { $pref = 'rating_default_options'; switch( $type ) { case 'wiki page': $pref = 'wiki_simple_ratings_options'; break; case 'article': $pref = 'article_user_rating_options'; break; } global $tikilib; return $tikilib->get_preference($pref, range(1, 5), true); }{CODE} !!From lib/test/rating/RegisterVoteTest.php {CODE(wrap="0")}function testGetWikiPageRange() { global $prefs; $prefs['wiki_simple_ratings_options'] = range(2, 8); $lib = new RatingLib; $this->assertEquals(range(2, 8), $lib->get_options('wiki page')); }{CODE} !! From templates/tiki-show_page.tpl $tiki_p_assign_perm_wiki_page appears to be a bug. Too strong. Should perhaps be $tiki_p_wiki_vote_ratings . {CODE(wrap="0")} {if $prefs.feature_wiki_ratings eq 'y'} {include file='poll.tpl'} {/if} {if $prefs.wiki_simple_ratings eq 'y' && $tiki_p_assign_perm_wiki_page eq 'y'} <form method="post" action=""> {rating type="wiki page" id=$page_id} </form> {/if} {CODE} !!From lib/core/Tracker/Field/Rating.php: $votings = TikiDb::get()->table('tiki_user_votings'); !!From lib/polls/polllib_shared.php: $query = "select user from `tiki_user_votings` where `optionId`=?"; ' left join `tiki_user_votings` tuv on (tpo.`optionId` = tuv.`optionId`)' . $query = 'delete from `tiki_user_votings` where `id`=?'; $query = 'delete from `tiki_user_votings` where `id`=? and `optionId`=? and '; !!From lib/rating/ratinglib.php: $joins = array( '`tiki_user_votings` `uv`' ); INNER JOIN ( SELECT ' . $connect . '(`time`) `t`, `user` `u` FROM `tiki_user_votings` WHERE ' . implode(' AND ', $where) . ' GROUP BY `user` ' . $extra . ' ) `j` 'INSERT INTO `tiki_user_votings` ( `user`, `ip`, `id`, `optionId`, `time` ) VALUES( ?, ?, ?, ?, ? )', 'SELECT `optionId` FROM `tiki_user_votings` WHERE `user` = ? AND `id` = ? ORDER BY `time` DESC', !!From lib/surveys/surveylib.php: $query = 'delete from `tiki_user_votings` where `id`=?'; !!lib/test/rating/AggregationTest.php: TikiDb::get()->query('DELETE FROM `tiki_user_votings` WHERE `id` LIKE ?', array('test.%')); !! Fromlib/test/rating/RegisterVoteTest.php: return TikiDb::get()->fetchAll('SELECT `user`, `id`, `optionId` FROM `tiki_user_votings` WHERE `id` LIKE ? ORDER BY `user`, `id`, `optionId`', array('test.%')); !!lib/tikilib.php: $query = "select count(*) from `tiki_user_votings` where `user`=? and `id`=?"; $userVotings = $this->table('tiki_user_votings'); $vote = $this->getOne("select `optionId` from `tiki_user_votings` where `user` = ? and `id` = ? order by `time` desc", array( $user, $id)); !!lib/trackers/trackerlib.php: $userVotings = $this->table('tiki_user_votings'); ... !!lib/userslib.php: $this->query('update `tiki_user_votings` set `user`=? where `user`=?', array($to, $from)); !!lib/wiki-plugins/wikiplugin_votings.php: $votings = TikiDb::get()->table('tiki_user_votings'); !! From other pages {CODE(wrap="0")}$ grep -C5 -iR "wiki_simple_ratings" * | grep -v -e templates_c -e temp\/cache #redacted out the above templates/admin/include_rating.tpl- {preference name=ip_can_be_checked} templates/admin/include_rating.tpl- </fieldset> templates/admin/include_rating.tpl- templates/admin/include_rating.tpl- <fieldset> templates/admin/include_rating.tpl- <legend>{tr}Wiki{/tr}</legend> templates/admin/include_rating.tpl: {preference name=wiki_simple_ratings} templates/admin/include_rating.tpl: <div class="adminoptionboxchild" id="wiki_simple_ratings_childcontainer"> templates/admin/include_rating.tpl: {preference name=wiki_simple_ratings_options} templates/admin/include_rating.tpl- </div> templates/admin/include_rating.tpl- </fieldset> templates/admin/include_rating.tpl- templates/admin/include_rating.tpl- <fieldset> templates/admin/include_rating.tpl- <legend>{tr}Articles{/tr}</legend> -- templates/admin/include_wiki.tpl- templates/admin/include_wiki.tpl- {preference name=feature_wiki_ratings} templates/admin/include_wiki.tpl- <div class="adminoptionboxchild" id="feature_wiki_ratings_childcontainer"> templates/admin/include_wiki.tpl- <a class="link" href="tiki-objectpermissions.php?permType=wiki&textFilter=ratings&show_disabled_features=y" title="{tr}Permission{/tr}">{icon _id="key" alt="{tr}Permission{/tr}"}</a> templates/admin/include_wiki.tpl- </div> templates/admin/include_wiki.tpl: {preference name=wiki_simple_ratings} templates/admin/include_wiki.tpl: <div class="adminoptionboxchild" id="wiki_simple_ratings_childcontainer"> templates/admin/include_wiki.tpl: {preference name=wiki_simple_ratings_options} templates/admin/include_wiki.tpl- </div> templates/admin/include_wiki.tpl- templates/admin/include_wiki.tpl- {preference name=feature_backlinks} templates/admin/include_wiki.tpl- <div class="adminoptionboxchild" id="feature_backlinks_childcontainer"> templates/admin/include_wiki.tpl- {preference name=wiki_backlinks_name_len}
Related content
