function printLanguagePart($sqllanguageRes, $artID)
{
$articleTranslationDB = new ArticleTranslationDB();
echo "<tr>";
echo "<td >Translations: </td>";
echo "</tr>";
while ($language = $sqllanguageRes->fetch_object()) {
$translatedName = '';
$translatedDescription = '';
$sqlTransRes = $articleTranslationDB->getArticletranslation($artID, $language->Language_ID);
while ($trans = $sqlTransRes->fetch_object()) {
$translatedName = $trans->TranslatedName;
$translatedDescription = $trans->TranslatedDescription;
}
echo "<tr></tr>";
echo "<tr>";
echo "<td >{$language->EnglishName}: </td>";
echo "</tr>";
echo "<tr>";
echo "<td >Translated Name: </td>";
echo "<td>";
echo "<input class=\"changeArticleForm-title\" type=\"text\" name=\"" . $language->Language_ID . "translatedName\" maxlength=\"45\" value=\"{$translatedName}\" /input>";
echo "</td>";
echo "</tr>";
echo "<tr>";
echo "<td >Translated Description: </td>";
echo "<td>";
echo "<textarea class=\"changeArticleForm-description\" type=\"text\" name=\"" . $language->Language_ID . "translatedDescription\" >{$translatedDescription}</textarea>";
echo "</td>";
echo "</tr>";
}
}
function deleteArticle($artID)
{
require_once ROOT . "DBInterface/articleTranslationDB.php";
require_once ROOT . "DBInterface/categoryArticleDB.php";
require_once ROOT . "DBInterface/variantDB.php";
require_once ROOT . "DBInterface/variantTranslationDB.php";
$articleDB = new ArticleDB();
$articleTranslationDB = new ArticleTranslationDB();
$categoryArticleDB = new CategoryArticleDB();
$variantDB = new VariantDB();
$variantTranslationDB = new VariantTranslationDB();
$articleDB->deleteArticle($artID);
$articleTranslationDB->deleteAllTranslationsByArticle($artID);
$categoryArticleDB->deleteAllCategorysByArticle($artID);
$sqlVariantRes = $variantDB->getAllVariantIDsByArticle($artID);
while ($variant = $sqlVariantRes->fetch_object()) {
$variantTranslationDB->deleteAllVariantsByArticle($variant->Variation_ID);
}
$variantDB->deleteAllVariantsByArticle($artID);
}
