Пример #1
0
function view_post()
{
    global $DB;
    $View = new BoardView();
    $DB->query("SELECT\n                tp.id,\n                extract(epoch from tp.date_posted) as date_posted,\n                m.id as member_id,\n                m.name,\n                tp.body,\n                tp.member_ip,\n                t.subject,\n                t.id as thread_id,\n                m.is_admin\n              FROM\n                thread_post tp\n              LEFT JOIN\n                member m\n              ON\n                m.id=tp.member_id\n              LEFT JOIN\n                thread t\n              ON\n                t.id = tp.thread_id\n              WHERE\n                m.id IN (3122,6100,3122,6050,8879)\n              ORDER BY\n                random()\n              LIMIT 1");
    $data = $View->prep_data($DB->load_array());
    print "[quote]{$data['3']} posted this on {$data['date']}\n";
    print strip_tags($data[4]);
    print "[/quote]";
    exit;
}