| Author |
 Topic  |
|
mot
New Member
United Kingdom
70 Posts |
 Posted - 16 January 2001 : 21:52:32
|
Another sml problem, cant get the moderator function to work, added you code to pop_profile.asp as follows:
<!--#INCLUDE FILE="inc_top.asp" -->
<% end if
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
if strAuthType = "nt" then
if ChkAccountReg() <> "1" then %>
<p align="center"><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>">
<b>Note:</b> This NT account has not been registered yet, thus the profile is not available.<br>
If this is your account, <a href="register.asp?mode=Register">click here</a> to register.
</font></p>
<!--#INCLUDE FILE="inc_footer.asp" -->
Clicking moderator icon returns a 500 internal server error.
|
 |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 16 January 2001 : 21:57:40
|
Is that exactly as the code looks, if so, there should
be a new line between
Request.QueryString("ID") and my_Conn.Execute(strsql)
'Resistance is futile' |
|
|
|
mot
New Member
United Kingdom
70 Posts |
Posted - 16 January 2001 : 22:10:36
|
Thats wot you get for cuting and pasting 
Sorry HuwR problem solved
Edited by - mot on 16 January 2001 22:11:30 |
|
|
|
Astro
Starting Member
11 Posts |
Posted - 17 January 2001 : 09:50:04
|
Hi Huwr
We installed the members list with the search box at the top (the one with with the search by first name...etc,
When search for the letter A and we are suppose to have 3 pages of those, when we click on 2 for the second page, we are return to the first page of the member list. Nothing to do with the second page of the letter A. And when we go by the little scrolling box at the top we have:
Microsoft JET Database Engine (0x80040E14)
Erreur de syntaxe (opérateur absent) dans l'expression '()'.
/cgi-bin/forum/members.asp, line 214
Help!!!!! Please 
PS: I am not to lucky with your mods. My board is one of the most popular french board on the net and many members are webmasters and they are very intersting in the Snitz forum but they wait to see if we can take our board as the same level of my ubb was and we have a realy hard time with every mods we try to install. Why dont you create sections in your board with mods in beta version and finish version just like the ubb people in sites like:
http://www.ubbdev.com
http://www.ubbhackers.com
It will be helpfull for ASP newbie like me and i'm sure it will help the diffusion of you very nice Snitz board.
Thank you
Astro
highway@videotron.ca
http://www.astro23.com
Edited by - Astro on 17 January 2001 09:51:51 |
|
|
|
rick7165
Senior Member
USA
1094 Posts |
Posted - 19 January 2001 : 23:37:50
|
Got a good one....
I changed the members.asp from Country to State. Sorting works great expect for the page drop down, but the page numbers at the bottom work fine. I guess the drop down and numbers don't change pages the same..
What I need to know is can anyone "add" into the search a option to search by "State" also?
here is my members.asp file.
www.eastpasco.com/files/members.txt
Thanks,
Rick
My Demo Site
www.eastpasco.com
Edited by - rick7165 on 19 January 2001 23:39:30 |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 20 January 2001 : 11:14:56
|
This should search by state, if you don't have it enabled, it won't show the option.
New Members with State search
Here are the instructions for the make moderator link
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
The download file contains two members.asp, one called members_noPM.asp, this is for people wihout the PM Mod
Edited by - huwr on 23 January 2001 21:01:05
Edited by - huwr on 23 January 2001 21:11:09
Edited by - huwr on 23 January 2001 21:26:42 |
|
|
|
rick7165
Senior Member
USA
1094 Posts |
Posted - 20 January 2001 : 17:08:46
|
This is the error I get
Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'FORUM_MEMBERS.M_PMRECEIVE FORUM_MEMBERS.M_STATE'.
/Forums/members.asp, line 225
My Demo Site
www.eastpasco.com |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 20 January 2001 : 18:19:20
|
fixed, redownload the file.
'Resistance is futile' |
|
|
|
Kenno
Average Member
Cambodia
846 Posts |
Posted - 20 January 2001 : 22:46:29
|
Huwr,
I tried "members2.asp", and I got the following errors:
Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.
/khmersite/forum/members2.asp, line 224
Did I do something wrong?
÷§÷ Kenno ÷§÷ |
|
|
|
Kerry
Average Member
USA
553 Posts |
Posted - 20 January 2001 : 23:09:46
|
Same here.
-Kerry
|
|
|
|
rick7165
Senior Member
USA
1094 Posts |
Posted - 20 January 2001 : 23:12:08
|
Redownload the file... Works Great!
Thanks HuwR!
My Demo Site
www.eastpasco.com |
|
|
|
Kenno
Average Member
Cambodia
846 Posts |
Posted - 20 January 2001 : 23:33:08
|
quote:
Same here.
-Kerry
Kerry, I'm not sure if you encountered the same problems as mine, but if you did, try to redownload the file. Now, it's working well with me. Well done, Huwr! 
÷§÷ Kenno ÷§÷ |
|
|
|
Kenno
Average Member
Cambodia
846 Posts |
Posted - 20 January 2001 : 23:35:03
|
Huwr, do you have this "icon_mod.gif" icon? Anyway, just wanna let you know that the members.asp at your page is not funtionally well. I tried to search for a name and I got this error:
Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'FORUM_MEMBERS.M_PMRECEIVE FORUM_MEMBERS.M_STATE'.
/MushroomGrove/members.asp, line 224
÷§÷ Kenno ÷§÷ |
|
|
|
rick7165
Senior Member
USA
1094 Posts |
Posted - 20 January 2001 : 23:45:35
|
Here is the Icon
Just right click and Save As.
www.eastpasco.com/files/icon_mod.gif
Rick
My Demo Site
www.eastpasco.com |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 20 January 2001 : 23:50:22
|
You'll need this one as well: 
Kenno,
just looks like Huw left out a comma...
Edited by - Richard Kinser on 20 January 2001 23:52:01 |
|
|
|
Topic |
|
Topic Locked
