Hey guys please help me out here having some little problem i want to add the following code to make the forum text in color already have the future to select color from database
ibwf_users forumcolor varchar 54 default yellow
now just need to get the forum text in color
this is my viewtpc
ibwf_users forumcolor varchar 54 default yellow
now just need to get the forum text in color
Code:
else if($action=="viewtpc") { $tid = cleanQuery($_GET["tid"]); $go = cleanQuery($_GET["go"]); addonline(getuid_sid($sid),"Viewing Forum Topic","index.php?action=viewtpc&tid=$tid"); $tfid = mysql_fetch_array(mysql_query("SELECT fid FROM ibwf_topics WHERE id='".$tid."'")); if(!canaccess(getuid_sid($sid), $tfid[0])) { $pstyle = gettheme($sid); echo xhtmlhead("$stitle",$pstyle); echo "<body>"; echo "<p align=\"center\">"; echo "You Don't Have A Permission To View The Contents Of This Forum<br/><br/>"; echo "<a href=\"index.php?action=main&sid=$sid\">Home</a>"; echo "</p>"; echo "</body>"; echo "</html>"; exit(); } $tinfo = mysql_fetch_array(mysql_query("SELECT name, text, authorid, crdate, views, fid, pollid from ibwf_topics WHERE id='".$tid."'")); $tnm = htmlspecialchars($tinfo[0]); $pstyle = gettheme($sid); echo xhtmlhead("$stitle",$pstyle); echo "<body>"; echo "<div align=\"center\">"; $umsg = getunreadpm(getuid_sid($sid)); if($umsg>0) { echo "<a href=\"inbox.php?action=main&sid=$sid\">$umsg New Inbox!</a><br/>"; } $num_pages = getnumpages($tid); if($page==""||$page<1)$page=1; if($go!="")$page=getpage_go($go,$tid); $posts_per_page = 5; if($page>$num_pages)$page=$num_pages; $limit_start = $posts_per_page *($page-1); $whonick = getnick_uid($uid); $isin = mysql_fetch_array(mysql_query("SELECT thanked FROM thanksyou WHERE unid='".$uid."' AND tid='".$tid."' ")); if ($ttext[0]==$uid) { } else { if ($isin[0]==0) { echo"<a href=\"genproc.php?action=thnx&sid=$sid&author=$tinfo[2]&tid=$tid\">Thanks User's Topic<br/></a>"; } else { }} /* $whonick = getnick_uid($uid); $isin = mysql_fetch_array(mysql_query("SELECT thanked FROM thanksyou WHERE unid='".$uid."' AND tid='".$tid."' ")); if ($ttext[0]==$uid) { } else{ if ($isin[0]==0){ echo"<a href=\"genproc.php?action=thnx&sid=$sid&author=$tinfo[2]&tid=$tid\">Thanks User's Topic<br/></a>"; } else { } } */ echo "<a href=\"index.php?action=post&sid=$sid&tid=$tid\">Post reply</a>"; $lastlink = "<a href=\"index.php?action=$action&tid=$tid&sid=$sid&go=last\">Last Page</a>"; $firstlink = "<a href=\"index.php?action=$action&tid=$tid&sid=$sid&page=1\">First Page</a> "; $golink = ""; if($page>1) { $golink = $firstlink; } if($page<$num_pages) { $golink .= $lastlink; } if($golink !="") { echo "<br/>$golink"; } $vws = $tinfo[4]+1; $rpls = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_posts WHERE tid='".$tid."'")); echo "<br/>Replies: $rpls[0] - Views: $vws<br/>"; echo "</div>"; echo "<div>"; echo "<br/>"; ///fm here if($page==1) { $posts_per_page=4; mysql_query("UPDATE ibwf_topics SET views='".$vws."' WHERE id='".$tid."'"); $ttext = mysql_fetch_array(mysql_query("SELECT authorid, text, crdate, pollid FROM ibwf_topics WHERE id='".$tid."'")); $unick = getnick_uid($ttext[0]); if(isonline($ttext[0])) { $iml = "<img src=\"../images/onl.gif\" alt=\"+\"/>"; }else{ $iml = "<img src=\"../images/ofl.gif\" alt=\"-\"/>"; } $for = "<br/>".forat($ttext[0]).""; $usl = "<br/>Topic Author: <a href=\"index.php?action=viewuser&sid=$sid&who=$ttext[0]\">$iml$unick</a>$for"; $topt = "<a href=\"index.php?action=tpcopt&sid=$sid&tid=$tid\">*</a>"; if($go==$tid) { $fli = "<img src=\"../images/flag.gif\" alt=\"!\"/>"; }else{ $fli =""; } $pst = parsemsg($ttext[1],$sid); echo "» $fli$pst $topt$usl<br/>"; $unop = mysql_fetch_array(mysql_query("SELECT posts FROM ibwf_users WHERE id='".$ttext[0]."'")); $unol = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_posts WHERE uid='".$ttext[0]."'")); $plink = "<a href=\"lists.php?action=uposts&sid=$sid&who=$ttext[0]\">$unol[0]</a>"; echo "Forum Post $plink/$unop[0]<br/>"; $dtot = date("d-m-y - H:i:s",$ttext[2]); echo $dtot; echo "<br/>"; echo "<hr width=\"100%\"/>"; if($ttext[3]>0) { echo "<a href=\"index.php?action=viewtpl&sid=$sid&who=$tid\">POLL</a><br/>"; } } if($page>1) { $limit_start--; } $sql = "SELECT id, text, uid, dtpost, quote FROM ibwf_posts WHERE tid='".$tid."' ORDER BY dtpost LIMIT $limit_start, $posts_per_page"; $posts = mysql_query($sql); while($post = mysql_fetch_array($posts)) { $unick = getnick_uid($post[2]); if(isonline($post[2])) { $iml = "<img src=\"../images/onl.gif\" alt=\"+\"/>"; }else{ $iml = "<img src=\"../images/ofl.gif\" alt=\"-\"/>"; } $que = mysql_fetch_array(mysql_query("SELECT text, uid, dtpost FROM ibwf_posts WHERE id='".$post[4]."'")); $nick = getnick_uid($que[1]); $dto = date("d-m-y - H:i:s",$que[2]); $as = parsemsg($que[0], $sid); $quo = "<i>[$nick Wrote:$as<br/>$dto]</i><br/>"; $for = "<br/>".forat($post[2]).""; $usl = "<br/>Post BY: <a href=\"index.php?action=viewuser&sid=$sid&who=$post[2]\">$iml$unick</a>$for"; $pst = parsemsg($post[1], $sid); $topt = "<a href=\"index.php?action=pstopt&sid=$sid&pid=$post[0]&page=$page&fid=$tinfo[5]\">*</a>"; if($post[4]>0) { $qtl = "<small><i><a href=\"index.php?action=viewtpc&sid=$sid&tid=$tid&pst=\">(quote:p=blaze,d=16-04-2006)</a></i></small>"; } if($go==$post[0]) { $fli = "<img src=\"../images/flag.gif\" alt=\"!\"/>"; }else{ $fli =""; } if($post[4]==0) { echo "» $fli$pst $topt$usl<br/>"; }else{ echo "» $quo » $fli$pst $topt$usl<br/>"; } $unop = mysql_fetch_array(mysql_query("SELECT posts FROM ibwf_users WHERE id='".$post[2]."'")); $unol = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_posts WHERE uid='".$post[2]."'")); $plink = "<a href=\"lists.php?action=uposts&sid=$sid&who=$post[2]\">$unol[0]</a>"; echo "Forum Post $plink/$unop[0]<br/>"; $dtot = date("d-m-y - H:i:s",$post[3]); echo $dtot; echo "<br/>"; echo "<hr width=\"100%\"/>"; } ///to here echo "<p align=\"center\">"; if($page>1) { $ppage = $page-1; echo "<a href=\"index.php?action=viewtpc&page=$ppage&sid=$sid&tid=$tid\">«PREV</a> "; } if($page<$num_pages) { $npage = $page+1; echo "<a href=\"index.php?action=viewtpc&page=$npage&sid=$sid&tid=$tid\">Next»</a>"; } echo "<br/>$page/$num_pages<br/>"; if($num_pages>2) { $rets = "<form action=\"index.php\" method=\"get\">"; $rets .= "Jump<input name=\"page\" style=\"-wap-input-format: '*N'\" size=\"2\"/>"; $rets .= "<input type=\"hidden\" name=\"action\" value=\"$action\"/>"; $rets .= "<input type=\"hidden\" name=\"tid\" value=\"$tid\"/>"; $rets .= "<input type=\"hidden\" name=\"sid\" value=\"$sid\"/>"; $rets .= "<input type=\"Submit\" value=\"Go\" Name=\"Submit\"/></form>"; echo $rets; } echo "</div>"; echo "<div align=\"center\">"; $isin = mysql_fetch_array(mysql_query("SELECT bywho FROM ibwf_topics WHERE id='".$tid."'")); if ($isin[0]=="") { echo"<b>TOPIC THANKED by</b><font color=\"red\"> $isin[0]</font><br/><br/>"; } else { echo"<FONT SIZE=1><b>TOPIC THANKED by</b><font color=\"red\"> $isin[0]</font></font><br/><br/>"; } echo "<a href=\"index.php?action=post&sid=$sid&tid=$tid\">Post reply</a><br/>"; $var3 = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_online WHERE place='Viewing Forum Topic'")); echo "<br/><i>$var3[0] User(s) Currently Browsing Here</i><br/><br/>"; $fid = $tinfo[5]; $fname = getfname($fid); $cid = mysql_fetch_array(mysql_query("SELECT cid FROM ibwf_forums WHERE id='".$fid."'")); $cinfo = mysql_fetch_array(mysql_query("SELECT name FROM ibwf_fcats WHERE id='".$cid[0]."'")); $cname = $cinfo[0]; $cid = mysql_fetch_array(mysql_query("SELECT cid FROM ibwf_forums WHERE id='".$fid."'")); $fname = htmlspecialchars($fname); echo "<a href=\"index.php?action=viewfrm&sid=$sid&fid=$fid\">Back To $fname</a><br/>"; if($cid[0]>0) { $cinfo = mysql_fetch_array(mysql_query("SELECT name FROM ibwf_fcats WHERE id='".$cid[0]."'")); $cname = htmlspecialchars($cinfo[0]); echo "<a href=\"index.php?action=viewcat&sid=$sid&cid=$cid[0]\">$cname</a><br/>"; echo forumlink($sid); }else{ $cid = mysql_fetch_array(mysql_query("SELECT clubid FROM ibwf_forums WHERE id='".$fid."'")); $cinfo = mysql_fetch_array(mysql_query("SELECT name FROM ibwf_clubs WHERE id='".$cid[0]."'")); $cname = htmlspecialchars($cinfo[0]); echo "<a href=\"index.php?action=gocl&sid=$sid&clid=$cid[0]\">$cname Club</a><br/>"; } echo "<a href=\"index.php?action=main&sid=$sid\">© $stitle</a>"; echo "</div>"; echo "</body>"; exit(); }
Comment