include("../mysql/mysql.php");
$adat_lekerd = "SELECT max(noteTime) As lastNote, forum.fID, forum.fName, csocso_members.memberName, forum.fCreateTime, forum.fView, forum.fPrefer from forum inner join csocso_members on csocso_members.counter=forum.fCreator left join forumNotes on forum.fID=forumNotes.fID where not forum.isDeleted and isVisible group by forum.fID Order by fPrefer, lastNote desc;";
$adat_lekerd_eredmeny = mysql_query($adat_lekerd, $ossz) or die(mysql_error('Hiba a lekérdezésben!'));
while($info = mysql_fetch_array($adat_lekerd_eredmeny)){
$ID = $info['fID'];
$forumNev = $info['fName'];
$letrehozo = $info['memberName'];
$letrehozas = $info['fCreateTime'];
$darab = $info['fView'];
$className = "forumNev";
if ($info['fPrefer'] == -1) {
$className = "preferforumNev";
}
$nev = $info['memberName'];
$uj = 1;
if($uj == 1){
$uj = "
";
}
else{
$uj = "";
}
$db_lekerd = "select count(*) as hszDB from forumNotes where fID=".$ID." and not isDeleted;";
$db_lekerd_eredmeny = mysql_query($db_lekerd, $ossz) or die(mysql_error('Hiba a lekérdezésben!'));
$info = mysql_fetch_array($db_lekerd_eredmeny);
$hszDB = $info['hszDB'];
$uccso_lekerd = "select memberName, IF(date(IF(date(noteTime)=curdate(),'ma',noteTime))=date_add(curdate(), interval -1 day),'tegnap',IF(date(noteTime)=curdate(),'ma',date(noteTime))) as mikor, concat_ws(':',right(concat('0',Hour(noteTime)),2), right(concat('0',Minute(noteTime)),2)) As ido from forumNotes inner join csocso_members on csocso_members.counter=forumNotes.noteWriter where fID=".$ID." and not forumNotes.isDeleted Order By fnID Desc limit 0,1;";
$uccso_lekerd_eredmeny = mysql_query($uccso_lekerd, $ossz) or die(mysql_error('Hiba a lekérdezésben!'));
$info = mysql_fetch_array($uccso_lekerd_eredmeny);
$hszUccso = $info['memberName'];
$hszIdo = $info['mikor']." ".$info['ido'];
$kiir .=
"
| ".$forumNev." ".$uj." |
| Létrehozta: ".$letrehozo." | Hozzaszólások száma: ".$hszDB." | Megtekintések száma: ".$darab." | Utolsó hozzászóló: ".$hszUccso." (".$hszIdo.") |
";
}
?>