Jump to content
  • 0

Help with Sql


Dori

Question


  • Group:  Members
  • Topic Count:  105
  • Topics Per Day:  0.02
  • Content Count:  332
  • Reputation:   15
  • Joined:  12/11/11
  • Last Seen:  

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.

Link to comment
Share on other sites

9 answers to this question

Recommended Posts


  • Group:  Members
  • Topic Count:  9
  • Topics Per Day:  0.00
  • Content Count:  50
  • Reputation:   0
  • Joined:  01/27/12
  • Last Seen:  

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?

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  105
  • Topics Per Day:  0.02
  • Content Count:  332
  • Reputation:   15
  • Joined:  12/11/11
  • Last Seen:  

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 by Bagel
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  32
  • Topics Per Day:  0.01
  • Content Count:  386
  • Reputation:   28
  • Joined:  01/16/12
  • Last Seen:  

Do you recompile and restart after every update?

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  47
  • Topics Per Day:  0.01
  • Content Count:  633
  • Reputation:   78
  • Joined:  11/14/11
  • Last Seen:  

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

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  105
  • Topics Per Day:  0.02
  • Content Count:  332
  • Reputation:   15
  • Joined:  12/11/11
  • Last Seen:  

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.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  32
  • Topics Per Day:  0.01
  • Content Count:  386
  • Reputation:   28
  • Joined:  01/16/12
  • Last Seen:  

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.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  105
  • Topics Per Day:  0.02
  • Content Count:  332
  • Reputation:   15
  • Joined:  12/11/11
  • Last Seen:  

<<;;; yes i am saving.

My admin account is working fine.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  138
  • Topics Per Day:  0.03
  • Content Count:  835
  • Reputation:   25
  • Joined:  11/22/11
  • Last Seen:  

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.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  105
  • Topics Per Day:  0.02
  • Content Count:  332
  • Reputation:   15
  • Joined:  12/11/11
  • Last Seen:  

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 by Bagel
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...