/**
*
* @param string $Name
* @return \Dashbird\Model\Entities\User
*/
public function FindByName($Name)
{
$Query = new \Pvik\Database\Generic\Query('Users');
$Query->SetConditions('WHERE Users.Name = "%s"');
$Query->AddParameter($Name);
return $Query->SelectSingle();
}
/**
*
* @param string $Name
* @return \Dashbird\Model\Entities\Plugin
*/
public function FindByNameAndUserId($Name, $UserId)
{
$Query = new \Pvik\Database\Generic\Query('PluginDatas');
$Query->SetConditions('WHERE PluginDatas.Name = "%s" AND PluginDatas.UserId = "%s"');
$Query->AddParameter($Name);
$Query->AddParameter($UserId);
return $Query->SelectSingle();
}
public function DeleteTag($TagTitle)
{
$Query = new \Pvik\Database\Generic\Query('Tags');
$Query->SetConditions('WHERE Tags.Title = "%s"');
$Query->AddParameter($TagTitle);
$Tag = $Query->SelectSingle();
if ($Tag != null) {
foreach ($this->PostsTags as $PostsTags) {
if ($PostsTags->TagId == $Tag->TagId) {
$PostsTags->Delete();
break;
}
}
}
}
