Дневники под johncms 3.x

$req_user222 = mysql_query("SELECT * FROM `users` WHERE `id` = '".$res222['userid']."' LIMIT 1");
	  $datauser222 = mysql_fetch_assoc($req_user222);
	    
	  $total = mysql_result(mysql_query("SELECT COUNT(*) FROM `dnevniki` WHERE `dnid` = 'com' AND `com_id` = '".$id."'"), 0); 
	    	    
	  $req = mysql_query("SELECT * FROM `dnevniki` WHERE `dnid` = 'com' AND `com_id` = '".$id."' ORDER BY `vr` DESC LIMIT $start,10");
    while ($res = mysql_fetch_assoc($req))
    {
      $req_user = mysql_query("SELECT * FROM `users` WHERE `id` = '".$res['userid']."' LIMIT 1");
      if (mysql_num_rows($req_user))
      {
      	$datauser = mysql_fetch_assoc($req_user);
 
     	  echo ($i % 2) ? '<div class="list2">' : '<div class="list1">';
        echo show_user($datauser, 1, 0, $str = '', $text = '', $sub = '');
        echo '<span class="gray"><b><small>('.date("d.m.y | H:i", $res['vr']).')</small></b></span><br />';
        $text=$res['text'];
		    $text=checkout($text, 1, 1);
		    $text = smileys($text, $datauser['rights'] ? 1 : 0);
        echo $text;
        if ($res['last_mod']) echo '<br /><span class="gray"><small>Изм. <b>'.$res['mod_who'].'</b> ('.date("d.m.y | H:i", $res['last_mod']).')</small></span>';
        if ($user_id==$res['userid'] or ($rights >= 6 and $rights > $datauser['rights']))
          echo '<div class="sub"><a href="?act=editcom&amp;id='.$res['id'].'">Изменить</a> | <a href="?act=del&amp;id='.$res['id'].'">Удалить</a></div>';
        echo '</div>'; 
      }

      ++$i;
    }