[FAQ] Jot

[!Jot? &subscribe=`1` &pagination=`5` &captcha=`1` &numdir=`0` &moderated=`1` &notifyAuthor=`1` &customfields=`name,email,comment` &validate=`content:Вы забыли написать комментарий,name:Введите свое имя,email:Неправильный e-mail:email` &notify=`2` &canmoderate=`Administrator_Jot` !]

[!Jot? ... &canmoderate=`Moderator` &notify=`2`!]

[!Jot? &subscribe=`1` &pagination=`5` &captcha=`1` &numdir=`0` &moderated=`1` &customfields=`name,email,comment` &validate=`content:Вы забыли написать комментарий,name:Введите свое имя,email:Неправильный e-mail:email` &notify=`2` &canmoderate=`Administrator_Jot` !]

<?php
$jc='mod_jot_content';
$jf='mod_jot_fields';
$sc='modx_site_content';
$ua='modx_user_attributes';
$sql="SELECT $jc.content, $jc.id, $jc.uparent, $jc.createdon, (SELECT $jf.content FROM $jf WHERE $jf.label='name' AND $jc.id=$jf.id ORDER BY $jf.id) AS guestname, (SELECT $sc.pagetitle FROM $sc WHERE $jc.uparent=$sc.id ORDER BY $sc.id) AS pagetitle, (SELECT $ua.fullname FROM $ua WHERE $jc.createdby=$ua.id ORDER BY $ua.id) AS regname FROM $jc WHERE $jc.published=1 ORDER BY $jc.createdon DESC LIMIT 3";

$q=mysql_query($sql) or die(mysql_error());
while($row = mysql_fetch_array($q)){

echo '<div class="comment"><div class="ballbtm">';
echo '<div class="content"><a href="'.$row[uparent].'" class="midtxt">'.$row[pagetitle].'</a><br/>
<a href="'.$row[uparent].'#'.$row[id].'" class="darkgrey xsmltxt">'.$row[content].'</a></div>';
echo '</div>';
echo '<div class="aboutpost author">';
if ($row[guestname]==NULL)
{
echo $row[regname];
} else {
echo $row[guestname];
}
echo '</div></div>';
}
?>