Welcome to Geeklog, Anonymous Friday, April 12 2024 @ 11:47 am EDT

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.
 Quote

All times are EDT. The time is now 11:47 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