Color in forum

riderz

Senior Member

Join Date: Mar 2009
Posts: 1385

25.03.10, 19:11

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

Code:

else if($action=="viewtpc")
{
  $tid = cleanQuery($_GET["tid"]);
  $go = cleanQuery($_GET["go"]);
  addonline(getuid_sid($sid),"Viewing Forum Topic","index.php?action=viewtpc&amp;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&amp;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&amp;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&amp;sid=$sid&amp;author=$tinfo[2]&amp;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&amp;sid=$sid&amp;author=$tinfo[2]&amp;tid=$tid\">Thanks User's Topic<br/></a>";
     }
     else
     {
     	   }
       }   */
    echo "<a href=\"index.php?action=post&amp;sid=$sid&amp;tid=$tid\">Post reply</a>";
    $lastlink = "<a href=\"index.php?action=$action&amp;tid=$tid&amp;sid=$sid&amp;go=last\">Last Page</a>";
    $firstlink = "<a href=\"index.php?action=$action&amp;tid=$tid&amp;sid=$sid&amp;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&amp;sid=$sid&amp;who=$ttext[0]\">$iml$unick</a>$for";
    $topt = "<a href=\"index.php?action=tpcopt&amp;sid=$sid&amp;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&amp;sid=$sid&amp;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&amp;sid=$sid&amp;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&amp;sid=$sid&amp;who=$post[2]\">$iml$unick</a>$for";
    $pst = parsemsg($post[1], $sid);
    $topt = "<a href=\"index.php?action=pstopt&amp;sid=$sid&amp;pid=$post[0]&amp;page=$page&amp;fid=$tinfo[5]\">*</a>";
    if($post[4]>0)
    {
        $qtl = "<small><i><a href=\"index.php?action=viewtpc&amp;sid=$sid&amp;tid=$tid&amp;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&amp;sid=$sid&amp;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&amp;page=$ppage&amp;sid=$sid&amp;tid=$tid\">«PREV</a> ";
    }
    if($page<$num_pages)
    {
      $npage = $page+1;
      echo "<a href=\"index.php?action=viewtpc&amp;page=$npage&amp;sid=$sid&amp;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&amp;sid=$sid&amp;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&amp;sid=$sid&amp;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&amp;sid=$sid&amp;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&amp;sid=$sid&amp;clid=$cid[0]\">$cname Club</a><br/>";
  }
  echo "<a href=\"index.php?action=main&amp;sid=$sid\">© $stitle</a>";
  echo "</div>";
    echo "</body>";
exit();
}

this is my viewtpc

Last edited by riderz; 26.03.10, 03:27.

________________
Jacques
jacques@gw-designs.co.za
http://coding.biz.tm
Come join and lets make it a place to learn all the noobies how to code
__________________

NEVER FORGET TO CLICK THE TANX BUTTON IF U LIKE WHAT IM SHARING OR HELPING WITH

Tags: None

i0nutzxp

Senior Member

Join Date: Apr 2009

Posts: 153
#2

26.03.10, 05:53

$option = mysql_fetch_array(mysql_query("SELECT forumcolor FROM ibwf_users WHERE id='".$uid."'"));
$pst = parsemsg($ttext[1],$sid); // uper
$pst = parsemsg($post[1], $sid);//
$pst = "<font color=\"$option[0]\">$pst</font>";

// something like that:-?

<?php unlink('World/Europe/Romania.country'); ?>
Comment
riderz

Senior Member

Join Date: Mar 2009

Posts: 1385
#3

26.03.10, 16:02

Ok it works now i just want it to show all the diff users selected colors for the forum text now it just show all the text from all users in the selected color

________________
Jacques
jacques@gw-designs.co.za
http://coding.biz.tm
Come join and lets make it a place to learn all the noobies how to code
__________________

NEVER FORGET TO CLICK THE TANX BUTTON IF U LIKE WHAT IM SHARING OR HELPING WITH
Comment
i0nutzxp

Senior Member

Join Date: Apr 2009

Posts: 153
#4

26.03.10, 17:20

it shows the default value :-??

$option = mysql_fetch_array(mysql_query("SELECT forumcolor FROM ibwf_users WHERE id='".getuid_sid($sid)."'"));
maybe u didnt had already declared the $uid :P

<?php unlink('World/Europe/Romania.country'); ?>
Comment

Previous template Next

Color in forum

Color in forum

Comment

Comment

Comment