View Single Post
  #26  
Old 10-20-2009, 09:45 AM
gabeki gabeki is offline
Premium Member
 
Join Date: Oct 2009
Posts: 24
Gender: Female
Credits: 1,293
gabeki
Default RE: Integrated Forum V 2.0 -Released!-

hi, can you help me? :P

I installed this script in my site, and it works pretty well but it will only have 1 parent forum...

when I create another nothing changes, even if I create foruns inside it...

and the parents and foruns are being inserted in the database, so I guess it's a problem of showing and not of inserting...

here's the code where it's supposed to show all parents

PHP Code:
$table $table."

<table width='95%' border='1' align='center' cellpadding='3' cellspacing='1' class='forum'>"
;

$query "SELECT * FROM parent_forum ORDER BY pid ASC";
$result mysql_query($query);
$num3 mysql_numrows($result);

    
//Loop out code
    
$i=0;
    while (
$i $num3) {
    
$pid=@mysql_result($result,$i,"pid");
    
$ptopic=@mysql_result($result,$i,"topic");
    
$ptopic stripslashes($ptopic);

$table $table."
<tr>
<td width='100%' class='forum'><img src='images/iconforum.png'> <b>"
.$ptopic."</b></td>
</tr>
</table>
<table width='95%' border='1' align='center' cellpadding='3' cellspacing='1' class='forum'>
<tr>
<td width='55%' class='forum2' align='center'><strong>Fórum</strong></td>
<td width='10%' class='forum2' align='center'><strong>Tópicos</strong></td>
<td width='10%' class='forum2' align='center'><strong>Posts</strong></td>
<td width='20%' class='forum2' align='center'><strong>Último Post</strong></td>
</tr>"
;

$query "SELECT * FROM forum Where pid='".$pid."'";
$result mysql_query($query);
$num2 mysql_numrows($result);

    
$i=0;
    while (
$i $num2) {
    
$fid=@mysql_result($result,$i,"fid");
    
$topic=@mysql_result($result,$i,"topic");
    
$desc=@mysql_result($result,$i,"desc");
    
$posts=@mysql_result($result,$i,"posts");
    
$threads=@mysql_result($result,$i,"threads");
    
$lby=@mysql_result($result,$i,"lby");
    
$ldatetime=@mysql_result($result,$i,"ldatetime");
    
$ltopic=@mysql_result($result,$i,"ltopic");
    
$lid=@mysql_result($result,$i,"lid");
    
$topic stripslashes($topic);
    
$ltopic stripslashes($ltopic);
    
$desc stripslashes($desc);

if(
$ltopic == ""){
$lpost "<i>Nunca</i>";
}
else{
$lpost "<a href='view_topic.php?id=".$lid."'>".$ltopic."</a> por: <a href='perfil.php?user=".$lby."'>".$lby."</a><br>".$ldatetime;
}

$table $table."
<tr>
<td class='trow'><a href='main_forum.php?fid="
.$fid."'>".$topic."</a><BR><i>".$desc."</i></td>
<td align='center' class='trow'>"
.$threads."</td>
<td align='center' class='trow'>"
.$posts."</td>
<td align='center' class='trow'>"
.$lpost."</td>
</tr>"
;

    
$i++;
    }
    
$i++;
    }

$table $table."
</table><br>"

and here's the link http://www.maplepet.co.cc/main_forum2.php

ty from now. :D
__________________
My Pets site: MaplePet (Released: No)
Done: Stats system, Adoptables Sex system, Battle and using pokeballs like items to capture pets, stats (luck and dexterity) affecting the chance of capturing, Element system (8 elements), Trading, shopping, inventory system, Pet profile for each pet.
Working: Battle System againsts monsters found in the Map
Reply With Quote