SELECT
markers.id,
markers.uuid,
markers.view,
markers.markerdetails,
markers.latitude,
markers.longitude,
markers.iconid,
markers.streetsid,
markers.creationdate,
markers.markername,
markers.address1,
markers.address2,
markers.city,
markers.state,
markers.zip,
markers.country,
markers.LonLatMatch,
DATE_FORMAT(markers.eventdate,'%m/%d/%y') AS eventdate,
markers.event,
markers.fullAddress,
markers.forCrew,
markers.forUser,
icontypes.iconimgpath,
icontypes.iconimgname,
users.name as UsersName,
(SELECT users.name FROM users WHERE streetsid = markers.forUser) AS forUsersName,
(SELECT crews.name FROM crews WHERE id = markers.forCrew) AS forCrewName,
(SELECT count(id) FROM markeralbums WHERE markerid = markers.id AND streetsid = ) AS MyLinkedAlbumsCount,
(SELECT count(id) FROM comments WHERE associated_id = markers.id AND postedby = ) AS MyCommentsCount
FROM
markers
LEFT JOIN
icontypes ON markers.iconid = icontypes.id
LEFT JOIN
users ON markers.streetsid = users.streetsid
WHERE
markers.id =
SELECT
markers.id,
markers.latitude,
markers.longitude,
markers.markerdetails,
icontypes.id AS iconid,
icontypes.iconimgpath,
icontypes.iconimgname,
users.StreetsID,
users.name as UsersName
FROM
markers
LEFT JOIN
icontypes ON markers.iconid = icontypes.id
LEFT JOIN
users ON markers.streetsid = users.streetsid
JOIN crews
LEFT JOIN
crewuserlist ON crewuserlist.crewid = crews.ID
WHERE
latitude
BETWEEN
AND
AND
longitude
BETWEEN
AND
AND
(
0=1
OR
markers.forCrew =
OR
(
crewuserlist.userid IN(SELECT userid FROM crewuserlist WHERE crewid = )
AND
markers.view =
OR
markers.view =
)
OR
markers.forUser =
OR
markers.view =
OR
(
markers.StreetsID IN(SELECT FriendID FROM buddylist WHERE userid = )
AND
markers.view =
)
OR
(
crewuserlist.userid IN(SELECT userid FROM crewuserlist WHERE userid = )
AND
markers.view =
)
OR
(
markers.StreetsID IN(SELECT FriendID FROM buddylist WHERE userid = )
AND
markers.view =
OR
crewuserlist.userid IN(SELECT userid FROM crewuserlist WHERE userid = )
AND
markers.view =
)
OR
(
markers.StreetsID =
AND
markers.view !=
)
)
GROUP BY markers.ID
ORDER BY markers.ID Desc
SELECT id,iconImgPath,IconImgName FROM icontypes
WHERE
ID =
var getBrowseResultsStruct = StructNew();
var GeoBoxed = "";
var getZipToCord = "";
var getCordToZip = StructNew();
if(arguments.pan EQ 1) {
getZipToCord = ZipToCord(arguments.searchzip);
arguments.lat = getZipToCord.lat;
arguments.lng = getZipToCord.lng;
}
getCordToZip.obj = CordToZip(arguments.lat,arguments.lng);
arguments.searchzip = getCordToZip.obj;
GeoBoxed = GeoBox(arguments.lat,arguments.lng,arguments.radiusmiles);
switch(arguments.searchview) {
case 1:
getBrowseResultsStruct = getMarkersBrowse_members
(
geoboxed:GeoBoxed,
lat:arguments.lat,
lng:arguments.lng,
searchstr:arguments.searchstr,
onlineNow:arguments.membersOnlineNow,
car_make:arguments.car_make,
page:arguments.page,
limit:arguments.limit
);
break;
case 2:
getBrowseResultsStruct = getMarkersBrowse_cars
(
geoboxed:GeoBoxed,
lat:arguments.lat,
lng:arguments.lng,
searchstr:arguments.searchstr,
car_make:arguments.car_make,
page:arguments.page,
limit:arguments.limit
);
break;
case 3:
getBrowseResultsStruct = getMarkersBrowse_crews
(
geoboxed:GeoBoxed,
lat:arguments.lat,
lng:arguments.lng,
searchstr:arguments.searchstr,
car_make:arguments.car_make,
page:arguments.page,
limit:arguments.limit,
crewsortby:arguments.crewsortby
);
break;
case 4:
getBrowseResultsStruct = getMarkersBrowse_events
(
geoboxed:GeoBoxed,
lat:arguments.lat,
lng:arguments.lng,
searchstr:arguments.searchstr,
car_make:arguments.car_make,
page:arguments.page,
limit:arguments.limit,
eventDateStart:arguments.eventDateStart,
eventDateEnd:arguments.eventDateEnd
);
break;
case 5:
getBrowseResultsStruct = getMarkersBrowse_places
(
geoboxed:GeoBoxed,
lat:arguments.lat,
lng:arguments.lng,
searchstr:arguments.searchstr,
page:arguments.page,
limit:arguments.limit
);
break;
}
return getBrowseResultsStruct;
var GetTotalCount = '';
var TotalResults = '';
var getBrowse_MembersQuery = '';
var getBrowse_MembersReturn = StructNew();
var pagedStruct = StructNew();
pagedStruct.RowEnd = arguments.page*arguments.limit;
pagedStruct.RowStart = pagedStruct.RowEnd-arguments.limit;
SELECT
SQL_CALC_FOUND_ROWS
markers.markerdetails,
markers.latitude,
markers.longitude,
users.id,
users.id AS IconID,
users.name,
users.StreetsID,
users.name as UsersName,
users.avatar AS IconImgName,
users.avatar_path AS IconImgPath,
users.avatar AS DisplayImgName,
users.avatar_path AS DisplayImgPath,
#arguments.lat# AS querySetLat,
#arguments.lng# AS querySetLng
FROM
markers
LEFT JOIN
users ON markers.id = users.MarkerID
LEFT JOIN
garage ON users.id = garage.userid
LEFT JOIN
garagedescriptions ON garage.id = garagedescriptions.garageid
WHERE
markers.latitude
BETWEEN
AND
AND
markers.longitude
BETWEEN
AND
AND
markers.view =
AND
users.onlineNow = 1
AND
garage.car_make =
AND
users.name LIKE
OR
garage.car_name LIKE
OR
garagedescriptions.details LIKE
GROUP BY users.id
ORDER BY users.id desc, ID Desc
LIMIT ,;
SELECT FOUND_ROWS() AS TotalResults
StructInsert(getBrowse_MembersReturn, "getBrowse_Query", markerSpread(getBrowse_MembersQuery));
StructInsert(getBrowse_MembersReturn, "totalResultCount", GetTotalCount.TotalResults);
var GetTotalCount = '';
var TotalResults = '';
var getBrowse_CarsQuery = '';
var getBrowse_CarsReturn = StructNew();
var pagedStruct = StructNew();
pagedStruct.RowEnd = arguments.page*arguments.limit;
pagedStruct.RowStart = pagedStruct.RowEnd-arguments.limit;
SELECT
SQL_CALC_FOUND_ROWS
markers.markerdetails,
markers.latitude,
markers.longitude,
users.id,
users.name,
users.StreetsID,
users.name as UsersName,
users.avatar AS IconImgName,
users.avatar_path AS IconImgPath,
gallery.thumb_small AS DisplayImgName,
gallery.path AS DisplayImgPath,
#arguments.lat# AS querySetLat,
#arguments.lng# AS querySetLng
FROM
markers
LEFT JOIN
users ON markers.streetsid = users.id
LEFT JOIN
garage ON markers.streetsid = garage.userid
LEFT JOIN
gallery_albums ON garage.id = gallery_albums.garageid
LEFT JOIN
gallery ON gallery_albums.id = gallery.albumid
WHERE
markers.latitude
BETWEEN
AND
AND
markers.longitude
BETWEEN
AND
AND
markers.view =
AND
markers.id = users.MarkerID
AND
gallery.filename != ''
AND
markers.streetsid IN(select userid FROM garage WHERE garage.car_make = )
AND
0=0
AND
( users.name LIKE
OR
garage.car_name LIKE
OR
markers.streetsid IN(select streetsid FROM garagedescriptions WHERE garagedescriptions.details LIKE )
)
GROUP BY users.id
ORDER BY users.id desc, ID Desc
LIMIT ,;
SELECT FOUND_ROWS() AS TotalResults
StructInsert(getBrowse_CarsReturn, "getBrowse_Query", markerSpread(getBrowse_CarsQuery));
StructInsert(getBrowse_CarsReturn, "totalResultCount", GetTotalCount.TotalResults);
var GetTotalCount = '';
var TotalResults = '';
var getBrowse_CrewsQuery = '';
var getBrowse_CrewsReturn = StructNew();
var pagedStruct = StructNew();
pagedStruct.RowEnd = arguments.page*arguments.limit;
pagedStruct.RowStart = pagedStruct.RowEnd-arguments.limit;
switch(arguments.crewsortby) {
case 1:
pagedStruct.SortBy = "crews.created asc";
break;
case 2:
pagedStruct.SortBy = "crews.created desc";
break;
case 3:
pagedStruct.SortBy = "CrewsSortBySize desc";
break;
}
SELECT
SQL_CALC_FOUND_ROWS
markers.latitude,
markers.longitude,
users.avatar AS IconImgName,
users.avatar_path AS IconImgPath,
crews.id,
crews.name,
crews.zip,
crews.description AS markerdetails,
crews.bannerpath AS DisplayImgPath,
crews.bannerfilename AS DisplayImgName,
crews.ownerid,
DATE_FORMAT(crews.created,'%b %e, %Y') AS created,
crews.bannerwidth,
crews.bannerheight,
users.avatar AS IconImgName,
users.avatar_path AS IconImgPath,
users.StreetsID,
users.name as UsersName,
(SELECT count(id) FROM crewuserlist WHERE crewuserlist.crewid = crews.id) AS CrewsSortBySize,
#arguments.lat# AS querySetLat,
#arguments.lng# AS querySetLng
FROM
markers
LEFT JOIN
users ON markers.streetsid = users.id
LEFT JOIN
crews ON markers.streetsid = crews.ownerid
WHERE
markers.latitude
BETWEEN
AND
AND
markers.longitude
BETWEEN
AND
AND
markers.view =
AND
crews.bannerfilename != ''
AND
markers.streetsid IN(select userid FROM garage WHERE garage.car_make = )
AND
0=0
AND
( users.name LIKE
OR
garage.car_name LIKE
OR
markers.streetsid IN(select streetsid FROM garagedescriptions WHERE garagedescriptions.details LIKE )
OR
crews.name LIKE
OR
crews.description LIKE
)
GROUP BY crews.id
ORDER BY #pagedStruct.SortBy#
LIMIT ,;
SELECT FOUND_ROWS() AS TotalResults
StructInsert(getBrowse_CrewsReturn, "getBrowse_Query", markerSpread(getBrowse_CrewsQuery));
StructInsert(getBrowse_CrewsReturn, "totalResultCount", GetTotalCount.TotalResults);
var GetTotalCount = '';
var TotalResults = '';
var getBrowse_EventsQuery = '';
var getBrowse_EventsReturn = StructNew();
var pagedStruct = StructNew();
pagedStruct.RowEnd = arguments.page*arguments.limit;
pagedStruct.RowStart = pagedStruct.RowEnd-arguments.limit;
SELECT
SQL_CALC_FOUND_ROWS
markers.id,
markers.latitude,
markers.longitude,
markers.markerName as Name,
markers.markerdetails,
DATE_FORMAT(markers.eventdate,'%b %e, %Y') AS eventdate,
icontypes.IconImgName,
icontypes.IconImgPath,
icontypes.IconImgName AS DisplayImgName,
icontypes.IconImgPath AS DisplayImgPath,
users.name as UsersName,
users.streetsid as StreetsID,
#arguments.lat# AS querySetLat,
#arguments.lng# AS querySetLng
FROM
markers
LEFT JOIN
icontypes ON markers.iconid = icontypes.id
LEFT JOIN
users ON markers.streetsid = users.streetsid
WHERE
markers.latitude
BETWEEN
AND
AND
markers.longitude
BETWEEN
AND
AND
markers.view =
AND
markers.eventdate
BETWEEN
AND
AND
markers.event = 1
AND
markers.markerdetails LIKE
GROUP BY markers.id
ORDER BY markers.eventdate asc
LIMIT ,;
SELECT FOUND_ROWS() AS TotalResults
StructInsert(getBrowse_EventsReturn, "getBrowse_Query", markerSpread(getBrowse_EventsQuery));
StructInsert(getBrowse_EventsReturn, "totalResultCount", GetTotalCount.TotalResults);
var streetsObj = CreateObject('component','streets.streets');
var GetTotalCount = '';
var TotalResults = '';
var getBrowse_PlacesQuery = '';
var getBrowse_PlacesReturn = StructNew();
var pagedStruct = StructNew();
pagedStruct.RowEnd = arguments.page*arguments.limit;
pagedStruct.RowStart = pagedStruct.RowEnd-arguments.limit;
SELECT
SQL_CALC_FOUND_ROWS
markers.id,
markers.latitude,
markers.longitude,
markers.markerName as Name,
markers.markerdetails,
DATE_FORMAT(DATE_ADD(markers.creationdate, INTERVAL #streetsObj.getMyTimeZoneOffset()# HOUR),'%b %e, %Y %r') AS ddate,
icontypes.IconImgName,
icontypes.IconImgPath,
icontypes.IconImgName AS DisplayImgName,
icontypes.IconImgPath AS DisplayImgPath,
users.name as UsersName,
users.streetsid as StreetsID,
#arguments.lat# AS querySetLat,
#arguments.lng# AS querySetLng
FROM
markers
LEFT JOIN
icontypes ON markers.iconid = icontypes.id
LEFT JOIN
users ON markers.streetsid = users.streetsid
WHERE
markers.latitude
BETWEEN
AND
AND
markers.longitude
BETWEEN
AND
AND
markers.view =
AND
markers.event = 0
AND
markers.id NOT IN(SELECT MarkerID from users)
AND
0=0
AND
(
markers.markerdetails LIKE
OR
markers.markerName LIKE
)
GROUP BY markers.id
ORDER BY markers.id desc
LIMIT ,;
SELECT FOUND_ROWS() AS TotalResults
StructInsert(getBrowse_PlacesReturn, "getBrowse_Query", markerSpread(getBrowse_PlacesQuery));
StructInsert(getBrowse_PlacesReturn, "totalResultCount", GetTotalCount.TotalResults);
var streetsObj = CreateObject('component','streets.streets');
var getManageMarkersReturn = StructNew();
var GetTotalCount = '';
var TotalResults = '';
var getManageMarkersQuery = '';
var pagedStruct = StructNew();
pagedStruct.RowEnd = arguments.page*arguments.limit;
pagedStruct.RowStart = pagedStruct.RowEnd-arguments.limit;
SELECT
SQL_CALC_FOUND_ROWS
markers.id,
markers.latitude,
markers.longitude,
markers.markerdetails,
markers.iconid,
markers.streetsid,
markers.forCrew,
markers.forUser,
markers.markername,
markers.event,
markers.eventdate,
icontypes.iconimgname,
icontypes.iconimgpath,
users.name
FROM
markers
LEFT JOIN
icontypes ON markers.iconid = icontypes.id
LEFT JOIN
users ON markers.streetsid = users.streetsid
LEFT JOIN
crews ON markers.forCrew = crews.id
WHERE
0=0
AND
(
markers.markername LIKE
OR
markers.markerdetails LIKE
)
AND
markers.streetsid =
AND
markers.forCrew != 0
AND
markers.view = 6
AND
markers.streetsid =
AND
markers.event = 1
AND
markers.streetsid =
AND
markers.event = 0
AND
markers.streetsid =
AND
markers.id IN
(
SELECT
comments.associated_id
FROM
comments
WHERE
comments.postedby =
AND
comments.type = 2
)
AND
markers.id IN
(
SELECT
markeralbums.markerid
FROM
markeralbums
WHERE
markeralbums.streetsid =
)
AND
markers.forUser =
AND
markers.forUser IN
(
SELECT
buddylist.userid
FROM
buddylist
WHERE
buddylist.friendid =
)
AND
markers.streetsid =
LIMIT ,;
SELECT FOUND_ROWS() AS TotalResults
StructInsert(getManageMarkersReturn, "getManageMarkersQuery", markerSpread(getManageMarkersQuery));
StructInsert(getManageMarkersReturn, "totalResultCount", GetTotalCount.TotalResults);
var variables = StructNew();
variables.browseQueryObject = arguments.getBrowseQueryResults;
variables.getBrowseQueryResultsTMP = '';
variables.Step = 0;
variables.Reach = 0;
variables.Push = 0;
variables.Pre = 0;
variables.StepC = 0;
variables.ReachC = 1;
variables.PreC = 0;
variables.intRow = 1;
SELECT ID,LATITUDE AS TmpLat,LONGITUDE AS TmpLng FROM variables.browseQueryObject
WHERE Latitude =
AND Longitude =
ORDER BY ID DESC
for(variables.intRow = 1; variables.intRow LTE getBrowseQueryResultsTMP.RecordCount; variables.intRow++) {
if(getBrowseQueryResultsTMP.recordCount) {
if(getBrowseQueryResultsTMP.id neq getBrowseQueryResults.id) {
variables.byLat = getBrowseQueryResultsTMP.TmpLat;
variables.ByLon = getBrowseQueryResultsTMP.TmpLng;
if(variables.Step EQ 5) {
variables.Step = 1;
variables.StepC = variables.StepC+1;
}
if(variables.Reach EQ 5) {
variables.Reach = 1;
variables.ReachC = variables.ReachC+1;
}
if(variables.Push EQ 5) {
variables.Push = 1;
}
if(variables.Pre EQ 0) {
variables.Pre = 1;
variables.PreC = variables.PreC+1;
}
switch(variables.Pre) {
case 1:
variables.byLat = variables.byLat+Sin(0)/(180 * PI());
variables.ByLon = variables.ByLon-Cos(0)/(180 * PI() / variables.PreC);
break;
case 2:
variables.byLat = variables.byLat+Cos(0)/(180 * PI() / variables.PreC);
variables.ByLon = variables.ByLon-Sin(0)/(180 * PI());
break;
case 3:
variables.byLat = variables.byLat-Sin(0)/(180 * PI());
variables.ByLon = variables.ByLon+Cos(0)/(180 * PI() / variables.PreC);
break;
case 4:
variables.byLat = variables.byLat-Cos(0)/(180 * PI() / variables.PreC);
variables.ByLon = variables.ByLon+Sin(0)/(180 * PI());
break;
}
switch(variables.Step) {
case 1:
variables.byLat = variables.byLat-Cos(0)/(180 * PI() / variables.StepC);
variables.ByLon = variables.ByLon+Cos(0)/(180 * PI() / variables.StepC);
break;
case 2:
variables.byLat = variables.byLat-Cos(0)/(180 * PI() / variables.StepC);
variables.ByLon = variables.ByLon-Cos(0)/(180 * PI() / variables.StepC);
break;
case 3:
variables.byLat = variables.byLat+Cos(0)/(180 * PI() / variables.StepC);
variables.ByLon = variables.ByLon+Cos(0)/(180 * PI() / variables.StepC);
break;
case 4:
variables.byLat = variables.byLat+Cos(0)/(180 * PI() / variables.StepC);
variables.ByLon = variables.ByLon-Cos(0)/(180 * PI() / variables.StepC);
break;
}
if(variables.Reach EQ 1) {
if(variables.Push EQ 1) {
variables.byLat = variables.byLat-Cos(0)/(180 * PI() / variables.ReachC);
variables.ByLon = variables.ByLon+Sin(1)/(180 * PI());
}
if(variables.Push EQ 2) {
variables.byLat = variables.byLat-Sin(1)/(180 * PI());
variables.ByLon = variables.ByLon+Cos(0)/(180 * PI() / variables.ReachC);
}
}
if(variables.Reach EQ 2) {
if(variables.Push EQ 1) {
variables.byLat = variables.byLat-Cos(0)/(180 * PI() / variables.ReachC);
variables.ByLon = variables.ByLon+Sin(-1)/(180 * PI());
}
if(variables.Push EQ 2) {
variables.byLat = variables.byLat+Sin(-1)/(180 * PI());
variables.ByLon = variables.ByLon-Cos(0)/(180 * PI() / variables.ReachC);
}
}
if(variables.Reach EQ 3) {
if(variables.Push EQ 1) {
variables.byLat = variables.byLat+Cos(0)/(180 * PI() / variables.ReachC);
variables.ByLon = variables.ByLon-Sin(1)/(180 * PI());
}
if(variables.Push EQ 2) {
variables.byLat = variables.byLat+Sin(1)/(180 * PI());
variables.ByLon = variables.ByLon-Cos(0)/(180 * PI() / variables.ReachC);
}
}
if(variables.Reach EQ 4) {
if(variables.Push EQ 1) {
variables.byLat = variables.byLat+Cos(0)/(180 * PI() / variables.ReachC);
variables.ByLon = variables.ByLon-Sin(-1)/(180 * PI());
}
if(variables.Push EQ 2) {
variables.byLat = variables.byLat-Sin(-1)/(180 * PI());
variables.ByLon = variables.ByLon+Cos(0)/(180 * PI() / variables.ReachC);
}
}
QuerySetCell(getBrowseQueryResults, "LATITUDE", variables.byLat, getBrowseQueryResults.currentRow);
QuerySetCell(getBrowseQueryResults, "LONGITUDE", variables.ByLon, getBrowseQueryResults.currentRow);
}
}
}
switch(variables.Pre) {
case 4:
variables.Pre = 6;
variables.Step = 5;
break;
case 3:
variables.Pre = 4;
break;
case 2:
variables.Pre = 3;
break;
case 1:
variables.Pre = 2;
break;
}
switch(variables.Step) {
case 4:
variables.Step = 6;
variables.Reach = 5;
variables.Push = 5;
break;
case 3:
variables.Step = 4;
break;
case 2:
variables.Step = 3;
break;
case 1:
variables.Step = 2;
break;
}
if(variables.Reach EQ 4 and variables.Push EQ 2) {
variables.Reach = 6;
variables.Push = 6;
variables.Pre = 0;
}
if(variables.Reach EQ 3 and variables.Push EQ 2) {
variables.Reach = 4;
variables.Push = 5;
}
if(variables.Reach EQ 2 and variables.Push EQ 2) {
variables.Reach = 3;
variables.Push = 5;
}
if(variables.Reach EQ 1 and variables.Push EQ 2) {
variables.Reach = 2;
variables.Push = 5;
}
if(variables.Push EQ 1) {
variables.Push = 2;
}
SELECT
markers.id,
markers.latitude,
markers.longitude,
markers.iconid,
markers.markerdetails,
markers.streetsid,
markers.view,
icontypes.id as IconTypeID,
icontypes.IconImgPath,
icontypes.IconImgName,
group_concat(distinct CAST(`crewuserlist`.`crewid` as CHAR)) AS `FORCREW`
FROM markers
LEFT JOIN icontypes ON markers.iconid = icontypes.id
JOIN crewuserlist
WHERE markers.id =
AND IN(crewuserlist.userid)
GROUP BY markers.id
SELECT
crews.id AS crewid,
crews.name
FROM crews
WHERE crews.id IN ()
SELECT id,view,streetsid FROM markers where ID =
SELECT crewid,userid FROM crewuserlist
WHERE userid =
AND crewid IN (SELECT crewid FROM crewuserlist WHERE userid = );
SELECT userid,friendid FROM buddylist
WHERE userid =
AND friendid =
JSTAGDETAILS
