XF 1.1 XenForo and Database tables


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.



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

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?


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:
Any interest on releasing this to the community?
I'm not sure what you mean.