- 01
- 02
- 03
- 04
- 05
- 06
- 07
- 08
- 09
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
$result = dbquery(
"SELECT a.tag_id, a.tag_name, a.tag_type, a.tag_tags, u.article_id, u.article_cat, u.article_7, u.article_6, u.article_8, u.article_subject, u.article_snippet
FROM ".DB_TAGS." a
LEFT JOIN ".DB_ARTICLES." u ON u.article_id=a.tag_name
WHERE a.tag_type = 'A' AND article_draft='0'
ORDER BY article_datestamp
DESC");
if (dbrows($result)) {
while ($data = dbarray($result)) {
if ($data['tag_tags']) {
$tags = explode(", ", $data['tag_tags']);
foreach ($tags as $values) {
if ($values == $tagname) {
echo "<tr><td class='tbl1'>";
echo "Статья: <a href='".BSFURL.article($data['article_id'])."' title='".$data['article_subject']."' class='side'><strong>".$data['article_subject']."</strong></a>"; if ($data['article_6']) { echo" (Язык: <b>".$data['article_6']."</b>) "; } if ($data['article_7']) { echo"(Тип: <b><a href='".BSFURL.articlesTypes($data['article_8'])."'>".$data['article_7']."</a></b>)";} echo"\n<br />";
echo nl2br(parsesmileys(parseubb($data['article_snippet'])))."<hr /></td>\n</tr>\n";
}
}
}
}
}
lohpider 01.06.2012 11:16 # −15
Lure Of Chaos 01.06.2012 17:59 # −3
lohpider 01.06.2012 18:02 # −13
Lure Of Chaos 01.06.2012 18:05 # +4
vistefan 01.06.2012 19:54 # +3
Lure Of Chaos 02.06.2012 00:05 # 0
vistefan 02.06.2012 11:42 # −4
eth0 02.06.2012 20:16 # 0
rat4 03.06.2012 05:47 # +2
eth0 03.06.2012 17:59 # 0
rat4 03.06.2012 18:48 # 0
eth0 04.06.2012 15:00 # 0
rat4 04.06.2012 15:59 # +1
eth0 04.06.2012 18:10 # +2
rat4 04.06.2012 19:51 # 0
Lure Of Chaos 04.06.2012 22:43 # 0
Lure Of Chaos 03.06.2012 23:15 # 0
rat4 04.06.2012 08:32 # 0
ReallyBugMeNot 03.06.2012 15:45 # 0