Hi -

I'm currently customising my forum (v7.8) to get it looking the way I want, so I'll probably be posting a bit more from now on.

Most of the queries I have had so far I have been able to find with the search, but here are two questions that I'm still having.

Firstly, my forum (health discussion) is going to have a lot of Guest users. People who a) can't be bothered logging in, or more importantly b) don't want to log in for privacy reasons. That's fine with me. However, when someone posts as a Guest, even though they enter a name, it appears as "Guest" on the forum_topics screen. Is there a way to modify this so that it actually shows their "username" that they entered previously?

Secondly, I want to put the entire forum into a table that is 750 pixels wide. Is there a way to do this through the config, because I can't find it. Otherwise, could someone please give me a pointer to where the code is? Thanks!

RC

Actually, I managed to hack something together for the first part of my question above. It's a painful UNION ALL statement. The SELECT statement on 407 (??) of forum_topics needs to be changed toL

   strSQL = "SELECT " & strDbTable & "Thread.Thread_ID, " & strDbTable & "Thread.Author_ID, " & strDbTable & "Thread.Message, " & strDbTable & "Thread.Message_date, " & strDbTable & "Author.Username, " & strDbTable & "GuestName.Name "
   strSQL = strSQL & "FROM " & strDbTable & "Author, " & strDbTable & "Thread, " & strDbTable & "GuestName "
   strSQL = strSQL & "WHERE " & strDbTable & "Author.Author_ID = " & strDbTable & "Thread.Author_ID AND "& strDbTable & "GuestName.Thread_ID = " & strDbTable & "Thread.Thread_ID AND " & strDbTable & "Thread.Topic_ID = " & lngTopicID & " "
   strSQL = strSQL & "UNION ALL "
   strSQL = strSQL & "SELECT " & strDbTable & "Thread.Thread_ID, " & strDbTable & "Thread.Author_ID, " & strDbTable & "Thread.Message, " & strDbTable & "Thread.Message_date, " & strDbTable & "Author.Username, NULL "
   strSQL = strSQL & "FROM " & strDbTable & "Author, " & strDbTable & "Thread "
   strSQL = strSQL & "WHERE " & strDbTable & "Author.Author_ID = " & strDbTable & "Thread.Author_ID AND "& strDbTable & "Thread.Topic_ID = " & lngTopicID & " AND " & strDbTable & "Thread.Thread_ID NOT IN (SELECT thread_id from " & strDbTable & "GuestName) "
   strSQL = strSQL & "ORDER BY " & strDbTable & "Thread.Message_date ASC;"

then this line:

strTopicStartUsername = rsTopic("Username")

needs to be changed to

   If rsTopic("Username") = "Guests" Then
    strTopicStartUsername = rsTopic("Name")
   Else
    strTopicStartUsername = rsTopic("Username")
   End If

Same for     

strLastEntryUsername= rsTopic("Username")

which becomes

   If rsTopic("Username") = "Guests" Then
    strLastEntryUsername= rsTopic("Name")
   Else
    strLastEntryUsername= rsTopic("Username")
   End If

There are still a few more places that I'd like to fix it, such as on the 'Last Post' section on the main screen, and down the bottom (ie "The Newest Forum Member is Guests ")

erp - one more question: what's the best way to get rid of the "stars" ranking system? Just replace the images with 1x1 clear pixels?

RC

You can just replace the stars with something else in the admin area.