Extrapolating from the image database

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Extrapolating from the image database

    Hello I posted a picture in the database, but the chat room can not see, put the query to extract the image from the database .. where am I wrong?
    PHP Code:
    //////////////////////////
    else if($action=="addchr")
    {
      $chrnm = $_POST["chrnm"];
      $pic = $_POST["pic"];
      $pic = mysql_fetch_array(mysql_query("SELECT pic FROM ibwf_rooms WHERE name='pic'"));
      $chrage = $_POST["chrage"];
      $maxage = $_POST["maxage"];
      $chrpst = $_POST["chrpst"];
      $chrprm = $_POST["chrprm"];
      $chrcns = $_POST["chrcns"];
      $chrfun = $_POST["chrfun"];
          echo "<head>";
          echo "<title>Admin Tools</title>";
          echo "<link rel=\"stylesheet\" type=\"text/css\" href=\"../themes/$theme[0]\">";
          echo "</head>";
          echo "<body>";
          echo "<p align=\"center\">";
      if(!isadmin(getuid_sid($sid)))
      {
      echo "Permission Denied!";
      }else{
            echo $chrnm;
            echo "<br/>";
            $pic = mysql_fetch_array(mysql_query("SELECT pic FROM ibwf_rooms WHERE name='pic'"));
            $res = mysql_fetch_array (mysql_query("INSERT INTO ibwf_rooms SET name='".$chrnm."', pic='".$pic."', static='1', pass='', mage='".$chrage."', maxage='".$maxage."', chposts='".$chrpst."', perms='".$chrprm."', censord='".$chrcns."' , freaky='".$chrfun."'"));
    echo mysql_error();
            if($res)
          {
            echo "<img src=\"../images/ok.gif\" alt=\"O\"/>Chatroom added successfully";
          }else{
            echo "<img src=\"../images/notok.gif\" alt=\"X\"/>Error adding Chat room";
          }
          } 
    
    PHP Code:
    else if ($action=="chat")
               {
    $pic = $_POST["pic"];
      $mmsg = htmlspecialchars(getsetmood(getuid_sid($sid)));
            addonline(getuid_sid($sid),"รจ nella lista delle Chatroom ($mmsg)","index.php?action=chat");
            echo "<head>";
            echo "<title>Lista Chatroom</title>";
            echo "<link rel=\"stylesheet\" type=\"text/css\" href=\"../themes/$theme[0]\">";
            echo "</head>";
            echo "<body>";
            echo "<p align=\"center\">";
            echo "<img src=\"../images/chat3.gif\" alt=\"\"/>";
            echo popup($sid);
            echo "<p align=\"center\">";
            $pic = mysql_fetch_array(mysql_query("SELECT pic FROM ibwf_rooms WHERE static='1'"));
            $rooms = mysql_query("SELECT id, name, perms, mage, pic, chposts FROM ibwf_rooms WHERE static='1' AND clubid='0'");
                    while ($room= mysql_fetch_array($rooms))
            {
            }
            $pic = mysql_query("SELECT id, name, pass, pic FROM ibwf_rooms WHERE static='1' AND clubid='0'");
            while ($room= mysql_fetch_array($rooms))
    
            {
              
              /*if(canenter($room[0], $sid))
              {*/
                $noi = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_chonline WHERE rid='".$room[0]."'"));
                echo "<a href=\"chat.php?sid=$sid&amp;rid=$room[0]\">$room[1]($noi[0])</a><br/>";
              /*}*/
              
            }
            echo "<br/>"; 
    
Working...
X