public function augmentSQL(SQLQuery &$query) {

		$base = ClassInfo::baseDataClass($this->owner);

		$simple = DB::getConn() instanceof SQLite3Database ? true : false;

		if ($simple) {
			$bound = "(($base.Up / $base.Down) / ($base.Up + $base.Down))";
		} else {
			$bound = "(($base.Up + 1.9208) / ($base.Up + $base.Down) - " .
                   "1.96 * SQRT(($base.Up * $base.Down) / ($base.Up + $base.Down) + 0.9604) / " .
                   "($base.Up + $base.Down)) / (1 + 3.8416 / ($base.Up + $base.Down))  / SQRT(HOUR(TIMEDIFF(NOW(), $base.Created)) + 1)";
		}

		$query->selectField($bound, 'WilsonRating');

		$query->selectField("($base.Up + $base.Down)", 'ActiveRating');

		$query->selectField("($base.Up - $base.Down)", "PositiveRating");

	}
public function augmentSQL(SQLQuery &$query) {

		$base = ClassInfo::baseDataClass($this->owner);

		$simple = DB::getConn() instanceof SQLite3Database ? true : false;

		if ($simple) {
			$bound = "(($base.Up / $base.Down) / ($base.Up + $base.Down))";
		} else {
			$bound = "(($base.Up + 1.9208) / ($base.Up + $base.Down) - " .
                   "1.96 * SQRT(($base.Up * $base.Down) / ($base.Up + $base.Down) + 0.9604) / " .
                   "($base.Up + $base.Down)) / (1 + 3.8416 / ($base.Up + $base.Down))  / SQRT(HOUR(TIMEDIFF(NOW(), $base.Created)) + 1)";
		}

		$query->selectField($bound, 'WilsonRating');

		$query->selectField("($base.Up + $base.Down)", 'ActiveRating');

		$query->selectField("($base.Up - $base.Down)", "PositiveRating");

	}
public function augmentSQL ( SQLQuery & $ query ) { $ base = ClassInfo :: baseDataClass ( $ this -> owner ) ; $ simple = DB :: getConn ( ) instanceof SQLite3Database ? true : false ; if ( $ simple ) { $ bound = "(($base.Up / $base.Down) / ($base.Up + $base.Down))" ; } else { $ bound = "(($base.Up + 1.9208) / ($base.Up + $base.Down) - " . "1.96 * SQRT(($base.Up * $base.Down) / ($base.Up + $base.Down) + 0.9604) / " . "($base.Up + $base.Down)) / (1 + 3.8416 / ($base.Up + $base.Down))  / SQRT(HOUR(TIMEDIFF(NOW(), $base.Created)) + 1)" ; } $ query -> selectField ( $ bound , 'WilsonRating' ) ; $ query -> selectField ( "($base.Up + $base.Down)" , 'ActiveRating' ) ; $ query -> selectField ( "($base.Up - $base.Down)" , "PositiveRating" ) ; }
Add in rating information

@param SQLQuery $query
@param DataQuery $dataQuery
Add in rating information