Uploading custom instances etc

[Aldun]

Hey,

Sure, call me a noob or something. But I would really appreciate if you guys could help me with some questions I got.

I'll start of by telling Im running a 3.0.8 server atm with arcemu/ascent. Obviously, its already public and Im busy adding custom stuff. As Database Im using Navicat.

However, when looking at the forum with released stuff, I saw some really nice things (like Scarlet Hold, and the total mall).

Now I tried to get these to work, but I cant! Maybe I got the Scarlet Hold to work (I queried it in Navicat and it gave the message thats it successfull), however then I just can't find how to get there ;>

About the mall, from that topic I downloaded the mall.rar file, but I havent got a single clue how to get it into my server! I would really love you if you could tell me exactly what to do to get stuff like this running =)

Also, if you got the time, could anyone search a topic with a clear explanation how to make a ''porting stone''? I couldnt find it.


Thanks!
-Aldun

[stoneharry]

There are guides out there, but personally I can never find the one I want when I want it...
I'll tell you how to do it in SqlYog (google it, there is a free version) but Navicat I cant stand.
Once you've connected to your database, you need to click on the world/ascent table on the left, then go into tables, and theres your database. To open one of the tables left click it then press table data in the middle of your screen. On the bottom right you have your data, and on the top right your query box. To execute some queries you controll and paste into there, then press the two arrows on the top left to execute. You will now know if it worked or not, i'll post some screenshots later.
Another way is to get it to try and execute it for you, right click on "Ascent" or "World" and press "Execute from sqldump". With the sql you found on the forums, paste it into notepad and save as a .sql file. Now choose that file on sqlyog and press execute.
Good luck!

Picture for sql executing:

http://i44.tinypic.com/xgk4uo.jpg

To get to the place, you have to ask where it is for the person who made it, then .recall there or .worldport map x y z

A portal stone isn't as simple as it sounds. You need to get the item that works; and a Lua that works. Search "teleport stone" or something and find a release. There are some out there.

[Aldun]

There are guides out there, but personally I can never find the one I want when I want it...
I'll tell you how to do it in SqlYog (google it, there is a free version) but Navicat I cant stand.
Once you've connected to your database, you need to click on the world/ascent table on the left, then go into tables, and theres your database. To open one of the tables left click it then press table data in the middle of your screen. On the bottom right you have your data, and on the top right your query box. To execute some queries you controll and paste into there, then press the two arrows on the top left to execute. You will now know if it worked or not, i'll post some screenshots later.
Another way is to get it to try and execute it for you, right click on "Ascent" or "World" and press "Execute from sqldump". With the sql you found on the forums, paste it into notepad and save as a .sql file. Now choose that file on sqlyog and press execute.
Good luck!

Thanks The Scarlet Hold works now as far as I can see.
However, what should I do with the Mall.rar file then?
The link of the Mall is http://www.mmowned.com/forums/emulat...rs-arcemu.html

[stoneharry]

Simple take the sql's you want out of the rar, then execute into your database the way I showed.
If you get errors; it's because he is out of date (databases change over time, that is an old post)