Panelių bazė
Sveiki, jūs panelių bazėje.
Neaktyvuotų panelių: 0
Viso panelių: 377
Ieškoti panelės
Neaktyvuotų panelių: 0
Viso panelių: 377
Ieškoti panelės
Panelės peržiūra
Pavadinimas | Paskutiniai komentarai | |||
Įdėjo | MAnjack - Pateikta: 2007-07-25 - Peržiūrėta: 3025 | |||
Aprašymas | Rodo 5(arba kiek pasirinksite) komentarus panel�je. | |||
Panelė | Code opentable(\"Komentarai\");
$limit = 5;
$result = dbquery(\"SELECT * FROM \".$db_prefix.\"comments LEFT JOIN \".$db_prefix.\"users ON comment_name = user_id ORDER BY comment_datestamp DESC LIMIT 0,$limit\");
if (dbrows($result)) {
while ($data = dbarray($result)) {
if ($data['comment_type'] == \"U\") {
$place = BASEDIR.\"profile.php?lookup=\".$data['comment_item_id'];
} elseif ($data['comment_type'] == \"N\") {
$place = BASEDIR.\"news.php?readmore=\".$data['comment_item_id'];
} elseif ($data['comment_type'] == \"A\") {
$place = BASEDIR.\"readarticle.php?article_id=\".$data['comment_item_id'];
} elseif ($data['comment_type'] == \"P\") {
$place = BASEDIR.\"photogallery.php?photo_id=\".$data['comment_item_id'];
}
echo \" |
Rašyti komentarą
Turite prisijungti, norėdami parašyti komentarą.
nebloga:p:o
Klaidu pilna sitoje panelej nebaigta ji daryti seip:@ :@
kai kas nors paraso komentara ji parodo taciau kai paspaudi skaityt krc neuzeina i ta puslapi kur buvo tas komentaras parasytas :@ :D eina i news.php arba i bekuria paskutinia naujiena parasyta :D :D :@
Nu krc busiu dekingas jei sutvakytumet paciam nera laiko tvarkyt :| :)
nu gal tuoj padarysiu normalei ;)
arba kokia kita diena imesiu cia padaryta normalei
$limit = 7;
$result = dbquery("SELECT * FROM ".$db_prefix."comments LEFT JOIN ".$db_prefix."users ON comment_name = user_id ORDER BY comment_datestamp DESC LIMIT 0,$limit");
if (dbrows($result)) {
while ($data = dbarray($result)) {
if ($data['comment_type'] == "U") {
$place = BASEDIR."profile.php?lookup=".$data['comment_item_id'];
} elseif ($data['comment_type'] == "N") {
$place = BASEDIR."news.php?readmore=".$data['comment_item_id'];
} elseif ($data['comment_type'] == "A") {
$place = BASEDIR."readarticle.php?article_id=".$data['comment_item_id'];
} elseif ($data['comment_type'] == "P") {
$place = BASEDIR."photogallery.php?photo_id=".$data['comment_item_id'];
} elseif ($data['comment_type'] == "C") {
$place = BASEDIR."viewpage.php?page_id=".$data['comment_item_id'];
}
echo "
\n";
}
} else {
echo "
}
closetable();
Va biski istaisiu bet nevisiskai ir biski kai ka pakeiciau cia isvis tik biski padariau bet vis sis tas geriau dbr bent kai komentaras parasytas pridetiniame puslapyje ji galima perziureti...
Jeigu rasiu dar bugu cia pakeisiu panelke arba nauja komentara parasysiu cia ;)
i?junk smylei
?tai mano variantas. Dar prid�jau jeigu komentaras para?ytas profilyje.
<?php
opentable("Paskutiniai komentarai");
$i = 0;
$result = dbquery(
"SELECT * FROM ".$db_prefix."comments LEFT JOIN ".$db_prefix."users
ON ".$db_prefix."comments.comment_name=".$db_prefix."users.user_id
ORDER BY comment_datestamp DESC LIMIT 05"
);
if (dbrows($result)) {
echo "<table width='100%' align='center' cellpadding='0' cellspacing='1' class='tbl-border'>\n";
while ($data = dbarray($result)) {
echo "<tr>\n<td class='".($i% 2==0?"tbl1":"tbl2")."'><span class='comment-name'>";
if ($data['user_name']) {
echo "<a href='".BASEDIR."profile.php?lookup=".$data['comment_name']."' class='slink'>".$data['user_name']."</a>";
} else {
echo $data['comment_name'];
}
$comment_message = nl2br(parseubb($data['comment_message']));
$comment_item_id = $data['comment_item_id'];
$comment_type = $data['comment_type'];
if ($data['comment_smileys'] == "1") $comment_message = parsesmileys($comment_message);
echo "</span>
<span class='small'>".$locale['041'].showdate("longdate", $data['comment_datestamp'])."</span>
".$comment_message."";
if ($data['comment_type'] == "N") {
echo "<a href='".BASEDIR."news.php?readmore=".$data['comment_item_id'].;
}
else if ($data['comment_type'] == "A") {
echo "<a href='".BASEDIR."readarticle.php?article_id=".$data['comment_item_id'].;
}
else if ($data['comment_type'] == "P") {
echo "<a href='".BASEDIR."photogallery.php?photo=".$data['comment_item_id'].;
}
else if ($data['comment_type'] == "C") {
echo "<a href='".BASEDIR."viewpage.php?page_id=".$data['comment_item_id'].;
}
else if ($data['comment_type'] == "U") {
echo "<a href='".BASEDIR."profile.php?lookup=".$data['comment_item_id'].;
}
else {
echo ;
}
echo "</td>\n</tr>\n";
$i++;
}
echo "</table>\n";
} else {
echo ;
}
closetable();
?>