View file wap/usergallery.php

World Fastest and Cheapest Hosting
Buy Cheapest Web Domains
File size: 33.5Kb 
<?php
include("inc/func.inc.php");
header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
header("Cache-Control: no-cache, must-revalidate");
header("Pragma: no-cache");
echo "<?xml version=\"1.0\"?>\n";
echo "<!DOCTYPE html PUBLIC \"-//WAPFORUM//DTD XHTML Mobile 1.0//EN\" \"http://www.wapforum.org/DTD/xhtml-mobile10.dtd\">\n";
?>
<html xmlns="http://www.w3.org/1999/xhtml">
<?php
  if(!db()){
  echo "<head>";
  echo "<title>RemiXchaT.CoM - World Wide Chat Community And Downloads !</title>";
  include("inc/css.inc.php");
  echo "</head>";
  echo "<body>";
  echo getdberror();
  echo "</body>";
  echo "</html>";
  exit();
  }

  $show = $_GET["show"];
  $hits = $_GET["hits"];
  $page = $_GET["page"];
  $who = $_GET["who"];
  $uid = getuid_hits($hits);
  $uip = getip();
  $ubr = $_SERVER['HTTP_USER_AGENT'];
  cleardata();
  addvisitor();

  if(isipbanned($uip,$ubr)){
  if(!isshield(getuid_hits($hits))){
  echo "<head>";
  echo "<title>RemiXchaT.CoM - World Wide Chat Community And Downloads !</title>";
  include("inc/css.inc.php");
  echo "</head>";
  echo "<body>";
  echo getipbanned($uip, $ubr);
  echo "</body>";
  echo "</html>";
  exit();
  }
  }

  if(($show != "") && ($show != "terms")){
  $uid = getuid_hits($hits);
  if((islogged($hits)==false)||($uid==0)){
  echo "<head>";
  echo "<title>RemiXchaT.CoM - World Wide Chat Community And Downloads !</title>";
  include("inc/css.inc.php");
  echo "</head>";
  echo "<body>";
  echo getsesexplog();
  echo "</body>";
  echo "</html>";
  exit();
  }
  }

  if((isbanned($uid))&&($uid != '0')){
  echo "<head>";
  echo "<title>RemiXchaT.CoM - World Wide Chat Community And Downloads !</title>";
  include("inc/css.inc.php");
  echo "</head>";
  echo "<body>";
  echo getbanned($uid);
  echo "</body>";
  echo "</html>";
  exit();
  }

$whoimage = $_GET["whoimage"];


////Menu Utama///

 if($show=="main")
{
  addonline(getuid_hits($hits),"Photo Gallery","");
          echo "<head>";
  echo "<title>RemiXchaT.CoM - World Wide Chat Community And Downloads !</title>";
  include("inc/css.inc.php");
 echo "</head>";
 echo "<body>";
  echo "<div class=\"box_cen\" align=\"center\">";
  echo "<b>Photo Gallery</b>";
  echo "<div class=\"box_sub\" align=\"center\">";
 echo "Welcome ".getnick_uid($uid)." To Gallery.<br/>";
 echo "Lets Share Our Pic Here And Comment Other Member Pic!<br/>";
  echo "<hr>";
  $noi = mysql_fetch_array(mysql_query("SELECT COUNT(DISTINCT uid) FROM mx_usergallery"));
  echo "All Members<br/><a href=\"usergallery.php?show=all&amp;hits=$hits\">$noi[0] Photos</a><br/>";
  $noi = mysql_fetch_array(mysql_query("SELECT COUNT(DISTINCT uid) FROM mx_usergallery WHERE sex='M'"));
  echo "Male Members<br/><a href=\"usergallery.php?show=males&amp;hits=$hits\">$noi[0] Photos</a><br/>";
  $noi = mysql_fetch_array(mysql_query("SELECT COUNT(DISTINCT uid) FROM mx_usergallery WHERE sex='F'"));
  echo "Female Members<br/><a href=\"usergallery.php?show=females&amp;hits=$hits\">$noi[0] Photos</a><br/><hr>";
 echo "Random Photos<br/>";
    $sql = "SELECT id, uid, imageurl, info FROM mx_usergallery ORDER BY RAND()  LIMIT 5";
    $items = mysql_query($sql);
    echo mysql_error();
    if(mysql_num_rows($items)>0)
    {
    while ($item = mysql_fetch_array($items))
    {

      $id = $item[0];
   $img = $item[2];
      $whonick = getnick_uid($item[1]);
  $ext = getext($img);
         $foto = "<img src=\"thumb.php?image=$img&amp;w=27&amp;h=27&amp;type=$ext\" alt=\"$whonick\"/>";
        echo "<a href=\"$img\">$foto</a>";

    }
    }
  echo "</div></div>";
 echo "<div class=\"box_cen\" align=\"center\">";
 echo "<div class=\"box_sub\" align=\"center\">";
 echo "<a href=\"usergallery.php?show=viewgaluser&amp;who=$uid&amp;hits=$hits\">My Album</a><br/>";
  echo "<a href=\"upload.php?show=uploader&amp;hits=$hits\">Upload Photo</a></div></div>";
 echo footerweb($hits);
  echo "</body>";

}

////Menu All///

