Investigations

We strive to investigate a variety of locations. While there are many known haunted sites, it's important that we research to find new haunted locations to share with everyone. Our investigations include everything from private residences to asylums to historical locations and everything in between! Nothing is more exciting than finding a new haunted location.


Sort By: Date | Location | Haunted | EVPs


falase ); $db = DB::connect("mysql://nikatsu_nikatsu:pheardom@localhost/nikatsu_nikblog", $options); $db->setOption('portability', DB_PORTABILITY_NUMROWS); if (!$db) { die (mysql_error()); } if ($sort == "evps") { $sql = "select a.id, a.name, a.file, a.stamp, a.site, a.haunted, a.haunted+0 as haunted2, a.image, count(b.id) as total, b.site_id from locations a join evps b on a.id=b.site_id group by b.site_id order by total desc"; } else { if($sort == "site" or $sort == "haunted") { $order = "asc"; } else { $order = "desc"; } $sql = "select distinct id,name, file, stamp, site, haunted, haunted+0 as haunted2, image from locations order by $sort $order"; } $q = $db->query($sql); $count = 0; while ($q->fetchInto($row, DB_FETCHMODE_ASSOC)) { switch ($row{"haunted2"}) { case 1: $label = "label-danger"; break; case 2: $label = "label-danger"; break; case 3: $label = "label-danger"; break; case 4: $label = "label-warning"; break; case 5: $label = "label-primary"; break; case 6: $label = "label-success"; break; } print <<
{$row{name}}
{$row{haunted}}

{$row{site}}
Investigated: {$row{stamp}}
Evidence

WEB; $sql2 = "select id from evps where site_id={$row{id}}"; $q2 = $db->query($sql2); if ($q2->numRows() > 0 ) { echo "Audio EVPs
\n"; } $sql3 = "select id from videos where siteid={$row{id}}"; $q3 = $db->query($sql3); if ($q3->numRows() > 0) { echo "Video Clip EVPs
\n"; } $sql4 = "select id from webvids where site_id={$row{id}}"; $q4 = $db->query($sql4); if ($q4->numRows() > 0 ) { echo "Investigation Videos
\n"; } print <<

WEB; } ?>