Lavalair Script :(

[Guest]

Don't speak in your natal language this it say'it alesh

[Guest]

hey guys wats the code to fetch the last post on forum? how to fetch it on the main? man i tried all the quries but somethin isnt ok it just wont fetch can anyone of u gave me the code?

[futurewap]

can you give me the code to show number of registered members

[Guest]

i can give that but i too need the code to fetch last posted topic



here the code but make sure to help me too


$memid = mysql_fetch_array(mysql_query("SELECT id, name FROM ibwf_users ORDER BY regdate DESC LIMIT 0,1"));
echo "Newest Member:


sorry i gave the wrong code ill add the the registered member 2moro i have no time now

[futurewap]

cheers i would help but dont know code sorry

[futurewap]

cheers i need that code too

[Guest]

here is ur code now some one plz gimme the code to show last posted topic on main pleaseeeeeeeeeeeeeeeeeeeee


code echo "Registered Members: $norm[0] ";

[alesh]

<?
$lpt = mysql_fetch_array(mysql_query("SELECT id, name FROM ibwf_topics ORDER BY lastpost DESC LIMIT 0,1"));
$nops = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_posts"));
if($nops[0]==0)
{
$pinfo = mysql_fetch_array(mysql_query("SELECT authorid FROM ibwf_topics"));
$tluid = $pinfo[0];

}else{
$pinfo = mysql_fetch_array(mysql_query("SELECT uid FROM ibwf_posts ORDER BY dtpost DESC LIMIT 0, 1"));

$tluid = $pinfo[0];
}
$tlnm = htmlspecialchars($lpt[1]);
$tlnick = getnick_uid($tluid);
$tpclnk = "<a href=\"index.php?action=viewtpc&amp;sid=$sid&amp;t id=$lpt[0]&amp;go=last\">$tlnm</a>";
$vulnk = "<a href=\"index.php?action=viewuser&amp;sid=$sid&amp; who=$tluid\">$tlnick</a>";
echo "

last post
topic: $tpclnk
by: $vulnk";
?>[/b]

i use this... name it lastpost.php and then put include (&#39;lastpost.php&#39;); where ever u want it 2 show

[Guest]

thanks alton brother u r great and the best ever

[futurewap]

miluckass that code you gave dnt work mate it say register members but no number

[Guest]

brother do this open up ur index.php and look for registered members there is the code there just try them it will work bro its not hard to figure that code out

[futurewap]

i got codes but show as blank mate

[Guest]

ok bro ill leave for home now 2moro when i come to work ill figure the exact code out and give u ok?

[alesh]

$norm = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_users"));

echo "Registered Members: $norm[0]
";


matthew u could found this at ur statistic page

its nt so hard 2 copy and paste right?

[futurewap]

thanks