Ok here is my complete functions list.
<?php
/**
* Function that gets last xx searches from database.
* @param int $searches Number of searches that sould be returned from database
* @return string String that contains last
*/
function lastSearches($searches) {
global $baza;
if(!isset($_GET['a'])) $_GET['a'] = 'txt';
$sql = "SELECT cat, query FROM cache WHERE cat = '{$_GET['a']}' LIMIT $searches";
$baza -> izvrsiUpit($sql);
$baza -> stvoriNiz();
$str = "";
while($red = $baza -> noviRed()) {
$str .= "<li><a href=\"http://kywordpro.com/txt/1/10/" . urlencode($red["query"]) . ".html\" target=\"blank\">" . $red['query'] . "</a> ";
}
return substr($str, 0, strlen($str) - 2);
}
function remUserAd() {
global $baza;
$sql = "DELETE FROM adds WHERE UNIX_TIMESTAMP(NOW()) > UNIX_TIMESTAMP(expire)";
$baza -> izvrsiUpit($sql);
}
if(!function_exists('file_get_contents')) {
function file_get_contents($url) {
$f = fopen($url, 'r');
while(!feof($f)) {
$str .= fread($f, '1024');
}
fclose($f);
return $str;
}
}
if(!function_exists('file_get_contents')) {
function file_put_contents($url, $data) {
$f = fopen($url, 'w+');
fwrite($f, $data);
fclose($f);
return true;
}
}
/**
* Returns user adds
* @return string String that contains add code
*/
function userAdd() {
global $baza, $q;
$sql = "SELECT * FROM adds WHERE LOWER(keyword) = '$q' AND STATUS = '1'";
$baza -> izvrsiUpit($sql);
$baza -> stvoriNiz();
while($red = $baza -> noviRed()) {
if(empty($red['img'])) {
$str = file_get_contents('inc/templates/sponsor.htm');
}
else {
$str = file_get_contents('inc/templates/sponsorImg.htm');
}
$search = array('[url]', '[title]', '[desc]', '[root]', '[img]');
$rep = array($red['url'], $red['title'], $red['desc'], ROOT, $red['img']);
$add .= str_replace($search, $rep, $str);
$sql = "UPDATE adds SET hits = hits + '1' WHERE id = '{$red['id']}'";
$baza -> izvrsiUpit($sql);
}
return $add . '';
}
/**
* Returns google adds
* @param int $int Code (1 upp, 2 low)
* @return string String that contains google add code
*/
function googleAdd($int) {
if(file_get_contents('inc/ads/' . $int . '.txt') == 1) {
return file_get_contents('inc/ads/google' . $int . '.txt');
}
}
/**
* Function that generates xml sitemap
* @return bool True on success, false on failure
*/
function genSiteMap() {
global $baza, $clear;
$xml = "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<urlset xmlns=\"http://www.sitemaps.org/schemas/sitemap/0.9\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:schemaLocation=\"http://www.sitemaps.org/schemas/sitemap/0.9 http://www.sitemaps.org/schemas/sitemap/0.9/sitemap.xsd\">\n";
$xml .= "\t<url>\n\t\t<loc>" . ROOT . "</loc>\n\t\t";
$xml .= "<priority>1</priority>\n\t\t";
$xml .= "<changefreq>" . $clear . "</changefreq>\n\t";
$xml .= "</url>\n";
$xml .= "\t<url>\n\t\t<loc>" . ROOT . "index.php</loc>\n\t\t";
$xml .= "<priority>0.9</priority>\n\t\t";
$xml .= "<changefreq>" . $clear . "</changefreq>\n\t";
$xml .= "</url>\n";
$sql = "SELECT query, cat FROM cache";
$baza -> izvrsiUpit($sql);
$baza -> stvoriNiz();
while($red = $baza -> noviRed()) {
$xml .= "\t<url>\n\t\t<loc>" . ROOT . "txt/1/10/" . urlencode($red["query"]) . ".html</loc>\n\t\t";
$xml .= "<priority>0.8</priority>\n\t\t";
$xml .= "<changefreq>" . $clear . "</changefreq>\n\t";
$xml .= "</url>\n";
}
$xml .= "</urlset>";
file_put_contents('sitemap.xml', $xml);
}
/**
* Function check if we have that query in cache.
* @param string $q Query string
* @param string $a Action
* @return mix query string if in cache, false if not
*/
function inCache($q, $a) {
global $baza;
$sql = "SELECT * FROM cache WHERE LCASE(query) = LCASE('$q') AND cat = '$a' LIMIT 1";
$baza -> izvrsiUpit($sql); echo mysql_error();
if($baza -> brSelectRedova() > 0) {
$baza -> stvoriNiz();
$red = $baza -> noviRed();
return $red['result'];
}
else {
return false;
}
}
/**
* Function that clears chache.
* @return bool True if success, false if not
*/
function clearCache($time) {
if($time < 1) return true;
global $baza;
$sql = "DELETE cache FROM cache WHERE UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(time) > $time";
$baza -> izvrsiUpit($sql) ? true : false;
return $baza -> optimize("cache") ? true : false;
}
/**
* Function that paginates the result.
* @param int $count Number of results
* @param int $num Array count.
* @param int $page Current page
* @return string Pages
*/
function paginate($count, $num, $page) {
global $a, $q;
$str = '';
if(is_float($count / $num)) {
$max = substr($count / $num, 0, strpos($count / $num, ".")) + 1;
}
else {
$max = $count / $num;
}
if(1 == $page) {
$str .= '<<< | < | ';
}
else {
$str .= "<a href=\"" . ROOT . "$a/1/$num/" . urlencode($q) . ".html\"><<<</a> | <a href=\"" . ROOT . "$a/" . ($page - 1) . "/$num/" . urlencode($q) . ".html\"><</a> | ";
}
for($i = 1; $i < 11; $i++) {
if($i == $max + 1) break;
if($i == $page) {
$str .= "$i | ";
}
else {
$str .= "<a href=\"" . ROOT . "$a/$i/$num/" . urlencode($q) . ".html\">$i</a> | ";
}
}
if($page == $max) {
$str .= '> | >>>';
}
else {
$str .= "<a href=\"" . ROOT . "$a/" . ($page + 1) . "/$num/" . urlencode($q) . ".html\">></a> | <a href=\"" . ROOT . "$a/$max/$num/" . urlencode($q) . ".html\">>>></a>";
}
return $str;
}
/**
* Function that sends request to server and returns results.
* @param string $req Request url
* @return string Results string
*/
function sendReq($req) {
return file_get_contents($req);
}