if (!isset($_GET['rowstart']) || !isnum($_GET['rowstart'])) { $_GET['rowstart'] = 0; }
	$result = dbquery("SELECT * FROM ".DB_USER_GROUPS." WHERE group_id='".$_GET['group_id']."'");
	if (dbrows($result)) {
		$data = dbarray($result);
		$result = dbquery("SELECT * FROM ".DB_USERS." WHERE user_groups REGEXP('^\\\.{$_GET['group_id']}$|\\\.{$_GET['group_id']}\\\.|\\\.{$_GET['group_id']}$') ORDER BY user_name DESC LIMIT ".$_GET['rowstart'].",10");
		$rows = dbrows(dbquery("SELECT user_id FROM ".DB_USERS." WHERE user_groups REGEXP('^\\\.{$_GET['group_id']}$|\\\.{$_GET['group_id']}\\\.|\\\.{$_GET['group_id']}$')")); 
		if ($rows != 0) {
		opentable($data['group_name']);
		echo "<table cellpadding='0' cellspacing='0' width='100%'>\n<tr>\n";
		echo "<td align='center' colspan='2' class='tbl1'><strong>".$data['group_name']."</strong> (".sprintf((dbrows($result) == 1 ? "Пользователь" : "Пользователи"), dbrows($result)).")</td>\n";
		echo "</tr>\n<tr>\n";
		echo "<td class='tbl2'><strong>Группы пользователей</strong></td>\n";
		echo "<td align='center' width='1%' class='tbl2' style='white-space:nowrap'><strong>Тип</strong></td>\n";
		echo "</tr>\n";
		while ($data = dbarray($result)) {
			$cell_color = ($i % 2 == 0 ? "tbl1" : "tbl2"); $i++;
			echo "<tr>\n<td class='".$cell_color."'>\n".profile_link($data['user_id'], $data['user_name'])."</td>\n";
			echo "<td align='center' width='1%' class='".$cell_color."' style='white-space:nowrap'>".getuserlevel($data['user_level'])."</td>\n</tr>";
		}
		echo "</table>\n";
		closetable();
		if ($rows > 10) { echo "<div align='center' style='margin-top:5px;'>\n".makepagenav($_GET['rowstart'], 10, $rows, 3, FUSION_SELF."?group_id=".$_GET['group_id']."&")."\n</div>\n"; }
		} else {
			redirect(BASEDIR);
		}		
	} else {
		redirect(BASEDIR);
	}
Добавлено за 0.032 секунд, используя GeSHi 1.0.8.10

	$result = dbquery("SELECT * FROM ".DB_USER_GROUPS." WHERE group_id='8'");
 
	if (dbrows($result)) {
 
		$data = dbarray($result);
 
		$result = dbquery("SELECT * FROM ".DB_USERS." WHERE user_groups REGEXP('^\\\.{8}$|\\\.{8}\\\.|\\\.{8}$') ORDER BY user_name DESC");
 
		opentable($data['group_name']);
 
		echo "<table cellpadding='0' cellspacing='0' width='100%'>\n<tr>\n";
 
		echo "<td align='center' colspan='2' class='tbl1'><strong>".$data['group_name']."</strong> (".sprintf((dbrows($result) == 1 ? "Пользователь" : "Пользователи"), dbrows($result)).")</td>\n";
 
		echo "</tr>\n<tr>\n";
 
		echo "<td class='tbl2'><strong>Группы пользователей</strong></td>\n";
 
		echo "<td align='center' width='1%' class='tbl2' style='white-space:nowrap'><strong>Тип</strong></td>\n";
 
		echo "</tr>\n";
 
		while ($data = dbarray($result)) {
 
			$cell_color = ($i % 2 == 0 ? "tbl1" : "tbl2"); $i++;
 
			echo "<tr>\n<td class='".$cell_color."'>\n".profile_link($data['user_id'], $data['user_name'])."</td>\n";
 
			echo "<td align='center' width='1%' class='".$cell_color."' style='white-space:nowrap'>".getuserlevel($data['user_level'])."</td>\n</tr>";
 
		}
 
		echo "</table>\n";
 
		closetable();
 
	} else {
 
		redirect(BASEDIR);
 
	}
Добавлено за 0.020 секунд, используя GeSHi 1.0.8.10

CREATE TABLE IF NOT EXISTS `gamer_users_groups` (
  `group_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `group_name` varchar(255) NOT NULL,
  `group_description` varchar(255) NOT NULL,
  `group_color` varchar(6) NOT NULL,
  PRIMARY KEY (`group_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
Добавлено за 0.008 секунд, используя GeSHi 1.0.8.10

<?php
 
require_once "maincore.php";
require_once THEMES."templates/header.php";
include LOCALE.LOCALESET."user_fields.php";
 
$group_id = "1"; // вбиваещ ид своей группы
 
$result = dbquery("SELECT group_id, group_name FROM ".DB_USER_GROUPS." WHERE group_id='".$group_id."'");
if (dbrows($result)) {
	$data = dbarray($result);
	$result = dbquery(
		"SELECT user_id, user_name, user_level, user_status
		FROM ".DB_USERS."
		WHERE user_groups REGEXP('^\\\.{$group_id}$|\\\.{$group_id}\\\.|\\\.{$group_id}$')
		ORDER BY user_level DESC, user_name"
	);
	opentable($locale['u110']);
	echo "<table cellpadding='0' cellspacing='0' width='100%'>\n<tr>\n";
	echo "<td align='center' colspan='2' class='tbl1'><strong>".$data['group_name']."</strong>\n";
	echo "(".sprintf((dbrows($result) == 1 ? $locale['u111'] : $locale['u112']), dbrows($result)).")";
	echo "</td>\n</tr>\n<tr>\n";
	if (dbrows($result)) {
		echo "<td class='tbl2'><strong>".$locale['u113']."</strong></td>\n";
		echo "<td align='center' width='1%' class='tbl2' style='white-space:nowrap'><strong>".$locale['u114']."</strong></td>\n";
		echo "</tr>\n";
		while ($data = dbarray($result)) {
			$cell_color = ($i % 2 == 0 ? "tbl1" : "tbl2"); $i++;
			echo "<tr>\n<td class='".$cell_color."'>\n".profile_link($data['user_id'], $data['user_name'], $data['user_status'])."</td>\n";
			echo "<td align='center' width='1%' class='$cell_color' style='white-space:nowrap'>".getuserlevel($data['user_level'])."</td>\n</tr>";
		}
	}
	echo "</table>\n";
} else {
	redirect("index.php");
}
closetable();
require_once THEMES."templates/footer.php";
?>
Добавлено за 0.026 секунд, используя GeSHi 1.0.8.10