/// <summary>
/// Gets all classifieds in the given region
/// </summary>
/// <param name = "regionName"></param>
/// <returns></returns>
public Classified[] GetClassifiedsInRegion(string regionName)
{
QueryFilter filter = new QueryFilter();
filter.andFilters["SimName"] = regionName;
List <string> retVal = GD.Query(new string[] { "*" }, "userclassifieds", filter, null, null, null);
if (retVal.Count == 0)
{
return(new Classified[0] {
});
}
List <Classified> Classifieds = new List <Classified>();
Classified classified;
for (int i = 0; i < retVal.Count; i += 6)
{
classified = new Classified();
//Pull the classified out of OSD
classified.FromOSD((OSDMap)OSDParser.DeserializeJson(retVal[i + 5]));
Classifieds.Add(classified);
}
return(Classifieds.ToArray());
}
public Classified GetClassified(UUID queryClassifiedID)
{
if (m_doRemoteOnly)
{
object remoteValue = DoRemote(queryClassifiedID);
return(remoteValue != null ? (Classified)remoteValue : null);
}
QueryFilter filter = new QueryFilter();
filter.andFilters ["ClassifiedUUID"] = queryClassifiedID;
List <string> query = genData.Query(new [] { "*" }, m_userClassifiedsTable, filter, null, null, null);
if (query.Count < 9)
{
return(null);
}
Classified classified = new Classified();
classified.FromOSD((OSDMap)OSDParser.DeserializeJson(query [6]));
return(classified);
}
public List <Classified> GetClassifieds(UUID ownerID)
{
object remoteValue = DoRemote(ownerID);
if (remoteValue != null || m_doRemoteOnly)
{
return((List <Classified>)remoteValue);
}
QueryFilter filter = new QueryFilter();
filter.andFilters["OwnerUUID"] = ownerID;
List <string> query = GD.Query(new[] { "*" }, "userclassifieds", filter, null, null, null);
List <Classified> classifieds = new List <Classified>();
for (int i = 0; i < query.Count; i += 9)
{
Classified classified = new Classified();
classified.FromOSD((OSDMap)OSDParser.DeserializeJson(query[i + 6]));
classifieds.Add(classified);
}
return(classifieds);
}
public Classified GetClassified(UUID queryClassifiedID)
{
try
{
List <string> serverURIs =
m_registry.RequestModuleInterface <IConfigurationService>().FindValueOf("RemoteServerURI");
foreach (string url in serverURIs)
{
OSDMap map = new OSDMap();
map["Method"] = "getclassified";
map["ClassifiedUUID"] = queryClassifiedID;
OSDMap response = WebUtils.PostToService(url + "osd", map, true, true);
if (response["_Result"].Type == OSDType.Map)
{
OSDMap responsemap = (OSDMap)response["_Result"];
Classified info = new Classified();
info.FromOSD(responsemap);
return(info);
}
}
}
catch (Exception e)
{
MainConsole.Instance.DebugFormat("[AuroraRemoteProfileConnector]: Exception when contacting server: {0}", e);
}
return(null);
}
public Classified GetClassified(UUID queryClassifiedID)
{
object remoteValue = DoRemote(queryClassifiedID);
if (remoteValue != null || m_doRemoteOnly)
{
return((Classified)remoteValue);
}
QueryFilter filter = new QueryFilter();
filter.andFilters["ClassifiedUUID"] = queryClassifiedID;
List <string> query = GD.Query(new string[1] {
"*"
}, "userclassifieds", filter, null, null, null);
if (query.Count < 6)
{
return(null);
}
Classified classified = new Classified();
classified.FromOSD((OSDMap)OSDParser.DeserializeJson(query[5]));
return(classified);
}
/// <summary>
/// Searches for classifieds
/// </summary>
/// <param name = "queryText"></param>
/// <param name = "category"></param>
/// <param name = "queryFlags"></param>
/// <param name = "StartQuery"></param>
/// <returns></returns>
public DirClassifiedReplyData[] FindClassifieds(string queryText, string category, uint queryFlags, int StartQuery)
{
QueryFilter filter = new QueryFilter();
if (int.Parse(category) != (int)DirectoryManager.ClassifiedCategories.Any) //Check the category
{
filter.andFilters["Category"] = category;
}
filter.andLikeFilters["Name"] = "%" + queryText + "%";
List <string> retVal = GD.Query(new string[1] {
"*"
}, "userclassifieds", filter, null, (uint)StartQuery, 50);
if (retVal.Count == 0)
{
return(new DirClassifiedReplyData[0] {
});
}
List <DirClassifiedReplyData> Data = new List <DirClassifiedReplyData>();
DirClassifiedReplyData replyData;
for (int i = 0; i < retVal.Count; i += 6)
{
//Pull the classified out of OSD
Classified classified = new Classified();
classified.FromOSD((OSDMap)OSDParser.DeserializeJson(retVal[i + 5]));
replyData = new DirClassifiedReplyData
{
classifiedFlags = classified.ClassifiedFlags,
classifiedID = classified.ClassifiedUUID,
creationDate = classified.CreationDate,
expirationDate = classified.ExpirationDate,
price = classified.PriceForListing,
name = classified.Name
};
//Check maturity levels
if ((replyData.classifiedFlags & (uint)DirectoryManager.ClassifiedFlags.Mature) == (uint)DirectoryManager.ClassifiedFlags.Mature)
{
if ((queryFlags & (uint)DirectoryManager.ClassifiedQueryFlags.Mature) == (uint)DirectoryManager.ClassifiedQueryFlags.Mature)
{
Data.Add(replyData);
}
}
else
{ //Its PG, add all
Data.Add(replyData);
}
}
return(Data.ToArray());
}
/// <summary>
/// Searches for classifieds
/// </summary>
/// <param name="queryText"></param>
/// <param name="category"></param>
/// <param name="queryFlags"></param>
/// <param name="StartQuery"></param>
/// <returns></returns>
public DirClassifiedReplyData[] FindClassifieds(string queryText, string category, string queryFlags, int StartQuery)
{
List <DirClassifiedReplyData> Data = new List <DirClassifiedReplyData>();
string whereClause = "";
string classifiedClause = "";
uint cqf = uint.Parse(queryFlags);
if (int.Parse(category) != (int)DirectoryManager.ClassifiedCategories.Any) //Check the category
{
classifiedClause = " and Category = '" + category + "'";
}
whereClause = " Name LIKE '%" + queryText + "%'" + classifiedClause + " LIMIT " + StartQuery.ToString() + ",50 ";
List <string> retVal = GD.Query(whereClause, "userclassifieds", "*");
if (retVal.Count == 0)
{
return(Data.ToArray());
}
DirClassifiedReplyData replyData = null;
for (int i = 0; i < retVal.Count; i += 6)
{
//Pull the classified out of OSD
Classified classified = new Classified();
classified.FromOSD((OSDMap)OSDParser.DeserializeJson(retVal[i + 5]));
replyData = new DirClassifiedReplyData();
replyData.classifiedFlags = classified.ClassifiedFlags;
replyData.classifiedID = classified.ClassifiedUUID;
replyData.creationDate = classified.CreationDate;
replyData.expirationDate = classified.ExpirationDate;
replyData.price = classified.PriceForListing;
replyData.name = classified.Name;
//Check maturity levels
if ((replyData.classifiedFlags & (uint)DirectoryManager.ClassifiedFlags.Mature) == (uint)DirectoryManager.ClassifiedFlags.Mature)
{
if ((cqf & (uint)DirectoryManager.ClassifiedQueryFlags.Mature) == (uint)DirectoryManager.ClassifiedQueryFlags.Mature)
{
Data.Add(replyData);
}
}
else //Its PG, add all
{
Data.Add(replyData);
}
}
return(Data.ToArray());
}
public byte[] AddClassified(OSDMap request)
{
Classified info = new Classified();
info.FromOSD((OSDMap)request["Classified"]);
ProfileConnector.AddClassified(info);
string xmlString = OSDParser.SerializeJsonString(new OSDMap());
//MainConsole.Instance.DebugFormat("[AuroraDataServerPostHandler]: resp string: {0}", xmlString);
UTF8Encoding encoding = new UTF8Encoding();
return(encoding.GetBytes(xmlString));
}
public Classified GetClassified(UUID queryClassifiedID)
{
List <string> query = GD.Query(new string[1] {
"ClassifiedUUID"
}, new object[1] {
queryClassifiedID
}, "userclassifieds", "*");
if (query.Count < 6)
{
return(null);
}
Classified classified = new Classified();
classified.FromOSD((OSDMap)OSDParser.DeserializeJson(query[5]));
return(classified);
}
public List <Classified> GetClassifieds(UUID ownerID)
{
List <Classified> classifieds = new List <Classified> ();
List <string> query = GD.Query(new string[1] {
"OwnerUUID"
}, new object[1] {
ownerID
}, "userclassifieds", "*");
for (int i = 0; i < query.Count; i += 6)
{
Classified classified = new Classified();
classified.FromOSD((OSDMap)OSDParser.DeserializeJson(query[i + 5]));
classifieds.Add(classified);
}
return(classifieds);
}
public Classified GetClassified(UUID queryClassifiedID)
{
Dictionary <string, object> where = new Dictionary <string, object>(1);
where["ClassifiedUUID"] = queryClassifiedID;
List <string> query = GD.Query(new string[1] {
"*"
}, "userclassifieds", new QueryFilter
{
andFilters = where
}, null, null, null);
if (query.Count < 6)
{
return(null);
}
Classified classified = new Classified();
classified.FromOSD((OSDMap)OSDParser.DeserializeJson(query[5]));
return(classified);
}
/// <summary>
/// Gets all classifieds in the given region
/// </summary>
/// <param name="regionName"></param>
/// <returns></returns>
public Classified[] GetClassifiedsInRegion(string regionName)
{
List <Classified> Classifieds = new List <Classified>();
List <string> retVal = GD.Query("SimName", regionName, "userclassifieds", "*");
if (retVal.Count == 0)
{
return(Classifieds.ToArray());
}
Classified classified = new Classified();
for (int i = 0; i < retVal.Count; i += 6)
{
//Pull the classified out of OSD
classified.FromOSD((OSDMap)OSDParser.DeserializeJson(retVal[i + 5]));
Classifieds.Add(classified);
classified = new Classified();
}
return(Classifieds.ToArray());
}
public List <Classified> GetClassifieds(UUID ownerID)
{
Dictionary <string, object> where = new Dictionary <string, object>(1);
where["OwnerUUID"] = ownerID;
List <string> query = GD.Query(new string[1] {
"*"
}, "userclassifieds", new QueryFilter
{
andFilters = where
}, null, null, null);
List <Classified> classifieds = new List <Classified>();
for (int i = 0; i < query.Count; i += 6)
{
Classified classified = new Classified();
classified.FromOSD((OSDMap)OSDParser.DeserializeJson(query[i + 5]));
classifieds.Add(classified);
}
return(classifieds);
}
public List <Classified> GetClassifieds(UUID ownerID)
{
try
{
List <string> serverURIs =
m_registry.RequestModuleInterface <IConfigurationService>().FindValueOf(ownerID.ToString(),
"RemoteServerURI");
foreach (string url in serverURIs)
{
OSDMap map = new OSDMap();
map["Method"] = "getclassifieds";
map["PrincipalID"] = ownerID;
OSDMap response = WebUtils.PostToService(url + "osd", map, true, true);
if (response["_Result"].Type == OSDType.Map)
{
OSDMap responsemap = (OSDMap)response["_Result"];
if (responsemap.ContainsKey("Result"))
{
List <Classified> list = new List <Classified>();
OSDArray picks = (OSDArray)responsemap["Result"];
foreach (OSD o in picks)
{
Classified info = new Classified();
info.FromOSD((OSDMap)o);
list.Add(info);
}
return(list);
}
return(new List <Classified>());
}
}
}
catch (Exception e)
{
MainConsole.Instance.DebugFormat("[AuroraRemoteProfileConnector]: Exception when contacting server: {0}", e);
}
return(null);
}
public List<Classified> GetClassifieds(UUID ownerID)
{
object remoteValue = DoRemote(ownerID);
if (remoteValue != null || m_doRemoteOnly)
return (List<Classified>) remoteValue;
QueryFilter filter = new QueryFilter();
filter.andFilters["OwnerUUID"] = ownerID;
List<string> query = GD.Query(new[] {"*"}, "userclassifieds", filter, null, null, null);
List<Classified> classifieds = new List<Classified>();
for (int i = 0; i < query.Count; i += 9)
{
Classified classified = new Classified();
classified.FromOSD((OSDMap) OSDParser.DeserializeJson(query[i + 6]));
classifieds.Add(classified);
}
return classifieds;
}
public Classified GetClassified(UUID queryClassifiedID)
{
object remoteValue = DoRemote(queryClassifiedID);
if (remoteValue != null || m_doRemoteOnly)
return (Classified) remoteValue;
QueryFilter filter = new QueryFilter();
filter.andFilters["ClassifiedUUID"] = queryClassifiedID;
List<string> query = GD.Query(new[] {"*"}, "userclassifieds", filter, null, null, null);
if (query.Count < 9)
{
return null;
}
Classified classified = new Classified();
classified.FromOSD((OSDMap) OSDParser.DeserializeJson(query[6]));
return classified;
}
