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. |
|
| @@ 2258-2276 (lines=19) @@ | ||
| 2255 | * |
|
| 2256 | * @author Thorsten Rinne <[email protected]> |
|
| 2257 | */ |
|
| 2258 | public function getNumberOfVotings($record_id) |
|
| 2259 | { |
|
| 2260 | $query = sprintf( |
|
| 2261 | 'SELECT |
|
| 2262 | usr |
|
| 2263 | FROM |
|
| 2264 | %sfaqvoting |
|
| 2265 | WHERE |
|
| 2266 | artikel = %d', |
|
| 2267 | PMF_Db::getTablePrefix(), |
|
| 2268 | $record_id); |
|
| 2269 | if ($result = $this->_config->getDb()->query($query)) { |
|
| 2270 | if ($row = $this->_config->getDb()->fetchObject($result)) { |
|
| 2271 | return $row->usr; |
|
| 2272 | } |
|
| 2273 | } |
|
| 2274 | ||
| 2275 | return 0; |
|
| 2276 | } |
|
| 2277 | ||
| 2278 | /** |
|
| 2279 | * Adds a new voting record. |
|
