Quotations Manual
The database is broken down into four sections: Additions and Changes, Scheduling, Maintenance, and User Administration.
Database Additions and Changes
DATABASE ADDITIONS AND CHANGES
DATABASE ADDITIONS AND CHANGES – Work with Quotations
Add Quotations – This is the page that adds new quotations to the database.
It asks for the Category, the quotation, the Author, and the Source of the quotation.
Note that the list of Categories is pulled from the database.
This list can be modified in the "Work with Categories" section.
Edit/Delete Quotations - Clicking on this link will bring you to a page listing all of the authors in the database.
Click on the name of the author of the quote you want to edit.
This brings up a page listing a snippet of all of the quotations in the database from that author.
Next to each quotation is an icon indicting if the quote is 'active", a link to edit the quote and a link to delete the quote:
The 'Active" icon was added to allow quotes to stay in the database, but not be shown on the Web site.
This was added with the idea of adding a form that allows Web site visitors to add their own quotation to the database,
but not have it visible until it was approved. Note that all quotations added from the administration page are automatically 'Active".
The "Edit" link brings up a page that allows you to change the quotation information, as well as changing the 'Active' status.
The "Delete" link will bring up a confirmation page that asks if you"re sure you want to delete the quotation.
There is a button to confirm the deletion, and a link to cancel the deletion.
DATABASE ADDITIONS AND CHANGES – Work with Authors
Add Authors – This link adds new authors to the database.
The form includes name, profession, country, year of birth and death.
Edit/Delete Authors - Clicking on this link will bring you to a page listing all of the authors in the database.
Next to the authors name is a link to 'edit" and a link to 'delete" this author.
The "Edit" link allows you to change information for this author.
The "Delete" link will bring up a confirmation page that asks if you"re sure you want to delete the author.
There is a button to confirm the deletion, and a link to cancel the deletion.
DATABASE ADDITIONS AND CHANGES – Work with Categories
Add Categories – This link adds new categories to the database. The form just asks for the category name.
Edit/Delete Categories- Clicking on this link will bring you to a page listing all of the categories in the database.
Next to the category name is a link to 'edit" and a link to 'delete" this category.
The "Edit" link allows you to change the name information for this category.
The "Delete" link will bring up a confirmation page that asks if you"re sure you want to delete the category.
There is a button to confirm the deletion, and a link to cancel the deletion.
SCHEDULING – Schedule Quotations
Daily Quote - Clicking on this link will bring you to a page listing all of the authors in the database.
Click on the name of the author of the quote you want to schedule. This brings up a page listing a snippet of all of the quotations in the database from that author.
Next to the quotation is a drop down box listing dates for the next two weeks. Select the date you"d like to schedule the quotation for and click the submit button.
Notes:
If you schedule two quotations for the same day, the newly scheduled quotation will replace the previous quotation for that date.
If there is no quotation scheduled for a particular date, a 'default' quote will show up on the Quote of the Day Web site page.
Quote Schedule – This link brings up a page with the current schedule of quotations.
There is a link next to each quotation that allows you to replace the quotation for that day.
SCHEDULING – Schedule Themes
Weekly Theme – This link brings up a page with a text box to enter the name of a theme, and a drop down box that lets you select which week to schedule the theme for.
Note: the drop down box contains selections for the next six weeks. Weeks begin on a Monday.
Theme Schedule – This link brings up a page listing the upcoming theme schedule.
Under the theme for each week are links to edit the theme, or delete the theme for that particular week.
Delete from Quotation Schedule- Removes the quotation schedule from the database where the schedule is older than 90 days.
A confirmation page will let you know how many records will be removed from the database.
Delete from Theme Schedule- Removes the theme schedule from the database where the schedule is older than 90 days.
A confirmation page will let you know how many records will be removed from the database.
Both of these links are provided to help keep the size of the database down. Using these links every month or so should be sufficient.
USER ADMINISTRATION - Work with Users
Add Users Adds new users to the administration database.
Edit/Delete Users - This link brings up a list of all administrative users in the database.
Next to each user is a link to edit there name and password, and a link to delete that user.