Skip to content

need sql script.

Featured Replies

i need sql script to change droplist of raidbosses, I mean i want to change all raidbosses weapons/armors etc drop chance :) because config rates configuration don't help, raids droping alot of parts and mostly no weapons/armors ;/

 

p.s i can send if u need 200-300adena for help :D

We need more info about what this sql should update etc.

 

you have to use something like:

 

UPDATE 'column_name' WHERE something = something etc...

  • Author

i need script which would drop from npc all raidbosses ID.Script would execute in droplist with raidboss id and would change items drop chance of thies raidbosses :)

 

im talking about increasing chance of droping items of all raidbosses :)

try this...

UPDATE droplist SET chance = x WHERE itemId = x AND mobId IN (SELECT mobId FROM npc WHERE type = 'L2RaidBoss');

  • Author

but when u would have to put item id one by one, it would cost a lot of time ;)

[EDIT]

try those...

UPDATE droplist SET chance = x WHERE mobId IN (SELECT mobId FROM npc WHERE type = 'L2RaidBoss') and itemId IN (SELECT itemId FROM weapon WHERE item_id);

UPDATE droplist SET chance = x WHERE mobId IN (SELECT mobId FROM npc WHERE type = 'L2RaidBoss') and itemId IN (SELECT itemId FROM armor WHERE item_id);

  • Author

when excecute ;/

 

 

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' SELECT itemId FROM armor WHERE itemid)' at line 1

[Err] UPDATE droplist SET chance = 700000 WHERE itemId AND mobId IN (SELECT mobId FROM npc WHERE type = 'L2RaidBoss', SELECT itemId FROM armor WHERE itemid);

[Msg] Finished - Unsuccessfully

W8.. i gotta find out whats wrong

Leno , your sql file is corrupted.

 

Try to install it manually.

UPDATE droplist SET chance = x WHERE itemId = x AND mobId IN (SELECT mobId FROM npc WHERE type = 'L2RaidBoss');

use this..

Just add itemId of the wep u wanna increase his chance, it's very hard

Create an account or sign in to comment

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.