PHP - Facebook Api Advice?

In short i want to use the following code below, when someone selects there option and submits it, it would bring up details from the database on this user from the selected table, can you explain what it would be called doing this so i can look it up, Sorry to be a pain, Cheers.

Code: [Select]
<select name="target2" id="target2">

    <option value=""></option>

  <?php

  $sql = "SELECT player_id, friend_id, name, is_active FROM contacts as c JOIN players as p ON c.friend_id = p.id WHERE c.player_id = $playerID AND is_active = 1 ORDER BY name ASC";

  $que = mysql_query($sql) or die(mysql_error());

  while($list = mysql_fetch_array($que)) {

  ?>

  <option value="<?php echo $list['friend_id'] ?>"><?php echo $list['name'] ?></option>

  <?php } ?>

  </select>

So here's my problem I'm not sure how to approach this:

I have a table with user_items which are stored together separated by commas.
Code: [Select]
13,12,11,9,27,15,16,22,21,23,24,26,29,30,31,32,33
Now, I have a script where the user is in a trade and I want to verify the item they are trying to trade, but is there an alternative other than grabbing all of that users' items and checking that one item with all of the records?

I've tried using
Code: [Select]
SELECT * FROM MYTABLE WHERE user_item_id IN(33)
As an example to see if it will pull the rows with that ID.  It didn't seem to work, am I doing it wrong? if so, forgive me. Any suggestions/help? The main problem is I don't want to have to explode that data and use a foreach to check that one item against all of that users items, as they could have well over 500.

Right now I have a SESSION so when users flip though pages they carry their info with them, what I'm trying to do now is that userhome.php can't be accesses unless the user just was succesful in cracking there system.. game I'm creating for those of you helping and following me while I do this! it's a virutal hacking simulation and where I'm now is that the user's passwordcracker was compared to the target systems 'systemkey' and either granted him access or didn't, if it did it displayed a progress bar then fowarded to userhome.php where the target users info will lay, right now though if I just type in userhome.php i get there without haveing the crack it.... any ideas?

Hello, can someone please advice me on what scripts I will need to accomplish the following.

I want users to be able to login to their personal page, on there will be items such as pdf files, jpeg files etc, that they will be able to download.

Are there any free scripts out there that can do this, that anyone knows of? I don't mind paying if its a cheapish script for one of you to make for me, but money is a bit tight at the moment so a free script would be my 1st choice...

Thanks for all your help

Hello.

I have a facebook like button. It is wrapped in an iFrame. What I would like to create is a Form that when the user clicks the submit button the action is to process the Facebook like button. So pressing my button presses the facebook like button as well. Why? Because I would like to keep track of users that click the like button.

This is an example of the like button.

<iframe src="http://www.facebook.com/plugins/like.php?href=http%3A%2F%2Fwww.likethis.com&amp;send=false&amp;layout=standard&amp;width=450&amp;show_faces=true&amp;action=like&amp;colorscheme=light&amp;font&amp;height=80" scrolling="no" frameborder="0" style="border:none; overflow:hidden; width:450px; height:80px;" allowTransparency="true"></iframe>

I dont no if this should even go here but here it goes. I created a blog were each blog post is veiwed on the same page in regards to the id passed to it (as standard). What i really need to do is incorporate the facebook comment box onto the page but... it only relates to the document itself rather than it's dynamic content.

I'm trying to add Facebook connect to my new app, but I'm not sure where to really start.  I looked through a lot of the facebook documentation, but I haven't been able to find any really good implementation suggestions.  I just want basic functionality.

Hi all,

I am a beginner for PHP.  I created a site & now I want to add a wall post to my Facebook Page.  This post should be posted via PHP when I add a post to my site, without manually adding that on Facebook Page.   I referred Facebook Developer documentations, but those are really mess for me.    I really don't want this to do with php-sdk or any other.    I want to do this manually.   

Thanks

Hey guys, i'm creating a facebook clone. Almost there, got the main/basic features all done, however i've got one piece of code which is really bugging me, don't worry about it being messy and horribley coded. I will be improving and optimising it every chance i get once i've got this down.

it's on the main page, i want it to display all recent status' that have been made, i can display them however i think i've bugg'd the SQL somewhere and it's driving my crazy, any help would be greatly appriciated

Thanks

Code: [Select]
  <?php
   $sql = mysql_query("SELECT * FROM statuses ORDER BY id DESC");
    $sql = mysql_query("SELECT * FROM statuses LEFT JOIN users ON statuses.userid = users.id");
