Thanks. That will help me a lot.
I am a bit scare of entering command in there and the few times I did nothing happened
[] Run a search like this:
SELECT DISTINCT B_ip FROM w3t_Posts WHERE B_Username = ' username ' (enter their username)
and then this:
SELECT B_Username FROM w3t_Posts WHERE B_ip LIKE 'XXX.XXX.XXX.XXX' (enter each of the IP's you got from the first search)
The first search will give you all the IP's he's posted under. Then the second search will tell you if anyone else has posted with those IP's other than him. If you don't have any conflicts, ban those IP's. We usually try taking the IP back a few digits if all of their IP's are similar, using '%' [/]
do you just copy it, past it into the command box, and replace the xxx wit the number... but is it with the '' or not?
SELECT B_Username FROM w3t_Posts WHERE B_ip LIKE XXX.XXX.XXX.XXX
or
SELECT B_Username FROM w3t_Posts WHERE B_ip LIKE 'XXX.XXX.XXX.XXX'
and the same question for the other... how do I enter it?
this time you place a space between the '' and the username
so do i enter
SELECT DISTINCT B_ip FROM w3t_Posts WHERE B_Username = ' username '
or
SELECT DISTINCT B_ip FROM w3t_Posts WHERE B_Username = username
or
SELECT DISTINCT B_ip FROM w3t_Posts WHERE B_Username = 'username'
there should be a place where all the commands are listed. Is there?
