the ibwf_blogs table is fine, its got all the required fields, yet I or any member of my site is unable to post any blog. It gives XError Posting Message, why is that so ?
Plz can som1 help me?? The Table structure is ::::::
--
-- Table structure for table `ibwf_blogs`
--
CREATE TABLE `ibwf_blogs` (
`id` int(100) NOT NULL auto_increment,
`bowner` int(100) NOT NULL default '0',
`bname` varchar(30) NOT NULL default '',
`btext` blob NOT NULL,
`bgdate` int(100) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `bname` (`bname`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
And the code is
<div class='codetop'>CODE</div><div class='codemain' style='height:200px;white-space:pre;overflow:auto'>
else if($action=="addblg")
{
echo "<head>\n";
echo "<title>Rock-On</title>\n";
echo "<link rel=\"StyleSheet\" type=\"text/css\" href=\"style/$theme[0]\" />";
echo "<meta http-equiv=\"Cache-Control\" content=\"must-revalidate\" />\n";
echo "<meta http-equiv=\"Cache-Control\" content=\"no-cache\" />\n";
echo "<meta http-equiv=\"Pragma\" content=\"no-cache\" />\n";
echo "</head>";
echo "<body>";
if(!getplusses(getuid_sid($sid))>50)
{
echo "<p align=\"center\">";
echo "Only 50+ plusses can add blogs
";
echo "<a href=\"index.php?action=main&sid=$sid\">Home</a>";
echo "</p>";
echo "</card>";
echo "</wml>";
exit();
}
$msgtxt = $_POST["btitle"];
$msgtxt = $_POST["msgtxt"];
$qut = $_POST["qut"];
addonline(getuid_sid($sid),"Adding a blog","");
echo "<card id=\"main\" title=\"rock-on.mobi\">";
echo "<p align=\"center\">";
$crdate = $time;
$uid = getuid_sid($sid);
$ress = false;
if((trim($msgtxt)!="")&&(trim($btitle)!=""))
{
$ress = mysql_query("INSERT INTO ibwf_blogs SET bowner='".$uid."', bname='".$btitle."', bgdate='".$crdate."', btext='".$msgtxt."'");
}
if($ress)
{
$cow = mysql_fetch_array(mysql_query("SELECT plusses FROM ibwf_users WHERE id='".$uid."'"));
$cow = $cow[0]+10;
mysql_query("UPDATE ibwf_users SET plusses='".$cow."' WHERE id='".$uid."'");
echo "<img src=\"images/ok.gif\" alt=\"O\"/>Message Posted Successfully";
}
else{
echo "<img src=\"images/notok.gif\" alt=\"X\"/>Error Posting Message";
}
echo "
";
echo "<a href=\"index.php?action=main&sid=$sid\"><img src=\"images/home.gif\" alt=\"*\"/>";
echo "Home</a>";
echo "</p>";
echo "</body>";
echo "</html>";
exit();
}
</div>
Plz can som1 help me?? The Table structure is ::::::
--
-- Table structure for table `ibwf_blogs`
--
CREATE TABLE `ibwf_blogs` (
`id` int(100) NOT NULL auto_increment,
`bowner` int(100) NOT NULL default '0',
`bname` varchar(30) NOT NULL default '',
`btext` blob NOT NULL,
`bgdate` int(100) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `bname` (`bname`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
And the code is
<div class='codetop'>CODE</div><div class='codemain' style='height:200px;white-space:pre;overflow:auto'>
else if($action=="addblg")
{
echo "<head>\n";
echo "<title>Rock-On</title>\n";
echo "<link rel=\"StyleSheet\" type=\"text/css\" href=\"style/$theme[0]\" />";
echo "<meta http-equiv=\"Cache-Control\" content=\"must-revalidate\" />\n";
echo "<meta http-equiv=\"Cache-Control\" content=\"no-cache\" />\n";
echo "<meta http-equiv=\"Pragma\" content=\"no-cache\" />\n";
echo "</head>";
echo "<body>";
if(!getplusses(getuid_sid($sid))>50)
{
echo "<p align=\"center\">";
echo "Only 50+ plusses can add blogs
";
echo "<a href=\"index.php?action=main&sid=$sid\">Home</a>";
echo "</p>";
echo "</card>";
echo "</wml>";
exit();
}
$msgtxt = $_POST["btitle"];
$msgtxt = $_POST["msgtxt"];
$qut = $_POST["qut"];
addonline(getuid_sid($sid),"Adding a blog","");
echo "<card id=\"main\" title=\"rock-on.mobi\">";
echo "<p align=\"center\">";
$crdate = $time;
$uid = getuid_sid($sid);
$ress = false;
if((trim($msgtxt)!="")&&(trim($btitle)!=""))
{
$ress = mysql_query("INSERT INTO ibwf_blogs SET bowner='".$uid."', bname='".$btitle."', bgdate='".$crdate."', btext='".$msgtxt."'");
}
if($ress)
{
$cow = mysql_fetch_array(mysql_query("SELECT plusses FROM ibwf_users WHERE id='".$uid."'"));
$cow = $cow[0]+10;
mysql_query("UPDATE ibwf_users SET plusses='".$cow."' WHERE id='".$uid."'");
echo "<img src=\"images/ok.gif\" alt=\"O\"/>Message Posted Successfully";
}
else{
echo "<img src=\"images/notok.gif\" alt=\"X\"/>Error Posting Message";
}
echo "
";
echo "<a href=\"index.php?action=main&sid=$sid\"><img src=\"images/home.gif\" alt=\"*\"/>";
echo "Home</a>";
echo "</p>";
echo "</body>";
echo "</html>";
exit();
}
</div>
Comment