how do i remove personal text by default?

[Razgo]

YaBB SE Version: 1.5.2 to 1.5.4
Link to Forum: http://www.rioworld.org/yabbse/index.php

Problem Description:
how do i remove personal text by default? at the moment it has the "i'm a llama".

i dont see anything in the admin panel to turn it off?

thanks.

[Chris Cromer]

Open English.lng and search for "llama" and remove the text in the quotes.

[Razgo]

excellent, thank you. i did find in the admin panel "Show User Text in Message View?"

but that then meant no text would be shown if they chose to put something there.

thanks for that, much appreciated.

[Razgo]

ok i edited the file and found " I'm a llama!" , edited it out. but now how do a refresh the board to reflect that? i did a board recount but that didnt work. in other words everyone that had  "I'm a llama!" is still there.

[Chris Cromer]

It doesn't change the text for current members. All it does is make it so when people register those new members won't have the personal text.

The members that have it set to that will have to be manually altered to remove it from their profile.

[Shadow's Pawn]

Open up phpmyadmin, then run a query to change everyone who has their usertext set to I'm a llama to show nothing at all.

I'm pretty sure that this query should work...

UPDATE yabbse_members
SET personalText = ''
WHERE personalText = 'I\'m a llama'

Change yabbse_ to whatever prefix you used.


Editted to fix the mistake that Chris pointed out.  (Thanks Chris)

[Chris Cromer]

That query won't work. You didn't escape the '.

[Razgo]

excellent!! i was going to ask about a query to run. but no need to now
i will try this out shortly. i wasn't too sure about the continued support for this yabbse edition. as we have no need or desire to upgrade just yet or maybe not for a long time.

so thanks for the continued support!

[Razgo]

hmmmm..... ok i ran the query and nothing changed.

the query return said:

Affected rows: 0

SQL-query :
UPDATE yabbse_members
SET personalText = ''
WHERE personalText = 'I\'m a llama'

[[Unknown]]

Please try:

UPDATE yabbse_members
SET personalText = ''
WHERE personalText LIKE '%llama%';

There's actually a ! after the line...

-[Unknown]

[Razgo]

lol! yes i had just figured it out! and put in the exclamation mark! it worked great now! thank you guys!