View Full Version : Primary Content Article order in Database
kc3815
03-13-2014, 08:52 PM
Can anyone tell which database table the primary content article order is located in?
ForceHSS
03-13-2014, 08:59 PM
Do you mean info for cms ie posts on the cms
kc3815
03-13-2014, 11:06 PM
Yes for the CMS. I found the table with the articles but I can't locate the display order for the articles.
ForceHSS
03-13-2014, 11:11 PM
admincp/vBulletin CMS/Contact Manager
You will see the order there. Not sure if this is what you are looking for
kc3815
03-13-2014, 11:40 PM
I currently have 10 articles displayed in my primary content. Their display order is set manually. They are also the last 10 articles posted. When I sort the articles in the database by their ID they match the order od display in the CMS. However, I do not see the numbers 1-10 in any of the other table columns. I am trying to figure out where the display order (1-10) is displayed.
tbworld
03-14-2014, 05:20 AM
Unlike the forum software the CMS uses nodes. The table is 'cms_sectionorder'. What you are calling 'primary' most likely will be 'sectionid : 1' in the table.
I hope this helps. :)
--------------- Added 1394774748 at 1394774748 ---------------
This might help you a bit. :)
The query for this is located: "/packages/vbcms/collection/content/section.php" around line 278
kc3815
03-15-2014, 03:11 AM
Thanks! That was the info I needed!
tbworld
03-15-2014, 03:23 AM
Thanks! That was the info I needed!
Your welcome. :)
vBulletin® v3.8.12 by vBS, Copyright ©2000-2025, vBulletin Solutions Inc.