function get_wall_noptifytype_ids() { $sql = "SELECT `notifytype_id` FROM `se_notifytypes` " . "WHERE `notifytype_name` IN ('wallpost', 'wallactioncomment', 'wallactionlike')"; return he_database::fetch_column($sql); }
function delete_user_info($user_id) { //get user quizzes $query = he_database::placeholder("SELECT `id` FROM `se_he_quiz`\r\n WHERE `user_id`=?", $user_id); $quiz_ids = he_database::fetch_column($query); foreach ($quiz_ids as $quiz_id) { he_quiz::delete_quiz($quiz_id); } //delete user plays $query = he_database::placeholder("DELETE FROM `se_he_quiz_play`\r\n WHERE `user_id`=?", $user_id); he_database::query($query); }