Index.php
<B><CENTER>Forum Dyskusyjne</CENTER></B> <? $query = \"SELECT * FROM forum_cat\"; $katalogi = $r['katalogi']; $id = $r['id']; ?> <? echo \"<table width=\"100%\" cellpadding=\"2\" cellspacing=\"1\" border=\"0\" class=\"forumline\"> <tr> <th colspan=\"2\" class=\"thCornerL\" height=\"25\" nowrap=\"nowrap\"> Forum </th> <th width=\"100\" class=\"thTop\" nowrap=\"nowrap\"> Tematy </th> </tr> <tr> <td class=\"row1\" align=\"center\" valign=\"middle\" height=\"50\"></td> <td class=\"row1\" width=\"100%\" height=\"50\"><span class=\"forumlink\"><a href=\"?s=forum/zobacz&co=$katalogi\" class=\"forumlink\"> $katalogi</a><br /> </span> <span class=\"gensmall\"> </span></td> <td class=\"row2\" align=\"center\" valign=\"middle\" height=\"50\"><span class=\"gensmall\">[<b>$ile</b>]</span></td> </tr> </TABLE> \";}?>
temat.php
<meta http-equiv=\"Content-Type\" content=\"text/html; charset=iso-8859-2\"> <? if ($linki == wszystkie){ } else { $wynik = mysql_query (\"SELECT * FROM forum WHERE kategoria='$co' ORDER BY 'id' DESC limit 5;\") or } $id = $rekord[0]; $autor2 = $rekord[1]; $email2 = $rekord[2]; $tresc2 = $rekord[3]; $tytul2 = $rekord[4]; $www2 = $rekord[5]; $gg2 = $rekord[5]; $kategorie = $rekord[6]; <td bgcolor=\"#2A2A2A\"><a href=\"?s=forum/temat&co=$temat\"><b>:: $tytul2</A></b></td> </tr> <br />\"; } ?>
Zobacz.php
<meta http-equiv=\"Content-Type\" content=\"text/html; charset=iso-8859-2\"> <? if ($linki == wszystkie){ } else { $wynik = mysql_query (\"SELECT * FROM forum WHERE kategoria='$co' ORDER BY 'id' DESC limit 5;\") or } $id = $rekord[0]; $autor2 = $rekord[1]; $email2 = $rekord[2]; $tresc2 = $rekord[3]; $tytul2 = $rekord[4]; $www2 = $rekord[5]; $gg2 = $rekord[6]; $kategorie = $rekord[7]; <td bgcolor=\"#2A2A2A\"><b>:: $tytul2</A></b></td> </tr> <tr> <td><br />$tresc2<br /></td> </tr> <tr> <td bgcolor=\"#2A2A2A\"><b>Dodał: <a href=\"mailto:$email2\">$autor2</a> <a href=\"$www2\">Strona WWW</a> <a href=\"gg:$gg2\">Gadu Gadu</a></b><br /></td></tr>\"; } ?>
Baza mysql
CREATE TABLE `forum` ( `id` tinyint(11) NOT NULL AUTO_INCREMENT, `autor2` varchar(255) NOT NULL DEFAULT '', `email2` varchar(255) NOT NULL DEFAULT '', `tresc2` text NOT NULL, `tytul2` varchar(255) NOT NULL DEFAULT '', `www2` varchar(255) NOT NULL DEFAULT '', `gg2` varchar(255) NOT NULL DEFAULT '', `kategoria` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; INSERT INTO `forum` VALUES (1, 'zava141', 'zava141@o2.pl', 'TEST', 'TEST', 'http://www.test.pl', '2384052', 'O stronie'); CREATE TABLE `forum_cat` ( `id` tinyint(11) NOT NULL AUTO_INCREMENT, `katalogi` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ; INSERT INTO `forum_cat` VALUES (1, 'O stronie'); INSERT INTO `forum_cat` VALUES (2, 'Problem'); INSERT INTO `forum_cat` VALUES (3, 'Moduly'); INSERT INTO `forum_cat` VALUES (4, 'Skorki'); INSERT INTO `forum_cat` VALUES (5, 'off topic');