Administrative Infos about Aktiv

--> [ Aktiv ]

Querying the database for mailings to our support base

You must restrict your query to uids that have a confirmed email address!

• select * from pnom natural join persist where pstvar='idconfirmed';

Querying the database for membership fees

You must restrict your query to uids with a member status of 2 or higher!

• select * from pnom natural join asoc where asolvl>=2;

• Users with asolvl=-1 e.g. have terminated their membership
• Users with asolvl=0 or 1 may have downgraded they member status after having been a paying member

• See http://www.ffii.org/verein/profil/profil.de.txt for asolvl documentation

Automatic transfer of Aktiv user logins for Kwiki Editor use

See AktivLoginsForKwiki (private page)