• From: Leuven, Belgium
  • Registered: 2005-06-14
  • Posts: 2,653

Re: Log Forum Activity 1.2

User: elbekko
IP: 127.0.0.1
Viewed page at: 
    Today 23:33:45
    Today 23:33:41
    Today 23:33:37
    Today 23:33:35
    2006-04-16 16:28:15
    2006-04-16 16:28:14
    2006-04-16 16:27:53
    2006-04-16 16:27:51
    2006-04-16 16:27:43
    2006-04-16 16:26:57
    2006-04-16 16:25:59
    2006-04-16 16:25:57
    2006-04-16 16:25:55
    2006-04-16 16:25:53
    2006-04-16 00:27:50
    2006-04-16 00:27:47
    2006-04-16 00:24:25
    2006-04-16 00:24:22
    2006-04-16 00:24:18
    2006-04-16 00:24:16
    2006-04-16 00:24:14
    2006-04-16 00:24:07
    2006-04-16 00:24:03
    2006-04-16 00:23:20
    2006-04-16 00:23:17
    2006-04-16 00:23:09
    2006-04-16 00:23:08
    2006-04-16 00:23:07
    2006-04-16 00:22:28
    2006-04-16 00:22:24
    2006-04-16 00:22:05
    2006-04-16 00:21:35
    2006-04-16 00:21:02
    2006-04-16 00:20:56
    2006-04-16 00:20:02
    2006-04-16 00:20:00
    2006-04-16 00:19:48
    2006-04-16 00:19:46
    2006-04-16 00:19:14
    2006-04-16 00:19:13
    2006-04-16 00:18:50
    2006-04-16 00:18:49
    2006-04-16 00:18:39
    2006-04-16 00:18:37
    2006-04-16 00:17:57
    2006-04-16 00:17:55
    2006-04-16 00:17:34
    2006-04-16 00:17:28
    2006-04-16 00:17:23
    2006-04-16 00:16:29
    2006-04-16 00:15:14
    2006-04-16 00:15:12
    2006-04-16 00:13:18
    2006-04-16 00:13:17
    2006-04-16 00:12:40
    2006-04-16 00:12:27
    2006-04-16 00:12:26
    2006-04-16 00:12:26
    2006-04-16 00:12:25
    2006-04-16 00:12:24
    2006-04-16 00:12:24
    2006-04-16 00:12:23
    2006-04-16 00:12:22
    2006-04-16 00:12:22
    2006-04-16 00:12:21
    2006-04-16 00:12:21
    2006-04-16 00:12:15
    2006-04-16 00:12:13
    2006-04-16 00:12:12
    2006-04-16 00:12:10
    2006-04-16 00:12:08
    2006-04-16 00:11:12
    2006-04-16 00:10:16
    2006-04-16 00:10:09
    2006-04-16 00:10:01
    2006-04-16 00:06:42
    2006-04-16 00:06:34
    2006-04-16 00:06:28
    2006-04-16 00:06:20
    2006-04-16 00:06:03
    2006-04-16 00:03:20
    2006-04-16 00:03:11
    2006-04-16 00:01:13
    2006-04-16 00:01:02
    2006-04-16 00:00:53
    2006-04-16 00:00:49
    2006-04-15 23:59:20
    2006-04-15 23:59:20
    2006-04-15 23:59:20
    2006-04-15 23:59:20
    2006-04-15 23:59:19
    2006-04-15 23:59:19
    2006-04-15 23:59:19
    2006-04-15 23:59:18
    2006-04-15 23:59:18
    2006-04-15 23:59:17
    2006-04-15 23:59:17
    2006-04-15 23:59:17
    2006-04-15 23:59:17
    2006-04-15 23:59:16
    2006-04-15 23:59:16
    2006-04-15 23:58:18
    2006-04-15 23:58:17
    2006-04-15 23:57:06
    2006-04-15 23:57:04
    2006-04-15 23:55:15
    2006-04-15 23:55:13
    2006-04-15 23:54:03
    2006-04-15 23:54:01
    2006-04-15 23:54:00
    2006-04-15 23:53:59
    2006-04-15 23:53:51
    2006-04-15 23:52:15
    2006-04-15 23:52:14
    2006-04-15 23:51:15
    2006-04-15 23:51:13
    2006-04-15 23:50:37
    2006-04-15 23:50:15
    2006-04-15 23:50:14
    2006-04-15 23:48:27
    2006-04-15 23:48:25
    2006-04-15 23:47:59
    2006-04-15 23:47:57
    2006-04-15 23:42:21
    2006-04-15 23:42:20
    2006-04-15 23:42:19
    2006-04-15 23:42:16
    2006-04-15 23:42:07
    2006-04-15 23:40:56
    2006-04-15 23:40:42
    2006-04-15 23:40:40
    2006-04-15 23:40:25
    2006-04-15 23:40:24
    2006-04-15 23:40:16
    2006-04-15 23:25:26
    2006-04-15 23:25:02
    2006-04-15 23:24:53
    2006-04-15 23:22:59
    2006-04-15 23:17:49
    2006-04-15 23:16:34
    2006-04-15 23:16:32
    2006-04-15 23:15:59


