IndexNo |
int(11) |
auto_increment primary Key |
Header |
varchar(64) |
Short title for event or webpage |
ARC |
char(1) |
Set to 'Y' to include entry on Animal Rights Calendar, else leave blank. |
VEG |
char(1) |
- 'Y' to include entry on Sumac Diary
- 'V' to include on diary of Veggies Events, as well as Sumac Diary.
- 'F' to indicate 'Food by Veggies' on diary of Veggies Events, as well as Sumac Diary.
- 'X' Not for inclusion on diary system. Omits date from non-diary webpages.
Perhaps should be renamed 'SumacVeggies'. |
Vegan |
char(1) |
Set to 'Y' to include entry on Vegan Outreach Diary, else leave blank. |
PageIndex |
char(1) |
Set to 'Y' to include entry on Index of Supplimentary Webpages, else leave blank. |
DateTime |
datetime |
Date and Time event starts.
Format is '0000-00-00 00:00:00' |
EndTime |
Time |
Time event ends, if on same day. May be left blank.
- Possibly combine with EndDate variable. |
EndDate |
datetime |
Date event ends, if continuous for more than one day.
eg Laboratory Animals Month, Veggie-pledge month, etc |
Repeat |
char(1) |
(D)aily, (W)eekly, (F)ortnightly, (M)onthly, (A)nnual, (V)aries
- Input with a radio button
- If set to D, W or F the date is automatically rolled forward.
- D, W, F, M and V forces a single line entry on full calendar/diary listings (subject to 'ShortListing', below).
- (A)nnual dates are shown in full, and rolled forward automatically, if on 'same date each year'. |
RepeatDetail |
char(50) |
Description of event repetion pattern.
- Daily events
... single line listing on full calendar/diary
... program adds 7days to DateTime.
- Weekly events
- assumed to be same day and time each week
... single line listing on full calendar/diary
... program adds 7days to DateTime.
- Monthly:
... single line listing on full calendar/diary
- 'Same date each month'
... program adds 1 month to DateTime, where RepeatDetail contains the phrase "Same date each month".
- 'First, 2nd, 3rd, 4th or last xxxday of month'
... programming needed to add 28days to DateTime, adjusted for 5-week months. Meanwhile editor updates manually.
- Annual:
... Full listing on full calendar/diary
- 'Same date each year'
... program adds 1year to DateTime
- 'Same month each year'
... program adds 1year to DateTime and to EndDate
- otherwise describe pattern. eg 1st Sat in Nov; nearest Sunday to 1st Nov; Easter bank holiday. Editor updates manually.
- Events repeated at (V)arious intervals have single line listing on full calendar/diary - editor updates manually.
Where possible standard repeat patterns are selected from a menu for program to select action to be taken to roll event forward.
|
ShortListing |
char(1) |
Set to 'Y' or 'N' to overrule single line settings (above), else leave blank.
See coding of arc.php for other ShortListing options. |
EventIntro |
text |
One paragraph describing the campaign & event. Editor reserves option to include more (or less). If field contains the phrase 'to be confirmed', this will be stated on the title of EventPage, and will force a full Diary/Calendar listing to show a single line: 'Header - to be confirmed' |
EventDetails |
text |
One paragraph with meeting time, place and similar details. |
MapLink |
varchar(128) |
Link created for any url beginning 'http', submitted by user (eg for GoogleMap, MultiMap, Streetmap link etc).
If set to 'Sumac', Sumac map link inserted automatically.
Program otherwise attempts to create a GoogleMap link from a postcode (with no blank space) submitted by user.
|
FullDetails |
text |
Extensive and further details, to create EventView page linked from Event Heading and Image on main listing.
- contains only link to specific external event website if stated.
- may include html code, graphics, links etc
- may serve as Event Website for groups without their own website.
|
ImageLink |
varchar(128) |
Address for graphic.
When clicked links to EventView page.
On EventView page links to group website or else to display graphic full size at original location.
Default location for images is /img/arc directory, using pathname /img/arc/imagename.ext |
ImageWidth |
int(3) |
Set by editors to original size of graphic, or otherwise as appropriate. (Suggest default width=150; banners max width=500, but see below). Firefox and Internet Explorer resize the height by same proportion and the width - is this the case with other browsers? |
ImagePosition |
chr(1) |
(B)anner, (L)eft, (R)ight
Set by editors to improve visual layout of listings, subject to size and format of graphic. Default position (L)eft.(B)anners are now resized to 90% of width of table column, which works well with Firefox, but is a mess with Windows |
ContactGroup |
varchar(60) |
GroupName
May be linked to ACD when available. |
ContactAddress |
varchar(128) |
Group Address
May be drawn from ACD when available.
Auto-completed if left blank and group name is 'Veggies' or 'Sumac' |
ContactPhone |
varchar(128) |
Phone / Mobile / Fax
May be drawn from ACD when available.
Auto-completed if left blank and group name is 'Veggies' or 'Sumac' |
ContactEmail |
varchar(128) |
Email of the organising group for publication on Calendar Listing.
Auto-completed if left blank and group name is 'Veggies' or 'Sumac' |
WebLink |
varchar(128) |
External website for the organising group's homepage (or other submitted url).
Auto-completed if left blank and group name is 'Veggies' or 'Sumac' |
UserEmail |
varchar(128) |
Email of user submitting entry, if different.
Not for publication on Calendar listings.
Confirmation message would be sent to both addresses.
|
Review |
text |
Reviews, reports and references added for archive purposes after the event. May include links to external sources. Not currently used in any programming. |
NewDate |
datetime |
Datestamp indicating when event was added to calendar. Entered automatically for entirely new entries on table. (Sometime a new event is created by editing or cloning an old event by same group, in which case date need editing manually). |
Amendate |
datetime |
Date entered manually indicating last time any substancial details have been updated.
User would be advised to put amended info within < b > and < i > tags in event info fields. |
Reference |
text |
Source of event info, editing history. Not for publication on Calendar listings.
To exclude entry from search engines and other robots include 'noindex' in Reference field |
