Enhanced Forum Statistics

[FragaCampos]

I think the upload went wrong and truncated the file... reinstalled and everything is ok. 


Portuguese and brazilian translations:

Code Select Expand


<file name="$themedir/languages/Stats.portuguese.php" error="skip">
<operation>
<search position="end" />
<add><![CDATA[
//-Enhanced Forum Statistics MOD- Start
$txt['enh_stats_title'] = 'Seleccionar per&iacute;odo para ver as estat&iacute;sticas';
$txt['period_title'] = 'Seleccionar o per&iacute;odo onde quer ver as estat&iacute;sticas parciais';
$txt['last'] = '&Uacute;ltimo';
$txt['first'] = 'Primeiro';
$txt['period_0'] = 'Hora(s)';
$txt['period_1'] = 'Dia(s)';
$txt['period_2'] = 'Semana(s)';
$txt['period_3'] = 'M&ecirc;s(es)';
$txt['period_4'] = 'Ano(s)';
$txt['update'] = 'Actualizar';
$txt['number_descr'] = '<em>Usar <strong>0</strong> para ver todos</em>';
$txt['from'] = 'desde';
$txt['to'] = 'at&eacute;';
$txt[564] = 'M&ecirc;s (MM)';
$txt[565] = 'Dia (DD)';
$txt[566] = 'Ano (YYYY)';
//-Enhanced Forum Statistics MOD- End
]]></add>
</operation>
</file>

<file name="$themedir/languages/Stats.brazilian.php" error="skip">
<operation>
<search position="end" />
<add><![CDATA[
//-Enhanced Forum Statistics MOD- Start
$txt['enh_stats_title'] = 'Seleccionar per&iacute;odo para ver as estat&iacute;sticas';
$txt['period_title'] = 'Seleccionar o per&iacute;odo onde quer ver as estat&iacute;sticas parciais';
$txt['last'] = '&Uacute;ltimo';
$txt['first'] = 'Primeiro';
$txt['period_0'] = 'Hora(s)';
$txt['period_1'] = 'Dia(s)';
$txt['period_2'] = 'Semana(s)';
$txt['period_3'] = 'M&ecirc;s(es)';
$txt['period_4'] = 'Ano(s)';
$txt['update'] = 'Actualizar';
$txt['number_descr'] = '<em>Usar <strong>0</strong> para ver todos</em>';
$txt['from'] = 'desde';
$txt['to'] = 'at&eacute;';
$txt[564] = 'M&ecirc;s (MM)';
$txt[565] = 'Dia (DD)';
$txt[566] = 'Ano (YYYY)';
//-Enhanced Forum Statistics MOD- End
]]></add>
</operation>
</file>

[mjltigger]

I just upgraded my test server to 1.1.6 and installed this mod.. it says it all installed properly, i have no errors on either my server or the forum error log and yet nothing has changed on my stats page... am I a muppet?

[HunterP]

I'm getting this error :

Database error: Column 'ID_TOPIC' in field list is ambiguous
File: /www/htdocs/hulpvera/forum/Sources/Stats.php
Line: 492

Code Select Expand

// Are you on a larger forum?  If so, let's try to limit the number of topics we search through.
if ($modSettings['totalMessages'] > 100000)
{
//-Enhanced Forum Statistics MOD- Start
if ($restrict_date)
$request = db_query("
SELECT ID_TOPIC
FROM {$db_prefix}topics as t
LEFT JOIN {$db_prefix}messages as msg ON (msg.ID_MSG = t.ID_FIRST_MSG)
WHERE numReplies != 0 AND posterTime >= $start_date AND posterTime <= $end_date
ORDER BY numReplies DESC
[b] LIMIT 100", __FILE__, __LINE__);
[/b] else
//-Enhanced Forum Statistics MOD- End
$request = db_query("
SELECT ID_TOPIC
FROM {$db_prefix}topics
WHERE numReplies != 0
ORDER BY numReplies DESC
LIMIT 100", __FILE__, __LINE__);
$topic_ids = array();
while ($row = mysql_fetch_assoc($request))
$topic_ids[] = $row['ID_TOPIC'];
mysql_free_result($request);
}
else
$topic_ids = array();

The bold line is 492.

[Rudolf]

Replace

Code Select Expand


SELECT ID_TOPIC
with

Code Select Expand


SELECT t.ID_TOPIC

[texasman1979]

is there a 2.0 rc 5 version of this downloadable or maybe someone that has it can send it to me or something?

[HunterP]

Replace

Code Select Expand


SELECT ID_TOPIC
with

Code Select Expand


SELECT t.ID_TOPIC

Thanks! Is fixed now.

[MommaYoung]

Good Morning Rudolf,

I am trying to install the "Enhanced forum Statistics" for a friend, but I am receiving errors and receiving the following message:  Error in Package Installation

"Error in Package Installation - At least one error was encountered during a test installation of this package. It is strongly recommended that you do not continue with installation unless you know what you are doing, and have made a backup very recently. This error may be caused by a conflict between the package you're trying to install and another package you have already installed, an error in the package, a package which requires another package that you don't have installed yet, or a package designed for another version of SMF."

She is using 2.0.2

Your suggestions would be much appreciated.

Thank you for your time.

[TheListener]

Letting us know there was an error is not enough to go on.

We need to know what the error actually states.

Have you checked your error log?