View file chat/index.php

<?
#-*- coding: utf-8 -*-
#Name:     chatRooms v1.0 alpha
#Author:    Nugroho Adi Prayatso
#e-mail:     hongoaoi@gmail.com
#Web:        frendzzi.tk

include_once '../sys/inc/start.php';
$doc = new document();
if ($user->group >= 1)mysql_query("DELETE FROM `chat_who` WHERE `id_user` = '$user->id'");
mysql_query("DELETE FROM `chat_who` WHERE `time` < '".(TIME-120)."'");

$doc->title = 'Chat - Rooms';
$posts = array();
$posts[] = array('icon' => array('size' => 'small', 'src' => '/sys/images/icons/admin.1.png'), 'title' => '<a href="/users.php?order=group">Administrator</a>', 'url'=>'/users.php?order=group');

$whois = '<a href="/chat/who.php">Who is online?</a> ('.mysql_result(mysql_query("SELECT COUNT(*) FROM `users_online` WHERE `request` LIKE '/chat/%'"),0).' people)</a>';

$posts[] = array('icon' => array('size' => 'small', 'src' => '/sys/images/icons/dpanel.smiles.png'), 'title' => $whois, 'url'=>'/chat/who.php');

$pages = new pages;
$pages->posts = mysql_result(mysql_query("SELECT COUNT(*) FROM `chat_rooms`"), 0); 
$pages->this_page(); 


$q = mysql_query("SELECT * FROM `chat_rooms` ORDER BY `pos` ASC LIMIT {$pages->my_start()}, {$pages->items_per_page}");

while ($chat = mysql_fetch_assoc($q)) {

    $url = "rooms.post.php?id=$chat[id]";
    $i = array('size' => 'small', 'src' => '/sys/images/icons/chat.png');
    $t = "<a href='$url'>$chat[name]</a> (".mysql_result(mysql_query("SELECT COUNT(*) FROM `chat_who` WHERE `room` = '$chat[id]'"),0)." people)</a>";
    $p = text::for_opis($chat['opis']);
    $posts[] = array('icon' => $i, 'title' => $t, 'post' => $p, 'url'=>$url);
}

if (!$posts)
    $posts[] = array('icon' => array('size' => 'small', 'src' => '/sys/images/icons/empty.png'), 'title' => 'Rooms empty');

$show = new design();
$show->assign('post', $posts);
$show->display('design.listing.tpl');

$pages->listing('?');

if ($user->group >= 4)
    $doc->act('Create rooms', 'rooms.new.php');
?>