add article comment error

ahehehe nice :D

[mhazter]

Guyz how can i add text limit in article? I try to change my text character in 500 to 1000 in article.php but when i post my article have 500 only text char post in my article.

[riderz]

well 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

alesh can u please share the other sql for the article if u dnt mind please

[mhazter]

LOL i can't see the wrong tnx to all of you guyz. LOL LOL LOL

[metulj]

well 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

basicly i never saw any point in this article script
as blogs can be used for exact same thing...
:rolleyes:

[alesh]

well 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

[metulj]

LOL 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

my bad!
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 ;)

[alesh]

WTF you blabing about ?????:mad:

you have posted exact same SQL table as post writer so WTF ?!?!?
i'd suggest you to stop free posting...

LOL 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

[metulj]

*********************
apology to tkreturns

[tkreturns]

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 ;

[mhazter]

this is the full code of my article

<?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 = "&#x2022;  <a href=\"articles.php?action=kindat&amp;sid=$sid&amp;cid=$fcat[0]&amp;browse?\">$fcat[1]($noi[0])</a>";
    echo "<br/>$catlink";
    
  }
    echo "<br/><a href=\"index.php?action=main&amp;sid=$sid&amp;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&amp;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&amp;sid=$sid&amp;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&amp;sid=$sid&amp;browse?\">";
    echo "Articles</a><br/>";
    echo "<a href=\"index.php?action=main&amp;sid=$sid&amp;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&amp;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&amp;sid=$sid&amp;artid=$artid&amp;cid=$cid&amp;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&amp;sid=$sid&amp;browse?\">";
    echo "Articles</a>";
 echo "<br/><a href=\"index.php?action=main&amp;sid=$sid&amp;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&amp;sid=$sid&amp;browse?\">";
    echo "Articles</a>";
 
      echo "<br/><a href=\"index.php?action=main&amp;sid=$sid&amp;type=send&amp;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&amp;sid=$sid&amp;artid=$artid&amp;cid=$cid&amp;id=$id&amp;go=last&amp;type=send&amp;browse?start\">";
      echo "Read Article</a>";
      }else{
        echo "Article could not submit";
      }
echo "<br/><a href=\"articles.php?action=articles&amp;sid=$sid&amp;browse?\">";
    echo "Articles</a>";
      echo "<br/><a href=\"index.php?action=main&amp;sid=$sid&amp;type=send&amp;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&amp;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&amp;sid=$sid&amp;id=$ibwfsite[0]\">[x]</a>,";
    $hm2 = "<a href=\"articles.php?action=edit&amp;sid=$sid&amp;artid=$ibwfsite[0]\">edit</a>";
 }
 if (ischecker(getuid_sid($sid)))
  {
    $hm = "<a href=\"articles.php?action=delart1&amp;sid=$sid&amp;id=$ibwfsite[0]\">[x]</a>,";
    $hm2 = "<a href=\"articles.php?action=edit&amp;sid=$sid&amp;artid=$ibwfsite[0]\">edit</a>";
 }
