How to create and Import Custom Things.

[Zopherus]

Hey there. I want to make some custom items for my server.
But I dont know what db I need to modify and with what program I'll
do that. I havent used any dbs for 3 or 4 years since my first server
and I dont remember a thing :/
So. The emulator is ArcEmu Repack v2.1.0 for 3.0.9. and I have windows Vista.
(I think it matters what OS im using)
Thanks in advance

[Sparta12]

Hey there. I want to make some custom items for my server.
But I dont know what db I need to modify and with what program I'll
do that. I havent used any dbs for 3 or 4 years since my first server
and I dont remember a thing :/
So. The emulator is ArcEmu Repack v2.1.0 for 3.0.9. and I have windows Vista.
(I think it matters what OS im using)
Thanks in advance

Ok, for starts you are going to need a database manager, such as, Navicat
Navicat Oracle, MySQL Admin Tool - the World's Best Oracle Manager, MySQL GUI & PostgreSQL GUI for Windows, Linux & Mac OS X - Download Now! Support Access to MySQL, Excel to MySQL, MySQL editor, MySQL administrator, MySQL frontend, MySQL manager, ph
After you instal it open the connection to your database and find the database in the column "World" Double click on it to make it active.
Once it is active goto WoW-V
WOW-V
Create an account and click the creator of the thing you want to make. IE Items to make items.
Use the tools provided to make the item. Click submit and from the selection box to the right, click download for ArcEmu.
After you download it go back to navicat, In navicat right click world and select the option. Execute Batch File. Now target the file that you downloaded from WOW-V (Your custom item) , After you target it, click execute. Restart server and clear your cache.

[Zopherus]

Ok, for starts you are going to need a database manager, such as, Navicat
Navicat Oracle, MySQL Admin Tool - the World's Best Oracle Manager, MySQL GUI & PostgreSQL GUI for Windows, Linux & Mac OS X - Download Now! Support Access to MySQL, Excel to MySQL, MySQL editor, MySQL administrator, MySQL frontend, MySQL manager, ph
After you instal it open the connection to your database and find the database in the column "World" Double click on it to make it active.
Once it is active goto WoW-V
WOW-V
Create an account and click the creator of the thing you want to make. IE Items to make items.
Use the tools provided to make the item. Click submit and from the selection box to the right, click download for ArcEmu.
After you download it go back to navicat, In navicat right click world and select the option. Execute Batch File. Now target the file that you downloaded from WOW-V (Your custom item) , After you target it, click execute. Restart server and clear your cache.

I intalled navicat and I created a New connection. Inside that connection
how do I input the world database from emulator directory?
Because I found out about the item creation and about the batch file.
But I still dont get it how do i import it to the actual wow emu db. :/
(A bit noob )

[1ns0mnia]

right click you conenct > new database
call it wow
click click on the database wow and go to arcemu > sql > and there will be 3 structure SQL's (world, char and logon) execute all 3 of them 1 by one into the db, gratz youve got your structure.
now you need a database, these can be found all over, for example NCDB, Project Silvermoon etc, it all depends on what EMU you are using. there will be a big SQL called world o databse or somthing, you do what you did to the 3 structure to this, (right click the database > execute batch file and select it)
once its done you will have a database


p.s. you can also make 2 databases, one for the world structure and 1 for the char/logon structture, then execute the database on the world one, but i find it easier to put them all in 1 big database

p.s.s. sorry for the spelling mistakes, its 4am and i rushed it :P

[Zopherus]

right click you conenct > new database
call it wow
click click on the database wow and go to arcemu > sql > and there will be 3 structure SQL's (world, char and logon) execute all 3 of them 1 by one into the db, gratz youve got your structure.
now you need a database, these can be found all over, for example NCDB, Project Silvermoon etc, it all depends on what EMU you are using. there will be a big SQL called world o databse or somthing, you do what you did to the 3 structure to this, (right click the database > execute batch file and select it)
once its done you will have a database


p.s. you can also make 2 databases, one for the world structure and 1 for the char/logon structture, then execute the database on the world one, but i find it easier to put them all in 1 big database

p.s.s. sorry for the spelling mistakes, its 4am and i rushed it :P

Hmm. I created the database "World" but I cant find anywhere these three
sql structures. I also tried "search" for .sql formats and there isnt anything.
Although I found the files but I tried dragging them on "world" db and nothing
happened.
Maybe its the time because I havent slept for 25hours or Im stupid :/

[coldmrn]

DUDE, your background is mirror's edge right?!

I WANT THAT SO BAD OH MY GOD!

Please tell me where I can get it, ill +3 rep you lol

Sorry its offtopic but its fking ownage!!!

[Zopherus]

DUDE, your background is mirror's edge right?!

I WANT THAT SO BAD OH MY GOD!

Please tell me where I can get it, ill +3 rep you lol

Sorry its offtopic but its fking ownage!!!

:P ok ok chill out xD
here you go ^____^

Mirror Pictures, Mirror Images, Mirror Photos, Mirror Videos - Image - TinyPic - Free Image Hosting, Photo Sharing & Video Hosting

[1ns0mnia]

ah, your using a repack so all the directories are different, your looking for these 3 files..

http://img14.imageshack.us/img14/2407/directory.jpg

[Zopherus]

ah, your using a repack so all the directories are different, your looking for these 3 files..

http://img14.imageshack.us/img14/2407/directory.jpg

Nice. I found it. Although I did it a bit differently.
I just needed to Unistall SQL server. Because it was creating an instance
of the db and Navicat couldt find the actual db :P
Btw nice skin
+Rep because u helped me a bit ^____^