function admin_purge_related($table, $id) { $ns = e107::getRender(); $tp = e107::getParser(); $msg = ""; $tp->parseTemplate(""); // Delete any related comments require_once e_HANDLER . "comment_class.php"; $_com = new comment(); $num = $_com->delete_comments($table, $id); if ($num) { $msg .= $num . " " . LAN_COMMENTS . " " . LAN_DELETED . "<br />"; } // Delete any related ratings require_once e_HANDLER . "rate_class.php"; $_rate = new rater(); $num = $_rate->delete_ratings($table, $id); if ($num) { $msg .= LAN_RATING . " " . LAN_DELETED . "<br />"; } if ($msg) { $ns->tablerender(LAN_DELETE, $msg); } }
function purgeRatings($table) { global $sql, $tp; // Delete any related ratings require_once e_HANDLER . "rate_class.php"; $_rate = new rater(); $q = "SELECT DISTINCT " . MPREFIX . "rate.rate_itemid" . " FROM " . MPREFIX . "rate " . " WHERE (rate_table='{$table}')"; $text .= $q . '<br>'; $result = $sql->db_Query($q); $num_rows = mysql_numrows($result); for ($i = 0; $i < $num_rows; $i++) { $id = mysql_result($result, $i, "rate_itemid"); $text .= "rate id: {$id}<br>"; $num = $_rate->delete_ratings($table, $id); } }