$sitelink = "$cou. <a href=\"articles.php?action=viewart&amp;id=$ibwfsite[0]&amp;sid=$sid&amp;cid=$cid&amp;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&amp;page=$ppage&amp;sid=$sid&amp;cid=$cid&amp;type=send&amp;browse?\">«PREV</a> ";
    }
    if($page<$num_pages)
    {
      $npage = $page+1;
      echo "<a href=\"articles.php?action=$action&amp;page=$npage&amp;sid=$sid&amp;cid=$cid&amp;type=send&amp;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&amp;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&amp;cid=$cid&amp;sid=$sid&amp;type=send&amp;artid=$item[0]\">Submit Article</a><br/>";
 
echo "<a href=\"articles.php?action=articles&amp;sid=$sid&amp;browse?\">";
    echo "Articles</a>";
echo "<br/>";
    echo "<a href=\"index.php?action=main&amp;sid=$sid&amp;type=send&amp;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&amp;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&amp;sid=$sid&amp;artid=$artid&amp;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&amp;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&amp;sid=$sid&amp;who=$tinfo[1]&amp;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&amp;sid=$sid&amp;who=$post[2]&amp;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&amp;page=$ppage&amp;sid=$sid&amp;artid=$artid&amp;cid=$cid&amp;id=$id\">«PREV</a> ";
    }
    if($page<$num_pages)
    {
      $npage = $page+1;
      echo "<a href=\"articles.php?action=viewart&amp;page=$npage&amp;sid=$sid&amp;artid=$artid&amp;cid=$cid&amp;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?&amp;action=newart2&amp;sid=$sid&amp;id=$artid&amp;artid=$artid&amp;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&amp;sid=$sid&amp;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?&amp;action=artcom&amp;sid=$sid&amp;id=$id&amp;artid=$id&amp;cid=$cid\">Comments($countpics[0])</a>";
echo "<br/>";
   echo "<a href=\"articles.php?&amp;action=dload&amp;sid=$sid&amp;id=$id&amp;artid=$id\">Download</a>";
echo "<br/>";
   echo "<a href=\"articles.php?&amp;action=viewall&amp;sid=$sid&amp;id=$id&amp;artid=$id&amp;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?&amp;action=kindat&amp;sid=$sid&amp;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?&amp;action=vall&amp;sid=$sid&amp;who=$ttext[0]&amp;cid=$cid&amp;cid=$cid&amp;id=$artid&amp;artid=$artid\">All articles of $unick</a>";
echo "<br/>----------<br/>";
echo "<a href=\"articles.php?action=articles&amp;sid=$sid&amp;browse?\">";
    echo "Articles</a><br/>";


 

echo "<a href=\"index.php?action=main&amp;sid=$sid&amp;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&amp;sid=$sid&amp;who=$tinfo[1]&amp;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&amp;sid=$sid&amp;who=$post[2]&amp;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?&amp;action=newart2&amp;sid=$sid&amp;id=$artid&amp;artid=$artid&amp;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&amp;sid=$sid&amp;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?&amp;action=artcom&amp;sid=$sid&amp;id=$id&amp;artid=$id&amp;cid=$cid\">Comments($countpics[0])</a>";
echo "<br/>";
   echo "<a href=\"articles.php?&amp;action=dload&amp;sid=$sid&amp;id=$id&amp;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?&amp;action=kindat&amp;sid=$sid&amp;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?&amp;action=vall&amp;sid=$sid&amp;who=$ttext[0]&amp;cid=$cid&amp;cid=$cid&amp;id=$artid&amp;artid=$artid\">All articles of $unick</a>";
echo "<br/>----------<br/>";
echo "<a href=\"articles.php?action=articles&amp;sid=$sid&amp;browse?\">";
    echo "Articles</a><br/>";


 

echo "<a href=\"index.php?action=main&amp;sid=$sid&amp;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&amp;sid=$sid&amp;browse?\">";
    echo "Articles</a><br/>";




      echo "<a href=\"index.php?action=main&amp;sid=$sid&amp;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&amp;sid=$sid&amp;browse?\">";
    echo "Articles</a><br/>";

echo "<a href=\"index.php?action=main&amp;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&amp;sid=$sid&amp;browse?\">";
    echo "Articles</a><br/>";

  echo "<a href=\"index.php?action=main&amp;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&amp;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&amp;sid=$sid&amp;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&amp;sid=$sid&amp;browse?\">";
    echo "Articles</a><br/>";


 

    echo "<a href=\"index.php?action=main&amp;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&amp;who=$who&amp;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 = "[&#x2022;]";
    
  }else{
    $iml = "[x]";
  }
    $snick = getnick_uid($item[3]);
      $lnk = "<a href=\"index.php?action=viewuser&amp;who=$item[3]&amp;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&amp;sid=$sid&amp;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&amp;page=$ppage&amp;sid=$sid&amp;id=$artid&amp;cid=$cid&amp;artid=$artid&amp;type=send\">«PREV</a> ";
    }
    if($page<$num_pages)
    {
      $npage = $page+1;
      echo "<a href=\"articles.php?action=artcom&amp;page=$npage&amp;sid=$sid&amp;id=$artid&amp;cid=$cid&amp;artid=$artid&amp;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&amp;sid=$sid&amp;artid=$artid\">Add Comment</a><br/>";
}
echo "<a href=\"articles.php?action=viewart&amp;sid=$sid&amp;cid=$cid&amp;artid=$artid&amp;id=$id&amp;browse?\">";
    echo "Back to article</a><br/>";

echo "<a href=\"articles.php?action=articles&amp;sid=$sid&amp;browse?\">";
    echo "Articles</a><br/>";


 

    echo "<a href=\"index.php?action=main&amp;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&amp;id=$ibwfsite[0]&amp;sid=$sid&amp;cid=$ibwfsite[3]&amp;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&amp;page=$ppage&amp;sid=$sid&amp;artid=$artid&amp;who=$who&amp;cid=$cid&amp;artid=$artid&amp;id=$id\">«PREV</a> ";
    }
    if($page<$num_pages)
    {
      $npage = $page+1;
      echo "<a href=\"articles.php?action=$action&amp;page=$npage&amp;sid=$sid&amp;artid=$artid&amp;who=$who&amp;cid=$cid&amp;artid=$artid&amp;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&amp;sid=$sid&amp;cid=$cid&amp;artid=$artid&amp;id=$id&amp;browse?\">";
    echo "Back to article</a>";
echo "<br/><a href=\"articles.php?action=articles&amp;sid=$sid&amp;browse?\">";
    echo "Articles</a><br/>";




    echo "<a href=\"index.php?action=main&amp;sid=$sid&amp;type=send&amp;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&amp;id=$id&amp;artid=$artid&amp;sid=$sid&amp;type=send&amp;browse?start\">Download Now</a><br/>";
      echo "<a href=\"articles.php?action=articles&amp;sid=$sid&amp;browse?\">";
    echo "Articles</a><br/>";
  
echo "<br/><a href=\"index.php?action=main&amp;sid=$sid&amp;type=send&amp;browse?start\"><br/>";
echo "Main menu</a>";
    
  echo "<do type=\"Chatrooms\" label=\"Chatrooms\"><go href=\"index.php?action=chat&amp;sid=$sid&amp;type=send&amp;browse?start\"/></do>";
  echo "<do type=\"Forum Index\" label=\"Forum Index\"><go href=\"index.php?action=forums&amp;sid=$sid&amp;type=send&amp;browse?start\"/></do>";
   echo "</p>";
    echo "</card>";
  }


?>

</wml>

[metulj]

this is 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 ; 

like i said above... you will need to post CODE
and not SQL in order to get this fixed

[mhazter]

this is 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 ; 

[metulj]

help me i encountered this error in my add article comment ibwf_cwart' doesnt exist

you will need to post that article code..
then some1 may create/post sql table

[mhazter]

help me i encountered this error in my add article comment ibwf_cwart' doesnt exist