1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.1 XenForo and Database tables

Discussion in 'XenForo Questions and Support' started by xIsabel38, Oct 3, 2012.

  1. xIsabel38

    xIsabel38 Well-Known Member

    My developer is creating a PHP Search Engine for my website. The problem is the engine runs on the main page of the site and needs to search and show returns from the Forum and Wiki Databases.

    Going through the list, there are a ton of tables in both. If anyone happens to know what Database Table xF uses to store user posts, comments, information, and all that, it could really help a lot.

    I attached an image of a snapshot of the database listing. Obviously, that's not all of them but if any of you happen to know, then please let me know.

    Attached Files:

  2. craigiri

    craigiri Well-Known Member

    You can get some hints by looking at the size of the fields in phpmyadmin.

    xf_post seems like the one that has all the posts in it.

    xf_threads has the titles of the posts
  3. Adam Howard

    Adam Howard Well-Known Member

    xf_post == post

    xf_threads == threads

    xf_user === users

    xf_forums === forums

    It's very self explaining........ Any interest on releasing this to the community?
  4. xIsabel38

    xIsabel38 Well-Known Member

    Thanks guys. I highlighted the ones I had seen that seemed to be about posts, threads, and whatnot in that image I attached but I couldn't be sure. It's reassuring to see you guys say the same thing.

    As for this:
    I'm not sure what you mean.

Share This Page