gctools-outilsgc / gcconnex

		// get names wheres

		$names_where = '';

		if ($names !== null) {

			if (!is_array($names)) {

				$names = array($names);

			}

			$sanitised_names = array();

			foreach ($names as $name) {

				$name = $name_prefix . $name;

				$sanitised_names[] = '\'' . $this->db->sanitizeString($name) . '\'';

			}

			$names_str = implode(',', $sanitised_names);

			if ($names_str) {

				$names_where = "(ps.name IN ($names_str))";

			}

		}

		// get values wheres

		$values_where = '';

		// get values wheres

		$values_where = '';

		if ($values !== null) {

			if (!is_array($values)) {

				$values = array($values);

			}

			$sanitised_values = array();

			foreach ($values as $value) {

				// normalize to 0

				if (!$value) {

					$value = 0;

				}

				$sanitised_values[] = '\'' . $this->db->sanitizeString($value) . '\'';

			}

			$values_str = implode(',', $sanitised_values);

			if ($values_str) {

				$values_where = "(ps.value IN ($values_str))";

			}

		}

		if ($names_where && $values_where) {

			$wheres[] = "($names_where AND $values_where)";