$('.google-ad-container').click(function (event) {$user_info_get = users::getInfoForUser($crt_usr);
$smarty->var_dump assign("user_info_get", $user_info_get);EXPLAIN SELECT class_ads . * , class_ads.id AS adid, DATE_FORMAT( class_ads.`date_added` , '%d.%m РІ %H:%i' ) AS date_nice, DATE_FORMAT( class_ads.`date_expires` , '%d.%m РІ %H:%i' ) AS date_expires_nice, UNIX_TIMESTAMP( class_ads.`date_added` ) AS `time_added` , (
class_ads.date_expires < '2019-09-03 23:30:04'
AND class_ads.date_expires != '0000-00-00 00:00:00'
AND class_ads.active =0
) AS expired, class_slugs.slug
FROM class_ads
INNER JOIN class_slugs ON class_ads.id = class_slugs.object_id
WHERE class_ads.active LIKE 1
AND class_ads.category_id = '116'
AND class_ads.id != '99178'
AND class_slugs.`type` = 'listing'
LIMIT 52054 , 12(select_type)SIMPLE
(table)class_slugs
(type)ref
(possible_keys)idx_type,idx_object_id
(key)idx_type
(key_len)63
(ref)const
(rows)67741
(Extra)Using index condition; Using whereSIMPLE
class_ads
eq_ref
PRIMARY,idx_category,idx_active,active_2,active_3,...
PRIMARY
4
tix_db.class_slugs.object_id
1
Using whereEXPLAIN SELECT class_ads . * , class_ads.id AS adid, DATE_FORMAT( class_ads.`date_added` , '%d.%m РІ %H:%i' ) AS date_nice, DATE_FORMAT( class_ads.`date_expires` , '%d.%m РІ %H:%i' ) AS date_expires_nice, UNIX_TIMESTAMP( class_ads.`date_added` ) AS `time_added` , (
class_ads.date_expires < '2019-09-03 23:30:04'
AND class_ads.date_expires != '0000-00-00 00:00:00'
AND class_ads.active =0
) AS expired, class_slugs.slug
FROM class_ads
INNER JOIN class_slugs ON class_ads.id = class_slugs.object_id
WHERE class_ads.active LIKE 1
AND class_ads.category_id = '116'
AND class_ads.id != '99178'
AND class_slugs.`type` = 'listing'
LIMIT 52054 , 12(select_type)SIMPLE
(table)class_slugs
(type)ref
(possible_keys)idx_type,idx_object_id
(key)idx_type
(key_len)63
(ref)const
(rows)67741
(Extra)Using index condition; Using whereSIMPLE
class_ads
eq_ref
PRIMARY,idx_category,idx_active,active_2,active_3,...
PRIMARY
4
tix_db.class_slugs.object_id
1
Using wherefunction oldDepending(m, h, g, k, b, d, n, o, e, l) {
var c = $("#" + h).val();
if (d) {
if (c == "-1") {
$("#span_" + h + "_other_val").show();
$("#span_" + g + "_other_val").show();
$("#" + g).removeAttr("disabled");
var j = $("<option></option>").attr("value", "-1").text(n);
$("#" + g).empty().append(j);
return
} else {
$("#span_" + h + "_other_val").hide();
$("#span_" + g + "_other_val").hide()
}
}href="javascript:;" var e=c.split(",");id=e[0];url_str=b+"/include/get_info.php?type=quick-search&id="+id;$.get(url_str,function(k){if(k==0){return}var j=k.split(",");var l=j.length;for(f=0;f<l;f++){div_spec=j[f];var g=div_spec.split("=");var h=g[0];if($("#"+h).val()!=null){if(g[1]==1){$("#"+h).fadeIn()}else{$("#"+h).fadeOut()}}}})}function IsNumeric(b){if(isNaN(parseFloat(b))){return false}return true}function dump(b,k){var h="";if(!k){k=0}var g="";for(var c=0;c<k+1;c++){g+=" "}if(typeof(b)=="object"){for(var d in b){var e=b[d];if(typeof(e)=="object"){h+=g+"'"+d+"' ...\n";h+=dump(e,k+1)}else{h+=g+"'"+d+"' => \""+e+'"\n'}}}else{h="===>"+b+"<===("+typeof(b)+")"}return h}function onReportMsg(d,c){if(myConfirm(c)==false){return}var b="include/actions.php?action=report&object=msg&id="+d;$.get(b,function(e){location.reload(true)})}function changeLocation(b,g){var c=g.split("|");var d=c[0];var e=c[1];$.post(b+"/include/set_location.php",{field:d,location:e,direct:1},function(h){location.reload(true)})}function changeDoubleLocation(l,m,j){var b=j.split(",");var k=b[0];var h=b[1];b=k.split("|");var d=b[0];var g=b[1];b=h.split("|");var c=b[0];var e=b[1];jQuery.post(l+"/include/set_location.php",{field1:d,location1:g,field2:c,location2:e,double_type:1},function(n){var o;if(m){o="html"}else{o="php"}location.href=l+"/listings."+o})}function deleteFile(c,e,b){var d="include/actions.php?action=delete_file&object="+b+"&id="+e+"&field_name="+c;$.get(d,function(g){location.reload(true)})}function load_gmaps(){var b=document.createElement("script");b.type="text/javascript";b.src="https://maps.googleapis.com/maps/api/js?callback=gmap_callback";if(typeof(places)!="undefined"&&places){b.src+="&libraries=places"}if(typeof(gmak)!="undefined"&&gmak!=null){b.src+="&key="+gmak}if(typeof(gmalng)!="undefined"&&gmalng!=null){b.src+="&language="+gmalng}if(typeof(gmareg)!="undefined"&&gmareg!=null){b.src+="®ion="+gmareg}document.body.appendChild(b)}function gmap_callback(){if(places){enable_autocomplete()}if(typeof init_gmap==="function"){init_gmap()}}jQuery.expr[":"].icontains=function(c,d,b){return jQuery(c).text().toUpperCase().indexOf(b[3].toUpperCase())>=0};function reinit(){$("#payment").empty();$(".form_footer").show()}function onEnable(e,d,b){if(d){if(myConfirm(d)==false){return}}var c="include/actions.php?action=enable&object="+b+"&id="+e;$.get(c,function(g){location.reload(true)})}function onDisable(e,d,b){if(d){if(myConfirm(d)==false){return}}var c="include/actions.php?action=favourite&object="+b+"&id="+e;$.get(c,function(g){location.reload(true)})}function makeFavorite(c,b){if(b){var d=b+"/"}d+="include/actions.php?object=favourite&action=add&id="+c;$.ajax({url:d,success:function(e){},async:false})}function remFavorite(c,b){if(b){var d=b+"/"}d+="include/actions.php?object=favourite&action=delete&id="+c;$.ajax({url:d,success:function(e){},async:false})}function loadExtScript(d,g,c){var b=document.createElement("script");b.type="text/javascript";if(b.readyState){b.onreadystatechange=function(){if(b.readyState=="loaded"||b.readyState=="complete"){b.onreadystatechange=null;g()}}}else{b.onload=function(){g()}}b.src=d;for(var e in c){b.setAttribute(e,c[e])}document.getElementsByTagName("head")[0].appendChild(b)};select ".TABLE_ADS.".*$mlang_vars, ".TABLE_ADS.".id as adid.*$mlang_vars, я даже сейчас уже и не знаю