Mod: "Recount member posts"

[Adraeus]

Would someone please convert the following code, written by [Unknown], into a Forum Maintenance (General Maintenance) mod? Thank you.

Code Select Expand


<?php

include_once('SSI.php');

$result = db_query("
SELECT ID_MEMBER, COUNT(ID_MSG) AS posts
FROM {$db_prefix}messages
GROUP BY ID_MEMBER", __FILE__, __LINE__);

while ($row = mysql_fetch_assoc($result))
{
db_query("
UPDATE {$db_prefix}members
SET posts = " . (int) $row['posts'] . "
WHERE ID_MEMBER = $row[ID_MEMBER]
LIMIT 1", __FILE__, __LINE__);
}

mysql_free_result($result);

?>


Source

[MaximKat]

up!
but don't forget that posts in some boards shouldn't be counted

[MaximKat]

Code Select Expand

<?php

include_once('SSI.php');

$result = db_query("
SELECT ID_MEMBER, COUNT(ID_MSG) AS posts
FROM {$db_prefix}messages JOIN {$db_prefix}boards ON {$db_prefix}messages.ID_BOARD={$db_prefix}boards.ID_BOARD
WHERE countPosts=0
GROUP BY ID_MEMBER", __FILE__, __LINE__);

while ($row = mysql_fetch_assoc($result))
{
db_query("
UPDATE {$db_prefix}members
SET posts = " . (int) $row['posts'] . "
WHERE ID_MEMBER = $row[ID_MEMBER]
LIMIT 1", __FILE__, __LINE__);
}
mysql_free_result($result);

echo "Done...";

?>

here it is
just convert it into the mod, plz

[MaximKat]

Ok... I created a mod myself 
Just test it (i'm using 1.1)
Posts are recounted when you click "Recount all forum totals and statistics" in Maintainance section
Oh, it lives here http://mods.simplemachines.org/index.php?mod=561
Not approved yet, though