Доска объявлений for JohnCMS 6.x.x

<?php
    $trader = mysql_fetch_assoc(mysql_query("SELECT `id`, `name` FROM `users` WHERE `id` = " . $id));
    if($trader){
        echo '<div class="phdr">Активные объявления <b>' . $trader['name'] . '</b></div>';
        $req = mysql_query("SELECT * FROM `board_ads` WHERE `status` = 1 AND `user_id` = " . $trader['id']);
        $total = mysql_num_rows($req);
        if($total > 0){
            if($total > $kmess)
    		    echo '<div class="topmenu" style="text-align: center;">' . functions::display_pagination('index.php?do=my_trade&amp;id=' . $trader['id'] . '&amp;', $start, $total, $kmess) . '</div>';
    	    While($res = mysql_fetch_assoc($req)){
        	    echo ($i % 2) ? '<div class="list1">' : '<div class="list2">';
                echo  functions::image('board.png') . '<a href="./?do=view&amp;id=' . $res['id'] . '">' . $res['name'] . '</a>';
                echo '</div>';
    	    }
    		if($total > $kmess)
    		    echo '<div class="topmenu" style="text-align: center;">' . functions::display_pagination('index.php?do=my_trade&amp;id=' . $trader['id'] . '&amp;id=' . $id . '&amp;', $start, $total, $kmess) . '</div>';
        }else{
            echo '<div class="rmenu">' . $trader['name'] . ' еще не добавлял обьявлений!</div>';
        }
    }else{
        echo '<div class="rmenu">Такого пользователя нет!</div>';
    }