My b2evolution Version: 1.9.x
using b2evo 1.9.2 I asked some time ago for an option to count my outgoing clicks on links... nobody could really help me out with this so I googled a bit anf found a php/mysql-script which does the job, adding an internal count.php-URL before every external URL.
I learned today that this is really not good for trackbacks, some bloogers are... a little bit displeased by seeing this and removing my trackbacks seeing them as spam. Additionally I learned, that my count.php-URL's are not good for search engines and pageranks etc. so I made my decision to remove all those pre-URL's... the count.php-URL's in front of my out-of-side-links.
But my big problem is... I now have nearly 500 posts in my blogs, and checking all posts and removing all those pre-links would take hours over hours... So... and that´s why I have the "a bit off-topic" in the headline it has nothing to do directly with the b2evolution software itself, but with my MySQL database... the same b2evo is using... because the URL's are saved in the evo_posts fields post_content and post_url...
I need a search-and-replace-function to delete all those pre-URL's simple... to replace "http://www.chaoszone.de/blog/count.php?url=" in my whole database with nothing.
Do anybody knows a (simple) solution for me? Please!
Thank you very much in advance...