Deleted users

[Thomas]

Hei

I'm not sure if ther is a mod that is my solution, but I ask the question here anyway.

I have deleted a user at my board, and then his posts remain but he is registered as a guest. The problem is that his real email is also shown in the html code, and now he wants me to get rid of this because of this neing a possible spam source.

Is there a way of doing that easy.
One of his posts can be seen as the first one here.

/Thomas

[[Unknown]]

UPDATE yabbse_messages
SET posterEmail = ''
WHERE posterEmail = '[email protected]';

-[Unknown]

[Thomas]

Thanks Unknown.

Is there possible to run this from a php file?

/Thomas

[FaSan]

http://www.yabbse.org/community/index.php?thread=18386/0

[Thomas]

Unknown or others:Can you bee so kind to put this in a php file for me.

/Thomas

[[Unknown]]

<?php

include('Settings.php');
mysql_connect($db_server, $db_user, $db_passwd);
mysql_select_db($db_name);

mysql_query("
  UPDATE {$db_prefix}messages
  SET posterEmail = ''
  WHERE posterEmail = '[email protected]'");

?>

-[Unknown]

[Thomas]

Thanks Unknown

/Thomas