users & sites in tables.

Discussion in 'General' started by michealstich, Sep 16, 2014.

  1. michealstich

    michealstich New Member

    can you tell me the query to show all the sites that belong to a user? I have looked the tables isp_nodes and isp_dep but i didn´t find the relation of the sites with the users
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    the table isp_dep is a cros table. so it e.g. lonks users to websites. the website is here the parent while the user is the child. so the relation:

    isp_isp_web.doc_id = isp_dep.parent_doc_id
    isp_isp_web.doctype_id = isp_dep.parent_doctype_id
    isp_dep.child_doc_id = isp_isp_user.doc_id
    isp_dep.child_doctype_id = isp_isp_user.doctype_id

    will list you all users of a website

Share This Page