Geeklog Forums

I've got a locked-down site because we've been hit by an excessive number of comment spammers.
We do want people to participate, so we've set them up to require an authenticated account.

Well, sometimes the auth email doesn't make it, or they don't follow the directions correctly, and the new-guy account just sits there in limbo.

I looked, but I didn't find a plugin to just display the pending user requests, so this quick patch solves that by displaying the user account status. note that I haven't gone the next step and replaced the numeric status with actual text code.. not sure how to go about that just yet as my sql skills are empty set.

anyhoo.. it's really easy. Only two changes:
-----------------
--- html/admin/user.php~ 2006-12-15 13:54:32.000000000 -0900
+++ html/admin/user.php 2006-12-15 14:11:12.000000000 -0900
@@ -264,4 +264,5 @@
array('text' => $LANG28[3], 'field' => 'username', 'sort' => true),
array('text' => $LANG28[4], 'field' => 'fullname', 'sort' => true),
array('text' => $login_text, 'field' => $login_field, 'sort' => true),
+ array('text' => 'Status', 'field' => 'status', 'sort' => true)
array('text' => $LANG28[7], 'field' => 'email', 'sort' => true)
);

$defsort_arr = array('field' => 'uid',
@@ -293,7 +292,7 @@
$join_userinfo="LEFT JOIN {$_TABLES['userinfo']} ON {$_TABLES['users']}.uid={$_TABLES['userinfo']}.uid ";
$select_userinfo=",lastlogin ";
}
- $sql = "SELECT {$_TABLES['users']}.uid,username,fullname,email,photo,regdate$select_userinfo FROM {$_TABLES['users']} $join_userinfo WHERE 1";
+ $sql = "SELECT {$_TABLES['users']}.uid,username,fullname,email,photo,status,regdate$select_userinfo FROM {$_TABLES['users']} $join_userinfo WHERE 1";

$query_arr = array('table' => 'users',
'sql' => $sql,
-------------------------

---

Training Better Artists Towards a Better Alaska.