phpBB2Refugees.com Logo
Not affiliated with or endorsed by the phpBB Group

Register •  Login 

Continue the legacy...

Welcome to all phpBB2 Refugees!Wave Smilie

This site is intended to continue support for the legacy 2.x line of the phpBB2 bulletin board package. If you are a fan of phpBB2, please, by all means register, post, and help us out by offering your suggestions. We are primarily a community and support network. Our secondary goal is to provide a phpBB2 MOD Author and Styles area.

Admin Userlist

Goto page 1, 2  Next
 
Search this topic... | Search MOD Requests... | Search Box
Register or Login to Post    Index » MOD Requests  Previous TopicPrint TopicNext Topic
Author Message
Sylver Cheetah 53
Board Member



Joined: 17 Dec 2008

Posts: 426
Location: Milky Way


flag
PostPosted: Tue Mar 03, 2009 8:51 pm 
Post subject: Admin Userlist

Hy, guys! icon_smile.gif

I want Admin Userlist but there are at least three MODs for that and I just can't figure out wich one to use. icon_rolleyes.gif
I've tryed two...

This is how Simple Admin Userlist looks like:
Image link
It has a bug. It sais users who never logged in, were last logged in 1970. icon_eek.gif

And this is Admin Userlist
Image link
It's older so it has several bugs. You can only sort users by user ID. Apperantly the other sorting things do not work. I like when you open an account and you see those basic information (without reloading the page, probably javascript).

So. What's the best Admin Userlist? icon_biggrin.gif

_________________
Image link
My Forum || My Blog

phpBB2 forever! icon_smile.gif
Back to top
~Cowboy~
Board Member



Joined: 08 Dec 2008

Posts: 297
Location: Chicago


flag
PostPosted: Tue Mar 03, 2009 9:53 pm 
Post subject: Re: Admin Userlist

I have always used the second one and I like it a lot.
_________________
Image link
We are not refugees we are trail blazers. icon_wink.gif
Back to top
dogs and things
Board Member



Joined: 18 Nov 2008

Posts: 621
Location: Spain


flag
PostPosted: Tue Mar 03, 2009 10:32 pm 
Post subject: Re: Admin Userlist

You want Admin Userlist 2.0.6.
_________________
phpBB2 will never die, I hope!
Back to top
Chapter 24
Board Member



Joined: 30 Dec 2008

Posts: 36



PostPosted: Tue Mar 03, 2009 10:42 pm 
Post subject: Re: Admin Userlist

dogs and things wrote:
You want Admin Userlist 2.0.6.


That's the one I use and was going to suggest too.
Back to top
Ram
Board Member



Joined: 23 Dec 2008

Posts: 100
Location: Somewhere over the rainbow


flag
PostPosted: Wed Mar 04, 2009 7:46 am 
Post subject: Re: Admin Userlist

An other one here icon_biggrin.gif
Back to top
Red Dog
Board Member



Joined: 06 Mar 2009

Posts: 41


flag
PostPosted: Fri Mar 06, 2009 9:11 pm 
Post subject: Re: Admin Userlist

New user here, so please be nice!

How to prevent delete, deactivate and banning of main admin?
This is admin_userlist.php: http://pastebin.com/mb773e35

Please, help!
Back to top
~Cowboy~
Board Member



Joined: 08 Dec 2008

Posts: 297
Location: Chicago


flag
PostPosted: Fri Mar 06, 2009 10:35 pm 
Post subject: Re: Admin Userlist

Red Dog wrote:
New user here, so please be nice!

How to prevent delete, deactivate and banning of main admin?
This is admin_userlist.php: http://pastebin.com/mb773e35

Please, help!


The best way to keep from getting deleted as an admin is to have a strong password and change it every 2 weeks or so.

_________________
Image link
We are not refugees we are trail blazers. icon_wink.gif
Back to top
roadhog
Board Member



Joined: 19 Nov 2008

Posts: 95
Location: Central Texas


flag
PostPosted: Sat Mar 07, 2009 4:56 am 
Post subject: Re: Admin Userlist

Install this hack, (Main Admin Security):

http://www.phpbbhacks.com/download/3463
Back to top
~Cowboy~
Board Member



Joined: 08 Dec 2008

Posts: 297
Location: Chicago


flag
PostPosted: Sat Mar 07, 2009 5:57 am 
Post subject: Re: Admin Userlist

Isnt that for phpbb 2.0.10?
_________________
Image link
We are not refugees we are trail blazers. icon_wink.gif
Back to top
roadhog
Board Member



Joined: 19 Nov 2008

Posts: 95
Location: Central Texas


flag
PostPosted: Sat Mar 07, 2009 6:51 am 
Post subject: Re: Admin Userlist

Yep. Are you suggesting that it won't work with any other version?
Back to top
Red Dog
Board Member



Joined: 06 Mar 2009

Posts: 41


flag
PostPosted: Sat Mar 07, 2009 11:03 am 
Post subject: Re: Admin Userlist

roadhog wrote:
Install this hack, (Main Admin Security):
http://www.phpbbhacks.com/download/3463

I have this, but it's only preventing deletion from User Management, not from Admin Userlist. What I want is to prevent main admin deleting, deactivation or banning in Admin Userlist MOD.
The only thing that I could come out with is this:

