public boolean doArchonDBCompare(MOB mob, String scope, String firstWord, Vector commands)
throws java.io.IOException {
CMClass.CMObjectType doType = OBJECT_TYPES.get(firstWord.toUpperCase());
if (doType == null) doType = OBJECT_TYPES.get(firstWord.toUpperCase() + "S");
if (doType != null) commands.remove(0);
else doType = CMClass.CMObjectType.LOCALE;
final String theRest = CMParms.combineQuoted(commands, 0);
DBConnector dbConnector = null;
final String dbClass = CMParms.getParmStr(theRest, "DBCLASS", "");
final String dbService = CMParms.getParmStr(theRest, "DBSERVICE", "");
final String dbUser = CMParms.getParmStr(theRest, "DBUSER", "");
final String dbPass = CMParms.getParmStr(theRest, "DBPASS", "");
final int dbConns = CMParms.getParmInt(theRest, "DBCONNECTIONS", 3);
final int dbPingIntMins = CMParms.getParmInt(theRest, "DBPINGINTERVALMINS", 30);
final boolean dbReuse = CMParms.getParmBool(theRest, "DBREUSE", true);
final String ignore = CMParms.getParmStr(theRest, "IGNORE", "");
final String maskStr = CMParms.getParmStr(theRest, "MASK", "");
final Set<String> ignores = new SHashSet(CMParms.parseCommas(ignore.toUpperCase(), true));
final MaskingLibrary.CompiledZapperMask mask = CMLib.masking().maskCompile(maskStr);
if (dbClass.length() == 0) {
mob.tell(L("This command requires DBCLASS= to be set."));
return false;
}
if (dbService.length() == 0) {
mob.tell(L("This command requires DBSERVICE= to be set."));
return false;
}
if (dbUser.length() == 0) {
mob.tell(L("This command requires DBUSER= to be set."));
return false;
}
if (dbPass.length() == 0) {
mob.tell(L("This command requires DBPASS= to be set."));
return false;
}
dbConnector =
new DBConnector(
dbClass, dbService, dbUser, dbPass, dbConns, dbPingIntMins, dbReuse, false, false);
dbConnector.reconnect();
final DBInterface dbInterface = new DBInterface(dbConnector, null);
final DBConnection DBTEST = dbConnector.DBFetch();
if (DBTEST != null) dbConnector.DBDone(DBTEST);
mob.tell(L("Loading database rooms..."));
final List<Room> rooms = new LinkedList<Room>();
if ((!dbConnector.amIOk()) || (!dbInterface.isConnected())) {
mob.tell(L("Failed to connect to database."));
return false;
}
if (scope.equalsIgnoreCase("AREA"))
rooms.addAll(
Arrays.asList(dbInterface.DBReadRoomObjects(mob.location().getArea().Name(), false)));
else if (scope.equalsIgnoreCase("ROOM")) {
final Room R = dbInterface.DBReadRoomObject(mob.location().roomID(), false);
if (R != null) rooms.add(R);
} else
for (final Enumeration<Area> e = CMLib.map().areas(); e.hasMoreElements(); )
rooms.addAll(Arrays.asList(dbInterface.DBReadRoomObjects(e.nextElement().Name(), false)));
if (rooms.size() == 0) {
mob.tell(L("No rooms found."));
return false;
}
for (final Room R : rooms) dbInterface.DBReadContent(R.roomID(), R, false);
mob.tell(L("Data loaded, starting scan."));
final Comparator<MOB> convM =
new Comparator<MOB>() {
@Override
public int compare(MOB arg0, MOB arg1) {
final int x = arg0.ID().compareTo(arg1.ID());
return (x != 0) ? x : arg0.Name().compareTo(arg1.Name());
}
};
final Comparator<Item> convI =
new Comparator<Item>() {
@Override
public int compare(Item arg0, Item arg1) {
final int x = arg0.ID().compareTo(arg1.ID());
return (x != 0) ? x : arg0.Name().compareTo(arg1.Name());
}
};
try {
for (final Room dbR : rooms) {
Room R = CMLib.map().getRoom(dbR.roomID());
if (R == null) {
if (doType == CMClass.CMObjectType.LOCALE)
Log.sysOut("Merge", dbR.roomID() + " not in database");
// import, including exits!
continue;
}
synchronized (("SYNC" + dbR.roomID()).intern()) {
final Area.State oldFlags = R.getArea().getAreaState();
R.getArea().setAreaState(Area.State.FROZEN);
boolean updateMobs = false;
boolean updateItems = false;
final boolean updateRoom = false;
R = CMLib.map().getRoom(R);
CMLib.map().resetRoom(R);
final List<MOB> mobSetL = new Vector<MOB>();
for (final Enumeration<MOB> e = dbR.inhabitants(); e.hasMoreElements(); )
mobSetL.add(e.nextElement());
final MOB[] mobSet = mobSetL.toArray(new MOB[0]);
Arrays.sort(mobSet, convM);
String lastName = "";
int ct = 1;
final HashSet<MOB> doneM = new HashSet<MOB>();
for (final MOB dbM : mobSet) {
if (!lastName.equals(dbM.Name())) ct = 1;
else ct++;
final String rName = dbM.Name() + "." + ct;
MOB M = null;
int ctr = ct;
for (final Enumeration<MOB> m = R.inhabitants(); m.hasMoreElements(); ) {
final MOB M1 = m.nextElement();
if (M1.Name().equalsIgnoreCase(dbM.Name()) && ((--ctr) <= 0)) {
M = M1;
break;
}
}
if (M == null) {
if (amMerging(doType, mask, dbM) && (!ignore.contains("MISSING"))) {
if (mob.session()
.confirm(
L(
"MOB: @x1.@x2 not in local room.\n\rWould you like to add it (y/N)?",
dbR.roomID(),
rName),
L("N"))) {
M = (MOB) dbM.copyOf();
M.bringToLife(R, true);
doneM.add(M);
updateMobs = true;
Log.sysOut("Merge", mob.Name() + " added mob " + dbR.roomID() + "." + rName);
}
}
} else {
doneM.add(M);
if (amMerging(doType, mask, dbM)) {
if (!dbM.sameAs(M)) {
final MOB oldM = (MOB) M.copyOf();
if ((dbMerge(mob, "^MMOB " + dbR.roomID() + "." + rName + "^N", dbM, M, ignores))
&& (!oldM.sameAs(M))) {
Log.sysOut("Merge", mob.Name() + " modified mob " + dbR.roomID() + "." + rName);
updateMobs = true;
}
}
}
final STreeSet<Item> itemSetL = new STreeSet<Item>(convI);
for (final Enumeration<Item> e = dbM.items(); e.hasMoreElements(); )
itemSetL.add(e.nextElement());
final Item[] itemSet = itemSetL.toArray(new Item[0]);
Arrays.sort(itemSet, convI);
String lastIName = "";
int ict = 1;
final HashSet<Item> doneI = new HashSet<Item>();
for (final Item dbI : itemSet) {
if (!lastIName.equals(dbI.Name())) ict = 1;
else ict++;
final String rIName = dbI.Name() + "." + ict;
Item I = null;
ctr = ict;
for (final Enumeration<Item> i = M.items(); i.hasMoreElements(); ) {
final Item I1 = i.nextElement();
if (I1.Name().equalsIgnoreCase(dbI.Name()) && ((--ctr) <= 0)) {
I = I1;
break;
}
}
if (I == null) {
if (amMerging(doType, mask, dbI) && (!ignore.contains("MISSING"))) {
if (mob.session()
.confirm(
L(
"Item: @x1.@x2.@x3 not in local room.\n\rWould you like to add it (y/N)?",
dbR.roomID(),
dbM.Name(),
rIName),
L("N"))) {
I = (Item) dbI.copyOf();
M.addItem(I);
doneI.add(I);
final Item cI =
(dbI.container() == null) ? null : M.findItem(dbI.container().Name());
if (cI instanceof Container) I.setContainer((Container) cI);
updateMobs = true;
Log.sysOut(
"Merge",
mob.Name()
+ " added item "
+ dbR.roomID()
+ "."
+ dbM.Name()
+ "."
+ rIName);
}
}
} else if (amMerging(doType, mask, dbI)) {
doneI.add(I);
if (!dbI.sameAs(I)) {
final Item oldI = (Item) I.copyOf();
if ((dbMerge(
mob,
"^IITEM ^M" + dbR.roomID() + "." + dbM.Name() + "." + rIName + "^N",
dbI,
I,
ignores))
&& (!oldI.sameAs(I))) {
Log.sysOut(
"Merge",
mob.Name()
+ " modified item "
+ dbR.roomID()
+ "."
+ dbM.Name()
+ "."
+ rIName);
updateMobs = true;
}
}
}
lastIName = dbI.Name();
}
for (final Enumeration<Item> i = M.items(); i.hasMoreElements(); ) {
final Item I = i.nextElement();
if (amMerging(doType, mask, I)
&& (!doneI.contains(I))
&& (!ignore.contains("EXTRA"))) {
if (mob.session()
.confirm(
L(
"Item: @x1.@x2.@x3 not in database.\n\rWould you like to delete it (y/N)?",
R.roomID(),
M.Name(),
I.Name()),
L("N"))) {
M.delItem(I);
updateMobs = true;
Log.sysOut(
"Merge",
mob.Name()
+ " deleted item "
+ R.roomID()
+ "."
+ M.Name()
+ "."
+ I.Name());
}
}
}
}
lastName = dbM.Name();
}
for (final Enumeration<MOB> r = R.inhabitants(); r.hasMoreElements(); ) {
final MOB M = r.nextElement();
if (amMerging(doType, mask, M)
&& (!doneM.contains(M))
&& (M.isMonster())
&& (!ignore.contains("EXTRA"))) {
if (mob.session()
.confirm(
L(
"MOB: @x1.@x2 not in database.\n\rWould you like to delete it (y/N)?",
R.roomID(),
M.Name()),
L("N"))) {
R.delInhabitant(M);
updateMobs = true;
Log.sysOut("Merge", mob.Name() + " deleted mob " + R.roomID() + "." + M.Name());
}
}
}
final STreeSet<Item> itemSetL = new STreeSet<Item>(convI);
for (final Enumeration<Item> e = dbR.items(); e.hasMoreElements(); )
itemSetL.add(e.nextElement());
final Item[] itemSet = itemSetL.toArray(new Item[0]);
Arrays.sort(itemSet, convI);
lastName = "";
ct = 1;
final HashSet<Item> doneI = new HashSet<Item>();
for (final Item dbI : itemSet) {
if (!lastName.equals(dbI.Name())) ct = 1;
else ct++;
final String rName = dbI.Name() + "." + ct;
Item I = null;
int ctr = ct;
for (final Enumeration<Item> i = R.items(); i.hasMoreElements(); ) {
final Item I1 = i.nextElement();
if (I1.Name().equalsIgnoreCase(dbI.Name()) && ((--ctr) <= 0)) {
I = I1;
break;
}
}
if (I == null) {
if (amMerging(doType, mask, dbI) && (!ignore.contains("MISSING"))) {
if (mob.session()
.confirm(
L(
"Item: @x1.@x2 not in local room.\n\rWould you like to add it (y/N)?",
dbR.roomID(),
rName),
L("N"))) {
I = (Item) dbI.copyOf();
R.addItem(I);
doneI.add(I);
final Item cI =
(dbI.container() == null) ? null : R.findItem(dbI.container().Name());
if (cI instanceof Container) I.setContainer((Container) cI);
updateItems = true;
Log.sysOut("Merge", mob.Name() + " added item " + dbR.roomID() + "." + rName);
}
}
} else if (amMerging(doType, mask, dbI)) {
doneI.add(I);
if (!dbI.sameAs(I)) {
final Item oldI = (Item) I.copyOf();
if ((dbMerge(mob, "^IITEM " + dbR.roomID() + "." + rName + "^N", dbI, I, ignores))
&& (!oldI.sameAs(I))) {
Log.sysOut("Merge", mob.Name() + " modified item " + dbR.roomID() + "." + rName);
updateItems = true;
}
}
}
lastName = dbI.Name();
}
for (final Enumeration<Item> i = R.items(); i.hasMoreElements(); ) {
final Item I = i.nextElement();
if (amMerging(doType, mask, I) && (!doneI.contains(I)) && (!ignore.contains("EXTRA"))) {
if (mob.session()
.confirm(
L(
"Item: @x1.@x2 not in database.\n\rWould you like to delete it (y/N)?",
R.roomID(),
I.Name()),
L("N"))) {
R.delItem(I);
updateItems = true;
Log.sysOut("Merge", mob.Name() + " deleted item " + R.roomID() + "." + I.Name());
}
}
}
if (updateRoom) CMLib.database().DBUpdateRoom(R);
if (updateItems) CMLib.database().DBUpdateItems(R);
if (updateMobs) CMLib.database().DBUpdateMOBs(R);
CMLib.map().resetRoom(R);
R.getArea().setAreaState(oldFlags);
}
dbR.destroy();
}
mob.tell(L("Done"));
} catch (final CMException cme) {
mob.tell(L("Cancelled."));
}
dbInterface.shutdown();
return true;
}
@Override
public void addTicker(TickClient C) {
if (!tickers.contains(C)) tickers.add(C);
}