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

 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/O Code)
 When Deleteing A Member		  New Topic  Reply to Topic
 Printer Friendly
Next Page
Author Previous Topic Topic Next Topic
Page: of 2

leatherlips
Senior Member

USA
1838 Posts
Posted - 31 March 2008 :  20:41:16  Show Profile  Visit leatherlips's Homepage  Reply with Quote
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

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 31 March 2008 :  20:45:48  Show Profile  Send ruirib a Yahoo! Message  Reply with Quote
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
Go to Top of Page

leatherlips
Senior Member

USA
1838 Posts
Posted - 31 March 2008 :  20:53:19  Show Profile  Visit leatherlips's Homepage  Reply with Quote
I just don't know how to do that. <
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
Go to Top of Page

phy1729
Average Member

USA
589 Posts
Posted - 31 March 2008 :  21:10:18  Show Profile  Reply with Quote
"SELECT M_NAME FROM " & strMemberTablePrefix & "MEMBERS WHERE MEMBER_ID = " & Member_ID<
Edited by - phy1729 on 31 March 2008 21:10:38
Go to Top of Page

phy1729
Average Member

USA
589 Posts
Posted - 31 March 2008 :  21:28:23  Show Profile  Reply with Quote
In pop_delete.asp line 694-696

			case "Member"
				Response.Write("Member")
			case "Category"

to

			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.<
Go to Top of Page

leatherlips
Senior Member

USA
1838 Posts
Posted - 31 March 2008 :  21:38:11  Show Profile  Visit leatherlips's Homepage  Reply with Quote
Perfect! Thank you so much! <
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
Go to Top of Page

phy1729
Average Member

USA
589 Posts
Posted - 31 March 2008 :  21:40:22  Show Profile  Reply with Quote
Your welcome.<
Go to Top of Page

Shaggy
Support Moderator

Ireland
6780 Posts
Posted - 01 April 2008 :  04:21:04  Show Profile  Reply with Quote
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:

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.”
Go to Top of Page

phy1729
Average Member

USA
589 Posts
Posted - 01 April 2008 :  07:04:52  Show Profile  Reply with Quote
Well that makes modding easier. Thanks Shaggy.
New Code:

			case "Member"
				Response.Write("Member <br> " & getMemberName(Member_ID))
			case "Category"
<
Edited by - phy1729 on 01 April 2008 07:05:11
Go to Top of Page

Shaggy
Support Moderator

Ireland
6780 Posts
Posted - 01 April 2008 :  07:56:52  Show Profile  Reply with Quote
You're welcome

<
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

PPSSWeb
Junior Member

312 Posts
Posted - 01 April 2008 :  09:35:12  Show Profile  Reply with Quote
This is a nice little addition to help reduce mistakes. It works for lock (pop_lock.asp) and unlock (pop_open.asp) as well.<
Go to Top of Page

TastyNutz
Junior Member

USA
251 Posts
Posted - 01 April 2008 :  09:35:43  Show Profile  Visit TastyNutz's Homepage  Reply with Quote
Nice little tweak. Thanks guys.<

PowerQuad Disability Support Forum
Go to Top of Page

Andy Humm
Average Member

United Kingdom
908 Posts
Posted - 10 April 2008 :  18:52:54  Show Profile  Reply with Quote
Nice little tweak -

Quote "It works for lock (pop_lock.asp) and unlock (pop_open.asp) as well."
Where do we amend the code to reflect the additional tweak?<
Go to Top of Page

phy1729
Average Member

USA
589 Posts
Posted - 10 April 2008 :  19:51:36  Show Profile  Reply with Quote
pop_lock.asp line 197

			case "Member"
				Response.Write("Lock Member <br> " & getMemberName(Member_ID))
			case "STopic"

pop_open.asp line 189

			case "Member"
				Response.Write("Un-Lock Member <br> " & getMemberName(Member_ID))
			case "STopic"
<
Go to Top of Page

Andy Humm
Average Member

United Kingdom
908 Posts
Posted - 11 April 2008 :  07:49:42  Show Profile  Reply with Quote
thank you ever so much..
andy<
Go to Top of Page

texanman
Junior Member

United States
410 Posts
Posted - 14 April 2008 :  12:50:29  Show Profile  Reply with Quote
Sorry guys!
These changes create a mismatch error when locking a member from the members list.<
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Next Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.21 seconds. Powered By: Snitz Forums 2000 Version 3.4.07