Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $content = Parser::getData();
- $sqlHash = "SELECT * FROM `logs` WHERE `hash` = ?";
- $sqlView = "SELECT * FROM `views` WHERE `view` = ?";
- $sqlRequest = "SELECT * FROM `requests` WHERE `hash` = ?";
- foreach ($content as $row) {
- $hash = md5($row);
- $resultLogs = $adapter->query($sqlHash, [$hash]);
- if(count($resultLogs) === 0) {
- $a = unserialize($row);
- $view = $a['view'];
- $request = $a['request'];
- $hashRequest = md5($request);
- if(isset($a['assets'][0])) {
- $assets = $a['assets'][0];
- }
- $resultViews = $adapter->query($sqlView, [$view]);
- if(count($resultViews) === 0){
- $statement = $adapter->createStatement("INSERT INTO `views` (view) VALUES ('$view')");
- $idV = $statement->execute()->getGeneratedValue();
- } else {
- $idV = $resultViews->toArray()[0]['id'];
- }
- $resultRequests = $adapter->query($sqlRequest, [$hashRequest]);
- if(count($resultRequests) === 0){
- $statement = $adapter->createStatement("INSERT INTO `requests` (request, hash) VALUES ('$request', '$hashRequest')");
- $idR = $statement->execute()->getGeneratedValue();
- } else {
- $idR = $resultRequests->toArray()[0]['id'];
- }
- $statement = $adapter->createStatement("INSERT INTO `logs` (id_v, id_r, hash)
- VALUES ('$idV', '$idR', '$hash' )");
- $idLog = $statement->execute()->getGeneratedValue();
- if(isset($assets)) {
- foreach ($assets as $asset) {
- $statement = $adapter->createStatement("INSERT INTO `assets` (asset) VALUES ('$asset')");
- $idAsset = $statement->execute()->getGeneratedValue();
- $statement = $adapter->createStatement("INSERT INTO `logs_assets` (id_l, id_a) VALUES ('$idLog', '$idAsset')");
- $statement->execute();
- }
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement