[TUT]Cum adaugi itemele de upgrade la NPC..

gLontz · 15 Noi 2014, 21:08

Sã începem cu începutul.
Precum era si vorba româneasca , cum îti asterni..aºa dormi!
Deci in primul rând incepem cu crearea unor noi shopuri, in care vom aseza itemele de upgrade.
Intrãm în Navicat-Player-shop
Executam comanda CTRL+Q apoi inserãm urmãtorul cod:

Acum avem shopurile create, nu rãmâne decât sã adaugam codurile itemelor.
Intrãm in shop_item
Executam din nou comanda CTRL+Q, adaugam :

INSERT INTO `shop_item` VALUES (9003, 30005, 20);
INSERT INTO `shop_item` VALUES (9003, 30007, 20);
INSERT INTO `shop_item` VALUES (9003, 30008, 20);
INSERT INTO `shop_item` VALUES (9003, 30009, 20);
INSERT INTO `shop_item` VALUES (9003, 30012, 20);
INSERT INTO `shop_item` VALUES (9003, 30014, 20);
INSERT INTO `shop_item` VALUES (9003, 30015, 20);
INSERT INTO `shop_item` VALUES (9003, 30016, 20);
INSERT INTO `shop_item` VALUES (9003, 30019, 20);
INSERT INTO `shop_item` VALUES (9003, 30021, 20);
INSERT INTO `shop_item` VALUES (9003, 30022, 20);
INSERT INTO `shop_item` VALUES (9003, 30025, 20);
INSERT INTO `shop_item` VALUES (9003, 30030, 20);
INSERT INTO `shop_item` VALUES (9003, 30039, 20);
INSERT INTO `shop_item` VALUES (9003, 30040, 20);
INSERT INTO `shop_item` VALUES (9003, 30041, 20);
INSERT INTO `shop_item` VALUES (9003, 30042, 20);
INSERT INTO `shop_item` VALUES (9003, 30045, 20);
INSERT INTO `shop_item` VALUES (9003, 30046, 20);
INSERT INTO `shop_item` VALUES (9003, 30047, 20);
INSERT INTO `shop_item` VALUES (9003, 30048, 20);
INSERT INTO `shop_item` VALUES (9003, 30049, 20);
INSERT INTO `shop_item` VALUES (9003, 30050, 20);
INSERT INTO `shop_item` VALUES (9003, 30051, 20);
INSERT INTO `shop_item` VALUES (9003, 30055, 20);
INSERT INTO `shop_item` VALUES (9003, 30056, 20);
INSERT INTO `shop_item` VALUES (9003, 30057, 20);
INSERT INTO `shop_item` VALUES (9003, 30058, 20);
INSERT INTO `shop_item` VALUES (9003, 30059, 20);
INSERT INTO `shop_item` VALUES (9003, 30060, 20);
INSERT INTO `shop_item` VALUES (9003, 30061, 20);
INSERT INTO `shop_item` VALUES (9003, 30067, 20);
INSERT INTO `shop_item` VALUES (9003, 30091, 20);
INSERT INTO `shop_item` VALUES (9003, 50053, 1);
INSERT INTO `shop_item` VALUES (9003, 50056, 1);
INSERT INTO `shop_item` VALUES (9003, 50057, 1);
INSERT INTO `shop_item` VALUES (9003, 50058, 1);
INSERT INTO `shop_item` VALUES (9003, 50059, 1);
INSERT INTO `shop_item` VALUES (9003, 50060, 1);
INSERT INTO `shop_item` VALUES (2099, 30069, 20);
INSERT INTO `shop_item` VALUES (2099, 30070, 20);
INSERT INTO `shop_item` VALUES (2099, 30071, 20);
INSERT INTO `shop_item` VALUES (2099, 30072, 20);
INSERT INTO `shop_item` VALUES (2099, 30073, 20);
INSERT INTO `shop_item` VALUES (2099, 30074, 20);
INSERT INTO `shop_item` VALUES (2099, 30075, 20);
INSERT INTO `shop_item` VALUES (2099, 30076, 20);
INSERT INTO `shop_item` VALUES (2099, 30077, 20);
INSERT INTO `shop_item` VALUES (2099, 30078, 20);
INSERT INTO `shop_item` VALUES (2099, 30079, 20);
INSERT INTO `shop_item` VALUES (2099, 30080, 20);
INSERT INTO `shop_item` VALUES (2099, 30081, 20);
INSERT INTO `shop_item` VALUES (2099, 30082, 20);
INSERT INTO `shop_item` VALUES (2099, 30083, 20);
INSERT INTO `shop_item` VALUES (2099, 30084, 20);
INSERT INTO `shop_item` VALUES (2099, 30085, 20);
INSERT INTO `shop_item` VALUES (2099, 30086, 20);
INSERT INTO `shop_item` VALUES (2099, 30087, 20);
INSERT INTO `shop_item` VALUES (2099, 30088, 20);
INSERT INTO `shop_item` VALUES (2099, 30089, 20);
INSERT INTO `shop_item` VALUES (2099, 30090, 20);

