Startseite Erkunden Hilfe
Registrieren Anmelden
L2j
/
l2j-server-datapack
2
0
Fork 0
Dateien Issues 0 Pull-Requests 0 Wiki
Struktur: 5c0e373c5a
Branches Tags
l2j-server-data...
/
dist
/
sql
/
game
/
updates
/
20100914update.sql

20100914update.sql 1.5 KB
Verlauf Originalformat

12345678910 
  1. -- Delete incorrect Dwarven Craft skill
    2. 

  2. DELETE FROM character_skills WHERE skill_id = 1321 AND class_index = 0 AND charId NOT IN ( SELECT charId FROM characters WHERE base_class IN (53, 54, 55, 56, 57, 117, 118));
    3. 

  3. DELETE FROM character_skills WHERE skill_id = 1321 AND class_index = 1 AND charId NOT IN ( SELECT charId FROM character_subclasses WHERE class_id IN (55, 117) AND class_index = 1);
    4. 

  4. DELETE FROM character_skills WHERE skill_id = 1321 AND class_index = 2 AND charId NOT IN ( SELECT charId FROM character_subclasses WHERE class_id IN (55, 117) AND class_index = 2);
    5. 

  5. DELETE FROM character_skills WHERE skill_id = 1321 AND class_index = 3 AND charId NOT IN ( SELECT charId FROM character_subclasses WHERE class_id IN (55, 117) AND class_index = 3);
    6. 

  6. -- Delete incorrect Dwarven Craft shortcuts
    7. 

  7. DELETE FROM character_shortcuts WHERE shortcut_id = 1321 AND class_index = 0 AND charid NOT IN ( SELECT charid FROM characters WHERE base_class IN (53, 54, 55, 56, 57, 117, 118));
    8. 

  8. DELETE FROM character_shortcuts WHERE shortcut_id = 1321 AND class_index = 1 AND charid NOT IN ( SELECT charid FROM character_subclasses WHERE class_id IN (55, 117) AND class_index = 1);
    9. 

  9. DELETE FROM character_shortcuts WHERE shortcut_id = 1321 AND class_index = 2 AND charid NOT IN ( SELECT charid FROM character_subclasses WHERE class_id IN (55, 117) AND class_index = 2);
    10. 

  10. DELETE FROM character_shortcuts WHERE shortcut_id = 1321 AND class_index = 3 AND charid NOT IN ( SELECT charid FROM character_subclasses WHERE class_id IN (55, 117) AND class_index = 3);
    11.