| Author |
 Topic  |
|
Kerry
Average Member
USA
553 Posts |
 Posted - 25 January 2001 : 09:29:59
|
Email List & Message Manager with opt-in / out feature:
- Emails all / selected users from Admin panel
- Allows saving of frequently sent messages
- Allows archiving of sent messages
- Allows creation & storing of messages before being sent.
- Allows minor Member management from Mail List panel.
- Allows users to opt-in / opt out of Forum Email Updates via their profile. (Default is to allow mail and is not presented as an option at registration so you'll at least get one in on 'em
 )
http://www.cantonweb.com/Emaillist_and_MessageManager.zip
It seems to work fine here on a standard 3.1sr4 release, but should be tested on your own development system before being used live. Please post any bugs or suggestions!
-Kerry
* No PM support yet, but it'll likley be added eventually.
Edited by - kerry on 25 January 2001
09:31:34
Updated file available:
This file is not in the zip yet - I'd like a couple of opinions first. This version has paging and should work well with either version posted here.
File:
http://www.cantonweb.com/kerrycode/admin_emaillist2.txt
Edited by - kerry on 29 January 2001 05:16:51 |
|
|
Kerry
Average Member
USA
553 Posts |
Posted - 25 January 2001 : 17:59:11
|
Note:
-If you are using HuwR's release, do not install this yet. As it stands it is incompatible but I'll be releasing a modified version for it later tonight.
-Kerry
* UPDATE - HuwR-ized version below
Edited by - kerry on 26 January 2001 00:12:50 |
 |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 25 January 2001 : 19:45:16