Aºadar am creat douã shopuri ce contin iteme de upgrade cu + respectiv fara +.
Shop Iteme upgr + : 2099
Shop Iteme upgr fara + : 9003
Acum mai ramâne doar sa alegem NPC-ul caruia ii vom atribui doua shopuri, eu am ales Cetateanul Turmentat ( 20041 )
Ne conectam la Filezilla /WinSCP ( dupa caz )
/usr/home/game/share/romania/quest ( dupa caz )
creem un nou fisier pe care il numim itemeupgr+.quest
Adaugam urmatorul quest:

Apoi compilam questul, banuiesc cã majoritatea stim sã facem acest lucru.
Tocmai am creat la Cetãþeanul turmentat o optiune pentru iteme de upgrade cu +

Acum mai avem de creat un shop pentru iteme de upgrade fara +
Deci, ca in pasul anterior, creem un nou fisier il redeumim cum doriti dvs, deºi recomand ca titlu sa fie cât mai sugestiv.

Adaugam urmatorul quest:

Sper sa reusiti !
Daca ati reusit , dati un THX, va rog! Multumesc.

Tutorial creat de glonTz .

andreipop123 · 15 Noi 2014, 21:22

Frate de ce imi spune la navicat " Canoot create file "Y:\navicat\Navicat\MySQL\servers\root\player\_NAVICAT_DESIGNQUERY.sql.bak". The system cannot find the path specified "

gLontz · 15 Noi 2014, 22:37

andreipop123 scrie:Frate de ce imi spune la navicat " Canoot create file "Y:\navicat\Navicat\MySQL\servers\root\player\_NAVICAT_DESIGNQUERY.sql.bak". The system cannot find the path specified "

cand adauugi astea?

andreipop123 · 15 Noi 2014, 22:52

Nu .. cand apas ctrl + q

gLontz · 16 Noi 2014, 09:22

Acasta este o problema de la baza ta de date ... Nu am idee..

[ Mesaj scris via Windows Smartphone ] Imagine

leokent · 21 Noi 2014, 14:24

Foarte bun tutorial!

geogeorgel1995 · 24 Sep 2015, 23:08

Salut imi da asta cand incerc sa bag codu

[SQL]SELECT * FROM `shop`INSERT INTO `shop` VALUES (2099, 'Upgrade cu +', 20041);
[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 'INSERT INTO `shop` VALUES (2099, 'Upgrade cu +', 20041)' at line 1

TB.c-mt2.Ro · 27 Sep 2015, 20:44

Chiar cautam un astfel de tutorial

, multumesc .

Marian15 · 28 Sep 2015, 22:37

Dud, quest-urile nu functioneaz...

Chameleon. · 03 Oct 2015, 22:12

nu imi apare nimic la cetateanu turmentat

[TUT]Cum adaugi itemele de upgrade la NPC..

Cum pot sa rezolv itemele upgrade.

Cum modific itemele cerute la Upgrade

[Cum Sa]: Adaugi o noua frizură.

Cine este conectat