- ');
$szoveg=trim(addslashes($szoveg));
return $szoveg;
*/
// return $alap->connection->quote( trim( strip_tags( html_entity_decode( $szoveg ) ) ) );
$szoveg = trim(strip_tags($szoveg));
$szoveg = $alap->connection->quote($szoveg);
$szoveg = substr($szoveg, 1, -1);
return $szoveg;
}
function text_ellenorzes_tag($szoveg)
{
global $alap;
/*
$szoveg=strip_tags($szoveg, '
');
$szoveg=trim(addslashes($szoveg));
return $szoveg;
*/
// return $alap->connection->quote( trim( strip_tags( html_entity_decode( $szoveg ) ) ) );
$szoveg = $alap->connection->quote($szoveg);
$szoveg = substr($szoveg, 1, -1);
return $szoveg;
}
/**
* melyKonyvtarba()
*
* @param mixed $szam
* @param integer $limit
* @return
*/
function melyKonyvtarba($szam, $limit = 5000)
{
global $user;
if (is_numeric($szam) && is_numeric($limit)) {
return ceil($szam / $limit) * $limit;
} else {
return "alap";
}
}
/**
* random_nev()
*
* @param integer $hossz
* @return
*/
function random_nev($hossz = 14)
{
$karakterek = "0123456789abcdfghjkmnpqrstvwxyz";
$jelszo = "a_";
$szamlalo = 0;
while ($szamlalo < $hossz) {
$valasztott_karakter = substr($karakterek, rand(0, strlen($karakterek) - 1), 1);
// csak hogy minden karakter különböző legyen
if (!strstr($jelszo, $valasztott_karakter)) {
$jelszo .= $valasztott_karakter;
$szamlalo++;
}
}
return $jelszo;
}
/**
* KepekSorrend()
*
* @param mixed $fileList
* @param mixed $sorrendArray
* @return
*/
function KepekSorrend($fileList, $sorrendArray)
{
if (count($fileList) == 0 || count($sorrendArray) == 0) {
return $fileList;
}
$fileListMax = count($fileList) - 1;
for (
$i = 0;
$i <= $fileListMax;
$i++
) {
if (in_array($fileList[$i], $sorrendArray)) {
unset($fileList[$i]);
}
}
return array_merge($sorrendArray, $fileList);
}
/**
* DateToUnix()
*
* @param mixed $str
* @return
*/
function DateToUnix($str)
{
list(
$date,
$time
)
= explode(' ', $str);
list(
$year,
$month,
$day
)
= explode('-', $date);
list(
$hour,
$minute,
$second
)
= explode(':', $time);
$timestamp = mktime($hour, $minute, $second, $month, $day, $year);
return $timestamp;
}
/**
* DebugHtmlComment()
*
* @param mixed $comment
* @return
*/
function DebugHtmlComment($comment)
{
return '';
}
/**
* LinkButton()
*
* @param mixed $s_inpText
* @param mixed $s_inpLink
* @param string $s_inpTitle
* @param string $s_inpClass
* @param string $s_inpStyle
* @return
*/
function LinkButton($s_inpText, $s_inpLink, $s_inpTitle = '', $s_inpClass = '', $s_inpStyle = '')
{
return '';
}
/**
* Lapozas()
*
* @param mixed $i_rekordSzam
* @param mixed $i_oldal
* @param integer $i_rekordPerOldal
* @param string $a_getValtozok
* @return
*/
function Lapozas($i_rekordSzam, $i_oldal, $i_rekordPerOldal = 20, $a_getValtozok = '')
{
global $translator;
/*
$lapozas = Lapozas($row['0'], $oldal);
$kiiras .= $lapozas[0];
$sql = 'SELECT
...
FROM
tabla
WHERE
...
ORDER BY
...
LIMIT ' . $lapozas[1];
return (array) 0 : form
1 : SQL LIMIT
*/
$s_getValtozok = '';
if (is_array($a_getValtozok)) {
foreach ($a_getValtozok as $s_key => $s_value) {
if ($s_key == '') {
$s_getValtozok .= $s_value;
} else {
$s_getValtozok .= '&' . $s_key . '=' . $s_value;
}
}
}
if (!isset($i_oldal)) {
$i_oldal = 1;
}
$items_per_page = $i_rekordPerOldal;
$page_num = $i_oldal;
$offset = ($page_num - 1) * $items_per_page;
$max_page = ceil($i_rekordSzam / $items_per_page);
if ($i_oldal >= 2) {
$prev_page = $i_oldal - 1;
} else {
$prev_page = 1;
}
if ($i_oldal != $max_page) {
$next_page = $i_oldal + 1;
} else {
$next_page = $max_page;
}
for (
$i = 1;
$i <= $max_page;
$i++
) {
$value[($i - 1)][0] = '?oldal=' . $i . $s_getValtozok;
$value[($i - 1)][1] = $i;
}
$sa_return[0] = '';
//$sa_return[0] .= '
';
$sa_return[0] .= '';
$sa_return[0] .= ' ';
//$sa_return[0] .= ' ';
$sa_return[0] .= ' ';
//$sa_return[0] .= ' ';
$sa_return[0] .= ' ';
$i_tol = $offset + 1;
if ($i_rekordSzam < ($i_rekordPerOldal * $page_num)) {
$i_ig = $i_rekordSzam;
} else {
$i_ig = ($i_rekordPerOldal * $page_num);
}
$sa_return[0] .= ' ' . $i_tol . ' - ' . $i_ig . ' / ' . $i_rekordSzam
. ' ';
$sa_return[0] .= '$sql::' . $sql . '
');
}
$res = query($sql);
return $res;
}
}
}
/**
* Insert()
*
* @param mixed $s_tableName
* @param mixed $a_values
* @param bool $b_die
* @return
*/
function Insert($s_tableName, $a_values, $b_die = false)
{
global $alap, $user;
if (!empty($s_tableName)) {
if (is_array($a_values)) {
$sql = 'INSERT INTO ' . $s_tableName . ' (';
foreach ($a_values as $s_key => $s_value) {
$sql .= $s_key . ',';
}
$sql = substr($sql, 0, -1) . ') VALUES (';
foreach ($a_values as $s_key => $s_value) {
if ($s_value == 'NOW()' || $s_value == 'CURDATE()') {
$sql .= $s_value . ',';
} else {
$sql .= '"' . $s_value . '",';
}
}
$sql = substr($sql, 0, -1);
$sql .= ')';
if ($b_die) {
die('$sql::' . $sql . '
');
}
query($sql);
}
}
}
/**
* TelefonszamFormat()
*
* @param mixed $s_telefonszam
* @param bool $b_kellMellek
* @param bool $b_csakMellek
* @return
*/
function TelefonszamFormat($s_telefonszam, $b_kellMellek = true, $b_csakMellek = false)
{
$s_mellek = '';
if (strpos($s_telefonszam, ';') !== false) {
$a_telefonszam = explode(';', $s_telefonszam);
$s_telefonszam = $a_telefonszam[0];
//$s_mellek = ''; //Notice: Undefined variable: s_mellek
if (
isset($a_telefonszam[1]) && !empty($a_telefonszam[1]) && is_numeric($a_telefonszam[1])
&& $a_telefonszam[1] > 0
) {
if ($b_csakMellek) {
return $a_telefonszam[1];
}
if ($b_kellMellek) {
$s_mellek = ' / ' . $a_telefonszam[1];
}
}
}
if ($b_csakMellek) {
return '';
}
if (empty($s_telefonszam)) {
return '';
}
if (strlen($s_telefonszam) == 7) {
return "+36 1 / " . substr($s_telefonszam, 0, 3) . "-" . substr($s_telefonszam, 3, 4) . $s_mellek;
} elseif (strlen($s_telefonszam) == 8) {
if (substr($s_telefonszam, 0, 1) == '1') {
return "+36 1 / " . substr($s_telefonszam, 1, 3) . "-" . substr($s_telefonszam, 4, 4) . $s_mellek;
} else {
return "+36 " . substr($s_telefonszam, 0, 2) . " / " . substr($s_telefonszam, 2, 3) . "-" . substr(
$s_telefonszam,
5,
3
) . $s_mellek;
}
} else {
return "+36 " . substr($s_telefonszam, 0, 2) . " / " . substr($s_telefonszam, 2, 3) . "-" . substr(
$s_telefonszam,
5,
4
) . $s_mellek;
}
}
/**
* TelefonszamFormatUj()
*
* @param mixed $country_id
* @param string $s_telefonszam
* @return
*/
function TelefonszamFormatUj($country_id, $s_telefonszam = '')
{
$s_telefonszam = trim($s_telefonszam);
if ($s_telefonszam == '') {
return '';
}
//global $alap, $c_plum, $cache;
global $alap, $c_plum, $cache, $user, $domain, $lap;
if ($domain == 'beszamolok.com' and $country_id == 1) {
return '+36 ' . $c_plum->SzamFormaz($s_telefonszam);
//return '+36 '.preg_replace('/[^0-9]/', '', $s_telefonszam);
} else {
if (isset($country_id) && !empty($country_id) && is_numeric($country_id)) {
$cachekey = 'telephone_code_' . $country_id;
if (
(
$s_telephone_code = $cache->get($cachekey)) === false
) {
$s_telephone_code = getOne('SELECT telephone_code FROM address_country WHERE id = ' . $country_id);
$cache->set($cachekey, $s_telephone_code);
}
return $s_telephone_code . ' ' . $c_plum->SzamFormaz($s_telefonszam);
}
}
return $c_plum->SzamFormaz($s_telefonszam);
}
/**
* TelefonszamPDALink()
*
* @param mixed $country_id
* @param string $s_telefonszam
* @return
*/
function TelefonszamPDALink($country_id, $s_telefonszam = '')
{
global $domain, $cache;
if ($domain == 'beszamolok.com' and $country_id == 1) {
return '+36' . preg_replace_callback('/[^0-9]/', function () {
return '';
}, $s_telefonszam);
} else {
if (isset($country_id) && !empty($country_id) && is_numeric($country_id)) {
$cachekey = 'telephone_code_' . $country_id;
if (
(
$s_telephone_code = $cache->get($cachekey)) === false
) {
$s_telephone_code = getOne('SELECT telephone_code FROM address_country WHERE id = ' . $country_id);
$cache->set($cachekey, $s_telephone_code);
}
return $s_telephone_code . preg_replace_callback('/[^0-9]/', function () {
return '';
}, $s_telefonszam);
}
}
}
function detectDevice()
{
$userAgent = $_SERVER['HTTP_USER_AGENT'];
// Mobil eszköz detektálása
if (preg_match('/mobile|android|iphone|ipad|phone/i', $userAgent)) {
return 'mobile';
} else {
return 'desktop';
}
}
/**
* TelefonszamTarol()
*
* @param mixed $s_telefonszam
* @param string $s_mellek
* @return
*/
function TelefonszamTarol($s_telefonszam, $s_mellek = '')
{
$telefon = trim($s_telefonszam);
$telefon = str_replace('-', '', $telefon);
$telefon = str_replace(' ', '', $telefon);
$telefon = str_replace('/', '', $telefon);
$telefon = trim(preg_replace("[\s \-\/\(\)]", "", $telefon));
//$telefon = trim(preg_replace_callback("[\s \-\/\+\(\)]","", $telefon));
if (substr($telefon, 0, 2) == "36") {
if (strlen($s_telefonszam) == 8 || strlen($s_telefonszam) == 9) // heves megye 36492120 (36 492-120)
{
} else {
$telefon = substr_replace($telefon, "", 0, 2);
}
}
if (substr($telefon, 0, 3) == "+36") {
$telefon = substr_replace($telefon, "", 0, 3);
}
if (substr($telefon, 0, 2) == "06") {
$telefon = substr_replace($telefon, "", 0, 2);
}
if (isset($s_mellek) && !empty($s_mellek) && is_numeric($s_mellek) && $s_mellek > 0) {
$telefon .= ';' . $s_mellek;
}
return $telefon;
}
/**
* Opciok()
*
* @param mixed $a_array
* @param mixed $i_selected
* @return
*/
function Opciok($a_array, $i_selected)
{
$ret = '';
foreach ($a_array as $key => $value) {
$ret .= '';
}
return $ret;
}
/**
* SetCim()
*
* @param mixed $varosresz_id
* @param mixed $telepules_id
* @param mixed $megye_id
* @return
*/
function SetCim($varosresz_id, $telepules_id, $megye_id)
{
//
global $alap;
if (!isset($megye_id) || !is_numeric($megye_id) || $megye_id < 1) {
return false;
}
$ret = array();
$ret['varosresz'] = '';
$ret['telepules'] = '';
$ret['megye'] = '';
$b_vanVaroszresz = true;
$b_vanTelepules = true;
if (isset($megye_id) && is_numeric($megye_id) && $megye_id > 0) {
$res_megye = query('SELECT id, nev FROM kereso_megye WHERE orszag_id = 1');
while (
$row_megye = $res_megye->fetchRow()
) {
$ret['megye'] .= '';
if (
$row_megye['id'] == $megye_id
&& (!isset($telepules_id) || !is_numeric($telepules_id)
|| $telepules_id < 1)
) {
$telepules_id = $row_megye['id'];
$b_vanTelepules = false;
}
}
}
if (isset($telepules_id) && is_numeric($telepules_id) && $telepules_id > 0) {
if (!$b_vanTelepules) {
$ret['telepules'] .= '';
}
$res_telepules = query('SELECT id, nev, megye_id FROM kereso_telepules WHERE megye_id = ' . $megye_id);
while (
$row_telepules = $res_telepules->fetchRow()
) {
$ret['telepules'] .= '';
if (
$row_telepules['id'] == $telepules_id
&& (!isset($varosresz_id) || !is_numeric($varosresz_id)
|| $varosresz_id < 1)
) {
$varosresz_id = $row_telepules['id'];
$b_vanVaroszresz = false;
}
}
}
if (isset($varosresz_id) && is_numeric($varosresz_id) && $varosresz_id > 0) {
if (!$b_vanVaroszresz) {
$ret['varosresz'] .= '';
}
$res_varosresz = query(
'SELECT id, nev, telepules_id FROM kereso_varosresz WHERE telepules_id = ' . $telepules_id
);
while (
$row_varosresz = $res_varosresz->fetchRow()
) {
$ret['varosresz'] .= '';
}
}
return $ret;
}
/**
* HirdetesTortenetLink()
*
* @param mixed $lid
* @return
*/
function HirdetesTortenetLink($lid)
{
global $lang_modul;
return '
';
}
/**
* HirdetesElo()
*
* @param mixed $user_id
* @return
*/
function HirdetesElo($user_id)
{
if (!isset($user_id) || !is_numeric($user_id)) {
return false;
}
global $alap, $aktualis_ora, $user;
$res = query(
'SELECT id FROM hirdeto WHERE com_user_id = ' . $user_id . ' AND veg >= "' . $aktualis_ora
. '" AND nagyveg >= "' . $aktualis_ora . '"'
);
if ($res->numRows() > 0) {
$row = $res->fetchRow();
return $row['id'];
} else {
$res = query(
'SELECT id FROM hirdeto WHERE user_id = ' . $user_id . ' AND veg >= "' . $aktualis_ora
. '" AND nagyveg >= "' . $aktualis_ora . '"'
);
if ($res->numRows() > 0) {
$row = $res->fetchRow();
return $row['id'];
}
}
return false;
}
/**
* HirdetoSzamok()
*
* @param integer $i_level
* @return
*/
function HirdetoSzamok($i_level = 1)
{
global $alap, $cache, $country_id;
$s_level = 'level_' . $i_level;
$a_nemek['mind'] = -1;
$a_nemek['no'] = 0;
$a_nemek['ferfi'] = 1;
$a_nemek['travi'] = 2;
$a_nemek['par'] = 99;
if (
(
$a_hirdetoszamok = $cache->get('hirdetoszamok_level_' . $i_level, 'hirdeto_szamok')) === false
) {
for (
$fokat = 0;
$fokat <= 2;
$fokat++
) {
foreach ($a_nemek as $nem_key => $nem) {
$a_aktivHirdetok = array();
$res = query(
'SELECT id FROM hirdeto WHERE veg >= NOW() ' . ($nem > -1 ? ' AND neme = ' . $nem . ' ' : '')
. ' AND country_id ' . WhereCountryId($country_id) . ($fokat > 0 ? ' AND fokat = ' . $fokat
: '')
);
while (
$row = $res->fetchRow()
) {
$a_aktivHirdetok[] = $row['id'];
}
if (!empty($a_aktivHirdetok)) {
$a_cim_id = array();
/////////////////////////////////////////////////////////////////////////
// fovaros/videk
$res_capital = query(
'SELECT level, level_id FROM address_capital WHERE country_id ' . WhereCountryId(
$country_id
)
);
if ($res_capital->numRows() > 0 && $country_id > 0) {
$row_capital = $res_capital->fetchRow();
$res = query(
'SELECT COUNT(hird_id) AS szam FROM hirdeto_cim WHERE hird_id IN (' . implode(
',',
$a_aktivHirdetok
) . ') AND level_' . $row_capital['level'] . '_id = ' . $row_capital['level_id']
);
if ($res->numRows() > 0) // fovaros
{
$row = $res->fetchRow();
$a_hirdetoszamok[$fokat][$nem_key]['fovaros']['szam'] = $row['szam'];
$a_hirdetoszamok[$fokat][$nem_key]['fovaros']['nev'] = getOne(
'SELECT name FROM address_level_' . $row_capital['level'] . ' WHERE id = '
. $row_capital['level_id']
);
} else {
$a_hirdetoszamok[$fokat][$nem_key]['fovaros']['szam'] = 0; //notice miatt kell
$a_hirdetoszamok[$fokat][$nem_key]['fovaros']['nev'] = '';
}
$res = query(
'SELECT COUNT(hird_id) AS szam FROM hirdeto_cim WHERE hird_id IN (' . implode(
',',
$a_aktivHirdetok
) . ') AND level_' . $row_capital['level'] . '_id != ' . $row_capital['level_id']
);
if ($res->numRows() > 0) // videk
{
$row = $res->fetchRow();
$a_hirdetoszamok[$fokat][$nem_key]['videk']['szam'] = $row['szam'];
$a_hirdetoszamok[$fokat][$nem_key]['videk']['nev'] = '';
} else {
$a_hirdetoszamok[$fokat][$nem_key]['videk']['szam'] = 0; //notice miatt kell
$a_hirdetoszamok[$fokat][$nem_key]['videk']['nev'] = '';
}
} else {
$a_hirdetoszamok[$fokat][$nem_key]['fovaros']['szam'] = count($a_aktivHirdetok);
$a_hirdetoszamok[$fokat][$nem_key]['fovaros']['nev'] = '';
$a_hirdetoszamok[$fokat][$nem_key]['videk']['szam'] = count($a_aktivHirdetok);
$a_hirdetoszamok[$fokat][$nem_key]['videk']['nev'] = '';
}
/////////////////////////////////////////////////////////////////////////
$res = query(
'SELECT level_1_id, COUNT(hird_id) AS szam FROM hirdeto_cim WHERE hird_id IN (' . implode(
',',
$a_aktivHirdetok
) . ') AND level_1_id > 0 GROUP BY level_1_id'
);
while (
$row = $res->fetchRow()
) {
$a_hirdetoszamok[$fokat][$nem_key][$row['level_1_id']]['szam'] = $row['szam'];
$a_cim_id[] = $row['level_1_id'];
}
//hibakiir($a_cim_id);
if (is_array($a_cim_id) && !empty($a_cim_id)) {
$res = query(
'SELECT id, name FROM address_level_1 WHERE id IN (' . implode(',', $a_cim_id) . ')'
);
while (
$row = $res->fetchRow()
) {
$a_hirdetoszamok[$fokat][$nem_key][$row['id']]['nev'] = $row['name'];
}
}
//$cache->set('hirdetoszamok_level_' . $i_level, $a_hirdetoszamok);
} else {
$a_hirdetoszamok[$fokat][$nem_key]['fovaros']['szam'] = 0; //notice miatt kell
$a_hirdetoszamok[$fokat][$nem_key]['videk']['szam'] = 0; //notice miatt kell
}
}
}
$cache->set('hirdetoszamok_level_' . $i_level, $a_hirdetoszamok, 'hirdeto_szamok');
}
return $a_hirdetoszamok;
}
/**
* HirdetoSzamokUj()
*
* @param bool $i_country_id_plus
* @param bool $terkep
* @return
*/
function HirdetoSzamokUj($i_country_id_plus = false, $terkep = false)
{
global $alap, $cache, $country_id, $user;
// fokat, neme, level_1_id
$s_cacheKey = 'hirdetoszamok_uj3';
if (is_numeric($i_country_id_plus)) {
$s_cacheKey .= '_' . $i_country_id_plus;
}
if ($terkep != false) {
$s_cacheKey .= '_' . $terkep;
}
if (
(
$szamok = $cache->get($s_cacheKey, 'hirdeto_szamok')) === false
)
//if ( 1 == 1 )
{
$szamok = array();
$s_whereCountryId = WhereCountryId($country_id);
if (is_numeric($i_country_id_plus)) {
$s_whereCountryId = WhereCountryId($i_country_id_plus);
}
$res = query(
"SELECT COUNT(id) AS szam,sum(if(neme=0 and level_1_id = 1 and fokat=1,1,0)) as 'no-bp-1',sum(if(neme=1 and level_1_id=1 and fokat=1,1,0)) as 'ferfi-bp-1',sum(if(neme=2 and level_1_id=1 and fokat=1,1,0)) as 'travi-bp-1',sum(if(neme=0 and level_1_id!=1 and fokat=1,1,0)) as 'no-v-1',sum(if(neme=1 and level_1_id!=1 and fokat=1,1,0)) as 'ferfi-v-1',sum(if(neme=2 and level_1_id!=1 and fokat=1,1,0)) as 'travi-v-1', sum(if(neme=0 and level_1_id = 1 and fokat=2,1,0)) as 'no-bp-2',sum(if(neme=1 and level_1_id=1 and fokat=2,1,0)) as 'ferfi-bp-2',sum(if(neme=2 and level_1_id=1 and fokat=2,1,0)) as 'travi-bp-2',sum(if(neme=0 and level_1_id!=1 and fokat=2,1,0)) as 'no-v-2',sum(if(neme=1 and level_1_id!=1 and fokat=2,1,0)) as 'ferfi-v-2',sum(if(neme=2 and level_1_id!=1 and fokat=2,1,0)) as 'travi-v-2' FROM hirdeto left join hirdeto_cim on hirdeto_cim.hird_id=hirdeto.id WHERE nagyveg >= NOW() AND hirdeto.country_id"
. $s_whereCountryId . ($terkep != false ? ' and terkep=' . intval($terkep) : '')
);
$row = $res->fetchRow();
$res = query(
"select
sum(if(level_1_id = 1 and fokat=1,1,0)) as 'bp-1',
sum(if(level_1_id!= 1 and fokat=1,1,0)) as 'v-1',
sum(if(level_1_id = 1 and fokat=2,1,0)) as 'bp-2',
sum(if(level_1_id!= 1 and fokat=2,1,0)) as 'v-2'
from
(select h.id,fokat,level_1_id
FROM hirdeto h left join hirdeto_rel hr on ((h.id=hr.hird_id_1 ) or (h.id=hr.hird_id_2))
and hr.veg>now() and hr.status=1 and hr.van_kep=1,hirdeto_cim WHERE h.id = hirdeto_cim.hird_id and h.nagyveg >= now()
and hr.hird_id_1 is not null group by ifnull(hr.id,h.id),fokat ) hc"
);
$row2 = $res->fetchRow();
$szamok[0]['no'][''] = $row['no-bp-1'] + $row['no-bp-2'] + $row['no-v-1'] + $row['no-v-2'];
$szamok[0]['ferfi'][''] = $row['ferfi-bp-1'] + $row['ferfi-bp-2'] + $row['ferfi-v-1'] + $row['ferfi-v-2'];
$szamok[0]['travi'][''] = $row['travi-bp-1'] + $row['travi-bp-2'] + $row['travi-v-1'] + $row['travi-v-2'];
$szamok[0]['par'][''] = $row2['bp-1'] + $row2['bp-2'] + $row2['v-1'] + $row2['v-2'];
$szamok[0]['no']['fovaros'] = $row['no-bp-1'] + $row['no-bp-2'];
$szamok[0]['ferfi']['fovaros'] = $row['ferfi-bp-1'] + $row['ferfi-bp-2'];
$szamok[0]['travi']['fovaros'] = $row['travi-bp-1'] + $row['travi-bp-2'];
$szamok[0]['par']['fovaros'] = $row2['bp-1'] + $row2['bp-2'];
$szamok[0]['no']['videk'] = $row['no-v-1'] + $row['no-v-2'];
$szamok[0]['ferfi']['videk'] = $row['ferfi-v-1'] + $row['ferfi-v-2'];
$szamok[0]['travi']['videk'] = $row['travi-v-1'] + $row['travi-v-2'];
$szamok[0]['par']['videk'] = $row2['v-1'] + $row2['v-2'];
$szamok[1]['no'][''] = $row['no-bp-1'] + $row['no-v-1'];
$szamok[1]['ferfi'][''] = $row['ferfi-bp-1'] + $row['ferfi-v-1'];
$szamok[1]['travi'][''] = $row['travi-bp-1'] + $row['travi-v-1'];
$szamok[1]['par'][''] = $row2['bp-1'] + $row2['v-1'];
$szamok[1]['no']['fovaros'] = $row['no-bp-1'];
$szamok[1]['ferfi']['fovaros'] = $row['ferfi-bp-1'];
$szamok[1]['travi']['fovaros'] = $row['travi-bp-1'];
$szamok[1]['par']['fovaros'] = $row2['bp-1'];
$szamok[1]['no']['videk'] = $row['no-v-1'];
$szamok[1]['ferfi']['videk'] = $row['ferfi-v-1'];
$szamok[1]['travi']['videk'] = $row['travi-v-1'];
$szamok[1]['par']['videk'] = $row2['v-1'];
$szamok[2]['no'][''] = $row['no-bp-2'] + $row['no-v-2'];
$szamok[2]['ferfi'][''] = $row['ferfi-bp-2'] + $row['ferfi-v-2'];
$szamok[2]['travi'][''] = $row['travi-bp-2'] + $row['travi-v-2'];
$szamok[2]['par'][''] = $row2['bp-2'] + $row2['v-2'];
$szamok[2]['no']['fovaros'] = $row['no-bp-2'];
$szamok[2]['ferfi']['fovaros'] = $row['ferfi-bp-2'];
$szamok[2]['travi']['fovaros'] = $row['travi-bp-2'];
$szamok[2]['par']['fovaros'] = $row2['bp-2'];
$szamok[2]['no']['videk'] = $row['no-v-2'];
$szamok[2]['ferfi']['videk'] = $row['ferfi-v-2'];
$szamok[2]['travi']['videk'] = $row['travi-v-2'];
$szamok[2]['par']['videk'] = $row2['v-2'];
$cache->set($s_cacheKey, $szamok, 'hirdeto_szamok', 600);
}
return $szamok;
}
/**
* HirdetoSzamokCallgirl()
*
* @param bool $i_country_id_plus
* @return
*/
function HirdetoSzamokCallgirl($i_country_id_plus = false)
{
global $alap, $cache, $country_id;
// fokat, neme, level_1_id
$s_cacheKey = 'hirdetoszamok_uj_callgirl';
if (is_numeric($i_country_id_plus)) {
$s_cacheKey .= '_' . $i_country_id_plus;
}
if (
(
$szamok = $cache->get($s_cacheKey, 'hirdeto_szamok')) === false
)
//if ( 1 == 1 )
{
$szamok = array();
$s_whereCountryId = WhereCountryId($country_id);
if (is_numeric($i_country_id_plus)) {
$s_whereCountryId = WhereCountryId($i_country_id_plus);
}
$szamok[0]['no'][''] = getOne(
'SELECT COUNT(hird_id) AS szam FROM mv_hirdeto WHERE country_id ' . $s_whereCountryId . ' AND neme = 0 '
);
$szamok[0]['ferfi'][''] = getOne(
'SELECT COUNT(hird_id) AS szam FROM mv_hirdeto WHERE country_id ' . $s_whereCountryId . ' AND neme = 1 '
);
$szamok[0]['travi'][''] = getOne(
'SELECT COUNT(hird_id) AS szam FROM mv_hirdeto WHERE country_id ' . $s_whereCountryId . ' AND neme = 2 '
);
$szamok[0]['par'][''] = getOne(
'SELECT COUNT(id) AS szam FROM hirdeto_rel WHERE van_kep = 1 AND veg >= NOW() AND `status` = 1'
);
$szamok[1]['no'][''] = getOne(
'SELECT COUNT(hird_id) AS szam FROM mv_hirdeto WHERE country_id ' . $s_whereCountryId
. ' AND neme = 0 AND fokat = 1'
);
$szamok[1]['ferfi'][''] = getOne(
'SELECT COUNT(hird_id) AS szam FROM mv_hirdeto WHERE country_id ' . $s_whereCountryId
. ' AND neme = 1 AND fokat = 1'
);
$szamok[1]['travi'][''] = getOne(
'SELECT COUNT(hird_id) AS szam FROM mv_hirdeto WHERE country_id ' . $s_whereCountryId
. ' AND neme = 2 AND fokat = 1'
);
$szamok[1]['par'][''] = getOne(
'SELECT COUNT(id) AS szam FROM hirdeto_rel WHERE van_kep = 1 AND veg >= NOW() AND `status` = 1 AND ( hird_id_1 IN ( SELECT id FROM hirdeto WHERE fokat = 1 AND country_id '
. $s_whereCountryId . ' ) OR hird_id_2 IN ( SELECT id FROM hirdeto WHERE fokat = 1 AND country_id '
. $s_whereCountryId . ' ) )'
);
$szamok[2]['no'][''] = getOne(
'SELECT COUNT(hird_id) AS szam FROM mv_hirdeto WHERE country_id ' . $s_whereCountryId
. ' AND neme = 0 AND fokat = 2'
);
$szamok[2]['ferfi'][''] = getOne(
'SELECT COUNT(hird_id) AS szam FROM mv_hirdeto WHERE country_id ' . $s_whereCountryId
. ' AND neme = 1 AND fokat = 2'
);
$szamok[2]['travi'][''] = getOne(
'SELECT COUNT(hird_id) AS szam FROM mv_hirdeto WHERE country_id ' . $s_whereCountryId
. ' AND neme = 2 AND fokat = 2'
);
$szamok[2]['par'][''] = getOne(
'SELECT COUNT(id) AS szam FROM hirdeto_rel WHERE van_kep = 1 AND veg >= NOW() AND `status` = 1 AND ( hird_id_1 IN ( SELECT id FROM hirdeto WHERE fokat = 2 AND country_id '
. $s_whereCountryId . ' ) OR hird_id_2 IN ( SELECT id FROM hirdeto WHERE fokat = 2 AND country_id '
. $s_whereCountryId . ' ) )'
);
$a_parosidk = array();
$i_cnt = 0;
$sql = 'SELECT hird_id_1, hird_id_2 FROM hirdeto_rel WHERE van_kep = 1 AND veg >= NOW() AND `status` = 1';
$res = query($sql);
if ($res->numRows() > 0) {
while (
$row = $res->fetchRow()
) {
if (
!in_array($row['hird_id_1'] . ';' . $row['hird_id_2'], $a_parosidk)
&& !in_array(
$row['hird_id_2'] . ';' . $row['hird_id_1'],
$a_parosidk
)
) {
$a_parosidk[] = $row['hird_id_1'] . ';' . $row['hird_id_2'];
$i_cnt++;
}
}
}
$szamok[0]['par'][''] = $i_cnt;
$cache->set($s_cacheKey, $szamok, 'hirdeto_szamok', 900);
}
return $szamok;
}
/**
* HirdetoSzamok2()
*
* @param integer $i_level
* @return
*/
function HirdetoSzamok2($i_level = 1)
{
global $alap, $cache, $country_id, $user;
$s_level = 'level_' . $i_level;
if (
(
$a_hirdetoszamok = $cache->get('hirdetoszamok_level_' . $i_level)) === false /*or $user->id == 66640*/
)
//if ( 1 == 1 )
{
$a_hirdetoszamok = array();
for (
$fokat = 0;
$fokat <= 2;
$fokat++
) {
$a_aktivHirdetok = array();
//$res = query('SELECT id FROM hirdeto WHERE veg >= NOW() AND country_id = ' . $country_id . ( $fokat > 0 ? ' AND fokat = ' . $fokat : '' ));
$res = query(
'SELECT id FROM hirdeto WHERE nagyveg >= NOW() AND country_id = ' . $country_id . ($fokat > 0
? ' AND fokat = ' . $fokat : '')
);
while (
$row = $res->fetchRow()
) {
$a_aktivHirdetok[] = $row['id'];
}
if (!empty($a_aktivHirdetok)) {
$a_cim_id = array();
$res = query(
'SELECT ' . $s_level . '_id, COUNT(hird_id) AS szam FROM hirdeto_cim WHERE hird_id IN ('
. implode(',', $a_aktivHirdetok) . ') AND ' . $s_level . '_id > 0 GROUP BY ' . $s_level . '_id'
);
while (
$row = $res->fetchRow()
) {
$a_hirdetoszamok[$fokat][$row[$s_level . '_id']]['szam'] = $row['szam'];
$a_cim_id[] = $row[$s_level . '_id'];
}
//hibakiir($a_cim_id);
if (is_array($a_cim_id) && !empty($a_cim_id)) {
$res = query(
'SELECT id, name, sort FROM address_' . $s_level . ' WHERE id IN (' . implode(
',',
$a_cim_id
) . ')'
);
while (
$row = $res->fetchRow()
) {
$a_hirdetoszamok[$fokat][$row['id']]['nev'] = $row['name'];
$a_hirdetoszamok[$fokat][$row['id']]['sort'] = $row['sort'];
}
}
$cache->set('hirdetoszamok_level_' . $i_level, $a_hirdetoszamok);
}
}
}
return $a_hirdetoszamok;
}
/**
* HirdetoSzamok3()
*
* @param integer $i_level
* @param integer $i_neme
* @param bool $keresohoz
* @return
*/
function HirdetoSzamok3($i_level = 1, $i_neme = 0, $keresohoz = false)
{
global $alap, $cache, $country_id, $lap, $user;
$a_nemek = array(
0 => 'Nő',
1 => 'Férfi',
2 => 'Travi',
3 => 'Összes',
99 => 'Páros'
);
if (array_key_exists($i_neme, $a_nemek)) {
$s_level = 'level_' . $i_level;
$s_cacheKey = 'hirdetoszamok_level_' . $i_level . '_' . $i_neme;
if ($lap == 'kereso_vtr') {
$s_cacheKey .= '_vtr';
}
if ($keresohoz === true) {
$s_cacheKey .= '_kereso';
} else if ($lap == 'hirdetesek_listaja') {
$s_cacheKey .= '_hirdi_lista';
}
if (
(
$a_hirdetoszamok = $cache->get($s_cacheKey)) === false /*or $user->id == 66640*/
) {
$a_hirdetoszamok = array();
if ($lap == 'hirdetesek_listaja') {
$sql_neme = '';
} else {
switch ($i_neme) {
case 3:
$sql_neme = '';
break; //összes
//case 99 : $sql_neme = ' AND ( id IN (SELECT hird_id_1 FROM hirdeto_rel WHERE `status` = 1 AND veg >= NOW()) OR id IN (SELECT hird_id_2 FROM hirdeto_rel WHERE `status` = 1 AND veg >= NOW()) ) '; break; //páros
case 99: // páros
{
if ($keresohoz === true) {
// a keresővel szinkronban működő valós páros hirdetések számához való lekérdezés (dzsozi @ 160223)
$sql_neme
= ' AND ( id IN (SELECT hird_id_1 FROM hirdeto_rel WHERE `status` = 1 AND van_kep = 1 AND veg >= NOW() AND kinel_fogadnak IN (1,3)) OR id IN (SELECT hird_id_2 FROM hirdeto_rel WHERE `status` = 1 AND van_kep = 1 AND veg >= NOW() AND kinel_fogadnak IN (2,3)) ) ';
} else {
$sql_neme
= ' AND ( id IN (SELECT hird_id_1 FROM hirdeto_rel WHERE `status` = 1 AND veg >= NOW()) OR id IN (SELECT hird_id_2 FROM hirdeto_rel WHERE `status` = 1 AND veg >= NOW()) ) ';
}
}
break;
default:
$sql_neme = ' AND neme = ' . $i_neme; //nő, férfi, travi
}
}
for (
$fokat = 0;
$fokat <= 3;
$fokat++
) {
$a_aktivHirdetok = array();
/*
if ($lap == 'hirdetesek_listaja')
{
$res = query('SELECT id FROM hirdeto WHERE country_id = ' . $country_id . ( $fokat > 0 ? ' AND fokat = ' . $fokat : '' ) . $sql_neme );
}
else
{
$res = query('SELECT id FROM hirdeto WHERE nagyveg >= NOW() AND country_id = ' . $country_id . ( $fokat > 0 ? ' AND fokat = ' . $fokat : '' ) . $sql_neme );
}
*/
switch ($lap) {
case 'hirdetesek_listaja':
$res = query(
'SELECT id FROM hirdeto WHERE country_id = ' . $country_id . ($fokat > 0
? ' AND fokat = ' . $fokat : '') . $sql_neme
);
break;
case 'kereso_vtr':
$res = query(
'SELECT hirdeto.id FROM hirdeto, hirdeto_altalanos WHERE hirdeto.country_id = '
. $country_id . ($fokat > 0 ? ' AND hirdeto.fokat = ' . $fokat : '') . $sql_neme
. ' AND hirdeto.nagyveg >= NOW() AND hirdeto_altalanos.vtr_ajanlastol > -1 AND hirdeto.id = hirdeto_altalanos.hird_id'
);
break;
default:
$res = query(
'SELECT id FROM hi catch (Exception $e) {
if ($resend_counter < 2) {
return parse_website($url, $fbimg, ++$resend_counter);
}
return '';
}
// --- META KINYERÉS ---
$title = '';
$description = '';
$img = '';
// TITLE
if (preg_match('/
';
}
if ($title !== '') {
$ret .= '' . htmlspecialchars($title, ENT_QUOTES, 'UTF-8') . '
';
}
if ($description !== '') {
$ret .= htmlspecialchars($description, ENT_QUOTES, 'UTF-8') . '
';
}
if ($domain !== '') {
$ret .= '
' .
htmlspecialchars($domain, ENT_QUOTES, 'UTF-8') . '
';
}
return $ret;
}
/**
* onlineHirdetok()
*
* @param integer $a
* @return
*/
function onlineHirdetok($a = 0)
{
global $alap, $a_onlineHirdetok, $cache;
/* if (is_array($a_onlineHirdetok))
{
return $a_onlineHirdetok;
}
if ($a == 0)
{
error_log("Nincs meg az online hirdetok tomb!!! - " . serialize($a_onlineHirdetok));
}
$s_cacheKey = 'hirdetok';
$s_cacheGroup = 'online';
$a_ret = $cache->get($s_cacheKey, $s_cacheGroup);
if ($a_ret === false)
{*/
$a_ret = array();
$sql = "SELECT DISTINCT hirdeto.id
FROM hirdeto, online_hirdeto
WHERE hirdeto.aktiv=1
AND (
(hirdeto.user_id = online_hirdeto.user_id) OR
(hirdeto.com_user_id = online_hirdeto.user_id)
)";
$res = query($sql);
while (
$row = $res->fetchRow()
) {
$a_ret[] = $row['id'];
}
// $cache->set($s_cacheKey, $a_ret, $s_cacheGroup, 300);
//}
return $a_ret;
}
/**
* onlineFelhasznalok()
*
* @param integer $a
* @return
*/
function onlineFelhasznalok($a = 0)
{
global $alap, $a_onlineFelhasznalok, $cache;
/* if (is_array($a_onlineFelhasznalok))
{
return $a_onlineFelhasznalok;
}
if ($a == 0)
{
error_log("Nincs meg az online felhasznalok tomb!!! " . $a . " - " . serialize($a_onlineFelhasznalok));
}
$s_cacheKey = 'felhasznalok';
$s_cacheGroup = 'online';
$a_ret = $cache->get($s_cacheKey, $s_cacheGroup);
if ($a_ret === false)
{*/
$a_ret = array();
$sql = "SELECT DISTINCT user_id
FROM online
WHERE user_id > 0";
$res = query($sql);
while (
$row = $res->fetchRow()
) {
$a_ret[] = $row['user_id'];
}
// $cache->set($s_cacheKey, $a_ret, $s_cacheGroup, 300);
// }
return $a_ret;
}
/**
* cache_onlineFelhasznalok()
*
* @return
*/
function cache_onlineFelhasznalok()
{
global $cache;
$a_ret = array();
$sql = "SELECT DISTINCT user_id FROM online WHERE user_id > 0";
$res = query($sql);
while (
$row = $res->fetchRow()
) {
$a_ret[] = $row['user_id'];
}
$cache->set('felhasznalok', $a_ret, 'online', 300);
}
/**
* cache_onlineHirdetok()
*
* @return
*/
function cache_onlineHirdetok()
{
global $cache;
$a_ret = array();
$sql = "SELECT DISTINCT hirdeto.id
FROM hirdeto, online_hirdeto
WHERE hirdeto.nagyveg >= NOW()
AND (
(hirdeto.com_user_id = 0 AND hirdeto.user_id = online_hirdeto.user_id) OR
(hirdeto.com_user_id > 0 AND hirdeto.com_user_id = online_hirdeto.user_id)
)";
$res = query($sql);
while (
$row = $res->fetchRow()
) {
$a_ret[] = $row['id'];
}
$cache->set('hirdetok', $a_ret, 'online', 300);
}
/**
* hirdeto_dir()
*
* @param mixed $hird_id
* @return
*/
function hirdeto_dir($hird_id)
{
return floor($hird_id / 1000) . "000";
}
/**
* mostHivhatoHirdetok()
*
* @param integer $a
* @return
*/
function mostHivhatoHirdetok($a = 0)
{
global $alap, $a_mostHivhatoHirdetok, $cache;
if (is_array($a_mostHivhatoHirdetok)) {
return $a_mostHivhatoHirdetok;
}
if ($a == 0) {
error_log("Nincs meg a most hivhato hirdetok tomb!!! - " . serialize($a_mostHivhatoHirdetok));
}
$s_cacheKey = 'mostHivhatoHirdetok';
$s_cacheGroup = 'hirdetok';
$a_ret = $cache->get($s_cacheKey, $s_cacheGroup);
if ($a_ret === false) {
$a_ret = array();
$now = date("Y-m-d H:i:00");
/*
$sql = "SELECT id
FROM hirdeto
WHERE nagyveg >= '".$now."'
AND (
id IN (SELECT hird_id FROM hirdeto_altalanos WHERE lehet_hivni_most = 1 AND lehet_hivni_most_datum >= '".$now."') OR
id IN (SELECT hird_id FROM hirdeto_hivhato_ma WHERE (tol_1_ido <= '".date("H:i:00")."' AND ig_1_ido >= '".date("H:i:00")."') OR (tol_2_ido <= '".date("H:i:00")."' AND ig_2_ido >= '".date("H:i:00")."'))
)";
*/
/*
"László: a now az kicsit keves baszod 1. ird at a lekerdezes tpobbi reszet is 5 percre + adjal neki cachet" - 10:02 2015.04.07.
*/
$sql = "SELECT id
FROM hirdeto
WHERE aktiv=1
AND (
id IN (SELECT hird_id FROM hirdeto_altalanos WHERE lehet_hivni_most = 1 AND lehet_hivni_most_datum >= '"
. $now . "') OR
id IN (SELECT hird_id FROM hirdeto_hivhato_ma WHERE (tol_1_ido <= '" . date("H:i:00")
. "' AND ig_1_ido >= '" . date("H:i:00") . "') OR (tol_2_ido <= '" . date("H:i:00")
. "' AND ig_2_ido >= '" . date("H:i:00") . "'))
)";
$res = query($sql);
while (
$row = $res->fetchRow()
) {
$a_ret[] = $row['id'];
}
$cache->set($s_cacheKey, $a_ret, $s_cacheGroup, 300);
}
return $a_ret;
}
/**
* mostSzabadHirdetok()
*
* @param integer $a
* @return
*/
function mostSzabadHirdetok($a = 0)
{
global $alap, $a_mostSzabadHirdetok;
if (is_array($a_mostSzabadHirdetok)) {
return $a_mostSzabadHirdetok;
}
if ($a == 0) {
error_log("Nincs meg a most szabad hirdetok tomb!!! - " . serialize($a_mostSzabadHirdetok));
}
$a_ret = array();
$sql = "SELECT DISTINCT hird_id
FROM hirdeto_calendar
WHERE `start` <= NOW()
AND `end` >= NOW()";
$res = query($sql);
while (
$row = $res->fetchRow()
) {
$a_ret[] = $row['hird_id'];
}
return $a_ret;
}
/**
* RanghozBeszi()
*
* @param mixed $rang
* @return
*/
function RanghozBeszi($rang)
{
$re = 1;
switch ($rang) {
case 103:
$re = 2;
break;
case 104:
$re = 3;
break;
case 105:
$re = 4;
break;
case 106:
$re = 5;
break;
case 107:
$re = 6;
break;
case 108:
$re = 7;
break;
case 109:
$re = 8;
break;
case 110:
$re = 9;
break;
case 111:
$re = 10;
break;
case 112:
$re = 11;
break;
case 113:
$re = 12;
break;
case 114:
$re = 13;
break;
case 115:
$re = 14;
break;
case 116:
$re = 15;
break;
case 117:
$re = 16;
break;
case 118:
$re = 17;
break;
case 119:
$re = 18;
break;
case 120:
$re = 19;
break;
case 121:
$re = 20;
break;
}
return $re;
}
/**
* validateDate()
*
* @param mixed $date
* @param string $format
* @return
*/
function validateDate($date, $format = 'Y-m-d')
{
$d = DateTime::createFromFormat($format, $date);
return $d && $d->format($format) == $date;
}
/**
* OnlyAlphaNum()
*
* @param mixed $str
* @param bool $lc
* @return
*/
function OnlyAlphaNum($str, $lc = true) // csak az angol abc betűit és a számokat adja vissza a stringből (dzsozi @ 160414)
{
$str = str_replace('ö', 'o', $str);
$str = str_replace('Ö', 'o', $str);
$str = str_replace('ü', 'u', $str);
$str = str_replace('Ü', 'u', $str);
$str = str_replace('ó', 'o', $str);
$str = str_replace('Ó', 'o', $str);
$str = str_replace('ő', 'o', $str);
$str = str_replace('Ő', 'o', $str);
$str = str_replace('ú', 'u', $str);
$str = str_replace('Ú', 'u', $str);
$str = str_replace('é', 'e', $str);
$str = str_replace('É', 'e', $str);
$str = str_replace('á', 'a', $str);
$str = str_replace('Á', 'a', $str);
$str = str_replace('ű', 'u', $str);
$str = str_replace('Ű', 'u', $str);
$str = str_replace('í', 'i', $str);
$str = str_replace('Í', 'i', $str);
$str = preg_replace_callback('([^A-Za-z0-9-]+)', function () {
return '';
}, $str);
if ($lc === true) {
$str = strtolower($str);
}
return $str;
}
/**
* replaceKerulet()
*
* @param mixed $str
* @return
*/
function replaceKerulet($str) // római kerület számok konvertálása (dzsozi @ 160414)
{
$str = str_replace('XXIII.', '23.', $str);
$str = str_replace('XXII.', '22.', $str);
$str = str_replace('XXI.', '21.', $str);
$str = str_replace('XX.', '20.', $str);
$str = str_replace('XIX.', '19.', $str);
$str = str_replace('XVIII.', '18.', $str);
$str = str_replace('XVII.', '17.', $str);
$str = str_replace('XVI.', '16.', $str);
$str = str_replace('XV.', '15.', $str);
$str = str_replace('XIV.', '14.', $str);
$str = str_replace('XIII.', '13.', $str);
$str = str_replace('XII.', '12.', $str);
$str = str_replace('XI.', '11.', $str);
$str = str_replace('IX.', '9.', $str);
$str = str_replace('X.', '10.', $str);
$str = str_replace('VIII.', '8.', $str);
$str = str_replace('VII.', '7.', $str);
$str = str_replace('VI.', '6.', $str);
$str = str_replace('IV.', '4.', $str);
$str = str_replace('V.', '5.', $str);
$str = str_replace('III.', '3.', $str);
$str = str_replace('II.', '2.', $str);
$str = str_replace('I.', '1.', $str);
return $str;
}
/**
* TelepulesTomb()
*
* @param integer $cid
* @param bool $besz
* @return
*/
function TelepulesTomb($cid = 1, $besz = false) // település tömb subdomain kezeléshez (dzsozi @ 160414)
{
global $alap;
$ret = array();
$cid = intval($cid);
if ($cid < 0)
$cid = 0;
$sql = "SELECT id, name FROM address_level_2
WHERE id IN (SELECT DISTINCT level_2_id FROM " . ($besz == false ? "hirdeto_cim" : "besz_cim") . ")
" . ($cid > 0 ? " AND parent_id IN (SELECT id FROM address_level_1 WHERE parent_id = " . $cid . ")"
: "");
$res = query($sql);
while (
$row = $res->fetchRow()
) {
$index = OnlyAlphaNum(replaceKerulet($row['name']));
$ret[$index] = array(
'id' => $row['id'],
'name' => $row['name'],
);
}
return $ret;
}
/**
* MegyeTomb()
*
* @param integer $cid
* @param bool $besz
* @return
*/
function MegyeTomb($cid = 1, $besz = false) // megye tömb subdomain kezeléshez (dzsozi @ 160419)
{
global $alap;
$ret = array();
$cid = intval($cid);
if ($cid < 0)
$cid = 0;
$sql = "SELECT id, name FROM address_level_1
WHERE id IN (SELECT DISTINCT level_1_id FROM " . ($besz == false ? "hirdeto_cim" : "besz_cim") . ")
" . ($cid > 0 ? " AND parent_id = " . $cid : "");
$res = query($sql);
while (
$row = $res->fetchRow()
) {
$index = OnlyAlphaNum($row['name']);
$ret[$index] = array(
'id' => $row['id'],
'name' => $row['name'],
);
}
return $ret;
}
/**
* img_list_item()
*
* @param mixed $row
* @return
*/
function img_list_item($row)
{
global $more_kiiras, $i_kepmode, $uj_kepek_listaja, $lany, $user;
$size = mt_rand(100, 160);
// https://beszamolok.com/szexpartner_kep.php?adat=Sindy+szexpartner+hirdet%C5%91+Budapest%2C+XIII.+ker%C3%BClet&lid=199424&kepszam=8951649
if (($row['is_video'] == 1 && $lany['premium_szint'] < 3)) {
} else {
$kiiras .= '';
// if($user->id==4)print_r($uj_kepek_listaja);
$rowindex = $row['kepszam'] . '.webp';
if ($uj_kepek_listaja[$rowindex] == 1) {
$van_uj_kepe = 1;
$kiiras .= '';
//print_r($row);
//if(isset($more_kiiras)&&$more_kiiras!=''){$kiiras.=$more_kiiras;}
$kiiras .= '';
}
return $kiiras;
}
function img_list_item_laci($row, $arckep = 0)
{
global $more_kiiras, $i_kepmode, $uj_kepek_listaja, $lany, $user;
if ($lany['kezdokep'] == $row['kepszam']) {
if (
!is_file('/home/beszamolok/public_html/kepek/hirdeto/' . hirdeto_dir($lany['id']) . '/' . $lany['id'] . '/' . $row['kepszam'] . '_175x175.webp')
or
!is_file('/home/beszamolok/public_html/kepek/hirdeto/' . hirdeto_dir($lany['id']) . '/' . $lany['id']
. '/' . $row['kepszam'] . '_245x245.webp')
or
!is_file('/home/beszamolok/public_html/kepek/hirdeto/' . hirdeto_dir($lany['id']) . '/' . $lany['id'] . '/' . $row['kepszam'] . '_120x120.webp')
) {
if (is_file('/home/beszamolok/public_html' . $row['tn'] . '_800x800.webp')) {
thumbkeszito(
'/home/beszamolok/public_html' . $row['tn'] . '_800x800.webp',
'/home/beszamolok/public_html/kepek/hirdeto/' . hirdeto_dir($lany['id']) . '/' . $lany['id']
. '/' . $row['kepszam'] . '_175x175.webp',
175,
175
);
thumbkeszito(
'/home/beszamolok/public_html' . $row['tn'] . '_800x800.webp',
'/home/beszamolok/public_html/kepek/hirdeto/' . hirdeto_dir($lany['id']) . '/' . $lany['id']
. '/' . $row['kepszam'] . '_120x120.webp',
120,
120
);
thumbkeszito(
'/home/beszamolok/public_html' . $row['tn'] . '_800x800.webp',
'/home/beszamolok/public_html/kepek/hirdeto/' . hirdeto_dir($lany['id']) . '/' . $lany['id']
. '/' . $row['kepszam'] . '_145x145.webp',
245,
245
);
} else {
if (is_file('/home/beszamolok/public_html' . $row['tn'] . '_245x245.webp')) {
thumbkeszito(
'/home/beszamolok/public_html' . $row['tn'] . '_245x245.webp',
'/home/beszamolok/public_html/kepek/hirdeto/' . hirdeto_dir($lany['id']) . '/' . $lany['id']
. '/' . $row['kepszam'] . '_175x175.webp',
175,
175
);
thumbkeszito(
'/home/beszamolok/public_html' . $row['tn'] . '_245x245.webp',
'/home/beszamolok/public_html/kepek/hirdeto/' . hirdeto_dir($lany['id']) . '/' . $lany['id']
. '/' . $row['kepszam'] . '_120x120.webp',
120,
120
);
thumbkeszito(
'/home/beszamolok/public_html' . $row['tn'] . '_245x245.webp',
'/home/beszamolok/public_html/kepek/hirdeto/' . hirdeto_dir($lany['id']) . '/' . $lany['id']
. '/' . $row['kepszam'] . '_145x145.webp',
245,
245
);
}
}
}
}
$kiiras = '';
// https://beszamolok.com/szexpartner_kep.php?adat=Sindy+szexpartner+hirdet%C5%91+Budapest%2C+XIII.+ker%C3%BClet&lid=199424&kepszam=8951649
if (isset($row['is_video']) && $row['is_video'] == true) {
$kiiras .= '';
$rowindex = $row['kepszam'] . '.webp';
$kiiras .= '
';
if ($row['is_video'] == true) {
$kiiras .= 'VIDEÓ ';
}
$kiiras .= '
';
} else {
$kiiras .= '';
$rowindex = $row['kepszam'] . '.webp';
$row['tn'] = str_replace('.webp', '', $row['full']);
if (!is_file('/home/beszamolok/public_html' . $row['tn'] . '_245x245.webp') or !is_file('/home/beszamolok/public_html' . $row['tn'] . '_105x105.webp') or !is_file('/home/beszamolok/public_html' . $row['tn'] . '_175x175.webp')) {
if (is_file('/home/beszamolok/public_html' . $row['tn'] . '_800x800.webp')) {
thumbkeszito(
'/home/beszamolok/public_html' . $row['tn'] . '_800x800.webp',
'/home/beszamolok/public_html' . $row['tn'] . '_105x105.webp',
105,
105
);
thumbkeszito(
'/home/beszamolok/public_html'
. $row['tn']
. '_800x800.webp',
'/home/beszamolok/public_html'
.
$row['tn']
. '_175x175.webp',
175,
175
);
thumbkeszito(
'/home/beszamolok/public_html'
. $row['tn']
. '_800x800.webp',
'/home/beszamolok/public_html'
.
$row['tn']
. '_150x150.webp',
150,
150
);
thumbkeszito(
'/home/beszamolok/public_html'
. $row['tn']
. '_800x800.webp',
'/home/beszamolok/public_html'
.
$row['tn']
. '_245x245.webp',
245,
245
);
} elseif (is_file('/home/beszamolok/public_html' . $row['tn'] . '.webp')) {
thumbkeszito(
'/home/beszamolok/public_html' . $row['tn'] . '.webp',
'/home/beszamolok/public_html' . $row['tn'] .
'_105x105.webp',
105,
105
);
thumbkeszito(
'/home/beszamolok/public_html' . $row['tn'] . '.webp',
'/home/beszamolok/public_html' . $row['tn'] . '_175x175.webp',
175,
175
);
thumbkeszito(
'/home/beszamolok/public_html' . $row['tn'] . '.webp',
'/home/beszamolok/public_html' . $row['tn'] . '_245x245.webp',
245,
245
);
thumbkeszito(
'/home/beszamolok/public_html' . $row['tn'] . '.webp',
'/home/beszamolok/public_html' . $row['tn'] . '_150x150.webp',
150,
150
);
} elseif (is_file('/home/beszamolok/public_html' . $row['tn'] . '.jpg')) {
thumbkeszito(
'/home/beszamolok/public_html' . $row['tn'] . '.jpg',
'/home/beszamolok/public_html' . $row['tn'] .
'_105x105.webp',
105,
105
);
thumbkeszito(
'/home/beszamolok/public_html'
. $row['tn']
. '.jpg',
'/home/beszamolok/public_html'
.
$row['tn']
. '_175x175.webp',
175,
175
);
thumbkeszito(
'/home/beszamolok/public_html'
. $row['tn']
. '.jpg',
'/home/beszamolok/public_html'
.
$row['tn']
. '_150x150.webp',
150,
150
);
thumbkeszito(
'/home/beszamolok/public_html'
. $row['tn']
. '.jpg',
'/home/beszamolok/public_html'
.
$row['tn']
. '_245x245.webp',
245,
245
);
}
}
if (($arckep == 0 && $row['vip'] == 0)
or ($arckep == 1 && $row['vip'] == 1
&& $user->rang > $lany['arckep']
&& ($user->rang < 144 or $user->rang > 190))
) {
$kiiras .= '![' . strip_tags($row['kepalairas']) . '](' . $row['tn'] . '_105x105.webp)
';
if (isset($uj_kepek_listaja[$rowindex]) && $uj_kepek_listaja[$rowindex] == 1) {
if (is_file('/home/beszamolok/public_html'
. $row['tn']
. '_800x800.webp')) {
$van_uj_kepe = 1;
$kiiras .= 'ÚJ KÉP! ';
} else {
query('delete from hirdeto_uj_kepek where hird_id=' . $lany['id'] . ' and kepnev="'
. $uj_kepek_listaja[$rowindex] . '"');
}
}
//print_r($row);
//if(isset($more_kiiras)&&$more_kiiras!=''){$kiiras.=$more_kiiras;}
}
$kiiras .= '';
}
return $kiiras;
}
function chatuzenet_admintol($kinek, $szoveg, $kepopcio = "")
{
global $alap;
$chatid = '8c' . $kinek;
$bevenev = getOne('select becenev from felhasznalok where id=' . intval($kinek));
if ($szoveg != "") {
$row_user = getRow(
"SELECT felhasznalok.rang,felhasznalok.device_id,felhasznalok.id,felhasznalok.becenev,felhasznalok.email,felhasznalok.lang FROM felhasznalok WHERE id="
. $kinek
);
query(
'INSERT INTO `beszamolok`.`messages_new`
( `datum`, `user1`, `user2`, `kitol`, `kinek`, `szoveg`, `chat_id`)
VALUES(now(),6,' . $kinek . ',6,' . $kinek . ',"Kedves ' . $bevenev . '!
' . addslashes($szoveg) . '
(erre az üzenetre soha ne válaszolj, ez egy automatikus rendszer üzenet, Webmesternek írj, ha kérdés merül fel)","6c'
. $kinek
. '")'
);
/*sendgcm(
$row_user['device_id'], 'A rendszer új üzenetet küldött:
' . $a_values['msg'], 0, 0, 6, $row_user['rang'], $chatid, $kinek
);*/
sendPush($kinek, 'RENDSZERÜZENET', $szoveg, $kepopcio);
}
}
function ekezetlenit($mit)
{
$ekezetes
= array(' ', 'Á', 'É', 'Í', 'Ó', 'Ö', 'Õ', 'Ú', 'Ü', 'Û', 'á', 'é', 'í', 'ó', 'ö', 'õ', 'ú', 'ü', 'û', 'ű', 'Ű ', 'Ő', 'ő', 'lő', 'ű', '+');
$ekezettelen
= array('-', 'a', 'e', 'i', 'o', 'o', 'o', 'u', 'u', 'u', 'a', 'e', 'i', 'o', 'o', 'o', 'u', 'u', 'u', 'u', 'U', 'o', 'o', 'u', '');
return strtolower(str_replace($ekezetes, $ekezettelen, $mit));
}
function discord_push($type, $url, $cim, $szoveg, $kep)
{
if ($type == 1) {
$webhookurl
= "https://discord.com/api/webhooks/762664676517085254/2cfryUcVpzDCUJUI4enn47Uq_zMfPXWNhb2vXNh8A7MS_MZIPFhNH1wC7ZVoU80PaH_4";
$content = "Új hirdető";
}
if ($type == 2) {
$webhookurl
= "https://discord.com/api/webhooks/762664676517085254/2cfryUcVpzDCUJUI4enn47Uq_zMfPXWNhb2vXNh8A7MS_MZIPFhNH1wC7ZVoU80PaH_4";
$content = "Visszatérő hirdető";
}
if ($type == 3) {
$webhookurl
= "https://discordapp.com/api/webhooks/762968911452176384/cOoR79Rwmhhibbg_MJcukLfSMgiU-ajy8ty9CN3qrgvLrV3-P-DGmXOsW71AokaG4JGo";
$content = "Új beszámoló";
}
if ($type == 4) {
$webhookurl
= "https://discordapp.com/api/webhooks/762985987986161664/qF_ITBCgfKgAtAZ5C63Tbjr5GzTzxmuW34GeNyO1fAFaKPqwU3F51QfDj6B4Qc-1GQGh";
$content = "Új hozzászólás csevegéshez";
}
if ($type == 5) {
$webhookurl
= "https://discordapp.com/api/webhooks/762992715851235338/m3sjFeDiUOpaNoegq0fSOpLU6RfxOO6i9-eRhlSh3xKvwZiM1GUljEtlS6Hkbdr_o-Ho";
$content = "Új hozzászólás beszámolóhoz";
}
if ($type == 6) {
$webhookurl
= "https://discordapp.com/api/webhooks/763004074764927016/4wam01rzpSdC247kKPEJBVCvv-7GRnBu5u7XTKf2YTnJzJhWXuctswkxNRghwv6Ke1e9";
$content = "Új hozzászólás fórumhoz";
}
$szoveg = str_replace(
'\n',
'
',
$szoveg
);
//=======================================================================================================
// Compose message. You can use Markdown
// Message Formatting -- https://discordapp.com/developers/docs/reference#message-formatting
//========================================================================================================
$timestamp = date("c", strtotime("now"));
$json_data = json_encode(
[
// Message
"content" => $content,
// Username
"username" => "beszamolok.com",
// Avatar URL.
// Uncoment to replace image set in webhook
//"avatar_url" => "https://ru.gravatar.com/userimage/28503754/1168e2bddca84fec2a63addb348c571d.jpg?size=512",
// Text-to-speech
"tts" => false,
// File upload
// "file" => "",
// Embeds Array
"embeds" => [
[
// Embed Title
"title" => $cim
. '
(kattints ide, ha meg akarod nézni)',
// Embed Type
"type" => "rich",
// Embed Description
"description" => '
' . $szoveg . '
@everyone',
// URL of title link
"url" => $url,
// Timestamp of embed must be formatted as ISO8601
"timestamp" => $timestamp,
// Embed left border color in HEX
"color" => hexdec(
"3366ff"
),
// Footer
"footer" => [
"text" => "beszamolok.com",
"icon_url" => "https://beszamolok.com/images/design/logo_guggolo.jpg"
],
// Image to send
"image" => [
"url" => $kep
],
// Thumbnail
//"thumbnail" => [
// "url" => "https://ru.gravatar.com/userimage/28503754/1168e2bddca84fec2a63addb348c571d.jpg?size=400"
//],
// Author
"author" => [
"name" => "beszamolok",
"url" => "https://beszamolok.com"
],
// Additional Fields array
/* "fields" => [
// Field 1
[
"name" => "
user_rangja:". $user_adat['rang'];'