public bool AllowGroup(string regionName, string groups)
{
string groupsNew = "";
using (
var reader = database.QueryReader("SELECT * FROM Regions WHERE RegionName=@0 AND WorldID=@1", regionName,
Main.worldID.ToString()))
{
if (reader.Read())
{
groupsNew = reader.Get <string>("Groups");
}
}
if (groupsNew != "")
{
groupsNew += ",";
}
groupsNew += groups;
int q = database.Query("UPDATE Regions SET Groups=@0 WHERE RegionName=@1 AND WorldID=@2", groupsNew,
regionName, Main.worldID.ToString());
Region r = GetRegionByName(regionName);
if (r != null)
{
r.SetAllowedGroups(groupsNew);
}
else
{
return(false);
}
return(q > 0);
}