boardom

[Cyberian75]

I wanted to change some of my smilies but doing so would have "corrupted" my older entries with broken links or plain smilie strings. So I did a query via phpMyAdmin to find out how many entries had that particular smilie, and the query returned 119 entries. There was no way I was going to update all of them manually one by one, so I wrote the following script.

To use this script, save it in a file with php extension and fill in "replace" and "with" variables with strings you want to search for and replace with.

[epolady]

Great hack! I don't need to use it right now, but I may soon.

Good job! *thumbs up*
_________________
No more support from me. Goodbye!
Go upgrade to WordPress, you'll find better support there.

[Viper007Bond]

Ditto. I'll probably get rid of all of the <br> tags or something.
_________________
http://www.viper007bond.com

If you haven't already installed b2, I advise you look into WordPress or b2evo instead as b2 is dead.

[Cyberian75]

Thanks, guys!

Updated.
_________________
Michael P.

[Aoidas]

Hello,
sorry, maybe I don't understand the meaning of this script, but I want't script, which could replace letters with them HTML codes

[GamerZ]

wanted to create it...since u got it first, must as well use urs. =D cheers dude
_________________

++ GamerZ.Per.Sg - Complex Simplicity

[Cyberian75]

Aoidas,

I wouldn't recommend using the script to replace a single character since it uses wildcards in the search. If you do this, it could replace every instance of that character in your database. However, you could accomplish what you want to do by searching for "<a", not just "a", and replacing it with its character set ("<a").

Don't forget to backup your database first.
_________________
Michael P.

[Aoidas]

Cyberian75:
yes, if I would like to replace one of QWERTY letters, it could be a problem with HTML commands, but I I'm going to try only the letters from my language.
Letters: here is keyboard layout. Letters, which I would like to replace is shown in the upper line (from "`" to "\").

About script:
as I understand it, I should fill one symbol in $replace = "symbol_place", and other symbol, that should be placed instead $with = "another_symbol_place"?
So it is only for one symbol. And should I use some of those scripts, or is there any syntax, that I could use to replace some symbols?

And sorry, maybe I'm wrong, and this script only make replaces in all DB, not only in the concrete file (not only in new message as I want)?

[Cyberian75]

As far as I know, there are no other ways to search and replace strings than to use some kind of scripts. It's certainly not possible to do this within phpMyAdmin. And yes, this script is only for the database and does not handle actual files or anything outside the database.

The variable "replace" is for strings you want to search for and the other variable "with" is for strings you want that is going to replace the strings you put in for the first variable "replace." Each variable can be assigned multiple words or letters separated by spaces.
_________________
Michael P.

[Aoidas]

Thank you, Cyberian75.

I have an idea, that I can replace characters using such code in b2functions.php (b2/include/b2functions.php):

function aa($content) {
$content = preg_replace("/ą/"here is letter, $content);
$content = preg_replace("ą"here is letter html code, $content);
$content = preg_replace("/(\015\012)|(\015)|(\012)/", "<br />\n", $content);
return($content);
}
function unaa($content) {
$content = preg_replace("ą"here is letter html code, "/ą/"here is letter, $content);
return($content);
}

I used autobrize and unautobrize functions. But I don't know, what does last line in function aa, I mean: preg_replace("/(\015\012)|(\015)|(\012)/", "<br />\n", $content);.
So if anyone could help me, and tell something useful about this code I would be very thankful.
And maybe something is here, but I really have no ideas how to use this in editing comments (so that this function could replace characters with other characters, like pedroivo at linuxgoias dot net example). Maybe it could be somehow transfered to b2 message board.?.

And sorry, for posting here, maybe it's time for new post? But I still post it here, because it's concerned with strings replacing (I hope so.. )

[Cyberian75]

[Aoidas]

I have some other things to do, and now I'm back to this letters converting.
I founded, that I'm trying to do same thing once again:
in b2-include folder there is file b2vars.php which is used to replace BBCode`s to HTML, so I think, that I could add there required letters and everything should be allright, but one problem:
then I add "ą" (ą), and add in OUT array code ą