The JSON Feed

This option is for hardcore programmers that know how to parse a JSON stream. It allows any kinda of data layout that you want, but at the price of custom coding. You will need some kinda of scripting language php,asp or javascript...

Record Control Options
lim
Limit. The number of shows to display. A value of 0 will show unlimited shows. The default value is 0.
pg
Page. If limit is set, will send a set of records starting with page x limit. Page 1 is the first page, page 0 is invalid
off
Offset. Will send records starting with the offset number. If limit/page is set the first record will be (limit * page) + offset.
Content Filtering Shows
old
1/0. old=1 will send past shows, 0 for upcoming shows. If omitted the value is 0.
ldr
1/0/empty. A value of 1 will display shows where the project leader option is set. A value of zero will send shows where leader flag is not sent. When omitted both leader and non leader shows will be sent.
feat
1/0. A value of 1 will display shows where the "featured" option is set. A value of zero will send shows were featured is not set. If omitted all shows are sent.
vid
Venue id. Filter the stream based on the venue's id.
pid
Project id. Filter the stream based on the project id.
pcat
Project Category. Filter the stream based on the project category.
id
Send only info for the one gig
Content Filtering Posts
cat
category. Matches records that have this category as set in bill's gigulator.
id
Id. Retrieve's the post specified by the id.
JSON feed fields
type
the type of data being sent, "posts" "show"
limit
the limit set by "lim"
offset
the offset as set by "pg"
page
the page as set by "pg".
page_recs
number of records being sent on this page.
total_recs
total number of records ignoring page/limit/offset values
data
the requested data in array form.
Example
Ex 1
publish.twelvepoint.net/shows.json?site=999&old=1&ldr=1&pg=3&lim=100Sends old shows for site '999' where the user is the project leader. The first gig is the 100th show.
Show Example Feed:
{
   type: "shows",
   limit: "1",
   offset: 0,
   page: 2,
   page_recs: 1,
   total_recs: 422,
   data: [ {
         gig_id: "6095",
         gig_date: "20120518",
         status: "CONFIRMED",
         private: "0",
         featured: "0",
         hide_date: "0",
         event_name: "Happy hour - free oysters",
         event_url: null,
         time_show: "7pm - 9:45pm",
         time_doors: null,
         ticket_price: null,
         ticket_url: null,
         proj_id: "1322",
         proj_name: "Bill Malchow - solo piano",
         proj_leader: "1",
         proj_description: null,
         proj_url: "http://www.billmalchow.com",
         venue_id: "778",
         venue_name: "Le Bon Temps Roule",
         venue_url: "http://www.myspace.com/4801magazine",
         venue_addr1: "4801 Magazine Street",
         venue_addr2: null,
         venue_addr3: null,
         venue_city: "New Orleans",
         venue_state: "LA",
         venue_country: null,
         venue_zip: null,
         venue_phone: "(504) 897-3448",
         pic: "http://www.billmalchow.com/pic/sched_pics/bill_back_sm.jpg",
         event_pic: null,
         proj_pic: "http://www.billmalchow.com/pic/sched_pics/bill_back_sm.jpg",
         venue_pic: null,
         misc: ""
  {]
}
Post Example Feed:
{
   type: "posts",
   limit: "1",
   offset: 0,
   page: 1,
   page_recs: 1,
   total_recs: 56,
   data: [ {
      id: "323",
      category: "News",
      post_date: "2012-04-26 22:40:00",
      hide_date: "0",
      title: "New Years",
      content: "Happy belated New Year Everyone!",
      pic: null
   }]
}