•  BWG
  • 99.4% (Exalted)
  • YAF Lover Topic Starter
At database level, how do you determine if a user has host admin level access? I read somewhere that if the Flags field in the yaf_User table is set to 3 the user has host admin access. Can anyone:

1) Confirm if this is the case?
2) Tell me if a stored procedure exists which accepts username as a parameter and checks whether that user is a host admin?


  •  BWG
  • 99.4% (Exalted)
  • YAF Lover Topic Starter
Figured this out myself. :oops:

I've got another wich the host admin of my forum needs admin level access to. So in the the user logs in and then needs to be validated against YAF to check for Host Admin status.

1) I've modified the web.config to use the YafRoleProvider and YafMembershipProvider to get users logging into my app with their YAF credentials.

2) In my app I'ved added in references to the Yaf dlls, and then used this code to check for host admin status

bool boolAdmin = false;
int currentUserID = (int) YafContext.Current.PageUserID;

using (DataTable dt = DB.user_list(1, currentUserID, null))
DataRow row = dt.Rows[0];
var userFlags = new UserFlags(row["Flags"]);
boolAdmin = userFlags.IsHostAdmin;

Very easy to set up, and offers the level of integration I need. 😁
  •  shide
  • 80.6% (Honored)
  • YAF Lover
Thanx for your post, it helped.

However, in YAF version 2.1.1 you can find out if a user is host admin or not by calling


Hope this will help ! 😮
Evening news is where they begin with ‘Good evening’, and then proceed to tell you why it isn’t.

About Us

The YAF.NET is an open source .NET forum project. YAF.NET is supported by an team of international developers who are build community by building community software.

Powered by Resharper Donate with PayPal button

Project Twitter Updates

Copyright © YetAnotherForum.NET & Ingo Herbote. All rights reserved