MemHT Portal is a Free PHP CMS and Blog
It permit the creation and the management online of websites with few and easy steps.
It's completelly customizable, expandable and suitable for all needs.
Moderators: Moderators
Forum RSS feedReply
Exclude admins from data?
AuthorText
Jery
Junior Member
Avatar

Posts: 11
Contributes: 11

Gender: _NEUTRAL_
Online: No
Date: 06/09/2008 01:12
Exclude admins from data?
#post11536
Hi, I am working on something so I need get some data out of the user table, but I need to exclude admins.

So my question is did we have some kind of the users levels so I am able to exclude admins from data?
Delete Edit Quote
 
mem
MemHT's Dad
Admin & Developer

Avatar

Posts: 5137
Contributes: 2480

Gender: _MALE_
Online: No
Date: 06/09/2008 11:47
Re: Exclude admins from data?
#post11545
Admin accounts use different database table memht_amministratori while users are in memht_utenti
Delete Edit Quote
 
Jery
Junior Member
Avatar

Posts: 11
Contributes: 11

Gender: _NEUTRAL_
Online: No
Date: 06/09/2008 14:15
Re: Exclude admins from data?
#post11566
quote
mem:
Admin accounts use different database table memht_amministratori while users are in memht_utenti
Hmmm, did exist difference between admin user and member user in database table memht_utenti? I ask becouase I starting to play with forum so I moded him a little bit, so what I try to achieve is to exclude admins from forum statistic at the bottom of the forum first page, and I will need also this later for some other things. Before I was moded one CMS and his forum heavily, so my goal with your forum (for now, later perhaps with site) is to do the same thing. During that process I will release some of the mods, some not, so I will need to hide admins all over the plaice for different stuffs. Also I saw in main settings hide admins function, and what is that for?

So for now my main problem is to separate admins from ordinary members from database data. Any idea how to do that on shortest and safest possible way?

For example how to exclude here admins?
code
$result = $dblink->get_list("SELECT user,post FROM memht_utenti ORDER BY post DESC LIMIT 5");


Usualy I call users level from users table with WHERE, but now it seems I don't have anything to call?

Also suggestion for next version to have in memht_utenti (users?) some column which will tell is it member admin or not, or some kind users level so for example guest will be 1, members will be 2, admins 3 and etc. Also suggestions for new version, to have all database tables with english names, so others who don't understand Serbian, Bosnian or Italian will understand what that table is about. Naravno, ovo su samo prijedlozi, do tebe je da li ces ih prihvatiti ili ne. Smile
Edited: 06/09/2008 14:21
Delete Edit Quote
 
mem
MemHT's Dad
Admin & Developer

Avatar

Posts: 5137
Contributes: 2480

Gender: _MALE_
Online: No
Date: 06/09/2008 16:38
Re: Exclude admins from data?
#post11572
Of course there is difference, if you login as user, you cannot access in the admin area nor have admin rights, even if your account is called admin (it's just a nick name). A user can be moderator in the forum, nothing more.
Delete Edit Quote
 
Reply
Tags Cloud
Advertising
News Archive
Language
Help MemHT Portal
Navigator
Users Block
Hi Guest
IP: 38.103.63.59

Username
Password
New files
MemHT Wiki
Friends
MemHT Portal is a free software released under the GNU/GPL License by Miltenovik Manojlo