When Deleteing A Member - Posted (2046 Views)
leatherlips
Senior Member
leatherlips
Posts: 1838
1838
Sometimes when I go to delete a member I get a little apprehensive that I may accidentally delete the wrong person. I would like to have the members name appear on the pop_delete.asp page so I know I am deleting the correct person.
I have uploaded the picture below to show what I would like it to do.
I was trying to figure out how to add the member name to appear but I can't figure it out. The pop_delete.asp file is too complicated for me and I don't want to mess it up. Can anyone help? Thanks.
<
Mangione Magic Forum - The Music of Chuck Mangione
My Mods: Googiespell MOD | Link To Reply MOD | Petition MOD | Contact Page MOD | Share This Topic MOD | MP3 MOD | PageEar MOD | Google Viewer MOD
 Sort direction, for dates DESC means newest first  
 Page size 
Posted
ruirib
Snitz Forums Admin
ruirib
Posts: 26364
26364
Member_ID is passed in the query string. Any reason for not using it to retrieve the member's name from the database?<
Snitz 3.4 Readme | Like the support? Support Snitz too
Posted
leatherlips
Senior Member
leatherlips
Posts: 1838
1838
I just don't know how to do that. blush<
Mangione Magic Forum - The Music of Chuck Mangione
My Mods: Googiespell MOD | Link To Reply MOD | Petition MOD | Contact Page MOD | Share This Topic MOD | MP3 MOD | PageEar MOD | Google Viewer MOD
Posted
phy1729
Average Member
phy1729
Posts: 589
589
"SELECT M_NAME FROM " & strMemberTablePrefix & "MEMBERS WHERE MEMBER_ID = " & Member_ID<
Last edited by phy1729 on 31 March 2008, 21:10
Posted
phy1729
Average Member
phy1729
Posts: 589
589
In pop_delete.asp line 694-696
Code:

			case "Member"
				Response.Write("Member")
			case "Category"
to
Code:

			case "Member"
				strsql="SELECT M_NAME FROM " & strMemberTablePrefix & "MEMBERS WHERE MEMBER_ID = " & Member_ID
				set rs = my_Conn.Execute (strSql)
				M_NAME = rs("M_NAME")
				rs.close
				set rs = nothing
				Response.Write("Member <br> " & M_NAME)
			case "Category"
This has been tested.<
Posted
leatherlips
Senior Member
leatherlips
Posts: 1838
1838
Perfect! Thank you so much! bigsmile<
Mangione Magic Forum - The Music of Chuck Mangione
My Mods: Googiespell MOD | Link To Reply MOD | Petition MOD | Contact Page MOD | Share This Topic MOD | MP3 MOD | PageEar MOD | Google Viewer MOD
Posted
phy1729
Average Member
phy1729
Posts: 589
589
Your welcome.<
Posted
Shaggy
Support Moderator
Shaggy
Posts: 6780
6780
There's already a function in inc_func_secure.asp that returns a member's username if you pass the id through it, like so:

Code:
response.write getMemberName(Member_ID)
You may need to include inc_func_secure.asp in pop_delete.asp if it isn't already included.
<
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.”
Posted
phy1729
Average Member
phy1729
Posts: 589
589
Well that makes modding easier. Thanks Shaggy. New Code:
Code:

			case "Member"
				Response.Write("Member <br> " & getMemberName(Member_ID))
			case "Category"
<
Last edited by phy1729 on 01 April 2008, 07:05
Posted
Shaggy
Support Moderator
Shaggy
Posts: 6780
6780
You're welcome smile
<
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.”
Posted
PPSSWeb
Junior Member
PPSSWeb
Posts: 312
312
This is a nice little addition to help reduce mistakes. It works for lock (pop_lock.asp) and unlock (pop_open.asp) as well.<
You Must enter a message