Jump to content
  • 0

SQL command to


Damid

Question


  • Group:  Members
  • Topic Count:  9
  • Topics Per Day:  0.00
  • Content Count:  15
  • Reputation:   0
  • Joined:  06/20/14
  • Last Seen:  

take away every drop and make every mob have 0 items?

Link to comment
Share on other sites

4 answers to this question

Recommended Posts


  • Group:  Forum Moderator
  • Topic Count:  93
  • Topics Per Day:  0.02
  • Content Count:  10015
  • Reputation:   2348
  • Joined:  10/28/11
  • Last Seen:  

then just update the column for each drop id and rate to 0.

UPDATE `mob_db` SET `column1` = 0,`column2` = 0,`column3` = 0,`column4` = 0,`column5` = 0;
  • Upvote 1
Link to comment
Share on other sites


  • Group:  Forum Moderator
  • Topic Count:  93
  • Topics Per Day:  0.02
  • Content Count:  10015
  • Reputation:   2348
  • Joined:  10/28/11
  • Last Seen:  

why not just set your drop rate to 0 ?? inside the conf/battle/drops.conf

 

change all the "MAX" drop rate to 0.

  • Upvote 1
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  9
  • Topics Per Day:  0.00
  • Content Count:  15
  • Reputation:   0
  • Joined:  06/20/14
  • Last Seen:  

I want to make every mob have 0 loot and then I want to add some on some other mobs :/

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  9
  • Topics Per Day:  0.00
  • Content Count:  15
  • Reputation:   0
  • Joined:  06/20/14
  • Last Seen:  

Thanks!

 

@Edit

 

1 more doubt that I hope can be solved here. Can I change the emulator to make the configuration "use_sql_db" read only the mob_db on SQL?

 

@Edit2

 

Nevermind. Solved!

Edited by Damid
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...