| Author |
 Topic  |
|
TStewartFan
Junior Member
190 Posts |
 Posted - 09 February 2005 : 18:45:26
|
After quite some time of work on my end I have managed to create a solution that will allow you the ability to display warned members that have been warned for forum rule violations. My work is an extension of the Report to Moderator Mod and is completely compliant with 3.4.05 Take into consideration I am a newbie in ASP and this is my very first mod for any asp program so if you find any bugs then let me know and I will fix accordingly. Furthermore this mod is further enhanced if you have the PM mod installed. I declared two levels of warnings: 1) A warning that stands for a 1 hr period (you could further this warning to include member can't post during this period) 2) A warning that stands for a 24 hr period (you could further this warning to include member can't post during this period) Hope you enjoy and you may see a working sample of this mod at the below link:
http://e.domaindlx.com/SmokeRises/Forum/default.asp
User Name: TestModerator
Password: password
The zip file is below:
http://www.smokerises.com/reportMembers_1.zip
I accidentally forgot the readme file in the zip:
http://www.smokerises.com/reportReadMe.txt
Fix Number 1:
Replace the file in the zip with this file:
http://www.smokerises.com/reportMembers_Fix1.zip
 |
Edited by - TStewartFan on 09 February 2005 19:27:43 |
|
|
Jorrit787
Average Member
Netherlands
681 Posts |
Posted - 09 February 2005 : 22:04:44
|
quote:
Originally posted by TStewartFan
Fix Number 1:
Replace the file in the zip with this file:
http://www.smokerises.com/reportMembers_Fix1.zip
There is no inc_reportedmembers1 in the original zip... Should we just upload it too? |
 |