else if($show=="all")
{
  addonline(getuid_hits($hits),"Gallery - All Members","");
          echo "<head>";
  echo "<title>RemiXchaT.CoM - World Wide Chat Community And Downloads !</title>";
  include("inc/css.inc.php");
 echo "</head>";
 echo "<body>";
  echo "<div class=\"box_cen\" align=\"center\">";
  echo "<b>All Members</b>";
  echo "<div class=\"box_sub\" align=\"left\">";
    if($page=="" || $page<=0)$page=1;

    $noi = mysql_fetch_array(mysql_query("SELECT COUNT(DISTINCT uid) FROM mx_usergallery"));
    $num_items = $noi[0]; //changable
    $items_per_page= 6;
    $num_pages = ceil($num_items/$items_per_page);
    if(($page>$num_pages)&&$page!=1)$page= $num_pages;
    $limit_start = ($page-1)*$items_per_page;

 $sql = "SELECT DISTINCT uid FROM mx_usergallery ORDER BY uid ASC LIMIT $limit_start, $items_per_page";

    $items = mysql_query($sql);
    echo mysql_error();
    
    if(mysql_num_rows($items)>0)
    {
    while ($item = mysql_fetch_array($items))
    {
$who = $item[0];
$whonick = getnick_uid($who);

    $online = mysql_fetch_array(mysql_query("SELECT sex, uicon FROM mx_users WHERE id='".$who."'"));

 if($online[1]=="")
 {
 $seximg = "";
}else{
 $seximg = "<img src=\"$online[1]\" alt=\"*\"/>";
 }
 $foto = idle($who, 45, 45);
 $countpics = mysql_fetch_array(mysql_query("SELECT COUNT(id) FROM mx_usergallery WHERE uid='".$who."'"));
    $pm = "<a href=\"inbox.php?show=sendpms&amp;who=$who&amp;hits=$hits\">Send PM</a>";
        $lnk = " $seximg<a href=\"prov.php?show=viewuser&amp;who=$who&amp;hits=$hits\">$whonick</a>";
 $cpic = " <a href=\"usergallery.php?show=viewgaluser&amp;who=$who&amp;hits=$hits\">$countpics[0] Photos</a>";
       echo "<table><tr><td>$foto<br/>$pm</td><td>$lnk<br/>$cpic</td></tr></table><br/><hr>"; 
    }
}
  echo "<img src=\"images/d_upload.gif\" alt=\"&#187;\"/> <a href=\"upload.php?show=uploader&amp;hits=$hits\">Upload Picture</a><br/>";
 echo "<img src=\"images/gallery.png\" alt=\"*\"/> <a href=\"usergallery.php?show=main&amp;hits=$hits\">Gallery</a>";
  echo "</div></div>";
 echo "<div class=\"box_sub\" align=\"center\">";
    if($page>1)
    {
      $ppage = $page-1;
      echo "<a href=\"usergallery.php?show=$show&amp;page=$ppage&amp;hits=$hits\">&#171;Prev</a> ";
    }
    if($page<$num_pages)
    {
      $npage = $page+1;
      echo "<a href=\"usergallery.php?show=$show&amp;page=$npage&amp;hits=$hits\">Next&#187;</a>";
    }
    echo "<br/>Page $page of $num_pages<br/>";
    if($num_pages>2)
    {
        $rets = "<form action=\"usergallery.php\" method=\"get\">";
      $rets .= "Page<input name=\"pg\" format=\"*N\" size=\"3\"/>";
        $rets .= "<input type=\"hidden\" name=\"show\" value=\"$show\"/>";
        $rets .= "<input type=\"hidden\" name=\"view\" value=\"$view\"/>";
        $rets .= "<input type=\"hidden\" name=\"hits\" value=\"$hits\"/>";
        $rets .= "<input type=\"submit\" value=\"[GO]\"/></form>";
        echo $rets;
    }
 echo "</div>";
 echo footerweb($hits);
  echo "</body>";

}

////Menu Lelaki///

