:) you are doing a good job with this hack.

It worked!!

Thanks, what did you change?

I just need to add the phrases now as its saying there are duplicates but i'm missing some?

Is there any SQL query i can run which will drop the phrase if it exists and adds them all. The database is fine now, its just the phrases. After the prases are added I can do the file changes.

Thanks in advance, fantastic support.

Try running the following query in your system:

This will show you the phrases which start with 'warning'. All of these are connected to the warning system, so if you do not see anyone that is not related to a warning, then you may execute the following query to remove whichever is left:

Please make sure that there are no other phrases in the list produced by the first query, except those related to a warning, if there are, then do not run the second one, or else you will delete them.

Rgds

works thanks!!!

I'll get onto changing the files now. Thank You very much.

Most welcome!

Just query about the atomatic arwings when people post words which are in the censored list. You say you can't prove they said what they said as it replaces the words with **** or whatever symbol you use.

Could you just not make another field (or text box) which the automatic warnings run from? Instead of using the words listed in the censored list, have a warning list and when someone types in a word which is in the warning list, they get warned and the words they typed are still shown as they are not censored.

ALSO you could have (if you want) 3 different boxes for the sevearily of the word.

For examply,

Very Very naughty words: (type words in the box, if uses types in one of the words he gets 5 warning points)

Naughty words: (type words in the box, if uses types in one of the not so nautghy words he only gets 2 points)

Not so naughty: like prick, twat (they will get 1 warning point)
Just a suggestion.

Also could you add something like this so the public can view the banned members with a ling to the post they got the ban for and when the ban expires:

https://vborg.vbsupport.ru/showthread.php?t=70293

Or will this already work in parralel with this hack?

All these could be done, but with lot's of coding. At the moment, I am just trapping the censored words, by just comparing the messages, before and after they are parsed by the vB's routine. If they are different, then the user typed bad words, so I issue the warning. If I were to code everything from the beginning, it would take me months (or who knows, weeks? days? hours?).

We'll see, you never know.

But what I wrote before, that I do not know what the user wrote, is not true. If you activate the Automatic PM Warning option, you will see that it adds a report to your AdminCP, in which you can see the original text, as it was typed before being censored. I do not do the same in the simple posts, because it is obvious that whatever got replaced by **** was a bad word. The PM goes from one user to another, the rest of us, do not see it.

Rgds

You are obviously trying to make me come up with version 3.0???

That's a nice hack, but I agree, it should work with the original userban table, there is no reason to have another one. If you want to store details, such the reason for the ban or the URL that got that person banned, it can be done with extra columns in the original table. Also, it will not work with AWS, because AWS is using the userban table and I do not plan to alter it to use another one (redundancy, I hate it).

This is an interesting idea. Maybe next week. The weekend I am too busy taking care of the twins. At the moment, one of them is sitting in my lap (the other one is still asleep), playing with the Sun's keyboard, which has exceeded its buffer and is beeping every time he presses a key. He really enjoys it!! When they are both awake, I have to go!!! LoL

Rgds
---------
John