merge databases [Archive] - ForumsHQ

[FreeBander]

is there a way to merge 2 databases.



what i am looking to do is this:



I am running 1.11i with tons of edits

I now want to install 1.11m



is there a way to merge the databases into one with all the new items ect that are in version 1.11m but keep all the edits to the spells, new areas, races classes ect that i have in the 1.11i databases?

:eek1:

[BlackHaze]

export to an access file everything you want to merge.. install m.. import from the access file.. using NMR. make sure you have a backup copy of i dats before you install m, just in case something goes wrong.

[Reckless]

make sure that there are no double entries before merging the db's though. If you didn't start high enough on the room #'s, item #'s, etc. you'll have to change it in access.

[FreeBander]

so after this point if i do further updates i would change nightmare to the 1.11m setting correct

[FreeBander]

you guys are da bomb, thanks for the help !

[syntax53]

i'm also making a utility right now that will change record numbers in case of an instance like that (conflicts). say you want to change items 1034 to 1050 to numbers 9000 to 9016 ... well you would also need to change that item # in all the shops that sell it, all the users that have it, all the rooms that it's sitting in, any textblocks that "giveitem" it, etc etc. yeah it sucks.



i got item numbers changing in shops and textblocks so far, the list i made that needs to be changed is long tho. the only thing i'm worried about is that the info we have on room exit parameters is a little iffy. can any one verify any number of them and report findings?



example:



Record Number Change Job Started 5/16/2003 @ 3:00:23 AM



User MUDNAME/BBSNAME -- Item #4 to 9001

User MUDNAME/BBSNAME -- Item #4 to 9001

User MUDNAME/BBSNAME -- Item #1836 to 9006

Shop #160 -- Item #3 to 9000

Shop #160 -- Item #4 to 9001

Shop #160 -- Item #5 to 9002

Shop #160 -- Item #6 to 9003

Shop #170 -- Item #8 to 9004

Shop #170 -- Item #1835 to 9005

Shop #170 -- Item #1836 to 9006

Textblock #2854 -- Item #1837 to 9007

Textblock #2854 -- Item #1838 to 9008

Textblock #2854 -- Item #1839 to 9009

Textblock #2854 -- Item #1840 to 9010

Textblock #2854 -- Item #1841 to 9011

Textblock #2854 -- Item #1842 to 9012

Textblock #2854 -- Item #1843 to 9013

Textblock #2857 -- Item #1837 to 9007

Textblock #2857 -- Item #1838 to 9008

Textblock #2857 -- Item #1839 to 9009





Changing Actual Item Record Numbers

-----------------------------------

Item #3 -- Retrieve=OK, Copy->9000=OK, Delete=OK

Item #4 -- Retrieve=OK, Copy->9001=OK, Delete=OK

Item #5 -- Retrieve=OK, Copy->9002=OK, Delete=OK

Item #6 -- Retrieve=OK, Copy->9003=OK, Delete=OK

Item #8 -- Retrieve=OK, Copy->9004=OK, Delete=OK

Item #1835 -- Retrieve=OK, Copy->9005=OK, Delete=OK

Item #1836 -- Retrieve=OK, Copy->9006=OK, Delete=OK

Item #1837 -- Retrieve=OK, Copy->9007=OK, Delete=OK

Item #1838 -- Retrieve=OK, Copy->9008=OK, Delete=OK

Item #1839 -- Retrieve=OK, Copy->9009=OK, Delete=OK

Item #1840 -- Retrieve=OK, Copy->9010=OK, Delete=OK

Item #1841 -- Retrieve=OK, Copy->9011=OK, Delete=OK

Item #1842 -- Retrieve=OK, Copy->9012=OK, Delete=OK

Item #1843 -- Retrieve=OK, Copy->9013=OK, Delete=OK

[BlackHaze]

NMR rules.. Syntax rules...

[Reckless]

Changing item #'s is relatively easy to do w/o that feature in NMR, but I realize not everyone has Access. *cough* Plat *cough* I'd like to see it where you can change room #'s and have it update those. I realize this is a stretch, as if syn doesn't have enough to do. That is a real pain in the ass though and I thought I'd share my 2 cents. :thumbu:

[syntax53]

Originally posted by Reckless

Changing item #'s is relatively easy to do w/o that feature in NMR, but I realize not everyone has Access.



it still a pain even with access. if you gotta change item numbers you're screwed because of users. it will change room numbers, it's actually not that hard.



here is the list i've been making of evertything i gotta scan and change (go ahead, change all this in access :)):



classes

-------

title textblock









items

-----

hit msg

miss msg

dest msg



read tb



class restrict 0-9



race restrict 0-9



negate spells 0-9



abilities 0-19









monsters

--------

item drops 0-9

weapon



create spell

death spell

between spells 0-5

hit spell 0-4

attack spell (if spell attack) 0-4



hit/miss/dodge attack msg's - all 0-4

move msg

death msg



greet txt

talk txt

desc txt



abilities 0-9









rooms

-----

room spell

spell exit type: open and close spell

cast exit type: pre spell, post spell

spell trap exit type: spell



key exit type: item

item exit type: item

door exit type: item

gate exit type: item

remote action exit type: item

ticket exit type: item

placed items 0-9

items in room 0-16

hidden items in room 0-14



item exit type: msg-no, msg-ok

spell exit type: msg

action exit type: msg

hidden exit type: msg, msg

trap exit type: pass msg, fail msg

text exit type: msg, msg, msg

remote action exit type: msg, msg

class exit type: fail msg

level exit type: fail msg

timed exit type: msg

ticket exit type: fail msg, ok msg

cast exit type: pass msg, look msg

ability exit type: fail msg

spell trap exit type: pass msg, fail msg



class exit type: class-ok, class-no



race exit type: race-ok, race-no



map change exit type: map

death room

exit room

control room

exit room #s



command text



shop #



permanent npc monster









shops

-----

class restrict



items 0-19









spells

------

msg a

msg b



abilities 0-9









textblocks

----------

class



race



failitem

checkitem

giveitem

roomitem

failroomitem

takeitem

clearitem



cast

learnspell

checkspell



summon

needmonster



message

checkitem

failitem

failroomitem

takeitem

maxlevel

minlevel

needmonster

nomonsters

price

evilaligned

goodaligned

failability



text

random

checkspell

testskill

:



teleport









users

-----

inven items 0-99

keys 0-49

weapon

worn items 0-19



spellbook 0-99

spell casted on 0-9



race



class



current room



abilities 0-29









abilities

---------

43-castspell

151-end cast

153-kill spell

42-learnspell

73-dispell magix

122-removesspell

160-givetempspell



59-class ok



146-mon guards



115-desc msg

120-start msg

101-confuse msg

[Reckless]

only if someone has the item that had it's number changed. For rooms, will it change the exit room #'s for all directions? That's something I needed recently.