public static function IndeksujGaleriePozycjeDlaArtykulu($artykul_gid)
{
$del_query = "DELETE FROM #S#artykuly_galeriepozycje WHERE artykuly_GID=?";
$del_result = DataBase::GetDbInstance()->ExecuteQueryWithParams($del_query, array((int) $artykul_gid));
$a = Artykuly::PobierzArtykulJezyk($artykul_gid);
if ($a->GetTagi() != '') {
$sub_query = "SELECT GID FROM #S#galeriepozycje WHERE Tagi <> '' AND Tagi LIKE ? AND IdJezyk=1045";
$ins_query = "INSERT INTO #S#artykuly_galeriepozycje (artykuly_GID, galeriepozycje_GID) VALUES(?, ?);";
$tagi = explode(",", $a->GetTagi());
$unique_tags = array();
foreach ($tagi as $tag) {
if (!isset($unique_tags[$tag])) {
$sub_result = DataBase::GetDbInstance()->ExecuteQueryWithParams($sub_query, array('%' . $tag . '%'));
while ($sub_row = DataBase::GetDbInstance()->FetchArray($sub_result)) {
$ins_result = DataBase::GetDbInstance()->ExecuteQueryWithParams($ins_query, array($a->GetGID(), $sub_row['GID']));
}
$unique_tags[$tag] = true;
}
}
}
}
