Jump to content
  • 0

Materials Drop


Itachi
 Share

Question

Hey guys , does some1 know how to make it DONT drop materials?

 

i know that there is a "code" to writte in 1 of the Server\GameServer\Config\ but i dunno the code...

 

can some1 tell me a code or a way to do that?

 

thanks  :P

Link to comment
Share on other sites

Recommended Posts

  • 0

u can delete the droplist table from navicat and then import the drop that u want to the mobs u want..

 

Edit: i guess i got the point, go to gameserver/config/altsettings and find this:

 

# AutoLoot enable. True to enable, False to disable

AutoLoot = False

 

Change it to True

Link to comment
Share on other sites

  • 0

i mean...

 

how do i make the mobs NOT DROP any kind of material...

 

The first way is that Extremedwarf said to you but there is also another way easier than the first.

 

Shift + Left click on the mob --> Show Droplist and from there you can see and delete the materials that you want.

Link to comment
Share on other sites

  • 0

Make new sql file ... for example something like:

 

DELETE FROM `tablename` WHERE id=ITEM ID;

 

In tablename i mean it should be droplist table.

 

The fastest way to delete all unnecessary drops from droplist.

 

Link to comment
Share on other sites

  • 0

What's the difference ... use my SQL code and you're done..

 

DELETE FROM `tablename` WHERE id=ITEM ID;

 

In tablename i mean it should be droplist table.

 

 

the same result

Link to comment
Share on other sites

  • 0

Matim is there any way to erase all except the adena(57)?

 

cuz if i am to writte all id's i wont finish writting them not even tomorrow xD

thanks :D

 

Huh...im not sure..;D It should be something delete Alll where id != 57 xD But its SQL...hmm i will try to find something ^^

Link to comment
Share on other sites

  • 0

I have only somthing like this:

 

DELETE FROM `tablename` WHERE `id` > 57

 

so it will delete all drops with id higher than 57

 

and than use:

 

DELETE FROM `tablename` WHERE `id` < 57

 

so it will delete all drops with id lower than 57..

 

and i think it should work ^^ but im nor sure

Link to comment
Share on other sites

  • 0

it gives me a error ;/

 

"[Err] 1054 - Unknown column 'id' in 'where clause'

[Err] DELETE FROM `droplist` WHERE `id` > 57

[Msg] Finished - Unsuccessfully

--------------------------------------------------"

Link to comment
Share on other sites

  • 0

change the id with itemId

 

Something like that:

 

 

DELETE FROM `tablename` WHERE `itemId` > 57

 

 

and then use:

 

DELETE FROM `tablename` WHERE `itemId` < 57

 

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.

 Share



  • Posts

    • Promotional banners:  
    • We have added few new features for Second Edition of L2Etina. Check them out:   While streaming L2Etina, you will now receive L2Coins automatically.   Dwarves who have set private workshop, now automatically sell Crystallization to nearby players. For this service, they receive 10% of created crystals.   Before closing game, you will now see amount of earned experience, adena, total play time and acquired items.   You can now check Ranking of current and previous edition. This window can be found in Main Menu.   Party Window now have a special spot, showing if member has Noble Blessing.   Players from South America will be able to connect to the server by proxy.   Players who have supported first edition by donation, will now 2 weeks of free premium.   We have rewritten description of every buff, so they are now clear and handy. Vote rewards will be different for new edition, but exact items are not decided yet.   When spoil is successfull, you will now see special popup window. When you target monster who has been spoiled, you will see Spoil as a debuff.   Buff Store now have possibility to refuse to buff someone. Retail version of party matching was added back. Offline private stores now automatically disappear after 5 days. There are plenty more improvements and fixes, like ability to disable skill bar, multiple fixes to epic bosses, adjustments to aggro.
    • First of all thank you for fast answer. I have changed internal as you said but didn't work sir.
    • The difference isn't paying upfront or at the end of each week. The major difference is that paying clans to join, leads to leaders making random weak sides who play just for money and creates an extremely toxic fake competition in-game (i.e. l2 dex, e-global, valhalla and this kind of servers). Paying clans just to join absolutely kills the rivalry between them as there are no real losers and winners. Everyone gets paid at the end of every week so who cares right ?   Rewarding the winners with cash gives a massive motive to the leaders to create strong sides and try their best to win without giving any advantage to any clan (unlike paying people to join and basically giving them free premiums and whatnot). In this case, there will always be losers and winners and the rivalry will be kept alive.   I hope that clears up the massive difference between the 2 scenarios. Look at all those big russian servers. No1 makes fraps flaming about which side is better. Everyone cares about daily 9v9s or organized ones. There is no clan identity anymore because leaders simply don't care. They have been so detached from the clan's identity that most of the times the leader's CP holds a different name to the side's. This is a very important point to think about. 
  • Topics

×
×
  • Create New...

AdBlock Extension Detected!

Our website is made possible by displaying online advertisements to our members.

Please disable AdBlock browser extension first, to be able to use our community.

I've Disbaled AdBlock