Welcome to AC Web.
Page 5 of 5 FirstFirst ... 345
Results 61 to 71 of 71
  1. #61
    Web Developer

    Join Date
    Oct 2010
    Location
    somewhere between <?php and ?>
    Posts
    2,983

    REGISTER! (FREE)
    Registered members see less ads
    and also gain access to other great features.
    Thats why you ALWAYS need to use "WHERE" in SQL Queries. So it selects specific npcs. If you dont use a WHERE clause it will do the update for the whole table

    example
    Code:
    UPDATE creature_template
    SET health_mod = 1
    Dont run this query ! this query would change hp of every single mob to 1

    But if you use WHERE in query
    Code:
    UPDATE creature_template
    SET health_mod = 1
    WHERE entry = 12345
    It will update only the creature with entryID 12345

    - - - Updated - - -

    Quote Originally Posted by satyra123 View Post
    What is your skype i not change anything and my custom boss dont have hight hp its some elite an idk why they have so much hp... my custom bosses have only about 170k
    I sent skype in PM but its tim.levinsson

  2. #62
    And if i want to decreased 15%, how to do it?

  3. #63
    Well if 1 equals 100% and 1.15 is 115% what would be (100-15)? Right: 85% or 0.85

    Code:
    UPDATE `Item_template` SET stat_value1 = (stat_value1 * 0.85) WHERE `Name` LIKE '%Wrathful%';
    UPDATE `Item_template` SET stat_value2 = (stat_value2 * 0.85) WHERE `Name` LIKE '%Wrathful%';
    UPDATE `Item_template` SET stat_value3 = (stat_value3 * 0.85) WHERE `Name` LIKE '%Wrathful%';
    UPDATE `Item_template` SET stat_value4 = (stat_value4 * 0.85) WHERE `Name` LIKE '%Wrathful%';
    UPDATE `Item_template` SET stat_value5 = (stat_value5 * 0.85) WHERE `Name` LIKE '%Wrathful%';
    UPDATE `Item_template` SET stat_value6 = (stat_value6 * 0.85) WHERE `Name` LIKE '%Wrathful%';
    UPDATE `Item_template` SET stat_value7 = (stat_value7 * 0.85) WHERE `Name` LIKE '%Wrathful%';
    UPDATE `Item_template` SET stat_value8 = (stat_value8 * 0.85) WHERE `Name` LIKE '%Wrathful%';
    Regards,

    Astyc.
    Last edited by Astyc; 05-16-2017 at 04:26 PM.

  4. #64
    100(orig) * 1.15 =115
    100(orig) * 0.85 = 85
    115 * 0.85 = 97.75 / 0.85 = 115
    115 / 1.15 = 100(orig)
    85 / 0.85 = 100(orig)

  5. #65
    sql for lowering stats ?

  6. #66
    Web Developer

    Join Date
    Oct 2010
    Location
    somewhere between <?php and ?>
    Posts
    2,983
    Quote Originally Posted by GhostRiderTW View Post
    sql for lowering stats ?
    Use / instead of * in the query

    For example if stat_value1 is 2000 and you do
    UPDATE item_template SET stat_value1 = stat_value1 /2

    then it will be 1000 after you run the query

  7. #67
    nice, liked

    @micakilleric

    how to update stats, set pve 277hc !?

    and how to add more stats Armor items?!
    Last edited by irgc; 08-28-2018 at 06:55 AM.

  8. #68
    http://YugoWoW.com/

    Join Date
    Feb 2014
    Location
    http://yugowow.com
    Posts
    2,388
    Quote Originally Posted by irgc View Post
    nice, liked

    @micakilleric

    how to update stats, set pve 277hc !?

    and how to add more stats Armor items?!
    You may add more info in where exp :

    where ItemLevel = 277 and InventoryType BETWEEN 1 and 29 And DisenchantID = 68;

    This is the result :

    Code:
    Sanctified Lightsworn Gloves
    Sanctified Lightsworn Greaves
    Sanctified Lightsworn Headpiece
    Sanctified Lightsworn Spaulders
    Sanctified Lightsworn Tunic
    Sanctified Ymirjar Lord's Breastplate
    Sanctified Ymirjar Lord's Greathelm
    Sanctified Ymirjar Lord's Handguards
    Sanctified Ymirjar Lord's Legguards
    Sanctified Ymirjar Lord's Pauldrons
    Sanctified Ymirjar Lord's Battleplate
    Sanctified Ymirjar Lord's Gauntlets
    Sanctified Ymirjar Lord's Helmet
    Sanctified Ymirjar Lord's Legplates
    Sanctified Ymirjar Lord's Shoulderplates
    Sanctified Dark Coven Gloves
    Sanctified Dark Coven Hood
    Sanctified Dark Coven Leggings
    Sanctified Dark Coven Robe
    Sanctified Dark Coven Shoulderpads
    Sanctified Shadowblade Breastplate
    Sanctified Shadowblade Gauntlets
    Sanctified Shadowblade Helmet
    Sanctified Shadowblade Legplates
    Sanctified Shadowblade Pauldrons
    Sanctified Crimson Acolyte Gloves
    Sanctified Crimson Acolyte Hood
    Sanctified Crimson Acolyte Leggings
    Sanctified Crimson Acolyte Robe
    Sanctified Crimson Acolyte Shoulderpads
    Sanctified Bloodmage Gloves
    Sanctified Bloodmage Hood
    Sanctified Bloodmage Leggings
    Sanctified Bloodmage Robe
    Sanctified Bloodmage Shoulderpads
    Sanctified Lightsworn Chestguard
    Sanctified Lightsworn Faceguard
    Sanctified Lightsworn Handguards
    Sanctified Lightsworn Legguards
    Sanctified Lightsworn Shoulderguards
    Sanctified Lightsworn Battleplate
    Sanctified Lightsworn Gauntlets
    Sanctified Lightsworn Helmet
    Sanctified Lightsworn Legplates
    Sanctified Lightsworn Shoulderplates
    Sanctified Lasherweave Cover
    Sanctified Lasherweave Gloves
    Sanctified Lasherweave Mantle
    Sanctified Lasherweave Trousers
    Sanctified Lasherweave Vestment
    Sanctified Lasherweave Handgrips
    Sanctified Lasherweave Headguard
    Sanctified Lasherweave Legguards
    Sanctified Lasherweave Raiment
    Sanctified Lasherweave Shoulderpads
    Sanctified Lasherweave Robes
    Sanctified Lasherweave Gauntlets
    Sanctified Lasherweave Helmet
    Sanctified Lasherweave Legplates
    Sanctified Lasherweave Pauldrons
    Sanctified Crimson Acolyte Cowl
    Sanctified Crimson Acolyte Handwraps
    Sanctified Crimson Acolyte Mantle
    Sanctified Crimson Acolyte Pants
    Sanctified Crimson Acolyte Raiments
    Rib Spreader
    Marrowgar's Frigid Eye
    Bulwark of Smouldering Steel
    Shadowvault Slayer's Cloak
    Scourgeborne Waraxe
    Amulet of the Silent Eulogy
    Death Surgeon's Sleeves
    Bryntroll, the Bone Arbiter
    Sanctified Frost Witch's Shoulderpads
    Sanctified Frost Witch's Kilt
    Sanctified Frost Witch's Helm
    Sanctified Frost Witch's Gloves
    Sanctified Frost Witch's Hauberk
    Sanctified Frost Witch's Shoulderguards
    Sanctified Frost Witch's War-Kilt
    Sanctified Frost Witch's Faceguard
    Sanctified Frost Witch's Grips
    Sanctified Frost Witch's Chestguard
    Sanctified Frost Witch's Spaulders
    Sanctified Frost Witch's Legguards
    Sanctified Frost Witch's Headpiece
    Sanctified Frost Witch's Handguards
    Sanctified Frost Witch's Tunic
    Sanctified Ahn'Kahar Blood Hunter's Handguards
    Sanctified Ahn'Kahar Blood Hunter's Headpiece
    Sanctified Ahn'Kahar Blood Hunter's Legguards
    Sanctified Ahn'Kahar Blood Hunter's Spaulders
    Sanctified Ahn'Kahar Blood Hunter's Tunic
    Sanctified Scourgelord Chestguard
    Sanctified Scourgelord Faceguard
    Sanctified Scourgelord Handguards
    Sanctified Scourgelord Legguards
    Sanctified Scourgelord Pauldrons
    Sanctified Scourgelord Battleplate
    Sanctified Scourgelord Gauntlets
    Sanctified Scourgelord Helmet
    Sanctified Scourgelord Legplates
    Sanctified Scourgelord Shoulderplates
    Band of the Bone Colossus
    Loop of the Endless Labyrinth
    Bone Sentinel's Amulet
    Legguards of Lost Hope
    Dislodged Foreign Object
    Deathbringer's Will
    Cryptmaker
    Crushing Coldwraith Belt
    Grinning Skull Greatboots
    Zod's Repeating Longbow
    Leggings of Northern Lights
    Nibelung
    Ikfirus's Sack of Wonder
    Polar Bear Claw Bracers
    Boneguard Commander's Pauldrons
    Boots of Unnatural Growth
    Dual-Bladed Pauldrons
    Raging Behemoth's Shoulderplates
    Bile-Encrusted Medallion
    Royal Crimson Cloak
    Icecrown Glacial Wall
    Corpse Tongue Coin
    Althor's Abacus
    Heartpierce
    Cultist's Bloodsoaked Spaulders
    The Lady's Brittle Bracers
    Scourge Hunter's Vambraces
    Gunship Captain's Mittens
    Winding Sheet
    Nerub'ar Stalker's Cord
    Horrific Flesh Epaulets
    Holiday's Grace
    Treads of the Wasteland
    Dying Light
    Incarnadine Band of Mending
    Shadow Silk Spindle
    Unclean Surgical Gloves
    Distant Land
    Corpse-Impaling Spike
    Blightborne Warplate
    Rot-Resistant Breastplate
    Seal of Many Mouths
    Skeleton Lord's Circle
    Frostbinder's Shredded Cape
    Noose of Malachite
    Coldwraith Links
    Frozen Bonespike
    Shoulders of Frost-Tipped Thorns
    Trauma
    Toskk's Maximized Wristguards
    Valanar's Other Signet Ring
    Boots of the Funeral March
    Snowserpent Mail Helm
    Blood Queen's Crimson Choker
    Bloodsunder's Bracers
    Aldriana's Gloves of Secrecy
    Frostbrood Sapphire Ring
    Gangrenous Leggings
    Crypt Keeper's Bracers
    Frostbitten Fur Boots
    Anub'ar Stalker's Gloves
    Scourge Reaver's Legplates
    Bracers of Eternal Dreaming
    Blood-Soaked Saronite Stompers
    Broken Ram Skull Helm
    Ahn'kahar Onyx Neckguard
    Greatcloak of the Turned Champion
    Fleshrending Gauntlets
    Plaguebringer's Stained Pants
    Astrylian's Sutured Cinch
    Last Word
    Geistlord's Punishment Sack
    Lana'thel's Chain of Flagellation
    Sindragosa's Flawless Fang
    Phylactery of the Nameless Lich
    Gendarme's Cuirass
    Bracers of Dark Reckoning
    Handguards of Winter's Respite
    Rusted Bonespike Pauldrons
    Lungbreaker
    Devium's Eternally Cold Ring
    Leggings of Dying Candles
    Snowstorm Helm
    Robe of the Waking Nightmare
    Nightmare Ender
    Sindragosa's Cruel Claw
    Sundial of Eternal Dusk
    Memory of Malygos
    Juggernaut Band
    Shoulders of Mercy Killing
    Ring of Maddening Whispers
    Deathwhisper Raiment
    Fallen Lord's Handguards
    Necrophotic Greaves
    Corp'rethar Ceremonial Crown
    Ring of Rapid Ascent
    Waistband of Righteous Fury
    Belt of the Blood Nova
    Bloodvenom Blade
    Helm of the Elder Moon
    Carapace of Forgotten Kings
    Belt of Broken Bones
    Black Bruise
    Might of Blight
    Leather of Stitched Scourge Parts
    Plague Scientist's Boots
    Faceplate of the Forgotten
    Lingering Illness
    Rigormortis
    Professor's Bloodied Smock
    Tiny Abomination in a Jar
    Keleseth's Seducer
    Landsoul's Horned Greathelm
    Taldaram's Plated Fists
    Sanguine Silk Robes
    San'layn Ritualist Gloves
    Mail of Crimson Coins
    Bauble of True Blood
    Bloodfall
    222 item recorded when select those.


    About armor just do

    UPDATE Item_template SET armor = armor * 2
    or use +
    UPDATE Item_template SET armor = armor + 1200

    + means the existing armor + 1200 exp :

    if the armor is 200 than it will be 1400 and if 3000 than it will be 4200 etc..
    Last edited by JadaDev; 08-28-2018 at 11:55 AM.

  9. #69
    UPDATE `Item_template` SET stat_value1 = (stat_value1 /20.50) ;
    UPDATE `Item_template` SET stat_value2 = (stat_value2 /20.50) ;
    UPDATE `Item_template` SET stat_value3 = (stat_value3 /20.50) ;
    UPDATE `Item_template` SET stat_value4 = (stat_value4 /20.50) ;
    UPDATE `Item_template` SET stat_value5 = (stat_value5 /20.50) ;
    UPDATE `Item_template` SET stat_value6 = (stat_value6 /20.50) ;
    UPDATE `Item_template` SET stat_value7 = (stat_value7 /20.50) ;
    UPDATE `Item_template` SET stat_value8 = (stat_value8 /20.50) ;

    -----------------------------------

    That's for Deceased your all stat items value.

  10. #70
    thank you
    Last edited by 4wow; 04-19-2019 at 08:29 AM.

  11. #71

    REGISTER! (FREE)
    Registered members see less ads
    and also gain access to other great features.
    Nice

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •