Hi Josh,
thanks for the Hack. <img border="0" title="" alt="[Smile]" src="images/icons/smile.gif" /> btw. Happy new 2003!
In the meantime I thought a little bit about how to do the re: name thing without too much additional queries. As Vexalith mentioned before we already know postnumber and username of every post that is shown. Why not store these in an array. The missing names could be grabed by queries.
I think the best way would be to add a new field to w3t_Posts. Lets call it
B_ParentUserID <img border="0" title="" alt="[Roll Eyes]" src="images/icons/rolleyes.gif" /> <img border="0" title="" alt="[Wink]" src="images/icons/wink.gif" /> . Now we only need one extra query for each post and in combination with an cache-array to reduce the queries this could be a good solution.
What do you think?
Maze
