Accueil Explorer Aide
S'inscrire Connexion
L2j
/
l2j-server-datapack
2
0
Fork 0
Fichiers Tickets 0 Pull Requests 0 Wiki
Aborescence: 5c0e373c5a
Branches Tags
l2j-server-data...
/
dist
/
sql
/
game
/
updates
/
20100922update.sql

20100922update.sql 2.2 KB
Historique Raw

1234567891011121314 
  1. -- Delete Male Soldier skills:
    2. 

  2. -- Ancient Sword Mastery, Strike Back, Dark Strike, Sword Shield, Rush, Disarm, Courage, Increase Power
    3. 

  3. -- from Female SoulBreakers/SoulHounds and Inspectors/Judicators (subclass only)
    4. 

  4. DELETE FROM character_skills WHERE skill_id IN (472, 475, 476, 483, 484, 485, 499, 1432) AND class_index = 0 AND charId IN ( SELECT charId FROM characters WHERE base_class IN (129, 133));
    5. 

  5. DELETE FROM character_skills WHERE skill_id IN (472, 475, 476, 483, 484, 485, 499, 1432) AND class_index = 1 AND charId IN ( SELECT charId FROM character_subclasses WHERE class_id IN (129, 133, 135, 136) AND class_index = 1);
    6. 

  6. DELETE FROM character_skills WHERE skill_id IN (472, 475, 476, 483, 484, 485, 499, 1432) AND class_index = 2 AND charId IN ( SELECT charId FROM character_subclasses WHERE class_id IN (129, 133, 135, 136) AND class_index = 2);
    7. 

  7. DELETE FROM character_skills WHERE skill_id IN (472, 475, 476, 483, 484, 485, 499, 1432) AND class_index = 3 AND charId IN ( SELECT charId FROM character_subclasses WHERE class_id IN (129, 133, 135, 136) AND class_index = 3);
    8. 

  8. -- Delete Male Soldier shortcuts:
    9. 

  9. -- Ancient Sword Mastery, Strike Back, Dark Strike, Sword Shield, Rush, Disarm, Courage, Increase Power
    10. 

  10. -- from Female SoulBreakers/SoulHounds and Inspectors/Judicators (subclass only)
    11. 

  11. DELETE FROM character_shortcuts WHERE shortcut_id IN (472, 475, 476, 483, 484, 485, 499, 1432) AND class_index = 0 AND charid IN ( SELECT charid FROM characters WHERE base_class IN (129, 133));
    12. 

  12. DELETE FROM character_shortcuts WHERE shortcut_id IN (472, 475, 476, 483, 484, 485, 499, 1432) AND class_index = 1 AND charid IN ( SELECT charid FROM character_subclasses WHERE class_id IN (129, 133, 135, 136) AND class_index = 1);
    13. 

  13. DELETE FROM character_shortcuts WHERE shortcut_id IN (472, 475, 476, 483, 484, 485, 499, 1432) AND class_index = 2 AND charid IN ( SELECT charid FROM character_subclasses WHERE class_id IN (129, 133, 135, 136) AND class_index = 2);
    14. 

  14. DELETE FROM character_shortcuts WHERE shortcut_id IN (472, 475, 476, 483, 484, 485, 499, 1432) AND class_index = 3 AND charid IN ( SELECT charid FROM character_subclasses WHERE class_id IN (129, 133, 135, 136) AND class_index = 3);
    15.