public static function OnContextBoxDelete($contextBoxId) { global $g_ado_db; $contextBoxId = (int) $contextBoxId; if ($contextBoxId < 1) { return; } $queryStr = 'DELETE FROM context_articles' . " WHERE fk_context_id = '{$contextBoxId}'"; $g_ado_db->Execute($queryStr); }
/** * Remove the context box for the given article. * @param int $articleNumber * @return void */ public static function OnArticleDelete($articleNumber) { global $g_ado_db; $articleNumber = (int) $articleNumber; if ($articleNumber < 1) { return; } $queryStr = 'SELECT * FROM context_boxes' . " WHERE fk_article_no = '{$articleNumber}'"; $boxes = $g_ado_db->GetAll($queryStr); foreach ($boxes as $box) { ContextBoxArticle::OnContextBoxDelete($box['id']); } $queryStr = 'DELETE FROM context_boxes' . " WHERE fk_article_no = '{$articleNumber}'"; $g_ado_db->Execute($queryStr); }