$generate = new SimpleList(); $generate->setTitle('No device type found - ' . $provider->name . ' <small>' . $provider->version . '</small>'); $generate->setElements($result); file_put_contents($folder . '/device-types.html', $generate->getHtml()); } /* * botNames */ if ($provider->canDetectBotName === true) { echo '.'; $sql = "\n SELECT\n \tresBotName as name,\n \tuaId,\n \tuaString,\n \t(\n \t\tSELECT\n \t\t\tCOUNT(1)\n \t\tFROM result as res2\n WHERE\n \t\t\tres2.userAgent_id = uaId\n AND res2.resBotName IS NOT NULL\n \t\t\tAND res2.provider_id != '" . $provider->id . "'\n ) as `detectionCount`\n FROM result\n JOIN userAgent\n \tON uaId = userAgent_id\n WHERE\n \tprovider_id = '" . $provider->id . "'\n AND resResultFound = 1\n AND resBotIsBot IS NOT NULL\n AND resBotName IS NULL\n "; $result = $conn->fetchAll($sql); $generate = new SimpleList(); $generate->setTitle('No bot name found - ' . $provider->name . ' <small>' . $provider->version . '</small>'); $generate->setElements($result); file_put_contents($folder . '/bot-names.html', $generate->getHtml()); } /* * botTypes */ if ($provider->canDetectBotType === true) { echo '.'; $sql = "\n SELECT\n \tresBotType as name,\n \tuaId,\n \tuaString,\n \t(\n \t\tSELECT\n \t\t\tCOUNT(1)\n \t\tFROM result as res2\n WHERE\n \t\t\tres2.userAgent_id = uaId\n AND res2.resBotType IS NOT NULL\n \t\t\tAND res2.provider_id != '" . $provider->id . "'\n ) as `detectionCount`\n FROM result\n JOIN userAgent\n \tON uaId = userAgent_id\n WHERE\n \tprovider_id = '" . $provider->id . "'\n AND resResultFound = 1\n AND resBotIsBot IS NOT NULL\n AND resBotType IS NULL\n "; $result = $conn->fetchAll($sql); $generate = new SimpleList(); $generate->setTitle('No bot type found - ' . $provider->name . ' <small>' . $provider->version . '</small>'); $generate->setElements($result); file_put_contents($folder . '/bot-types.html', $generate->getHtml()); } echo PHP_EOL; }
file_put_contents($folder . '/device-brands.html', $generate->getHtml()); echo '.'; /* * detected - deviceTypes */ $sql = "\n SELECT\n resDeviceType as name,\n uaId,\n \tuaString,\n COUNT(1) `detectionCount`\n FROM result\n JOIN userAgent\n ON uaId = userAgent_id\n WHERE\n provider_id IN('" . implode('\', \'', $proIds) . "')\n AND resDeviceType IS NOT NULL\n GROUP BY resDeviceType\n"; $result = $conn->fetchAll($sql); $generate = new SimpleList($entityManager); $generate->setTitle('Detected device types'); $generate->setElements($result); file_put_contents($folder . '/device-types.html', $generate->getHtml()); echo '.'; /* * detected - botNames */ $sql = "\n SELECT\n resBotName as name,\n uaId,\n \tuaString,\n COUNT(1) `detectionCount`\n FROM result\n JOIN userAgent\n ON uaId = userAgent_id\n WHERE\n provider_id IN('" . implode('\', \'', $proIds) . "')\n AND resBotName IS NOT NULL\n GROUP BY resBotName\n"; $result = $conn->fetchAll($sql); $generate = new SimpleList($entityManager); $generate->setTitle('Detected bot names'); $generate->setElements($result); file_put_contents($folder . '/bot-names.html', $generate->getHtml()); echo '.'; /* * detected - botTypes */ $sql = "\n SELECT\n resBotType as name,\n uaId,\n \tuaString,\n COUNT(1) `detectionCount`\n FROM result\n JOIN userAgent\n ON uaId = userAgent_id\n WHERE\n provider_id IN('" . implode('\', \'', $proIds) . "')\n AND resBotType IS NOT NULL\n GROUP BY resBotType\n"; $result = $conn->fetchAll($sql); $generate = new SimpleList($entityManager); $generate->setTitle('Detected bot types'); $generate->setElements($result); file_put_contents($folder . '/bot-types.html', $generate->getHtml());
if ($provider->canDetectDeviceType === true) { $sql = "\n SELECT\n resDeviceType as name,\n uaId,\n \tuaString,\n COUNT(1) `detectionCount`\n FROM result\n JOIN userAgent\n ON uaId = userAgent_id\n WHERE\n resDeviceType IS NOT NULL\n AND provider_id = '" . $provider->id . "'\n GROUP BY resDeviceType\n "; $result = $conn->fetchAll($sql); $generate = new SimpleList(); $generate->setTitle('Detected device types - ' . $provider->name . ' <small>' . $provider->version . '</small>'); $generate->setElements($result); file_put_contents($folder . '/device-types.html', $generate->getHtml()); } /* * detected - botNames */ if ($provider->canDetectBotName === true) { $sql = "\n SELECT\n resBotName as name,\n uaId,\n \tuaString,\n COUNT(1) `detectionCount`\n FROM result\n JOIN userAgent\n ON uaId = userAgent_id\n WHERE\n resBotName IS NOT NULL\n AND provider_id = '" . $provider->id . "'\n GROUP BY resBotName\n "; $result = $conn->fetchAll($sql); $generate = new SimpleList(); $generate->setTitle('Detected bot names - ' . $provider->name . ' <small>' . $provider->version . '</small>'); $generate->setElements($result); file_put_contents($folder . '/bot-names.html', $generate->getHtml()); } /* * detected - botTypes */ if ($provider->canDetectBotType === true) { $sql = "\n SELECT\n resBotType as name,\n uaId,\n \tuaString,\n COUNT(1) `detectionCount`\n FROM result\n JOIN userAgent\n ON uaId = userAgent_id\n WHERE\n resBotType IS NOT NULL\n AND provider_id = '" . $provider->id . "'\n GROUP BY resBotType\n "; $result = $conn->fetchAll($sql); $generate = new SimpleList(); $generate->setTitle('Detected bot types - ' . $provider->name . ' <small>' . $provider->version . '</small>'); $generate->setElements($result); file_put_contents($folder . '/bot-types.html', $generate->getHtml()); } }