else if($show=="males")
{
  addonline(getuid_hits($hits),"Gallery - Male Members","");
          echo "<head>";
  echo "<title>RemiXchaT.CoM - World Wide Chat Community And Downloads !</title>";
  include("inc/css.inc.php");
 echo "</head>";
 echo "<body>";
  echo "<div class=\"box_cen\" align=\"center\">";
  echo "<b>Male Members</b>";
  echo "<div class=\"box_sub\" align=\"left\">";
    //////ALL gallery SCRIPT <<

    if($page=="" || $page<=0)$page=1;

    $noi = mysql_fetch_array(mysql_query("SELECT COUNT(DISTINCT uid) FROM mx_usergallery WHERE sex='M'"));

    $num_items = $noi[0]; //changable
    $items_per_page= 6;
    $num_pages = ceil($num_items/$items_per_page);
    if(($page>$num_pages)&&$page!=1)$page= $num_pages;
    $limit_start = ($page-1)*$items_per_page;

$sql = "SELECT DISTINCT uid FROM mx_usergallery WHERE sex='M' ORDER BY uid ASC LIMIT $limit_start, $items_per_page";

    $items = mysql_query($sql);
    echo mysql_error();
    
    if(mysql_num_rows($items)>0)
    {
    while ($item = mysql_fetch_array($items))
    {
$who = $item[0];
$whonick = getnick_uid($who);

    $online = mysql_fetch_array(mysql_query("SELECT sex, uicon FROM mx_users WHERE id='".$who."'"));

 if($online[1]=="")
 {
 $seximg = "";
}else{
 $seximg = "<img src=\"$online[1]\" alt=\"*\"/>";
 }

 $foto = idle($who, 45, 45);
 $countpics = mysql_fetch_array(mysql_query("SELECT COUNT(id) FROM mx_usergallery WHERE uid='".$who."'"));
    $pm = "<a href=\"inbox.php?show=sendpms&amp;who=$who&amp;hits=$hits\">Send PM</a>";
        $lnk = " $seximg<a href=\"prov.php?show=viewuser&amp;who=$who&amp;hits=$hits\">$whonick</a>";
 $cpic = " <a href=\"usergallery.php?show=viewgaluser&amp;who=$who&amp;hits=$hits\">$countpics[0] Photos</a>";
       echo "<table><tr><td>$foto<br/>$pm</td><td>$lnk<br/>$cpic</td></tr></table><br/><hr>"; 
    }
}
  echo "<img src=\"images/d_upload.gif\" alt=\"&#187;\"/> <a href=\"upload.php?show=uploader&amp;hits=$hits\">Upload Pic</a><br/>";
 echo "<img src=\"images/gallery.png\" alt=\"*\"/> <a href=\"usergallery.php?show=main&amp;hits=$hits\">Gallery</a>";
  echo "</div></div>";
  echo "<div class=\"box_sub\" align=\"center\">";
    if($page>1)
    {
      $ppage = $page-1;
      echo "<a href=\"usergallery.php?show=$show&amp;page=$ppage&amp;hits=$hits\">&#171;Prev</a> ";
    }
    if($page<$num_pages)
    {
      $npage = $page+1;
      echo "<a href=\"usergallery.php?show=$show&amp;page=$npage&amp;hits=$hits\">Next&#187;</a>";
    }
    echo "<br/>Page $page of $num_pages<br/>";
    if($num_pages>2)
    {
        $rets = "<form action=\"usergallery.php\" method=\"get\">";
      $rets .= "Page<input name=\"pg\" format=\"*N\" size=\"3\"/>";
        $rets .= "<input type=\"hidden\" name=\"show\" value=\"$show\"/>";
        $rets .= "<input type=\"hidden\" name=\"view\" value=\"$view\"/>";
        $rets .= "<input type=\"hidden\" name=\"hits\" value=\"$hits\"/>";
        $rets .= "<input type=\"submit\" value=\"[GO]\"/></form>";
        echo $rets;
    }
 echo "</div>";
 echo footerweb($hits);
  echo "</body>";

}
////Menu Girl///
else if($show=="females")
{
  addonline(getuid_hits($hits),"Gallery - Female Members","");
          echo "<head>";
  echo "<title>RemiXchaT.CoM - World Wide Chat Community And Downloads !</title>";
  include("inc/css.inc.php");
 echo "</head>";
 echo "<body>";
  echo "<div class=\"box_cen\" align=\"center\">";
  echo "<b>Female Members</b>";
  echo "<div class=\"box_sub\" align=\"left\">";
    //////ALL gallery SCRIPT <<
    if($page=="" || $page<=0)$page=1;

    $noi = mysql_fetch_array(mysql_query("SELECT COUNT(DISTINCT uid) FROM mx_usergallery WHERE sex='F'"));

    $num_items = $noi[0]; //changable
    $items_per_page= 6;
    $num_pages = ceil($num_items/$items_per_page);
    if(($page>$num_pages)&&$page!=1)$page= $num_pages;
    $limit_start = ($page-1)*$items_per_page;
 $sql = "SELECT DISTINCT uid FROM mx_usergallery WHERE sex='F' ORDER BY uid ASC LIMIT $limit_start, $items_per_page";

    $items = mysql_query($sql);
    echo mysql_error();
    
    if(mysql_num_rows($items)>0)
    {
    while ($item = mysql_fetch_array($items))
    {
$who = $item[0];
$whonick = getnick_uid($who);

    $online = mysql_fetch_array(mysql_query("SELECT sex, uicon FROM mx_users WHERE id='".$who."'"));

 if($online[1]=="")
 {
 $seximg = "";
}else{
 $seximg = "<img src=\"$online[1]\" alt=\"*\"/>";
 }

 $foto = idle($who, 45, 45);
 $countpics = mysql_fetch_array(mysql_query("SELECT COUNT(id) FROM mx_usergallery WHERE uid='".$who."'"));
    $pm = "<a href=\"inbox.php?show=sendpms&amp;who=$who&amp;hits=$hits\">Send PM</a>";
        $lnk = " $seximg<a href=\"prov.php?show=viewuser&amp;who=$who&amp;hits=$hits\">$whonick</a>";
 $cpic = " <a href=\"usergallery.php?show=viewgaluser&amp;who=$who&amp;hits=$hits\">$countpics[0] Photos</a>";
       echo "<table><tr><td>$foto<br/>$pm</td><td>$lnk<br/>$cpic</td></tr></table><br/><hr>"; 
    }
}
  echo "<img src=\"images/d_upload.gif\" alt=\"&#187;\"/> <a href=\"upload.php?show=uploader&amp;hits=$hits\">Upload Pic</a><br/>";
 echo "<img src=\"images/gallery.png\" alt=\"*\"/> <a href=\"usergallery.php?show=main&amp;hits=$hits\">Gallery</a>";
  echo "</div></div>";
  echo "<div class=\"box_sub\" align=\"center\">";
    if($page>1)
    {
      $ppage = $page-1;
      echo "<a href=\"usergallery.php?show=$show&amp;page=$ppage&amp;hits=$hits\">&#171;Prev</a> ";
    }
    if($page<$num_pages)
    {
      $npage = $page+1;
      echo "<a href=\"usergallery.php?show=$show&amp;page=$npage&amp;hits=$hits\">Next&#187;</a>";
    }
    echo "<br/>Page $page of $num_pages<br/>";
    if($num_pages>2)
    {
        $rets = "<form action=\"usergallery.php\" method=\"get\">";
      $rets .= "Page<input name=\"pg\" format=\"*N\" size=\"3\"/>";
        $rets .= "<input type=\"hidden\" name=\"show\" value=\"$show\"/>";
        $rets .= "<input type=\"hidden\" name=\"view\" value=\"$view\"/>";
        $rets .= "<input type=\"hidden\" name=\"hits\" value=\"$hits\"/>";
        $rets .= "<input type=\"submit\" value=\"[GO]\"/></form>";
        echo $rets;
    }
 echo "</div>";
 echo footerweb($hits);
  echo "</body>";
}
////Menu View Kedua///
else if($show=="viewgaluser2")
{
 $snick = getnick_uid($who);
  addonline(getuid_hits($hits),"Viewing $snick Photo","");
  $who = $_GET["who"];
  $type = $_GET["type"];
  $uid = getuid_hits($hits);
  $whonick = getnick_uid($who);

          echo "<head>";
  echo "<title>RemiXchaT.CoM - World Wide Chat Community And Downloads !</title>";
  include("inc/css.inc.php");
 echo "</head>";
 echo "<body>";
  echo "<div class=\"box_cen\" align=\"center\">";
    $online = mysql_fetch_array(mysql_query("SELECT sex, uicon FROM mx_users WHERE id='".$who."'"));

 if($online[1]=="")
 {
 $seximg = "";
}else{
 $seximg = "<img src=\"$online[1]\" alt=\"*\"/>";
 }
  echo "$seximg<a href=\"prov.php?show=viewuser&amp;who=$who&amp;hits=$hits\">$whonick</a> Pictures";
  echo "<div class=\"box_sub\" align=\"left\">";
   //////ALL LISTS SCRIPT <<
   
    if($page=="" || $page<=0)$page=1;
    $noi = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM mx_usergallery WHERE uid='".$who."' AND type='".$type."'"));
    $num_items = $noi[0]; //changable
    $items_per_page= 3;
    $num_pages = ceil($num_items/$items_per_page);
    if(($page>$num_pages)&&$page!=1)$page= $num_pages;
    $limit_start = ($page-1)*$items_per_page;


    //changable sql

        $sql = "SELECT id, sex, imageurl, info, filesize, udate, download, view FROM mx_usergallery WHERE uid='".$who."' AND type='".$type."' ORDER BY id DESC LIMIT $limit_start, $items_per_page";
    $items = mysql_query($sql);
    echo mysql_error();
    if(mysql_num_rows($items)>0)
    {
    while ($item = mysql_fetch_array($items))
    {
  $vws = mysql_fetch_array(mysql_query("SELECT view FROM mx_usergallery WHERE id='".$item[0]."'"));
  $views = $vws[0]+1;
      mysql_query("UPDATE mx_usergallery SET view='".$views."' WHERE id='".$item[0]."'");

        $info = parsepm($item[3], $hits);
  $ext = getext($item[2]);
        $foto = "<img src=\"thumb.php?image=$item[2]&amp;w=80&amp;h=80&amp;type=$ext\" alt=\"$item[0]\"/>";
    $cotime = time() - (23*60*60);
  if($item[5]>=$cotime)
 {
  $remain = time() - $item[5];
  $idle = gettimemsg($remain);
  $bila = "$idle ago";
 }else{
  $tari = date("d m y - h:i:s A",$item[5]);
  $bila = $tari;
  }
 $jpg = htmlspecialchars("$item[2]");
 list($width,$height) = getimagesize($jpg);

 $pixel = "".$width."x".$height."";

 $nama = explode("/",$item[2]); 

 $newname = $nama[1];
        if(ismod($uid)||($uid==$who))
    	{
         $uinfo = "<a href=\"usergallery.php?show=addinfo&amp;hits=$hits&amp;who=$who&amp;id=$item[0]&amp;type=$type\">Update Photo</a><br/>";
  }
    $cmtl = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM mx_usergallery_rating WHERE gbowner='".$item[0]."'"));
  $commt = "<a href=\"usergallery.php?show=comment&amp;hits=$hits&amp;id=$item[0]\">Comments ($cmtl[0])</a>";
 echo "<table><tr><td>$foto<br/><i><b>$info</b></i><br/>$uinfo$commt</td><td>Picture ID: <b>$item[0]</b><br/><a href=\"gdownload.php?id=$item[0]\">Download $pixel</a> ($item[4])<br/>View: <b>$item[7] Times</b><br/>Download: <b>$item[6] Times</b><br/><b>$bila</b></td></tr></table><br/><hr>";
        
    }
    }
  echo "<a href=\"usergallery.php?show=viewgaluser&amp;who=$who&amp;hits=$hits\">Back To Album</a><br/>";
   echo "<a href=\"usergallery.php?show=main&amp;hits=$hits\">Main Gallery</a>";
 echo "</div></div>";
    echo "<div class=\"box_sub\" align=\"center\">";
    if($page>1)
    {
      $ppage = $page-1;
      echo "<a href=\"usergallery.php?show=$show&amp;who=$who&amp;hits=$hits&amp;page=$ppage&amp;type=$type\">&#171;Prev</a> ";
    }
    if($page<$num_pages)
    {
      $npage = $page+1;
      echo "<a href=\"usergallery.php?show=$show&amp;who=$who&amp;hits=$hits&amp;page=$npage&amp;type=$type\">Next&#187;</a>";
    }
    echo "<br/>Page $page of $num_pages";
    if($num_pages>2)
    {
        $rets = "<form action=\"usergallery.php\" method=\"get\">";
      $rets .= "Page<input name=\"pg\" format=\"*N\" size=\"3\"/>";
        $rets .= "<input type=\"hidden\" name=\"show\" value=\"$show\"/>";
        $rets .= "<input type=\"hidden\" name=\"who\" value=\"$who\"/>";
        $rets .= "<input type=\"hidden\" name=\"type\" value=\"$type\"/>";
        $rets .= "<input type=\"hidden\" name=\"hits\" value=\"$hits\"/>";
        $rets .= "<input type=\"submit\" value=\"[GO]\"/></form>";
        echo $rets;
    }
   echo "</div>";
 echo footerweb($hits);
  echo "</body>";
}

////Menu View Pertama///
else if($show=="viewgaluser")
{
  addonline(getuid_hits($hits),"Gallery - View Album Lists","");
  $who = $_GET["who"];
  $uid = getuid_hits($hits);
  $whonick = getnick_uid($who);

          echo "<head>";
  echo "<title>RemiXchaT.CoM - World Wide Chat Community And Downloads !</title>";
  include("inc/css.inc.php");
 echo "</head>";
 echo "<body>";
  echo "<div class=\"box_cen\" align=\"center\">";
 echo "<b>View Albums</b>";
  echo "<div class=\"box_sub\" align=\"center\">";
    $online = mysql_fetch_array(mysql_query("SELECT sex, uicon FROM mx_users WHERE id='".$who."'"));
 if($online[1]=="")
 {
 $seximg = "";
}else{
 $seximg = "<img src=\"$online[1]\" alt=\"*\"/>";
 }
  echo "$seximg<a href=\"prov.php?show=viewuser&amp;who=$who&amp;hits=$hits\">$whonick</a>";
  echo "<br/><hr>";
   //////ALL LISTS SCRIPT <<
    $noi = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM mx_usergallery WHERE uid='".$who."' AND type='0'"));
 echo "My Photo<br/>";
    if($noi[0] == '0')
    {
        $foto = "<img src=\"thumb.php?image=images/nopic.jpg&amp;w=45&amp;h=45&amp;type=jpg\" alt=\"No Image\"/>";
        echo "$foto<br/>";
 echo "No Photo<br/><br/>";
   }else{
    $sql = "SELECT id, uid, imageurl, info FROM mx_usergallery WHERE uid='".$who."' AND type='0' ORDER BY RAND()  LIMIT 1";

    $items = mysql_query($sql);
    echo mysql_error();
    if(mysql_num_rows($items)>0)
    {
    while ($item = mysql_fetch_array($items))
    {

      $id = $item[0];
    $img = $item[2];
      $whonick = getnick_uid($item[1]);
   $ext = getext($img);
        $foto = "<img src=\"thumb.php?image=$img&amp;w=45&amp;h=45&amp;type=$ext\" alt=\"$whonick\"/>";
        echo "$foto<br/>";
    }
    }
  echo "<a href=\"usergallery.php?show=viewgaluser2&amp;who=$who&amp;type=0&amp;hits=$hits\">$noi[0] Photos</a><br/><br/>"; 
 }
    $noi1 = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM mx_usergallery WHERE uid='".$who."' AND type='1'"));
 echo "My Family<br/>";
    if($noi1[0] == '0')
    {
        $foto = "<img src=\"thumb.php?image=images/nopic.jpg&amp;w=45&amp;h=45&amp;type=jpg\" alt=\"No Image\"/>";
        echo "$foto<br/>";
 echo "No Photo<br/><br/>";
   }else{
    $sql = "SELECT id, uid, imageurl, info FROM mx_usergallery WHERE uid='".$who."' AND type='1' ORDER BY RAND()  LIMIT 1";

    $items = mysql_query($sql);
    echo mysql_error();
    if(mysql_num_rows($items)>0)
    {
    while ($item = mysql_fetch_array($items))
    {

      $id = $item[0];
    $img = $item[2];
      $whonick = getnick_uid($item[1]);
   $ext = getext($img);
        $foto = "<img src=\"thumb.php?image=$img&amp;w=45&amp;h=45&amp;type=$ext\" alt=\"$whonick\"/>";
        echo "$foto<br/>";
    }
    }
 echo "<a href=\"usergallery.php?show=viewgaluser2&amp;who=$who&amp;type=1&amp;hits=$hits\">$noi1[0] Photos</a><br/><br/>"; 
 }
    $noi2 = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM mx_usergallery WHERE uid='".$who."' AND type='2'"));
 echo "My Friend<br/>";
    if($noi2[0] == '0')
    {
        $foto = "<img src=\"thumb.php?image=images/nopic.jpg&amp;w=45&amp;h=45&amp;type=jpg\" alt=\"No Image\"/>";
        echo "$foto<br/>";
 echo "No Photo<br/><br/>";
   }else{
    $sql = "SELECT id, uid, imageurl, info FROM mx_usergallery WHERE uid='".$who."' AND type='2' ORDER BY RAND()  LIMIT 1";

    $items = mysql_query($sql);
    echo mysql_error();
    if(mysql_num_rows($items)>0)
    {
    while ($item = mysql_fetch_array($items))
    {

      $id = $item[0];
    $img = $item[2];
      $whonick = getnick_uid($item[1]);
   $ext = getext($img);
        $foto = "<img src=\"thumb.php?image=$img&amp;w=45&amp;h=45&amp;type=$ext\" alt=\"$whonick\"/>";
        echo "$foto<br/>";
    }
    }
 echo "<a href=\"usergallery.php?show=viewgaluser2&amp;who=$who&amp;type=2&amp;hits=$hits\">$noi2[0] Photos</a><br/><br/>"; 
 }
    $noi3 = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM mx_usergallery WHERE uid='".$who."' AND type='3'"));
 echo "My Favourite<br/>";
    if($noi3[0] == '0')
    {
        $foto = "<img src=\"thumb.php?image=images/nopic.jpg&amp;w=45&amp;h=45&amp;type=jpg\" alt=\"No Image\"/>";
        echo "$foto<br/>";
 echo "No Photo<br/><br/>";
   }else{
    $sql = "SELECT id, uid, imageurl, info FROM mx_usergallery WHERE uid='".$who."' AND type='3' ORDER BY RAND()  LIMIT 1";

    $items = mysql_query($sql);
    echo mysql_error();
    if(mysql_num_rows($items)>0)
    {
    while ($item = mysql_fetch_array($items))
    {

      $id = $item[0];
    $img = $item[2];
      $whonick = getnick_uid($item[1]);
   $ext = getext($img);
        $foto = "<img src=\"thumb.php?image=$img&amp;w=45&amp;h=45&amp;type=$ext\" alt=\"$whonick\"/>";
        echo "$foto<br/>";
    }
    }
 echo "<a href=\"usergallery.php?show=viewgaluser2&amp;who=$who&amp;type=3&amp;hits=$hits\">$noi3[0] Photos</a><br/><br/>"; 
 }
    $noi4 = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM mx_usergallery WHERE uid='".$who."' AND type='4'"));
 echo "My Other<br/>";
    if($noi4[0] == '0')
    {
        $foto = "<img src=\"thumb.php?image=images/nopic.jpg&amp;w=45&amp;h=45&amp;type=jpg\" alt=\"No Image\"/>";
        echo "$foto<br/>";
 echo "No Photo";
   }else{
    $sql = "SELECT id, uid, imageurl, info FROM mx_usergallery WHERE uid='".$who."' AND type='4' ORDER BY RAND()  LIMIT 1";

    $items = mysql_query($sql);
    echo mysql_error();
    if(mysql_num_rows($items)>0)
    {
    while ($item = mysql_fetch_array($items))
    {

      $id = $item[0];
    $img = $item[2];
      $whonick = getnick_uid($item[1]);
   $ext = getext($img);
        $foto = "<img src=\"thumb.php?image=$img&amp;w=45&amp;h=45&amp;type=$ext\" alt=\"$whonick\"/>";
        echo "$foto<br/>";
    }
    }
 echo "<a href=\"usergallery.php?show=viewgaluser2&amp;who=$who&amp;type=4&amp;hits=$hits\">$noi4[0] Photos</a>"; 
 }
    echo "</div></div>";
 echo "<div class=\"box_cen\" align=\"center\">";
 echo "<div class=\"box_sub\" align=\"center\">";
   echo "<a href=\"usergallery.php?show=main&amp;hits=$hits\">Main Gallery</a></div></div>";
 echo footerweb($hits);
  echo "</body>";
}

