With MODX CMS you can let your website's users vote for cool article / info / post. There are different ways of making a voting system for your site but imagine your article's rating is stored in TV called 'rating'. So, whow can one get the most rated resource id?

It's just to access the table getFullTableName('site_tmplvar_contentvalues'):

<?php $tblName = $modx->getFullTableName('site_tmplvar_contentvalues'); $selectQuery = $modx->db->select('value,contentid', $tblName, '`tmplvarid`=60'); $votes = $modx->db->makeArray($selectQuery); //$output=''; if(is_array($votes)){ $max = intval($votes[0]['value']); // echo $max; $id= intval($votes[0]['contentid']); foreach($votes as $vote){ //$output.= '<br>Vote Value='. intval($vote['value']).' voteId='.intval($vote['contentid']); if($max < intval($vote['value'])){ $max = intval($vote['value']); $id= intval($vote['contentid']); } } } $docid=$id; ?>

* The `tmplvarid`=60 is the id of your rating tv generated by MODX on saving new tv name.

Below this article you can find the rating system in Stars mode and on the right sidebar the most voted item output updated dinamically after each vote.

Rate this information:

• Currently2.99207135778/5 Stars
• 1
• 2
• 3
• 4
• 5

May we recommend:

Change php / html theme opencart  ModX CMS for company presentation  Warehouse pick-n-pack software  map points of sales with MODX documents  

MODX CMS extensions Sale:

OCS different template per a product  4h support  MODX Evolution documents as products export to google base  build your product in opencart  

Modx Extras for advanced content