Announcement

Collapse
No announcement yet.

Need database help

Collapse
This topic is closed.
X
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Need database help

    Please dont immediately delete this post, I understand this isnt the support section but at the moment I cannot access it as I am required to link the customer number ect, I dont have access to that information and this is quite urgent.

    I am currently working on my companies vBulletin forum and I just need a little advice on the database structure and how to pull a certain bit of information...

    I do not have access to the customer number or anything like that which is why I am posting here. I had originally sent support an email, however that was a week ago and i still havent heard anything.

    Here is my email, any help is massively appreciated:

    "I require assistance on how I can pull the user group/s that a particular user is attached to, or better still list all users in a particular user group... I need to do this through the database as I am trying to populate another database using the information and we have over 100,000 users so doing it by hand isnt going to be fun.

    Now that the client I am using should make any difference, but I am using MySQL Workbench.

    I would really appreciate any help you can offer on this matter."

    Regards,
    Matt

  • #2
    This query will return a simple list of users that exist in a usergroup:
    Code:
    SELECT username FROM user WHERE usergroupid = xx
    Replace 'xx' with the relevant usergroupid, these can be found in the usergroup manager section of the admincp.
    MARK.B | vBULLETIN SUPPORT

    TalkNewsUK - My vBulletin 5.5.6 Demo
    AdminAmmo - My Cloud Demo

    Comment


    • #3
      The original question has been answered. This was done as a goodwill gesture to help someone out. We don't normally provide any support for unlicensed users.
      MARK.B | vBULLETIN SUPPORT

      TalkNewsUK - My vBulletin 5.5.6 Demo
      AdminAmmo - My Cloud Demo

      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...
      X