Welcome to Geeklog, Anonymous Wednesday, December 11 2024 @ 02:37 am EST
Geeklog Forums
Administrative Status
Status: offline
ak_hepcat
Forum User
Newbie
Registered: 04/29/02
Posts: 2
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.
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.
11
10
Quote
All times are EST. The time is now 02:37 am.
- Normal Topic
- Sticky Topic
- Locked Topic
- New Post
- Sticky Topic W/ New Post
- Locked Topic W/ New Post
- View Anonymous Posts
- Able to post
- Filtered HTML Allowed
- Censored Content