VMP. 202 Posted September 16, 2012 BoasVou explicar a função desta query:Imaginem que mudaram o valor de HP Max dos bónus, e querem que os itens que já tenham sido rodados tenham já esse novo bonus, pois há jogadores já com sets perfeitos.Com esta query, todos os que tiverem HP Max nos itens, no caso do meu servidor, 8k HP, ficarão com 12k HP. UPDATE `item` SET `attrvalue1`=12000 WHERE `attrtype1`=1 AND `attrvalue1`=8000;Onde diz:attrtype1 é o ID do bónusattrvalue1 é o valor do bónus.Lista de bónus: 01 - MAX HP02 - MAX MP03 - CON04 - INT05 - STR06 - DEX07 - Attack Speed08 - Movement Speed09 - Skill Speed10 - HP Regeneration11 - MP Regeneration12 - Chance of Poisoning13 - Chance to Stun14 - Chance of Slowing15 - Chance to Critical16 - Chance Price17 - Strong against Demi-human18 - Strong to Animals19 - Strong against Orks20 - Strong Against Esoteric21 - Strong against Undead22 - Strong against Demons23 - Damage Absorbed by HP24 - Damage Absorbed by MP27 - Chance to Block Physical Attacks28 - Chance to Avoid Arrows29 - Sword Defense30 - Two-Handed Defense31 - Defense Dagger32 - Protection of Bells33 - Protection of Fans34 - Resistance Arrows35 - Resistance to Fire36 - Lightning Resistance37 - Magic Resistance38 - Wind Resistance39 - Chance to reflect Physical Attack40 - Chance to reflect Curse41 - Resistance to Poison42 - Chance to restore MP43 - Chance Bonus EXP44 - Chance to duplicate Yang Dropped45 - Chance to double Drops48 - Immune to Stun49 - Immune to Slowdown50 - The Immune Falls *** ***53 - Bonus Attack54 - Defense Bonus55 - Magic Attack Bonus56 - Bonus Magic Defense58 - Bonus Stamina59 - Strong against Warriors60 - Strong vs. Ninjas61 - Strong against Suras62 - Strong against Shamans63 - Strong against Monster65 - Defense66 - Bonus EXP (%)67 - Bonus Drop (%)68 - Bonus Drop Yang (%)71 - Damage Skill (DH%)72 - Damage Average (% DM)73 - Resistance Skills74 - Resistance to Damage78 - Resistance to Warriors79 - Resistance Ninjas80 - Resistance Suras81 - Resistance Shamans Fontes:Elitepvpers: Lista de bónusMysql.com: Tinha-me esquecido de uma expressão :xCumprimentos,Moisés 6 Kelux, Tyler Durden, BigJoke and 3 others reacted to this Share this post Link to post Share on other sites
xXBoyDarkXx 328 Posted September 16, 2012 WoooooooW Muito mas muito útil http://cyber-gamers.org/public/style_emoticons/default/451960.gif http://cyber-gamers.org/public/style_emoticons/default/espi28.gif Share this post Link to post Share on other sites
Kelux 15 Posted September 16, 2012 mt fixe este topico http://cyber-gamers.org/public/style_emoticons/default/451960.gif :) Share this post Link to post Share on other sites
iReapZz 23 Posted September 16, 2012 Nop Tu Mereces Afinal Tas Ajudar Muitas Pessoas Não Sei Se Sabes. Share this post Link to post Share on other sites