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)
 Search engine for Users		  New Topic  Topic Locked
 Printer Friendly
Previous Page | Next Page
Author Previous Topic Topic Next Topic
Page: of 9

mot
New Member

United Kingdom
70 Posts
Posted - 16 January 2001 :  21:52:32  Show Profile  Visit mot's Homepage
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.
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts
Posted - 16 January 2001 :  21:57:40  Show Profile  Visit HuwR's Homepage
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'
Go to Top of Page

mot
New Member

United Kingdom
70 Posts
Posted - 16 January 2001 :  22:10:36  Show Profile  Visit mot's Homepage
Thats wot you get for cuting and pasting
Sorry HuwR problem solved



Edited by - mot on 16 January 2001 22:11:30
Go to Top of Page

Astro
Starting Member

11 Posts
Posted - 17 January 2001 :  09:50:04  Show Profile
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
Go to Top of Page

rick7165
Senior Member

USA
1094 Posts
Posted - 19 January 2001 :  23:37:50  Show Profile  Visit rick7165's Homepage
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
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts
Posted - 20 January 2001 :  11:14:56  Show Profile  Visit HuwR's Homepage
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
Go to Top of Page

rick7165
Senior Member

USA
1094 Posts
Posted - 20 January 2001 :  17:08:46  Show Profile  Visit rick7165's Homepage
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
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts
Posted - 20 January 2001 :  18:19:20  Show Profile  Visit HuwR's Homepage
fixed, redownload the file.

'Resistance is futile'
Go to Top of Page

Kenno
Average Member

Cambodia
846 Posts
Posted - 20 January 2001 :  22:46:29  Show Profile  Visit Kenno's Homepage
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 ÷§÷
Go to Top of Page

Kerry
Average Member

USA
553 Posts
Posted - 20 January 2001 :  23:09:46  Show Profile  Visit Kerry's Homepage
Same here.

-Kerry
Go to Top of Page

rick7165
Senior Member

USA
1094 Posts
Posted - 20 January 2001 :  23:12:08  Show Profile  Visit rick7165's Homepage
Redownload the file... Works Great!

Thanks HuwR!



My Demo Site
www.eastpasco.com
Go to Top of Page

Kenno
Average Member

Cambodia
846 Posts
Posted - 20 January 2001 :  23:33:08  Show Profile  Visit Kenno's Homepage
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 ÷§÷
Go to Top of Page

Kenno
Average Member

Cambodia
846 Posts
Posted - 20 January 2001 :  23:35:03  Show Profile  Visit Kenno's Homepage
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 ÷§÷
Go to Top of Page

rick7165
Senior Member

USA
1094 Posts
Posted - 20 January 2001 :  23:45:35  Show Profile  Visit rick7165's Homepage
Here is the Icon
Just right click and Save As.

www.eastpasco.com/files/icon_mod.gif

Rick

My Demo Site
www.eastpasco.com
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts
Posted - 20 January 2001 :  23:50:22  Show Profile
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
Go to Top of Page
Page: of 9 Previous Topic Topic Next Topic  
Previous Page | Next Page
 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.22 seconds. Powered By: Snitz Forums 2000 Version 3.4.07