////Menu Rate///

 else if($show=="comment")
{
  addonline(getuid_hits($hits),"Gallery - Comment List","");
          echo "<head>";
  echo "<title>RemiXchaT.CoM - World Wide Chat Community And Downloads !</title>";
  include("inc/css.inc.php");
 echo "</head>";
 echo "<body>";
  $id = $_GET["id"];
  echo "<div class=\"box_cen\" align=\"center\">";
 echo "<b>Comment Lists</b>";
      //////ALL LISTS SCRIPT <<
    if($page=="" || $page<=0)$page=1;
    $noi = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM mx_usergallery_rating WHERE gbowner='".$id."'"));
    $num_items = $noi[0]; //changable
    $items_per_page= 6;
    $num_pages = ceil($num_items/$items_per_page);
    if(($page>$num_pages)&&$page!=1)$page= $num_pages;
    $limit_start = ($page-1)*$items_per_page;
    
    $sql = "SELECT gbmsg, gbsigner, dtime, id, rate  FROM mx_usergallery_rating WHERE gbowner ='".$id."' ORDER BY dtime DESC LIMIT $limit_start, $items_per_page";
  echo "<div class=\"box_sub\" align=\"left\">";
    $items = mysql_query($sql);
    echo mysql_error();
    if(mysql_num_rows($items)>0)
    {
    while ($item = mysql_fetch_array($items))
    {
        
    if(isonline($item[1]))
  {
    $iml = "<img src=\"images/onl.gif\" alt=\"+\"/>";
    
  }else{
    $iml = "<img src=\"images/ofl.gif\" alt=\"-\"/>";
  }
 $foto = idle($item[1], 45, 45);
      $snick = getnick_uid($item[1]);
 $txcmt = $item[0];
 $sape = $item[1];
      $bs = date("d/m/y",$item[2]);
  echo "<table><tr><td>$foto</td><td><a href=\"prov.php?show=viewuser&amp;who=$item[1]&amp;hits=$hits\">$iml$snick</a><br/>$txcmt<br/>$bs</td></tr></table><br/><hr>";
    }
    }
    echo "</div></div>";
 echo "<div class=\"box_sub\" align=\"center\">";
    if($page>1)
    {
      $ppage = $page-1;
      echo "<a href=\"usergallery.php?show=$show&amp;page=$ppage&amp;hits=$hits&amp;id=$id\">&#171;Prev</a> ";
    }
    if($page<$num_pages)
    {
      $npage = $page+1;
      echo "<a href=\"usergallery.php?show=$show&amp;page=$npage&amp;hits=$hits&amp;id=$id\">Next&#187;</a>";
    }
    echo "<br/>Page $page of $num_pages<br/>";
    if($num_pages>2)
    {
        $rets = "<form action=\"usergallery.php\" method=\"get\">";
      $rets .= "Page<input name=\"pg\" format=\"*N\" size=\"3\"/>";
        $rets .= "<input type=\"hidden\" name=\"show\" value=\"$show\"/>";
        $rets .= "<input type=\"hidden\" name=\"id\" value=\"$id\"/>";
        $rets .= "<input type=\"hidden\" name=\"hits\" value=\"$hits\"/>";
        $rets .= "<input type=\"submit\" value=\"[GO]\"/></form>";
        echo $rets;
    }
    echo "</div>"; 
 echo "<div class=\"box_cen\" align=\"center\">";
 echo "<div class=\"box_sub\" align=\"center\">";
         echo "<a href=\"usergallery.php?show=acomment&amp;hits=$hits&amp;id=$id\">Add Comment</a><br/>";
   echo "<a href=\"usergallery.php?show=main&amp;hits=$hits\">Main Gallery</a></div></div>";
 echo footerweb($hits);
  echo "</body>";
}
else if($show=="acomment")
{
   $id = $_GET["id"];
  addonline(getuid_hits($hits),"Gallery - Add Comment","");
                echo "<head>";
  echo "<title>RemiXchaT.CoM - World Wide Chat Community And Downloads !</title>";
  include("inc/css.inc.php");
 echo "</head>";
 echo "<body>";
  echo "<div class=\"box_cen\" align=\"center\">";
 echo "<b>Add Comment</b>";
  echo "<div class=\"box_sub\" align=\"center\">";
  echo "<form action=\"usergallery.php?show=adcomment&amp;hits=$hits\" method=\"post\">";
    echo "Message:<br/><textarea rows=\"2\" cols=\"12\" name=\"msgtxt\" maxlength=\"500\"/></textarea><br/>";
        echo "<input type=\"hidden\" name=\"id\" value=\"$id\"/>";
    echo "<input type=\"submit\" value=\"Add\"/></form>";
   echo "</div></div>";
 echo "<div class=\"box_cen\" align=\"center\">";
 echo "<div class=\"box_sub\" align=\"center\">";
 echo "<a href=\"usergallery.php?show=main&amp;hits=$hits\">Main Gallery</a></div></div>";
 echo footerweb($hits);
    echo "</body>";
}

 else if($show=="adcomment")
{
   addonline(getuid_hits($hits),"Gallery - Add Comment","");
   $id = $_POST["id"];
   $msgtxt = $_POST["msgtxt"];
           echo "<head>";
  echo "<title>RemiXchaT.CoM - World Wide Chat Community And Downloads !</title>";
  include("inc/css.inc.php");
 echo "</head>";
 echo "<body>";
  ///echo "<card=\"main\" title=\"MaxHits.CO.CC\">";
  echo "<div class=\"box_cen\" align=\"center\">";
 echo "<b>Add Comment</b>";
  echo "<div class=\"box_sub\" align=\"center\">";
      $uid = getuid_hits($hits);
      $res = mysql_query("INSERT INTO mx_usergallery_rating SET gbowner='".$id."', gbsigner='".$uid."', dtime='".time()."', gbmsg='".$msgtxt."', rate='0'");

   if($res)
 {
    echo "<img src=\"images/ok.gif\" alt=\"o\"/>Comments added Successfully";
   }else{
     echo "<img src=\"images/notok.gif\" alt=\"x\"/>No Comments were added";
   }
    echo "</div></div>"; 
 echo "<div class=\"box_cen\" align=\"center\">";
 echo "<div class=\"box_sub\" align=\"center\">";
   echo "<a href=\"usergallery.php?show=comment&amp;hits=$hits&amp;id=$id\">Back To Comment</a><br/>";
   echo "<a href=\"usergallery.php?show=main&amp;hits=$hits\">Main Gallery</a></div></div>";
 echo footerweb($hits);
  echo "</body>";
    }
 else if($show=="addinfo")
{
  addonline(getuid_hits($hits),"Update Pic","");
          echo "<head>";
  echo "<title>RemiXchaT.CoM - World Wide Chat Community And Downloads !</title>";
  include("inc/css.inc.php");
 echo "</head>";
 echo "<body>";
  $who = $_GET["who"];
  $type = $_GET["type"];
  $id = $_GET["id"];
  echo "<div class=\"box_cen\" align=\"center\">";
  echo "<b>Update Picture</b>";
  echo "<div class=\"box_sub\" align=\"center\">";
        $sql = "SELECT imageurl, info FROM mx_usergallery WHERE id='".$id."'";

    $items = mysql_query($sql);
    echo mysql_error();
    if(mysql_num_rows($items)>0)
    {
    while ($item = mysql_fetch_array($items))
    {
 $link = $item[0];
 $info = $item[1];
        if(ismod($uid)||($uid==$who))
    	{
        echo "<form action=\"usergallery.php?show=addinfoact&amp;hits=$hits&amp;id=$id\" method=\"post\">";
        echo "Image Info<br/><textarea rows=\"2\" cols=\"12\" name=\"info\" value=\"$info\"/></textarea><br/>";
    echo "Change Album<br/><select name=\"type\" value=\"$type\">";

    echo "<option value=\"0\">My Photo</option>";
    echo "<option value=\"1\">My Family</option>";
    echo "<option value=\"2\">My Friend</option>";
    echo "<option value=\"3\">My Favourite</option>";
    echo "<option value=\"4\">My Others</option>";
    echo "</select><br/>";
    echo "<input type=\"submit\" value=\"Update\"/></form></div></div>";
 echo "<div class=\"box_sub\" align=\"center\">";
         echo "<a href=\"genproc.php?show=upavg&amp;hits=$hits&amp;who=$who&amp;avsrc=$link\">Use As Avatar</a><br/>";
         echo "<a href=\"genproc.php?show=upavg2&amp;hits=$hits&amp;who=$who&amp;avsrc=$link\">Use As Background</a><br/>";
         echo "<a href=\"usergallery.php?show=del&amp;hits=$hits&amp;who=$who&amp;whoimage=$id\">Delete Picture</a></div>";
        }else{
 echo "You Cant Use This Tool!</div></div>";
 }
}
}else{
 echo "Database Error!!</div></div>";
 }
 echo "<div class=\"box_cen\" align=\"center\">";
 echo "<div class=\"box_sub\" align=\"center\">";
   echo "<a href=\"usergallery.php?show=main&amp;hits=$hits\">Gallery</a></div></div>";
 echo footerweb($hits);
  echo "</body>";

}
else if($show=="addinfoact")
{
   addonline(getuid_hits($hits),"Adding Pic Info","");
   $who = $_GET["who"];
   $id = $_GET["id"];
   $info = $_POST["info"];
   $type = $_POST["type"];
           echo "<head>";
  echo "<title>RemiXchaT.CoM - World Wide Chat Community And Downloads !</title>";
  include("inc/css.inc.php");
 echo "</head>";
 echo "<body>";
  echo "<div class=\"box_cen\" align=\"center\">";
 echo "<b>Update Info</b>";
  echo "<div class=\"box_sub\" align=\"center\">";
   $uid = getuid_hits($hits);
   $res = mysql_query("UPDATE mx_usergallery SET info='".$info."', type='".$type."' WHERE id='".$id."'");

        if((ismod($uid))||($uid==$who))
    	{

   if($res){
   
     echo "<img src=\"images/ok.gif\" alt=\"o\"/>Pic Update Successfully";
   }else{
     echo "<img src=\"images/notok.gif\" alt=\"x\"/>Error Updating Pic Info";
   }
 }else{
     echo "<img src=\"images/notok.gif\" alt=\"x\"/>Error Updating Pic Info";
 }
    echo "</div></div>"; 
 echo "<div class=\"box_cen\" align=\"center\">";
 echo "<div class=\"box_sub\" align=\"center\">";
   echo "<a href=\"usergallery.php?show=main&amp;hits=$hits\">Gallery</a></div></div>";
 echo footerweb($hits);
  echo "</body>";
}

 else if($show=="del")
 {
    $who = $_GET["who"];
  echo "<head>";
  echo "<title>RemiXchaT.CoM - World Wide Chat Community And Downloads !</title>";
  include("inc/css.inc.php");
 echo "</head>";
 echo "<body>";
  echo "<div class=\"box_cen\" align=\"center\">";
 echo "<b>Delete Image</b>";
  echo "<div class=\"box_sub\" align=\"center\">";
 $link = mysql_fetch_array(mysql_query("SELECT imageurl FROM mx_usergallery WHERE id='".$whoimage."'"));
    $res = unlink("$link[0]");
    $res = mysql_query("DELETE FROM mx_usergallery WHERE id='".$whoimage."'");
    $res = mysql_query("DELETE FROM mx_usergallery_rating WHERE gbowner='".$whoimage."'");
      

        if($res)
      {
        echo "<img src=\"images/ok.gif\" alt=\"O\"/>Photo and all the Comments have been deleted";
      }else{
        echo "<img src=\"images/notok.gif\" alt=\"X\"/>Error deleting Photo";
      }

  echo "</div></div>";
 echo footerweb($hits);
      echo "</body>";
}else{
       echo "<head>";
  echo "<title>RemiXchaT.CoM - World Wide Chat Community And Downloads !</title>";
  include("inc/css.inc.php");
 echo "</head>";
 echo "<body>";
   echo getpagerror();
   echo "</body>";
}

?></html>