| Author |
 Topic  |
|
CodeName
Junior Member
296 Posts |
 Posted - 23 September 2002 : 11:18:14
|
burthold,
İf I do anything wrong to you , I'm sorry because I didnt know..
Anyway Thanks For This Mod Now its working ok .. I changed the Language I hope its not problem  |
 |
|
|
CodeName
Junior Member
296 Posts |
Posted - 23 September 2002 : 12:05:13
|
Hello Again burthold,
I Tryed to change admin_inactive_users.asp with your new file .. But İts giving error again  ..
ADODB.Recordset error '800a0bcd'
Ya BOF ya da EOF Doðru veya geçerli kayýt silinmiþ; uygulama tarafýndan istenen iþlem bir geçerli kayýt gerektiriyor.
/snitzozel/admin_inactive_users.asp, line 93
And Line 93 : aData = oRs.GetRows
How Can I Fix it ? |
|
|
|
burthold
Junior Member
USA
426 Posts |
Posted - 23 September 2002 : 13:42:47
|
| I ran it on an access database and now I get the error I will attempt to correct for it. I don't get this error on MySQL db. |
|
|
|
burthold
Junior Member
USA
426 Posts |
Posted - 23 September 2002 : 13:56:20
|
It was the placement of the on error resume next statement which allows us to trap these errors. I am not sure why it wouldn't effect MySQL but would access I moved the statment further down and it seems to work fine now and will display that no users were found instead of bombing out on the EOF BOF error.
New files are up.
Wes |
Edited by - burthold on 23 September 2002 13:56:37 |
|
|
|
stwilson
Junior Member
USA
385 Posts |
Posted - 23 September 2002 : 18:40:28
|
Burthold,
Thank you for your efforts!!!! That fixed my issue.
STW |
Shannon
RidingArizona.com |
|
|
|
runnerblade
Starting Member
35 Posts |
Posted - 24 September 2002 : 09:22:28
|
Thank you burthold for u work !!
it is fixed. |
|
|
|
Pouyan
New Member
91 Posts |
Posted - 29 September 2002 : 19:35:37
|
Wes,
Do you have this mod for 3.3.x with all the new features you've added ? If not, then what is the link to the old 3.3.x download ?
thanks a lot! |
|
|
|
burthold
Junior Member
USA
426 Posts |
Posted - 29 September 2002 : 23:31:00
|
Nope, I rewrote this from the origonal 3.3.x mod from MotoX who requested my help to make it 3.4.x compliant and add some new features. I don't have the origional 3.3.x mod at all. I started from a work in progress. Check the snitz exchange.
Wes |
|
|
|
DJ5A
Junior Member
163 Posts |
Posted - 02 October 2002 : 10:19:13
|
Hello Burthold:
How Hard would it be, to Change this Mod to Where a E-mail Window would Pop up & We Could Place the Text we want in the Subject Line & in the Body of the E-mail that we Choose?
I've Changed the Wording of the Message with no Problems just it Would Be Far Easier if We Could just Fill in the Subject Line & Body of Message with What We Want, Making it Similar to the email_all_users-34-34b.zip.
I Really Appreciate all Your Work on this Mod, It's Great!
So Please bare with me on these Questions, I have No Idea How to Accomplish this. It Might take you 30 Minutes or Days, If I was Doing it, LOL It would Never get Done? As You can Tell I have no Clue!
Thank For Your Time!!!!!
DJ5A |
Thank You for Your Time!!!!!
DJ5A |
|
|
|
schef
Junior Member
USA
164 Posts |
Posted - 02 October 2002 : 12:18:05
|
| i dont get any erros... but the e-mail is never sent. I have tested it several times, but no go. I am using CDONT on my forum, and all other forum mail is sent without problem... any ideres? |
ATV Outdoors |
|
|
|
burthold
Junior Member
USA
426 Posts |
Posted - 02 October 2002 : 12:50:13
|
DJ5A the feature you requested is on the list for the next version, it will be a couple of weeks I'm working on upgrading my own forums to 3.4.03 and working on 3 other mods at the moment.
schef It is using the snitz mail include I didn't code all the diffrent mail modules I am not using CDONT on any of my test boxes. I will see what I can do to test it. As far as I can tell you if your forum is sinding mail then this app should be sinding mail too.
Wes |
|
|
|
DJ5A
Junior Member
163 Posts |
Posted - 02 October 2002 : 16:41:03
|
Hello Wes aka burthold:
Thank You for all Your Time & Generous Contributions to the Snitz Community and Me T00!
LOL, Do I Just Count 14 Days from Today & then Just
Aggervateyoutodeath&driveyounutsaboutthenewmod?
Or Do I Just Wait Until You are Finished with it Completely & then Do that?
Just Kidding!!!!!
DJ5A |
Thank You for Your Time!!!!!
DJ5A |
Edited by - DJ5A on 02 October 2002 16:42:10 |
|
|
|
KC
Junior Member
USA
152 Posts |
Posted - 04 October 2002 : 12:38:47
|
I run the "E-mail Password for new registeration" setting.
I get a lot of accounts where the user never gets the password and just makes a new account, leaving the 1st one dead.
This is far from fancy, it's just something I made months ago to weed out dead accounts, but it's fast and easy.
Just put this code in an .asp page format and run it.
<html><body>
<p>This script deletes never used Forum Members.</p>
<%
' <!-- variables -->
Up2Day=20020813000000
'day to stop looking, in Snitz Format yyyymmddhhmmss.
db="DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & server.MapPath ("tools/snitz_forums_2000.mdb")
delCount=0
allCount=0
server.scriptTimeout=120
'<-- create object.-->
set connForum = server.createobject("ADODB.Connection")
connForum.open db
'<-- Fetch the Forum Record -->
SQLforum="SELECT MEMBER_ID, M_POSTS, M_DATE, M_LASThereDATE FROM FORUM_MEMBERS where M_POSTS=0 ORDER BY MEMBER_ID"
set forumG=connForum.execute(SQLforum)
do while not forumG.bof and not forumG.eof
ID=forumG(0)
M_DATE=forumG(2)
L_DATE=forumG(3)
allCount=allCount+1
'<-- found a record, check the date. -->
IF int(M_DATE) < UP2DAY THEN
IF M_DATE=L_DATE THEN
delCount=delCount+1
SQLUPDATE="delete * from FORUM_MEMBERS WHERE MEMBER_ID =" & ID
connForum.execute(SQLUPDATE)
END IF
END IF
forumG.movenext
loop
connForum.close
set forumG=nothing
%>
<br>Total members without any Posts= <%=allCount%>
<br>Inactive users deleted= <%=delCount%>
<br>End.
</body></html>
- - - - - - - - -
You could easily make a simple form to call it with any kind of counting you wanted.
In short, if the user never posted or logged in on another day than the Reg day it's deleted, up to the stop date.
I usually set it 15 days prior to the day I run it.
KC |
|
|
|
burthold
Junior Member
USA
426 Posts |
Posted - 04 October 2002 : 12:52:49
|
| Well, Since this isn't in my mod are you sugesting I put it in? |
|
|
|
anadolubjk
Starting Member
31 Posts |
Posted - 08 October 2002 : 11:34:25
|
Where can I find this mod for version 3.3.05?
Thanks |
|
|
|
Topic |
|
Topic Locked
