DEBUG
FN args: Array
(
[0] => 457
[1] =>
[2] =>
[3] => agent
)
BEFORE:
Site: 457
LocID:
Region:
State: agent
Experttype:
Expertnum: 1
ProcessOverride: 1
SearchNearby:
DisplayCount: 1
SITE IS NUMERIC, SWAPPING
IFELSE numeric
IFELSE else
AFTER:
Site: 457
Igate: njhud
LocID: 457
Region:
State:
Experttype: agent
Expertnum: 1
ProcessOverride: 1
SearchNearby:
DisplayCount: 1
QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 457 AND i.igate IN ('gahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG
FN args: Array
(
[0] => 457
[1] =>
[2] =>
[3] => lender
)
BEFORE:
Site: 457
LocID:
Region:
State: lender
Experttype:
Expertnum: 1
ProcessOverride: 1
SearchNearby:
DisplayCount: 1
SITE IS NUMERIC, SWAPPING
IFELSE numeric
IFELSE else
AFTER:
Site: 457
Igate: njhud
LocID: 457
Region:
State:
Experttype: lender
Expertnum: 1
ProcessOverride: 1
SearchNearby:
DisplayCount: 1
QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 457 AND i.igate IN ('gahud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG
FN args: Array
(
[0] => 457
[1] =>
[2] =>
[3] => other
)
BEFORE:
Site: 457
LocID:
Region:
State: other
Experttype:
Expertnum: 1
ProcessOverride: 1
SearchNearby:
DisplayCount: 1
SITE IS NUMERIC, SWAPPING
IFELSE numeric
IFELSE else
AFTER:
Site: 457
Igate: njhud
LocID: 457
Region:
State:
Experttype: other
Expertnum: 1
ProcessOverride: 1
SearchNearby:
DisplayCount: 1
QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 457 AND i.igate IN ('gahud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Deprecated: Non-static method propertylistController::getDB() should not be called statically in /var/www/njhud/components/com_propertylist/models/details.php on line 46
object(JDatabaseDriverMysqli)#972 (23) {
["name"]=>
string(6) "mysqli"
["serverType"]=>
string(5) "mysql"
["connection":protected]=>
object(mysqli)#973 (18) {
["affected_rows"]=>
int(20)
["client_info"]=>
string(14) "mysqlnd 7.4.33"
["client_version"]=>
int(70433)
["connect_errno"]=>
int(0)
["connect_error"]=>
NULL
["errno"]=>
int(0)
["error"]=>
string(0) ""
["error_list"]=>
array(0) {
}
["field_count"]=>
int(1)
["host_info"]=>
string(72) "1b500716c327f998dcde593ff239235196266c0e.rackspaceclouddb.com via TCP/IP"
["info"]=>
NULL
["insert_id"]=>
int(0)
["server_info"]=>
string(6) "5.7.21"
["server_version"]=>
int(50721)
["sqlstate"]=>
string(5) "00000"
["protocol_version"]=>
int(10)
["thread_id"]=>
int(486659870)
["warning_count"]=>
int(0)
}
["nameQuote":protected]=>
string(1) "`"
["nullDate":protected]=>
string(19) "0000-00-00 00:00:00"
["_database":"JDatabaseDriver":private]=>
string(5) "ushud"
["count":protected]=>
int(4)
["cursor":protected]=>
NULL
["debug":protected]=>
bool(false)
["limit":protected]=>
int(0)
["log":protected]=>
array(0) {
}
["timings":protected]=>
array(0) {
}
["callStacks":protected]=>
array(0) {
}
["offset":protected]=>
int(0)
["options":protected]=>
array(9) {
["driver"]=>
string(6) "mysqli"
["prefix"]=>
string(4) "abc_"
["host"]=>
string(61) "1b500716c327f998dcde593ff239235196266c0e.rackspaceclouddb.com"
["user"]=>
string(7) "njhudj3"
["password"]=>
string(9) "greentree"
["database"]=>
string(5) "ushud"
["select"]=>
bool(true)
["port"]=>
int(3306)
["socket"]=>
NULL
}
["sql":protected]=>
string(259) "SELECT DISTINCT IF(l.PermitPictureOnInternet <> 'false', CONCAT('https://newjerseyhud.com/ushudsupportfiles/img.php?kid=', p.id), '') AS picture FROM listhub.Photo p, listhub.Listing l WHERE l.ListingKey = p.ListingKey AND l.ListingKey = '3yd-GAMLS-10287590';"
["tablePrefix":protected]=>
string(4) "abc_"
["utf":protected]=>
bool(true)
["utf8mb4":protected]=>
bool(true)
["errorNum":protected]=>
int(0)
["errorMsg":protected]=>
string(0) ""
["transactionDepth":protected]=>
int(0)
["disconnectHandlers":protected]=>
array(0) {
}
}