| Author |
 Topic  |
|
SalmanKhana
Average Member
USA
961 Posts |
 Posted - 22 June 2001 : 22:39:49
|
O this thread is back again.. sorry davio i did not read your reply.
i had to re install the forum again and added a portal and now i want to install the ban ip mod too. i'll get back here if i have any problems.
thanx 
|
 |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 22 June 2001 : 23:01:45
|
gglosser, the instructions are on the first post in this topic and also in the readme.txt file in the zip.
And this mod isn't just for SQL users. It will work for Access databases too. Don't where you got that this mod was made for SQL. Most mod authors try to make the mods compatible with all database versions that are supported by snitz. If they can't, they usually test them on Access databases only and hope for the best for MySQL and SQL users.
- David |
|
|
|
kimkr
Starting Member
Denmark
36 Posts |
Posted - 03 July 2001 : 11:28:29
|
quote:
You would also need to re-create the tables ...
I have tried to install the ban ip, but i failed... then I tried the rebuild, but it failed too ! - The error(s) are:
Dropping Column...
ALTER TABLE Hardinfo_SQL_Adm.FORUM_CONFIG DROP COLUMN C_STRBANIP
-2147217900 | The total row size (9295) for table 'FORUM_CONFIG' exceeds the maximum number of bytes per row (8060). Rows that exceed the maximum number of bytes will not be added.
Dropping Column...
ALTER TABLE Hardinfo_SQL_Adm.FORUM_CONFIG DROP COLUMN C_STRBANIPRANGE
-2147217900 | The total row size (9295) for table 'FORUM_CONFIG' exceeds the maximum number of bytes per row (8060). Rows that exceed the maximum number of bytes will not be added.
Dropping Column...
ALTER TABLE Hardinfo_SQL_Adm.FORUM_CONFIG DROP COLUMN C_BAN_IP
-2147217900 | The total row size (9295) for table 'FORUM_CONFIG' exceeds the maximum number of bytes per row (8060). Rows that exceed the maximum number of bytes will not be added.
Dropping Column...
ALTER TABLE Hardinfo_SQL_Adm.FORUM_CONFIG DROP COLUMN C_BAN_IPRANGE
-2147217900 | The total row size (9295) for table 'FORUM_CONFIG' exceeds the maximum number of bytes per row (8060). Rows that exceed the maximum number of bytes will not be added.
Adding Column...
ALTER TABLE Hardinfo_SQL_Adm.FORUM_CONFIG ADD C_STRBANIP byte NULL DEFAULT 0
-2147217900 | Column or parameter #118: Cannot find data type byte.
Adding Column...
ALTER TABLE Hardinfo_SQL_Adm.FORUM_CONFIG ADD C_STRBANIPRANGE byte NULL DEFAULT 0
-2147217900 | Column or parameter #118: Cannot find data type byte.
Adding Column...
ALTER TABLE Hardinfo_SQL_Adm.FORUM_CONFIG ADD C_BAN_IP nvarchar(255) NULL DEFAULT '000.000.000.000|'
-2147217900 | The total row size (9807) for table 'FORUM_CONFIG' exceeds the maximum number of bytes per row (8060). Rows that exceed the maximum number of bytes will not be added.
Adding Column...
ALTER TABLE Hardinfo_SQL_Adm.FORUM_CONFIG ADD C_BAN_IPRANGE nvarchar(255) NULL DEFAULT '000.000.000|'
-2147217900 | Only the owner or members of the sysadmin role can alter table 'FORUM_CONFIG'.
Table(s) updated
What do I miss ?
Edited by - kimkr on 03 July 2001 12:40:17
Edited by - kimkr on 05 July 2001 11:31:09 |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 03 July 2001 : 14:11:12
|
Where and when did you download that file?
1) I didn't provide any script to drop any tables from the database.
2) The C_STRBANIP and C_STRBANIPRANGE fields are set to INTEGER in the script, not byte.
You are using sql?
- David |
|
|
|
kimkr
Starting Member
Denmark
36 Posts |
Posted - 03 July 2001 : 14:48:35
|
quote:
Where and when did you download that file?
1) I didn't provide any script to drop any tables from the database.
2) The C_STRBANIP and C_STRBANIPRANGE fields are set to INTEGER in the script, not byte.
You are using sql?
I downloaded it from a earlier subject... and I'm using SQL 7...
Kim Rasmussen
|
|
|
|
kimkr
Starting Member
Denmark
36 Posts |
Posted - 04 July 2001 : 13:16:43
|
I am VERY SORRY !!! - I have found out what was wrong... so don't worry - I'm happy now !
- The ADD looks very well !
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 04 July 2001 : 14:39:58
|
It would be helpful to me if you told me what was wrong. In case another user has the same problem.
- David |
|
|
|
Morten
Junior Member
Denmark
251 Posts |
Posted - 03 August 2001 : 17:26:54
|
This mod is now working by me - I THINK! - the case is: I have not yet tryed it out, I don´t want to ban myself. What does it looks like if a banned user try to acces the forum ?
Morten
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 03 August 2001 : 21:50:56
|
This is what you will see:
You have been banned from this forum.
- David |
|
|
|
Classicmotorcycling
Development Team Leader
Australia
2084 Posts |
Posted - 03 August 2001 : 23:54:03
|
gglosser,
I use Access 2000 and just downloaded the files in the original post and went from there and they work fine. Worked real easy.
quote:
Davio,
So what is the final set of files and instructions for this MOD? I need to place it on my Forums (with Access 2000) as soon as possible.
Thanks,
Gisele
Regards,
Webmaster @ Classic Motor Cycling
Classic Motor Cycling |
|
|
|
GnatRat
Starting Member
2 Posts |
Posted - 12 August 2001 : 02:16:02
|
Will this work with the new 3.3.2 version?
|
|
|
|
hawkster
Starting Member
4 Posts |
Posted - 15 August 2001 : 12:18:34
|
Is there anyway to use this mod so when you BAN somone that they can "not" view/access the board at all?
Thanks
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 19 August 2001 : 01:26:54
|
No, this mod does not work with the 3.3 version.
It will soon be updated for the 3.3 version.
If you want, you can subscribe to this topic, so you will be notified when it is released for the 3.3.
- David |
|
|
|
BogieMan
New Member
USA
88 Posts |
Posted - 20 August 2001 : 13:12:16
|
Does the link on the very first post contain the latest and greatest version? Nope I am not putting it on a 3.3 version...
|
|
|
|
greedo
Starting Member
France
31 Posts |
Posted - 21 August 2001 : 10:57:36
|
we can't suscribe there :(
|
|
|
|
Topic |
|
Topic Locked
