src/ShopArticleReviewBundle/objects/db/TPkgShopArticleReviewShopArticleReview.class.php
public function RateReview($bRateUp = true)
    {
        if (false == $this->ReviewRatedByActiveUser()) {
            $sRateString = 'helpful_count';
            //helpful_count
            //not_helpful_count
            if (false == $bRateUp) {
                $sRateString = 'not_helpful_count';
            }
            $query = 'UPDATE `'.MySqlLegacySupport::getInstance()->real_escape_string($this->table)."`
                     SET `{$sRateString}` = `{$sRateString}`+1
                   WHERE `id` = '".MySqlLegacySupport::getInstance()->real_escape_string($this->id)."'
                   LIMIT 1
                 ";
            MySqlLegacySupport::getInstance()->query($query);
            // get value from disc
            $query = "SELECT `{$sRateString}` FROM `".MySqlLegacySupport::getInstance()->real_escape_string($this->table)."` WHERE `id` = '".MySqlLegacySupport::getInstance()->real_escape_string($this->id)."'";
            if ($aTmp = MySqlLegacySupport::getInstance()->fetch_assoc(MySqlLegacySupport::getInstance()->query($query))) {
                $this->sqlData[$sRateString] = $aTmp[$sRateString];
                if ($bRateUp) {
                    $this->fieldHelpfulCount = $this->sqlData[$sRateString];
                } else {
                    $this->fieldNotHelpfulCount = $this->sqlData[$sRateString];
                }
            }
            if (!array_key_exists('TPkgShopArticleReviewShopArticleReviewRated', $_SESSION)) {
                $_SESSION['TPkgShopArticleReviewShopArticleReviewRated'] = array();
            }
            $_SESSION['TPkgShopArticleReviewShopArticleReviewRated'][(string) $this->id] = time();
        }
    }
public function RateReview($bRateUp = true)
    {
        if (false == $this->ReviewRatedByActiveUser()) {
            $sRateString = 'helpful_count';
            //helpful_count
            //not_helpful_count
            if (false == $bRateUp) {
                $sRateString = 'not_helpful_count';
            }
            $query = 'UPDATE `'.MySqlLegacySupport::getInstance()->real_escape_string($this->table)."`
                     SET `{$sRateString}` = `{$sRateString}`+1
                   WHERE `id` = '".MySqlLegacySupport::getInstance()->real_escape_string($this->id)."'
                   LIMIT 1
                 ";
            MySqlLegacySupport::getInstance()->query($query);
            // get value from disc
            $query = "SELECT `{$sRateString}` FROM `".MySqlLegacySupport::getInstance()->real_escape_string($this->table)."` WHERE `id` = '".MySqlLegacySupport::getInstance()->real_escape_string($this->id)."'";
            if ($aTmp = MySqlLegacySupport::getInstance()->fetch_assoc(MySqlLegacySupport::getInstance()->query($query))) {
                $this->sqlData[$sRateString] = $aTmp[$sRateString];
                if ($bRateUp) {
                    $this->fieldHelpfulCount = $this->sqlData[$sRateString];
                } else {
                    $this->fieldNotHelpfulCount = $this->sqlData[$sRateString];
                }
            }
            if (!array_key_exists('TPkgShopArticleReviewShopArticleReviewRated', $_SESSION)) {
                $_SESSION['TPkgShopArticleReviewShopArticleReviewRated'] = array();
            }
            $_SESSION['TPkgShopArticleReviewShopArticleReviewRated'][(string) $this->id] = time();
        }
    }
public function RateReview ( $ bRateUp = true ) { if ( false == $ this -> ReviewRatedByActiveUser ( ) ) { $ sRateString = 'helpful_count' ; //helpful_count //not_helpful_count if ( false == $ bRateUp ) { $ sRateString = 'not_helpful_count' ; } $ query = 'UPDATE `' . MySqlLegacySupport :: getInstance ( ) -> real_escape_string ( $ this -> table ) . "`
                     SET `{$sRateString}` = `{$sRateString}`+1
                   WHERE `id` = '" . MySqlLegacySupport :: getInstance ( ) -> real_escape_string ( $ this -> id ) . "'
                   LIMIT 1
                 " ; MySqlLegacySupport :: getInstance ( ) -> query ( $ query ) ; // get value from disc $ query = "SELECT `{$sRateString}` FROM `" . MySqlLegacySupport :: getInstance ( ) -> real_escape_string ( $ this -> table ) . "` WHERE `id` = '" . MySqlLegacySupport :: getInstance ( ) -> real_escape_string ( $ this -> id ) . "'" ; if ( $ aTmp = MySqlLegacySupport :: getInstance ( ) -> fetch_assoc ( MySqlLegacySupport :: getInstance ( ) -> query ( $ query ) ) ) { $ this -> sqlData [ $ sRateString ] = $ aTmp [ $ sRateString ] ; if ( $ bRateUp ) { $ this -> fieldHelpfulCount = $ this -> sqlData [ $ sRateString ] ; } else { $ this -> fieldNotHelpfulCount = $ this -> sqlData [ $ sRateString ] ; } } if ( ! array_key_exists ( 'TPkgShopArticleReviewShopArticleReviewRated' , $ _SESSION ) ) { $ _SESSION [ 'TPkgShopArticleReviewShopArticleReviewRated' ] = array ( ) ; } $ _SESSION [ 'TPkgShopArticleReviewShopArticleReviewRated' ] [ ( string ) $ this -> id ] = time ( ) ; } }
vote the review up or down.

@param bool $bRateUp
vote the review up or down .