Here are the code to add folders to ur inbox
inbox.php
action=main
anywhere in the inbox.php
at this in
else if($action=="readpm")
sql
inbox.php
action=main
Code:
$readpmnotinfolder = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_private WHERE touid='".$uid."' AND unread='0' AND folderid='0'"));
echo "<img src=\"mailbox_full.gif\" alt=\"*\"/><a href=\"inbox.php?action=folderunread&sid=$sid\">New</a>($umsg)<br/>";
echo "<img src=\"mailbox_empty.gif\" alt=\"*\"/><a href=\"inbox.php?action=folderread&sid=$sid\">Old</a>($readpmnotinfolder[0])<br/><br/>";
$sql = "SELECT foldername, folderid FROM ibwf_private_folders WHERE uid='".$uid."' ORDER BY foldername DESC";
$items = mysql_query($sql);
echo mysql_error();
if(mysql_num_rows($items)>0)
{
while ($item = mysql_fetch_array($items))
{
$noi = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_private WHERE touid='".$uid."' AND folderid='".$item[1]."'"));
$lnk = "<img src=\"mailbox_folder.gif\" alt=\"*\"/><a href=\"inbox.php?action=folder&folderid=$item[1]&sid=$sid\">$item[0]</a>($noi[0])";
echo "$lnk<br/>";
}
}
echo "<a href=\"inbox.php?action=crfolder&sid=$sid\">*Create New Folder*</a><br/>";
Code:
else if($action=="renamefolder")
{
addonline(getuid_sid($sid),"Renaming PM Folder","");
echo "<head>\n";
echo "<title>$stitle</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>";
echo "<p align=\"center\">";
$folderid = $_GET["fid"];
$foldername = mysql_fetch_array(mysql_query("SELECT foldername FROM ibwf_private_folders WHERE folderid='".$folderid."'"));
echo "Renaming Folder: $foldername[0]<br/><br/>";
echo "<form action=\"inbox.php?action=rnamefdone&sid=$sid\" method=\"post\">";
echo "New Folder Name: <input name=\"newname\" format=\"*x\" maxlength=\"25\"/><br/>";
echo "<input type=\"hidden\" name=\"fid\" value=\"$folderid\"/>";
echo "<input type=\"submit\" value=\"Rename\"/>";
echo "</form>";
echo "<br/><br/>";
echo "<a href=\"inbox.php?action=main&sid=$sid\">«Back to Inbox</a><br/>";
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();
}
else if($action=="rnamefdone")
{
addonline(getuid_sid($sid),"Renaming PM Folder","");
echo "<head>\n";
echo "<title>$stitle</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>";
$folderid = $_POST["fid"];
$newname = $_POST["newname"];
echo "<p align=\"center\">";
$res = mysql_query("UPDATE ibwf_private_folders SET foldername='".$newname."' WHERE folderid='".$folderid."'");
if($res)
{
echo "<img src=\"images/ok.gif\" alt=\"O\"/>Folder Renamed Successfully<br/><br/>";
}else{
echo "<img src=\"images/notok.gif\" alt=\"O\"/>Rename Error!<br/><br/>";
}
echo "<br/><br/>";
echo "<a href=\"inbox.php?action=main&sid=$sid\">«Back to Inbox</a><br/>";
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();
}
else if($action=="delfolder")
{
addonline(getuid_sid($sid),"Deleting PM Folder","");
echo "<head>\n";
echo "<title>$stitle</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>";
echo "<p align=\"center\">";
$folderid = $_POST["fid"];
$res = mysql_query("DELETE FROM ibwf_private_folders WHERE folderid='".$folderid."'");
$sql = "SELECT folderid FROM ibwf_private WHERE folderid='".$folderid."'";
$items = mysql_query($sql);
echo mysql_error();
if(mysql_num_rows($items)>0)
{
while ($item = mysql_fetch_array($items))
{
$sql = mysql_query("UPDATE ibwf_private SET folderid='0' WHERE folderid='".$folderid."'");
}
}
if($res)
{
echo "<img src=\"images/ok.gif\" alt=\"O\"/>Folder Deleted Successfully<br/><br/>";
}else{
echo "<img src=\"images/notok.gif\" alt=\"O\"/>Delete Error!<br/><br/>";
}
echo "<br/><br/>";
echo "<a href=\"inbox.php?action=main&sid=$sid\">«Back to Inbox</a><br/>";
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();
}
else if($action=="folderread")
{
addonline(getuid_sid($sid),"User Inbox","");
echo "<head>\n";
echo "<title>$stitle</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>";
echo "<p align=\"center\">";
echo "Read";
echo "</p>";
$view = $_GET["view"];
//////ALL LISTS SCRIPT <<
if($view=="")$view="all";
if($page=="" || $page<=0)$page=1;
$myid = getuid_sid($sid);
$doit=false;
$noi = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_private WHERE touid='".$uid."' AND unread='0'"));
$num_items = $noi[0]; //changable
$items_per_page= 7;
$num_pages = ceil($num_items/$items_per_page);
if($page>$num_pages)$page= $num_pages;
$limit_start = ($page-1)*$items_per_page;
if($num_items>0)
{
if($doit)
{
$exp = "&rwho=$myid";
}else
{
$exp = "";
}
//changable sql
$sql = "SELECT
a.name, b.id, b.byuid, b.unread, b.starred FROM ibwf_users a
INNER JOIN ibwf_private b ON a.id = b.byuid
WHERE b.touid='".$myid."' AND b.unread='0'
ORDER BY b.timesent DESC
LIMIT $limit_start, $items_per_page
";
echo "<div class=\"mblock1\">";
echo "<small>";
$items = mysql_query($sql);
echo mysql_error();
while ($item = mysql_fetch_array($items))
{
if($item[3]=="1")
{
$iml = "<img src=\"images/npm.gif\" alt=\"+\"/>";
}else{
if($item[4]=="1")
{
$iml = "<img src=\"images/spm.gif\" alt=\"*\"/>";
}else{
$iml = "<img src=\"images/opm.gif\" alt=\"-\"/>";
}
}
$lnk = "<a href=\"inbox.php?action=readpm&pmid=$item[1]&sid=$sid\">$iml $item[0]</a>";
echo "$lnk<br/>";
}
echo "</small>";
echo "</div>";
echo "<p align=\"center\">";
$npage = $page+1;
echo "<a href=\"inbox.php?action=sendto&sid=$sid\">Send to</a><br/>";
if($page>1)
{
$ppage = $page-1;
echo "<a href=\"inbox.php?action=folderread&page=$ppage&sid=$sid&view=$view$exp\">«Prev</a> ";
}
if($page<$num_pages)
{
$npage = $page+1;
echo "<a href=\"inbox.php?action=folderread&page=$npage&sid=$sid&view=$view$exp\">Next»</a>";
}
echo "<br/>$page/$num_pages<br/>";
if($num_pages>2)
{
$rets = "<form action=\"inbox.php\" method=\"get\">";
$rets .= "Jump to page: <input name=\"page\" format=\"*N\" size=\"3\"/><br/>";
$rets .= "<input type=\"submit\" value=\"GO\"/>";
$rets .= "<input type=\"hidden\" name=\"action\" value=\"$action\"/>";
$rets .= "<input type=\"hidden\" name=\"sid\" value=\"$sid\"/>";
$rets .= "<input type=\"hidden\" name=\"view\" value=\"$view\"/>";
$rets .= "</form>";
echo $rets;
}
echo "<br/>";
echo "</p>";
}else{
echo "<p align=\"center\">";
echo "You have no Private Messages<br/>";
echo "</p>";
}
////// UNTILL HERE >>
echo "<p align=\"center\">";
echo "<a href=\"inbox.php?action=main&sid=$sid\">«Back to Inbox</a><br/>";
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();
}
else if($action=="folderunread")
{
addonline(getuid_sid($sid),"User Inbox","");
echo "<head>\n";
echo "<title>$stitle</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>";
echo "<p align=\"center\">";
echo "Unread Mail";
echo "</p>";
$view = $_GET["view"];
//////ALL LISTS SCRIPT <<
if($view=="")$view="all";
if($page=="" || $page<=0)$page=1;
$myid = getuid_sid($sid);
$doit=false;
$noi = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_private WHERE touid='".$uid."' AND unread='1'"));
$num_items = $noi[0]; //changable
$items_per_page= 7;
$num_pages = ceil($num_items/$items_per_page);
if($page>$num_pages)$page= $num_pages;
$limit_start = ($page-1)*$items_per_page;
if($num_items>0)
{
if($doit)
{
$exp = "&rwho=$myid";
}else
{
$exp = "";
}
//changable sql
$sql = "SELECT
a.name, b.id, b.byuid, b.unread, b.starred FROM ibwf_users a
INNER JOIN ibwf_private b ON a.id = b.byuid
WHERE b.touid='".$myid."' AND b.unread='1'
ORDER BY b.timesent DESC
LIMIT $limit_start, $items_per_page
";
echo "<div class=\"mblock1\">";
echo "<small>";
$items = mysql_query($sql);
echo mysql_error();
while ($item = mysql_fetch_array($items))
{
if($item[3]=="1")
{
$iml = "<img src=\"images/npm.gif\" alt=\"+\"/>";
}else{
if($item[4]=="1")
{
$iml = "<img src=\"images/spm.gif\" alt=\"*\"/>";
}else{
$iml = "<img src=\"images/opm.gif\" alt=\"-\"/>";
}
}
$lnk = "<a href=\"inbox.php?action=readpm&pmid=$item[1]&sid=$sid\">$iml $item[0]</a>";
echo "$lnk<br/>";
}
echo "</small>";
echo "</div>";
echo "<p align=\"center\">";
$npage = $page+1;
echo "<a href=\"inbox.php?action=sendto&sid=$sid\">Send to</a><br/>";
if($page>1)
{
$ppage = $page-1;
echo "<a href=\"inbox.php?action=folderunread&page=$ppage&sid=$sid&view=$view$exp\">«Prev</a> ";
}
if($page<$num_pages)
{
$npage = $page+1;
echo "<a href=\"inbox.php?action=folderunread&page=$npage&sid=$sid&view=$view$exp\">Next»</a>";
}
echo "<br/>$page/$num_pages<br/>";
if($num_pages>2)
{
$rets = "<form action=\"inbox.php\" method=\"get\">";
$rets .= "Jump to page: <input name=\"page\" format=\"*N\" size=\"3\"/><br/>";
$rets .= "<input type=\"submit\" value=\"GO\"/>";
$rets .= "<input type=\"hidden\" name=\"action\" value=\"$action\"/>";
$rets .= "<input type=\"hidden\" name=\"sid\" value=\"$sid\"/>";
$rets .= "<input type=\"hidden\" name=\"view\" value=\"$view\"/>";
$rets .= "</form>";
echo $rets;
}
echo "<br/>";
echo "<form action=\"inbxproc.php?action=proall&sid=$sid\" method=\"post\">";
echo "Delete: <select name=\"pmact\">";
echo "<option value=\"ust\">Unstarred</option>";
echo "<option value=\"red\">Read</option>";
echo "<option value=\"all\">All</option>";
echo "</select>";
echo "<input type=\"Submit\" Name=\"GO\" value=\"Delete!\"></form>";
echo "</p>";
}else{
echo "<p align=\"center\">";
echo "You have no Private Messages<br/>";
echo "<a href=\"inbox.php?action=sendto&sid=$sid\">Send PM</a><br/>";
echo "</p>";
}
////// UNTILL HERE >>
echo "<p align=\"center\">";
echo "<a href=\"inbox.php?action=main&sid=$sid\">«Back to Inbox</a><br/>";
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();
}
else if($action=="folder")
{
addonline(getuid_sid($sid),"User Inbox","");
echo "<head>\n";
echo "<title>$stitle</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>";
$folderid = $_GET["folderid"];
$foldername = mysql_fetch_array(mysql_query("SELECT foldername FROM ibwf_private_folders WHERE folderid='".$folderid."'"));
echo "<p align=\"center\">";
echo "Folder $foldername[0]";
echo "</p>";
//////ALL LISTS SCRIPT <<
if($view=="")$view="all";
if($page=="" || $page<=0)$page=1;
$myid = getuid_sid($sid);
$doit=false;
$noi = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_private WHERE touid='".$uid."' AND folderid='".$folderid."'"));
$num_items = $noi[0]; //changable
$items_per_page= 10;
$num_pages = ceil($num_items/$items_per_page);
if($page>$num_pages)$page= $num_pages;
$limit_start = ($page-1)*$items_per_page;
if($num_items>0)
{
if($doit)
{
$exp = "&rwho=$myid";
}else
{
$exp = "";
}
//changable sql
$sql = "SELECT
a.name, b.id, b.byuid, b.unread, b.starred, folderid FROM ibwf_users a
INNER JOIN ibwf_private b ON a.id = b.byuid
WHERE b.touid='".$myid."' AND folderid='".$folderid."'
ORDER BY b.timesent DESC
LIMIT $limit_start, $items_per_page
";
echo "<div class=\"mblock1\">";
echo "<small>";
$items = mysql_query($sql);
echo mysql_error();
while ($item = mysql_fetch_array($items))
{
if($item[3]=="1")
{
$iml = "<img src=\"images/npm.gif\" alt=\"+\"/>";
}else{
if($item[4]=="1")
{
$iml = "<img src=\"images/spm.gif\" alt=\"*\"/>";
}else{
$iml = "<img src=\"images/opm.gif\" alt=\"-\"/>";
}
}
$lnk = "<a href=\"inbox.php?action=readpm&pmid=$item[1]&sid=$sid\">$iml $item[0]</a>";
echo "$lnk<br/>";
}
echo "<br/>";
echo "</small>";
echo "<div align=\"center\">\n";
echo "<form action=\"inbxproc.php?action=proall&sid=$sid\" method=\"post\">";
echo "Delete: <select name=\"pmact\">";
echo "<option value=\"ust\">Unstarred</option>";
echo "<option value=\"red\">Read</option>";
echo "<option value=\"all\">All</option>";
echo "</select>";
echo "<input type=\"Submit\" Name=\"GO\" value=\"Delete!\"></form>";
echo "<small><a href=\"inbox.php?action=delfolder&fid=$folderid&sid=$sid\">Delete Folder</a></small><br/>";
echo "<small><a href=\"inbox.php?action=renamefolder&fid=$folderid&sid=$sid\">Rename Folder</a></small>";
echo "</div>";
echo "<p align=\"center\">";
$npage = $page+1;
echo "<a href=\"inbox.php?action=sendto&sid=$sid\">Send to</a><br/>";
if($page>1)
{
$ppage = $page-1;
echo "<a href=\"inbox.php?action=main&page=$ppage&sid=$sid&view=$view$exp\">«Prev</a> ";
}
if($page<$num_pages)
{
$npage = $page+1;
echo "<a href=\"inbox.php?action=main&page=$npage&sid=$sid&view=$view$exp\">Next»</a>";
}
echo "<br/>$page/$num_pages<br/>";
if($num_pages>2)
{
$rets = "<form action=\"inbox.php\" method=\"get\">";
$rets .= "Jump to page: <input name=\"page\" format=\"*N\" size=\"3\"/><br/>";
$rets .= "<input type=\"submit\" value=\"GO\"/>";
$rets .= "<input type=\"hidden\" name=\"action\" value=\"$action\"/>";
$rets .= "<input type=\"hidden\" name=\"sid\" value=\"$sid\"/>";
$rets .= "<input type=\"hidden\" name=\"view\" value=\"$view\"/>";
$rets .= "</form>";
echo $rets;
}
echo "<br/>";
echo "</p>";
}else{
echo "<p align=\"center\">";
echo "You have no Private Messages<br/>";
echo "<a href=\"inbox.php?action=sendto&sid=$sid\">Send PM</a><br/>";
echo "</p>";
}
////// UNTILL HERE >>
echo "<p align=\"center\">";
echo "<a href=\"inbox.php?action=main&sid=$sid\">«Back to Inbox</a><br/>";
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();
}
else if($action=="crfolder")
{
addonline(getuid_sid($sid),"Creating Folder","");
echo "<head>\n";
echo "<title>$stitle</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>";
echo "<p align=\"center\">";
echo "<form method=\"post\" action=\"inbox.php?action=crfolderdone&sid=$sid\">";
echo "Folder Name: <input name=\"fname\" maxlength=\"25\"/><br/>";
echo "<input type=\"submit\" name=\"Submit\" value=\"Create\"/>";
echo "</form><br/>";
echo "<a href=\"inbox.php?action=main&sid=$sid\">«Back to Inbox</a><br/>";
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();
}
else if($action=="crfolderdone")
{
addonline(getuid_sid($sid),"Creating Folder","");
echo "<head>\n";
echo "<title>$stitle</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>";
echo "<p align=\"center\">";
$fname = $_POST["fname"];
$uid = getuid_sid($sid);
$reg = mysql_query("INSERT INTO ibwf_private_folders SET uid='".$uid."', foldername='".$fname."'");
if($reg)
{
echo "<img src=\"images/ok.gif\" alt=\"O\"/>Folder Created Successfully<br/><br/>";
}else{
echo "<img src=\"images/notok.gif\" alt=\"X\"/>Error Creating Folder<br/><br/>";
}
echo "<a href=\"inbox.php?action=main&sid=$sid\">«Back to Inbox</a><br/>";
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();
}
else if($action=="movetofolder")
{
addonline(getuid_sid($sid),"Moving PM to Folder","");
echo "<head>\n";
echo "<title>$stitle</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>";
echo "<p align=\"center\">";
$movetof = $_POST["movetof"];
$pmid = $_POST["pmid"];
$uid = getuid_sid($sid);
$str = mysql_query("UPDATE ibwf_private SET folderid='".$movetof."' WHERE id='".$pmid."' ");
if($str)
{
echo "<img src=\"images/ok.gif\" alt=\"O\"/>PM moved successfully<br/><br/>";
}else{
echo "<img src=\"images/notok.gif\" alt=\"X\"/>Can't move PM at the moment<br/><br/>";
}
echo "<a href=\"inbox.php?action=main&sid=$sid\">«Back to Inbox</a><br/>";
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();
}
at this in
else if($action=="readpm")
Code:
echo "<form action=\"inbox.php?action=movetofolder&sid=$sid\" method=\"post\">";
$uid = getuid_sid($sid);
echo "Move To: <select name=\"movetof\">";
$foldername = mysql_query("SELECT folderid, foldername FROM ibwf_private_folders WHERE uid='".$uid."'");
while ($items = mysql_fetch_array($foldername))
{
echo "<option value=\"$items[0]\">".htmlspecialchars($items[1])."</option>";
}
echo "</select>";
echo "<input type=\"hidden\" name=\"pmid\" value=\"$pmid\"/>";
echo "<input type=\"submit\" value=\"Move\"/>";
echo "</form>";
Code:
-- -- Table structure for table `ibwf_private` -- CREATE TABLE IF NOT EXISTS `ibwf_private` ( `id` int(100) NOT NULL auto_increment, `text` blob NOT NULL, `byuid` int(100) NOT NULL default '0', `touid` int(100) NOT NULL default '0', `unread` char(1) NOT NULL default '1', `timesent` int(100) NOT NULL default '0', `starred` char(1) NOT NULL default '0', `reported` char(1) NOT NULL default '0', `folderid` int(100) NOT NULL default '0', `title` blob NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=509 ; -- -- Dumping data for table `ibwf_private` -- -- -- Table structure for table `ibwf_private_folders` -- CREATE TABLE IF NOT EXISTS `ibwf_private_folders` ( `folderid` int(100) NOT NULL auto_increment, `uid` int(100) NOT NULL default '0', `foldername` varchar(250) NOT NULL default '', PRIMARY KEY (`folderid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Dumping data for table `ibwf_private_folders` --

Comment