|
If you need a hand, I'm aboutfor an hour or two
'Resistance is futile' |
|
|
|
Kerry
Average Member
USA
553 Posts |
Posted - 26 January 2001 : 00:10:17
|
Thanks for the offer HuwR - I got back in about an hour ago (she-who-must-be-obeyed didn't let me know we had plans for the evening)
Anyway, I jumped on this as soon as I got in and I think it should be fine with your release. Anyone d/l'ing this, this has only been tested on a default install of HuwR's modified release - if you have a standard release, please use the file in the first post.
Also, I suspect neither of these will work with Richard's modified release but I'll be working on that next.
File:
http://www.cantonweb.com/HuwR-ized_Emaillist_MessageManager.zip
Please post any bugs, comments or suggestions.
-Kerry
P.S. - The term "she-who-must-be-obeyed" is referring to my wife and is a running joke only
|
|
|
|
rick7165
Senior Member
USA
1094 Posts |
Posted - 26 January 2001 : 03:06:00
|
After I added this Mod to HuwR's Mod..
"The setup ran without any errors."
I can't edit Profile now.. I get this error:
Microsoft JET Database Engine error '80040e07'
Data type mismatch in criteria expression.
/forums/pop_profile.asp, line 1193
Here is the pop_profile.asp file:
www.eastpasco.com/files/pop_profile.txt
Thanks
My Demo Site
www.eastpasco.com
BTW This Mod works Great!
Edited by - rick7165 on 26 January 2001 03:11:38 |
|
|
|
Kerry
Average Member
USA
553 Posts |
Posted - 26 January 2001 : 03:55:58
|
Got it - the problem is actually in inc_profile.asp (where the form is)
Had you changed whether or not you wanted to receive forum mail, the error would have not shown up (till someone else found it ).
THE FIX:
In inc_profile.asp look for
<!################### - kerrycode for Email List------>
<%if Request.QueryString("mode") = "goEdit" or Request.Querystring("mode") = "goModify" then
RECMAIL = RS("M_RECMAIL")
if RECMAIL = "1" then
YesNo = "No"
else
YesNo = "Yes"
end if
%>
And replace it with:
<!################### - kerrycode for Email List------>
<%if Request.QueryString("mode") = "goEdit" or Request.Querystring("mode") = "goModify" then
RECMAIL = RS("M_RECMAIL")
if RECMAIL = "1" then
YesNo = "No"
else
RECMAIL = "0"
YesNo = "Yes"
end if
%>
Let me know how it works. (Changes made to zip)
-Kerry
( 49 min. from problem > fix... I'm spending waaaaay too much time at this computer )
Edited by - kerry on 26 January 2001 12:13:52 |
|
|
|
rick7165
Senior Member
USA
1094 Posts |
Posted - 26 January 2001 : 04:07:56
|
That Fixed it!
I was just coming back in here to tell you how I got around it... You had to pick yes or no and then it would save. Even if you didn't edit anything... You had to drop the drop box down to allow it to save without the error.
Thanks,
Rick
My Demo Site
www.eastpasco.com |
|
|
|
KXS
New Member
Canada
66 Posts |
Posted - 26 January 2001 : 05:50:17
|
Nice work Kerry, I have implemented your mod, I like it...
------------------
"keeping it real" |
|
|
|
Kerry
Average Member
USA
553 Posts |
Posted - 26 January 2001 : 10:13:23
|
Thanks KXS - which version did you install?
-Kerry
|
|
|
|
Kerry
Average Member
USA
553 Posts |
Posted - 26 January 2001 : 11:22:44
|
Problem & Fix: (HuwR-ized copy only)
'Had a case of late night file version confusion so if you've recently downloaded this file, try registering a new user. If no password field is visible for user input replace you inc_profile.asp with this one:
http://www.cantonweb.com/inc_profile_HuwR3.1sr4.txt
Update included in zip file.
-Kerry
|
|
|
|
tteal
Junior Member
USA
438 Posts |
Posted - 26 January 2001 : 13:25:34
|
Kerry,
This is an outstanding mod and is very much appreciated. Only recommendation I have is that there is currently no paging. For those of us that might have tons of members, messages, etc... it takes up alot of time and resources to wait for a recordset with potentially 1000's of records.
Just a thought...
Thanks you,
Tim
Cheers,
Tim
http://www.free-guestbook.com |
|
|
|
Kerry
Average Member
USA
553 Posts |
Posted - 26 January 2001 : 13:59:53
|
Thanks Tim! And yes - paging is next on the plate but it may be a day or so before I can get to it (work just got very demanding and will likely remain so all weekend).
-Kerry
|
|
|
|
tteal
Junior Member
USA
438 Posts |
Posted - 26 January 2001 : 20:11:49
|
Kerry, one other item that I noticed and no biggie is that the actual "Members Level" is not reading from the database as to what the Administrator setup... something else to consider. Sorry and not nit-picking.
Thanks alot for your efforts, they are much appreciated!
Cheers,
Tim
http://www.free-guestbook.com |
|
|
|
Kerry
Average Member
USA
553 Posts |
Posted - 26 January 2001 : 22:03:27
|
quote:
"Members Level" is not reading from the database
I'm not sure what you mean - it *should*
breakdown by:
Admins > Moderators > Everyone else using M_Level.
-If it isn't, could it be related to SQL
server vs Access (I haven't tried it on SQL
server) ?
-Kerry
Edited by - kerry on 26 January 2001 22:04:13 |
|
|
|
stef
Starting Member
37 Posts |
Posted - 27 January 2001 : 13:02:46
|
Kerry,
This a very well done mod and is much appreciated. Thank you very much for taking the time to develop it and making it available to us.
I have noticed a minor problem however. It seems that the sorting on the email list page is a little buggy. Are you aware of this or is it just my installation. Specifically, I cannot get it to sort by Posts DESC.
Stef.
|
|
|
|
Kerry
Average Member
USA
553 Posts |
Posted - 27 January 2001 : 13:11:47
|
Nope - it's not just you, I get the same bug here (in the Standard Release only) and will look into it. Thanks for finding it!
-Kerry
Edited by - kerry on 27 January 2001 13:13:39 |
|
|
|
Topic |
|
Topic Locked
