thorsten /
phpMyFAQ
| @@ 455-476 (lines=22) @@ | ||
| 452 | * |
|
| 453 | * @return string |
|
| 454 | */ |
|
| 455 | public function getTagNameById($tagId) |
|
| 456 | { |
|
| 457 | if (!is_numeric($tagId)) { |
|
| 458 | return; |
|
| 459 | } |
|
| 460 | ||
| 461 | $query = sprintf(' |
|
| 462 | SELECT |
|
| 463 | tagging_name |
|
| 464 | FROM |
|
| 465 | %sfaqtags |
|
| 466 | WHERE |
|
| 467 | tagging_id = %d', |
|
| 468 | PMF_Db::getTablePrefix(), |
|
| 469 | $tagId |
|
| 470 | ); |
|
| 471 | ||
| 472 | $result = $this->_config->getDb()->query($query); |
|
| 473 | if ($row = $this->_config->getDb()->fetchObject($result)) { |
|
| 474 | return $row->tagging_name; |
|
| 475 | } |
|
| 476 | } |
|
| 477 | ||
| 478 | /** |
|
| 479 | * Returns the HTML for the Tags Cloud. |
|
| @@ 2177-2195 (lines=19) @@ | ||
| 2174 | * |
|
| 2175 | * @author Thorsten Rinne <[email protected]> |
|
| 2176 | */ |
|
| 2177 | public function getNumberOfVotings($record_id) |
|
| 2178 | { |
|
| 2179 | $query = sprintf( |
|
| 2180 | 'SELECT |
|
| 2181 | usr |
|
| 2182 | FROM |
|
| 2183 | %sfaqvoting |
|
| 2184 | WHERE |
|
| 2185 | artikel = %d', |
|
| 2186 | PMF_Db::getTablePrefix(), |
|
| 2187 | $record_id); |
|
| 2188 | if ($result = $this->_config->getDb()->query($query)) { |
|
| 2189 | if ($row = $this->_config->getDb()->fetchObject($result)) { |
|
| 2190 | return $row->usr; |
|
| 2191 | } |
|
| 2192 | } |
|
| 2193 | ||
| 2194 | return 0; |
|
| 2195 | } |
|
| 2196 | ||
| 2197 | /** |
|
| 2198 | * Adds a new voting record. |
|
