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."'");

  }

}