while ($row = mysql_fetch_assoc($sql)) {
$status_id = $row['id'];
$status = $row['status'];
$time_posted = $row['time_posted'];
$sql2 = mysql_query("SELECT username,avatar_url FROM users WHERE id=$userid LIMIT 1");
while ($row2=mysql_fetch_array($sql)){
$usernamestatus = $row2['username'];
$avatar_url = $row2['avatar_url'];
echo '<div id="content">';
echo "<img src='/photos/$usernamestatus/$avatar_url' height='50px' width='50px' />";
echo "<a href=\"profile.php?id=$userid\">". $usernamestatus ."</a>";
echo "<br />";
echo $status;
echo " <span class=x><a href=delete_status.php?id=$status_id>x</a></span>";
echo "<br />";
echo time_ago($time_posted);
echo "<br />";
echo "<br />";
echo "</div>";
}
}
}
?>

I am going to use this script http://www.gayadesign.com/diy/snotify-easy-notifications-in-jquery/ but I wanted to know how exactly would I make it work like facebook does? What steps would I take to show the other user the notification rather than showing me, the sender it?

Following is the code that works fine if I am passing `/pageid/feed` to `facebook->api`, but when I change it to upload the image directly to my Facebook FAN PAGE photo album, it will not work. Kindly let me know what I am doing wrong in the following code:

    // Works fine
    $status = $facebook->api("/406221796071956/feed", 'post', $attachment);

    // Does not work
    $status = $facebook->api('/196878530339618/photos', 'post', $attachment);

# Full Source

    Code: [Select]
<?php

    require 'src/facebook.php';
    
    $app_id = "364900470214655";
    $app_secret = "xxxx";
    
    $facebook = new Facebook(array(
     'appId' => $app_id,
     'secret' => $app_secret,
     'cookie' => true,
     'fileUpload' => true,
    ));
    
    $user = $facebook->getUser();
    
    if(($facebook->getUser())==0){
     header("Location:{$facebook->getLoginUrl(array('req_perms' => 'photo_upload,user_status,publish_stream,user_photos,offline_access,manage_pages'))}");
     exit;
    } else {
     $accounts_list = $facebook->api('/me/accounts');
     echo "i am connected";
    }
    $valid_files = array('image/jpeg', 'image/png', 'image/gif');
    
    // To get the page access token to post as a page
    foreach($accounts_list['data'] as $account){
     if($account['id'] == 194458563914948){ // my page id =123456789
      $access_token = $account['access_token'];
      echo "<p>Page Access Token: $access_token</p>";
     }
    }
    
    // Posting to the page wall
    
    if(isset($_FILES) && !empty($_FILES)){  
     $folder = "pak/".$_FILES['pic']['name']; // Getting the path of the folder
     $fold = 'http://radiations3.com/facebook/'.$folder;  // URL Path to folder
     echo $fold."<br>";
     if(move_uploaded_file($_FILES['pic']['tmp_name'], $folder)){
      # Upload photo here
      $img = realpath($_FILES["pic"]["tmp_name"]);
      $album_id = '406221796071956';
      $attachment = array(
       'message' => $_POST['textfield'],
       'source' => $fold,
       'aid' => $album_id,
       'no_story' => 1,
       'access_token' => $access_token
      );
      $status = $facebook->api("/196878530339618/photos", 'post', $attachment); 
     } else{
      echo 'Only jpg, png and gif image types are supported!';
     }
    }
    ?>
    <body>
     <!-- Form for uploading the photo -->
     <div class="main">
      <p>Select a photo to upload on Facebook Fan Page</p>
      <form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>" enctype="multipart/form-data">
      <p>Select the image: <input type="file" name="pic" />
        <br />
        <label>Description
        <input type="text" name="textfield" id="textfield" />
        </label>
      </p>
      <p><input class="post_but" type="submit" value="Upload to my album" /></p>
      </form>
     </div>
    </body>

Hey guys,

Been trying to get my head around curl over the past month, I need help with loading one of Facebook's Applications.

I need the script to:
1) Log into Facebook.
2) Load up the application.
3) Load up the application's iFrame.

I've got steps 1 + 2 down, so it logs into Facebook and loads up the application alright, but when it comes to loading up the specific application's iframe, it re-directs me to log in again. I am 99% sure it's something to do with cookies because if you log in locally and load up the iframe url it has no problem loading up the app.

