Author |
Topic |
bugzy
Junior Member
USA
147 Posts |
Posted - 15 February 2001 : 19:13:20
|
awesome ! i changed MEMO to VARCHAR(8000) .. works so far
havent tested to see if the actual messaging out works yet
|
|
|
Kerry
Average Member
USA
553 Posts |
Posted - 15 February 2001 : 21:41:32
|
quote:
Anyway, I'm I think it would make a great addition and quite frankly I NEED something like this -- which is why I'd be happy to undertake it. That is, unless you're interested in doing something like this -- it's your mod after all.
So...what do you think?
Go for it! When it comes to MOD writing, the more the merrier! -Heck, that's how we ended up with this forum.
-Kerry
|
|
|
Rob Poretti
Junior Member
Canada
435 Posts |
Posted - 15 February 2001 : 22:41:13
|
Kewl... I'm sure I'll be back with questions...
Thanks Kerry...
Rob
|
|
|
rick7165
Senior Member
USA
1094 Posts |
Posted - 16 February 2001 : 09:11:47
|
I'm running V2 of this Mod.. where you can break it down by pages. When I send a message to ALL it never sends it.. It will send to the ones I check the boxes, but not if I select the All option.
Any Clues?
I do notice when I send to all it only takes a sec. to send.. so I know it's not sending :(
Thank, Rick
Test Site www.eastpasco.com Running on HuwR's SR4 release. Colors and Graphic scheme done by Richard Kinser. |
|
|
Kerry
Average Member
USA
553 Posts |
Posted - 16 February 2001 : 10:16:05
|
Rick,
So far I can't seem to replicate this with either version, but I am only using a small test db with about 20 addresses.
Questions: 1 - What mail component are you using? 2 - How many users are you trying to send to? 3 - Are you sending a "saved" message or a "new" one?
Also, send me a copy of your admin_emaillist.asp anI'll see what I can figure out .
(*I'm working right now but will try and look at it either this afternoon or this evening)
-Kerry
|
|
|
rick7165
Senior Member
USA
1094 Posts |
Posted - 16 February 2001 : 11:04:52
|
I tried CDONTS and Jmail about 500 users I tried Saved and New
I sent you the file..
Thanks, Rick
quote:
Rick,
So far I can't seem to replicate this with either version, but I am only using a small test db with about 20 addresses.
Questions: 1 - What mail component are you using? 2 - How many users are you trying to send to? 3 - Are you sending a "saved" message or a "new" one?
Also, send me a copy of your admin_emaillist.asp anI'll see what I can figure out .
(*I'm working right now but will try and look at it either this afternoon or this evening)
-Kerry
Test Site www.eastpasco.com Running on HuwR's SR4 release. Colors and Graphic scheme done by Richard Kinser. |
|
|
Rob Poretti
Junior Member
Canada
435 Posts |
Posted - 16 February 2001 : 11:17:01
|
quote:
I'm running V2 of this Mod.. where you can break it down by pages. When I send a message to ALL it never sends it.. It will send to the ones I check the boxes, but not if I select the All option.
Any Clues?
I do notice when I send to all it only takes a sec. to send.. so I know it's not sending :(
Thank, Rick
Test Site www.eastpasco.com Running on HuwR's SR4 release. Colors and Graphic scheme done by Richard Kinser.
wow... you have a version2??? kewl! I don't know your problem might be (since I'm using a v1) but I'm certainly curious what else version 2 has?
Could you very briefly point out the new features? Thanks!
Kerry,
I'm almost done what I described earlier -- its working great! I have a couple of comments and some changes that I made as a result:
1) If one selects "All Users" from the combo box (on the dropdown menu NOT from the SELECT value), the variable My_Sort becomes "All Users" and as a result the variable Sort_Name does not become set. When the page reloads, the "Select User Group" combo Box is empty (nothing is SELECTED) and it does not return any members.
2) When building the SQL string for the main (rs) recordset this statement does not run properly when My_Sort equals to "All Users" (As in the case when "All Users" is selected from the ComboBox):
elseif My_Sort = "4" or "5" then strSql = strSql & " AND " & strMemberTablePrefix & "MEMBERS.M_LASTPOSTDATE < '" & My_Last & "'"
For some reason it sees the statement as true when it evaluates and then incorrectly adds to the strSQL string.
I changed it to this and then it behaved as expected:
elseif My_Sort = "4" or My_Sort = "5" then strSql = strSql & " AND " & strMemberTablePrefix & "MEMBERS.M_LASTPOSTDATE < '" & My_Last & "'"
Hopefully by tonight (if nothing goes wrong!) I'll have some files to post...
Cheers!
|
|
|
rick7165
Senior Member
USA
1094 Posts |
Posted - 16 February 2001 : 12:02:39
|
Rob... Look at the Very First Post at the bottom of the message.
This breaks down the user list so if you have a large number of people it doesn't load them all.. breaks them down by pages. and a few more features added.
Also Note If you're running HuwR's Forum as I am.. Look down a few post from that and you will see a file for HuwR's Forum.
Rick
Test Site www.eastpasco.com Running on HuwR's SR4 release. Colors and Graphic scheme done by Richard Kinser. |
|
|
Rob Poretti
Junior Member
Canada
435 Posts |
Posted - 16 February 2001 : 12:46:48
|
Ahh... I see! Thats weird... when I click on that link (and I clicked on it earlier) it actually opened that file in IE and displayed an "ugly" version of the emailist page. I actually thought it was the "demo" of the MOD!! It's like my text MIME is screwed-up. (Except I know its not, because I click on teck links to text files all the time. Just with this link.)
Anyway, I'm glad you pointed it out to me, now that I'm in the middle of things... I right clicked and "Saved target" and got the file....
I'm only running some of Huwr's mods so I used the first set of files...
BTW, Rick, your Forum is very cool!!
What's with the "Live Support" mod on your site!!! I'm trying to set up a discussion/support forum and this looks like something I'd like... one of you Mods? Could you brief me on it?
Cheers!
Rob
Edited by - Rob Poretti on 16 February 2001 14:31:10 |
|
|
rick7165
Senior Member
USA
1094 Posts |
Posted - 16 February 2001 : 13:31:28
|
Thanks Rob... But you have to Thank Snitz, HuwR and Richard for the Awesome Forum and it's layout!. And ALL the Mod Makers at Snitz
Live Support... This Mod I got from KyCable I think KyCable and HuwR did this mod... Not sure (Trying to give credit to the right people so correct me if I'm wrong.) it's very easy to install and setup. It links with http://www.livehelper.com and they work together... Yes it's Awesome!
You might want to ask him about it... If not I can give you the files that you will need.
BTW.... If you apply your mod to this Mod V2 let me know, Note: HuwR's Forum is Different.
Rick
Test Site www.eastpasco.com Running on HuwR's SR4 release. Colors and Graphic scheme done by Richard Kinser.
Edited by - rick7165 on 16 February 2001 13:34:31
Edited by - rick7165 on 16 February 2001 13:38:07 |
|
|
netcall
Starting Member
United Kingdom
10 Posts |
Posted - 19 February 2001 : 06:47:41
|
Great Mod thanks Kerry
Iain
|
|
|
netcall
Starting Member
United Kingdom
10 Posts |
Posted - 19 February 2001 : 12:36:08
|
Hi Kerry
I am getting this error when admin tries to modify a members detail
Microsoft JET Database Engine error '80040e07'
Data type mismatch in criteria expression.
/pop_profile.asp, line 1118
Others are getting this when trying to edit their profiles
Microsoft JET Database Engine error '80040e07' Data type mismatch in criteria expression. /pop_profile.asp, line 924
I am using Huws great file attach mod ...
Any help would be great...
|
|
|
Kerry
Average Member
USA
553 Posts |
Posted - 19 February 2001 : 12:45:27
|
Netcall,
What version of the forum are you running?
-Kerry
|
|
|
netcall
Starting Member
United Kingdom
10 Posts |
Posted - 19 February 2001 : 12:47:03
|
quote:
Netcall,
What version of the forum are you running?
-Kerry
version 3.1 sr4
|
|
|
Kerry
Average Member
USA
553 Posts |
Posted - 19 February 2001 : 15:47:59
|
I'm guessing that it's a Standard sr4 (not HuwR's release, but has one of his Mods).
My best suggestion would be to go back to the old pop_profile that worked with the file attachments - from there, look in my release for anything commented "kerrycode" and put it in the corresponding spot in the copy with the file attachement mod. -I'm pretty sure it's commented clearly, so give that a shot and see how it works.
-Kerry
|
|
|
Topic |
|