Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - How to display Real name instead of user name
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

How to display Real name instead of user name
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
wwf100 View Drop Down
Newbie
Newbie


Joined: 09 May 2007
Status: Offline
Points: 5 		Post Options Post Options   Thanks (0) Thanks(0)   Quote wwf100 Quote  Post ReplyReply Direct Link To This Post Topic: How to display Real name instead of user name
    Posted: 09 May 2007 at 3:52pm
I want to display real name instead of user name. I tried modify the code in forum_topics.asp as a test, but it didn't work.

Appreciate any tips on this mod.

T
Back to Top
User123 View Drop Down
Newbie
Newbie


Joined: 11 March 2007
Status: Offline
Points: 38 		Post Options Post Options   Thanks (0) Thanks(0)   Quote User123 Quote  Post ReplyReply Direct Link To This Post Posted: 10 May 2007 at 2:15pm
This is a pretty big change as I went through this same issue myself.  There are a ton of places you have to modify.  As an example to get started if you want to try to embark on this, look at the file "forum_posts.asp".    Down around line 400 (395 in my file but other modifications may have moved this from the original source code) there is a SQL select statement.  You have to add "Author.Real_Name" to this select statement something like this:
strSQL = "" & _

"SELECT " & strDbTable & "Thread.Thread_ID, " & strDbTable
& "Thread.Message, " & strDbTable & "Thread.Message_date, "
& strDbTable & "Thread.Show_signature, " & strDbTable &
"Thread.IP_addr, " & strDbTable & "Thread.Hide, " &
strDbTable & "Author.Author_ID, " & strDbTable &
"Author.Username, " & strDbTable & "Author.Homepage, " &
strDbTable & "Author.Location, " & strDbTable &
"Author.No_of_posts, " & strDbTable & "Author.Join_date, "
& strDbTable & "Author.Signature, " & strDbTable &
"Author.Active, " & strDbTable & "Author.Avatar, " &
strDbTable & "Author.Avatar_title, " & strDbTable &
"Group.Name, " & strDbTable & "Group.Stars, " & strDbTable
& "Group.Custom_stars, " & strDbTable & "GuestName.Name, "
& strDbTable & "Author.Real_name " & _

"FROM (" & strDbTable & "Group INNER JOIN (" & strDbTable
& "Author INNER JOIN " & strDbTable & "Thread ON " &
strDbTable & "Author.Author_ID = " & strDbTable &
"Thread.Author_ID) ON " & strDbTable & "Group.Group_ID = "
& strDbTable & "Author.Group_ID) LEFT JOIN " & strDbTable
& "GuestName ON " & strDbTable & "Thread.Thread_ID = "
& strDbTable & "GuestName.Thread_ID " & _

"WHERE " & strDbTable & "Thread.Topic_ID = " & lngTopicID & " "
As you can see I added it to the end of the field list, after the last field which was GuestName.Name.  Down a little farther in the file are some inline comments about the array each record gets loaded in to: (excerpted)
...
    '6 = tblAuthor.Author_ID,
    '7 = tblAuthor.Username,
    '8 = tblAuthor.Homepage,
    '9 = tblAuthor.Location,
    ...
    '17 = tblGroup.Stars,
    '18 = tblGroup.Custom_stars
    '19 = tblGuestName.Name
Since I added Real_name after GuestName.Name, Real_name becomes element 20.  While it's not required, I added this to the comments to jog my memory if I made further changes in the future:
    '20 = tblAuthor.Real_name
This array comment list is repeated down around line 750 so I added it in both places.

Now you have to find the places where it gets the Username and replace it with the Real_name.  As you can see from the array list above, element 7 is the Username.  This means finding all references to element 7 and changing them to reference element 20.  In this particular file there is only 1 place (unless you have other modifications), around line 775:
        strUsername = sarryPosts(7,intCurrentRecord)

Change this to:
        strUsername = sarryPosts(20,intCurrentRecord)

Voila, it will now show the real name instead of the username.  Again this is only 1 of a dozen or more places you have to make similar changes.
Back to Top
wwf100 View Drop Down
Newbie
Newbie


Joined: 09 May 2007
Status: Offline
Points: 5 		Post Options Post Options   Thanks (0) Thanks(0)   Quote wwf100 Quote  Post ReplyReply Direct Link To This Post Posted: 10 May 2007 at 2:59pm
thanks, user123!
 
Actually, I did similar mod in forum_topics.asp as you did for forum_posts.asp, but it run into error of can't finding Real_name is field list. Anyway, I will try your approach to see if that works.
 
 
Back to Top
User123 View Drop Down
Newbie
Newbie


Joined: 11 March 2007
Status: Offline
Points: 38 		Post Options Post Options   Thanks (0) Thanks(0)   Quote User123 Quote  Post ReplyReply Direct Link To This Post Posted: 10 May 2007 at 3:51pm
For forum_topics.asp here's what I changed to achieve the desired results...

Changed line 299:
" " & strDbTable & "Topic.Topic_ID, " & strDbTable & "Topic.Poll_ID, " & strDbTable & "Topic.Moved_ID, " & strDbTable & "Topic.Subject, " & strDbTable & "Topic.Icon, " & strDbTable & "Topic.Start_Thread_ID, " & strDbTable & "Topic.Last_Thread_ID, " & strDbTable & "Topic.No_of_replies, " & strDbTable & "Topic.No_of_views, " & strDbTable & "Topic.Locked, " & strDbTable & "Topic.Priority, " & strDbTable & "Topic.Hide, " & strDbTable & "Thread.Message_date, " & strDbTable & "Thread.Message, " & strDbTable & "Thread.Author_ID, " & strDbTable & "Author.Username, LastThread.Message_date, LastThread.Author_ID, LastAuthor.Username, " & strDbTable & "Topic.Event_date, " & strDbTable & "Author.Real_name, LastAuthor.Real_name " & _

(Notice it has 2 additional fields, 1 for the author and one for the last post author).

Added lines 430 and 431:
'20 = tblAuthor.Author_Real_name
'21 = LastAuthor.Real_name

(Just comments for future reference)

Changed line 467:
"SELECT " & strDbTable & "Forum.Forum_ID, " & strDbTable & "Forum.Forum_name, " & strDbTable & "Forum.Forum_description, " & strDbTable & "Forum.No_of_topics, " & strDbTable & "Forum.No_of_posts, " & strDbTable & "Author.Username, " & strDbTable & "Forum.Last_post_author_ID, " & strDbTable & "Forum.Last_post_date, " & strDbTable & "Forum.Password, " & strDbTable & "Forum.Locked, " & strDbTable & "Forum.Hide, " & strDbTable & "Permissions.View_Forum, " & strDbTable & "Author.Real_name " & _

(Added Real_name field to the return list)

Added lines 854 and 855:
        '20 = tblAuthor.Author_Real_name
        '21 = LastAuthor.Real_name

(More comments)

Changed line 874:
        strTopicStartUsername = sarryTopics(20,intCurrentRecord)

(References element 20 instead of 15)

Changed line 880:
        strLastEntryUsername = sarryTopics(21,intCurrentRecord)

(References element 21 instead of 18)
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.