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