(Iframe URL: http://mobsters-fb-apache-dynamic-lb.playdom.com/prod_facebook/facebook/mobsters_v1/facebook_iframe.php?track=bookmark)


Here is my current code: (Running it in apache)
And also I am really new to curl and am pretty much learning on the go so please excuse any obvious errors


$Email = strip_tags(str_replace(' ', '', $_POST['email']));
$Password = strip_tags(str_replace(' ', '', $_POST['password']));
$MobstersURL = "http://apps.facebook.com/mobstersapp/index.php?track=bookmark&ref=bookmarks&count=0";
$FBlogin = 'https://www.facebook.com/login.php?login_attempt=1';
$Data = 'charset_test=%E2%82%AC%2C%C2%B4%2C%E2%82%AC%2C%C2%B4%2C%E6%B0%B4%2C%D0%94%2C%D0%84&lsd=vuCfh&locale=en_US&email='.urlencode($Email).'&pass='.urlencode($Password).'&default_persistent=0&charset_test=%E2%82%AC%2C%C2%B4%2C%E2%82%AC%2C%C2%B4%2C%E6%B0%B4%2C%D0%94%2C%D0%84&lsd=vuCfh';

$Cookie = "cookie.txt";

$fp = fopen($Cookie,'wb');   

   
$agent = "Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.7.12) Gecko/20050915 Firefox/1.0.7";
//login to facebook
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL,$FBlogin);   
curl_setopt($ch, CURLOPT_USERAGENT, $agent);
curl_setopt($ch, CURLOPT_COOKIEFILE, $Cookie);
curl_setopt($ch, CURLOPT_COOKIEJAR, $Cookie);
curl_setopt($ch, CURLOPT_REFERER, $FBlogin);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_FOLLOWLOCATION, 1);
curl_setopt($ch, CURLOPT_HEADER, 1);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0);
curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0);
curl_setopt($ch, CURLOPT_POSTFIELDS, $Data);
       
$Excecute = curl_exec($ch);
//echo $Excecute;

//load up mobsters then display it

curl_setopt($ch, CURLOPT_URL,$MobstersURL);
curl_setopt($ch, CURLOPT_USERAGENT, $agent);
curl_setopt($ch, CURLOPT_REFERER, "http://www.facebook.com/?ref=logo");
curl_setopt($ch, CURLOPT_COOKIEFILE, $Cookie);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_FOLLOWLOCATION, 1);
curl_setopt($ch, CURLOPT_HEADER, 1);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0);
curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0);

$LoadMobsters = curl_exec($ch);
echo $LoadMobsters;











//load up mobsters in iframe THIS IS WHERE I'M STUCK

curl_setopt($ch, CURLOPT_URL, "http://mobsters-fb-apache-dynamic-lb.playdom.com/prod_facebook/facebook/mobsters_v1/facebook_iframe.php?track=bookmark");
curl_setopt($ch, CURLOPT_USERAGENT, $agent);
curl_setopt($ch, CURLOPT_COOKIEFILE, $Cookie);
curl_setopt($ch, CURLOPT_REFERER, "http://apps.facebook.com/mobstersapp/index.php?track=bookmark&ref=bookmarks&count=0");
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_FOLLOWLOCATION, 1);
curl_setopt($ch, CURLOPT_HEADER, 1);

$Load_iFrame = curl_exec($ch);

echo $Load_iFrame; // This is where I noticed it wasn't working since instead of loading up the iframe, it brought me back to facebook to log in.


So yeah I need some help in loading up the iframe since that is where I need to grab important data.

Any help would be much appreciated, and yes, I've been to http://php.net/manual/en/book.curl.php a billion times which is why I've come here where the pro's are for help

Thanks.

Hi,
I'm having problems with my phpbb forum/facebook coding. I have recently put Facebook Share links in my forum...

The facebook 'Share' links(buttons), are attached to every post viewable within th eforum, and link to:
http://www.facebook.com/sharer.php?u=http://www.mywebsite.com/facebook/share-fb.php?postNo=" . $postrow[$i]['post_id'].'&title='.$userdata['username'].'%20on%20facebook!!'
--> where
'$userdata['username']' username of forum user
..and
'$postrow[$i]['post_id']' = the id of the forum post, to be processed by share-fb.php


So as according to he
http://developers.facebook.com/docs/share
under the Basics section, I will be able to control the thumbnail, title and content from
Quote

You can control the exact title, description, and thumbnail that Facebook Share uses by adding the following meta tags to the <head> element in your page:

So the url looks like this:
http://www.anclchess.net/facebook/share.php?postNo=65914&title=My%20Names%20on%20facebook!!Title%20of%20post

