UPDATE `evo_posts` SET `post_content` = REPLACE(`post_content`,'http://www.chaoszone.de/blog/count.php?url=','');

Run that in your phpMyAdmin :)

Just for a little note, step 1) http://www.google.com/search?q=search+and+replace+mysql+query&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-GB:official&client=firefox-a step 2) http://blog.igeek.info/still-fresh/2005/08/31/search-replace-in-mysql-tables/ step 3) read first comment step 4) re-write :)

This comes in handy: a question I wanted to post is answered already today. I needed to get rid of some comments in the XHTML style <!-- --> that conflicted with the new way the _auto_p_plugin handles <!--more-->.

Thanks

Thanks balupton, I know I could count on you... ;-)

It worked in my database... but weird I can´t see it yet by viewing my blog entries... although when I want to edit a posting, the pre-URL is gone... after deleting my browser cache, the page itself still shows the pre-URL... weird... I don´t understand why... but I hope that´s some cache problem and nothing more...

Any ideas how to change that? Do I have to click a refresh-button anywhere in b2evo or do I have to edit each posting and save it new... I´ve treid... then the pre-URL is gone even when I do not have made changes in the posting by hand...

Some random example: http://www.chaoszone.de/blog/webnews.php/2007/06/24/verlorener_bauchnabel

Admin > app tools click "delete pre-rendered content" ;)

¥

Amazing... now this problem is history!

There are other ways of counting clicks ( using js if enabled ) ;)

¥

Ah.. js=javascript? And how?

It depends oh how you want to track them :

1) We have a plugin that opens all external links in a new window/tab, the page that it calls can have click tracking added ( you could use googles urchin tracker for this )

2) We have a script that adds image tracking for clicks ( but it works on all links in a section of your page, not just external ones, although the code could be amended )

Basically it works by intercepting the onclick and changing an images source to the click tracker, waits a tad and then follows the link as normal

Both methods require js to be enabled in the browser though so the stats won't be 100% accurate

¥