Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Turns out that (even though it is not documented) we need to exchange the code for an access_token ourselves. I think this is a total waste since that was the nice thing about the old cookie. It was fast and easy to get the access_token. </p> <p>Anyway. To get the access_token from the new cookie you need to do the following:</p> <pre><code>public string ReturnAccessToken() { HttpCookie cookie = htc.Request.Cookies[string.Format("fbsr_{0}", facebookAppID)]; string jsoncode = System.Text.ASCIIEncoding.ASCII.GetString(FromBase64ForUrlString(cookie.Value.Split(new char[] { '.' })[1])); JsonData data = JsonMapper.ToObject(jsoncode); getAccessToken(data["code"].ToJson() } private string getAccessToken(string code) { //Notice the empty redirect_uri! And the replace on the code we get from the cookie. string url = string.Format("https://graph.facebook.com/oauth/access_token?client_id={0}&amp;redirect_uri={1}&amp;client_secret={2}&amp;code={3}", "YOUR_APP_ID", "", "YOUR_APP_SECRET", code.Replace("\"", "")); System.Net.HttpWebRequest request = System.Net.WebRequest.Create(url) as System.Net.HttpWebRequest; System.Net.HttpWebResponse response = null; using (response = request.GetResponse() as System.Net.HttpWebResponse) { System.IO.StreamReader reader = new System.IO.StreamReader(response.GetResponseStream()); string retVal = reader.ReadToEnd(); return retVal; } } public byte[] FromBase64ForUrlString(string base64ForUrlInput) { int padChars = (base64ForUrlInput.Length % 4) == 0 ? 0 : (4 - (base64ForUrlInput.Length % 4)); StringBuilder result = new StringBuilder(base64ForUrlInput, base64ForUrlInput.Length + padChars); result.Append(String.Empty.PadRight(padChars, '=')); result.Replace('-', '+'); result.Replace('_', '/'); return Convert.FromBase64String(result.ToString()); } </code></pre> <p>This may seem a bit redundant, but I suppose you can store the access_token in a session variable. If you do this and iFrame the your app on Facebook you need to know that it will not work in IE 6, 7 and 8 if the user have set his browser privacy settings to medium. There is a workaround for this, but as it is not a part of this question I will not write it. If people really want it, write a comment and I will show it :)</p> <p>-----------------------------------<strong>EDIT</strong>------------------------------------------</p> <p><strong>When using any of the old IE browsers you can't use cookies or session variables in pages that are Iframed</strong> in, like your pages on Facebook. This is a problem that can't really be solved sufficiently in coding. By sufficiently I mean that the solution is not nice. You need to set the p3p-header in your response. You can of course do this in coding for all the pages that you service, but the easiest solution (if you are using a .NET server to host your pages) is to set up a p3p policy for the IIS. A guide for this can be seen in <a href="http://support.microsoft.com/kb/324013" rel="noreferrer">http://support.microsoft.com/kb/324013</a>. It shouldn't matter what you write in the p3p policy (if you check Facebooks own you can see that they use "We don't have a p3p policy), the important part is that there stands something. I have had troubles just using random text though, but if you use the text in the example there shouldn't be a problem :)</p> <p>This took me forever to find out, so I hope someone can use it :D</p>
    singulars
    1. This table or related slice is empty.
    1. POProblem getting access_token after migrating to OAuth 2.0
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USKasper Vesth
    1. USKasper Vesth
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POProblem getting access_token after migrating to OAuth 2.0
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COWe want your solution for Session Variable and IFRAME ;)
      singulars
      1. PO
      1. USkape123
    2. COThanks this really helped me.
      singulars
      1. PO
      1. USWilliam Walseth
    3. COthx this worked. just out of curiosity, why is the redirect uri an empty string?
      singulars
      1. PO
      1. USTranscendence
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload