We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
MODX Community Forums Archive

Error In Count

    • 5555
    • 9 Posts
    cnywx Reply #1, 18 years, 10 months ago
    Even though I have the snippet set for ascending ordering, it counts them descending. They show up in the right order, but lets say there are 9 comments. The first one would show up as #9.

    Also, is there anyway to carry post-counts from multiple posts?
      • 33033
      • 43 Posts
      YankeeDeuce Reply #2, 18 years, 10 months ago
      Quote from: cnywx at Dec 19, 2007, 09:03 PM

      Even though I have the snippet set for ascending ordering, it counts them descending. They show up in the right order, but lets say there are 9 comments. The first one would show up as #9.
      Try adding this in your Jot call, it should do the trick. 
      &sortby=`createdon:a` &numdir=`0`


      Quote from: cnywx at Dec 19, 2007, 09:03 PM

      Also, is there anyway to carry post-counts from multiple posts?

      In assets/snippets/jot/includes/jot.db.class.inc.php in the getUserPostCount function around Line 179 delete AND uparent = "’.$docid.’"

      Before:
      			$sql = 'SELECT count(id) FROM '.$this->tbl["content"].' WHERE createdby = "'.$userid.'" AND uparent = "'.$docid.'" AND tagid = "' . $tagid . '"';

      After:
      			$sql = 'SELECT count(id) FROM '.$this->tbl["content"].' WHERE createdby = "'.$userid.'"  AND tagid = "' . $tagid . '"';
        • 5555
        • 9 Posts
        cnywx Reply #3, 18 years, 10 months ago
        Works well.

        Thanks man.