print_body_top(); print_header($g_page_title); print_spacer(); $f_note_id = gpc_get_int('f_note_id'); $f_page_id = gpc_get_int('f_page_id'); $f_email = gpc_get_string('f_email'); $f_note = gpc_get_string('f_note'); $t_page_info = page_get_info(page_where_id_equals($f_page_id)); if (false === $t_page_info) { echo "page not found"; exit; } $t_note['id'] = '0'; $t_note['email'] = string_prepare_note_for_viewing($f_email); $t_note['date'] = time(); $t_note['note'] = string_prepare_note_for_viewing($f_note); $t_page_data = array(); $t_page_data['id'] = 0; $t_page_data['page'] = page_get_name($f_page_id); $t_page_data['url'] = $t_page_info['url']; $t_page_data['preview'] = true; $t_page_data['prev_page'] = ''; $t_page_data['prev_url'] = ''; $t_page_data['next_page'] = ''; $t_page_data['next_url'] = ''; $t_page_data['notes'] = array($t_note); theme_body($t_page_data); $f_email = string_to_form($f_email); $f_note = string_to_form($f_note); echo <<<EOT \t<div class="spacer"></div>
function note_get_all_visible($p_page_id) { $notes = array(); $t_page_info = page_get_info(page_where_id_equals($p_page_id)); if (false === $t_page_info) { return false; } $c_page_id = db_prepare_int($p_page_id); $query = "SELECT *, UNIX_TIMESTAMP(date_submitted) as date_submitted\r\n\t\t\t\tFROM " . config_get('phpWN_note_table') . "\r\n\t\t\t\tWHERE page_id={$c_page_id}\r\n\t\t\t\tORDER BY date_submitted " . config_get('note_order'); $result = db_query($query); while ($row = db_fetch_array($result)) { extract($row, EXTR_PREFIX_ALL, 'v'); if (NOTE_VISIBLE_PENDING == $v_visible && access_check_action(ACTION_NOTES_VIEW_PENDING) === false) { continue; } if (NOTE_VISIBLE_ACCEPTED == $v_visible && access_check_action(ACTION_NOTES_VIEW_ACCEPTED) === false) { continue; } if (NOTE_VISIBLE_DECLINED == $v_visible && access_check_action(ACTION_NOTES_VIEW_DECLINED) === false) { continue; } if (NOTE_VISIBLE_ARCHIVED == $v_visible && access_check_action(ACTION_NOTES_VIEW_ARCHIVED) === false) { continue; } if (NOTE_VISIBLE_DELETED == $v_visible && access_check_action(ACTION_NOTES_VIEW_DELETED) === false) { continue; } $info['visible'] = $v_visible; $info['id'] = $v_id; $info['email'] = string_prepare_note_for_viewing($v_email, $t_page_info['url']); $info['note'] = string_prepare_note_for_viewing($v_note, $t_page_info['url']); $info['date'] = $v_date_submitted; $notes[] = $info; } return $notes; }