Форум администраторов игровых серверов

Форум администраторов игровых серверов (https://forum.zone-game.info/TT.php)
-   Работа со скриптами (https://forum.zone-game.info/forumdisplay.php?f=37)
-   -   Проблема с Профами (https://forum.zone-game.info/showthread.php?t=5198)

skil 09.11.2009 16:14
Проблема с Профами
 
привет, у тх нету одново скила (шадов степ) как это исправить?

lanevo 09.11.2009 16:47
Re: Проблема с Профами
 
Превед! Поиск для дураков?

Код:
INSERT INTO skill_trees VALUES (8, 821, 1, "Shadow Step", 0, 72);
INSERT INTO skill_trees VALUES (23, 821, 1, "Shadow Step", 0, 72);
INSERT INTO skill_trees VALUES (36, 821, 1, "Shadow Step", 0, 72);

CoKoJI 27.01.2010 23:23
Re: Проблема с Профами
 
тут вроде все скилы который добавленны на грации финале
[SPOILER]INSERT INTO `skill_trees` (`class_id`, `skill_id`, `level`, `name`, `sp`, `min_level`) VALUES
# DUELIST
(88, 759, 1, 'Archers Will', 0, 81),
(88, 767, 1, 'Expose Weak Point', 0, 81),
(88, 758, 1, 'Fighter Will', 0, 81),
(88, 917, 1, 'Final Secret', 0, 81),
(88, 757, 1, 'Protection of Alignment', 0, 82),
(88, 756, 1, 'Protection of Elemental', 0, 82),
(88, 755, 1, 'Protection of Rune', 0, 82),
(88, 919, 1, 'Maximum Focus Sonic', 0, 83),
(88, 775, 1, 'Weapon Blockade', 0, 83),
# DREADNOUGHT
(89, 759, 1, 'Archers Will', 0, 81),
(89, 767, 1, 'Expose Weak Point', 0, 81),
(89, 758, 1, 'Fighter Will', 0, 81),
(89, 917, 1, 'Final Secret', 0, 81),
(89, 757, 1, 'Protection of Alignment', 0, 82),
(89, 756, 1, 'Protection of Elemental', 0, 82),
(89, 755, 1, 'Protection of Rune', 0, 82),
(89, 774, 1, 'Dread Pool', 0, 83),
# PHOENIX KNIGHT
(90, 759, 1, 'Archers Will', 0, 81),
(90, 760, 1, 'Anti Magic Armor', 0, 81),
(90, 758, 1, 'Fighter Will', 0, 81),
(90, 913, 1, 'Deflect Magic', 0, 81),
(90, 766, 1, 'Sixth Sense', 0, 81),
(90, 757, 1, 'Protection of Alignment', 0, 82),
(90, 756, 1, 'Protection of Elemental', 0, 82),
(90, 755, 1, 'Protection of Rune', 0, 82),
(90, 785, 1, 'Flame Icon', 0, 83),
(90, 784, 1, 'Spirit of Phoenix', 0, 83),
(90, 912, 1, 'Summon Imperial Phoenix', 0, 83),
# HELL KNIGHT
(91, 759, 1, 'Archers Will', 0, 81),
(91, 760, 1, 'Anti Magic Armor', 0, 81),
(91, 758, 1, 'Fighter Will', 0, 81),
(91, 913, 1, 'Deflect Magic', 0, 81),
(91, 766, 1, 'Sixth Sense', 0, 81),
(91, 757, 1, 'Protection of Alignment', 0, 82),
(91, 756, 1, 'Protection of Elemental', 0, 82),
(91, 755, 1, 'Protection of Rune', 0, 82),
(91, 763, 1, 'Hell Scream', 0, 83),
(91, 761, 1, 'Seed of Revenge', 0, 83),
(91, 762, 1, 'Insane Crusher', 0, 83),
# TREASURE HUNTER / ADVENTURER
(8, 821, 1, 'Shadow Step', 0, 72),
(8, 820, 1, 'Evasion Haste', 0, 74),
(93, 759, 1, 'Archers Will', 0, 81),
(93, 758, 1, 'Fighter Will', 0, 81),
(93, 767, 1, 'Expose Weak Point', 0, 81),
(93, 766, 1, 'Sixth Sense', 0, 81),
(93, 922, 1, 'Hide', 0, 81),
(93, 923, 1, 'Dual Dagger Mastery', 0, 81),
(93, 757, 1, 'Protection of Alignment', 0, 82),
(93, 756, 1, 'Protection of Elemental', 0, 82),
(93, 755, 1, 'Protection of Rune', 0, 82),
(93, 768, 1, 'Exciting Adventure', 0, 83),
# SAGITTARIUS
(92, 759, 1, 'Archers Will', 0, 81),
(92, 758, 1, 'Fighter Will', 0, 81),
(92, 924, 1, 'Seven Arrow', 0, 81),
(92, 946, 1, 'Silent Mind', 0, 81),
(92, 757, 1, 'Protection of Alignment', 0, 82),
(92, 756, 1, 'Protection of Elemental', 0, 82),
(92, 755, 1, 'Protection of Rune', 0, 82),
(92, 771, 1, 'Flame Hawk', 0, 83),
# ARCHMAGE
(94, 1532, 1, 'Enlightenment', 0, 81),
(94, 945, 1, 'Magicians Will', 0, 81),
(94, 1467, 1, 'Meteor', 0, 81),
(94, 757, 1, 'Protection of Alignment', 0, 82),
(94, 756, 1, 'Protection of Elemental', 0, 82),
(94, 755, 1, 'Protection of Rune', 0, 82),
(94, 1492, 1, 'Flame Armor', 0, 83),
# SOULTAKER
(95, 1532, 1, 'Enlightenment', 0, 81),
(95, 945, 1, 'Magicians Will', 0, 81),
(95, 1467, 1, 'Meteor', 0, 81),
(95, 757, 1, 'Protection of Alignment', 0, 82),
(95, 756, 1, 'Protection of Elemental', 0, 82),
(95, 755, 1, 'Protection of Rune', 0, 82),
(95, 1495, 1, 'Vampiric Mist', 0, 83),
#ARCANA LORD
(96, 1497, 1, 'Excessive Loyalty', 0, 81),
(96, 945, 1, 'Magicians Will', 0, 81),
(96, 1498, 1, 'Mutual Response', 0, 81),
(96, 1496, 1, 'Servitor Barrier', 0, 81),
(96, 757, 1, 'Protection of Alignment', 0, 82),
(96, 756, 1, 'Protection of Elemental', 0, 82),
(96, 755, 1, 'Protection of Rune', 0, 82),
(95, 929, 1, 'Spirit of the Cat', 0, 83),
# CARDINAL
(97, 1533, 1, 'Enlightenment', 0, 81),
(97, 945, 1, 'Magicians Will', 0, 81),
(97, 1540, 1, 'Turn to Stone', 0, 81),
(97, 757, 1, 'Protection of Alignment', 0, 82),
(97, 756, 1, 'Protection of Elemental', 0, 82),
(97, 755, 1, 'Protection of Rune', 0, 82),
(97, 1505, 1, 'Sublime Self-Sacrifice', 0, 83),
# PROPHET / HIEROPHANT
(17, 1499, 1, 'Improved Combat', 0, 70),
(17, 1501, 1, 'improved Condition', 0, 70),
(98, 1533, 1, 'Enlightenment', 0, 81),
(98, 945, 1, 'Magicians Will', 0, 81),
(98, 1540, 1, 'Turn to Stone', 0, 81),
(98, 757, 1, 'Protection of Alignment', 0, 82),
(98, 756, 1, 'Protection of Elemental', 0, 82),
(98, 755, 1, 'Protection of Rune', 0, 82),
(98, 1542, 1, 'Counter Critical', 0, 83),
# EVAS TEMPLAR
(99, 759, 1, 'Archers Will', 0, 81),
(99, 760, 1, 'Anti Magic Armor', 0, 81),
(99, 758, 1, 'Fighter Will', 0, 81),
(99, 913, 1, 'Deflect Magic', 0, 81),
(99, 766, 1, 'Sixth Sense', 0, 81),
(99, 757, 1, 'Protection of Alignment', 0, 82),
(99, 756, 1, 'Protection of Elemental', 0, 82),
(99, 755, 1, 'Protection of Rune', 0, 82),
(99, 786, 1, 'Evas Will', 0, 83),
(99, 787, 1, 'Touch of Eva', 0, 83),
# SWORDMUSE
(100, 759, 1, 'Archers Will', 0, 81),
(100, 758, 1, 'Fighter Will', 0, 81),
(100, 913, 1, 'Deflect Magic', 0, 81),
(100, 766, 1, 'Sixth Sense', 0, 81),
(100, 757, 1, 'Protection of Alignment', 0, 82),
(100, 756, 1, 'Protection of Elemental', 0, 82),
(100, 755, 1, 'Protection of Rune', 0, 82),
(100, 914, 1, 'Song of Purification', 0, 83),
# PLAINSWALKER / WIND RAIDER
(23, 821, 1, 'Shadow Step', 0, 72),
(23, 819, 1, 'Evasion Chance', 0, 74),
(101, 759, 1, 'Archers Will', 0, 81),
(101, 758, 1, 'Fighter Will', 0, 81),
(101, 767, 1, 'Expose Weak Point', 0, 81),
(101, 766, 1, 'Sixth Sense', 0, 81),
(101, 922, 1, 'Hide', 0, 81),
(101, 923, 1, 'Dual Dagger Mastery', 0, 81),
(101, 757, 1, 'Protection of Alignment', 0, 82),
(101, 756, 1, 'Protection of Elemental', 0, 82),
(101, 755, 1, 'Protection of Rune', 0, 82),
(101, 769, 1, 'Wind Riding', 0, 83),
# MOONLIGHT SENTINEL
(102, 759, 1, 'Archers Will', 0, 81),
(102, 758, 1, 'Fighter Will', 0, 81),
(102, 924, 1, 'Seven Arrow', 0, 81),
(102, 946, 1, 'Silent Mind', 0, 81),
(102, 757, 1, 'Protection of Alignment', 0, 82),
(102, 756, 1, 'Protection of Elemental', 0, 82),
(102, 755, 1, 'Protection of Rune', 0, 82),
(102, 772, 1, 'Arrow Rain', 0, 83),
# MYSTIC MUSE
(103, 1532, 1, 'Enlightenment', 0, 81),
(103, 945, 1, 'Magicians Will', 0, 81),
(103, 1468, 1, 'Star Fall', 0, 81),
(103, 757, 1, 'Protection of Alignment', 0, 82),
(103, 756, 1, 'Protection of Elemental', 0, 82),
(103, 755, 1, 'Protection of Rune', 0, 82),
(103, 1493, 1, 'Frost Armor', 0, 83),
# ELEMENTAL MASTER
(104, 1497, 1, 'Excessive Loyalty', 0, 81),
(104, 945, 1, 'Magicians Will', 0, 81),
(104, 1498, 1, 'Mutual Response', 0, 81),
(104, 1496, 1, 'Servitor Barrier', 0, 81),
(104, 757, 1, 'Protection of Alignment', 0, 82),
(104, 756, 1, 'Protection of Elemental', 0, 82),
(104, 755, 1, 'Protection of Rune', 0, 82),
(104, 931, 1, 'Spirit of the Unicorn', 0, 83),
# ELVEN ELDER / EVA SAINT
(30, 1504, 1, 'Improved Movement', 0, 70),
(30, 1503, 1, 'improved Shield Defense', 0, 70),
(105, 1533, 1, 'Enlightenment', 0, 81),
(105, 945, 1, 'Magicians Will', 0, 81),
(105, 1540, 1, 'Turn to Stone', 0, 81),
(105, 757, 1, 'Protection of Alignment', 0, 82),
(105, 756, 1, 'Protection of Elemental', 0, 82),
(105, 755, 1, 'Protection of Rune', 0, 82),
(105, 1506, 1, 'Blessing of Eva', 0, 83),
# SHILLIEN TEMPLAR
(106, 759, 1, 'Archers Will', 0, 81),
(106, 760, 1, 'Anti Magic Armor', 0, 81),
(106, 758, 1, 'Fighter Will', 0, 81),
(106, 913, 1, 'Deflect Magic', 0, 81),
(106, 766, 1, 'Sixth Sense', 0, 81),
(106, 757, 1, 'Protection of Alignment', 0, 82),
(106, 756, 1, 'Protection of Elemental', 0, 82),
(106, 755, 1, 'Protection of Rune', 0, 82),
(106, 788, 1, 'Pain of Shilen', 0, 83),
(106, 789, 1, 'Spirit of Shilen', 0, 83),
# SPECTRAL DANCER
(107, 759, 1, 'Archers Will', 0, 81),
(107, 758, 1, 'Fighter Will', 0, 81),
(107, 913, 1, 'Deflect Magic', 0, 81),
(107, 766, 1, 'Sixth Sense', 0, 81),
(107, 757, 1, 'Protection of Alignment', 0, 82),
(107, 756, 1, 'Protection of Elemental', 0, 82),
(107, 755, 1, 'Protection of Rune', 0, 82),
(107, 915, 1, 'Dance of Berserker', 0, 83),
# ABISS WALKER / GHOST HUNTER
(36, 821, 1, 'Shadow Step', 0, 72),
(36, 818, 1, 'Evasion COUNTER', 0, 74),
(108, 759, 1, 'Archers Will', 0, 81),
(108, 758, 1, 'Fighter Will', 0, 81),
(108, 767, 1, 'Expose Weak Point', 0, 81),
(108, 766, 1, 'Sixth Sense', 0, 81),
(108, 922, 1, 'Hide', 0, 81),
(108, 923, 1, 'Dual Dagger Mastery', 0, 81),
(108, 757, 1, 'Protection of Alignment', 0, 82),
(108, 756, 1, 'Protection of Elemental', 0, 82),
(108, 755, 1, 'Protection of Rune', 0, 82),
(108, 770, 1, 'Ghost Walking', 0, 83),
# GHOST SENTINEL
(109, 759, 1, 'Archers Will', 0, 81),
(109, 758, 1, 'Fighter Will', 0, 81),
(109, 924, 1, 'Seven Arrow', 0, 81),
(109, 946, 1, 'Silent Mind', 0, 81),
(109, 757, 1, 'Protection of Alignment', 0, 82),
(109, 756, 1, 'Protection of Elemental', 0, 82),
(109, 755, 1, 'Protection of Rune', 0, 82),
(109, 773, 1, 'Ghost Piercing', 0, 83),
# STORM SCREAMER
(110, 1532, 1, 'Enlightenment', 0, 81),
(110, 945, 1, 'Magicians Will', 0, 81),
(110, 1468, 1, 'Star fall', 0, 81),
(110, 757, 1, 'Protection of Alignment', 0, 82),
(110, 756, 1, 'Protection of Elemental', 0, 82),
(110, 755, 1, 'Protection of Rune', 0, 82),
(110, 1494, 1, 'Hurricane Armor', 0, 83),
# SPECTRAL MASTER
(111, 1497, 1, 'Excessive Loyalty', 0, 81),
(111, 945, 1, 'Magicians Will', 0, 81),
(111, 1498, 1, 'Mutual Response', 0, 81),
(111, 1496, 1, 'Servitor Barrier', 0, 81),
(111, 757, 1, 'Protection of Alignment', 0, 82),
(111, 756, 1, 'Protection of Elemental', 0, 82),
(111, 755, 1, 'Protection of Rune', 0, 82),
(111, 930, 1, 'Spirit of the Demon', 0, 83),
# SHILLIEN ELDER / SHILLIEN SAINT
(43, 1502, 1, 'Improved Critical Attack', 0, 70),
(43, 1500, 1, 'improved Magic', 0, 70),
(112, 1533, 1, 'Enlightenment', 0, 81),
(112, 945, 1, 'Magicians Will', 0, 81),
(112, 1540, 1, 'Turn to Stone', 0, 81),
(112, 757, 1, 'Protection of Alignment', 0, 82),
(112, 756, 1, 'Protection of Elemental', 0, 82),
(112, 755, 1, 'Protection of Rune', 0, 82),
(112, 1507, 1, 'Lord of Vampire', 0, 83),
# TITAN
(113, 759, 1, 'Archers Will', 0, 81),
(113, 767, 1, 'Expose Weak Point', 0, 81),
(113, 758, 1, 'Fighter Will', 0, 81),
(113, 917, 1, 'Final Secret', 0, 81),
(113, 757, 1, 'Protection of Alignment', 0, 82),
(113, 756, 1, 'Protection of Elemental', 0, 82),
(113, 755, 1, 'Protection of Rune', 0, 82),
(113, 777, 1, 'Demolition Impact', 0, 83),
# GRAND KHAVATARI
(114, 759, 1, 'Archers Will', 0, 81),
(114, 767, 1, 'Expose Weak Point', 0, 81),
(114, 758, 1, 'Fighter Will', 0, 81),
(114, 917, 1, 'Final Secret', 0, 81),
(114, 757, 1, 'Protection of Alignment', 0, 82),
(114, 756, 1, 'Protection of Elemental', 0, 82),
(114, 755, 1, 'Protection of Rune', 0, 82),
(114, 776, 1, 'Force of Destruction', 0, 83),
(114, 918, 1, 'Maximum Focus Force', 0, 83),
# OVERLORD / DOMINATOR
(51, 1536, 1, 'Combat of Paagrio', 0, 70),
(51, 1538, 1, 'Condition of Paagrio', 0, 72),
(51, 1537, 1, 'Critical of Paagrio', 0, 74),
(115, 1533, 1, 'Enlightenment', 0, 81),
(115, 945, 1, 'Magicians Will', 0, 81),
(115, 1540, 1, 'Turn to Stone', 0, 81),
(115, 757, 1, 'Protection of Alignment', 0, 82),
(115, 756, 1, 'Protection of Elemental', 0, 82),
(115, 755, 1, 'Protection of Rune', 0, 82),
(115, 949, 1, 'Onslaught of Paagrio', 0, 83),
(115, 1509, 1, 'Seal of Limit', 0, 83),
# WARCRYER / DOOMCRYER
(52, 1517, 1, 'Chant of Combat', 0, 70),
(52, 1518, 1, 'Chant of Critical Attack', 0, 72),
(52, 1535, 1, 'Chant of Movement', 0, 72),
(52, 1519, 1, 'Chant of Blood Awakening', 0, 74),
(116, 1533, 1, 'Enlightenment', 0, 81),
(116, 945, 1, 'Magicians Will', 0, 81),
(116, 1540, 1, 'Turn to Stone', 0, 81),
(116, 757, 1, 'Protection of Alignment', 0, 82),
(116, 756, 1, 'Protection of Elemental', 0, 82),
(116, 755, 1, 'Protection of Rune', 0, 82),
(116, 1543, 1, 'Great Fury', 0, 83),
# FORTUNE SEEKER
(117, 759, 1, 'Archers Will', 0, 81),
(117, 767, 1, 'Expose Weak Point', 0, 81),
(117, 758, 1, 'Fighter Will', 0, 81),
(117, 917, 1, 'Final Secret', 0, 81),
(117, 757, 1, 'Protection of Alignment', 0, 82),
(117, 756, 1, 'Protection of Elemental', 0, 82),
(117, 755, 1, 'Protection of Rune', 0, 82),
(117, 947, 1, 'Lucky Strike', 0, 83),
# MAESTRO
(118, 759, 1, 'Archers Will', 0, 81),
(118, 767, 1, 'Expose Weak Point', 0, 81),
(118, 758, 1, 'Fighter Will', 0, 81),
(118, 917, 1, 'Final Secret', 0, 81),
(118, 757, 1, 'Protection of Alignment', 0, 82),
(118, 756, 1, 'Protection of Elemental', 0, 82),
(118, 755, 1, 'Protection of Rune', 0, 82),
(118, 778, 1, 'Golem Armor', 0, 83),
# DOOMBRINGER
(131, 759, 1, 'Archers Will', 0, 81),
(131, 767, 1, 'Expose Weak Point', 0, 81),
(131, 758, 1, 'Fighter Will', 0, 81),
(131, 917, 1, 'Final Secret', 0, 81),
(131, 757, 1, 'Protection of Alignment', 0, 82),
(131, 756, 1, 'Protection of Elemental', 0, 82),
(131, 755, 1, 'Protection of Rune', 0, 82),
(131, 948, 1, 'Eye for Eye', 0, 83),
# SOUL HOUND
(132, 759, 1, 'Archers Will', 0, 81),
(132, 758, 1, 'Fighter Will', 0, 81),
(132, 767, 1, 'Expose Weak Point', 0, 81),
(132, 766, 1, 'Sixth Sense', 0, 81),
(132, 1532, 1, 'Enlightenment', 0, 81),
(132, 757, 1, 'Protection of Alignment', 0, 82),
(132, 756, 1, 'Protection of Elemental', 0, 82),
(132, 755, 1, 'Protection of Rune', 0, 82),
(132, 791, 1, 'Lightning Shock', 0, 83),
# SOUL HOUND
(133, 759, 1, 'Archers Will', 0, 81),
(133, 758, 1, 'Fighter Will', 0, 81),
(133, 767, 1, 'Expose Weak Point', 0, 81),
(133, 766, 1, 'Sixth Sense', 0, 81),
(133, 1532, 1, 'Enlightenment', 0, 81),
(133, 757, 1, 'Protection of Alignment', 0, 82),
(133, 756, 1, 'Protection of Elemental', 0, 82),
(133, 755, 1, 'Protection of Rune', 0, 82),
(133, 791, 1, 'Lightning Shock', 0, 83),
# TRICKSTER
(134, 759, 1, 'Archers Will', 0, 81),
(134, 758, 1, 'Fighter Will', 0, 81),
(134, 757, 1, 'Protection of Alignment', 0, 82),
(134, 756, 1, 'Protection of Elemental', 0, 82),
(134, 755, 1, 'Protection of Rune', 0, 82),
(134, 790, 1, 'Wild Shot', 0, 83);[/SPOILER]

IGROMI 21.07.2010 03:03
Re: Проблема с Профами
 
ОООГРОМНОЕ спасибо Вашему порталу что он есть.Пол ночи мучился чтобы Shadow Step добавить,SQL запрос в 1 переменной писал и все,а тут поиском воспользовался и все стало отлично.Извените за офф топ,просто радуюсь как дитя)
Allcheats в топку, zone-game лучший

SoftTap 22.07.2010 00:00
Re: Проблема с Профами
 
Предлогаю ввести отдельный раздел для благодарностей пользователей ибо раз за разом подобные случаи ;D

Credo 22.07.2010 06:09
Re: Проблема с Профами
 
Цитата:
Сообщение от IGROMI (Сообщение 80033)
ОООГРОМНОЕ спасибо Вашему порталу что он есть.Пол ночи мучился чтобы Shadow Step добавить,SQL запрос в 1 переменной писал и все,а тут поиском воспользовался и все стало отлично.Извените за офф топ,просто радуюсь как дитя)
Allcheats в топку, zone-game лучший
оффтоп:
Свернуть ↑Развернуть ↓

IGROMI 22.07.2010 22:08
Re: Проблема с Профами
 
Офф топ:
Свернуть ↑Развернуть ↓


Текущее время: 08:35. Часовой пояс GMT +3.

Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd. Перевод: zCarot