[For 1.8] Ban User List Page
#2
Works but:

1. Try not to hard-code the HTML, use the template system.
2. get_user() function is not something I'd use as it generates lots of queries (1 query per user). Check below, that's a query I use for my ban list.

$query = $db->write_query(sprintf("
	SELECT b.*, u2.*, u.uid AS id, u.username AS user, u.displaygroup AS dispgroup, u.usergroup AS ugroup FROM %sbanned b
	LEFT JOIN %susers u ON(b.admin = u.uid)
	LEFT JOIN %susers u2 ON(b.uid = u2.uid)
	ORDER BY b.dateline DESC
	LIMIT {$start}, {$perpage}", TABLE_PREFIX, TABLE_PREFIX, TABLE_PREFIX
));
Reply


Messages In This Thread
Ban User List Page - by Brian. - 2017-10-15, 08:57 PM
RE: Ban User List Page - by Sazze - 2017-10-16, 08:40 PM
RE: Ban User List Page - by sosanime - 2018-04-19, 10:34 PM
RE: Ban User List Page - by Omar G. - 2018-04-20, 04:22 AM
RE: Ban User List Page - by Eldenroot - 2018-04-21, 08:59 PM
RE: Ban User List Page - by Omar G. - 2018-04-21, 09:11 PM
RE: Ban User List Page - by Eldenroot - 2018-04-21, 10:16 PM
RE: Ban User List Page - by arhavili - 2020-02-20, 01:43 AM

Forum Jump:


Users browsing this thread: 1 Guest(s)