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&rid=$room[0]\">$room[1]($noi[0])</a><br/>";
/*}*/
}
echo "<br/>";