Zugg Software :: View topic - A different question for the mapper in Zmud

Newbie Joined: 17 Feb 2005 Posts: 7 Location: ...

Hello everyone... I have a big problem with the Zmud maps... the thing is, I've managed to get a copy of a HUGE map that almost has all the rooms in the entire MUD in it's contents... the problem is, I'm not the person who came up with it, and that person has certain WORMHOLE exits that he created in the EXITS tab instead of the Portals options... so now when I'm walking around, I use a skill that I don't have, and it generally messes with where I am... now... these wormholes are scattered around the 1000+ rooms... and there is no way I could possibly comb through all the rooms without going mad... I was wondering if someone could help me with that? Perhaps a trigger or a script that someone can come up with that would delete the exit of a room whenever I get there if it has wormholes in it? I can't get around anywhere because of this map, and though it has most of the rooms, it's pointless if I can autowalk to where I need to be :( Any ideas?

SubAdmin Joined: 18 Nov 2001 Posts: 5182

It sounds like he built these with portals. You can have the mapper display a list of known portals by selecting Edit|Portals... from the Mapper menu. If my guess is right you may then delete/disable all the portals or click the box marked "Disable all portals". If I am wrong then you will have to supply more information about how the map was built.

Newbie Joined: 17 Feb 2005 Posts: 7 Location: ...

Oh sorry... well... instead of using the PORTALS option... like the one you just talked about, he instead created manual exits using the EXITS tab in each individual room properties... so he has an exit setup from one room to go to the other using the "other" command, that being WORM WARP. So... out of the 1000+ rooms, there are some that when you go to PROPERTIES (for the individual room) and go to the EXITS tab... then you'll see exits in the normal directions (N,E,S.. etc)... but then some have WORM WARP for the "other" command... and those are the ones I'm looking to get rid of. I don't want to go through all the rooms because there are over a thousand of them. :(

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

Ok BACK UP YOUR MAP FIRST this is untested and could be wrong, might not be right, might be missing a step, the SQL syntax might be wrong, and you could break your map in the process. Of Course if it does look like it worked correctly make sure to keep a backup in case something kreeps up. This will remove all exits named work warp. for best results map should be closed while perfoming this

Adjust the ConnStr correctly (The bold part)

#ALIAS removeworm {
#VARIABLE query {delete * from ExitTbl where name = 'WORM WARP'}
#VAR ConnStr {Provider=Microsoft.Jet.OLEDB.4.0%char( 59)Data Source=c:\path\to\map.mdb}
#VARIABLE conn %comcreate( "ADODB.connection")
#CALL @conn.Open(@ConnStr)
#CALL @conn.execute(@query)
#CALL @conn.close
#VARIABLE rs ""
#UNVAR rs
#UNVAR query
#UNVAR ConnStr
#SAY All done
}

Newbie Joined: 17 Feb 2005 Posts: 7 Location: ...

woot! I love you... i mean... yes, it seems to have worked. Thank you so much. Smile