| Author |
 Topic  |
|
Freeman II
Junior Member
232 Posts |
|
|
big9erfan
Average Member
540 Posts |
 Posted - 06 July 2001 : 01:09:45
|
Thanks for the work around on the dl Richard.
Freeman,
Some screen shots of what this mod does, a demo, or a more indepth explaniation would be really nice. I may be interested in using this mod, but since I really have no idea what kind of tasks can be assigned to Mods, or how, I am a bit reluctant to implement this yet.
http://www.ugfl.net/forums
Edited by - Big9erFan on 06 July 2001 02:19:26 |
 |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
|
|
Freeman II
Junior Member
232 Posts |
Posted - 06 July 2001 : 14:11:02
|
hmm can you guys see those screenshots?
|
|
|
|
stuF
Average Member
United Kingdom
561 Posts |
Posted - 06 July 2001 : 14:31:22
|
do we get anymore clues as to what exactly it does...?
|
|
|
|
RDoGG™
Junior Member
USA
329 Posts |
Posted - 06 July 2001 : 16:02:52
|
quote:
do we get anymore clues as to what exactly it does...?
pretty cool...just look at screen shots:
shot1.jpg and shot2.jpg
RDoGG™ |
|
|
|
gglosser
Starting Member
16 Posts |
Posted - 06 July 2001 : 16:43:14
|
quote:
quote:
do we get anymore clues as to what exactly it does...?
pretty cool...just look at screen shots:
shot1.jpg and shot2.jpg
RDoGG™
It is not clear to me what this MOD does. An explanation would be appreciated.
Gisele
|
|
|
|
stuF
Average Member
United Kingdom
561 Posts |
Posted - 06 July 2001 : 16:45:54
|
it just allows you to make a diary sort of thing to tell mods/admins what needs doing...ill be using it to keep track of nasty peoples IPs, so the mods can be alert, and to tell them when an update will be happening so theyre aware of it before hand.
|
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 06 July 2001 : 16:58:19
|
quote:
This mod allows admins to assign task to moderators.
Download
the instructions are in the zip file
this is my first mod, let me know what you think about it
Screenshots
A nice mod, however, if you are going to use the mod_dbsetup, please try not to supply a different one than the currently available one, it is hard enough supporting the versions as it is. You should supply it as is, and you should not claim it is part of the mod if all you have done is changed the name.
|
|
|
|
Classicmotorcycling
Development Team Leader
Australia
2084 Posts |
Posted - 06 July 2001 : 17:31:49
|
Hello,
Found some error in the code that you may wish to fix.
The following lines where looking in the wrong place for data;
In admin_mod_tasks_new.asp the following;
strSql = "INSERT INTO MOD_TASKS ("
change it to
strSql = "INSERT INTO FORUM_MOD_TASKS ("
I also found the following in admin_mod_tasks_edit.asp;
strSql = "UPDATE MOD_TASKS "
to
strSql = "UPDATE FORUM_MOD_TASKS "
and also this in the same file;
strSQL = "SELECT TASK_ID, SUBJECT, COMPLETED, DUE_DATE, PRIORITY, MEMBER_ID, BODY, SHOW FROM MOD_TASKS WHERE TASK_ID ="& tasknumber
to this
strSQL = "SELECT TASK_ID, SUBJECT, COMPLETED, DUE_DATE, PRIORITY, MEMBER_ID, BODY, SHOW FROM FORUM_MOD_TASKS WHERE TASK_ID ="& tasknumber
While in admin_mod_tasks_review.asp the following;
strSQL = "DELETE FROM MOD_TASKS WHERE TASK_ID IN (" & strDeleteList & ")"
Changed to
strSQL = "DELETE FROM FORUM_MOD_TASKS WHERE TASK_ID IN (" & strDeleteList & ")"
and
strSQL = "SELECT TASK_ID, SUBJECT, COMPLETED, DUE_DATE, PRIORITY, MEMBER_ID, SHOW FROM MOD_TASKS ORDER BY PRIORITY DESC"
had to be changed to;
strSQL = "SELECT TASK_ID, SUBJECT, COMPLETED, DUE_DATE, PRIORITY, MEMBER_ID, SHOW FROM FORUM_MOD_TASKS ORDER BY PRIORITY DESC"
Just thought that I would let you know that you need to include FORUM_ before all of the MOD_TASKS in each of those files.
Apart from that, looks like a nice mod..
Regards,
Webmaster @ Classic Motor Cycling
Classic Motor Cycling
Edited by - Classicmotorcycling on 06 July 2001 17:37:50 |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 06 July 2001 : 17:44:25
|
instead of adding FORUM_ you should use the forum variable strTablePrefix, not everyone uses the default value of FORUM_
|
|
|
|
Freeman II
Junior Member
232 Posts |
Posted - 06 July 2001 : 17:52:48
|
you wouldn't need to do the changes if you used the mod db setup file supplied with this mod.
HuwR this is a customized version of mod_dbsetup.asp, like the link manager, it doesn't use strTablePrefix
|
|
|
|
Classicmotorcycling
Development Team Leader
Australia
2084 Posts |
Posted - 06 July 2001 : 17:53:44
|
Good point. Just not that advanced with the programming. But, yes all use the variable as HurW suggests.
You may need to go through all files included in this mod and change them where it calls on the database. I found more.
quote:
instead of adding FORUM_ you should use the forum variable strTablePrefix, not everyone uses the default value of FORUM_
Regards,
Webmaster @ Classic Motor Cycling
Classic Motor Cycling |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 06 July 2001 : 18:46:42
|
quote:
Good point. Just not that advanced with the programming. But, yes all use the variable as HurW suggests.
Instead of inserting FORUM_ in the strings, insert this instead
" & strTablePrefix & " make sure it is imediatly before the table name ie
this
strSql = "INSERT INTO MOD_TASKS ("
becomes
strSql = "INSERT INTO " & strTablePrefix & "MOD_TASKS ("
|
|
|
|
Freeman II
Junior Member
232 Posts |
Posted - 06 July 2001 : 22:39:30
|
did you guys find any bug?
if you did please post it, ill fix it and reupload the file
|
|
|
|
Classicmotorcycling
Development Team Leader
Australia
2084 Posts |
Posted - 07 July 2001 : 03:31:55
|
Yes,
When I first put your MOD (which is quote handy) in, I kept getting ODBC errors. Then when I changed to the have the FORUM_ before the call of database items, it worked. Now as that most people will not use another db setup script, I thought it would be nice to let them know about what was needed to fix it, when HuwR told me a better way of doing it. But like I said, great MOD. Good job..
quote:
did you guys find any bug?
if you did please post it, ill fix it and reupload the file
Regards,
Webmaster @ Classic Motor Cycling
Classic Motor Cycling |
|
|
|
Topic |
|
Topic Locked
