App : "; print_r($_POST); echo "";*/ //$fb_sig_user=$_POST['fb_sig_user']; //gets the user who is using the app $is_tab = isset($_POST['fb_sig_in_profile_tab']); if($is_tab) { $fb_sig_user=$_POST['fb_sig_profile_user']; //gets the user who is using the app $fb_sig_pages_id = $_POST['fb_sig_page_id']; } else { $fb_sig_user=$_POST['fb_sig_user']; //gets the user who is using the app } if($_GET['fb_page_id'] != ""){ $_SESSION['fb_page_id'] = $_GET['fb_page_id']; $page_id= $_SESSION['fb_page_id']; $page_info = $facebook->api_client->fql_query("SELECT has_added_app,name FROM page WHERE page_id = $page_id"); for ($i=0; $i < count($page_info); $i++) { $record = $page_info[$i]; $has_added_app=$record['has_added_app']; $admin = $facebook->api_client->pages_isAdmin("$page_id"); } } else if($is_tab) { //$page_id= '6665652845'; $page_id= $_SESSION['fb_page_id']; //$page_info = $facebook->api_client->fql_query("SELECT has_added_app,name FROM page WHERE page_id = $page_id"); /*for ($i=0; $i < count($page_info); $i++) { $record = $page_info[$i]; $has_added_app=$record['has_added_app']; $admin = $facebook->api_client->pages_isAdmin("$page_id"); }*/ } /*echo "Page id is : " . $fb_sig_pages_id; echo "
User is : " . $fb_sig_user;*/ if($fb_sig_user==$fb_sig_pages_id) { include_once('browse.php'); exit(); } echo "Browse for Art..."; echo ""; if($is_tab) { echo "Add My Art Gallery App >>"; } $str_artist = stripslashes($artist); if($op=='delete') //DELETE ART { $queryD = "DELETE FROM `gallery` WHERE `facebook_id` = '$fb_sig_user' AND `art_id` = '$artID';"; // $result1 = mysql_query($queryD); } // Query for record set $query1 = "SELECT DISTINCT art_id FROM `gallery` WHERE facebook_id = '$fb_sig_user' ORDER BY time"; // $result1 = mysql_query($query1); if ($myrow = mysql_fetch_array($result1)) { $nume=mysql_num_rows($result1); } if(!isset($start)) { // This variable is set to zero for the first page $start = 0; } $eu = ($start - 0); $limit = 6; // No of records to be shown per page. $back = $eu - $limit; $next = $eu + $limit; if (isset($_GET['sortby'])) $sortwith = $_GET['sortby']; // this be the real magic else if (isset($sortby)) $sortwith = $sortby; else $sortwith = "time"; if(!$is_tab) { echo "
"; } echo "
"; if ($nume == 0) { echo ""; } else { echo ""; } //echo ""; echo "
 "; if($back >=0) { echo "« PREV"; } else { echo "« PREV"; } echo "
"; $i=0; $k=1; for($i=0; $i<$nume; $i=$i+$limit){ if($i <> $eu){ echo " $k "; } else { echo "$k"; $current = $k; } /// Current page is not displayed as link and given font color red $k=$k+1; } echo "
"; if($nume > $next) { echo "NEXT »"; } else { echo "NEXT »"; } echo "Displaying $limit of $nume
"; //categories // Query for record set $query2 = "SELECT DISTINCT SubDeptName1 FROM `framed-feed` WHERE SubDeptName1 <> '' ORDER BY SubDeptName1 ASC"; // $result2 = mysql_query($query2); echo "
Choose an Artist...
    "; while ($row = mysql_fetch_array($result2)) { /*if ($row[0] == $str_artist) { echo "
  • " . $row[0] . "
    • "; } else echo "
  • " . $row[0] . "
    • ";*/ $artist_check = str_replace(" ","+",$row[0]); if ($artist_check == str_replace(" ","+",$artist)) { echo "
  • " . $row[0] . "
    • "; } else echo "
  • " . $row[0] . "
    • "; } echo "
"; // Get list of friends who have this app installed... $rs = $facebook->api_client->fql_query("SELECT uid FROM user WHERE has_added_app=1 and uid IN (SELECT uid2 FROM friend WHERE uid1 = $user)"); // Build a list of friends echo "
Your Friends...
"; if ($rs) { for ( $i = 0; $i < count($rs); $i++ ) { $friend_id = $rs[$i]["uid"]; echo ""; } } else { echo "

