menudo foro tan permisivo que deja más del 3.000% xD
¿Puedes seguir enviando y recibiendo mensajes?
Está claro que la opción de recontar mensajes privados no funciona correctamente.
// Get all members with wrong number of personal messages.
if ($_REQUEST['step'] <= 2)
{
$request = db_query("
SELECT /*!40001 SQL_NO_CACHE */ mem.ID_MEMBER, COUNT(pmr.ID_PM) AS realNum, mem.instantMessages
FROM {$db_prefix}members AS mem
LEFT JOIN {$db_prefix}pm_recipients AS pmr ON (mem.ID_MEMBER = pmr.ID_MEMBER AND pmr.deleted = 0)
GROUP BY mem.ID_MEMBER
HAVING realNum != instantMessages", __FILE__, __LINE__);
while ($row = mysql_fetch_assoc($request))
updateMemberData($row['ID_MEMBER'], array('instantMessages' => $row['realNum']));
mysql_free_result($request);
$request = db_query("
SELECT /*!40001 SQL_NO_CACHE */ mem.ID_MEMBER, COUNT(pmr.ID_PM) AS realNum, mem.unreadMessages
FROM {$db_prefix}members AS mem
LEFT JOIN {$db_prefix}pm_recipients AS pmr ON (mem.ID_MEMBER = pmr.ID_MEMBER AND pmr.deleted = 0 AND pmr.is_read = 0)
GROUP BY mem.ID_MEMBER
HAVING realNum != unreadMessages", __FILE__, __LINE__);
while ($row = mysql_fetch_assoc($request))
updateMemberData($row['ID_MEMBER'], array('unreadMessages' => $row['realNum']));
mysql_free_result($request);
if (array_sum(explode(' ', microtime())) - array_sum(explode(' ', $time_start)) > 3)
{
$context['continue_get_data'] = '?action=boardrecount;step=2;start=0';
$context['continue_percent'] = round(300 / $total_steps);
return;
}
}
Autor
En línea
