Intram în Navicat-Player-shop
Executam comanda CTRL+Q apoi inseram urmatorul cod:

INSERT INTO `shop` VALUES (20096, 'Upgrade cu +', 20041);
INSERT INTO `shop` VALUES (9003, 'Upgrade fara +', 20041);

Acum avem shopurile create, nu ramâne decât sa adaugam codurile itemelor.
Intram 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 (20096, 30069, 20);
INSERT INTO `shop_item` VALUES (20096, 30070, 20);
INSERT INTO `shop_item` VALUES (20096, 30071, 20);
INSERT INTO `shop_item` VALUES (20096, 30072, 20);
INSERT INTO `shop_item` VALUES (20096, 30073, 20);
INSERT INTO `shop_item` VALUES (20096, 30074, 20);
INSERT INTO `shop_item` VALUES (20096, 30075, 20);
INSERT INTO `shop_item` VALUES (20096, 30076, 20);
INSERT INTO `shop_item` VALUES (20096, 30077, 20);
INSERT INTO `shop_item` VALUES (20096, 30078, 20);
INSERT INTO `shop_item` VALUES (20096, 30079, 20);
INSERT INTO `shop_item` VALUES (20096, 30080, 20);
INSERT INTO `shop_item` VALUES (20096, 30081, 20);
INSERT INTO `shop_item` VALUES (20096, 30082, 20);
INSERT INTO `shop_item` VALUES (20096, 30083, 20);
INSERT INTO `shop_item` VALUES (20096, 30084, 20);
INSERT INTO `shop_item` VALUES (20096, 30085, 20);
INSERT INTO `shop_item` VALUES (20096, 30086, 20);
INSERT INTO `shop_item` VALUES (20096, 30087, 20);
INSERT INTO `shop_item` VALUES (20096, 30088, 20);
INSERT INTO `shop_item` VALUES (20096, 30089, 20);
INSERT INTO `shop_item` VALUES (20096, 30090, 20);

Asadar am creat doua shopuri ce contin iteme de upgrade cu + respectiv fara +.
Shop Iteme upgr + : 20096
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:

quest itemeupgr begin
	state start begin
    	when 20041.chat."Iteme de upgrade cu +" begin
        	npc.open_shop(20096)
        	setskin(NOWINDOW)
    	end
	end
end

Apoi compilam questul, banuiesc ca majoritatea stim sa facem acest lucru.
Tocmai am creat la Cetateanul 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, desi recomand ca titlu sa fie cât mai sugestiv.

Adaugam urmatorul quest:

quest itemeupgrfaraplus begin
	state start begin
    	when 20041.chat."Iteme de upgrade fara +" begin
        	npc.open_shop(9003)
        	setskin(NOWINDOW)
    	end
	end
end

Sper ca te-am ajutat.