Help with Sql

[Dori]

Hi,

I'm using rAthena 15405 trunk and it runs on SQL. I'm fairly new to SQL (setting it up wise). I have never set it up by myself before. But I did it following a guide.

Anyway Server is up and running on sql fine. The problem now is, I don't know how to edit stuff and customize, because the server is not reading anything I edit. For example I edited the mob db.txt But when I go in-game the changes I made hasnt taken effect. Same goes for the atcommands and everything else.

I think I'm doing it wrong. Could someone please guide me on how to edit things after seting sql up? Thank you.

[rlt]

Did you restart the server after editing? if it is in src/, you need to recompile it.

What exactly are you editing in mob_dx.txt and atcommand_athena.conf?

Are you trying to make a new mob/command?

[Dori]

Did you restart the server after editing? if it is in src/, you need to recompile it.

What exactly are you editing in mob_dx.txt and atcommand_athena.conf?

Are you trying to make a new mob/command?

no no. I know about recompiling and all. These are just basic edits like, giving a new item to a poring or allowing certain @commands or editting a monster's hp. And yes I restart the server everytime I edit.

Like anything I edit doesn't seem to be taking effect except for src related stuff.

Edited February 3, 2012 by Bagel

[Sharpienero]

Do you recompile and restart after every update?

[JayPee]

you dont need to recompile your server when editting in db folder maybe your using SQL db files and also use @reloadmobdb for reloading mob database and @reloaditemdb for reloading item database

[Dori]

you dont need to recompile your server when editting in db folder maybe your using SQL db files and also use @reloadmobdb for reloading mob database and @reloaditemdb for reloading item database

o.o;; i know all that the problem is I can't sign any @commands to my character. Like I said in my earlier post anything I edit jus wont change.

[Sharpienero]

you dont need to recompile your server when editting in db folder maybe your using SQL db files and also use @reloadmobdb for reloading mob database and @reloaditemdb for reloading item database

o.o;; i know all that the problem is I can't sign any @commands to my character. Like I said in my earlier post anything I edit jus wont change.

Are you saving the document? Also, remember you have to change the desired GM level.

[Dori]

<<;;; yes i am saving.

My admin account is working fine.

[manabeast]

about edit item/mob

if your server are txt only can edit direct in txt. if your server are sql version then you can't edit your item_db/mob_db in txt. you need find item_db/mob_db.sql < must sql format. after edit reimport/re put in sql.

[Dori]

about edit item/mob

if your server are txt only can edit direct in txt. if your server are sql version then you can't edit your item_db/mob_db in txt. you need find item_db/mob_db.sql < must sql format. after edit reimport/re put in sql.

Ok now we're getting somewhere..

So how do I import these files to my sql?

EDIT: Ok so I think I'm just going to play around cuz I figured out now how to load the mob_db and item_db in to sql. If I run into a wall again I will ask for help. Thanks guys~

Edited February 3, 2012 by Bagel