Sql

[kastet 0]

люди кто может сделать sql запрос для skill веспр армора пож(((

[kastet 0]

ребят ну помогите пож ктонибудь(((( целый день мучаюсь немагу зделать((( пожалуйста

[NewTrend 159]

хоть ид скинь и сборку напиши у нас не форум телепатов любителей

[kastet 0]

вот иды шмотки а сборка l2jx

9900 Vesper Black Blade Bestows Focus, Haste or Health. -1 0 0 0

9901 Vesper Black Blade Focus <Soul Crystal Enhancement>\n Increases Critical by 60. Increases damage inflicted during PvP. -1 0 0 0

9902 Vesper Black Blade Haste <Soul Crystal Enhancement>\n Increases Atk. Spd. by 15%. Increases damage inflicted during PvP. -1 0 0 0

9903 Vesper Black Blade Health <Soul Crystal Enhancement>\n Increases maximum HP by 25%. Increases damage inflicted during PvP. -1 0 0 0

9904 Vesper Black Bow Bestows Focus, Silence or Crt. Slow. -1 0 0 0

9905 Vesper Black Bow Focus <Soul Crystal Enhancement>\n Increases Critical by 60. Increases damage inflicted during PvP. -1 0 0 0

9906 Vesper Black Bow Quick Recovery <Soul Crystal Enhancement>\n Degree delay attack by 10%. Increases damage inflicted during PvP. -1 0 0 0

9907 Vesper Black Bow Critical Slow <Soul Crystal Enhancement>\n During a regular critical attack, it causes the enemy to slow with a success rate of 25%. Increases damage inflicted during PvP. -1 0 0 0

9908 Vesper Black Dagger Bestows Focus, Haste, Critical Damage. -1 0 0 0

9909 Vesper Black Dagger Focus <Soul Crystal Enhancement>\n Increases critical attack rate by 60. Increases damage inflicted during PvP. -1 0 0 0

9910 Vesper Black Dagger Haste <Soul Crystal Enhancement>\n Increases Evasion by 2. Increases damage inflicted during PvP. -1 0 0 0

9911 Vesper Black Dagger Critical Damage <Soul Crystal Enhancement>\n Increases Critical by 60. Increases damage inflicted during PvP. -1 0 0 0

9912 Vesper Black Avenger Bestows Focus, Haste or Health. -1 0 0 0

9913 Vesper Black Avenger Focus <Soul Crystal Enhancement>\n Increases Critical by 60. Increases damage inflicted during PvP. -1 0 0 0

9914 Vesper Black Avenger Haste <Soul Crystal Enhancement>\n Increases Atk. Spd. by 15%. Increases damage inflicted during PvP. -1 0 0 0

9915 Vesper Black Avenger Health <Soul Crystal Enhancement>\n Increases maximum HP by 25%. Increases damage inflicted during PvP. -1 0 0 0

9916 Vesper Black Fangs Bestows Focus, Crt. Stun or Crt. Slow. -1 0 0 0

9917 Vesper Black Fangs Focus <Soul Crystal Enhancement>\n Increases Critical by 60. Increases damage inflicted during PvP. -1 0 0 0

9918 Vesper Black Fangs Critical Stun <Soul Crystal Enhancement>\n During a regular critical attack, it causes the enemy to stun with a success rate of 25%. Increases damage inflicted during PvP. -1 0 0 0

9919 Vesper Black Fangs Critical Silence <Soul Crystal Enhancement>\n During a regular critical attack, it causes the enemy to silence with a success rate of 25%. Increases damage inflicted during PvP. -1 0 0 0

9920 Vesper Black Magic Blunt Bestows Acumen, Empower or Magic Power. -1 0 0 0

9921 Vesper Black Magic Blunt Acumen <Soul Crystal Enhancement>\n Increases casting speed by 15%. Increases damage inflicted during PvP. -1 0 0 0

9922 Vesper Black Magic Blunt Empower <Soul Crystal Enhancement>\n Increases M. Atk. by 15%. Increases damage inflicted during PvP. -1 0 0 0

9923 Vesper Black Magic Blunt Mana Up <Soul Crystal Enhancement>\n When using magic, increases MP Consumption by 50%, and M. Atk. by 15%. Increases damage inflicted during PvP. -1 0 0 0

9924 Vesper Black Spear Bestows Haste, Health or Crt. Stun. -1 0 0 0

9925 Vesper Black Spear Haste <Soul Crystal Enhancement>\n Increases Atk. Spd. by 15%. Increases damage inflicted during PvP. -1 0 0 0

9926 Vesper Black Spear Health <Soul Crystal Enhancement>\n Increases maximum HP by 25%. Increases damage inflicted during PvP. -1 0 0 0

9927 Vesper Black Spear Critical Stun <Soul Crystal Enhancement>\n During a regular critical attack, it causes the enemy to stun with a success rate of 25%. Increases damage inflicted during PvP. -1 0 0 0

9928 Vesper Black Magic Sword Bestows Empower, Acumen or Magic Silence. -1 0 0 0

9929 Vesper Black Magic Sword Acumen <Soul Crystal Enhancement>\n Increases casting speed by 15%. Increases damage inflicted during PvP. -1 0 0 0

9930 Vesper Black Magic Sword Empower <Soul Crystal Enhancement>\n Increases M. Atk. by 15%. Increases damage inflicted during PvP. -1 0 0 0

9931 Vesper Black Magic Sword Magic Silence <Soul Crystal Enhancement>\n Increases the chances of causing Silence by 15% when using bad magic upon a target. Increases damage inflicted during PvP. -1 0 0 0

9932 Vesper Black Big Sword Bestows Focus, Haste, or Health. -1 0 0 0

9933 Vesper Black Big Sword Focus <Soul Crystal Enhancement>\n Increases Critical by 60. Increases damage inflicted during PvP. -1 0 0 0

9934 Vesper Black Big Sword Haste <Soul Crystal Enhancement>\n Increases Atk. Spd. by 15%. Increases damage inflicted during PvP. -1 0 0 0

9935 Vesper Black Big Sword Health <Soul Crystal Enhancement>\n Increases maximum HP by 25%. Increases damage inflicted during PvP. -1 0 0 0

9936 Vesper Black Shield L2 WoD -1 0 0 0

9937 Dual Vesper Black Sword L2 WoD <Soul Crystal Enhancement>\n Increases damage inflicted during PvP. -1 0 0 0

9950 Vesper Black Helmet Part of Vesper Black Set. -1 0 0 0

9951 Vesper Black Breastplate Heavy Armor Vesper Black Breastplate. -1 9951,9952,9950,9953,9954 Produces bonus effects level 4: Increases Max CP,HP,MP,\nP.atk, P.atk Speed, Speed,\nAccuracy, Evasion and Critical Rate. 70000 0 0 6 Quando todas as partes do set estiverem +6, um adicional de defesa lhe sera dado automaticamente.

9952 Vesper Black Gaiters Heavy Armor Part of Vesper Black Heavy Set. -1 0 0 0

9953 Vesper Black Gloves Heavy Armor Part of Vesper Black Heavy Set. -1 0 0 0

9954 Vesper Black Boots Heavy Armor Part of Vesper Black Heavy Set. -1 0 0 0

9955 Vesper Black Leather Armor Light Armor Vesper Black Leather Armor. -1 9955,9956,9950,9957,9958 Produces bonus effects level 4: Increases Max CP,HP,MP,\nP.atk, P.atk Speed, Speed,\nAccuracy, Evasion and Critical Rate. 0 0 0

9956 Vesper Black Leggings Light Armor Part of Vesper Black Light Set. -1 0 0 0

9957 Vesper Black Gloves Light Armor Part of Vesper Black Light Set. -1 0 0 0

9958 Vesper Black Boots Light Armor Part of Vesper Black light Set. -1 0 0 0

9959 Vesper Black Tunic Robe Armor Vesper Black Tunic. -1 9959,9960,9950,9961,9962 Produces bonus effects level 4: Increases Max CP,HP,MP,\nM.atk, M.atk Speed, Speed,\nEvasion, Heal Effect\nand Decrease Cast Interrupt. 0 0 0

9960 Vesper Black Stockings Robe Armor Part of Vesper Black Robe Set. -1 0 0 0

9961 Vesper Black Gloves Robe Armor Part of Vesper Black Robe Set. -1 0 0 0

9962 Vesper Black Boots

[NewTrend 159]

ты сами скилы сделал?

Или ты хочешь чтобы я тебе написал за тебя все сюл на шмот в армор?

[kastet 0]

ай сори иды наверно skills??? да?? если да то вот 10110 10111 10112

[NewTrend 159]

INSERT INTO `skill_trees` VALUES ('0', '10110', '1', 'Light', '31000', '1', null);

INSERT INTO `skill_trees` VALUES ('0', '10111', '1', 'Heavy', '31000', '1', null);

INSERT INTO `skill_trees` VALUES ('0', '10112', '1', 'Roba', '31000', '1', null);

Вот вроде так

Изменено 21 ноября, 2012 пользователем NewTrend

[kastet 0]

щас как сделать создать текстовый документ туда вставить и залить да???

[NewTrend 159]

можно правой кнопкой на базе и так Console и туда вставить

[kastet 0]

INSERT INTO `skill_trees` VALUES ('0', '10110', '1', 'Light', '31000', '1', null);

INSERT INTO `skill_trees` VALUES ('0', '10111', '1', 'Heavy', '31000', '1', null);

INSERT INTO `skill_trees` VALUES ('0', '10112', '1', 'Roba', '31000', '1', null);

Вот вроде так

 

держи спасибку

[kastet 0]

[Err] 1136 - Column count doesn't match value count at row 1

[Err] INSERT INTO `skill_trees` VALUES ('0', '10110', '1', 'Light', '31000', '1', null);

[Err] 1136 - Column count doesn't match value count at row 1

[Err] INSERT INTO `skill_trees` VALUES ('0', '10111', '1', 'Heavy', '31000', '1', null);

[Err] 1136 - Column count doesn't match value count at row 1

[Err] INSERT INTO `skill_trees` VALUES ('0', '10112', '1', 'Roba', '31000', '1', null);

[Msg] Finished - Unsuccessfullyвот такая ошибка выскочила при заливке в базу

[NewTrend 159]

Сейчас фрозенов сделаю я со своей сборки делал одну секунду

[kastet 0]

спасиб жду)

[NewTrend 159]

INSERT INTO skill_trees VALUES (null,10110,1,'Light',0,0);

INSERT INTO skill_trees VALUES (null,10111,1,'heavy',0,0);

INSERT INTO skill_trees VALUES (null,10112,1,'roba',0,0);

[kastet 0]

щас залью скажу норм или нет)

[NewTrend 159]

А вообще на сколько я знаю вообще не надо сюл для шмота скилов ток xml и в клиент

[kastet 0]

[Err] 1048 - Column 'class_id' cannot be null

[Err] INSERT INTO skill_trees VALUES (null,10110,1,'Light',0,0);

INSERT INTO skill_trees VALUES (null,10111,1,'heavy',0,0);

INSERT INTO skill_trees VALUES (null,10112,1,'roba',0,0);

[Msg] Finished - Unsuccessfully

 

вот такая ошибка(((

[kastet 0]

у меня иза этого skill нету стат((( хотя в xtml ни ннаписаны(

[NewTrend 159]

надо не xtml а xml делать

и закидывал server/gameserver/data/stats/skills суда?

Изменено 21 ноября, 2012 пользователем NewTrend

[kastet 0]

ну да их))) делал

tester мне написал статы но без sql skill они не пашут((( и тоесть ваще веспр шмот нечего не дает так для красоты(

[Warox 116]

1) l2jx это теон а не как не фрозены.

2) Ваш запрос не имеет вроде идов шмота. вам не кажеться? о каком тогда скиле может идти реч.

[NewTrend 159]

а скил армор сетс дал в базе?

[NewTrend 159]

1) l2jx это теон а не как не фрозены.

2) Ваш запрос не имеет вроде идов шмота. вам не кажеться? о каком тогда скиле может идти реч.

спасибо за 1 просто с другой темы на фрозенах так и остался на своей волне

[kastet 0]

ну что ребят мне сделать как мне сделать что бы статы были на шмоте они прописаны но не работают((((

[Warox 116]

запрос должен быть приблизительно таким:

INSERT INTO `armorsets` VALUES ('1', '23', '2386', '43', '0', '0', '3500', '0', '0', '0');

INSERT INTO `armorsets` VALUES ('2', '1101', '1104', '44', '0', '0', '3501', '0', '0', '0');

INSERT INTO `armorsets` VALUES ('3', '58', '59', '47', '0', '0', '3502', '628', '3543', '3611');

Иды стоят с моей таблицы не ваши)

Заливать не пробуйте)