thorsten /
phpMyFAQ
| @@ 1904-1928 (lines=25) @@ | ||
| 1901 | * |
|
| 1902 | * @return string |
|
| 1903 | */ |
|
| 1904 | public function getVisibilityOfQuestion($questionId) |
|
| 1905 | { |
|
| 1906 | $query = sprintf(" |
|
| 1907 | SELECT |
|
| 1908 | is_visible |
|
| 1909 | FROM |
|
| 1910 | %sfaqquestions |
|
| 1911 | WHERE |
|
| 1912 | id = %d |
|
| 1913 | AND |
|
| 1914 | lang = '%s'", |
|
| 1915 | PMF_Db::getTablePrefix(), |
|
| 1916 | $questionId, |
|
| 1917 | $this->_config->getLanguage()->getLanguage() |
|
| 1918 | ); |
|
| 1919 | ||
| 1920 | $result = $this->_config->getDb()->query($query); |
|
| 1921 | if ($this->_config->getDb()->numRows($result) > 0) { |
|
| 1922 | $row = $this->_config->getDb()->fetchObject($result); |
|
| 1923 | ||
| 1924 | return $row->is_visible; |
|
| 1925 | } |
|
| 1926 | ||
| 1927 | return; |
|
| 1928 | } |
|
| 1929 | ||
| 1930 | /** |
|
| 1931 | * Sets the visibility of a question. |
|
| @@ 120-142 (lines=23) @@ | ||
| 117 | * |
|
| 118 | * @return string |
|
| 119 | */ |
|
| 120 | public function fetch($key, $value) |
|
| 121 | { |
|
| 122 | $select = sprintf(" |
|
| 123 | SELECT |
|
| 124 | %s |
|
| 125 | FROM |
|
| 126 | %sfaquserdata |
|
| 127 | WHERE |
|
| 128 | %s = '%s'", |
|
| 129 | $key, |
|
| 130 | PMF_Db::getTablePrefix(), |
|
| 131 | $key, |
|
| 132 | $this->config->getDb()->escape($value) |
|
| 133 | ); |
|
| 134 | ||
| 135 | $res = $this->config->getDb()->query($select); |
|
| 136 | ||
| 137 | if (0 === $this->config->getDb()->numRows($res)) { |
|
| 138 | return false; |
|
| 139 | } else { |
|
| 140 | return $this->config->getDb()->fetchObject($res)->$key; |
|
| 141 | } |
|
| 142 | } |
|
| 143 | ||
| 144 | /** |
|
| 145 | * Sets the user data given by $field and $value. If $field |
|
