php mysql query to pull last x number of posts

[IggyP]

ive tried this fix and some other things but still cannot get a basic display of recent content in the order it was updated....theres always a couple in the middle thats out of order...

the search modules are pretty confusing to start with in vb5 but then to not work idk what i can do but wait and pray they fix it

really all i want is one "topic view" style module with a list of latest topics, posts, and comments, then one "default style" module that includes all activity but pms....shouldn't be too hard right?

--------------- Added [DATE]1458114644[/DATE] at [TIME]1458114644[/TIME] ---------------

well...i kept messing with it....

this is the best string i found so far

{"last_visit":1,"type":["vBForum_Gallery","vBForum_Link","vBForum_Poll","vBForum_Text","vBForum_Video"],"channel":["1"],"sort":{"lastcontent":"desc"},"view":"topic","exclude_type":["vBForum_PrivateMessage"]}

i think my confusion may be a bug for if i add photo content, it basically breaks....takes out things that should be listed and dont have anything to do with photo content...could be other issues, but for my current content at least that seem to display it all in a proper chronology.

btw, another thing that bugs me and seems to come up about searches of recent activity is regarding confusion when members comments, or editing....wouldnt it be nice if above the members name on these results, is said last edited by, last commented by, or last posted by above names? yes...yes it would