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/Code)
 PM Sendto Add-on (dropdown)
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

blackinwhite
Average Member

Turkey
657 Posts

Posted - 20 September 2002 :  01:44:27  Show Profile
Again small but a usefult addition, as a part of my more usable forum work.

replace your


<input name="sendto" value="<% =Request.Querystring("mname") %>" size="50">  <span class="dikkat"><a class="dikkat" href="JavaScript:pmmembers();"><strong>Üye Listesi</strong></a><br />


in your privatesend.asp with the following,


<%
Response.Write "<select name=""sendto"">"

' Declare SQL String
Dim strSQLSendto
' /Declare SQL String

' Declare Recordset Object
Dim objRSSendto
Set objRSSendto = Server.CreateObject("ADODB.Recordset")
' /Declare Recordset Object

strSQLSendto = strSQLSendto & "SELECT * FROM " & strMemberTablePrefix & "MEMBERS ORDER BY M_NAME ASC "
Set objRSSendto = my_Conn.Execute(strSQLSendto)


				Do While Not objRSSendto.EOF

Response.Write "<option value=""" & objRSSendto.Fields("M_NAME") & """"

if objRSSendto.Fields("M_NAME") = Request.Querystring("mname") then

Response.Write "selected"

end if

Response.Write ">" & objRSSendto.Fields("M_NAME") & "</option>"
				objRSSendto.MoveNext
				Loop

Response.Write "</select><br />"

objRSSendto.close
set objRSSendto = nothing
%>



that's it.

Edited by - blackinwhite on 20 September 2002 01:54:36

alex042
Average Member

USA
631 Posts

Posted - 20 September 2002 :  08:26:21  Show Profile  Send alex042 an AOL message  Send alex042 a Yahoo! Message
Is this to pull a memberlist dropdown box? With 1000's of members, that list could be quite long.
Go to Top of Page

blackinwhite
Average Member

Turkey
657 Posts

Posted - 20 September 2002 :  09:51:58  Show Profile
yeah, you're right.

People who want to implement this feature must take that into acount.

Personally I don't think it's that important, though.
Go to Top of Page

s5design
Starting Member

United Kingdom
7 Posts

Posted - 08 October 2002 :  18:58:19  Show Profile
Neat, thanks!

-Steve-
Go to Top of Page

laser
Advanced Member

Australia
3859 Posts

Posted - 09 October 2002 :  01:34:57  Show Profile
*shudder*

Apart from a drop-down with potentially thousands of members (yes, members will grow over time), what about these points :

- do you cater for locked members ? (I don't know if the current one does, but just something i thought of while looking at your SQL)

- how do you send the same message to multiple people ?
Go to Top of Page

blackinwhite
Average Member

Turkey
657 Posts

Posted - 09 October 2002 :  05:59:57  Show Profile
1. locked members can't login, so it's not a problem.
2. currently it's not implemented in the code, but you can easily add multiple member support. If I have the chance for having time, I'll do it for you.
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.18 seconds. Powered By: Snitz Forums 2000 Version 3.4.07