Fehler im Statistik-Tracker

[MC600]

Mir sind einige Fehler/Unkorrektheiten in den Statistiken aufgefallen. In diesem Thema werde ich Lösungsvorschläge aufzeigen, über die dann diskutiert werden kann. Voraussetzung: Statistik-Tracker ist eingeschaltet.

Gelöschte User werden nicht erfasst
Meldet sich ein User z.B. 5 mal an einem Tag am Forum an (weil er z.B. immer wieder eine falsche E-Mail Adresse angegeben hat) oder du testest die Anmeldung und löscht die User wieder, dann erscheinen in den Statistiken Neue Mitglieder dennoch die gelöschen User als Neue Mitglieder.

Dies kannst du ändern wenn du willst. Suche in profile.php nach:

Code Select Expand

      if(($settings[7] == 'Administrator' || $member['user'] == $username)) {
            $request = mysql_query("UPDATE {$db_prefix}messages SET ID_MEMBER='-1' WHERE ID_MEMBER='$userID'");
            $request = mysql_query("DELETE FROM {$db_prefix}members WHERE memberName='$member[user]'");
            $request = mysql_query("DELETE FROM {$db_prefix}log_topics WHERE memberName='$member[user]'");
            $request = mysql_query("DELETE FROM {$db_prefix}log_boards WHERE memberName='$member[user]'");
            $request = mysql_query("DELETE FROM {$db_prefix}log_mark_read WHERE memberName='$member[user]'");
            $request = mysql_query("DELETE FROM {$db_prefix}instant_messages WHERE (toName='$member[user]' AND deletedBy=0)");
            $request = mysql_query("DELETE FROM {$db_prefix}instant_messages WHERE (fromName='$member[user]' AND deletedBy=1)");
            $request = mysql_query("UPDATE {$db_prefix}instant_messages SET deletedBy=1 WHERE toName='$member[user]'");
            $request = mysql_query("UPDATE {$db_prefix}instant_messages SET deletedBy=0 WHERE fromName='$member[user]'");

      }

und ergänze mit diesem Code

Code Select Expand

   if ($modSettings['trackStats']==1){
      $date = getdate(time());
      $statsquery = mysql_query("UPDATE {$db_prefix}log_activity SET registers = registers - 1 WHERE month = $date[mon] AND day = $date[mday] AND year = $date[year]");
      if(mysql_affected_rows() == 0)
        $statsquery = mysql_query("INSERT INTO {$db_prefix}log_activity (month, day, year, registers) VALUES ($date[mon], $date[mday], $date[year], 1)");
    }
sieht dann so aus:

Code Select Expand

      if(($settings[7] == 'Administrator' || $member['user'] == $username)) {
            $request = mysql_query("UPDATE {$db_prefix}messages SET ID_MEMBER='-1' WHERE ID_MEMBER='$userID'");
            $request = mysql_query("DELETE FROM {$db_prefix}members WHERE memberName='$member[user]'");
            $request = mysql_query("DELETE FROM {$db_prefix}log_topics WHERE memberName='$member[user]'");
            $request = mysql_query("DELETE FROM {$db_prefix}log_boards WHERE memberName='$member[user]'");
            $request = mysql_query("DELETE FROM {$db_prefix}log_mark_read WHERE memberName='$member[user]'");
            $request = mysql_query("DELETE FROM {$db_prefix}instant_messages WHERE (toName='$member[user]' AND deletedBy=0)");
            $request = mysql_query("DELETE FROM {$db_prefix}instant_messages WHERE (fromName='$member[user]' AND deletedBy=1)");
            $request = mysql_query("UPDATE {$db_prefix}instant_messages SET deletedBy=1 WHERE toName='$member[user]'");
            $request = mysql_query("UPDATE {$db_prefix}instant_messages SET deletedBy=0 WHERE fromName='$member[user]'");

      }

    if ($modSettings['trackStats']==1){
      $date = getdate(time());
      $statsquery = mysql_query("UPDATE {$db_prefix}log_activity SET registers = registers - 1 WHERE month = $date[mon] AND day = $date[mday] AND year = $date[year]");
      if(mysql_affected_rows() == 0)
        $statsquery = mysql_query("INSERT INTO {$db_prefix}log_activity (month, day, year, registers) VALUES ($date[mon], $date[mday], $date[year], 1)");
    }