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)
 Members Email Notification
 New Topic  Topic Locked
 Printer Friendly
Previous Page
Author Previous Topic Topic Next Topic
Page: of 4

Astro
Starting Member

11 Posts

Posted - 17 January 2001 :  12:47:39  Show Profile
Hi,
I have the same line you have to change and i tryed different way to do it and when i click to send the the email, he tell me i dont have permission and i am the administrator of the board.....Help!!!! please
quote:

quote:

I made this add-on based on the client email notification application written by Richard Walker (http://www.aspalliance.com/richardwalker/email/clientemail/). It will enable the Forum Admin to send email to all or selected members. suggestions, bugs and fixes please post here.
(Please use at your own risks... )

d/l : http://www.abeditions.com/forums/e_notification.zip



I can't get it work! For the first:

In the instruction it says like this:
quote:


Approx. Line 208 replace this section:

if strAuthType = "db" then

strSql = strSql & " WHERE M_NAME = '" & ChkString(Request.Form("Name"),"name") & "' "

strSql = strSql & " AND M_PASSWORD = '" & ChkString(Request.Form("Password"),"password") & "'"

end if



with:

if strAuthType = "db" then

if Request.Form("Name")<>"" then

strSql = strSql & " WHERE M_NAME = '" & ChkString(Request.Form("Name"),"name") & "' "

strSql = strSql & " AND M_PASSWORD = '" & ChkString(Request.Form("Password"),"password") & "'"

else

strSql = strSql & " WHERE M_NAME = '" & ChkString(Request.querystring("Name"),"name") & "' "

strSql = strSql & " AND M_PASSWORD = '" & ChkString(Request.querystring("Password"),"password") & "'"

end if

end if







I can't find an exact line of what you're reffering to. I can find this though:
quote:

if strAuthType = "db" then
strSql = strSql & " AND M_PASSWORD = '" & ChkString(Request.Form("Password"),"password") & "'"
end if



But there is one line missin in that one!

Why!?
When I've replaced that line with the lines you suggest. Than pop_profile works great. The bug that I can see is that when Im in the Admin home, adn Im clicking on the new link I've created, it sends me to the "admin_home" login-page!! It asks me to login again to the admin_home! Why!?

cheers
/CHEETAH



Go to Top of Page

marc
Junior Member

Belgium
175 Posts

Posted - 17 January 2001 :  13:42:12  Show Profile
quote:

The bug that I can see is that when Im in the Admin home, adn Im clicking on the new link I've created, it sends me to the "admin_home" login-page!! It asks me to login again to the admin_home! Why!?


You didn't read all the messages in this thread, did you ? Read them and you will have the answer.

Marc Valentin
Go to Top of Page

marc
Junior Member

Belgium
175 Posts

Posted - 17 January 2001 :  13:45:49  Show Profile
I am sorry, but I am waiting for the internationalised version of the forum to get back to work on this mod.

Marc Valentin
Go to Top of Page

Rob Poretti
Junior Member

Canada
435 Posts

Posted - 17 January 2001 :  18:08:16  Show Profile  Visit Rob Poretti's Homepage
I had to make a few changes to this mod to get it to work with 3.1.
At the top of each file there is this code:

<% If Session("Approval") = "15916941253" Then %> <!-- #include FILE="config.asp" --><!-- #include FILE="inc_functions.asp" --> <!-- #include FILE="inc_top.asp" -->

Changed it to this:

<!-- #include FILE="config.asp" --><% If Session(strCookieURL & "Approval") = "15916941253" Then %><!-- #include FILE="inc_functions.asp" --> <!-- #include FILE="inc_top.asp" -->

This will stop the continous looping when accessing the mod from the admin options. When replacing, don't overwrite the script.timeout code in the file e_send_it.asp

Also, I saw no need for the 'UserName' column if I wasn't using NT authenication. So I added the following 'if' statement to the username table data code:

<% if strAuthType = "nt" then %><TH bgColor="<% =strPopUpTableColor %>" align="center"><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>">UserName</FONT></TH><% end if %>
________________________________________________________________________________________________________


Hi, I'm wondering which particular files you need to do the above modifications -- The section at the top of each page for example: I checked a number of pages and they didn't have this code. Would it be to much trouble to identify which files need to be modified to make thi mod work?

Same goes with the NT Authentication conditional branch -- which file are you talking about?

I'd really like to get this mod working so any help is very much appreciated!

Cheers!



Edited by - Rob Poretti on 17 January 2001 18:09:42

Edited by - Rob Poretti on 17 January 2001 18:11:24
Go to Top of Page

Rob Poretti
Junior Member

Canada
435 Posts

Posted - 17 January 2001 :  18:54:40  Show Profile  Visit Rob Poretti's Homepage
Concerning this item....

<% If Session("Approval") = "15916941253" Then %>
<!-- #include FILE="config.asp" -->
<!-- #include FILE="inc_functions.asp" -->
<!-- #include FILE="inc_top.asp" -->

I changed all three files with this mod (e_sendit.asp, e_notification.asp, e_sendmessage.asp), to this:

<!-- #include FILE="config.asp" -->
<% If Session("Approval") = "15916941253" Then %>
<!-- #include FILE="inc_functions.asp" -->
<!-- #include FILE="inc_top.asp" -->

... and I still get "looped" back to the Admin login page. (I'm able to get to the page that defines who the email is going to -- but when I "submit" it takes me to the login page.)

Once again any help here would be appreciated!

Go to Top of Page

Davio
Development Team Member

Jamaica
12217 Posts

Posted - 17 January 2001 :  19:17:50  Show Profile
Rob, I haven't really been keeping track of this topic, but if you look at some of the admin files of the forum at the top, you will see the correct code you need to fix that. And I presume you are using SR4 release.

<!--#INCLUDE FILE="config.asp" -->
<% If Session(strCookieURL & "Approval") = "15916941253" Then %>
<!--#INCLUDE FILE="inc_functions.asp" -->
<!--#INCLUDE file="inc_top.asp" -->
Just trying to help.

*----*----*----*----*----*----*----*----*
"Even when you feel you have nothing left,
You still have prayer--And that's enough."

*----*----*----*----*----*----*----*----*
Go to Top of Page

Rob Poretti
Junior Member

Canada
435 Posts

Posted - 17 January 2001 :  23:29:11  Show Profile  Visit Rob Poretti's Homepage
Thanks Davio!

Yup the cookie differences between sr3 and 4. I figured it out and it seems to be all working! All three of the "e_XXX.asp" files needed that update.

Actually I'm using sr3 -- I've got to many of my own mods to jump into sr4 quickly. I'll get to it soon though.


Cheers!

Go to Top of Page

rick7165
Senior Member

USA
1094 Posts

Posted - 17 January 2001 :  23:40:45  Show Profile  Visit rick7165's Homepage
I've done this also and It still loops... I'm using 3.1 SR4. Here are the files I've changed maybe I'm over looking something



www.eastpasco.com/files/email.zip

Thanks,
Rick
quote:

Concerning this item....

<% If Session("Approval") = "15916941253" Then %>
<!-- #include FILE="config.asp" -->
<!-- #include FILE="inc_functions.asp" -->
<!-- #include FILE="inc_top.asp" -->

I changed all three files with this mod (e_sendit.asp, e_notification.asp, e_sendmessage.asp), to this:

<!-- #include FILE="config.asp" -->
<% If Session("Approval") = "15916941253" Then %>
<!-- #include FILE="inc_functions.asp" -->
<!-- #include FILE="inc_top.asp" -->

... and I still get "looped" back to the Admin login page. (I'm able to get to the page that defines who the email is going to -- but when I "submit" it takes me to the login page.)

Once again any help here would be appreciated!





My Demo Site
www.eastpasco.com

Edited by - rick7165 on 17 January 2001 23:43:05

Edited by - rick7165 on 17 January 2001 23:52:38

Edited by - rick7165 on 18 January 2001 03:14:54
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 18 January 2001 :  05:18:03  Show Profile
rick,

did you change:


<% If Session("Approval") = "15916941253" Then %>


to:


<% If Session(strCookieURL & "Approval") = "15916941253" Then %>
Go to Top of Page

rick7165
Senior Member

USA
1094 Posts

Posted - 18 January 2001 :  05:38:42  Show Profile  Visit rick7165's Homepage
Yes... This is how the e_send_it.asp looks like.. I did this to all the files.

<% If Session(strCookieURL & "Approval") = "15916941253" Then %>
<% Server.ScriptTimeout = 3600 %>
<!-- #include FILE="config.asp" -->
<!-- #include FILE="inc_functions.asp" -->
<!-- #include FILE="inc_top.asp" -->

quote:

rick,

did you change:


<% If Session("Approval") = "15916941253" Then %>


to:


<% If Session(strCookieURL & "Approval") = "15916941253" Then %>




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

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 18 January 2001 :  06:10:32  Show Profile
It needs to be like below:


<% Server.ScriptTimeout = 3600 %>
<!-- #include FILE="config.asp" -->
<% If Session(strCookieURL & "Approval") = "15916941253" Then %>
<!-- #include FILE="inc_functions.asp" -->
<!-- #include FILE="inc_top.asp" -->
Go to Top of Page

rick7165
Senior Member

USA
1094 Posts

Posted - 18 January 2001 :  06:54:25  Show Profile  Visit rick7165's Homepage
Thank You Richard... I'm learning more and more about ASP! Just not fast enough! LOL

Again Thanks!

Rick

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

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 18 January 2001 :  07:31:23  Show Profile
The reason that it has to be in that order, is strCookieURL is defined in config.asp so the way it was, strCookieURL was not defined and you got stuck in that loop because it couldn't find the cookie.
Go to Top of Page
Page: of 4 Previous Topic Topic Next Topic  
Previous 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.13 seconds. Powered By: Snitz Forums 2000 Version 3.4.07