Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Code Support: ASP (Non-Forum Related)
 Adding new M_LEVEL to db but not to forum
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Shaggy
Support Moderator

Ireland
6780 Posts

Posted - 27 August 2003 :  07:10:56  Show Profile
I am currently in the process of adding an additional M_LEVEL to my members table for use outside the forums and just wanted to double check that I have made all the necessary changes to the forum files.

The new M_LEVEL structure in the database is:

1: Ordinary User
2: New M_LEVEL (Contributor)
3: Moderator
4: Administrator

In inc_profile.asp, beginning at line 462, I have made the following changes to the member level select list (additions in green, edits in red):
Response.Write	"                      <select value=""1"" name=""Level"">" & vbNewLine & _
		"                           <option value=""1"""
if rs("M_LEVEL") = 1 then Response.Write(" selected=""selected""")
Response.Write	">Normal User</option>" & vbNewLine & _
		"                           <option value=""2"""
if rs("M_LEVEL") = 2 then Response.Write(" selected=""selected""")
Response.Write	">Contributor</option>" & vbNewLine & _In inc
		"                           <option value=""3"""
if rs("M_LEVEL") = 3 then Response.Write(" selected=""selected""")
Response.Write	">Moderator</option>" & vbNewLine & _
		"                           <option value=""4"""
if rs("M_LEVEL") = 4 then Response.Write(" selected=""selected""")
Response.Write	">Administrator</option>" & vbNewLine & _
					"                      </select>" & vbNewLine
In inc_func_common.asp, beginning at line 900, the following changes have been made to the chkUser function:
if (rsCheck("MEMBER_ID") & "" = fAuthor & "") and (cLng(rsCheck("M_LEVEL")) <> 4) then 
	chkUser = 1 '## Author
else
	select case cLng(rsCheck("M_LEVEL"))
		case 1, 2
			chkUser = 2 '## Normal User
'## lines below to be removed before implementation
'		case 3
'			chkUser = 3 '## Moderator
'		case 4
'			chkUser = 4 '## Admin
'## lines above to be removed before implementation
		case else
			chkUser = cLng(rsCheck("M_LEVEL"))
	end select
end if
Is there anything I've missed out on or done incorrectly? Any help would be appreciated.


Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.”

Davio
Development Team Member

Jamaica
12217 Posts

Posted - 27 August 2003 :  08:06:57  Show Profile
Looks good to me.
One thing you might missed is the ranking you want to display for that user. Don't know if you want to display a different ranking for the "Contributor". You find the getMember_Level function in the inc_func_member.asp file.

Support Snitz Forums
Go to Top of Page

Shaggy
Support Moderator

Ireland
6780 Posts

Posted - 27 August 2003 :  08:26:58  Show Profile
Thanks Davio. Haven't decided yet whether I want to give them different titles and/or star colours, but they both look like simple enough changes so I might just do so.


Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.”
Go to Top of Page

Shaggy
Support Moderator

Ireland
6780 Posts

Posted - 27 August 2003 :  09:27:12  Show Profile
Actually, I'll have to make changes to getMember_Level and getStar_Level anyway as it's M_LEVEL that gets passed through those functions not mlev. Cheers again, Davio, would have missed that without your post.


Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.”
Go to Top of Page

Davio
Development Team Member

Jamaica
12217 Posts

Posted - 27 August 2003 :  09:41:12  Show Profile
Hey, that's what we're here for. To steer you guys in the right direction.

Support Snitz Forums
Go to Top of Page

Shaggy
Support Moderator

Ireland
6780 Posts

Posted - 10 September 2003 :  07:20:49  Show Profile
For anyone who may be trying to implement a similar change on their own site, there are a few more files which need a bit of modification besides those mentioned in this topic. All changes are related to database M_LEVEL checks:

active_users.asp - 2 changes
admin_login.asp - 1 change
admin_login_short.asp - 1 change
admin_moderators.asp - 1 change
inc_activeusers.asp - 2 changes
inc_create_forum_access.asp - 1 change
inc_create_forum_mssql.asp - 1 change
inc_subscription.asp - 2 changes
pop_delete.asp - 9 changes
pop_lock.asp - 3 changes
pop_open.asp - 3 changes
pop_profile.asp - 1 change
post.asp - 1 change

If anyone needs help with the exact changes to be made, post back and I'll help you out.


Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.”
Go to Top of Page

VampDEATH
Starting Member

2 Posts

Posted - 27 September 2003 :  06:26:33  Show Profile
Hi there,

I am currently trying to implement extra M_Level's.

I have done pretty much the same as you MeTV... (Nice site btw) except my new M_LEVEL struicture in the database is as follows:

1: Ordinary User
2: New M_LEVEL (Clan Member)
3: Moderator
4: Administrator
5: New M_LEVEL (Clan Leader)

I believe i have made the necessary changes to the files required although i am having one slight problem i need some help with...

Ok say you have a Particular Member as M_LEVEL 4 (administrator) then if you view that person in the members list for the forum their title appears as Administrator, Unless you physically change the members title by editing their profile.

Now with the new M_LEVEL's I have choosen if i were to say put a member as M_LEVEL 2 then their title appears blank... the same hapens for the M_LEVEL 5.

to explain what i want basically the M_LEVEL 2 is a duplicate of the ordinary user with one exception... their title/Rank is Clan Member and their star ranking would still reflect the members amount of posts. The M_LEVEL 5 is a duplicate of the Administrator again with the exception that the Members title/rank would reflect CLan Leader although i would like to keep the administrator star ranking.

Some may ask why not just manually give these members new titles physically, well my answer is it's getting way to boring and tedious to update... so my answer was to implement the new M_Levels so i can update / change members easier without so much "editing" their titles.

If someone could help me out that would be much appreciated... I have played around abit with inc_func_member.asp to no avail... i fink i even broke the star count for admins and moderators as they seem to be based on normal starcount + 1 but right color.. weird neway nehelp would be much appreciated.
Go to Top of Page

VampDEATH
Starting Member

2 Posts

Posted - 27 September 2003 :  08:11:26  Show Profile
Ok fixed my problem after i went and played some more with the Ranks and Stars... I found that even though i had entered the values into the config_new table in the database it seemed they should also be referenced in the config.asp file...

If neone falls into the trap like i did i found looking at this topiv very helpful(http://forum.snitz.com/forum/topic.asp?TOPIC_ID=46874), basically it shows you all relations to the ranks as you have to modify them to allow for the extra five ranks they add...

Neway to cut a long story short my problem is fixed and all by following through another mod tutorial and filling in the gaps where i needed them filled... hehe
Go to Top of Page

D3mon
Senior Member

United Kingdom
1685 Posts

Posted - 27 September 2003 :  08:22:44  Show Profile  Visit D3mon's Homepage
Hmm, this is interesting as I've recently been considering adding a 'paid-for' section to my site and a new member level might be just the way to secure it.


Snitz 'Speedball' : Site Integration Mod : Friendly Registration Mod
"In war, the victorious strategist only seeks battle after the victory has been won"
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.3 seconds. Powered By: Snitz Forums 2000 Version 3.4.07