Zugg Software :: View topic - howto Clear all room descriptions from map db?

Novice Joined: 27 Sep 2002 Posts: 37 Location: USA

How would I go about Clearing all room descriptions from my entire map db easily... my db has over 5,000 rooms. I have been searching and found delkey, i didnt really see how to use it effectivly in the help though :(

Thanks for any help I can get :)

Smok

Wizard Joined: 15 Jan 2002 Posts: 1644 Location: USA

Ok Lets try something like this *warning untested and without zmud in front of me so make a backup first* my commands might be backwards

#call %mapmode(1)
#call %maplocked(0)
#loop %numrooms {#call %roomdesc(%i, "")}

GURU Joined: 15 Jun 2001 Posts: 654 Location: USA

This should also work, connecting to the map database via ADO to do its work. Make sure you change the MapDatabase variable to reflect where and what the name of your map database is before entering it into zMUD. This has the advantage of being very, very fast. Compacting the database (File, Compact map database) afterwards should make it much smaller than it was originally and remove any trace of the descriptions that might still be stored in the file.

#VARIABLE MapDatabase "C:zMUDmap.mdb"
#VARIABLE Connection %comcreate( "ADODB.Connection")
#CALL @Connection.Open(%concat("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=", @MapDatabase))
#VARIABLE Recordset @Connection.Execute("UPDATE ObjectTbl SET [Desc] = ''")
#CALL @Recordset.Close
#VARIABLE Recordset %null
#VARIABLE Connection %null
#SAY Done.

Novice Joined: 27 Sep 2002 Posts: 37 Location: USA

Charbal I like the way yours looks BUT, it gives me an error:

Error parsing command:
Operation is not allowed when the object is closed

Does anyone know how to fix this problemo??

Thanks for the helps zMUD mASTERS

GURU Joined: 15 Jun 2001 Posts: 654 Location: USA

Ah... okay, I shuld have removed the #CALL @Recordset.Close line from it. Here it is without that:

#VARIABLE MapDatabase "C:zMUDmap.mdb"
#VARIABLE Connection %comcreate( "ADODB.Connection")
#CALL @Connection.Open(%concat("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=", @MapDatabase))
#VARIABLE Recordset @Connection.Execute("UPDATE ObjectTbl SET [Desc] = ''")
#VARIABLE Recordset %null
#VARIABLE Connection %null
#SAY Done.

Novice Joined: 27 Sep 2002 Posts: 37 Location: USA

Man that worked good and quickly.

You da man Charbal.

Thanx

Apprentice Joined: 11 Oct 2007 Posts: 154

I should be able to modify this to Clear all: Notes, Room Script, Walk Script, Contents, User defined string, Script Parameters

I am not sure what the field names are internally in the map database though, could anyone help me here? I would like to clean up my map file.

Posted: Thu Jul 09, 2009 1:25 am

Got this about a year ago or so when i asked for it

Posted: Thu Jul 09, 2009 1:46 am

ok, tested it, and it throws an error pop up box saying:
Error parsing command:
No value given for one or more required parameters
clearrooms2

Not sure why, but prolly cause it's trying to do to much at once.
Separate alias for each might be the way to go.

Posted: Thu Jul 09, 2009 1:51 am

WHOOPS

#var sql "UPDATE ObjectTbl SET NoteTbl.Note = ''"

SHOULD BE

#var sql "UPDATE NoteTbl SET NoteTbl.Note = ''"

Posted: Thu Jul 09, 2009 1:57 am

Ok, it works :-)
ODDLY deleting ALL of that info actually INCREASED my file size by 300KB
Compacting did nothing.

I had a load of notes but the other stuff was sprinkled around.
Not sure why the file size got bigger, but i compressed it with the map compression and compressed it in Access as well.
But went from 19,780KB to 20,008KB

Magician Joined: 23 Nov 2004 Posts: 364

I'd guess because your indices are still saved to prevent corruption, the allocations are still there but they're just working as placeholders now.

Posted: Thu Jul 09, 2009 4:50 am

But given that i lose 15MB when removing the room descs, why would i gain when removing Notes?
either way, the gain is minor Mr. Green