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. |
|
| @@ 2282-2300 (lines=19) @@ | ||
| 2279 | * |
|
| 2280 | * @return integer |
|
| 2281 | */ |
|
| 2282 | public function getNumberOfVotings($record_id) |
|
| 2283 | { |
|
| 2284 | $query = sprintf( |
|
| 2285 | 'SELECT |
|
| 2286 | usr |
|
| 2287 | FROM |
|
| 2288 | %sfaqvoting |
|
| 2289 | WHERE |
|
| 2290 | artikel = %d', |
|
| 2291 | PMF_Db::getTablePrefix(), |
|
| 2292 | $record_id); |
|
| 2293 | if ($result = $this->_config->getDb()->query($query)) { |
|
| 2294 | if ($row = $this->_config->getDb()->fetchObject($result)) { |
|
| 2295 | return $row->usr; |
|
| 2296 | } |
|
| 2297 | } |
|
| 2298 | ||
| 2299 | return 0; |
|
| 2300 | } |
|
| 2301 | ||
| 2302 | /** |
|
| 2303 | * Adds a new voting record. |
|
