https://www.icyphoenix.com/viewtopic.php?f=30&t=871
-----------------------------------
TheSteffen
Thu 11 Jan, 2007 19:03

No none activated user count and shown
-----------------------------------
Hello @all,

if you want that users whitch are not activated shouldn't be shown in
memberlist and shouldn't be count.

OPEN [b]includes/functions.php[/b]
FIND
[codeblock]		case 'newestuser':
			$sql = "SELECT user_id, username
				FROM " . USERS_TABLE . "
				WHERE user_id <> " . ANONYMOUS . "
				ORDER BY user_id DESC
				LIMIT 1";
			break;[/codeblock]
REPLACE WITH
[codeblock]		case 'newestuser':
			$sql = "SELECT user_id, username
				FROM " . USERS_TABLE . "
				WHERE user_id <> " . ANONYMOUS . " AND user_active = 1
				ORDER BY user_id DESC
				LIMIT 1";
			break;[/codeblock]


OPEN [b]memberlist.php[/b]
FIND
[codeblock]	$sql = "SELECT count(*) AS total
		FROM " . USERS_TABLE . " u
		WHERE user_id <> " . ANONYMOUS . " AND user_active = 1
		$where_sql
		$alpha_where";[/codeblock]
REPLACE WITH
[codeblock]	$sql = "SELECT count(*) AS total
		FROM " . USERS_TABLE . " u
		WHERE user_id <> " . ANONYMOUS . " AND user_active = 1
		$where_sql
		$alpha_where";[/codeblock]

FIND
[codeblock]$sql = "SELECT u.*, t.*
	FROM " . USERS_TABLE . " u, " . THEMES_TABLE . " t
	WHERE u.user_id <> " . ANONYMOUS . "
	AND t.themes_id = u.user_style
	$where_sql
	$alpha_where
	ORDER BY $order_by";[/codeblock]
REPLACE WITH
[codeblock]$sql = "SELECT u.*, t.*
	FROM " . USERS_TABLE . " u, " . THEMES_TABLE . " t
	WHERE u.user_id <> " . ANONYMOUS . " AND user_active = 1
	AND t.themes_id = u.user_style
	$where_sql
	$alpha_where
	ORDER BY $order_by";[/codeblock]

@MG: Maybe it could be standard in IcyPhoenix.


-----------------------------------
tiolalu
Thu 11 Jan, 2007 23:04

Re: No None Activated User Count And Shown
-----------------------------------
Hi! That rules! Great work TheSteffen! (Danke viele)

It's a little bit strange when you clean users and you see that number of users goes down :? .
Can it be a standard?


-----------------------------------
Zuker
Thu 11 Jan, 2007 23:06

Re: No none activated user count and shown
-----------------------------------
Only mighty knows  :lol: 

ps: great work steffen ;)


-----------------------------------
TheSteffen
Thu 11 Jan, 2007 23:35

Re: No none activated user count and shown
-----------------------------------
It's not from me [b]Zuker[/b]  :( 

It's from phpbb... but it was important for my site.

Great you like it  :mricy:


-----------------------------------
Mighty Gorgon
Fri 12 Jan, 2007 01:42

Re: No none activated user count and shown
-----------------------------------
[quote user="TheSteffen" post="7140"]It's not from me [b]Zuker[/b]  :( 

It's from phpbb... but it was important for my site.

Great you like it  :mricy:[/quote]
He he he...

Steffen, create a poll... and when we will reach 25 votes casted we will take the decision that the major part of users did choose... :icy_lol_flag:

DemocrIcy Phoenix! :mri:


-----------------------------------
jz
Fri 12 Jan, 2007 16:23

Re: No None Activated User Count And Shown
-----------------------------------
I have to say I like it... 

I've been doing this manualy for the last two years, I think it would be a cool feature.

After all who needs non-Active Users  :mricy:


-----------------------------------
KugeLSichA
Sun 14 Jan, 2007 22:36

Re: No none activated user count and shown
-----------------------------------
I have vote now and i voted for yes.

but if MG wants to add this, the admin should see ALL users.  8)


-----------------------------------
KugeLSichA
Sun 14 Jan, 2007 22:37

Re: No none activated user count and shown
-----------------------------------
btw who have voted before TheSteffen edited his post, please vote again ;-)


-----------------------------------
jz
Mon 15 Jan, 2007 02:32

Re: No None Activated User Count And Shown
-----------------------------------
voted again  :mrorange:


-----------------------------------
z3d0
Mon 15 Jan, 2007 07:30

Re: No none activated user count and shown
-----------------------------------
personally I don't care about the number of members  :mrgreen:


-----------------------------------
tiolalu
Mon 15 Jan, 2007 10:31

Re: No None Activated User Count And Shown
-----------------------------------
Voted again :D .


-----------------------------------
Zuker
Mon 15 Jan, 2007 17:03

Re: No none activated user count and shown
-----------------------------------
[quote user="z3d0" post="7457"]personally I don't care about the number of members  :mrgreen:[/quote]

me too


-----------------------------------
Tom
Fri 19 Jan, 2007 09:08

Re: No none activated user count and shown
-----------------------------------
I like it, but it should be optional.
Like a ACP switch in user management: Show not activated users - yes / no


-----------------------------------
Mighty Gorgon
Mon 22 Jan, 2007 01:52

Re: No none activated user count and shown
-----------------------------------
Ok... added with a switch... :wink:


-----------------------------------
TheSteffen
Mon 22 Jan, 2007 02:13

Re: No none activated user count and shown
-----------------------------------
Thanks, you are the greatest  :mricy:


