namespace Friendica\Model;
+use Friendica\Database\Database;
use Friendica\Database\DBA;
class Verb
* @return integer verb id
* @throws \Exception
*/
- public static function getID($verb)
+ public static function getID(string $verb)
{
if (empty($verb)) {
return 0;
return $verb_record['id'];
}
- DBA::insert('verb', ['name' => $verb], true);
+ DBA::insert('verb', ['name' => $verb], Database::INSERT_IGNORE);
return DBA::lastInsertId();
}
+
+ /**
+ * Return verb name for the given ID
+ *
+ * @param integer $id
+ * @return string verb
+ */
+ public static function getByID(int $id)
+ {
+ if (empty($id)) {
+ return '';
+ }
+
+ $verb_record = DBA::selectFirst('verb', ['name'], ['id' => $id]);
+ if (!DBA::isResult($verb_record)) {
+ return '';
+ }
+
+ return $verb_record['name'];
+ }
}