Signature in topix for lava

[awan]

what i mean is . I need a code ..I wanted the code below
the image user ade mark
signature. At the forum,
as in the current forum

[subzero]

take it out of profiles

and paste it under topic[8] some crap lol

[adex3g]

Lol, copy from profile to forum post or add another table to ur ibwf_users.

[awan]

Lol, copy from profile to forum post or add another table to ur ibwf_users.

Thnx ! S0rry im n0ob

[xdosx]

$sign = mysql_fetch_array(mysql_query("SELECT signature FROM users WHERE id='".$ttext[0]."'"));
$sign = $sign[0];
echo "$usl: $fli$pst $sign"; 

[ewanz]

awan, do you mean the signature in the topic or your forum signature? it is different... ..if your signature topic... u can set different signature for different topic in forum...

[awan]

awan, do you mean the signature in the topic or your forum signature? it is different... ..if your signature topic... u can set different signature for different topic in forum...

Forum signature br0. . Sorry my mistake

$sign = mysql_fetch_array(mysql_query("SELECT signature FROM users WHERE id='".$ttext[0]."'"));
$sign = $sign[0];
echo "$usl: $fli$pst $sign"; 

Demo please

[ewanz]

ALTER TABLE `ibwf_users` ADD `fsignature` varchar( 50) NOT NULL default 'I Love Mygenkz';

first, make this sql in your users row...

Added after 5 minutes:

Then.... post your topic script here awan..... i will teach u mate

[awan]

ALTER TABLE `ibwf_users` ADD `fsignature` varchar( 50) NOT NULL default 'I Love Mygenkz';

first, make this sql in your users row...

Added after 5 minutes:

Then.... post your topic script here awan..... i will teach u mate

Here is my topic script


//////ALL LISTS SCRIPT <<

if($page=="" || $page<=0)$page=1;
$num_items = regmemcount(); //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;

//changable sql

$sql = "SELECT id, name, rep FROM mx_users ORDER BY rep DESC LIMIT $limit_start, $items_per_page";

$cou = $limit_start;
echo "<p>";
$items = mysql_query($sql);
echo mysql_error();
if(mysql_num_rows($items)>0)
{
while ($item = mysql_fetch_array($items))
{
$cou++;
$online = mysql_fetch_array(mysql_query("SELECT sex, uicon FROM mx_users WHERE id='".$item[0]."'"));

if($online[1]=="")
{
$seximg = "";
}else{
$seximg = "<img src=\"$online[1]\" alt=\"*\"/>";
}
$cname = cname($item[0]);
if(($cname == "000000")||($cname == "")){ $fonto = "";
$fontc = ""; }else{ $fonto = "<font color=\"$cname\">";
$fontc = "</font>"; }
$lnk = "$cou. $seximg<a href=\"prov.php?a=viewuser&amp;w=$item[0]\">$fonto$item[1]$fontc</a><br/><i><b>Rep Power:</b> $item[2]</i>";
echo "$lnk<br/>";

[ewanz]

if($page=="" || $page<=0)$page=1;
    $num_items = regmemcount(); //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;
 
    //changable sql
 
        $sql = "SELECT id, name, rep, , fsignature FROM mx_users ORDER BY rep DESC LIMIT $limit_start, $items_per_page";
 
    $cou = $limit_start;
    echo "<p>";
    $items = mysql_query($sql);
    echo mysql_error();
    if(mysql_num_rows($items)>0)
    {
    while ($item = mysql_fetch_array($items))
    {
      $cou++;
    $online = mysql_fetch_array(mysql_query("SELECT sex, uicon FROM mx_users WHERE id='".$item[0]."'"));
 
 if($online[1]=="")
 {
 $seximg = "";
}else{
 $seximg = "<img src=\"$online[1]\" alt=\"*\"/>";
 }
 $cname = cname($item[0]);
 if(($cname == "000000")||($cname == "")){ $fonto = "";
 $fontc = ""; }else{ $fonto = "<font color=\"$cname\">";
 $fontc = "</font>"; }

$ewanz = htmlentities($item[3], ENT_QUOTES); 

      $lnk = "$cou. $seximg<a  href=\"prov.php?a=viewuser&amp;w=$item[0]\">$fonto$item[1]$fontc</a><br/><i><b>Rep  Power:</b> $item[2]<br/>Forum Signature: $ewanz</i>";
      echo "$lnk<br/>"; 

try this code above awan..

[awan]

bty , how to create new rows fsignature in table mx_users?

[ewanz]

open your notepad.. just paste this code.. u can save it as .txt or .sql ... then just import it in your table mate..

ALTER TABLE `mx_users` ADD `fsignature` varchar( 50) NOT NULL default 'I Love Mygenkz';

[awan]

awan

open your notepad.. just paste this code.. u can save it as .txt or .sql ... then just import it in your table mate..

ALTER TABLE `mx_users` ADD `fsignature` varchar( 50) NOT NULL default 'I Love Mygenkz';

An0ther method please? By using phpadmin tool .

[metulj]

An0ther method please? By using phpadmin tool .

''how to''... using phpmyadmin has been explained even with screenshot..
so... start to read/search before you asking for help !
also topic signature code been posted before,
yet you are to lazy to search, you just make new topic...
stop being lazy !