Scoop -- the swiss army chainsaw of content management
Front Page Everything News Code Help! Wishlist Project Scoop Sites Dev Notes Latest CVS changes Development Activities
Scoop Box Exchange - Show Box: list_all_users 1.00

Author: theantix [Info]

Description:

This box just very simply lists all of the users, ordered by user id

Box Code:

#return nothing for non-admins
return '' unless $S->have_perm('story_admin');

my ($rv,$sth) = $S->db_select({
WHAT => 'u.nickname, u.uid',
FROM => 'users u',
ORDER_BY=> "u.uid"
});

my $return='<div class="userlist">';

if ( $rv ) {
while (my $r = $sth->fetchrow_hashref) {
$return .= '<a href="/scoop/user/uid:' . $r->{uid} . '">' . $r->{nickname} . ' <br />';
};
}

$sth->finish();

$return .= '</div>';

return $return ;
Display: Sort:
Some more info (none / 0) (#1)
by cam on Sat Mar 26, 2005 at 09:52:44 AM PST

This line;

$return .= '..... etc etc etc';

Needs the "a" tag to be closed. Also to have the users list by descending order and limit it to the last ten users replace the SQL statement with;

my ($rv,$sth) = $S->db_select({
    WHAT => 'u.nickname, u.uid',
    FROM => 'users u',
    ORDER_BY=> "u.uid DESC",
    LIMIT=> "0,10"
});

cam



User (none / 0) (#2)
by BrendaDCoulson on Thu Nov 08, 2018 at 01:22:41 AM PST

That box code facilitated me athe assignment help lot. I have tried it and it worked. I am sure you have done a lot of hard to make this statement but thanks just because of you have the access to this path.



packers and movers Pune (none / 0) (#3)
by Sumitsingh72 on Sat May 11, 2019 at 05:26:36 AM PST

Get simple Home Shifting Services in Pune with Shiftinindia More info :- movers and packers in pune packers and movers charges packers and movers charges in Pune



movers and packers in Hyderabad (none / 0) (#4)
by Sumitsingh72 on Sat May 11, 2019 at 05:27:08 AM PST

Bother Free Packers and Movers in Hyderabad through Shiftinindia More info :- movers and packers in Hyderabad packers and movers charges in Hyderabad packers and movers Pune to Mumbai



packers and movers in Mumbai (none / 0) (#6)
by varsah on Mon Jun 10, 2019 at 07:02:53 AM PST

packers and movers in Mumbai home shifting services in Mumbai packers and movers Mumbai Charges packers and movers Charges



great (none / 0) (#7)
by heenacruzl on Thu Jan 16, 2020 at 09:39:34 PM PST

I feel admired by your work and wonder how you manage this blog so well. It was great that I could see this valuable information whenever I surf the internet. Skid Racers



Menu
create account
faq
search
report bugs
Scoop Administrators Guide
Scoop Box Exchange

Scoop Site Scroller: Get one yourself!
The OpenNIC
Democratically operated Domain Name System; using Scoop since Jan. 2001.

Login
Make a new account
Username:
Password:

Hosted by ScoopHost.com Powered by Scoop
All trademarks and copyrights on this page are owned by their respective companies. Comments are owned by the Poster. The Rest 1999 The Management

create account | faq | search