think tank forum

like mine, here:

http://teh-lolums.web44.net/userlist.php

perhaps it can be applied for users only using the kill_guests() function. but i've always wondered how many people are registered here and everything.

it takes over 4 seconds to load a userlist on this forum. :) we'd definitely need some pagination.

if you're curious, then try plugging numbers into this url:
https://www.thinktankforums.com/profile.php?user_id=2000

@lucas: how about expiration for accounts registered but never confirmed via email? maybe 5 days and it's deleted, that should prune things down a bit.

bluet didn't like that idea. and you know how i feel about deleting records. :)

fair enough, just thought it would help the snr

how about 14 days? r356

it takes over 4 seconds to load a userlist on this forum. :) we'd definitely need some pagination.

heh, well yeah this forum has over 2000 registered users.

anything wrong with pagination which displays 50 users per page.

dunno if this will work but will something like it?

<?php
if (!isset($_GET['start']))
{
if (empty($_GET['start']))
{
$start = '0';
}
}
else
{
$start = $_GET['start'];
}

$sql = "SELECT * FROM ttf_user ORDER BY user_id DESC LIMIT {$start},50";
$result = mysql_query($sql);

while ($user = mysql_fetch_array($result))
{
// Display individual row here.
}

$sql = "SELECT * FROM ttf_user";
$result = mysql_query($sql);
$num_rows = mysql_num_rows($result);

if ($start = 0)
{
$link = '50';
$pagination = '<a href="userlist.php?start=' . $link . '">Next Page</a>';
}
else
{
if ($start < 0)
{
$start = '50';
}
$link = $start + 50;
$link1 = $start - 50;
$pagination = '<a href="userlist.php?start=' . $link1 . '">Previous Page</a> - <a href="userlist.php?start=' . $link . '">Next Page</a>';
}
echo $pagination;
?>

i'd recommend taking a look at http://code.google.com/p/thinktankforums/sour … /forum.php lines 51:81 for a reference of existing ttf pagination. it's the code for showing threads within a forum. not to mention it makes use of the ttf_config file for num of rows so it can be set by the admin.