Horse Site Documentation

! : %21

/ : %2F

: : %3A

‘ : %27

( : %28

) : %29

, : %2C

• Categories are managed in geodesic_classifieds_categories_languages
• Field labels are managed in geodesic_pages_messages_languages
• Mandatory registration data fields in geodesic_registration_configuration
• Modules are managed in geodesic_pages

To modify field or category text through Navicat or another database client:

1. Open the table to return all rows.
2. Use the filter function to show records for the page_id of the page with the fields, and to only show records where the language_id equals 22 (Australian English).
3. Modify the wording in the text memo field as required.

Before the site goes live, the Horse People need to provide the following information.  

• Write terms and conditions. This gets added to: Pages Management > Sections > Registration > Registration Information Collection Page.
• Write registration agreement.This gets added to: geodesic_pages_messages_languages, text_id=316.

The following tasks also need to be completed.

• Replace (non-standard) Cancel Registration button (http://www.chloekirkhope.com/images/buttons/btn_user_cancel_reg.gif) with new image, and similarly the Restart Regstration button (http://www.chloekirkhope.com/images/buttons/btn_user_restart_reg.gif).

The Geodesic MySQL database is made up of over 100 tables. Some tables store auction and classified data (ie, client-entered data), while others store configuration information. To help with the management of the site configuration, the following provides some handy information on where different features are located within the table structure. The database can be maintained through the Web interface provided by the ISP, or through a GUI client such as Navicat.

• geodesic_auctions_feedback_icons
• Contains file names (URLs) for star-shaped icons used in feedback panels
• geodesic_categories
• Contains the category names (eg, miniatures, paints, ponies, warmbloods, etc) and associated descriptions, images and display order.
• geodesic_cc_*
• Tables starting with geodesic_cc relate to credit card processing and payment gateways. There are two tables for each payment gateway: one holds configuration information, and the other holds transaction data.
• geodesic_classifieds
• This is where the classifieds data is stored.
• geodesic_classifieds_categories_languages
• Contains the category information for the different languages used within the site. There are two languages in the Horse Site: US English (1) and Australian English (22).
• geodesic_classifieds_configuration
• Top level configuration information for the Classifieds, including site name, page size, fonts, and URLs.
• geodesic_classifieds_images_urls
• The URLs, file names, dimensions and other details for uploaded images files.
• geodesic_classifieds_transactions
• Details of classified ad transactions, including all price details.
• geodesic_countries
• Stores information about valid countries for the site. Our only valid country is Australia.
• geodesic_file_types
• Allowable file types for images and uploading.
• geodesic_html_allowed
• List of HTML tags allowed in auctions and classifieds.
• geodesic_logins
• User names and unencrypted passwords for users of the site. (See also, geodesic_userdata.)
• geodesic_pages
• Names, descriptions and full details of pages within the system. Examples of pages are Success/Failure Page, Final Approval Page, Registration Email Confirmation, and Fixed Category Navigation 1.
• geodesic_pages_fonts
• Font and display information for elements which appear on pages.
• geodesic_pages_messages
• User interface labels.
• geodesic_pages_messages_languages
• User interface labels for the different valid languages. There are two valid languages in the Site: US English (1) and Australian English (22).
• geodesic_states
• The list of geographical States for the valid countries.
• geodesic_templates
• Contains details of the templates used within the site.
• geodesic_badwords
• List of rude words, and what those words should be replaced with if entered in a classified ad or an auction.
• geodesic_user_communications
• Stores details of messages sent by Site users.
• geodesic_userdata
• Details of all users of the Site. (See also, geodesic_logins.)

(more…)