function removeComment($tid, $sid, $ok = 0) { global $ultramode, $prefix, $db, $admin_file; if ($ok) { $tid = intval($tid); $result = $db->sql_query("SELECT date from " . $prefix . "_comments where pid='{$tid}'"); $numresults = $db->sql_numrows($result); $sid = intval($sid); $db->sql_query("update " . $prefix . "_stories set comments=comments-1-'{$numresults}' where sid='{$sid}'"); /* Call recursive delete function to delete the comment and all its childs */ removeSubComments($tid); if ($ultramode) { ultramode(); } Header("Location: modules.php?name=News&file=article&sid={$sid}"); } else { include "header.php"; GraphicAdmin(); OpenTable(); echo "<center><font class=\"title\"><b>" . _REMOVECOMMENTS . "</b></font></center>"; CloseTable(); echo "<br>"; OpenTable(); echo "<center>" . _SURETODELCOMMENTS . ""; echo "<br><br>[ <a href=\"javascript:history.go(-1)\">" . _NO . "</a> | <a href=\"" . $admin_file . ".php?op=RemoveComment&tid={$tid}&sid={$sid}&ok=1\">" . _YES . "</a> ]</center>"; CloseTable(); include "footer.php"; } }
function removeSubComments($tid, $table) { global $prefix, $db; $result = $db->sql_query("SELECT tid FROM " . $prefix . "_{$table} WHERE pid='{$tid}'"); $numrows = $db->sql_numrows($result); if ($numrows > 0) { while (list($ctid) = $db->sql_fetchrow($result)) { $numrows += removeSubComments($ctid, $table); } $db->sql_query("DELETE FROM " . $prefix . "_{$table} WHERE pid='{$tid}'"); } $db->sql_freeresult($result); return $numrows; }