help me i encountered this error in my add article comment ibwf_cwart' doesnt exist
add article comment error
Collapse
X
-
you will need to post that article code..Originally posted by mhazter View Posthelp me i encountered this error in my add article comment ibwf_cwart' doesnt exist
then some1 may create/post sql tableキノgんイノ刀g 4 ア乇ムc乇 ノ丂 レノズ乇 キucズノ刀g 4 √ノ尺gノ刀ノイリ!It's better to keep your mouth shut and give the impression that you're stupid, than to open it and remove all doubt.
ⓣⓗⓔ ⓠⓤⓘⓔⓣⓔⓡ ⓨⓞⓤ ⓑⓔ©ⓞⓜⓔ, ⓣⓗⓔ ⓜⓞⓡⓔ ⓨⓞⓤ â“â“¡â“” â“ⓑⓛⓔ ⓣⓞ â“—â“”â“â“¡ !
ιη тнєσÑу, тнє ÏÑα¢тι¢є ιѕ α Ñєѕυℓт σƒ тнє тнєσÑу, вυт ιη ÏÑα¢тι¢є ιѕ тнє σÏÏσѕιтє.
-
this is the sql
PHP Code:-- Table structure for table `iwbf_cwart`
--
CREATE TABLE `iwbf_cwart` (
`id` int(255) NOT NULL auto_increment,
`artid` int(255) NOT NULL default '0',
`uid` int(255) NOT NULL default '0',
`text` varchar(255) NOT NULL default '',
`crdate` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=92 DEFAULT CHARSET=latin1 AUTO_INCREMENT=92 ;
Last edited by metulj; 24.04.09, 09:44.
Comment
-
like i said above... you will need to post CODEOriginally posted by mhazter View Postthis is the sql
PHP Code:-- Table structure for table `iwbf_cwart`
--
CREATE TABLE `iwbf_cwart` (
`id` int(255) NOT NULL auto_increment,
`artid` int(255) NOT NULL default '0',
`uid` int(255) NOT NULL default '0',
`text` varchar(255) NOT NULL default '',
`crdate` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=92 DEFAULT CHARSET=latin1 AUTO_INCREMENT=92 ;
and not SQL in order to get this fixedキノgんイノ刀g 4 ア乇ムc乇 ノ丂 レノズ乇 キucズノ刀g 4 √ノ尺gノ刀ノイリ!It's better to keep your mouth shut and give the impression that you're stupid, than to open it and remove all doubt.
ⓣⓗⓔ ⓠⓤⓘⓔⓣⓔⓡ ⓨⓞⓤ ⓑⓔ©ⓞⓜⓔ, ⓣⓗⓔ ⓜⓞⓡⓔ ⓨⓞⓤ â“â“¡â“” â“ⓑⓛⓔ ⓣⓞ â“—â“”â“â“¡ !
ιη тнєσÑу, тнє ÏÑα¢тι¢є ιѕ α Ñєѕυℓт σƒ тнє тнєσÑу, вυт ιη ÏÑα¢тι¢є ιѕ тнє σÏÏσѕιтє.
Comment
-
this is the full code of my article
PHP Code:<?php
/*
Dont u see?
its me russel
*/
//>> »
//<< «
header("Content-type: text/vnd.wap.wml");
header("Cache-Control: no-store, no-cache, must-revalidate");
echo("<?xml version=\"1.0\"?>");
echo "<!DOCTYPE wml PUBLIC \"-//WAPFORUM//DTD WML 1.1//EN\"". " \"http://www.wapforum.org/DTD/wml_1.1.xml\">";
?>
<wml>
<?php
include("config.php");
include("core.php");
$bcon = connectdb();
if (!$bcon)
{
echo "<card id=\"main\" title=\"DATABASE ERROR\">";
echo "<p align=\"center\">";
echo "Backing up database<br/><br/>";
echo "</p>";
echo "</card>";
echo "</wml>";
exit();
}
$action = $_GET["action"];
$sid = $_GET["sid"];
$artid = $_GET["artid"];
$page = $_GET["page"];
$uid = getuid_sid($sid);
if($action != "")
{
if(islogged($sid)==false)
{
echo "<card id=\"main\" title=\"Pinoytribe\">";
echo "<p align=\"left\">";
echo "Your session has been expired<br/>";
echo "UserID: <input name=\"loguid\" format=\"*x\" maxlength=\"30\"/><br/>";
echo "Password: <input type=\"password\" name=\"logpwd\" maxlength=\"30\"/><br/>";
echo "<anchor>LOGIN<go href=\"login.php\" method=\"get\">";
echo "<postfield name=\"loguid\" value=\"$(loguid)\"/>";
echo "<postfield name=\"logpwd\" value=\"$(logpwd)\"/>";
echo "</go></anchor>";
echo "</p>";
echo "</card>";
echo "</wml>";
exit();
}
}
if(isbanned($uid))
{
echo "<card id=\"main\" title=\"PinoyTribe\">";
echo "<p align=\"center\">";
echo "<img src=\"http://coding-talk.com/images/exit2.gif\" alt=\"*\"/><br/>";
echo "You are <b>Banned</b><br/>";
$banto = mysql_fetch_array(mysql_query("SELECT timeto FROM ibwf_penalties WHERE uid='".$uid."' AND penalty='1'"));
$remain = $banto[0]- time();
$rmsg = gettimemsg($remain);
echo "Time to finish your penalty: $rmsg<br/><br/>";
//echo "<a href=\"index.php\">Login</a>";
echo "</p>";
echo "</card>";
echo "</wml>";
exit();
}
if($action=="articles")
{
addonline(getuid_sid($sid),"Articles","index.php?action=$action");
echo "<card id=\"main\" title=\"Articles\">\n";
echo "<p align=\"left\">";
echo "PinoyTribe Articles<br/>";
$fcats = mysql_query("SELECT id, name FROM ibwf_articles ORDER BY id");
while($fcat=mysql_fetch_array($fcats))
{
$noi = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_readart WHERE cid='".$fcat[0]."'"));
$catlink = "• <a href=\"articles.php?action=kindat&sid=$sid&cid=$fcat[0]&browse?\">$fcat[1]($noi[0])</a>";
echo "<br/>$catlink";
}
echo "<br/><a href=\"index.php?action=main&sid=$sid&browse?\">";
echo "Main menu</a>";
echo "</p>";
echo "<p align=\"center\">";
echo "</p>";
echo "</card>\n";
}
//////////////////////////////////ONLINE USERS
else if($action=="newart")
{
$cid = $_GET["cid"];
$artid = $_GET["artid"];
addonline(getuid_sid($sid),"Making new article","index.php?action=$action&fid=$fid");
echo "<card id=\"main\" title=\"New Article\">";
echo "<p align=\"center\">";
if(getchatpost(getuid_sid($sid))<250)
{
echo "<br/>You need 250 chatpost to do this action!<br/>";
}else{
echo "Article name: <input name=\"ntitle\" maxlength=\"60\"/><br/>";
echo "Text: <input name=\"tpctxt\" maxlength=\"300\"/><br/>";
echo "<anchor>SUBMIT";
echo "
<go href=\"articles.php?action=done&sid=$sid&artid=$artid\" method=\"post\">
<postfield name=\"cid\" value=\"$cid\"/>
<postfield name=\"ntitle\" value=\"$(ntitle)\"/>
<postfield name=\"tpctxt\" value=\"$(tpctxt)\"/>
</go>
";
echo "</anchor>";
}
echo "<br/><a href=\"articles.php?action=articles&sid=$sid&browse?\">";
echo "Articles</a><br/>";
echo "<a href=\"index.php?action=main&sid=$sid&browse?\">";
echo "Main menu</a>";
echo "</p>";
echo "</card>";
}
//////////////////////////////////ONLINE USERS
else if($action=="newart2")
{
$artid = $_GET["artid"];
$cid = $_GET["cid"];
$id = $_GET["id"];
addonline(getuid_sid($sid),"Making new article","index.php?action=$action&fid=$fid");
echo "<card id=\"main\" title=\"New Article\">";
echo "<p align=\"left\">";
echo "Details: <input name=\"tpctxt\" maxlength=\"260\"/><br/>";
echo "<anchor>SUBMIT";
echo "
<go href=\"articles.php?action=done2&sid=$sid&artid=$artid&cid=$cid&id=$id\" method=\"post\">
<postfield name=\"tpctxt\" value=\"$(tpctxt)\"/>
</go>
";
echo "</anchor>";
echo "<br/><anchor><refresh><setvar name=\"tpctxt\" value=\"\"/></refresh>ClearText</anchor>";
echo "<br/><a href=\"articles.php?action=articles&sid=$sid&browse?\">";
echo "Articles</a>";
echo "<br/><a href=\"index.php?action=main&sid=$sid&browse?\">";
echo "Main menu</a>";
echo "</p>";
echo "</card>";
}
/////////////////////////////////////////////////////new tops
else if($action=="done")
{
$artid = $_GET["artid"];
$cid = $_POST["cid"];
$ntitle = $_POST["ntitle"];
$tpctxt = $_POST["tpctxt"];
addonline(getuid_sid($sid),"Making New Article","index.php?action=main");
echo "<card id=\"main\" title=\"xtm article\">";
echo "<p align=\"center\">";
$crdate = time();
$uid = getuid_sid($sid);
$texst = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_readart WHERE name LIKE '".$ntitle."' AND cid='".$cid."'"));
if($texst[0]==0)
{
$res = false;
if((trim($ntitle)!="")||(trim($tpctxt)!=""))
{
$res = mysql_query("INSERT INTO ibwf_readart SET name='".$ntitle."', cid='".$cid."', authorid='".$uid."', text='".$tpctxt."', crdate='".$crdate."'");
}
if($res)
{
$tnm = htmlspecialchars($ntitle);
echo "Article <b>$tnm</b> Submitted Successfully<br/>";
}else{
echo "Article could not submit";
}
}else{
echo "Article name Already submitted";
}
echo "<br/><a href=\"articles.php?action=articles&sid=$sid&browse?\">";
echo "Articles</a>";
echo "<br/><a href=\"index.php?action=main&sid=$sid&type=send&browse?start\">";
echo "Main menu</a>";
echo "</p>";
echo "</card>";
}
/////////////////////////////////////////////////////new tops
else if($action=="done2")
{
$artid = $_GET["artid"];
$cid = $_GET["cid"];
$id = $_GET["id"];
$tpctxt = $_POST["tpctxt"];
addonline(getuid_sid($sid),"Making New Article","index.php?action=main");
echo "<card id=\"main\" title=\"PinoyTribe\">";
echo "<p align=\"center\">";
$crdate = time();
$uid = getuid_sid($sid);
$res = mysql_query("INSERT INTO ibwf_artpost SET artid='".$artid."', text='".$tpctxt."', crdate='".time()."'");
if($res)
{
$tnm = htmlspecialchars($ntitle);
echo "Article <b>$tnm</b> Submitted Successfully";
$tid = mysql_fetch_array(mysql_query("SELECT id FROM ibwf_topics WHERE name='".$ntitle."' AND fid='".$fid."'"));
echo "<br/><br/><a href=\"articles.php?action=viewart&sid=$sid&artid=$artid&cid=$cid&id=$id&go=last&type=send&browse?start\">";
echo "Read Article</a>";
}else{
echo "Article could not submit";
}
echo "<br/><a href=\"articles.php?action=articles&sid=$sid&browse?\">";
echo "Articles</a>";
echo "<br/><a href=\"index.php?action=main&sid=$sid&type=send&browse?start\">";
echo "Main menu</a>";
echo "</p>";
echo "</card>";
}
//////////////////////////////////Buddies
else if($action=="kindat")
{
$cid = $_GET["cid"];
$cinfo = mysql_fetch_array(mysql_query("SELECT name from ibwf_articles WHERE id='".$cid."'"));
addonline(getuid_sid($sid),"Viewing article $cinfo[0]","index.php?action=$action&cid=$cid");
$cinfo = mysql_fetch_array(mysql_query("SELECT name from ibwf_articles WHERE id='".$cid."'"));
echo "<card id=\"main\" title=\"$cinfo[0]\">";
echo "<p align=\"left\">";
echo "<b>$cinfo[0]</b>";
$ibwf = mysql_fetch_array(mysql_query("SELECT COUNT(distinct id) FROM ibwf_readart WHERE cid='".$cid."'"));
if($page=="" || $page<=0)$page=1;
$num_items = $ibwf[0]; //changable
$items_per_page= 10;
$num_pages = ceil($num_items/$items_per_page);
if(($page>$num_pages)&&$page!=1)$page= $num_pages;
$limit_start = ($page-1)*$items_per_page;
$cou = $limit_start+1;
////////////////////////////////////////
$ibwfsites = mysql_query("SELECT id, name, crdate FROM ibwf_readart WHERE cid='".$cid."' ORDER BY cid, crdate DESC LIMIT $limit_start, $items_per_page");
while($ibwfsite=mysql_fetch_array($ibwfsites))
{
if (ismod(getuid_sid($sid)))
{
$hm = "<a href=\"articles.php?action=delart1&sid=$sid&id=$ibwfsite[0]\">[x]</a>,";
$hm2 = "<a href=\"articles.php?action=edit&sid=$sid&artid=$ibwfsite[0]\">edit</a>";
}
if (ischecker(getuid_sid($sid)))
{
$hm = "<a href=\"articles.php?action=delart1&sid=$sid&id=$ibwfsite[0]\">[x]</a>,";
$hm2 = "<a href=\"articles.php?action=edit&sid=$sid&artid=$ibwfsite[0]\">edit</a>";
}
$sitelink = "$cou. <a href=\"articles.php?action=viewart&id=$ibwfsite[0]&sid=$sid&cid=$cid&artid=$ibwfsite[0]\">$ibwfsite[1]</a> $hm$hm2";
echo "<br/>$sitelink";
$cou++;
}
echo "</p>";
echo "<p align=\"center\">";
if($page>1)
{
$ppage = $page-1;
echo "<a href=\"articles.php?action=$action&page=$ppage&sid=$sid&cid=$cid&type=send&browse?\">«PREV</a> ";
}
if($page<$num_pages)
{
$npage = $page+1;
echo "<a href=\"articles.php?action=$action&page=$npage&sid=$sid&cid=$cid&type=send&browse?\">Next»</a>";
}
echo "<br/>Page $page of $num_pages";
if($num_pages>2)
{
$rets = "<br/>Jump to page: <input name=\"pg\" format=\"*N\" size=\"3\"/>";
$rets .= "<anchor>[GO]";
$rets .= "<go href=\"articles.php?type=send&browse?\" method=\"get\">";
$rets .= "<postfield name=\"action\" value=\"$action\"/>";
$rets .= "<postfield name=\"sid\" value=\"$sid\"/>";
$rets .= "<postfield name=\"cid\" value=\"$cid\"/>";
$rets .= "<postfield name=\"page\" value=\"$(pg)\"/>";
$rets .= "</go></anchor>";
echo $rets;
}
echo "<br/><a href=\"articles.php?action=newart&cid=$cid&sid=$sid&type=send&artid=$item[0]\">Submit Article</a><br/>";
echo "<a href=\"articles.php?action=articles&sid=$sid&browse?\">";
echo "Articles</a>";
echo "<br/>";
echo "<a href=\"index.php?action=main&sid=$sid&type=send&browse?\">";
echo "Main menu</a>";
echo "</p>";
echo "</card>";
}
////////////////////////////////////////////Edit Post
else if($action=="edit2")
{
$artid = $_GET["artid"];
$ptext = $_POST["ptext"];
echo "<card id=\"main\" title=\"Edit Options\">";
echo "<p align=\"center\">";
$res = mysql_query("UPDATE ibwf_readart SET text='"
.$ptext."' WHERE id='".$artid."'");
if($res)
{
echo "Article Title Edited";
}else{
echo "Database Error";
}
echo "<br/><br/>";
echo "<a href=\"index.php?action=main&sid=$sid\"><img src=\"http://coding-talk.com/images/home.gif\" alt=\"*\"/>";
echo "Home</a>";
echo "</p></card>";
}
else if($action=="edit")
{
$artid = $_GET["artid"];
addonline(getuid_sid($sid),"Article Checker Tool ","index.php?action=main");
$pinfo= mysql_fetch_array(mysql_query("SELECT name FROM ibwf_readart WHERE id='".$artid."'"));
$ptext = htmlspecialchars($pinfo[0]);
echo "<card id=\"main\" title=\"Edit Title\">";
echo "<onevent type=\"onenterforward\">";
echo "<refresh>
<setvar name=\"ptext\" value=\"$ptext\"/>";
echo "</refresh></onevent>";
echo "<p align=\"center\">";
echo "<input name=\"ptext\" value=\"$ptext\" maxlength=\"150\"/> ";
echo "<br/><anchor>Edit";
echo "<go href=\"articles.php?action=edit2&sid=$sid&artid=$artid&browse?\" method=\"post\">";
echo "<postfield name=\"ptext\" value=\"$(ptext)\"/>";
echo "</go>";
echo "</anchor>";
echo "</p>";
echo "<p align=\"center\">";
echo "<a href=\"index.php?action=main&sid=$sid\">";
echo "Main menu</a>";
echo "</p>";
echo "</card>";
}
//////////////////////////////////View Topic
else if($action=="viewart")
{
$id = $_GET["id"];
$cid = $_GET["cid"];
$artid = $_GET["artid"];
$cinfo = mysql_fetch_array(mysql_query("SELECT name from ibwf_readart WHERE id='".$id."'"));
addonline(getuid_sid($sid),"Reading article $cinfo[0]","articles.php?action=$action");
$tinfo = mysql_fetch_array(mysql_query("SELECT name, authorid, crdate, id from ibwf_readart WHERE id='".$id."'"));
$tnm = htmlspecialchars($tinfo[0]);
echo "<card id=\"main\" title=\"$tnm\">";
echo "<p align=\"left\">";
echo "<b>$cinfo[0]</b><br/>";
$tmstamp = $tinfo[2];
$tmdt = date("D,dMy-h:i:s a",$tmstamp);
echo "$tmdt<br/>";
$unick = getnick_uid($tinfo[1]);
$usl = "<a href=\"index.php?action=viewuser&sid=$sid&who=$tinfo[1]&browse?\">$unick</a>";
echo "$usl2 Submitted by: $usl<br/>";
$tid = $_GET["artid"];
$go = $_GET["go"];
$uid = getuid_sid($sid);
$num_pages = getnumpages($artid);
if($page==""||$page<1)$page=1;
if($go!="")$page=getpage_go($go,$artid);
$posts_per_page = 5;
if($page>$num_pages)$page=$num_pages;
$limit_start = $posts_per_page *($page-1);
$vws = $tinfo[3]+1;
///////from here
if($page==1)
{
$posts_per_page=4;
$ttext = mysql_fetch_array(mysql_query("SELECT authorid, text, crdate FROM ibwf_readart WHERE id='".$id."'"));
$pst2 = parsemsg($ttext[1], $sid);
$unick = getnick_uid($ttext[0]);
if(substr_count($ttext[1],"[br/]")<=1000){
$text = str_replace("[br/]","<br/>",$ttext[1]);
}
echo "$text<br/>";
mysql_query("UPDATE ibwf_readart SET vws='".$vws."' WHERE id='".$id."'");
mysql_query("INSERT INTO ibwf_view2 SET uid='".$uid."', artid='".$artid."', actime='".time()."'");
}
if($page>1)
{
$limit_start--;
}
$sql = "SELECT id, text FROM ibwf_artpost WHERE artid='".$artid."' ORDER BY crdate LIMIT $limit_start, $posts_per_page";
$posts = mysql_query($sql);
while($post = mysql_fetch_array($posts))
{
$unick = getnick_uid($post[2]);
$usl = "<br/><a href=\"index.php?action=viewuser&sid=$sid&who=$post[2]&browse?\">$unick</a>";
$pst = parsemsg($post[1], $sid);
if(substr_count($post[1],"[br/]")<=1000){
$pst = str_replace("[br/]","<br/>",$post[1]);
}
echo "<br/>$hm $pst<br/>";
}
///to here
if($page>1)
{
$ppage = $page-1;
echo "<a href=\"articles.php?action=viewart&page=$ppage&sid=$sid&artid=$artid&cid=$cid&id=$id\">«PREV</a> ";
}
if($page<$num_pages)
{
$npage = $page+1;
echo "<a href=\"articles.php?action=viewart&page=$npage&sid=$sid&artid=$artid&cid=$cid&id=$id\">Next»</a>";
}
echo "<br/>Page $page of $num_pages";
if($num_pages>2)
{
$rets = "<br/>Jump to page: <input name=\"pg\" format=\"*N\" size=\"3\"/>";
$rets .= "<anchor>[GO]";
$rets .= "<go href=\"articles.php?browse?\" method=\"get\">";
$rets .= "<postfield name=\"action\" value=\"$action\"/>";
$rets .= "<postfield name=\"cid\" value=\"$cid\"/>";
$rets .= "<postfield name=\"id\" value=\"$id\"/>";
$rets .= "<postfield name=\"artid\" value=\"$artid\"/>";
$rets .= "<postfield name=\"sid\" value=\"$sid\"/>";
$rets .= "<postfield name=\"page\" value=\"$(pg)\"/>";
$rets .= "</go></anchor>";
echo $rets;
}
if(canaddart($uid, $id))
{
echo "<br/><a href=\"articles.php?&action=newart2&sid=$sid&id=$artid&artid=$artid&cid=$cid\">Add more</a>";
}
$tmsg = getpmcount(getuid_sid($sid));
$umsg = getunreadpm(getuid_sid($sid));
if($umsg>0)
{
echo "<br/><a href=\"inbox.php?action=main&sid=$sid&browse?\">New $umsg Inbox!</a>";
}
$countpics = mysql_fetch_array(mysql_query("SELECT COUNT(id) FROM ibwf_cwart WHERE artid='".$artid."'"));
echo "<br/><a href=\"articles.php?&action=artcom&sid=$sid&id=$id&artid=$id&cid=$cid\">Comments($countpics[0])</a>";
echo "<br/>";
echo "<a href=\"articles.php?&action=dload&sid=$sid&id=$id&artid=$id\">Download</a>";
echo "<br/>";
echo "<a href=\"articles.php?&action=viewall&sid=$sid&id=$id&artid=$id&cid=$cid\">Fastread</a>";
echo "<br/>";
$cinfo = mysql_fetch_array(mysql_query("SELECT name from ibwf_articles WHERE id='".$cid."'"));
echo "<a href=\"articles.php?&action=kindat&sid=$sid&cid=$cid\">$cinfo[0]</a>";
echo "<br/>";
$ttext = mysql_fetch_array(mysql_query("SELECT authorid, text, crdate FROM ibwf_readart WHERE id='".$id."'"));
$unick = getnick_uid($ttext[0]);
$unick2 = getnick_uid($post[2]);
echo "<a href=\"articles.php?&action=vall&sid=$sid&who=$ttext[0]&cid=$cid&cid=$cid&id=$artid&artid=$artid\">All articles of $unick</a>";
echo "<br/>----------<br/>";
echo "<a href=\"articles.php?action=articles&sid=$sid&browse?\">";
echo "Articles</a><br/>";
echo "<a href=\"index.php?action=main&sid=$sid&type=send\">";
echo "Main menu</a>";
echo "</p>";
echo "</card>";
}
//////////////////////////////////View Topic
else if($action=="viewall")
{
$id = $_GET["id"];
$cid = $_GET["cid"];
$artid = $_GET["artid"];
$cinfo = mysql_fetch_array(mysql_query("SELECT name from ibwf_readart WHERE id='".$id."'"));
addonline(getuid_sid($sid),"Reading article $cinfo[0]","articles.php?action=$action");
$tinfo = mysql_fetch_array(mysql_query("SELECT name, authorid, crdate, vws from ibwf_readart WHERE id='".$id."'"));
$tnm = htmlspecialchars($tinfo[0]);
echo "<card id=\"main\" title=\"$tnm\">";
echo "<p align=\"left\">";
echo "<b>$cinfo[0]</b><br/>";
$num_pages = getnumpages($artid);
if($page==""||$page<1)$page=1;
if($go!="")$page=getpage_go($go,$artid);
$posts_per_page = 100;
if($page>$num_pages)$page=$num_pages;
$limit_start = $posts_per_page *($page-1);
$vws = $tinfo[3]+1;
$tmstamp = $tinfo[2];
$tmdt = date("D,dMy-h:i:s a",$tmstamp);
echo "$tmdt<br/>";
$unick = getnick_uid($tinfo[1]);
$usl = "<a href=\"index.php?action=viewuser&sid=$sid&who=$tinfo[1]&browse?\">$unick</a>";
echo "Submitted by: $usl<br/>";
$tid = $_GET["artid"];
$go = $_GET["go"];
$uid = getuid_sid($sid);
if($page==1)
{
$posts_per_page=100;
mysql_query("UPDATE ibwf_readart SET views='".$vws."' WHERE id='".$id."'");
$ttext = mysql_fetch_array(mysql_query("SELECT authorid, text, crdate FROM ibwf_readart WHERE id='".$id."'"));
$pst2 = parsemsg($ttext[1], $sid);
$unick = getnick_uid($ttext[0]);
if(substr_count($ttext[1],"[br/]")<=1000){
$text = str_replace("[br/]","<br/>",$ttext[1]);
}
echo "$text<br/>";
}
if($page>1)
{
$limit_start--;
}
$sql = "SELECT id, text FROM ibwf_artpost WHERE artid='".$artid."' ORDER BY crdate LIMIT $limit_start, $posts_per_page";
$posts = mysql_query($sql);
while($post = mysql_fetch_array($posts))
{
$unick = getnick_uid($post[2]);
$usl = "<br/><a href=\"index.php?action=viewuser&sid=$sid&who=$post[2]&browse?\">$unick</a>";
$pst = parsemsg($post[1], $sid);
if(substr_count($post[1],"[br/]")<=1000){
$text2 = str_replace("[br/]","<br/>",$post[1]);
}
echo "<br/>$hm $text2<br/>";
}
echo "-------<br/>Viewed: $vws";
if(canaddart($uid, $id))
{
echo "<br/><a href=\"articles.php?&action=newart2&sid=$sid&id=$artid&artid=$artid&cid=$cid\">Add more</a>";
}
$tmsg = getpmcount(getuid_sid($sid));
$umsg = getunreadpm(getuid_sid($sid));
if($umsg>0)
{
echo "<br/><a href=\"inbox.php?action=main&sid=$sid&browse?\">New $umsg Inbox</a>";
}
$countpics = mysql_fetch_array(mysql_query("SELECT COUNT(id) FROM ibwf_cwart WHERE artid='".$artid."'"));
echo "<br/><a href=\"articles.php?&action=artcom&sid=$sid&id=$id&artid=$id&cid=$cid\">Comments($countpics[0])</a>";
echo "<br/>";
echo "<a href=\"articles.php?&action=dload&sid=$sid&id=$id&artid=$id\">Download</a>";
echo "<br/>";
$cinfo = mysql_fetch_array(mysql_query("SELECT name from ibwf_articles WHERE id='".$cid."'"));
echo "<a href=\"articles.php?&action=kindat&sid=$sid&cid=$cid\">$cinfo[0]</a>";
echo "<br/>";
$ttext = mysql_fetch_array(mysql_query("SELECT authorid, text, crdate FROM ibwf_readart WHERE id='".$id."'"));
$unick = getnick_uid($ttext[0]);
$unick2 = getnick_uid($post[2]);
echo "<a href=\"articles.php?&action=vall&sid=$sid&who=$ttext[0]&cid=$cid&cid=$cid&id=$artid&artid=$artid\">All articles of $unick</a>";
echo "<br/>----------<br/>";
echo "<a href=\"articles.php?action=articles&sid=$sid&browse?\">";
echo "Articles</a><br/>";
echo "<a href=\"index.php?action=main&sid=$sid&type=send\">";
echo "Main menu</a>";
echo "</p>";
echo "</card>";
}
//////////////////////////////////////////////sdasda
else if($action=="artcom2")
{
$text = $_POST["text"];
$artid = $_GET["artid"];
$qut = $_POST["qut"];
addonline(getuid_sid($sid),"Adding Article Comment","index.php?action=main");
echo "<card id=\"main\" title=\"Add Article Comment\">";
echo "<p align=\"center\">";
$crdate = time();
$uid = getuid_sid($sid);
$res = false;
$res = mysql_query("INSERT INTO ibwf_cwart SET uid='".$uid."', text='".$text."', crdate='".$crdate."', artid='".$artid."'");
if($res)
{
echo "Comment submitted<br/>";
}else{
echo "Error Adding Comment<br/>";
}
echo "<a href=\"articles.php?action=articles&sid=$sid&browse?\">";
echo "Articles</a><br/>";
echo "<a href=\"index.php?action=main&sid=$sid&browse?start\">";
echo "Main menu</a>";
echo "</p>";
echo "</card>";
}
else if($action=="delart")
{
$id = $_GET["id"];
echo "<card id=\"main\" title=\"Delete Articles\">";
echo "<p align=\"center\">";
$res = mysql_query("DELETE FROM ibwf_cwart WHERE id ='".$id."'");
if($res)
{
echo "Comment deleted";
}else{
echo "Database Error";
}
echo "<br/><br/>";
echo "<a href=\"articles.php?action=articles&sid=$sid&browse?\">";
echo "Articles</a><br/>";
echo "<a href=\"index.php?action=main&sid=$sid\">";
echo "Main menu</a>";
echo "</p>";
echo" </card>";
}
///////////////////////////////////////////////sadasdas
else if($action=="delart1")
{
$id = $_GET["id"];
$cid = $_GET["cid"];
echo "<card id=\"main\" title=\"Delete Articles\">";
echo "<p align=\"center\">";
$res = mysql_query("DELETE FROM ibwf_readart WHERE id='".$id."'");
if($res)
{
echo "Article deleted";
$tpci = mysql_fetch_array(mysql_query("SELECT name, authorid FROM ibwf_readart WHERE id='".$id."'"));
$tname = htmlspecialchars($tpci[0]);
$msg = "Your article "."[/topic] is deleted"." due to non-sense or not in correct category!";
autopm($msg, $tpci[1]);
}else{
echo "Database Error";
}
echo "<br/><br/>";
echo "<a href=\"articles.php?action=articles&sid=$sid&browse?\">";
echo "Articles</a><br/>";
echo "<a href=\"index.php?action=main&sid=$sid\">";
echo "Main menu</a>";
echo "</p>";
echo" </card>";
}
///////////////////////////////vrrrrr
else if($action=="artcom3")
{
$artid = $_GET["artid"];
addonline(getuid_sid($sid),"Making Article Comments","index.php?action=$action&who=$who");
echo "<card id=\"main\" title=\"Article Comments\">";
echo "<p align=\"center\">";
echo "Comment: <input name=\"text\" maxlength=\"500\"/><br/>";
echo "<anchor>Submit <go href=\"articles.php?action=artcom2&sid=$sid&artid=$artid\" method=\"post\">";
echo" <postfield name=\"text\" value=\"$(text)\"/>";
echo "</go></anchor>";
echo "</p>";
echo "<p align=\"center\">";
echo "<a href=\"articles.php?action=articles&sid=$sid&browse?\">";
echo "Articles</a><br/>";
echo "<a href=\"index.php?action=main&sid=$sid\">";
echo "Main menu</a>";
echo "</p>";
echo "</card>";
}
/////////////////////////////////////smooch
else if($action=="artcom")
{
$id = $_GET["id"];
$cid = $_GET["cid"];
$artid = $_GET["artid"];
addonline(getuid_sid($sid),"Viewing Article Comments","lists.php?action=$action&who=$who&bid=$bid");
echo "<card id=\"main\" title=\"Article Comments\">";
$uid = getuid_sid($sid);
echo "<p align=\"left\">";
//////ALL LISTS SCRIPT <<
if($page=="" || $page<=0)$page=1;
$noi = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_cwart WHERE artid='".$artid."'"));
$num_items = $noi[0]; //changable
$items_per_page= 5;
$num_pages = ceil($num_items/$items_per_page);
if(($page>$num_pages)&&$page!=1)$page= $num_pages;
$limit_start = ($page-1)*$items_per_page;
$sql = "SELECT id, artid, text, uid, crdate FROM ibwf_cwart WHERE artid='".$artid."' ORDER BY crdate DESC LIMIT $limit_start, $items_per_page";
$items = mysql_query($sql);
$items = mysql_query($sql);
echo mysql_error();
if(mysql_num_rows($items)>0)
{
while ($item = mysql_fetch_array($items))
{
if(isonline($item[3]))
{
$iml = "[•]";
}else{
$iml = "[x]";
}
$snick = getnick_uid($item[3]);
$lnk = "<a href=\"index.php?action=viewuser&who=$item[3]&sid=$sid\">$iml$snick</a>:";
$tmstamp = $item[4];
$bs = date("D,dMy-h:i:s a",$tmstamp);
echo "$lnk<br/><small>";
$me = getuid_sid($sid);
if($who=="$me") {
$can = "a";
}else{
$can = "b";
}
if(ismod($uid)||$can=="a")
{
$delnk = "<a href=\"articles.php?action=delart&sid=$sid&id=$item[0]\">[x]</a>";
}else{
$delnk = "";
}
$text = parsepm($item[2], $sid);
echo "$text $delnk<br/>";
echo "$bs";
echo "<br/>";
echo "</small>";
}
}
echo "</p><p align=\"center\">";
if($page>1)
{
$ppage = $page-1;
echo "<a href=\"articles.php?action=artcom&page=$ppage&sid=$sid&id=$artid&cid=$cid&artid=$artid&type=send\">«PREV</a> ";
}
if($page<$num_pages)
{
$npage = $page+1;
echo "<a href=\"articles.php?action=artcom&page=$npage&sid=$sid&id=$artid&cid=$cid&artid=$artid&type=send\">Next»</a>";
}
echo "<br/>$page/$num_pages<br/>";
if($num_pages>2)
{
$rets = "Jump to page: <input name=\"pg\" format=\"*N\" size=\"3\"/>";
$rets .= "<anchor>[GO]";
$rets .= "<go href=\"lists.php?type=send\" method=\"get\">";
$rets .= "<postfield name=\"action\" value=\"$action\"/>";
$rets .= "<postfield name=\"sid\" value=\"$sid\"/>";
$rets .= "<postfield name=\"artid\" value=\"$artid\"/>";
$rets .= "<postfield name=\"id\" value=\"$artid\"/>";
$rets .= "<postfield name=\"cid\" value=\"$cid\"/>";
$rets .= "<postfield name=\"page\" value=\"$(pg)\"/>";
$rets .= "</go></anchor>";
echo $rets;
}
echo "</p>";
echo "<p align=\"center\">";
$me = getuid_sid($sid);
if($me!="$id") {
echo "<a href=\"articles.php?action=artcom3&sid=$sid&artid=$artid\">Add Comment</a><br/>";
}
echo "<a href=\"articles.php?action=viewart&sid=$sid&cid=$cid&artid=$artid&id=$id&browse?\">";
echo "Back to article</a><br/>";
echo "<a href=\"articles.php?action=articles&sid=$sid&browse?\">";
echo "Articles</a><br/>";
echo "<a href=\"index.php?action=main&sid=$sid\">";
echo "Main menu</a>";
echo "</p>";
echo "</card>";
}
//////////////////////////////////Buddies
else if($action=="vall")
{
$id = $_GET["id"];
$cid = $_GET["cid"];
$artid = $_GET["artid"];
$who = $_GET["who"];
addonline(getuid_sid($sid),"Users Articles","lists.php?action=$action");
echo "<card id=\"main\" title=\"Articles\">";
$uid = getuid_sid($sid);
echo "<p align=\"left\">";
if($page=="" || $page<=0)$page=1;
$ibwf = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_readart WHERE authorid='".$who."'"));
$num_items = $ibwf[0]; //changable
$items_per_page= 10;
$num_pages = ceil($num_items/$items_per_page);
if(($page>$num_pages)&&$page!=1)$page= $num_pages;
$limit_start = ($page-1)*$items_per_page;
$cou = $limit_start+1;
$ibwfsites = mysql_query("SELECT id, name, crdate, cid FROM ibwf_readart WHERE authorid='".$who."' ORDER BY crdate DESC LIMIT $limit_start, $items_per_page");;
while($ibwfsite=mysql_fetch_array($ibwfsites))
{
$sitelink = "$cou. <a href=\"articles.php?action=viewart&id=$ibwfsite[0]&sid=$sid&cid=$ibwfsite[3]&artid=$ibwfsite[0]\">$ibwfsite[1]</a>";
echo "<br/>$sitelink";
$cou++;
}
echo "</p>";
echo "<p align=\"center\">";
if($page>1)
{
$ppage = $page-1;
echo "<a href=\"articles.php?action=$action&page=$ppage&sid=$sid&artid=$artid&who=$who&cid=$cid&artid=$artid&id=$id\">«PREV</a> ";
}
if($page<$num_pages)
{
$npage = $page+1;
echo "<a href=\"articles.php?action=$action&page=$npage&sid=$sid&artid=$artid&who=$who&cid=$cid&artid=$artid&id=$id\">Next»</a>";
}
echo "<br/>Page $page of $num_pages";
if($num_pages>2)
{
$rets = "<br/>Jump to page: <input name=\"pg\" format=\"*N\" size=\"3\"/>";
$rets .= "<anchor>[GO]";
$rets .= "<go href=\"lists.php?type=send\" method=\"get\">";
$rets .= "<postfield name=\"action\" value=\"$action\"/>";
$rets .= "<postfield name=\"who\" value=\"$who\"/>";
$rets .= "<postfield name=\"sid\" value=\"$sid\"/>";
$rets .= "<postfield name=\"page\" value=\"$(pg)\"/>";
$rets .= "</go></anchor>";
echo $rets;
}
////// UNTILL HERE >>
echo "<br/><a href=\"articles.php?action=viewart&sid=$sid&cid=$cid&artid=$artid&id=$id&browse?\">";
echo "Back to article</a>";
echo "<br/><a href=\"articles.php?action=articles&sid=$sid&browse?\">";
echo "Articles</a><br/>";
echo "<a href=\"index.php?action=main&sid=$sid&type=send&browse?\">";
echo "Main menu</a>";
echo "</p>";
echo "</card>";
}
////////////////////////////////////
else if($action=="dload")
{
$artid = $artid;
addonline(getuid_sid($sid),"Download Article","index.php?action=main");
echo "<card id=\"main\" title=\"Article\">";
echo "<p align=\"center\">";
$pminfo = mysql_fetch_array(mysql_query("SELECT text, authorid FROM ibwf_readart WHERE id='".$id."'"));
echo "Ready to download<br/><br/>";
echo "<a href=\"artdl.php?action=dart&id=$id&artid=$artid&sid=$sid&type=send&browse?start\">Download Now</a><br/>";
echo "<a href=\"articles.php?action=articles&sid=$sid&browse?\">";
echo "Articles</a><br/>";
echo "<br/><a href=\"index.php?action=main&sid=$sid&type=send&browse?start\"><br/>";
echo "Main menu</a>";
echo "<do type=\"Chatrooms\" label=\"Chatrooms\"><go href=\"index.php?action=chat&sid=$sid&type=send&browse?start\"/></do>";
echo "<do type=\"Forum Index\" label=\"Forum Index\"><go href=\"index.php?action=forums&sid=$sid&type=send&browse?start\"/></do>";
echo "</p>";
echo "</card>";
}
?>
</wml>Last edited by metulj; 24.04.09, 10:24.
Comment
-
LOL ....YOU POSTED THE SQL
-- Table structure for table `iwbf_cwart`
--
CREATE TABLE `iwbf_cwart` (
`id` int(255) NOT NULL auto_increment,
`artid` int(255) NOT NULL default '0',
`uid` int(255) NOT NULL default '0',
`text` varchar(255) NOT NULL default '',
`crdate` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=92 DEFAULT CHARSET=latin1 AUTO_INCREMENT=92 ;
THATS CORRECT YOUR FIRST POST SEEMS IBWF_CWART DOES'NT EXIST ..I GOT IT
IN UR SQL "CREATE TABLE `iwbf_cwart` "
ITS IWBF_CART AND I UR SCRIPT ITS IBWF SO CHANGE THE SQL IT SHUD BE
-- Table structure for table `ibwf_cwart`
--
CREATE TABLE `ibwf_cwart` (
`id` int(255) NOT NULL auto_increment,
`artid` int(255) NOT NULL default '0',
`uid` int(255) NOT NULL default '0',
`text` varchar(255) NOT NULL default '',
`crdate` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=92 DEFAULT CHARSET=latin1 AUTO_INCREMENT=92 ;
Comment
-
*********************
apology to tkreturnsLast edited by metulj; 25.04.09, 09:43.キノgんイノ刀g 4 ア乇ムc乇 ノ丂 レノズ乇 キucズノ刀g 4 √ノ尺gノ刀ノイリ!It's better to keep your mouth shut and give the impression that you're stupid, than to open it and remove all doubt.
ⓣⓗⓔ ⓠⓤⓘⓔⓣⓔⓡ ⓨⓞⓤ ⓑⓔ©ⓞⓜⓔ, ⓣⓗⓔ ⓜⓞⓡⓔ ⓨⓞⓤ â“â“¡â“” â“ⓑⓛⓔ ⓣⓞ â“—â“”â“â“¡ !
ιη тнєσÑу, тнє ÏÑα¢тι¢є ιѕ α Ñєѕυℓт σƒ тнє тнєσÑу, вυт ιη ÏÑα¢тι¢є ιѕ тнє σÏÏσѕιтє.
Comment
-
LOL he was rightOriginally posted by metulj View PostWTF you blabing about ?????:mad:
you have posted exact same SQL table as post writer so WTF ?!?!?
i'd suggest you to stop free posting...
CREATE TABLE `iwbf_cwart`
CREATE TABLE `ibwf_cwart`
but than again its not even a sql 4 that article file... its just another mistakeLast edited by alesh; 25.04.09, 09:16.sigpiceeeeerrr....
Comment
-
my bad!Originally posted by alesh View PostLOL he was right
CREATE TABLE `iwbf_cwart`
CREATE TABLE `ibwf_cwart`
but than again its not even a sql 4 that article file... its just another mistake
i must admit
i haven't noticed that lil detail
but then again.. posted table is the right one for posted code,
but most likely it is not the only table for that code ;)キノgんイノ刀g 4 ア乇ムc乇 ノ丂 レノズ乇 キucズノ刀g 4 √ノ尺gノ刀ノイリ!It's better to keep your mouth shut and give the impression that you're stupid, than to open it and remove all doubt.
ⓣⓗⓔ ⓠⓤⓘⓔⓣⓔⓡ ⓨⓞⓤ ⓑⓔ©ⓞⓜⓔ, ⓣⓗⓔ ⓜⓞⓡⓔ ⓨⓞⓤ â“â“¡â“” â“ⓑⓛⓔ ⓣⓞ â“—â“”â“â“¡ !
ιη тнєσÑу, тнє ÏÑα¢тι¢є ιѕ α Ñєѕυℓт σƒ тнє тнєσÑу, вυт ιη ÏÑα¢тι¢є ιѕ тнє σÏÏσѕιтє.
Comment
-
basicly i never saw any point in this article scriptOriginally posted by alesh View Postwell i think it is...
at least a part of it lol
i found 4 tables 4 this articles in posted code that is somehow releted...
ibwf_articles
ibwf_readart
ibwf_artpost
ibwf_cwart
btw WTF is it??? i mean whats the use of this??
i cant be bodered 2 upload it and try it lol
as blogs can be used for exact same thing...
:rolleyes:キノgんイノ刀g 4 ア乇ムc乇 ノ丂 レノズ乇 キucズノ刀g 4 √ノ尺gノ刀ノイリ!It's better to keep your mouth shut and give the impression that you're stupid, than to open it and remove all doubt.
ⓣⓗⓔ ⓠⓤⓘⓔⓣⓔⓡ ⓨⓞⓤ ⓑⓔ©ⓞⓜⓔ, ⓣⓗⓔ ⓜⓞⓡⓔ ⓨⓞⓤ â“â“¡â“” â“ⓑⓛⓔ ⓣⓞ â“—â“”â“â“¡ !
ιη тнєσÑу, тнє ÏÑα¢тι¢є ιѕ α Ñєѕυℓт σƒ тнє тнєσÑу, вυт ιη ÏÑα¢тι¢є ιѕ тнє σÏÏσѕιтє.
Comment
-
alesh can u please share the other sql for the article if u dnt mind pleaseOriginally posted by alesh View Postwell i think it is...
at least a part of it lol
i found 4 tables 4 this articles in posted code that is somehow releted...
ibwf_articles
ibwf_readart
ibwf_artpost
ibwf_cwart
btw WTF is it??? i mean whats the use of this??
i cant be bodered 2 upload it and try it lol
Comment
-
Guest
Comment