Sorry... none of your friends have this app...

"; } echo "
Invite Your Friends...

"; //logo echo "
"; echo "
"; $html = "
Paintings in Your Art Collection - Page $current
"; $count = 3; $i = 0; $html .= ""; //QUERY FOR ALL THE ART in the gallery $query = "SELECT DISTINCT art_id FROM `gallery` WHERE facebook_id = '$fb_sig_user' ORDER BY $sortwith DESC LIMIT $eu, $limit"; //echo $query; //FIND THE THUMBNAIL OF ART $path_thumb = "http://site.overstockart.com/sorter/shadow/"; $result = mysql_query($query); if ($nume == 0) { $html .= ""; } while ($row_id = mysql_fetch_array($result)) { $art_id = $row_id['art_id']; //QUERY FOR ALL THE ART ON THE PAGE $query2 = "SELECT * FROM `framed-feed` WHERE YahooID = '$art_id'"; $result2 = mysql_query($query2); while ($row = mysql_fetch_array($result2)) { $imageCaption = $row['Caption']; $imagePartId = $row['CatalogSK']; $part_id = substr($imagePartId,0,strpos($imagePartId,'-')); $artist = $row['SubDeptName1']; $path_to_thumb = $path_thumb . $part_id. '.jpg'; $path_to_thumb_gif = $path_thumb . $part_id . '.gif'; if(url_exists($path_to_thumb)) { // file exists } else if(url_exists($path_to_thumb_gif)) { //gif file exists... $path_to_thumb = $path_to_thumb_gif; } else { // file doesn't exists continue; } $imageFile = $row['Filename']; //STRIPS THE FRAME INFO $art_name = substr($imageCaption,0,strrpos($imageCaption,'with')); $imageID = $row['YahooID']; $html .= ""; $i++; if ($i == $count) { $html .= ""; $i = 0; } } } $html .= "
Sorry... You don't have any art in your gallery...
"; $html .= ""; $html .= "

"; if(!$is_tab) { $html .= "
" . $art_name . "
(-) remove
"; } else { $html .= "
" . $art_name . "
"; } $html .= "

"; //$html .= "
" . $art_name . "
(-) remove
"; $html .= "
"; //THE CURRENT ART ON YOUR WALL... $html .= "
Currently on Your Profile Wall...
"; $count = 3; $i = 0; $html .= ""; //QUERY FOR ALL THE ART in the gallery $query = "SELECT art_id FROM `facebook` WHERE facebook_id = '$fb_sig_user' ORDER BY time DESC LIMIT 1"; //echo $query; //FIND THE THUMBNAIL OF ART $path_thumb = "http://site.overstockart.com/sorter/shadow/"; $result = mysql_query($query); $on_wall=mysql_num_rows($result); if ($on_wall == 0) { $html .= ""; } while ($row_id = mysql_fetch_array($result)) { $art_id = $row_id['art_id']; //QUERY FOR ALL THE ART ON THE PAGE $query2 = "SELECT * FROM `framed-feed` WHERE YahooID = '$art_id'"; $result2 = mysql_query($query2); while ($row = mysql_fetch_array($result2)) { $imageCaption = $row['Caption']; $imagePartId = $row['CatalogSK']; $artist = $row['SubDeptName1']; $part_id = substr($imagePartId,0,strpos($imagePartId,'-')); $path_to_thumb = $path_thumb . $part_id . '.jpg'; if(url_exists($path_to_thumb)) { // file exists } else { // file doesn't exists continue; } $imageFile = $row['Filename']; //STRIPS THE FRAME INFO $art_name = substr($imageCaption,0,strrpos($imageCaption,'with')); $imageID = $row['YahooID']; $html .= ""; $i++; if ($i == $count) { $html .= ""; $i = 0; } } } $html .= "
Sorry... You don't have any art on your profile...
"; $html .= ""; $html .= "

"; $html .= "
" . $art_name . "
"; $html .= "

"; $html .= "
"; /*$html .= "
";*/ $html .= ""; print "$html"; //close database mysql_close($conn); ?>