|
|
TStewartFan
Junior Member
190 Posts |
Posted - 09 February 2005 : 22:32:30
|
Sorry about the delay was working out a few flaws I found when implemented with a base install. Just overide your existing files with these and it otta work. Except do not use my default, topic, or header files ;)
http://www.smokerises.com/reportMembers_Fix2.zip
Also: Before Someone Ask. There is a possibility the dbs file may not be correct....I tried but by the time I got to it I was so drained from writing this mod to work with my site and then rewriting it to wrok with a base install site that I suppose my dbs effort was second best to say the least...heh If you have any problems with the dtabase and before asking all that needs to happen is you need to make M_WARNDATE in table FORUM_MEMBERS a Memo type field. Do that if you do get any errors because it should fix more then half of them 
I am off to bed....work tomorrow. Enjoy! |
Edited by - TStewartFan on 09 February 2005 23:11:27 |
|
|
|
PeeWee.Inc
Senior Member
United Kingdom
1893 Posts |
Posted - 10 February 2005 : 03:57:24
|
ADODB.Recordset error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/SmokeRises/Forum/ComplaintManager.asp, line 77
http://e.domaindlx.com/SmokeRises/Forum/ComplaintManager.asp |
De Priofundus Calmo Ad Te Damine |
|
|
|
TStewartFan
Junior Member
190 Posts |
Posted - 10 February 2005 : 05:54:42
|
| Sorry about that. I changed something in my original to accomodate for th newer version and forgot to change it back. As soon as the host comes back online I will upload the fixed page. Also I went ahead and made the update an include so it worked independantly from the inc_report pages. The changes have been upladed. |
Edited by - TStewartFan on 10 February 2005 06:45:55 |
|
|
|
TStewartFan
Junior Member
190 Posts |
Posted - 10 February 2005 : 11:24:36
|
I love the rain. It keeps me out of the cold for a day...heh I have uploaded the changes to my server so it should proces error free now. If anyone can find any problems with file then let me know but I believe with the new quick fixes I added then it should proces fine:
http://www.smokerises.com/reportMembers_Fix2.zip
A side not for those whom wish to set different time criteria (how long they are warned): If you open up inc_updateReport.asp you will find these two lines of code:
If (pWarn = 1) and (mWarn < nWarn - 3600) then
If (pWarn = 2) and (mWarn < nWarn - 86400) then
The first line is the initial warning system (which on my site is the under caution) and the second line is if someone is warned a second time while under caution. If you change the -# then this will effect your warning period. (i.e. 3600 = 1 hour (60 seconds x 60 minutes = 3600) and the 86400 is 24 hours. For testing purposes I have been changing the first to 60 (one minute) and the second to 120 (two minutes) so I could see the cause and effect of what happens when i warn a member twice and what happens when a member's warn status changes. Feel free to experimen with the code and if you can come up with a more efficient solution then let me know. As previously stated this is my first attempt at designing my own mod and a good 60 percent of it was just reverse engineering. |
If You Have to Ask, You Wouldn't Understand. |
Edited by - TStewartFan on 10 February 2005 14:23:38 |
|
|
|
Jorrit787
Average Member
Netherlands
681 Posts |
Posted - 11 February 2005 : 14:45:43
|
| The Style Sheet file messed up my whole forum, so I didn't use it. Also, the rest of the pages look kinda messy, but I'm sure that can be touched up. |
|
|
|
TStewartFan
Junior Member
190 Posts |
Posted - 11 February 2005 : 16:24:13
|
| Sorry about that. I thought I removed all non independant pieces from the stylesheet. The only two needed styles are the topicdark and topiclight. The rest can be deleted and should have no effect on your existing forum. And in regards to the rest of the pages looking kinda messy. I will be altering my look a bit to match the look and feel of my site. Much like I did with the Under Caution and Black Flagged. However my needs are substantially different then most so I was doing as everyone else has done and submit the mod that gave the same look and feel as the base snitz forum. |
Edited by - TStewartFan on 11 February 2005 16:43:05 |
|
|
|
Jorrit787
Average Member
Netherlands
681 Posts |
Posted - 11 February 2005 : 22:24:04
|
quote:
Originally posted by TStewartFan
Sorry about that. I thought I removed all non independant pieces from the stylesheet. The only two needed styles are the topicdark and topiclight. The rest can be deleted and should have no effect on your existing forum.
Could you edit the file and upload a new version? I'm not sure what to delete and what not. Right now I'm not using the style sheet. |
|
|
|
TStewartFan
Junior Member
190 Posts |
Posted - 12 February 2005 : 06:24:57
|
Here is a link to an updated stylesheet. When using this stylesheet it will effect this mod and only this mod. If you need to alter the styles of this mod just open this stylesheet and edit whichever piece you like (topiclight = the body & topicdark = the header)
http://www.smokerises.com/reportCSS.zip |
If You Have to Ask, You Wouldn't Understand. |
|
|
|
Jorrit787
Average Member
Netherlands
681 Posts |
Posted - 12 February 2005 : 18:54:13
|
quote:
Originally posted by TStewartFan
Here is a link to an updated stylesheet. When using this stylesheet it will effect this mod and only this mod. If you need to alter the styles of this mod just open this stylesheet and edit whichever piece you like (topiclight = the body & topicdark = the header)
http://www.smokerises.com/reportCSS.zip
Great, thanks :) |
|
|
|
eauxvives
Junior Member
Bhutan
145 Posts |
Posted - 08 March 2005 : 07:28:45
|
I have installed this and I get the following error when I process the form after filling the message to moderator (message: "test comment'"):
Microsoft OLE DB Provider for SQL Server error '80040e14'
The name 'test comment' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
/Forum/ComplainToModerator.asp, line 100
Any idea?
line 100 is : my_Conn.execute SQL
after
SQL = "INSERT INTO FORUM_COMPLAINTS(ForumID, TopicID, CatID, Message, ReporterID, IsTopic, ReplyID, Solved)"
SQL = SQL & " VALUES(" & ForumID & ", " & TopicID & ", " & CatID & ", """ & message & """, " & ReporterID & ", " & IsTopic & ", " & ReplyID & ", " & 0 & ")"
|
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 08 March 2005 : 08:25:08
|
Change it to look like this:
SQL = "INSERT INTO FORUM_COMPLAINTS(ForumID, TopicID, CatID, Message, ReporterID, IsTopic, ReplyID, Solved)"
SQL = SQL & " VALUES(" & ForumID & ", " & TopicID & ", " & CatID & ", '" & message & "', " & ReporterID & ", " & IsTopic & ", " & ReplyID & ", " & 0 & ")"
|
 Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
Edited by - Shaggy on 08 March 2005 08:25:39 |
|
|
|
eauxvives
Junior Member
Bhutan
145 Posts |
Posted - 08 March 2005 : 08:57:59
|
| thanks it works! |
|
|
|
eauxvives
Junior Member
Bhutan
145 Posts |
Posted - 08 March 2005 : 09:11:42
|
one suggestion for the developper: it would be nice if the moderator(s) and admin(s) could be warned in case of a new report, e.g. similar to what happens when you get a new private message, the 'complaints' link in the header would appear red ... and then when you open ComplaintManager.asp the new reports would show differently from the old ones
|
|
|
|
withanhdammit
Junior Member
USA
236 Posts |
Posted - 08 March 2005 : 09:12:27
|
Any chance of posting an updated zip file with all the fixes and updates included?
Thanks!
h |
|
|
|
Topic |
|
Topic Locked