OPEN
admin/admin_userlist.php

FIND
$sql = "SELECT u.username, g.group_id
FROM " . USERS_TABLE . " u, " . USER_GROUP_TABLE . " ug, " . GROUPS_TABLE . " g
WHERE ug.user_id = $user_id
AND u.user_id = $user_id
AND g.group_id = ug.group_id
AND g.group_single_user = 1";
if( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not obtain group information for this user', '', __LINE__, __FILE__, $sql);
}
$row = $db->sql_fetchrow($result);

AFTER, ADD (line 246)
if ( $user_id == 2 && $userdata['user_id'] != 2 )
{
message_die(GENERAL_ERROR, 'You can not delete main admin!' );
}


This is for preventing main admin deletion and it seems to work. But the the error message shows up after delete confirmation, so it's not perfect. I couldn't find a solution so far for deactivation or banning main admin... Still have a lot to lern about programming. That's why I'm here. icon_wink.gif
Back to top
drathbun
Board Member



Joined: 24 Jul 2008

Posts: 653
Location: Texas


flag
PostPosted: Sat Mar 07, 2009 3:02 pm 
Post subject: Re: Admin Userlist

Hi, and welcome.

Put your code before the $sql definition, not after. That way it will check to see if they're trying to delete user_id 2 before the sql is even written.

_________________
phpBBDoctor Blog
Back to top
~Cowboy~
Board Member



Joined: 08 Dec 2008

Posts: 297
Location: Chicago


flag
PostPosted: Sat Mar 07, 2009 5:20 pm 
Post subject: Re: Admin Userlist

roadhog wrote:
Yep. Are you suggesting that it won't work with any other version?


Not suggesting that, simply assuming it hasn't been updated is all. icon_sad.gif

Correct me if you feel I am wrong.. but, If it has not been updated, the only way to find out if it works with .23 is to install it and find out... since this is a security mod, it just doesn't seam wise for some one to install it with out being certain.. right?

The people using these mods recommended by this board might not have the expertize to know this themselves and install blindly..if it becomes a hazard or risk instead of a help how are they to know?

Not that I think your wrong to suggest it, it's just that I viewed this as a very old mod for V 2.0.10, it's last update was September 4, 2004 icon_eek.gif

_________________
Image link
We are not refugees we are trail blazers. icon_wink.gif
Back to top
Red Dog
Board Member



Joined: 06 Mar 2009

Posts: 41


flag
PostPosted: Sat Mar 07, 2009 9:18 pm 
Post subject: Re: Admin Userlist

drathbun wrote:
Hi, and welcome.
Put your code before the $sql definition, not after. That way it will check to see if they're trying to delete user_id 2 before the sql is even written.

Thanks!!!

So... maybe someone else will need this. icon_smile.gif

Code:
OPEN
admin/admin_userlist.php

FIND
            $sql = "SELECT u.username, g.group_id

BEFORE, ADD
            if ( $user_id == 2 && $userdata['user_id'] != 2 )
            {
               message_die(GENERAL_ERROR, $lang['Main_Admin_Undeleted'] );
            }

FIND
            $sql = "INSERT INTO " . BANLIST_TABLE . " ( ban_userid )

BEFORE, ADD
            if ( $user_id == 2 && $userdata['user_id'] != 2 )
            {
               message_die(GENERAL_ERROR, $lang['Main_Admin_Unbanned'] );
            }

FIND
         $sql = "SELECT user_active FROM " . USERS_TABLE . "

BEFORE, ADD
            if ( $user_id == 2 && $userdata['user_id'] != 2 )
            {
               message_die(GENERAL_ERROR, $lang['Main_Admin_Unchanged_Profile'] );
            }

OPEN
language/lang_english/lang_admin.php

FIND
//
// That's all Folks!

BEFORE, ADD
$lang['Main_Admin_Undeleted'] = 'Main Admin can\'t be deleted!';
$lang['Main_Admin_Unbanned'] = 'Main Admin can\'t be banned!';
$lang['Main_Admin_Unchanged_Profile'] = 'You can\'t modify Main Admin\'s profile!';
Back to top
~Cowboy~
Board Member



Joined: 08 Dec 2008

Posts: 297
Location: Chicago


flag
PostPosted: Sun Mar 08, 2009 1:00 am 
Post subject: Re: Admin Userlist

How effective is that code red dog? Have you tested it yet?
_________________
Image link
We are not refugees we are trail blazers. icon_wink.gif
Back to top
Display posts from previous:   
Register or Login to Post    Index » MOD Requests  Previous TopicPrint TopicNext Topic
Page 1 of 2 All times are GMT
Goto page 1, 2  Next
 
Jump to:  

Index • About • FAQ • Rules • Privacy • Search •  Register •  Login 
Not affiliated with or endorsed by the phpBB Group
Powered by phpBB2 © phpBB Group
Generated in 0.0204 seconds using 15 queries. (SQL 0.0016 Parse 0.0007 Other 0.0181)
phpBB Customizations by the phpBBDoctor.com
Template Design by DeLFlo and MomentsOfLight.com Moments of Light Logo