Web Wiz Forums - A have a question (please help)

Print Page | Close Window

A have a question (please help)

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=405
Printed Date: 29 March 2026 at 6:46pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: A have a question (please help)

Posted By: worldwide1504
Subject: A have a question (please help)
Date Posted: 21 February 2003 at 6:56pm

On my boards I have it so a mod or admin can have there username different colors. But on the display_forum_topics page only WorldWide1504 and pumpkincarver are supposed to have colored names, but the colors show up on someone elses name. Any tips?

Link:
http://www24.brinkster.com/aldrich/forum/display_forum_topics.asp?ForumID=8 - http://www24.brinkster.com/aldrich/forum/display_forum_topics.asp?ForumID=8

Replies:

Posted By: worldwide1504
Date Posted: 24 February 2003 at 7:39pm

Bump...please give some suggestions. I dont understand why it wont work.

Posted By: Mikael
Date Posted: 24 February 2003 at 7:50pm

Post your "username color code" here and I will have a look.

Posted By: worldwide1504
Date Posted: 24 February 2003 at 9:17pm

First off: It works right on the display_topic_threads.asp but not on display_forum_tropics.asp .

Ok:

Dim strUsernameColor
Dim strUsernameBackColor

---------------------------------------------

        'Initalise the strSQL variable with an SQL statement to query the database to get the Author and subject from the database for the topic
        If strDatabaseType = "SQLServer" Then
            strSQL = "EXECUTE wwfSpLastAndFirstThreadAuthor @lngTopicID = " & lngTopicID
        Else
            strSQL = "SELECT tblThread.Thread_ID, tblThread.Author_ID, tblThread.Message_date, tblAuthor.Username, tblAuthor.Username_back_color, tblAuthor.Username_color "
            strSQL = strSQL & "FROM tblAuthor INNER JOIN tblThread ON tblAuthor.Author_ID = tblThread.Author_ID "
            strSQL = strSQL & "WHERE tblThread.Topic_ID = " & lngTopicID & " "
            strSQL = strSQL & "ORDER BY tblThread.Message_date ASC;"
        End If

-----------------------------------------

strUsernameColor = rsTopic("Username_color")
strUsernameBackColor = rsTopic("Username_back_color")
--------------------------------------------

<a href="JavaScript:openWin('pop_up_profile.asp?profile=<% = lngTopicStartUserID %>&ForumID=<% = intForumID %>','profile','toolbar=0,location=0,status=0,menubar=0,scrollbars=0,resizable=1,width=440,height=370')">
; font-weight: bold; font-style: normal; background-color: <% = strUsernameBackColor %>; text-decoration: none;">

<% = strTopicStartUsername %>

</a>

Posted By: Mikael
Date Posted: 25 February 2003 at 3:34am

seems to be ok, how do the database feilds "Username_back_color" and "Username_color" looks for diffrent users?

Posted By: worldwide1504
Date Posted: 25 February 2003 at 5:54pm

For the admin/mods it shows the colors (ie. black, white, red) and normal users are just blank.

Posted By: worldwide1504
Date Posted: 26 February 2003 at 7:52am

Bump, it was a few pages back and I wanted to make sure it gets read.

Posted By: worldwide1504
Date Posted: 26 February 2003 at 5:21pm

Sorry if me bumping this up is a little obnoxious, but I really want to get this problem solved.

Posted By: Mikael
Date Posted: 28 February 2003 at 11:31am

I can't see the problem in the code.... anyone?

Posted By: worldwide1504
Date Posted: 01 March 2003 at 9:31pm

Ok, thanks anyways.