force disable vbcode

[DetonatorX]

how do i force disable vbcode for my all users?

[ragear]

I dont think you can do it for all the users, but I know you can do it for certain forums

[Freddie Bingham]

http://www.vbulletin.com/forum/showt...ghlight=update

See my post.

[DetonatorX]

Originally posted by freddie
http://www.vbulletin.com/forum/showt...ghlight=update

See my post.

tried to enter this command via telnet:

UPDATE user SET options=options+8 WHERE NOT(options&8)

but error occurs and says:

bash: syntax error near unexpected token `NOT(o'

what is wrong?

[Freddie Bingham]

Um you tried to enter it on the command line. You have to run 'mysql' first and then 'use database' where database is the name of your database.

[DetonatorX]

Originally posted by freddie
Um you tried to enter it on the command line. You have to run 'mysql' first and then 'use database' where database is the name of your database.

how do i run mysql? what are the step by step processes? thanks in advance.

[tubedogg]

mysql -uUSERNAME -p DATABASENAME
hit enter, type your password

[DetonatorX]

Originally posted by tubedogg
mysql -uUSERNAME -p DATABASENAME
hit enter, type your password

ok ive done it. but after entering the UPDATE command, nothing happened. how do i confirm the update that has been done?

[tubedogg]

What exactly do you mean by "nothing happened"? Did it just sit there and not do anything, or did it give an error, or...?

[DetonatorX]

Originally posted by tubedogg
What exactly do you mean by "nothing happened"? Did it just sit there and not do anything, or did it give an error, or...?

just returned a >

how do i confirm if i have logged onto my mqSQL server btw? is that when this mesg appears: Possible variables for option... blah blah blah

[Mike Sullivan]

Query should be:

UPDATE user SET options=options+8 WHERE NOT(options&8);

(small technicality)