| T O P I C R E V I E W |
| leesh695 |
Posted - 02 March 2008 : 18:40:57
I want the Thank you message in post_info.asp to add the users title and name at the end.
I know I can use "" & strDBNTUserName & "" to add the name but not sure of the title can anyone help me please? 
< |
| 13 L A T E S T R E P L I E S (Newest First) |
| cgcarter1 |
Posted - 01 April 2008 : 12:00:53
I decide that having the user's number of posts was better.
For instance:
Thank you JohnQSmith for your 123456 posts!
This is how I changed your code...
If mLev > 0 Then
strSql = "SELECT M_POSTS FROM " & strMemberTablePrefix & "MEMBERS WHERE MEMBER_ID = " & MemberID
set rsMposts = Server.CreateObject("ADODB.Recordset")
rsMposts.open strSql, my_Conn
MemberPosts = rsMposts("M_POSTS")
rsMposts.close
set rsMposts = nothing
End If< |
| muzishun |
Posted - 03 March 2008 : 17:47:15
You're quite welcome.< |
| leesh695 |
Posted - 03 March 2008 : 15:38:19
Well, I have added the fix that anon posted because you both seem to agree thats better:p
Thanks again for everything < |
| muzishun |
Posted - 03 March 2008 : 14:38:46
Good idea, Anon. I agree that it could probably be done more efficiently during the login process, but I was going for "quick and dirty" to save time.< |
| AnonJr |
Posted - 03 March 2008 : 12:02:35
Why not do this instead? This way you don't hit the database if they aren't logged in... it will save you a little overhead in the long-run.
There's probably an even better way of doing it during the login process, but I'd have to go back and dig up a clean copy of the code...< |
| muzishun |
Posted - 03 March 2008 : 10:55:52
You're welcome. I forgot to include a check for users who aren't logged in. It's a fairly simple change. Make this line:
MemberTitle = rsMTitle("M_TITLE")
Look like this:
if not (rsMTitle.BOF or rsMTitle.EOF) then
MemberTitle = rsMTitle("M_TITLE")
end if
That'll cover your rear for users who aren't logged in.< |
| leesh695 |
Posted - 03 March 2008 : 09:31:01
Oh, I noticed an error when i include it in Inc_header, when people are not logged in.
"ADODB.Field error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/forum/forum/inc_header.asp, line 595"
Its not really important, It works fine just in post_info.asp.
Thanks alot for writing this for me :)< |
| leesh695 |
Posted - 03 March 2008 : 08:46:39
Worked Great, I included it in Inc_header.
Thanks loads < |
| muzishun |
Posted - 02 March 2008 : 23:44:14
This is untested, but it should work for you. You can include it in post_info.asp or in inc_header.asp, which will give you a little more flexibility with using the title on other pages.
strSql = "SELECT M_TITLE FROM " & strMemberTablePrefix & "MEMBERS WHERE MEMBER_ID = " & MemberID
set rsMTitle = Server.CreateObject("ADODB.Recordset")
rsMTitle.open strSql, my_Conn
MemberTitle = rsMTitle("M_TITLE")
rsMTitle.close
set rsMTitle = nothing< |
| leesh695 |
Posted - 02 March 2008 : 19:51:33
Thanks alot  < |
| muzishun |
Posted - 02 March 2008 : 19:49:24
I am on my way out the door just at the moment, but if nobody has replied when I get home this evening, I'll take a look. It should only be a couple lines of code.< |
| leesh695 |
Posted - 02 March 2008 : 19:31:25
Thanks for the info
Could you help me with the code for that please?
I really lack knowledge< |
| muzishun |
Posted - 02 March 2008 : 19:15:28
There's really no "quick" way to do it, since the title is not stored in any forum variables. If you only want to use it in that one location, it would be as simple as running a quick SQL query to get the user's title from the database and use it on post_info.asp. However, if you think you'll want to use it in other places as well, you might consider adding the code to inc_header.asp and storing it in a variable for use throughout your site.< |