There are 2 major problems.
1) I am passing the post number identity via URL.. which means anyone wanting to view posts they may not have permissions to view, would simply need to change the share.php?postNo=65914&title= and they would have access..
and
2) The the thumbnail, title and content don't seem to work.. I cant figure out why.. see below
This is 'share-fb.php':
<?php

define('IN_PHPBB', true);  // allows infomation to be passed to external page, such as '$userdata['username'] '(username)
$phpbb_root_path = '../forum/';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);

//
// Start session management
//
$userdata = session_pagestart($user_ip, PAGE_INDEX);
init_userprefs($userdata);
//
// End session management
//
?>
<?php

$postIdent = $_GET['postNo']; // gets forum post identity from URL, to then later query.. \\
$titleIdent = $_GET['title']; // gets title of post from URL too \\

if($userdata['session_logged_in'])
{

//echo'Hello ' . $userdata['username'] . '. The facebook system is not yet up-and-running. Please try later.<br>'; // <-works \\
$sql = "SELECT post_id, post_subject, post_text FROM phpbb_posts_text WHERE post_id='$postIdent'";
if( !($result = $db->sql_query($sql)) )
{
message_die(CRITICAL_ERROR, "Could not query config information", "", __LINE__, __FILE__, $sql);
}

while ( $row = $db->sql_fetchrow($result) ) // executes database query \\
{
$postSubject = $row['post_subject'];
$postText = $row['post_text'];

}
$pattern = '#\[[^\]]+\]#';
$postTextFormat = preg_replace($pattern, '', $postText);  // this search and replaces the forum square brackets code such as: '[ url ]' & '[ /url ]' content 
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title></title> // left empty \\ 
<script src="http://static.ak.fbcdn.net/connect.php/js/FB.Share" 
        type="text/javascript">
</script>
<meta name="title" content="<?php echo echo $titleIdent; ?>" /> // this doesnt work - I don't know why. The variables work in the <body> but not here \\
<meta name="description" content="<?php echo $postSubject.$postTextFormat; ?>" /> 
<link rel="image_src" href="http://www.mywebsite.com/images/website_log.png" />
</head>

<body>
<?php  
echo $postSubject.'<br>'.$postTextFormat; // contains content of forum post \\
?>
</body>
</html>
<?php
}
else
{
echo('You are a forum guest. Please sign in or register.');
}

?>


Please help if you can.

Hi I am using facebook auth but email id not fetching from facebook login please help me why is happening? 

Hi there!

First, i must say that i have no php knowledge, maybe a 1%

Here is what i want to do:

I have wordpress, with a plugin called Facebook connect, it has a cool feature where you can invite your facebook friends, it looks like this:

http://dailyerz.com/login/?fbconnect_action=invite

And i am also using cubepoints, a plugin that rewards users with points. I want to reward users for every user they invite.

From the cube points docs http://techcube.net/docs/1.3/docs.html
i got this:

Quote

The following code will add 10 points to the current logged in user. If no user is logged in, no points will be added. You may input negative number to subtract points.


<php
  if( function_exists('cp_alterPoints') && is_user_logged_in() ){
    cp_alterPoints(cp_currentUser(), 10);
  }
?>

and the invite.php of facebook connect looks like this:

<?php get_header(); 
$fb_user = fb_get_loggedin_user();
?>
<div style="padding:20px;" >
<?php if(FBCONNECT_CANVAS=="web") : ?>
  <fb:serverfbml style="width: 100%;">
    <script type="text/fbml">
      <fb:fbml>
<?php endif; ?>       
      
          <fb:request-form
                    action="<?php echo get_option('siteurl'); ?>"
                    method="GET"
                    invite="true"
                    type="<?php echo get_option('blogname');?>"
                    content="<?php echo get_option('blogname')." : ".get_option('blogdescription'); ?>
                 <fb:req-choice url='<?php echo get_option('siteurl'); ?>'
                       label='<?php _e('Become a Member!', 'fbconnect') ?>' />
              "
              >
 
                    <fb:multi-friend-selector
rows="5"
email_invite="false"
cols="3"
                    showborder="false"
                    actiontext="<?php _e('Invite your friends to Dailyerz.', 'fbconnect') ?>">
        </fb:request-form>
<?php if(FBCONNECT_CANVAS=="web") : ?>
      </fb:fbml>
 
    </script>
  </fb:serverfbml>
<?php endif; ?>
</div>
<?php get_footer(); ?>


Any idea on how to make this work? Do i have to create a Facebook App? 

Thanks!