XoopsModules25x / xoopsinfo

	function getCount($criteria = null, $notNullFields='') {

		$sql = 'SELECT COUNT(*) FROM '.$this->db->prefix('mimetypes');

		if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) {

			$whereClause = $criteria->renderWhere();

			if ($whereClause != 'WHERE ()') {

				$sql .= ' '.$criteria->renderWhere();

			}

		}

		$result = $this->db->query($sql);

		if (!$result) {

			return 0;

		$this->db->prefix("mimetypes") . ' t on p.mperm_mime = t.mime_id LEFT JOIN ' .

		$this->db->prefix("modules") . ' m on p.mperm_module = m.mid';

		if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) {

			$whereClause = $criteria->renderWhere();

			if ($whereClause != 'WHERE ()') {

				$sql .= ' '.$criteria->renderWhere();

			}

		}

		$result = $this->db->query($sql);