| Author |
 Topic  |
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
 Posted - 07 January 2001 : 11:44:00
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
in your example page, you have a hard coded list from A-Z... and if there are no members with the letter clicked... you get a page that says "No Members Found"... this can be espeicaly detering when you have a new forum... and not many users.
what I'm saying is that you also miss the other characters that can be used in names such as !@#$%^&*() etc... so a general parse of all the names for first letters would be needed
then to list tehm and make them links that actualy search for names begining with those characters.
<center>Reinsnitz (Mike)
<font color=red>><)))'></font id=red>
"The glory of young men is their strength, and the honor of old men is their gray hair." - Proverbs 20:29
</center>
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
with only 100 members, trying to extract a list of distinct first letters crashed my computer.
The only way I can think to do it without degrading performance/crashing is to store a seperate list, then on registration do a qick check and add the first letter of the username if it is not there all ready, that way it would be a fairly small db hit to fetch the letters
thoughts ?
<font color=blue>'Resistance is futile'</font id=blue> |
 |
|
|
Indy
Starting Member
17 Posts |
Posted - 14 January 2001 : 22:31:37
|
quote:
How about this
New members.asp Demo
Paging is relative to the search results, to clear search results and show all members, just do a blank search against usernames.
Pressing the letters A..Z will search for membes whos username starts with the selected letter
'Resistance is futile'
Is there a download for this version? i.e. integrated into the members.asp page
Edited by - Indy on 14 January 2001 22:32:27 |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 15 January 2001 : 03:30:39
|
just download the linked file, and replace your members.asp with the new one.
coded using 3.1 sr4.
'Resistance is futile' |
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 15 January 2001 : 03:47:16
|
Just adding a few things to the wishlist:
- If I select a first letter, it would be nice to be able to return to the full list
- If I have select a first letter and then select a sort option it reverts back to the full list instead of sorting the members with that first letter
Nice work btw 
Pierre |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 15 January 2001 : 04:10:32
|
1. if you hit the Go button with a blank search box, it will give you all the members back.
2. I gues I could fix that.
Watch this space.
'Resistance is futile' |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 15 January 2001 : 14:37:22
|
Try this one then
Link removed, posted later in topic
It now has an 'All' option alongside the A,B.......
The sorting now works against the results rather than the whole table.
One thing I forgot, if you are an administrator, and click on the 'make moderator' link, you will get an error.
You need to add this code to pop_profile.asp
if Request.QueryString("mode") = "Moderator" then
select case Request.QueryString("action")
case "del"
strSql = "UPDATE " & strMemberTablePrefix & "MEMBERS "
strSql = strSql & " SET M_LEVEL = 1 "
strSql = strSql & " WHERE MEMBER_ID = " & Request.QueryString("ID")
my_Conn.Execute(strsql)
case "add"
strSql = "UPDATE " & strMemberTablePrefix & "MEMBERS "
strSql = strSql & " SET M_LEVEL = 2 "
strSql = strSql & " WHERE MEMBER_ID = " & Request.QueryString("ID")
my_Conn.Execute(strsql)
end select %>
<meta http-equiv="Refresh" content="2; URL=members.asp">
<% end if
Place it directly above
if strAuthType = "nt" then
if ChkAccountReg() <> "1" then %>
NOTE
If you do not have the personal Messenges mod installed, you will need to remove the references to M_PMRECEIVE
Edited by - huwr on 23 January 2001 21:02:11
Edited by - huwr on 23 January 2001 21:09:34 |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 15 January 2001 : 22:12:19
|
Huw,
You are also using the sGetColspan function that alot of people probably don't have in their inc_functions.asp, you might want to include it at the top of members.asp for those that don't have it.
I also changed: (on line #305)
this:
<td colspan="<%=sGetColspan(8, 7)%>"
to this:
<td colspan="<%=sGetColspan(9, 7)%>"
It wasn't spanning the entire table when you were logged in as Admin and clicked on a letter where there were no members. |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 16 January 2001 : 03:33:08
|
Thanks richard, I'll add the function and make the change, linked file should be fixed any minute
'Resistance is futile'
Fixed in link
Edited by - huwr on 16 January 2001 03:33:48 |
|
|
|
rick7165
Senior Member
USA
1094 Posts |
Posted - 16 January 2001 : 20:45:06
|
Doing a search and not finding a member I get this error back.
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'sGetColspan'
/Forums/members.asp, line 305
Thanks,
Rick
www.eastpasco.com
|
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 16 January 2001 : 20:49:55
|
did you try redownloading the file, I fixed this earlier today
'Resistance is futile' |
|
|
|
mot
New Member
United Kingdom
70 Posts |
Posted - 16 January 2001 : 21:02:26
|
Any clues on this error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ')'.
/forum/members.asp, line 211
Latest version of members.asp
|
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 16 January 2001 : 21:16:28
|
Urrmm, I did something rather stupid, and overwrote the wrong file, could someone who downloaded it earlier today please mail me a copy.
'Resistance is futile'
false alarm, fortunately I had been testing it on my 121 site.
Edited by - huwr on 16 January 2001 21:20:55 |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 16 January 2001 : 21:23:05
|
quote:
Any clues on this error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ')'.
/forum/members.asp, line 211
Latest version of members.asp
What where you doing when you got the error?
'Resistance is futile' |
|
|
|
mot
New Member
United Kingdom
70 Posts |
Posted - 16 January 2001 : 21:34:57
|
I typed a name in the text box but did not check any of the checkboxes.
Edited by - mot on 16 January 2001 21:35:32 |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 16 January 2001 : 21:38:23
|
Ok, that would explain it, I will put a check incase soemone does that.
'Resistance is futile'
I have fixed he file, but if you want to code it youself, change this
If Request("mode") = "search" then
to this
If Request("mode") = "search" and (srchUName = "1" or srchFName = "1" or srchLName = "1") then
Edited by - huwr on 16 January 2001 21:43:22
Edited by - huwr on 16 January 2001 21:44:01 |
|
|
|
Topic |
|
Topic Locked
