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 Guest
Comment