| Author |
 Topic  |
|
|
Kerry
Average Member
USA
553 Posts |
 Posted - 17 January 2001 : 06:28:15
|
This mod allows admins to block unwanted names from being registered by users (Administrator, ForumAdmin, MickeyMouse, etc...)
http://www.cantonweb.com/Snitz_Username_filter.zip
This is based on a standard 3.1sr4 install.
For now I will leave adding this to the MOD Commander to someone with more experience with it. Between this and finishing up a project-that-pays-the-bills, I've been at this computer waaaaaaay to long tonight 
-Kerry
* Please keep in mind, I am not a professional programmer and could use any tips from the more experienced crowd on this.
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 17 January 2001 : 07:41:28
|
Found 1 little problem. The nouser_setup.asp file you included creates a table named FORUM_NOUSER2 but admin_nouser.asp is looking for FORUM_NOUSER
to have this show up in the mod commander all you need to do is copy the following lines and paste them into a file called something like: UsernameFilter.mod
Username Filter
admin_nouser.asp
false
1.00
Kerry
There are 6 lines above, you need that blank line also.
just place the UsernameFilter.mod file in the MODS directory and it will now show up in the Mod Commander.
Edited by - Richard Kinser on 17 January 2001 07:42:51 |
 |
|
|
Kerry
Average Member
USA
553 Posts |
Posted - 17 January 2001 : 12:10:39
|
quote:
Found 1 little problem. The nouser_setup.asp file you included creates a table named [b]FORUM_NOUSER2[b/]
Thanks for catching the NOUSER2 - I was retesting that when I put that in. Too little sleep + ASP = oops 
quote:
to have this show up in the mod commander all you need to do...
Now that you explain it, I can't imagine why it seemed difficult - thanks, Richard!
The above file has the above noted correction (NOUSER2) and is now MOD Commander friendly  .
-Kerry
|
|
|
|
Kerry
Average Member
USA
553 Posts |
Posted - 17 January 2001 : 13:49:12
|
BUG FOUND & FIXED
If you downladed and installed the Username Filter and used the register_with_filter_only.txt prior to this post, please download http://www.cantonweb.com/register_with_filter_only.txt
...or fix in your current version by replacing line 306 (approx.)
strMessage = strMessage & "Password: " & My_Pass & vbCrLf & vbCrLf
with
strMessage = strMessage & "Password: " & Request.Form("Password") & vbCrLf & vbCrLf
* Do not make this change if you're using register_with_random_pass_and_filter.txt - this bug affects register_with_filter_only.txt
My apologies for the inconvenience - 
The posted zip file has this correction in place.
-Kerry
Edited by - kerry on 17 January 2001 13:56:25 |
|
|
|
bjlt
Senior Member
1144 Posts |
Posted - 06 April 2001 : 16:03:56
|
got this when tried to delete names.
it happened when i tried to delete a name appeared(guess i entered it) twice
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '*'.
/club/admin_nouser.asp, line 30
===========
30 Set RS = conn.execute(sqlstmt)
|
|
|
|
Kerry
Average Member
USA
553 Posts |
Posted - 06 April 2001 : 16:31:41
|
bjlt,
It looks like you're running SQL Server and unforunately I am just learning to work with it (just now started with MySQL) so I won't be of much help .
Maybe posting this in the MS SQL forum will draw out someone who's got a better background.
-Kerry
|
|
|
|
work mule
Senior Member
USA
1358 Posts |
Posted - 06 April 2001 : 19:06:04
|
quote:
Too little sleep + ASP = oops
LOL!!! That's too funny.... 
|
|
|
|
work mule
Senior Member
USA
1358 Posts |
Posted - 06 April 2001 : 19:13:45
|
Line 29 reads:
sqlstmt = "DELETE * from FORUM_NOUSER WHERE ID=" & record
Change to:
sqlstmt = "DELETE from FORUM_NOUSER WHERE ID=" & record
|
|
|
|
Kerry
Average Member
USA
553 Posts |
Posted - 06 April 2001 : 22:21:49
|
quote:
Line 29 reads:
sqlstmt = "DELETE * from FORUM_NOUSER WHERE ID=" & record
Change to:
sqlstmt = "DELETE from FORUM_NOUSER WHERE ID=" & record
Is that an SQL Server-specific thing or did I goof on this line? -It seems to work on Access, buuut... 
-Kerry
|
|
|
|
work mule
Senior Member
USA
1358 Posts |
Posted - 07 April 2001 : 10:58:53
|
quote:
Is that an SQL Server-specific thing or did I goof on this line? -It seems to work on Access, buuut...
I'm not sure.
I did see somewhere that the basic format of the DELETE statement was defined as (Beginning ASP Databases, WROX):
DELETE column* FROM tablename WHERE criteria
The column* parameter specifies individual columns to be deleted or using a star character indicates that all columns should be deleted.
But I've also been told that when doing a DELETE where you're going to delete the entire row, omit the * character and just write it as:
DELETE FROM tablename WHERE criteria
|
|
|
|
bjlt
Senior Member
1144 Posts |
Posted - 08 April 2001 : 05:33:53
|
quote:
Line 29 reads:
sqlstmt = "DELETE * from FORUM_NOUSER WHERE ID=" & record
Change to:
sqlstmt = "DELETE from FORUM_NOUSER WHERE ID=" & record
thanks, fixed.
|
|
|
| |
Topic |
|
Topic Locked
