K3nkσz 824 Posted June 9, 2014 Boas comunidade. Tenho aqui umas Querys boas para um servidor PvM. As Querys são adicionadas no navicat, simplesmente adicionam lá, alteram para o Shop que querem e está andar. Para quem não quer trabalho nenhum vou deixar tudo para facilitar. Transformar npcs em lojas INSERT INTO `shop` VALUES (20096, 'Upgrade cu +', 20041); INSERT INTO `shop` VALUES (9003, 'Upgrade fara +', 20041); Adicionar items as lojas 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); Quest's para criar as lojas quest itemeupgr+ begin state start begin when 20041.chat."Iteme de upgrade cu +" begin npc.open_shop(20096) setskin(NOWINDOW) end end end quest itemeupgrfaraplus begin state start begin when 20041.chat."Iteme de upgrade fara +" begin npc.open_shop(9003) setskin(NOWINDOW) end end end Creditos: Pro-area.com Cumprimentos, Kenkoz. 10 Ennemis, OceanusMT2, skinhead and 7 others reacted to this Share this post Link to post Share on other sites
K3nkσz 824 Posted June 12, 2014 Ninguem me dá +1? Nunca mais posto nada, rsrsrs. 1 skinhead reacted to this Share this post Link to post Share on other sites
'PACI 2,317 Posted June 12, 2014 Não postes 1 skinhead reacted to this Share this post Link to post Share on other sites
.тιαgσ 624 Posted June 12, 2014 Dei +1 para não ficares triste, mas por acaso até é útil Share this post Link to post Share on other sites
K3nkσz 824 Posted June 12, 2014 Esse off-topic. Dei +1 para não ficares triste, mas por acaso até é útil Obrigado eheh. Cumprimentos. Share this post Link to post Share on other sites
'PACI 2,317 Posted June 12, 2014 Ya, porque comentares que ninguém te dá reputação tem a ver com o tópico. Share this post Link to post Share on other sites
K3nkσz 824 Posted June 12, 2014 Sempre tão aziado, isso faz te mal rapaz. 1 Eztourqi reacted to this Share this post Link to post Share on other sites
'PACI 2,317 Posted June 12, 2014 kkkkkkkkk porque é que vou estar aziado? Share this post Link to post Share on other sites
Cσяvσ⋆ 1,804 Posted June 12, 2014 kkkkkkkk Reputation Whore ^_^ Share this post Link to post Share on other sites