vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Need help ASAP for Police Help!!!!! Are a User IP Addresses Listed Chronologically? (https://vborg.vbsupport.ru/showthread.php?t=48722)

maoz440 02-09-2003 01:28 PM
Need help ASAP for Police Help!!!!! Are a User IP Addresses Listed Chronologically?
 
A user on my forum has made a very serious threat to shoot another kid at school on Monday. I am helping his local police investigate his identity. Among other things I sent the investigator a list of all IP addys the kid has used to log on. Is there a little hack or piece of code I can run to correllate a list of IP address (from a user's admin panel profile) to a list of dates? Any timely help is greatly appreciated as time is of the essence.

Thanks.

Dean C 02-09-2003 02:33 PM
Wow it sounds very serious. Someone will help you very shortly i hope :)

- miSt

Xenon 02-09-2003 03:04 PM
open admin/user.php find this block:
PHP Code:
// ############################# douserid() #########################
function douserid($userid,$previpaddress,$depth=2) {
  global $DB_site,$session;

  $depth--;

  $getusername=$DB_site->query_first("SELECT username FROM user WHERE userid=$userid");
  echo "<ul>";

  $ips=$DB_site->query("SELECT DISTINCT ipaddress FROM post WHERE userid=$userid AND ipaddress<>'' AND ipaddress<>'$previpaddress' ORDER BY ipaddress");
  while ($ip=$DB_site->fetch_array($ips)) {

    echo "<li>$ip[ipaddress] (".gethostbyaddr($ip[ipaddress]).") ".makelinkcode("find more users for this ip","user.php?s=$session[sessionhash]&action=doips&ipaddress=$ip[ipaddress]")."</li>\n";

    if ($depth>0 and $ip[ipaddress]!=$previpaddress) {
      doipaddress($ip[ipaddress],$userid,$depth);
    }

  }

  echo "</ul>";

} 
and change it into:
PHP Code:
// ############################# douserid() #########################
function douserid($userid,$previpaddress,$depth=2) {
  global $DB_site,$session;

  $depth--;

  $getusername=$DB_site->query_first("SELECT username FROM user WHERE userid=$userid");
  echo "<ul>";

  $ips=$DB_site->query("SELECT DISTINCT ipaddress, dateline FROM post WHERE userid=$userid AND ipaddress<>'' AND ipaddress<>'$previpaddress' ORDER BY ipaddress");
  while ($ip=$DB_site->fetch_array($ips)) {

    echo "<li>".date("H:i m-d-Y", $ip[dateline]). ": $ip[ipaddress] (".gethostbyaddr($ip[ipaddress]).") ".makelinkcode("find more users for this ip","user.php?s=$session[sessionhash]&action=doips&ipaddress=$ip[ipaddress]")."</li>\n";

    if ($depth>0 and $ip[ipaddress]!=$previpaddress) {
      doipaddress($ip[ipaddress],$userid,$depth);
    }

  }

  echo "</ul>";

} 
think this should do what ya wanted

maoz440 02-09-2003 03:21 PM
Worked Perfectly Xenon - exactly what the inspector needed! :D Thanks so much! I'll keep you posted on what develops with this sad situation.

maoz

Dean C 02-09-2003 03:41 PM
Xenon what does that code do btw :)?

- miSt

Xenon 02-09-2003 03:52 PM
@maoz: glad i could help :)

@Mist: it shows the dateline near the ip when it was used..

Dean C 02-09-2003 04:32 PM
Ahhh cool :) Thanks bud!

- miSt

Erwin 02-09-2003 07:50 PM
That serious stuff. Hope they catch the guy.

Logik 02-10-2003 03:51 AM
/me watches the TV show "Cops".
"A vBulletin killer on the loose!"

Xenon 02-10-2003 12:49 PM
@Logik: i think this is a theme where you shouldn't make any fun of it...

just calm down a bit, not every thread needs your comments!

Dominick 02-10-2003 05:41 PM
Quote:
Originally posted by maoz440
A user on my forum has made a very serious threat to shoot another kid at school on Monday. I am helping his local police investigate his identity.

Thanks.
Im banning anyone under 18 from my forum...
:devious:

maoz440 02-10-2003 07:42 PM
Xenon - thanks again for your help. :D Thought I would paste some of the inspector's email to me this morning :)

"I wanted to let you know that all your efforts to assist paid off. I put the Regional Police in touch with the family of the youth who posted those messages on your website. The investigators contacted me to let me know they were planning on attending that evening to speak to the boy and his parents.
I do not know what the final results were, however I am sure they attended and took some type of action to evaluate the situation. I will let you know more within a few days as to whether it was actually a threat or not. The matter is no longer a concern though, and we can be more relaxed regarding the kids going to school today.

Thanks again!"

A good ending to a bad situation!

Xenon 02-10-2003 08:09 PM
yeah, really...

that's how vb admins can help the police :)

Erwin 02-10-2003 08:30 PM
And another episode of Law and Order ends... ;)

Logik 02-10-2003 10:14 PM
Wait.. Xenon, i just got jumped at for joking. But yet, Erwin can say a smart comment (being funny). But when i do, i get told every thread dont need my comment..

Xenon 02-11-2003 11:03 AM
maybe you should compare when Erwin posted his comment and when you did.
Also compare what he posted and what you did.

Logik 02-11-2003 08:50 PM
Same thing. Basically cops, both are. I mean it was a joke. Xenon just calm down bro.

Dribbles 02-11-2003 09:19 PM
Internet threats are so common


All times are GMT. The time now is 03:44 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01059 seconds
  • Memory Usage 1,769KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_php_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (18)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete