From:user1 To:user5

[darnoldy]

Originally Posted by WetWired

The modification to the existing query would require a left joins then a left join to that left join to relink the post table for the parent post to the post table with the original posts and then to link the user table to the parent posts.

I'm sorry, I'm a UI guy--html & javascript I can do--that paragraph was so far over my head, I need binoculars to read it!

An chance you could translate it into noob for me? <G>

--don

[WetWired]

Basicly, I believe that you should be able to modify the query to get posts by adding
,parentpost.username AS parentpostusername, parentpostuser.username AS parentpostuserusername
to the SELECT part, then right before the WHERE clause, add
LEFT JOIN post AS parentpost ON post.parentid=parentpost.postid LEFT JOIN user AS parentpostuser ON parentpostuser.userid=parentpost.userid
Then in the part to construct the postbit, you would check for a valid parentpostuserusername element in the array, and if it was invalid user parentpostusername instead. I am unsure of the way that PHP represents NULL values in results from mySQL, though, and the query may not work with those changes (I am by no means an expert on mySQL, and the changes add a good deal of complexity to the query).

[darnoldy]

Okay, let me see if I get this...

What you're saying is that, at the time the thread is displayed (or, more specifically, when each post within the thread is displayed) that a query can be performed to find the poster of the parent. When this is done, one has to make arrangements in case the parent message has been deleted.

If the query is made at the time that the reply is created (I think this is how the quote bbcode gets it), then that value needs to be stored somewhere. Quote simply puts it into the body of the message. Can a field be added to the post record so that the postbit can just call it from there? In that case, even if the parent message was deleted, the "to" value would still exist and be valid.

--don

[WetWired]

Well, actually, it's a matter of soft deleted posts and back-linking to them that I was talking about, but yes if the original post was hard deleted, then the parentid field would point to the parent of the deleted post. Yes, a field could be added and you could probably fill it when the post is stored.

[mholtum]

<a href="https://vborg.vbsupport.ru/showthread.php?t=61490" target="_blank">https://vborg.vbsupport.ru/showthread.php?t=61490</a>

[why-not]

Hi

I did not forget you, I just trying to finish my expanded search mod, so I did not have time to do what I said! I have the search mode done and I am just writing the installer information. Once I have that done I will work on getting a demo up for you to try!

Sorry, for being so slow!

Sonia!

[darnoldy]

Originally Posted by why-not

Sorry, for being so slow!

no need to appologize. I can wait a bit.

--don

[4number8]

Thank you so much WetWired, My members also thank you for your work, Excellent job to btw

Works great.

[darnoldy]

Originally Posted by why-not

I just trying to finish my expanded search mod

I saw your "save draft" mod--looks very cool. I'll keep an eye open for the expanded search too!

--don

[darnoldy]

Sonia-

I notice that you're back on the forum again. Please PM me about this mod. I'm eager to move forward with this.

--don