Estrarre immagine dal database

[Leviathan73]

e con queste funzioni?

/////////////////////////////////////////////Chat Tools



function addchatmsg($uid,$msg,$admin,$errormsg)

{

  $user = mysql_query("SELECT id, name, perm, pic FROM ibwf_users WHERE id='".$uid."'");

  while($row=mysql_fetch_array($user))

  {

  if(($admin==0)||($admin==1)&&(ismod($uid)))

  {

  $nick=getnick_uid($uid);

  $link = "[b]$nick [i]*$msg*[/i][/b]
";

  }else{

  $link = "[b]Chat System:» [i]*Hey! ".getnick_uid($uid).", Non è possibile utilizzare questro Strumento!*[/i][/b]
";

  }

  }

  if($errormsg!="")

  {

  $link = "[b]Chat System:» [i]$errormsg[/i][/b]
";

  }

  return $link;

}
///////////////////clear data





function cleardata()

{

  $timeto = 300;

  $timenw = time();

  $timeout = $timenw - $timeto;

  $exec = mysql_query("DELETE FROM ibwf_chonline WHERE lton<'".$timeout."'");

  $timeto = 200;

  $timenw = time();

  $timeout = $timenw - $timeto;

  $exec = mysql_query("DELETE FROM ibwf_chat WHERE timesent<'".$timeout."'");

  $timeto = 60*60;

  $timenw = time();

  $timeout = $timenw - $timeto;

  $exec = mysql_query("DELETE FROM ibwf_search WHERE stime<'".$timeout."'");

  

  ///delete expired rooms

  $timeto = 5*60;

  $timenw = time();

  $timeout = $timenw - $timeto;

  $rooms = mysql_query("SELECT id FROM ibwf_rooms WHERE static='0' AND lastmsg<'".$timeout."'");

  while ($room=mysql_fetch_array($rooms))

  {

    $ppl = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_chonline WHERE rid='".$room[0]."'"));

    if($ppl[0]==0)

    {

        $exec = mysql_query("DELETE FROM ibwf_rooms WHERE id='".$room[0]."'");

    }

  }

  $lbpm = mysql_fetch_array(mysql_query("SELECT value FROM ibwf_settings WHERE name='lastbpm'"));

  $td = date("Y-m-d");

  //echo $lbpm[0];

  

  if ($td!=$lbpm[0])

  {

    //echo "boo";

    $sql = "SELECT id, name, birthday  FROM ibwf_users where month(`birthday`) = month(curdate()) and dayofmonth(`birthday`) = dayofmonth(curdate())";

    $ppl = mysql_query($sql);

    while($mem = mysql_fetch_array($ppl))

    {

        $msg = "[card=008]to you $mem[1]"."[/card] $sitename team wish you a day full of joy and happiness and many happy returns[br/]*fireworks*[br/][small][i]p.s: this is an automated pm[/i][/small]";

        autopm($msg, $mem[0]);

    }

    mysql_query("UPDATE ibwf_settings SET value='".$td."' WHERE name='lastbpm'");

  }

  

}

///////////////////////////////////////Add to chat



function addtochat($uid, $rid)

{
  $bago = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_chonline WHERE uid='".$uid."' AND rid='".$rid."'"));
if($bago[0]==0){
$msg = "*mat Enter the Room";
mysql_query("INSERT INTO ibwf_chat SET timesent='".time()."', chatter='".$uid."', text='".$msg."'");
}

  $timeto = 45;

  $timenw = time();

  $timeout = $timenw - $timeto;

  //$exec = mysql_query("DELETE FROM ibwf_chonline WHERE lton<'".$timeout."'");

  $res = mysql_query("INSERT INTO ibwf_chonline SET lton='".time()."', uid='".$uid."', rid='".$rid."'");

  if(!$res)
  if($counter<15)

  {
    
    mysql_query("UPDATE ibwf_chonline SET lton='".time()."', rid='".$rid."' WHERE uid='".$uid."'");

  }

} 

[Dascos]

Guarda, detto sinceramente per risolvere il problema specifico o si individua esattamente dove vengono recuperate le immagini per la chat, oppure è inutile procedere "a tentoni"..

[Leviathan73]

ecco qua.. l'immagine sta fuori questa stanza privata, anzichè stare dentro la stanza, e ci vuole la query

echo "[b]2 [/b]<a accesskey=\"2\" href=\"index.php?action=mkroom&amp;sid=$sid\">Crea Stanza</a>

";
$rooms = mysql_query("SELECT id, name, pass, pic FROM ibwf_rooms WHERE static='0'"); 
$co = 0;  
while ($room = mysql_fetch_array($rooms)) 
{ 
    $ilink = trim($room[3]); 
    if ($ilink == "") 
    { 
        echo "<img src=\"../images/logo.gif\" alt=\"*\"/>
"; 
    } else { 
        echo "<img src=\"{$ilink}\" width=\"100\" height=\"100\" alt=\"*\"/>
";
    
     } 
  
 
            $co++;
          if(canenter($room[0], $sid))
          {
            $noi = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_chonline WHERE rid='".$room[0]."'"));
            if($room[2]=="")
            {
            echo "<a href=\"chat.php?sid=$sid&amp;rid=$room[0]\">".htmlspecialchars($room[1])."($noi[0])</a>
";
            }else{
echo htmlspecialchars($room[1]);


              //echo "($noi[0])";
echo "<form action=\"chat.php\" method=\"get\">";
              echo "
<input format=\"*x\" name=\"rpw\" maxlength=\"10\"/>
";
echo "<input type=\"submit\" value=\"GO\"/>";
              echo "<input type=\"hidden\" name=\"rid\" value=\"$room[0]\"/>";
              echo "<input type=\"hidden\" name=\"sid\" value=\"$sid\"/>";
              echo "</form>";
            }
          }
        } 

[Dascos]

Ok...macosa significa "fuori" e cosa "dentro"?

[Leviathan73]

Che quando crei una stanza e ci inserisci un immagine, spunta l'immagine, e sotto il nome della stanza che hai creato, clicchi nel nome della stanza, ci entri, e l'immagine non c'è perchè sta fuori..

[Leviathan73]

la query è questa ma non so deve metterla

$pic = mysql_escape_string($_POST["pic"]); 
$pic = htmlspecialchars($pic); 
        $res = mysql_query("INSERT INTO ibwf_rooms SET name='".$rname."', pass='".$rpass."', censord='".$cns."', static='0', lastmsg='".time()."', pic='".$pic."'");