Users changing their own title.. - Snitz™ Forums 2000

The Forum has been Updated

The code has been upgraded to the latest .NET core version. Please check instructions in the Community Announcements about migrating your account.

Users changing their own title.. - Posted 23 May 2006 08:57 (1388 Views)

i011877

Junior Member

Posts: 169

169

Hmm this is not actually a MOD, but kindda.. I have seen this topic before, but are not able to find it

How do I change the code, so that users can change their own title in their profile?
Anyone..<

Posted 23 May 2006 10:47

MarcelG

Retired Support Moderator

Posts: 2625

2625

i011877, search in progress. Its a small change if I'm not mistaking.<

portfolio - linkshrinker - oxle - twitter

Posted 23 May 2006 10:49

MarcelG

Retired Support Moderator

Posts: 2625

2625

Found it! http://forum.snitz.com/forum/topic.asp?ARCHIVE=true&TOPIC_ID=47643
Old topic though, so be carefull.<

portfolio - linkshrinker - oxle - twitter

Posted 23 May 2006 12:30

i011877

Junior Member

Posts: 169

169

Thanks mate!
I'll get right to it

Posted 24 May 2006 10:24

Davecl

Junior Member

Posts: 105

105

I have implemented these changes and they seem to work fine

However I was wondering if there is a way to restrict what titles people can use.. e.g they cannot use "moderator" or "admin" or any other that i wish them not to use.
Thanks.<

Dave

Posted 25 May 2006 01:30

Davecl

Junior Member

Posts: 105

105

would this work??
set rs = my_conn.Execute("SELECT M_POSTS FROM " & strMemberTablePrefix & "MEMBERS WHERE M_NAME = '" & ChkString(Request.Form("Name"), "SQLString") & "'")
if rs("M_POSTS") >= intRankLevel5 or mlev > 2 and Request.Form("Title")<> "Moderator" then
strSql = strSql & " M_TITLE = '" & ChkString(Request.Form("Title"),"SQLString") & "', "
end if
rs.Close
set rs = nothing
<

Dave

Last edited by Davecl on 25 May 2006, 01:31