Deleted member n/a to Former Member - Posted (2294 Views)
Average Member
Andy Humm
Posts: 908
908
I am looking to replace a deleted member's reply name from 'n/a' to 'Former Member' in the search.asp listing
The Code which displays the author is: lines 545-548

if IsNull(Topic_LastPostAuthor) then strLastAuthor = ""
else
strLastAuthor = "<br />by: <span class=""spnMessageText"">" & profileLink(Topic_LastPostAuthorName,Topic_LastPostAuthor) & "</span>"

I have utilised this if statement within topic.asp
if Reply_MemberName = "n/a" then
Response.Write " <p><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """ color=""" & strSiteBGColor & """><b><span class=""spnMessageText"">Former Member</span></b></font><br />" & vbNewLine
else
Response.Write " <p><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """><b><span class=""spnMessageText"">" & profileLink(ChkString(Reply_MemberName,"display"),Reply_Author) & "</span></b></font><br />" & vbNewLine
end if

I can not get the if statement slotted into the search.asp to do the same text replacement
Any help would be greatly appreciated. andy

<
 Sort direction, for dates DESC means newest first  
 Page size 
Posted
Snitz Forums Admin
ruirib
Posts: 26364
26364
The posts are retrieved with an INNER JOIN. If there is no author member, the posts will not be retrieved! It's that simple!<
Posted
Junior Member
texanman
Posts: 410
410
Thanks guys
I usually don't delete a member with topics or replies. One of admins today deleted a member and that is why I was wondering. So, what I did for now was to comment out the portion of the code that shows the delete icon in members.asp. Regards<
Posted
Snitz Forums Admin
ruirib
Posts: 26364
26364
Originally posted by texanman
Thanks guys
I usually don't delete a member with topics or replies. One of admins today deleted a member and that is why I was wondering. So, what I did for now was to comment out the portion of the code that shows the delete icon in members.asp. Regards
Using the icon raises no issues, because the member is not deleted from the DB. Some data is removed and his name is changed to 'n/a', but there is a database record to be retrieved, so no data loss occurs.
The problems occur if you delete a member directly in the database, or using mod setup, for example.<
Posted
Junior Member
texanman
Posts: 410
410
Gotcha! Thanks<
You Must enter a message