{"id":526,"date":"2010-08-02T00:03:48","date_gmt":"2010-08-02T08:03:48","guid":{"rendered":"https:\/\/www.laaker.com\/micah\/?p=526"},"modified":"2024-04-02T19:34:15","modified_gmt":"2024-04-03T03:34:15","slug":"analysis-of-and-apis-for-we-rule-and-we-farm-actions","status":"publish","type":"post","link":"https:\/\/www.laaker.com\/micah\/blog\/2010\/analysis-of-and-apis-for-we-rule-and-we-farm-actions","title":{"rendered":"Analysis of (and APIs for) We Rule and We Farm actions"},"content":{"rendered":"<p>For anyone who hasn&#8217;t had the pleasure to rock either of ngmoco:)&#8217;s great iPhone\/iPad game titles, <a href=\"http:\/\/itunes.apple.com\/WebObjects\/MZStore.woa\/wa\/viewSoftware?id=339274852&#038;mt=8\">We Rule<\/a> and <a href=\"http:\/\/itunes.apple.com\/WebObjects\/MZStore.woa\/wa\/viewSoftware?id=374027675&#038;mt=8\">We Farm<\/a>, this post will make little sense.<\/p>\n<p><a href=\"http:\/\/itunes.apple.com\/WebObjects\/MZStore.woa\/wa\/viewSoftware?id=339274852&#038;mt=8\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/a1.phobos.apple.com\/us\/r1000\/032\/Purple\/a5\/07\/3e\/mzl.hsshwgjx.175x175-75.jpg\" width=\"80\" height=\"80\" title=\"We Rule icon\" class=\"alignleft\"  alt=\"We Rule icon\" \/><\/a> <a href=\"http:\/\/itunes.apple.com\/WebObjects\/MZStore.woa\/wa\/viewSoftware?id=374027675&#038;mt=8\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/a1.phobos.apple.com\/us\/r1000\/048\/Purple\/d1\/4a\/32\/mzl.jhhibnwm.175x175-75.jpg\" width=\"80\" height=\"80\" title=\"We Farm icon\" class=\"alignleft\"  alt=\"We Farm icon\" \/><\/a> If, however, you are a fan of the &#8220;Farmville in medieval times&#8221; and the &#8220;Farmville in, well, Farmville times&#8221; game titles that are all the rage with the kids (and <a href=\"http:\/\/revision3.com\/diggnation\/jimmyfallon\">Jimmy Fallon<\/a>), I have compiled some data that may help you make some educated decisions in-game. Namely, I&#8217;ve attempted to compile the earning ratios of both crops and buildings (the two revenue- and experience-generating facets of the games) so as to minimize the time I needed to spend to jump levels. And now I&#8217;ve opened that data up in hopes that its of help to someone else playing the game. <\/p>\n<p>Please note, however, that none are complete, largely due to the fact that I&#8217;m a casual player of these games. (As of writing this, I am level 27 in We Rule and level 11 in We Farm, both of which have levels going well into the 30s, I believe..) As such, I can see that there are levels I haven&#8217;t achieved, but I can&#8217;t fill in the details until I get there. (Are you already there at the finish line? Then please skip to the end of this post to see how you can help.)<\/p>\n<p><iframe width='400' height='300' frameborder='0' src='http:\/\/spreadsheets.google.com\/pub?key=tzIkc_R61ROUJ1GLE2Tby4Q&#038;single=true&#038;gid=0&#038;output=html&#038;widget=true'><\/iframe><\/p>\n<p><iframe width='400' height='300' frameborder='0' src='http:\/\/spreadsheets.google.com\/pub?key=tzIkc_R61ROUJ1GLE2Tby4Q&#038;single=true&#038;gid=1&#038;output=html&#038;widget=true'><\/iframe><\/p>\n<p><iframe width='400' height='300' frameborder='0' src='http:\/\/spreadsheets.google.com\/pub?key=tzIkc_R61ROUJ1GLE2Tby4Q&#038;single=true&#038;gid=2&#038;output=html&#038;widget=true'><\/iframe><\/p>\n<p><iframe width='400' height='300' frameborder='0' src='http:\/\/spreadsheets.google.com\/pub?key=tzIkc_R61ROUJ1GLE2Tby4Q&#038;single=true&#038;gid=3&#038;output=html&#038;widget=true'><\/iframe><\/p>\n<p>For any developers out there interested in leveraging this data in their apps, too, you can grab (and query and filter) the entire data set using <a href=\"http:\/\/developer.yahoo.com\/yql\/\">YQL (Yahoo! Query Language)<\/a>. (After recently reading <a href=\"http:\/\/www.wait-till-i.com\">Christian Heilmann<\/a>&#8216;s fantastic &#8220;<a href=\"http:\/\/m13.me\/9UxdSM\">How to Create a Web Service in a Matter of Minutes<\/a>,&#8221; particularly the &#8220;Turning an Editable Data Set into a Web Service&#8221; section, I knew I had a great project worth testing against his example.)<\/p>\n<p>Just run these queries thru YQL, and you&#8217;re off and running.<\/p>\n<ul>\n<li><a href=\"http:\/\/developer.yahoo.com\/yql\/console\/?q=use%20'http%3A%2F%2Fgithub.com%2Fmlaaker%2Fyql-tables%2Fraw%2Fmaster%2Fngmoco%2Fngmoco.we.rule.crops.xml'%20as%20ngmoco.we.rule.crops%3B%20%20select%20*%20from%20ngmoco.we.rule.crops&#038;env=store%3A%2F%2Fdatatables.org%2Falltableswithkeys\">select * from ngmoco.we.rule.crops<\/a><\/li>\n<li><a href=\"http:\/\/developer.yahoo.com\/yql\/console\/?q=use%20'http%3A%2F%2Fgithub.com%2Fmlaaker%2Fyql-tables%2Fraw%2Fmaster%2Fngmoco%2Fngmoco.we.rule.structures.xml'%20as%20ngmoco.we.rule.structures%3B%20select%20*%20from%20ngmoco.we.rule.structures&#038;env=store%3A%2F%2Fdatatables.org%2Falltableswithkeys\">select * from ngmoco.we.rule.structures<\/a><\/li>\n<li><a href=\"http:\/\/developer.yahoo.com\/yql\/console\/?q=use%20'http%3A%2F%2Fgithub.com%2Fmlaaker%2Fyql-tables%2Fraw%2Fmaster%2Fngmoco%2Fngmoco.we.farm.structures.xml'%20as%20ngmoco.we.farm.structures%3B%20select%20*%20from%20ngmoco.we.farm.structures&#038;env=store%3A%2F%2Fdatatables.org%2Falltableswithkeys\">select * from ngmoco.we.farm.structures<\/a><\/li>\n<li><a href=\"http:\/\/developer.yahoo.com\/yql\/console\/?q=use%20'http%3A%2F%2Fgithub.com%2Fmlaaker%2Fyql-tables%2Fraw%2Fmaster%2Fngmoco%2Fngmoco.we.farm.crops.xml'%20as%20ngmoco.we.farm.crops%3B%20%20select%20*%20from%20ngmoco.we.farm.crops&#038;env=store%3A%2F%2Fdatatables.org%2Falltableswithkeys\">select * from ngmoco.we.farm.crops<\/a><\/li>\n<\/ul>\n<p>Frustrated that this isn&#8217;t comprehensive? Care to enhance the data? It&#8217;s all available in a <a href=\"http:\/\/spreadsheets.google.com\/ccc?key=0Ai3sMl8HoQtQdHpJa2NfUjYxUk9VSjFHTEUyVGJ5NFE&#038;hl=en\">large Google Docs spreadsheet<\/a>. Chip in, and help refine the data set. (Even better? It&#8217;s already got 2 sheets waiting for We City to drop.)<\/p>\n<p>Lastly, if you&#8217;re looking for someone else to add to your collectives in these games, I&#8217;m &#8220;mlaaker&#8221; in both games.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>For anyone who hasn&#8217;t had the pleasure to rock either of ngmoco:)&#8217;s great iPhone\/iPad game titles, We Rule and We Farm, this post will make little sense. If, however, you are a fan of the &#8220;Farmville in medieval times&#8221; and the &#8220;Farmville in, well, Farmville times&#8221; game titles that are all the rage with the [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[476,458,223,475,474,473,472,471,477],"class_list":["post-526","post","type-post","status-publish","format-standard","hentry","category-blog","tag-data","tag-ipad","tag-iphone","tag-newtoy","tag-ngmoco","tag-social-games","tag-we-farm","tag-we-rule","tag-yql"],"_links":{"self":[{"href":"https:\/\/www.laaker.com\/micah\/wp-json\/wp\/v2\/posts\/526","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.laaker.com\/micah\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.laaker.com\/micah\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.laaker.com\/micah\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.laaker.com\/micah\/wp-json\/wp\/v2\/comments?post=526"}],"version-history":[{"count":0,"href":"https:\/\/www.laaker.com\/micah\/wp-json\/wp\/v2\/posts\/526\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.laaker.com\/micah\/wp-json\/wp\/v2\/media?parent=526"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.laaker.com\/micah\/wp-json\/wp\/v2\/categories?post=526"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.laaker.com\/micah\/wp-json\/wp\/v2\/tags?post=526"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}