public bool AddClassified(Classified classified)
{
object remoteValue = DoRemote(classified);
if (remoteValue != null || m_doRemoteOnly)
return remoteValue != null && (bool) remoteValue;
if (GetUserProfile(classified.CreatorUUID) == null)
return false;
string keywords = classified.Description;
if (keywords.Length > 512)
keywords = keywords.Substring(keywords.Length - 512, 512);
//It might be updating, delete the old
QueryFilter filter = new QueryFilter();
filter.andFilters["ClassifiedUUID"] = classified.ClassifiedUUID;
GD.Delete("userclassifieds", filter);
List<object> values = new List<object>
{
classified.Name,
classified.Category,
classified.SimName,
classified.CreatorUUID,
classified.ScopeID,
classified.ClassifiedUUID,
OSDParser.SerializeJsonString(classified.ToOSD()),
classified.PriceForListing,
keywords
};
return GD.Insert("userclassifieds", values.ToArray());
}
public Classified GetClassifiedByID(UUID id)
{
object remoteValue = DoRemote(id);
if (remoteValue != null || m_doRemoteOnly)
return (Classified) remoteValue;
QueryFilter filter = new QueryFilter();
Dictionary<string, object> where = new Dictionary<string, object>(1);
where.Add("ClassifiedUUID", id);
filter.andFilters = where;
List<string> retVal = GD.Query(new[] {"*"}, "userclassifieds", filter, null, null, null);
if ((retVal == null) || (retVal.Count == 0)) return null;
Classified classified = new Classified();
classified.FromOSD((OSDMap) OSDParser.DeserializeJson(retVal[6]));
return classified;
}
public List<Classified> GetClassifiedsInRegion(string regionName)
{
object remoteValue = DoRemote(regionName);
if (remoteValue != null || m_doRemoteOnly)
return (List<Classified>) remoteValue;
QueryFilter filter = new QueryFilter();
filter.andFilters["SimName"] = regionName;
List<string> retVal = GD.Query(new[] {"*"}, "userclassifieds", filter, null, null, null);
if (retVal.Count == 0)
{
return new List<Classified>();
}
List<Classified> Classifieds = new List<Classified>();
for (int i = 0; i < retVal.Count; i += 9)
{
Classified classified = new Classified();
//Pull the classified out of OSD
classified.FromOSD((OSDMap) OSDParser.DeserializeJson(retVal[i + 6]));
Classifieds.Add(classified);
}
return Classifieds;
}
public List<DirClassifiedReplyData> FindClassifieds(string queryText, string category, uint queryFlags,
int StartQuery, UUID scopeID)
{
object remoteValue = DoRemote(queryText, category, queryFlags, StartQuery, scopeID);
if (remoteValue != null || m_doRemoteOnly)
return (List<DirClassifiedReplyData>) remoteValue;
QueryFilter filter = new QueryFilter();
filter.andLikeFilters["Name"] = "%" + queryText + "%";
if (int.Parse(category) != (int) DirectoryManager.ClassifiedCategories.Any) //Check the category
filter.andFilters["Category"] = category;
if (scopeID != UUID.Zero)
filter.andFilters["ScopeID"] = scopeID;
List<string> retVal = GD.Query(new[] {"*"}, "userclassifieds", filter, null, (uint) StartQuery, 50);
if (retVal.Count == 0)
return new List<DirClassifiedReplyData>();
List<DirClassifiedReplyData> Data = new List<DirClassifiedReplyData>();
for (int i = 0; i < retVal.Count; i += 9)
{
//Pull the classified out of OSD
Classified classified = new Classified();
classified.FromOSD((OSDMap) OSDParser.DeserializeJson(retVal[i + 5]));
DirClassifiedReplyData 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 Mature, add all
Data.Add(replyData);
}
return Data;
}
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;
}
public void ClassifiedInfoUpdate(UUID queryclassifiedID, uint queryCategory, string queryName,
string queryDescription, UUID queryParcelID,
uint queryParentEstate, UUID querySnapshotID, Vector3 queryGlobalPos,
byte queryclassifiedFlags,
int queryclassifiedPrice, IClientAPI remoteClient)
{
IScenePresence p = remoteClient.Scene.GetScenePresence(remoteClient.AgentId);
if (p == null)
return; //Just fail
IScheduledMoneyModule scheduledMoneyModule = p.Scene.RequestModuleInterface<IScheduledMoneyModule>();
IMoneyModule moneyModule = p.Scene.RequestModuleInterface<IMoneyModule>();
Classified classcheck = ProfileFrontend.GetClassified(queryclassifiedID);
if (((queryclassifiedFlags & 32) != 32) && moneyModule != null)
{
//Single week
if (!moneyModule.Charge(remoteClient.AgentId, queryclassifiedPrice, "Add Classified", TransactionType.ClassifiedCharge))
{
remoteClient.SendAlertMessage("You do not have enough money to create this classified.");
return;
}
}
else if (scheduledMoneyModule != null)
{
//Auto-renew
if (classcheck != null)
scheduledMoneyModule.RemoveFromScheduledCharge("Classified" + queryclassifiedID);
if (!scheduledMoneyModule.Charge(remoteClient.AgentId, queryclassifiedPrice, "Add Classified (" + queryclassifiedID +")",
7, TransactionType.ClassifiedCharge, "Classified" + queryclassifiedID, true))
{
remoteClient.SendAlertMessage("You do not have enough money to create this classified.");
return;
}
}
UUID creatorUUID = remoteClient.AgentId;
UUID classifiedUUID = queryclassifiedID;
uint category = queryCategory;
string name = queryName;
string description = queryDescription;
uint parentestate = queryParentEstate;
UUID snapshotUUID = querySnapshotID;
string simname = remoteClient.Scene.RegionInfo.RegionName;
Vector3 globalpos = queryGlobalPos;
byte classifiedFlags = queryclassifiedFlags;
int classifiedPrice = queryclassifiedPrice;
UUID parceluuid = p.CurrentParcelUUID;
string parcelname = "Unknown";
IParcelManagementModule parcelManagement =
remoteClient.Scene.RequestModuleInterface<IParcelManagementModule>();
if (parcelManagement != null)
{
ILandObject parcel = parcelManagement.GetLandObject(p.AbsolutePosition.X, p.AbsolutePosition.Y);
if (parcel != null)
{
parcelname = parcel.LandData.Name;
parceluuid = parcel.LandData.GlobalID;
}
}
uint creationdate = (uint) Util.UnixTimeSinceEpoch();
uint expirationdate = (uint) Util.UnixTimeSinceEpoch() + (365*24*60*60);
Classified classified = new Classified
{
ClassifiedUUID = classifiedUUID,
CreatorUUID = creatorUUID,
CreationDate = creationdate,
ExpirationDate = expirationdate,
Category = category,
Name = name,
Description = description,
ParcelUUID = parceluuid,
ParentEstate = parentestate,
SnapshotUUID = snapshotUUID,
SimName = simname,
GlobalPos = globalpos,
ParcelName = parcelname,
ClassifiedFlags = classifiedFlags,
PriceForListing = classifiedPrice,
ScopeID = remoteClient.ScopeID
};
ProfileFrontend.AddClassified(classified);
}