![[Shadow]](/forum/data/avatars/m/6/6212.jpg?1550430741){kind=avatar}
How long will it take roughly to convert 1.9 to 2.3(MSSQL), many custom mobs etc, i haven't found a fast way of doing it, but i know people have.
Converting to 2.3
- Thread starter [Shadow]
- Start date
Export the files into text file from DBCommander (If your using 1.9)
Then Import the items back into tables in SQL
Dont forget you will need to do a copy of things like
FLD_STDITEMS
FLD_MONSTER
FLD_MAGIC
Simply do this by :- Right Click > New Table > e.g Name: FLD_STDITEMS1
When youve created the table, right click FLD_STDITEMS > Design Table.
Do the same with FLD_STDITEMS1
(Sometimes you may need to right click + Refresh the page if you create new tables and they dont show up)
Make sure that the FLD names are all correct and in the exact same order on your new FLD_STDITEMS1 as the old FLD_STDITEMS.
E.G
Column Name \ Data Type \ Legnth \ Allow Nulls
FLD_ID.........\..... int.......\.....4.....\ (Tick The Boxes)
FLD_NAME.....\ ..varchar...\....20....\ (Tick The Boxes)
And so on.. (Repeat this with FLD_MONSTER + FLD_MAGIC)
It personally find it better to Tick all of the boxes, or it seems to give an SQL error if you leave any boxes unticked a majority of the time.
When you've done that, its always best to look into the names of your spell books.
E.G 1.9 - SummonSkele 2.3 - SummonSkelton
Go through every book and make sure that each of the books match up with the same names + levels to train the books.
Hope this helps.
Then Import the items back into tables in SQL
Dont forget you will need to do a copy of things like
FLD_STDITEMS
FLD_MONSTER
FLD_MAGIC
Simply do this by :- Right Click > New Table > e.g Name: FLD_STDITEMS1
When youve created the table, right click FLD_STDITEMS > Design Table.
Do the same with FLD_STDITEMS1
(Sometimes you may need to right click + Refresh the page if you create new tables and they dont show up)
Make sure that the FLD names are all correct and in the exact same order on your new FLD_STDITEMS1 as the old FLD_STDITEMS.
E.G
Column Name \ Data Type \ Legnth \ Allow Nulls
FLD_ID.........\..... int.......\.....4.....\ (Tick The Boxes)
FLD_NAME.....\ ..varchar...\....20....\ (Tick The Boxes)
And so on.. (Repeat this with FLD_MONSTER + FLD_MAGIC)
It personally find it better to Tick all of the boxes, or it seems to give an SQL error if you leave any boxes unticked a majority of the time.
When you've done that, its always best to look into the names of your spell books.
E.G 1.9 - SummonSkele 2.3 - SummonSkelton
Go through every book and make sure that each of the books match up with the same names + levels to train the books.
Hope this helps.
Last edited:
Upvote
0
- Mar 23, 2007
- 458
- 12
- 65
i will help you at about 4 pm 2moz when i come online if you aint already done it by then. going to bed in a minute though, add me to msn if u want n ill help you 2moz, [email protected]
Upvote
0