Imported from PHPBB2

[bchawla]

I have a lot of HTML tags which makes the posts unreadable. Any suggestions as to how i can remove it?

Here is an example:
<strong><EM>i also think so</EM></strong>
<strong><EM>love</EM></strong>
<strong><EM>lamya</EM></strong>

[bchawla]

I am also having DATE issues. is there any way to update the date? What table is the date located in?

[Scott MacVicar]

It looks like you had HTML enabled or something similar?

I'd run these queries
UPDATE post SET pagetext = REPLACE(pagetext, '<strong>', '');
UPDATE post SET pagetext = REPLACE(pagetext, '</strong>', '');
UPDATE post SET pagetext = REPLACE(pagetext, '<EM>', '');
UPDATE post SET pagetext = REPLACE(pagetext, '</EM>', '');

What sort of date?
Post date, thread start date, user registration date, user birthday date?

[bchawla]

Thanks for the information;
is there any way to do these:
1) Mass update information about EVERY user (i.e. all signatures or all options)
2) Is there any way to make a user REVERIFY their email address? SOme users dont have an email IDand i want them to have to reset it to make sure we have the right one on file.

[bchawla]

By the way, is there any way to increase the SMILEY "Text to Replace" length?