/*
* Author : numplumz
* Generated on : 22-Nov-2009 19:18:30
* Version : 3.0
*/
application "Numplumz Race Calendar"
{
type = public
date format = "dd-MMM-yyyy"
time zone = "Europe/London"
section All_Events
{
displayname = "All Events"
list Full_Cal2
{
displayname = "Full Calendar"
show all rows from Events [Verify1 == 95]
(
Date_field as "Date"
Event_Name as "Event Name"
Event_Type as "Type"
Venue
Weblink
Org as "Organiser"
Details
)
filters
(
Date_field
Event_Type
)
sort by
(
Date_field ascending
)
options
(
display rows = 30
)
}
calendar Monthly_View
{
displayname = "Monthly View"
show all rows from Events [Verify1 == 95]
(
Date_field as "Date"
Event_Name as "Event Name"
Event_Type as "Event Type"
New_Venue as "Venue"
Venue as "Venue2"
Weblink
Details
)
sort by
(
Date_field ascending
)
options
(
show calendar based on Date_field
)
}
}
section Events
{
list XC1
{
displayname = "XC"
show all rows from Events [(Event_Type.contains("XC") && Verify1 == 95)]
(
Date_field as "Date"
To
Event_Name as "Name"
Details
Weblink
Venue
New_Venue as "---"
Org as "Organiser"
)
sort by
(
Date_field ascending
)
options
(
display rows = 100
)
}
list Copy_of_Full_Calendar2
{
displayname = "Enduros"
show all rows from Events [(Event_Type.contains("Enduro") && Verify1 == 95)]
(
Date_field as "Date"
To
Event_Name as "Name"
Details
Weblink
Venue
New_Venue as "---"
Org as "Organiser"
)
sort by
(
Date_field ascending
)
options
(
display rows = 50
)
}
list Trailquests
{
show all rows from Events [(Event_Type == "Trailquest" && Verify1 == 95)]
(
Date_field as "Date"
To
Event_Name as "Name"
Details
Weblink
Venue
New_Venue as "---"
Org as "Organiser"
)
sort by
(
Date_field ascending
)
options
(
display rows = 50
)
}
list Cyclo_X
{
displayname = "Cyclo-X"
show all rows from Events [(Event_Type.startsWith("Cyclo") && Verify1 == 95)]
(
Date_field as "Date"
To
Event_Name as "Name"
Details
Weblink
Venue
New_Venue as "---"
Org as "Organiser"
)
sort by
(
Date_field ascending
)
options
(
display rows = 50
)
}
list Hour_events1
{
displayname = "24 Hour events"
show all rows from Events [((Event_Type.contains("Enduro") && Verify1 == 95) && Event_Name.contains("24"))]
(
Date_field as "Date"
To
Event_Name as "Name"
Details
Weblink
Venue
New_Venue as "---"
Org as "Organiser"
)
sort by
(
Date_field ascending
)
options
(
display rows = 50
)
}
list Hour_events
{
displayname = "12 Hour events"
show all rows from Events [((Event_Type.contains("Enduro") && Verify1 == 95) && Event_Name.contains("12"))]
(
Date_field as "Date"
To
Event_Name as "Name"
Details
Weblink
Venue
New_Venue as "---"
Org as "Organiser"
)
sort by
(
Date_field ascending
)
options
(
display rows = 50
)
}
list The_Tens
{
displayname = "The Tens"
show all rows from Events [((Event_Type.contains("Enduro") && Verify1 == 95) && Event_Name.startsWith("10"))]
(
Date_field as "Date"
To
Event_Name as "Name"
Details
Weblink
Venue
New_Venue as "---"
Org as "Organiser"
)
sort by
(
Date_field ascending
)
options
(
display rows = 50
)
}
}
section Series_Dates
{
displayname = "Series Dates"
list British_MTB_Series
{
displayname = "British MTB Series"
show all rows from Events [((Event_Name.startsWith("British") && Verify1 == 95) && Event_Type == "XC")]
(
Date_field as "Date"
To
Event_Name as "Name"
Details
Weblink
Venue
New_Venue as "---"
Org as "Organiser"
)
sort by
(
Date_field ascending
)
options
(
display rows = 20
)
}
list Scottish_XC
{
displayname = "Scottish XC"
show all rows from Events [(Event_Name.startsWith("Scottish") && Verify1 == 95)]
(
Date_field as "Date"
To
Event_Name as "Name"
Details
Weblink
Venue
New_Venue as "---"
Org as "Organiser"
)
sort by
(
Date_field ascending
)
options
(
display rows = 20
)
}
list Welsh_XC
{
displayname = "Welsh XC"
show all rows from Events [((Verify1 == 95 && Event_Name.startsWith("Dragon")) && Event_Type == "XC")]
(
Date_field as "Date"
To
Event_Name as "Name"
Details
Weblink
Venue
New_Venue as "---"
Org as "Organiser"
)
sort by
(
Date_field ascending
)
options
(
display rows = 20
)
}
list Southern_XC
{
displayname = "Southern XC"
show all rows from Events [((Event_Name.contains("South") && Verify1 == 95) && Event_Type == "XC")]
(
Date_field as "Date"
To
Event_Name as "Name"
Details
Weblink
Venue
New_Venue as "---"
Org as "Organiser"
)
sort by
(
Date_field ascending
)
options
(
display rows = 20
)
}
list Midlands_XC
{
displayname = "Midlands XC"
show all rows from Events [((Verify1 == 95 && Event_Type == "XC") && Event_Name.startsWith("Midlands"))]
(
Date_field as "Date"
To
Event_Name as "Name"
Details
Weblink
Venue
New_Venue as "---"
Org as "Organiser"
)
sort by
(
Date_field ascending
)
options
(
display rows = 20
)
}
list Thetford_Series
{
displayname = "Thetford Series"
show all rows from Events [(Event_Name.startsWith("Thetford") && Verify1 == 95)]
(
Date_field as "Date"
To
Event_Name as "Name"
Details
Weblink
Venue
New_Venue as "---"
Org as "Organiser"
)
sort by
(
Date_field ascending
)
}
list XC
{
displayname = "Soggy Bottom"
show all rows from Events [(Event_Name.startsWith("Soggy") && Verify1 == 95)]
(
Date_field as "Date"
To
Event_Name as "Name"
Details
Weblink
Venue
New_Venue as "---"
Org as "Organiser"
)
sort by
(
Date_field ascending
)
options
(
display rows = 20
)
}
list Eastern_XC
{
displayname = "Eastern XC"
show all rows from Events [((Verify1 == 95 && Event_Type == "XC") && Event_Name.startsWith("Eastern"))]
(
Date_field as "Date"
To
Event_Name as "Name"
Details
Weblink
Venue
New_Venue as "---"
Org as "Organiser"
)
sort by
(
Date_field ascending
)
options
(
display rows = 20
)
}
list Gorrick_Races
{
displayname = "Gorrick Races"
show all rows from Events [(Org == "Gorrick" && Verify1 == 95)]
(
Date_field as "Date"
To
Event_Name as "Name"
Details
Weblink
Venue
New_Venue as "---"
Org as "Organiser"
)
sort by
(
Date_field ascending
)
options
(
display rows = 20
)
}
list FNSS
{
show all rows from Events [(Org == "FNSS" && Verify1 == 95)]
(
Date_field as "Date"
To
Event_Name as "Name"
Details
Weblink
Venue
New_Venue as "---"
Org as "Organiser"
)
sort by
(
Date_field ascending
)
options
(
display rows = 20
)
}
}
section Admin_Only
{
displayname = "Admin Only"
hide = true
list Contact_Us_View
{
displayname = "Contact Us View"
show all rows from Contact_Us
(
ID
Added_User as "Added User"
Added_Time as "Added Time"
Modified_User as "Last Modified User"
Modified_Time as "Last Modified Time"
Your_Email_Address as "Your Email Address"
Feedback_Category as "Feedback Category"
Comments
info_contact as "info contact"
)
options
(
display rows = 100
)
}
list Admin_Full_Calendar
{
displayname = "Admin Full Calendar"
show all rows from Events
(
Date_field as "Date"
To
Event_Name as "Event Name"
Event_Type as "Type"
Venue
New_Venue as "-----"
Weblink
Org as "Organiser"
Details
Added_Time as "Added"
)
sort by
(
Date_field ascending
)
options
(
display rows = 100
)
}
list Last_added_Venues
{
displayname = "Last added Venues"
show all rows from Venues
(
Venue
Terrain_Details as "Terrain Details"
Map_web_link as "Map web link"
Postcode
Directions
Added_Time as "Added Time"
)
sort by
(
Added_Time descending
)
}
form Add_Web_Sites
{
displayname = "Add Web Sites"
column
{
plain
(
type = plaintext
value = "Admin Use Only\n"
)
must have Title
(
type = text
tooltip = "Make it snappy yet descriptive"
)
must have Group_Title
(
displayname = "Group Title"
type = list
values = {"Add new", "GPS and Route stores", "Clubs MTB and Road", "Training and Energy Drinks", "Games", "Lights", "Forums on cycle sites", "Press and Info", "Holidays", "Ride areas", "Accomodation -cycle areas", "BikeShops on the Web", "Manufacturers", "Podcasters - cycle", "Photos and Video", "Maintenance info", "Sportives"}
sortorder = ascending
)
must have Url_1
(
displayname = "Web Address"
type = url
enable linkname, target
)
Quick_Details
(
displayname = "Extra Details"
type = textarea
tooltip = "brief details of what this is about."
)
}
column
{
Link_Checked
(
displayname = "Link Checked"
type = checkbox
private = true
defaultvalue = false
)
}
actions
{
on add
{
Submit
(
type = submit
displayname = "Submit"
)
Reset
(
type = reset
displayname = "Reset"
)
}
on edit
{
Update
(
type = submit
displayname = "Update"
)
Cancel
(
type = cancel
displayname = "Cancel"
)
}
}
}
list New_added
{
displayname = "New added-admin"
show all rows from Events [(Verify1 != 95 && Verify1 != 99)]
(
Date_field as "Date"
To
Event_Name as "Event Name"
Event_Type as "Event Type"
Details
Email as "Your Email"
Weblink
Venue
New_Venue as "Other Venue"
Your_Name as "Your Name"
Org as "Organiser"
Verify1 as "Admin use"
)
sort by
(
Date_field ascending
)
options
(
display rows = 100
)
}
list Old_Store
{
displayname = "Old Store"
show all rows from Events [Verify1 == 99]
(
Event_Name as "Event Name"
Date_field as "Date"
Event_Type as "Event Type"
New_Venue as "Other Venue"
Details
Email as "Your Email"
Weblink
Venue
Your_Name as "Your Name"
Org as "Organiser"
To
Verify1 as "Admin use"
)
sort by
(
Date_field ascending
)
options
(
display rows = 100
)
}
list Poll_results
{
displayname = "Poll results"
show all rows from About_Calendar
(
I_m_Interested_mainly_in as "I'm Interested mainly in:"
Added_Time as "Added Time"
)
filters
(
I_m_Interested_mainly_in
)
sort by
(
Added_Time descending
)
options
(
display rows = 100
)
}
list All_99s
{
displayname = "All 99s"
show all rows from Events [Verify1 == 99]
(
Date_field as "Date"
Event_Name as "Event Name"
Event_Type as "Type"
Venue
Weblink
Org as "Organiser"
Details
)
filters
(
Date_field
Event_Type
)
sort by
(
Date_field ascending
)
options
(
display rows = 30
)
}
}
section "Hidden"
{
displayname = "Hidden"
hide = true
form About_Calendar
{
displayname = "About Calendar"
success message = "Thanks for your input"
column
{
plain3
(
type = plaintext
value = "Welcome to the new Numplumz Calendar.
\nSuper Improved with lots of Filtering options
\n"
)
plain1
(
type = plaintext
value = "User information poll.
\n"
)
I_m_Interested_mainly_in
(
displayname = "I'm Interested mainly in:"
type = radiobuttons
values = {"Endruo MTB Racing", "XC racing", "Duathlon-Triathlons", "Road Racing", "Sportives", "DH/4X", "TrialQuests", "24Hr MTB Racing", "Charity rides", "MTB Club Rides", "Cyclo-Cross"}
)
plain
(
type = plaintext
value = "Please indicate your main interest
\n
\n"
)
}
column
{
plain2
(
type = plaintext
value = "To add a new event:
\n"
)
plain4
(
type = plaintext
value = "1. First add your organisation to the \"Organisers list\" if not already listed. (This is required)
\n"
)
plain5
(
type = plaintext
value = "2. Add your venue to the New venue list
\n"
)
plain6
(
type = plaintext
value = "3. Now add your Event. Drop down lists are then available for the above entries, and will be available for all future entries..\n"
)
plain7
(
type = plaintext
value = "Your event will not appear untill it has been approved by admin. Use the contact us form for any ammendments required.
\n"
)
}
actions
{
on add
{
Submit
(
type = submit
displayname = "Submit"
)
Reset
(
type = reset
displayname = "Reset"
)
}
on edit
{
Update
(
type = submit
displayname = "Update"
)
Cancel
(
type = cancel
displayname = "Cancel"
)
}
}
}
form Contact_Us
{
displayname = "Contact Us"
captcha = true
success message = "Thanks for your input"
info_contact
(
displayname = "info contact"
type = text
defaultvalue = "Contact-calendar or team Plumz"
tooltip = "no input required here"
)
plain
(
type = plaintext
value = "Warning: No Tech Heads here so don't ask for anything complicated ;-)\n"
)
Your_Email_Address
(
displayname = "Your Email Address"
type = email
)
must have Feedback_Category
(
displayname = "Feedback Category"
type = picklist
values = {"Info for admin", "Suggestion For Improvement (within reason)", "How do I do that ?", "I'd like to offer a numplumz rider a free event entry!", "Numplumz team or website question"}
tooltip = "Make your choice"
)
Comments
(
type = textarea
)
actions
{
on add
{
Submit
(
type = submit
displayname = "Submit"
on success
{
sendmail
(
To : zoho.adminuserid
From : zoho.adminuserid
Subject : "someone has contacted you"
Message : "<input.Feedback_Category%><input.Comments%>" + input.formdata
)
}
)
Reset
(
type = reset
displayname = "Reset"
)
}
on edit
{
Update
(
type = submit
displayname = "Update"
)
Cancel
(
type = cancel
displayname = "Cancel"
)
}
}
}
form Organisers
{
displayname = "Add New Organiser"
captcha = true
success message = "Your now on the list for future use"
column
{
plain2
(
type = plaintext
value = "ORGANISERS and Clubs: if you are not already listed then fill in this information
\n(you only need to do this once, its then available in the listings for selction)
\n"
)
plain
(
type = plaintext
value = "A short concise organiser name please
\n"
)
Organiser
(
type = text
)
}
column
{
plain3
(
type = plaintext
value = "Provide a full link to your website, and a short name that will appear as the link. I.E. \"your organiser name\" or \"website\"\n"
)
Website
(
type = url
enable linkname, target
)
Org_Info
(
displayname = "More Info"
type = textarea
tooltip = "Any other information you would like the public to know about you.\n(emails not recommended unless you want lots of spam from web crawler tools)"
)
plain1
(
type = plaintext
value = "\n
Further Info about this organiser
Check new Organiser mail.
" + input.formdata
)
}
)
Reset
(
type = reset
displayname = "Reset"
)
}
on edit
{
Update
(
type = submit
displayname = "Update"
)
Cancel
(
type = cancel
displayname = "Cancel"
)
}
}
}
form Venues
{
displayname = "Add New Venue"
captcha = true
success message = "Thanks for you new venue this will now appear in the listing for future use."
column
{
Venue
(
type = text
)
Terrain_Details
(
displayname = "Terrain Details"
type = textarea
)
Map_web_link
(
displayname = "Map web link"
type = url
enable linkname, target
)
Postcode
(
type = text
tooltip = "Add a nearest Postcode to help Sat Nav users"
)
}
column
{
plain
(
type = plaintext
value = "Any helpfull direction Information\n"
)
Directions
(
type = textarea
)
plain1
(
type = plaintext
value = "You only need to fill in this venue information once. It will then be listed permanently and when you add a future event will be available as a quick drop down list selection.\n"
)
}
actions
{
on add
{
Submit
(
type = submit
displayname = "Submit"
on success
{
sendmail
(
To : zoho.adminuserid
From : zoho.adminuserid
Subject : "New Venue"
Message : input.formdata
)
}
)
Reset
(
type = reset
displayname = "Reset"
)
}
on edit
{
Update
(
type = submit
displayname = "Update"
)
Cancel
(
type = cancel
displayname = "Cancel"
)
}
}
}
list Latest_Added
{
displayname = "Latest Added"
show all rows from Events [Verify1 == 95]
(
Date_field as "Date"
To
Event_Name as "Event Name"
Event_Type as "Type"
Venue
New_Venue as "-----"
Weblink
Org as "Organiser"
Details
Added_Time as "Added"
)
sort by
(
Added_Time descending
)
options
(
display rows = 20
)
}
form Events
{
displayname = "Add New Events"
captcha = true
success message = "Event added for admin verification"
column
{
Verify1
(
displayname = "Admin use"
type = number
private = true
defaultvalue = 00
width = 20
maxchar = 2
tooltip = "Admin use only"
)
plain1
(
type = plaintext
value = "IMPORTANT: If you not already done so, please add your organiser and venue details before adding the full event details.\n"
)
plain
(
type = plaintext
value = "\n
Please enter your Name and the all the EVENT details