PRD Tables

From Rhypedigital

Jump to: navigation, search

[edit] Database Tables

client

This is currently a stub, intended for future extensions to support multiple and separately billabe clients.

host

Entries in the host table correspond to websites (so multiple entries can refer to the same physical machine and the table is misnamed). The table contains:

  • ho_name: Arbitrary indentifying name, typically like www.sitename.com
  • ho_host: IP or host name to which content is uploaded
  • ho_username: Login user name for uploads
  • ho_password: Login password for uploads
  • ho_style: Name of theme used on the site
  • ho_hash: Internal use
  • ho_dirty: Internal use
  • ho_path: Path to content directory
  • ho_protocol: Upload protocol, currently only FTP supported
  • ho_urltype: Not used

article

Skeleton text to be published on the sites is stored in this table. Within the text, random selection can be achieved using notation like [I|We|They]; when the text to be uploaded is generated, one value will be chosen at random. This allows multiple variants of the same article text to be generated, for instance [I|We|My mate] found a [fantastic|great|really cool] site with [lots|loads] of information about [computers|PCs]personal computers]. [Check it out|Give it a look]! which can generate 36 different versions.

  • ar_name: Arbitrary article name
  • ar_title: Title text
  • ar_summary: Summary text
  • ar_body: Body text
  • ar_seo: Search engine optimisation text
  • ar_keywords: Page keywords
  • ar_description: Page description
  • ar_clientid: Associated client
  • ar_dirty: Internal use

The ar_title, ar_summary, ar_body, ar_seo, ar_keywords and ar_description values are subject the the random substitutions.

publish

Articles will appear on sites when they are published via an entry in this table.

  • pu_hostid: Host to which article is published
  • pu_articleid: Article to publish
  • pu_from: Date from which article should appear on site
  • pu_until: Date from which article should disappear from site
  • pu_title: Generated title on site
  • pu_summary: Generated summary on site
  • pu_body: Generated body on site
  • pu_seo: Generated search engine optimisation string on site
  • pu_keywords: Generated keywords on site
  • pu_description: Generated description on site

A single article may be published on multiple sites, ie., there may be multiple publish records referring to the same article. The article is randomly substituted when first uploaded, then remains fixes for the period when it appears on the site. Articles on each site are ordered by the pu_from date in descending (latest first) order.

When uploaded, the various text components are substituted into the site themes.

Retrieved from "http://www.shop2buy.net/index.php/PRD_Tables"
Personal tools