User: Guest
IP: 127.0.0.1
Viewed page at: 
    Today 23:33:33
    Today 23:33:32
    Today 23:33:30
    2006-07-14 12:52:06
    2006-07-10 22:21:46
    2006-04-28 23:00:33
    2006-04-17 15:14:08
    2006-04-16 16:25:52
    2006-04-16 16:25:50
    2006-04-16 16:25:48
    2006-04-16 00:28:05
    2006-04-16 00:27:51
    2006-04-16 00:22:53
    2006-04-16 00:22:37
    2006-04-16 00:22:31
    2006-04-16 00:22:29
    2006-04-16 00:17:22
    2006-04-16 00:17:15
    2006-04-16 00:17:12
    2006-04-15 23:53:58
    2006-04-15 23:53:56
    2006-04-15 23:53:56
    2006-04-15 23:53:55
    2006-04-15 23:53:55
    2006-04-15 23:53:55
    2006-04-15 23:53:54
    2006-04-15 23:53:54
    2006-04-15 23:53:52


User: testuser
IP: 127.0.0.1
Viewed page at: 
    2006-04-16 00:24:11
    2006-04-16 00:23:16
    2006-04-16 00:23:16
    2006-04-16 00:23:15
    2006-04-16 00:23:15
    2006-04-16 00:23:15
    2006-04-16 00:23:14
    2006-04-16 00:22:55
  • Registered: 2006-04-30
  • Posts: 382

Re: Log Forum Activity 1.2

mmm... might get very heavy for a bigger forum.
i think a database its like mandatory for this mod.

  • From: Leuven, Belgium
  • Registered: 2005-06-14
  • Posts: 2,653

Re: Log Forum Activity 1.2

It's DB-based...

  • Registered: 2006-01-24
  • Posts: 55

Re: Log Forum Activity 1.2

Hi elbekko   
I want to not register logs of guests except those of bots.
Having installed mod "BotDetect v1.5 ", I thought replace (in inlcude/common.php) this code:

// Add user to log
$log_res = $db->query("SELECT id, time FROM ".$db->prefix."log WHERE name='".$pun_user['username']."'");
$log_row = $db->fetch_assoc($log_res);
if($log_row['id'])
    {
    $log_time = $log_row['time'] . ", " . time();
    $db->query("UPDATE ".$db->prefix."log SET `time` = '".$log_time."', `ip` = '".$_SERVER['REMOTE_ADDR']."' WHERE id=".$log_row['id']);
    }
else
    {
    $db->query("INSERT INTO ".$db->prefix."log (`ip`, `name`, `time`) VALUES ('".$_SERVER['REMOTE_ADDR']."', '".$pun_user['username']."', '".time()."')");
    }

By:

// Add user to log
$log_res = $db->query("SELECT id, time FROM ".$db->prefix."log WHERE name='".$pun_user['username']."'");
$log_row = $db->fetch_assoc($log_res);

include('botdetect.php');
$botStatus = isBotOnline();

if ($pun_user['g_id'] != PUN_GUEST || $botStatus != '')
{
if($log_row['id'])
    {
    $log_time = $log_row['time'] . ", " . time();
    $db->query("UPDATE ".$db->prefix."log SET `time` = '".$log_time."', `ip` = '".$_SERVER['REMOTE_ADDR']."' WHERE id=".$log_row['id']);
    }
else
    {
    $db->query("INSERT INTO ".$db->prefix."log (`ip`, `name`, `time`) VALUES ('".$_SERVER['REMOTE_ADDR']."', '".$pun_user['username']."', '".time()."')");
    }
}

The only valid result is that guests are no longer logged when any bot is online.
But it not good when a bot is online: At this point all guests are logged and the bots are not individually identified by name as in online.php.
I have tried without success how to arrive at a result.
Can you give me an idea?

Thanks a lot.


Regards